winform通用分页控件

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CommonModel;
using WebService.WSBySoap;
using Util;

namespace BillsInquiry.Forms
{
    /**/
    /// <summary>
    /// 申明委托
    /// </summary>
    /// <param name="e"></param>
    /// <returns></returns>
    public delegate int EventPagingHandler(EventPagingArg e);
    /**/
    /// <summary>
    /// 分页控件呈现
    /// </summary>
    public partial class Pager : UserControl
    {
        public Pager()
        {
            InitializeComponent();
        }
        public event EventPagingHandler EventPaging;
        /**/
        /// <summary>
        /// 每页显示记录数
        /// </summary>
        private int _pageSize = 15;
        /**/
        /// <summary>
        /// 每页显示记录数
        /// </summary>
        public int PageSize
        {
            get { return _pageSize; }
            set
            {
                _pageSize = value;
               
            }
        }

        private int _nMax = 0;
        /**/
        /// <summary>
        /// 总记录数
        /// </summary>
        public int NMax
        {
            get { return _nMax; }
            set
            {
                _nMax = value;
               
            }
        }

        private int _pageCount = 0;
        /**/
        /// <summary>
        /// 页数=总记录数/每页显示记录数
        /// </summary>
        public int PageCount
        {
            get { return _pageCount; }
            set { _pageCount = value; }
        }

        private int _pageCurrent = 1;
        /**/
        /// <summary>
        /// 当前页号
        /// </summary>
        public int PageCurrent
        {
            get { return _pageCurrent; }
            set { _pageCurrent = value; }
        }

        /// <summary>
        /// 设置页面大小
        /// </summary>
        private void GetPageCount()
        {
            if (this.NMax > 0)
            {
                this.PageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(this.NMax) / Convert.ToDouble(this.PageSize)));
                lblPageCount.Text = PageCurrent+" / " + PageCount.ToString();
                lblPageCount1.Text = "每页 "+PageSize .ToString ()+" 条，共 "+PageCount.ToString()+" 页";             
                cmbPagecount.Items.Clear();
                for (int i = 1; i <= PageCount; i++)
                    cmbPagecount.Items.Add(i.ToString());
               
            }
            else
            {
                this.PageCount = 0;
            }
        }

        /**/
        /// <summary>
        /// 翻页控件数据绑定的方法 关键是这步，都是调用这里
        /// </summary>
        public void Bind()
        {
            GetPageCount();
            if (this.EventPaging != null)
            {
                this.NMax = this.EventPaging(new EventPagingArg(this.PageCurrent));
            }

            if (this.PageCurrent > this.PageCount)
            {
                this.PageCurrent = this.PageCount;
            }
            if (this.PageCount == 1)
            {
                this.PageCurrent = 1;
            }          
            lblRecordCount.Text = "共有 " + NMax.ToString() + " 条记录";         

            btnPrev.Enabled = true;
            btnFirst.Enabled = true;
            btnLast.Enabled = true;
            btnNext.Enabled = true;

            if (this.PageCurrent == 1)
            {
                this.btnPrev.Enabled = false;
                this.btnFirst.Enabled = false;
            }

            if (this.PageCurrent == this.PageCount)
            {
                this.btnLast.Enabled = false;
                this.btnNext.Enabled = false;
            }

            if (this.NMax == 0)
            {
                btnNext.Enabled = false;
                btnLast.Enabled = false;
                btnFirst.Enabled = false;
                btnPrev.Enabled = false;
            }          
          
            cmbPagecount.SelectedIndexChanged -= new EventHandler(btnGo_Click);
            cmbPagecount.Text = PageCurrent.ToString();
            cmbPagecount.SelectedIndexChanged += new EventHandler(btnGo_Click);

         

        }
        /// <summary>
        /// 首页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnFirst_Click(object sender, EventArgs e)
        {
            PageCurrent = 1;
            this.Bind();
        }
        //上一页
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPrev_Click(object sender, EventArgs e)
        {
            PageCurrent -= 1;
            if (PageCurrent <= 0)
            {
                PageCurrent = 1;
            }
            this.Bind();
        }
        /// <summary>
        /// 下一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnNext_Click(object sender, EventArgs e)
        {
            this.PageCurrent += 1;
            if (PageCurrent > PageCount)
            {
                PageCurrent = PageCount;
            }
            this.Bind();
        }
        /// <summary>
        /// 最后页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLast_Click(object sender, EventArgs e)
        {
            PageCurrent = PageCount;
            this.Bind();
        }
        /// <summary>
        /// 转到新页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void btnGo_Click(object sender, EventArgs e)
        {
            if (Int32.TryParse(cmbPagecount.SelectedItem.ToString(), out _pageCurrent))
            {
                this.Bind();
            }
        }

    }
    /**/
    /// <summary>
    /// 自定义事件数据基类
    /// </summary>
    public class EventPagingArg : EventArgs
    {
        public int _intPageIndex;
        public EventPagingArg(int PageIndex)
        {
            _intPageIndex = PageIndex;
        }
    }
}

 

调用：

 private void FormBillNo_Load(object sender, EventArgs e)
        {
            dgvAll.AutoGenerateColumns = false;         
            pager1.PageCurrent = 1;
            LoadGrid();          
            pager1.Bind();
            pager1.EventPaging += new EventPagingHandler(pager1_EventPaging);
        }

  private int LoadGrid()
        {
                        
            string offset = (pager1.PageSize * (pager1.PageCurrent - 1) + 1).ToString();

            DataTable dt = CommonModel.Dao.BasicUtil.GetDataTableByPage("select * from (" + sql.ToString() + ") order by CREATEDATE desc", "CREATEDATE", pager1.PageSize.ToString(), offset);
            dgvAll.DataSource = dt;
            int countRecord = Convert.ToInt32(CommonModel.Dao.BasicUtil.ExecuteScalar("select count(*) from (" + sql.ToString() + ") order by CREATEDATE desc"));
            pager1.NMax = countRecord; //总共有多少条记录
            return countRecord;            
           
        }
        public int pager1_EventPaging(EventPagingArg e)
        {
             return LoadGrid();            
        }