public bool CheckMySqlConnection()
{
bool result = false;
_checkStep = ServerCheckStep.MySqlPing;
try
{
OnWriteLog("MySql 서버 접속테스트...");
handler.Open();
result = handler.Ping();
if (result)
{
OnWriteLog("MySql 서버 접속테스트 성공");
}
else
{
OnWriteLog("MySql 서버 접속테스트 실패");
}
}
catch (Exception e)
{
OnWriteLog("MySql 서버 접속테스트 에러 : " + e.ToString());
}
finally
{
handler.Close();
}
return result;
}
/// <summary>
///3. 8882로 전송
///4. 8883이 대기 및 수신
/// </summary>
/// <returns></returns>
public bool CheckBasicConnection()
{
_checkStep = ServerCheckStep.WDServerPing;
_socHandler.SendUDP(8883, "127.0.0.1", 8882, "8881전송테스트");
return true;
}
public bool SetWDServerFirewall()
{
MsgrLogger.WriteLog("WeDoServer방화벽 등록...");
_checkStep = ServerCheckStep.WDServerFirewallCheck;
return _fwManager.AddProgram(WEDO_SERVER_NAME, WEDO_SERVER);
}
public bool ReleaseWDServerFirewall()
{
MsgrLogger.WriteLog("WeDoServer방화벽 등록해제...");
_checkStep = ServerCheckStep.WDServerFirewallCheck;
return _fwManager.RemoveProgram(WEDO_SERVER);
}
public bool SetMySqlFirewall()
{
MsgrLogger.WriteLog("MySql port 방화벽 등록...");
_checkStep = ServerCheckStep.MySqlFirewallCheck;
return _fwManager.AddProgram(WEDO_MYSQL_NAME, WEDO_MYSQL);
}
public bool ReleaseMySqlFirewall()
{
MsgrLogger.WriteLog("MySql port 방화벽 등록해제...");
_checkStep = ServerCheckStep.MySqlFirewallCheck;
return _fwManager.RemoveProgram(WEDO_MYSQL);
}
/// <summary>
/// 방화벽 활성화/비활성화 확인
/// </summary>
/// <returns></returns>
public bool IsFirewallEnabled()
{
MsgrLogger.WriteLog("방화벽 활성화 체크...");
_checkStep = ServerCheckStep.MySqlFirewallCheck;
string fwStatus = "";
if (_fwManager.IsFirewallEnabled())
{
fwStatus = "방화벽활성화상태";
}
else
{
fwStatus = "방화벽비활성화상태";
}
MsgrLogger.WriteLog("===>"+fwStatus);
return _fwManager.IsFirewallEnabled();
}
/// <summary>
/// 1. t_company
/// 2. t_user
/// 3. t_l_code
/// 4. t_s_code
/// </summary>
/// <returns></returns>
public string GetCompanyCd()
{
string result = null;
_checkStep = ServerCheckStep.MySqlComCd;
string sql = null;
DataTable dt = null;
try
{
OnWriteLog("회사코드 확인.");
handler.Open();
//t_company
sql = "select com_cd, com_nm from t_company";
handler.SetQuery(sql);
OnWriteLog("실행쿼리문:"+sql);
dt = handler.DoQuery();
foreach (DataRow dr in dt.Rows)
{
result += dr["com_cd"].ToString() + ":" + dr["com_nm"].ToString();
OnWriteLog(string.Format("회사코드[{0}]회사명[{1}]", dr["com_cd"].ToString(), dr["com_nm"].ToString()));
}
//t_user
sql = "select com_cd, user_id, user_nm from t_user";
handler.SetQuery(sql);
OnWriteLog("실행쿼리문:" + sql);
dt = handler.DoQuery();
foreach (DataRow dr in dt.Rows)
{
result += dr["com_cd"].ToString() + ":" + dr["user_id"].ToString() + ":" + dr["user_nm"].ToString();
OnWriteLog(string.Format("회사코드[{0}]사용자ID[{1}]사용자명[{2}]", dr["com_cd"].ToString(), dr["user_id"].ToString(), dr["user_nm"].ToString()));
}
//t_l_code
sql = "select com_cd, l_menu_cd, l_menu_nm from t_l_code";
handler.SetQuery(sql);
OnWriteLog("실행쿼리문:" + sql);
dt = handler.DoQuery();
foreach (DataRow dr in dt.Rows)
{
result += dr["com_cd"].ToString() + ":" + dr["l_menu_cd"].ToString() + ":" + dr["l_menu_nm"].ToString();
OnWriteLog(string.Format("회사코드[{0}]코드[{1}]코드명[{2}]", dr["com_cd"].ToString(), dr["l_menu_cd"].ToString(), dr["l_menu_nm"].ToString()));
}
//t_s_code
sql = "select com_cd, l_menu_cd, s_menu_cd, s_menu_nm from t_s_code";
handler.SetQuery(sql);
OnWriteLog("실행쿼리문:" + sql);
dt = handler.DoQuery();
foreach (DataRow dr in dt.Rows)
{
result += dr["com_cd"].ToString() + ":" + dr["l_menu_cd"].ToString() + ":" + dr["s_menu_cd"].ToString() + ":" + dr["s_menu_nm"].ToString();
OnWriteLog(string.Format("회사코드[{0}]코드[{1}]코드명[{2}]", dr["com_cd"].ToString(), dr["s_menu_cd"].ToString(), dr["s_menu_nm"].ToString()));
}
}
catch (Exception e)
{
OnWriteLog("회사코드 확인 에러 : " + e.ToString());
}
finally
{
handler.Close();
}
return result;
}
//클라이언트 방화벽 확인
//1. WDMsg_Client.exe
//2. 각종유틸
// ==> 상태확인
public string CheckWDServerFirewallStatus()
{
MsgrLogger.WriteLog("WeDoServer방화벽 체크중...");
_checkStep = ServerCheckStep.WDServerFirewallCheck;
return _fwManager.GetByProgramPath(WEDO_SERVER);
}
public string CheckMySqlFirewallStatus()
{
MsgrLogger.WriteLog("MySql 방화벽 체크중...");
_checkStep = ServerCheckStep.MySqlFirewallCheck;
return _fwManager.GetByProgramPath(WEDO_MYSQL);
}
