winform dateGrid实现分页

一.现实完成效果如下图：

二.功能实现
1.新建用户控件

2.在用户控件中拉如下图控件（并注册对应的事件）

3.用户控件UPage代码如下：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Glory.Common.UI.Controls
{
    public partial class UPage : UserControl
    {
        public delegate void JumpToPageIndex(int pageIndex, int rowsPerPage);
        public event JumpToPageIndex PageJumpTo;
        public UPage()
        {
            InitializeComponent();
        }
        private bool _jumpToPageFocused;
        /// <summary>
        /// 跳转第几页有没有获得焦点
        /// </summary>
        public bool JumpToPageFocused
        {
            get { return _jumpToPageFocused; }
        }
        private int _pageCount;
        /// <summary>
        /// 总页数
        /// </summary>
        public int PageCount
        {
            get { return _pageCount; }
        }
        private int _rowCount;
        /// <summary>
        /// 总行数
        /// </summary>
        public int RowCount
        {
            get { return _rowCount; }
        }
        private int _rowsPerPage;
        /// <summary>
        /// 每页行数
        /// </summary>
        public int RowsPerPage
        {
            get { return _rowsPerPage; }
            set
            {
                if (value <= 0)
                {
                    _rowsPerPage = 10;
                }
                else
                {
                    _rowsPerPage = value;
                }
            }
        }
        private int _currentPage;
        /// <summary>
        /// 当前第几页
        /// </summary>
        public int CurrentPage
        {
            get { return _currentPage; }
        }
        /// <summary>
        /// 前面还有没有页
        /// </summary>
        /// <param name="havePage"></param>
        private void setHavePrePage(bool havePage)
        {
            llPgHm.Enabled = havePage;
            llPgUp.Enabled = havePage;
        }
        /// <summary>
        /// 后面还有没有页
        /// </summary>
        /// <param name="havePage"></param>
        private void setHavePostPage(bool havePage)
        {
            llPgEd.Enabled = havePage;
            llPgDn.Enabled = havePage;
        }
        private void setCurrentPage(int currentPage)
        {
            _currentPage = currentPage;
            txtCurrentPage.Text = _currentPage.ToString();
            if (_currentPage == 1)
            {
                setHavePrePage(false);
            }
            else
            {
                setHavePrePage(true);
            }
            if (_currentPage >= _pageCount)
            {
                setHavePostPage(false);
            }
            else
            {
                setHavePostPage(true);
            }
        }
        public void SetRowCount(int rowCount)
        {
            if (_rowCount < 0)
            {
                _rowCount = 0;
                lbDesc.Text = "";
            }
            else
            {
                _rowCount = rowCount;
                _pageCount = (int)Math.Ceiling((double)_rowCount / _rowsPerPage);
                lbDesc.Text = string.Format("共{0}页,共{1}条数据", _pageCount, _rowCount);
                setCurrentPage(1);
            }
        }

        private void UPage_Load(object sender, EventArgs e)
        {
            llPgHm.Text = "Page Home";
            llPgUp.Text = "Page Up";
            llPgDn.Text = "Page Down";
            llPgEd.Text = "Page End";

            lbDesc.Text = "";

            txtCurrentPage.GotFocus += TxtCurrentPage_GotFocus;
            txtCurrentPage.LostFocus += TxtCurrentPage_LostFocus;
        }
        private void TxtCurrentPage_LostFocus(object sender, EventArgs e)
        {
            _jumpToPageFocused = false;
        }

        private void TxtCurrentPage_GotFocus(object sender, EventArgs e)
        {
            _jumpToPageFocused = true;
        }
        /// <summary>
        /// 第一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void llPgHm_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            setCurrentPage(1);
            if (PageJumpTo != null)
            {
                PageJumpTo(_currentPage, _rowsPerPage);
            }
        }
        /// <summary>
        /// 上一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void llPgUp_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            setCurrentPage(_currentPage - 1);
            if (PageJumpTo != null)
            {
                PageJumpTo(_currentPage, _rowsPerPage);
            }
        }
        /// <summary>
        /// 下一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void llPgDn_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            setCurrentPage(_currentPage + 1);
            if (PageJumpTo != null)
            {
                PageJumpTo(_currentPage, _rowsPerPage);
            }
        }
        /// <summary>
        /// 最后页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void llPgEd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            setCurrentPage(_pageCount);
            if (PageJumpTo != null)
            {
                PageJumpTo(_currentPage, _rowsPerPage);
            }
        }
        /// <summary>
        /// 页跳转
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtCurrentPage_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                int jumpPageIndex;
                if (!int.TryParse(txtCurrentPage.Text, out jumpPageIndex))
                {
                    txtCurrentPage.Text = _currentPage.ToString();
                    return;
                }
                if (jumpPageIndex <= 0)
                {
                    txtCurrentPage.Text = _currentPage.ToString();
                    return;
                }
                if (jumpPageIndex > _pageCount)
                {
                    txtCurrentPage.Text = _currentPage.ToString();
                    return;
                }
                setCurrentPage(jumpPageIndex);
                if (PageJumpTo != null)
                {
                    PageJumpTo(_currentPage, _rowsPerPage);
                }
            }
        }
    }
}

