private void VisualizaDetalheVenda_Load(object sender, EventArgs e)
        {
            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            comboLojas.DropDownStyle = ComboBoxStyle.DropDownList;
            OracleConnection conn1  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd1  = new OracleCommand();
            string           query1 = "SELECT S.LOJA_SAP_PK, " +
                                      "s.loja_sap_pk || ' - ' || u.tund_fantasia LOJA," +
                                      "s.host_servidor " +
                                      "FROM tloja_sap s " +
                                      "join TUND_UNIDADE u on s.loja_proton_uk = u.tund_unidade_pk " +
                                      "where s.ativa_difusao = 'S' " +
                                      "order by 1";

            oCmd1.CommandText = query1;
            oCmd1.CommandType = CommandType.Text;
            oCmd1.Connection  = conn1;

            conn1.Open();
            OracleDataReader ler1 = oCmd1.ExecuteReader();

            while (ler1.Read())
            {
                string CENTRO = ler1.GetValue(0).ToString();
                string LOJA   = ler1.GetValue(1).ToString();
                Lojas.Add(LOJA);
                Centros.Add(CENTRO);
            }

            conn1.Close();

            comboLojas.DataSource = Lojas;
            lojasArray            = Lojas.ToArray();
            centrosArray          = Centros.ToArray();
        }
Beispiel #2
0
 private void FormWait_Load(object sender, EventArgs e)
 {
     nomedoDominio            = ConfigINI.LerINI(@"configuracoes.ini", "[NomeDoDominio]");
     timerMensagens.Interval  = 3000;
     timerConectando.Interval = 2000;
     timerMensagens.Start();
     timerConectando.Start();
 }
