📄 numberintever.frm
字号:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Object = "{65E121D4-0C60-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCHRT20.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Begin VB.Form numberintever
BorderStyle = 1 'Fixed Single
ClientHeight = 3705
ClientLeft = 45
ClientTop = 330
ClientWidth = 6480
Icon = "numberintever.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3705
ScaleWidth = 6480
StartUpPosition = 3 '窗口缺省
Begin MSAdodcLib.Adodc Adodc2
Height = 330
Left = 3600
Top = 840
Visible = 0 'False
Width = 2655
_ExtentX = 4683
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = 0
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\黄河风采副\黄河风采.mdb;Persist Security Info=False"
OLEDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\黄河风采副\黄河风采.mdb;Persist Security Info=False"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "基本间隔数据"
Caption = "Adodc2"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHFlexGrid2
Bindings = "numberintever.frx":08CA
Height = 1695
Left = 3210
TabIndex = 2
Top = 0
Width = 3285
_ExtentX = 5794
_ExtentY = 2990
_Version = 393216
Cols = 6
ScrollBars = 2
SelectionMode = 1
MergeCells = 3
_NumberOfBands = 1
_Band(0).Cols = 6
_Band(0).GridLinesBand= 1
_Band(0).TextStyleBand= 0
_Band(0).TextStyleHeader= 0
_Band(0)._NumMapCols= 6
_Band(0)._MapCol(0)._Name= "自编"
_Band(0)._MapCol(0)._RSIndex= 0
_Band(0)._MapCol(0)._Alignment= 7
_Band(0)._MapCol(0)._Hidden= -1 'True
_Band(0)._MapCol(1)._Name= "号码"
_Band(0)._MapCol(1)._RSIndex= 1
_Band(0)._MapCol(2)._Name= "间隔"
_Band(0)._MapCol(2)._RSIndex= 2
_Band(0)._MapCol(2)._Alignment= 7
_Band(0)._MapCol(3)._Name= "频次"
_Band(0)._MapCol(3)._RSIndex= 3
_Band(0)._MapCol(3)._Alignment= 7
_Band(0)._MapCol(4)._Name= "最近间隔"
_Band(0)._MapCol(4)._RSIndex= 4
_Band(0)._MapCol(4)._Alignment= 7
_Band(0)._MapCol(5)._Name= "间频比"
_Band(0)._MapCol(5)._RSIndex= 5
_Band(0)._MapCol(5)._Alignment= 7
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 360
Top = 840
Visible = 0 'False
Width = 2415
_ExtentX = 4260
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = 0
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\黄河风采副\黄河风采.mdb;Persist Security Info=False"
OLEDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\黄河风采副\黄河风采.mdb;Persist Security Info=False"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "分析间隔数据一"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSChart20Lib.MSChart MSChart1
Height = 1935
Left = 0
OleObjectBlob = "numberintever.frx":08DF
TabIndex = 1
Top = 1800
Width = 6495
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHFlexGrid1
Bindings = "numberintever.frx":2D86
Height = 1695
Left = 0
TabIndex = 0
Top = 0
Width = 3225
_ExtentX = 5689
_ExtentY = 2990
_Version = 393216
Cols = 6
ScrollBars = 2
SelectionMode = 1
MergeCells = 3
_NumberOfBands = 1
_Band(0).Cols = 6
_Band(0)._NumMapCols= 5
_Band(0)._MapCol(0)._Name= "自编"
_Band(0)._MapCol(0)._RSIndex= 0
_Band(0)._MapCol(0)._Alignment= 7
_Band(0)._MapCol(1)._Name= "号码"
_Band(0)._MapCol(1)._RSIndex= 1
_Band(0)._MapCol(2)._Name= "间隔组"
_Band(0)._MapCol(2)._RSIndex= 2
_Band(0)._MapCol(2)._Alignment= 7
_Band(0)._MapCol(3)._Name= "间隔频次"
_Band(0)._MapCol(3)._RSIndex= 3
_Band(0)._MapCol(3)._Alignment= 7
_Band(0)._MapCol(4)._Name= "间隔概率"
_Band(0)._MapCol(4)._RSIndex= 4
_Band(0)._MapCol(4)._Alignment= 7
End
End
Attribute VB_Name = "numberintever"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim intervalchart() As Variant
Private Sub Form_Load()
Me.Caption = givenumber + "间隔"
If nfleft <= 3800 Then
If nfleft + 6570 < 9600 Then
Me.Left = nfleft + 100
Else
Me.Left = 3000
End If
Me.Top = nftop - Me.Height + 200
Else
If nfleft - Me.Width > 0 Then
Me.Left = nfleft - Me.Width + 100
Else
Me.Left = 300
End If
Me.Top = nftop - Me.Height + 200
End If
'interval.adodc3.Refresh
'interval.adodc2.Refresh
MSHFlexGrid1.ColWidth(0, 0) = 0
MSHFlexGrid1.ColWidth(1, 0) = 0
MSHFlexGrid1.ColWidth(2, 0) = 500
MSHFlexGrid1.ColWidth(3, 0) = 650
MSHFlexGrid1.ColWidth(4, 0) = 900
MSHFlexGrid1.ColWidth(5, 0) = 900
MSHFlexGrid1.BackColorFixed = vbCyan
MSHFlexGrid1.BackColorSel = &HFF8080
MSHFlexGrid1.BackColor = &HFF8080
MSHFlexGrid1.MergeCol(2) = True
MSHFlexGrid1.MergeCol(4) = True
MSHFlexGrid1.MergeCol(5) = True
MSHFlexGrid2.ColWidth(0, 0) = 0
MSHFlexGrid2.ColWidth(1, 0) = 500
MSHFlexGrid2.ColWidth(2, 0) = 500
MSHFlexGrid2.ColWidth(3, 0) = 500
MSHFlexGrid2.ColWidth(4, 0) = 900
MSHFlexGrid2.ColWidth(5, 0) = 650
MSHFlexGrid2.BackColorFixed = vbCyan
MSHFlexGrid2.BackColorSel = &HFF8080
MSHFlexGrid2.BackColor = &HFF8080
MSHFlexGrid2.MergeCol(2) = True
MSHFlexGrid2.MergeCol(4) = True
MSHFlexGrid2.MergeCol(5) = True
'为mshflexgrid1赋值
Dim frenqucysum As Integer
Dim i As Integer
i = 1
frenqucysum = 0
interval.Adodc3.Recordset.Filter = "号码='" & givenumber & "'"
interval.Adodc3.Recordset.Requery
ReDim intervalchart(1 To interval.Adodc3.Recordset.RecordCount, 1 To 2) As Variant
interval.Adodc3.Recordset.MoveFirst
Do While Not interval.Adodc3.Recordset.EOF
frenqucysum = frenqucysum + interval.Adodc3.Recordset.Fields(3).Value
interval.Adodc3.Recordset.MoveNext
Loop
interval.Adodc3.Recordset.MoveFirst
Do While Not interval.Adodc3.Recordset.EOF
interval.Adodc3.Recordset.Fields(4).Value = Int((interval.Adodc3.Recordset.Fields(3).Value / frenqucysum) * 10000) / 10000
' interval.adodc3.Recordset.Fields(4).Value = Val(Left(Str(interval.adodc3.Recordset.Fields(3).Value / frenqucysum), 6))
intervalchart(i, 1) = Str(interval.Adodc3.Recordset.Fields(2).Value) + "间隔"
intervalchart(i, 2) = interval.Adodc3.Recordset.Fields(4).Value
interval.Adodc3.Recordset.MoveNext
i = i + 1
Loop
interval.Adodc3.Recordset.Requery
Set MSHFlexGrid1.DataSource = interval.Adodc3
MSHFlexGrid1.Refresh
' For i = 1 To interval.adodc3.Recordset.RecordCount
' MSHFlexGrid1.Col = 5
' MSHFlexGrid1.Row = i
' Debug.Print MSHFlexGrid1.Text
' MSHFlexGrid1.Text = Format(MSHFlexGrid1.Text, "##.##%")
' Debug.Print MSHFlexGrid1.Text
' Next i
'为mshflexgrid2赋值
interval.Adodc2.Recordset.Filter = "号码='" & givenumber & "'"
interval.Adodc2.Recordset.Requery
Set MSHFlexGrid2.DataSource = interval.Adodc2
MSHFlexGrid2.Refresh
'绘制图表
MSChart1.ChartData = intervalchart
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -