📄 form2.frm
字号:
Left = 1080
TabIndex = 16
Top = 1160
Width = 1095
End
End
Begin VB.Frame Frame1
Caption = "输入数据"
Height = 2535
Left = 105
TabIndex = 0
Top = 120
Width = 2295
Begin VB.TextBox Text1
Height = 270
Left = 1080
TabIndex = 7
Top = 220
Width = 1095
End
Begin VB.TextBox Text2
Height = 270
Left = 1080
TabIndex = 6
Top = 530
Width = 1095
End
Begin VB.TextBox Text3
Height = 270
Left = 1080
TabIndex = 5
Top = 840
Width = 1095
End
Begin VB.TextBox Text4
Height = 270
Left = 1080
TabIndex = 4
Top = 1140
Width = 1095
End
Begin VB.TextBox Text5
Height = 270
Left = 1080
TabIndex = 3
Top = 1440
Width = 1095
End
Begin VB.TextBox Text6
Height = 270
Left = 1080
TabIndex = 2
Top = 1750
Width = 1095
End
Begin VB.TextBox Text7
Height = 270
Left = 1080
TabIndex = 1
Top = 2060
Width = 1095
End
Begin VB.Label Label1
Caption = "工 资 号："
Height = 255
Left = 120
TabIndex = 14
Top = 240
Width = 975
End
Begin VB.Label Label2
Caption = "工作部门："
Height = 255
Left = 120
TabIndex = 13
Top = 555
Width = 975
End
Begin VB.Label Label3
Caption = "姓 名："
Height = 255
Left = 120
TabIndex = 12
Top = 885
Width = 975
End
Begin VB.Label Label4
Caption = "职务工资："
Height = 255
Left = 120
TabIndex = 11
Top = 1200
Width = 975
End
Begin VB.Label Label5
Caption = "津 贴："
Height = 255
Left = 120
TabIndex = 10
Top = 1515
Width = 975
End
Begin VB.Label Label6
Caption = "保留津贴："
Height = 255
Left = 120
TabIndex = 9
Top = 1845
Width = 975
End
Begin VB.Label Label7
Caption = "保留奖金："
Height = 255
Left = 120
TabIndex = 8
Top = 2160
Width = 975
End
End
Begin VB.Label Label16
BackColor = &H8000000D&
Caption = "查询到记录00条，现在第00条"
ForeColor = &H8000000E&
Height = 255
Left = 2520
TabIndex = 56
Top = 4440
Width = 2415
End
End
Attribute VB_Name = "Form2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rec
Dim nowrecord As Integer
Dim delflag As Boolean
Sub cleartext()
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Label17.Caption = ""
Label18.Caption = ""
Label19.Caption = ""
Label20.Caption = ""
Check1.Value = 0
Check2.Value = 0
Check3.Value = 0
Check4.Value = 0
Check5.Value = 0
Check6.Value = 0
Check7.Value = 0
Check8.Value = 0
Check9.Value = 0
Check10.Value = 0
Check11.Value = 0
Check12.Value = 0
Combo1.Text = "请选择所属部门"
End Sub
Sub display()
Text1.Text = rec(0)
Text2.Text = rec(1)
Text3.Text = rec(2)
Text4.Text = rec(4)
Text5.Text = rec(5)
Text6.Text = rec(6)
Text7.Text = rec(7)
Label17.Caption = rec(8)
Label18.Caption = rec(9)
Label19.Caption = rec(10)
Label20.Caption = rec(3)
If rec(13) = "未交" Then
Check1.Value = 0
Else
Check1.Value = 1
End If
If rec(14) = "未交" Then
Check2.Value = 0
Else
Check2.Value = 1
End If
If rec(15) = "未交" Then
Check3.Value = 0
Else
Check3.Value = 1
End If
If rec(16) = "未交" Then
Check4.Value = 0
Else
Check4.Value = 1
End If
If rec(17) = "未交" Then
Check5.Value = 0
Else
Check5.Value = 1
End If
If rec(18) = "未交" Then
Check6.Value = 0
Else
Check6.Value = 1
End If
If rec(19) = "未交" Then
Check7.Value = 0
Else
Check7.Value = 1
End If
If rec(20) = "未交" Then
Check8.Value = 0
Else
Check8.Value = 1
End If
If rec(21) = "未交" Then
Check9.Value = 0
Else
Check9.Value = 1
End If
If rec(22) = "未交" Then
Check10.Value = 0
Else
Check10.Value = 1
End If
If rec(23) = "未交" Then
Check11.Value = 0
Else
Check11.Value = 1
End If
If rec(24) = "未交" Then
Check12.Value = 0
Else
Check12.Value = 1
End If
If rec("党员性质") = "正式" Then
Option13.Value = True
ElseIf rec("党员性质") = "预备" Then
Option14.Value = True
End If
Combo1.Text = rec("所属总支")
If Combo1.Text = "暂无记录" Then Combo1.Text = "请选择所属部门"
Command7.Enabled = True
Command14.Enabled = True
End Sub
Private Sub Command1_Click()
Form4.Show
End Sub
Private Sub Command10_Click()
If Trim(Text1.Text) = "" Then
MsgBox "工资号不能为空", , "I/O错误"
Exit Sub
End If
If Trim(Text2.Text) = "" Or Trim(Text3.Text) = "" Then
MsgBox "姓名和部门不能为空", , "I/O错误"
Exit Sub
End If
If Trim(Text4.Text) = "" Or Trim(Text5.Text) = "" Or Trim(Text6.Text) = "" Or Trim(Text7.Text) = "" Or Label17.Caption = "" Or Label18.Caption = "" Or Label19.Caption = "" Or Label20.Caption = "" Then
MsgBox "命令执行不合法，有数据项为空"
Exit Sub
End If
Set cnn = New ADODB.Connection
cnn.Open cnstr
Set rec3 = New ADODB.Recordset
sqlstr = "select * from teacher2003 where 工资号='" & Trim(CStr(Text1.Text)) & "'"
rec3.Open sqlstr, cnn, 3, 2
If rec3.RecordCount >= 1 Then
rec3(0) = Trim(CStr(Text1.Text))
rec3(1) = Trim(CStr(Text2.Text))
rec3(2) = Trim(CStr(Text3.Text))
rec3(3) = Round(CDbl(Label20.Caption), 2)
rec3(4) = Round(CDbl(Text4.Text), 2)
rec3(5) = Round(CDbl(Text5.Text), 2)
rec3(6) = Round(CDbl(Text6.Text), 2)
rec3(7) = Round(CDbl(Text7.Text), 2)
rec3(8) = Round(CDbl(Label17.Caption), 2)
rec3(9) = Round(CDbl(Label18.Caption), 2)
rec3(10) = Round(CDbl(Label19.Caption), 2)
If Check1.Value = 0 Then
rec3(13) = "未交"
Else
rec3(13) = "已交"
End If
If Check2.Value = 0 Then
rec3(14) = "未交"
Else
rec3(14) = "已交"
End If
If Check3.Value = 0 Then
rec3(15) = "未交"
Else
rec3(15) = "已交"
End If
If Check4.Value = 0 Then
rec3(16) = "未交"
Else
rec3(16) = "已交"
End If
If Check5.Value = 0 Then
rec3(17) = "未交"
Else
rec3(17) = "已交"
End If
If Check6.Value = 0 Then
rec3(18) = "未交"
Else
rec3(18) = "已交"
End If
If Check7.Value = 0 Then
rec3(19) = "未交"
Else
rec3(19) = "已交"
End If
If Check8.Value = 0 Then
rec3(20) = "未交"
Else
rec3(20) = "已交"
End If
If Check9.Value = 0 Then
rec3(21) = "未交"
Else
rec3(21) = "已交"
End If
If Check10.Value = 0 Then
rec3(22) = "未交"
Else
rec3(22) = "已交"
End If
If Check11.Value = 0 Then
rec3(23) = "未交"
Else
rec3(23) = "已交"
End If
If Check12.Value = 0 Then
rec3(24) = "未交"
Else
rec3(24) = "已交"
End If
If Option13.Value = True Then
rec3("党员性质") = "正式"
ElseIf Option14.Value = True Then
rec3("党员性质") = "预备"
End If
rec3("所属总支") = Combo1.Text
If rec3("所属总支") = "请选择所属部门" Then rec3("所属总支") = "暂无记录"
rec3.Update
MsgBox "修改成功"
Else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -