Dim Filter As String Dim dr As DataRow = e.Node.DataRow '获取生成此节点的行 If e.Node.Text <> "显示所有行" Then Select Case e.Node.Level Case 0 Filter = "[mu] = '" & dr("mu") & "'" Case 1 Filter = "[mu] = '" & dr("mu") & "' And [lei] = '" & dr("lei") & "'" End Select End If Tables("商品").Filter = Filter