[求助]根据多列内容生成筛选树节点如何显示人数统计 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim Filter As String = ""
Dim dr As DataRow = e.Node.DataRow       '声明变量dr为行类型,初值为生成此节点的行
Dim tbl As Table = Tables("员工信息")    '声明变量tbl为表类型,初值为"员工信息"表
'Dim ary = e.node.fullpath.split("\")
Dim ary = e.node.fullName.split("\")
If e.node.level > 0 '第二层节点开始
    Select Case ary(0)
        Case "户籍地"
            If ary(1) = "" Then
                Filter = "户籍地 is null"
            Else
                Filter = "户籍地 = '" & ary(1) & "'"
            End If
        Case "岗类部门"
            If e.node.level = 1 Then
                Filter = "岗位类别 = '" & ary(1) & "'"
            Else
                Filter = "岗位类别 = '" & ary(1) & "' and 工作部门 = '" & ary(2) & "'"
            End If
    End Select
    tbl.Filter = filter
    'ElseIf e.node.Text = "全部"
ElseIf e.node.Name = "全部"
    tbl.Filter = ""
End If

主题：[求助]根据多列内容生成筛选树节点如何显示人数统计