jquerypage插件

使用 JqueryPage插件时

1：在项目中添加插件的JS文件

2：在需要显示的页面添加JS文件的引用<script src="···/jquerypage.js"  type="text/javascript"></script>

　　jquery    : <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

3: 在显示页面的区域添加HTML标签：  <div id="pagelist"  class="pagination"></div>

4:

<script type="text/javascript">

$.ajax({

     var TpageSize = 12;

　　///用JSON传送的值
        url: "JsonDemo.ashx", ///发送到处理界面
        data: { "act": "getCount" },
        dataType: "json",
        success: function (json) {
            for (var i in json) {
                for (var j in json[i]) {
                    Tnum = json[i][j].getCount;
                }
            }
            $("#pagelist").pagination(Tnum, {
                prev_text: "上一页",
                next_text: "下一页",
                items_per_page: 12, //每页显示的条数
                num_display_entries: 6, //连续分页主体部分显示的条数
                current_page: 0, //当前选中的页面
                num_edge_entries: 2, //两侧显示首尾分页的条目数
                callback: pageselectfn
            });
        }
    });

function pageselectfn(page) {
    InitData(page);
}

function InitData(page) {
    page = page + 1;
    var getlist = { "act": "page", "pageIndex": page, "pageSize": TpageSize };
    $.ajax({
        url: "NewJsonDemo.ashx",
        type: "POST",
        datatype: "json",
        data: getlist,
        success: GetList
    });
}

</script>

5：JsonDemo.ashx代码：

         else if (context.Request["act"] == "page")
            {
                int pageIndex = int.Parse(context.Request["pageIndex"]);
                int pageSize = int.Parse(context.Request["pageSize"]);
                ds = new XQsys.BLL.News().SelectNews(pageIndex, pageSize, out num, "@count");//pageIndex:定位页，pageSize:每页大小，num:
                if (ds != null)
                {
                    DataTable dt = ds.Tables[0];
                    context.Response.ContentType = "json/application";
                    context.Response.Write(JsonHelp.DataTableToJSON(dt, num.ToString()));
                }
            }

6：DAL层

        public DataSet SelectNews(int pageIndex, int pageSize, out int num, string returnstring)
        {
            SqlParameter[] parms = new SqlParameter[]
            {
                new SqlParameter("@count",SqlDbType.Int)
            };
            parms[0].Direction = ParameterDirection.Output;
            return COM.SqlHelper.ExecuteQuery("sp_SelectNews", parms, pageIndex, pageSize, out num, returnstring);
        }

7:sp_SelectNews存储过程代码：

create proc [dbo].[sp_SelectNews]
@count int output
as
begin
set @count=(select COUNT(*)from News)
select title,newsid,intime from News order by newsid desc
end