private void BtnFiltro_Click(object sender, EventArgs e) { try { Actualizar_Temporal_Lavado(); Actualizar_Temporal_Envasado(); Actualizar_Temporal_Blanquear(); Actualizar_Temporal_Descarte(); Actualizar_Temporal_Exportacion(); FormPasoProcesos_Repetidos s = new FormPasoProcesos_Repetidos(Convert.ToInt32(cmb_variedad.SelectedValue.ToString())); s.traer_estimacion(); if (s.dataGridView1.RowCount > 0) { s.ShowDialog(); } traer_pre_PorVar(); traer_pre_PorVar2(); traer_pre_PorVar3(); if(dataGridView3.RowCount > 0) { dataGridView3.Columns[0].Visible = false; dataGridView3.Visible = true; } else { MessageBox.Show("No existen datos de blanqueado", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); } dataGridView1.Visible = true; dataGridView1.Columns[0].Visible = false; dataGridView2.Visible = true; dataGridView2.Columns[0].Visible = false; dataGridView2.Rows[1].Visible = false; dataGridView2.Rows[0].Visible = false; } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dataGridView1.Visible = false; dataGridView2.Visible = false; } finally { cn.Cerrar(); } for (int i = 2; i < dataGridView1.ColumnCount; i++) { try { dataGridView1.Rows[3].Cells[i].Value = (Convert.ToDouble(dataGridView1.Rows[2].Cells[i].Value.ToString()) - Convert.ToDouble(dataGridView1.Rows[8].Cells[i].Value.ToString())) + Convert.ToDouble(dataGridView1.Rows[3].Cells[i].Value.ToString()); dataGridView1.Rows[2].Cells[i].Value = Math.Round((Convert.ToDouble(dataGridView1.Rows[0].Cells[i].Value.ToString()) - Convert.ToDouble(dataGridView1.Rows[1].Cells[i].Value.ToString())), 1); if (dataGridView1.Rows[3].Cells[i].Value.ToString() == "") { dataGridView1.Rows[3].Cells[i].Value = 0; } if (dataGridView1.Rows[4].Cells[i].Value.ToString() == "") { dataGridView1.Rows[4].Cells[i].Value = 0; } if (dataGridView1.Rows[5].Cells[i].Value.ToString() == "") { dataGridView1.Rows[5].Cells[i].Value = 0; } if (dataGridView1.Rows[6].Cells[i].Value.ToString() == "") { dataGridView1.Rows[6].Cells[i].Value = 0; } if (dataGridView1.Rows[7].Cells[i].Value.ToString() == "") { dataGridView1.Rows[7].Cells[i].Value = 0; } dataGridView1.Rows[8].Cells[i].Value = Math.Round((Convert.ToDouble(dataGridView1.Rows[2].Cells[i].Value.ToString())) - (Convert.ToDouble(dataGridView1.Rows[3].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[4].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[5].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[6].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[7].Cells[i].Value.ToString())), 1); } catch { } } try { dataGridView1.Rows[8].Cells[1].Value = "MERMA"; dataGridView2.Rows[8].Cells[1].Value = "MERMA"; Pre_Porvar(); } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error",MessageBoxButtons.OK,MessageBoxIcon.Error); dataGridView1.Visible = false; dataGridView2.Visible = false; } }
private void BtnFiltro_Click(object sender, EventArgs e) { try { Actualizar_Temporal_Lavado(); Actualizar_Temporal_Envasado(); Actualizar_Temporal_Blanquear(); Actualizar_Temporal_Descarte(); Actualizar_Temporal_Exportacion(); FormPasoProcesos_Repetidos s = new FormPasoProcesos_Repetidos(Convert.ToInt32(cmb_variedad.SelectedValue.ToString())); s.traer_estimacion(); if (s.dataGridView1.RowCount > 0) { s.ShowDialog(); } traer_pre_PorVar(); traer_pre_PorVar2(); traer_pre_PorVar3(); if (dataGridView3.RowCount > 0) { dataGridView3.Columns[0].Visible = false; dataGridView3.Visible = true; } else { MessageBox.Show("No existen datos de blanqueado", "Informacion", MessageBoxButtons.OK, MessageBoxIcon.Information); } dataGridView1.Visible = true; dataGridView1.Columns[0].Visible = false; dataGridView2.Visible = true; dataGridView2.Columns[0].Visible = false; dataGridView2.Rows[1].Visible = false; dataGridView2.Rows[0].Visible = false; } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dataGridView1.Visible = false; dataGridView2.Visible = false; } finally { cn.Cerrar(); } for (int i = 2; i < dataGridView1.ColumnCount; i++) { try { dataGridView1.Rows[3].Cells[i].Value = (Convert.ToDouble(dataGridView1.Rows[2].Cells[i].Value.ToString()) - Convert.ToDouble(dataGridView1.Rows[8].Cells[i].Value.ToString())) + Convert.ToDouble(dataGridView1.Rows[3].Cells[i].Value.ToString()); dataGridView1.Rows[2].Cells[i].Value = Math.Round((Convert.ToDouble(dataGridView1.Rows[0].Cells[i].Value.ToString()) - Convert.ToDouble(dataGridView1.Rows[1].Cells[i].Value.ToString())), 1); if (dataGridView1.Rows[3].Cells[i].Value.ToString() == "") { dataGridView1.Rows[3].Cells[i].Value = 0; } if (dataGridView1.Rows[4].Cells[i].Value.ToString() == "") { dataGridView1.Rows[4].Cells[i].Value = 0; } if (dataGridView1.Rows[5].Cells[i].Value.ToString() == "") { dataGridView1.Rows[5].Cells[i].Value = 0; } if (dataGridView1.Rows[6].Cells[i].Value.ToString() == "") { dataGridView1.Rows[6].Cells[i].Value = 0; } if (dataGridView1.Rows[7].Cells[i].Value.ToString() == "") { dataGridView1.Rows[7].Cells[i].Value = 0; } dataGridView1.Rows[8].Cells[i].Value = Math.Round((Convert.ToDouble(dataGridView1.Rows[2].Cells[i].Value.ToString())) - (Convert.ToDouble(dataGridView1.Rows[3].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[4].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[5].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[6].Cells[i].Value.ToString()) + Convert.ToDouble(dataGridView1.Rows[7].Cells[i].Value.ToString())), 1); } catch { } } try { dataGridView1.Rows[8].Cells[1].Value = "MERMA"; dataGridView2.Rows[8].Cells[1].Value = "MERMA"; Pre_Porvar(); } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dataGridView1.Visible = false; dataGridView2.Visible = false; } }