/// <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));
}
