【二维码】下面条件将所有分册编号的二维码全部生成出来了有没有办法只生成符合某个条件的二维码记录呢？ - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

下面代码是将当前表所有分册编号的全部生成报表出来了

有没有办法加上一个条件使之只生成当前【卷宗编号】的二维码记录表呢？

Dim doc As New PrintDoc

Dim rg As prt.RenderGraphics

Dim Bar As New BarCodeBuilder

Bar.Symbology = Barpro.Symbology.QRCode

Doc.Stacking = prt.StackingRulesEnum.InlineLeftToRight

For Each r As Row In Tables("入库明细").Rows

bar.Code = r("分册编号的")

rg = new prt.RenderGraphics

bar.DrawOnCanvas(rg.Graphics,0,0,1)

rg.Style.Spacing.All = 1

Doc.Body.Children.Add(rg)

Doc.Preview()

自行修改为下面的代码初步可以实现效果【不知道是否有更好的办法呢？】

Dim ab As Row = Tables("卷宗入库").Current

Dim doc As New PrintDoc

Dim rg As prt.RenderGraphics

Dim Bar As New BarCodeBuilder

Bar.Symbology = Barpro.Symbology.QRCode

Doc.Stacking = prt.StackingRulesEnum.InlineLeftToRight

For Each r As Row In Tables("入库明细").Rows

If r("卷宗编号")=ab("卷宗编号") Then

bar.Code = r("分册编号")

rg = new prt.RenderGraphics

bar.DrawOnCanvas(rg.Graphics,0,0,1)

rg.Style.Spacing.All = 1

Doc.Body.Children.Add(rg)

End If

Doc.Preview()

If Tables("卷宗入库").Current IsNot Nothing Then

Tables("入库明细").Filter = "卷宗编号 = '" & Tables("卷宗入库").Current("卷宗编号") & "'"

Dim doc As New PrintDoc

Dim rg As prt.RenderGraphics

Dim Bar As New BarCodeBuilder

Bar.Symbology = Barpro.Symbology.QRCode

Doc.Stacking = prt.StackingRulesEnum.InlineLeftToRight

For Each r As Row In Tables("入库明细").Rows

bar.Code = r("分册编号的")

rg = new prt.RenderGraphics

bar.DrawOnCanvas(rg.Graphics,0,0,1)

rg.Style.Spacing.All = 1

Doc.Body.Children.Add(rg)

Doc.Preview()

End If

谢谢

有没有调整生成的二维码的大小呢？

默认A4纸张图片太大

此主题相关图片如下：2017-10-23_214622.jpg

[此贴子已经被作者于2017/10/23 21:47:42编辑过]

http://www.foxtable.com/webhelp/scr/2090.htm

bar.DrawOnCanvas(rg.Graphics,0,0,0.5)

主题：【二维码】下面条件将所有分册编号的二维码全部生成出来了 有没有办法只生成符合某个条件的二维码记录呢？

主题：【二维码】下面条件将所有分册编号的二维码全部生成出来了有没有办法只生成符合某个条件的二维码记录呢？