怎么用商业版打印没问题。。。。
转换格式后,用 开发板打印
Dim fileName1 As String = dr("受领书")
Dim obj1 As object = CreateObject("WScript.Network")
obj1.SetDefaultPrinter("EPSON LQ-1600K IIIH ESC/P2")
If filename1 IsNot Nothing Then
PDFView.PrinterUtil.RenderDPI = 350
Dim pageCount1 As Integer = pdf.PageCount(fileName1) '获取页码
PDFView.PrinterUtil.PrintImagesToPrinter(fileName1,1, pagecount1, 1, False)
End If
Dim fileName As String = dr("路径") '文件路径
Dim obj As object = CreateObject("WScript.Network")
obj.SetDefaultPrinter(dayinji)
If filename IsNot Nothing Then
PDFView.PrinterUtil.RenderDPI = 500
Dim pageCount As Integer = pdf.PageCount(fileName) '获取页码
Dim copyCount As Integer = Math.Ceiling((pageCount - 2)/4)
If dr("货号")="H2" Then
Dim sum1 As Integer
sum1 =DataTables("订单明细").Compute("sum(箱体总高)","[订单条码] = '" & dr("订单条码") &"' And [客户品番] = '90915CA003'")
If sum1 >0 Then
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 1, 2, Math.Ceiling(sum1/396), False)
End If
Dim sum2 As Integer
sum2 =DataTables("订单明细").Compute("sum(箱体总高)","[订单条码] = '" & dr("订单条码") &"' And [客户品番] <> '90915CA003'")
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 1, 2, Math.Ceiling(sum2/396), False)
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 3, pagecount, 1, False)
Else
If dr("货号")="K5" Then
Dim sum4 As Integer
sum4 =DataTables("订单明细").Compute("sum(箱体总高)","[订单条码] = '" & dr("订单条码") &"' And [客户品番] = '177000V110'")
If sum4 > 0 Then
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 1, 2, Math.Ceiling(sum4/297), False)
End If
Dim sum5 As Integer
sum5 =DataTables("订单明细").Compute("sum(箱体总高)","[订单条码] = '" & dr("订单条码") &"' And [客户品番] <> '177000V110'")
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 1, 2, Math.Ceiling(sum5/396), False)
PDFView.PrinterUtil.PrintImagesToPrinter(fileName, 3, pagecount, 1, False)
'追加空箱打印
Dim sum6 As Integer
sum6 =DataTables("订单明细").Compute("sum(箱数)","[订单条码] = '" & dr("订单条码") &"' And [箱体高度] = '33' And [客户品番] <> '177000V110'")
Dim sum7 As Integer
sum7 =DataTables("订单明细").Compute("sum(箱数)","[订单条码] = '" & dr("订单条码") &"' And [箱体高度] = '22' And [客户品番] <> '177000V110'")
Dim vk As DataRow = DataTables("空箱计算表").Find("EU33 = '" & sum6 & "' and EU22 = '" & sum7 & "'")
If vk IsNot Nothing Then
If vk("空箱数") > 0 Then
Dim ln As Integer = vk("空箱数")
Dim strpath As String = "E:\出货系统\Attachments\空箱" & ln & ".xlsx"
If FileSys.FileExists(strpath) Then
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(strpath)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Ws.PrintOut(From:=1,To:=1,Copies:=1,Preview:=False)
App.Visible = True
App.Quit
End If
End If
end if
打印的时候 "H2" 就会提示 。
"K5" 没问题!
[此贴子已经被作者于2015/7/9 12:05:57编辑过]