public async Task <IResultModel> Query(ModelPropertyQueryModel model)
{
var result = new QueryResultModel <ModelPropertyEntity>
{
Rows = await _repository.Query(model),
Total = model.TotalCount
};
return(ResultModel.Success(result));
}
public async Task <IResultModel> Select(ModelPropertyQueryModel model)
{
var all = await _repository.QueryAll(model);
var result = all.OrderBy(m => m.Sort).Select(m => new OptionResultModel()
{
Label = $"{m.Name}({m.Remarks})",
Value = m.Name,
Data = m.Id
}).ToList();
return(ResultModel.Success(result));
}
public async Task <IResultModel> QuerySortList(ModelPropertyQueryModel model)
{
var result = new SortUpdateModel <Guid>();
var all = await _repository.QueryAll(model);
result.Options = all.OrderBy(m => m.Sort).Select(m => new SortOptionModel <Guid>()
{
Id = m.Id,
Label = m.Name,
Sort = m.Sort
}).ToList();
return(ResultModel.Success(result));
}
public async Task <IList <ModelPropertyEntity> > Query(ModelPropertyQueryModel model)
{
var paging = model.Paging();
var query = Db.Find(m => m.ClassId == model.ClassId && m.ModelType == model.ModelType);
if (!paging.OrderBy.Any())
{
query.OrderBy(m => m.Sort);
}
var list = await query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id)
.LeftJoin <ModelPropertyEntity>((x, y, z) => x.EnumId == z.Id)
.Select((x, y, z) => new { x, Creator = y.Name, EnumName = z.Name })
.PaginationAsync(paging);
model.TotalCount = paging.TotalCount;
return(list);
}
public Task <IList <ModelPropertyEntity> > QueryAll(ModelPropertyQueryModel model)
{
return(Db.Find(m => m.ClassId == model.ClassId && m.ModelType == model.ModelType).ToListAsync());
}
public Task <IResultModel> Select([FromQuery] ModelPropertyQueryModel model)
{
return(_service.Select(model));
}
public Task <IResultModel> Sort([FromQuery] ModelPropertyQueryModel model)
{
return(_service.QuerySortList(model));
}
public Task <IResultModel> Query([FromQuery] ModelPropertyQueryModel model)
{
return(_service.Query(model));
}
