private List<PrintItemDetail> getQueryResult(SqlCommand cmd)
{
DbDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
List<PrintItemDetail> items = new List<PrintItemDetail>();
PrintItemDetail item = null;
dt.Load(reader);
reader.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new PrintItemDetail();
item.category = getString(dt.Rows[i]["category"]);
item.code_desc = getString(dt.Rows[i]["code_desc"]);
item.jid = getInt(dt.Rows[i]["jid"]);
item.ordering = "" + getInt(dt.Rows[i]["ordering"]);
item.category_name = getString(dt.Rows[i]["category_name"]);
items.Add(item);
}
}
return items;
}
public static String getJobLookupItemsJson(PrintItemDetail lookup)
{
StringBuilder JobLookupItemJson = new StringBuilder();
JobLookupItemJson.Append("{xtype:'checkbox',boxLabel:'").Append(lookup.code_desc).Append("',name:'item").Append(lookup.jid).Append("'}");
return JobLookupItemJson.ToString();
}