8,497
社区成员
发帖
与我相关
我的任务
分享
var dtDeviceDataSum = (from a in dtDeviceDataSameSum
join b in dtDeviceDataDiffSum
on (Convert.ToDateTime(a.currtime).Day)
equals (Convert.ToDateTime(b.currtime).Day)
into c
from o in c.DefaultIfEmpty()
select new
{
dateType = Convert.ToDateTime(a.currtime).Day,
currQty = System.DBNull.Value.Equals(a.currElectQty) ? 0 : a.currElectQty,
beforeQty = o.currElectQty.HasValue ? o.currElectQty : decimal .Zero
}).ToList();