void MostrarDatos(DataTable dtIngresos, DataTable dtSalidas)
{
int n_fil = 0;
int n_col = 0;
int n_reg = 0;
string c_nomcol = "";
int n_columna = 0;
C1.Win.C1FlexGrid.CellRange rng;
n_fil = 2;
FgItems.Cols.Count = 3;
FgItems.Rows.Count = 2;
FgItems.Cols.Count = 66;
FgItems.Rows.Count = 2;
n_col = 6;
for (n_reg = 0; n_reg <= dtIngresos.Rows.Count - 1; n_reg++)
{
FgItems.Rows.Count = FgItems.Rows.Count + 1;
FgItems.SetData(n_fil, 1, dtIngresos.Rows[n_reg]["TARJETA_TMP"].ToString());
FgItems.SetData(n_fil, 2, dtIngresos.Rows[n_reg]["APENOM"].ToString());
FgItems.SetData(n_fil, 3, dtIngresos.Rows[n_reg]["AREA"].ToString());
n_columna = 4;
for (n_col = 6; n_col <= dtIngresos.Columns.Count - 1; n_col++)
{
c_nomcol = dtIngresos.Columns[n_col].ColumnName;
if (n_reg == 0)
{
FgItems.Cols[n_columna].Width = 45;
FgItems.Cols[n_columna + 1].Width = 45;
FgItems.Cols[n_columna].TextAlignFixed = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
FgItems.Cols[n_columna + 1].TextAlignFixed = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
FgItems.Rows[0].AllowMerging = true;
rng = FgItems.GetCellRange(0, n_columna, 0, n_columna + 1);
if (c_nomcol.Length == 5)
{
rng.Data = "DIA " + c_nomcol.Substring(4, 1);
}
else
{
rng.Data = "DIA " + c_nomcol.Substring(4, 2);
}
FgItems.SetData(1, n_columna, "Ingreso");
FgItems.SetData(1, n_columna + 1, "Salida");
}
FgItems.SetData(n_fil, n_columna, dtIngresos.Rows[n_reg][c_nomcol].ToString());
n_columna = n_columna + 1;
if (ChkOpcion.Checked == true) // AQUI IMPRIME EL FORMTATO PREPARADO MISTRANDO LAS HORAS FORMALES DE TRABAJO
{
string c_newhor;
string c_ing = "";
string c_sal = "";
if (dtIngresos.Rows[n_reg][c_nomcol].ToString() != "")
{
c_ing = dtIngresos.Rows[n_reg][c_nomcol].ToString();
}
if (dtSalidas.Rows[n_reg][c_nomcol].ToString() != "")
{
c_sal = dtSalidas.Rows[n_reg][c_nomcol].ToString();
}
c_newhor = Hora_HallarSalidaFormal(c_sal, c_ing, 9);
FgItems.SetData(n_fil, n_columna, c_newhor);
}
else
{
FgItems.SetData(n_fil, n_columna, dtSalidas.Rows[n_reg][c_nomcol].ToString()); // AQUI IMPRIME LAS HORAS REALMENTE TRABAJADAS
}
n_columna = n_columna + 1;
}
n_fil = n_fil + 1;
}
}
