/// <summary> /// 添加 ///</summary> public static int AddSudents(Sudents SudentsModel) { string sql = string.Format("insert into Sudents (SutCode,SutName,ClassId,Native,Born,[National],Political,Sex,Grade,Contact,Note,Pwd )values(@SutCode,@SutName,@ClassId,@Native,@Born,@National,@Political,@Sex,@Grade,@Contact,@Note,@Pwd)"); SqlParameter[] para = { new SqlParameter("@SutCode", SqlDbType.NVarChar), new SqlParameter("@SutName", SqlDbType.NVarChar), new SqlParameter("@ClassId", SqlDbType.Int), new SqlParameter("@Native", SqlDbType.NVarChar), new SqlParameter("@Born", SqlDbType.DateTime), new SqlParameter("@National", SqlDbType.NVarChar), new SqlParameter("@Political", SqlDbType.NVarChar), new SqlParameter("@Sex", SqlDbType.NVarChar), new SqlParameter("@Grade", SqlDbType.Int), new SqlParameter("@Contact", SqlDbType.NVarChar), new SqlParameter("@Note", SqlDbType.NText), new SqlParameter("@Pwd", SqlDbType.NVarChar) }; para[0].Value = SudentsModel.SutCode; para[1].Value = SudentsModel.SutName; para[2].Value = SudentsModel.ClassId; para[3].Value = SudentsModel.Native; para[4].Value = SudentsModel.Born; para[5].Value = SudentsModel.National; para[6].Value = SudentsModel.Political; para[7].Value = SudentsModel.Sex; para[8].Value = SudentsModel.Grade; para[9].Value = SudentsModel.Contact; para[10].Value = SudentsModel.Note; para[11].Value = SudentsModel.Pwd; return(DBHelper.ExecuteCommand(sql, para)); }
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; } }
/// <summary> /// 验证用户是否能登录成功 /// </summary> /// <param name="UserName"></param> /// <param name="Pwd"></param> /// <param name="users"></param> /// <returns></returns> public static bool GetUsersLogin(string SutCode, string Pwd, out Sudents sudents) { sudents = SudentsDAL.GetIdBySutCode(SutCode); if (sudents != null && sudents.Pwd == Pwd) { return(true); } return(false); }
//添加验证是否存在 public static bool IsTrue(string SutCode) { Sudents sud = SudentsDAL.GetIdBySutCode(SutCode); if (sud != null && sud.SutId != 0) { return(true); } return(false); }
/// <summary> /// 根据主键查询实体 ///</summary> public static Sudents GetIdBySudents(int Id) { string sql = string.Format("SELECT * FROM Sudents where SutId={0} ", Id); Sudents SudentsModel = new Sudents(); using (DataTable table = DBHelper.GetDataSet(sql)) { SudentsModel = GetMode(table); } return(SudentsModel); }
/// <summary> /// 根据学号查询实体 ///</summary> public static Sudents GetIdBySutCode(string SutCode) { string sql = string.Format("SELECT * FROM Sudents where SutCode collate Chinese_PRC_CS_AS_WS = '{0}'", SutCode); Sudents SudentsModel = new Sudents(); using (DataTable table = DBHelper.GetDataSet(sql)) { SudentsModel = GetMode(table); } return(SudentsModel); }
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>"); } }
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; } } }
/// <summary> /// 私有方法 ///</summary> private static Sudents GetMode(DataTable table) { Sudents SudentsModel = new Sudents(); foreach (DataRow row in table.Rows) { SudentsModel.SutId = Convert.ToInt32(row["SutId"]); SudentsModel.SutCode = Convert.ToString(row["SutCode"]); SudentsModel.SutName = Convert.ToString(row["SutName"]); SudentsModel.ClassId = Convert.ToInt32(row["ClassId"]); SudentsModel.Native = Convert.ToString(row["Native"]); SudentsModel.Born = Convert.ToDateTime(row["Born"]); SudentsModel.National = Convert.ToString(row["National"]); SudentsModel.Political = Convert.ToString(row["Political"]); SudentsModel.Sex = Convert.ToString(row["Sex"]); SudentsModel.Grade = Convert.ToInt32(row["Grade"]); SudentsModel.Contact = Convert.ToString(row["Contact"]); SudentsModel.Note = Convert.ToString(row["Note"]); SudentsModel.Pwd = Convert.ToString(row["Pwd"]); } return(SudentsModel); }
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(); } }
/// <summary> /// 根据ID修改 ///</summary> public static int UpdateSudents(Sudents SudentsModel) { string sql = string.Format("UPDATE Sudents set SutCode=@SutCode,SutName=@SutName,ClassId=@ClassId,Native=@Native,Born=@Born,[National]=@National,Political=@Political,Sex=@Sex,Grade=@Grade,Contact=@Contact,Note=@Note,Pwd=@Pwd where SutId=@SutId"); SqlParameter[] para = { new SqlParameter("@SutCode", SqlDbType.NVarChar), new SqlParameter("@SutName", SqlDbType.NVarChar), new SqlParameter("@ClassId", SqlDbType.Int), new SqlParameter("@Native", SqlDbType.NVarChar), new SqlParameter("@Born", SqlDbType.DateTime), new SqlParameter("@National", SqlDbType.NVarChar), new SqlParameter("@Political", SqlDbType.NVarChar), new SqlParameter("@Sex", SqlDbType.NVarChar), new SqlParameter("@Grade", SqlDbType.Int), new SqlParameter("@Contact", SqlDbType.NVarChar), new SqlParameter("@Note", SqlDbType.NText), new SqlParameter("@Pwd", SqlDbType.NVarChar), new SqlParameter("@SutId", SqlDbType.Int) }; para[0].Value = SudentsModel.SutCode; para[1].Value = SudentsModel.SutName; para[2].Value = SudentsModel.ClassId; para[3].Value = SudentsModel.Native; para[4].Value = SudentsModel.Born; para[5].Value = SudentsModel.National; para[6].Value = SudentsModel.Political; para[7].Value = SudentsModel.Sex; para[8].Value = SudentsModel.Grade; para[9].Value = SudentsModel.Contact; para[10].Value = SudentsModel.Note; para[11].Value = SudentsModel.Pwd; para[12].Value = SudentsModel.SutId; return(DBHelper.ExecuteCommand(sql, para)); }
//添加、修改 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; } } } }
/// <summary> /// 修改 ///</summary> public static int UpdateSudents(Sudents SudentsModel) { return(SudentsDAL.UpdateSudents(SudentsModel)); }
/// <summary> /// 添加 ///</summary> public static int AddSudents(Sudents SudentsModel) { return(SudentsDAL.AddSudents(SudentsModel)); }
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; } } } }