/// <summary>
/// 将 DataTable 填充到 List 实体集（适用于存储过程的分页）
/// </summary>
/// <typeparam name="T">List 实体集</typeparam>
/// <param name="dt">DataTable 对象</param>
/// <param name="paging">Utility.Paging 分页属性</param>
/// <returns>返回 List 实体集</returns>
public static List <T> ToList <T>(DataTable dt, ref Utility.Paging paging)
{
int recordTotal = 0;
int recordStart = 0;
int recordEnd = 0;
if (dt != null && dt.Rows.Count > 0 && dt.Columns.Contains("RecordTotal"))
{
recordTotal = Convert.ToInt32(dt.Rows[0]["RecordTotal"]);
dt.Columns.Remove("RecordTotal");
if (dt.Columns.Contains("RecordStart"))
{
recordStart = Convert.ToInt32(dt.Rows[0]["RecordStart"]);
dt.Columns.Remove("RecordStart");
}
if (dt.Columns.Contains("RecordEnd"))
{
recordEnd = Convert.ToInt32(dt.Rows[0]["RecordEnd"]);
dt.Columns.Remove("RecordEnd");
}
}
paging.SetPaging(paging.PageIndex, paging.PageSize, recordTotal, recordStart, recordEnd);
return(AX.CSF.DBHelper.ToEntity.ToList <T>(dt));
}
/// <summary>
/// 逐条执行查询命令（适用于存储过程的分页）
/// </summary>
/// <param name="storProcName">存储过程名称</param>
/// <param name="cmdParms">参数集合</param>
/// <param name="paging">Utility.Paging 分页属性</param>
/// <returns>返回 DataTable</returns>
public DataTable DataTable(string storProcName, SqlParameter[] cmdParms, ref Utility.Paging paging)
{
DataTable dt = Sql.DataTable(storProcName, cmdParms);
int recordTotal = 0;
int recordStart = 0;
int recordEnd = 0;
if (dt != null && dt.Rows.Count > 0 && dt.Columns.Contains("RecordTotal"))
{
recordTotal = Convert.ToInt32(dt.Rows[0]["RecordTotal"]);
dt.Columns.Remove("RecordTotal");
if (dt.Columns.Contains("RecordStart"))
{
recordStart = Convert.ToInt32(dt.Rows[0]["RecordStart"]);
dt.Columns.Remove("RecordStart");
}
if (dt.Columns.Contains("RecordEnd"))
{
recordEnd = Convert.ToInt32(dt.Rows[0]["RecordEnd"]);
dt.Columns.Remove("RecordEnd");
}
}
paging.SetPaging(paging.PageIndex, paging.PageSize, recordTotal, recordStart, recordEnd);
return(dt);
}
