Foxtable(狐表)用户栏目专家坐堂 → 加载树代码编写错误


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

主题:加载树代码编写错误

美女呀,离线,留言给我吧!
动检
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:113 积分:1107 威望:0 精华:0 注册:2016/12/14 14:30:00
加载树代码编写错误  发帖心情 Post By:2017/8/17 17:17:00 [只看该作者]

想让各位大神帮看看代码哪里出错了 提示说“至少一个参数没有被指定值”。而且年月日的排布也不对,想生成的加载树逐级关系是:送检单位,年份,月份,日
窗口代码
Dim dt As DataTable
Dim b As New SQLGroupTableBuilder("统计表1","检测样品登记")
b.Groups.AddDef("送检单位")
b.Groups.AddDef("送检日期",DateGroupEnum.Year,"年")
b.Groups.AddDef("送检日期",DateGroupEnum.Month,"月")
b.Groups.AddDef("送检日期",DateGroupEnum.Day,"日")
b.Totals.AddDef("_Identify",AggregateEnum.Count,"样品数量")
dt = b.Build(False) '参数设置为False,生成一个临时表,不在主界面显示
'然后根据统计表生成目录树
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
trv.BuildTree(dt, "送检单位|年|月|日|送检单位")
trv.StopRedraw
For Each nd As WinForm.TreeNode In trv.AllNodes
    Dim Product As String = nd.DataRow("送检单位")
    Dim Year As Integer = nd.DataRow("年")
    Dim Month As Integer = nd.DataRow("月")
    Dim Day As Integer = nd.DataRow("日")
    Select Case nd.Level
        Case 0
            nd.Text = nd.text & "年(" & dt.Compute("Sum(样品数量)","年 = " & Year) & "条)"
        Case 1
            nd.Text = nd.text & "月(" & dt.Compute("Sum(样品数量)","年 = " & Year & " And 月 = " & Month) & "条)"
        Case 2
            nd.Text = nd.text & "日(" & dt.Compute("Sum(样品数量)","年 = " & Year & " And 月 = " & Month & " And 日 = " & Day) & "条)"
        Case 3
            nd.Text = nd.text & "(" & nd.DataRow("样品数量") & ")"
    End Select
Next
trv.Nodes.Insert("加载所有行","加载所有行(" & dt.Compute("Sum(样品数量)") & "条)",0)
trv.ResumeRedraw

窗口下加载树的代码
Dim Filter As String = ""
If e.Node.Name <> "加载所有行" Then '要用Name属性,不能用Text属性
    Dim Product As String = e.Node.DataRow("送检单位")
    Dim Year As Integer = e.Node.DataRow("年")
    Dim Month As Integer = e.Node.DataRow("月")
    Dim Day As Integer = e.Node.DataRow("日")
   
    Select Case e.Node.Level
        Case 0
            Filter ="Product(送检单位) = "
        Case 1
            Filter ="Year(检测日期) = " & Year
        Case 2
            Filter ="Year(检测日期) = " & Year & " And Month(检测日期) = " & Month
        Case 3
            Filter ="Year(检测日期) = " & Year & " And Month(检测日期) = " & Year & " And Day(检测日期) = " & Day
        Case 4
            Filter ="Year(检测日期) = " & Year & " And Month(检测日期) = " & Year & " And Day(检测日期) " & Day & " And 送检单位 = '" & Product & "'"
    End Select
End If
DataTables("检测样品登记").LoadFilter = Filter
DataTables("检测样品登记").Load()

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2017/8/17 18:01:00 [只看该作者]

Dim b As New SQLGroupTableBuilder("统计表1","检测样品登记")
b.Groups.AddDef("送检单位")
b.Groups.AddDef("送检日期",DateGroupEnum.Year,"年")
b.Groups.AddDef("送检日期",DateGroupEnum.Month,"月")
b.Groups.AddDef("送检日期",DateGroupEnum.Day,"日")
b.Totals.AddDef("送检日期",AggregateEnum.Count,"样品数量")
b.Build() '参数设置为False,生成一个临时表,不在主界面显示
'然后根据统计表生成目录树
dim dt as datatable = DataTables("统计表1")
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
trv.BuildTree(dt, "送检单位|年|月|日|送检单位")
trv.StopRedraw
For Each nd As WinForm.TreeNode In trv.AllNodes
    Dim Product As String = nd.DataRow("送检单位")
    Dim Year As Integer = nd.DataRow("年")
    Dim Month As Integer = nd.DataRow("月")
    Dim Day As Integer = nd.DataRow("日")
    Select Case nd.Level
        Case 0
            nd.Text = nd.text & "(" & dt.Compute("Sum(样品数量)","送检单位 = '" & product & "'") & "条)"
        Case 1
            nd.Text = nd.text & "年(" & dt.Compute("Sum(样品数量)","送检单位 = '" & product & "' and 年 = " & Year) & "条)"
        Case 2
            nd.Text = nd.text & "月(" & dt.Compute("Sum(样品数量)","送检单位 = '" & product & "' and 年 = " & Year & " And 月 = " & Month) & "条)"
        Case 3
            nd.Text = nd.text & "日(" & dt.Compute("Sum(样品数量)","送检单位 = '" & product & "' and 年 = " & Year & " And 月 = " & Month & " And 日 = " & Day) & "条)"
    End Select
Next
trv.Nodes.Insert("加载所有行","加载所有行(" & dt.Compute("Sum(样品数量)") & "条)",0)
trv.ResumeRedraw

 

-------------------------

 

Dim Filter As String = ""
If e.Node.Name <> "加载所有行" Then '要用Name属性,不能用Text属性
    Dim Product As String = e.Node.DataRow("送检单位")
    Dim Year As Integer = e.Node.DataRow("年")
    Dim Month As Integer = e.Node.DataRow("月")
    Dim Day As Integer = e.Node.DataRow("日")
    Select Case e.Node.Level
        Case 0
            Filter ="送检单位 = '" & product & "'"
        Case 1
            Filter ="送检单位 = '" & product & "' and Year(检测日期) = " & Year
        Case 2
            Filter ="送检单位 = '" & product & "' and Year(检测日期) = " & Year & " And Month(检测日期) = " & Month
        Case 3
            Filter ="送检单位 = '" & product & "' and Year(检测日期) = " & Year & " And Month(检测日期) = " & Year & " And Day(检测日期) = " & Day
    End Select
End If
DataTables("检测样品登记").LoadFilter = Filter
DataTables("检测样品登记").Load()


 回到顶部
美女呀,离线,留言给我吧!
动检
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:113 积分:1107 威望:0 精华:0 注册:2016/12/14 14:30:00
  发帖心情 Post By:2017/9/18 15:20:00 [只看该作者]

谢谢

 回到顶部