以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  【二维码】根据分册编码,如何批量生成二维码呢?  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=108476)

--  作者:李孝春
--  发布时间:2017/10/23 18:36:00
--  【二维码】根据分册编码,如何批量生成二维码呢?
【二维码】根据分册编码,如何批量生成二维码呢?
录入卷宗册数,假设是5卷
会自动生成5行
分册编号【类型为字符】对应为
5-1
5-2
5-3
5-4
5-5

代码如下:如何在红色部分代码做修改,使之对应生成五个二维码呢?分别对应分册编号记录数

Select Case e.DataCol.Name
    Case "所属地州","所属单位","卷宗名称","录入时间","承办人","承办部门","联系电话","卷宗册数","分册编号"
        Dim Val1 As String = e.DataRow("所属地州")
        Dim Val11 As String = e.DataRow("所属单位")
        Dim Val111 As String = e.DataRow("卷宗名称")
        Dim Val1111 As String = e.DataRow("卷宗册数")
        Dim Val11111 As String= e.DataRow("录入时间")
        Dim Val111111 As String= e.DataRow("承办人")
        Dim Val1111111 As String= e.DataRow("承办部门")
        Dim Val11111111 As String= e.DataRow("联系电话")
        Dim Val111111111 As  String= e.DataRow("卷宗册数")
        Dim Val1111111111 As  String= e.DataRow("分册编号")
        
        Dim val0 As String = "所属地州:[" & val1 & "]" & "所属单位:[" & val11 & "]" & "案卷名:[" & val111 & "]" & "册数:[" & val1111 & "]" & "入库时间:[" & Val11111 & "]" & "承办人:[" & Val111111 & "]" & "承办部门:[" & Val1111111 & "]" & "联系电话:[" & Val11111111 & "]" & "卷宗册数:[" & Val111111111 & "]" & "分册编号:[" & Val1111111111 & "]"
        e.DataRow("加密字符")=EncryptText(Val0,"a23","op#")
        Dim Bar As New BarCodeBuilder
        Bar.Symbology = Barpro.Symbology.QRCode
        Bar.Code = EncryptText(Val0,"a23","op#")
        Bar.QuietZoneWidth = 2
        Bar.SaveImage("d:\\ceshi\\" & e.DataRow("卷宗名称") & e.datarow("分册编号") & ".jpg")
            
End Select
[此贴子已经被作者于2017/10/23 20:06:56编辑过]

--  作者:有点蓝
--  发布时间:2017/10/23 20:12:00
--  
既然是自动生成5行,那么这个事件就自然会触发5次,然后保存了5个。还需要怎么处理呢?