public int GetProductListNum(ProductListSearchViewModel productListSearchViewModel) { var predicate = SearchProductListWhere(productListSearchViewModel); var result = DbSet6.Where(predicate).ToList().Count; return(result); }
public List <Product_List> GetProductListListNum(ProductListSearchViewModel productListSearchViewModel) { int SkipNum = productListSearchViewModel.pageViewModel.CurrentPageNum * productListSearchViewModel.pageViewModel.PageSize; var predicate = SearchProductListWhere(productListSearchViewModel); var result = DbSet6.Where(predicate).ToList(); return(result); }
public ActionResult TopThreeProducts() { var viewModel = new ProductListSearchViewModel { ProductList = _productService.GetThreeNewestProducts(), }; return(View("_ProductTopThree", viewModel)); }
public ActionResult Index() { var viewModel = new ProductListSearchViewModel { ProductFiltersViewModel = _productService.GetProductSearch(), }; return(View(viewModel)); }
public List <Product_List> GetProductListList(ProductListSearchViewModel productListSearchViewModel) { int SkipNum = productListSearchViewModel.pageViewModel.CurrentPageNum * productListSearchViewModel.pageViewModel.PageSize; var predicate = SearchProductListWhere(productListSearchViewModel); var result = DbSet6.Where(predicate).OrderByDescending(A => A.AddDate) .Skip(SkipNum) .Take(productListSearchViewModel.pageViewModel.PageSize).ToList(); return(result); }
public ActionResult <ProductListSearchResModel> Manage_Product_List_Search(ProductListSearchViewModel productListSearchViewModel) { ProductListSearchResModel productListSearchResModel = new ProductListSearchResModel(); var Product_List = _userService.Product_List_Search(productListSearchViewModel); int count = _userService.Product_List_Search_Num(productListSearchViewModel); productListSearchResModel.productListMiddles = Product_List; productListSearchResModel.isSuccess = true; productListSearchResModel.TotalNum = count; productListSearchResModel.baseViewModel.Message = "查询兑换清单信息成功"; productListSearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("查询兑换清单信息成功"); return(Ok(productListSearchResModel)); }
//根据条件查询商品列表 private Expression <Func <Product_List, bool> > SearchProductListWhere(ProductListSearchViewModel productListSearchViewModel) { var predicate = WhereExtension.True <Product_List>();//初始化where表达式 if (productListSearchViewModel.User_UnionId != null) { predicate = predicate.And(p => p.User_UnionId == productListSearchViewModel.User_UnionId.Value); } if (productListSearchViewModel.User_DepartId != null) { predicate = predicate.And(p => p.User_DepartId == productListSearchViewModel.User_DepartId.Value); } predicate = predicate.And(p => p.CommodityName.Contains(productListSearchViewModel.CommodityName)); predicate = predicate.And(p => p.userName.Contains(productListSearchViewModel.UserName)); predicate = predicate.And(p => p.IntegralNum.Contains(productListSearchViewModel.IntegralNum)); if (productListSearchViewModel.starDate != null && productListSearchViewModel.endDate != null) { predicate = predicate.And(p => p.AddDate >= productListSearchViewModel.starDate && p.AddDate <= productListSearchViewModel.endDate); } return(predicate); }