以下是引用lsy在2014-10-8 14:22:00的发言:
那个父子关系,起什么作用?没这个关系,会影响目录树生成吗?
这个父子关系,又根据什么确定的?
我在节点展开前的事件里这样写 不对呢
If e.Node.Level = 2 Then
Dim Value() As String
Value = e.Node.FullName.Split("\")
Dim cmd As new SQLCommand
cmd.CommandText = "select * from {表A} where 状态 = '" & Value(0) & "' and 订单编号 = '" & Value(1) & "' And 自定义编号 = '" & Value(2) & "'"
Dim dt As DataTable = cmd.ExecuteReader
For Each dr As DataRow In dt.DataRows
Dim cd As Winform.TreeNode = e.Node.Nodes.Add(dr("子"),dr("名称"))
Functions.Execute("AddChildrenTree",cd,dt)
Next
End If
AddChildrenTree:
Dim nd As WinForm.TreeNode = args(0)
Dim dt As DataTable = args(1)
Dim drs As List(of DataRow)
drs = dt.Select("[父] = '" & nd.name & "'")
For Each dr As DataRow In drs
Dim cd As Winform.TreeNode = nd.Nodes.Add(dr("子"),dr("名称"))
Functions.Execute("AddChildrenTree",cd,dt)
Next
[此贴子已经被作者于2014-10-8 14:46:03编辑过]