/// <summary>
/// 得到分页数据，同时把绑定到DataGridView控件中。
/// </summary>
/// <param name="dataControl">显示分页数据的控件(一般为DataGridView)</param>
/// <param name="pageControl">分页控件名称</param>
/// <param name="tableName">表名</param>
/// <param name="pageDbType">数据库类型</param>
/// <param name="primaryKey">主键名</param>
/// <param name="orderField">排序字段</param>
/// <param name="whereConditional">Where条件</param>
/// <param name="queryFields">结果字段列表</param>
/// <param name="connstring">数据库连接字符串</param>
/// <returns></returns>
public int BindPageData(UcDataGridView dataControl, UcPageControl pageControl, string tableName, CurrentDbType pageDbType
, string primaryKey = "ID", string orderField = "ID", string whereConditional = "DELETEMARK = 0"
, string queryFields = "*", string connstring = "")
{
pageData = null;
pageDataTable = null;
pageData = new PageData();
pageDataTable = new DataTable();
pageData.TableName = tableName;
pageData.PrimaryKey = primaryKey;
pageData.OrderStr = orderField;
pageData.PageIndex = pageControl.PageCurrent;
pageData.PageSize = SystemInfo.PageSize; //指定分页大小(注：此句一定不能省略)
pageControl.PageSize = pageData.PageSize; //指定此页面的分页大小(注：此句一定不能省略)
pageData.QueryCondition = whereConditional;
pageData.QueryFieldName = queryFields;
pageData.PageDbType = pageDbType;
pageDataTable = pageData.QueryDataTable(!string.IsNullOrEmpty(connstring.Trim()) ? connstring : SystemInfo.RDIFrameworkDbConection);
pageControl.bindingSource.DataSource = pageDataTable;
pageControl.bindingNavigator.BindingSource = pageControl.bindingSource;
//((DataGridView)dataControl).DataSource = null;
//((DataGridView)dataControl).AutoGenerateColumns = false;
//((DataGridView)dataControl).DataSource = ((DataTable)pageControl.bindingSource.DataSource).DefaultView;
//this.AddCheckBoxColumn(((DataGridView)dataControl));
dataControl.DataSource = null;
dataControl.AutoGenerateColumns = false;
dataControl.DataSource = pageControl.bindingSource;
this.AddCheckBoxColumn(dataControl);
pageControl.PageCount = pageData.TotalCount;
return(pageData.TotalCount);
}
/// <summary>
/// 得到分页数据，同时把绑定到DataGridView控件中。
/// </summary>
/// <param name="dataControl">显示分页数据的控件(一般为DataGridView)</param>
/// <param name="pageControl">分页控件名称</param>
/// <param name="tableName">表名</param>
/// <param name="pageDbType">数据库类型</param>
/// <param name="connstring">数据库连接字符串</param>
/// <returns></returns>
public int BindPageData(UcDataGridView dataControl, UcPageControl pageControl, string tableName, CurrentDbType pageDbType, string connstring)
{
return(this.BindPageData(dataControl, pageControl, tableName, pageDbType, BusinessLogic.FieldId, BusinessLogic.FieldId, "DELETEMARK = 0", "*", connstring));
}
