医疗设备信息管理系统的设计与实现
摘要
随着科学技术的迅速发展,现代化的先进医疗设备是现代化医院的物质基础,是先进的医学诊治手段,医疗设备管理已成为现代医院管理的一个重要领域。因此,对医疗设备管理水平的要求也越来越高,对医疗设备从采购到维护、报废的整个环节,需要严格的科学管理,必须运用现代科学技术手段树立医疗综合管理思想,改进医疗设备管理工作,进行医疗设备的信息化管理,以获得最佳效益。
目前的医疗设备信息管理系统都是各医院根据自身的特点和要求设计开发的,软件开发平台、使用的数据库、前后台操作系统各不一样,各软件之间的兼容性差。本人工作的山东省千佛山医院医学工程部,医疗设备信息化管理主要进行了医疗设备固定资产、卫生材料的计算机管理,并未进行医疗设备的全过程信息化管理。
本课题针对我院医疗设备管理的现状和信息化要求,设计一套操作简单、实用的医疗设备信息管理系统。该系统要反映医疗设备的两种运动状态,物质运动状态和价值运动状态,以便于使用者、管理者和决策者比较清晰地掌握设备的运动过程;涵盖医疗设备管理的各个方面,做到全面、动态的管理;改善设备管理人员的工作强度,提高工作效率,为领导层提供决策依据。
本课题研究的信息系统以我院现有的HIS系统服务器和计算机作为硬件设备,是HIS系统的一部分。系统结构采用C/S结构,数据库采用Microsoft SQLsever 2000,客户端程序利用集成开发工具Visual Basic 6.0进行各种设计。
该论文首先介绍了医疗设备管理信息化的意义,医疗设备管理的要点,医疗设备信息系统的现状,指出了我院现有信息系统的不足,提出了本课题的工作目标和现实意义,然后论述了该系统的理论基础和方法,对医疗设备信息系统作了分析,进行数据库设计,最后展示了系统实现的相关的页面。
该系统设计了设备申请管理、设备计划管理、设备合同管理、设备验收管理、设备固定资产管理、设备使用管理、设备计量管理、设备维护管理、系统设置九项功能,不同权限的用户进入该系统实现不同的管理功能及分析查询功能。通过对该系统的试运行,本文的设计是基本成功的。基本完成了医疗设备的全过程管理,规范了日常的工作流程,减轻了工作强度,提高了办事效率,并可为领导层提供决策依据。
With the rapid development of advanced technologies, hospitals are becoming more and more rely on the medical instruments to create precision diagnostic tools for human illness. In the meantime, medical instruments management is playing important role in the hospital management. With higher and higher expectation for medical instruments management, the process for medical instrument purchase, maintenance, and discarding needs to be under the strict scientific management. In order to get the best benefit from the advanced medical instruments, it is necessary for hospitals to implement information management system to improve their management by its advanced scientific method.
Currently, most of information management systems for medical instruments are designed and developed based on different business requirements from different hospitals. Additionally, utilizing different software platforms, database servers, and operating systems causes the very poor compatibility between the systems. Our medical engineering department of QianfoShan hospital has implemented the information management only for the portion of asset of medical instrument, hygiene materials but not for the whole process for medical instrument yet.
In the project, I designed easy-to-use and practical information management system of medical instruments for QianfoShan hospital. The system displays the two dynamic process statuses on material and value, which can help users, administrators and managers to view the dynamic process on the instruments based on their roles. It covers all the aspects of medical instrument management so that we can manage all the instruments dynamically and improve our workload and performance. It also provides the evidence for the decision makers.
The proposed information management system integrated with QianfoShan hospital's Hospital Information System (HIS). Its system architecture is based on Client/Server (C/S) model and the back-end database is Microsoft SQL 2000 server. Client side application is designed and developed by Visual Basic 6.0 and its library.
This thesis firstly introduced the practical significance and the main points as well as the situation of medical instrument information management system. It went on to point out drawbacks existed in our own information system. Then the goal and practical significance of this project was highlighted. Finally, this thesis described the theoretical basis and method of this system, followed by system analysis, database design, and its interface implementation.
The system provides the following functionalities and features: instrument applying management, instrument planning management, instrument contracting management, instrument verifying management, instrument asset management, instrument usage management, instrument measurement management, instrument maintenance management, and system configuration. It provides the different functionalities for information management and retrieval based on the different privileges. From the project pilot result, it is concluded that the project is very successful on its design and the implement of the whole process management. In the meantime, it establishes the work routine and improves users' workload and performance. Additionally, it will provide the evidence for management people to make decision on medical instrument management process.
目前的医疗设备信息管理系统都是各医院根据自身的特点和要求设计开发的,软件开发平台、使用的数据库、前后台操作系统各不一样,各软件之间的兼容性差。本人工作的山东省千佛山医院医学工程部,医疗设备信息化管理主要进行了医疗设备固定资产、卫生材料的计算机管理,并未进行医疗设备的全过程信息化管理。
本课题针对我院医疗设备管理的现状和信息化要求,设计一套操作简单、实用的医疗设备信息管理系统。该系统要反映医疗设备的两种运动状态,物质运动状态和价值运动状态,以便于使用者、管理者和决策者比较清晰地掌握设备的运动过程;涵盖医疗设备管理的各个方面,做到全面、动态的管理;改善设备管理人员的工作强度,提高工作效率,为领导层提供决策依据。
本课题研究的信息系统以我院现有的HIS系统服务器和计算机作为硬件设备,是HIS系统的一部分。系统结构采用C/S结构,数据库采用Microsoft SQLsever 2000,客户端程序利用集成开发工具Visual Basic 6.0进行各种设计。
该论文首先介绍了医疗设备管理信息化的意义,医疗设备管理的要点,医疗设备信息系统的现状,指出了我院现有信息系统的不足,提出了本课题的工作目标和现实意义,然后论述了该系统的理论基础和方法,对医疗设备信息系统作了分析,进行数据库设计,最后展示了系统实现的相关的页面。
该系统设计了设备申请管理、设备计划管理、设备合同管理、设备验收管理、设备固定资产管理、设备使用管理、设备计量管理、设备维护管理、系统设置九项功能,不同权限的用户进入该系统实现不同的管理功能及分析查询功能。通过对该系统的试运行,本文的设计是基本成功的。基本完成了医疗设备的全过程管理,规范了日常的工作流程,减轻了工作强度,提高了办事效率,并可为领导层提供决策依据。
With the rapid development of advanced technologies, hospitals are becoming more and more rely on the medical instruments to create precision diagnostic tools for human illness. In the meantime, medical instruments management is playing important role in the hospital management. With higher and higher expectation for medical instruments management, the process for medical instrument purchase, maintenance, and discarding needs to be under the strict scientific management. In order to get the best benefit from the advanced medical instruments, it is necessary for hospitals to implement information management system to improve their management by its advanced scientific method.
Currently, most of information management systems for medical instruments are designed and developed based on different business requirements from different hospitals. Additionally, utilizing different software platforms, database servers, and operating systems causes the very poor compatibility between the systems. Our medical engineering department of QianfoShan hospital has implemented the information management only for the portion of asset of medical instrument, hygiene materials but not for the whole process for medical instrument yet.
In the project, I designed easy-to-use and practical information management system of medical instruments for QianfoShan hospital. The system displays the two dynamic process statuses on material and value, which can help users, administrators and managers to view the dynamic process on the instruments based on their roles. It covers all the aspects of medical instrument management so that we can manage all the instruments dynamically and improve our workload and performance. It also provides the evidence for the decision makers.
The proposed information management system integrated with QianfoShan hospital's Hospital Information System (HIS). Its system architecture is based on Client/Server (C/S) model and the back-end database is Microsoft SQL 2000 server. Client side application is designed and developed by Visual Basic 6.0 and its library.
This thesis firstly introduced the practical significance and the main points as well as the situation of medical instrument information management system. It went on to point out drawbacks existed in our own information system. Then the goal and practical significance of this project was highlighted. Finally, this thesis described the theoretical basis and method of this system, followed by system analysis, database design, and its interface implementation.
The system provides the following functionalities and features: instrument applying management, instrument planning management, instrument contracting management, instrument verifying management, instrument asset management, instrument usage management, instrument measurement management, instrument maintenance management, and system configuration. It provides the different functionalities for information management and retrieval based on the different privileges. From the project pilot result, it is concluded that the project is very successful on its design and the implement of the whole process management. In the meantime, it establishes the work routine and improves users' workload and performance. Additionally, it will provide the evidence for management people to make decision on medical instrument management process.
引文
[1]陈鹏岗.医院信息管理系统设计与开发实施的研究[D].西安电子科技大学,2005.10.
[2]李包罗,迟宝兰.计算机化的医院信息系统与医院管理[J].中国医院,1997,(1):25-28.
[3]郑守臣,韩迎辰.医疗卫生设备管理与应用[M].济南:黄河出版社,1997.
[4]王黎明,蒋红兵,曹安之.医疗设备全程管理[J].中国医院,2004,(7):54-56.
[5]谢松城,徐伟伟.医疗设备管理与技术规范[M].杭州:浙江大学出版社,2004.
[6]于京杰,陈锐华等.医疗设备的购置管理[J].医疗设备信息,2007,(5):61-63.
[7]姜远海.临床医学工程技术[M].北京:科学出版社,2002.
[8]万超瑾.医疗设备固定资产管理的相关问题[J].医疗设备信息,2004,(3):61-62.
[9]贾国良.对医疗设备使用的制度化管理[J],医疗卫生装备,2007,(7):51-52.
[10]曹少平,孙国君等.现代医院医疗设备的计量管理探讨[J].上海生物医学工程,2006,(4):253-254.
[11]荆世臻.医疗设备的维修管理与质量控制[J].医疗装备,2004,(9):41-42.
[12]于京杰,戚仕涛,王羽.医疗设备报废的科学管理[J].中国医疗设备,2008,(01):73-74.
[13]段贵军,张福林,宋赞等.区域医疗设备信息管理系统的研究[J].中华医学科研管理杂志,2005,18(5):301-303.
[14]李湘平.医院信息化管理的现状与前景[J].医学信息,2004,17(2):74-75.
[15]杨丰,温铁祥,涂圣贤.基于C/S模式的医疗耗材管理系统设计与开发[J].医疗卫生装备,2006,(9):45-47.
[16]郑理华,王华,丁效军.医疗设备采购合同管理系统的建立[J].医疗设备信息,2007,(04):64-65.
[17]张詠波.网络版的医疗设备资产管理模块设计与应用[J].医疗设备信息,2006,(12):26-27.
[18]陈维平,黄晓庆,任俐,张德昌.医院医学计量器具计算机管理系统的设计方案[J].医疗设备信息,2001,(11)4-9.
[19]赵巍,刘锋,周爱柱.医疗设备维护管理信息系统的开发与研究[J].医疗设备信息,2006(11):26-28.
[20]田蕾.医院设备管理系统的开发[J].医疗设备信息,2007,(05)38-39.
[21]闪四清.数据库系统原理与应用.北京:清华大学出版社,2001.
[22]Abraham Silberschatz,Henry F.Korth,S.Sudarshan.数据库系统概念[M].北京:机械工业出版社,2004.
[23](美)Dusan Pet ko vic.SQL Server 2000基础教程[M].北京:清华大学出版社,2001.
[24]Dalton Patrick.SQL server 2000 black book[M].Scottsdale,AZ:Coriolis Group Books,2001.
[25][美]Jeffrey R Shap iro.SQL Server 2000参考大全[M].北京:清华大学出版社,2002
[26]Shapiro,Jeffrey R.SQL Server 2000 the complete reference[M].Berkeley,Calif.:Osbore/McGraw Hill,c2001.
[27]Paul Nielson.SQL Server 2000 宝典[M].北京:中国铁道出版社,2004.
[28]Sunderic,Dejan.SQL Server 2000 stored procedure & XML programming[M].New York:McGraw-Hill/Osborne,c2003.
[29]袁鹏飞.SQL SERVER 2000数据库系统管理[M].北京:人民邮电出版社,2001.
[30]刘卫宏.SQL SERVER 2000实用教程[M].北京:科学出版社,2003.
[31]Vieira,Robert.Professional SQL Server 2000 programming[M].Indianapolis,IN:Wrox,c2003.
[32]Roger Jennings.Visual Basic6数据库开发人员指南[M].北京:机械工业出版社,1999.
[33]E.Winemiller等.Visual Basic6数据库开发[M].北京:清华大学出版社,1999.
[34]Aitken,Peter G Visual Basic 6 programming blue book[M].Scottsdale,Ariz.:Coriolis Group Books,c2002.
[35]王福成,周铁柱,黄淼云.Visual Basic6.0数据库开发指南[M].北京:清华大学出版社,2000.
[36]罗喆帅,丁凉等.Visual Basic网络开发实例[M].北京:北京伯通电子出版社,2003.
[37]白鹏.Visual Basic编程实例与技巧-数据库编程[M].北京:科学出版社,2003.
[38]梁普选.新编Visual Basic程序设计教程[M].北京:电子工业出版社,2002.
[39]白鹏,莫卫东.Visual Basic 6.0 ADO数据访问篇[M].西安:西安交通大学出版社,2001.
[40]将铁海,刘朝晖.ADO控件访问数据库的各种技巧探讨[J].微计算机信息,2003,19(1):65-66.
[41]汪晓平,钟军.Visual Basic网络通信协议分析与应用实现.北京:人民邮电出版社,2003.
[42][美]微软公司.Querying Microsoft SQL Server 2000 With Transact-SQL[M].北京:清华大学出版社,2001.
[43][美]微软公司.Programming a Microsoft SQL Server 2000 Database[M].北京:清华大学出版社,2002.
[44]Michael Otey、Paul Conte著.SQL Server 2000开发指南[M].清华大学出版社,2002
[45]Microsoft Corporation.Microsoft SQL Server 2000管理员指南.Microsoft Press,2001.11
[2]李包罗,迟宝兰.计算机化的医院信息系统与医院管理[J].中国医院,1997,(1):25-28.
[3]郑守臣,韩迎辰.医疗卫生设备管理与应用[M].济南:黄河出版社,1997.
[4]王黎明,蒋红兵,曹安之.医疗设备全程管理[J].中国医院,2004,(7):54-56.
[5]谢松城,徐伟伟.医疗设备管理与技术规范[M].杭州:浙江大学出版社,2004.
[6]于京杰,陈锐华等.医疗设备的购置管理[J].医疗设备信息,2007,(5):61-63.
[7]姜远海.临床医学工程技术[M].北京:科学出版社,2002.
[8]万超瑾.医疗设备固定资产管理的相关问题[J].医疗设备信息,2004,(3):61-62.
[9]贾国良.对医疗设备使用的制度化管理[J],医疗卫生装备,2007,(7):51-52.
[10]曹少平,孙国君等.现代医院医疗设备的计量管理探讨[J].上海生物医学工程,2006,(4):253-254.
[11]荆世臻.医疗设备的维修管理与质量控制[J].医疗装备,2004,(9):41-42.
[12]于京杰,戚仕涛,王羽.医疗设备报废的科学管理[J].中国医疗设备,2008,(01):73-74.
[13]段贵军,张福林,宋赞等.区域医疗设备信息管理系统的研究[J].中华医学科研管理杂志,2005,18(5):301-303.
[14]李湘平.医院信息化管理的现状与前景[J].医学信息,2004,17(2):74-75.
[15]杨丰,温铁祥,涂圣贤.基于C/S模式的医疗耗材管理系统设计与开发[J].医疗卫生装备,2006,(9):45-47.
[16]郑理华,王华,丁效军.医疗设备采购合同管理系统的建立[J].医疗设备信息,2007,(04):64-65.
[17]张詠波.网络版的医疗设备资产管理模块设计与应用[J].医疗设备信息,2006,(12):26-27.
[18]陈维平,黄晓庆,任俐,张德昌.医院医学计量器具计算机管理系统的设计方案[J].医疗设备信息,2001,(11)4-9.
[19]赵巍,刘锋,周爱柱.医疗设备维护管理信息系统的开发与研究[J].医疗设备信息,2006(11):26-28.
[20]田蕾.医院设备管理系统的开发[J].医疗设备信息,2007,(05)38-39.
[21]闪四清.数据库系统原理与应用.北京:清华大学出版社,2001.
[22]Abraham Silberschatz,Henry F.Korth,S.Sudarshan.数据库系统概念[M].北京:机械工业出版社,2004.
[23](美)Dusan Pet ko vic.SQL Server 2000基础教程[M].北京:清华大学出版社,2001.
[24]Dalton Patrick.SQL server 2000 black book[M].Scottsdale,AZ:Coriolis Group Books,2001.
[25][美]Jeffrey R Shap iro.SQL Server 2000参考大全[M].北京:清华大学出版社,2002
[26]Shapiro,Jeffrey R.SQL Server 2000 the complete reference[M].Berkeley,Calif.:Osbore/McGraw Hill,c2001.
[27]Paul Nielson.SQL Server 2000 宝典[M].北京:中国铁道出版社,2004.
[28]Sunderic,Dejan.SQL Server 2000 stored procedure & XML programming[M].New York:McGraw-Hill/Osborne,c2003.
[29]袁鹏飞.SQL SERVER 2000数据库系统管理[M].北京:人民邮电出版社,2001.
[30]刘卫宏.SQL SERVER 2000实用教程[M].北京:科学出版社,2003.
[31]Vieira,Robert.Professional SQL Server 2000 programming[M].Indianapolis,IN:Wrox,c2003.
[32]Roger Jennings.Visual Basic6数据库开发人员指南[M].北京:机械工业出版社,1999.
[33]E.Winemiller等.Visual Basic6数据库开发[M].北京:清华大学出版社,1999.
[34]Aitken,Peter G Visual Basic 6 programming blue book[M].Scottsdale,Ariz.:Coriolis Group Books,c2002.
[35]王福成,周铁柱,黄淼云.Visual Basic6.0数据库开发指南[M].北京:清华大学出版社,2000.
[36]罗喆帅,丁凉等.Visual Basic网络开发实例[M].北京:北京伯通电子出版社,2003.
[37]白鹏.Visual Basic编程实例与技巧-数据库编程[M].北京:科学出版社,2003.
[38]梁普选.新编Visual Basic程序设计教程[M].北京:电子工业出版社,2002.
[39]白鹏,莫卫东.Visual Basic 6.0 ADO数据访问篇[M].西安:西安交通大学出版社,2001.
[40]将铁海,刘朝晖.ADO控件访问数据库的各种技巧探讨[J].微计算机信息,2003,19(1):65-66.
[41]汪晓平,钟军.Visual Basic网络通信协议分析与应用实现.北京:人民邮电出版社,2003.
[42][美]微软公司.Querying Microsoft SQL Server 2000 With Transact-SQL[M].北京:清华大学出版社,2001.
[43][美]微软公司.Programming a Microsoft SQL Server 2000 Database[M].北京:清华大学出版社,2002.
[44]Michael Otey、Paul Conte著.SQL Server 2000开发指南[M].清华大学出版社,2002
[45]Microsoft Corporation.Microsoft SQL Server 2000管理员指南.Microsoft Press,2001.11