📄 frmqinfqiu.frm
字号:
End
Begin VB.TextBox Tv
Height = 315
Left = 720
TabIndex = 12
Top = 960
Width = 1095
End
Begin VB.TextBox Ta
Height = 315
Left = 3000
TabIndex = 11
Top = 960
Width = 1095
End
Begin VB.TextBox Tb
Height = 315
Left = 5280
TabIndex = 10
Top = 960
Width = 1095
End
Begin VB.TextBox Tc
Height = 315
Left = 7680
TabIndex = 9
Top = 960
Width = 1095
End
Begin VB.TextBox Tevent
Height = 315
Left = 2400
TabIndex = 8
Top = 480
Width = 1815
End
Begin VB.TextBox Tname
Height = 315
Left = 7680
TabIndex = 7
Top = 480
Width = 2415
End
Begin VB.Label Label8
BackStyle = 0 'Transparent
Caption = "4路电流："
Height = 255
Left = 6720
TabIndex = 30
Top = 1440
Width = 855
End
Begin VB.Label Label7
BackStyle = 0 'Transparent
Caption = "3路电流："
Height = 255
Left = 4440
TabIndex = 29
Top = 1440
Width = 855
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "2路电流："
Height = 255
Left = 2160
TabIndex = 28
Top = 1440
Width = 855
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "1路电流："
Height = 255
Left = 120
TabIndex = 27
Top = 1440
Width = 855
End
Begin VB.Label Label10
BackStyle = 0 'Transparent
Caption = "站号："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 26
Top = 480
Width = 615
End
Begin VB.Label Label11
BackStyle = 0 'Transparent
Caption = "时间："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 4320
TabIndex = 25
Top = 480
Width = 735
End
Begin VB.Label Label12
BackStyle = 0 'Transparent
Caption = "电压："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 24
Top = 960
Width = 615
End
Begin VB.Label Label13
BackStyle = 0 'Transparent
Caption = "A相电流(A)："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1920
TabIndex = 23
Top = 960
Width = 1215
End
Begin VB.Label Label14
BackStyle = 0 'Transparent
Caption = "B相电流(A)："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4200
TabIndex = 22
Top = 960
Width = 1215
End
Begin VB.Label Label15
BackStyle = 0 'Transparent
Caption = "C相电流(A)："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 6480
TabIndex = 21
Top = 960
Width = 1215
End
Begin VB.Label Label16
BackStyle = 0 'Transparent
Caption = "事件："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1920
TabIndex = 20
Top = 480
Width = 615
End
Begin VB.Label Label17
BackStyle = 0 'Transparent
Caption = "名称："
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7080
TabIndex = 19
Top = 480
Width = 975
End
End
Begin MCI.MMControl MMControl1
Height = 375
Left = 120
TabIndex = 33
Top = 5160
Width = 3540
_ExtentX = 6244
_ExtentY = 661
_Version = 393216
UpdateInterval = 800
DeviceType = ""
FileName = ""
End
End
Attribute VB_Name = "Frmqingqiu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim no As String '存储侦听到的消息为第几条消息
Dim rs As New ADODB.Recordset
Dim dbcn As New ADODB.Connection
Dim arr_return(40) As Variant '存储带%%的数据信息
Dim mess_index() As Variant '存储GSM模块返回的带有短消息编号的确认信息
Dim message(100) As Variant '存储读取短消息时的所有信息
Dim mess(19) As Variant '存储arr_return转化后的信息
Dim Value(11) As Variant '存储数据转化之后的信息，即最后的数值
Dim zhuanfa_no As Integer '记录侦听到的第几号站口,以供转发时使用
Dim intall As Integer '在Timer1控件中指示程序的流程，初始值为0
Dim strsql As String
Private Sub Combo1_Click()
If Combo1.Text <> "" Then
strsql = "SELECT name FROM data where id=" & Combo1.Text & ""
excutesql (strsql)
Text1.Text = rs!name
rs.Close
dbcn.Close
End If
End Sub
Private Sub CommandAsk_Click()
Dim Count As Integer
Tno.Text = "" '清空Text控件中的内容
Ttime.Text = ""
Tname.Text = ""
Tevent.Text = ""
Tv.Text = ""
Ta.Text = ""
Tb.Text = ""
Tc.Text = ""
For Count = 0 To 7 '设置Shape控件的颜色为绿色
Shape1(Count).FillColor = &H80FF80
Next
If Combo1.Text <> "" Then '如果用户选择的站不为空
strsql = "select * from zhankou where id=" & Combo1.Text & ""
excutesql (strsql) '根据站号获得该站是否出于活动状态，只能够对处于活动状态的站请求数据，
If rs!ifactive = 1 Then
MDIForm1.Comm1.Output = "AT+CMGS=" + rs!tel + Chr(13) + Chr(13) + Chr(10)
'发送AT指令
rs.Close
dbcn.Close
Timer1.Enabled = True
Else
MsgBox "您所呼叫的站口并没有处于运行状态!", vbOKOnly, "通知"
Exit Sub
End If
Else
MsgBox "请输入您所要呼叫的对象！", vbOKOnly, "通知"
End If
End Sub
Private Sub Form_Load()
intall = 0
Combo1.Clear '清空ComboBox的下拉列表项
strsql = "SELECT id,sum(v) FROM data GROUP BY id;"
'取得呼叫对象的编号，以及该对象的数量
excutesql (strsql)
While Not rs.EOF '将所有的呼叫对象编号插入到ComboBox控件中
If rs!id <> "" Then
Combo1.AddItem (rs!id)
End If
rs.MoveNext
Wend
rs.Close
dbcn.Close
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -