php liger 表格排序,jQuery liger ui ligerGrid 通用的分页排序查询报表

三，准备一个通用的ashx页面

using System;

using System.Web;

using ligerUI.Utility.Common;

using ligerUI.Utility.LigerGrid;

public class BillListData : IHttpHandler {

public void ProcessRequest (HttpContext context) {

context.Response.ContentType = "text/plain";

try

{

TryGetGridViewData();

}

catch (Exception err)

{

context.Response.Write("null");

}

context.Response.End();

}

public void TryGetGridViewData()

{

System.Web.HttpContext context = System.Web.HttpContext.Current;

GridViewPager pager = new GridViewPager();

string datajson = pager.GetDataJSON();

context.Response.Write(datajson);

}

public bool IsReusable {

get {

return false;

}

}

}

四，实现处理方法(接收分页排序信息，并返回正确的数据)

public DataTable GetGridView(string gridViewName, string fieldName, string gridKeyName, int pageNo, int pageSize, string orderStr, string whereStr, ref int recordTotal)

{

string sqlCommad = "P_GridViewPager";

SqlParameter[] parms = new SqlParameter[]{

new SqlParameter("viewName",SqlDbType.VarChar,50),

new SqlParameter("fieldName",SqlDbType.VarChar,50),

new SqlParameter("keyName",SqlDbType.VarChar,50),

new SqlParameter("pageNo",SqlDbType.Int),

new SqlParameter("pageSize",SqlDbType.Int),

new SqlParameter("orderString",SqlDbType.VarChar,50),

new SqlParameter("whereString",SqlDbType.VarChar,50),

new SqlParameter("recordTotal",SqlDbType.VarChar,50)

};

parms[0].Value = gridViewName;

parms[1].Value = fieldName;

parms[2].Value = gridKeyName;

parms[3].Value = pageNo;

parms[4].Value = pageSize;

parms[5].Value = orderStr;

parms[6].Value = whereStr;

parms[7].Direction = ParameterDirection.Output;

DataTable dt = SqlHelper.ExecuteDataset(DataBaseHelper.connectionstring, CommandType.StoredProcedure, sqlCommad, parms).Tables[0];

recordTotal = CommonHelper.ObjToInt(parms[7].Value);

return dt;

}

public string GetDataJSON()

{

System.Web.HttpContext ctx = System.Web.HttpContext.Current;

int pageno = CommonHelper.ObjToInt(ctx.Request.Params["page"]);

int pagesize = CommonHelper.ObjToInt(ctx.Request.Params["pagesize"]);

string sortname = CommonHelper.ObjToStr(ctx.Request.Params["sortname"]);

string sortorder = CommonHelper.ObjToStr(ctx.Request.Params["sortorder"]);

string gridviewname = CommonHelper.ObjToStr(ctx.Request.Params["gridviewname"]);

string gridsearch = CommonHelper.ObjToStr(ctx.Request.Params["gridsearch"]);

if (string.IsNullOrEmpty(gridviewname))

throw new ArgumentNullException("Grid视图名[gridsearch]不能为空");

if (pageno == 0 || pagesize == 0)

{

if (string.IsNullOrEmpty(sortorder) && string.IsNullOrEmpty(gridsearch))

{

return GetDataJSON(gridviewname);

}

if(string.IsNullOrEmpty(sortorder))

return GetDataJSON(gridviewname, gridsearch);

if (string.IsNullOrEmpty(gridsearch))

return GetDataJSONUseSQL(string.Format("select * from {0} order by {1} {2}", gridviewname, sortname, sortorder.ToLower() == "asc" ? "asc" : "desc"));

return GetDataJSON(gridviewname, gridsearch, string.Format("order by {0} {1}", sortname, sortorder));

}

if (string.IsNullOrEmpty(gridsearch) && string.IsNullOrEmpty(sortname))

{

return GetDataJSON(gridviewname, pageno, pagesize);

}

if (string.IsNullOrEmpty(gridsearch) && !string.IsNullOrEmpty(sortname))

{

return GetDataJSON(gridviewname, pageno, pagesize, sortname, sortorder);

}

if (!string.IsNullOrEmpty(gridsearch) && string.IsNullOrEmpty(sortname))

{

return GetDataJSON(gridviewname, pageno, pagesize, gridsearch);

}

if (!string.IsNullOrEmpty(gridsearch) && !string.IsNullOrEmpty(sortname))

{

return GetDataJSON(gridviewname, pageno, pagesize, sortname, sortorder, gridsearch);

}

return @"{""Rows"":[],""Total"":""0""}";

}