protected DataTable obtienDatosTabla(string headCampos, string sql)
{
DataTable dt = new DataTable();
int cont = 0;
string[] words1 = headCampos.Split(',');
//string[] words4 = aliasTablasCampoSel.Split('|');
ArrayList headCol = new ArrayList();
for (cont = 0; cont < words1.Length; cont++)
{
String campo = words1[cont];
if (campo != "")
{
headCol.Add(campo);
dt.Columns.Add(new DataColumn(campo, typeof(string)));
}
}
ArrayList resp = ServiciosGen.getResultadoSQL(sql);
if (resp != null)
{
ArrayList datCol = new ArrayList();
for (int rowCtr = 0; (rowCtr < resp.Count); rowCtr++)
{
datCol = (ArrayList)resp[rowCtr];
DataRow tRow = dt.NewRow();
for (int cellCtr = 0; cellCtr < datCol.Count; cellCtr++)
{
tRow[cellCtr] = datCol[cellCtr];
}
// Add new row to table.
dt.Rows.Add(tRow);
}
}
return(dt);
}
//-----------------------------------------------------------------------------------
protected ArrayList obtienDatosTablaArray(string headCampos, string sql)
{
ArrayList dt = new ArrayList();
int cont = 0;
string[] words1 = headCampos.Split(',');
//string[] words4 = aliasTablasCampoSel.Split('|');
ArrayList headCol = new ArrayList();
for (cont = 0; cont < words1.Length; cont++)
{
String campo = words1[cont];
if (campo != "")
{
headCol.Add(campo);
}
}
dt.Add(headCol);
ArrayList resp = ServiciosGen.getResultadoSQL(sql);
if (resp != null)
{
ArrayList datCol = new ArrayList();
for (int rowCtr = 0; (rowCtr < resp.Count); rowCtr++)
{
datCol = new ArrayList();
ArrayList camposRec = (ArrayList)resp[rowCtr];
for (int cellCtr = 0; cellCtr < camposRec.Count; cellCtr++)
{
datCol.Add(camposRec[cellCtr]);
}
// Add new row to table.
dt.Add(datCol);
}
}
return(dt);
}
