ASP.NET分页

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace PagerControls
{
    [DefaultProperty("Text")]
    [ToolboxData("<{0}:PagerControl runat=server></{0}:PagerControl>")]
    public class PagerControl : WebControl
    {

        private int currentPage;                    // 当前页的页码
        private int pageCount;                        // 总页数
        private int recordCount;                    //总记录数

        private bool showPrevious = false;        // 是否显示 上一页、第一页 的链接
        private bool showNext = false;            // 是否显示 下一页、最末页 的链接

        private int startPage;                        // 显示的第一页 的 页码
        private int endPage;                            // 显示的最末页 的 页码

        public int pageSize;                  //分页条数

        public PagerControl()
        {
            // 当前页之前可以显示的最多链接数，大于此条链接将被隐藏
            ViewState["PreviousPageCount"] = 5;

            // 当前页之后可以显示的最多链接数，大于此条链接将被隐藏
            ViewState["AfterPageCount"] = 4;

            // 供客户端设置样式
            ViewState["CssClass"] = "Pager";
        }

        public new string CssClass
        {
            get { return ViewState["CssClass"].ToString(); }
            set { ViewState["CssClass"] = value; }
        }

        public int PreviousPageCount
        {
            get { return (int)ViewState["PreviousPageCount"]; }
            set { ViewState["PreviousPageCount"] = value; }
        }

        public int AfterPageCount
        {
            get { return (int)ViewState["AfterPageCount"]; }
            set { ViewState["AfterPageCount"] = value; }
        }

        public UrlManager UrlManager
        {
            get { return (UrlManager)ViewState["UrlManager"]; }
            set { ViewState["UrlManager"] = value; }
        }

        // 添加“第一页”，“上一页”的连接
        private void AddPreviousLink(UrlManager UrlManager, HtmlTextWriter output)
        {
            output.RenderBeginTag(HtmlTextWriterTag.Li);

            //output.AddAttribute(HtmlTextWriterAttribute.Class, "PagerIcon");
            output.AddAttribute(HtmlTextWriterAttribute.Title, "第一页");
            //output.AddAttribute(HtmlTextWriterAttribute.Href, UrlManager.GetPageUrl(1));
            output.AddAttribute(HtmlTextWriterAttribute.Onclick, "$(\"#page-content\").load('" + UrlManager.GetPageUrl(1) + "')");
            output.AddAttribute(HtmlTextWriterAttribute.Href, "javascript:void(0);");
            output.RenderBeginTag(HtmlTextWriterTag.A);
            output.Write("&lt;&lt;");
            output.RenderEndTag();

            //output.AddAttribute(HtmlTextWriterAttribute.Class, "PagerIcon");
            output.AddAttribute(HtmlTextWriterAttribute.Title, "上一页");
            //output.AddAttribute(HtmlTextWriterAttribute.Href, UrlManager.GetPageUrl(currentPage - 1));
            output.AddAttribute(HtmlTextWriterAttribute.Onclick, "$(\"#page-content\").load('" + UrlManager.GetPageUrl(currentPage - 1) + "')");
            output.AddAttribute(HtmlTextWriterAttribute.Href, "javascript:void(0);");
            output.RenderBeginTag(HtmlTextWriterTag.A);
            output.Write("&lt;");
            output.RenderEndTag(); //A

            output.RenderEndTag(); //Li

            showPrevious = false;    // 只显示一次
        }


        // 添加 “下一页”、“最末页” 的链接
        private void AddNextLink(UrlManager UrlManager, HtmlTextWriter output)
        {
            output.RenderBeginTag(HtmlTextWriterTag.Li);

            //output.AddAttribute(HtmlTextWriterAttribute.Class, "pagination page");
            output.AddAttribute(HtmlTextWriterAttribute.Title, "下一页");
            //output.AddAttribute(HtmlTextWriterAttribute.Href, UrlManager.GetPageUrl(currentPage + 1));
            output.AddAttribute(HtmlTextWriterAttribute.Onclick, "$(\"#page-content\").load('" + UrlManager.GetPageUrl(currentPage + 1) + "')");
            output.AddAttribute(HtmlTextWriterAttribute.Href, "javascript:void(0);");
            output.RenderBeginTag(HtmlTextWriterTag.A);
            output.Write("&gt;");
            output.RenderEndTag();

            //output.AddAttribute(HtmlTextWriterAttribute.Class, "pagination page");
            output.AddAttribute(HtmlTextWriterAttribute.Title, "最末页");
            //output.AddAttribute(HtmlTextWriterAttribute.Href, UrlManager.GetPageUrl(pageCount));
            output.AddAttribute(HtmlTextWriterAttribute.Onclick, "$(\"#page-content\").load('" + UrlManager.GetPageUrl(pageCount) + "')");
            output.AddAttribute(HtmlTextWriterAttribute.Href, "javascript:void(0);");
            output.RenderBeginTag(HtmlTextWriterTag.A);
            output.Write("&gt;&gt;");
            output.RenderEndTag();

            output.RenderEndTag(); //Li

            showNext = false;    // 可有可无，程序会跳出循环
        }


        // 根据当前页，当前页之前可以显示的页数，算得从第几页开始进行显示
        private void SetStartPage()
        {

            // 如果当前页小于它前面所可以显示的条目数，
            // 那么显示第一页就是实际的第一页
            if (currentPage <= PreviousPageCount)
            {
                startPage = 1;
            }
            else
            // 这种情况下 currentPage 前面总是能显示完，
            // 要根据后面的长短确定是不是前面应该多显示
            {
                if (currentPage > PreviousPageCount + 1)
                    showPrevious = true;

                int linkLength = (pageCount - currentPage + 1) + PreviousPageCount;

                int startPage = currentPage - PreviousPageCount;

                while (linkLength < PreviousPageCount + AfterPageCount + 1 && startPage > 1)
                {
                    linkLength++;
                    startPage--;
                }

                this.startPage = startPage;
            }
        }

        // 根据CurrentPage、总页数、当前页之后长度 算得显示的最末页是 第几页
        private void SetEndPage()
        {
            // 如果当前页加上它之后可以显示的页数 大于 总页数，
            // 那么显示的最末页就是实际的最末页
            if (currentPage + AfterPageCount >= pageCount)
            {
                endPage = pageCount;
            }
            else
            {

                // 这种情况下 currentPage后面的总是可以显示完，
                // 要根据前面的长短确定是不是后面应该多显示

                int linkLength = (currentPage - startPage + 1) + AfterPageCount;

                int endPage = currentPage + AfterPageCount;

                while (linkLength < PreviousPageCount + AfterPageCount + 1 && endPage < pageCount)
                {
                    linkLength++;
                    endPage++;
                }

                if (endPage < pageCount)
                    showNext = true;

                this.endPage = endPage;
            }
        }


        // 显示在页面上
        protected override void Render(HtmlTextWriter output)
        {

            //////output.AddAttribute(HtmlTextWriterAttribute.Class, CssClass);
            //////output.RenderBeginTag(HtmlTextWriterTag.Div);

            if (UrlManager == null)
                throw new ArgumentNullException("UrlManager 不能为 Null");

            // 获取当前页
            currentPage = UrlManager.CurrentPageIndex;

            // 获取总页数
            pageCount = UrlManager.PageCount;

            // 获取总记录数
            recordCount = UrlManager.RecordCount;

            SetStartPage();
            SetEndPage();

            output.RenderBeginTag(HtmlTextWriterTag.Span);
            string str = "记录共" + pageCount + "页，" + recordCount + "条记录，当前" + currentPage + "页，每页" + pageSize + "条。";
            output.Write(String.Format("<span class=\"count\">{0}</span>", str));
            //output.Write(String.Format(" ( 第<b>{0}</b>页/共<b>{1}</b>页 )", currentPage, pageCount));
            output.RenderEndTag();    // Span

            output.AddAttribute(HtmlTextWriterAttribute.Class, "pagination page");
            output.RenderBeginTag(HtmlTextWriterTag.Ul);

            if (recordCount > 1)
            {
                showPrevious = true;
            }

            if (currentPage <= endPage)
            {
                showNext = true;
            }

            // 循环打印链接
            for (int i = startPage; i <= endPage; i++)
            {
                if (showPrevious)             // 如果需要显示前一页、第一页链接
                    AddPreviousLink(UrlManager, output);

                if (i == currentPage)
                {
                    output.AddAttribute(HtmlTextWriterAttribute.Class, "on");
                }
                output.RenderBeginTag(HtmlTextWriterTag.Li);
                //output.AddAttribute(HtmlTextWriterAttribute.Href, UrlManager.GetPageUrl(i));
                string url = UrlManager.GetPageUrl(i);
                output.AddAttribute(HtmlTextWriterAttribute.Onclick, "$(\"#page-content\").load('" + url + "')");
                output.AddAttribute(HtmlTextWriterAttribute.Href, "javascript:void(0);");
                output.RenderBeginTag(HtmlTextWriterTag.A);
                output.Write(i);
                output.RenderEndTag();    // A

                output.RenderEndTag();    // Li

                if (i == endPage && showNext)    // 如果需要显示 下一页、最末页 链接
                    AddNextLink(UrlManager, output);
            }

            output.RenderEndTag(); //Ul

            ////////output.RenderEndTag();    // Div
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;

namespace PagerControls
{
    [Serializable]
    public abstract class UrlManager
    {

        protected int currentPageIndex;            // 当前页码
        protected int recordCount;                    // 记录总数
        protected int pageSize;                        // 分页大小
        protected int pageCount;                    // 总页数
        protected string queryParam;                // 传递页数的参数名称

        protected UrlManager(int recordCount, int pageSize, string queryParam)
        {

            if (recordCount < 0)
                throw new ArgumentOutOfRangeException("recordCount 应该大于等于 0 !");
            if (pageSize <= 0)
                throw new ArgumentOutOfRangeException("pageSize 应该大于 0 ！");
            if (String.IsNullOrEmpty(queryParam))
                throw new ArgumentNullException("queryParam 不能为空！");

            // 设置私有变量
            this.recordCount = recordCount;
            this.pageSize = pageSize;
            this.queryParam = queryParam;
            this.pageCount = getPageCount(recordCount, pageSize);
            this.currentPageIndex = getPageIndex(recordCount, pageCount, queryParam);
        }


        // 获取页码总数
        private int getPageCount(int recordCount, int pageSize)
        {
            int pageCount;

            // 如果记录数为0，也认为有一页(因为至少需要进行一个显示)
            if (recordCount == 0)
            {
                pageCount = 1;
            }
            else
            {
                // 计算总页数
                if (recordCount % pageSize == 0)
                    pageCount = recordCount / pageSize;
                else
                    pageCount = (recordCount / pageSize) + 1;
            }

            return pageCount;
        }

        // 从Url参数中获得但前页码
        private int getPageIndex(int recordCount, int pageCount, string queryParam)
        {
            if (recordCount == 0)
                return 1;        // 如果记录数为0，则显示为第一页

            int pageIndex;

            // 从Url参数获得当前页码
            string queryIndex =
                HttpContext.Current.Request.QueryString[queryParam];

            // 对页码进行一些校验
            if (string.IsNullOrEmpty(queryIndex))
                pageIndex = 1;        // 显示第一页
            else
            {
                try
                {
                    pageIndex = Math.Abs(int.Parse(queryIndex));

                    if (pageIndex == 0)
                        pageIndex = 1;

                    // 如果当前页大于总页数，设当前页为最后一页
                    if (pageIndex > pageCount)
                        pageIndex = pageCount;
                }
                catch
                {
                    pageIndex = 1;    // 显示第一页
                }
            }

            return pageIndex;
        }

        public int PageCount
        {
            get { return pageCount; }
        }

        public int RecordCount
        {
            get { return recordCount; }
        }

        public int PageSize
        {
            get { return pageSize; }
        }

        public int CurrentPageIndex
        {
            get { return currentPageIndex; }
        }
        public abstract string GetPageUrl(int pageIndex);
    }


    // 我提供的默认 DefaultUrlManager，如果你要使用控件，只要继承自UrlManager
    // 并覆盖 GetPageUrl() 方法即可。
    [Serializable]
    public class DefaultUrlManager : UrlManager
    {

        public DefaultUrlManager(int recordCount, int pageSize, string queryParam)
            : base(recordCount, pageSize, queryParam) { }

        public DefaultUrlManager(int recordCount, int pageSize)
            : this(recordCount, pageSize, "Page") { }

        public DefaultUrlManager(int recordCount)
            : this(recordCount, 10) { }

        // 获得页面Url
        public override string GetPageUrl(int pageIndex)
        {
            string pageUrl = HttpContext.Current.Request.RawUrl;

            string pattern = @"(?<=[?&]" + queryParam + @"=)(\d+)\b";
            Regex reg = new Regex(pattern, RegexOptions.IgnoreCase);

            // 如果找到匹配，也就是URL中含有类似 ?page=3 或者 &page=4 这样的字符串
            // 则对后面的数值进行替换
            if (reg.IsMatch(pageUrl))
            {
                pageUrl = reg.Replace(pageUrl, pageIndex.ToString());
            }
            else
            {
                string queryString = HttpContext.Current.Request.Url.Query;

                if (string.IsNullOrEmpty(queryString))
                    pageUrl += "?" + queryParam + "=" + pageIndex.ToString();
                else
                    pageUrl += "&" + queryParam + "=" + pageIndex.ToString();
            }

            return pageUrl;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace PagerControls
{
    // 通过 manager 提供的参数算得 GetRange()类 需要的参数(起始索引index,以及长度count)：
    // 然后调用 List<T> 的 GetRange()方法。
    public class PagerAdapter<T>
    {
        List<T> list;

        public PagerAdapter(List<T> list)
        {
            this.list = list;
        }

        /// <summary>
        /// 数据加载完毕后,从 List 集合中取得分页信息
        /// </summary>
        /// <param name="manager"></param>
        /// <returns></returns>
        public List<T> GetRange(UrlManager manager)
        {
            int currentPageIndex = manager.CurrentPageIndex;
            int pageSize = manager.PageSize;
            int recordCount = manager.RecordCount;
            int count, start;

            if (currentPageIndex * pageSize > recordCount)
            {
                count = pageSize - (currentPageIndex * pageSize - recordCount);
            }
            else
            {
                count = pageSize;
            }

            start = (currentPageIndex - 1) * pageSize;

            return list.GetRange(start, count);
        }

        public PagerAdapter() { }

        /// <summary>
        /// 获取分页信息,自定义扩展方法 SQL 数据库分页方式,取得当前页码
        /// </summary>
        /// <param name="manager"></param>
        /// <param name="_pageIndex"></param>
        /// <param name="_pageSize"></param>
        public void GetPage(UrlManager manager, ref int _pageIndex, ref int _pageSize)
        {
            int currentPageIndex = manager.CurrentPageIndex;
            int pageSize = manager.PageSize;
            int recordCount = manager.RecordCount;

            if (currentPageIndex <= 0)
            {
                _pageIndex = 1;
            }
            else
            {
                _pageIndex = currentPageIndex;
            }
            _pageSize = pageSize;
        }
    }
}

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace PagerControls.Test
{
    public class PagerInfo
    {
        public static string RequestRowNum(string from, string where)
        {
            try
            {
                string bsSQL = "SELECT COUNT(*) RowNum from " + from + where; 
                return "";
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public static DataTable RequestPage(string from, string where, string field, string pageSize, string pageIndex)
        {
            try
            {
                 string bsSQL = "declare @pagesize integer,@cpage integer; ";
                bsSQL += "set @pagesize ="+pageSize+";";
                bsSQL += "set @cpage = "+pageIndex+";";

                bsSQL += "select top (@pagesize) * from " + from + " where " + where + " AND " + field + " not in(select top ((@cpage - 1) * @pagesize) " + field + " from " + from + " where " + where + " order by " + field + " desc) order by " + field + " desc";

                return null;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="PagerControls.Test.Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div class="mange-company-tab">
            <div class="tab-main">
                <table class="table table-hover table-striped">
                    <thead>
                        <tr>
                            <th>姓名</th>
                            <th>账户 </th>
                            <th>联系电话</th>
                            <th>操作</th>
                        </tr>
                    </thead>
                    <tbody>
                        <asp:Literal  ID="literRecord" runat="server"></asp:Literal>
                    </tbody>
                </table>
            </div>
            <div class="tab-bottom">
                <asp:PlaceHolder ID="phHolder" runat="server"></asp:PlaceHolder>
            </div>
        </div>
    </form>
</body>
</html>

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace PagerControls.Test
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //RequestUsers();
                this.RequestData();
            }
        }

        /// <summary>
        /// 数据库分页取数据
        /// </summary>
        private void RequestData()
        {
            try
            {
               string num = PagerInfo.RequestRowNum("Users", " where Status = 1 ");

                // 动态使用方式
                PagerControl pager = new PagerControl();
                pager.pageSize = 10;
                // 设置根据Request.QueryString获取页码的参数
                DefaultUrlManager manager = new DefaultUrlManager(Convert.ToInt32(num), pager.pageSize, "P");
                pager.UrlManager = manager;        // 因为 HttpContext 的原因 UrlManager 不可串行化

                // 如果你实现了自己的IUrlManager接口，这里可能是这样：
                // pager.UrlManager = new YourUrlManger(133);             

                //pager.CssClass = "GreenStyle";    // 设置颜色    
                pager.PreviousPageCount = 3;        // 设置当前页之前显示的最大链接数
                pager.AfterPageCount = 3;            // 设置当前也之后可以显示的最大链接数

                // 将控件加入到页面上
                phHolder.Controls.Add(pager);

                // 使用 GetRange() 方法进行分页
                PagerAdapter<object> adpter = new PagerAdapter<object>();
                int pageIndex = 1;
                int pageSize = 10;
                adpter.GetPage(manager, ref pageIndex, ref pageSize);
                DataTable dt = PagerInfo.RequestPage("Users", " Status = 1 ", "ID",pageSize.ToString(), pageIndex.ToString());
                StringBuilder strHtml = new StringBuilder();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    strHtml.Append("<tr><td>" + dt.Rows[i]["NickName"].ToString() + "</td><td>" + dt.Rows[i]["UserName"].ToString() + "</td><td>" + dt.Rows[i]["Mobile"].ToString() + "</td><td uid=" + dt.Rows[i]["ID"].ToString() + " cid=" + dt.Rows[i]["CompanyID"].ToString() + "><a href=\"javascript:void(0);\" class=\"edit-user\"><i class=\"icon icon-edit\"></i></a><a href=\"javascript:void(0);\" class=\"del-user\"><i class=\"icon icon-del\"></i></a></td></tr>");
                }
                this.literRecord.Text = strHtml.ToString();
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}