基于.NET框架的WEB综合查询系统的开发
|
摘要
本文首先分析了供电企业管理信息系统(MIS)的特点,指出了其存在的不足。针对现有客户机/服务器(C/S)模式MIS系统中大量有价值数据不能实现完全共享,无法充分利用现有数据资源和网络资源的问题,提出了开发Web综合查询系统的构想,说明了开发浏览器/服务器(B/S)模式的Web综合查询系统的必要性和重要性。本文按照系统分析、系统规划、系统设计和系统实现的顺序对系统开发过程中涉及的查询数据生成和查询结果表达两方面内容进行了较为深入和全面的探讨,对一些重点、难点问题给出了流程图或实现代码。Web综合查询系统以.Net框架为基础,采用ASP. Net和ADO. Net技术进行开发,系统架构合理、实现简单,体现了基于.Net平台开发B/S模式数据库应用的优越性。本论文所探讨的技术问题不仅适用于供电企业,对所有进行信息化建设的企业都具有重要的价值。
This paper first analyzed the characteristic of power supply business managementinformation system (MIS), pointed out its existence shortage. There are massively valuabledata in MIS that cannot be completely shared for most of the existence MIS is Client/Serverpattern. In view of the above fact, the paper proposed plan of developing web synthesis querysystem in Browser/Server pattern, explained the necessity and importance. In the order ofsystem analysis, system plan, system design and system realization, the query data generationand 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 frameworkusing ASP.Net and ADO.Net that made the constructor is more reasonable and realization issimpler. The realization of the system manifested the superiority in developing B/S databaseapplication based on .Net framework. The technical problems which the paper discussed notonly can apply to power supply business but also have important values for other enterprises.
This paper first analyzed the characteristic of power supply business managementinformation system (MIS), pointed out its existence shortage. There are massively valuabledata in MIS that cannot be completely shared for most of the existence MIS is Client/Serverpattern. In view of the above fact, the paper proposed plan of developing web synthesis querysystem in Browser/Server pattern, explained the necessity and importance. In the order ofsystem analysis, system plan, system design and system realization, the query data generationand 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 frameworkusing ASP.Net and ADO.Net that made the constructor is more reasonable and realization issimpler. The realization of the system manifested the superiority in developing B/S databaseapplication based on .Net framework. The technical problems which the paper discussed notonly can apply to power supply business but also have important values for other enterprises.
引文
[1]杨化动.基于.NET 平台的 BS 应用系统的开发与研究:硕士学位论文.保定:华北电力大学,2002
[2]范孝良,杨化动.基于 B/S 模式的供电 MIS 综合查询系统的设计.华北电力大学学报. 2001,28(4):72-74
[3]张丽,张艳.从 C/S 到 B/S,再到三层(多层)结构-论体系结构的发展.河南师范大学学报,2002,30(3):24～27
[4]陈欣.MIS 系统开发中 C/S 与 B/S 模式结合的探讨.西北电力技术,2005,33(3): 33～35
[5]林海,浏览器/服务器应用开发.北京:科学出版社,2000.1～20
[6]王春红.Delphi 7.0 程序设计.北京:清华大学出版社,2004.26～127
[7]李维.Delphi 7 高效数据库程序设计.北京:机械工业出版社,2003.135～197
[8] (美)Eric Harmon. Delphi COM 深入编程(陈旭、杨彬、刘怀等,译者).北京:机械工业出版社,2003.56～96
[9] (美) Jeffrey Richter. Microsoft .NET 框架程序设计(修订版)(陈忠明,译者).北京:清华大学出版社,2003.21～64
[10]曹祖圣,吴明哲,黄世阳等.Visual C# .NET 程序设计经典.北京:科学出版社,2002.26～102
[11] (美)Stephen Walther. ASP.NET 揭秘(汤涛,译者).北京:中国电力出版社,2004.35～87
[12]肖建.ASP.NET 编程实例与技巧集粹.北京:北京希望电子出版社.2003.5:221～229
[13] (美)佩恩(Payne,C.).ASP.NET 从入门到精通(赵斌等,译者).北京:人民邮电出版社,2002.12～106
[14] (美)鲍威尔(Powell,R.).C#和.NET 架构(袁鹏飞,译者).北京:人民邮电出版社,2002.19～134
[15] (美)凡若切提等..NET 数据服务 C#高级编程(毛尧飞,译者).北京:清华大学出版社,2002.36～245
[16] (美)布启敏(Bob Beauchemin).ADO.NET 本质论(周靖,译者).北京:清华大学出版社,2003.16～56
[17]曹祖圣,吴明哲,黄世阳等.Visual C# .NET 程序设计经典.北京:科学出版社,2002.302～330
[18] (美)David Sceppa.ADO.NET 技术内幕(梁超,张莉等,译者).北京:清华大 学出版社,2003.56～93
[19]Michael Abbey、Michael J.Corey. Oracle8 初学者指南(钟鸣、刘晓霞等,译者).北京:机械工业出版社,1998.12～299
[20]Michael Abbey、Michael J.Corey. Oracle8 参考大全(钟鸣、刘晓霞等,译者).北京:机械工业出版社,1998,200～400
[21]甘仞初.管理信息系统.北京:机械工业出版社,2002.62～77
[22]刘斌,李文革等.Delphi 7 数据库高级教程.北京:清华大学出版社,2004.341～356
[23]黄承安,谢东文,许聪.C#网络应用案例导航.北京:中国铁道出版社,2003.344～384
[2]范孝良,杨化动.基于 B/S 模式的供电 MIS 综合查询系统的设计.华北电力大学学报. 2001,28(4):72-74
[3]张丽,张艳.从 C/S 到 B/S,再到三层(多层)结构-论体系结构的发展.河南师范大学学报,2002,30(3):24～27
[4]陈欣.MIS 系统开发中 C/S 与 B/S 模式结合的探讨.西北电力技术,2005,33(3): 33～35
[5]林海,浏览器/服务器应用开发.北京:科学出版社,2000.1～20
[6]王春红.Delphi 7.0 程序设计.北京:清华大学出版社,2004.26～127
[7]李维.Delphi 7 高效数据库程序设计.北京:机械工业出版社,2003.135～197
[8] (美)Eric Harmon. Delphi COM 深入编程(陈旭、杨彬、刘怀等,译者).北京:机械工业出版社,2003.56～96
[9] (美) Jeffrey Richter. Microsoft .NET 框架程序设计(修订版)(陈忠明,译者).北京:清华大学出版社,2003.21～64
[10]曹祖圣,吴明哲,黄世阳等.Visual C# .NET 程序设计经典.北京:科学出版社,2002.26～102
[11] (美)Stephen Walther. ASP.NET 揭秘(汤涛,译者).北京:中国电力出版社,2004.35～87
[12]肖建.ASP.NET 编程实例与技巧集粹.北京:北京希望电子出版社.2003.5:221～229
[13] (美)佩恩(Payne,C.).ASP.NET 从入门到精通(赵斌等,译者).北京:人民邮电出版社,2002.12～106
[14] (美)鲍威尔(Powell,R.).C#和.NET 架构(袁鹏飞,译者).北京:人民邮电出版社,2002.19～134
[15] (美)凡若切提等..NET 数据服务 C#高级编程(毛尧飞,译者).北京:清华大学出版社,2002.36～245
[16] (美)布启敏(Bob Beauchemin).ADO.NET 本质论(周靖,译者).北京:清华大学出版社,2003.16～56
[17]曹祖圣,吴明哲,黄世阳等.Visual C# .NET 程序设计经典.北京:科学出版社,2002.302～330
[18] (美)David Sceppa.ADO.NET 技术内幕(梁超,张莉等,译者).北京:清华大 学出版社,2003.56～93
[19]Michael Abbey、Michael J.Corey. Oracle8 初学者指南(钟鸣、刘晓霞等,译者).北京:机械工业出版社,1998.12～299
[20]Michael Abbey、Michael J.Corey. Oracle8 参考大全(钟鸣、刘晓霞等,译者).北京:机械工业出版社,1998,200～400
[21]甘仞初.管理信息系统.北京:机械工业出版社,2002.62～77
[22]刘斌,李文革等.Delphi 7 数据库高级教程.北京:清华大学出版社,2004.341～356
[23]黄承安,谢东文,许聪.C#网络应用案例导航.北京:中国铁道出版社,2003.344～384