Foxtable(狐表)用户栏目专家坐堂 → [求助]加载树报错


  共有1642人关注过本帖树形打印复制链接

主题:[求助]加载树报错

帅哥哟,离线,有人找我吗?
有点色
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/2/21 16:47:00 [显示全部帖子]

Dim dr As DataRow = e.Node.DataRow
Dim Year As Integer = dr("年")
Dim Month As Integer = dr("月")
Dim day As Integer  = dr("日")

 

改成-----------------------------------------

 

Dim dr As DataRow = e.Node.FullName.split("\")
Dim Year As Integer = ary(0)
Dim Month As Integer = ary(1)
Dim day As Integer  = ary(2)

 


 回到顶部
帅哥哟,离线,有人找我吗?
有点色
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/2/21 18:10:00 [显示全部帖子]

哦,改成

 

Dim ary() As String = e.Node.FullName.split("\")
Dim Year As Integer = ary(0)
Dim Month As Integer = ary(1)
Dim day As Integer  = ary(2)

 


 回到顶部
帅哥哟,离线,有人找我吗?
有点色
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/2/21 18:24:00 [显示全部帖子]

Dim Filter As String

If e.node.Text = "加载所有数据" Then
   
    Filter = ""
   
Else
   
    Dim ary() As String = e.Node.FullName.split("\")
    Dim Year As Integer = ary(0)
    Dim Month As Integer = ary(1)
    Dim day As Integer  = ary(2)
   
    Select Case e.Node.Level
       
        Case 0
           
            Filter ="Year(日期) = " & Year
           
        Case 1
           
            Filter ="Year(日期) = " & Year & " And Month(日期) = " & Month
           
        Case 2
           
            Filter ="Year(日期) = " & Year & " And Month(日期) = " & Month & " And day(日期) = " & day
           
    End Select
   
End If

DataTables("订单组合1").LoadFilter = Filter


DataTables("订单组合1").Load()


 回到顶部