public static DbConnection_My MyGetRemoteDataInstance()
{
if (remoteInstance == null || string.IsNullOrEmpty(remoteInstance.remoteConn.Database))
{
remoteInstance = new DbConnection_My();
}
return(remoteInstance);
}
private void button1_Click(object sender, EventArgs e)
{
MYconn = DbConnection_My.MyGetRemoteDataInstance().MygetRemoteDbConnection("124");
formstimer.Interval = 1000;
formstimer.Tick += timer_sales_Tick;
formstimer.Start();
safe_sale_timer.Interval = 1000;
safe_sale_timer.Tick += timer_safe_sale_Tick;
safe_sale_timer.Start();
if (MYconn.State.ToString() == "Open")
{
string DB_124 = MYconn.DataSource.ToString();
if (DB_124 != "")
{
checkBox1.Checked = true;
}
}
else
{
checkBox1.Checked = false;
}
MYconn.Dispose();
MYconn.Close();
Log((String.Format("[MySql_124]:{0}", MYconn.State.ToString())));
MYconn = DbConnection_My.MyGetRemoteDataInstance().MygetRemoteDbConnection("164");
if (MYconn.State.ToString() == "Open")
{
string DB_164 = MYconn.DataSource.ToString();
if (DB_164 != "")
{
checkBox2.Checked = true;
}
}
else
{
checkBox2.Checked = false;
}
MYconn.Dispose();
MYconn.Close();
Log((String.Format("[MySql_164]:{0}", MYconn.State.ToString())));
MYconn = DbConnection_My.MyGetRemoteDataInstance().MygetRemoteDbConnection("18");
if (MYconn.State.ToString() == "Open")
{
string DB_18 = MYconn.DataSource.ToString();
if (DB_18 != "")
{
checkBox3.Checked = true;
}
}
else
{
checkBox3.Checked = false;
}
MYconn.Dispose();
MYconn.Close();
Log((String.Format("[MySql_18]:{0}", MYconn.State.ToString())));
if ((checkBox1.Checked == true) && (checkBox2.Checked == true) && (checkBox3.Checked == true))
{
label2.ForeColor = System.Drawing.Color.Blue;
label2.Text = "정상 접속 성공";
sendSms("[2차 시뮬레이션 판매예측값] 프로그램 시작 ");
}
else
{
label2.ForeColor = System.Drawing.Color.Red;
label2.Text = "접속 오류";
}
}
