基于WinCC的堆场管理与自动化系统的设计与实现
摘要
随着经济全球化和贸易自由化的不断深入和发展,货物的集装箱运输已经成为-种先进的、高效的、快速的现代化运输方式。集装箱堆场,作为集装箱运输的枢纽,衔接着内陆和沿海的集装箱港口和码头,在集装箱运输中发挥着极其重要的作用。提高集装箱堆场的管理水平和设备的自动化程度是提升装卸作业效率的重要手段。组态软件作为自动化技术、网络技术、计算机技术发展的产物,被广泛应用于工业自动化控制领域的过程通信和过程可视化,为构筑满足用户要求的管理信息系统提供了强大的技术支撑。
本论文主要对基于WinCC的堆场管理与自动化系统的设计与开发进行了比较详尽的描述,最终实现了基于WinCC的堆场管理与自动化系统。堆场管理与自动化系统是以组态软件WinCC作为系统开发的核心,辅以VB开发的数据采集处理程序共同构成了整个系统。系统通过集装箱起重吊装平台模型提供的PLC编程接口访问和处理PLC中的数据。WinCC负责过程画面显示、设备控制、过程数据归档与显示、报警记录归档与显示等模块的设计与开发。VB开发的数据采集处理程序模块主要包括集装箱自动化入场、场内集装箱查询、箱位使用情况查询、集装箱自动化出场。同时专门设计了后台数据库。
论文也详细介绍了组态软件WinCC与集装箱起重吊装平台模型PLC的通信方法以及VB数据采集处理程序访问数据库的方法。WinCC与PLC的通信,采用OPC技术实现WinCC和PLC编程接口的通信连接。而VB数据采集处理程序则采用ADO对象模型实现与后台数据库服务器的数据交互。
本系统在实验室环境下进行了多次测试。测试结果表明,本系统具备数据采集与处理功能、具备过程操控和报警功能。系统运行稳定。
With the deepening of economic globalization and trade liberalization, container transport of goods has been an advanced, efficient and rapid modern mode of transportation. Container yard, as the hub of container transport, is connecting the inland and coastal container ports and terminals. It plays an extremely important role in container transportation. Improving the management level of container yard and equipment automation degree is an important means to improve operation efficiency. Configuration software is a product of the development of automation technology, computer technology and network technology. It is widely used in processing communication and visualization in the field of industrial automation control. It provides a powerful technical support to meet the users'requirements of the management information system.
In this thesis, the design and implementation of yard management and automation system based on WinCC have been described in detail. In the end, the system has been achieved. About them, on the one hand the software that is named WinCC has been taken as the core of system development, on the other hand data acquisition and processing procedures that developed by VB have been supplemented. And through the PLC programming interface which is provided by the model of container lifting platform, the data in PLC has been accessed and processed. WinCC is responsible for design and development of many modules which contain the display of process picture, equipment control, archive and display of data, and the archive and display of alarm records. The module of data acquisition and processing procedures that developed by VB includes containers entry automated, containers query, query of space usage, containers out automated. In addition to that, the back-end database has been designed.
Besides that, communication method between WinCC and PLC has been described in detail, and the method of data acquisition and processing procedures by VB to access database has also been described. Using OPC technology, WinCC can communicate with PLC, besides that, the OPC can complete the communication by connecting WinCC and PLC programming interface. Using ADO object model, Data acquisition and processing procedures of VB has achieved data exchange with the back-end database server.
This system has been tested for many times in laboratory environment. Test results have showed that this system has completed the function of field data acquisition and processing, besides that it also has completed the functions of process control and alarm. The system runs stably.
本论文主要对基于WinCC的堆场管理与自动化系统的设计与开发进行了比较详尽的描述,最终实现了基于WinCC的堆场管理与自动化系统。堆场管理与自动化系统是以组态软件WinCC作为系统开发的核心,辅以VB开发的数据采集处理程序共同构成了整个系统。系统通过集装箱起重吊装平台模型提供的PLC编程接口访问和处理PLC中的数据。WinCC负责过程画面显示、设备控制、过程数据归档与显示、报警记录归档与显示等模块的设计与开发。VB开发的数据采集处理程序模块主要包括集装箱自动化入场、场内集装箱查询、箱位使用情况查询、集装箱自动化出场。同时专门设计了后台数据库。
论文也详细介绍了组态软件WinCC与集装箱起重吊装平台模型PLC的通信方法以及VB数据采集处理程序访问数据库的方法。WinCC与PLC的通信,采用OPC技术实现WinCC和PLC编程接口的通信连接。而VB数据采集处理程序则采用ADO对象模型实现与后台数据库服务器的数据交互。
本系统在实验室环境下进行了多次测试。测试结果表明,本系统具备数据采集与处理功能、具备过程操控和报警功能。系统运行稳定。
With the deepening of economic globalization and trade liberalization, container transport of goods has been an advanced, efficient and rapid modern mode of transportation. Container yard, as the hub of container transport, is connecting the inland and coastal container ports and terminals. It plays an extremely important role in container transportation. Improving the management level of container yard and equipment automation degree is an important means to improve operation efficiency. Configuration software is a product of the development of automation technology, computer technology and network technology. It is widely used in processing communication and visualization in the field of industrial automation control. It provides a powerful technical support to meet the users'requirements of the management information system.
In this thesis, the design and implementation of yard management and automation system based on WinCC have been described in detail. In the end, the system has been achieved. About them, on the one hand the software that is named WinCC has been taken as the core of system development, on the other hand data acquisition and processing procedures that developed by VB have been supplemented. And through the PLC programming interface which is provided by the model of container lifting platform, the data in PLC has been accessed and processed. WinCC is responsible for design and development of many modules which contain the display of process picture, equipment control, archive and display of data, and the archive and display of alarm records. The module of data acquisition and processing procedures that developed by VB includes containers entry automated, containers query, query of space usage, containers out automated. In addition to that, the back-end database has been designed.
Besides that, communication method between WinCC and PLC has been described in detail, and the method of data acquisition and processing procedures by VB to access database has also been described. Using OPC technology, WinCC can communicate with PLC, besides that, the OPC can complete the communication by connecting WinCC and PLC programming interface. Using ADO object model, Data acquisition and processing procedures of VB has achieved data exchange with the back-end database server.
This system has been tested for many times in laboratory environment. Test results have showed that this system has completed the function of field data acquisition and processing, besides that it also has completed the functions of process control and alarm. The system runs stably.
引文
[1]吴广强.基于Web的铁路物流企业集装箱信息系统的研究与实现[D].中国铁道科学研究院,2012
[2]包起帆.现代港口集装箱物流创新技术研究与应用[C]//中国广东广州：第七届海内外青年设计与制造科学会议论文集.2006
[3]周天星,刘澜.铁路集装箱物流管理信息系统分析[J].综合运输.2003,(11)：39-41
[4]何华.深入浅出西门子WinCC V6[M].北京航空航天大学出版社,2004
[5]张晓杰,刘海昌.基于WinCC的数据采集和监控系统设计[J].工业仪表与自动化装置.2007,(4)：53-55
[6]Vis I F A, de Koster R, Roodbergen K J, et al. Determination of the number of automated guided vehicles required at a semi-automated container terminal [J]. Journal of the Operational Research Society.2001:409-417
[7]王力,朱晓宁,闫伟,等.铁路集装箱中心站堆场混堆优化模型[J].交通运输系统工程与信息.2013,13(2)：172-178
[8]彭传圣.汉堡港的自动化集装箱码头[J].集装箱化.2005,(2)：21.23
[9]张竹.区域集装箱物流信息系统的设计与实现[D].重庆大学,2007
[10]韩晓龙.集装箱港口装卸作业资源配置研究[D].上海海事大学,2005
[11]邱惠清,卢凯良.国际自动化集装箱码头技术发展述评[J].自主创新实现物流工程的持续与科学发展——第八届物流工程学术年会论文集,2008
[12]王洪雪,雷黎黎.集装箱堆场箱位最优分配[J].交通科技与经济.2013,15(001)：50-53
[13]丁以中,费红英,韩晓龙.港口集装箱物流研究现状与分析[J].上海海运学院学报.2004,25(2)：45-54
[14]张春海,刘波,李华.基于事件驱动模型的集装箱物流信息系统[J].计算机工程.2005,31(17)
[15]郑见粹,李海波,谢文宁,等.自动化集装箱码头装卸工艺系统比较研究[J].水运科学研究.2011,7(2)：26-33
[16]包起帆.集装箱电子标签系统的研究和应用介绍[J].港口装卸.2005,(5)：51.56
[17]张玉洁,刘军,贾利民等RFID技术在铁路集装箱堆场进出的应用[J].物流科技.2008,(2)
[18]黄琪,黄卜夫.基于C/S体系结构的集装箱MIS系统设计[J].计算机工程与应用.2003,39(3)：211-212
[19]杨芙清.软件工程技术发展思索[J].软件学报.2005,16(1)
[20]何苗.基于WinCC的港口起重机移动监控系统的研究与应用[D].武汉理工大学自动化学院,2006
[21]钱宏,施荣华.基于OPC技术的B/S模式生产调度系统的研究与实现[J].微计算机信息.2010(034)：50-52
[22]Microsoft Corporation. Microsoft SQL Server 2000 Transact-SQL和技术参考手册[M].科学出版社,2001
[23]Anley C. Advanced SQL injection in SQL server applications[J]. White paper, Next Generation Security Software Ltd,2002
[24]Agrawal S, Chaudhuri S, Narasayya V. Materialized view and index selection tool for Microsoft SQL Server 2000[C]//ACM SIGMOD Record. ACM,2001,30(2):608
[25]陶宏才.数据库原理及设计[M].清华大学出版社,2004
[26]Kohler K E, Gill S M. Coral Point Count with Excel extensions (CPCe):A Visual Basic program for the determination of coral and substrate coverage using random point count methodology[J]. Computers & Geosciences,2006,32(9):1259-1269
[27]Zak, Diane.Programming with Microsoft Visual Basic 6.0[M]. Beijing:Publishing House of Electronics Industry;Thomson Learning,2002
[28]杨力,李月恒,于智.基于WinCC V6.2的VB脚本操作自定义SQL数据库[J].工业控制计算机.2010(009)：7.8
[29]Dobson R. Programming Microsoft SQL Server 2000 with Microsoft Visual Basic. NET[M]. Microsoft Press,2002
[30]马俊朋,杨钢.工业组态软件WinCC及其在水电站自动化中的应用[J].微计算机信息.2006,22(31)：62-64
[31]邹彤.WinCC组态软件的编程技巧[J].化工自动化及仪表.2001,28(2)：63.64
[32]杨路明,雷亚军.组态软件WinCC在自动监控系统中的应用[J].计算技术与自动化.2003,(12)：22-24
[33]吕涌,皇甫正贤.组件化结构的组态软件的研究与开发[J].电气自动化.2000,22(005)：46-48
[34]欧金城,欧世乐,林德杰,等.组态软件的现状与发展.工业控制计算机[J].2002,(5)：10-12
[35]朱荣.基于WinCC的天然气门站SCADA系统上位监控软件研制[D].西南交通大学,2010
[36]袁楚明,谌彦,周敬东,等.实时多任务工业监控组态软件的研究与开发[J].机械与电子.2004,2(3)：43-46
[37]Siemens A G, IA I S. Home-Automation technology-SIMATIC HMI Operator Control and Monitoring Systems-HMI software-SCADA system SIMATIC WinCC-SIMATIC WinCC options-WinCC/IndustrialDataBridge[J].2012
[38]YANG L, LEI Y. Application of Configuration Software WinCC in Automation Monitor System [J]. Computing Technology and Automation,2003,4:006
[39]Wang X, Du J, Qi L, et al. Supervision Control System of Chemical Industry Based on WinCC [J]. Control and Instruments in Chemical Industry,2006,33(5):41
[40]Siemens A G. WinCC v5 The configuration manual and the communication manual[J]. Germany:Siemens,2000
[41]Zheng M G, Zhu X H. Design of Tower Crane Intelligent Monitoring Management System Based on PLC and WinCC[J]. Applied Mechanics and Materials,2012,184: 1554-1557
[42]ZHANG X, LIU H. The design of data acquisition and supervisory system based on WinCC [J]. Industrial Instrumentation & Automation,2007, (4):017
[43]ZHU Y, YE H, LIU C. Using WinCC to Monitor and Control the Mechatronic System [J]. Instrument Technique and Sensor,2004, (6):009
[44]梁棉鑫,罗艳红,边春元,等.WinCC基础及应用开发指南[M].机械工业出版社,2009
[45]Tan Q S W. Programming OPC Client Using VB to Visit WinCC[J]. Anhui Metallurgy, 2011,4:012
[46]Schleipen M. OPC UA supporting the automated engineering of production monitoring and control systems[C]//Emerging Technologies and Factory Automation,2008. ETFA 2008. IEEE International Conference on. IEEE,2008:640-647
[47]Zheng L, Nakagawa H. OPC (OLE for process control) specification and its developments[C]//SICE 2002. Proceedings of the 41st SICE Annual Conference. IEEE, 2002,2:917-920
[48]张宁,薛士龙,陈加敏,等.基于OPC技术的自动化集装箱码头监控系统设计[J].上海海事大学学报.2011,32(1)：21.24
[49]邓全亮,邹益仁.基于OPC技术的系统集成[J].计算机应用研究.2005,22(1)：160-161
[50]Abraham Silberschatz, Henry F.Korth, S.Sudarshan.数据库系统概念[M].杨东,马秀莉等译.第5版.机械工业出版社,2006
[51]王聪华.ADO访问数据库实例剖析[J].计算机应用研究.2002,19(5)：159-160
[52]徐枫,马国之,刘良旭.基于ADO技术的数据库访问研究与实现[J].计算机工程 与设计.2004,25(1)：107-110
[53]卢宏,汪金良,曾青云.基于OPC技术的WinCC实时数据采集[J].自动化博览.2006,23(4)：58-60
[54]Guo Z X, Xie X Q, Ni Z G. The application of OPC DA in factory data acquisition[C]//Computer Science and Automation Engineering (CSAE),2012 IEEE International Conference on. IEEE,2012,2:209-212.
[55]Liu C I, Jula H, Ioannou P A. Design, simulation, and evaluation of automated container terminals[J]. Intelligent Transportation Systems, IEEE Transactions on,2002,3(1): 12-26.
[56]刘莉.用VB编写OPC客户端程序的方法[J].工业控制计算机.2005,18(5)：5-6
[2]包起帆.现代港口集装箱物流创新技术研究与应用[C]//中国广东广州：第七届海内外青年设计与制造科学会议论文集.2006
[3]周天星,刘澜.铁路集装箱物流管理信息系统分析[J].综合运输.2003,(11)：39-41
[4]何华.深入浅出西门子WinCC V6[M].北京航空航天大学出版社,2004
[5]张晓杰,刘海昌.基于WinCC的数据采集和监控系统设计[J].工业仪表与自动化装置.2007,(4)：53-55
[6]Vis I F A, de Koster R, Roodbergen K J, et al. Determination of the number of automated guided vehicles required at a semi-automated container terminal [J]. Journal of the Operational Research Society.2001:409-417
[7]王力,朱晓宁,闫伟,等.铁路集装箱中心站堆场混堆优化模型[J].交通运输系统工程与信息.2013,13(2)：172-178
[8]彭传圣.汉堡港的自动化集装箱码头[J].集装箱化.2005,(2)：21.23
[9]张竹.区域集装箱物流信息系统的设计与实现[D].重庆大学,2007
[10]韩晓龙.集装箱港口装卸作业资源配置研究[D].上海海事大学,2005
[11]邱惠清,卢凯良.国际自动化集装箱码头技术发展述评[J].自主创新实现物流工程的持续与科学发展——第八届物流工程学术年会论文集,2008
[12]王洪雪,雷黎黎.集装箱堆场箱位最优分配[J].交通科技与经济.2013,15(001)：50-53
[13]丁以中,费红英,韩晓龙.港口集装箱物流研究现状与分析[J].上海海运学院学报.2004,25(2)：45-54
[14]张春海,刘波,李华.基于事件驱动模型的集装箱物流信息系统[J].计算机工程.2005,31(17)
[15]郑见粹,李海波,谢文宁,等.自动化集装箱码头装卸工艺系统比较研究[J].水运科学研究.2011,7(2)：26-33
[16]包起帆.集装箱电子标签系统的研究和应用介绍[J].港口装卸.2005,(5)：51.56
[17]张玉洁,刘军,贾利民等RFID技术在铁路集装箱堆场进出的应用[J].物流科技.2008,(2)
[18]黄琪,黄卜夫.基于C/S体系结构的集装箱MIS系统设计[J].计算机工程与应用.2003,39(3)：211-212
[19]杨芙清.软件工程技术发展思索[J].软件学报.2005,16(1)
[20]何苗.基于WinCC的港口起重机移动监控系统的研究与应用[D].武汉理工大学自动化学院,2006
[21]钱宏,施荣华.基于OPC技术的B/S模式生产调度系统的研究与实现[J].微计算机信息.2010(034)：50-52
[22]Microsoft Corporation. Microsoft SQL Server 2000 Transact-SQL和技术参考手册[M].科学出版社,2001
[23]Anley C. Advanced SQL injection in SQL server applications[J]. White paper, Next Generation Security Software Ltd,2002
[24]Agrawal S, Chaudhuri S, Narasayya V. Materialized view and index selection tool for Microsoft SQL Server 2000[C]//ACM SIGMOD Record. ACM,2001,30(2):608
[25]陶宏才.数据库原理及设计[M].清华大学出版社,2004
[26]Kohler K E, Gill S M. Coral Point Count with Excel extensions (CPCe):A Visual Basic program for the determination of coral and substrate coverage using random point count methodology[J]. Computers & Geosciences,2006,32(9):1259-1269
[27]Zak, Diane.Programming with Microsoft Visual Basic 6.0[M]. Beijing:Publishing House of Electronics Industry;Thomson Learning,2002
[28]杨力,李月恒,于智.基于WinCC V6.2的VB脚本操作自定义SQL数据库[J].工业控制计算机.2010(009)：7.8
[29]Dobson R. Programming Microsoft SQL Server 2000 with Microsoft Visual Basic. NET[M]. Microsoft Press,2002
[30]马俊朋,杨钢.工业组态软件WinCC及其在水电站自动化中的应用[J].微计算机信息.2006,22(31)：62-64
[31]邹彤.WinCC组态软件的编程技巧[J].化工自动化及仪表.2001,28(2)：63.64
[32]杨路明,雷亚军.组态软件WinCC在自动监控系统中的应用[J].计算技术与自动化.2003,(12)：22-24
[33]吕涌,皇甫正贤.组件化结构的组态软件的研究与开发[J].电气自动化.2000,22(005)：46-48
[34]欧金城,欧世乐,林德杰,等.组态软件的现状与发展.工业控制计算机[J].2002,(5)：10-12
[35]朱荣.基于WinCC的天然气门站SCADA系统上位监控软件研制[D].西南交通大学,2010
[36]袁楚明,谌彦,周敬东,等.实时多任务工业监控组态软件的研究与开发[J].机械与电子.2004,2(3)：43-46
[37]Siemens A G, IA I S. Home-Automation technology-SIMATIC HMI Operator Control and Monitoring Systems-HMI software-SCADA system SIMATIC WinCC-SIMATIC WinCC options-WinCC/IndustrialDataBridge[J].2012
[38]YANG L, LEI Y. Application of Configuration Software WinCC in Automation Monitor System [J]. Computing Technology and Automation,2003,4:006
[39]Wang X, Du J, Qi L, et al. Supervision Control System of Chemical Industry Based on WinCC [J]. Control and Instruments in Chemical Industry,2006,33(5):41
[40]Siemens A G. WinCC v5 The configuration manual and the communication manual[J]. Germany:Siemens,2000
[41]Zheng M G, Zhu X H. Design of Tower Crane Intelligent Monitoring Management System Based on PLC and WinCC[J]. Applied Mechanics and Materials,2012,184: 1554-1557
[42]ZHANG X, LIU H. The design of data acquisition and supervisory system based on WinCC [J]. Industrial Instrumentation & Automation,2007, (4):017
[43]ZHU Y, YE H, LIU C. Using WinCC to Monitor and Control the Mechatronic System [J]. Instrument Technique and Sensor,2004, (6):009
[44]梁棉鑫,罗艳红,边春元,等.WinCC基础及应用开发指南[M].机械工业出版社,2009
[45]Tan Q S W. Programming OPC Client Using VB to Visit WinCC[J]. Anhui Metallurgy, 2011,4:012
[46]Schleipen M. OPC UA supporting the automated engineering of production monitoring and control systems[C]//Emerging Technologies and Factory Automation,2008. ETFA 2008. IEEE International Conference on. IEEE,2008:640-647
[47]Zheng L, Nakagawa H. OPC (OLE for process control) specification and its developments[C]//SICE 2002. Proceedings of the 41st SICE Annual Conference. IEEE, 2002,2:917-920
[48]张宁,薛士龙,陈加敏,等.基于OPC技术的自动化集装箱码头监控系统设计[J].上海海事大学学报.2011,32(1)：21.24
[49]邓全亮,邹益仁.基于OPC技术的系统集成[J].计算机应用研究.2005,22(1)：160-161
[50]Abraham Silberschatz, Henry F.Korth, S.Sudarshan.数据库系统概念[M].杨东,马秀莉等译.第5版.机械工业出版社,2006
[51]王聪华.ADO访问数据库实例剖析[J].计算机应用研究.2002,19(5)：159-160
[52]徐枫,马国之,刘良旭.基于ADO技术的数据库访问研究与实现[J].计算机工程 与设计.2004,25(1)：107-110
[53]卢宏,汪金良,曾青云.基于OPC技术的WinCC实时数据采集[J].自动化博览.2006,23(4)：58-60
[54]Guo Z X, Xie X Q, Ni Z G. The application of OPC DA in factory data acquisition[C]//Computer Science and Automation Engineering (CSAE),2012 IEEE International Conference on. IEEE,2012,2:209-212.
[55]Liu C I, Jula H, Ioannou P A. Design, simulation, and evaluation of automated container terminals[J]. Intelligent Transportation Systems, IEEE Transactions on,2002,3(1): 12-26.
[56]刘莉.用VB编写OPC客户端程序的方法[J].工业控制计算机.2005,18(5)：5-6