62,025
社区成员
发帖
与我相关
我的任务
分享
Web层
addStudent.aspx.cs
protected void btnAdd_Click(object sender, EventArgs e)
{
StudentInfo info = new StudentInfo();
info.Name = txtName.Text;
......
if (StudentBLL.AddStudent(info))
{
JScript.AlertAndRedirect("添加成功!", "ManageStudent.aspx");
}
}
addTeacher.aspx.cs
protected void btnAdd_Click(object sender, EventArgs e)
{
TeacherInfo info = new TeacherInfo();
info.Name = txtName.Text;
......
if (TeacherBLL.AddTeacher(info))
{
JScript.AlertAndRedirect("添加成功!", "ManageTeacher.aspx");
}
}
BLL层
(StudentBLL.cs)
public static bool AddStudent(StudentInfo info)
{
if (instance.AddStudent(info))
return true;
else
return false;
}
(TeacherBLL.cs)
public static bool AddTeacher(TeacherInfo info)
{
if (instance.AddTeacher(info))
return true;
else
return false;
}
DAL层
(StudentDAL.cs)
public bool AddStudent(StudentInfo info)
{
StringBuilder buffer = new StringBuilder();
buffer.Append("insert into People(Flag,Name,Sex) Values (@Flag,@Name,@Sex)");
SqlParameter[] parameters = {
new SqlParameter("@Flag",SqlDbType.Int,4)...};
parameters[0].Value = 1;
...
SqlDbHelper db = new SqlDbHelper();
return db.ExecuteNonQuery(buffer.ToString(), CommandType.Text, parameters) > 0;
}
(TeacherDAL.cs)
public bool AddTeacher(TeacherInfo info)
{
StringBuilder buffer = new StringBuilder();
buffer.Append("insert into People(Flag,Name,Sex) Values (@Flag,@Name,@Sex)");
SqlParameter[] parameters = {
new SqlParameter("@Flag",SqlDbType.Int,4)...};
parameters[0].Value = 2;
...
SqlDbHelper db = new SqlDbHelper();
return db.ExecuteNonQuery(buffer.ToString(), CommandType.Text, parameters) > 0;
}
DBUtility层
StudentInfo.cs
...
TeacherInfo.cs
...
Web层
addStudent.aspx.cs
protected void btnAdd_Click(object sender, EventArgs e)
{
PeopleInfo info = new PeopleInfo();
info.Name = txtName.Text;
info.Flag = 1;
......
if (PeopleBLL.AddPeople(info))
{
JScript.AlertAndRedirect("添加成功!", "ManageStudent.aspx");
}
}
addTeacher.aspx.cs
protected void btnAdd_Click(object sender, EventArgs e)
{
PeopleInfo info = new PeopleInfo();
info.Name = txtName.Text;
info.Flag = 2;
......
if (PeopleBLL.AddPeople(info))
{
JScript.AlertAndRedirect("添加成功!", "ManageStudent.aspx");
}
}
BLL层
(PeopleBLL.cs)
public static bool AddPeople(PeopleInfo info)
{
if (instance.AddPeople(info))
return true;
else
return false;
}
DAL层
(PeopleDAL.cs)
public bool AddPeope(PeopleInfo info)
{
StringBuilder buffer = new StringBuilder();
buffer.Append("insert into People(Flag,Name,Sex) Values (@Flag,@Name,@Sex)");
SqlParameter[] parameters = {
new SqlParameter("@Flag",SqlDbType.Int,4)...};
parameters[0].Value = info.Flag;
...
SqlDbHelper db = new SqlDbHelper();
return db.ExecuteNonQuery(buffer.ToString(), CommandType.Text, parameters) > 0;
}
DBUtility层
PeopleInfo.cs
...