/// <summary>
        /// 创建结果集对象--静态方法
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="sp">参数数组</param>
        /// <returns>DataSet结果集</returns>
        public static DataSet SCreateDataSet(string sql, SqlParameter[] sp)
        {
            DBSql dsSql = new DBSql();

            try
            {
                dsSql.dataadapter = dsSql.CreateDataAdapter(sql);
                if (sp != null)
                {
                    for (int i = 0; i < sp.Length; i++)
                    {
                        dsSql.dataadapter.SelectCommand.Parameters.Add(sp[i]);//将参数加到Command中
                    }
                }
                dsSql.dataset = new DataSet();
                dsSql.dataadapter.Fill(dsSql.dataset);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                dsSql.CloseDataReader();
                dsSql.CloseConnection();
            }
            return(dsSql.dataset);
        }
        /// <summary>
        /// 执行带参数的SQL语句--静态方法
        /// </summary>
        /// <param name="cmdText">sql语句</param>
        /// <param name="sp">SqlParameter数组</param>
        public static bool SRunSQL(string cmdText, SqlParameter[] sp)
        {
            DBSql dbSql = new DBSql();

            try
            {
                dbSql.command = dbSql.CreateCommand(cmdText);
                if (sp != null)
                {
                    for (int i = 0; i < sp.Length; i++)
                    {
                        dbSql.command.Parameters.Add(sp[i]);//将参数加到Command中
                    }
                }
                dbSql.command.ExecuteNonQuery();
                return(true);
            }
            catch (SqlException ex)
            {
                return(false);

                throw ex;
            }
            finally
            {
                dbSql.CloseDataReader();
                dbSql.CloseConnection();
            }
        }
        /// <summary>
        /// 创建结果集对象--静态方法
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <returns>DataSet对象</returns>
        public static DataSet SCreateDataSet(string sql)
        {
            DBSql dsSql = new DBSql();

            try
            {
                dsSql.dataadapter = dsSql.CreateDataAdapter(sql);
                dsSql.dataset     = new DataSet();
                dsSql.dataadapter.Fill(dsSql.dataset);
            }
            catch
            {
                return(null);
            }
            finally
            {
                dsSql.CloseDataReader();
                dsSql.CloseConnection();
            }
            return(dsSql.dataset);
        }