private void dataHistoryPeriodo_CellClick(object sender, DataGridViewCellEventArgs e)
{
selccionValor = true;
btnCreate.Text = "Modificar Periodo";
Fill = dataHistoryPeriodo.CurrentCell.RowIndex;
ValorPeriodo = dataHistoryPeriodo[1, Fill].Value.ToString().Trim();
Ano = dataHistoryPeriodo[4, Fill].Value.ToString();
Mes = dataHistoryPeriodo[5, Fill].Value.ToString();
Periodo = dataHistoryPeriodo[6, Fill].Value.ToString();
dtpEventInitial.Value = Convert.ToDateTime(dataHistoryPeriodo[2, Fill].Value.ToString().Trim());
dtpDatenEnd.Value = Convert.ToDateTime(dataHistoryPeriodo[3, Fill].Value.ToString().Trim());
cboAno.Text = dataHistoryPeriodo[4, Fill].Value.ToString().Trim();
cboMes.Text = dataHistoryPeriodo[5, Fill].Value.ToString().Trim();
cboPeriodo.Text = dataHistoryPeriodo[6, Fill].Value.ToString().Trim();
if (dataHistoryPeriodo[7, Fill].Value != null && Convert.ToDecimal(dataHistoryPeriodo[7, Fill].Value.ToString().Trim()) > 0)
{
txtOnzasFundidas.Text = dataHistoryPeriodo[7, Fill].Value.ToString().Trim();
}
else
{
txtOnzasFundidas.Text = string.Empty;
}
if (dataHistoryPeriodo[9, Fill].Value != null && Convert.ToDecimal(dataHistoryPeriodo[9, Fill].Value.ToString().Trim()) > 0)
{
txtRecuperacion.Text = dataHistoryPeriodo[9, Fill].Value.ToString().Trim();
}
else
{
txtRecuperacion.Text = string.Empty;
}
if (dataHistoryPeriodo[8, Fill].Value != null && Convert.ToDecimal(dataHistoryPeriodo[8, Fill].Value.ToString().Trim()) > 0)
{
txtOnzasRecuperadas.Text = dataHistoryPeriodo[8, Fill].Value.ToString().Trim();
}
else
{
txtOnzasRecuperadas.Text = string.Empty;
}
if (Convert.ToBoolean(dataHistoryPeriodo[10, Fill].Value.ToString().Trim()))
{
label17.Text = "Abierto";
btnCerrarPe.Enabled = true;
btnCerrarPe.Enabled = true;
dtpEventInitial.Enabled = true;
dtpDatenEnd.Enabled = true;
cboAno.Enabled = true;
cboMes.Enabled = true;
cboPeriodo.Enabled = true;
txtOnzasFundidas.Enabled = true;
txtRecuperacion.Enabled = true;
txtOnzasRecuperadas.Enabled = true;
}
else
{
label17.Text = "Cerrado";
btnCerrarPe.Enabled = false;
dtpEventInitial.Enabled = false;
dtpDatenEnd.Enabled = false;
cboAno.Enabled = false;
cboMes.Enabled = false;
cboPeriodo.Enabled = false;
txtOnzasFundidas.Enabled = false;
txtRecuperacion.Enabled = false;
txtOnzasRecuperadas.Enabled = false;
}
var read = ConsultaEntidades.DetallePeriodos("SpConsulta_Tablas", "DetallePeriodo", dataHistoryPeriodo[1, Fill].Value.ToString().Trim(), 0, string.Empty);
dataDetailPeriodo.DataSource = read;
dataDetailPeriodo.Columns[0].Width = 40;
dataDetailPeriodo.Columns[1].Width = 40;
dataDetailPeriodo.Columns[2].Width = 40;
dataDetailPeriodo.Columns["Toneladas"].DefaultCellStyle.Format = "##,##.00";
dataDetailPeriodo.Columns["Toneladas"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataDetailPeriodo.Columns["Onzas"].DefaultCellStyle.Format = "##,##.00";
dataDetailPeriodo.Columns["Onzas"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataDetailPeriodo.Columns["Tenor"].DefaultCellStyle.Format = "##,##.00";
dataDetailPeriodo.Columns["Tenor"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
var suma = read.Select(c => c.Toneladas).Sum();
txtToneladas.Text = suma.Value.ToString("##.00");
suma = read.Select(c => c.Tenor).Sum();
txtTenor.Text = suma.Value.ToString("##.00");
suma = read.Select(c => c.Onzas).Sum();
txtOnzas.Text = suma.Value.ToString("##.00");
dataDetailPeriodo.AutoResizeColumns();
}