/// <summary>
/// 异常信息分页
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Task <PagedResultsDto <SystemExceptionLog> > PagingExceptionLogQuery(SystemLoginLogPagingInput param)
{
string strWhere = "";
if (!string.IsNullOrWhiteSpace(param.CreateUserCode))
{
strWhere += $" AND CreateUserCode='{param.CreateUserCode}' ";
}
if (!string.IsNullOrWhiteSpace(param.CreateUserName))
{
strWhere += $" AND CreateUserName='******' ";
}
if (param.startTime != default(DateTime))
{
strWhere += $" AND CreateTime>='{param.startTime}' ";
}
if (param.endTime != default(DateTime))
{
strWhere += $" AND CreateTime<='{param.endTime}' ";
}
string sql = $"select * from Sys_ExceptionLog where 1=1 {strWhere}";
return(SqlMapperUtil.PagingQuery <SystemExceptionLog>(sql, param));
}
public Task <PagedResults <SystemOperateLog> > GetPagingOperationLog(SystemLoginLogPagingInput param)
{
string strWhere = "";
if (!string.IsNullOrWhiteSpace(param.CreateUserCode))
{
strWhere += $" AND CreateUserCode='{param.CreateUserCode}' ";
}
if (!string.IsNullOrWhiteSpace(param.CreateUserName))
{
strWhere += $" AND CreateUserName='******' ";
}
if (param.startTime != default(DateTime))
{
strWhere += $" AND CreateTime>='{param.startTime}' ";
}
if (param.endTime != default(DateTime))
{
strWhere += $" AND CreateTime<='{param.endTime}' ";
}
string sql = $"SELECT * FROM Sys_OperateLog where 1=1 {strWhere}";
return(SqlMapperUtil.PagingQuery <SystemOperateLog>(sql, param));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="queryParam"></param>
/// <returns></returns>
public Task <PagedResults <SystemOperateLog> > GetPagingOperationLog(SystemLoginLogPagingInput queryParam)
{
return(_repository.GetPagingOperationLog(queryParam));
}
public async Task <JsonResult> GetPagingLoginLog(SystemLoginLogPagingInput logPagingInput)
{
return(JsonForGridPaging(await _loginLogLogic.PagingLoginLogQuery(logPagingInput)));
}
/// <summary>
/// 登录信息分页查询
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public Task <PagedResultsDto <SystemLoginLog> > PagingLoginLogQuery(SystemLoginLogPagingInput logPagingInput)
{
return(_loginLogRepository.PagingLoginLogQuery(logPagingInput));
}
/// <summary>
/// 异常信息分页
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Task <PagedResults <SystemExceptionLog> > PagingExceptionLogQuery(SystemLoginLogPagingInput query)
{
return(_exceptionLogRepository.PagingExceptionLogQuery(query));
}
public async Task <JsonResult> GetPagingExceptionLog(SystemLoginLogPagingInput queryParam)
{
return(JsonForGridPaging(await _exceptionLogLogic.PagingExceptionLogQuery(queryParam)));
}
public async Task <JsonResult> GetPagingOperationLog(SystemLoginLogPagingInput queryParam)
{
return(JsonForGridPaging(await _operationLogLogic.GetPagingOperationLog(queryParam)));
}
