LigerUI Server端实现分页

 前台JS代码:

<script type="text/javascript" language="javascript">         $(f_initGrid);         var grid;         function f_initGrid() {             grid = $("#maingrid").ligerGrid({                 columns: [                 {display:'前缀',name:'prefix',width: 100},                 { display: '编码', name: 'parts_no', width: 100},                 { display: '配件编码', name: 'prefix_parts_no', width: 100}],                 url: 'Ashx/GetPartsList.ashx?Action=GetData', //一般处理程序                 dataAction: 'server',//服务器排序                 usePager:true             });         }

        function f_search() {               grid.options.parms.where1 = "111";  //查询条件             grid.loadData(true);         } </script>

Ashx代码：

public void ProcessRequest(HttpContext context)         {             context.Response.ContentType = "text/plain";             string result=string.Empty;

            string action = context.Request.Params["Action"];             string where = context.Request.Params["where1"];             string sortname = context.Request.Params["sortname"]; //排序名称             string sortorder = context.Request.Params["sortorder"]; //排序方式             string pageSize = context.Request.Params["pagesize"];             string page = context.Request.Params["page"];

            int page_size_int = 10;             int page_int = 1;             if (!string.Empty.Equals(SalesCommon.GetIsNullOrEmpty(page))) int.TryParse(page, out page_int);             if (!string.Empty.Equals(SalesCommon.GetIsNullOrEmpty(pageSize))) int.TryParse(pageSize, out page_size_int);             page_int = page_int - 1;

            IList<Node> list = new List<Node>();             string sql = "select prefix,parts_no,prefix_parts_no from sales_order_detail where ifnull(prefix,'')<>'' ";

            if (!string.Empty.Equals(SalesCommon.GetIsNullOrEmpty(sortname)))             {                 sql += " order by " + sortname + " " + sortorder;             }             else             {                 sql += " order by create_date desc ";             }

            sql += " limit " + page_int * page_size_int + "," + page_size_int;                         DataTable dt = SalesCommon.QueryTable(sql);

            for (var i = 0; i < dt.Rows.Count; i++)             {                 list.Add(new Node()                 {                     prefix = dt.Rows[i]["prefix"].ToString(),                     parts_no = dt.Rows[i]["parts_no"].ToString(),                     prefix_parts_no = dt.Rows[i]["prefix_parts_no"].ToString()                 });             }                         sql = "select count(1) cnt from sales_order_detail where ifnull(prefix,'')<>''";             dt = SalesCommon.QueryTable(sql);             int page_count=0;             if (dt != null && dt.Rows.Count > 0) int.TryParse(SalesCommon.GetIsNullOrEmpty(dt.Rows[0]["cnt"]), out page_count);

            var griddata = new { Rows = list, Total = page_count };             result = new JavaScriptSerializer().Serialize(griddata);

            context.Response.Write(result);             context.Response.End();         }

        //字段属性

        class Node         {             public string prefix { get; set; }             public string parts_no { get; set; }             public string prefix_parts_no { get; set; }         }