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