MVC与Jqgrid结合使用实现数据分页示例

create proc [dbo].[LogList]
@pageIndex int,
@pageSize int,
@strFilter varchar(1000)
as
begin
 exec('select top '+@pageSize+' * 
 from (select distinct ROW_NUMBER() OVER(order by ID desc) as RowNumber,LogType,LogContent,LogTime \
 from Log 
 where '+@strFilter+' 1=1 ) AS TEMPTABLE Where RowNumber>' + @pageIndex+'*'+@pageSize+'')
 exec('select count(*) from Log  Where '+@strFilter+' 1=1  ')
end

 

public ActionResult Log(String str)
        {
            int intCurPage;
            int intRowNum;
            string strWhere = "";
            intCurPage = GFun.SafeToInt32(Request["curpage"].ToString());
            if (Request["rownum"] != null)
                intRowNum = GFun.SafeToInt32(Request["rownum"].ToString());
            else
                intRowNum = 1;
            if (str.Contains('$'))
            {
                var strFilter = str.Split('$');
                str = " LogType like'%" + strFilter[0].ToString() + "%' and LogContent like'%" + strFilter[1].ToString() + "%' and ";
                if (strFilter[2].ToString() == "" || strFilter[2].ToString() == null)

                {
                    strWhere =str;
                }
                else
                {
                    strWhere =str+ "LogTime >='" + strFilter[2].ToString() + " 00:00:00' and LogTime<='" + strFilter[3].ToString() + " 23:59:59' and ";
                }
            }
            UIDataTable udtTask = LogBL.LogData(strWhere, intCurPage - 1, GFun.SafeToInt32(intRowNum));
            string strjson = GFun.Dt2Json("task", udtTask.DtData);
            strjson = strjson.Substring(1);
            strjson = strjson.Substring(0, strjson.Length - 1);
            string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": ";
            jsonData += strjson + "}";
            return Json(jsonData, JsonRequestBehavior.AllowGet);
        }

 

 public static UIDataTable LogData(String strFilter, int a_intPageIndex, int a_intPageSize)
       {
           return LogDA.LogData(strFilter,a_intPageIndex,a_intPageSize);
       }

 

public static UIDataTable LogData(String strFilter, int a_intPageIndex, int a_intPageSize)
       {
           UIDataTable instData = new UIDataTable();