📄 hisform2.frm
字号:
VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form HisForm2
BorderStyle = 0 'None
Caption = "Form1"
ClientHeight = 11520
ClientLeft = 0
ClientTop = 0
ClientWidth = 15360
LinkTopic = "Form1"
ScaleHeight = 11520
ScaleWidth = 15360
ShowInTaskbar = 0 'False
Begin VB.Frame Frame1
BackColor = &H00FFFFC0&
Height = 10620
Left = 13140
TabIndex = 0
Top = 840
Width = 2175
Begin VB.CommandButton Cdata
Caption = "灌溉记录"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 7
Top = 3600
Width = 1545
End
Begin VB.CommandButton Cmdset
Caption = "系统设置"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 6
Top = 6480
Width = 1545
End
Begin VB.CommandButton Cmdzn
Caption = "应用指南"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 315
TabIndex = 5
Top = 7875
Width = 1545
End
Begin VB.CommandButton Cmdxx
Caption = "环境信息"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 4
Top = 5040
Width = 1545
End
Begin VB.CommandButton Cmdzt
Caption = "阀门状态"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 3
Top = 2177
Width = 1545
End
Begin VB.CommandButton Cmdbz
Caption = "阀门编组"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 2
Top = 750
Width = 1545
End
Begin VB.CommandButton Cmdquit
Caption = "退 出"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Left = 300
TabIndex = 1
Top = 9315
Width = 1545
End
End
Begin VB.Frame Frame2
BackColor = &H00FFFFC0&
Height = 10620
Left = 60
TabIndex = 8
Top = 840
Width = 13065
Begin VB.CommandButton Cquit
Caption = "关 闭"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 525
Left = 5880
TabIndex = 18
Top = 9570
Width = 1485
End
Begin MSDBGrid.DBGrid DBGrid1
Bindings = "HisForm2.frx":0000
Height = 9075
Left = 60
OleObjectBlob = "HisForm2.frx":0014
TabIndex = 16
Top = 150
Width = 12945
End
Begin VB.TextBox Text1
DataField = "土壤温度"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 9
Text = "Text1"
Top = 2070
Width = 2235
End
Begin VB.TextBox Text2
DataField = "土壤水分1"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 10
Text = "Text2"
Top = 2734
Width = 2235
End
Begin VB.TextBox Text3
DataField = "土壤水分2"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 11
Text = "Text3"
Top = 3398
Width = 2235
End
Begin VB.TextBox Text4
DataField = "土壤水分3"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 12
Text = "Text4"
Top = 4062
Width = 2235
End
Begin VB.TextBox Text6
DataField = "气象温度"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 13
Text = "Text6"
Top = 5390
Width = 2235
End
Begin VB.TextBox Text7
DataField = "气象湿度"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 14
Text = "Text7"
Top = 6054
Width = 2235
End
Begin VB.TextBox Text8
DataField = "记录时间"
DataSource = "Data2"
Height = 405
Left = 8430
TabIndex = 17
Text = "Text8"
Top = 6630
Width = 2295
End
Begin VB.TextBox Tdata
DataField = "土壤温度"
DataSource = "Data2"
Height = 495
Left = 11010
TabIndex = 19
Text = "Text5"
Top = 2010
Width = 1095
End
Begin VB.TextBox Ttime
DataField = "记录时间"
DataSource = "Data2"
Height = 495
Left = 11010
TabIndex = 20
Text = "Text5"
Top = 6570
Width = 1005
End
Begin VB.TextBox Text9
DataField = "序号"
DataSource = "Data2"
Height = 435
Left = 8430
TabIndex = 21
Text = "Text9"
Top = 7230
Width = 2265
End
End
Begin VB.Data Data2
Caption = "Data2"
Connect = "Access 2000;"
DatabaseName = "C:\Documents and Settings\ljq\桌面\CAN(7518d)\dust.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 645
Left = 3000
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "环境信息表"
Top = 8460
Width = 1845
End
Begin VB.Label Label12
BackStyle = 0 'Transparent
Caption = "节水灌溉智能监控系统"
BeginProperty Font
Name = "宋体"
Size = 26.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000080FF&
Height = 540
Left = 4320
TabIndex = 15
Top = 210
Width = 7545
End
End
Attribute VB_Name = "HisForm2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
On Error GoTo errhandler
Data2.DatabaseName = App.Path & "\data\dust.mdb"
'Data2.DatabaseName = WinDir & "\" & "\system32\" & "dust.mdb"
Data2.RecordSource = "SELECT * FROM 环境信息表 order by 序号"
Data2.Refresh
Data2.Recordset.MoveLast
datan = Data2.Recordset.RecordCount
Exit Sub
errhandler:
Call MsgBox("数据库文件不存在！", vbOKOnly, "警告！")
End Sub
'获得环境信息数据
Public Sub his_data2()
If Data2.Recordset.RecordCount <> 0 Then
Data2.Recordset.MoveLast
Data2.Recordset.AddNew
End If
Text1.Text = xxForm.Label14.Caption
'Text2.Text = xxForm.Label16.Caption
'Text3.Text = xxForm.Label10.Caption
'Text4.Text = xxForm.Label12.Caption
'Text6.Text = xxForm.Label2.Caption
'Text7.Text = xxForm.Label4.Caption
Text8.Text = Date & Time
datan = datan + 1
Text9.Text = datan
Data2.Recordset.AddNew
End Sub
Public Sub get_hisdata()
Data2.DatabaseName = App.Path & "\data\dust.mdb"
'Data2.DatabaseName = WinDir & "\" & "\system32\" & "dust.mdb"
Data2.RecordSource = "SELECT * FROM 环境信息表 order by 序号"
Data2.Refresh
Data2.Recordset.MoveLast
tempnum = Data2.Recordset.RecordCount
If tempnum <> 0 Then
Data2.Recordset.MoveFirst
For i = 0 To tempnum - 1
tempdata(i, 1) = Tdata.Text
tempdata(i, 10) = Ttime.Text
Data2.Recordset.MoveNext
Next i
End If
End Sub
Private Sub Cquit_Click()
xxForm.Show
Unload Me
End Sub
Private Sub Cmdbz_Click()
TeamForm.Show
End Sub
Private Sub Cmdzt_Click()
filedForm.Show
End Sub
Private Sub Cmdxx_Click()
xxForm.Show
End Sub
Private Sub Cdata_Click()
HisForm.Show
Call HisForm.get_cdata
End Sub
Private Sub Cmdset_Click()
commandbz = 2
PassForm.Show
End Sub
Private Sub Cmdzn_Click()
GuideForm.Show
End Sub
Private Sub Cmdquit_Click()
commandbz = 3
PassForm.Show
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -