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); } }
public static void LoadClusterConfig() { try { SqlHelper.ExcuteSql(CoreGlobalConfig.PlatformManageConnectString, (c) => { tb_cluster_dal clusterdal = new tb_cluster_dal(); var clustermodel = clusterdal.GetNewByServerip(c, ServerIP, LoadClusterConfigTime); if (clustermodel != null) { LoadClusterConfigTime = c.GetServerDate(); ClusterModel = clustermodel; } tb_keyvalue_config_dal keyvalueconfigdal = new tb_keyvalue_config_dal(); MonitorCollectBackgroundTaskSleepTime = Convert.ToInt32(keyvalueconfigdal.Get(c, "MonitorCollectBackgroundTaskSleepTime").value); PerformanceCollectBackgroundTaskSleepTime = Convert.ToInt32(keyvalueconfigdal.Get(c, "PerformanceCollectBackgroundTaskSleepTime").value); ConfigUpdateBackgroundTaskSleepTime = Convert.ToInt32(keyvalueconfigdal.Get(c, "ConfigUpdateBackgroundTaskSleepTime").value); OnLineTimeBackgroundTaskSleepTime = Convert.ToInt32(keyvalueconfigdal.Get(c, "OnLineTimeBackgroundTaskSleepTime").value); }); } catch (Exception exp) { LogHelper.Error(string.Format("服务器[id:{0}] ", GlobalConfig.ServerIP.NullToEmpty()) + "LoadClusterConfig", exp); } }
public ActionResult Update(int id) { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_keyvalue_config_model model = new tb_keyvalue_config_dal().Get(PubConn, id); return(View(model)); } }
public JsonResult Delete(int id) { try { tb_keyvalue_config_dal dal = new tb_keyvalue_config_dal(); using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); dal.Delete(PubConn, id); return(Json(new { code = 1, msg = "Success" })); } } catch (Exception ex) { return(Json(new { code = -1, msg = ex.Message })); } }
public ActionResult Update(tb_keyvalue_config_model model) { tb_keyvalue_config_dal dal = new tb_keyvalue_config_dal(); try { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); dal.Edit(PubConn, model); return(RedirectToAction("index")); } } catch (Exception ex) { ModelState.AddModelError("Error", ex.Message); return(View(model)); } }
// // GET: /Manage/Config/ public ActionResult Index(string keyword, int pageindex = 1, int pagesize = 10) { ViewBag.keyword = keyword; ViewBag.pagesize = pagesize; ViewBag.pageindex = pageindex; tb_keyvalue_config_dal dal = new tb_keyvalue_config_dal(); PagedList <tb_keyvalue_config_model> pageList = null; int count = 0; using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); List <tb_keyvalue_config_model> List = dal.GetList(PubConn, keyword, pagesize, pageindex, out count); pageList = new PagedList <tb_keyvalue_config_model>(List, pageindex, pagesize, count); } if (Request.IsAjaxRequest()) { return(PartialView("List", pageList)); } return(View(pageList)); }