private void Query(HttpContext context) { var name = context.Request["Name"].Trim(); var description = context.Request["Description"].Trim(); var area = context.Request["Area"].Trim(); var type = context.Request["Type"].Trim(); var ds = new DataSet(); var classBll = new BLL.Class(); var strWhere = ""; if (!string.IsNullOrEmpty(name)) { strWhere = string.Format(" Name like '%" + name + "%' "); } if (!string.IsNullOrEmpty(description)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Description like '%" + description + "%' "); } else { strWhere = string.Format(" Description like '%" + description + "%' "); } } if (!string.IsNullOrEmpty(area)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Area like '%" + area + "%' "); } else { strWhere = string.Format(" Area like '%" + area + "%' "); } } if (!string.IsNullOrEmpty(type)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Type like '%" + type + "%' "); } else { strWhere = string.Format(" Type like '%" + type + "%' "); } } var page = Convert.ToInt32(context.Request["page"]); var rows = Convert.ToInt32(context.Request["rows"]); var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "Name" : context.Request["sort"]; var order = string.IsNullOrEmpty(context.Request["order"]) ? "asc" : context.Request["order"]; var startIndex = (page - 1)*rows + 1; var endIndex = startIndex + rows - 1; var num = classBll.GetRecordCount(strWhere); ds = classBll.GetListByPage(strWhere, sort, startIndex, endIndex,order); var str = JsonConvert.SerializeObject(new {total = num, rows = ds.Tables[0]}); context.Response.Write(str); }
private string GetData(HttpContext context) { var ds = new DataSet(); var classBll = new BLL.Class(); var page = Convert.ToInt32(context.Request["page"]); var rows = Convert.ToInt32(context.Request["rows"]); var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "Name" : context.Request["sort"]; var order = string.IsNullOrEmpty(context.Request["order"]) ? "desc" : context.Request["order"]; var startIndex = (page - 1) * rows + 1; var endIndex = startIndex + rows - 1; var num = classBll.GetRecordCount(""); ds = classBll.GetListByPage("", sort, startIndex, endIndex, order); var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] }); return str; }