public OracleDataReader getParametros() { string sql = "Select DES_PARAMETRO as \"Proceso\", VAL_PARAMETRO as \"Fec.Referencia\" " + Environment.NewLine + " from [email protected] a " + Environment.NewLine + " where A.COD_PARAMETRO_V in ('APLOPERT', 'CIERRECONT','UFCARPRE')"; OracleDataReader dr = MyOracleUtils.executeSqlStm(sql, ConnGl.Instance.Conn); return(dr); }
public OracleDataReader getCatalogoEntries(string pcond) { OracleDataReader res = null; string sql = "SELECT * FROM GE_AMBCATALOGO "; sql = sql + (pcond.Length > 0 ? " WHERE " : string.Empty) + pcond; res = MyOracleUtils.executeSqlStm(sql, this.conn); return(res); }
private OracleDataReader getOraMetaParamsSp(string packageName, string methodName, string schemaDb) { OracleDataReader res = null; string sql = "SELECT A.package_name , A.object_name ,A.argument_name, A.data_type, A.in_out " + Environment.NewLine + "FROM all_arguments A " + Environment.NewLine + "WHERE package_name = " + MyStringUtils.entreComas(packageName.ToUpper()) + Environment.NewLine + "AND object_name = " + MyStringUtils.entreComas(methodName.ToUpper()) + Environment.NewLine + "AND OWNER = " + MyStringUtils.entreComas(schemaDb).Trim() + Environment.NewLine + " ORDER BY POSITION"; res = MyOracleUtils.executeSqlStm(sql, this.conn); return(res); }
public OracleDataReader getBitacoraEntries(string pcond) { OracleDataReader res = null; string sql = "select a.fec_registro, a.nom_servicio, A.DES_MENSAJE, A.DES_TRANSACCION, a.fec_inicio, a.fec_fin, " + " a.des_ipservidor, a.des_ipcliente, A.COD_DOMINIO_V, A.COD_USUARIO_V " + " from GE_AMBBITACORA A " + (pcond.Length > 0 ? " WHERE " : string.Empty) + pcond + " order by fec_inicio desc"; System.Console.WriteLine(sql); res = MyOracleUtils.executeSqlStm(sql, this.conn); return(res); }
public OracleDataReader getCierres() { string sql = "SELECT -- sis.DES_SISTEMA as \"Sistema\", " + Environment.NewLine + "sis.des_subsist as \"Sub Sistema\", " + Environment.NewLine + "cie.FEC_ULTCIER as \"Fec.Ult.Cierre\", " + Environment.NewLine + "cie.FEC_PROXHAB as \"Fec.Sistema\", " + Environment.NewLine + "cie.FEC_MODESTA as \"Fec.Realiza Cierre\", " + Environment.NewLine + "cie.USU_MODESTA as \"Usu.Realiza\" " + Environment.NewLine + "FROM [email protected] cie, " + Environment.NewLine + " SE_SISTEMAS @PRDPBBN04.CONSULTA sis " + Environment.NewLine + "where cie.COD_SISTEMA_V = sis.COD_SISTEMA_V AND " + Environment.NewLine + "cie.COD_SUBSIST_V = sis.COD_SUBSIST_V"; OracleDataReader dr = MyOracleUtils.executeSqlStm(sql, ConnGl.Instance.Conn); return(dr); }
/// <summary> /// //FUNCTION get_ddl ( // object_type IN VARCHAR2, // name IN VARCHAR2, // schema IN VARCHAR2 DEFAULT NULL, // version IN VARCHAR2 DEFAULT 'COMPATIBLE', // model IN VARCHAR2 DEFAULT 'ORACLE', // transform IN VARCHAR2 DEFAULT 'DDL') // RETURN CLOB; /// </summary> /// <param name="pOwner"></param> /// <param name="pType"></param> /// <param name="pObjectName"></param> /// <returns></returns> public string GetDll(string pSchema, string pObjectType, string pObjectName) { string res = string.Empty; string wObjType = pObjectType.Replace(' ', '_'); string wsql = "select dbms_metadata.get_ddl( OBJECT_TYPE => " + MyStringUtils.entreComas(wObjType) + ", NAME =>" + MyStringUtils.entreComas(pObjectName) + ", SCHEMA => " + MyStringUtils.entreComas(pSchema) + " ) as res from dual"; OracleDataReader dr = MyOracleUtils.executeSqlStm(wsql, ConnGl.Instance.Conn); while (dr.Read()) { res = (Convert.ToString(dr["RES"])); } return(res); }
public OracleDataReader getCtlHorariosSabNet() { string sql = "SELECT A.COD_PROCESOCTL_V as \"Nom.Proceso\", " + Environment.NewLine + " A.FEC_ULTEJEC as \"Fec.Ult.Ejecución\", " + Environment.NewLine + " A.USU_CORPROC as \"Usu.Ejecutó\" " + Environment.NewLine + " FROM [email protected] A " + Environment.NewLine + " WHERE A.COD_PROCESOCTL_V IN ('VENOPER', 'REPVENOPE', 'VENCUST', 'REPVENC') " + Environment.NewLine + " UNION ALL " + Environment.NewLine + " SELECT 'Cierre Divsas' as \"Nom.Proceso\", " + Environment.NewLine + " a.FEC_ULTEJEC, a.USU_CORPROC " + Environment.NewLine + " FROM [email protected] a " + Environment.NewLine + "WHERE(a.cod_sistema_v, a.cod_subsist_v, a.cod_proceso) " + Environment.NewLine + " in (('OR', 'OR', 'CIERREDIV'))"; OracleDataReader dr = MyOracleUtils.executeSqlStm(sql, ConnGl.Instance.Conn); return(dr); }
private void ExecQrytlsStrp_Click(object sender, EventArgs e) { string sql; try { sql = txtQry.Text; OracleDataReader dr = MyOracleUtils.executeSqlStm(sql, ConnGl.Instance.Conn); DataTable dt = new DataTable(); dt.Load(dr); dgrData.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SendSqlToDataView(string sql, DataGridView dgrView) { OracleDataReader dr = MyOracleUtils.executeSqlStm(sql, ConnGl.Instance.Conn); SendDataReaderToDataView(dr, dgrView); }