linq中的sum函数有一个重载:计算可以为 null 的 Double 值序列之和。wo = from p in work
where p.ProjectID == "XXX"
join p2 in work on p.WorkID equals p2.WorkID into p3
from p4 in p3
where p4.ClientID == "XXX"
group p4 by p.UserObjectID into g
select new { g.Key, TotalTime = g.Sum(p => p.UseOfTime)};我这样写最后的TotalTime去掉了结果是NULL的,我需要保留
where p.ProjectID == "XXX"
join p2 in work on p.WorkID equals p2.WorkID into p3
from p4 in p3
where p4.ClientID == "XXX"
group p4 by p.UserObjectID into g
select new { g.Key, TotalTime = g.Sum(p => p.UseOfTime)};我这样写最后的TotalTime去掉了结果是NULL的,我需要保留
var wo = from p in work select new { Key = "", TotalTime = 0.0 };