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