mdiform1.frm

教务辅助管理系统利用VB开发的数据库管理系统,里面分学生,教师,教务等等各方面的需求满足学校的教务管理的简单需求!

VERSION 5.00
Begin VB.MDIForm MDIForm1 
   BackColor       =   &H00FF8080&
   Caption         =   "教务辅助管理系统"
   ClientHeight    =   6525
   ClientLeft      =   60
   ClientTop       =   765
   ClientWidth     =   12015
   LinkTopic       =   "MDIForm1"
   StartUpPosition =   2  'CenterScreen
   WindowState     =   2  'Maximized
   Begin VB.Menu system 
      Caption         =   "系统管理"
      Begin VB.Menu addUser 
         Caption         =   "添加用户信息"
      End
      Begin VB.Menu selectUser 
         Caption         =   "查询用户信息"
      End
      Begin VB.Menu deleteUser 
         Caption         =   "删除用户信息"
      End
      Begin VB.Menu aa 
         Caption         =   "-"
      End
      Begin VB.Menu menuExit 
         Caption         =   "退出系统"
      End
   End
   Begin VB.Menu Teacher 
      Caption         =   "教师信息管理"
      Begin VB.Menu addteacher 
         Caption         =   "添加教师"
      End
      Begin VB.Menu deletelteacher 
         Caption         =   "删除教师"
      End
      Begin VB.Menu seletteacher 
         Caption         =   "查询教师信息"
      End
   End
   Begin VB.Menu Classroon 
      Caption         =   "教室信息管理"
      Begin VB.Menu addclassroom 
         Caption         =   "添加教室"
      End
      Begin VB.Menu deletelclassroom 
         Caption         =   "删除教室"
      End
      Begin VB.Menu selectclassroom 
         Caption         =   "查询教师信息"
      End
   End
   Begin VB.Menu course 
      Caption         =   "课程信息管理"
      Begin VB.Menu addcourse 
         Caption         =   "添加课程"
      End
      Begin VB.Menu deletecourse 
         Caption         =   "删除课程"
      End
      Begin VB.Menu selectcourse 
         Caption         =   "课程查询"
      End
   End
   Begin VB.Menu class 
      Caption         =   "班级信息管理"
      Begin VB.Menu addclass 
         Caption         =   "添加班级"
      End
      Begin VB.Menu deleteclass 
         Caption         =   "删除班级"
      End
      Begin VB.Menu selectclass 
         Caption         =   "班级信息查询"
      End
   End
   Begin VB.Menu special 
      Caption         =   "专业教学计划"
      Begin VB.Menu addspecial 
         Caption         =   "专业教学计划信息管理"
      End
   End
   Begin VB.Menu paikea 
      Caption         =   "排课"
      Begin VB.Menu menpaike 
         Caption         =   "自动排课"
      End
   End
   Begin VB.Menu shujubeifen 
      Caption         =   " 数据备份"
      Begin VB.Menu menbeifen 
         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 addspecial_Click()
  frmspecial.Show
  
End Sub



'备份
Private Sub menbeifen_Click()
  frmbeifen.Show
End Sub

'排课
Private Sub menpaike_Click()
frmPaiKe.Show
End Sub

'查询班级信息
Private Sub selectclass_Click()
frmclass.Command1.Enabled = False
 frmclass.Command2.Enabled = False
 frmclass.Command3.Enabled = True
  frmclass.Text1.Enabled = False
  frmclass.Text2.Enabled = False
 frmclass.Text1.BackColor = &HC0C0C0
 frmclass.Text2.BackColor = &HC0C0C0
 
 
  frmclass.Show
End Sub

'删除班级
Private Sub deleteclass_Click()
 frmclass.Command1.Enabled = False
 frmclass.Command2.Enabled = True
frmclass.Command3.Enabled = False
frmclass.Text1.Enabled = True
frmclass.Text1.BackColor = &HFFFFFF
frmclass.Text2.Enabled = False
frmclass.Text2.BackColor = &HC0C0C0
  frmclass.Show
End Sub

'添加班级
Private Sub addclass_Click()
    frmclass.Command1.Enabled = True
    frmclass.Command2.Enabled = False
    frmclass.Command3.Enabled = False
    frmclass.Text1.Enabled = True
  frmclass.Text1.BackColor = &HFFFFFF
    frmclass.Text2.Enabled = True
  frmclass.Text2.BackColor = &HFFFFFF
  frmclass.Show
  
End Sub

