/// <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>bool</returns>
        public static bool STRunSQL(string sql)
        {
            DBSql dbSql = new DBSql();

            try
            {
                dbSql.command = dbSql.CreateCommand(sql);
                dbSql.command.ExecuteNonQuery();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);

                throw ex;
            }
            finally
            {
                dbSql.CloseConnection();
            }
        }