public object ExecuteScalar(IDbConnection conn, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
object result = MySqlHelper.ExecuteScalar((MySqlConnection)conn, commandType, commandText, parameterValues);
return(result);
}
/// <summary>
/// 执行sql语句,ExecuteScalar 返回第一行第一列的值
/// </summary>
/// <param name="trans">事务param>
/// <param name="commandText">sql语句</param>
/// <param name="parameterValues">参数</param>
public object ExecuteScalar(IDbTransaction trans, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
object result = MySqlHelper.ExecuteScalar(trans, commandType, commandText, parameterValues);
return(result);
}
public object ExecuteScalar(IDbConnection conn, string commandText, CommandType commandType)
{
object result = MySqlHelper.ExecuteScalar((MySqlConnection)conn, commandType, commandText);
return(result);
}
public IDataReader ExecuteReader(IDbConnection conn, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
IDataReader dr = MySqlHelper.ExecuteReader((MySqlConnection)conn, commandType, commandText, parameterValues);
return(dr);
}
/// <summary>
/// 执行sql语句,ExecuteScalar 返回第一行第一列的值
/// </summary>
/// <param name="trans">事务</param>
/// <param name="commandText">sql语句</param>
public object ExecuteScalar(IDbTransaction trans, string commandText, CommandType commandType)
{
object result = MySqlHelper.ExecuteScalar(trans, commandType, commandText);
return(result);
}
public DataSet ExecuteDataSet(IDbTransaction trans, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
DataSet ds = MySqlHelper.ExecuteDataset(trans, commandType, commandText, parameterValues);
return(ds);
}
public IDataReader ExecuteReader(IDbConnection conn, string commandText, CommandType commandType)
{
IDataReader dr = MySqlHelper.ExecuteReader((MySqlConnection)conn, commandType, commandText);
return(dr);
}
public int ExecuteNonQuery(IDbConnection conn, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
int result = MySqlHelper.ExecuteNonQuery((MySqlConnection)conn, commandType, commandText, parameterValues);
return(result);
}
public IDataReader ExecuteReader(IDbTransaction trans, string commandText, CommandType commandType)
{
IDataReader dr = MySqlHelper.ExecuteReader(trans, commandType, commandText);
return(dr);
}
/// <summary>
/// 执行sql语句,返回影响的行数
/// </summary>
/// <param name="trans">事务对象</param>
/// <param name="commandText">sql语句</param>
/// <param name="parameterValues">参数</param>
public int ExecuteNonQuery(IDbTransaction trans, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
int result = MySqlHelper.ExecuteNonQuery(trans, commandType, commandText, parameterValues);
return(result);
}
public int ExecuteNonQuery(IDbConnection conn, string commandText, CommandType commandType)
{
int result = MySqlHelper.ExecuteNonQuery((MySqlConnection)conn, commandType, commandText);
return(result);
}
/// <summary>
/// 执行sql语句,返回影响的行数
/// </summary>
/// <param name="trans">事务对象</param>
/// <param name="commandText">sql语句</param>
public int ExecuteNonQuery(IDbTransaction trans, string commandText, CommandType commandType)
{
int result = MySqlHelper.ExecuteNonQuery(trans, commandType, commandText);
return(result);
}
public DataSet ExecuteDataSet(IDbConnection conn, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
DataSet ds = MySqlHelper.ExecuteDataset((MySqlConnection)conn, commandType, commandText, parameterValues);
return(ds);
}
public DataSet ExecuteDataSet(IDbConnection conn, string commandText, CommandType commandType)
{
DataSet ds = MySqlHelper.ExecuteDataset((MySqlConnection)conn, commandType, commandText);
return(ds);
}
/// <summary>
/// 回滚事务
/// </summary>
public void RollbackTractionand(IDbTransaction dbTransaction)
{
MySqlHelper.endTransactionRollback(dbTransaction);
}
public IDataReader ExecuteReader(IDbTransaction trans, string commandText, CommandType commandType, params IDataParameter[] parameterValues)
{
IDataReader dr = MySqlHelper.ExecuteReader(trans, commandType, commandText, parameterValues);
return(dr);
}
/// <summary>
/// 结束并确认事务
/// </summary>
public void CommitTractionand(IDbTransaction dbTransaction)
{
MySqlHelper.endTransactionCommit(dbTransaction);
}
public DataSet ExecuteDataSet(IDbTransaction trans, string commandText, CommandType commandType)
{
DataSet ds = MySqlHelper.ExecuteDataset(trans, commandType, commandText);
return(ds);
}