.NET DataTable扩展之快速处理DataTable映射到List数组

醉酒的李白、

已于 2022-07-20 15:36:45 修改

阅读量458

点赞数 1

分类专栏： .NET 文章标签： DataTable遍历数据对象映射

于 2022-07-06 14:58:43 首次发布

本文链接：https://blog.csdn.net/CSDN_wcy/article/details/125639628

版权

.NET 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

// C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.8\System.Data.DataSetExtensions.dll

我项目引用的是.NETFramework\v4.8下的一个扩展.dll

public List<CaseStatusModel> GetTECaseStatus()
{
    using (var db = new DBCommon())
    {
        var result = new List<CaseStatusModel>();
        string sql = @"with 
					t as(
						select count(ID) CaseCount,IsActive,[Period] from TE_T_TESummaryCase where 1=1 group by IsActive ,[Period]
					)
					select top 12 t.[Period]
					,sum(case t.IsActive when 1 then t.CaseCount else 0 end) as PendingCase
					,sum(case t.IsActive when 0 then t.CaseCount else 0 end) as ClosedCase
					from t
					group by t.[Period]
					order by t.[Period] desc";
        DataTable dt = db.ExecuteQuery(sql.ToString());
        if (dt != null && dt.Rows.Count > 0)
        {
            result = dt.AsEnumerable().Select(t => new CaseStatusModel()
            {
                //可空选项
                Month = t.Field<DateTime?>("Period")?.ToString("yyyy-MM"),
                PendingCase = t.Field<int>("PendingCase"),
                ClosedCase = t.Field<int>("ClosedCase")
            }).ToList();
        }
        return result;
    }
}

原表长这样