以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 目录树节点连接? (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=32357) |
-- 作者:wqb1102 -- 发布时间:2013/4/30 15:39:00 -- 目录树节点连接? Dim Filter As String If e.Node.Text = "加载所有数据" Then Filter
= "" Else Dim
Value() As String Value
= e.Node.FullPath.Split("\\") Select
Case e.Node.Level Case
0 Filter ="[省] = \'" & Value(0) & "\'" Case
1 Filter ="[省] = \'" & Value(0) & "\' And [市] = \'" & Value(1) & "\'" End
Select End If DataTables("出库").LoadFilter = Filter DataTables("出库").Load() Dim Value()As String Dim Filter As String Value = e.Node.FullPath.Split("\\") Select Case e.Node.Level Case
0 Filter
="Year(发货日期) = " &
Value(0) Case
1 Filter
="Year(发货日期) = " &
Value(0) & " And Month(发货日期) = " & Value(1) End Select DataTables("出库").LoadFilter
= Filter DataTables("出库").Load() 想在目录树中上述两代码连接在一起,即以省和年作为根节点,如何设置,窗口事件中的代码如何修改? |
-- 作者:wqb1102 -- 发布时间:2013/5/2 9:28:00 -- 自顶 |