/// <summary> /// 详情 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Detail(int id) { TLogsDebugLog debugLog = null; var rs = _debugLogService.GetDebugLogById(id); if (rs.ReturnCode == ReturnCodeType.Success) { debugLog = rs.Content; } return(View(debugLog)); }
/// <summary> /// 插入 /// </summary> /// <param name="item">待插入的记录</param> public bool Insert(TLogsDebugLog item) { using (var conn = DapperHelper.CreateConnection()) { var effectRows = conn.Execute(@"INSERT INTO dbo.t_logs_debug_log VALUES (@SystemCode ,@Source ,@MachineName ,@IpAddress ,@ProcessId ,@ProcessName ,@ThreadId,@ThreadName ,@AppdomainName ,@CreatedTime ,@Detail ,@Message, @ClientIp);", item); if (effectRows > 0) { return(true); } } return(false); }
/// <summary> /// 依id查询 /// </summary> /// <param name="id">id</param> /// <returns></returns> public TLogsDebugLog GetById(int id) { TLogsDebugLog result = null; using (var conn = DapperHelper.CreateConnection()) { result = conn.Query <TLogsDebugLog>(@"SELECT debugLogs.system_code AS SystemCode , debugLogs.machine_name AS MachineName , debugLogs.ip_address AS IpAddress , debugLogs.client_ip AS ClientIp, debugLogs.process_id AS ProcessId , debugLogs.process_name AS ProcessName , debugLogs.thread_id AS ThreadId , debugLogs.thread_name AS ThreadName , debugLogs.appdomain_name AS AppdomainName , debugLogs.created_time AS CreatedTime , * FROM dbo.t_logs_debug_log AS debugLogs WHERE debugLogs.id = @Id;", new { @Id = id }).FirstOrDefault(); } return(result); }
/// <summary> /// 插入调试日志(批量) /// </summary> /// <param name="list"></param> /// <returns></returns> public ServiceResult <bool> AddDebugLogs(List <AddDebugLogRequest> list) { var result = new ServiceResult <bool> { ReturnCode = ReturnCodeType.Error }; if (!list.HasValue()) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; return(result); } //黑名单过滤 var matchedDebugLogs = new List <AddDebugLogRequest>(); var debugLogBlackListCacheKey = "Log.Cache.DebugLogBlackList"; var debugLogBlackList = CacheHelper.Get(debugLogBlackListCacheKey) as List <TLogsDebugLogBlackList>; if (debugLogBlackList == null) { debugLogBlackList = _debugLogBlackListDao.GetAll(); CacheHelper.Set(debugLogBlackListCacheKey, debugLogBlackList); } if (debugLogBlackList.HasValue()) { foreach (var debugLog in list) { var isMatchBlackList = IsMatchDebugLogBlackList(debugLog, debugLogBlackList); if (isMatchBlackList) { matchedDebugLogs.Add(debugLog); } } } list = list.Except(matchedDebugLogs).ToList(); if (!list.HasValue()) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; return(result); } //EmitMapper对象映射 var insertedDebugLogs = new List <TLogsDebugLog>(); TLogsDebugLog insertedDebugLog = null; foreach (var debugLog in list) { var mapper = ObjectMapperManager.DefaultInstance.GetMapper <AddDebugLogRequest, TLogsDebugLog>(); insertedDebugLog = mapper.Map(debugLog); insertedDebugLogs.Add(insertedDebugLog); } var rs = _debugLogDao.BatchInsert(insertedDebugLogs); if (rs == true) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; } return(result); }