/// <summary> /// Executes the query. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal override DbDataReader ExecuteQuery(DbSqlStructure structure) { DbCommand command = null; try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.Transaction = Transaction; command.CommandType = structure.SqlType; command.CommandTimeout = 0; return(ClientHelper.ExecuteQueryCommand(command, null, CommandBehavior.CloseConnection)); } catch { throw; } finally { if (command != null) { command.Dispose(); } } }
/// <summary> /// Executes the non query. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal override int ExecuteNonQuery(DbSqlStructure structure) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = this.Connection.CreateCommand(); command.CommandText = structure.Sql; command.Transaction = this.Transaction; command.CommandType = structure.SqlType; command.CommandTimeout = 0; return(this.ClientHelper.ExecuteNonQueryCommand(command, (List <DbInputParameter>)null)); } catch { throw; } finally { if (Connection != null) { Connection.Close(); } } }
/// <summary> /// Executes the non query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <param name="hasOutputValue">if set to <c>true</c> [has output value].</param> /// <param name="outparametername">The outparametername.</param> /// <returns></returns> internal override int ExecuteNonQuery(DbSqlStructure structure, List <DbInputParameter> parameters, bool hasOutputValue, string outparametername) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; command.Transaction = Transaction; command.CommandTimeout = 0; int num = ClientHelper.ExecuteNonQueryCommand(command, parameters); if (hasOutputValue && command.Parameters.Contains(outparametername)) { num = int.Parse(command.Parameters[outparametername].Value.ToString()); } return(num); } catch { throw; } finally { } }
/// <summary> /// Gets the one value. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal override object GetOneValue(DbSqlStructure structure) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; command.Transaction = Transaction; object obj = ClientHelper.ExecuteScalarCommand(command); if (obj != null && obj != DBNull.Value) { return(obj); } return(null); } catch { throw; } finally { } }
/// <summary> /// Executes the report query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal override DbDataAdapter ExecuteReportQuery(DbSqlStructure structure, List <DbInputParameter> parameters) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; command.CommandTimeout = 0; ClientHelper.AttachParameters(command, parameters); DbDataAdapter dataAdapter = Factory.CreateDataAdapter(); dataAdapter.SelectCommand = command; return(dataAdapter); } catch { throw; } finally { if (Connection != null) { Connection.Close(); } } }
/// <summary> /// Executes the query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal override DbDataReader ExecuteQuery(DbSqlStructure structure, List <DbInputParameter> parameters) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.Transaction = Transaction; command.CommandType = structure.SqlType; command.CommandTimeout = 0; return(ClientHelper.ExecuteQueryCommand(command, parameters, CommandBehavior.Default)); } catch { throw; } finally { } }
/// <summary> /// Executes the disconnected. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal override DataTable ExecuteDisconnected(DbSqlStructure structure, List <DbInputParameter> parameters) { DbDataAdapter dbDataAdapter = (DbDataAdapter)null; DataTable dataTable = new DataTable(); try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = this.Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; command.CommandTimeout = 0; ClientHelper.AttachParameters(command, parameters); dbDataAdapter = this.Factory.CreateDataAdapter(); dbDataAdapter.SelectCommand = command; dbDataAdapter.Fill(dataTable); return(dataTable); } catch { throw; } finally { if (dbDataAdapter != null) { dbDataAdapter.Dispose(); } if (Connection != null) { Connection.Close(); } } }
/// <summary> /// Executes the disconnected. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal override DataTable ExecuteDisconnected(DbSqlStructure structure) { DbDataAdapter dbDataAdapter = null; DataTable dataTable = new DataTable(); try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } DbCommand command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; command.CommandTimeout = 0; dbDataAdapter = Factory.CreateDataAdapter(); dbDataAdapter.SelectCommand = command; dbDataAdapter.Fill(dataTable); return(dataTable); } catch { throw; } finally { if (dbDataAdapter != null) { dbDataAdapter.Dispose(); } if (Connection != null) { Connection.Close(); } } }
/// <summary> /// Gets the one value. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal override object GetOneValue(DbSqlStructure structure, List <DbInputParameter> parameters) { DbCommand command = null; try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } command = Connection.CreateCommand(); command.CommandText = structure.Sql; command.CommandType = structure.SqlType; object obj = ClientHelper.ExecuteScalarCommand(command, parameters); if (obj != null && obj != DBNull.Value) { return(obj); } return(null); } catch { throw; } finally { if (command != null) { command.Dispose(); } if (Connection != null) { Connection.Close(); } } }
/// <summary> /// Executes the query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal abstract DbDataReader ExecuteQuery(DbSqlStructure structure, List <DbInputParameter> parameters);
/// <summary> /// Executes the report query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> internal virtual DbDataAdapter ExecuteReportQuery(DbSqlStructure structure, List <DbInputParameter> parameters) { throw new NotImplementedException(); }
/// <summary> /// Gets the one value. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal abstract object GetOneValue(DbSqlStructure structure, List <DbInputParameter> parameters);
/// <summary> /// Gets the one value. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal abstract object GetOneValue(DbSqlStructure structure);
/// <summary> /// Executes the non query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <param name="hasOutputValue">if set to <c>true</c> [has output value].</param> /// <param name="outparametername">The outparametername.</param> /// <returns></returns> internal abstract int ExecuteNonQuery(DbSqlStructure structure, List <DbInputParameter> parameters, bool hasOutputValue, string outparametername);
/// <summary> /// Executes the non query. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> internal abstract int ExecuteNonQuery(DbSqlStructure structure, List <DbInputParameter> parameters);
/// <summary> /// Executes the non query. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal abstract int ExecuteNonQuery(DbSqlStructure structure);
/// <summary> /// Executes the disconnected. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> internal virtual DataTable ExecuteDisconnected(DbSqlStructure structure) { throw new NotImplementedException(); }
/// <summary> /// Executes the disconnected. /// </summary> /// <param name="structure">The structure.</param> /// <param name="parameters">The parameters.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> internal virtual DataTable ExecuteDisconnected(DbSqlStructure structure, List <DbInputParameter> parameters) { throw new NotImplementedException(); }
/// <summary> /// Executes the query. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> internal abstract DbDataReader ExecuteQuery(DbSqlStructure structure);
/// <summary> /// Executes the report query. /// </summary> /// <param name="structure">The structure.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> internal virtual DbDataAdapter ExecuteReportQuery(DbSqlStructure structure) { throw new NotImplementedException(); }