protected internal void frmInvRotativo_Load(object sender, EventArgs e) { AccessBD conex = new AccessBD(); string SQL, posicao, rua = "0", nivel = "0"; int qtdCont; IDataReader retornoBD; dtpDe.Text = "01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); dtpAte.Text = DateTime.Now.ToString(); cmbPesquisa.SelectedIndex = 0; conex.AbrirConexao(); lblUltimoInvent.Text = conex.consultaScalar("SELECT RIGHT(DAT_post, 2) &'/'& MID(DAT_post, 5, 2) &'/'& LEFT(DAT_post, 4) & ' ÀS ' & MAX(hr_post) AS hr_post FROM INVENTARIO WHERE (((INVENTARIO.[DAT_POST])=(SELECT Max(dat_POST) FROM INVENTARIO))) group by dat_post"); try { //Preenche o datagridview SQL = "SELECT INVENTARIO.POS_DEP, COUNT(INVENTARIO.POS_DEP), POSICAO.DAT_CONT " + "FROM(" + "SELECT DOC_INV1, POS_DEP " + "FROM INVENTARIO " + "GROUP BY POS_DEP, DOC_INV1 " + ") , POSICAO " + "WHERE INVENTARIO.POS_DEP = POSICAO.POSICAO " + "GROUP BY INVENTARIO.POS_DEP, POSICAO.DAT_CONT " + "order by INVENTARIO.POS_DEP "; retornoBD = conex.consultaReader(SQL); cmbNivel.Items.Add(""); cmbRua.Items.Add(""); while (retornoBD.Read()) { posicao = retornoBD.GetString(0); qtdCont = retornoBD.GetInt32(1); dgvPos.Rows.Add(posicao, qtdCont); //carrega Combo box RUA if (rua != posicao.Substring(0, 5)) { rua = posicao.Substring(0, 5); cmbRua.Items.Add(posicao.Substring(0, 5)); } if (posicao.Length >= 13) { nivel = posicao.Substring(11, 2); } //Carrega combo box Nivel if (cmbNivel.FindStringExact(nivel) < 0) { cmbNivel.Items.Add(posicao.Substring(11, 2)); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } conex.FecharConexao(); }
private void bgwImportaExcel_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { AccessBD AccessBD = new AccessBD(); AccessBD.FecharConexao(); BarraProgresso.Dispose(); lblStripImportar.Dispose(); dgvPos.DataSource = output.Tables[0]; dgvPos.AutoGenerateColumns = true; }
private void frmIndicadores_Load(object sender, EventArgs e) { CheckForIllegalCrossThreadCalls = false; AccessBD conex = new AccessBD(); conex.AbrirConexao(); dtpDe1.Text = "01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); dtpDe2.Text = "01/01/" + DateTime.Now.Year.ToString(); dtpAte1.Text = DateTime.Now.ToString(); dtpAte2.Text = DateTime.Now.ToString(); dataDe = dtpDe1.Text.Substring(6, 4) + dtpDe1.Text.Substring(3, 2) + dtpDe1.Text.Substring(0, 2); dataAte = dtpAte1.Text.Substring(6, 4) + dtpAte1.Text.Substring(3, 2) + dtpAte1.Text.Substring(0, 2); //Carrega os gráficos nas Threads bgwGrafEvolucaoRotativo.RunWorkerAsync(); bgwAcuracidadeMensal.RunWorkerAsync(); bgwEanPosicaoMensal.RunWorkerAsync(); bgwRupturaPK.RunWorkerAsync(); conex.FecharConexao(); liteBD.FecharConexao(); }