C#三层结构的问题
我想添加一条记录 在
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);
}
为什么每次都添不进去呢? 存储过程肯定没写错,麻烦各位给点意见 急等 谢谢```