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; } } }
public ResponseVM Delete(Guid id) { using (context) { if (context.CategoryLists.Where(x => x.ITGroupid == id).Any()) { return(new ResponseVM("deleted", false, "ITGroup", ResponseVM.DONT_DELETE)); } using (var dbTransaction = context.Database.BeginTransaction()) { try { ITGroup itgroupToBeDeleted = context.ITGroups.Find(id); if (itgroupToBeDeleted == null) { return(new ResponseVM("deleted", false, "ITGroup", ResponseVM.DOES_NOT_EXIST)); } context.ITGroups.Remove(itgroupToBeDeleted); context.SaveChanges(); dbTransaction.Commit(); return(new ResponseVM("deleted", true, "ITGroup")); } catch (Exception ex) { dbTransaction.Rollback(); return(new ResponseVM("deleted", false, "ITGroup", ResponseVM.SOMETHING_WENT_WRONG, "", ex)); } } } }
public ResponseVM Update(ITGroupVM itgroupVM) { using (context) { if (context.ITGroups.Where(x => x.ITGroupName == itgroupVM.ITGroupName).Any()) { return(new ResponseVM("updated", false, "ITGroup", ResponseVM.NO_NEW_DATA)); } using (var dbTransaction = context.Database.BeginTransaction()) { try { ITGroup itgroupToBeUpdated = context.ITGroups.Find(itgroupVM.ITGroupid); if (itgroupToBeUpdated == null) { return(new ResponseVM("updated", false, "ITGroup", ResponseVM.DOES_NOT_EXIST)); } itgroupToBeUpdated.ITGroupCode = itgroupVM.ITGroupCode; itgroupToBeUpdated.ITGroupName = itgroupVM.ITGroupName; context.SaveChanges(); dbTransaction.Commit(); return(new ResponseVM("updated", true, "ITGroup")); } catch (Exception ex) { dbTransaction.Rollback(); return(new ResponseVM("updated", false, "ITGroup", ResponseVM.SOMETHING_WENT_WRONG, "", ex)); } } } }
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 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("修改失败")); } }