首页 > 代码库 > jquery-pager分页

jquery-pager分页

2024-07-11 15:17:28   210人阅读

首先引用这三个文件

<script src="http://www.mamicode.com/Scripts/jquery-1.4.4.min.js" type="text/javascript"></script>
<script src="http://www.mamicode.com/Scripts/jquery-pager-1.0.js" type="text/javascript"></script>
<link href="http://www.mamicode.com/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[0].Rows.Count];            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)            {                string mxdm = ds.Tables[0].Rows[i]["MXDM"].ToString();                string mxdmmc = ds.Tables[0].Rows[i]["MXDMMC"].ToString();                double mj = Double.Parse(ds.Tables[0].Rows[i]["MJ"].ToString() == "" ? "0" : ds.Tables[0].Rows[i]["MJ"].ToString());                int dj = Int32.Parse(ds.Tables[0].Rows[i]["DJ"].ToString() == "" ? "0" : ds.Tables[0].Rows[i]["DJ"].ToString());                int ljjm = Int32.Parse(ds.Tables[0].Rows[i]["LJJM"].ToString() == "" ? "0" : ds.Tables[0].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();        }

 


联系
我们