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");
}
}
}
