public void ScanDatabase() { while (!mShutdown) { //if (mConnect || !mRunn) //{ // break; //} DB_TYPE NewDB = GetSelectServerDb(); if (mCurrentDB != NewDB) { mConnect = false; mCurrentDB = NewDB; if (mCurrentDB != DB_TYPE.DB_None) { Reconnect(); } } else { if (mCurrentDB != DB_TYPE.DB_None) { mIsConnectedDB = GetConnectServer(mCurrentDB); mIsMasterDB = GetIsMaster(mCurrentDB); if (!mIsConnectedDB) { mCurrentDB = DB_TYPE.DB_None; mConnect = false; Reconnect(); } } } Thread.Sleep(5000); } }
public Database(frmMain f) { //fMain = new frmMain(); fMain = f; //mConnOracle = new OracleConnection(); logFile = new Logfile(); mIni = new IniLib.CINI(); currentDB = DB_TYPE.DB_None; //ScanDatabase(); StartThread(); }
public cOracle(frmCRBay f) { //fMain = new frmMain(); mFMercury = f; //mConnOracle = new OracleConnection(); mLog = new clogfile(); mIni = new IniLib.CINI(); mCurrentDB = DB_TYPE.DB_None; //ScanDatabase(); StartThread(); }
DB_TYPE SelectServer() { //string ret = mIni.INIRead(mPathIni, "SELECT", "SERVER", ""); //string ret = "0"; //return DB_TYPE.DB_MASTER; //switch (Convert.ToInt16(ret)) //{ // case 0: // return DB_TYPE.DB_MASTER; // case 1: // return DB_TYPE.DB_SUBMASTER; //} //return DB_TYPE.DB_None; DB_TYPE ret = DB_TYPE.DB_MASTER; return(ret); }
bool GetIsMaster(DB_TYPE pServer) { string ret = "0"; switch (pServer) { case DB_TYPE.DB_None: ret = "0"; break; case DB_TYPE.DB_MASTER: ret = mIni.INIRead(mPathIni, "MASTER", "ISMASTER", ""); break; case DB_TYPE.DB_SUBMASTER: ret = mIni.INIRead(mPathIni, "SUBMASTER", "ISMASTER", ""); break; } return(Convert.ToBoolean(Convert.ToInt16(ret))); }
public void ScanActiveDatabase() { while (!shutdown) { //if (mConnect || !mRunn) //{ // break; //} DB_TYPE NewDB = SelectServer(); if (currentDB != NewDB) { _IsConnect = false; currentDB = NewDB; if (currentDB != DB_TYPE.DB_None) { Reconnect(); } else { Addlistbox("Database disconnect."); } } else { if (currentDB != DB_TYPE.DB_None) { //isConnectedDB = GetConnectServer(currentDB); //isMasterDB = GetIsMaster(currentDB); //if ((!isConnectedDB) || (!oraConnect)) if (!_IsConnect) { //currentDB = DB_TYPE.DB_None; Addlistbox("Database disconnect."); _IsConnect = false; Reconnect(); } } } Thread.Sleep(5000); } }
bool GetConnectServer(DB_TYPE pServer) { string ret = "0"; return(true); switch (pServer) { case DB_TYPE.DB_None: ret = "0"; break; case DB_TYPE.DB_MASTER: //ret = mIni.INIRead(mPathIni, "MASTER", "CONNECT", ""); break; case DB_TYPE.DB_BACKUP: //ret = mIni.INIRead(mPathIni, "SUBMASTER", "CONNECT", ""); break; } return(Convert.ToBoolean(Convert.ToInt16(ret))); }
private void RunProcess() { //Thread.Sleep(500); while (true) { if (mCurrentDB == DB_TYPE.DB_None) { mCurrentDB = GetSelectServerDb(); } if (mCurrentDB != DB_TYPE.DB_None) { //Reconnect(); //if (mConnect || mShutdown) if (mConnect || !mRunn) { break; } Reconnect(); } System.Threading.Thread.Sleep(10000); } Thread.Sleep(1000); mRunning = false; }
public SqlSqlUtil(DB_TYPE dbType) : base(dbType) { }
DB_TYPE SelectServer() { DB_TYPE ret = DB_TYPE.DB_MASTER; return(ret); }
public NpgSqlUtil(DB_TYPE dbType) : base(dbType) { }
/// <summary> /// /// </summary> /// <param name="dbType"></param> public BaseSqlUtil(DB_TYPE dbType) { this.dbType = dbType; }
public OracleSqlUtil(DB_TYPE dbType) : base(dbType) { }