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));
}
