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