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("修改失败"));
}
}