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); SqlParameter[] 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 = ConvertToOracleParameter(Request.CommandType, 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); } AsingValueParameter(aparam, ref lista); } 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 object ExecuteScalar(ref DAABRequest Request) { string connectionString = Request.ConnectionString; Object objObject = new Object(); 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 = ConvertToOracleParameter(Request.CommandType, lista); if (Request.Transactional) { objObject = ExecuteScalares(m_TranSQL, Request.CommandType, Request.Command, aparam); } else { objObject = ExecuteScalares(m_conecSQL, Request.CommandType, Request.Command, aparam); } AsingValueParameter(aparam, ref lista); } catch (Exception ex) { Request.Exception = ex; throw ex; } finally { if (!(Request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } return(objObject); }
public override DataSet ExecuteDataset(ref DAABRequest request) { string connectionString = request.ConnectionString; DataSet objDataSet = new DataSet(); 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 = ConvertToOracleParameter(request.CommandType, lista); if (request.Transactional) { objDataSet = ExecuteDatasets(m_TranSQL, request.CommandType, request.Command, aparam, request.TableNames); } else { objDataSet = ExecuteDatasets(m_conecSQL, request.CommandType, request.Command, aparam, request.TableNames); } AsingValueParameter(aparam, ref lista); } catch (Exception ex) { request.Exception = ex; throw ex; } finally { if (!(request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } return(objDataSet); }
public override DAABDataReader ExecuteReader(ref DAABRequest Request) { DAABOracleDataReader oDataReaderSQL; string connectionString = Request.ConnectionString; if ((connectionString == null || connectionString.Length == 0)) { throw new ArgumentNullException("connectionString"); } try { ArrayList lista = Request.Parameters; OracleParameter[] aparam = ConvertToOracleParameter(Request.CommandType, lista); estableceConexion(false, connectionString); OracleDataReader drSQL; drSQL = ExecuteReaders(m_conecSQL, ((OracleTransaction)(null)), Request.CommandType, Request.Command, aparam); oDataReaderSQL = new DAABOracleDataReader(); oDataReaderSQL.ReturnDataReader = drSQL; AsingValueParameter(aparam, ref lista); return(oDataReaderSQL); } catch (OracleException ex1) { if (!(m_conecSQL == null)) { m_conecSQL.Dispose(); } Request.Exception = ex1; throw ex1; } catch (Exception ex1) { Request.Exception = ex1; if (!(m_conecSQL == null)) { m_conecSQL.Dispose(); } throw; } }
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 = ConvertToOracleParameter(Request.CommandType, 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); } AsingValueParameter(aparam, ref lista); return(iretval); } finally { if (!(Request.Transactional) & !(m_conecSQL == null)) { m_conecSQL.Dispose(); } } }
public abstract DataSet ExecuteDataset(ref DAABRequest Request);
public abstract int ExecuteNonQuery(ref DAABRequest Request);
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 override void UpdateDataSet(ref DAABRequest RequestInsert, ref DAABRequest RequestUpdate, ref DAABRequest RequestDelete) { string connectionString = RequestInsert.ConnectionString; SqlCommand cmdCommandInsert; SqlCommand cmdCommandUpdate; SqlCommand 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 SqlCommand(); SqlParameter[] aparamInsert = DevuelveParametros(RequestInsert.CommandType, ref lista); PrepareCommand(cmdCommandInsert, m_conecSQL, m_TranSQL, RequestInsert.CommandType, RequestInsert.Command, aparamInsert, ref cerrarCn); cmdCommandUpdate = new SqlCommand(); SqlParameter[] aparamUpdate = DevuelveParametros(RequestUpdate.CommandType, ref lista); PrepareCommand(cmdCommandUpdate, m_conecSQL, m_TranSQL, RequestUpdate.CommandType, RequestUpdate.Command, aparamUpdate, ref cerrarCn); cmdCommandDelete = new SqlCommand(); SqlParameter[] 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(); } } }