基于高级编程语言WINCC复杂报表管理的实现

华电技术 ›› 2011, Vol. 33 ›› Issue (11): 54-56.

基于高级编程语言WINCC复杂报表管理的实现

徐志杰

国电南自新能源科技有限公司，江苏南京210032

收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2011-11-25

Realization of complex report management based on high level programming language WINCC

XU Zhijie

Guodian Nanjing Automation New Energy Technology Company Limited, Nanjing 210032, China

Received:1900-01-01 Revised:1900-01-01 Published:2011-11-25

摘要/Abstract

摘要： 介绍了在某电厂烟尘减排控制系统上位机监控系统中采用高级编程语言(VB)和脚本编程语言VBSCRIPT与WINCC下的SQL2005数据库进行接口的方法，完成了过程历史数据的存储和读取。通过调用Spread Active控件进而实现复杂报表的查询和打印，可方便地输出为Excel和HTML文件。对数据的二次梳理进行了分析，为以B/S模式访问过程运行数据提供了接口。

关键词: 高级编程语言(VB), WINCC软件, SQL2005数据库, 报表管理

Abstract: In the upper computer monitoring system of the soot emission reducing control system of a power plant, the high level programming language (VB) and the script programming language VBSCRIPT were used to interface with SQL2005 database under WINCC, and the interface method was introduced. By using this method, the storage and reading out of procedure history data were accomplished. By calling the spread active controls, the query and print of complex reports can be realized, and Exceland HTML files can be output easily. The recombing of the data was analyzed, which provides interface to access procedure operation data in B/S mode.

Key words: high level programming language, WINCC software, SQL2005 database, report management

徐志杰. 基于高级编程语言WINCC复杂报表管理的实现[J]. 华电技术, 2011, 33(11): 54-56.

XU Zhijie. Realization of complex report management based on high level programming language WINCC[J]. Huadian Technology, 2011, 33(11): 54-56.