public override object ExecuteScalar(ref DAABRequest Request) { string connectionString = Request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } if ((Request.Command == null || Request.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar."); } try { ArrayList lista = Request.Parameters; estableceConexion(Request.Transactional, connectionString); OracleParameter[] aparam = DevuelveParametros(Request.CommandType, ref lista); if (Request.Transactional) { return(ExecuteScalares(m_TranSQL, Request.CommandType, Request.Command, aparam)); } else { return(ExecuteScalares(m_conecSQL, Request.CommandType, Request.Command, aparam)); } } finally { if (!(Request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }
public override void FillDataset(ref DAABRequest request) { string connectionString = request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } if ((request.Command == null || request.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar."); } if ((request.RequestDataSet == null)) { throw new ArgumentNullException("RequestDataSet"); } try { ArrayList lista = request.Parameters; estableceConexion(request.Transactional, connectionString); OracleParameter[] aparam = DevuelveParametros(request.CommandType, ref lista); if (request.Transactional) { FillDatasets(m_conecSQL, m_TranSQL, request.CommandType, request.Command, request.RequestDataSet, request.TableNames, aparam); } else { FillDatasets(m_conecSQL, ((OracleTransaction)(null)), request.CommandType, request.Command, request.RequestDataSet, request.TableNames, aparam); } } catch (Exception ex1) { request.Exception = ex1; throw ex1; } finally { if (!(request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }
public override DAABDataReader ExecuteReader(ref DAABRequest Request) { DAABSQLDataReader oDataReaderSQL; string connectionString = Request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } try { ArrayList lista = Request.Parameters; SqlParameter[] aparam = DevuelveParametros(Request.CommandType, ref lista); estableceConexion(false, connectionString); SqlDataReader drSQL; drSQL = ExecuteReaders(m_conecSQL, ((SqlTransaction)(null)), Request.CommandType, Request.Command, aparam); oDataReaderSQL = new DAABSQLDataReader(); oDataReaderSQL.ReturnDataReader = drSQL; return(oDataReaderSQL); } catch (SqlException ex1) { if (!(m_conecSQL == null)) { m_conecSQL.Dispose(); } Request.Exception = ex1; throw ex1; //return null; } catch (Exception ex1) { Request.Exception = ex1; if (!(m_conecSQL == null)) { m_conecSQL.Dispose(); } throw; //return null; } }
public override DataSet ExecuteDataset(ref DAABRequest request) { string connectionString = request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } if ((request.Command == null || request.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar."); } try { ArrayList lista = request.Parameters; estableceConexion(request.Transactional, connectionString); SqlParameter[] aparam = DevuelveParametros(request.CommandType, ref lista); if (request.Transactional) { return(ExecuteDatasets(m_TranSQL, request.CommandType, request.Command, aparam, request.TableNames)); } else { return(ExecuteDatasets(m_conecSQL, request.CommandType, request.Command, aparam, request.TableNames)); } } catch (Exception e) { throw e; } finally { if (!(request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }
public override int ExecuteNonQuery(ref DAABRequest request) { string connectionString = request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } if ((request.Command == null || request.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar."); } try { ArrayList lista = request.Parameters; OracleParameter[] aparam = DevuelveParametros(request.CommandType, ref lista); estableceConexion(request.Transactional, connectionString); int iretval; if (request.Transactional) { iretval = ExecuteNonQuerys(m_TranSQL, request.CommandType, request.Command, aparam); } else { iretval = ExecuteNonQuerys(m_conecSQL, request.CommandType, request.Command, aparam); } return(iretval); } finally { if (!(request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }
public abstract object ExecuteScalar(ref DAABRequest request);
public abstract DAABDataReader ExecuteReader(ref DAABRequest repuest);
public abstract void UpdateDataSet(ref DAABRequest requestInsert, ref DAABRequest requestUpdate, ref DAABRequest requestDelete);
public abstract void FillDataset(ref DAABRequest request);
public abstract DataSet ExecuteDataset(ref DAABRequest request);
public abstract int ExecuteNonQuery(ref DAABRequest request);
public override void UpdateDataSet(ref DAABRequest RequestInsert, ref DAABRequest RequestUpdate, ref DAABRequest RequestDelete) { string connectionString = RequestInsert.ConnectionString; OracleCommand cmdCommandInsert; OracleCommand cmdCommandUpdate; OracleCommand cmdCommandDelete; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } if ((RequestInsert.Command == null || RequestInsert.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar.RequestInsert"); } if ((RequestUpdate.Command == null || RequestUpdate.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar.RequestUpdate"); } if ((RequestDelete.Command == null || RequestDelete.Command.Length == 0)) { throw new ArgumentNullException("No ha ingresado el commando a ejecutar.RequestDelete"); } if ((RequestInsert.RequestDataSet == null)) { throw new ArgumentNullException("RequestDataSet:RequestInsert"); } if (RequestInsert.TableNames == null) { throw new ArgumentNullException("Falta especificar el nombre de la tabla a actualizar"); } try { bool cerrarCn = false; ArrayList lista = RequestInsert.Parameters; estableceConexion(RequestInsert.Transactional, connectionString); cmdCommandInsert = new OracleCommand(); OracleParameter[] aparamInsert = DevuelveParametros(RequestInsert.CommandType, ref lista); PrepareCommand(cmdCommandInsert, m_conecSQL, m_TranSQL, RequestInsert.CommandType, RequestInsert.Command, aparamInsert, ref cerrarCn); cmdCommandUpdate = new OracleCommand(); OracleParameter[] aparamUpdate = DevuelveParametros(RequestUpdate.CommandType, ref lista); PrepareCommand(cmdCommandUpdate, m_conecSQL, m_TranSQL, RequestUpdate.CommandType, RequestUpdate.Command, aparamUpdate, ref cerrarCn); cmdCommandDelete = new OracleCommand(); OracleParameter[] aparamDelete = DevuelveParametros(RequestDelete.CommandType, ref lista); PrepareCommand(cmdCommandDelete, m_conecSQL, m_TranSQL, RequestDelete.CommandType, RequestDelete.Command, aparamDelete, ref cerrarCn); UpdateDatasets(cmdCommandInsert, cmdCommandDelete, cmdCommandUpdate, RequestInsert.RequestDataSet, RequestInsert.TableNames[0]); } catch (Exception ex1) { RequestInsert.Exception = ex1; RequestDelete.Exception = ex1; RequestUpdate.Exception = ex1; throw ex1; } finally { if (!(RequestInsert.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }