示例#1
0
 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);
     }
 }
示例#2
0
 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();
 }
示例#3
0
 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();
 }
示例#4
0
        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);
        }
示例#5
0
        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)));
        }
示例#6
0
 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);
     }
 }
示例#7
0
        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)));
        }
示例#8
0
 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;
 }
示例#9
0
 public SqlSqlUtil(DB_TYPE dbType)
     : base(dbType)
 {
 }
示例#10
0
        DB_TYPE SelectServer()
        {
            DB_TYPE ret = DB_TYPE.DB_MASTER;

            return(ret);
        }
示例#11
0
 public NpgSqlUtil(DB_TYPE dbType)
     : base(dbType)
 {
 }
示例#12
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="dbType"></param>
 public BaseSqlUtil(DB_TYPE dbType)
 {
     this.dbType = dbType;
 }
示例#13
0
 public OracleSqlUtil(DB_TYPE dbType)
     : base(dbType)
 {
 }