//修改管理员是否为监考老师 public int ChangeAdminExamTeacher(string tId) { int res = 0; try { Teacher teacher = db.Teacher.First(t => t.TId == tId); if (teacher.isExamTeacher == (int)IsExamTeacher.Yes)//取消该教师的监考老师资格 { teacher.isExamTeacher = (int)IsExamTeacher.No; db.SubmitChanges(); List <Authority> deleteAuthority = (from p in db.Authority join q in db.TeaAuthority on p.AuthorityId equals q.AuthorityId where q.TId == tId && p.AuthorityType == (int)AuthorityBLL.AuthorityType.ExamTeacher select p).ToList(); //从权限信息中删除监考老师权限 foreach (var item in deleteAuthority) { TeaAuthority teaAu = db.TeaAuthority.First(t => t.TId == tId && t.AuthorityId == item.AuthorityId); db.TeaAuthority.DeleteOnSubmit(teaAu); db.SubmitChanges(); } } else //设置管理员为该监考老师 { teacher.isExamTeacher = (int)IsExamTeacher.Yes; //获取监考老师权限 List <Authority> examTeacherAu = db.Authority.Where(t => t.AuthorityType == (int)AuthorityBLL.AuthorityType.ExamTeacher).ToList(); //插入该管理员的权限信息中 foreach (var item in examTeacherAu) { TeaAuthority teaAu = new TeaAuthority() { AuthorityId = item.AuthorityId, TId = tId }; db.TeaAuthority.InsertOnSubmit(teaAu); db.SubmitChanges(); } } res = 1; } catch (Exception ex) { res = 0; } return(res); }
protected void btn_GrantGroup_Click(object sender, EventArgs e) { bool flag = false; userName = Request.QueryString["username"].ToString(); try { foreach (RepeaterItem item in rp_AutorityGrant.Items) { if (((CheckBox)item.FindControl("cb_Select")).Checked == true) { flag = true; int Aid = Int32.Parse(((HiddenField)item.FindControl("hi_Id")).Value); var cs = new TeaAuthority { AuthorityId = Aid, TId = userName }; db.TeaAuthority.InsertOnSubmit(cs); } } if (flag == false) { ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('请先勾选功能!');</script>"); return; } else { db.SubmitChanges(); ClientScript.RegisterStartupScript(this.GetType(), "message", "<script> alert('权限授予成功!');</script>"); // ClientScript.RegisterStartupScript(this.GetType(), "message", "<script> alert('权限授予成功!');window.location='GrantAuthority.aspx?username=userName';</script>"); } Bindata(); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('权限授予失败,请重试!');</script>"); return; } }
protected void btn_GrantGroup_Click(object sender, EventArgs e) { bool flag = false; userName = Request.QueryString["username"].ToString(); try { foreach (RepeaterItem item in rp_AutorityGrant.Items) { if (((CheckBox)item.FindControl("cb_Select")).Checked == true) { flag = true; int Aid = Int32.Parse(((HiddenField)item.FindControl("hi_Id")).Value); TeaAuthority cs = db.TeaAuthority.Single(a => a.TId == userName && a.AuthorityId == Aid);//删除权限 db.TeaAuthority.DeleteOnSubmit(cs); } } if (flag == false) { ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('请先勾选功能!');</script>"); return; } else { db.SubmitChanges(); ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('权限回收成功!');</script>"); Bindata(); } Bindata(); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('权限回收失败,请重试!');</script>"); return; } }
///删除教师 public int DeleteTeacher(Teacher teacher) { try { List <Authority> authority = authorityBll.GetAuthorityByUserId(teacher.TId); foreach (var item in authority) { TeaAuthority teaAu = db.TeaAuthority.Where(t => t.TId == teacher.TId && t.AuthorityId == item.AuthorityId).First(); db.TeaAuthority.DeleteOnSubmit(teaAu); } Teacher deleteTeacher = db.Teacher.Where(t => t.TId == teacher.TId).First(); db.Teacher.DeleteOnSubmit(deleteTeacher); db.SubmitChanges(); return(1); } catch (Exception ex) { return(0); } }