frmmain.frm

毕业前的一点小程序

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form FrmMain 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "教务管理系统"
   ClientHeight    =   8325
   ClientLeft      =   -2820
   ClientTop       =   720
   ClientWidth     =   11895
   Icon            =   "FrmMain.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   Picture         =   "FrmMain.frx":0CCA
   ScaleHeight     =   8325
   ScaleWidth      =   11895
   StartUpPosition =   2  '屏幕中心
   Begin VB.Timer Timer1 
      Enabled         =   0   'False
      Interval        =   5000
      Left            =   3720
      Top             =   6480
   End
   Begin MSComctlLib.StatusBar StatusBar1 
      Align           =   2  'Align Bottom
      Height          =   495
      Left            =   0
      TabIndex        =   0
      Top             =   7830
      Width           =   11895
      _ExtentX        =   20981
      _ExtentY        =   873
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   1
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
         EndProperty
      EndProperty
   End
   Begin VB.Menu mn_1 
      Caption         =   "基本信息管理"
      Begin VB.Menu mn_class 
         Caption         =   "班级管理"
      End
      Begin VB.Menu mn_terms 
         Caption         =   "学期管理"
      End
      Begin VB.Menu mn_lesson 
         Caption         =   "课程管理"
      End
      Begin VB.Menu m_arrange 
         Caption         =   "排课管理"
      End
      Begin VB.Menu mn_exit 
         Caption         =   "退出系统"
      End
   End
   Begin VB.Menu mn_2 
      Caption         =   "学生成绩管理"
      Begin VB.Menu mn_query 
         Caption         =   "成绩查询"
      End
      Begin VB.Menu mn_score 
         Caption         =   "成绩管理"
      End
      Begin VB.Menu mn_sort 
         Caption         =   "成绩排名"
      End
   End
   Begin VB.Menu mn_stuManage 
      Caption         =   "学生学籍管理"
      Begin VB.Menu mn_stuInfo 
         Caption         =   "学生信息管理与维护"
      End
   End
   Begin VB.Menu mn_teacher 
      Caption         =   "教师教务管理"
      Begin VB.Menu mn_tFile 
         Caption         =   "教师档案管理"
      End
      Begin VB.Menu mn_tGlory 
         Caption         =   "教师获奖情况"
      End
      Begin VB.Menu mn_tTheme 
         Caption         =   "教师论文信息"
      End
   End
   Begin VB.Menu mn_Evaluate 
      Caption         =   "教师评估"
      Begin VB.Menu mn_TEresult 
         Caption         =   "教师评估成绩查询"
      End
   End
   Begin VB.Menu mn_3 
      Caption         =   "系统用户管理"
      Begin VB.Menu mn_user 
         Caption         =   "用户管理"
      End
      Begin VB.Menu mn_pwd 
         Caption         =   "修改密码"
      End
   End
End
Attribute VB_Name = "FrmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Form_Load()
  '连接字符串
  conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + App.Path + "\学生成绩.mdb; "
  
  With StatusBar1
  .Panels.Add (1)
  .Panels(1).Text = Now
  .Panels(1).Width = 3500
  .Panels.Add (2)
  .Panels(2).Text = "  欢迎使用本教务管理系统  "
  .Panels(2).Width = 3500
  .Panels.Add (3)
  .Panels(3).Width = 3500
  
  FrmLogin.Show 1
    
    If MyUser.UserRole = True Then
  .Panels(3).Text = "  当前用户为管理员"
  Else
  .Panels(3).Text = "  当前用户为普通用户"
  End If
  
  End With
  
    Timer1.Enabled = True
    
  If MyUser.UserRole = False Then
  '设置权限，根据权限设置菜单,不是管理员以下菜单不能用
  mn_class.Enabled = False
  mn_terms.Enabled = False
  mn_lesson.Enabled = False
  mn_score.Enabled = False
  mn_stuManage.Enabled = False
  mn_teacher.Enabled = False
  mn_user.Enabled = False
  m_arrange.Enabled = False
  mn_Evaluate.Enabled = False
  Else
  '不是学生，无法进行教师投票
  mn_query.Enabled = False
  '如果是普通管理员不能进行系统用户管理
  If Format(MyUser.UserName, "<") <> "admin" Then
    mn_user.Enabled = False
    FrmUserEdit.cboRole.Enabled = False
    FrmUserEdit.txtUserName.Enabled = False
  End If
  
  End If
End Sub

Private Sub lblUsers_Click()

End Sub

Private Sub mn_change_Click()
  FrmChangeMan.Show 1
End Sub

Private Sub Label1_Click()

End Sub

Private Sub m_arrange_Click()
  FrmArrangeMan.Show 1
End Sub

Private Sub mn_class_Click()
  FrmClassMan.Show 1
End Sub

Private Sub mn_eva_Click()
  FrmEvaMan.Show 1
End Sub

Private Sub mn_exit_Click()
  DBapi_Disconnect
  End
End Sub

Private Sub mn_lesson_Click()
  FrmLessonMan.Show 1
End Sub

Private Sub mn_pwd_Click()
FrmUserEdit.txtUserName.Enabled = False
FrmUserEdit.cboRole.Enabled = False
'如果当前用户是普通用户，则打开用户编辑窗体，编辑自己的用户信息
  With FrmUserEdit
  .OriUser = CurUser.UserName
  .txtUserName = CurUser.UserName
  .txtPass = CurUser.UserPwd
  .txtPass2 = CurUser.UserPwd
  .modify = True
  .Show 1
  End With
End Sub

Private Sub mn_query_Click()
frmScoreQuery.Show 1
End Sub

Private Sub mn_score_Click()
  FrmScoresMan.Show 1
End Sub

Private Sub mn_sort_Click()
  FrmScoresSort.Show 1
End Sub

Private Sub mn_student_Click()

End Sub

Private Sub mn_stuInfo_Click()
  FrmStuMan.Show
End Sub

Private Sub mn_TEresult_Click()
frmVoteResult.Show 1
End Sub

Private Sub mn_Terms_Click()
  FrmTermMan.Show 1
End Sub

Private Sub mn_tFile_Click()
frmTeacher.Show 1
End Sub

Private Sub mn_tGlory_Click()
frmAward.Show 1
End Sub

Private Sub mn_tTheme_Click()
frmTeacherPaper.Show 1
End Sub

Private Sub mn_user_Click()
  '如果当前用户为Admin，则打开用户管理窗体
  If Format(CurUser.UserName, "<") = "admin" Then
    FrmUserMan.Show 1
  Else
    MsgBox "没有权限"
  End If
End Sub

Private Sub Timer1_Timer()
StatusBar1.Panels(1).Text = Now
End Sub