/// <summary> /// 新增和修改教师信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonOK_Click(object sender, EventArgs e) { TbTeacher teacher = new TbTeacher(); TbUser user = new TbUser(); user.Zt = int.Parse(userrole.SelectedValue); user.Xh = ""; teacher.LsName = teachername.Text.Trim(); user.YhName = teacheruser.Text.Trim(); //用户名(账号) user.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(teacherpwd.Text, "MD5"); //密码 teacher.ZyID = int.Parse(this.teacherzy.SelectedValue); //专业 teacher.Remark = textRemark.Text.Trim(); if (this.hidTeacherID.Value != "") /*用户编号不为空,即为修改时*/ { teacher.YhID = int.Parse(this.hidTeacherID.Value); user.YhID = teacher.YhID; TbUserManager.UpdateUserRoleByYhID(user); TbTeacherManager.UpdateTeacherInfoByYhID(teacher); this.hidTeacherID.Value = ""; } else { int yhid = TbUserManager.InsertTeacherUser(user.YhName, user.Xh, user.YhPwd, user.Zt);/*新增教师用户信息,返回其用户编号*/ if (yhid > 0) { int Result = TbTeacherManager.InsertTeacherInfo(yhid, teacher.LsName, teacher.ZyID, teacher.Remark); } } teacherzy.Items.Clear(); GetSpeciality(); GetPageInfo(); teachername.Text = ""; teacherpwd.Text = ""; teacheruser.Text = ""; }
static int FirstSxNum = 0;/*声明变量,初始化为0,用于判断筛选条件是否改变*/ /// <summary> /// 获取页面信息 /// </summary> public void GetPageInfo() { string lsname = this.txtTeacherName.Value.Trim() == "按教师名、用户名、专业名模糊查找" ? "" : this.txtTeacherName.Value.Trim(); if (lsname != "按教师名、用户名、专业名模糊查找" && lsname != "" && FirstSxNum == 0) { nowPage = 1; FirstSxNum = 1; } Record = TbTeacherManager.GetAllTeachersInfo(lsname).Rows.Count;;/*记录总数*/ TeacherList = TbTeacherManager.GetAllTeacherInfoPage(len, nowPage, lsname); if (Record == 0) { Pages = 1; } else { if (Record % len == 0) { Pages = (Record / len); } else { Pages = (Record / len) + 1; } } }
public static int maxPage = 0; //定义显示页面的最大页数,初始化为0 protected void Page_Load(object sender, EventArgs e) { HttpCookie usercookie = Request.Cookies["nowloginuser"]; string url = PublicClass.CheckLogin(usercookie, "main"); if (url != "") { Response.Write(url); return; } if (!IsPostBack) { string zyid = Request["ZyID"]; if (zyid != null) { //判断是否存在科目信息,存在则提示不能删除专业信息,不存在则执行删除操作 if (TbSubjectManager.QuerySubjectInfo(int.Parse(zyid)) <= 0) { //根据专业ID删除班级、老师信息表以及专业信息表对应的信息 TbClassManager.DeleteClassByZyID(int.Parse(zyid)); TbTeacherManager.DeleteTeaByZyID(int.Parse(zyid)); TbSpecialityManager.DeleteSpecByZyID(int.Parse(zyid)); } else { Page.RegisterStartupScript("", "<script>alert('存在专业对应的科目信息,如需继续执行删除操作,请先删除科目信息!')</script>"); } } GetAllSpenIntoCount(); } }
/// <summary> /// 根据教师编号LsID查询对应的详细信息 /// </summary> /// <param name="LsID"></param> private void GetTeacher(int YhID) { TbTeacher teacher = TbTeacherManager.GetTeacherInfoByLsID(YhID); TbUser user = TbUserManager.GetUserInfoByYhID(YhID); string role = ""; if (user.Zt == 1) { role = "管理员"; } else { role = "教师"; } TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(teacher.ZyID); string message = teacher.YhID + "|" + teacher.LsName + "|" + user.YhName + "|" + user.YhPwd + "|" + role + "|" + speciality.ZyName + "|" + teacher.Remark; Response.Write(message); }
public static int Record = 0; //定义当前符号查询的记录总数,初始化为0 protected void Page_Load(object sender, EventArgs e) { HttpCookie usercookie = Request.Cookies["nowloginuser"]; string url = PublicClass.CheckLogin(usercookie, "main"); if (url != "") { Response.Write(url); return; } if (!IsPostBack) { string lsid = Request["LsID"]; if (lsid != null) { int yhid = TbUserManager.GetTeacherUserYhID(int.Parse(lsid)); //根据教师编号LsID得到对应的用户编号 TbTeacherManager.DeleteTeacherInfo(int.Parse(lsid)); //根据教师编号LsID删除对应教师信息 TbUserManager.DeleteUserByYhID(yhid); //根据用户编号删除教师对应的用户信息 } GetPageInfo(); GetSpeciality(); } }