求高人帮我看看这段程序哪里有问题,万谢!

已锁定

Allen(艾伦)

  • 帖子

    2
  • 精华

    0
  • 被关注

    0

论坛等级:新手

注册时间:2017-05-31

普通 普通 如何晋级?

求高人帮我看看这段程序哪里有问题,万谢!

464

5

2017-07-05 09:00:44

求高人帮我看看这段程序哪里有问题,万谢!


Sub OnClick(ByVal Item)          


Dim dataname,m
Dim ltimebegin,ltimeend,utctimebegin,utctimeend
Dim scon,ssql,ors,ocom
Dim mint,moutt,boutt,bint

item.Enabled=False
On Error Resume Next

Set dataname = HMIRuntime.Tags("@DatasourceNameRT").Read
Set ltimebegin = HMIRuntime.Tags("tag_timebegin").Read
Set ltimeend = HMIRuntime.Tags("tag_timeend").Read

Msgbox "open with:"&dataname &ltimebegin

utctimebegin = Dateadd("h",-8,ltimebegin.value)
utctimeend = Dateadd("h",-8,ltimeend.value)

utctimebegin = Year(utctimebegin) & "-" & Month(utctimebegin) & "-" & Day(utctimebegin) & " " & Hour(utctimebegin) & ":" & Minute(utctimebegin) & ":" & Second(utctimebegin)
utctimeend = Year(utctimeend) & "-" & Month(utctimeend) & "-" & Day(utctimeend) & " " & Hour(utctimeend) & ":" & Minute(utctimeend) & ":" & Second(utctimeend)

scon = "Provider=WinCCOLEDBProvider.1; Catalog='&dataname.value&'; Data Source=ES.\WinCC"

Set conn = CreateObject("ADODB.Connection")
   conn.ConnectionString = scon
   conn.CursorLocation = 3
   conn.Open
   
ssql = "Tag:R,('lsw\branch_intemperature,lsw\branch_outtemperature,lsw\main_outtemperature,lsw\main_intemperature'),'"&utctimebegin&"','"&utctimeend&"'"
ssql = ssql + "order by timestamp ASC"

MsgBox "open with:" &vbCr & scon &vbCr &ssql &vbCr

Set ors = CreateObject("ADODB.Recordset")
Set ocom = CreateObject("ADODB.Command")
   ocom.CommandType = 1
Set ocom.ActiveConnection = conn
   ocom.CommandText = ssql        
Set ors=ocom.Execute

m=ors.RecordCount

If m > 0 Then
   bint = ors.fields(0).value
   boutt = ors.fields(1).value
   moutt = ors.fields(2).value
   mint = ors.fields(4).value
Else
   MsgBox "没有查询到数据............."
   item.Enabled=True
   Set ors=Nothing
       conn.close
   Set conn=Nothing
End If

Set ors=Nothing
   conn.close
Set conn=Nothing

HMIRuntime.Tags("branch_int").Write bint
HMIRuntime.Tags("branch_outt").Write boutt
HMIRuntime.Tags("main_int").Write mint
HMIRuntime.Tags("main_outt").Write moutt

End Sub
求高人帮我看看这段程序哪里有问题,万谢! 已锁定
编辑推荐: 关闭

请填写推广理由:

本版热门话题

SIMATIC WinCC / Panel

共有32574条技术帖

相关推荐

热门标签

相关帖子推荐

guzhang

恭喜,你发布的帖子

评为精华帖!

快扫描右侧二维码晒一晒吧!

再发帖或跟帖交流2条,就能晋升VIP啦!开启更多专属权限!

  • 分享

  • 只看
    楼主

top
您收到0封站内信:
×
×
信息提示
很抱歉!您所访问的页面不存在,或网址发生了变化,请稍后再试。