private void ListaSubsidio()
{
string cdn = ConfigurationManager.ConnectionStrings["cdnNomina"].ConnectionString;
cnx = new SqlConnection(cdn);
cmd = new SqlCommand();
cmd.Connection = cnx;
sh = new TablaSubsidio.Core.SubsidioHelper();
sh.Command = cmd;
try
{
cnx.Open();
lstSubsidio = sh.obtenerTablaSubsidio();
cnx.Close();
cnx.Dispose();
var sub = from s in lstSubsidio
select new
{
Id = s.id,
Desde = s.desde,
Cantidad = s.cantidad,
Periodo = (s.periodo == 7) ? "SEMANAL" : "QUINCENAL",
Anio = s.anio
};
dgvSubsidio.DataSource = sub.ToList();
}
catch (Exception error)
{
MessageBox.Show("Error: \r\n \r\n" + error.Message, "Error");
}
DataGridViewCellStyle estilo = new DataGridViewCellStyle();
estilo.Alignment = DataGridViewContentAlignment.MiddleRight;
estilo.Format = "n6";
dgvSubsidio.Columns[1].DefaultCellStyle = estilo;
dgvSubsidio.Columns[2].DefaultCellStyle = estilo;
dgvSubsidio.Columns["Id"].Visible = false;
for (int i = 0; i < dgvSubsidio.Columns.Count; i++)
{
dgvSubsidio.AutoResizeColumn(i);
}
}