Beispiel #3
0
        private void FormPai_Load(object sender, EventArgs e)
        {
            timerHoraExibicao.Interval = 1000;
            timerHoraExibicao.Start();

            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            FormCloseButtonDisabler.DisableCloseButton(this.Handle.ToInt32());
            lblBemVindo.Text = nome;
            timer1.Interval  = 100;
            timer1.Start();
        }
        }//Fim metódo Processamento()

        private void ConsultaGeral_Load(object sender, EventArgs e)
        {
            ////LOG DE ACESSO ///////////////////////////////////////////////////////////////////////////////
            //FormPai pai = new FormPai();
            //string hostname = pai.hostName, usuarioLogado = pai.usuarioLogado;
            //MessageBox.Show(hostname + " " + usuarioLogado);
            //OracleConnection conn2 = new OracleConnection("Data Source=10.101.1.32/INTEGRACAOTS;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", pai.usuarioLogado);
            //oCmd2.Parameters.AddWithValue("HOST", pai.hostName);
            //oCmd2.Parameters.AddWithValue("OBS", "Consulta Geral");
            //oCmd2.Connection = conn2;
            //conn2.Open();
            //OracleDataReader ler2 = oCmd2.ExecuteReader();
            //conn2.Close();
            //////////////////////////////////////////////////////////////////////////////////////////////////

            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            OracleConnection conn1  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd1  = new OracleCommand();
            string           query1 = "SELECT S.LOJA_SAP_PK, " +
                                      "s.loja_sap_pk || ' - ' || u.tund_fantasia LOJA," +
                                      "s.host_servidor " +
                                      "FROM tloja_sap s " +
                                      "join TUND_UNIDADE u on s.loja_proton_uk = u.tund_unidade_pk " +
                                      "where s.ativa_difusao = 'S' " +
                                      "order by 1";

            oCmd1.CommandText = query1;
            oCmd1.CommandType = CommandType.Text;
            oCmd1.Connection  = conn1;

            conn1.Open();
            OracleDataReader ler1 = oCmd1.ExecuteReader();

            while (ler1.Read())
            {
                string LOJA = ler1.GetValue(1).ToString();
                Lojas.Add(LOJA);
                string CENTRO = ler1.GetValue(0).ToString();
                Centros.Add(CENTRO);
            }
            conn1.Close();

            lojasArray   = Lojas.ToArray();
            centrosArray = Centros.ToArray();
        }
        private void ConsultaPorUF_Load(object sender, EventArgs e)
        {
            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
            comboUF.DropDownStyle   = ComboBoxStyle.DropDownList;
            OracleConnection conn1  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd1  = new OracleCommand();
            string           query1 = "select distinct " +
                                      "c.tloc_uf_fk, " +
                                      "c.tloc_uf_fk || ' - ' || f.tloc_nome as UF " +
                                      "from " +
                                      "tund_unidade u " +
                                      "join tloc_cidade_cep c on u.tund_cidade_cep_fk = c.tloc_cidade_cep_pk " +
                                      "join tloja_sap s on u.tund_unidade_pk = s.loja_proton_uk " +
                                      "join tloc_uf f on c.tloc_uf_fk = f.tloc_uf_pk " +
                                      "AND s.ativa_difusao = 'S' " +
                                      "and s.loja_sap_pk not like ('9%') " +
                                      "order by 1";

            oCmd1.CommandText = query1;
            oCmd1.CommandType = CommandType.Text;
            oCmd1.Connection  = conn1;

            conn1.Open();
            OracleDataReader ler1 = oCmd1.ExecuteReader();

            while (ler1.Read())
            {
                string UF     = ler1.GetValue(0).ToString();
                string ESTADO = ler1.GetValue(1).ToString();
                Uf.Add(UF);
                Estados.Add(ESTADO);
            }

            conn1.Close();

            comboUF.DataSource = Estados;
            UfArray            = Uf.ToArray();
            EstadoArray        = Estados.ToArray();
        }
        void ConsultaRecarga()
        {
            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            comboLoja.DropDownStyle = ComboBoxStyle.DropDownList;
            OracleConnection conn1  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd1  = new OracleCommand();
            string           query1 = "select sp.loja_sap_pk, " +
                                      "s.codlojasitef, " +
                                      "s.idt_terminal, " +
                                      "s.data_trn, " +
                                      "case when s.estado_trn = '2' " +
                                      "then 'PENDENTE' " +
                                      "when s.estado_trn = '4' " +
                                      "then 'EFETUADA PDV' " +
                                      "when s.estado_trn = '132' " +
                                      "then 'EFETUADA LOCAL' " +
                                      "end " +
                                      "as ESTADO, " +
                                      "s.cuponfiscal, " +
                                      "s.valor_trn/100 as VALOR, " +
                                      "s.nsu_sitef as NSU_SITEF, " +
                                      "s.nome_filial as OPERADORA, " +
                                      "'(' || s.area || ')' || s.telefone as TELEFONE " +
                                      "from logrecargacel@banco_sitef s " +
                                      "join tloja_proton_sitef l " +
                                      "on s.codlojasitef = '00000' || l.loja_sitef " +
                                      "join tloja_sap sp " +
                                      "on l.loja_proton = sp.loja_proton_uk " +
                                      "where s.estado_trn in (2, 4, 132) " +
                                      "and s.codigo_resp = '00' " +
                                      "and s.data_trn between '" + maskedDataIni.Text.Substring(6, 4) + maskedDataIni.Text.Substring(3, 2) + maskedDataIni.Text.Substring(0, 2) + "' and '" + maskedDataFim.Text.Substring(6, 4) + maskedDataFim.Text.Substring(3, 2) + maskedDataFim.Text.Substring(0, 2) + "' " +
                                      "and s.codlojasitef <> 'GRP_3024' " +
                                      "and not exists (select " +
                                      "* " +
                                      "from ttransacao t " +
                                      "join tloja_proton_sitef l " +
                                      "on t.numero_loja_uk = l.loja_proton " +
                                      "where t.nsu_servico = s.nsu_sitef " +
                                      "and to_char(trunc(t.data_hora_transacao_uk), " +
                                      "'YYYYMMDD') = s.data_trn " +
                                      "and '00000' || l.loja_sitef = s.codlojasitef " +
                                      "and t.tipo = 'R')";

            oCmd1.CommandText = query1;
            oCmd1.CommandType = CommandType.Text;
            oCmd1.Connection  = conn1;

            conn1.Open();
            OracleDataReader ler1 = oCmd1.ExecuteReader();

            while (ler1.Read())
            {
                ListaRecarga.Add(new ServicosRecarga()
                {
                    LojaSAP   = ler1.GetValue(0).ToString(),
                    LojaSiTef = ler1.GetValue(1).ToString(),
                    PDVSiTef  = ler1.GetValue(2).ToString(),
                    Data      = ler1.GetValue(3).ToString(),
                    Estado    = ler1.GetValue(4).ToString(),
                    Cupom     = ler1.GetValue(5).ToString(),
                    Valor     = ler1.GetValue(6).ToString(),
                    NSU       = ler1.GetValue(7).ToString(),
                    Operadora = ler1.GetValue(8).ToString(),
                    Telefone  = ler1.GetValue(9).ToString()
                });
            }

            conn1.Close();
        }
        void ConsultaFatura()
        {
            localBanco = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
            comboLoja.DropDownStyle = ComboBoxStyle.DropDownList;
            OracleConnection conn1  = new OracleConnection("Data Source=" + localBanco + "/INTEGRACAOSP;User Id=pdvuser;Password=pdv1234;Integrated Security=no");
            OracleCommand    oCmd1  = new OracleCommand();
            string           query1 = "select sp.loja_sap_pk as LOJA, " +
                                      "s.codlojasitef, " +
                                      "s.idt_terminal as PDV, " +
                                      "s.ipterminal, " +
                                      "s.data_trn as DATA, " +
                                      "case when s.estado_trn = '2' " +
                                      "then 'PENDENTE' " +
                                      "when s.estado_trn = '4' " +
                                      "then 'EFETUADA PDV' " +
                                      "when s.estado_trn = '132' " +
                                      "then 'EFETUADA LOCAL' " +
                                      "end " +
                                      "as ESTADO, " +
                                      "s.cuponfiscal, " +
                                      "s.VALOR_TRN/100 AS VALOR, " +
                                      "s.nsu_sitef as NSU_SITEF " +
                                      "from logtef@banco_sitef s " +
                                      "join tloja_proton_sitef l " +
                                      "on s.codlojasitef = '00000' || l.loja_sitef " +
                                      "join tloja_sap sp " +
                                      "on l.loja_proton = sp.loja_proton_uk " +
                                      "where s.data_trn between '" + maskedDataIni.Text.Substring(6, 4) + maskedDataIni.Text.Substring(3, 2) + maskedDataIni.Text.Substring(0, 2) + "' and '" + maskedDataFim.Text.Substring(6, 4) + maskedDataFim.Text.Substring(3, 2) + maskedDataFim.Text.Substring(0, 2) + "' " +
                                      "and s.idt_rede = '247' " +
                                      "and s.cdmodoentrada <> '-1' " +
                                      "and s.idt_produto = '-1' " +
                                      "and s.estado_trn not in ('1', '3', '5', '6', '134') " +
                                      "and s.codigo_resp = '00' " +
                                      "and not exists (select * " +
                                      "from ttransacao t " +
                                      "join tloja_proton_sitef l " +
                                      "on t.numero_loja_uk = l.loja_proton " +
                                      "where t.nsu_servico = s.nsu_sitef " +
                                      "and trunc(t.data_hora_transacao_uk) between '" + maskedDataIni.Text.Substring(0, 2) + maskedDataIni.Text.Substring(3, 2) + maskedDataIni.Text.Substring(6, 4) + "' and '" + maskedDataFim.Text.Substring(0, 2) + maskedDataFim.Text.Substring(3, 2) + maskedDataFim.Text.Substring(6, 4) + "' " +
                                      "and '00000' || l.loja_sitef = s.codlojasitef " +
                                      "and t.tipo = 'SR') ";

            oCmd1.CommandText = query1;
            oCmd1.CommandType = CommandType.Text;
            oCmd1.Connection  = conn1;

            conn1.Open();
            OracleDataReader ler1 = oCmd1.ExecuteReader();

            while (ler1.Read())
            {
                ListaFatura.Add(new ServicosFatura()
                {
                    LojaSAP   = ler1.GetValue(0).ToString(),
                    LojaSiTef = ler1.GetValue(1).ToString(),
                    PDVSiTef  = ler1.GetValue(2).ToString(),
                    IP        = ler1.GetValue(3).ToString(),
                    Data      = ler1.GetValue(4).ToString(),
                    Estado    = ler1.GetValue(5).ToString(),
                    Cupom     = ler1.GetValue(6).ToString(),
                    Valor     = ler1.GetValue(7).ToString(),
                    NSU       = ler1.GetValue(8).ToString()
                });
            }

            conn1.Close();
        }
Beispiel #8
0
 private void FormLogin_Load(object sender, EventArgs e)
 {
     nomedoDominio = ConfigINI.LerINI(@"configuracoes.ini", "[NomeDoDominio]");
     localBanco    = ConfigINI.LerINI(@"configuracoes.ini", "[LocalBanco]");
     FormCloseButtonDisabler.DisableCloseButton(this.Handle.ToInt32());
 }