主题：求助 目录树

老师:

谢谢老师!!!

老师:

谢谢老师!!!

老师:

老师:

好的!

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:测试.rar

老师:

老师:

您好!

以下是截图,任一个树没勾选都会提示,加了判断代码也是一样会有提示

此主题相关图片如下：aa.png


此主题相关图片如下：bb.png


此主题相关图片如下：cc.png

 

 

Dim nms As String() = {"年","月","日"} '指定生成目录树的各列
Dim qts As String() = {"'","'","'"} '指定将各列的值括起来的符号,这里都是字符型,所以都是单引号
Dim tr1 As WinForm.TreeView = e.Form.Controls("TreeView1")
Dim flt As String
Dim nd As WinForm.TreeNode
If tr1.SelectedNode Is Nothing
    MessageBox.Show("AA")
Else
    For Each nd In tr1.SelectedNode.allNodes '清除子节点的选中标记
        nd.Checked = False
    Next
    nd = tr1.SelectedNode.ParentNode
    Do While nd IsNot Nothing '清除父节点的选中标记
        nd.Checked = False
        nd = nd.ParentNode
    Loop
End If
    For Each nd In tr1.AllNodes
        If nd.Checked  Then
            Dim rts() As String = nd.FullPath.Split("\")
            Dim val As String = ""
            For i As Integer = 0 To rts.length - 1
                If val > "" Then
                    val = val & " And "
                End If
                val = val & nms(i) & " = " & qts(i) & rts(i) & qts(i)
            Next
            If flt > "" Then
                flt = flt & " Or (" & val & ")"
            Else
                flt = val
            End If
        End If
    Next
Dim tr2 As WinForm.TreeView = e.Form.Controls("TreeView2")
Dim odkl As String
If tr2.SelectedNode IsNot Nothing
    For Each nd1 As WinForm.TreeNode In tr2.SelectedNode.Nodes '清除子节点选中状态
        nd1.Checked = False
    Next
    If tr2.SelectedNode.ParentNode IsNot Nothing Then '去掉父节点选中状态
        tr2.SelectedNode.ParentNode.Checked = False
    End If
End If
    For Each nd1 As WinForm.TreeNode In tr2.AllNodes
        If nd1.Checked Then
            If odkl > "" Then
                odkl = odkl & " Or "  '注意用or而不是And
            End If
            If nd1.Level = 0 Then '注意下面的条件都要用括号括起来
                odkl = odkl & "( 类别 = '" & nd1.Text & "')"
            Else
                odkl = odkl & "( 类别 = '" & nd1.ParentNode.Text & "' And 款式 = '" & nd1.Text & "')"
            End If
        End If
    Next
Dim tr3 As WinForm.TreeView = e.Form.Controls("TreeView3")
Dim kkth As String
If tr3.SelectedNode IsNot Nothing
    For Each nd2 As WinForm.TreeNode In tr3.SelectedNode.Nodes '清除子节点选中状态
        nd2.Checked = False
    Next
    If tr3.SelectedNode.ParentNode IsNot Nothing Then '去掉父节点选中状态
        tr3.SelectedNode.ParentNode.Checked = False
    End If
End If
    For Each nd2 As WinForm.TreeNode In tr3.AllNodes
        If nd2.Checked Then
            If kkth > "" Then
                kkth = kkth & " Or "  '注意用or而不是And
            End If
            If nd2.Level = 0 Then '注意下面的条件都要用括号括起来
                kkth = kkth & "( 品牌 = '" & nd2.Text & "')"
            End If
        End If
    Next
Tables("表A").Filter = "(" & flt & ") And (" & odkl & ") And (" & kkth & ")"

请老师指教!!!

谢谢!!!