public async Task <IResultModel> Query(DictItemQueryModel model)
{
var result = new QueryResultModel <DictItemEntity>
{
Rows = await _repository.Query(model),
Total = model.TotalCount
};
return(ResultModel.Success(result));
}
public Task <IList <DictItemEntity> > QueryAll(DictItemQueryModel model)
{
var paging = model.Paging();
var query = Db.Find();
query.WhereNotNull(model.GroupCode, m => m.GroupCode == model.GroupCode);
query.WhereNotNull(model.DictCode, m => m.DictCode == model.DictCode);
query.WhereNotNull(model.Name, m => m.Name.Contains(model.Name));
query.WhereNotNull(model.Value, m => m.Value.Contains(model.Value));
var joinQuery = query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id)
.Select((x, y) => new { x, Creator = y.Name });
if (!paging.OrderBy.Any())
{
joinQuery.OrderBy((x, y) => x.Sort);
}
return(joinQuery.ToListAsync());
}
public async Task <IList <DictItemEntity> > Query(DictItemQueryModel model)
{
var paging = model.Paging();
var query = Db.Find(m => m.GroupCode == model.GroupCode && m.DictCode == model.DictCode && m.ParentId == model.ParentId);
query.WhereNotNull(model.Name, m => m.Name.Contains(model.Name));
query.WhereNotNull(model.Value, m => m.Value.Contains(model.Value));
var joinQuery = query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id)
.Select((x, y) => new { x, Creator = y.Name });
if (!paging.OrderBy.Any())
{
joinQuery.OrderBy((x, y) => x.Sort);
}
var list = await joinQuery.PaginationAsync(paging);
model.TotalCount = paging.TotalCount;
return(list);
}
public Task <IResultModel> Query([FromQuery] DictItemQueryModel model)
{
return(_service.Query(model));
}
