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