protected void editGroup_Click(object sender, EventArgs e) { Regex re = new Regex(@"(http|https)://[^\s]*"); if (txtGpName.Text.Trim().Equals(string.Empty)) { Response.Write(JSHelper.ShowAlert("组织名称不能为空!")); return; } if (!re.IsMatch(txtGpLink.Text)) { Response.Write(JSHelper.ShowAlert("请输入正确网址!")); return; } if (GroupHelper.Select(txtGpName.Text) != null) { Response.Write(JSHelper.ShowAlert("该组织已存在!")); return; } if (GroupHelper.Add(txtGpName.Text.Trim(), dplAddTyped.SelectedValue, Image1.ImageUrl, txtGpLink.Text.Trim())) { Response.Write(JSHelper.ShowAlert("添加成功!")); Response.Redirect("groupList.aspx"); } else { Response.Write(JSHelper.ShowAlert("添加失败!请重试!")); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='Login.aspx';</script>"); } int gpID = 1; try { gpID = Convert.ToInt32(Request.QueryString["groupId"].ToString()); } catch { gpID = 1; } pageGp = GroupHelper.Select(gpID); if (!IsPostBack) { #region 绑定数据 txtGpName.Text = pageGp.GroupName; dpl.Text = GroupHelper.getTypeOfString(pageGp.groupType); txtGpLink.Text = pageGp.Link; Image1.ImageUrl = pageGp.Img; #endregion gdvGpLs.DataSource = GroupHelper.getAllNumberOfGroup(pageGp.GroupID); gdvGpLs.DataBind(); if (gdvGpLs.Rows.Count == 0) { lbtnJumpAddOrgNum.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='Login.aspx';</script>"); } else if (!IsPostBack) { User u = (User)Session["User"]; if (u != null) { var db = new oucITEntities(); var teac = (from a in db.Teacher where a.UserID == u.UserID select a).FirstOrDefault(); if (teac != null) { lblName.Text = teac.Name; var query = (from a in db.Connection where a.UserID == u.UserID select a.ITGroup.GroupName).ToList(); if (query.Count != 0) { ddlGroup.DataSource = query; ddlGroup.DataBind(); ITGroup itgroup = GroupHelper.Select(ddlGroup.Text); var conn = (from a in db.Connection where a.UserID == u.UserID && a.GroupID == itgroup.GroupID select a).FirstOrDefault(); if (conn != null) { txtDuty.Text = conn.Duty; txtJob.Text = conn.Job; txtEmail.Text = conn.Email; txtPhone.Text = conn.Phone; } } else { Response.Redirect("Index.aspx"); } } else { Response.Redirect("Index.aspx"); } } } }
protected void submit_Click(object sender, EventArgs e) { if (ConnHelp.Update(connID, GroupHelper.Select(dplGp.SelectedValue).GroupID, ddlClass.SelectedValue, ddlRight.SelectedValue)) { string url = Request.RawUrl; Response.Write("<script>alert('修改成功!');location.href='" + url + "'</script>"); //Response.Write("<script>alert('');location.href='groupList.aspx'</script>"); //Response.Redirect(Request.RawUrl); } else { string url = Request.RawUrl; Response.Write("<script>alert('修改失败,请重试!');location.href='" + url + "'</script>"); } }
protected void ddlGroup_SelectedIndexChanged(object sender, EventArgs e) { User u = (User)Session["User"]; var db = new oucITEntities(); ITGroup itgroup = GroupHelper.Select(ddlGroup.Text); var conn = (from a in db.Connection where a.UserID == u.UserID && a.GroupID == itgroup.GroupID select a).FirstOrDefault(); if (conn != null) { txtDuty.Text = conn.Duty; txtJob.Text = conn.Job; txtEmail.Text = conn.Email; txtPhone.Text = conn.Phone; } }
protected void btnEdit_Click(object sender, EventArgs e) { User u = (User)Session["User"]; var db = new oucITEntities(); ITGroup itgroup = GroupHelper.Select(ddlGroup.Text); var conn = (from a in db.Connection where a.UserID == u.UserID && a.GroupID == itgroup.GroupID select a).FirstOrDefault(); if (ConnHelp.MessUpdate(conn.GroupID, u.UserID, txtJob.Text, txtDuty.Text, txtPhone.Text, txtEmail.Text)) { Response.Write("<script>alert('修改成功!');window.location.href ='Index.aspx'</script>"); } else { Response.Write(JSHelper.ShowAlert("修改失败")); } }
protected void btnDelCheck_Click(object sender, EventArgs e) { if (txtDelete.Text.Length == 0) { Response.Write(JSHelper.ShowAlert("输入不能为空!")); } else { var user = UserHelper.Select(txtDelete.Text); if (user == null) { lblDelete.Text = "该组不存在该老师或学生<br/>"; } else { var teac = TeacherHelper.Select(user.UserID); var stu = StudentHelper.Select(user.UserID); if (teac != null || stu != null) { var itgroup = GroupHelper.Select(ddlDelete.Text); var db = new oucITEntities(); var conn = (from a in db.Connection where a.UserID == user.UserID && a.GroupID == itgroup.GroupID select a).SingleOrDefault(); if (conn != null && teac != null) { lblDelete.Text = teac.Name; } else if (conn != null && stu != null) { lblDelete.Text = stu.Name; } else { lblDelete.Text = "该组不存在该老师或学生<br/>"; } } else { lblDelete.Text = "该组不存在该老师<br/>"; } } } }
protected void btnDelete_Click(object sender, EventArgs e) { if (txtDelete.Text.Length == 0) { Response.Write(JSHelper.ShowAlert("输入不能为空!")); } else { var user = UserHelper.Select(txtDelete.Text); if (user == null) { Response.Write(JSHelper.ShowAlert("该组不存在该老师")); } else { var teac = TeacherHelper.Select(user.UserID); var stu = StudentHelper.Select(user.UserID); if (teac != null || stu != null) { var itgroup = GroupHelper.Select(ddlDelete.Text); var db = new oucITEntities(); var conn = (from a in db.Connection where a.UserID == user.UserID && a.GroupID == itgroup.GroupID select a).SingleOrDefault(); if (conn != null) { db.Connection.Remove(conn); db.SaveChanges(); Response.Write("<script>alert('删除成功!');window.location.href ='Index.aspx'</script>"); } else { Response.Write(JSHelper.ShowAlert("该组不存在该老师或学生")); } } else { Response.Write(JSHelper.ShowAlert("该组不存在该老师或学生")); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var db = new oucITEntities(); if (Request.QueryString["type"] != "组织机构") { Response.Redirect("index.aspx"); } string item = "党委团委"; if (Request.QueryString["item"] != null) { item = Request.QueryString["item"]; } // 绑定组织结构列表 if (item == "党委团委") { // 显示党委团委对应Panel,下同 Panel1.Visible = true; Panel2.Visible = false; Panel3.Visible = false; // 绑定右侧列表,下同 var ITgroup = GroupHelper.Select("学院党委"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater1.DataSource = xydwlist.ToList(); Repeater1.DataBind(); } ITgroup = GroupHelper.Select("学院团委"); if (ITgroup != null) { var xytwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater2.DataSource = xytwlist.ToList(); Repeater2.DataBind(); } ITgroup = GroupHelper.Select("教工党支部"); if (ITgroup != null) { var jgdzblist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class, a.Job select a; Repeater3.DataSource = jgdzblist.ToList(); Repeater3.DataBind(); } ITgroup = GroupHelper.Select("学生党支部"); if (ITgroup != null) { var xsdzblist = from a in db.Connection where a.GroupID == ITgroup.GroupID select new { Job = a.Job }; Repeater4.DataSource = xsdzblist.ToList(); Repeater4.DataBind(); } } else if (item == "院行政") { Panel1.Visible = false; Panel2.Visible = true; Panel3.Visible = false; var ITgroup = GroupHelper.Select("院行政"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater5.DataSource = xydwlist.ToList(); Repeater5.DataBind(); } ITgroup = GroupHelper.Select("院办公室"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater6.DataSource = xydwlist.ToList(); Repeater6.DataBind(); } ITgroup = GroupHelper.Select("物理系"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater7.DataSource = xydwlist.ToList(); Repeater7.DataBind(); } ITgroup = GroupHelper.Select("电子工程系"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater8.DataSource = xydwlist.ToList(); Repeater8.DataBind(); } ITgroup = GroupHelper.Select("计算机科学与技术系"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater9.DataSource = xydwlist.ToList(); Repeater9.DataBind(); } ITgroup = GroupHelper.Select("海洋技术系"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater10.DataSource = xydwlist.ToList(); Repeater10.DataBind(); } ITgroup = GroupHelper.Select("信息工程中心"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater11.DataSource = xydwlist.ToList(); Repeater11.DataBind(); } } else if (item == "院工会妇委会") { Panel1.Visible = false; Panel2.Visible = false; Panel3.Visible = true; var ITgroup = GroupHelper.Select("院工会"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater12.DataSource = xydwlist.ToList(); Repeater12.DataBind(); } ITgroup = GroupHelper.Select("院妇女委员会"); if (ITgroup != null) { var xydwlist = from a in db.Connection where a.GroupID == ITgroup.GroupID orderby a.Class select a; Repeater13.DataSource = xydwlist.ToList(); Repeater13.DataBind(); } } else { Response.Redirect("index.aspx"); } } }