public static void Error(string msg, Exception exp) { try { LoadConnectString(); if (exp == null) { exp = new Exception(); } SqlHelper.ExcuteSql(UnityLogConnectString, (c) => { tb_error_log_dal dal = new tb_error_log_dal(); dal.Add(c, new tb_error_log_model() { logcreatetime = DateTime.Now, developer = "车江毅", logtag = "统一监控平台系统异常", logtype = (int)XXF.BaseService.Monitor.SystemRuntime.EnumErrorLogType.SystemError, msg = msg + "【原始信息】" + exp.Message.NullToEmpty(), projectname = "统一监控平台", remark = "", tracestack = exp.StackTrace }); }); Debug.WriteLine(msg + exp.Message); XXF.Log.ErrorLog.Write(msg, exp); } catch (Exception e) { XXF.Log.ErrorLog.Write(msg, e); } }
public static void Error(string logtag, string msg, string projectname) { try { LoadConnectString(); SqlHelper.ExcuteSql(UnityLogConnectString, (c) => { tb_error_log_dal dal = new tb_error_log_dal(); dal.AddError(c, new tb_error_log_model() { logcreatetime = DateTime.Now, developer = "", logtag = logtag, logtype = (int)XXF.BaseService.Monitor.SystemRuntime.EnumErrorLogType.SystemError, msg = msg, projectname = projectname + "【监控平台】", remark = "", tracestack = "" }); }); } catch (Exception exp) { XXF.Log.ErrorLog.Write("LogHelper.Error", exp); } }
public override void Run() { GlobalConfig.MonitorPlatformManageConnectString = AppConfig["MonitorPlatformManageConnectString"]; int EveryGrowErrorNum = Convert.ToInt32(AppConfig["EveryGrowErrorNum"]); SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_database_config_dal dal = new tb_database_config_dal(); var list = dal.GetModelList(c); UnityLogConnectString = XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.GetDataBase(list, XXF.BaseService.Monitor.SystemRuntime.DataBaseType.UnityLog); }); int errornum = 0; SqlHelper.ExcuteSql(UnityLogConnectString, (c) => { tb_error_log_dal dal = new tb_error_log_dal(); errornum = dal.GetGrawErrorNum(c, lastscantime); }); if (errornum > EveryGrowErrorNum) { TaskLogHelper.Error("错误预警任务", string.Format("【{0}】-【{1}】期间平台错误日志增加{2}条", lastscantime, DateTime.Now, errornum), "错误预警任务"); } lastscantime = DateTime.Now; }
public override void Run() { GlobalConfig.MonitorPlatformManageConnectString = AppConfig["MonitorPlatformManageConnectString"]; SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_database_config_dal dal = new tb_database_config_dal(); var list = dal.GetModelList(c); UnityLogConnectString = XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.GetDataBase(list, XXF.BaseService.Monitor.SystemRuntime.DataBaseType.UnityLog); }); List <tb_user_model> users = new List <tb_user_model>(); SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_user_dal dal = new tb_user_dal(); users = dal.GetAllUsers(c); }); foreach (var u in users) { if (!string.IsNullOrWhiteSpace(u.useremail)) { if (u.lastsenderrortime.AddMinutes(u.errorsendintervaltime) < DateTime.Now) { List <tb_error_log_model> errors = new List <tb_error_log_model>(); SqlHelper.ExcuteSql(UnityLogConnectString, (c) => { tb_error_log_dal dal = new tb_error_log_dal(); if (u.userrole == (byte)XXF.BaseService.Monitor.SystemRuntime.EnumUserRole.Admin) { errors = dal.GetUserErrors(c, u.lastsenderrortime, "", "", 50); } else { errors = dal.GetUserErrors(c, u.lastsenderrortime, u.username.Trim(), u.userstaffno.Trim(), 50); } }); SendEmail(errors, u.useremail); SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_user_dal dal = new tb_user_dal(); dal.UpdateLastErrorSendTime(c, u.id, DateTime.Now); }); } } } }
// // GET: /UnityLog/ErrorLog/ public ActionResult Index(string id, string keyword, string month, string timebegin, string timeend, string projectname, int logtype = -1, int pageindex = 1, int pagesize = 10) { ViewBag.keyword = keyword; ViewBag.logtype = logtype; ViewBag.projectname = projectname; ViewBag.id = id; if (!string.IsNullOrWhiteSpace(timebegin)) { ViewBag.timebegin = DateTime.Parse(timebegin); } else { ViewBag.timebegin = DateTime.Now.Date; } if (!string.IsNullOrWhiteSpace(timeend)) { ViewBag.timeend = DateTime.Parse(timeend); } else { ViewBag.timeend = DateTime.Now.Date.AddDays(1); } tb_error_log_dal dal = new tb_error_log_dal(); PagedList <tb_error_log_model> pageList = null; int count = 0; using (DbConn PubConn = DbConfig.CreateConn(Config.UnityLogConnectString)) { PubConn.Open(); List <tb_error_log_model> List = new List <tb_error_log_model>(); try { List = dal.GetList(PubConn, id, keyword, ViewBag.timebegin, ViewBag.timeend, logtype, projectname, pagesize, pageindex, out count); } catch { List = new List <tb_error_log_model>(); } pageList = new PagedList <tb_error_log_model>(List, pageindex, pagesize, count); } if (Request.IsAjaxRequest()) { return(PartialView("List", pageList)); } return(View(pageList)); }
public static void AddErrorLog(ErrorLogInfo log) { if (XXF.Common.XXFConfig.IsWriteErrorLog && XXF.Common.XXFConfig.IsWriteErrorLogToMonitorPlatform) { try { if (!string.IsNullOrWhiteSpace(Config.UnityLogConnectString)) { SqlHelper.ExcuteSql(Config.UnityLogConnectString, (c) => { tb_error_log_dal errorlogdal = new tb_error_log_dal(); errorlogdal.Add(c, log); }); logbatchqueue.Add(new CommonLogInfo() { logcreatetime = log.logcreatetime, logtag = log.logtag, logtype = log.logtype, msg = log.msg.SubString2(900).NullToEmpty(), projectname = log.projectname }); } } catch (Exception exp) { } } }