private void checkLogDB()
{
try
{
bool bok = DBTools4Mysql.checkLogTable();
}
catch (Exception ex) {
logger.Error(ex, "创建日志表失败");
MessageBox.Show(ex.Message);
}
}
private bool checkConfDB()
{
bool bok = false;
try
{
bok = DBTools4Mysql.checkConfigTable();
}
catch (Exception ex)
{
logger.Error(ex, "创建配置表失败");
MessageBox.Show(ex.Message);
}
return(bok);
}
private void TestDBLink(object sender, EventArgs e)
{
if (configM != null && !string.IsNullOrEmpty(CURR_DBConf))
{
if (string.IsNullOrEmpty(DBTools4Mysql.DBLink))
{
DBTools4Mysql.DBLink = CURR_DBConf;
}
string bgtime = DBTools4Mysql.GetSearchBgTime(configM.Sid);
MessageBox.Show(string.Format("获取到任务开始查询时间{0}", bgtime));
}
else
{
MessageBox.Show("没有数据库配置信息！");
}
}
private void GetServerConfigInfo(object sender, EventArgs e)
{
string url = tb_uri.Text;
if (string.IsNullOrEmpty(url) && string.IsNullOrWhiteSpace(url))
{
MessageBox.Show("请输入【服务器地址】");
return;
}
string configId = tb_conf_id.Text;
if (string.IsNullOrEmpty(configId) && string.IsNullOrWhiteSpace(configId))
{
MessageBox.Show("请输入【配置Id】");
return;
}
string queryparam = "type=400&sid=" + configId;
try
{
string res = Tools.HttpPostInfo(url + ICL.API_KEY, queryparam);
if (!string.IsNullOrWhiteSpace(res))
{
ResultInfo rInfo = JsonConvert.DeserializeObject <ResultInfo>(res);
if (rInfo.Data != null)
{
string conf = rInfo.Data["conf"];
configM = JsonConvert.DeserializeObject <DBConfigM>(conf);
string dbconf = configM.Dbconf;
if (string.IsNullOrWhiteSpace(dbconf))
{
MessageBox.Show("服务端没有数据库配置信息！");
return;
}
iniFile.IniWriteValue(ICL.DB_LAB, ICL.DB_DBLINK, configM.Dbconf);
iniFile.IniWriteValue(ICL.SERV_LAB, ICL.SERV_SCONF, Tools.EncodeBase64("UTF-8", JsonConvert.SerializeObject(configM)));
iniFile.IniWriteValue(ICL.SERV_LAB, ICL.SERV_URI, url);
iniFile.IniWriteValue(ICL.SERV_LAB, ICL.SERV_SID, configId);
CURR_URI = url;
CURR_DBConf = configM.Dbconf;
DBTools4Mysql.DBLink = CURR_DBConf;
bool bok = checkConfDB();
if (bok)
{
DBTools4Mysql.insertOrUpDate(configM.Sid, configM.Bgtime);
}
checkLogDB();
tb_conf_id.Enabled = false;
tb_uri.Enabled = false;
}
else
{
MessageBox.Show("没有获取到配置信息");
}
}
else
{
MessageBox.Show("没有获取到配置信息");
}
}
catch (Exception ex)
{
logger.Error(ex, "访问服务器失败");
MessageBox.Show(ex.Message);
}
}
