📄 frmxsxxgl.frm
字号:
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 10
Left = 360
TabIndex = 33
Top = 435
Width = 1290
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "考 试 号："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 1
Left = 375
TabIndex = 32
Top = 885
Width = 1305
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "学号："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 240
Index = 3
Left = 3120
TabIndex = 31
Top = 840
Width = 780
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "姓 名："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 4
Left = 375
TabIndex = 30
Top = 1335
Width = 1320
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "性 别："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 5
Left = 360
TabIndex = 29
Top = 1785
Width = 1320
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "出生年月："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 6
Left = 360
TabIndex = 28
Top = 2235
Width = 1290
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "家长姓名："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 7
Left = 360
TabIndex = 27
Top = 3135
Width = 1290
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "联系电话："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 8
Left = 3240
TabIndex = 26
Top = 3120
Width = 1290
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "家庭住址："
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 240
Index = 9
Left = 375
TabIndex = 25
Top = 3600
Width = 1290
End
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "2、请尽量保持刷新状态，数据更新失误易使系统崩溃。"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 480
TabIndex = 37
Top = 1680
Width = 5880
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "1、班级一定要从列表中选择；"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 480
TabIndex = 36
Top = 1200
Width = 3240
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "班级："
BeginProperty Font
Name = "黑体"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 285
Index = 0
Left = 480
TabIndex = 3
Top = 210
Width = 900
End
Begin VB.Label RSCount
AutoSize = -1 'True
BackStyle = 0 'Transparent
BeginProperty Font
Name = "楷体_GB2312"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000040C0&
Height = 300
Left = 8160
TabIndex = 2
Top = 240
Width = 150
End
End
Attribute VB_Name = "FrmKsdj"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs As ADODB.Recordset
Dim RsLst As ADODB.Recordset
Dim AddFlg As Boolean
Dim arr() As Byte
Dim i As Long
Private Sub CmdAdd_Click()
DataNull
rs.AddNew
CmdAdd.Enabled = False
CmdMdi.Enabled = False
CmdDel.Enabled = False
CmdSave.Enabled = True
CmdCancel.Enabled = True
Command7.Enabled = False
Command8.Enabled = False
Command9.Enabled = False
Command10.Enabled = False
List1.Enabled = False
AddFlg = True
End Sub
Private Sub Command10_Click()
rs.MoveLast
List1.ListIndex = List1.ListCount - 1
Display
End Sub
Private Sub Command11_Click()
On Error GoTo err
rs.Close
Set rs = New ADODB.Recordset
rs.Open "select * from 学籍表 order by 班级,学号", Con, adOpenStatic, adLockPessimistic, adCmdText
RsLst.Open "select * from 学籍表 order by 班级,学号", Con, adOpenStatic, adLockPessimistic, adCmdText
List1.Clear
List1.AddItem "班级 " & "学号" & "-" & "姓名"
If RsLst.BOF And RsLst.EOF Then
RsLst.Close
Exit Sub
Else
RsLst.MoveFirst
Do While RsLst.EOF = False
If Len(RsLst!学号) = 1 Then
List1.AddItem RsLst!班级 & " 0" & RsLst!学号 & " - " & RsLst!姓名
Else
List1.AddItem RsLst!班级 & " " & RsLst!学号 & " - " & RsLst!姓名
End If
RsLst.MoveNext
Loop
RsLst.MoveFirst
End If
RsLst.Close
List1.ListIndex = 1
Display
Exit Sub
err:
Call ExecErr(Date, Me.Caption, err.Number, err.Source, err.Description)
End Sub
Private Sub CmdMdi_Click()
Dim ctl As Control
For Each ctl In Controls
If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Then
ctl.Enabled = True
End If
Next ctl
MaskEdBox1.Enabled = True
Frame1.Enabled = True
CmdSave.Enabled = True
CmdCancel.Enabled = True
CmdAdd.Enabled = False
CmdMdi.Enabled = False
CmdDel.Enabled = False
Command7.Enabled = False
Command8.Enabled = False
Command9.Enabled = False
Command10.Enabled = False
List1.Enabled = False
AddFlg = False
End Sub
Private Sub CmdDel_Click()
On Error GoTo delErr
If vbYes = MsgBox("确认索要删除此记录么？", vbYesNo, "删除对话框") Then
rs.Delete
rs.MoveNext
If rs.EOF Then rs.MoveLast
Command11_Click
Display
End If
Exit Sub
delErr:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -