我下面用linq去过滤数据报 转换格式错误


DataTable 数据如上图。。我下面用linq去过滤数据报 转换格式错误。。请教大家。。

 List<int> callTypes = new List<int> { 2, 3 };
            var  query = from data in ds.Tables[0].AsEnumerable()
                         where callTypes.Contains(data.Field<int>("CallType"))
                         group data by new { t1 = data.Field<int>("Ent_ID"), t2 = data.Field<string>("SDate") } into m
                         select new
                         {
                             
                             Ent_ID = m.Key.t1,
                             SDate = m.Key.t2,
                             CallAll = m.Select(x => x.Field<string>("CallCode")).Distinct().Count()
                         };
        foreach (var item in query)  //这里就报错了。。。
            {
                WriteSysLog(item.Ent_ID + "..." + item.SDate + "..." + item.CallAll);
            }

 var query_Trs_Suc = from data in ds.Tables[0].AsEnumerable()
                                let ToLen = data.Field<int>("TotalLen")
                                where data.Field<int>("CallType") == 2 && data.Field<string>("Called").Length > 5
                                && ToLen>0
                         group data by new { t1 = data.Field<int>("Ent_ID"), t2 = data.Field<string>("SDate") } into m
                         select new
                         {

                             Ent_ID = m.Key.t1,
                             SDate = m.Key.t2,
                             CallIn_TRS_Suc = m.Select(x => x.Field<string>("CallCode")).Distinct().Count()
                         };
            foreach (var item_trs_suc in query_Trs_Suc)
            {
                WriteSysLog(item_trs_suc.Ent_ID + "..." + item_trs_suc.SDate + "..." + item_trs_suc.CallIn_TRS_Suc);
            }

[解决办法]
var query = from data in ds.Tables[0].AsEnumerable()
where callTypes.Contains(data.Field<int>("CallType"))
group data by new { t1 = data.Field<int?>("Ent_ID"), t2 = data.Field<string>("SDate") } into m
select new
{

Ent_ID = m.Key.t1.HasValue?m.Key.t1.Value:0,
SDate = m.Key.t2,
CallAll = m.Select(x => x.Field<string>("CallCode")).Distinct().Count()
};