//###############End Properties //####################Procedimento de banco################################ public void conectorPDV_find_consultaNome() { texto = " select idcliente as Codigo, nome,cpf, nascimento from fisica where nome like concat('"; texto += nome; texto += "' ,'%') "; try { auxConsistencia = 0; banco.abreConexao(); banco.singleTransaction(texto); banco.procedimentoSet(); } catch (Exception erro) { auxConsistencia = 1; msgInfo msg = new msgInfo("Caro Cliente - " + erro.Message); msg.ShowDialog(); } finally { if (auxConsistencia == 0) { dgvConsultaNome.DataSource = banco.retornaSet().Tables[0].DefaultView; } banco.fechaConexao(); //MessageBox.Show("Carrega...", "Caro Usúario", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
//######################################################END Controle de objetos####################################################### //######################################################Procedimento de banco######################################################### public int conector_verifica_exits_contrato(string store, string client) { auxConsistencia = 0; int result = -1; try { banco.abreConexao(); banco.singleTransaction("select count(*) from crediario where idLoja=?store and idCliente=?id and status not in(1,5)"); banco.addParametro("?store", store); banco.addParametro("?id", client); banco.procedimentoRead(); if (banco.retornaRead().Read() == true) { result = Convert.ToInt32(banco.retornaRead().GetString(0)); } } catch (Exception e) { auxConsistencia = 1; throw new Exception("ERRO BANCO DE DADOS: " + e.Message.ToString()); } finally { banco.fechaConexao(); if (auxConsistencia == 1) { result = -1; } } return(result); }
//######################################End Variaveis ########################################################### //######################################Procedimento de banco de dados########################################### public void conector_find_entrada() { dgvConsultaNota.Rows.Clear(); dgvConsultaNota.AllowUserToAddRows = false; auxConsistencia = 0; texto = " select "; texto += " idEntrada as chave, "; texto += " nr_nota, "; texto += " Serie, "; texto += " cfop, "; texto += " entrada.idCliente as Fornecedor, "; texto += " juridica.razao, "; texto += " emissao, "; texto += " valorTotalNota "; texto += " from "; texto += " entrada "; texto += " inner join juridica on(entrada.idCliente=juridica.idCliente)"; texto += " where"; texto += " nr_nota= " + auxNota + " and serie = " + auxSerie + " and"; texto += " entrada.idLoja = " + auxIdLoja + " and entrada.idCliente = " + auxIdFornecedor; try { banco.abreConexao(); banco.singleTransaction(texto); banco.procedimentoSet(); } catch (Exception erro) { MessageBox.Show(erro.Message, "Caro Usúario", MessageBoxButtons.OK, MessageBoxIcon.Warning); auxConsistencia = 1; } finally { if (auxConsistencia == 0) { countField = banco.retornaSet().Tables[0].Columns.Count; countRows = banco.retornaSet().Tables[0].DefaultView.Count; if (countRows > 0) { for (i = 0; i < countRows; i++) { dgvConsultaNota.Rows.Add(); for (j = 0; j < countField; j++) { dgvConsultaNota.Rows[i].Cells[j].Value = Convert.ToString(banco.retornaSet().Tables[0].Rows[i][j]); } } } else if (dgvConsultaNota.RowCount < 1) { dgvConsultaNota.Rows.Add(); } } else if (dgvConsultaNota.RowCount < 1) { dgvConsultaNota.Rows.Add(); } banco.fechaConexao(); } }
public void carrega_infor(string store) { int retorno = 0; try { banco1 = new dados(); banco1.abreConexao(); if (banco1.statusSchema() == 1) { banco1.singleTransaction("select versaoBanco, versaoSystem, conectorServer, localMachini from system"); banco1.procedimentoRead(); if (banco1.retornaRead().Read() == true) { VersaoBanco = banco1.retornaRead().GetString(0); VersaoSystem = banco1.retornaRead().GetString(1); ConectorServer = banco1.retornaRead().GetString(2); LocalMonitor = banco1.retornaRead().GetString(3); } else { retorno = 0; } } else { msgInfo msg = new msgInfo(1, "IMPOSSÍVEL ESTABELECER CONEXÃO"); msg.ShowDialog(); retorno = 0; } } catch (Exception) { } finally { if (banco1 != null) { banco1.fechaConexao(); } } }
//###############End Properties //####################Procedimento de banco################################ public void conectorPDV_find_consulta() { texto = " select "; texto += " tab.idCliente AS Codigo, "; texto += " if(tab.idtipoPessoa != 3, if(tab.idtipoPessoa=1,(tab1.nome),tab2.razao),tab3.nome) as 'Nome', "; texto += " mid(tab6.ddd,1,4) as DDD, "; texto += " tab6.telefone as Telefone "; texto += " from "; texto += " conectorPDV.cliente tab "; texto += " left join conectorPDV.fone tab6 on(tab.idCliente = tab6.idCliente) "; texto += " left join conectorPDV.fisica tab1 on(tab.idcliente = tab1.idcliente) "; texto += " left join conectorPDV.juridica tab2 on(tab.idcliente = tab2.idcliente) "; texto += " left join (select rural.idcliente,rural.cpf as cpf_1,rural.nome,rural.nascimento,rural.ie,rural.idsexo,rural.identidade,rural.idcivil,sexo.descricao as sexo1,civil.descricao as civil1 from conectorPDV.rural "; texto += " inner join conectorPDV.sexo on(rural.idsexo = sexo.idsexo) "; texto += " inner join conectorPDV.civil on(rural.idcivil = civil.idcivil)) as tab3 "; texto += " on(tab.idcliente = tab3.idcliente) "; texto += " where tab6.telefone = "; texto += fone; try { banco.abreConexao(); banco.singleTransaction(texto); banco.procedimentoSet(); } catch (Exception erro) { msgInfo msg = new msgInfo("Caro Cliente - " + erro.Message); msg.ShowDialog(); auxConsistencia = 1; } finally { if (auxConsistencia == 0) { dgvConsultaFone.DataSource = banco.retornaSet().Tables[0].DefaultView; } banco.fechaConexao(); //MessageBox.Show("Carrega...", "Caro Usúario", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }