b考生考试管理.frm

在线考试系统。用vb编写

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