private const int cols = 3;
private StringBuilder body=new StringBuilder(string.Empty);
var ID =Cursor.GetFieldValue<int>("ID");
var cmdRec = SqlClient.Main.CreateCommand(@"
select r.res, r.ID,r.emp, kdk.FIO, cert.date from certres r
left join kdk on n_kdk=r.EMPL
left join cert on cert.id=r.ID
, new SqlParam("ID", ID)).ExecObjects(new { res = 0, fio = string.Empty, date=DateTime.MinValue});
foreach (var c in cmdRec.GroupBy(x=>x.date))
for (int i = 0; i < cmdRec.Select(x=>x.date==c.Key.Date).Count(); i++)
public void CreateHtml(int cols,string[] captions)
StringBuilder sb=new StringBuilder(string.Empty);
foreach (var c in captions)
sb.AppendFormat("<th>{0}</th>", c);
var title=string.Format("№", "FIO","Result");
header = string.Format("<thead><tr>{0}</tr></thead>", sb.ToString());
public void AddRows(object[] values)
for (int i = 0; i < values.Length; i++)
body.AppendFormat("<td>{0}</td>", values[i].ToString());
for (int i = 0; i < cols; i++)
body.Append("<tr></tr>");
return string.Format("<table>{0}</table><table style=\"boarder:solid 1px;\">{1}<tbody>{2}</tbody></table>",
title,header,body.ToString());