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)); }