Foxtable(狐表)用户栏目专家坐堂 → [求助]SQLCrossTableBuilder的关联方式


  共有3967人关注过本帖树形打印复制链接

主题:[求助]SQLCrossTableBuilder的关联方式

帅哥哟,离线,有人找我吗?
ifastudy
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:童狐 帖子:250 积分:1875 威望:0 精华:1 注册:2013/5/25 18:06:00
[求助]SQLCrossTableBuilder的关联方式  发帖心情 Post By:2013/12/18 10:15:00 [显示全部帖子]

请问SQLCrossTableBuilder中左表和右表的关联方式是inner join还是left join?
我做了一个四个表的关联,发现交叉后的列数少了一些

Dim g As New SQLCrossTableBuilder("库存H", "D_Stock")
g.ConnectionName = _DataSource
g.AddTable("D_Stock","SKUCode","B_SKU","SKUCode")
g.AddTable("D_Stock","PartyCode","B_Party","PartyCode")
g.AddTable("B_SKU","ProductColorCode","View_ProductKS","款色")
Dim Cols1() As String = {"PartyCode","SKUCode"}
Dim Cols2() As String = {"PartyCode","SKUCode"}
g.AddTable("D_Stock",Cols1,"D_SaleBillItem",Cols2)
g.HGroups.AddDef("{D_Stock}.PartyCode","仓库对象","仓库对象")
g.HGroups.AddDef("ProductColorCode","款色")
g.HGroups.AddDef("InsideLengthCode","内长")
g.HGroups.AddDef("销售分类")
g.HGroups.AddDef("YearCode","年份")
g.HGroups.AddDef("SeasonCode","季节")
g.HGroups.AddDef("SeasonStageCode","波段")
g.VGroups.AddDef("SizeCode","尺码")
g.Totals.AddDef("TargetQty", "目标库存")
g.Totals.AddDef("SaleBillQty", "累计销量")
g.HorizontalTotal= True
g.OrderByTotal = True

 回到顶部
帅哥哟,离线,有人找我吗?
ifastudy
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:童狐 帖子:250 积分:1875 威望:0 精华:1 注册:2013/5/25 18:06:00
  发帖心情 Post By:2013/12/18 10:28:00 [显示全部帖子]

谢谢帅哥,在线噢!狐爸,设置为JoinModeEnum.Left就可以了。默认是inner join

 回到顶部