public int AddUserByPro(string sUserName, string sPassword, int nRole, string sEmailAddress, string s_PhoneNumber, int nRegionID, string sCusName)
 {
        SqlConnection myConnection = new SqlConnection(
            ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        SqlCommand myCommand = myConnection.CreateCommand();//创建command
        myCommand.CommandType = CommandType.StoredProcedure;//指定执行存储过程操作
        myCommand.CommandText = "AddUser";//存储过程名称

        ////往存储过程中添加参数
       myCommand.Parameters.Add("@UserName", SqlDbType.VarChar);
        myCommand.Parameters.Add("@Password", SqlDbType.VarChar);
        myCommand.Parameters.Add("@PhoneNumber", SqlDbType.VarChar);
         myCommand.Parameters.Add("@CustomerName", SqlDbType.VarChar);

        ////给存储过程的参数赋值
       myCommand.Parameters["@UserName"].Value = sUserName;
        myCommand.Parameters["@Password"].Value = sPassword;
        myCommand.Parameters["@Email"].Value = sEmailAddress;
        myCommand.Parameters["@PhoneNumber"].Value = s_PhoneNumber;
        myCommand.Parameters["@CustomerName"].Value = sCusName;

        //定义返回值
        int nResult = -1;
        try
        {
            myConnection.Open();

            //执行存储过程
            nResult = myCommand.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
        return nResult;
 }