protected void btnSubmit_Click(object sender, EventArgs e)
{
string no = txtDno.Text;
string name = txtDname.Text;
string dean = ddlDean.SelectedValue;
if (no.Length != 3 || name.Length > 20 || dean.Length != 4)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "UPDATE department SET no = '" + txtDno.Text + "', name = '" + txtDname.Text + "', dean = '" + ddlDean.SelectedValue + "' WHERE no = '" + ddlDepart.SelectedValue + "'; ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"部门" + name + "添加成功\");</script>");
Response.Redirect(".\\AltDepart.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"部门" + name + "添加失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string sno = txtSno.Text;
string sname = txtSname.Text;
string gender = ddlGender.SelectedValue;
int age = Convert.ToInt32(txtAge.Text);
string depart = ddlDepart.SelectedValue;
string specialty = txtSpecialty.Text;
if (sno.Length != 10 || sname.Length > 20 ||
(gender != "男" && gender != "女") || age < 0 || age > 150 ||
depart.Length != 3 || specialty.Length > 50)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT INTO student(sno, sname, gender, age, depart, specialty, spwd) " +
"VALUES('" + sno + "', '" + sname + "', '" + gender + "', " + age + ", '" + depart + "', '" + specialty + "', '" + sno + "');";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"学生" + sname + "添加成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"学生" + sname + "添加失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string no = txtDno.Text;
string name = txtDname.Text;
string dean = ddlDean.SelectedValue;
if (no.Length != 3 || name.Length > 20 || dean.Length != 4)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT INTO department(no, name, dean) " +
"VALUES('" + no + "', '" + name + "', '" + dean + "'); ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"部门" + name + "添加成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"部门" + name + "添加失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int grade = Convert.ToInt32(txtNewGrade.Text);
if (grade < 0 || grade > 100)
{
Response.Write("<script>alert('请输入正确的成绩');</script>");
}
else
{
string sqlCom = "UPDATE score " +
"SET grade=" + txtNewGrade.Text + " " +
"WHERE sno='" + ddlStudent.SelectedValue + "' and cno='" + ddlCourse.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的成绩修改成功\");</script>");
//Response.Redirect(".\\AltScore.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的成绩修改失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string id = txtId.Text;
string pwd = txtPwd.Text;
if (id.Length > 20 || pwd.Length > 20)
{
Response.Write("<script>alert('账号和密码长度不能超过20字符');</script>");
}
else
{
string sqlCom = "UPDATE admin " +
"SET adminID='" + id + "', adminPwd='" + pwd + "' WHERE adminID='" + ddlAdmin.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"管理员" + ddlAdmin.SelectedValue + "的信息修改成功\");</script>");
Response.Redirect(".\\AltAdmin.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"管理员" + ddlAdmin.SelectedValue + "的信息修改失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string cno = txtCno.Text;
string cname = txtCname.Text;
string pcno = ddlPcno.SelectedValue;
string tno = ddlTno.SelectedValue;
if (cno.Length != 8 || cname.Length > 20 || pcno.Length != 8 || tno.Length != 4)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "UPDATE course SET cno = '" + txtCno.Text + "', cname = '" + txtCname.Text + "', pcno = '" + ddlPcno.SelectedValue + "', tno = '" + ddlTno.SelectedValue + "' WHERE cno = '" + ddlCourse.SelectedValue + "'; ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(/课程" + cname + "添加成功/);</script>");
Response.Redirect(".\\AltCourses.aspx");
}
else
{
Response.Write("<sCrIpT>alert(/课程" + cname + "添加失败/);</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string tno = txtNewTno.Text;
string tname = txtNewTname.Text;
string gender = ddlNewGender.SelectedValue;
int age = Convert.ToInt32(txtNewAge.Text);
string depart = ddlNewDepart.SelectedValue;
string prof = txtNewProf.Text;
if (tno.Length != 4 || tname.Length > 20 ||
(gender != "男" && gender != "女") || age < 0 || age > 150 ||
depart.Length != 3 || prof.Length > 10)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "UPDATE teacher " +
"SET tno='" + tno + "', tname='" + tname + "', gender='" + gender + "', age=" + age + ", prof='" + prof + "', depart='" + depart + "' WHERE tno='" + ddlTeacher.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"教师" + ddlTeacher.SelectedValue + "的信息修改成功\");</script>");
//Response.Redirect(".\\AltTeacher.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"教师" + ddlTeacher.SelectedValue + "的信息修改失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string cno = txtCno.Text;
string cname = txtCname.Text;
string pcno = ddlPcno.SelectedValue;
string tno = ddlTno.SelectedValue;
if (cno.Length != 8 || cname.Length > 20 || pcno.Length != 8 || tno.Length != 4)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT INTO course(cno, cname, pcno, tno) " +
"VALUES('" + cno + "', '" + cname + "', '" + pcno + "', '" + tno + "'); ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(/课程" + cname + "添加成功/);</script>");
}
else
{
Response.Write("<sCrIpT>alert(/课程" + cname + "添加失败/);</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string oldPwd = txtOld.Text;
string newPwd = txtNew.Text;
string newPwd2 = txtNew2.Text;
if (oldPwd.Length > 20 || newPwd.Length > 20)
{
Response.Write("<script>alert('密码长度不能超过20字符');</script>");
}
else if (newPwd != newPwd2)
{
Response.Write("<script>alert('两次输入的密码不一致');</script>");
}
else
{
string sqlCom = "UPDATE student SET spwd='" + newPwd + "' " +
"WHERE sno='" + Session["id"].ToString() + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"密码修改成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"密码修改失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string cno = ddlCourse.SelectedValue;
string sno = txtSno.Text;
int grade = Convert.ToInt32(txtGrade.Text);
if (sno.Length != 10 || grade > 100 || grade < 0)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT INTO score(sno, cno, grade) " +
"VALUES('" + sno + "', '" + cno + "', " + grade + "); ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"学生" + sno + "的成绩录入成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"学生" + sno + "的成绩录入失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string sno = txtNewSno.Text;
string sname = txtNewSname.Text;
string gender = ddlNewGender.SelectedValue;
int age = Convert.ToInt32(txtNewAge.Text);
string depart = ddlNewDepart.SelectedValue;
string specialty = txtNewSpecialty.Text;
if (sno.Length != 10 || sname.Length > 20 ||
(gender != "男" && gender != "女") || age < 0 || age > 150 ||
depart.Length != 3 || specialty.Length > 50)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "UPDATE student " +
"SET sno='" + sno + "', sname='" + sname + "', gender='" + gender + "', age=" + age + ", depart='" + depart + "', specialty='" + specialty + "' WHERE sno='" + ddlStudent.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的信息修改成功\");</script>");
//Response.Redirect(".\\AltStudent.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"学生" + ddlStudent.SelectedValue + "的信息修改失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string cno = ddlCourse.SelectedValue;
string sno = Session["id"].ToString();
int grade = -1;
if (sno.Length != 10)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT INTO score(sno, cno, grade) " +
"VALUES('" + sno + "', '" + cno + "', " + grade + "); ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"选课成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"选课失败\");</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string tno = txtTno.Text;
string tname = txtTname.Text;
string gender = ddlGender.SelectedValue;
int age = Convert.ToInt32(txtAge.Text);
string depart = ddlDepart.SelectedValue;
string prof = txtProf.Text;
if (tno.Length != 4 || tname.Length > 20 ||
(gender != "男" && gender != "女") || age < 0 || age > 150 ||
depart.Length != 3 || prof.Length > 10)
{
Response.Write("<script>alert('请输入正确的信息');</script>");
}
else
{
string sqlCom = "INSERT teacher(tno, tname, gender, age, prof, depart, tpwd) " +
"VALUES('" + tno + "', '" + tname + "', '" + gender + "', " + age + ", '" + prof + "', '" + depart + "', '" + tno + "');";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"教师" + tname + "添加成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"教师" + tname + "添加失败\");</script>");
}
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
string sqlCom = "DELETE FROM student " +
"where sno='" + ddlSno.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"成绩记录已删除\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"成绩记录删除失败\");</script>");
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
string no = ddlDno.SelectedValue;
string sqlCom = "DELETE FROM department " +
"WHERE no = '" + no + "'; ";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"部门已删除\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"部门删除失败\");</script>");
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
string sqlCom = "DELETE FROM admin " +
"WHERE adminID='" + ddlAdmin.SelectedValue + "';";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"管理员账号已删除\");</script>");
Response.Redirect(".\\DelAdmin.aspx");
}
else
{
Response.Write("<sCrIpT>alert(\"管理员账号删除失败\");</script>");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string id = txtId.Text;
string pwd = txtPwd.Text;
if (id.Length > 20 || pwd.Length > 20)
{
Response.Write("<script>alert('账号或密码长度不超过20字符');</script>");
}
else
{
string sqlCom = "INSERT admin(adminID, adminPwd) " +
"VALUES('" + id + "', '" + pwd + "');";
OperateDataBase operate = new OperateDataBase();
if (operate.ExceSql(sqlCom))
{
Response.Write("<sCrIpT>alert(\"管理员" + id + "添加成功\");</script>");
}
else
{
Response.Write("<sCrIpT>alert(\"管理员" + id + "添加失败\");</script>");
}
}
}
