/// <summary> /// 分页查询 /// </summary> public async Task <List <DataDictDetailEntity> > GetPageList(DataDictDetailListParam param, Pagination pagination) { #region 查询条件 var query = _dataDictDetailEntityDB.AsQueryable(); /* * // 字典类型(外键) * if (!string.IsNullOrEmpty(param.DictType)) * query = query.Where(p => p.DictType.Contains(param.DictType)); * // 字典键(一般从1开始) * if (param.DictKey.HasValue) * query = query.Where(p => p.DictKey == param.DictKey); * // 字典值 * if (!string.IsNullOrEmpty(param.DictValue)) * query = query.Where(p => p.DictValue.Contains(param.DictValue)); * */ var data = await query.OrderByDescending(a => a.Id) .ToPagedListAsync(pagination.PageIndex, pagination.PageSize); #endregion // 分页参数赋值 pagination.TotalCount = data.TotalCount; return(data.Items.ToList()); }
public async Task <List <DataDictDetailEntity> > GetPageList(DataDictDetailListParam param, Pagination pagination) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression, pagination); return(list.ToList()); }
/// <summary> /// 带条件查询所有 /// </summary> public async Task <List <DataDictDetailEntity> > GetList(DataDictDetailListParam param) { #region 查询条件 var query = _dataDictDetailEntityDB.AsQueryable(); // 字典类型(外键) if (!string.IsNullOrEmpty(param.DictType)) { query = query.Where(p => p.DictType.Contains(param.DictType)); } // 字典键(一般从1开始) if (param.DictKey.HasValue) { query = query.Where(p => p.DictKey == param.DictKey); } // 字典值 if (!string.IsNullOrEmpty(param.DictValue)) { query = query.Where(p => p.DictValue.Contains(param.DictValue)); } #endregion var data = await query.ToListAsync(); return(data); }
public async Task <List <DataDictDetailEntity> > GetList(DataDictDetailListParam param) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression); return(list.OrderBy(p => p.DictSort).ToList()); }
public async Task <TData <List <DataDictDetailEntity> > > GetDataDictDetailListJson( [FromQuery] DataDictDetailListParam param, [FromQuery] Pagination pagination) { var obj = await _dataDictDetailBLL.GetPageList(param, pagination); return(obj); }
public async Task <IActionResult> GetPageListJson(DataDictDetailListRequest paramRequest) { DataDictDetailListParam param = paramRequest.param; Pagination pagination = paramRequest.pagination; TData <List <DataDictDetailEntity> > obj = await dataDictDetailBLL.GetPageList(param, pagination); return(Json(obj)); }
public async Task <TData <List <DataDictDetailEntity> > > GetList(DataDictDetailListParam param) { var obj = new TData <List <DataDictDetailEntity> >(); obj.Data = await _dataDictDetailService.GetList(param); obj.Tag = 1; return(obj); }
public async Task <TData <List <DataDictDetailEntity> > > GetPageList(DataDictDetailListParam param, Pagination pagination) { TData <List <DataDictDetailEntity> > obj = new TData <List <DataDictDetailEntity> >(); obj.Result = await dataDictDetailService.GetPageList(param, pagination); obj.TotalCount = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <TData <List <DataDictDetailEntity> > > GetList(DataDictDetailListParam param) { TData <List <DataDictDetailEntity> > obj = new TData <List <DataDictDetailEntity> >(); obj.Result = await dataDictDetailService.GetList(param); obj.TotalCount = obj.Result.Count; obj.Tag = 1; return(obj); }
private Expression <Func <DataDictDetailEntity, bool> > ListFilter(DataDictDetailListParam param) { var expression = LinqExtensions.True <DataDictDetailEntity>(); if (param != null) { if (param.DictKey.ParseToInt() > 0) { expression = expression.And(t => t.DictKey == param.DictKey); } if (!string.IsNullOrEmpty(param.DictValue)) { expression = expression.And(t => t.DictValue.Contains(param.DictValue)); } if (!string.IsNullOrEmpty(param.DictType)) { expression = expression.And(t => t.DictType.Contains(param.DictType)); } } return(expression); }
public async Task <IActionResult> GetPageListJson(DataDictDetailListParam param, Pagination pagination) { TData <List <DataDictDetailEntity> > obj = await dataDictDetailBLL.GetPageList(param, pagination); return(Json(obj)); }