-- 作者:cqlistone
-- 发布时间:2016/1/7 13:23:00
-- 目录树统计数据自动更新
当table有新的信息录入时,怎样让目录树自动更新统计数据--- 不重新打开窗口更新
Dim
dt
As
DataTable Dim
b
As
New
SQLGroupTableBuilder("统计表1","订单") b.Groups.AddDef("日期",DateGroupEnum.Year,"年") b.Groups.AddDef("日期",DateGroupEnum.Month,"月") b.Groups.AddDef("产品") 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
Year
As
Integer = nd.DataRow("年") Dim
Month
As
Integer = nd.DataRow("月") Dim
Product
As
String = 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
&
"("
&
nd.DataRow("订单数") &
")" End
Select Next trv.Nodes.Insert("加载所有行","加载所有行("
&
dt.Compute("Sum(订单数)") &
"条)",0) trv.ResumeRedraw
|