Dim trv As WinForm.TreeView = e.Sender
Dim flt As String = ""
For Each nd As WinForm.TreeNode In e.node.AllNodes '清除子节点选中状态
nd.Checked = False
Next
If e.node.ParentNode IsNot Nothing Then '去掉父节点选中状态
e.node.ParentNode.Checked = False
If e.node.ParentNode.ParentNode IsNot Nothing Then '去掉父节点选中状态
e.node.ParentNode.ParentNode.Checked = False
If e.node.ParentNode.ParentNode.ParentNode IsNot Nothing Then '去掉父节点选中状态
e.node.ParentNode.ParentNode.ParentNode.Checked = False
End If
End If
End If
Dim Value()As String
If e.node.text = "显示全部订单" AndAlso e.node.Checked Then
Else
For Each nd As WinForm.TreeNode In trv.AllNodes
If nd.Checked Then
Value = nd.FullName.Split("\")
If flt > "" Then
flt = flt & " Or " '注意用or而不是And
End If
If nd.Level = 0 Then '注意下面的条件都要用括号括起来
flt = flt & "( 客户名称 = '" & nd.Text & "')"
ElseIf nd.Level = 1
Dim dt1 As Date = nd.text
Dim dt2 As Date = dt1.adddays(1)
flt = flt & "( 客户名称 = '" & Value(0) & "' And 下单日期 <=#" & dt2 & "# And 下单日期>=#" & dt1 & "#)"
End If
End If
Next
End If
Tables("订单").Filter = flt