Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1") Dim key As String = e.Node.Name Dim ids As String If key = "全部" Then e.Form.controls("Table1").Table.Filter = "" Else For Each nd As WinForm.TreeNode In trv.AllNodes Dim pd As WinForm.TreeNode = nd Do If pd.Name = key Then If ids > "" Then ids= ids & "," End If ids = ids & "'" & nd.name & "'" Exit Do Else pd = pd.ParentNode If pd Is Nothing Then Exit Do End If End If Loop Next e.Form.controls("Table1").Table.Filter = "LB In (" & ids & ")" End If
|