JqGrid: paing int asp.net, jqgridpaing

JqGrid: paing int asp.net, jqgridpaing

Jadgrid. aspx

<! DOCTYPE html> <! -- HTML5 doctype --> 
GeovinHandler. ashx:
/// <Summary> /// $ codebehindclassname $ abstract description /// geovindu /// 20180128 // tu juwen /// </summary> [WebService (Namespace =" http://tempuri.org/ ")] [WebServiceBinding (ConformsTo = WsiProfiles. basicProfile1_1)] public class geovinHandler: IHttpHandler {DuMembershipLotteryBLL bll = new DuMembershipLotteryBLL (); /// <summary> ///// </summary> /// <param name = "context"> </param> public void ProcessRequest (HttpContext context) {HttpRequest request = context. request; HttpResponse response = context. response; System. collections. specialized. nameValueCollection forms = context. request. form; string strOperation = forms. get ("response"); // response. write (strOperation); string strResponse = string. empty; string _ search = request ["_ search"]; string numberOfRows = request ["rows"]; string pageIndex = request ["page"]; string sortColumnName = request ["sidx"]; string sortOrderBy = request ["sord"]; int totalRecords; List <DuMembershipLotteryInfo> info = new List <DuMembershipLotteryInfo> (); if (strOperation = null) {info = bll. selectDuMembershipLotteryPaging (Convert. toInt32 (numberOfRows), Convert. toInt32 (pageIndex), sortColumnName, sortOrderBy, out totalRecords); string output = BuildJQGridResults (info, Convert. toInt32 (numberOfRows), Convert. toInt32 (pageIndex), Convert. toInt32 (totalRecords); response. write (output);} else if (strOperation = "del") {string strEmpId = forms. get ("id "). toString (); // DeleteEmployee (strEmpId); bool del = false; del = bll. deleteDuMembershipLottery (Convert. toInt32 (strEmpId); if (del) {strResponse = "deleted successfully";} context. response. write (strResponse);} else {string strOut = string. empty; AddEdit (forms, info, out strOut); context. response. write (strOut );}} /// <summary> //// </summary> /// <param name = "users"> </param> /// <param name = "numberOfRows "> </param> /// <param name =" pageIndex "> </param> /// <param name =" totalRecords "> </param> /// <returns> </returns> private string BuildJQGridResults (List <DuMembershipLotteryInfo> infos, int numberOfRows, int pageIndex, int totalRecords) {JQGridResults result = new JQGridResults (); List <JQGridRow> rows = new List <JQGridRow> (); foreach) {JQGridRow row = new JQGridRow (); row. id = info. lotteryId; row. cell = new string [6]; row. cell [0] = info. lotteryId. toString (); row. cell [1] = info. lotteryVipNo; row. cell [2] = info. lotteryVipName; row. cell [3] = info. lotteryGuaranteeNumber; row. cell [4] = info. lotteryBranchAccount; row. cell [5] = info. lotteryAddTime. toString (); rows. add (row);} result. rows = rows. toArray (); result. page = pageIndex; result. total = totalRecords/numberOfRows; result. records = totalRecords; return new JavaScriptSerializer (). serialize (result );} /// <summary> /// add or modify the operation // </summary> /// <param name = "forms"> </param> /// <param name = "collectionEmployee"> </param> // <param name = "strResponse"> </param> private void AddEdit (NameValueCollection forms, list <DuMembershipLotteryInfo> collectionInfo, out string strResponse) {string strOperation = forms. get ("reported"); string strEmpId = string. empty; DuMembershipLotteryInfo = new DuMembershipLotteryInfo (); info. lotteryVipNo = forms. get ("LotteryVipNo "). toString (); info. lotteryVipName = forms. get ("LotteryVipName "). toString (); info. lotteryGuaranteeNumber = forms. get ("LotteryGuaranteeNumber "). toString (); info. lotteryBranchAccount = forms. get ("LotteryBranchAccount "). toString (); info. lotteryAddTime = DateTime. now; int saveok = 0; // string strdate = forms. get ("UpdateTime "). toString (); if (strOperation = "add") {string result = "0"; strEmpId = (Convert. toInt32 (result) + 1 ). toString (); saveok = bll. insertDuMembershipLottery (info); if (saveok> 0) {strResponse = "record successfully added" ;}else {strResponse = "";}} else if (strOperation = "edit") {strEmpId = forms. get ("EmpId "). toString (); // get the modified ID info. lotteryId = Convert. toInt32 (strEmpId); saveok = bll. updateDuMembershipLottery (info); if (saveok> 0) {strResponse = "record successfully updated modified" ;}else {strResponse = "";}} else {strResponse = "" ;}/// <summary >///// </summary> public bool IsReusable {get {return false ;}}}