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