コード例 #1
0
 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);
 }
コード例 #2
0
        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);
            }
        }