分页效果（无刷新）

来源：互联网发布：本溪农业盘古网络编辑：程序博客网时间：2024/05/03 03:53

---------------------------------存储过程--------------------------

ALTER proc [dbo].[pro_fenye]
@pagesize int,
@pageindex int
as
select * from(select ROW_NUMBER() over(order by Id) as rownumber,Id,NewsTitle,Substring(NewsContent,0,20) as NewsContent,CreateTime from T_News1)T
WHERE rownumber>(@pageindex-1)*@pagesize AND rownumber<=（@pageindex*@pagesize）

-------------------------------DAL层方法-----------------------------

///分页获取

public DataTable GetListDataTable(int PageSize, int PageIndex)
        {
            SqlParameter[] parameters = {

     new SqlParameter("@PageSize", SqlDbType.Int),
     new SqlParameter("@PageIndex", SqlDbType.Int)
     };

            parameters[0].Value = PageSize;
            parameters[1].Value = PageIndex;
            return DbHelperSQL.RunProcedureDataTable("pro_fenye", parameters);
        }

/// <summary>
  /// 获取记录总数
  /// </summary>
  public int GetRecordCount(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select count(1) FROM T_News1 ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   object obj = DbHelperSQL.GetSingle(strSql.ToString());
   if (obj == null)
   {
    return 0;
   }
   else
   {
    return Convert.ToInt32(obj);
   }
  }

------------------------------------BLL层方法-----------------------------------

///分页方法

public DataTable GetListDataTable(int pagesize, int pageindex)
        {
            return dal.GetListDataTable(pagesize, pageindex);
        }

/// <summary>
  /// 分页获取数据列表总条数
  /// </summary>
  public int GetRecordCount(string strWhere)
  {
   return dal.GetRecordCount(strWhere);
  }

--------------------------------------html页-----------------------------

strtable += '<td>' + result.d[i].NewsTitle + '</td>';

strtable += '<td>' + result.d[i].NewsContent + '</td>';

                            strtable += '<td>' + result.d[i].CreateTime + '</td>';
                            strtable += '</tr>';
                        }
                        strtable += '</table>';
                        $('#mydiv').html(strtable);
                    }
                })
            }

            //根据传递到后台的每页显示的记录数量来获取最大的页码(就是一共有多少页)
            $.ajax({
                type: "post",
                contentType: "application/json",
                url: "WebService1.asmx/GetLastPageindex",
                data: "{pagesize:" + pagesize + "}",
                success: function (result) {
                    lastpageindex = result.d;
                }
            })

            //显式调用函数，在页面初次加载时加载第一页数据
            loaddata();
            //下一页
            $('a:eq(2)').click(function () {
                if (pageindex < lastpageindex) {
                    pageindex++;
                    loaddata();
                }

            })
            //上一页
            $('a:eq(1)').click(function () {
                if (pageindex > 1) {
                    pageindex--;
                    loaddata();
                }
            })
            //第一页
            $('a:first').click(function () {
                pageindex = 1;
                loaddata();
            })
            //最后一页
            $('a:eq(3)').click(function () {
                pageindex = lastpageindex;
                loaddata();
            })
            $('a:last').click(function () {
                pageindex = $('#txtPageindex').val();
                loaddata();
            })
        })
    </script>
</head>
<body>
<div id="mydiv">
</div>
<div><a href="#">第一页</a><a href="#">上一页</a><a href="#">下一页</a><a href="#">最后一页</a><input
        id="txtPageindex" type="text" /><a href="#">Go</a></div>
</body>
</html>

-------------------------------WebService1.asmx---------------------------------

[WebMethod]
        public List<Model.T_News1> GetListAjax(int pagesize, int pageindex)
        {
            BLL.T_News1 bnews = new BLL.T_News1();
            DataTable dt= bnews.GetListDataTable(pagesize, pageindex);

List<Model.T_News1> list = new List<Model.T_News1>();

            int Id;
            string newstitle = "";
            string newscontent = "";
            DateTime createtime;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Id = Convert.ToInt32(dt.Rows[i]["Id"]);
                newstitle = dt.Rows[i]["NewsTitle"].ToString();
                newscontent = dt.Rows[i]["NewsContent"].ToString();
                createtime = Convert.ToDateTime(dt.Rows[i]["CreateTime"]);

                Model.T_News1 news = new Model.T_News1()
                {
                    Id = Id,
                    NewsTitle = newstitle,
                    NewsContent = newscontent,
                    CreateTime = createtime
                };
                list.Add(news);
            }
            return list;
        }
        [WebMethod]
        public int GetLastPageindex(int pagesize)
        {
            BLL.T_News1 bnews = new BLL.T_News1();
            int totalcount= bnews.GetRecordCount("");
            if (totalcount % pagesize == 0)
            {
                return totalcount / pagesize;
            }
            else
            {
                return totalcount / pagesize + 1;
            }
        }