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 bool CreateTable(out Dictionary <string, Exception> errordic) { errordic = new Dictionary <string, Exception>(); Dictionary <string, string> configDic = new Dictionary <string, string>(); List <tb_database_config_model> databaseList = new List <tb_database_config_model>(); tb_database_config_dal databaseDal = new tb_database_config_dal(); DateTime dateNow = new DateTime(); using (DbConn PubConn = DbConfig.CreateConn(XXFConfig.MonitorPlatformConnectionString)) { PubConn.Open(); dateNow = PubConn.GetServerDate(); configDic = new tb_keyvalue_config_dal().GetAll(PubConn); databaseList = databaseDal.GetModelList(PubConn); } if (configDic.Count > 0) { if (databaseList.Count > 0) { string dayTableSuffix = dateNow.ToString("yyyyMMdd"); string dayTableSuffixNext = dateNow.AddDays(1).ToString("yyyyMMdd"); string monthTableSuffix = dateNow.ToString("yyyyMM"); string monthTableSuffixNext = dateNow.AddMonths(1).ToString("yyyyMM"); foreach (tb_database_config_model m in databaseList) { string Connection = databaseDal.ReplaceConnectStringTemplate(m); using (DbConn PubConn = DbConfig.CreateConn(Connection)) { PubConn.Open(); try { if (m.dbtype == (int)DataBaseType.Cluster) { CreateDayTable(PubConn, "tb_performance_collect", configDic["CreatePerCollectTable"], dayTableSuffix, dayTableSuffixNext); } if (m.dbtype == (int)DataBaseType.Timewatch) { CreateDayTable(PubConn, "tb_timewatchlog_api", configDic["CreateTimeWatchApiLogTable"], dayTableSuffix, dayTableSuffixNext); CreateDayTable(PubConn, "tb_timewatchlog", configDic["CreateTimeWatchLogTable"], dayTableSuffix, dayTableSuffixNext); } if (m.dbtype == (int)DataBaseType.UnityLog) { CreateMonthTable(PubConn, "tb_error_log", configDic["CreateErrorLogTable"], monthTableSuffix, monthTableSuffixNext); CreateMonthTable(PubConn, "tb_log", configDic["CreateLogTable"], monthTableSuffix, monthTableSuffixNext); } } catch (Exception ex) { errordic.Add("创建表失败|连接" + Connection, ex); } } } } return(true); } else { return(false); } }
private static void LoadConnectString() { if (string.IsNullOrWhiteSpace(UnityLogConnectString)) { SqlHelper.ExcuteSql(CoreGlobalConfig.PlatformManageConnectString, (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); }); } }
static Config() { try { SqlHelper.ExcuteSql(XXF.Common.XXFConfig.MonitorPlatformConnectionString, (c) => { tb_database_config_dal configdal = new tb_database_config_dal(); UnityLogConnectString = DbShardingHelper.GetDataBase(configdal.GetModelList(c), DataBaseType.UnityLog); }); } catch { } }
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); MonitorClusterConnectString = XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.GetDataBase(list, XXF.BaseService.Monitor.SystemRuntime.DataBaseType.Cluster); }); CheckMonitorInfoWarning(); if (lastclusterruntime.Date != DateTime.Now.Date && DateTime.Now.Hour > 18)//每天18点后运行,每天运行一次足矣。 { CheckPerformanceOfCluster(); lastclusterruntime = 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); }); } } } }
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); list.ForEach(o => { if (o.dbtype == (byte)XXF.BaseService.Monitor.SystemRuntime.DataBaseType.Timewatch) { var connectstring = XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.GetDataBase(o); CheckPerformanceOfApi(connectstring, o); CheckPerformanceOfSql(connectstring, o); } }); }); }
public static void LoadBaseConfig() { try { DataBaseConfigModels = new List <tb_database_config_model>(); SqlHelper.ExcuteSql(CoreGlobalConfig.PlatformManageConnectString, (c) => { tb_database_config_dal databasedal = new tb_database_config_dal(); var modellist = databasedal.GetModelList(c); if (modellist != null) { DataBaseConfigModels = modellist; } }); } catch (Exception exp) { LogHelper.Error(string.Format("服务器[id:{0}] ", GlobalConfig.ServerIP.NullToEmpty()) + "LoadBaseConfig", exp); } }