Dim FZArys1 As List(Of String()) ''从指定列中,获取不重复的值,以集合的形式返回 FZArys1= DataTables("销售接单颜色").GetValues("分组标示|货号","销售接单明细ID = " & dr("_Identify")) '列名用符号|分割 For Each FZAry1 As String() In FZArys1 Dim cColor As String ="" For Each drColor As DataRow In DataTables("销售接单颜色").Select("销售接单明细ID = " & dr("_Identify") And 分组标示 = '" & FZArys1(0) & "' and 货号 = '" & FZArys1(1) & "'") ''按分组标示+半成品气球分组 cColor=cColor+drColor("分组标示")&drColor("打印_颜色")& ":" & drColor("小包装只数") & "只" Next rx = New prt.RenderText() rx.text=cColor rx.Style.FontBold = True '字体加粗 rx.Style.FontSize = 12 '大体大小为16磅 rx.Style.Spacing.All = 0 '设置各个方向的间隔 rx.Style.TextAlignHorz = prt.AlignHorzEnum.Left '水平居中排列 ra.Children.Add(rx) '将文本对象加入到容器ra中 Next
|