public async Task <PartialViewResult> ListByProjectId(Guid Id)
{
var re01 = _mainRepository.EntityItems;
var re02 = _staffRepository.EntityItems;
var linqVar = await(from p in re01
join q in re02
on p.StaffId equals q.Id
where p.ProjectId == Id
select new ProjectStaffProjectViewModel
{
Id = p.Id,
StaffName = q.Name,
Labor = (Labor)p.Labor,
Ratio = p.Ratio,
StandardValue = (p.Ratio) * _projectInspectionTypeRepository.GetStdValueByProjectId(p.ProjectId),
CalcValue = (p.Ratio) * _projectInspectionTypeRepository.GetCalcValueByProjectId(p.ProjectId),
}).ToAsyncEnumerable().ToList();
var re = await _projectRepository.QueryByIdAsync(Id);
var model = new ProjectStaffProjectListViewModel
{
ProjectId = Id,
ProjectName = re.Name,
ProjectStaffProjectViewModels = linqVar,
};
return(PartialView("ProjectStaffProjectListPartial", model));
}
public async Task <PartialViewResult> BriefList(Guid ContractId)
{
var re01 = _mainRepository.EntityItems;
var re02 = _bridgeRepository.EntityItems;
//var linqVar = await re01.Join(
// re02,
// p => p.ContractId,
// q => (Guid?)(q.Id),
// (p, q) => new ProjectBriefViewModel
// {
// Id = p.Id,
// Name = p.Name,
// BridgeName = q.Name
// }).ToAsyncEnumerable().ToList();
var linqVar = await(from p in re01
join q in re02
on p.BridgeId equals q.Id
where p.ContractId == ContractId
select new ProjectBriefViewModel
{
Id = p.Id,
Name = p.Name,
BridgeName = q.Name,
InspectionType = _projectInspectionTypeRepository.GetInspTypeNameByProjectId(p.Id),
StandardValue = _projectInspectionTypeRepository.GetStdValueByProjectId(p.Id),
CalcValue = _projectInspectionTypeRepository.GetCalcValueByProjectId(p.Id)
}).ToAsyncEnumerable().ToList();
var TotalStdValue = (from p in linqVar
select p).Sum(t => t.StandardValue);
var model = new ProjectBriefListViewModel
{
ContractId = ContractId,
ProjectBriefViewModels = linqVar,
ProjectBriefInfo = new ProjectBriefInfo
{
TotalItems = linqVar.Count(),
TotalStdValue = TotalStdValue,
TotalCalcValue = (from p in linqVar
select p).Sum(t => t.CalcValue),
}
};
return(PartialView("ProjectBriefListPartial", model));
}
