public ActionResult Index(InsMaterialCostRequest request) { var ProjectList = this.ProjectService.GetProjectBasedataList(new ProjectRequest()); this.ViewBag.ProjectBasedataID = new SelectList(ProjectList, "ID", "PName"); var result = this.ProjectService.GetInsMaterialCostList(request); return View(result); }
public IEnumerable<InsMaterialCost> GetInsMaterialCostList(InsMaterialCostRequest request = null) { request = request ?? new InsMaterialCostRequest(); using (var dbContext = new ProjectDbContext()) { IQueryable<InsMaterialCost> InsMaterialCost = dbContext.InsMaterialCosts.Include("ProjectBasedata"); if (request.ProjectBasedataID > 0) InsMaterialCost = InsMaterialCost.Where(d => d.ProjectBasedataID == request.ProjectBasedataID); return InsMaterialCost.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }