[C#]分享一个以前的项目使用的DataBaseAccess类(8)

/// <summary>
        /// Execute SQL Command,add new resultset into current ref DataSet.
        /// </summary>
        /// <param>SQL Command which will be Executed</param>
        /// <param>table name</param>
        /// <param>current Dataset</param>
        public void ExecuteSqlFillDs(string strSql, string strTableName, ref DataSet dsRef)
        {
            debug("Now Execute DataBaseAccess's Method:ExecuteSqlFillDs(string,string,ref DataSet)");
            ExecuteSqlFillDs(new SqlCommand(strSql),strTableName, ref dsRef);
        }

/// <summary>
        /// Execute SQL Command,add new resultset into current ref DataSet.
        /// </summary>
        /// <param>SQL Command which will be Executed</param>
        /// <param>SQL Parameters Collection</param>
        /// <param>table name</param>
        /// <param>Current Dataset</param>
        public void ExecuteSqlFillDs(string strSql, SqlParameter[] sqlParameters, string strTableName, ref DataSet dsRef)
        {
            debug("Now Execute DataBaseAccess's Method:ExecuteSqlFillDs(string strSql, SqlParameter[], string, ref DataSet)");
            ExecuteSqlFillDs(SQLHelper.CreateCommand(strSql, sqlParameters, this.conn), strTableName, ref dsRef);
        }

#endregion

#region ExecuteSqlDsEx

/// <summary>
        ///  Define pagination(Execute SQL Command,return DataSet).
        /// </summary>
        /// <param>SQL Command which will be Executed</param>
        /// <param>index of StartRecord</param>
        /// <param>number of Records</param>
        /// <param>table name</param>
        /// <returns>return DataSet</returns>
        public DataSet ExecuteSqlDsEx(SqlCommand sqlcmd, int iStartRecord, int iMaxRecord, string strTableName)
        {
            debug("Now Execute DataBaseAccess's Method:ExecuteSqlDsEx(SqlCommand,int,int,string),Return Type：DataSet ");
            sqlcmd.Connection = this.conn;
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlcmd);
            DataSet dsReapter = new DataSet();