/// <summary> /// 按条件分页查询指定字段,并返回总数 /// </summary> /// <param name="querySlopeInput"></param> /// <returns></returns> public async Task <PagedResultOutput <SlopeDto> > GetFieldsPageList(QuerySlopeInput querySlopeInput) { try { if (querySlopeInput.DISASTERUNITNAME == "" && querySlopeInput.LOCATION == "") { var slope = _iSlopeRepository.GetAll() .Select (s => new SlopeDto() { Id = s.Id, UNIFIEDCODE = s.UNIFIEDCODE, DISASTERUNITNAME = s.DISASTERUNITNAME, LOCATION = s.LOCATION, UPDATETIME = s.UPDATETIME, SLOPETYPE = s.SLOPETYPE } ) .OrderBy(s => s.UNIFIEDCODE).Skip((querySlopeInput.PageIndex - 1) * querySlopeInput.PageSize).Take(querySlopeInput.PageSize); IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >(); int count = await GetCount(querySlopeInput); PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir); return(list); } else { var slope = _iSlopeRepository.GetAll() .Where(_iSlopeRepository.GetWhere(querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION)) .Select (s => new SlopeDto() { Id = s.Id, UNIFIEDCODE = s.UNIFIEDCODE, DISASTERUNITNAME = s.DISASTERUNITNAME, LOCATION = s.LOCATION, UPDATETIME = s.UPDATETIME, SLOPETYPE = s.SLOPETYPE } ) .OrderBy(s => s.UNIFIEDCODE).Skip((querySlopeInput.PageIndex - 1) * querySlopeInput.PageSize).Take(querySlopeInput.PageSize); IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >(); int count = await GetCount(querySlopeInput); PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir); return(list); } } catch (Exception exception) { throw exception; } }
/// <summary> /// 按条件分页查询 /// </summary> /// <param name="querySlopeInput"></param> /// <returns></returns> public async Task <ListResultOutput <SlopeDto> > GetPageList(QuerySlopeInput querySlopeInput) { try { var slope = await _iSlopeRepository.GetPageList(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION); var list = new ListResultOutput <SlopeDto>(slope.MapTo <List <SlopeDto> >()); return(list); } catch (Exception exception) { throw exception; } }
/// <summary> /// 分页条件查询,并返回总数 /// </summary> /// <param name="querySlopeInput"></param> /// <returns></returns> public async Task <PagedResultOutput <SlopeDto> > GetPageAndCountList(QuerySlopeInput querySlopeInput) { try { var slope = await _iSlopeRepository.GetPageList(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION); IReadOnlyList <SlopeDto> ir = slope.MapTo <List <SlopeDto> >(); int count = await GetCount(querySlopeInput); PagedResultOutput <SlopeDto> list = new PagedResultOutput <SlopeDto>(count, ir); return(list); } catch (Exception exception) { throw exception; } }
/// <summary> /// 条件查询获取pageCount /// </summary> /// <param name="querySlopeInput"></param> /// <returns>pageCount</returns> /// public async Task <int> GetCount(QuerySlopeInput querySlopeInput) { int pageCount = await _iSlopeRepository.GetPageCount(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION); return(pageCount); }