//根据条件查询部门 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()); }