这篇文章主要介绍了c#构建分页应用的方法,结合实例形式分析了c#创建分页功能的具体步骤与相关实现技巧,需要的朋友可以参考下
本文实例讲述了C#构建分页应用的方法。分享给大家供大家参考,具体如下:
1、SQL语句
WITH [temptableforStockIC] AS ( SELECT *,ROW_NUMBER() OVER (ORDER BY CreateTime DESC) AS RowNumber FROM [StockIC] WHERE 1=1 AND Model = 'FTY765OP' ) SELECT * FROM [temptableforStockIC] WHERE RowNumber BETWEEN 1 AND 10
2、后台方法
/// <summary>
/// 表名
/// </summary>
private const string _tableNane = "StockIC";
/// <summary>
/// 获取库存列表
/// </summary>
public List<stockicresult> GetStockIcList(StockIcParam param)
{
List<stockicresult> list = new List<stockicresult>();
string sql = "WITH [temptablefor{0}] AS";
sql += " (SELECT *,ROW_NUMBER() OVER (ORDER BY {1}) AS RowNumber FROM [{0}] WHERE 1=1 {2})";
sql += " SELECT * FROM [temptablefor{0}] WHERE RowNumber BETWEEN {3} AND {4}";
StringBuilder sqlCondition = new StringBuilder();
List<sqlparameter> sqlParams = new List<sqlparameter>();
//型号
if (!String.IsNullOrEmpty(param.Model))
{
sqlCondition.AppendFormat(" AND Model LIKE '%{0}%'", param.Model);
}
//开始时间
if (param.BeginTime.HasValue)
{
sqlCondition.Append(" AND CreateTime >= @BeginTime");
sqlParams.Add(new SqlParameter("@BeginTime", param.BeginTime.Value));
}
//结束时间
if (param.EndTime.HasValue)
{
sqlCondition.Append(" AND CreateTime <p>注意:DBHelper.GetReader()方法、TranToList()方法等请自己完善。</p>
<p>一些计算方法</p>
<pre class="brush:csharp;">//分页
Int64 startNumber = (param.PageIndex - 1) * param.PageSize + 1;
Int64 endNumber = startNumber + param.PageSize - 1;
//总页数 = (数据总数 + 分页大小 -1) / 分页大小
TotalPage = (TotalCount + PageSize - 1) / PageSize;











