protected void btnAdd_Click(object sender, EventArgs e) { if (txtNum.Text.Length == 0) { Response.Write(JSHelper.ShowAlert("输入不能为空!")); } else { var user = UserHelper.Select(txtNum.Text); if (user != null) { var teac = TeacherHelper.Select(user.UserID); var stu = StudentHelper.Select(user.UserID); if (teac != null || stu != null) { var db = new oucITEntities(); var itgroup = (from a in db.ITGroup where a.GroupName == ddlGroup.Text select a).SingleOrDefault(); var conn = (from a in db.Connection where a.UserID == user.UserID && a.GroupID == itgroup.GroupID select a).FirstOrDefault(); if (conn == null) { int class1 = ddlClass.Text == "管理员" ? 2 : 1; if (ConnHelp.Add(itgroup.GroupID, user.UserID, ddlClass.Text, class1, txtJob.Text, txtDuty.Text, txtPhone.Text, txtEmail.Text) == true) { Response.Write("<script>alert('添加成功!');window.location.href ='Index.aspx'</script>"); } else { Response.Write(JSHelper.ShowAlert("添加失败")); } } else { Response.Write(JSHelper.ShowAlert("该老师或学生已存在于该组")); } } else { Response.Write(JSHelper.ShowAlert("该老师或学生不存在")); } } else { Response.Write(JSHelper.ShowAlert("该老师或学生不存在")); } } }
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 gdvGpLs_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "mydelete") { int connID = Convert.ToInt32(e.CommandArgument.ToString()); if (ConnHelp.Delete(connID)) { Response.Write(JSHelper.ShowAlert("删除成功")); Response.Redirect(Request.RawUrl); } else { Response.Write(JSHelper.ShowAlert("删除失败,请重试")); } } }
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("修改失败")); } }