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