以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  请教老师加载树的问题  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=158651)

--  作者:禾成
--  发布时间:2020/11/27 18:18:00
--  请教老师加载树的问题

 老师下面红色代码怎么写?

Dim dr As DataRow = e.Node.DataRow \'获取生成此节点的行
Dim Filter As String
Dim Year As Integer = dr("年")
Dim Month As Integer = dr("月")
Dim Product As String = dr("客户")
Dim SKHS As String = dr("收款状态")
Select Case e.Node.Level
    Case 0
        Filter ="收款状态 = " & SKHS
    Case 1
        Filter ="收款状态 = " & SKHS & Filter ="Year(对帐日期) = " & Year
    Case 2
       Filter ="收款状态 = " & SKHS &  Filter ="Year(对帐日期) = " & Year & " And Month(对帐日期) = " & Month
    Case 3
     Filter ="收款状态 = " & SKHS &  Filter ="Year(对帐日期) = " & Year & " And Month(对帐日期) = " & Month & " And 客户 = \'" & Product & "\'"
End Select
DataTables("对帐主表").LoadFilter = Filter
DataTables("对帐主表").Load()

 

 



此主题相关图片如下:1.png
按此在新窗口浏览图片

 

 

双击加载树一级报下图
 


此主题相关图片如下:2.png
按此在新窗口浏览图片

--  作者:有点蓝
--  发布时间:2020/11/28 8:57:00
--  
先看几遍:http://www.foxtable.com/webhelp/topics/1284.htm

Select Case e.Node.Level
    Case 0
        Filter ="收款状态 = \'" & SKHS & "\'"
    Case 1
        Filter ="收款状态 = \'" & SKHS & "\' and Year(对帐日期) = " & Year