e.Form.Controls("TreeView1").BuildTree("表c", "别人编号|我们编号")
Dim nd = e.Form.Controls("TreeView1").nodes.insert("所有", 0)
nd.checked = True
Tables("表c").Filter = ""
Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
If e.Node.Text = "所有" AndAlso e.node.Checked Then
flt = ""
Else
flt = "1=2"
For Each nd As WinForm.TreeNode In e.node.Nodes '清除子节点选中状态
nd.Checked = e.node.Checked
Next
If e.node.ParentNode IsNot Nothing Then '去掉父节点选中状态
e.node.ParentNode.Checked = False
End If
For Each nd As WinForm.TreeNode In trv.AllNodes
If nd.Checked Then
If flt > "" Then
flt = flt & " Or " '注意用or而不是And
End If
If nd.Level = 0 Then '注意下面的条件都要用括号括起来
flt = flt & "( 别人编号 = '" & nd.Text & "')"
Else
flt = flt & "( 别人编号 = '" & nd.ParentNode.Text & "' And 我们编号 = '" & nd.Text & "')"
End If
End If
Next
End If
Tables("表c").Filter = flt
-----------------------
有请老师百忙之中，指点下！
此主题相关图片如下：未标题-3.jpg
加好友 
发短信
Post By：2017/6/29 17:08:00 [只看该作者]
