首先引用这三个文件
<script src="../../Scripts/jquery-1.4.4.min.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-pager-1.0.js" type="text/javascript"></script>
<link href="../../Scripts/pager.css" rel="stylesheet" type="text/css" />
HTML
<body>
<div>
<div class="title">
<h1>
工作量统计表</h1>
</div>
<table width="50%" border="1" class="t1">
<thead>
<th>
墓型代码
</th>
<th>
墓型名称
</th>
<th>
面积
</th>
<th>
单价
</th>
<th>
累计建墓
</th>
</thead>
<tbody style="text-align: center; font-size: 12px; color: black;">
</tbody>
</table>
<br />
<div id="page-bottom" style="width: 55%; border: 1px;" class="pageinfo">
</div>
</div>
</body>
前端代码：
<script language="javascript" type="text/javascript">
//得到页面数据总数
function getPageCount() {
var result = "";
$.ajax({
type: "POST",
url: "/Manager/WorkStatistic/PageGetCount",
cache: "false",
async: false,
success: function (data) {
result = eval(data);
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert("程序异常!");
}
});
return result;
};
$(document).ready(function () {
//加载页数及页码
var recordCount = getPageCount();
InitPager(recordCount, 1);
});
function Init(PageIndex, PageCount) {
var receive_url = "/Manager/WorkStatistic/WorkStatistics?pageIndex=" + PageIndex + "&PageCount=" + PageCount;
$.ajax({
type: "GET",
url: receive_url,
cache: "false",
success: function (data) {
data = eval(data);
$("tbody").html("");
var html = "";
for (var i = 0; i < data.length; i++) {
var json = data[i];
var mxdm = json.mxdm;
var mxdmmc = json.mxdmmc;
var mj = json.mj;
var dj = json.dj;
var ljjm = json.ljjm;
html += "<tr><td>" + mxdm + "</td><td>" + mxdmmc + "</td><td>" + mj + "</td><td>" + dj + "</td><td>" + ljjm + "</td></tr>";
}
$("tbody").append(html);
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert("程序异常!");
}
});
};
//RecordCount[总记录数] PageIndex[当前页码]
function InitPager(RecordCount, PageIndex) {
$("#page-bottom").setPager({ RecordCount: RecordCount, PageIndex: PageIndex, buttonClick: PageClick });
//分页同时更新数据源
Init(PageIndex, 20);
};
//分页事件
PageClick = function (RecordCount, PageIndex) {
InitPager(RecordCount, PageIndex);
};
</script>
客户端代码：
public ActionResult WorkStatistics()
{
string pageIndex = Request.Params.Get("PageIndex");
string pageCount = Request.Params.Get("PageCount");
int page = Convert.ToInt32(pageIndex) * Convert.ToInt32(pageCount);
string SQL_Init = @"SELECT * FROM ( SELECT rownum RN,t.* FROM ( SELECT a.mxdm,a.mxdmmc,a.mj,AVG((SELECT dj FROM mxdm WHERE a.mxdm= mxdm)) dj,COUNT(*) ljjm"
+ " FROM mwdmxx a WHERE a.azfsdm= '01' GROUP BY a.mxdm ,a.mxdmmc,a.mj ORDER BY a.mxdm) t WHERE rownum <=" + page + ") WHERE RN > " + (page - Convert.ToInt32(pageCount)); DataSet ds = DBhelper.Query(SQL_Init);
//实例化结构体数组
TombType_SaleInfo[] result = new TombType_SaleInfo[ds.Tables[].Rows.Count];
for (int i = ; i < ds.Tables[].Rows.Count; i++)
{
string mxdm = ds.Tables[].Rows[i]["MXDM"].ToString();
string mxdmmc = ds.Tables[].Rows[i]["MXDMMC"].ToString();
double mj = Double.Parse(ds.Tables[].Rows[i]["MJ"].ToString() == "" ? "" : ds.Tables[].Rows[i]["MJ"].ToString());
int dj = Int32.Parse(ds.Tables[].Rows[i]["DJ"].ToString() == "" ? "" : ds.Tables[].Rows[i]["DJ"].ToString());
int ljjm = Int32.Parse(ds.Tables[].Rows[i]["LJJM"].ToString() == "" ? "" : ds.Tables[].Rows[i]["LJJM"].ToString()); TombType_SaleInfo temp = new TombType_SaleInfo(mxdm, mxdmmc, mj, dj, ljjm);
result[i] = temp;
}
return Json(result, JsonRequestBehavior.AllowGet);
}
//得到数据总条数
public void PageGetCount()
{
string SQL_Init = @"SELECT count(*) FROM (SELECT count(a.mxdm) FROM mwdmxx a WHERE a.azfsdm= '01' GROUP BY a.mxdm ,a.mxdmmc,a.mj )";
string count = DBhelper.GetScalar(SQL_Init);
Response.Write(count);
Response.End();
}