//1.1 系统操作日志列表
public List <SysOperLogResponse> List(SysOperLogQueryRequest request)
{
List <SysOperLogResponse> list = new List <SysOperLogResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.OperData.IsNotEmpty())
{
request.OperData = $"%{request.OperData}%";
join.Append(" and a.operdata like @OperData");
}
if (request.CreateStart.HasValue)
{
join.Append(" and a.createtime >= @CreateStart");
}
if (request.CreateEnd.HasValue)
{
request.CreateEnd = request.CreateEnd.Value.AddDays(1).AddSeconds(-1);
join.Append(" and a.createtime<=@CreateEnd");
}
var sql = $@"select a.*,b.name OperUserName from t_sys_operlog a
inner join t_sys_user b on a.sysuserId=b.id
where isdelete=0 {join.ToString()} order by a.createtime desc ";
int totalCount = 0;
list = _dbContext.Page <SysOperLogResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("SysOperLogService.List", ex);
}
return(list);
}
public ContentResult sysoperloglist(SysOperLogQueryRequest request)
{
var data = _sysOperLogService.List(request);
var res = new ResultDto <SysOperLogResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}