public ActionResult Index(SupplierRequest request) { //var materialList = this.BasisDataService.GetSupplierList(new SupplierRequest()); //this.ViewBag.ChannelId = new SelectList(classList, "ID", "Name"); this.ViewData["BasisDataService"] = this.BasisDataService; var result = this.BasisDataService.GetSupplierList(request); return View(result); }
public IEnumerable<Supplier> GetSupplierList(SupplierRequest request = null) { request = request ?? new SupplierRequest(); using (var dbContext = new BasisDataDbContext()) { IQueryable<Supplier> supplier = dbContext.Suppliers; if (!string.IsNullOrEmpty(request.Name)) supplier = supplier.Where(u => u.Name.Contains(request.Name)); if (!string.IsNullOrEmpty(request.Contact)) supplier = supplier.Where(u => u.Contact.Contains(request.Contact)); if (!string.IsNullOrEmpty(request.Address)) supplier = supplier.Where(u => u.Address.Contains(request.Address)); return supplier.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize); } }