📄 frmmain.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm FrmMain
BackColor = &H8000000C&
Caption = "班级信息管理系统"
ClientHeight = 6840
ClientLeft = 165
ClientTop = 855
ClientWidth = 11205
Icon = "FrmMain.frx":0000
LinkTopic = "MDIForm1"
StartUpPosition = 3 '窗口缺省
WindowState = 2 'Maximized
Begin MSComctlLib.ImageList ImageList1
Left = 6900
Top = 1500
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 32
ImageHeight = 32
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 5
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmMain.frx":06EA
Key = "imgClass"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmMain.frx":0C84
Key = "imgStudent"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmMain.frx":121E
Key = "imgGeneral"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmMain.frx":17B8
Key = "imgQuery"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmMain.frx":1D52
Key = "imgExit"
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 855
Left = 0
TabIndex = 0
Top = 0
Width = 11205
_ExtentX = 19764
_ExtentY = 1508
ButtonWidth = 1455
ButtonHeight = 1349
AllowCustomize = 0 'False
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 5
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "班级设置"
Key = "Class"
ImageKey = "imgClass"
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "学生管理"
Key = "Student"
ImageKey = "imgStudent"
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "综合管理"
Key = "General"
ImageKey = "imgGeneral"
Style = 5
BeginProperty ButtonMenus {66833FEC-8583-11D1-B16A-00C0F0283628}
NumButtonMenus = 5
BeginProperty ButtonMenu1 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Prize"
Text = "学生奖励管理"
EndProperty
BeginProperty ButtonMenu2 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Punish"
Text = "学生惩罚管理"
EndProperty
BeginProperty ButtonMenu3 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Grade"
Text = "学生考级管理"
EndProperty
BeginProperty ButtonMenu4 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Score"
Text = "学生测评管理"
EndProperty
BeginProperty ButtonMenu5 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "Archives"
Text = "班级档案管理"
EndProperty
EndProperty
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "综合查询"
Key = "Query"
ImageKey = "imgQuery"
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出系统"
Key = "Exit"
ImageKey = "imgExit"
EndProperty
EndProperty
OLEDropMode = 1
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 360
Left = 0
TabIndex = 1
Top = 6480
Width = 11205
_ExtentX = 19764
_ExtentY = 635
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 7
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Object.Width = 7056
MinWidth = 7056
Text = "常州信息职业技术学院计算机系 版权所有"
TextSave = "常州信息职业技术学院计算机系 版权所有"
Key = "project"
EndProperty
BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Object.Width = 4410
MinWidth = 4410
Text = "登录用户：系统管理员"
TextSave = "登录用户：系统管理员"
Key = "user"
EndProperty
BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 1
Alignment = 1
Enabled = 0 'False
Object.Width = 1411
MinWidth = 1411
TextSave = "CAPS"
EndProperty
BeginProperty Panel4 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 2
Alignment = 1
Enabled = 0 'False
Object.Width = 1411
MinWidth = 1411
TextSave = "NUM"
EndProperty
BeginProperty Panel5 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 3
Alignment = 1
Enabled = 0 'False
Object.Width = 1411
MinWidth = 1411
TextSave = "Ins"
EndProperty
BeginProperty Panel6 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 4
Alignment = 1
Enabled = 0 'False
Object.Width = 1411
MinWidth = 1411
TextSave = "SCRL"
EndProperty
BeginProperty Panel7 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Style = 6
AutoSize = 1
Object.Width = 2646
MinWidth = 2646
Text = "2006-10-12"
TextSave = "2007-12-14"
EndProperty
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.Menu mnu1
Caption = "基本信息"
Begin VB.Menu mnu1_1
Caption = "班级设置"
End
Begin VB.Menu mnu1_2
Caption = "学生管理"
End
End
Begin VB.Menu mnu2
Caption = "综合管理"
Begin VB.Menu mnu2_1
Caption = "学生奖励管理"
End
Begin VB.Menu mnu2_2
Caption = "学生惩罚管理"
End
Begin VB.Menu mnu2_3
Caption = "学生考级管理"
End
Begin VB.Menu mnu2_4
Caption = "学生测评管理"
End
Begin VB.Menu mnu2_5
Caption = "班级档案管理"
End
End
Begin VB.Menu mnu3
Caption = "综合查询"
End
Begin VB.Menu mnu4
Caption = "用户管理"
Begin VB.Menu mnu4_1
Caption = "用户设置"
End
Begin VB.Menu mnu4_2
Caption = "更改密码"
End
End
Begin VB.Menu mnu5
Caption = "退出系统"
End
End
Attribute VB_Name = "FrmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
'初始化窗体上状态条
Private Sub MDIForm_Load()
StatusBar1.Panels("user").Text = "登录用户：" & CurLoginUserName
End Sub
'关闭与数据库的连接，结束程序
Private Sub MDIForm_Unload(Cancel As Integer)
If Conn.State = adStateOpen Then Conn.Close
Set Conn = Nothing
Set FrmMain = Nothing
End
End Sub
'弹出对话框，让用户确认是否真正需要退出程序
Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer)
If MsgBox("确实要退出“班级信息管理系统”吗？", _
vbQuestion + vbYesNo, "操作提示") = vbNo Then
Cancel = True '取消用户事件（不退出）
End If
End Sub
'点击"退出系统"菜单
Private Sub mnu5_Click()
Unload Me
End Sub
'点击"班级设置"菜单
Private Sub mnu1_1_Click()
On Error GoTo ErrorHandle
FrmClass.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"学生管理"菜单
Private Sub mnu1_2_Click()
On Error GoTo ErrorHandle
FrmStudent.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"学生奖励管理"菜单
Private Sub mnu2_1_Click()
On Error GoTo ErrorHandle
FrmPrize.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"学生惩罚管理"菜单
Private Sub mnu2_2_Click()
On Error GoTo ErrorHandle
FrmPunish.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"学生考级管理"菜单
Private Sub mnu2_3_Click()
On Error GoTo ErrorHandle
FrmGrade.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"学生测评管理"菜单
Private Sub mnu2_4_Click()
On Error GoTo ErrorHandle
FrmScore.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"班级档案管理"菜单
Private Sub mnu2_5_Click()
On Error GoTo ErrorHandle
FrmArchives.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"综合查询"菜单
Private Sub mnu3_Click()
On Error GoTo ErrorHandle
FrmQuery.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"用户管理"菜单
Private Sub mnu4_1_Click()
On Error GoTo ErrorHandle
'非默认的Admin用户不能执行用户的增、删、改操作
If UCase(CurLoginUserNo) <> UCase("Admin") Then
MsgBox "您无权执行该项操作", vbExclamation + vbOKOnly, "操作提示"
Exit Sub
End If
FrmUser.Show
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'点击"更改密码"菜单
Private Sub mnu4_2_Click()
On Error GoTo ErrorHandle
FrmPwdEdit.Show 1
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'根据按钮的关键字，调用相同功能的菜单项点击事件过程
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
On Error GoTo ErrorHandle
Select Case Button.Key
Case "Class"
Call mnu1_1_Click '调用"班级设置"菜单事件过程
Case "Student"
Call mnu1_2_Click '调用"学生管理"菜单事件过程
Case "General"
Call mnu2_1_Click '调用"综合管理"中第1个按钮菜单事件过程
Case "Query"
Call mnu3_Click '调用"综合查询"菜单事件过程
Case "Exit"
Call mnu5_Click '调用"退出系统"菜单事件过程
End Select
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
'根据按钮菜单的关键字，调用相同功能的菜单项点击事件过程
Private Sub Toolbar1_ButtonMenuClick(ByVal ButtonMenu As MSComctlLib.ButtonMenu)
On Error GoTo ErrorHandle
Select Case ButtonMenu.Key
Case "Prize"
Call mnu2_1_Click '调用"学生奖励管理"菜单事件过程
Case "Punish"
Call mnu2_2_Click '调用"学生惩罚管理"菜单事件过程
Case "Grade"
Call mnu2_3_Click '调用"学生考级管理"菜单事件过程
Case "Score"
Call mnu2_4_Click '调用"学生测评管理"菜单事件过程
Case "Archives"
Call mnu2_5_Click '调用"班级档案管理"菜单事件过程
End Select
On Error GoTo 0
Exit Sub
ErrorHandle:
MsgBox Error(Err.Number), vbExclamation + vbOKOnly, "操作提示"
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -