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 & "( jxcjname = '" & nd.Text & "')" Else flt = flt & "( jxcjname = '" & nd.ParentNode.Text & "' And sbname = '" & nd.Text & "')" End If End If Next Tables("query").Filter = flt
这个代码是通过加载树实现多从选择筛选 现在query表类型成了查询表
Tables("query").Filter = flt这句代码就不能正确选出值了。 我应该如何改下这个代码或者参考哪里?烦请指点
|