private void timer1_Tick(object sender, EventArgs e) { int j = 0; int cont = cs.Usuario().Rows.Count; OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + caminho + ";Extended Properties=Excel 12.0;"); con.Open(); OleDbDataAdapter query = new OleDbDataAdapter(" SELECT * FROM [Planilha1$]", con); DataTable dataTable = new DataTable(); query.Fill(dataTable); timer1.Enabled = true; timer1.Start(); progressBar1.Maximum = mat1; Conecta cl = new Conecta(); Variavel va = new Variavel(); foreach (DataRow dtRow in dataTable.Rows) { us.Nome = dtRow[0].ToString(); int aux = co.pesquisaFalta(us).Rows.Count; if (mat1 > progressBar1.Value) { if (j == 0) { } else { if (cont == 0) { if (aux == 0) { va.Nome = dtRow[0].ToString(); va.DtCadastro = Convert.ToDateTime(data).ToString("dd/MM/yyyy"); cl.cadastro(va); } } else { if (aux == 0) { va.Nome = dtRow[0].ToString(); va.DtCadastro = Convert.ToDateTime(data).ToString("dd/MM/yyyy"); cl.cadastro(va); cont = cs.Usuario().Rows.Count; } } } j = j + 1; if (j + 1 <= mat1) { progressBar1.Value++; } } } con.Close(); timer1.Stop(); timer2.Enabled = true; seg = 10; }
private void button1_Click(object sender, EventArgs e) { us.Nome = comboBox1.Text; int cont = co.CarregaDatas().Rows.Count; int i = 0, data = 0, aux = 0, col = 1; dataGridView1.Rows.Clear(); dataGridView1.Columns.Clear(); DataGridViewColumn grid = new DataGridViewTextBoxColumn(); dataGridView1.Columns.Add("nomeMaisculo", "Nome"); this.dataGridView1.Rows.Insert(0, comboBox1.Text); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Lucida Bright", 11, FontStyle.Bold); while (i < cont) { data = data + 1; i = i + 1; } foreach (DataRow item in co.pesquisaFalta(us).Rows) { for (int j = 0; j < cont; j++) { us.Nome = dataGridView1.Rows[0].Cells[0].Value.ToString(); dta = "data" + Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("ddMMyyyy"); if (Convert.ToDateTime(Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("dd/MM/yyyy")) >= Convert.ToDateTime(Convert.ToDateTime(cs.faltaApinista(us).Rows[aux]["dtCad"].ToString()).ToString("dd/MM/yyyy"))) { if (item[dta].ToString() == "F" || item[dta].ToString() == "") { dataGridView1.Columns.Add("colum" + col, Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("dd/MM/yyyy")); dataGridView1.Columns["colum" + col].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns["colum" + col].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.RowsDefaultCellStyle.Font = new Font("Lucida Bright", 11); dataGridView1.Rows[0].Cells[col].Value = "F"; col = col + 1; } } } } }