殡仪管理信息系统的设计与实现
摘要
随着社会信息量的迅速增长,原始的手工管理模式已经不能满足信息社会的实际需要。为此,如何对现有资源进行有效管理,已经成为当今社会发展必须解决的主要问题之一。
本论文首先围绕数据库管理系统及其应用方面的技术问题进行了认真研究,对目前通辽市殡仪馆提出的业务需求进行了客观分析,建立了一个殡仪管理系统的框架模型,并进行了总体设计。然后将总体设计框架细化成系统操作员管理子系统、殡葬收费信息管理子系统、骨灰寄存信息管理子系统、数据库管理子系统等四个子系统,并借助VFP数据库开发工具实现了每个子系统的表、表单、报表等功能,最后完成并实现了整个管理系统的设计。
文中提出的殡仪管理系统的设计思想是:根据逝者信息分别建立殡葬收费信息表和骨灰寄存信息表,管理员可以对上述信息表进行增加、编辑、注销、查询、报表统计等多种操作,系统自动进行信息表之间的关联运算,以实现微机化管理的目的。该系统还实现了骨灰盒取走时自动提醒是否欠费的功能,提高了系统的实用性和自动化水平。
本论文完成的系统具有以下功能:
1、可以电子化录入、管理整个信息库内容(包括殡葬收费信息库和骨灰寄存信息库);
2、信息库管理细化到每名逝者或每个骨灰盒,包括各项具体信息的增加、修改、删除、查询等操作;
3、实现欠费信息有明显提示功能:
4、对各分支机构提供标准化模版,确保信息合成、管理不存在问题;
5、系统可以实现生成日报、月报、年报等统计功能;
6、可以根据工作需要进行数据库备份与恢复操作;
7、该数据库可移植性强,可以根据上级管理部门报表格式需求的不同提供DBF、XLS、格式化文本等多种格式转换;
8、操作界面简洁明了,快捷方便,通俗易懂。
在圆满完成以上各项功能的程序设计同时,根据实际需要,又对该系统在操作员分级管理、版权保护模式上进行了有效的优化尝试,达到了预期的目的。该系统在全国殡葬系统中具有较高的推广价值,系统的设计思想和方法对其他信息管理系统也有一定的参考价值。
The primitive manual management model already could not meet the actual needs of information society,with the rapid increasing of social information contents. Therefore,how to manage effectively the available resources became one of main issues must be solved now.
The technology of database and its application were studied carefully,in this paper, analysed objectively the current service demand of Tongliao funeral home,set up a frame model of funeral home management system and designed genreally.Then devided the general design details to four subsystems,the subsystem of system operator management,the subsystem of burial charge information management,the subsystem of ashes store information management and the subsystem database management.At last, achieved the founction of table,form,reportforms of every subsystem by VFP database developer tool,then finished and realized the design of the whole management system. The design idea of funeral management system in this paper was:to build respectively burial charge information table and ashes store information table according to the dead first,manager can carry out many operationd to above information,such as add,edit, cancel,search and form statistice.System carried on the associative operation among the information tables automatically,and then achieved the microcomputer management. This system still achived the function that auto alert charges owed when cinerary casket was taken away,thus increased the system practicability and the automated level.
The system finished in this paper had the following functions:
1.May input and manage electronicly the whole database content(including burial charge and ashes store database).
2.The database management refined to each the dead or each cinerary casket, inclued the operation of each concrete information like add,change,deletion,and search.
3.Realized the alert function of charges owed.
4.Provide the standardized pattern plate to branch office,guaranteed the information synthesis and the management.
5.The system may realize statistical functions of daily report,monthly report,and annual report.
6.May carry on the database backup and the resuming operation according to the job requirement.
7.This database had strong probability,may provide DBF,XLS,the formatted text and many kinds of format conversions according to report format demand of the higher authority control section.
8.The operation interface was simple,brief,convenient,and easy to understand.
While completed above each function programme design,according to actual need, carried on the effective optimized attempt to the operator grading management and the copyright protected mode,has achieved the anticipated purpose.This system had higher promotional value to national funeral system;the design idea and methods also had some reference value to other information management system.
本论文首先围绕数据库管理系统及其应用方面的技术问题进行了认真研究,对目前通辽市殡仪馆提出的业务需求进行了客观分析,建立了一个殡仪管理系统的框架模型,并进行了总体设计。然后将总体设计框架细化成系统操作员管理子系统、殡葬收费信息管理子系统、骨灰寄存信息管理子系统、数据库管理子系统等四个子系统,并借助VFP数据库开发工具实现了每个子系统的表、表单、报表等功能,最后完成并实现了整个管理系统的设计。
文中提出的殡仪管理系统的设计思想是:根据逝者信息分别建立殡葬收费信息表和骨灰寄存信息表,管理员可以对上述信息表进行增加、编辑、注销、查询、报表统计等多种操作,系统自动进行信息表之间的关联运算,以实现微机化管理的目的。该系统还实现了骨灰盒取走时自动提醒是否欠费的功能,提高了系统的实用性和自动化水平。
本论文完成的系统具有以下功能:
1、可以电子化录入、管理整个信息库内容(包括殡葬收费信息库和骨灰寄存信息库);
2、信息库管理细化到每名逝者或每个骨灰盒,包括各项具体信息的增加、修改、删除、查询等操作;
3、实现欠费信息有明显提示功能:
4、对各分支机构提供标准化模版,确保信息合成、管理不存在问题;
5、系统可以实现生成日报、月报、年报等统计功能;
6、可以根据工作需要进行数据库备份与恢复操作;
7、该数据库可移植性强,可以根据上级管理部门报表格式需求的不同提供DBF、XLS、格式化文本等多种格式转换;
8、操作界面简洁明了,快捷方便,通俗易懂。
在圆满完成以上各项功能的程序设计同时,根据实际需要,又对该系统在操作员分级管理、版权保护模式上进行了有效的优化尝试,达到了预期的目的。该系统在全国殡葬系统中具有较高的推广价值,系统的设计思想和方法对其他信息管理系统也有一定的参考价值。
The primitive manual management model already could not meet the actual needs of information society,with the rapid increasing of social information contents. Therefore,how to manage effectively the available resources became one of main issues must be solved now.
The technology of database and its application were studied carefully,in this paper, analysed objectively the current service demand of Tongliao funeral home,set up a frame model of funeral home management system and designed genreally.Then devided the general design details to four subsystems,the subsystem of system operator management,the subsystem of burial charge information management,the subsystem of ashes store information management and the subsystem database management.At last, achieved the founction of table,form,reportforms of every subsystem by VFP database developer tool,then finished and realized the design of the whole management system. The design idea of funeral management system in this paper was:to build respectively burial charge information table and ashes store information table according to the dead first,manager can carry out many operationd to above information,such as add,edit, cancel,search and form statistice.System carried on the associative operation among the information tables automatically,and then achieved the microcomputer management. This system still achived the function that auto alert charges owed when cinerary casket was taken away,thus increased the system practicability and the automated level.
The system finished in this paper had the following functions:
1.May input and manage electronicly the whole database content(including burial charge and ashes store database).
2.The database management refined to each the dead or each cinerary casket, inclued the operation of each concrete information like add,change,deletion,and search.
3.Realized the alert function of charges owed.
4.Provide the standardized pattern plate to branch office,guaranteed the information synthesis and the management.
5.The system may realize statistical functions of daily report,monthly report,and annual report.
6.May carry on the database backup and the resuming operation according to the job requirement.
7.This database had strong probability,may provide DBF,XLS,the formatted text and many kinds of format conversions according to report format demand of the higher authority control section.
8.The operation interface was simple,brief,convenient,and easy to understand.
While completed above each function programme design,according to actual need, carried on the effective optimized attempt to the operator grading management and the copyright protected mode,has achieved the anticipated purpose.This system had higher promotional value to national funeral system;the design idea and methods also had some reference value to other information management system.
引文
[1]Abraham Siiberchatz.数据库系统概念(第4版)[M].北京:机械工业出版社,2005,1(2):4-6.
[2]李建中,王珊.数据库系统原理(2版)[M].北京:电子工业出版社,2004,2(1):30-35
[3]马垣.关系数据库理论[M].北京:清华大学出版社,1999年,257-260
[4]康诺利(Connolly,T.M.)数据库设计教程(第二版)[M].北京:机械工业出版社,2005,1(2):5-8
[5](美)加西亚-莫里纳(Garcia-Molina,H.),(美)沃尔(ULlman,J.D.).数据库系统全书(第一版)[M].北京:机械工业出版社,2003年,1(2):6-9
[6]范剑波.数据库原理及应用(第一版)[M].北京:人民邮电出版社,2004,1(2):5-8
[7]王志梅.关系数据库基础与技术(第一版)[M].北京:国防工业出版社,2005,1(5):18-20
[8]李从利.数据结构(第一版)[M].南京:南京大学出版社,2003
[9]韩宏志.数据库设计与开发教程(第一版)[M].北京:清华大学出版社,2005,1(5)22-25
[10]M.Tamer Ozsu Patrick Valduriez.分布式数据库系统原理(第2版)影印版[M].北京:清华大学出版社,2002,4(1):76-77.
[11]BJeffery.EnterpriseClient/ServerComputing,Information Systems Management,1996
[12]PatelP MossK,Java Database Programming with JDBC,Scottsdale:CoriolisGroup,1996
[13]马松,盛浩林.Intmet上数据库中间件原型的研究与构造[J].软件学报,1999,1(1)
[14]萨师煊,王珊.数据库系统概论[M].北京:高等教育出版社,2000
[15][美]Raghu Ramakrishnan数据库管理系统原理与设计(第3版)[M].北京:清华大学出版社,2004,9(3):114-115.
[16]宁可.数据库技术与应用[M].北京:清华大学出版社,2006,1(4)
[17]廖明潮.数据库应用技术-Visual FoxPro及其应用系统开发[M].北京:水利水电出版社,2006,1(2)
[18]M.Tamer Ozsu Patrick Valduriez.分布式数据库系统原理(第2版)[M].北京:清华大学出版社,2002,4(1):76-77.
[19]张立科.Visual Foxpro数据库通用模块及典型系统开发实例导航[M].北京:人民邮电出版社,2006,8(2):94-96.
[20][美]Michael V.Mannino.数据库设计、应用开发与管理(第二版)[M].北京:电子工业出版社,2005,3(5)
[21]苗雪兰.数据库技术及应用[M].北京:机械工业出版社,2005,2(3)
[22]洪志全.数据库原理及应用[M].北京:电子工业出版社,2004,2(4)
[23]XML数据库:最新进展和发展方向[J].计算机世界报2005第36期
[24]吴迪,曲蒙.Visual Foxpro 6.0命令手册[M].北京:清华大学出社,1999
[25]李平,李军,梁静毅.Visual FoxPro数据库基础[M].北京:清华大学出版社,2005,2(4)
[26]蒋丽,袁学松.isual FoxPro 6.0程序设计与实现电子教案[M].北京:中国水利水电出版社,2006,1(4):14
[27]徐尔贵.Visual FoxPro面向对象数据库教程[M].北京:电子工业出版社,2006,1(2)
[28]梁锐城.Visual FoxPro数据库应用教程[M].北京:科学出版社,2005,2(1)
[29]史济民.Visual FoxPro及其应用系统开发[M].北京:清华大学出版社,2000,5
[30]刘瑞新.Visual FoxPro程序设计教程[M].北京:电子工业出版社,2006,1(1)
[31]张立科.Visual Foxpro数据库通用模块及典型系统开发实例导航[M].北京:人民邮电出版社,2006,8(2):94-96.
[32][美]Don Benage,Azam Mirza,严春莹,马琳,王宏伟,李喆译.Visual Studio 使用大全[M].北京:电子工业出版社,1998,13-6
[33]彭小军.基于web的信息管理系统架构的研究[EB/oL].htp方www.szlw.co而50川6/2007/200701131053.html,2006
[34]刘光远,黄立岩.多策略数据挖掘系统的分析与设计[J].吉林大学学报处理(信息科学版),2006(06).
[35]Sohn,Kwon-Joong,Yoo,Wang-Jin,Lee,Cheol-Gyu.The design and implementation of information system for the MBO of national R and D projects cooperated by industries,universities and government-supported research institute[J]Portland International Conference on Management of Engineering and Technology,PICMET '07-Portland International Center for Management of Engineering and Technology-Proceedings Management of Converging Technologies,2007,p 959-966
[36]贾旭光,黄厚宽,黄婉秋.数据仓库中的数据集成[J].北方交通大学学报,2002,(2).
[37]Dieudonne,James E.;Leslie Crane,H.;Gonda,John;Jones,Stanley R.NEO(NextGen TBOS) provided by multi-agency surveillance SOA(SDN)[J]AIAA/IEEE Digital Avionics Systems Conference-Proceedings,26th DASC Digital Avionics Systems Conference-4-Dimensional Trajectory-Based Operaions:Impact on Future Avionics and Systems,2007,p 1E31-1E313
[38]Onabe,Fumihiko.In search for systematic construction of newly integrated paper science 30.The present status of Mill Wide Control System as a hierarchical structure[J]Kami,Parupu Gijutsu Taimusu/Japanese Journal of Paper Technology,v 49,n 11,2006,p 75-82
[49]Gong,Zhu-Ping;Sun,Yan-Ming;Zheng,Shi-Xiong.Order-disorder measurement theory of manufacturing information system[J]Huanan Ligong Daxue Xuebao/Journal of South China University of Technology (Natural Science),v 35,n 12,December,2007,p 45-50
[40]Ma,Ainai.Outer space information and geographic information systems and their application[J]Beijing Daxue Xuebao Ziran Kexue Ban/Acta Scientiarum Naturalium Universitatis Pekinensis,v 34,n 4,Jul 20,1998,p 533-540,541
[41]张宁,李强娇.基于ERP的企业数据仓库设计田[J].计算机工程与设计,2005,(2).
[42]Xu,Lida;Liang,Ning;Gao,Qiong.An integrated approach for agricultural ecosystem management[J]IEEE Transactions on Systems,Man and Cybernetics Part C:Applications and Reviews,v 38,n 4,July,2008,p 590-599
[43]Shim,Young-Chul.Storage and access of temporal information for the management of complex systems[J]Applied Computing:Technological Challenges of the 1990's,1992,p 264-272
[44]Zhao,Hai-Feng;Wang,Jian-Rong;Liang,Shuang;Wang,Wan-Shah Research and implementation on integration of MES and information system in networked-manufacturing environment[J]Dongbei Daxue Xuebao/Journal of Northeastern University,v 29,n SUPPL.2,July,2008,p 73-76
[45]Yoshihara,Kiyohito;Isomura,Manabu;Horiuchi,Hiroki.Distributed policy-based management enabling policy adaptation[M]IEICE Transactions on Communications,v E87-B,n 7,July,2004,p 1854-1865
[46]Heales,Jon.A model of factors affecting an information system's change in state[J]Journal of Software Maintenance and Evolution,v 14,n 6,November/December,2002,p 409-427
[47]Liu,Danhong;Wang,Xia;Pan,Feng;Xu,Yongyong;Yang,Peng;Rao,Keqin.Web-based infectious disease reporting using XML forms[J]. International Journal of Medical Informatics, v 77, n 9, September, 2008, p 630-640
[48] Odhiambo-Otieno, George W. Evaluation of existing District Health Management Information Systems: A case study of the District Health Systems in Kenya [J]. International Journal of Medical Informatics, v 74, n 9, September, 2005, p 733-744
[49] Qiao, Li-Hong; Zhang, Yi-Zhu. Change information integration and control between PDM and ERP [M].Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems, CIMS, v 14, n 5, May, 2008, p 904-911
[50] Yang, Shunxin ; Ni, Fujian; Wang, WeiFreeway incident management system application in Jiangsu, China[J]. IEEE Conference on Intelligent Transportation Systems, Proceedings, ITSC, 10th International IEEE Conference on Intelligent Transportation Systems, ITSC 2007, 2007, p 76-80
[2]李建中,王珊.数据库系统原理(2版)[M].北京:电子工业出版社,2004,2(1):30-35
[3]马垣.关系数据库理论[M].北京:清华大学出版社,1999年,257-260
[4]康诺利(Connolly,T.M.)数据库设计教程(第二版)[M].北京:机械工业出版社,2005,1(2):5-8
[5](美)加西亚-莫里纳(Garcia-Molina,H.),(美)沃尔(ULlman,J.D.).数据库系统全书(第一版)[M].北京:机械工业出版社,2003年,1(2):6-9
[6]范剑波.数据库原理及应用(第一版)[M].北京:人民邮电出版社,2004,1(2):5-8
[7]王志梅.关系数据库基础与技术(第一版)[M].北京:国防工业出版社,2005,1(5):18-20
[8]李从利.数据结构(第一版)[M].南京:南京大学出版社,2003
[9]韩宏志.数据库设计与开发教程(第一版)[M].北京:清华大学出版社,2005,1(5)22-25
[10]M.Tamer Ozsu Patrick Valduriez.分布式数据库系统原理(第2版)影印版[M].北京:清华大学出版社,2002,4(1):76-77.
[11]BJeffery.EnterpriseClient/ServerComputing,Information Systems Management,1996
[12]PatelP MossK,Java Database Programming with JDBC,Scottsdale:CoriolisGroup,1996
[13]马松,盛浩林.Intmet上数据库中间件原型的研究与构造[J].软件学报,1999,1(1)
[14]萨师煊,王珊.数据库系统概论[M].北京:高等教育出版社,2000
[15][美]Raghu Ramakrishnan数据库管理系统原理与设计(第3版)[M].北京:清华大学出版社,2004,9(3):114-115.
[16]宁可.数据库技术与应用[M].北京:清华大学出版社,2006,1(4)
[17]廖明潮.数据库应用技术-Visual FoxPro及其应用系统开发[M].北京:水利水电出版社,2006,1(2)
[18]M.Tamer Ozsu Patrick Valduriez.分布式数据库系统原理(第2版)[M].北京:清华大学出版社,2002,4(1):76-77.
[19]张立科.Visual Foxpro数据库通用模块及典型系统开发实例导航[M].北京:人民邮电出版社,2006,8(2):94-96.
[20][美]Michael V.Mannino.数据库设计、应用开发与管理(第二版)[M].北京:电子工业出版社,2005,3(5)
[21]苗雪兰.数据库技术及应用[M].北京:机械工业出版社,2005,2(3)
[22]洪志全.数据库原理及应用[M].北京:电子工业出版社,2004,2(4)
[23]XML数据库:最新进展和发展方向[J].计算机世界报2005第36期
[24]吴迪,曲蒙.Visual Foxpro 6.0命令手册[M].北京:清华大学出社,1999
[25]李平,李军,梁静毅.Visual FoxPro数据库基础[M].北京:清华大学出版社,2005,2(4)
[26]蒋丽,袁学松.isual FoxPro 6.0程序设计与实现电子教案[M].北京:中国水利水电出版社,2006,1(4):14
[27]徐尔贵.Visual FoxPro面向对象数据库教程[M].北京:电子工业出版社,2006,1(2)
[28]梁锐城.Visual FoxPro数据库应用教程[M].北京:科学出版社,2005,2(1)
[29]史济民.Visual FoxPro及其应用系统开发[M].北京:清华大学出版社,2000,5
[30]刘瑞新.Visual FoxPro程序设计教程[M].北京:电子工业出版社,2006,1(1)
[31]张立科.Visual Foxpro数据库通用模块及典型系统开发实例导航[M].北京:人民邮电出版社,2006,8(2):94-96.
[32][美]Don Benage,Azam Mirza,严春莹,马琳,王宏伟,李喆译.Visual Studio 使用大全[M].北京:电子工业出版社,1998,13-6
[33]彭小军.基于web的信息管理系统架构的研究[EB/oL].htp方www.szlw.co而50川6/2007/200701131053.html,2006
[34]刘光远,黄立岩.多策略数据挖掘系统的分析与设计[J].吉林大学学报处理(信息科学版),2006(06).
[35]Sohn,Kwon-Joong,Yoo,Wang-Jin,Lee,Cheol-Gyu.The design and implementation of information system for the MBO of national R and D projects cooperated by industries,universities and government-supported research institute[J]Portland International Conference on Management of Engineering and Technology,PICMET '07-Portland International Center for Management of Engineering and Technology-Proceedings Management of Converging Technologies,2007,p 959-966
[36]贾旭光,黄厚宽,黄婉秋.数据仓库中的数据集成[J].北方交通大学学报,2002,(2).
[37]Dieudonne,James E.;Leslie Crane,H.;Gonda,John;Jones,Stanley R.NEO(NextGen TBOS) provided by multi-agency surveillance SOA(SDN)[J]AIAA/IEEE Digital Avionics Systems Conference-Proceedings,26th DASC Digital Avionics Systems Conference-4-Dimensional Trajectory-Based Operaions:Impact on Future Avionics and Systems,2007,p 1E31-1E313
[38]Onabe,Fumihiko.In search for systematic construction of newly integrated paper science 30.The present status of Mill Wide Control System as a hierarchical structure[J]Kami,Parupu Gijutsu Taimusu/Japanese Journal of Paper Technology,v 49,n 11,2006,p 75-82
[49]Gong,Zhu-Ping;Sun,Yan-Ming;Zheng,Shi-Xiong.Order-disorder measurement theory of manufacturing information system[J]Huanan Ligong Daxue Xuebao/Journal of South China University of Technology (Natural Science),v 35,n 12,December,2007,p 45-50
[40]Ma,Ainai.Outer space information and geographic information systems and their application[J]Beijing Daxue Xuebao Ziran Kexue Ban/Acta Scientiarum Naturalium Universitatis Pekinensis,v 34,n 4,Jul 20,1998,p 533-540,541
[41]张宁,李强娇.基于ERP的企业数据仓库设计田[J].计算机工程与设计,2005,(2).
[42]Xu,Lida;Liang,Ning;Gao,Qiong.An integrated approach for agricultural ecosystem management[J]IEEE Transactions on Systems,Man and Cybernetics Part C:Applications and Reviews,v 38,n 4,July,2008,p 590-599
[43]Shim,Young-Chul.Storage and access of temporal information for the management of complex systems[J]Applied Computing:Technological Challenges of the 1990's,1992,p 264-272
[44]Zhao,Hai-Feng;Wang,Jian-Rong;Liang,Shuang;Wang,Wan-Shah Research and implementation on integration of MES and information system in networked-manufacturing environment[J]Dongbei Daxue Xuebao/Journal of Northeastern University,v 29,n SUPPL.2,July,2008,p 73-76
[45]Yoshihara,Kiyohito;Isomura,Manabu;Horiuchi,Hiroki.Distributed policy-based management enabling policy adaptation[M]IEICE Transactions on Communications,v E87-B,n 7,July,2004,p 1854-1865
[46]Heales,Jon.A model of factors affecting an information system's change in state[J]Journal of Software Maintenance and Evolution,v 14,n 6,November/December,2002,p 409-427
[47]Liu,Danhong;Wang,Xia;Pan,Feng;Xu,Yongyong;Yang,Peng;Rao,Keqin.Web-based infectious disease reporting using XML forms[J]. International Journal of Medical Informatics, v 77, n 9, September, 2008, p 630-640
[48] Odhiambo-Otieno, George W. Evaluation of existing District Health Management Information Systems: A case study of the District Health Systems in Kenya [J]. International Journal of Medical Informatics, v 74, n 9, September, 2005, p 733-744
[49] Qiao, Li-Hong; Zhang, Yi-Zhu. Change information integration and control between PDM and ERP [M].Jisuanji Jicheng Zhizao Xitong/Computer Integrated Manufacturing Systems, CIMS, v 14, n 5, May, 2008, p 904-911
[50] Yang, Shunxin ; Ni, Fujian; Wang, WeiFreeway incident management system application in Jiangsu, China[J]. IEEE Conference on Intelligent Transportation Systems, Proceedings, ITSC, 10th International IEEE Conference on Intelligent Transportation Systems, ITSC 2007, 2007, p 76-80