HDC调试需求开发（15万预算）,能者速来！>>>
sql语句:
select count(rd.package_id) packageCount,
sum(e.total_activity) as totalActivity, sum(m.diamerter / 2 * m.diamerter / 2 * m.height) as totalVolumn from RWIS_NUCLEAR_RUB_RECEPTION_D RD inner join RWIS_BASIC_MATERIAL m on b.material_id = m.material_id left join RWIS_DISPSITE_EVAL e
on c.detail_id = e.check_detail_id
下面是我自己写的linq,没运行出来
var nuclearRubReceptionDs = _currentUnitOfWork.NuclearRubReceptionDs.AsQueryable();
var materialType = _currentUnitOfWork.MaterialTypes.AsQueryable();
var dispsiteEval = _currentUnitOfWork.DispsiteEvals.AsQueryable();


var query = from rd in nuclearRubReceptionDs
join m in materialType on b.MaterialId equals m.MaterialId into mEmpt
from m in mEmpt.DefaultIfEmpty()
join e in dispsiteEval on c.DetailId equals e.CheckDetailId into eEmpt
from e in eEmpt.DefaultIfEmpty()
select new WasteStatisticView
{
Code = "",
TotalActivity = eEmpt.Sum(t => t.TotalActivity),
TotalVolume=mEmpt.Sum(t=>t.Diamerter/2*t.Diamerter/2*t.Height),
packageCount = rd.PackageId.Count()
};
return query;