/// <summary> /// 获取所有菜单 /// </summary> /// <param name="pagedSortedAndSearchInputDto">分页过滤排序dto</param> /// <returns></returns> public MenusOutputDto GetMenus(PagedSortedAndSearchInputDto pagedSortedAndSearchInputDto) { var all = _repository.GetAll(); if (pagedSortedAndSearchInputDto.Search != null && pagedSortedAndSearchInputDto.Search.Trim().Length > 0) { all = all.Where(item => item.Name.Contains(pagedSortedAndSearchInputDto.Search));//.Where($"Name.Contains(\"@0\")", pagedSortedAndSearchInputDto.Search); } var total = all.Count(); if (pagedSortedAndSearchInputDto.Sort.Trim().Length > 0) { //var orderExpression = all = all.OrderBy(string.Format("{0} {1}", pagedSortedAndSearchInputDto.Sort, pagedSortedAndSearchInputDto.Order)); } var list = all.Skip(pagedSortedAndSearchInputDto.Offset).Take(pagedSortedAndSearchInputDto.Limit).ToDynamicList <Menu>(); var listDto = _objectMapper.Map <List <MenuDto> >(list); MenusOutputDto menusOutputDto = new MenusOutputDto() { Rows = listDto, Total = total }; //menusOutputDto.Rows = listDto; //menusOutputDto.Total = total; return(menusOutputDto); }
/// <summary> /// 分页获取OrgnizationUnit /// </summary> /// <param name="pagedSortedAndSearchInputDto">分页过滤排序dto</param> /// <returns></returns> public OrgnizationUnitPagenationOutputDto GetOrgnizationUnitByPagenation(PagedSortedAndSearchInputDto pagedSortedAndSearchInputDto) { var all = _orgnizationUnitRepository.GetAll(); if (pagedSortedAndSearchInputDto.Search != null && pagedSortedAndSearchInputDto.Search.Trim().Length > 0) { all = all.Where(item => item.DisplayName.Contains(pagedSortedAndSearchInputDto.Search));//Change this Where for search } var total = all.Count(); if (pagedSortedAndSearchInputDto.Sort.Trim().Length > 0) { all = all.OrderBy(string.Format("{0} {1}", pagedSortedAndSearchInputDto.Sort, pagedSortedAndSearchInputDto.Order)); } var list = all.Skip(pagedSortedAndSearchInputDto.Offset).Take(pagedSortedAndSearchInputDto.Limit).ToDynamicList <OrganizationUnit>(); var listDto = _objectMapper.Map <List <OrgnizationUnitDto> >(list); OrgnizationUnitPagenationOutputDto result = new OrgnizationUnitPagenationOutputDto() { Rows = listDto, Total = total }; return(result); }
/// <summary> /// 分页获取User /// </summary> /// <param name="pagedSortedAndSearchInputDto">分页过滤排序dto</param> /// <returns></returns> public UserPagenationOutputDto GetUserByPagenation(PagedSortedAndSearchInputDto pagedSortedAndSearchInputDto) { var all = _userRepository.GetAll(); if (pagedSortedAndSearchInputDto.Search != null && pagedSortedAndSearchInputDto.Search.Trim().Length > 0) { all = all.Where(item => item.Name.Contains(pagedSortedAndSearchInputDto.Search)); } var total = all.Count(); if (pagedSortedAndSearchInputDto.Sort.Trim().Length > 0) { all = all.OrderBy(string.Format("{0} {1}", pagedSortedAndSearchInputDto.Sort, pagedSortedAndSearchInputDto.Order)); } var list = all.Skip(pagedSortedAndSearchInputDto.Offset).Take(pagedSortedAndSearchInputDto.Limit).ToDynamicList <User>(); var listDto = _objectMapper.Map <List <UserDto> >(list); UserPagenationOutputDto result = new UserPagenationOutputDto() { Rows = listDto, Total = total }; return(result); }