public async Task <IResultModel> Query(ClassQueryModel model) { var result = new QueryResultModel <ClassEntity> { Rows = await _repository.Query(model), Total = model.TotalCount }; return(ResultModel.Success(result)); }
public async Task <IList <ClassEntity> > Query(ClassQueryModel model) { var paging = model.Paging(); var query = Db.Find(m => m.ProjectId == model.ProjectId); query.WhereIf(model.Name.NotNull(), m => m.Name.Contains(model.Name) || m.Remarks.Contains(model.Name)); if (!paging.OrderBy.Any()) { query.OrderByDescending(m => m.Id); } var list = await query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id) .Select((x, y) => new { x, Creator = y.Name }) .PaginationAsync(paging); model.TotalCount = paging.TotalCount; return(list); }
public Task <IResultModel> Query([FromQuery] ClassQueryModel model) { return(_service.Query(model)); }