主题：[讨论]请问如何让两个筛选树联动

最近加了一个左侧导航菜单，所以想缩减筛选树占用的宽度，将原本一个筛选树分拆放进两个TreeView控件里

于是产生两个疑问

1. 如何让这两个筛选树联动？目前是两个控件互相独立筛选的

2.能否做进一个TreeView里？

先谢谢啦：D

窗口afterload里

e.Form.Controls("TreeView1").BuildTree(vars("table1"), "状态|考核体")
e.Form.Controls("TreeView2").BuildTree(vars("table1"), "部门大类|部门小类|岗位大类")

TreeView1里

Dim nms As String() = {"状态","考核体"} '指定生成目录树的各列
Dim qts As String() = {"'","'"} '指定将各列的值括起来的符号,这里都是字符型,所以都是单引号
Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
Dim nd As WinForm.TreeNode
For Each nd In e.node.allNodes '清除子节点的选中标记
    nd.Checked = False
Next
nd = e.Node.ParentNode
Do While nd IsNot Nothing '清除父节点的选中标记
    nd.Checked = False
    nd = nd.ParentNode
Loop
For Each nd In trv.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
Tables("cmst_sh_hr_hmc").Filter  = flt

TreeView2里

Dim nms As String() = {"部门大类","部门小类","岗位大类"} '指定生成目录树的各列
Dim qts As String() = {"'","'","'"} '指定将各列的值括起来的符号,这里都是字符型,所以都是单引号
Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
Dim nd As WinForm.TreeNode
For Each nd In e.node.allNodes '清除子节点的选中标记
    nd.Checked = False
Next
nd = e.Node.ParentNode
Do While nd IsNot Nothing '清除父节点的选中标记
    nd.Checked = False
    nd = nd.ParentNode
Loop
For Each nd In trv.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
Tables("cmst_sh_hr_hmc").Filter  = flt

蓝大好，

我先勾吴淞 考核体会筛选出吴淞

然后我到下面勾营销，此时筛选出地区里所有营销部门，上面第一次勾的吴淞就失效了

想请教下，代码怎么写可以让两个勾选都生效，另外可不可以放进一个TreeView控件里，

谢谢蓝大啦

此主题相关图片如下：武松.jpg

此主题相关图片如下：营销.jpg

T_T 蓝大 第一步是要改TreeView2里面变量名么=。= 后面完全不知道怎么合并到treeview1了

Dim nms2 As String() = {"部门大类","部门小类","岗位大类"} '指定生成目录树的各列

不好意思呀蓝大 求个treeview1的代码 这个我完全搞不定T_T

 

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

点击浏览该文件:筛选树联动.foxdb

蓝大 我在treeview2 里这么写 但是两个筛选树不能联动

先在treeview1里选吴淞 再在treeview2里选运营时会筛选出吴淞以外的记录

Dim nms As String() = {"部门大类","部门小类","岗位大类"} '指定生成目录树的各列
Dim qts As String() = {"'","'","'"} '指定将各列的值括起来的符号,这里都是字符型,所以都是单引号
Dim trv As WinForm.TreeView = e.Sender
Dim flt As String
Dim nd As WinForm.TreeNode
For Each nd In e.node.allNodes '清除子节点的选中标记
    nd.Checked = False
Next
nd = e.Node.ParentNode
Do While nd IsNot Nothing '清除父节点的选中标记
    nd.Checked = False
    nd = nd.ParentNode
Loop
For Each nd In trv.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 trv2 As WinForm.TreeView = e.Form.Controls("TreeView1")
For Each nd In trv2.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
Tables("表A").Filter  = flt

此主题相关图片如下：吴淞1.png


此主题相关图片如下：吴淞运营2.png