コード例 #1
0
        private void consultaEmMassaToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ConsultaGeral formConsultaGeral = new ConsultaGeral();

            abre_form_filho(formConsultaGeral);
            pictureBox2.Visible = false;

            //LOG DE ACESSO ///////////////////////////////////////////////////////////////////////////////
            OracleConnection conn2  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd2  = new OracleCommand();
            string           query2 = "INSERT INTO TLOG_VALIDADOR (TLOG_DATA, TLOG_USUARIO, TLOG_HOST, TLOG_OBS) VALUES (:DATAHORA, :USUARIO, :HOST, :OBS)";

            oCmd2.CommandText = query2;
            oCmd2.CommandType = CommandType.Text;
            oCmd2.Parameters.AddWithValue("DATAHORA", DateTime.Now);
            oCmd2.Parameters.AddWithValue("USUARIO", usuarioLogado);
            oCmd2.Parameters.AddWithValue("HOST", hostName);
            oCmd2.Parameters.AddWithValue("OBS", "Acessou a consulta em massa.");
            oCmd2.Connection = conn2;
            conn2.Open();
            OracleDataReader ler2 = oCmd2.ExecuteReader();

            conn2.Close();
            ////////////////////////////////////////////////////////////////////////////////////////////////
        }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            ConsultaGeral consultaGeral = new ConsultaGeral();

            consultaGeral.Show();
        }