//根据条件查询权限
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));
}
