public async Task <IResultModel> Query(JobQueryModel model) { var result = new QueryResultModel <JobEntity> { Rows = await _jobRepository.Query(model), Total = model.TotalCount }; return(ResultModel.Success(result)); }
public JsonResult GetJobList(JobQueryModel model) { if (string.IsNullOrEmpty(model.JobName)) { model.JobName = string.Empty; } var data = _job.GetJobList(); var tdata = data.Where(p => p.JobName.Contains(model.JobName)).OrderBy(p => p.JobName).ToList(); int total = tdata.Count; var list = tdata.Skip(model.Offset).Take(model.Limit).ToList();; return(Json(new { total = total, rows = list })); }
public async Task <IList <JobEntity> > Query(JobQueryModel model) { var paging = model.Paging(); var query = Db.Find(); if (!paging.OrderBy.Any()) { query.OrderByDescending(m => m.Id); } var result = 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(result); }
public async Task <IList <JobEntity> > Query(JobQueryModel model) { var conditions = await _filter.GetConditions <JobEntity, JobQueryModel>(model); var query = _dbContext.Db.Queryable <JobEntity>() .LeftJoin <JobGroupEntity>((x, y) => x.JobGroup == y.Code && y.IsDel == false) .Select((x, y) => new JobEntity() { Id = x.Id.SelectAll(), GroupName = y.Name }) .MergeTable() .Where(conditions) .OrderBy(model.OrderFileds); RefAsync <int> totalCount = 0; var data = await query.ToPageListAsync(model.PageIndex, model.PageSize, totalCount); model.TotalCount = totalCount; return(data); }
public async Task <IList <JobEntity> > Query(JobQueryModel model) { var paging = model.Paging(); var query = Db.Find(); query.WhereNotNull(model.Name, m => m.Name.Contains(model.Name)); var joinQuery = query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id); if (!paging.OrderBy.Any()) { joinQuery.OrderByDescending((x, y) => x.Id); } joinQuery.Select((x, y) => new { x, Creator = y.Name }); var result = await joinQuery.PaginationAsync(paging); model.TotalCount = paging.TotalCount; return(result); }
public Task <IResultModel> Query([FromQuery] JobQueryModel model) { return(_service.Query(model)); }