【VB开源代码栏目提醒】:网学会员VB开源代码为您提供frm项目经济信息.frm参考,解决您在frm项目经济信息.frm学习中工作中的难题,参考学习。
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "msadodc.ocx"
Begin VB.Form frm项目经济信息
BorderStyle = 3 'Fixed Dialog
Caption = "项目经济信息"
ClientHeight = 3540
ClientLeft = 1095
ClientTop = 510
ClientWidth = 5775
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3540
ScaleWidth = 5775
Begin VB.PictureBox picButtons
Align = 2 'Align Bottom
Appearance = 0 'Flat
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 300
Left = 0
ScaleHeight = 300
ScaleWidth = 5775
TabIndex = 18
Top = 3240
Width = 5775
Begin VB.CommandButton cmdClose
Caption = "关闭"
Height = 300
Left = 2367
TabIndex = 19
Top = 0
Width = 1095
End
End
Begin VB.TextBox txtFields
DataField = "项目工日合计"
Height = 285
Index = 8
Left = 2040
TabIndex = 17
Top = 2620
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目其他费合计"
Height = 285
Index = 7
Left = 2040
TabIndex = 15
Top = 2300
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目主材合计"
Height = 285
Index = 6
Left = 2040
TabIndex = 13
Top = 1980
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目设备合计"
Height = 285
Index = 5
Left = 2040
TabIndex = 11
Top = 1660
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目机械合计"
Height = 285
Index = 4
Left = 2040
TabIndex = 9
Top = 1340
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目材料合计"
Height = 285
Index = 3
Left = 2040
TabIndex = 7
Top = 1020
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目人工合计"
Height = 285
Index = 2
Left = 2040
TabIndex = 5
Top = 700
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "项目合计"
Height = 285
Index = 1
Left = 2040
TabIndex = 3
Top = 380
Width = 3375
End
Begin VB.TextBox txtFields
DataField = "工程名称"
Height = 285
Index = 0
Left = 2040
TabIndex = 1
Top = 60
Width = 3375
End
Begin MSAdodcLib.Adodc datPrimaryRS
Align = 2 'Align Bottom
Height = 330
Left = 0
Top = 2910
Visible = 0 'False
Width = 5775
_ExtentX = 10186
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Pass
word = ""
RecordSource = $"frm项目
经济信息.frx":0000
Caption = " "
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin
VB.Label lblLabels
Caption = "项目工日合计:"
Height = 255
Index = 8
Left = 120
TabIndex = 16
Top = 2620
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目其他费合计:"
Height = 255
Index = 7
Left = 120
TabIndex = 14
Top = 2300
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目主材合计:"
Height = 255
Index = 6
Left = 120
TabIndex = 12
Top = 1980
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目设备合计:"
Height = 255
Index = 5
Left = 120
TabIndex = 10
Top = 1660
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目机械合计:"
Height = 255
Index = 4
Left = 120
TabIndex = 8
Top = 1340
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目材料合计:"
Height = 255
Index = 3
Left = 120
TabIndex = 6
Top = 1020
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目人工合计:"
Height = 255
Index = 2
Left = 120
TabIndex = 4
Top = 700
Width = 1815
End
Begin VB.Label lblLabels
Caption = "项目合计:"
Height = 255
Index = 1
Left = 120
TabIndex = 2
Top = 380
Width = 1815
End
Begin VB.Label lblLabels
Caption = "工程名称:"
Height = 255
Index = 0
Left = 120
TabIndex = 0
Top = 60
Width = 1815
End
End
Attribute VB_Name = "frm项目经济信息"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'初始化
Private Sub Form_Load()
'打开错误处理陷阱
Dim intErrFileNo As Integer '自由文件号
On Error GoTo ErrGoto
'----------------------------------------------------
'设置连接
datPrimaryRS.ConnectionString = gConnectionString
SQL = "select 工程名称,项目合计,项目人工合计,项目材料合计,项目机械合计,项目设备合计,项目主材合计,项目其他费合计,项目工日合计 from 项目经济信息,工程信息 WHERE 工程信息.项目ID = 项目经济信息.项目ID AND 项目经济信息.项目ID = " & ProjectID
datPrimaryR