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