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