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