public PageResult <CommodityDto> Search(CommoditySearchCriteria csc, PageRequest request) { using (var db = base.NewDB()) { var data = db.Commoditys.AsQueryable(); if (csc.StarTime != null) { data = data.Where(c => c.CreatedTime >= csc.StarTime); } if (csc.EndTime != null) { data = data.Where(c => c.CreatedTime <= csc.EndTime); } if (!string.IsNullOrEmpty(csc.Search)) { data = data.Where(c => c.Name.Contains(csc.Search)); } if (csc.CategoryId != null) { data = data.Where(c => c.CategoryId == csc.CategoryId); } if (csc.State != -99)//全部 { data = data.Where(c => c.Status == csc.State); } return(data.ToDtos().ToPageResult(request)); } }
public ActionResult List(CommoditySearchCriteria csc, PageRequest request) { var list = Ioc.Get <ICommodityService>().Search(csc, request); return(Json(list, JsonRequestBehavior.AllowGet)); }