private PagedDataTableResult SelectPage(string qrySql, string statSql, int pageSize, int pageIndex, params object[] parameters)
{
var index = pageIndex;
var ds = SelectPaged(qrySql, statSql, pageSize, index, parameters);
if (ds == null || ds.Tables.Count == 0)
{
return(null);
}
//Tables[0] 无数据时判断
var rowCount = 0;
if (ds.Tables[0].Rows.Count > 0)
{
rowCount = ds.Tables[0].Rows[0][0].ConvertTo(0);
}
var pageCount = Math.Ceiling(1M * rowCount / pageSize).ConvertTo(0);
var pagedResult = new PagedDataTableResult(pageSize, pageIndex)
{
PageIndex = index,
PageCount = pageCount,
RowCount = rowCount,
Rows = ds.Tables[1]
};
if (statSql.HasValue())
{
pagedResult.Stat = ds.Tables[2].Rows[0];
}
return(pagedResult);
}
public void SelectPage <T>(string sql, Global.Db.PagedResult <T> pagedResult)
{
var pagedDataTableResult = new PagedDataTableResult(pagedResult.PageSize, pagedResult.PageIndex);
SelectPage(sql, pagedDataTableResult);
if (pagedDataTableResult.Rows == null)
{
return;
}
pagedDataTableResult.ListResult(pagedResult);
}
public void SelectPage(string sql, PagedDataTableResult pagedResult)
{
var pageIndex = pagedResult.PageIndex;
int pageCount;
int rowCount;
var dt = SelectPage(sql, pagedResult.PageSize, ref pageIndex, out pageCount, out rowCount);
if (dt == null)
{
return;
}
pagedResult.PageIndex = pageIndex;
pagedResult.PageCount = pageCount;
pagedResult.RowCount = rowCount;
pagedResult.Rows = dt;
}
