📄 form50.frm
字号:
TabIndex = 61
Top = 4320
Width = 135
End
Begin VB.Label Label17
BackStyle = 0 'Transparent
Caption = "2"
ForeColor = &H00FF0000&
Height = 255
Left = 13680
TabIndex = 60
Top = 3960
Width = 255
End
Begin VB.Label Label16
BackStyle = 0 'Transparent
Caption = "1"
ForeColor = &H00FF0000&
Height = 255
Left = 13680
TabIndex = 59
Top = 3600
Width = 135
End
Begin VB.Label Label14
BackStyle = 0 'Transparent
Caption = "备注"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 21360
TabIndex = 58
Top = 3240
Width = 495
End
Begin VB.Label Label13
BackStyle = 0 'Transparent
Caption = "总价（元）"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 19800
TabIndex = 57
Top = 3240
Width = 1095
End
Begin VB.Label Label11
BackStyle = 0 'Transparent
Caption = "工作量（米）"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 18360
TabIndex = 56
Top = 3240
Width = 1215
End
Begin VB.Label Label10
BackStyle = 0 'Transparent
Caption = "单位（元/米）"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 16800
TabIndex = 55
Top = 3240
Width = 1335
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "孔深"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 15840
TabIndex = 54
Top = 3240
Width = 495
End
Begin VB.Label Label8
BackStyle = 0 'Transparent
Caption = "类别"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 14640
TabIndex = 53
Top = 3240
Width = 495
End
Begin VB.Label Label7
BackStyle = 0 'Transparent
Caption = "序号"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 13560
TabIndex = 52
Top = 3240
Width = 495
End
Begin VB.Line Line24
X1 = 20880
X2 = 20880
Y1 = 4920
Y2 = 3120
End
Begin VB.Line Line23
X1 = 19560
X2 = 19560
Y1 = 4920
Y2 = 3120
End
Begin VB.Line Line22
X1 = 18120
X2 = 18120
Y1 = 4920
Y2 = 3120
End
Begin VB.Line Line21
X1 = 16560
X2 = 16560
Y1 = 4920
Y2 = 3120
End
Begin VB.Line Line20
X1 = 15360
X2 = 15360
Y1 = 4920
Y2 = 3120
End
Begin VB.Line Line19
X1 = 14160
X2 = 14160
Y1 = 5280
Y2 = 3120
End
Begin VB.Line Line18
X1 = 8880
X2 = 8880
Y1 = 7920
Y2 = 600
End
Begin VB.Line Line17
X1 = 13320
X2 = 22200
Y1 = 5280
Y2 = 5280
End
Begin VB.Line Line15
X1 = 13320
X2 = 22200
Y1 = 4920
Y2 = 4920
End
Begin VB.Line Line14
X1 = 13320
X2 = 22200
Y1 = 4200
Y2 = 4200
End
Begin VB.Line Line13
X1 = 13320
X2 = 22200
Y1 = 4560
Y2 = 4560
End
Begin VB.Line Line12
X1 = 13320
X2 = 22200
Y1 = 3840
Y2 = 3840
End
Begin VB.Line Line9
X1 = 13320
X2 = 22200
Y1 = 3120
Y2 = 3120
End
Begin VB.Line Line8
X1 = 13320
X2 = 22200
Y1 = 3480
Y2 = 3480
End
Begin VB.Line Line7
X1 = 8880
X2 = 8880
Y1 = 720
Y2 = 2520
End
Begin VB.Line Line2
X1 = 3960
X2 = 3960
Y1 = 600
Y2 = 1680
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "静力触探进尺（米）"
ForeColor = &H00FF0000&
Height = 255
Left = 4320
TabIndex = 51
Top = 1200
Width = 1695
End
Begin VB.Label Label15
BackStyle = 0 'Transparent
Caption = "工程名称"
ForeColor = &H00FF0000&
Height = 255
Left = 4800
TabIndex = 50
Top = 600
Width = 975
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "结算明细"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 13440
TabIndex = 49
Top = 2880
Width = 975
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Caption = "合同额（元）"
ForeColor = &H00FF0000&
Height = 375
Left = 1560
TabIndex = 48
Top = 1560
Width = 1215
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "钻探进尺（米）"
ForeColor = &H00FF0000&
Height = 255
Left = 4560
TabIndex = 47
Top = 885
Width = 1365
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "总进尺（米）"
ForeColor = &H00FF0000&
Height = 255
Left = 120
TabIndex = 46
Top = 1080
Width = 1215
End
Begin VB.Label Label1
BackColor = &H8000000B&
BackStyle = 0 'Transparent
Caption = "工程编号"
ForeColor = &H00FF0000&
Height = 255
Left = 360
TabIndex = 45
Top = 600
Width = 855
End
Begin VB.Line Line1
X1 = 0
X2 = 8880
Y1 = 795
Y2 = 795
End
Begin VB.Line Line3
X1 = 1320
X2 = 1320
Y1 = 600
Y2 = 1440
End
Begin VB.Line Line4
X1 = 0
X2 = 8880
Y1 = 1425
Y2 = 1425
End
Begin VB.Line Line5
X1 = 3960
X2 = 8880
Y1 = 1110
Y2 = 1110
End
Begin VB.Line Line6
X1 = 0
X2 = 8880
Y1 = 1740
Y2 = 1740
End
Begin VB.Line Line10
X1 = 0
X2 = 0
Y1 = 7920
Y2 = 480
End
Begin VB.Line Line11
X1 = 0
X2 = 8880
Y1 = 480
Y2 = 480
End
End
Attribute VB_Name = "Form50"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim i, m, n, o, l, j, r, s As Integer
Dim g
Dim da As Date
For i = 1 To 41
If Text1(i) = "" Then
Text1(i) = 0
End If
Next
If Text1(43) = "" Then
Text1(43) = 0
End If
If Text1(50) = "" Then
Text1(50) = 0
End If
For s = 53 To 81
If Text1(s) = "" Then
Text1(s) = 0
End If
Next
hzrs.CursorLocation = adUseClient
hzrs.Open "select * from 勘察工程任务结算单", hzconn, adOpenKeyset, adLockPessimistic
For r = 1 To hzrs.RecordCount
g = hzrs.Fields(1).Value
If Form50.Text1(1).Text = g Then
For j = 1 To 41
Text1(j).Text = ""
Next
Text1(43).Text = ""
For j = 53 To 81
Text1(j).Text = ""
Next
ln = MsgBox("工程编号已存在，请重新输入！", vbInformation, "提示")
hzrs.Close
Exit Sub
End If
hzrs.MoveNext
Next
If Form50.Text1(1).Text = "0" Then
For j = 1 To 41
Text1(j).Text = ""
Next
Text1(43).Text = ""
For j = 53 To 81
Text1(j).Text = ""
Next
ln = MsgBox("工程编号不能为空，请重新输入！", vbInformation, "⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -