示例#1
0
 public DB_Access(string connString, ref LockArea lockArea, ref CPU_Monitor cpu, ref CtrlStation ctrl, bool var_disableStandBy)
 {
     this.i_monCpu       = cpu;
     this.i_ctrl         = ctrl;
     this.disableStandBy = var_disableStandBy;
     this.MyConnection   = new OdbcConnection(connString);
     this.MyconnString   = connString;
     if (this.i_ctrl.StandByAlive)
     {
         if (!this.disableStandBy)
         {
             this.tcpClientStandBy = new TcpClient(this.i_ctrl.standby_server, this.i_ctrl.standby_server_port);
             this.netStreamStandBy = this.tcpClientStandBy.GetStream();
         }
     }
     try
     {
         this.MyConnection.Open();
         this.setDateFormat();
     }
     catch (OdbcException ex)
     {
         throw new Exception(ex.Message);
     }
     this.m_lockArea = lockArea;
 }
示例#2
0
 public DB_Access(string connString, ref LockArea lockArea, ref CPU_Monitor cpu)
 {
     this.i_monCpu       = cpu;
     this.m_lockArea     = lockArea;
     this.disableStandBy = true;
     this.MyConnection   = new OdbcConnection(connString);
     this.MyconnString   = connString;
     try
     {
         this.MyConnection.Open();
         this.setDateFormat();
     }
     catch (OdbcException ex)
     {
         throw new Exception(ex.Message);
     }
 }
示例#3
0
 public DB_Access(ref DB_Access ac)
 {
     this.i_monCpu         = ac.i_monCpu;
     this.MyconnString     = ac.MyconnString;
     this.i_ctrl           = ac.i_ctrl;
     this.failSafe_archive = ac.failSafe_archive;
     if (this.i_ctrl.StandByAlive)
     {
         this.tcpClientStandBy = new TcpClient(this.i_ctrl.standby_server, this.i_ctrl.standby_server_port);
         this.netStreamStandBy = this.tcpClientStandBy.GetStream();
     }
     this.MyConnection = new OdbcConnection(this.MyconnString);
     try
     {
         this.MyConnection.Open();
         this.setDateFormat();
     }
     catch (OdbcException ex)
     {
         throw new Exception(ex.Message);
     }
     this.m_lockArea = ac.m_lockArea;
 }
示例#4
0
        public LoadAutomated(string connString, ref ListViewItem lstResults, int pos, string transact)
        {
            LockArea    m_lockArea = new LockArea();
            CPU_Monitor m_cpu      = new CPU_Monitor();
            DB_Access   m_access   = new DB_Access(connString, ref m_lockArea, ref m_cpu);

            string path = "Log" + pos.ToString() + ".txt";

            FileStream m_log_file;

            if (File.Exists(path))
            {
                m_log_file = new FileStream(path, FileMode.Truncate, FileAccess.Write);
            }
            else
            {
                m_log_file = new FileStream(path, FileMode.Create, FileAccess.Write);
            }

            StreamWriter  m_Log  = new StreamWriter(m_log_file);
            Communication m_Comm = new Communication();

            string session = "session";

            DateTime work_time    = new DateTime();
            double   lowest       = 0;
            double   percent      = (double)100 / 42;
            double   percent_done = 0;
            double   tim_result   = 0;

            {
                Thread.Sleep(1);
                tst_type_base type_base = new tst_type_base(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                type_base.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_cadastros fetch_cadastros = new tst_fetch_cadastros(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_cadastros.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_ins_cartaoProprietario ins_cartaoProprietario = new tst_ins_cartaoProprietario(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                ins_cartaoProprietario.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_proprietario fetch_proprietario = new tst_fetch_proprietario(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_proprietario.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_login exec_login = new tst_exec_login(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_login.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_logoff exec_logoff = new tst_exec_logoff(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_logoff.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_trocaSenha exec_trocaSenha = new tst_exec_trocaSenha(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_trocaSenha.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_ins_usuario ins_usuario = new tst_ins_usuario(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                ins_usuario.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaUsuarios fetch_listaUsuarios = new tst_fetch_listaUsuarios(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaUsuarios.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_usuarios fetch_usuarios = new tst_fetch_usuarios(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_usuarios.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_alteraUsuario exec_alteraUsuario = new tst_exec_alteraUsuario(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_alteraUsuario.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_ins_empresa ins_empresa = new tst_ins_empresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                ins_empresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_ins_loja ins_loja = new tst_ins_loja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                ins_loja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_dadosEmpresa fetch_dadosEmpresa = new tst_fetch_dadosEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_dadosEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_dadosLoja fetch_dadosLoja = new tst_fetch_dadosLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_dadosLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_loginWeb exec_loginWeb = new tst_exec_loginWeb(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_loginWeb.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_codEmpresa fetch_codEmpresa = new tst_fetch_codEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_codEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_alteraEmpresa exec_alteraEmpresa = new tst_exec_alteraEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_alteraEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_alteraLoja exec_alteraLoja = new tst_exec_alteraLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_alteraLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_codTerminal fetch_codTerminal = new tst_fetch_codTerminal(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_codTerminal.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_nomeEmpresa fetch_nomeEmpresa = new tst_fetch_nomeEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_nomeEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_validaEmpresa fetch_validaEmpresa = new tst_fetch_validaEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_validaEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_ins_terminal ins_terminal = new tst_ins_terminal(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                ins_terminal.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_terminais fetch_terminais = new tst_fetch_terminais(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_terminais.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaTerminais fetch_listaTerminais = new tst_fetch_listaTerminais(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaTerminais.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_codLoja fetch_codLoja = new tst_fetch_codLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_codLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaEmpresas fetch_listaEmpresas = new tst_fetch_listaEmpresas(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaEmpresas.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_terminalLoja fetch_terminalLoja = new tst_fetch_terminalLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_terminalLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_del_Terminal del_Terminal = new tst_del_Terminal(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                del_Terminal.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_consultaLoja fetch_consultaLoja = new tst_fetch_consultaLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_consultaLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaLoja fetch_listaLoja = new tst_fetch_listaLoja(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaLoja.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_consultaEmpresa fetch_consultaEmpresa = new tst_fetch_consultaEmpresa(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_consultaEmpresa.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_consultaAuditoria fetch_consultaAuditoria = new tst_fetch_consultaAuditoria(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_consultaAuditoria.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaAuditoria fetch_listaAuditoria = new tst_fetch_listaAuditoria(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaAuditoria.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_alteraTerminal exec_alteraTerminal = new tst_exec_alteraTerminal(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_alteraTerminal.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_limitesCartao fetch_limitesCartao = new tst_fetch_limitesCartao(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_limitesCartao.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_listaCartoes fetch_listaCartoes = new tst_fetch_listaCartoes(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_listaCartoes.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_exec_alteraCartao exec_alteraCartao = new tst_exec_alteraCartao(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                exec_alteraCartao.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_fetch_consultaCartao fetch_consultaCartao = new tst_fetch_consultaCartao(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                fetch_consultaCartao.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_infra_SchedulerDispatcher infra_SchedulerDispatcher = new tst_infra_SchedulerDispatcher(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                infra_SchedulerDispatcher.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_schedule_tst schedule_tst = new tst_schedule_tst(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                schedule_tst.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }

            {
                Thread.Sleep(1);
                tst_schedule_base schedule_base = new tst_schedule_base(ref m_Log, ref m_Comm, ref m_access, session, transact);
                work_time = DateTime.Now;
                schedule_base.Test();
                tim_result = -work_time.Subtract(DateTime.Now).TotalMilliseconds;
                if (tim_result > lowest)
                {
                    lowest = tim_result;
                }
                percent_done  += percent;
                lstResults.Tag = lowest;
                lstResults.SubItems[1].Text = String.Format("{0:n}", percent_done) + " %";
                lstResults.SubItems[2].Text = String.Format("{0:n}", lowest);
                Application.DoEvents();
            }


            m_Log.Flush();
            m_Log.Close();
            m_log_file.Close();
            m_cpu.StopMonit();
        }
示例#5
0
 public MainServer(string engineVersion, string master_server, string master_server_port, string connectionString, string DB_Machine, string language, string schema, int clientServerPort, int max_packet_size, ref ConnectionMonitor mon, ref LoadMonitor ldl, ref CPU_Monitor cpu, ref CtrlStation ctrl, Dispatcher transDisp, string db, string var_path, CustomRecept var_recept, ref Translator translator, string standby_server, string standby_server_web, string standby_server_port, string fail_fs, bool master_srv)
 {
     this.MasterMode       = master_srv;
     this.i_monConnections = mon;
     this.i_monDataLoad    = ldl;
     this.i_monCpu         = cpu;
     this.i_ctrl           = ctrl;
     this.var_translator   = translator;
     this.recept           = var_recept;
     if (!Directory.Exists(var_path + "\\LOG"))
     {
         Directory.CreateDirectory(var_path + "\\LOG");
     }
     this.m_var_path            = var_path;
     this.transactionDispatcher = transDisp;
     this.transactionDispatcher.language_default_index = language;
     this.m_engineVersion      = engineVersion;
     this.m_master_server      = master_server;
     this.m_master_server_port = master_server_port;
     this.m_connectionString   = connectionString;
     this.m_db_machine         = DB_Machine;
     this.m_schema             = schema;
     this.m_clientServerPort   = clientServerPort;
     this.m_max_packet_size    = max_packet_size;
     this.my_db     = db;
     this.m_fail_fs = fail_fs;
     if (this.m_fail_fs == "")
     {
         this.m_fail_fs = var_path + "\\failSafe.SQL";
     }
     else if ((int)this.m_fail_fs[this.m_fail_fs.Length - 1] != 92)
     {
         this.m_fail_fs += "\\failSafe.SQL";
     }
     else
     {
         this.m_fail_fs += "failSafe.SQL";
     }
     this.failSafeFile       = !File.Exists(this.m_fail_fs) ? new FileStream(this.m_fail_fs, FileMode.Create, FileAccess.Write) : new FileStream(this.m_fail_fs, FileMode.Truncate, FileAccess.Write);
     this.failSafe           = new StreamWriter((Stream)this.failSafeFile);
     this.failSafe.AutoFlush = true;
     if (this.MasterMode && standby_server.Length > 0)
     {
         this.i_ctrl.standby_server      = standby_server;
         this.i_ctrl.standby_server_web  = standby_server_web;
         this.i_ctrl.standby_server_port = Convert.ToInt32(standby_server_port);
         try
         {
             this.tcpClientStandBy = new TcpClient(standby_server, Convert.ToInt32(standby_server_port));
             this.netStreamStandBy = this.tcpClientStandBy.GetStream();
             if (this.WriteMsgToClient(ref this.netStreamStandBy, "STANDBYSQL_ALIVE"))
             {
                 if (this.ReceiveMsgFromClient(ref this.netStreamStandBy, this.m_max_packet_size) != "STANDBYSQL_ACCEPTED")
                 {
                     this.tcpClientStandBy.Close();
                     this.netStreamStandBy.Close();
                 }
                 else
                 {
                     ctrl.StandByAlive = true;
                 }
             }
         }
         catch (ArgumentNullException ex)
         {
             ex.ToString();
         }
         catch (ArgumentOutOfRangeException ex)
         {
             ex.ToString();
         }
         catch (SocketException ex)
         {
             ex.ToString();
         }
         catch (Exception ex)
         {
             ex.ToString();
         }
     }
     this.lockArea   = new LockArea();
     this.lstClients = new ArrayList();
     if (this.MasterMode)
     {
         this.createScheduler();
     }
     this.StartServer();
 }