?? b考生考試管理.frm
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -