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