private void PesquisarEntrada() { StringBuilder sSql = new StringBuilder(); try { if (txtPesquisa.Text == "") { KryptonMessageBox.Show(lblCampoValor.Text + " está Vazio"); } else if (cbxCampoPesquisa.SelectedIndex == -1) { KryptonMessageBox.Show("Campo de Pesquisa está vazio"); } else if (cbxOperador.SelectedIndex == -1) { KryptonMessageBox.Show("Campo Operador esta Vazio"); } else { sSql.Append("select "); sSql.Append("movensai.cd_doc nNF, "); sSql.Append("movensai.cd_mov Lancamento, "); sSql.Append("movensai.cd_chave_nfe CHAVE, "); sSql.Append("clifor.nm_clifor nm_clifornor, "); sSql.Append("clifor.cd_ufnor cUF, "); sSql.Append("movensai.dt_emi AAMM, "); sSql.Append("clifor.cd_cgc CNPJ, "); sSql.Append("movensai.cd_serienf serie "); sSql.Append("from movensai inner join clifor on movensai.cd_clifor = clifor.cd_clifor "); sSql.Append("where movensai.cd_empresa = '"); sSql.Append(_sEmp); sSql.Append("' "); sSql.Append("and "); sSql.Append(_campoPesquisa); switch (cbxOperador.SelectedIndex) { case 0: { sSql.Append(" = "); sSql.Append("'"); sSql.Append(txtPesquisa.Text.Trim()); break; } case 1: { sSql.Append(" > "); sSql.Append("'"); sSql.Append(txtPesquisa.Text.Trim()); break; } case 2: { sSql.Append(" >= "); sSql.Append("'"); sSql.Append(txtPesquisa.Text.Trim()); break; } case 3: { sSql.Append(" < "); sSql.Append("'"); sSql.Append(txtPesquisa.Text.Trim()); break; } case 4: { sSql.Append(" <= "); sSql.Append("'"); sSql.Append(txtPesquisa.Text.Trim()); break; } case 5: { sSql.Append(" like "); sSql.Append("'%"); sSql.Append(txtPesquisa.Text.Trim()); sSql.Append("%"); break; } } sSql.Append("' "); if (cbxModelo.SelectedIndex == 0) { sSql.Append("and "); sSql.Append("movensai.cd_chave_nfe is not null "); } FbCommand cmd = new FbCommand(sSql.ToString(), cx.get_Conexao()); cx.Open_Conexao(); cmd.ExecuteNonQuery(); FbDataReader dr = cmd.ExecuteReader(); List<belCampoPesquisa> lCampoPesquisa = new List<belCampoPesquisa>(); while (dr.Read()) { belCampoPesquisa objCampo = new belCampoPesquisa(); objCampo.ChaveAcesso = dr["CHAVE"].ToString(); objCampo.NumeroNF = dr["nNF"].ToString(); objCampo.SeqNF = dr["Lancamento"].ToString(); objCampo.sCli_For = dr["nm_clifornor"].ToString(); objCampo.cUF = dr["cUF"].ToString(); objCampo.AAMM = dr["AAMM"].ToString(); objCampo.CNPJ = dr["CNPJ"].ToString(); objCampo.serie = dr["serie"].ToString(); lCampoPesquisa.Add(objCampo); } dgvPesquisa.DataSource = lCampoPesquisa; } } catch (Exception ex) { KryptonMessageBox.Show(ex.Message); ; } finally { cx.Close_Conexao(); } }
private void dgvPesquisa_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1) { objbelCampoPesquisa = new belCampoPesquisa(); objbelCampoPesquisa = objbelCampoPesquisa.RetornaCampoSelecionado((dgvPesquisa.DataSource as List<belCampoPesquisa>), dgvPesquisa[1, e.RowIndex].Value.ToString()); this.Close(); } }
private void btnPesquisarNF_Click(object sender, EventArgs e) { frmPesquisaNfe frm = new frmPesquisaNfe(_sEmp); frm.ShowDialog(); objbelCampoPesquisa = frm.objbelCampoPesquisa; if (objbelCampoPesquisa != null) { if (objbelCampoPesquisa.ChaveAcesso != "") { txtChaveAcesso.Text = objbelCampoPesquisa.ChaveAcesso; tabControl1.SelectedTab = tabPageRefNfe; } else { txtnNFref.Text = objbelCampoPesquisa.NumeroNF; txtClifor.Text = objbelCampoPesquisa.sCli_For; txtCNPJ.Text = objbelCampoPesquisa.CNPJ; txtcUF.Text = objbelCampoPesquisa.cUF; txtserieRef.Text = objbelCampoPesquisa.serie; txtAAMM.Text = Convert.ToDateTime(objbelCampoPesquisa.AAMM).ToString("dd/MM/yyyy"); tabControl1.SelectedTab = tabPageRefNotaA1; } objbelCampoPesquisa = new belCampoPesquisa(); } }