//根据条件查询权限 private Expression <Func <User_Rights, bool> > SearchRightsWhere(RightsSearchViewModel rightsSearchViewModel) { var predicate = WhereExtension.True <User_Rights>();//初始化where表达式 predicate = predicate.And(p => p.RightsName.Contains(rightsSearchViewModel.RightsName)); predicate = predicate.And(p => p.RightsValue.Contains(rightsSearchViewModel.RightsValue)); predicate = predicate.And(p => p.ParentId.Contains(rightsSearchViewModel.ParentId)); predicate = predicate.And(p => p.Type.Contains(rightsSearchViewModel.Type)); return(predicate); }
//查询权限 public List <RightsSearchMiddlecs> Rights_Search(RightsSearchViewModel rightsSearchViewModel) { List <User_Rights> user_Rights = _IUserRightsRepository.SearchRightsByWhere(rightsSearchViewModel); List <RightsSearchMiddlecs> rightsSearches = new List <RightsSearchMiddlecs>(); foreach (var item in user_Rights) { var RightsSearchMiddlecs = _IMapper.Map <User_Rights, RightsSearchMiddlecs>(item); rightsSearches.Add(RightsSearchMiddlecs); } return(rightsSearches); }
public ActionResult <RightsSearchResModel> Manage_Rights_Search(RightsSearchViewModel rightsSearchViewModel) { RightsSearchResModel rightsSearchResModel = new RightsSearchResModel(); var RightsSearchResult = _rightsService.Rights_Search(rightsSearchViewModel); var TotalNum = _rightsService.Rights_Get_ALLNum(rightsSearchViewModel); rightsSearchResModel.user_Rights = RightsSearchResult; rightsSearchResModel.isSuccess = true; rightsSearchResModel.baseViewModel.Message = "查询成功"; rightsSearchResModel.baseViewModel.ResponseCode = 200; rightsSearchResModel.TotalNum = TotalNum; //_ILogger.Information("查询权限信息成功"); return(Ok(rightsSearchResModel)); }
public List <User_Rights> SearchRightsByWhere(RightsSearchViewModel rightsSearchViewModel) { //查询条件 int SkipNum = rightsSearchViewModel.pageViewModel.CurrentPageNum * rightsSearchViewModel.pageViewModel.PageSize; //查询条件 var predicate = SearchRightsWhere(rightsSearchViewModel); var result = DbSet.Where(predicate).OrderBy(o => o.Sort) .Skip(SkipNum) .Take(rightsSearchViewModel.pageViewModel.PageSize) .ToList(); return(result); }
/// <summary> /// 获得权限数量 /// </summary> /// <param name="rightsSearchViewModel"></param> /// <returns></returns> public int Rights_Get_ALLNum(RightsSearchViewModel rightsSearchViewModel) { return(_IUserRightsRepository.GetRightsAll(rightsSearchViewModel).Count()); }
public IQueryable <User_Rights> GetRightsAll(RightsSearchViewModel rightsSearchViewModel) { var predicate = SearchRightsWhere(rightsSearchViewModel); return(DbSet.Where(predicate)); }