public List <User_Integral> SearchUserIntegralAllNum(UserIntegralSearchViewModel userIntegralSearchViewModel)
{
var predicate = SearchUserIntegralWhere(userIntegralSearchViewModel);
var result = DbSet2.Where(predicate).OrderBy(o => o.AddDate).ToList();
return(result);
}
public ActionResult <UserIntegralResModel> Manage_IntegralSearchAll(UserIntegralSearchViewModel userIntegralSearchViewModel)
{
UserIntegralResModel userIntegralResModel = new UserIntegralResModel();
var Result = _userService.SearchUserIntegralWhere(userIntegralSearchViewModel);
int count = _userService.SearchUserIntegralWhereNum(userIntegralSearchViewModel);
userIntegralResModel.user_Integrals = Result;
userIntegralResModel.count = count;
userIntegralResModel.isSuccess = true;
userIntegralResModel.baseViewModel.Message = "查询成功";
userIntegralResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("根据条件查询用户积分信息，查询成功");
return(Ok(userIntegralResModel));
}
public List <User_Integral> SearchUserIntegralAll(UserIntegralSearchViewModel userIntegralSearchViewModel)
{
int SkipNum = userIntegralSearchViewModel.pageViewModel.CurrentPageNum * userIntegralSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchUserIntegralWhere(userIntegralSearchViewModel);
var result = DbSet2.Where(predicate).OrderByDescending(o => o.AddDate)
.Skip(SkipNum)
.Take(userIntegralSearchViewModel.pageViewModel.PageSize)
.ToList();
return(result);
}
//根据条件查询用户
private Expression <Func <User_Integral, bool> > SearchUserIntegralWhere(UserIntegralSearchViewModel userIntegralSearchViewModel)
{
var predicate = WhereExtension.True <User_Integral>();//初始化where表达式
if (userIntegralSearchViewModel.User_DepartId != null)
{
predicate = predicate.And(p => p.User_DepartId == userIntegralSearchViewModel.User_DepartId.Value);
}
predicate = predicate.And(p => p.UserName.Contains(userIntegralSearchViewModel.UserName));
predicate = predicate.And(p => p.Mobile.Contains(userIntegralSearchViewModel.Mobile));
if (userIntegralSearchViewModel.starPoints != null && userIntegralSearchViewModel.endPoints != null)
{
predicate = predicate.And(p => Convert.ToInt64(p.TotalPoints) >= userIntegralSearchViewModel.starPoints && Convert.ToInt64(p.TotalPoints) <= userIntegralSearchViewModel.endPoints);
}
if (userIntegralSearchViewModel.strDate != null && userIntegralSearchViewModel.endDate != null)
{
predicate = predicate.And(p => p.updateDate.Value >= userIntegralSearchViewModel.strDate.Value && p.updateDate.Value <= userIntegralSearchViewModel.endDate.Value);
}
return(predicate);
}
