供电企业ERP系统——WEB综合查询子系统的研究
|
摘要
本文首先介绍了企业ERP系统概念及发展阶段,分析了电力企业ERP的特点,指出了大亚湾现有供电ERP的优缺点。针对现有客户端/服务器(C/S)模式ERP系统中大量有价值数据不能实现完全共享,无法充分利用现有数据资源和网络资源的问题,提出了开发Web综合查询系统的构想,说明了开发浏览器/服务器(B/S)模式的Web综合查询系统的必要性和重要性。本文按照系统分析、系统方案的确定、系统设计和系统实现的顺序对系统开发过程中涉及的查询数据生成和查询结果表达两方面内容进行了较为深入和全面的探讨,对一些重点、难点问题给出了流程图或实现代码。Web综合查询系统以.Net框架为基础,采用ASP. Net和ADO. Net技术进行开发,系统架构合理、实现简单,体现了基于.Net平台开发B/S模式数据库应用的优越性。
This paper first introduced concepts and seedtimes of (power supply) business Enterprise ResourcePlanning(ERP), analyzed the characteristic of power supply business ERP ,pointed out its existenceshortages and excellences. There are massively valuable data in ERP that cannot be completely shared formost of the existence ERP is Client/Server pattern. In view of the above fact, the paper proposed plan ofdeveloping web synthesis query system in Browser/Server pattern, explained the necessity and importance.In the order of system analysis, system plan, system design and system realization, the query datageneration and query result express are thoroughly discussed. To some key and difficult problem, flowchart or the realization code is presented. The system developed based on .Net framework using ASP.Netand ADO.Net that made the constructor is more reasonable and realization is simpler. The realization of thesystem manifested the superiority in developing B/S database application based on .Net framework..
This paper first introduced concepts and seedtimes of (power supply) business Enterprise ResourcePlanning(ERP), analyzed the characteristic of power supply business ERP ,pointed out its existenceshortages and excellences. There are massively valuable data in ERP that cannot be completely shared formost of the existence ERP is Client/Server pattern. In view of the above fact, the paper proposed plan ofdeveloping web synthesis query system in Browser/Server pattern, explained the necessity and importance.In the order of system analysis, system plan, system design and system realization, the query datageneration and query result express are thoroughly discussed. To some key and difficult problem, flowchart or the realization code is presented. The system developed based on .Net framework using ASP.Netand ADO.Net that made the constructor is more reasonable and realization is simpler. The realization of thesystem manifested the superiority in developing B/S database application based on .Net framework..
引文
[1]范孝良,杨化动.基于 B/S 模式的供电 MIS 综合查询系统的设计.华北电力大学学报. 2001,28(4):72-74
[2]杨化动.基于.NET 平台的 BS 应用系统的开发与研究:硕士学位论文.保定:华北电力大学,2002
[3]徐教辉.电力企业 ERP 系统中资金流、物流的研究:硕士论文.北京:华北电力大学,2004
[4]范孝良,陈亚宁,霍娟.ERP-实现企业管理综合自动化的有效途径.制造业自动化,2004 年增刊:23～25
[5]张丽、张艳.从 C/S 到 B/S,再到三层(多层)结构-论体系结构的发展.河南师范大学学报,2002,30(3):24～27
[6]林海,浏览器/服务器应用开发,北京:科学出版社,2000.1～20
[7]王春红.Delphi 7.0 程序设计.北京:清华大学出版社,2004.6～42
[8]黄文钰.Delphi 程序设计经典.北京:科学出版社,2005.295-308
[9]王伟.基于.NET 环境开发 Web 应用系统的研究:硕士论文.武汉:武汉理工大学,2003
[10] (美) Kent Tegels,Tony Bear. .NET Framework 编程思想(袁勤勇,窦蓉,马誉贤,译者).北京:清华大学出版社,2002.5～20
[11](美)Stephen Walther 著. ASP.NET 揭秘(汤涛,译者).北京:中国电力出版社,2004.36～214
[12] (美)Matthew MacDonald.著. ASP.NET 完全参考手册,贾晓军等,译. 北京:电子工业出版社,2003,7～51
[13] (美)Richard Anderson、Brian Francis 著. ASP.NET 高级编程,王毅、杨浩等,译. 北京:清华大学出版社,2002,21～43
[14] (美)布启敏(Bob Beauchemin)著.ADO.NET 本质论(周靖,译者).北京:清华大学出版社,2003.36～154
[15] (美)凡若切提等著.NET 数据服务 C#高级编程(毛尧飞,译者).北京:清华大学出版社,2002.124～287
[16] (美)佩恩(Payne,C.)著.ASP.NET 从入门到精通.(赵斌等,译者).北京:人民邮电出版社,2002.214～326
[17]Michael Abbey、Michael J.Corey 著. Oracle8 初学者指南(钟鸣、刘晓霞等,译).北京:机械工业出版社,1998.12～299
[18]Michael Abbey、Michael J.Corey 著. Oracle8 参考大全(钟鸣、刘晓霞等, 译).北京:机械工业出版社,1998,200～400
[19]甘仞初.管理信息系统.北京:机械工业出版社,2002.62-77
[20]Eric Harmon 著. Delphi COM 深入编程(陈旭、杨彬、刘怀等,译).北京:机械工业出版社,2003.56～96
[21] (美)佩恩(Payne,C.)著.ASP.NET 从入门到精通.(赵斌等,译者).北京:人民邮电出版社,2002.
[22]肖建.ASP.NET 编程实例与技巧集粹.北京:北京希望电子出版社.2003.5:325-328
[2]杨化动.基于.NET 平台的 BS 应用系统的开发与研究:硕士学位论文.保定:华北电力大学,2002
[3]徐教辉.电力企业 ERP 系统中资金流、物流的研究:硕士论文.北京:华北电力大学,2004
[4]范孝良,陈亚宁,霍娟.ERP-实现企业管理综合自动化的有效途径.制造业自动化,2004 年增刊:23～25
[5]张丽、张艳.从 C/S 到 B/S,再到三层(多层)结构-论体系结构的发展.河南师范大学学报,2002,30(3):24～27
[6]林海,浏览器/服务器应用开发,北京:科学出版社,2000.1～20
[7]王春红.Delphi 7.0 程序设计.北京:清华大学出版社,2004.6～42
[8]黄文钰.Delphi 程序设计经典.北京:科学出版社,2005.295-308
[9]王伟.基于.NET 环境开发 Web 应用系统的研究:硕士论文.武汉:武汉理工大学,2003
[10] (美) Kent Tegels,Tony Bear. .NET Framework 编程思想(袁勤勇,窦蓉,马誉贤,译者).北京:清华大学出版社,2002.5～20
[11](美)Stephen Walther 著. ASP.NET 揭秘(汤涛,译者).北京:中国电力出版社,2004.36～214
[12] (美)Matthew MacDonald.著. ASP.NET 完全参考手册,贾晓军等,译. 北京:电子工业出版社,2003,7～51
[13] (美)Richard Anderson、Brian Francis 著. ASP.NET 高级编程,王毅、杨浩等,译. 北京:清华大学出版社,2002,21～43
[14] (美)布启敏(Bob Beauchemin)著.ADO.NET 本质论(周靖,译者).北京:清华大学出版社,2003.36～154
[15] (美)凡若切提等著.NET 数据服务 C#高级编程(毛尧飞,译者).北京:清华大学出版社,2002.124～287
[16] (美)佩恩(Payne,C.)著.ASP.NET 从入门到精通.(赵斌等,译者).北京:人民邮电出版社,2002.214～326
[17]Michael Abbey、Michael J.Corey 著. Oracle8 初学者指南(钟鸣、刘晓霞等,译).北京:机械工业出版社,1998.12～299
[18]Michael Abbey、Michael J.Corey 著. Oracle8 参考大全(钟鸣、刘晓霞等, 译).北京:机械工业出版社,1998,200～400
[19]甘仞初.管理信息系统.北京:机械工业出版社,2002.62-77
[20]Eric Harmon 著. Delphi COM 深入编程(陈旭、杨彬、刘怀等,译).北京:机械工业出版社,2003.56～96
[21] (美)佩恩(Payne,C.)著.ASP.NET 从入门到精通.(赵斌等,译者).北京:人民邮电出版社,2002.
[22]肖建.ASP.NET 编程实例与技巧集粹.北京:北京希望电子出版社.2003.5:325-328