mdiform1.frm

学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统学生管理系统 加点啊

Private Sub cjfind_Click()
qxstr = Executeqx(4)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
End Sub

Private Sub claasfind_Click()
qxstr = Executeqx(2)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
 Form4.Show
  Form4.ZOrder (0)
  i = SetWindowPos(Form4.hwnd, -1, 0, 0, 0, 0, 3)
End Sub

Private Sub classapp_Click()
qxstr = Executeqx(2)
If qxstr = "false" Or qxstr = "readonly" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
Formclass1.Show
  classmodi = False
  Formclass1.classload
  Formclass1.ZOrder (0)
End Sub

Public Sub clabrowse()
txtsql = "select * from class"
Formclass2.ZOrder (0)
Formclass2.Caption = "浏览班级设置"
Formclass2.classshowtitle
Formclass2.classshowdata


End Sub

Private Sub classbrowse_Click()
qxstr = Executeqx(2)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
Formclass2.Show
End Sub

Private Sub classfind_Click()
qxstr = Executeqx(2)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
 Formclass3.Show
 Formclass3.ZOrder (0)
End Sub

Private Sub find_Click()
 
End Sub



Private Sub classkecheng_Click()
qxstr = Executeqx(4)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
Frmclasskecheng1.Show
Frmclasskecheng1.ZOrder
End Sub




Private Sub denglu2_Click()
Frmdenlu.Show
Unload Me
End Sub

Private Sub jiaofeiadd_Click()
qxstr = Executeqx(3)
If qxstr = "false" Or qxstr = "readonly" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
Frmjf1.Show
Frmjf1.ZOrder 0
End Sub

Private Sub jiaofeibrowse_Click()
qxstr = Executeqx(3)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
frmjf2.Show
frmjf2.ZOrder 0
End Sub

Private Sub jiaofeifind_Click()
qxstr = Executeqx(3)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
End Sub

Private Sub guanyu_Click()
about.Show

End Sub

Private Sub jibenkecheng_Click()
qxstr = Executeqx(4)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
frmjiben.Show
frmjiben.ZOrder 0
End Sub



Private Sub leixing_Click()
qxstr = Executeqx(4)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
Frmleixing.Show
Frmleixing.ZOrder 0
End Sub

Private Sub liulan_Click()
qxstr = Executeqx(2)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
  find = False
  Form3.Show
End Sub

Private Sub MDIForm_Load()
'username = "0001"
DataEnv1.Connection1.ConnectionString = connstring
StatusBar1.Panels(2).Text = Now
StatusBar1.Panels(3).Text = "当前操作员：    " & username
Dim aa As String
Select Case Executeqx(1)
Case "admin"
  aa = "超级管理员"
Case "readonly"
  aa = "只读管理员"
Case Else
  aa = "普通管理员"
End Select
StatusBar1.Panels(4).Text = "状态：   " & aa
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Tag
    Case "tjyh"
     frmuser1.Show
     Case "tjbj"
     Formclass1.Show
     Case "bjcx"
     Formclass3.Show
     Case "rxdj"
     Form1.Show
     Case "dacx"
     Form4.Show
        End Select
    
End Sub

Private Sub Toolbar1_ButtonMenuClick(ByVal ButtonMenu As MSComctlLib.ButtonMenu)
  Select Case ButtonMenu.Key
  Case "dang"
  If Trim(printstr) = "" Then
    sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
    Exit Sub
  End If
    If DataEnv1.rsCommand1.State = adStateOpen Then
     DataEnv1.rsCommand1.Close
    End If
     DataEnv1.rsCommand1.Open printstr
     If DataEnv1.rsCommand1.EOF = True Then
            sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
      Exit Sub
    End If
    DataReportclass.Show 1
   Case "all"
     If DataEnv1.rsCommand1.State = adStateOpen Then
     DataEnv1.rsCommand1.Close
    End If
     DataEnv1.rsCommand1.Open ("select xj.学号,xj.姓名,xj.性别,xj.班级,xj.出生年月,xj.家庭住址,xj.邮政编码,xj.联系电话,xj.入学时间,xj.备注,class.专业 from xj inner join class on xj.班级=class.班级")
     If DataEnv1.rsCommand1.EOF = True Then
            sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
      Exit Sub
    End If
    DataReportclass.Show 1
  End Select
End Sub

Private Sub useradd_Click()
qxstr = Executeqx(1)
If qxstr = "false" Or qxstr = "readonly" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
frmuser1.Show
frmuser1.ZOrder 0
End Sub

Private Sub usermodi_Click()
qxstr = Executeqx(1)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
End Sub

Private Sub xuefeiadd_Click()
qxstr = Executeqx(3)
If qxstr = "false" Or qxstr = "readonly" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
 xuefeimodi = False
 Dim i As Integer
  For i = 0 To 3
 frmxuefei1.Combo1(i).Enabled = True
  Next i
  Me.Caption = "添加班级设置"
 For i = 0 To 3
  frmxuefei1.Combo1(i).Text = ""
  Next i
    frmxuefei1.Text1.Text = ""
  frmxuefei1.Show
  frmxuefei1.ZOrder 0
End Sub

Public Sub xfbrowse()
txtsql = "select * from xuefei order by 学期 desc, 年级 desc,专业 desc"
Frmxuefei2.ZOrder (0)
Frmxuefei2.Caption = "浏览学费设置"
Frmxuefei2.xuefeishowtitle
Frmxuefei2.xuefeishowdata
End Sub

Private Sub xuefeibrowse_Click()
qxstr = Executeqx(3)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
  Frmxuefei2.Show
End Sub

Private Sub xuefeifind_Click()
qxstr = Executeqx(3)
If qxstr = "false" Then
   ss = MsgBox("对不起，你没有管理本功能的权限，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
 Exit Sub
End If
 Frmxuefei3.Show
   Frmxuefei3.ZOrder (0)
    i = SetWindowPos(Frmxuefei3.hwnd, -1, 0, 0, 0, 0, 3)
End Sub