硕硕 士士 学学 位位 论论 文文水厂运行数据实时检测与处理系统的设计与实现学科专业 ：检测技术与自动化装置研究方向 ：计算机测控作者姓名 ：王海珍指导教师 ：廉小亲 教授所在学院 ：计算机与信息工程学院二一三年三月The design and implementation of waterworks operating data real-time detection and processing systemDissertation Submitted toBeijing Technology and Business Universityin Partial Fulfillment of the Requirementfor the Degree ofMaster of EngineeringbyWang Haizhen（Detection technology and Automatic equipment）Dissertation Supervisor：Professor Lian XiaoqinMarch 2013学位论文原创性声明本人郑重声明：所呈交的学位论文是本人在导师指导下进行的研究工作所取得的研究成果。除了文中已经注明引用的内容外，论文中不包含其他个人或集体已经发表或撰写过的研究成果。对本文的研究做出重要贡献的个人和集体，均已在文中以明确方式标明。本声明的法律后果完全由本人承担。作者签名： 日期： 年 月 日学位论文授权使用声明本人完全了解北京工商大学有关保留和使用学位论文的规定，即：研究生在校攻读学位期间学位论文所涉及的知识产权属于北京工商大学。学校有权保留并向国家有关部门或机构送交论文的复印件和电子版，允许学位论文被查阅和借阅；学校可以公布学位论文的全部或部分内容，可以采用影印、缩印或其它复制手段保存、汇编学位论文。 （保密的学位论文在解密后遵守此规定）作者签名： 导师签名： 日期： 年 月 日I摘摘 要要随着我国经济的高速发展以及人民生活水平的日益提高，居民生活的用水量逐渐增大，人们对水质的要求也越来越高。因此，倾斜资金投入重心，开展技术攻关，设法获得高品质的自来水并制定科学的水质评价体系成为自来水处理厂发展的重点。但是在实际运行过程中，由于监控系统中的水质参数和运行状态等数据不能被实时的检测和处理，水厂不但需要投入力量手工抄表，更无法及时掌握水质情况并做出反馈。所以研究水厂数据通信与处理方法，开发气浮车间报表自动生成系统，进一步研究水质评价方法，对降低运行成本、提高水厂运营效率有重大意义。本文首先描述了自来水厂自控系统以及网络架构，分析了自来水处理的工艺流程，进而设计了运行数据实时检测与处理系统的总体方案。论文包含如下工作： 1、基于 OPC 技术，采用 Client/Server 模式，借助 Rslinx 通讯软件构建服务器，通过开发 OPC 客户程序，采集 OPC 服务器中的数据，实现服务器与各 PLC 控制站之间的数据通信；2、针对通信从净化车间、加氯间、加氨间内的采集到原始数据，研究获得各类水质、水量、药耗、电耗等参数值的数据处理方法，并利用系统保存到本地数据库中；3、对客户端进行界面设计和功能开发，实现日报表、月报表和年报表的查询与导出，并可以依据报表数据生成曲线趋势图；4、根据生活饮用水卫生标准，利用 BP 算法对水质进行建模研究，并针对算法的缺陷，提出改进方法，通过实验仿真进行验证。目前本文提出的水厂运行数据实时检测与处理系统已经成功地应用于天津某自来水厂中。该系统的成功运行不仅减轻了工作人员繁杂重复的工作内容，也使得水厂的信息综合化水平得到提高。关键词：关键词：自来水处理；OPC；Rslinx；神经网络；自动化报表IIAbstractAs the rapid growth of Chinese economic and the improvement of Chinese peoples living standards, residents water consumption become larger and larger while people expecting high requirements for water quality. Therefore, getting water of high quality and establishing a scientific water-quality evaluating system by inclining the focus of investment and tackling technical problems have been a key sector in waterworks development. However, the actual monitoring system cannot detect and process water quality parameters and system operating status automatically so that people have to waste more time on collecting sufficient information to make so-called “timely feedback”. In such circumstances, for decreasing operating cost and improving operating efficiency reasons, it is important to study waterworks data communication and processing, develop air-flotation plant report generation system, and further discuss water-quality evaluating system.This paper makes a brief description of waterworks automatic control system and network architecture, and gives a comprehensive analysis of the water treatment technological process. On that basis, a waterworks operating data real-time detection and processing system is designed. Main works are shown as the following:(1) To achieve the communication between server and PLC controlling station, based on OPC standards, adopted Client/Server Mode, a server is built by Rslinx from which develop OPC client code can collect system operating data.(2) Based on the original data acquired from purification plant, chlorine dosing room and ammonia dosing room, a program is exploited to analyze and store the parameter of water quality, water volume, drug consumption and power consumption.(3) In the client, designed and developed software, to realize daily, monthly and annual reports query and output. Moreover, users can check parameter curve tendency chart generated by the program intuitively.(4) According to the sanitary standard for drinking water, the paper analyzes the model of water-quality with BP algorithm, aimed at the algorithms defect, present improvement method, and verifies the system through simulation and experiment.The present system has been in a trial run in a certain waterworks in Tianjin. Its successful operating reduces workers labor intensity and gives a real-time water quality IIImonitoring, and will be contributory for improving the informationalized level of waterworks.Key Words : water treatment, opc, rslinx, neural network, aotumatic reportIV目录目录第 1 章 绪论.11.1 选题背景.11.2 选题的目的和意义.11.3 相关技术研究状况.21.3.1 水处理行业现状.21.3.2 水厂技术现状与现存问题.31.3.3 OPC 技术研究现状.41.3.4 水质评价研究现状.