/// <summary> /// 获取数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="total"></param> /// <param name="w_totalTime"></param> /// <returns></returns> public static List <SyLogMonitorList> SyLogMonitor_GetList(int pageIndex, int pageSize, out int total, decimal?w_totalTime, string controller) { total = 0; using (var db = new fz_bigdataEntities()) { IQueryable <log_operation> dbList = db.log_operation.OrderByDescending(o => o.CreateTime).AsQueryable(); if (!string.IsNullOrWhiteSpace(controller)) { dbList = dbList.Where(w => w.ControllerName == controller); } if (w_totalTime != null) { dbList = dbList.Where(w => w.TotalTime > w_totalTime); } total = dbList.Count(); return(dbList.Skip((pageIndex - 1) * pageSize).Take(pageSize).Select(s => new SyLogMonitorList { Id = s.Id, DType = s.Type, ControllerName = s.ControllerName, ActionName = s.ActionName, HttpMethod = s.HttpMethod, Url = s.Url, ResponseTime = s.ResponseTime, RenderTime = s.RenderTime, TotalTime = s.TotalTime, CreateIp = s.CreateIp, CreateTime = s.CreateTime, CreateUserId = s.CreateUserId, CreateUserName = s.CreateUserName, CreateAccount = s.CreateAccount }).ToList()); } }
/// <summary> /// 写监控 /// </summary> /// <param name="m"></param> /// <param name="dtype"></param> private static async Task SyLogMonitor_Add(SyLogMonitorAdd m, int dtype) { await Task.Run(() => { try { using (var db = new fz_bigdataEntities()) { db.log_operation.Add(new log_operation { Id = Guid.NewGuid().ToString(), Type = dtype, ControllerName = m.ControllerName, ActionName = m.ActionName, HttpMethod = m.HttpMethod, Url = m.Url, ResponseTime = m.ResponseTime, RenderTime = m.RenderTime, TotalTime = m.ResponseTime + m.RenderTime, CreateIp = m.CreateIp, CreateUserId = m.CreateUserId, CreateUserName = m.CreateUserName, CreateAccount = m.CreateAccount, CreateTime = DateTime.Now }); db.SaveChanges(); } } catch (Exception e) { LogHelper.WriteLog(string.Format("{0}", DateTime.Now), e); } }); }
/// <summary> /// 获取Error数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="total"></param> /// <returns></returns> public static List <SyLogErrorList> SyLogError_GetList(int pageIndex, int pageSize, out int total, string controller) { total = 0; using (var db = new fz_bigdataEntities()) { IQueryable <log_error> dbList = db.log_error.OrderByDescending(o => o.CreateTime); if (!string.IsNullOrWhiteSpace(controller)) { dbList = dbList.Where(w => w.ControllerName == controller); } total = dbList.Count(); return(dbList.Skip((pageIndex - 1) * pageSize).Take(pageSize).Select(s => new SyLogErrorList { Id = s.Id, DType = s.Type, ControllerName = s.ControllerName, ActionName = s.ActionName, HttpMethod = s.HttpMethod, Url = s.Url, Message = s.Message, CreateIp = s.CreateIp, CreateTime = s.CreateTime, CreateUserId = s.CreateUserId, CreateUserName = s.CreateUserName, CreateAccount = s.CreateAccount }).ToList()); } }
/// <summary> /// 获取智慧校园操作日志 /// </summary> /// <param name="sdate"></param> /// <param name="edate"></param> /// <returns></returns> public static List <RoomLogList> ClrLogMonitorWeb_GetListAll(DateTime?sdate, DateTime?edate) { DateTime _sdate = DateTime.Parse("1900-01-01"); DateTime _edate = DateTime.Parse("1900-01-01"); if (sdate != null) { _sdate = ((DateTime)sdate).Date; } if (edate != null) { _edate = ((DateTime)edate).Date; } using (var db = new fz_bigdataEntities()) { IQueryable <data_room_log_operation> dbList = db.data_room_log_operation.OrderByDescending(o => o.CreateTime); if (sdate != null) { dbList = dbList.Where(w => System.Data.Entity.DbFunctions.TruncateTime(w.CreateTime) >= _sdate); } if (edate != null) { dbList = dbList.Where(w => System.Data.Entity.DbFunctions.TruncateTime(w.CreateTime) <= _edate); } return(dbList.Select(s => new RoomLogList { Id = s.Id, CreateTime = s.CreateTime, CreateUserId = s.CreateUserId, CreateUserType = s.CreateUserType, OperId = s.OperId, OperContent = s.OperContent }).ToList()); } }
public void Post([FromBody] Operator operatorInfo) { try { using (var db = new fz_bigdataEntities()) { data_room_log_operation roomlog = new data_room_log_operation(); roomlog.Id = Guid.NewGuid().ToString(); roomlog.CreateUserId = operatorInfo.userId; roomlog.CreateUserType = operatorInfo.userType; roomlog.OperId = operatorInfo.OperId; roomlog.OperContent = operatorInfo.content; roomlog.CreateTime = DateTime.Now; db.data_room_log_operation.Add(roomlog); db.SaveChanges(); } } catch (Exception e) { LogHelper.WriteLog(string.Format("{0}", DateTime.Now), e); } }