DevExpress中实现GridControl的分页功能

佚名 7年前 (2019-05-05) 随笔 1330人围观抢沙发百度已收录

DevExpress中如何实现GridControl的分页功能

简介:DevExpress中如何实现GridControl的分页功能,

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

主要是利用DataNavigator和GridControl组合,自定义事件实现分页功能

接下来,我们就去实现分页功能,先看下效果图:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

整个分页操作,基本分三步:

一:界面层

二:代码层

三:数据库

四:调用

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

一:界面层,如图:

说明:放入一个GridControl控件(gridLogList)和DataNavigator控件(nvgtDataPager),给GridControl绑定好列,

设置DataNavigator控件属性Dock=Bottom;TextLocation=Center;TextStringFormat=第 {0}页 ,共 {1};

ShowToolTips=true;将下图中圈中的按钮属性visible=False;

如图:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

二:代码层

1.定义变量

//页行数
public int pagesize = 20;
//当前页
public int pageIndex = 1;
//总页数
public int pageCount;

2.定义方法

/// <summary>
/// 绑定分页控件和GridControl数据
/// </summary>
/// <author>PengZhen</author>
/// <time>2013-11-5 14:22:22</time>
/// <param name="strWhere">查询条件</param>
public void BindPageGridList(string strWhere)
{
SystemOperateLog objSOL = new BLL.SystemOperateLog();
nvgtDataPager.Buttons.CustomButtons[ 0].Enabled = true;
nvgtDataPager.Buttons.CustomButtons[ 1].Enabled = true;
nvgtDataPager.Buttons.CustomButtons[ 2].Enabled = true;
nvgtDataPager.Buttons.CustomButtons[ 3].Enabled = true;
//记录获取开始数
int startIndex = (pageIndex - 1) * pagesize + 1;
//结束数
int endIndex = pageIndex * pagesize;
//总行数
int row = objSOL.GetRecordCount(strWhere);
//获取总页数
if (row % pagesize > 0)
{
pageCount = row / pagesize + 1;
}
else
{
pageCount = row / pagesize;
}
if (pageIndex == 1)
{
nvgtDataPager.Buttons.CustomButtons[ 0].Enabled = false;
nvgtDataPager.Buttons.CustomButtons[ 1].Enabled = false; ;
}
//最后页时获取真实记录数
if (pageCount == pageIndex)
{
endIndex = row;
nvgtDataPager.Buttons.CustomButtons[ 2].Enabled = false;
nvgtDataPager.Buttons.CustomButtons[ 3].Enabled = false;
}
//分页获取数据列表
DataTable dt = objSOL.GetListByPage(strWhere, "", startIndex, endIndex).Tables[ 0];
gridLogList.DataSource = dt;
nvgtDataPager.DataSource = dt;
nvgtDataPager.TextStringFormat = string.Format( "第 {0}页, 共 {1}页", pageIndex, pageCount);
}

3.定义事件

/// <summary>
/// 按钮点击事件
/// </summary>
/// <author>PengZhen</author>
/// <time>2013-11-5 14:24:25</time>
/// <param name="sender"></param>
/// <param name="e"></param>
private void nvgtDataPager_ButtonClick(object sender, NavigatorButtonClickEventArgs e)
{
ShowEvent( "ButtonClick", e.Button);
}
/// <summary>
/// 分页事件处理
/// </summary>
/// <param name="eventString">事件名称</param>
/// <param name="button">按钮控件</param>
/// <author>PengZhen</author>
/// <time>2013-11-5 14:25:59</time>
void ShowEvent(string eventString, NavigatorButtonBase button)
{
//string type = button.ButtonType.ToString();
NavigatorCustomButton btn = (NavigatorCustomButton)button;
string type = btn.Tag.ToString();
if (type == "首页")
{
pageIndex = 1;
}
if (type== "下一页")
{
pageIndex++;
}
if (type== "末页")
{
pageIndex = pageCount;
}
if (type == "上一页")
{
pageIndex--;
}
//绑定分页控件和GridControl数据
BindPageGridList(strWhere);
}

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

三:数据库

