//根据条件查询部门
private Expression<Func<User_Depart, bool>> SearchDepartWhere(DepartSearchViewModel departSearchViewModel)
{
var predicate = WhereExtension.True<User_Depart>();//初始化where表达式
predicate = predicate.And(p => p.Code.Contains(departSearchViewModel.Code));
predicate = predicate.And(p => p.Name.Contains(departSearchViewModel.Name));
predicate = predicate.And(p => p.ParentId.Contains(departSearchViewModel.ParentId));
return predicate;
}
//查询部门
public List <DepartSearchMiddlecs> Depart_Search(DepartSearchViewModel departSearchViewModel)
{
List <User_Depart> user_Departs = _IUserDepartRepository.SearchDepartByWhere(departSearchViewModel);
List <DepartSearchMiddlecs> departSearches = new List <DepartSearchMiddlecs>();
foreach (var item in user_Departs)
{
var DeaprtSearchMiddlecs = _IMapper.Map <User_Depart, DepartSearchMiddlecs>(item);
departSearches.Add(DeaprtSearchMiddlecs);
}
return(departSearches);
}
public List<User_Depart> SearchDepartByWhere(DepartSearchViewModel departSearchViewModel)
{
//查询条件
int SkipNum = departSearchViewModel.pageViewModel.CurrentPageNum * departSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchDepartWhere(departSearchViewModel);
var result = DbSet.Where(predicate).OrderBy(o => o.Sort)
.Skip(SkipNum)
.Take(departSearchViewModel.pageViewModel.PageSize)
.ToList();
return result;
}
public ActionResult <DepartSearchResModel> Manage_Depart_Search(DepartSearchViewModel departSearchViewModel)
{
DepartSearchResModel departSearchResModel = new DepartSearchResModel();
var DepartSearchResult = _departService.Depart_Search(departSearchViewModel);
var TotalNum = _departService.Depart_Get_ALLNum(departSearchViewModel);
departSearchResModel.user_Departs = DepartSearchResult;
departSearchResModel.isSuccess = true;
departSearchResModel.baseViewModel.Message = "查询成功";
departSearchResModel.baseViewModel.ResponseCode = 200;
departSearchResModel.TotalNum = TotalNum;
//_ILogger.Information("查询部门信息成功");
return(Ok(departSearchResModel));
}
/// <summary>
/// 部门数量
/// </summary>
/// <param name="departSearchViewModel"></param>
/// <returns></returns>
public IQueryable<User_Depart> GetDepartAll(DepartSearchViewModel departSearchViewModel)
{
var predicate = SearchDepartWhere(departSearchViewModel);
return DbSet.Where(predicate);
}
public int Depart_Get_ALLNum(DepartSearchViewModel departSearchViewModel)
{
return(_IUserDepartRepository.GetDepartAll(departSearchViewModel).Count());
}
