private void CargaDatos()
 {
     var xcodmes = "99";
     var xtipoplanilla = ".";
     var sorted = default(SortOrder);
     var xnomcolumna = string.Empty;
     if (cboMes.SelectedValue != null)
     {
         xcodmes = cboMes.SelectedValue.ToString();
     }
     if (cboTipoplanilla.SelectedValue != null)
     {
         xtipoplanilla = cboTipoplanilla.SelectedValue.ToString();
     }
     if (Examinar.SortedColumn != null)
     {
         xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name;
         sorted = Examinar.SortOrder;
     }
     var BL = new tb_plla_rubrosafectosleyestrabemplBL();
     var BE = new tb_plla_rubrosafectosleyestrabempl();
     BE.perianio = spnperiodo.Value.ToString();
     BE.perimes = xcodmes;
     BE.tipoplla = xtipoplanilla;
     Tabla = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0];
     Examinar.AutoGenerateColumns = false;
     Examinar.DataSource = Tabla;
 }