📄 frmsell_qd.frm
字号:
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 240
Left = 6600
TabIndex = 6
Top = 7920
Width = 1275
End
Begin VB.Label lblSE
AutoSize = -1 'True
Caption = "Label8"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 240
Left = 7920
TabIndex = 5
Top = 7920
Width = 810
End
Begin VB.Label Label8
AutoSize = -1 'True
Caption = "金税合计："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 240
Left = 9360
TabIndex = 4
Top = 7920
Width = 1275
End
Begin VB.Label lblJSHJ
AutoSize = -1 'True
Caption = "Label9"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 240
Left = 10680
TabIndex = 3
Top = 7920
Width = 810
End
Begin VB.Label TxtSHR
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 300
Left = 1440
TabIndex = 2
Top = 915
Width = 2775
End
Begin VB.Label LblFPHM
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 300
Left = 1440
TabIndex = 1
Top = 480
Width = 2775
End
Begin VB.Line Line1
X1 = 120
X2 = 11880
Y1 = 7800
Y2 = 7800
End
Begin VB.Line Line2
X1 = 120
X2 = 11880
Y1 = 8280
Y2 = 8280
End
Begin VB.Line Line3
X1 = 120
X2 = 120
Y1 = 7800
Y2 = 8280
End
Begin VB.Line Line4
X1 = 11880
X2 = 11880
Y1 = 7800
Y2 = 8280
End
End
Attribute VB_Name = "FrmSELL_QD"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Call FPPrint
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub FPPrint()
Dim t As Integer
Dim j As Integer
Dim N As Integer
' Dim RstKH As ADODB.Recordset
' On Error GoTo Errorhandler
Set XSDExcel = New Excel.Application
XSDExcel.Visible = True
'Set XSDExcel = Nothing
XSDExcel.SheetsInNewWorkbook = 1
Set zsbworkbook = XSDExcel.Workbooks.Open(App.Path + "\" + "sheet\销售单.xlt")
With XSDExcel.ActiveSheet
'--------------------------------------填充客户资料
'Set RstKH = New Recordset
' SQL = "select * from customer where cn_CompanyName='" & Trim(Me.Combo1.Text) & "'"
' 'RstKH.Open SQL, Db, 1, 3
' Set RstKH = ExecuteSQL(SQL, MsgText)
'
'
' .Range("F3").Value = RstKH.Fields(1)
' .Range("F4").Value = RstKH.Fields(2)
' .Range("F5").Value = RstKH.Fields(3)
' .Range("F6").Value = "M.B.: " & RstKH.Fields(4)
'
' RstKH.Close
' Set RstKH = Nothing
'-----------------------------------------
' If Combo1.Text = "现金" Then
' .Range("D9").Value = "GOTOVINA"
' Else
' .Range("D9").Value = "Waiting...."
' End If
.Range("C4").Value = Me.lblxsrq
.Range("G4").Value = Me.LblFPHM
.Range("C6").Value = Me.TxtSHR
.Range("G6").Value = Me.TxtSHR1
.Range("C33").Value = Me.lblSL
.Range("F33").Value = Me.lblJE
.Range("C35").Value = Me.lblSE
.Range("F35").Value = Me.lblJSHJ
For t = 1 To Grid.Rows - 1
a = "A" + CStr(t + 8)
b = "B" + CStr(t + 8)
d = "D" + CStr(t + 8)
e = "E" + CStr(t + 8)
f = "F" + CStr(t + 8)
g = "G" + CStr(t + 8)
h = "H" + CStr(t + 8)
a2 = "J" + CStr(t + 8)
.Range(a).Value = Grid.TextMatrix(t, 0)
.Range(b).Value = Grid.TextMatrix(t, 1)
.Range(d).Value = Grid.TextMatrix(t, 5)
.Range(e).Value = Grid.TextMatrix(t, 6)
.Range(f).Value = Grid.TextMatrix(t, 7)
.Range(g).Value = Grid.TextMatrix(t, 8)
.Range(h).Value = Grid.TextMatrix(t, 9)
.Range(a2).Value = Grid.TextMatrix(t, 10)
Next t
For j = 1 To Grid.Rows - 1
a1 = "A" + CStr(j + 20)
c1 = "C" + CStr(j + 20)
d1 = "D" + CStr(j + 20)
f1 = "F" + CStr(j + 20)
.Range(a1).Value = Grid.TextMatrix(j, 1)
.Range(c1).Value = Grid.TextMatrix(j, 2)
.Range(d1).Value = Grid.TextMatrix(j, 3)
.Range(f1).Value = Grid.TextMatrix(j, 4)
Next j
' N = 12 + Grid.Rows
' 'If n > 40 Then
' 'End If
' j = 1
' For t = 14 To N
' a = "A" + CStr(t)
' .Range(a).Value = Grid.TextMatrix(j, 0)
' b = "B" + CStr(t)
' .Range(b).Value = Grid.TextMatrix(j, 1)
' c = "C" + CStr(t)
' .Range(c).Value = "KOM"
' d = "D" + CStr(t)
' .Range(d).Value = Grid.TextMatrix(j, 5)
' e = "E" + CStr(t)
' .Range(e).Value = Grid.TextMatrix(j, 6)
' f = "F" + CStr(t)
' .Range(f).Value = Grid.TextMatrix(j, 7)
' g = "G" + CStr(t)
' .Range(g).Value = "22%"
' h = "H" + CStr(t)
' .Range(h).Value = Grid.TextMatrix(j, 9)
' I = "I" + CStr(t)
' .Range(I).Value = Grid.TextMatrix(j, 10)
' j = j + 1
' Next t
' .Range("F54").Value = lblJE.Caption
' .Range("G54").Value = "22%"
' .Range("H54").Value = lblSE.Caption
' .Range("I54").Value = lblJSHJ.Caption
End With
'dd = MsgBox("yes or no", vbYesNo + vbSystemModal)
'If dd = vbNo Then Exit Sub
' XSDExcel.ActiveSheet.PageSetup.Orientation = xlPortrait 'xlLandscape
' XSDExcel.ActiveSheet.PageSetup.PaperSize = xlPaperA4
XSDExcel.Caption = "打印预览"
XSDExcel.ActiveWindow.SelectedSheets.PrintPreview
' XSDExcel.ActiveSheet.PrintOut
XSDExcel.DisplayAlerts = False
XSDExcel.Quit
XSDExcel.DisplayAlerts = True
Set XSDExcel = Nothing
Exit Sub
'Errorhandler:
' MsgBox "请正确安装EXCEL或检查打印机状况！", vbOKOnly + vbCritical
Exit Sub
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -