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