|
板凳
楼主 |
发表于 2013-6-27 11:50:19
|
只看该作者
本帖最后由 在路上。。。 于 2013-6-27 11:53 编辑
版本是3.2.3.0
代码:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
loaddata();
}
}
protected void loaddata()
{
// 1.设置总项数(特别注意:数据库分页一定要设置总记录数RecordCount)
Grid1.RecordCount = GetTotalCount();
// 2.获取当前分页数据
DataTable table = GetPagedDataTable();
// 3.绑定到Grid
Grid1.DataSource = table;
Grid1.DataBind();
}
protected void Grid1_Sort(object sender, FineUI.GridSortEventArgs e)
{
Grid1.SortDirection = e.SortDirection;
Grid1.SortColumnIndex = e.ColumnIndex;
loaddata();
}
protected void Grid1_PageIndexChange(object sender, FineUI.GridPageEventArgs e)
{
Grid1.PageIndex = e.NewPageIndex;
loaddata();
}
/// <summary>
/// 模拟返回总项数
/// </summary>
/// <returns></returns>
private int GetTotalCount()
{
return SqlHelper.Query("select * from t_qyxx order by id").Tables[0].Rows.Count;
}
/// <summary>
/// 模拟数据库分页
/// </summary>
/// <returns></returns>
private DataTable GetPagedDataTable()
{
int pageIndex = Grid1.PageIndex;
int pageSize = Grid1.PageSize;
//string sortField = Grid1.SortColumn; string sortField = Grid1.SortField;
string sortDirection = Grid1.SortDirection;
DataTable table2 = SqlHelper.Query("select * from t_qyxx order by id").Tables[0];
DataView view2 = table2.DefaultView;
view2.Sort = String.Format("{0} {1}", sortField, sortDirection);
DataTable table = view2.ToTable();
DataTable paged = table.Clone();
int rowbegin = pageIndex * pageSize;
int rowend = (pageIndex + 1) * pageSize;
if (rowend > table.Rows.Count)
{
rowend = table.Rows.Count;
}
for (int i = rowbegin; i < rowend; i++)
{
paged.ImportRow(table.Rows);
}
return paged;
}
} |
|