📄 frmpro.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 = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.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 frmpro
Caption = "生产动态数据"
ClientHeight = 8025
ClientLeft = 2055
ClientTop = 1635
ClientWidth = 12315
Icon = "frmpro.frx":0000
LinkTopic = "Form1"
ScaleHeight = 8025
ScaleWidth = 12315
Begin ComCtl2.UpDown UpDown1
Height = 495
Left = 5160
TabIndex = 8
Top = 6960
Width = 255
_ExtentX = 450
_ExtentY = 873
_Version = 327681
Enabled = -1 'True
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 6120
Top = 6720
_ExtentX = 847
_ExtentY = 847
_Version = 393216
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 = 4320
TabIndex = 5
Text = "10"
Top = 6960
Width = 855
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 375
Left = 0
TabIndex = 4
Top = 7650
Width = 12315
_ExtentX = 21722
_ExtentY = 661
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 2
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 18627
EndProperty
BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
Text = "帮助请按F1"
TextSave = "帮助请按F1"
EndProperty
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin Threed.SSCommand SSCommand1
Height = 855
Left = 7200
TabIndex = 2
Top = 6720
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1508
_StockProps = 78
Caption = "调用数据"
ForeColor = 255
Picture = "frmpro.frx":0442
End
Begin Threed.SSPanel SSPanel1
Height = 6375
Left = 0
TabIndex = 0
Top = 120
Width = 12135
_Version = 65536
_ExtentX = 21405
_ExtentY = 11245
_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 = "Arial"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 495
Left = 960
TabIndex = 9
Top = 1440
Width = 855
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 6135
Left = 120
TabIndex = 1
Top = 120
Width = 11895
_ExtentX = 20981
_ExtentY = 10821
_Version = 393216
Cols = 3
FixedCols = 2
RowHeightMin = 510
BackColor = 16777215
BackColorFixed = 12632256
ForeColorFixed = 12582912
ForeColorSel = 16777215
BackColorBkg = 14737632
FillStyle = 1
ScrollBars = 2
MergeCells = 3
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 SSCommand2
Height = 855
Left = 8760
TabIndex = 3
Top = 6720
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1508
_StockProps = 78
Caption = "数据保存"
ForeColor = 255
Picture = "frmpro.frx":0D1C
End
Begin Threed.SSPanel SSPanel2
Height = 495
Left = 240
TabIndex = 6
Top = 6960
Width = 3975
_Version = 65536
_ExtentX = 7011
_ExtentY = 873
_StockProps = 15
Caption = "经济评价生产年限修改："
ForeColor = 255
BackColor = 12640511
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "楷体_GB2312"
Size = 15.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BorderWidth = 2
BevelOuter = 1
FloodColor = 8421631
End
Begin Threed.SSCommand SSCommand3
Height = 855
Left = 10200
TabIndex = 7
Top = 6720
Width = 1095
_Version = 65536
_ExtentX = 1931
_ExtentY = 1508
_StockProps = 78
Caption = "退 出"
ForeColor = 255
Picture = "frmpro.frx":1396
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 = "frmpro"
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 As Integer
Dim xx(50), yy(50) As Single
Dim tval As Single
Dim kr_frt$(1 To 10)
Dim sat_max As Integer
Dim filename1 As String
' 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()
SSCommand2.Caption = "数据保存"
StatusBar1.Panels(1) = "修改经济评价生产年限后，请按回车键；右键单击可以对数据表进行删除、添加等操作！"
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"
formbl_x = 1: formbl_y = 1
'flag(1) = 0
If newis = 1 Then
Call MSFlexGridshow
Else
Dim Count
MousePointer = 11
Count = 0
Set Data1 = New ADODB.Connection
Data1.CursorLocation = adUseClient
Data1.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & OpeningDatabase
Set adozjyyyhg = New ADODB.Recordset
adozjyyyhg.Open "select * from 数据输入表", Data1, adOpenStatic, adLockOptimistic
'Data1.Refresh
With adozjyyyhg
' .OpenRecordset
If (.EOF = True) And (.BOF = True) Then
'MsgBox "数据库无记录"
Exit Sub
Else
.MoveFirst
Do While .EOF = False
Count = Count + 1
.MoveNext
Loop
'MsgBox "数据库共有" & Count & "条记录"
End If
End With
VarPingJiaQi = Count
TxtNianXian.Text = Str(Count)
'Data1.Refresh
adozjyyyhg.MoveFirst
For i = 1 To Count
For k = 1 To 7
'MsgBox Data1.Recordset.Fields(k).
TempS = adozjyyyhg.Fields(k).Value
VarShengCheng(i, k + 1) = Val(TempS)
Next k
adozjyyyhg.MoveNext
Next i
adozjyyyhg.Close
For i = 1 To Count
VarShengCheng(i, 1) = i
Next i
Call MSFlexGridshow
End If
MousePointer = 0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -