protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindsTypes();
if (Request.QueryString["uid"] != null)
{
Sudents model = SudentsBLL.GetIdBySudents(Convert.ToInt32(Request.QueryString["uid"]));
ddlGrade.SelectedValue = model.Grade.ToString();
ddlMajorId.SelectedValue = ClassBLL.GetIdByClass(model.ClassId).MajorId.ToString();
ddlClassId.DataSource = ClassBLL.AllData(" and MajorId =" + ddlMajorId.SelectedValue, "ClassId", "asc");
ddlClassId.DataTextField = "ClassName";
ddlClassId.DataValueField = "ClassId";
ddlClassId.DataBind();
ddlClassId.SelectedValue = model.ClassId.ToString();
ddlNational.SelectedValue = model.National.Trim();
ddlPolitical.SelectedValue = model.Political.Trim();
txtBorn.Value = model.Born.ToString("yyyy-MM-dd") != "1900-01-01" ? model.Born.ToString("yyyy-MM-dd") : "";
txtContact.Value = model.Contact.Trim();
txtNative.Value = model.Native.Trim();
txtNote.Value = model.Note.Trim();
txtPwd.Value = model.Pwd.Trim();
txtSutCode.Value = model.SutCode.Trim();
txtSutName.Value = model.SutName.Trim();
ddlSex.SelectedValue = model.Sex.Trim();
btnAdd.Text = "修改";
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Sudents sud = SudentsBLL.GetIdBySudents(sudents.SutId);
sud.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
sud.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
sud.Contact = txtContact.Value.Trim();
sud.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
sud.National = ddlNational.SelectedValue.Trim();
sud.Native = txtNative.Value.Trim();
sud.Note = txtNote.Value.Trim();
sud.Political = ddlPolitical.SelectedValue.Trim();
sud.Pwd = lblPwd.Text.Trim();
sud.Sex = ddlSex.SelectedValue.Trim();
sud.SutCode = lblSutCode.Text.Trim();
sud.SutName = txtSutName.Value.Trim();
if (SudentsBLL.UpdateSudents(sud) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.replace('PersonalSudents.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
return;
}
}
private void BindsTypes()
{
ddlCourseId.DataSource = CourseBLL.AllData("", "CourseId", "");
ddlCourseId.DataTextField = "CourseName";
ddlCourseId.DataValueField = "CourseId";
ddlCourseId.DataBind();
ddlSutId.DataSource = SudentsBLL.AllData("", "SutId", "");
ddlSutId.DataTextField = "SutName";
ddlSutId.DataValueField = "SutId";
ddlSutId.DataBind();
ddlSemesterId.DataSource = SemesterBLL.AllData("", "SemesterId", "");
ddlSemesterId.DataTextField = "SemesterName";
ddlSemesterId.DataValueField = "SemesterId";
ddlSemesterId.DataBind();
ddlSemesterName.DataSource = SemesterBLL.AllData("", "SemesterId", "");
ddlSemesterName.DataTextField = "SemesterName";
ddlSemesterName.DataValueField = "SemesterId";
ddlSemesterName.DataBind();
ddlSemesterName.Items.Insert(0, new ListItem("全部", "0"));
ddlCourseName.DataSource = CourseBLL.AllData("", "CourseId", "");
ddlCourseName.DataTextField = "CourseName";
ddlCourseName.DataValueField = "CourseId";
ddlCourseName.DataBind();
ddlCourseName.Items.Insert(0, new ListItem("全部", "0"));
}
protected void lnkbDel_Click(object sender, EventArgs e)
{
LinkButton lnkbDel = (LinkButton)sender;
if (SudentsBLL.DeleteSudents(Convert.ToInt32(lnkbDel.CommandArgument)) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功！');window.location.replace('SudentsManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除失败！');</script>");
return;
}
}
protected void imgbLogin_Click(object sender, ImageClickEventArgs e)
{
//判断是学生、教师、还是老师登录
if (ddlType.SelectedValue == "学生") //学生登录
{
Sudents sudents = new Sudents(); //验证该学生登录信息是否与数据库中一致
if (SudentsBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out sudents))
{ //学生登录信息正确，将该学生添加到session并跳转到学生主页
Session["Sudents"] = sudents;
Response.Redirect("SudentsMain.aspx", false);
}
else
{ //学生登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
else if (ddlType.SelectedValue == "教师") //教师登录
{
Teacher teacher = new Teacher(); //验证该教师登录信息是否与数据库中一致
if (TeacherBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out teacher))
{ //教师登录信息正确，将该教师添加到session中并跳转到教师主页
Session["Teacher"] = teacher;
Response.Redirect("TeacherMain.aspx", false);
}
else
{ //教师登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
else if (ddlType.SelectedValue == "管理员") //管理员登录
{
Admin admin = new Admin(); //验证该管理员信息是否与数据库中一致
if (AdminBLL.GetUsersLogin(txtUserName.Value.Trim(), txtPwd.Value.Trim(), out admin))
{ //管理员登录信息正确，将该管理员添加到session中并跳转到管理员主页
Session["Admin"] = admin;
Response.Redirect("AdminMain.aspx", false);
}
else
{ //管理员登录信息错误，提示登录错误
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "<script>alert('用户名或者密码错误！');</script>");
return;
}
}
}
private void Binds()
{
if (ddlClassId.SelectedValue != "0")
{
strWhere += " and ClassId=" + ddlClassId.SelectedValue;
}
if (txtSutCode.Value.Length != 0)
{
strWhere += " and SutCode like '%" + txtSutCode.Value.Trim() + "%'";
}
if (txtSutName.Value.Length != 0)
{
strWhere += " and SutName like '%" + txtSutName.Value.Trim() + "%'";
}
rpView.DataSource = SudentsBLL.AllData(strWhere, "SutId", "asc");
rpView.DataBind();
rpPrint.DataSource = SudentsBLL.AllData(strWhere, "SutId", "asc");
rpPrint.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Sudents"] != null)
{
sudents = (Sudents)Session["Sudents"];
}
else
{
Response.Write("<script>parent.window.location.href='Login.aspx'</script>");
}
if (!IsPostBack)
{
BindsTypes();
Sudents sud = SudentsBLL.GetIdBySudents(sudents.SutId);
ddlGrade.SelectedValue = sud.Grade.ToString();
ddlMajorId.SelectedValue = ClassBLL.GetIdByClass(sud.ClassId).MajorId.ToString();
ddlClassId.DataSource = ClassBLL.AllData(" and MajorId =" + ddlMajorId.SelectedValue, "ClassId", "asc");
ddlClassId.DataTextField = "ClassName";
ddlClassId.DataValueField = "ClassId";
ddlClassId.DataBind();
ddlClassId.SelectedValue = sud.ClassId.ToString();
ddlNational.SelectedValue = sud.National.Trim();
ddlPolitical.SelectedValue = sud.Political.Trim();
txtBorn.Value = sud.Born.ToString("yyyy-MM-dd") != "1900-01-01" ? sud.Born.ToString("yyyy-MM-dd") : "";
txtContact.Value = sud.Contact.Trim();
txtNative.Value = sud.Native.Trim();
txtNote.Value = sud.Note.Trim();
lblSutCode.Text = sud.SutCode.Trim();
txtSutName.Value = sud.SutName.Trim();
ddlSex.SelectedValue = sud.Sex.Trim();
lblPwd.Text = sud.Pwd.Trim();
}
}
//添加、修改
protected void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "添加")
{
Sudents model = new Sudents();
model.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
model.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
model.Contact = txtContact.Value.Trim();
model.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
model.National = ddlNational.SelectedValue.Trim();
model.Native = txtNative.Value.Trim();
model.Note = txtNote.Value.Trim();
model.Political = ddlPolitical.SelectedValue.Trim();
model.Pwd = txtPwd.Value.Trim();
model.Sex = ddlSex.SelectedValue.Trim();
model.SutCode = txtSutCode.Value.Trim();
model.SutName = txtSutName.Value.Trim();
if (SudentsBLL.IsTrue(model.SutCode))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学号已经存在，不能重复！');</script>");
return;
}
else
{
if (SudentsBLL.AddSudents(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.replace('SudentsManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败！');</script>");
return;
}
}
}
else
{
Sudents model = SudentsBLL.GetIdBySudents(Convert.ToInt32(Request.QueryString["uid"]));
model.Born = txtBorn.Value != "" ? Convert.ToDateTime(txtBorn.Value) : Convert.ToDateTime("1900-01-01");
model.ClassId = Convert.ToInt32(ddlClassId.SelectedValue);
model.Contact = txtContact.Value.Trim();
model.Grade = Convert.ToInt32(ddlGrade.SelectedValue);
model.National = ddlNational.SelectedValue.Trim();
model.Native = txtNative.Value.Trim();
model.Note = txtNote.Value.Trim();
model.Political = ddlPolitical.SelectedValue.Trim();
model.Pwd = txtPwd.Value.Trim();
model.Sex = ddlSex.SelectedValue.Trim();
model.SutCode = txtSutCode.Value.Trim();
model.SutName = txtSutName.Value.Trim();
if (SudentsBLL.IsTrue(model.SutCode, model.SutId))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学号已经存在，不能重复！');</script>");
return;
}
else
{
if (SudentsBLL.UpdateSudents(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.replace('SudentsManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败！');</script>");
return;
}
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (Session["Admin"] != null)
{
Admin admin = (Admin)Session["Admin"];
if (admin.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
admin.Pwd = txtNewPwd.Value.Trim();
if (AdminBLL.UpdateUsers(admin) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
if (Session["Teacher"] != null)
{
Teacher teacher = (Teacher)Session["Teacher"];
if (teacher.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
teacher.Pwd = txtNewPwd.Value.Trim();
if (TeacherBLL.UpdateTeacher(teacher) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
if (Session["Sudents"] != null)
{
Sudents sudents = (Sudents)Session["Sudents"];
if (sudents.Pwd != txtOldPwd.Value.Trim())
{
txtOldPwd.Focus();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('旧密码错误！');</script>");
return;
}
else
{
sudents.Pwd = txtNewPwd.Value.Trim();
if (SudentsBLL.UpdateSudents(sudents) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码成功！\\n新密码为：" + txtNewPwd.Value.Trim() + "');location=location;</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改密码失败！');</script>");
return;
}
}
}
}
