📄 frm_now.frm
字号:
Appearance = 0 'Flat
BackColor = &H80000005&
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 4815
Left = 8160
Picture = "Frm_Now.frx":030A
ScaleHeight = 4785
ScaleWidth = 6945
TabIndex = 4
Top = 120
Width = 6975
Begin MSComctlLib.ImageList ImageList1
Left = 360
Top = 1320
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 13
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":4C97
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":4FE9
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":53BB
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":574D
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":5A9F
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":5DF1
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":6143
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":64D5
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":68A7
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":6BF9
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":713B
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":7455
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Frm_Now.frx":776F
Key = ""
EndProperty
EndProperty
End
End
Begin VB.Timer Timer1
Interval = 1000
Left = 360
Top = 840
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 9255
Left = 120
TabIndex = 3
Top = 960
Width = 7935
_ExtentX = 13996
_ExtentY = 16325
_Version = 393216
Rows = 20
Cols = 4
FixedCols = 3
RowHeightMin = 400
BackColor = 16777215
ForeColor = 16711680
BackColorFixed = 12648384
ForeColorFixed = 16711680
BackColorSel = 16711935
BackColorBkg = 16777215
GridColor = 255
GridColorFixed = 16711680
GridLinesFixed = 1
SelectionMode = 1
Appearance = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.Label Lab_Week
AutoSize = -1 'True
BackColor = &H00FFFFC0&
Caption = "星 期 六"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 210
Left = 5760
TabIndex = 2
Top = 360
Width = 915
End
Begin VB.Label Lab_Time
AutoSize = -1 'True
BackColor = &H00FFFFC0&
Caption = "2006-07-01 08:00:00"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 210
Left = 2640
TabIndex = 1
Top = 360
Width = 2280
End
Begin VB.Label Label2
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H00FFFFC0&
Caption = "当 前 时 间 :"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 210
Index = 0
Left = 600
TabIndex = 0
Top = 360
Width = 1500
End
Begin VB.Shape Shape1
BackColor = &H00FFFFC0&
BackStyle = 1 'Opaque
BorderColor = &H000000FF&
Height = 735
Left = 120
Shape = 4 'Rounded Rectangle
Top = 120
Width = 7935
End
Begin VB.Menu M_Esc
Caption = "返 回 (&E)"
End
Begin VB.Menu M_Re
Caption = "刷 新 (&R)"
End
End
Attribute VB_Name = "Frm_Now"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Week_Day As String
Dim LB As String
Private Sub Form_Load()
Week_Day = Weekday(Now)
If Week_Day = "1" Then
Week_Day = " 星 期 日"
ElseIf Week_Day = "2" Then
Week_Day = " 星 期 一"
ElseIf Week_Day = "3" Then
Week_Day = " 星 期 二"
ElseIf Week_Day = "4" Then
Week_Day = " 星 期 三"
ElseIf Week_Day = "5" Then
Week_Day = " 星 期 四"
ElseIf Week_Day = "6" Then
Week_Day = " 星 期 五"
ElseIf Week_Day = "7" Then
Week_Day = " 星 期 六"
End If
Lab_Week = Week_Day
MSFlexGrid1.FormatString = "<站 号|站 名|^ 时 间 |库 水 位|入库流量|蓄 水 量|出库流量|"
Open_Data ("select * from ST_SKInfo ")
If rs.RecordCount > 0 Then
rs.MoveFirst
For i = 0 To 8
Lab1(i).Caption = Trim(rs.Fields(i) & "")
Next i
End If
M_Re_Click
End Sub
Private Sub M_Esc_Click()
Unload Me
End Sub
Private Sub M_Re_Click() '刷新
MSFlexGrid1.Rows = 1
MSFlexGrid1.Rows = 2
Open_Data ("select STCD,STNM from ST_STBPRP_B order by STCD")
If rs.RecordCount > 0 Then
MSFlexGrid1.Rows = rs.RecordCount + 1
For i = 1 To rs.RecordCount
If rs.EOF Then rs.MoveFirst
MSFlexGrid1.TextMatrix(i, 0) = rs.Fields(0)
MSFlexGrid1.TextMatrix(i, 1) = rs.Fields(1)
rs.MoveNext
Next i
End If
For i = 1 To MSFlexGrid1.Rows - 1
Open_Data ("select TM,Z,Q,XSA,XSAVV from ST_River_R where stcd='" & MSFlexGrid1.TextMatrix(i, 0) & "' order by tm desc")
If rs.RecordCount > 0 Then
For j = 1 To rs.RecordCount
If rs.EOF Then rs.MoveFirst
MSFlexGrid1.TextMatrix(i, 2) = Trim(rs.Fields(0) & "")
MSFlexGrid1.TextMatrix(i, 3) = Trim(rs.Fields(1) & "")
MSFlexGrid1.TextMatrix(i, 4) = Trim(rs.Fields(2) & "")
MSFlexGrid1.TextMatrix(i, 5) = Trim(rs.Fields(3) & "")
MSFlexGrid1.TextMatrix(i, 6) = Trim(rs.Fields(4) & "")
Next j
End If
Next i
MSFlexGrid1_Click
End Sub
Private Sub MSFlexGrid1_Click()
On Error GoTo Err:
Open_Data ("select * from ST_River_R where stcd='" & MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, 0) & "' order by tm desc")
If rs.RecordCount > 0 Then
If rs.EOF Then rs.MoveFirst
For i = 9 To 17
Lab1(i).Caption = Trim(rs.Fields(i - 3) & "")
Next i
End If
Err:
End Sub
Private Sub Timer1_Timer()
Lab_Time.Caption = Format(Now, "yyyy-mm-dd hh:mm:ss")
If Val(Hour(Now)) = 0 And Val(Minute(Now)) = 0 And Val(Second(Now)) = 1 Then
Week_Day = Weekday(Now)
If Week_Day = "1" Then
Week_Day = " 星 期 日"
ElseIf Week_Day = "2" Then
Week_Day = " 星 期 一"
ElseIf Week_Day = "3" Then
Week_Day = " 星 期 二"
ElseIf Week_Day = "4" Then
Week_Day = " 星 期 三"
ElseIf Week_Day = "5" Then
Week_Day = " 星 期 四"
ElseIf Week_Day = "6" Then
Week_Day = " 星 期 五"
ElseIf Week_Day = "7" Then
Week_Day = " 星 期 六"
End If
Lab_Week = Week_Day
End If
End Sub
Private Sub Timer2_Timer()
If Right(Minute(Now), 1) = 3 And Second(Now) = 0 Then
M_Re_Click
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -