protected void btnEnable_Click(object sender, EventArgs e) { if (DepTreeList.SelectionCount <= 0) { JSHelper.Alert("请至少选择一条记录!", this); } else { List <string> list = new List <string>();//建立事务列表 foreach (var item in DepTreeList.GetSelectedNodes()) { list.Add(string.Format("update department set deptstatus='1' where deptnumber='{0}'", item.Key)); } try { OracleHelper.ExecuteSqlTran(list); InitData(); DepTreeList.UnselectAll(); JSHelper.Alert("更新成功!", this); } catch (Exception ex) { JSHelper.Alert("出现异常,更新失败!请与管理员联系!", this); } } }
private void BindData(string where) { Session["FID"] = PublicMethod.ReadXmlReturnNode("ZY", this); DepartmentBll dept = new DepartmentBll(); DepTreeList.DataSource = dept.GetList(where); DepTreeList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { List <string> lstRole = new List <string>(); lstRole.Add("2"); lstRole.Add("46"); if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31") { var data = from dept in dc.Department select new { Deptname = dept.Deptname, Fatherid = dept.Fatherid, Deptnumber = dept.Deptnumber }; DepTreeList.DataSource = data; DepTreeList.DataBind(); } else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])) { var data = from dept in dc.Department select new { Deptname = dept.Deptname, Fatherid = dept.Fatherid, Deptnumber = dept.Deptnumber }; DepTreeList.DataSource = data; DepTreeList.DataBind(); } else { var data = from dept in dc.Department where dept.Deptnumber.StartsWith(SessionBox.GetUserSession().DeptNumber.Remove(4)) select new { Deptname = dept.Deptname, Fatherid = dept.Fatherid, Deptnumber = dept.Deptnumber }; DepTreeList.DataSource = data; DepTreeList.DataBind(); } } }