版权所有@2014 《油气储运》杂志社 冀ICP备号:0000000
地址:河北省廊坊市金光道51号(065000);电话:0316-2177193 / 0316-2176753; 传真:0316-2177392; 网址:yqcy.paperonce.org
技术支持:西安三才科技实业有限公司 029-89381847;029-88222991
成品油管网生产数据管理系统研发
Development of production data management system for products pipeline network
ASP.NET
; SCADA; template; data management system; Web成品油管道企业的SCADA系统产生大量的生产数据,如何对这些数据进行分析处理,并服务于企业,是亟待解决的一大难题。利用ASP.NET软件(基于C#)及SCADA系统自带模板软件对华东管网的生产数据(日报表、月报表、批次统计表、设备运行时间统计表、混油情况表和输油量同比表等)进行有效管理,在设定时间内,从SCADA系统自动获取生产数据并进行统计和分析,进而呈现在Web网页上,以便进行生产优化,并方便各部门人员浏览和下载。实践证明:成品油管网生产数据管理系统可以自动从SCADA系统中提取用户所需的数据,为管道企业的管理人员提供所需的数据,并为生产运行方案的优化提供有力的数据支持。
The SCADA systems of products pipeline enterprises contain vast quantities of production data. For these enterprises, it is challenging to analyze, process and use these data. By using ASP.NET (C# based) and integral templates of SCADA system, production data, including daily and monthly reports, batch reports, running-time reports of relevant facilities, oil contamination reports and reports for oil-transportation capacities, of Eastern China Pipeline Network can be managed effectively. The system may acquire production data from SCADA at pre-determined time interval for statistical analysis, with relevant results posted on Web pages to promote process optimization. In addition, all operators in relevant departments may easily access and download these data. Practices prove that the production data management system may automatically acquire required data from SCADA to satisfy demands of managers of pipeline enterprises. Moreover, the system may provide necessary supports for optimization of relevant operation programs.
[1] 王维斌. 长输油气管道大数据管理架构及应用[J].油气储运, 2015,34(3):229-232. WANG W B. Big data management framework and its application in long-distance oil/gas pipeline[J].Oil and Gas Storage and Transportation,2015,34(3):229-232.
[2] 马志祥. 油气长输管道的风险管理[J].油气储运,2005,24(2):1-7. MA Z X. Risk management of long-distance oil/gas pipeline[J].Oil and Gas Storage and Transportation,2005,24(2):1-7.
[3] 刘洪彬. 长输油气管道SCADA系统应用与研究[D].厦门:厦门大学,2013:19-20. LIU H B. The application & research of SCADA in long-distance oil & gas pipeline[D].Xiamen:Xiamen University,2013:19-20.
[4] 赵丹丹. 基于SCADA系统的爆管监测方法研究[D].杭州:浙江大学,2014:23-25. ZHAO D D. Research of burst detection based on SCADA[D].Hangzhou:Zhejiang University,2014:23-25.
[5] 仲瀛昊. 上海大众燃气SCADA系统设计与实现[D].成都:电子科技大学,2013:37-38. ZHONG Y H. Desitn and implementation of Shanghai Dazhong gas SCADA system[D].Chengdu:University of Electronic Science and Technology of China,2013:37-38.
[6] CHRIS P. ASP.NET从入门到精通[M].赵斌,张滨义,董清波, 译. 北京:清华大学出版社,2012:57-86. CHRIS P. From entry to master of ASP.NET[M].ZHAO B, ZHANG B Y, DONG Q B. translated Beijing:Tsinghua University Press,2012:57-86.
[7] 谭震林. 深入解析ASP.NET 2.0控件开发[M].北京:电子工业出版社,2007:88-132. TAN Z L. Deep research of control tools of ASP.NET 2.0[M].Beijing:Publishing House of Electronics Industry,2007:88-132.
[8] 范胜荣. Visual C# 2008控件使用范例详解[M].北京:清华大学出版社,2009:24-46. FAN S R. The explanation of examples for control tools of Visual C# 2008[M].Beijing:Tsinghua University Press,2009:24-46.
[9] 孙敬杰. EXCEL VBA入门与实例演练[M].北京:中国青年出版社,2005:87-102. SUN J J. The entry and example practice of EXCEL VBA[M].Beijing:China Youth Publishing Group,2005:87-102.
[10] 魏汪洋. C# 从入门到精通[M].北京:化学工业出版社,2011:35-36. WEI W Y. From entry to master of C#[M].Beijing:Chemical Industry Press,2011:35-46.
[1]闫峰,祁国成,魏凯,等.IEC 104 协议在陕京一线SCADA 系统中的应用[J].油气储运,2011,30(10):732.[doi:10.6047/j.issn.1000-8241.2011.10.004]
Yan Feng,Qi Guocheng,Wei Kai,et al.Application of IEC60870-5-104 Protocol in the SCADA system of the 1st Shaanxi-Beijing Gas Transmission Pipeline[J].Oil & Gas Storage and Transportation,2011,30(6):732.[doi:10.6047/j.issn.1000-8241.2011.10.004]
[2]王金柱,王泽根,张丙辰,等.基于SCADA和GIS的油气调控运行系统[J].油气储运,2011,30(12):902.[doi:10.6047/j.issn.1000-8241.2011.12.007]
Wang Jinzhu,Wang Zegen,Zhang Bingchen,et al.Constitution and function of SCADA / GIS-based oil & gas control system[J].Oil & Gas Storage and Transportation,2011,30(6):902.[doi:10.6047/j.issn.1000-8241.2011.12.007]
[3]何兆洋,尚义,何丽萍,等.漠大原油管道SCADA通讯中断原因及应对措施[J].油气储运,2014,33(5):501.[doi:10.6047/j.issn.1000-8241.2014.05.010]
HE Zhaoyang,SHANG Yi,HE Liping,et al.Reasons and solutions of SCADA communication interruption in Mohe-Daqing Crude Oil Pipeline[J].Oil & Gas Storage and Transportation,2014,33(6):501.[doi:10.6047/j.issn.1000-8241.2014.05.010]
[4]樊绪平,雷雨,王银娜,等.利用SCADA 系统防止西气东输管道冰堵的预警逻辑[J].油气储运,2014,33(10):1091.[doi:10.6047/j.issn.1000-8241.2014.10.014]
FAN Xuping,LEI Yu,WANG Yinna,et al.Warning logic of ice blockage with SCADA for West-to-East Gas Pipeline[J].Oil & Gas Storage and Transportation,2014,33(6):1091.[doi:10.6047/j.issn.1000-8241.2014.10.014]
[5]陈鹏,李永缙,张伟.油气管道SCADA系统分区分域安全防护方法[J].油气储运,2014,33(11):1244.[doi:10.6047/j.issn.1000-8241.2014.11.020]
CHEN Peng,LI Yongjin,ZHANG Wei.Safety protection of oil/gas pipeline SCADA system by partition[J].Oil & Gas Storage and Transportation,2014,33(6):1244.[doi:10.6047/j.issn.1000-8241.2014.11.020]
[6]黄河,黄平,闫峰,等.油气管道SCADA系统调控业务应用的GIS扩展[J].油气储运,2015,34(1):62.[doi:10.6047/j.issn.1000-8241.2015.01.013]
HUANG He,HUANG Ping,YAN Feng,et al.GIS extension in regulation application of oil and gas pipeline SCADA system[J].Oil & Gas Storage and Transportation,2015,34(6):62.[doi:10.6047/j.issn.1000-8241.2015.01.013]
[7]洪诗定 高松标 蔡欣 胡景军 张青.成品油管网生产数据管理系统研发[J].油气储运,2016,35(预出版):1.
HONG Shiding,GAO Songbiao,CAI Xin,et al.Development of production data management system for products pipeline network[J].Oil & Gas Storage and Transportation,2016,35(6):1.
[8]孙铁良,张群,刘飞,等.一种在SCADA 系统增加PostgreSQL 支持的数据库开发[J].油气储运,2017,36(10):1201.[doi:10.6047/j.issn.1000-8241.2017.10.017]
SUN Tieliang,ZHANG Qun,LIU Fei,et al.One database developed by adding PostgreSQL support into SCADA
system[J].Oil & Gas Storage and Transportation,2017,36(6):1201.[doi:10.6047/j.issn.1000-8241.2017.10.017]
[9]赵国辉.中俄东线天然气管道工程SCADA系统的设计与实现[J].油气储运,2020,39(04):379.[doi:10.6047/j.issn.1000-8241.2020.04.003]
ZHAO Guohui.Design and implementation of SCADA system for China–Russia Eastern Gas Pipeline[J].Oil & Gas Storage and Transportation,2020,39(6):379.[doi:10.6047/j.issn.1000-8241.2020.04.003]
收稿日期:2015-05-27;改回日期:2015-08-21。
作者简介:洪诗定,男,在读博士生,1982年生,2012年硕士毕业于同济大学机械电子工程专业,现主要从事油气储运管理工作。地址:上海市嘉定区曹安公路4800号,201804。电话:15216666202,Email:roticguitar@163.com
通讯作者:秦朝葵,男,教授,博士生导师,1968年生,1994年博士毕业于同济大学供热供燃气通风及空调工程专业,现主要从事燃气燃烧与应用技术、燃气管道安全防护技术研究工作。地址:上海市嘉定区曹安公路4800号,201804。电话:0216-9583802,Email:chkqin@tongji.edu.cn