C#关于Command命令抽象类

       public void Button1_Click(object sender, EventArgs e)
       {
           XKM.Model.B b = new XKM.Model.B();
           b.Name = System.Web.HttpContext.Current.Request["name"];
           b.Age = System.Web.HttpContext.Current.Request["age"];
           b.League = System.Web.HttpContext.Current.Request["league"];
           b.Club = System.Web.HttpContext.Current.Request["club"];
           b.Location = System.Web.HttpContext.Current.Request["location"];
           b.Country = System.Web.HttpContext.Current.Request["country"];
           b.Insert();
           MessageBox.Show("添加成功");
           System.Web.HttpContext.Current.Response.Redirect("Web2.aspx");

        public int Insert()//添加
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("insert into B(");
            sb.Append("Name,Age,League,Club,Location,Country)");
            sb.Append("values(");
            sb.Append("@Name,@Age,@League,@Club,@Location,@Country)");
            sb.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@Name", SqlDbType.VarChar,50),
                    new SqlParameter("@Age", SqlDbType.VarChar,50),
                    new SqlParameter("@League", SqlDbType.VarChar,50),
                    new SqlParameter("@Club", SqlDbType.VarChar,50),
                    new SqlParameter("@Location", SqlDbType.VarChar,50),
                    new SqlParameter("@Country", SqlDbType.VarChar,50) };
            parameters[0].Value = Name;
            parameters[1].Value = Age;
            parameters[2].Value = League;
            parameters[3].Value = Club;
            parameters[4].Value = Location;
            parameters[5].Value = Country;
            object obj = SQL.GetSingle(sb.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

        public static object GetSingle(string SQLString, params SqlParameter[] cmdParms)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    try
                    {
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        object obj = cmd.ExecuteScalar();
                        cmd.Parameters.Clear();                        
                        if ((Object.Equals(obj, null))||(Object.Equals(obj, System.DBNull.Value)))
                        {
                            connection.Close();
                            return null;
                        }
                        else
                        {
                            connection.Close();
                            return obj;
                        }
                    }
                    catch (System.Data.SqlClient.SqlException e)
                    {
                        connection.Close();
                        //throw e;
                        return null;
                    }
                }
            }
        }
        private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, string cmdText, SqlParameter[] cmdParms)
        {
            if (conn.State != ConnectionState.Open)
                conn.Open();
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
            if (trans != null)
                cmd.Transaction = trans;
            cmd.CommandType = CommandType.Text;//cmdType;
            if (cmdParms != null)
            {
                foreach (SqlParameter parameter in cmdParms)
                {
                    if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
                        (parameter.Value == null))
                    {
                        parameter.Value = DBNull.Value;
                    }
                    cmd.Parameters.Add(parameter);
                }
            }
        }

写了一个添加的代码，发现执行不了，大概是最后的PrepareCommand这个函数出问题了，但是具体是哪我也不太清楚，想请教请教网上的大神到底是哪出问题了