📄 客房.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.MDIForm MDIForm1
BackColor = &H8000000C&
Caption = "欢迎进入客房管理系统"
ClientHeight = 8565
ClientLeft = 165
ClientTop = 450
ClientWidth = 11190
Icon = "客房.frx":0000
LinkTopic = "MDIForm1"
Picture = "客房.frx":0442
StartUpPosition = 2 '屏幕中心
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 1095
Left = 0
TabIndex = 1
Top = 0
Width = 11190
_ExtentX = 19738
_ExtentY = 1931
ButtonWidth = 1799
ButtonHeight = 1773
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 6
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "客房信息"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "入住情况"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "退房记录"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "信息查询"
ImageIndex = 4
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "报表打印"
ImageIndex = 5
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "退出"
ImageIndex = 6
EndProperty
EndProperty
End
Begin MSComctlLib.ImageList ImageList1
Left = 2520
Top = 3600
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 61
ImageHeight = 61
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 6
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":29A83
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":2A2B5
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":2AAE7
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":2B319
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":2B633
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "客房.frx":2B94D
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 345
Left = 0
TabIndex = 0
Top = 8220
Width = 11190
_ExtentX = 19738
_ExtentY = 609
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 2
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 5
Alignment = 1
TextSave = "21:12"
EndProperty
BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 6
Alignment = 1
TextSave = "2007-12-28"
EndProperty
EndProperty
End
Begin VB.Menu mnusystem
Caption = "系统功能"
Begin VB.Menu mnuuser
Caption = "用户管理"
Enabled = 0 'False
End
Begin VB.Menu tc
Caption = "退出系统"
End
End
Begin VB.Menu mnuinfo
Caption = "基本信息管理"
Begin VB.Menu mnuroominfo
Caption = "客房信息"
End
Begin VB.Menu mnuguest
Caption = "入住情况"
Enabled = 0 'False
End
Begin VB.Menu mnuquit
Caption = "退房记录"
Enabled = 0 'False
End
End
Begin VB.Menu mnuqueryselect
Caption = "信息查询"
End
Begin VB.Menu mnureport
Caption = "报表输出"
Enabled = 0 'False
Begin VB.Menu mnureportroom
Caption = "房间情况表"
End
Begin VB.Menu mnureportmoney
Caption = "收费情况表"
End
End
Begin VB.Menu CK
Caption = "窗口"
Begin VB.Menu CD
Caption = "层叠"
End
Begin VB.Menu SPPP
Caption = "水平平铺"
End
Begin VB.Menu SZPP
Caption = "竖直平铺"
End
Begin VB.Menu CTPL
Caption = "窗体排列"
End
End
End
Attribute VB_Name = "MDIForm1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CD_Click()
MDIForm1.Arrange 3
End Sub
Private Sub CTPL_Click()
MDIForm1.Arrange 0
End Sub
Private Sub MDIForm_Load()
MDIForm1.Height = 9255
MDIForm1.Width = 11310
End Sub
Private Sub mnuguest_Click()
Form6.Show
End Sub
Private Sub mnuqueryselect_Click()
Form5.Show
End Sub
Private Sub mnuquit_Click()
Form3.Show
End Sub
Private Sub mnureportmoney_Click()
Dim rs3 As ADODB.Recordset
Set rs3 = New ADODB.Recordset
Call lj
rs3.Open "select * from 旅客退房记录表", conn
Set DataReport2.DataSource = rs3
DataReport2.Sections("section1").Controls("Text1").DataField = rs3.Fields(0).Name
DataReport2.Sections("section1").Controls("Text2").DataField = rs3.Fields(1).Name
DataReport2.Sections("section1").Controls("Text3").DataField = rs3.Fields(2).Name
DataReport2.Show
End Sub
Private Sub mnureportroom_Click()
Dim rs3 As ADODB.Recordset
Set rs3 = New ADODB.Recordset
Call lj
rs3.Open "select * from 客房信息表", conn
Set DataReport1.DataSource = rs3
DataReport1.Sections("section1").Controls("Text1").DataField = rs3.Fields(0).Name
DataReport1.Sections("section1").Controls("Text2").DataField = rs3.Fields(1).Name
DataReport1.Sections("section1").Controls("Text3").DataField = rs3.Fields(2).Name
DataReport1.Sections("section1").Controls("Text4").DataField = rs3.Fields(3).Name
DataReport1.Sections("section1").Controls("Text5").DataField = rs3.Fields(4).Name
DataReport1.Show
End Sub
Private Sub mnuroominfo_Click()
Form2.Show
End Sub
Private Sub mnuuser_Click()
Form1.Show
End Sub
Private Sub SPPP_Click()
MDIForm1.Arrange 2
End Sub
Private Sub StatusBar1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)
'StatusBar1.Panels(3).Text = x & "," & y
End Sub
Private Sub SZPP_Click()
MDIForm1.Arrange 1
End Sub
Private Sub tc_Click()
If MsgBox("确认退出系统", vbYesNo, "警告") = vbYes Then
End
End If
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
Case 1
Form2.Show
Case 2
Form4.Show
Case 3
Form3.Show
Case 4
Form5.Show
Case 5
mnureportroom_Click
Case 6
tc_Click
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -