📄 form1.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form Frm_main
Caption = "Form1"
ClientHeight = 7005
ClientLeft = 165
ClientTop = 810
ClientWidth = 8760
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
ScaleHeight = 7005
ScaleWidth = 8760
StartUpPosition = 3 '窗口缺省
Begin VB.Frame Frame1
Height = 30
Left = 0
TabIndex = 0
Top = 840
Width = 18285
End
Begin VB.Timer Timer1
Interval = 1000
Left = 8400
Top = 6480
End
Begin MSComctlLib.ImageList ImageList1
Left = 8160
Top = 2520
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 45
ImageHeight = 45
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 8
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":0000
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":0AA8
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":1508
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":1F91
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":29B9
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":3283
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":3E1B
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Form1.frx":474D
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 795
Left = 0
TabIndex = 1
Top = 0
Width = 8760
_ExtentX = 15452
_ExtentY = 1402
ButtonWidth = 1376
ButtonHeight = 1349
Appearance = 1
Style = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 6
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 4
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 5
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
ImageIndex = 8
EndProperty
EndProperty
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 375
Left = 0
TabIndex = 2
Top = 6630
Width = 8760
_ExtentX = 15452
_ExtentY = 661
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 4
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 3295
MinWidth = 1919
Text = "欢迎使用公寓管理系统"
TextSave = "欢迎使用公寓管理系统"
EndProperty
BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 2942
MinWidth = 1566
EndProperty
BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 2942
MinWidth = 1566
EndProperty
BeginProperty Panel4 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 5680
MinWidth = 4304
Picture = "Form1.frx":5119
EndProperty
EndProperty
End
Begin VB.Image Image1
Appearance = 0 'Flat
Height = 5445
Left = 120
Picture = "Form1.frx":586B
Stretch = -1 'True
Top = 840
Width = 8280
End
Begin VB.Image Image2
Height = 165
Left = 435
Picture = "Form1.frx":58572
Top = 2160
Visible = 0 'False
Width = 150
End
Begin VB.Menu xtsz
Caption = "系统设置(&D)"
Begin VB.Menu io
Caption = "-"
End
Begin VB.Menu yhhmm
Caption = "用户和密码(&D)"
End
Begin VB.Menu a1
Caption = "-"
End
Begin VB.Menu tc
Caption = "退出(&T)"
End
End
Begin VB.Menu zsgl
Caption = "住宿管理(&G)"
Begin VB.Menu k
Caption = "-"
End
Begin VB.Menu ssrygl
Caption = "宿舍人员管理(&R)"
Begin VB.Menu g
Caption = "-"
End
Begin VB.Menu zsrycx
Caption = "住宿人员查询"
End
Begin VB.Menu f
Caption = "-"
End
Begin VB.Menu kfjcx
Caption = "空房间查询"
End
Begin VB.Menu a9
Caption = "-"
End
Begin VB.Menu zsdj
Caption = "住宿登记(&J)"
End
Begin VB.Menu a8
Caption = "-"
End
Begin VB.Menu tfdj
Caption = "退房登记(I)"
End
End
Begin VB.Menu a2
Caption = "-"
End
Begin VB.Menu shwsgl
Caption = "生活卫生管理(&W)"
Begin VB.Menu o
Caption = "-"
End
Begin VB.Menu zj
Caption = "早检(Z)"
End
Begin VB.Menu a6
Caption = "-"
End
Begin VB.Menu wj
Caption = "晚检(V)"
End
End
Begin VB.Menu a3
Caption = "-"
End
Begin VB.Menu wxgl
Caption = "维修管理(&X)"
Begin VB.Menu dwxwp
Caption = "待维修物品(P)"
End
End
Begin VB.Menu a4
Caption = "-"
End
Begin VB.Menu cwgl
Caption = "财务管理(&C)"
Begin VB.Menu dfcx
Caption = "电费查询(&F)"
End
Begin VB.Menu a7
Caption = "-"
End
Begin VB.Menu sfcx
Caption = "水费查询(&M)"
End
End
End
Begin VB.Menu xsgl
Caption = "学生管理(&U)"
Begin VB.Menu h
Caption = "-"
End
Begin VB.Menu xsxxgl
Caption = "学生信息管理(&K)"
End
End
Begin VB.Menu bz
Caption = "帮助"
Begin VB.Menu r
Caption = "-"
End
Begin VB.Menu xtsm
Caption = "系统说明"
End
Begin VB.Menu a5
Caption = "-"
End
Begin VB.Menu cjwt
Caption = "常见问题"
End
End
End
Attribute VB_Name = "Frm_main"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim sql As String
Private Sub ssgl_Click()
End Sub
Private Sub ssrycx_Click()
End Sub
Private Sub xsxxcx_Click()
sql = "select * from 宿舍"
ShowData sql, Frm_xscx.MSFlexGrid1
Unload Me
Frm_xscx.Show 1
End Sub
Private Sub Command1_Click()
End Sub
Private Sub dwxwp_Click()
frm_wx.Show 1
End Sub
Private Sub Form_Load()
Me.Caption = "学生公寓管理系统"
Me.BackColor = RGB(255, 222, 89)
''Image1.Stretch = True
End Sub
Private Sub Form_Resize()
Image1.Left = 50
Image1.Top = Toolbar1.Height + 50
Image1.Width = ScaleWidth - 150
If ScaleHeight - Toolbar1.Height - StatusBar1.Height > 0 Then
Image1.Height = ScaleHeight - Toolbar1.Height - StatusBar1.Height - 150
End If
End Sub
Private Sub kfjcx_Click()
Frm_find.Caption = "空房间查询"
If Me.Caption = "添加记录" Then
strfind = "first"
End If
Dim sql As String
sql = "select 寝室编号 ,count(*) as 实际入住人数 from 宿舍 group by 寝室编号 having count(*)<6"
Frm_find.MSFlexGrid1.ColWidth(0) = 1000
Frm_find.MSFlexGrid1.ColWidth(1) = 1500
ShowData sql, Frm_find.MSFlexGrid1
Frm_find.Show 1
End Sub
Private Sub tfdj_Click()
Frm_tfdj.Caption = "退房登记"
Frm_tfdj.Show 1
End Sub
Private Sub Timer1_Timer()
StatusBar1.Panels(4).Text = Now
End Sub
Private Sub wj_Click()
frm_wj.Show 1
End Sub
Private Sub xsxxgl_Click()
Frm_xscx.Show 1
End Sub
Private Sub zj_Click()
frm_zj.Show 1
End Sub
Private Sub zsdj_Click()
Frm_xsgx.Caption = "住宿登记"
Frm_xsgx.Show 1
End Sub
Private Sub zsrycx_Click()
Frm_xscz.Show 1
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -