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