主题：如何实现类似物流明细的效果

如何显示成4楼的效果呢？安装时间、维修日期、维护日期、撤出日期都在第一列？

你直接调整一下列位置不就完了.

Dim jb As new SQLJoinTableBuilder("流水查询","安装")
jb.addTable("安装","设备序列号","维修","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","维护","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","撤出","设备序列号",JoinModeEnum.Left)
jb.addcols("{安装}.设备序列号","{安装}.省份","{安装}.医院名称","{安装}.安装科室","维修内容","维护内容","{撤出}.备注")
jb.Addexp("日期_安装日期","装机时间")
jb.Addexp("日期_维护日期","维护日期")
jb.Addexp("日期_维修日期","维修日期")
jb.Addexp("日期_撤出日期","撤出日期")

jb.Build

前面误解你的意思， 4楼的效果：
 
Dim qy As new QueryBuilder()
qy.TableName = "流水查询"
qy.SelectString = "Select 装机时间 As 日期, '安装' as 类型,医院名称,安装科室,备注 From {安装} UNION select 维修日期 As 日期, '维修' as 类型,医院名称,安装科室,维修内容 AS 备注 From {维修} UNION select 维护日期 As 日期, '维护' as 类型,医院名称,安装科室,维护内容 AS 备注 From {维护} union  select 撤出日期 As 日期, '撤出' as 类型,医院名称,安装科室,备注 From {撤出}"
qy.Build()

 
测试通过。
 
有关知识参考:
http://www.foxtable.com/help/topics/0688.htm

 

谢谢！我针对性的学习这一部分内容。