摘要
描述了如何运用PLC及西门子上位监控软件WinCC V6.2中集成的VBS脚本在发动机检测线将实时测试参数记录到数据库中,并最终通过用户查询,以报表的形式打印出来。系统由PLC控制,由WinCC通过西门子专用通道,以变量标签的形式将实时数据采集后并用VBS脚本编写标准的SQL语句将实时信息插入到数据库。通过使用ADO控件实现访问数据库。采用微软标准的ListView可视化控件来显示查询的结果。系统运行良好,可以很方便地采集、存储、查看电动机测试数据。
This article describes how to use PLC and integrated VBS script of Siemens WinCC V6.2 monitoring software to record real-time test parameters to the database in the engine test line and finally print out with the form of reports by the user query.The Ssystem is controlled by the PLC,the real-time data is collected in the form of variable label by WinCC using Siemens dedicated channel,and then a VBS script is used to write standard SQL statements to insert the real-time information into the database.To achieve access to the database by using the ADO control and display the query results by using Microsoft standard,visual control of ListView.The sSystem is running well,and we can easily collect,store,view the motor test data.
出处
《电脑开发与应用》
2012年第3期57-59,共3页
Computer Development & Applications