📄 krjz1.frm
字号:
End
Begin VB.Line Line5
X1 = 3240
X2 = 3240
Y1 = 720
Y2 = 1080
End
Begin VB.Line Line6
Index = 0
X1 = 4080
X2 = 4080
Y1 = 720
Y2 = 1080
End
Begin VB.Line Line7
Index = 0
X1 = 4680
X2 = 4680
Y1 = 720
Y2 = 1080
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "合 计"
Height = 255
Index = 14
Left = 5160
TabIndex = 14
Top = 3000
Width = 735
End
Begin VB.Line Line8
X1 = 120
X2 = 7320
Y1 = 3240
Y2 = 3240
End
Begin VB.Line Line9
X1 = 120
X2 = 7320
Y1 = 3960
Y2 = 3960
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "合计金额<大写>"
Height = 255
Index = 15
Left = 240
TabIndex = 13
Top = 3720
Width = 1455
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "结帐收现"
Height = 255
Index = 24
Left = 2760
TabIndex = 12
Top = 3360
Width = 735
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "下欠金额"
Height = 255
Index = 25
Left = 5040
TabIndex = 11
Top = 3360
Width = 735
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "备注："
Height = 255
Index = 26
Left = 240
TabIndex = 10
Top = 4080
Width = 735
End
Begin VB.Line Line11
X1 = 600
X2 = 7320
Y1 = 1800
Y2 = 1800
End
Begin VB.Line Line12
X1 = 600
X2 = 7320
Y1 = 2160
Y2 = 2160
End
Begin VB.Line Line13
X1 = 120
X2 = 7320
Y1 = 2520
Y2 = 2520
End
Begin VB.Line Line14
X1 = 600
X2 = 600
Y1 = 1440
Y2 = 3240
End
Begin VB.Line Line17
X1 = 3600
X2 = 3600
Y1 = 1080
Y2 = 3600
End
Begin VB.Line Line18
X1 = 4920
X2 = 4920
Y1 = 1080
Y2 = 3600
End
Begin VB.Line Line19
X1 = 5880
X2 = 5880
Y1 = 1080
Y2 = 3600
End
Begin VB.Line Line21
X1 = 1560
X2 = 1560
Y1 = 3600
Y2 = 3960
End
Begin VB.Line Line22
X1 = 1350
X2 = 1350
Y1 = 1440
Y2 = 3600
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "姓 名"
DataField = "姓名"
DataSource = "Data2"
Height = 255
Index = 27
Left = 1320
TabIndex = 9
Top = 840
Width = 1095
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "入住日期"
DataField = "入住日期"
DataSource = "Data2"
Height = 255
Index = 28
Left = 1320
TabIndex = 8
Top = 1200
Width = 1215
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "性 别"
DataField = "性别"
DataSource = "Data2"
Height = 255
Index = 29
Left = 3360
TabIndex = 7
Top = 840
Width = 615
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "离住日期"
DataField = "离住日期"
DataSource = "Data2"
Height = 255
Index = 30
Left = 3720
TabIndex = 6
Top = 1200
Width = 1215
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "房 号"
DataField = "房号"
DataSource = "Data2"
Height = 255
Index = 31
Left = 4800
TabIndex = 5
Top = 840
Width = 735
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "金额大写"
Height = 255
Index = 34
Left = 1680
TabIndex = 4
Top = 3720
Width = 5775
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "应 补"
Height = 255
Index = 35
Left = 360
TabIndex = 3
Top = 3360
Width = 735
End
Begin VB.Label Label1
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "散客离店结算单"
BeginProperty Font
Name = "楷体_GB2312"
Size = 15.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 0
Left = 120
TabIndex = 36
Top = 240
Width = 7215
End
End
End
Attribute VB_Name = "KRJZ1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command2_Click()
SKJZPREVIEW.Show vbModal
End Sub
Private Sub Command3_Click()
On Error GoTo SXERROR
If Data2.Recordset("结帐收现") > 0 Then
If MsgBox("已收现,确认是否修改?", vbQuestion + vbYesNo, "提示信息") = vbNo Then
Exit Sub
End If
End If
MYMARK = Data2.Recordset.Bookmark
Data2.Recordset.Edit
Data2.Recordset("结帐收现") = InputBox("请输入结帐收现金额:", "结帐收现窗口", Label4(16).Caption)
Data2.Recordset.Update
Data1.Refresh
Form_Activate
Exit Sub
SXERROR:
MsgBox CStr(Err.Number) & "-" & Err.Description, vbCritical, "错误信息"
Exit Sub
End Sub
Private Sub Form_Activate()
Dim CURINDEX As Label
Data2.Refresh
Data1.Recordset.FindFirst ("客人ID='" & left(KRJZ.List1(0).Text, 12) & "'")
Data2.Recordset.FindFirst ("客人ID='" & left(KRJZ.List1(0).Text, 12) & "'")
If Not Data2.Recordset("住房") Then Label1(0).Caption = "客人消费结算单"
For Each CURINDEX In Label4
If IsNumeric(CURINDEX.Caption) Then
CURINDEX.Caption = FormatNumber(CURINDEX.Caption, 2, vbTrue, , vbFalse)
End If
Next
If Data1.Recordset("应补应退") > 0 Then
Command3.Visible = False
Label1(35).Caption = "应 退"
MYMARK = Data2.Recordset.Bookmark
Data2.Recordset.Edit
Data2.Recordset("结帐收现") = -Data1.Recordset("应补应退")
Data2.Recordset.Update
Data2.Recordset.Bookmark = MYMARK
Label4(17).Caption = ""
Label4(18).Caption = ""
Else
If Data1.Recordset("应补应退") = 0 Then
Command3.Visible = False
Label4(16).Caption = ""
Label4(17).Caption = ""
Label4(18).Caption = ""
Else
If KRJZ.STRJZLX = "现金结帐" Then
Command3.Visible = False
MYMARK = Data2.Recordset.Bookmark
Data2.Recordset.Edit
Data2.Recordset("结帐收现") = -Data1.Recordset("应补应退")
Data2.Recordset.Update
Data2.Recordset.Bookmark = MYMARK
Label4(17).Caption = ""
Label4(18).Caption = FormatNumber(Data2.Recordset("结帐收现"), 2, vbTrue, , vbFalse)
End If
Label4(16).Caption = FormatNumber(Abs(Data1.Recordset("应补应退")), 2, vbTrue, , vbFalse)
End If
End If
Label1(34).Caption = "人民币" + SUMDM(CDbl(Label4(15)))
Label1(28).Caption = Format(Label1(28).Caption, "LONG DATE")
Label1(30).Caption = Format(Label1(30).Caption, "LONG DATE")
If IsNumeric(Label1(36).Caption) Then
Label1(36).Caption = FormatNumber(Label1(36).Caption, 2, vbTrue, , vbFalse)
End If
End Sub
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\data\jdgl.mdb"
Data1.Refresh
Data2.DatabaseName = App.Path & "\data\jdgl.mdb"
Data2.Refresh
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -