示例#1
0
 /// <summary>
 /// 执行SQL语句或者存储过程 ,返回参数dataset
 /// </summary>
 /// <param name="trans">语句所在的事务</param>
 /// <param name="commandText">SQL语句或者存储过程名</param>
 /// <param name="commandParameters">SQL语句或者存储过程参数</param>
 /// <param name="commandType">SQL语句类型</param>
 /// <param name="commandTimeout">超时时间</param>
 /// <returns>执行结果集</returns>
 public DataSet ExecuteDataSet(IDbTransaction trans, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null)
 {
     return(SQLHelper.ExecuteDataset(trans, commandText, commandParameters, commandType, commandTimeout));
 }
示例#2
0
 /// <summary>
 /// 执行SQL语句或者存储过程 ,返回参数dataset
 /// </summary>
 /// <param name="conn">要执行SQL语句的连接</param>
 /// <param name="commandText">SQL语句或者存储过程名</param>
 /// <param name="commandParameters">SQL语句或者存储过程参数</param>
 /// <param name="commandType">SQL语句类型</param>
 /// <param name="commandTimeout">超时时间</param>
 /// <returns>执行结果集</returns>
 public DataSet ExecuteDataSet(IDbConnection conn, string commandText, List <IDataParameter> commandParameters = null, CommandType commandType = CommandType.Text, int?commandTimeout = null)
 {
     return(SQLHelper.ExecuteDataset((MySqlConnection)conn, commandText, commandParameters, commandType, commandTimeout));
 }