VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form B考生考試管理 
   Caption         =   "考生考試管理"
   ClientHeight    =   1470
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   5325
   LinkTopic       =   "Form1"
   ScaleHeight     =   1470
   ScaleWidth      =   5325
   StartUpPosition =   3  '窗口缺省
   Begin MSComctlLib.ListView ListView1 
      Height          =   1215
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   5055
      _ExtentX        =   8916
      _ExtentY        =   2143
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      _Version        =   393217
      Icons           =   "ImageList1"
      ForeColor       =   -2147483640
      BackColor       =   12648447
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   360
      Top             =   240
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   4
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "B考生考試管理.frx":0000
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "B考生考試管理.frx":08DC
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "B考生考試管理.frx":11B8
            Key             =   ""
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "B考生考試管理.frx":1A94
            Key             =   ""
         EndProperty
      EndProperty
   End
End
Attribute VB_Name = "B考生考試管理"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim times As Integer            '保存登陸考生考試次數
Private Sub Form_Load()
    '初始化用戶類型
    Dim list As ListItem
    Set list = ListView1.ListItems.Add(, , "成績查詢", 3)
    Set list = ListView1.ListItems.Add(, , "考生考試", 2)
    Set list = ListView1.ListItems.Add(, , "重新登錄", 1)
    Set list = ListView1.ListItems.Add(, , "密碼維護", 4)
    times = 0
End Sub
Private Sub ListView1_Click()
'連接到相應的界面
    Dim key As String                           '保存節點的文本
    key = Trim(ListView1.SelectedItem.Text)
    If key = "成績查詢" Then                    '如果選擇“成績查詢”
        B考生成績查詢.Show
        Me.Enabled = False
    ElseIf key = "考生考試" Then                '如果選擇“考生考試”
        Call Text                               '確認該考生是否可以參加該場考試
    ElseIf key = "重新登錄" Then                '如果選擇“重新登錄”
        Unload Me
        E重新登錄.Show
    ElseIf key = "密碼維護" Then                '如果選擇“密碼維護”
        E密碼維護.Show
        Me.Enabled = False
    End If
End Sub
Private Sub Text()
'確認該考生是否可以參加該場考試
    Dim SQL As String
    Dim msg As String
    Dim rs As ADODB.Recordset
    '判斷該考生是否可以參加考試
    SQL = "SELECT 考試標志,考試時間 FROM 考試信息表 WHERE (考試代碼 ="
    SQL = SQL & "(SELECT 考試代碼 FROM 成績信息表 WHERE 考生號 ='" & UserID & "'))"
    Set rs = SelectSQL(SQL, msg)
    If rs.EOF = False Then                          '如果存在該考生
        If rs.Fields("考試標志") = "考試啟動" Then  '如果該考生的考場被啟動
            times = times + 1
            If times = 1 Then                       '如果該考生是第一次登錄
                B考生考試.Show
                '得到該場考試總時間
                B考生考試.Label4.Caption = rs.Fields("考試時間") & " 分鐘"
                Me.Enabled = False
            Else
                MsgBox "對不起，你不可以再次登陸！"
            End If
        Else
            MsgBox "對不起，你不可以參加考試！"
        End If
    Else
        MsgBox "對不起，你不可以參加考試！"
    End If
End Sub