📄 form66.frm
字号:
Width = 855
End
Begin VB.Line Line12
X1 = 7800
X2 = 7800
Y1 = 3480
Y2 = 600
End
Begin VB.Line Line9
X1 = 6120
X2 = 6120
Y1 = 3480
Y2 = 600
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "备注："
ForeColor = &H00FF0000&
Height = 255
Left = 6840
TabIndex = 25
Top = 1800
Width = 615
End
Begin VB.Label Label8
BackColor = &H8000000B&
BackStyle = 0 'Transparent
Caption = "姓名："
ForeColor = &H00FF0000&
Height = 255
Left = 960
TabIndex = 24
Top = 720
Width = 615
End
Begin VB.Label Label15
BackStyle = 0 'Transparent
Caption = "工程名称："
ForeColor = &H00FF0000&
Height = 255
Left = 720
TabIndex = 23
Top = 1440
Width = 975
End
Begin VB.Label Label7
BackStyle = 0 'Transparent
Caption = "结算额："
ForeColor = &H00FF0000&
Height = 255
Left = 840
TabIndex = 22
Top = 3240
Width = 855
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "欠款额："
ForeColor = &H00FF0000&
Height = 255
Left = 6720
TabIndex = 21
Top = 720
Width = 735
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "进款额："
ForeColor = &H00FF0000&
Height = 255
Left = 840
TabIndex = 20
Top = 2520
Width = 735
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Caption = "合同额："
ForeColor = &H00FF0000&
Height = 255
Left = 840
TabIndex = 19
Top = 2160
Width = 735
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "系数："
ForeColor = &H00FF0000&
Height = 255
Left = 960
TabIndex = 18
Top = 2880
Width = 855
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "建设单位："
ForeColor = &H00FF0000&
Height = 255
Left = 720
TabIndex = 17
Top = 1800
Width = 975
End
Begin VB.Label Label1
BackColor = &H8000000B&
BackStyle = 0 'Transparent
Caption = "工程编号："
ForeColor = &H00FF0000&
Height = 255
Left = 720
TabIndex = 16
Top = 1080
Width = 975
End
Begin VB.Line Line1
X1 = 120
X2 = 11880
Y1 = 960
Y2 = 960
End
Begin VB.Line Line3
X1 = 120
X2 = 11880
Y1 = 1320
Y2 = 1320
End
Begin VB.Line Line4
X1 = 120
X2 = 11880
Y1 = 1680
Y2 = 1680
End
Begin VB.Line Line5
X1 = 120
X2 = 11880
Y1 = 2040
Y2 = 2040
End
Begin VB.Line Line6
X1 = 120
X2 = 11880
Y1 = 2400
Y2 = 2400
End
Begin VB.Line Line7
X1 = 120
X2 = 11880
Y1 = 3120
Y2 = 3120
End
Begin VB.Line Line8
X1 = 11880
X2 = 11880
Y1 = 3480
Y2 = 600
End
Begin VB.Line Line10
X1 = 120
X2 = 120
Y1 = 3480
Y2 = 600
End
Begin VB.Line Line11
X1 = 120
X2 = 11880
Y1 = 600
Y2 = 600
End
End
Attribute VB_Name = "Form66"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim i, j, m, p As Integer
hzrs.CursorLocation = adUseClient
hzrs.Open "select * from 经营人员结算单", hzconn, adOpenKeyset, adLockPessimistic
If ii(73) <> "0" Then
For i = 1 To hzrs.RecordCount
If hzrs.Fields(0).Value = Text1(0).Text Then
If Text1(11).Text = "" Then
hzrs.Fields(13).Value = 0
Else
hzrs.Fields(13).Value = Text1(11).Text
End If
If Text1(12).Text = "" Then
hzrs.Fields(14).Value = 0
Else
hzrs.Fields(14).Value = Text1(12).Text
End If
End If
hzrs.MoveNext
Next
End If
If ii(75) <> "0" Then
For i = 1 To hzrs.RecordCount
If hzrs.Fields(0).Value = Text1(0).Text Then
If Text1(13).Text = "" Then
hzrs.Fields(15).Value = 0
Else
hzrs.Fields(15).Value = Text1(13).Text
End If
If Text1(14).Text = "" Then
hzrs.Fields(14).Value = 0
Else
hzrs.Fields(16).Value = Text1(14).Text
End If
End If
hzrs.MoveNext
Next
End If
hzrs.Close
Dim ln As Long
ln = MsgBox("信息修改完成！", vbInformation, "提示")
For p = 1 To Form65.ListView1.ListItems.Count
Form65.ListView1.ListItems.Item(p).Checked = False
Next
Unload Me
End Sub
Private Sub Command2_Click()
Dim p As Integer
For p = 1 To Form65.ListView1.ListItems.Count
Form65.ListView1.ListItems.Item(p).Checked = False
Next
Unload Me
End Sub
Private Sub Form_Load()
Dim i, j, l, m As Integer
With Me
.Height = 8010
.left = 2332
.top = 2600
.Width = 12160
End With
End Sub
Private Sub Form_Unload(Cancel As Integer)
Form65.ListView1.ListItems.Clear
hzrs.CursorLocation = adUseClient
hzrs.Open "select * from 经营人员结算单 order by ID", hzconn, adOpenKeyset, adLockPessimistic
For n = 1 To hzrs.RecordCount
If ii(73) <> "0" Then
If hzrs.Fields(13).Value = "0" Then
b = b + 1
Form65.ListView1.ListItems.Add , , hzrs.Fields(0).Value
Form65.ListView1.ListItems.Item(b).SubItems(1) = hzrs.Fields(1).Value
Form65.ListView1.ListItems.Item(b).SubItems(2) = hzrs.Fields(2).Value
Form65.ListView1.ListItems.Item(b).SubItems(3) = hzrs.Fields(3).Value
Form65.ListView1.ListItems.Item(b).SubItems(4) = hzrs.Fields(4).Value
Form65.ListView1.ListItems.Item(b).SubItems(5) = hzrs.Fields(10).Value
Form65.ListView1.ListItems.Item(b).SubItems(6) = hzrs.Fields(11).Value
If hzrs.Fields(13).Value = "0" Then
Form65.ListView1.ListItems.Item(b).ForeColor = &HFF0000 '兰色
For m = 1 To 5
Form65.ListView1.ListItems.Item(b).ListSubItems.Item(m).ForeColor = &HFF0000 '兰色
Next
End If
End If
End If
If ii(75) <> "0" Then
If hzrs.Fields(15).Value = "0" Then
b = b + 1
Form65.ListView1.ListItems.Add , , hzrs.Fields(0).Value
Form65.ListView1.ListItems.Item(b).SubItems(1) = hzrs.Fields(1).Value
Form65.ListView1.ListItems.Item(b).SubItems(2) = hzrs.Fields(2).Value
Form65.ListView1.ListItems.Item(b).SubItems(3) = hzrs.Fields(3).Value
Form65.ListView1.ListItems.Item(b).SubItems(4) = hzrs.Fields(4).Value
Form65.ListView1.ListItems.Item(b).SubItems(5) = hzrs.Fields(10).Value
Form65.ListView1.ListItems.Item(b).SubItems(6) = hzrs.Fields(11).Value
If hzrs.Fields(13).Value = "0" Then
Form65.ListView1.ListItems.Item(b).ForeColor = &HFF0000 '兰色
For m = 1 To 5
Form65.ListView1.ListItems.Item(b).ListSubItems.Item(m).ForeColor = &HFF0000 '兰色
Next
End If
If hzrs.Fields(15).Value = "0" And hzrs.Fields(13).Value <> "0" Then
Form65.ListView1.ListItems.Item(b).ForeColor = &HC0C000 '天蓝色
For m = 1 To 5
Form65.ListView1.ListItems.Item(b).ListSubItems.Item(m).ForeColor = &HC0C000 '天蓝色
Next
End If
End If
End If
hzrs.MoveNext
Next
hzrs.Close
If b <> 0 Then
Form65.ListView1.ListItems(Form65.ListView1.ListItems.Count).Selected = True
Form65.ListView1.SelectedItem.EnsureVisible
Form65.ListView1.Refresh
End If
End Sub
Private Sub Timer1_Timer()
Dim i, j, l, m As Integer
Dim a As String
For i = 4 To 7
If Text1(i).Text = "" Then
ll(i) = 0
Else
ll(i) = Val(Text1(i).Text)
End If
Next
Text1(6).Text = Val(ll(5)) * Val(Combo2.Text)
If Text1(6).Text = 0 Then
Text1(6).Text = ""
End If
Text1(7).Text = Val(ll(4)) - Val(ll(5))
If Text1(7).Text = 0 Then
Text1(7).Text = ""
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -