/// <summary>
/// 结束并确认事务
/// </summary>
public void CommitTractionand(IDbTransaction dbTransaction)
{
SQLHelper.endTransactionCommit(dbTransaction);
}
/// <summary>
/// 回滚事务
/// </summary>
public void RollbackTractionand(IDbTransaction dbTransaction)
{
SQLHelper.endTransactionRollback(dbTransaction);
}
/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回参数object．第一行，第一列的值
/// </summary>
/// <param name="trans">语句所在的事务</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>执行结果集第一行，第一列的值</returns>
public object ExecuteScalar(IDbTransaction trans, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null)
{
return(SQLHelper.ExecuteScalar(trans, commandText, commandParameters, commandType, commandTimeout));
}
/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回参数object．第一行，第一列的值
/// </summary>
/// <param name="conn">要执行ＳＱＬ语句的连接</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>执行结果集第一行，第一列的值</returns>
public object ExecuteScalar(IDbConnection conn, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null)
{
return(SQLHelper.ExecuteScalar((MySqlConnection)conn, commandText, commandParameters, commandType, commandTimeout));
}
/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回IEnumerable<T>
/// </summary>
/// <typeparam name="T">返回类似</typeparam>
/// <param name="trans">语句所在的事务</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>IEnumerable</returns>
public IEnumerable <T> ExecuteIEnumerable <T>(IDbTransaction trans, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null) where T : class, new()
{
IDataReader dr = SQLHelper.ExecuteReader(trans, commandText, commandParameters, commandType, commandTimeout);
return(DataReaderExtensions.DataReaderToList <T>(dr));
}
/// <summary>
/// 执行ＳＱＬ语句或者存储过程 ,返回DataReader
/// </summary>
/// <param name="connKey">连接字符串Key</param>
/// <param name="commandText">ＳＱＬ语句或者存储过程名</param>
/// <param name="commandParameters">ＳＱＬ语句或者存储过程参数</param>
/// <param name="commandType">ＳＱＬ语句类型</param>
/// <param name="commandTimeout">超时时间</param>
/// <returns>DataReader</returns>
public IDataReader ExecuteReader(string connKey, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null)
{
MySqlConnection conn = GetConnByKey(connKey);
return(SQLHelper.ExecuteReader(conn, commandText, commandParameters, commandType, commandTimeout));
}
