📄 krjz.frm
字号:
Left = -74880
TabIndex = 11
ToolTipText = "团会基本情况"
Top = 3600
Width = 3015
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
BorderStyle = 1 'Fixed Single
Caption = "Label2"
Height = 1575
Index = 0
Left = 120
TabIndex = 10
ToolTipText = "散客基本情况"
Top = 3600
Width = 3015
End
End
Begin MSComctlLib.ImageList ImageList2
Left = 6000
Top = 120
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 26
ImageHeight = 23
MaskColor = 16777215
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 10
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":303A
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":31BE
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":3686
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":3B8A
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":3D0E
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":41D6
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":435A
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":47E6
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":4C3A
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":50C6
Key = ""
EndProperty
EndProperty
End
Begin MSComDlg.CommonDialog CDLTEST
Left = 5520
Top = 120
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin MSComctlLib.ImageList ImageList1
Left = 6600
Top = 120
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 17
ImageHeight = 15
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 4
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":55DA
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":593A
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":5CD6
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "KRJZ.frx":608A
Key = ""
EndProperty
EndProperty
End
Begin DevPowerTransImg.TransImg TransImg1
Height = 495
Left = 8880
TabIndex = 0
Top = 680
Width = 1095
_ExtentX = 1931
_ExtentY = 873
AutoSize = 0 'False
MaskColor = 16777215
Transparent = -1 'True
End
Begin VB.Data Data3
Connect = "Access"
DatabaseName = "c:\JDGL\DATA\jdgl.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Index = 0
Left = 4200
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = $"KRJZ.frx":65CA
Top = 3600
Visible = 0 'False
Width = 2505
End
Begin VB.Frame Frame4
Height = 4155
Left = 3480
TabIndex = 12
Top = 750
Width = 6255
Begin VB.Data Data3
Caption = "Data3"
Connect = "Access"
DatabaseName = "C:\JDGL\DATA\Jdgl.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Index = 1
Left = 720
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = $"KRJZ.frx":66F2
Top = 2400
Visible = 0 'False
Width = 2055
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "KRJZ.frx":6B51
Height = 3975
Left = 30
OleObjectBlob = "KRJZ.frx":6B68
TabIndex = 13
ToolTipText = "计费窗口(消费明细帐)"
Top = 120
Width = 6180
End
End
Begin VB.Menu MNU1
Caption = "文件(&F)"
Begin VB.Menu MNU11
Caption = "打印设置"
End
Begin VB.Menu MNU12
Caption = "打印预览"
Enabled = 0 'False
Visible = 0 'False
End
Begin VB.Menu MNU13
Caption = "打印 "
Enabled = 0 'False
Shortcut = ^P
Visible = 0 'False
End
Begin VB.Menu MNU15
Caption = "-"
End
Begin VB.Menu MNU16
Caption = "退出(&E)"
End
End
Begin VB.Menu MNU2
Caption = "编辑(&E)"
Begin VB.Menu MNU21
Caption = "增加 "
Shortcut = ^A
End
Begin VB.Menu MNU26
Caption = "-"
End
Begin VB.Menu MNU22
Caption = "删除 "
Shortcut = ^D
End
End
Begin VB.Menu MNU3
Caption = "结帐(&C)"
End
Begin VB.Menu MNU4
Caption = "计算器(&J)"
End
Begin VB.Menu MNU5
Caption = "帮助(&H)"
Begin VB.Menu MNU51
Caption = "帮助主题"
Shortcut = {F1}
End
Begin VB.Menu MNU52
Caption = "索引"
Enabled = 0 'False
End
Begin VB.Menu MNU53
Caption = "-"
End
Begin VB.Menu MNU54
Caption = "关于红日软件..."
End
End
End
Attribute VB_Name = "KRJZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim DATJDGL As Database
Dim RECHT As Recordset
Dim RECSK As Recordset
Dim RECTH As Recordset
Public STRJZLX As String '结帐类型
Private Sub DBGrid1_AfterColEdit(ByVal ColIndex As Integer)
On Error GoTo EXITSUB
If Not IsNumeric(DBGrid1.Text) Then
MsgBox "错误的数据类型!请修改...", vbCritical, "错误信息"
DBGrid1.Text = 0
End If
MYMARK = Data3(0).Recordset.Bookmark
Data3(0).UpdateRecord
Data3(0).Recordset.Bookmark = MYMARK
Data3(1).Refresh
If SSTab1.Tab = 0 Then STRIDMC = "客人ID" Else STRIDMC = "团会ID"
Data3(1).Recordset.FindFirst (STRIDMC & "='" & left(List1(SSTab1.Tab).Text, 12) & "'")
Exit Sub
EXITSUB:
SFOK = MsgBox(CStr(Err.Number) & "-" & Err.Description, vbCritical + vbAbortRetryIgnore, "错误信息")
If SFOK = vbAbort Then
Unload Me
Else
If SFOK = vbRetry Then
Resume
Else
Resume Next
End If
End If
End Sub
Private Sub DBGrid1_MouseDown(Button As Integer, Shift As Integer, X As Single, y As Single)
If Button = vbRightButton Then
Me.PopupMenu MNU2
End If
End Sub
Private Sub Form_Activate()
If List1(SSTab1.Tab).ListCount > 0 Then List1(SSTab1.Tab).ListIndex = 0
End Sub
Private Sub Form_Load()
Data1(0).DatabaseName = App.Path & "\data\jdgl.mdb"
Data1(0).Refresh
Data2(0).DatabaseName = App.Path & "\data\jdgl.mdb"
Data2(0).Refresh
Data3(0).DatabaseName = App.Path & "\data\jdgl.mdb"
Data3(0).Refresh
Data1(1).DatabaseName = App.Path & "\data\jdgl.mdb"
Data1(1).Refresh
Data2(1).DatabaseName = App.Path & "\data\jdgl.mdb"
Data2(1).Refresh
Data3(1).DatabaseName = App.Path & "\data\jdgl.mdb"
Data3(1).Refresh
Set DATJDGL = OpenDatabase(App.Path & "\DATA\JDGL.MDB")
Set RECTH = DATJDGL.OpenRecordset("团会登记表", dbOpenDynaset)
Set RECSK = DATJDGL.OpenRecordset("散客登记表", dbOpenDynaset)
Set RECZD = DATJDGL.OpenRecordset("客人帐单", dbOpenDynaset)
List1(1).Clear
Do While Not RECTH.EOF
If RECTH("团会名称") <> " " Then
List1(1).AddItem RECTH("团会ID") + " " + IIf(IsNull(RECTH("团会名称")), "", RECTH("团会名称"))
End If
RECTH.MoveNext
Loop
List1(0).Clear
If RECSK.RecordCount > 0 Then RECSK.MoveFirst
While Not RECSK.EOF
List1(0).AddItem RECSK("客人ID") + " " + IIf(IsNull(RECSK("姓名")), "", RECSK("姓名"))
RECSK.MoveNext
Wend
End Sub
Private Sub Form_Unload(Cancel As Integer)
DATJDGL.Close
End Sub
Private Sub List1_Click(Index As Integer)
If List1(Index).Text = "" Then
If List1(Index).ListCount > 0 Then List1(Index).ListIndex = 0 Else seleid1 = "SELECT 客人帐单.客人ID,客人帐单.日期, 客人帐单.保证金,客人帐单.房费,客人帐单.商品, 客人帐单.加床费, 客人帐单.停车, 客人帐单.电话, 客人帐单.餐费, 客人帐单.酒水, 客人帐单.商务, 客人帐单.会议, 客人帐单.酒吧, 客人帐单.舞厅, 客人帐单.旅游, 客人帐单.损失赔偿, 客人帐单.其他, 客人帐单.操作员,客人帐单.班次 From 客人帐单 WHERE (((客人帐单.客人ID)='999999999999')) AND 客人帐单.保证金=0"
End If
If Index = 0 Then
seleid1 = "SELECT 客人帐单.ID,客人帐单.客人ID,客人帐单.日期, 客人帐单.保证金,客人帐单.房费,客人帐单.商品, 客人帐单.加床费, 客人帐单.停车, 客人帐单.电话, 客人帐单.餐费, 客人帐单.酒水, 客人帐单.商务, 客人帐单.会议, 客人帐单.酒吧, 客人帐单.舞厅, 客人帐单.旅游, 客人帐单.损失赔偿, 客人帐单.其他, 客人帐单.操作员,客人帐单.班次 From 客人帐单 WHERE (((客人帐单.客人ID)='" & left(List1(0).Text, 12) & "')) AND 客人帐单.保证金=0"
Else
seleid1 = "SELECT 客人帐单.ID,客人帐单.团会ID,客人帐单.日期, 客人帐单.保证金,客人帐单.房费,客人帐单.商品, 客人帐单.加床费, 客人帐单.停车, 客人帐单.电话, 客人帐单.餐费, 客人帐单.酒水, 客人帐单.商务, 客人帐单.会议, 客人帐单.酒吧, 客人帐单.舞厅, 客人帐单.旅游, 客人帐单.损失赔偿, 客人帐单.其他, 客人帐单.操作员,客人帐单.班次 From 客人帐单 WHERE (((客人帐单.团会ID)='" & left(List1(1).Text, 12) & "')) AND 客人帐单.保证金=0"
End If
Data3(0).RecordSource = seleid1
Data3(0).Refresh
If SSTab1.Tab = 0 Then STRIDMC = "客人ID" Else STRIDMC = "团会ID"
Data1(SSTab1.Tab).Recordset.FindFirst (STRIDMC & "='" & left(List1(SSTab1.Tab).Text, 12) & "'")
Data2(SSTab1.Tab).Recordset.FindFirst (STRIDMC & "='" & left(List1(SSTab1.Tab).Text, 12) & "'")
Data3(1).Recordset.FindFirst (STRIDMC & "='" & left(List1(SSTab1.Tab).Text, 12) & "'")
STROPTION = ""
If Not Data1(SSTab1.Tab).Recordset.EOF Then
If SSTab1.Tab = 0 Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -