public string DAOSEConsultarAdicionales(short pEMP_CODI, int pCAS_CONT, string pSQL)
{
try
{
StringBuilder builder = new StringBuilder();
pSQL = pSQL.ToUpper().Replace(":P_EMP_CODI", pEMP_CODI.AsString());
pSQL = pSQL.ToUpper().Replace(":P_CAS_CONT", "'" + pCAS_CONT + "'");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.GetDataSet(pTOContext, pSQL.ToString(), null);
List <string> lData = new List <string>();
for (int j = 0; j < objeto.Tables[0].Rows.Count; j++)
{
for (int k = 0; k < objeto.Tables[0].Columns.Count; k++)
{
DataColumn col = objeto.Tables[0].Columns[k];
lData.Add(string.Format("{0}: {1}", col.ColumnName, objeto.Tables[0].Rows[j][k].ToString()));
}
}
return(string.Join("<br />", lData));
}
catch (Exception)
{
//this.BOException.Throw("KDAOGeneral", "DAOSEListaFlujos", exception);
return("");
}
}