/// <summary>
/// 查找指定时段的日志信息
/// </summary>
/// <param name="operationLogQueryParam"></param>
/// <returns></returns>
public IQueryable <OperationLog> SearchOperationLogPageData(OperationLogQueryParam operationLogQueryParam)
{
var firstTime = Convert.ToDateTime(operationLogQueryParam.FirstTime);
var lastTime = Convert.ToDateTime(operationLogQueryParam.LastTime);
var temp = DbSession.OperationLogDal.GetEntities(u => (u.IsDeleted == false && (u.SubTime > firstTime && u.SubTime < lastTime)));
//按操作人员筛选
if (!string.IsNullOrEmpty(operationLogQueryParam.UName))
{
temp = temp.Where(o => o.UName.Contains(operationLogQueryParam.UName)).AsQueryable();
}
//按操作类型筛选
if (!string.IsNullOrEmpty(operationLogQueryParam.ActionType))
{
temp = temp.Where(o => o.ActionType.Contains(operationLogQueryParam.ActionType)).AsQueryable();
}
//按操作名称查找
if (!string.IsNullOrEmpty(operationLogQueryParam.ActionName))
{
temp = temp.Where(o => o.ActionName.Contains(operationLogQueryParam.ActionName)).AsQueryable();
}
operationLogQueryParam.Total = temp.Count();
//分页
return(temp.OrderByDescending(u => u.SubTime)
.Skip(operationLogQueryParam.PageSize * (operationLogQueryParam.PageIndex - 1))
.Take(operationLogQueryParam.PageSize).AsQueryable());
}
/// <summary>
/// 获取所有操作日志信息
/// </summary>
/// <returns></returns>
public ActionResult GetAllOperationLogs(string limit, string page)
{
int pageSize = int.Parse(limit ?? "10");
int pageIndex = int.Parse(page ?? "1");
var queryParam = new OperationLogQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = 0
};
var pageData = OperationLogService.LoagOperationLogPageData(queryParam);
var temp = pageData.Select(o => new
{
o.UName,
o.ActionType,
o.ActionName,
o.OperationObj,
o.Id,
o.SubTime
});
var data = new { code = 0, msg = "", count = queryParam.Total, data = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 多条件查询
/// </summary>
/// <param name="userQueryParam">查询条件</param>
/// <returns>查询结果</returns>
public IQueryable <OperationLog> LoagOperationLogPageData(OperationLogQueryParam operationLogQueryParam)
{
var temp = DbSession.OperationLogDal.GetEntities(u => u.IsDeleted == false);
operationLogQueryParam.Total = temp.Count();
//分页
return(temp.OrderByDescending(u => u.SubTime)
.Skip(operationLogQueryParam.PageSize * (operationLogQueryParam.PageIndex - 1))
.Take(operationLogQueryParam.PageSize).AsQueryable());
}
/// <summary>
/// 搜索具体范围时间内的日志
/// </summary>
/// <param name="limit"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult SearchOperationLogs(string page, string limit, OperationLogQueryParam operationLogQueryParam)
{
int pageSize = int.Parse(limit ?? "10");
int pageIndex = int.Parse(page ?? "1");
operationLogQueryParam.PageSize = pageSize;
operationLogQueryParam.PageIndex = pageIndex;
var pageData = OperationLogService.SearchOperationLogPageData(operationLogQueryParam);
var temp = pageData.Select(o => new
{
o.UName,
o.ActionType,
o.ActionName,
o.OperationObj,
o.Id,
o.SubTime
});
var data = new { code = 0, msg = "", count = operationLogQueryParam.Total, data = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