'添加课程信息
Private Sub addcourse_Click()
  frmcourse.Command1.Enabled = True
  frmcourse.Command2.Enabled = False
  frmcourse.Command3.Enabled = False
  frmcourse.Text1.Enabled = True
   frmcourse.Text1.BackColor = &HFFFFFF
  frmcourse.Text2.Enabled = True
   frmcourse.Text2.BackColor = &HFFFFFF
  frmcourse.Show
End Sub
'删除课程信息
Private Sub deletecourse_Click()
  frmcourse.Command1.Enabled = False
  frmcourse.Command2.Enabled = True
  frmcourse.Command3.Enabled = False
  
  frmcourse.Text1.Enabled = True
   frmcourse.Text1.BackColor = &HFFFFFF
  frmcourse.Text2.Enabled = False
   frmcourse.Text2.BackColor = &HC0C0C0
  frmcourse.Show
End Sub
'查询课程信息
Private Sub selectcourse_Click()
    frmcourse.Command1.Enabled = False
  frmcourse.Command2.Enabled = False
  frmcourse.Command3.Enabled = True
  frmcourse.Text1.Enabled = False
   frmcourse.Text1.BackColor = &HC0C0C0
   frmcourse.Text2.Enabled = False
   frmcourse.Text2.BackColor = &HC0C0C0
  frmcourse.Show
End Sub

'添加用户，只有管理员可此操作
Private Sub addUser_Click()
user.Command1.Enabled = True
user.Command2.Enabled = False
user.Command3.Enabled = False
 user.Text1.Enabled = True
  user.Text2.Enabled = True

user.Show

End Sub



'删除用户，只有管理员可此操作
Private Sub deleteUser_Click()
user.Command1.Enabled = False
user.Command2.Enabled = True
user.Command3.Enabled = False
 user.Text1.Enabled = True

user.Show

End Sub






'用户查询，只有管理员可此操作
Private Sub selectUser_Click()
 user.Command1.Enabled = False
 user.Command2.Enabled = False
 user.Command3.Enabled = True
  user.Text1.Enabled = False
 user.Text2.Enabled = False
 user.Option1.Enabled = False

 user.Show

End Sub
'退出系统
Private Sub menuExit_Click()
 
End
End Sub
'删除教师信息
Private Sub deletelteacher_Click()
   frmteacher.Command1.Enabled = False
   frmteacher.Command2.Enabled = True
  frmteacher.Command3.Enabled = False
  frmteacher.Text1.Enabled = True
  frmteacher.Text1.BackColor = &HFFFFFF
  frmteacher.Text2.Enabled = False
  frmteacher.Text2.BackColor = &HC0C0C0
  frmteacher.Combo1.Enabled = False

 frmteacher.Show

End Sub
'添加教师信息
Private Sub addteacher_Click()
frmteacher.Command1.Enabled = True
 frmteacher.Command2.Enabled = False
 frmteacher.Command3.Enabled = False
 frmteacher.Text1.Enabled = True
  frmteacher.Text1.BackColor = &HFFFFFF
  frmteacher.Text2.Enabled = True
  frmteacher.Text2.BackColor = &HFFFFFF
  frmteacher.Combo1.Enabled = True
frmteacher.Show

End Sub

'查询教师信息
Private Sub seletteacher_Click()
  frmteacher.Command1.Enabled = False
  frmteacher.Command2.Enabled = False
  frmteacher.Command3.Enabled = True
  frmteacher.Text1.Enabled = False
  frmteacher.Text1.BackColor = &HC0C0C0
  frmteacher.Text2.Enabled = False
  frmteacher.Text2.BackColor = &HC0C0C0
  frmteacher.Combo1.Enabled = False

 frmteacher.Show

End Sub

'添加教室
Private Sub addclassroom_Click()
room.Command1.Enabled = True
  room.Command2.Enabled = False
   room.Command3.Enabled = False
   
    room.Text1.Enabled = True
   room.Text1.BackColor = &HFFFFFF
   room.Text2.Enabled = True
   room.Text2.BackColor = &HFFFFFF
   room.Show
End Sub
'删除教室
Private Sub deletelclassroom_Click()
  room.Command1.Enabled = False
  room.Command2.Enabled = True
   room.Command3.Enabled = False
   room.Text1.Enabled = True
   room.Text1.BackColor = &HFFFFFF
   room.Text2.Enabled = False
   room.Text2.BackColor = &HC0C0C0
   room.Show
End Sub
'教室信息查询
Private Sub selectclassroom_Click()
  room.Command1.Enabled = False
   room.Command2.Enabled = False
   room.Command3.Enabled = True
   
   room.Text1.Enabled = False
   room.Text1.BackColor = &HC0C0C0
   room.Text2.Enabled = False
   room.Text2.BackColor = &HC0C0C0
   room.Show
End Sub