List <Expression <Func <ErrorLog, bool> > > GetSearchExpression(ErrorLogFilterDto model)
{
List <Expression <Func <ErrorLog, bool> > > filterList = new List <Expression <Func <ErrorLog, bool> > >();
if (model.FromDate != null)
{
filterList.Add(c => c.Date.Date >= model.FromDate);
}
if (model.ToDate != null)
{
filterList.Add(c => c.Date.Date <= model.ToDate);
}
return(filterList);
}
public async Task <ErrorLogFilterDto> Search(ErrorLogFilterDto model)
{
var expression = GetSearchExpression(model);
(var query, int totalCount) = await AuditUnitOfWork.ErrorLogRepository.GetPagedByFiltersAsync(
model.PageNumber,
model.jtPageSize.Value,
expression,
a => a.OrderByDescending(d => d.Date));
model.Items = query.Select(errorLog => ErrorLogMapper.MapToDto(errorLog)).ToList();
model.TotalCount = totalCount;
return(model);
}
/// <summary>
/// 获取任务异常日志分页
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public IPaging <ErrorLogDto> GetErrorLogPaging(ErrorLogFilterDto filter)
{
return(errorLogBusiness.GetErrorLogPaging(filter));
}
/// <summary>
/// 获取任务异常日志列表
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public List <ErrorLogDto> GetErrorLogList(ErrorLogFilterDto filter)
{
return(errorLogBusiness.GetErrorLogList(filter));
}
/// <summary>
/// 获取任务异常日志
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public ErrorLogDto GetErrorLog(ErrorLogFilterDto filter)
{
return(errorLogBusiness.GetErrorLog(filter));
}
/// <summary>
/// 获取任务异常日志分页
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public IPaging <ErrorLogDto> GetErrorLogPaging(ErrorLogFilterDto filter)
{
var errorLogPaging = errorLogService.GetErrorLogPaging(CreateQueryObject(filter));
return(errorLogPaging.ConvertTo <ErrorLogDto>());
}
/// <summary>
/// 获取任务异常日志列表
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public List <ErrorLogDto> GetErrorLogList(ErrorLogFilterDto filter)
{
var errorLogList = errorLogService.GetErrorLogList(CreateQueryObject(filter));
return(errorLogList.Select(c => c.MapTo <ErrorLogDto>()).ToList());
}
/// <summary>
/// 获取任务异常日志
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public ErrorLogDto GetErrorLog(ErrorLogFilterDto filter)
{
var errorLog = errorLogService.GetErrorLog(CreateQueryObject(filter));
return(errorLog.MapTo <ErrorLogDto>());
}
/// <summary>
/// 根据查询条件生成查询对象
/// </summary>
/// <param name="filter">查询条件</param>
/// <returns></returns>
IQuery CreateQueryObject(ErrorLogFilterDto filter)
{
if (filter == null)
{
return(null);
}
IQuery query = QueryFactory.Create(filter);
#region 筛选条件
if (!filter.Ids.IsNullOrEmpty())
{
query.In <ErrorLogQuery>(c => c.Id, filter.Ids);
}
if (!filter.Server.IsNullOrEmpty())
{
query.Equal <ErrorLogQuery>(c => c.Server, filter.Server);
}
if (!filter.Job.IsNullOrEmpty())
{
query.Equal <ErrorLogQuery>(c => c.Job, filter.Job);
}
if (!filter.Trigger.IsNullOrEmpty())
{
query.Equal <ErrorLogQuery>(c => c.Trigger, filter.Trigger);
}
if (!filter.Message.IsNullOrEmpty())
{
query.Equal <ErrorLogQuery>(c => c.Message, filter.Message);
}
if (!filter.Description.IsNullOrEmpty())
{
query.Equal <ErrorLogQuery>(c => c.Description, filter.Description);
}
if (filter.Type.HasValue)
{
query.Equal <ErrorLogQuery>(c => c.Type, filter.Type.Value);
}
if (filter.BeginDate.HasValue)
{
query.GreaterThanOrEqual <ErrorLogQuery>(c => c.Date, filter.BeginDate.Value);
}
if (filter.EndDate.HasValue)
{
query.LessThanOrEqual <ErrorLogQuery>(c => c.Date, filter.EndDate.Value);
}
#endregion
#region 数据加载
if (filter.LoadServer)
{
query.SetLoadPropertys <ErrorLog>(true, c => c.Server);
}
if (filter.LoadJob)
{
query.SetLoadPropertys <ErrorLog>(true, c => c.Job);
}
if (filter.LoadTrigger)
{
query.SetLoadPropertys <ErrorLog>(true, c => c.Trigger);
}
#endregion
#region 排序
query.Desc <ErrorLogQuery>(c => c.Date);
#endregion
return(query);
}