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));
}
