📄 frminvest.frm
字号:
VERSION 5.00
Object = "{0BA686C6-F7D3-101A-993E-0000C0EF6F5E}#1.0#0"; "THREED32.OCX"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "msflxgrd.ocx"
Object = "{FE0065C0-1B7B-11CF-9D53-00AA003C9CB6}#1.1#0"; "COMCT232.OCX"
Begin VB.Form frminvest
Caption = "工程投资表"
ClientHeight = 6105
ClientLeft = 2055
ClientTop = 1620
ClientWidth = 11535
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "frminvest.frx":0000
LinkTopic = "Form1"
ScaleHeight = 6105
ScaleWidth = 11535
Begin ComCtl2.UpDown UpDown1
Height = 495
Left = 3720
TabIndex = 8
Top = 5400
Width = 255
_ExtentX = 450
_ExtentY = 873
_Version = 327681
Enabled = -1 'True
End
Begin VB.TextBox TxtNianXian
Alignment = 2 'Center
BackColor = &H00C0E0FF&
BeginProperty Font
Name = "宋体"
Size = 15.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 495
Left = 2880
TabIndex = 7
Text = "10"
Top = 5400
Width = 855
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 120
Top = 5040
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin Threed.SSPanel SSPanel1
Height = 5055
Left = 0
TabIndex = 0
Top = 120
Width = 11535
_Version = 65536
_ExtentX = 20346
_ExtentY = 8916
_StockProps = 15
Caption = "SSPanel1"
BackColor = -2147483643
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BorderWidth = 2
BevelInner = 1
Font3D = 3
Begin VB.TextBox Text1
BackColor = &H00C0E0FF&
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000080&
Height = 495
Left = 720
TabIndex = 1
Top = 1560
Visible = 0 'False
Width = 1215
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 4815
Left = 120
TabIndex = 2
Top = 120
Width = 11295
_ExtentX = 19923
_ExtentY = 8493
_Version = 393216
Cols = 3
FixedCols = 2
RowHeightMin = 500
BackColor = 16777215
BackColorFixed = 12632256
ForeColorFixed = 12582912
BackColorBkg = 14737632
WordWrap = -1 'True
TextStyleFixed = 4
ScrollBars = 2
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
End
Begin Threed.SSCommand SSCommand1
Height = 735
Left = 7200
TabIndex = 3
Top = 5280
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1296
_StockProps = 78
Caption = "调用数据"
ForeColor = 255
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Picture = "frminvest.frx":1272
End
Begin Threed.SSCommand SSCommand3
Height = 735
Left = 9840
TabIndex = 4
Top = 5280
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1296
_StockProps = 78
Caption = "退 出"
ForeColor = 255
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Picture = "frminvest.frx":1B4C
End
Begin Threed.SSPanel SSPanel2
Height = 495
Left = 120
TabIndex = 5
Top = 5400
Width = 2655
_Version = 65536
_ExtentX = 4683
_ExtentY = 873
_StockProps = 15
Caption = "投资年限修改："
ForeColor = 255
BackColor = 12640511
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "楷体_GB2312"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BorderWidth = 2
BevelOuter = 1
FloodColor = 8421631
End
Begin Threed.SSCommand SSCommand2
Height = 735
Left = 5760
TabIndex = 6
Top = 5280
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1296
_StockProps = 78
Caption = "项目明细"
ForeColor = 255
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Picture = "frminvest.frx":1F9E
End
Begin Threed.SSCommand SSCommand4
Height = 735
Left = 8520
TabIndex = 9
Top = 5280
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1296
_StockProps = 78
Caption = "数据保存"
ForeColor = 255
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Picture = "frminvest.frx":2878
End
Begin VB.Menu operate
Caption = "aa"
Visible = 0 'False
Begin VB.Menu ins_line
Caption = "插入行"
End
Begin VB.Menu del_line
Caption = "删除行"
End
Begin VB.Menu cls_line
Caption = "清除内容"
End
Begin VB.Menu allcls_line
Caption = "全部清除"
End
End
End
Attribute VB_Name = "frminvest"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private mTotalRows& ' Contains the total rows in the set of records
Dim jsq, bb, insline_max As Integer
Dim mq_index As Integer
Dim del1$, del2$, col1$, col2$
Dim selx, sely, selzbx, tt, ttt As Integer
Dim xx(50), yy(50) As Single
Dim tval As Single
Dim kr_frt$(1 To 10)
Dim VarLiuDongZiJin(1 To 30) As Double
' Dim Count As Integer '生产年限 或 要写入数据库的记录数量
Private Sub allcls_line_Click()
Beep
msg$ = "是否清除所有的设置信息？"
Title$ = "警告"
xchoose = MsgBox(msg$, 49, Title$)
If xchoose = 2 Then Exit Sub
mTotalRows& = Val(TxtNianXian.Text)
For m = 1 To mTotalRows&
For n = 1 To MSFlexGrid1.Cols - 1
MSFlexGrid1.TextMatrix(m, n) = ""
Next n
Next m
If MSFlexGrid1.TextMatrix(MSFlexGrid1.row, MSFlexGrid1.col) = "" Then Text1.Text = ""
Call blank_MSFlexGridshow
MSFlexGrid1.row = MSFlexGrid1.FixedRows: MSFlexGrid1.col = MSFlexGrid1.FixedCols
MSFlexGrid1.TopRow = MSFlexGrid1.FixedRows: MSFlexGrid1.LeftCol = MSFlexGrid1.FixedCols
' Call draw_line
End Sub
Private Sub cls_line_Click()
For i = Val(del1$) To Val(del2$)
For j = Val(col1$) To Val(col2$)
MSFlexGrid1.TextMatrix(i + MSFlexGrid1.FixedRows - 1, j + MSFlexGrid1.FixedCols - 1) = ""
Next j
Next i
If MSFlexGrid1.TextMatrix(MSFlexGrid1.row, MSFlexGrid1.col) = "" Then Text1.Text = ""
' Call draw_line
End Sub
Private Sub Form_Load()
kr_frt$(1) = "#0.000": kr_frt$(2) = "#0.0000": kr_frt$(3) = "#0.0000"
kr_frt$(4) = "#0.0000": kr_frt$(5) = "#0.0000": kr_frt$(6) = "#0.0000"
formbl_x = 1: formbl_y = 1
If flag(2) = 1 Then
Call MSFlexGridshow
Else
'If OpeningDatabase = "" Then
'MsgBox "数据库无记录"
'Unload Me
'Me.Hide
'Else
MousePointer = 11
Call opendiaoyong(OpeningDatabase)
Call MSFlexGridshow
'End If
End If
MousePointer = 0
Me.Enabled = -1
Me.MousePointer = 1
' Call MSFlexGridshow
End Sub
'定义调用函数
Private Sub opendiaoyong(s As String)
Dim Count
Count = 0 '表中的记录数
Dim ss1, ss2 As Double
Count = 0 '表中的记录数
ss1 = 0: ss2 = 0 '合计
' MsgBox OpeningDatabase
On Error GoTo myerrr
''******************修改纪录***********************
Set Data1 = New ADODB.Connection
Data1.CursorLocation = adUseClient
Data1.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & s
Set adozjyyyhg = New ADODB.Recordset
adozjyyyhg.Open "select * from 投资表", Data1, adOpenStatic, adLockOptimistic
'Data1.Refresh
With adozjyyyhg
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -