public DataSet GetTiposSpsRetorno()
{
DataSet res = null;
string sql = "SELECT " + Environment.NewLine +
"cod_tipretorno_n as codigo, " + Environment.NewLine +
"des_tipretorno as descripcion " + Environment.NewLine +
"FROM ge_ambtipretorno";
res = MyOracleUtils.executeSqlStmDs(sql, this.conn);
return(res);
}
public DataSet GetCodModulo()
{
DataSet res = null;
try
{
string sql = "select reg.cod_modulo_n as Codigo, 'Modulo ' || to_char (cod_modulo_n) as descripcion " + Environment.NewLine +
" from (select distinct cod_modulo_n from ge_ambcatalogo) reg";
res = MyOracleUtils.executeSqlStmDs(sql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public DataSet GetTiposServicios()
{
DataSet res = null;
try
{
string sql = "SELECT cod_tipservicio_n as codigo, " + Environment.NewLine +
"des_tipservicio as descripcion " + Environment.NewLine +
"FROM ge_ambtipservicio";
res = MyOracleUtils.executeSqlStmDs(sql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public DataSet GetAccionServicio()
{
DataSet res = null;
try
{
string sql = "SELECT cod_accserv_n as codigo, " + Environment.NewLine +
" des_accserv as descripcion " + Environment.NewLine +
" FROM ge_ambaccserv " + Environment.NewLine +
" ORDER BY DES_ACCSERV";
res = MyOracleUtils.executeSqlStmDs(sql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public DataSet GetObjetoProp()
{
DataSet res = null;
try
{
string sql = "SELECT cod_objprop_n as codigo, " + Environment.NewLine +
"des_objprop || ' - ' || des_objdb as descripcion " + Environment.NewLine +
"FROM ge_ambobjprop " + Environment.NewLine +
"ORDER BY DES_OBJPROP";
res = MyOracleUtils.executeSqlStmDs(sql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public DataSet GetDependencies(DbObjectBE pDbObjectBE)
{
DataSet res = null;
string wsql = "select a.referenced_owner, a.referenced_type, a.referenced_name " + Environment.NewLine +
"from all_dependencies a " + Environment.NewLine +
" where a.owner = " + MyStringUtils.entreComas(pDbObjectBE.Owner) + Environment.NewLine +
" and a.type = " + MyStringUtils.entreComas(pDbObjectBE.Type) + Environment.NewLine +
" and a.name = " + MyStringUtils.entreComas(pDbObjectBE.Name) + Environment.NewLine;
try
{
res = MyOracleUtils.executeSqlStmDs(wsql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public string ObtDiaSemana(DateTime pdate)
{
const string LexFmtDate = "<%fecFormyyyy-MM-dd>";
string res = string.Empty;
string sql = "SELECT '" + LexFmtDate + "' as fec, TO_CHAR(date '"
+ LexFmtDate + "', 'DAY') diaSemana" + Environment.NewLine +
"FROM dual";
string scrap = pdate.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture);
sql = sql.Replace(LexFmtDate, scrap);
DataSet ds = MyOracleUtils.executeSqlStmDs(sql, this.conn);
foreach (DataRow dr in ds.Tables[0].Rows)
{
res = Convert.ToString(dr["diaSemana"]);
}
return(res);
}
string ObtServiceInvoker(string pServiceName)
{
DataSet ds = null;
string res = string.Empty;
string wSql = string.Empty;
try
{
wSql = "SELECT A.DES_INVOCADOR " + Environment.NewLine +
" FROM GE_AMBCATALOGO A " + Environment.NewLine +
" WHERE A.NOM_SERVICIO = " + MyStringUtils.entreComas(pServiceName);
ds = MyOracleUtils.executeSqlStmDs(wSql, this.conn);
foreach (DataRow dr in ds.Tables[0].Rows)
{
res = Convert.ToString(dr["DES_INVOCADOR"]);
}
}
catch (Exception)
{
throw;
}
return(res);
}
