/// <summary>
/// 通过查询条件获取日志信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <Business_OperationLog> GetLogListBySearch(SearchLogList searchParam, GridParams para)
{
using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance())
{
JsonResultModel <Business_OperationLog> jsonResult = new JsonResultModel <Business_OperationLog>();
var listUser = _dbMsSql.Queryable <Sys_User>().Select(i => i.LoginName).ToList();
var query = _dbMsSql.Queryable <Business_OperationLog>().Where(i => listUser.Contains(i.CreatedUser));
if (!string.IsNullOrEmpty(searchParam.EventType))
{
query.Where(c => c.EventType != "查询" && c.EventType != "错误异常" && c.EventType.Contains(searchParam.EventType));//事件类型
}
else
{
query.Where(c => c.EventType != "查询" && c.EventType != "错误异常");
}
if (!string.IsNullOrEmpty(searchParam.LogUser))
{
query.Where(c => c.LogUser.Contains(searchParam.LogUser));//用户
}
if (searchParam.BeginDate.ToString() != "0001/1/1 0:00:00" && searchParam.EndDate.ToString() != "0001/1/1 0:00:00")
{
query.Where(c => c.CreatedDate > searchParam.BeginDate && c.CreatedDate < searchParam.EndDate);
}
else
{
if (searchParam.BeginDate.ToString() != "0001/1/1 0:00:00")
{
query.Where(c => c.CreatedDate > searchParam.BeginDate);
}
if (searchParam.EndDate.ToString() != "0001/1/1 0:00:00")
{
query.Where(c => c.CreatedDate < searchParam.EndDate);
}
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize);
//存入操作日志表
string logData = JsonHelper.ModelToJson <JsonResultModel <Business_OperationLog> >(jsonResult);
return(jsonResult);
}
}
/// <summary>
/// 通过查询条件获取日志信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetLogListBySearch(SearchLogList searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "CreatedDate";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;//页0，+1
var model = _lb.GetLogListBySearch(searchParam, para);
// return Json(model, JsonRequestBehavior.AllowGet);
var result = new ConfigurableJsonResult()
{
Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
return(result);
}
/// <summary>
/// 通过查询条件获取日志信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <Business_OperationLog> GetLogListBySearch(SearchLogList searchParam, GridParams para)
{
return(_ls.GetLogListBySearch(searchParam, para));
}
