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