public List <User_Register> SearchUserRegisterNum(UserRegisterSearchViewModel userRegisterSearchViewModel)
{
//查询条件
var predicate = SearchRegisterWhere(userRegisterSearchViewModel);
var result = DbSet.Where(predicate).OrderByDescending(o => o.AddDate)
.ToList();
return(result);
}
//根据条件查询用户
private Expression <Func <User_Register, bool> > SearchRegisterWhere(UserRegisterSearchViewModel userRegisterSearchViewModel)
{
var predicate = WhereExtension.True <User_Register>();//初始化where表达式
predicate = predicate.And(p => p.status.Contains(userRegisterSearchViewModel.status));
if (userRegisterSearchViewModel.strDate != null && userRegisterSearchViewModel.endDate != null)
{
predicate = predicate.And(p => p.AddDate.Value >= userRegisterSearchViewModel.strDate.Value && p.AddDate.Value <= userRegisterSearchViewModel.endDate.Value);
}
return(predicate);
}
public List <User_Register> SearchUserRegister(UserRegisterSearchViewModel userRegisterSearchViewModel)
{
int SkipNum = userRegisterSearchViewModel.pageViewModel.CurrentPageNum * userRegisterSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchRegisterWhere(userRegisterSearchViewModel);
var result = DbSet.Where(predicate).OrderByDescending(o => o.AddDate)
.Skip(SkipNum)
.Take(userRegisterSearchViewModel.pageViewModel.PageSize)
.ToList();
return(result);
}
public ActionResult <UserRegisterSearchResModel> Manage_UserRegister_Search(UserRegisterSearchViewModel userRegisterSearchViewModel)
{
UserRegisterSearchResModel userRegisterSearchResModel = new UserRegisterSearchResModel();
var userRegister = _userService.SearchUserRegisterWhere(userRegisterSearchViewModel);
int count = _userService.SearchUserRegisterWhereNum(userRegisterSearchViewModel);
userRegisterSearchResModel.user_Registers = userRegister;
userRegisterSearchResModel.isSuccess = true;
userRegisterSearchResModel.TotalNum = count;
userRegisterSearchResModel.baseViewModel.Message = " 查询注册用户信息成功";
userRegisterSearchResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information(" 查询注册用户信息成功");
return(Ok(userRegisterSearchResModel));
}
