Dim bd1 As New SQLGroupTableBuilder("销售统计表1","合同明细")
bd1.C
Dim XV1 As fxDataSource
bd1.Groups.AddDef("合同编号")
bd1.Groups.AddDef("签订日期",DateGroupEnum.year)
bd1.Groups.Adddef("经办人")
bd1.Groups.AddDef("客户名称")
bd1.Totals.AddDef("金额")
XV1 = bd1.BuildDataSource()
Dim bd2 As New SQLGroupTableBuilder("销售统计表2","银行日记帐")
bd2.C
Dim XV2 As fxDataSource
bd2.Groups.AddDef("合同编号")
bd2.Totals.AddDef("收入金额","已回款")
XV2 = bd2.BuildDataSource()
Dim bd3 As New SQLGroupTableBuilder("销售统计表3","销项fa piao")
bd3.C
Dim XV3 As fxDataSource
bd3.Groups.AddDef("合同编号")
bd3.Totals.Addexp("已开piao","金额 + 税额")
XV3 = bd3.BuildDataSource()
XV1.Combine("合同编号",XV2,"合同编号")
XV1.Combine("合同编号",XV3,"合同编号")
Dim xm As DataTable
Dim ss As WinForm.TreeView = e.Form.Controls("tv18")
ss.BuildTree("xm", "年")
请专家帮助看一下,如何对组合后的表生成加载树?
[此贴子已经被作者于2020/5/21 10:42:59编辑过]