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(""); } }