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