private void GetJsonForNoticeDatagrid(HttpContext context)
{
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
int.TryParse(context.Request.QueryString["page"], out pageIndex);
int.TryParse(context.Request.QueryString["rows"], out pageSize);
string sqlWhere = string.Empty;
SqlParameter parm = null;
if (!string.IsNullOrEmpty(context.Request.QueryString["title"]))
{
sqlWhere = "and Title like @Title ";
parm = new SqlParameter("@Title", SqlDbType.NVarChar, 100);
parm.Value = "%" + context.Request.QueryString["title"].Trim() + "%";
}
Notice bll = new Notice();
var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parm);
if (list == null || list.Count == 0)
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
StringBuilder sb = new StringBuilder();
foreach (var model in list)
{
sb.Append("{\"Id\":\"" + model.Id + "\",\"Title\":\"" + model.Title + "\"},");
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}");
}