/// <summary>
/// 获取记录总数
/// </summary>
public int GetRecordCount(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append( "select count(1) FROM TL_SYSTEM_OPERATE_LOGS ");
if (strWhere.Trim() != "")
{
strSql.Append( " where " + strWhere);
}
object obj = _DbHelperOra.GetSingle(strSql.ToString());
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append( "SELECT * FROM ( ");
strSql.Append( " SELECT ROW_NUMBER() OVER (");
if (! string.IsNullOrEmpty( orderby.Trim()))
{
strSql.Append( "order by T." + orderby);
}
else
{
strSql.Append( "order by T.ID desc");
}
strSql.Append( ")AS Rowssss, T.* from TL_SYSTEM_OPERATE_LOGS T ");
if (! string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append( " WHERE " + strWhere);
}
strSql.Append( " ) TT");
strSql.AppendFormat( " WHERE TT.Rowssss between {0} and {1}", startIndex, endIndex);
return _DbHelperOra.Query(strSql.ToString());
}

说明:数据库的操作只作为借鉴,请根据自己的表做相应的修改

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

四:调用

如文章开头第一张效果图所述,当我就行查询操作时,也就是调用分页和绑定数据,需要做的操作,如下:

//查询条件
private static string strWhere = string.Empty;
/// <summary>
/// 查询
/// </summary>
/// <author>PengZhen</author>
/// <time>2013-10-30 11:08:03</time>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btSelect_Click(object sender, EventArgs e)
{
//获取查询条件
strWhere = GetSqlWhere();
BindPageGridList(strWhere);
}
/// <summary>
/// 获取查询条件
/// </summary>
/// <author>PengZhen</author>
/// <time>2013-11-5 15:25:00</time>
/// <returns>返回查询条件</returns>
private string GetSqlWhere()
{
//查询条件
string strReturnWhere = string.Empty;
//用户编号
string strUserId = string.Empty;
if (! string.IsNullOrEmpty(UserManage.UserID))
{
strUserId = "12"; // UserManage.UserID;
}
//分系统编码
string strSubSystemCode = string.Empty;
if (cbbSubSystemCode.SelectedItem != null)
{
strSubSystemCode = (cbbSubSystemCode.SelectedItem as ComboBoxData).Value;
}
//功能模块
string strFunctionModule = string.Empty;
if (cbbFunctionModule.SelectedItem != null)
{
strFunctionModule = (cbbFunctionModule.SelectedItem as ComboBoxData).Value;
}
//数据分类
string strDataType = string.Empty;
if (tcbDataType.SelectedNode != null)
{
strDataType = tcbDataType.SelectedNode.Name;
}
//操作类型
string strOperatedType = string.Empty;
if (cbbOperatedType.SelectedItem != null)
{
strOperatedType = (cbbOperatedType.SelectedItem as ComboBoxData).Value;
}
//开始时间
string strStartTime = string.Empty;
if (! string.IsNullOrEmpty(dateStartTime.Text))
{
strStartTime = dateStartTime.Text;
}
//结束时间
string strEndTime = string.Empty;
if (! string.IsNullOrEmpty(dateEndTime.Text))
{
strEndTime = dateEndTime.Text;
}
//用户ID
if (! string.IsNullOrEmpty(strUserId))
{
strReturnWhere += "USER_ID='" + strUserId + "' and";
}
//分系统代码
if (! string.IsNullOrEmpty(strSubSystemCode))
{
strReturnWhere += "SYSTEM_CODE='" + strSubSystemCode + "' and";
}
//模块编号
if (! string.IsNullOrEmpty(strFunctionModule))
{
strReturnWhere += "MODULE_ID='" + strFunctionModule + "' and";
}
//数据分类代码
if (! string.IsNullOrEmpty(strDataType))
{
strReturnWhere += "DATA_CATAGORY_CODE='" + strDataType + "' and";
}
//操作类型
if (! string.IsNullOrEmpty(strOperatedType))
{
strReturnWhere += "OPERATE_TYPE='" + strOperatedType + "' and";
}
//操作时间
if (! string.IsNullOrEmpty(strStartTime) && ! string.IsNullOrEmpty(strEndTime))
{
strReturnWhere += "OPERATE_DATE between '" + strStartTime + "' and '" + strEndTime + "'";
}
if (! string.IsNullOrEmpty(strReturnWhere))
{
strReturnWhere = strReturnWhere.Remove(strReturnWhere.LastIndexOf( "and"));
}
return strReturnWhere;
}

说明:此处只需要指定你自定义的条件就可以了,以上代码展示的只是文章图一的实现

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

好了,到这,我们的所有操作就完成了,来看下我们运行的分页效果图: