- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- [求助]fxDataSource如何转为datatable (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=150113)
-- 发布时间：2020/5/21 10:39:00
-- [求助]fxDataSource如何转为datatable
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","销项发票")
bd3.C
Dim XV3 As fxDataSource
bd3.Groups.AddDef("合同编号")
bd3.Totals.Addexp("已开票","金额 + 税额")
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编辑过]
-- 发布时间：2020/5/21 11:31:00
--
XV1.show("销售统计表1")
Dim ss As WinForm.TreeView = e.Form.Controls("tv18")
ss.BuildTree("销售统计表1", "年")
-- 发布时间：2020/5/21 11:47:00
--
学习了，多谢
