/// <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); }