主题：BuildTree 怎么根据同样数据的条数排序

1、先生成分组统计表 http://www.foxtable.com/webhelp/scr/0677.htm

2、对统计表进行目录树生成 http://www.foxtable.com/webhelp/scr/0894.htm

Dim cmd As New SQLCommand
'cmd.ConnectionName = "主数据源"
cmd.CommandText ="select DISTINCT 客户count,a.客户, fa piao, 结销状态 from (Select Count(客户) As 客户Count,客户 From {YW_销售发货单明细} where 发货数量>0 group by 客户) as a inner join {YW_销售发货单明细} as b on a.客户=b.客户"
Dim dt As DataTable=cmd.ExecuteReader()

Dim tv As WinForm.TreeView = e.Form.Controls("TreeView1")
tv.Nodes.clear
tv.BuildTree(dt,"客户|fa piao|结销状态","","客户count,fa piao,结销状态")

比如代码

select * from (Select Count(客户) As 客户Count,客户 From {YW_销售发货单明细} where 发货数量>0 group by 客户) as a right join (Select Count(客户) As fa piaoCount,客户,fa piao From {YW_销售发货单明细} where 发货数量>0 group by 客户,fa piao) as b on a.客户=b.客户