public async Task <IList <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
var paging = model.Paging();
var query = Db.Find();
query.WhereNotNull(model.ModuleCode, m => m.Area == model.ModuleCode);
query.WhereNotNull(model.Controller, m => m.Controller == model.Controller);
query.WhereNotNull(model.Action, m => m.Action == model.Action);
query.WhereNotNull(model.StartTime, m => m.ExecutionTime >= model.StartTime);
query.WhereNotNull(model.EndTime, m => m.ExecutionTime <= model.EndTime);
if (!paging.OrderBy.Any())
{
query.OrderByDescending(x => x.Id);
}
var sw = new Stopwatch();
sw.Start();
var list = await query.PaginationAsync(paging);
sw.Stop();
var s = sw.ElapsedMilliseconds;
model.TotalCount = paging.TotalCount;
return(list);
}
public async Task <IList <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
var paging = model.Paging();
var query = Db.Find();
query.WhereNotNull(model.ModuleCode, m => m.Area == model.ModuleCode);
query.WhereNotNull(model.Controller, m => m.Controller == model.Controller);
query.WhereNotNull(model.Action, m => m.Action == model.Action);
query.WhereNotNull(model.StartTime, m => m.ExecutionTime >= model.StartTime);
query.WhereNotNull(model.EndTime, m => m.ExecutionTime <= model.EndTime);
if (!paging.OrderBy.Any())
{
query.OrderByDescending(x => x.Id);
}
//导出全部
if (model.IsExport && model.Export.Mode == ExportMode.All)
{
model.ExportCount = await query.CountAsync();
if (model.IsOutOfExportCountLimit)
{
return(new List <AuditInfoEntity>());
}
return(await query.ToListAsync());
}
var list = await query.PaginationAsync(paging);
model.ExportCount = list.Count;
model.TotalCount = paging.TotalCount;
return(list);
}
public async Task <IList <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
var paging = model.Paging();
var query = Db.Find();
query.WhereIf(model.ModuleCode.NotNull(), m => m.Area == model.ModuleCode);
query.WhereIf(model.Controller.NotNull(), m => m.Controller == model.Controller);
query.WhereIf(model.Action.NotNull(), m => m.Action == model.Action);
query.WhereIf(model.StartTime != null, m => m.ExecutionTime >= model.StartTime);
query.WhereIf(model.EndTime != null, m => m.ExecutionTime <= model.EndTime);
if (!paging.OrderBy.Any())
{
query.OrderByDescending(m => m.Id);
}
var list = await query.LeftJoin <AccountEntity>((x, y) => x.AccountId == y.Id)
.LeftJoin <ModuleInfoEntity>((x, y, z) => x.Area == z.Code)
.Select((x, y, z) => new
{
x,
Creator = y.Name,
ModuleName = z.Name
})
.PaginationAsync(paging);
model.TotalCount = paging.TotalCount;
return(list);
}
public async Task <QueryResultModel <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
//model.PageModel = getQueryPageModel();
var result = await _service.Query(model);
return(result.Data);
}
public async Task <IResultModel> Query(AuditInfoQueryModel model)
{
var result = new QueryResultModel <AuditInfoEntity>
{
Rows = await _repository.Query(model),
Total = model.TotalCount
};
return(ResultModel.Success(result));
}
public async Task <IActionResult> Export(AuditInfoQueryModel model)
{
var result = await _service.Export(model);
if (result.Successful)
{
return(ExportExcel(result.Data.Path, result.Data.FileName));
}
return(Ok(result));
}
public async Task <IResultModel> Query(AuditInfoQueryModel model)
{
var result = new QueryResultModel <AuditInfoQueryResultModel>();
var paging = model.Paging();
var list = await _repository.Query(paging, model.AccountId, model.ModuleCode, model.Controller, model.Action, model.StartTime, model.EndTime);
result.Rows = _mapper.Map <List <AuditInfoQueryResultModel> >(list);
result.Total = paging.TotalCount;
return(ResultModel.Success(result));
}
public async Task <IResultModel <ExcelExportResultModel> > Export(AuditInfoQueryModel model)
{
var result = new ResultModel <ExcelExportResultModel>();
var list = await _repository.Query(model);
if (model.IsOutOfExportCountLimit)
{
return(result.Failed($"导出数据不能超过{model.ExportCountLimit}条"));
}
return(result.Success(_excelHandler.Export(model.Export, list)));
}
public async Task <IList <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
var conditions = await _filter.GetConditions <ResourceEntity, AuditInfoQueryModel>(model);
var query = _dbContext.Db.Queryable <AuditInfoEntity>()
.LeftJoin <UserEntity>((x, y) => x.Creater == y.Id && y.IsDel == false)
.Select((x, y) => new AuditInfoEntity()
{
Id = x.Id.SelectAll(),
UserCode = y.UserCode,
UserName = y.UserName
})
.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 <QueryResultModel <AuditInfoEntity> > Query(AuditInfoQueryModel model)
{
var paging = model.Paging();
var query = dbSet.AsQueryable();
if (!model.LoginName.IsNull())
{
query = query.Where(a => a.LoginName.Equals(model.LoginName));
}
if (!model.SAction.IsNull())
{
query = query.Where(a => a.Action.Equals(model.SAction));
}
if (!model.SController.IsNull())
{
query = query.Where(a => a.Controller.Equals(model.SController));
}
if (model.time_min != null)
{
query = query.Where(a => model.time_min < a.ExecutionTime);
}
if (model.time_max != null)
{
query = query.Where(a => model.time_max > a.ExecutionTime);
}
//if (!model.LoginName.IsNull())
//{
// query = query.Where(a => a.LoginName.Contains(model.LoginName));
//}
if (!paging.OrderBy.Any())
{
query = query.OrderByDescending(m => m.ExecutionTime);
}
return(await query.PaginationGetResult(paging));
}
public Task <IResultModel> Query([FromQuery] AuditInfoQueryModel model)
{
return(_service.Query(model));
}
public async Task <IResultModel <QueryResultModel <AuditInfoEntity> > > Query(AuditInfoQueryModel model)
{
var result = new ResultModel <QueryResultModel <AuditInfoEntity> >();
var data = await _repository.Query(model);
return(result.Success(data));
}