4.把UPage控件与dataGrid放到同一个面板上（dataGrid的Anchor设置成Top, Bottom, Left, Right，UPage属性Anchor设置成Bottom）

5.点击UPage控件的属性，设置每页显示的条数

6.UPage控件增加PageJumpTo事件

private void uPage1_PageJumpTo(int pageIndex, int rowsPerPage)
{
    var resultlist = EntityPublic.Instance.GetPageRowsFromSql<GT_DISPATCHINGMAIN>(sqlQuery, pageIndex, rowsPerPage, "DT_OPERATEDATE desc");
    if (resultlist != null && resultlist.Count > 0)
    {
        bsLot.DataSource = resultlist;
    }
    else
    {
        bsLot.DataSource = new List<GT_DISPATCHINGMAIN>();
    }
} 
        /// <summary>
        /// Grid分页功能，得到Sql执行第几页的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="sql">Sql</param>
        /// <param name="pageIndex">第几页</param>
        /// <param name="rowsPerPage">每页行数</param>
        /// <param name="orderByColum">排序列</param>
        /// <returns></returns>
        public List<T> GetPageRowsFromSql<T>(string sql, int pageIndex, int rowsPerPage, string orderByColum) where T : new()
        {
            Splasher.Show();
            string sqlQuery = string.Format(@"select * from (
select t.*, row_number() over(order by {3}) rownumber from (
{0}
) t
) where rownumber>=(({1}-1)*{2})+1 and rownumber<={1}*{2}", sql, pageIndex, rowsPerPage, orderByColum);
            var resultlist = this.GetEntityForSQL<T>(sqlQuery);
            Splasher.Close();
            return resultlist;
        }

7.数据查询

    sqlQuery = string.Format(@"Select a.nv_voucherid,a.nv_operatorname,a.nv_operatetype,a.dt_operatedate,a.nv_fromvoucherid,a.vc_batno,
								p.nv_processname,ap.nv_processname As nv_aprocessname,a.vc_invcode,a.NV_OPERATOR,
								a.dc_tqty,a.dc_sqty,a.dc_fqty,a.dc_wqty,a.vc_minvcode,i.nv_invname,a.vc_workplaceid,a.vc_workgroupid,nvl(a.nv_fromvoucherid1,'') As nv_fromvoucherid1,vc_traceid,bd.nv_badinfo,b.dc_qty
								From gt_dispatchingmain a
								Join gt_inventory i on a.vc_invcode = i.vc_invcode and a.org_rrn=i.org_rrn
								Left Join gt_process p on a.vc_processid = p.vc_processid and a.org_rrn=p.org_rrn
								Left Join gt_process ap on a.vc_aprocessid = ap.vc_processid and a.org_rrn=ap.org_rrn
								Left Join gt_dispatchingbaddetail b on a.nv_voucherid=b.nv_voucherid And b.dc_qty!=0  and a.org_rrn=b.org_rrn
								Left Join gt_badinfo bd on b.vc_badid=bd.vc_badid
								--Left Join gt_dispatchingplan dpp On a.nv_voucherid = dpp.nv_voucherid 
							Where a.ch_flag = '05' and a.org_rrn={1} {0}", conditionStr,ConnectionInfo.OrgRrn);
        int rowscount = EntityPublic.Instance.GetRowsCountFromSql(sqlQuery);
        uPage1.SetRowCount(rowscount);
        if (rowscount > 0)
        {
            var resultlist = EntityPublic.Instance.GetPageRowsFromSql<GT_DISPATCHINGMAIN>(sqlQuery, 1, uPage1.RowsPerPage, "DT_OPERATEDATE desc");
            bsLot.DataSource = resultlist;
        }
        else
        {
            ExceptionMsgBox.This.ShowMessageBox(" 未能查找到相关数据！");
            bsLot.Clear();
        }

      /// <summary>
        /// Grid分页功能，得到Sql执行结果的行数
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public int GetRowsCountFromSql(string sql)
        {
            Splasher.Show();
            string sqlCnt = string.Format(@"select count(1) value from (
{0}
)", sql);
            List<CheckType> rowsList = EntityPublic.Instance.GetEntityForSQL<CheckType>(sqlCnt);
            if (rowsList == null || rowsList.Count < 0)
            {
                Splasher.Close();
                return 0;
            }
            CheckType rows = rowsList.FirstOrDefault();
            int resultRows = 0;
            int.TryParse(rows.VALUE, out resultRows);
            Splasher.Close();
            return resultRows;
        }