📄 frmedithistory.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomct2.ocx"
Begin VB.Form frmEditHistory
Caption = "学员历史记录编辑窗口"
ClientHeight = 3300
ClientLeft = 60
ClientTop = 345
ClientWidth = 6285
Icon = "frmEditHistory.frx":0000
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 3300
ScaleWidth = 6285
Begin MSComCtl2.DTPicker DTPDate
Height = 300
Left = 1515
TabIndex = 3
Top = 1680
Width = 1215
_ExtentX = 2143
_ExtentY = 529
_Version = 393216
Format = 23724033
CurrentDate = 37634
End
Begin VB.ComboBox cmbName
Height = 300
Left = 1515
Style = 2 'Dropdown List
TabIndex = 1
Top = 720
Width = 1215
End
Begin VB.ComboBox cmbCCode
Height = 300
Left = 4800
Style = 2 'Dropdown List
TabIndex = 4
Top = 240
Width = 1215
End
Begin VB.ComboBox cmbSMcode
Height = 300
Left = 4800
TabIndex = 6
Text = "cmbSMcode"
Top = 1200
Width = 1215
End
Begin VB.CommandButton cmdSave
Caption = "确 定 "
Height = 375
Left = 4095
Style = 1 'Graphical
TabIndex = 15
Top = 2640
Width = 975
End
Begin VB.CommandButton cmdLast
Caption = ">>"
Height = 255
Left = 4875
Style = 1 'Graphical
TabIndex = 10
Top = 2160
Width = 735
End
Begin VB.CommandButton cmdNext
Caption = ">"
Height = 255
Left = 3475
Style = 1 'Graphical
TabIndex = 9
Top = 2160
Width = 735
End
Begin VB.CommandButton cmdPrevious
Caption = "<"
Height = 255
Left = 2075
Style = 1 'Graphical
TabIndex = 8
Top = 2160
Width = 735
End
Begin VB.CommandButton cmdFirst
Caption = "<<"
Height = 255
Left = 675
Style = 1 'Graphical
TabIndex = 7
Top = 2160
Width = 735
End
Begin VB.CommandButton cmdExit
Caption = "退 出"
Height = 375
Left = 5055
Style = 1 'Graphical
TabIndex = 17
Top = 2640
Width = 975
End
Begin VB.CommandButton cmdModify
Caption = "修改记录"
Height = 375
Left = 3135
Style = 1 'Graphical
TabIndex = 14
Top = 2640
Width = 975
End
Begin VB.CommandButton cmdDel
Caption = "删除记录"
Height = 375
Left = 2160
Style = 1 'Graphical
TabIndex = 13
Top = 2640
Width = 975
End
Begin VB.CommandButton cmdCancel
Caption = "放 弃"
Height = 375
Left = 1215
Style = 1 'Graphical
TabIndex = 12
Top = 2640
Width = 975
End
Begin VB.CommandButton cmdAdd
Caption = "添加记录"
Height = 375
Left = 240
Style = 1 'Graphical
TabIndex = 11
Top = 2640
Width = 975
End
Begin VB.TextBox txtSID
Height = 300
Left = 1515
TabIndex = 0
Top = 240
Width = 1215
End
Begin VB.TextBox txtBCode
Height = 300
Left = 1515
TabIndex = 2
Top = 1200
Width = 1215
End
Begin VB.ComboBox cmbStatus
Height = 300
Left = 4800
Style = 2 'Dropdown List
TabIndex = 5
Top = 720
Width = 1215
End
Begin VB.Label lblName
Caption = "姓 名"
Height = 300
Left = 315
TabIndex = 23
Top = 720
Width = 855
End
Begin VB.Label lblSMCode
Caption = "学期代号"
Height = 300
Left = 3555
TabIndex = 22
Top = 1200
Width = 855
End
Begin VB.Label lblSID
Caption = "学 号"
Height = 300
Left = 315
TabIndex = 21
Top = 240
Width = 855
End
Begin VB.Label lblCCode
Caption = "中心代码"
Height = 300
Left = 3555
TabIndex = 20
Top = 240
Width = 855
End
Begin VB.Label lblBCode
Caption = "班 号"
Height = 300
Left = 315
TabIndex = 19
Top = 1200
Width = 855
End
Begin VB.Label lblJDate
Caption = "日 期"
Height = 300
Left = 315
TabIndex = 18
Top = 1680
Width = 855
End
Begin VB.Label lblStatus
Caption = "学员状态"
Height = 300
Left = 3555
TabIndex = 16
Top = 720
Width = 855
End
End
Attribute VB_Name = "frmEditHistory"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cmbIDCard_Click()
If Len(cmbIDCard.Text) = 0 Then
RsClose rsTemp
strFind = "select sname from studentinfo where idcard='" & Trim(cmbIDCard.Text) & "'"
RsOpen rs, con, strFind, "adcmdtext"
txtName = rs.Fields("sname")
RsClose rsTemp
End If
End Sub
Private Sub cmdAdd_Click()
cmdFlag = 1
Dim ctlcontrol As Control
'禁用除 添加记录 放弃添加 确定 退出 以外的所有按钮控件
For Each ctlcontrol In Controls
If TypeOf ctlcontrol Is CommandButton Then
If ctlcontrol.Name = "cmdAdd" Or ctlcontrol.Name = "cmdCancel" Or ctlcontrol.Name = "cmdSave" Or ctlcontrol.Name = "cmdExit" Then
ctlcontrol.Enabled = True
Else
ctlcontrol.Enabled = False
End If
End If
Next
'清除所有控件的文本显示,DisplayRefresh子程 见本窗体
DisplayRefresh
cmdCancel.SetFocus
End Sub
Private Sub cmdCancel_Click()
cmdFlag = 0
'清除所有控件的文本显示,DisplayRefresh子程 见本窗体
DisplayRefresh
'消除控件的禁用,ControlEnabled子程 见本窗体
ControlEnabled
End Sub
Private Sub cmdDel_Click()
cmdFlag = 2
'禁用 添加记录 修改记录 按钮控件
Dim ctlcontrol As Control
For Each ctlcontrol In Controls
If TypeOf ctlcontrol Is CommandButton Then
If ctlcontrol.Name = "cmdAdd" Or ctlcontrol.Name = "cmdModify" Then
ctlcontrol.Enabled = False
End If
End If
Next
'禁用控件文本框和组合框,ControlDisabled子程 见本窗体
ControlDisabled
cmdCancel.SetFocus
End Sub
Private Sub cmdExit_Click()
'关闭记录集,RsClose函数 见模块MdlConnection
RsClose rs
'关闭窗体
Unload Me
End Sub
Private Sub cmdFirst_Click()
rs.MoveFirst
'显示当前记录内容,Display子程 见本窗体
Display
End Sub
Private Sub cmdLast_Click()
rs.MoveLast
'显示当前记录内容,Display子程 见本窗体
Display
End Sub
Private Sub cmdModify_Click()
cmdFlag = 3
'禁用 添加记录 删除记录 按钮控件
Dim ctlcontrol As Control
For Each ctlcontrol In Controls
If TypeOf ctlcontrol Is CommandButton Then
If ctlcontrol.Name = "cmdAdd" Or ctlcontrol.Name = "cmdDel" Then
ctlcontrol.Enabled = False
End If
End If
Next
cmdCancel.SetFocus
End Sub
Private Sub cmdNext_Click()
With rs
.MoveNext
If .EOF Then .MoveLast
End With
'显示当前记录内容,Display子程 见本窗体
Display
End Sub
Private Sub cmdPrevious_Click()
With rs
.MovePrevious
If .BOF Then .MoveFirst
End With
'显示当前记录内容,Display子程 见本窗体
Display
End Sub
Private Sub cmdSave_Click()
Dim ctlcontrol As Control
If cmdFlag = 1 Then
'验证录入项,InputVerify函数 见本窗体
If InputVerify = False Then
Exit Sub
End If
Dim strIdCard As String
RsClose rsTemp
strFind = "select idcard from studentinfo where sname='" & Trim(cmbName.Text) & "'"
RsOpen rsTemp, con, strFind, "adcmdtext"
strIdCard = rsTemp!idcard
RsClose rsTemp
'添加一行记录
With rs
.AddNew
rs![sname] = Trim(cmbName.Text)
rs![sid] = Trim(txtSID.Text)
rs![smcode] = Trim(cmbSMCode.Text)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -