📄 form5.frm
字号:
VERSION 5.00
Begin VB.Form 数据同步_BOF_1
Caption = "1#炉_数据同步-080615"
ClientHeight = 7965
ClientLeft = 60
ClientTop = 450
ClientWidth = 10245
LinkTopic = "Form1"
ScaleHeight = 7965
ScaleWidth = 10245
StartUpPosition = 3 '窗口缺省
Begin VB.Timer Timer3
Enabled = 0 'False
Left = 5460
Top = 60
End
Begin VB.CommandButton Cmd_Para
Caption = "手动刷新"
Height = 435
Left = 8460
TabIndex = 34
Top = 6180
Width = 1335
End
Begin VB.CommandButton Command3
Caption = "自动停止状态"
Height = 435
Left = 8460
TabIndex = 33
Top = 6840
Width = 1335
End
Begin VB.Frame Frame3
Caption = "BOF_SDM <<<- BOFCCM"
Height = 1695
Left = 5100
TabIndex = 27
Top = 5940
Width = 3315
Begin VB.CheckBox Check1
Caption = "动态系数"
Height = 315
Left = 1380
TabIndex = 38
Top = 1140
Width = 1455
End
Begin VB.TextBox Text3
Height = 390
Left = 1440
TabIndex = 28
Text = "2"
Top = 540
Width = 615
End
Begin VB.Label Label23
Caption = "模式表"
Height = 255
Left = 360
TabIndex = 32
Top = 360
Width = 855
End
Begin VB.Label Label22
Caption = "钢种标准"
Height = 255
Left = 240
TabIndex = 31
Top = 660
Width = 855
End
Begin VB.Label Label19
Caption = "(1-30分钟)"
Height = 255
Left = 2280
TabIndex = 30
Top = 600
Width = 975
End
Begin VB.Label Label18
Caption = "等等"
Height = 255
Left = 360
TabIndex = 29
Top = 960
Width = 615
End
End
Begin VB.CommandButton Command1
Caption = "自动停止状态"
Height = 435
Left = 8460
TabIndex = 24
Top = 4860
Width = 1335
End
Begin VB.CommandButton Cmd_SDM_TO_CCM
Caption = "手动刷新"
Height = 435
Left = 720
TabIndex = 14
Top = 6360
Width = 1335
End
Begin VB.CommandButton Cmd_CCM_TO_SDM
Caption = "手动刷新"
Height = 435
Left = 8460
TabIndex = 13
Top = 4320
Width = 1335
End
Begin VB.Frame Frame2
Caption = "BOF_SDM <<<- BOFCCM"
Height = 1515
Left = 5100
TabIndex = 9
Top = 4140
Width = 3255
Begin VB.CheckBox Check2
Caption = "生铁块实际值"
Height = 315
Left = 1380
TabIndex = 39
Top = 1140
Width = 1455
End
Begin VB.TextBox Text1
Height = 390
Left = 1440
TabIndex = 22
Text = "22"
Top = 540
Width = 615
End
Begin VB.Label Label14
Caption = "化验室值"
Height = 255
Left = 360
TabIndex = 26
Top = 960
Width = 855
End
Begin VB.Label Label13
Caption = "(20-60秒)"
Height = 255
Left = 2280
TabIndex = 12
Top = 600
Width = 855
End
Begin VB.Label Label12
Caption = "主原料-实际值"
Height = 255
Left = 120
TabIndex = 11
Top = 660
Width = 1515
End
Begin VB.Label Label11
Caption = "生产计划"
Height = 255
Left = 360
TabIndex = 10
Top = 360
Width = 855
End
End
Begin VB.Timer Timer1
Enabled = 0 'False
Interval = 60000
Left = 6420
Top = 60
End
Begin VB.CommandButton Command2
Caption = "自动停止状态"
Height = 435
Left = 2220
TabIndex = 3
Top = 6360
Width = 1335
End
Begin VB.Timer Timer2
Enabled = 0 'False
Left = 6900
Top = 60
End
Begin VB.Frame Frame1
Caption = "BOF_SDM ->>> BOFCCM"
Height = 1455
Left = 480
TabIndex = 0
Top = 4740
Width = 3315
Begin VB.CheckBox Check3
Caption = "动态系数"
Height = 315
Left = 1440
TabIndex = 40
Top = 1080
Width = 1455
End
Begin VB.TextBox Text2
Height = 375
Left = 1440
TabIndex = 23
Text = "22"
Top = 540
Width = 615
End
Begin VB.Label Label6
Caption = "操作员值"
Height = 315
Left = 240
TabIndex = 15
Top = 840
Width = 975
End
Begin VB.Label Label5
Caption = "静态计算值"
Height = 255
Left = 240
TabIndex = 2
Top = 480
Width = 975
End
Begin VB.Label Label7
Caption = "(20-60秒)"
Height = 255
Left = 2220
TabIndex = 1
Top = 660
Width = 855
End
End
Begin VB.Label Label27
Height = 315
Left = 120
TabIndex = 41
Top = 4320
Width = 4215
End
Begin VB.Label Label26
Height = 315
Left = 120
TabIndex = 37
Top = 3360
Width = 6855
End
Begin VB.Label Label25
Caption = "读钢种_失败次数："
Height = 255
Left = 7320
TabIndex = 36
Top = 3600
Width = 2175
End
Begin VB.Label Label24
Caption = "读钢种_成功次数："
Height = 255
Left = 7320
TabIndex = 35
Top = 3240
Width = 2175
End
Begin VB.Label Label8
Caption = "通讯状态："
Height = 255
Left = 7380
TabIndex = 25
Top = 2820
Width = 2175
End
Begin VB.Label Label4
Height = 315
Left = 60
TabIndex = 21
Top = 660
Width = 6855
End
Begin VB.Label Label21
Caption = "写计算值_失败次数："
Height = 255
Left = 7320
TabIndex = 20
Top = 2340
Width = 2175
End
Begin VB.Label Label20
Caption = "写计算值_成功次数："
Height = 255
Left = 7320
TabIndex = 19
Top = 1920
Width = 2175
End
Begin VB.Label Label17
Height = 315
Left = 180
TabIndex = 18
Top = 2700
Width = 6855
End
Begin VB.Label Label16
Height = 315
Left = 120
TabIndex = 17
Top = 2040
Width = 6855
End
Begin VB.Label Label15
Height = 315
Left = 120
TabIndex = 16
Top = 1320
Width = 6855
End
Begin VB.Label Label1
Caption = "数据刷新"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4020
TabIndex = 8
Top = 180
Width = 1215
End
Begin VB.Label Label2
Caption = "读实际值_失败次数："
Height = 255
Left = 7320
TabIndex = 7
Top = 1560
Width = 2175
End
Begin VB.Label Label3
Caption = "读实际值_成功次数："
Height = 255
Left = 7320
TabIndex = 6
Top = 1200
Width = 2175
End
Begin VB.Label Label9
Caption = "读计划_成功次数："
Height = 255
Left = 7320
TabIndex = 5
Top = 480
Width = 2175
End
Begin VB.Label Label10
Caption = "读计划_失败次数："
Height = 255
Left = 7320
TabIndex = 4
Top = 840
Width = 2175
End
End
Attribute VB_Name = "数据同步_BOF_1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public sql_SDM, sql_CCM As String
Public cn_SDM, cn_CCM As New ADODB.Connection
Public rs_SDM, rs_CCM As New ADODB.Recordset
Public sql_SDM2, sql_CCM2 As String
Public cn_SDM2, cn_CCM2 As New ADODB.Connection
Public rs_SDM2, rs_CCM2 As New ADODB.Recordset
Public sql2 As String
Public sql2_new As String
Public cn, cn_new As New ADODB.Connection
Public rs2 As New ADODB.Recordset
Public rs2_new As New ADODB.Recordset
Dim limited_const(69) As String
Dim temp_cal_coef(43) As String
Dim flux_coef() As String
Dim stat_coef1(46) As String
Dim stat_coef2() As String
Dim stat_self() As String
Dim sublance_coef() As Double
Dim sg_std() As String
Dim scrap_patt() As String
Dim std_temp() As String
Dim flux_data() As String
Dim production_plan() As String
Dim dyn_coef() As String
Dim dyn_coef_to_ccm() As String
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -