主题：[求助] 复选框目录树 增加节点

1、新建一个窗口，插入一个目录树控件。

2、将窗口的AfterLoad事件代码设置为：

e.Form.Controls("TreeView1").BuildTree("订单", "产品|客户|款号")

3、将目录树的AfterCheckNode事件代码设置为：

Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
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.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中
        Continue For '跳过此节点,处理下一结点
    End If
    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 & "')"
        Else
            flt = flt & "( 产品 = '" & nd.ParentNode.Text & "' And 客户 = '" & nd.Text & "'  帮我 + 个 款号  )"

        Else
    End If   
Next
Tables("订单").Filter = flt

怎么没人帮呀！示例只有2个节 我要3个节点 不知代码怎么改，帮我改下！ 先谢了

  flt = flt & "( 产品 = '" & nd.ParentNode.Text & "' And 客户 = '" & nd.Text & "'   And 款号= '" & nd.Text & "' )"

Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
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.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中
        Continue For '跳过此节点,处理下一结点
    End If
    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 & "')"
        Else
            flt = flt & "( 审核 = '" & nd.ParentNode.Text & "' And 客户 = '" & nd.Text & "' And 款号= '" & nd.Text & "')"    注意 ： 第3行节点加上就不能用！会的帮改下
        Else
    End If   
Next
Tables("订单标准").Filter = flt

^_^，我都以为您是要给大家分享问题，都没有看！

仔仔细细看完这个帖子，您就知道为啥，您的问题也就迎刃而解了！

真不知问题出在哪 我对代码不怎么会   会的说下吧

Dim trv As WinForm.TreeView = e.Sender
Dim flt,a,b,c As String
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
If nd.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中
    For Each nd As WinForm.TreeNode In trv.AllNodes
        If nd.Checked Then
            If nd.Level = 0 Then '注意下面的条件都要用括号括起来
                a = nd.Text
                flt = " 审核 = '" & a & "'"
            End If
            If nd.Level = 1 Then
                b = nd.Text
                flt = "审核 = '" & a & "' And 客户 = '" & b & "'"
            End If
            If nd.Level = 2 Then
                c = nd.Text
                flt = "审核 = '" & a & "' And 客户 = '" & b & "' And 款号= '" & c & "'"
            End If
        End If
    Next
End If
Tables("订单标准").Filter = flt

提示错误代码：If nd.Level > 0 AndAlso nd.ParentNode.Checked Then '如果父节点选中

 

还不行呀