数据表Department
DepartID DepartName
01 一级01
0101 二级0101
0102 二级0102
02 一级02
0201 二级0201
0202 二级0202
- /// <summary>
- /// 绑定导航树
- /// </summary>
- protected void BindTree()
- {
- //获取树数据
- DataSet ds = me.ExecuteDataSet("select * from Department");
- //过虑出父节点
- DataRow[] dr1 = ds.Tables[0].Select("len(DepartID)=2");
- for (int i = 0; i < dr1.Length; i++)
- {
- int count;
- TreeNode treeNode = new TreeNode();
- treeNode.Text = dr1[i]["DepartName"].ToString();
- //treeNode.NavigateUrl = "";//"../" + dr1[i]["Remark"];//这里导航,需要再设置字段。
- //treeNode.Target = "main";
- treeNode.SelectAction = TreeNodeSelectAction.Expand;
- treeNode.ImageUrl = "../images/book.gif";
- this.tv_Nav.Nodes.Add(treeNode);
- //过虑出子节点
- count = 0;
- DataRow[] dr2 = ds.Tables[0].Select("len(DepartID)=4 and Substring(DepartID,1,2)='" + dr1[i]["DepartID"] + "'");
- if (dr1.Length > 0)
- {
- for (int j = 0; j < dr2.Length; j++)
- {
- //这里增加权限判断逻辑。
- //if (QXDM.IndexOf("" + dr2[j]["lmbh"]) < 0)
- // continue;
- TreeNode childNode = new TreeNode();
- childNode.Text = dr2[j]["DepartName"].ToString();
- childNode.NavigateUrl = "../" + dr2[j]["Remark"].ToString();
- childNode.Target = "main";
- childNode.ImageUrl = "../images/book.gif";
- treeNode.ChildNodes.Add(childNode);
- count = count + 1;
- }
- }
- //如果没有小类,则连大类一起删除。
- if (count == 0)
- tv_Nav.Nodes.Remove(treeNode);
- }
- }