C#三层结构的问题

Question

我想添加一条记录 在
DAL层中是这样写的:
 public void AddProjectStatus(ProjectStatusInfo projectStatus)
        {
            SqlParameter paramProjectStatusName = new SqlParameter("@projectStatusName", SqlDbType.NVarChar);
            paramProjectStatusName.Value = projectStatus.ProjectStatusName;
            SqlParameter paramProjectStatusMemo = new SqlParameter("@projectStatusMemo", SqlDbType.NText);
            paramProjectStatusMemo.Value = projectStatus.ProjectStatusMemo;
            SqlParameter[] sqlParams = { paramProjectStatusName, paramProjectStatusMemo };
            SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "AddProjectStatus", sqlParams);
        }
在BLL层中是这样写的:
        private IProjectStatus projectStatusOptions;        public IProjectStatus ProjectStatusOptions
        {
            get {
                if (projectStatusOptions == null)
                    projectStatusOptions = DataAccess.CreateD_ProjectStatus();
                return projectStatusOptions;
                }
           
        }        public void Add(ProjectStatusInfo currentProjectStatus)
        {
            
            projectStatusOptions.AddProjectStatus(currentProjectStatus);
        }
在页面后方的cs中是如此调用:
 private B_ProjectStatus projectStatusOptions;    public B_ProjectStatus ProjectStatusOptions
    {
        get { 
            if(projectStatusOptions==null)
                projectStatusOptions= new B_ProjectStatus();
            return projectStatusOptions; }    }
  
    protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        ProjectStatusInfo projectStatus = new ProjectStatusInfo();
        
        projectStatus.ProjectStatusName = txtAddProjectStatus.Text.Trim();
        projectStatus.ProjectStatusMemo = txtAddProjectStatusDescription.Text.Trim();        projectStatusOptions.Add(projectStatus);
    }为什么每次都添不进去呢? 存储过程肯定没写错,麻烦各位给点意见 急等 谢谢```

Answer 1

看了被你的类名字看晕了
实例化ＢＬＬ对象调用Add 方法，参数为页面传入的值

Answer 2

调试一下
打开sql server跟踪器，看存储过程执行了没

Answer 3

怎么还念念不忘ADO.NET, 晕！

Answer 4

protected void btnAdd_Click(object sender, EventArgs e)
  {
  ProjectStatusInfo projectStatus = new ProjectStatusInfo();
   
  projectStatus.ProjectStatusName = txtAddProjectStatus.Text.Trim();
  projectStatus.ProjectStatusMemo = txtAddProjectStatusDescription.Text.Trim();  projectStatusOptions.Add(projectStatus);
  //好像projectStatusOptions没有获取对象
  //改成这样应该没问题吧this.ProjectStatusOptions.Add(projectStatus);
  }

Answer 5

你调试的时候没有出错？  我查了查SqlHelper.ExecuteNonQuery();这个方法，没有你那种重载，你自己又写了个？
用sql server跟踪器 看看，我也新手。

Answer 6

数据添加不上  确定数据库连接正常， sql语句是否正确  
像这些问题自己是可以搞定的！！