Example #1
0
 /// <summary>
 /// 执行SQL语句或者存储过程 ,返回参数object.第一行,第一列的值
 /// </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 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));
 }
Example #2
0
 /// <summary>
 /// 执行SQL语句或者存储过程 ,返回参数object.第一行,第一列的值
 /// </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 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));
 }