using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace WebInfoFormReport.Model
{
/// <summary>
/// DataTable分页
/// </summary>
/// 创建时间:2022-6-2 16:19:17。
public static class DataTablePageHelpter
{
/// <summary>
/// DataTable分页并取出指定页码的数据
/// </summary>
/// <param name="dtAll">DataTable</param>
/// <param name="pageNo">页码,注意:从1开始</param>
/// <param name="pageSize">每页条数</param>
/// <returns>指定页码的DataTable数据</returns>
public static DataTable GetOnePageTable(DataTable dtAll, int pageNo, int pageSize)
{
int totalCount = dtAll.Rows.Count;
int totalPage = GetTotalPage(totalCount, pageSize);
int currentPage = pageNo;
currentPage = currentPage > totalPage ? totalPage : currentPage;//如果PageNo过大,则较正PageNo=PageCount
currentPage = currentPage <= 0 ? 1 : currentPage;//如果PageNo<=0,则改为首页
//----克隆表结构到新表
var onePageTable = dtAll.Clone();
//----取出 页数据到新表
int rowBegin = (currentPage - 1) * pageSize;
int rowEnd = currentPage * pageSize;
rowEnd = (rowEnd > totalCount ? totalCount : rowEnd);
for (var i = rowBegin; i <= rowEnd - 1; i++)
{
var newRow = onePageTable.NewRow();
var oldRow = dtAll.Rows[i];
newRow.ItemArray = oldRow.ItemArray;
//foreach (DataColumn column in dtAll.Columns)
//{
// newRow[column.ColumnName] = oldRow[column.ColumnName];
//}
onePageTable.Rows.Add(newRow);
}
return onePageTable;
}
/// <summary>
/// 返回分页后的总页数
/// </summary>
/// <param name="totalCount">总记录条数</param>
/// <param name="pageSize">每页显示条数</param>
/// <returns>总页数</returns>
public static int GetTotalPage(int totalCount, int pageSize)
{
//var totalPage = (totalCount / pageSize) + (totalCount % pageSize > 0 ? 1 : 0);
int totalPage = (int)Math.Ceiling((decimal)totalCount / pageSize);
return totalPage;
}
}
}
02-24
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交