public int GetIntegral_Commodity_Num(IntegralCommoditySearchViewModel integralCommoditySearchViewModel) { var predicate = SearchIntegralCommodityWhere(integralCommoditySearchViewModel); var result = DbSet4.Where(predicate) .ToList().Count; return(result); }
public List <Integral_Commodity> GetIntegral_CommodityList(IntegralCommoditySearchViewModel integralCommoditySearchViewModel) { int SkipNum = integralCommoditySearchViewModel.pageViewModel.CurrentPageNum * integralCommoditySearchViewModel.pageViewModel.PageSize; var predicate = SearchIntegralCommodityWhere(integralCommoditySearchViewModel); var result = DbSet4.Where(predicate).OrderByDescending(A => A.AddDate) .Skip(SkipNum) .Take(integralCommoditySearchViewModel.pageViewModel.PageSize).ToList(); return(result); }
//根据条件查询商品列表 private Expression <Func <Integral_Commodity, bool> > SearchIntegralCommodityWhere(IntegralCommoditySearchViewModel integralCommoditySearchViewModel) { var predicate = WhereExtension.True <Integral_Commodity>();//初始化where表达式 if (integralCommoditySearchViewModel.User_UnionId != null) { predicate = predicate.And(p => p.User_UnionId == integralCommoditySearchViewModel.User_UnionId.Value); } predicate = predicate.And(p => p.CommodityName.Contains(integralCommoditySearchViewModel.CommodityName)); predicate = predicate.And(p => p.IntegralNum.Contains(integralCommoditySearchViewModel.IntegralNum)); predicate = predicate.And(p => p.status.Contains(integralCommoditySearchViewModel.status)); predicate = predicate.And(p => p.IsDelete == "0"); return(predicate); }
public ActionResult <IntegralCommoditySearchResModel> Manage_Integral_Commodity_Search(IntegralCommoditySearchViewModel integralCommoditySearchViewModel) { IntegralCommoditySearchResModel integralCommoditySearchResModel = new IntegralCommoditySearchResModel(); var Integral_Commodity = _userService.Integral_Commodity_Search(integralCommoditySearchViewModel); int count = _userService.Integral_Commodity_Num_Search(integralCommoditySearchViewModel); integralCommoditySearchResModel.integral_Commodities = Integral_Commodity; integralCommoditySearchResModel.isSuccess = true; integralCommoditySearchResModel.TotalNum = count; integralCommoditySearchResModel.baseViewModel.Message = " 查询商品信息成功"; integralCommoditySearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("查询商品信息成功"); return(Ok(integralCommoditySearchResModel)); }