Dim jb As new SQLJoinTableBuilder("库存表查询","库存表主表")
jb.C
jb.AddTable("库存表主表","单据编号","库存表","单据编号")
jb.AddCols("{库存表主表}.YEAR(日期) AS 年","{库存表主表}.单据编号","{库存表主表}.出入库存单位名称","{库存表主表}.承运人","{库存表主表}.出入库类型","{库存表主表}.出入库类型编号","{库存表主表}.简称","名称","编号","规格","类型","入库数量","出库数量","库存数量","单位","库存件数","重量","库存重量","备注","附件","生产单号","采购明细单号","订单编号","客户单号","包装","存放区","产品名称","入库件数","出库件数","结构","材质")
jb.AddExp("年","Year({库存表主表}.日期)",True)
JB.Build()
e.Form.Controls("TreeView1").BuildTree("库存表查询", "年|月|出入库类型|出入库存单位名称|类型|材质")
请