基于SQLServerPLC远程监控参数配置方法及其实现.pdfVIP

Computer Science and Application 计算机科学与应用, 2014, 4, 225-233 Published Online October 2014 in Hans. /journal/csa /10.12677/csa.2014.410031 Design and Realization of Parameter Configuration for PLC Equipments’ Remote Monitoring Based on SQL Server 1 1,2 1 1,2 Feiyan Huang , Yanlan Yang , Hongjun Chen , Hua Ye 1 School of Automation, Southeast University, Nanjing 2 Key Laboratory of Measurement and Control of CSE of Ministry of Education, Southeast University, Nanjing Email: zhineng@ st nd th Received: Sep. 1 , 2014; revised: Oct. 2 , 2014; accepted: Oct. 10 , 2014 Copyright © 2014 by authors and Hans Publishers Inc. This work is licensed under the Creative Commons Attribution International License (CC BY). /licenses/by/4.0/ Abstract Remote monitoring system will receive data with different protocol from underlying equipment. In order to enhance the Remote Monitoring Website’s adaptation to the software of data analysis, the parameter configuration method and the method of data calculation are introduced in this paper based on SQL Server 2005. This paper presents the encapsulation of the database operation methods of ADO.NET to design the SQLHelp class with the help of VS2010 A integral pro- gramming environment according to the modular design concept. In addition, SQL statement and procedures are designed to simplify the operation of the database. Caching mechanism of data is designed to deal with the large amount of monitoring data which speed up the response of the browser. Through the test, parameter of different equipment