jadgrid.aspx
<!DOCTYPE html><!--HTML5 doctype--><html><head runat="server"><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0"><title>JQGrid 测试分页用</title> ???<link href="~/Styles/Site.css" rel="stylesheet" type="text/css" /> ???<script src="JQGridReq/jquery-1.9.0.min.js" type="text/javascript"></script> ???<link href="JQGridReq/jquery-ui-1.9.2.custom.css" rel="stylesheet" type="text/css" /> ???<script src="JQGridReq/jquery.jqGrid.js" type="text/javascript"></script> ???<link href="JQGridReq/ui.jqgrid.css" rel="stylesheet" type="text/css" /> ???<script src="JQGridReq/grid.locale-cn.js" type="text/javascript"></script> ???<script type="text/javascript"> ???????$(function () { ???????????$("#UsersGrid").jqGrid({ ???????????????url: ‘geovinHandler.ashx‘, ???????????????datatype: ‘json‘, ???????????????height: 550, ???????????????colNames: [‘序號‘, ‘會員卡號‘, ‘會員姓名‘, ‘保證單號‘, ‘會員登錄賬號‘, ‘發佈時間‘], ???????????????colModel: [ ?????????????????????????{ name: ‘LotteryId‘, index: ‘LotteryId‘, width: 100, sortable: true }, ?????????????????????????{ name: ‘LotteryVipNo‘, width: 100, sortable: true, editable: true }, ?????????????????????????{ name: ‘LotteryVipName‘, width: 100, sortable: true, editable: true }, ?????????????????????????{ name: ‘LotteryGuaranteeNumber‘, width: 100, sortable: true, editable: true }, ?????????????????????????{ name: ‘LotteryBranchAccount‘, width: 100, sortable: true, editable: true }, ?????????????????????????{ name: ‘LotteryAddTime‘,formatter: "date",ormatoptions: { srcformat: "ISO8601Long", newformat: "m/d/Y h:i A" }, width: 150, sortable: true } ?????????????????????], ???????????????rowNum: 50, ???????????????mtype: ‘GET‘, ???????????????loadonce: true, ???????????????rowList: [50, 100, 300], ???????????????pager: ‘#UsersGridPager‘, ???????????????sortname: ‘LotteryId‘, ???????????????viewrecords: true, ???????????????sortorder: ‘asc‘, ???????????????editurl: ‘geovinHandler.ashx‘, ???????????????caption: ‘會員穫得中獎名單‘ ???????????}); ???????????$("#UsersGrid").jqGrid(‘navGrid‘, ‘#UsersGridPager‘, ???????????{ ??????????????????????edit: true, ??????????????????????add: true, ??????????????????????del: true, ??????????????????????search: true, ??????????????????????searchtext: "Search", ??????????????????????addtext: "Add", ??????????????????????edittext: "Edit", ??????????????????????deltext: "Delete" ??????????????????}, ??????????????????{ ??//EDIT ??????????????????????// ??????????????????????height: 300, ??????????????????????// ??????????????????????width: 400, ??????????????????????// ??????????????????????top: 50, ??????????????????????// ??????????????????????left: 100, ??????????????????????// ??????????????????????dataheight: 280, ??????????????????????closeOnEscape: true, //Closes the popup on pressing escape key ??????????????????????reloadAfterSubmit: true, ??????????????????????drag: true, ??????????????????????afterSubmit: function (response, postdata) { ??????????????????????????if (response.responseText == "") { ??????????????????????????????$(this).jqGrid(‘setGridParam‘, { datatype: ‘json‘ }).trigger(‘reloadGrid‘); //Reloads the grid after edit ??????????????????????????????return [true, ‘‘] ??????????????????????????} ??????????????????????????else { ??????????????????????????????$(this).jqGrid(‘setGridParam‘, { datatype: ‘json‘ }).trigger(‘reloadGrid‘); //Reloads the grid after edit ??????????????????????????????return [false, response.responseText]//Captures and displays the response text on th Edit window ??????????????????????????} ??????????????????????}, ??????????????????????editData: { ??????????????????????????EmpId: function () { ??????????????????????????????var sel_id = $(‘#UsersGrid‘).jqGrid(‘getGridParam‘, ‘selrow‘); ??????????????????????????????var value = $(‘#UsersGrid‘).jqGrid(‘getCell‘, sel_id, ‘LotteryId‘); ??????????????????????????????return value; ??????????????????????????} ??????????????????????} ??????????????????}, ??????????????????{ ??????????????????????closeAfterAdd: true, //Closes the add window after add 如何自定義添加窗口? ??????????????????????afterSubmit: function (response, postdata) { ??????????????????????????if (response.responseText == "") { ??????????????????????????????$(this).jqGrid(‘setGridParam‘, { datatype: ‘json‘ }).trigger(‘reloadGrid‘)//Reloads the grid after Add ??????????????????????????????return [true, ‘‘] ??????????????????????????} ??????????????????????????else { ??????????????????????????????$(this).jqGrid(‘setGridParam‘, { datatype: ‘json‘ }).trigger(‘reloadGrid‘)//Reloads the grid after Add ??????????????????????????????return [false, response.responseText] ??????????????????????????} ??????????????????????} ??????????????????}, ??????????????????{ ??//DELETE ??????????????????????closeOnEscape: true, ??????????????????????closeAfterDelete: true, ??????????????????????reloadAfterSubmit: true, ??????????????????????closeOnEscape: true, ??????????????????????drag: true, ??????????????????????afterSubmit: function (response, postdata) { ??????????????????????????if (response.responseText == "") { ??????????????????????????????$("#UsersGrid").trigger("reloadGrid", [{ current: true}]); ??????????????????????????????return [false, response.responseText] ??????????????????????????} ??????????????????????????else { ??????????????????????????????$(this).jqGrid(‘setGridParam‘, { datatype: ‘json‘ }).trigger(‘reloadGrid‘); ??????????????????????????????return [true, response.responseText] ??????????????????????????} ??????????????????????}, ??????????????????????delData: { ??????????????????????????EmpId: function () { ??????????????????????????????var sel_id = $(‘#UsersGrid‘).jqGrid(‘getGridParam‘, ‘selrow‘); ??????????????????????????????var value = $(‘#UsersGrid‘).jqGrid(‘getCell‘, sel_id, ‘LotteryId‘); ??????????????????????????????return value; ??????????????????????????} ??????????????????????} ??????????????????}, ??????????????????{//SEARCH ??????????????????????closeOnEscape: true ??????????????????}); ???????}); ????????????????????</script> ?</head><body> ???<form id="form1" runat="server"> ???<div> ?<table id="UsersGrid" cellpadding="0" cellspacing="0"> ??????</table> ?????????????<div id="UsersGridPager"> ?????????</div> ?????</div> ???</form></body></html>geovinHandler.ashx:
/// <summary> ???/// $codebehindclassname$ 的摘要说明 ???/// geovindu ???/// 20180128 ???/// 涂聚文 ???/// </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("oper"); // ???????????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 = "删除成功"; ???????????????} ???????????????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 (DuMembershipLotteryInfo info in infos) ???????????{ ???????????????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> ???????/// 添加或修改操作 ???????/// </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("oper"); ???????????string strEmpId = string.Empty; ???????????DuMembershipLotteryInfo info = 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(); //获取修改ID ???????????????info.LotteryId = Convert.ToInt32(strEmpId); ???????????????saveok=bll.UpdateDuMembershipLottery(info); ???????????????if (saveok > 0) ???????????????{ ???????????????????strResponse = "record successfully updated修改成功"; ???????????????} ???????????????else ???????????????{ strResponse = ""; } ???????????} ???????????else ???????????{ ???????????????strResponse = ""; ???????????} ???????} ???????/// <summary> ???????/// ????????/// </summary> ???????public bool IsReusable ???????{ ???????????get ???????????{ ???????????????return false; ???????????} ???????} ???}
JqGrid: paing int asp.net
原文地址：https://www.cnblogs.com/geovindu/p/8383554.html