一、分页现实效果:
二.功能实现
1.新建用户控件
2.在用户控件中拉如下图控件(并注册对应的事件)
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
{
public partial class UGridPage : UserControl
{
public delegate void JumpToPageIndex(int pageIndex, int rowsPerPage);
public event JumpToPageIndex PageJumpTo;
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; }
}
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);
txtRowsPerPage.Text = _rowsPerPage.ToString();
setCurrentPage(1);
}
}
private int _rowsPerPage = 10;
/// <summary>
/// 每页行数
/// </summary>
public int RowsPerPage
{
get { return _rowsPerPage; }
set
{
if (value > 0)
{
_rowsPerPage = value;
}
}
}
private int _currentPage;
/// <summary>
/// 当前第几页
/// </summary>
public int CurrentPage
{
get { return _currentPage; }
}
public UGridPage()
{
InitializeComponent();
}
private void UGridPage_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 += Txt_GotFocus;
txtCurrentPage.LostFocus += Txt_LostFocus;
txtRowsPerPage.GotFocus += Txt_GotFocus;
txtRowsPerPage.LostFocus += Txt_LostFocus;
}
private void Txt_LostFocus(object sender, EventArgs e)
{
_jumpToPageFocused = false;
}
private void Txt_GotFocus(object sender, EventArgs e)
{
_jumpToPageFocused = true;
}
/// <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);
}
}
/// <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);
}
}
}
private void txtRowsPerPage_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
int rowsPerPage;
if (!int.TryParse(txtRowsPerPage.Text, out rowsPerPage))
{
txtRowsPerPage.Text = _rowsPerPage.ToString();
return;
}
if (rowsPerPage <= 0)
{
txtRowsPerPage.Text = _rowsPerPage.ToString();
return;
}
_rowsPerPage = rowsPerPage;
SetRowCount(_rowCount);
if (PageJumpTo != null)
{
PageJumpTo(_currentPage, _rowsPerPage);
}
}
}
}
}
4.把UGridePage控件与dataGrid放到同一个面板容器上(dataGrid的Anchor设置成Top, Bottom, Left, Right,UGridePage属性Dock设置成Bottom)
5.设置UGridPage的PageJumpTo事件
private void uGridPage1_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,decode(a.nv_operatetype,'0','发料','3','不良处理','T','退料','返工') as 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,NVL(a.nv_fromvoucherid1,'') As NV_FROMVOUCHERID1,
'录入单' as operate1,'供应商信息' as operate2
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
Where a.ch_flag = '05' and a.org_rrn={1} {0}", conditionStr,ConnectionInfo.OrgRrn);
int rowscount = EntityPublic.Instance.GetRowsCountFromSql(sqlQuery);
uGridPage1.SetRowCount(rowscount);
if (rowscount>0)
{
var resultlist = EntityPublic.Instance.GetPageRowsFromSql<GT_DISPATCHINGMAIN>(sqlQuery, 1, uGridPage1.RowsPerPage, "DT_OPERATEDATE desc");
bsLot.DataSource = resultlist;
}
else
{
ExceptionMsgBox.This.ShowMessageBox(" 未能查找到相关数据!");
bsLot.Clear();
}
/// <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;
}