📄 frmprintrestbill.frm
字号:
VERSION 5.00
Begin VB.Form FrmRoomStatus
BackColor = &H00C0E0FF&
BorderStyle = 0 'None
Caption = "Room Status"
ClientHeight = 8325
ClientLeft = 0
ClientTop = 0
ClientWidth = 9795
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 8325
ScaleWidth = 9795
ShowInTaskbar = 0 'False
Begin VB.OptionButton Option3
BackColor = &H00C0E0FF&
Caption = "All Rooms"
BeginProperty Font
Name = "Times New Roman"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7680
TabIndex = 9
Top = 240
Value = -1 'True
Width = 1935
End
Begin VB.OptionButton Option2
BackColor = &H00C0E0FF&
Caption = "Full Rooms"
BeginProperty Font
Name = "Times New Roman"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 5520
TabIndex = 8
Top = 240
Width = 1935
End
Begin VB.OptionButton Option1
BackColor = &H00C0E0FF&
Caption = "Empty Rooms"
BeginProperty Font
Name = "Times New Roman"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3240
TabIndex = 7
Top = 240
Width = 1935
End
Begin VB.ListBox List4
Appearance = 0 'Flat
BackColor = &H0080C0FF&
Height = 6270
ItemData = "FrmPrintRestBill.frx":0000
Left = 6480
List = "FrmPrintRestBill.frx":0002
TabIndex = 6
Top = 1200
Width = 3015
End
Begin VB.ListBox List3
Appearance = 0 'Flat
BackColor = &H0080C0FF&
Height = 6270
ItemData = "FrmPrintRestBill.frx":0004
Left = 3480
List = "FrmPrintRestBill.frx":0006
TabIndex = 5
Top = 1200
Width = 3015
End
Begin VB.CommandButton Command1
BackColor = &H00808080&
Caption = "Quit"
BeginProperty Font
Name = "MS Sans Serif"
Size = 13.5
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7320
Style = 1 'Graphical
TabIndex = 2
Top = 7680
Width = 2175
End
Begin VB.ListBox List2
Appearance = 0 'Flat
BackColor = &H0080C0FF&
Height = 6270
ItemData = "FrmPrintRestBill.frx":0008
Left = 1560
List = "FrmPrintRestBill.frx":000A
TabIndex = 1
Top = 1200
Width = 1935
End
Begin VB.ListBox List1
Appearance = 0 'Flat
BackColor = &H0080C0FF&
Height = 6270
ItemData = "FrmPrintRestBill.frx":000C
Left = 240
List = "FrmPrintRestBill.frx":000E
TabIndex = 0
Top = 1200
Width = 1335
End
Begin VB.Line Line3
X1 = 6480
X2 = 6480
Y1 = 1200
Y2 = 840
End
Begin VB.Line Line2
X1 = 3480
X2 = 3480
Y1 = 1200
Y2 = 840
End
Begin VB.Line Line1
X1 = 1560
X2 = 1560
Y1 = 1200
Y2 = 840
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "Room Status"
BeginProperty Font
Name = "Times New Roman"
Size = 21.75
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 615
Left = 240
TabIndex = 4
Top = 120
Width = 3975
End
Begin VB.Label Label1
Appearance = 0 'Flat
BackColor = &H80000005&
BackStyle = 0 'Transparent
BorderStyle = 1 'Fixed Single
Caption = " Room No. Room Status Type of Room Feautres"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 240
TabIndex = 3
Top = 840
Width = 9255
End
End
Attribute VB_Name = "FrmRoomStatus"
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 Form_Load()
Me.Left = MDIForm1.Left + 1000
Me.Top = MDIForm1.Top + 1000
List1.Clear
List2.Clear
List3.Clear
List4.Clear
Set MyDb = DBEngine.Workspaces(0).OpenDatabase("D:\HOTEL\ROOMS\ROOMS.MDB")
Set MyRs = MyDb.OpenRecordset("ROOMS", dbOpenDynaset)
If MyRs.RecordCount <= 0 Then
Exit Sub
Else
Do While Not MyRs.EOF
List1.AddItem MyRs!ROOMNO
List2.AddItem MyRs!Status
List3.AddItem MyRs!TYPEOFROOM
List4.AddItem MyRs!FEATURS
MyRs.MoveNext
Loop
End If
MyDb.Close
End Sub
Private Sub List1_Click()
List2.ListIndex = List1.ListIndex
List3.ListIndex = List1.ListIndex
List4.ListIndex = List1.ListIndex
End Sub
Private Sub List2_Click()
List1.ListIndex = List2.ListIndex
End Sub
Private Sub Option1_Click()
If Option1.Value = True Then
List1.Clear
List2.Clear
List3.Clear
List4.Clear
SQL = "select * from ROOMS where STATUS='" & "EMPTY" & "'"
Set MyDb = DBEngine.Workspaces(0).OpenDatabase("D:\HOTEL\ROOMS\ROOMS.MDB")
Set MyRs = MyDb.OpenRecordset(SQL, dbOpenDynaset)
If MyRs.RecordCount <= 0 Then
Exit Sub
Else
Do While Not MyRs.EOF
List1.AddItem MyRs!ROOMNO
List2.AddItem MyRs!Status
List3.AddItem MyRs!TYPEOFROOM
List4.AddItem MyRs!FEATURS
MyRs.MoveNext
Loop
End If
MyDb.Close
Else
List1.Clear
List2.Clear
List3.Clear
List4.Clear
Form_Load
Exit Sub
End If
End Sub
Private Sub Option2_Click()
If Option2.Value = True Then
List1.Clear
List2.Clear
List3.Clear
List4.Clear
SQL = "select * from ROOMS where STATUS='" & "OCCUPIED" & "'"
Set MyDb = DBEngine.Workspaces(0).OpenDatabase("D:\HOTEL\ROOMS\ROOMS.MDB")
Set MyRs = MyDb.OpenRecordset(SQL, dbOpenDynaset)
If MyRs.RecordCount <= 0 Then
Exit Sub
Else
Do While Not MyRs.EOF
List1.AddItem MyRs!ROOMNO
List2.AddItem MyRs!Status
List3.AddItem MyRs!TYPEOFROOM
List4.AddItem MyRs!FEATURS
MyRs.MoveNext
Loop
End If
MyDb.Close
Else
List1.Clear
List2.Clear
List3.Clear
List4.Clear
Form_Load
Exit Sub
End If
End Sub
Private Sub Option3_Click()
If Option3.Value = True Then
Form_Load
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -