Dim dt As DataTable
Dim b As New GroupTableBuilder("统计表1",DataTables("客户"))
'b.Groups.AddDef("交货日期",DateGroupEnum.Month,"月")
'b.Groups.AddDef("产品名称")
b.Totals.AddDef("客户名称",AggregateEnum.Count,"订单数")
b.Totals.AddDef("等级",AggregateEnum.Count,"订单数") '
dt = b.Build(True) '参数设置为True,生成一个临时表,不在主界面显示
Dim trv7 As WinForm.TreeView = e.Form.Controls("TreeView7")
trv7.BuildTree("生产流程", "等级")
'trv7.Nodes.Insert("显示所有行",0)
trv7.StopRedraw
For Each nd As WinForm.TreeNode In trv7.AllNodes
'Dim Month As Integer = nd.DataRow("月")
Dim gx As String = nd.DataRow("等级")
Select Case nd.Level
Case 0
nd.Text = nd.text & "等级(" & dt.Compute("Sum(订单数)","等级 = " & gx) & "条)"
'nd.Text = nd.text & "月(" & dt.Compute("Sum(订单数)","月 = " & Month) & "条)"
Case 1
nd.Text = nd.text & "(" & nd.DataRow("订单数") & "条)"
End Select
Next
报错:
.NET Framework 版本:4.0.30319.42000
Foxtable 版本:2019.12.17.18
错误所在事件:窗口,客户,AfterLoad
详细错误信息:
未找到列 [等级]。
需求:目录树,实现统计:如“等级”20条,等级下属目录"1级10条,2级10“