62,025
社区成员
发帖
与我相关
我的任务
分享
@using T_Common;
@using T_Common.DBUtility;
@{
string conn = DBConnctionString.DBConnctionStringName.LB_Main.ToString();
if (IsAjax)
{
if(!string.IsNullOrEmpty(Request["action"]))
{
//这里面输出来的数据是这样的
/**
{"page":1,"total":1,"records":3,"rows":[{"MemberID":100006,"MemberName":"houqinqin","RowID":1},{"MemberID":100001,"MemberName":"xiaxia","RowID":2},{"MemberID":100000,"MemberName":"xiaoding","RowID":3}]}
**/
return;
}
}
}
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>测试</title>
<link href="../jqgrid/theme/1.10.0/redmond/jquery-ui.css" rel="stylesheet" />
<link href="../jqgrid/jquery.jqGrid-4.5.4/ui.jqgrid.css" rel="stylesheet" />
<script src="../jss/jquery-1.9.1.min.js" type="text/javascript"></script>
<script src="../jqgrid/jquery.jqGrid-4.5.4/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="../jqgrid/jquery.jqGrid-4.5.4/grid.locale-cn.js" type="text/javascript"></script>
<script src="../jqgrid/jquery-ui-1.10.0.custom.min.js" type="text/javascript"></script>
<script src="../jss/test.js"></script>
</head>
<body>
<table id="tbUserList"></table>
<div id="pageUserList"></div>
</body>
</html>
js代码:
$(document).ready(function () {
jQuery("#tbUserList").jqGrid({
url: "test.cshtml?_ISAJAX=true&action=getlistdata",
datatype: "json",
autowidth: true,
height: 400,
rownumbers: true,
colNames: ['用户名'],
colModel: [
{ name: 'MemberName', index: 'MemberName', width: 200, align: "center" }
],
rowNum: 30,
pager: '#pageUserList',
sortname: 'MemberID',
viewrecords: true,
multiselect: true,
sortorder: "desc",
jsonReader: {
repeatitems: false,
id: "MemberID"
},
onSortCol: function (sidx, iCol, sord) {
jQuery("#tbUserList").jqGrid('setGridParam', { url: "test.cshtml?_ISAJAX=true&action=getlistdata", page: 1, sidx: sidx, sord: sord }).trigger("reloadGrid");
}
}).navGrid("#pageUserList", { search: false, edit: false, add: false, del: false });
});