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();
}
