📄 frm_材料消耗.frm
字号:
k = 0
End If
'For J = 0 To DBGrid1.Columns.Count - 1
PrintString = DBGrid1.Columns(1).CellText(DBGrid1.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 2.4
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第三列内容
For i1 = 0 To Data1.Recordset.RecordCount - 1
If k = DBGrid1.VisibleRows Then
DBGrid1.Scroll 0, DBGrid1.VisibleRows
k = 0
End If
'For J = 0 To DBGrid1.Columns.Count - 1
PrintString = DBGrid1.Columns(2).CellText(DBGrid1.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 4.5
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第四列内容
For i1 = 0 To Data1.Recordset.RecordCount - 1
If k = DBGrid1.VisibleRows Then
DBGrid1.Scroll 0, DBGrid1.VisibleRows
k = 0
End If
'For J = 0 To DBGrid1.Columns.Count - 1
PrintString = DBGrid1.Columns(3).CellText(DBGrid1.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 7.05
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第五列内容
For i1 = 0 To Data1.Recordset.RecordCount - 1
If k = DBGrid1.VisibleRows Then
DBGrid1.Scroll 0, DBGrid1.VisibleRows
k = 0
End If
'For J = 0 To DBGrid1.Columns.Count - 1
PrintString = DBGrid1.Columns(4).CellText(DBGrid1.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 8.6
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第一行内容
.CurrentX = lngLM * 2.35
.CurrentY = lngTM * 2
Dest.Print Text22.Text
.CurrentX = lngLM * 2.9
.CurrentY = lngTM * 2.75
Dest.Print Text22.Text
.CurrentX = lngLM * 9
.CurrentY = lngTM * 2.75
Dest.Print "NJZG/QR7.5-2-2"
'第2行内容
.CurrentX = lngLM * 3.1
.CurrentY = lngTM * 3.15
Dest.Print Text2.Text
'第3行内容
.CurrentX = lngLM * 3.5
.CurrentY = lngTM * 3.55
Dest.Print Text1.Text
.CurrentX = lngLM * 9
.CurrentY = lngTM * 3.55
Dest.Print Text9.Text
.Font.Name = "标楷体"
.Font.Size = 12
.CurrentX = lngLM + lngSW / 1.2 - .TextWidth("第 1 页")
.CurrentY = lngTM + lngSH / 1.1 - .TextHeight("第 1 页")
Dest.Print "第 " & Text25.Text & " 页"
End If
If SSTab1.Tab = 1 Then
'最后列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid2.Columns.Count - 1
PrintString = DBGrid2.Columns(DBGrid2.Columns.count - 1).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 10.3
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第一列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid2.Columns.Count - 1
PrintString = DBGrid2.Columns(0).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 1.5
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第二列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid2.Columns.Count - 1
PrintString = DBGrid2.Columns(1).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 2.4
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第三列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid2.Columns.Count - 1
PrintString = DBGrid2.Columns(2).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 4.5
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第四列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid2.Columns.Count - 1
PrintString = DBGrid2.Columns(3).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 7.05
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第五列内容
For i1 = 0 To Data2.Recordset.RecordCount - 1
If k = DBGrid2.VisibleRows Then
DBGrid2.Scroll 0, DBGrid2.VisibleRows
k = 0
End If
'For J = 0 To DBGrid1.Columns.Count - 1
PrintString = DBGrid2.Columns(4).CellText(DBGrid2.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 8.6
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第一行内容
.CurrentX = lngLM * 2.35
.CurrentY = lngTM * 2
Dest.Print Text23.Text
.CurrentX = lngLM * 2.9
.CurrentY = lngTM * 2.75
Dest.Print Text23.Text
.CurrentX = lngLM * 9
.CurrentY = lngTM * 2.75
Dest.Print "NJZG/QR7.5-2-2"
'第2行内容
.CurrentX = lngLM * 3.1
.CurrentY = lngTM * 3.15
Dest.Print Text4.Text
'第3行内容
.CurrentX = lngLM * 3.5
.CurrentY = lngTM * 3.55
Dest.Print Text5.Text
.CurrentX = lngLM * 9
.CurrentY = lngTM * 3.55
Dest.Print Text3.Text
.Font.Name = "标楷体"
.Font.Size = 12
.CurrentX = lngLM + lngSW / 1.2 - .TextWidth("第 1 页")
.CurrentY = lngTM + lngSH / 1.1 - .TextHeight("第 1 页")
Dest.Print "第 " & Text26.Text & " 页"
End If
If SSTab1.Tab = 2 Then
'最后列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(DBGrid3.Columns.count - 1).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 10.3
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第一列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(0).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 1.5
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第二列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(1).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 2.4
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第三列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(2).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 4.5
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第四列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(3).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 7.05
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第五列内容
For i1 = 0 To Data3.Recordset.RecordCount - 1
If k = DBGrid3.VisibleRows Then
DBGrid3.Scroll 0, DBGrid3.VisibleRows
k = 0
End If
'For J = 0 To DBGrid3.Columns.Count - 1
PrintString = DBGrid3.Columns(4).CellText(DBGrid3.RowBookmark(k))
'Next
'Printer.Print PrintString
.CurrentX = lngLM * 8.6
.CurrentY = lngTM * (4.95 + k / 2.5)
Dest.Print PrintString
PrintString = ""
k = k + 1
DoEvents
Next
'第一行内容
.CurrentX = lngLM * 2.35
.CurrentY = lngTM * 2
Dest.Print Text24.Text
.CurrentX = lngLM * 2.9
.CurrentY = lngTM * 2.75
Dest.Print Text24.Text
.CurrentX = lngLM * 9
.CurrentY = lngTM * 2.75
Dest.Print "NJZG/QR7.5-2-2"
'第2行内容
.CurrentX = lngLM * 3.1
.CurrentY = lngTM * 3.15
Dest.Print Text11.Text
'第3行内容
.CurrentX = lngLM * 3.5
.CurrentY = lngTM * 3.55
Dest.Print Text12.Text
.CurrentX = lngLM * 9
.Cur
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -