public ActionResult Index(InsBudgetRequest request) { var ProjectList = this.ProjectService.GetProjectBasedataList(new ProjectRequest()); this.ViewBag.ProjectBasedataID = new SelectList(ProjectList, "ID", "PName"); var result = this.ProjectService.GetInsBudgetList(request); //foreach (var rt in result) //{ // if (rt.InsLaborCost != null) // { // rt.InsBudgetTotal += rt.InsLaborCost.LaborTotal; // } // if (rt.InsMaterialCost != null) // { // rt.InsBudgetTotal += rt.InsMaterialCost.MaterialTotal; // } // if (rt.InsMachineryCost != null) // { // rt.InsBudgetTotal += rt.InsMachineryCost.MachineryTotal; // } // if (rt.InsMeasure != null) // { // rt.InsBudgetTotal += rt.InsMeasure.MeasureTotal; // } // if (rt.InsOverhead != null) // { // rt.InsBudgetTotal += rt.InsOverhead.OverheadTotal; // } //} return View(result); }
public IEnumerable<InsBudgetInfo> GetInsBudgetList(InsBudgetRequest request = null) { request = request ?? new InsBudgetRequest(); using (var dbContext = new ProjectDbContext()) { IQueryable<InsBudgetInfo> InsBudgetInfos = dbContext.InsBudgetInfos.Include("ProjectBasedata"); if (request.ProjectBasedataID > 0) InsBudgetInfos = InsBudgetInfos.Where(d => d.ProjectBasedataID == request.ProjectBasedataID); return InsBudgetInfos.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }