硕士本科论文医药企业综合业务管理系统的设计与实现.docx
- 文档编号:29818318
- 上传时间:2023-07-27
- 格式:DOCX
- 页数:88
- 大小:1.24MB
硕士本科论文医药企业综合业务管理系统的设计与实现.docx
《硕士本科论文医药企业综合业务管理系统的设计与实现.docx》由会员分享,可在线阅读,更多相关《硕士本科论文医药企业综合业务管理系统的设计与实现.docx(88页珍藏版)》请在冰豆网上搜索。
硕士本科论文医药企业综合业务管理系统的设计与实现
医药企业综合业务管理系统的设计与实现
摘要
随着计算机技术的发展,医药企业都建立了小型的信息管理系统,为医药企业的管理和服务工作发挥了重大作用。
但随着计算机网络技术、大型数据库技术的推广与应用,医药企业的信息管理系统不论在技术水平还是数据处理水平,都无法满足日益发展的社会需求和本身业务的需要。
数据的共享性不高、系统的稳定性差、业务的处理效率低下等诸多问题制约着医药企业业务的发展。
因此,利用最新的计算机技术、计算机网络技术、大型数据库技术以及面向对象的开发技术,开发一套满足医药企业实际业务需求的医药企业综合业务管理系统是非常必要的。
本系统基于C/S开发模式,采用SQLServer2000作为后台数据库,PowerBuilder9.0作为前台开发工具,按照软件工程的设计开发规范和数据库的设计原则,结合医药企业的实际业务需求,进行了医药企业综合业务管理系统的设计与开发。
在满足设计原则、总体目标的基础上,给出了医药企业综合业务管理系统的设计思想和设计模型;在需求分析的基础上,描述了医药企业综合业务管理系统的功能和性能;给出了药品的购进入库管理、药品的出库管理、药品的库存管理以及药品的GSP规范管理等业务的实现方法和实现过程;对医药企业药品购进出入库、药品销售出库、药品价格管理、药品效期管理等诸多方面提供了良好的记录程序。
并向用户提供了以拼音码为主的多种、多条件组合模式的查询和统计,为用户及时准确地统计和查询所需要的信息提供了很大的方便,对药品的管理更加实时有效。
本系统操作简单,实用方便,可操作性和实用性强,具有技术先进、功能完善、性高稳定、安全性程度高等优点,基本实现了医药企业综合业务管理的信息化、规范化、安全化、科学化。
关键词:
医药企业;医药信息;管理系统;powerbuilder;
DesignandImplementationofIntegratedServicesManagementSysteminPharmaceuticalEnterprises
Abstract
Withthedevelopmentofcomputertechnology,pharmaceuticalenterpriseshaveestablishedsmallscaleinformationmanagementsystem;itplaysamajorroleforpharmaceuticalenterprises’managementandservice.Butwiththedevelopmentofcomputernetworktechnology,thepromotionandapplicationoflarge-scaledatabasetechnology,thesmallinformationmanagementsystemofpharmaceuticalenterprises,whetherintechnologyordataprocessing,areunabletomeetthegrowingneedsofthecommunityandtheirownbusinessneeds,suchproblemsaslowdatasharing,poorsystemstability,inefficientoperationsandmanyotherissuesrestrictedthedevelopmentofthepharmaceuticalenterprises.Therefore,itisverynecessaryusingthelatestcomputertechnology,computernetworktechnology,large-scaledatabasetechnologyandobject-orienteddevelopmenttechniques,todeveloparealinformationmanagementsystemtomeettheneedsofthepharmaceuticalenterprisesinformationmanagementandservices.
ThissystemisdevelopedbasedonC/Smodel,usingSQLServer2000databaseasabackground,PowerBuilder9.0asforegrounddevelopmenttool,toimplementthepharmaceuticalenterprisesIntegratedServicesmanagementsystemdesignanddevelopmentaccordingtosoftwareengineeringdesignanddevelopmentprinciplesofdatabase,combinedwiththepracticalbusinessneeds.WegiventhepharmaceuticalenterprisesIntegratedServicesManagementSystemdesignideasanddesignmodelaswellasmeetingthedesignprinciples,consideringtheoverallobjectives,todescribethefunctionalityandperformanceofpharmaceuticalenterprisesIntegratedServicesmanagementsystembasedondemandanalysis;giventheimplementationandrealizationprocessofdrugsstoragemanagement,drugdeliverymanagement,drugsinventorymanagementanddrugGSPmanagement;providedagoodrecordsprogramforpharmaceuticalenterprisesdrugslistofreceiptnoteandissuenote,managementofdrugprices,drugExpirationdatemanagement,andsoon.Andprovideduserswiththequerytermsandstatisticsofavarietyofthealphabetcode,multi-combinationmode,providedagreatconveniencewithtimelyandaccuratestatisticsquerywhichcontainstheinformationtheyneed,themanagementofdrugsiseffective.
Thesystemissimpleandpractical,withadvancedtechnology,fullyfunction,highstability,highdegreeofsecurity,realizedthepharmaceuticalenterprisesIntegratedServicesmanagementwithinformationtechnology,standardization,security,scientific.
Keywords:
PharmaceuticalEnterprises;MedicalInformation;ManagementSystem;Powerbuilder
声明········································································································I
中文摘要·······························································································II
ABSTRACT·························································································III
第1章绪论··························································································1
1.1选题背景及研究意义··········································································1
1.2项目的来源······················································································2
1.3本文的开发工作及其组织····································································4
第2章相关理论研究··········································································7
2.1数据库技术······················································································7
2.1.1数据库···················································································7
2.1.2数据库的体系结构····································································8
2.2SQLServer2000技术········································································9
2.3PowerBuilder9.0软件开发工具···························································10
2.3.1PowerBuilder语言的特点·························································11
2.3.2PowerBuilder应用构成的概念模式·············································11
2.3.3PowerBuilder主要应用范围·······················································13
第3章需求分析·················································································15
3.1医药企业业务管理现状·····································································15
3.2医药企业业务处理的工作流程····························································16
3.3医药企业综合业务管理系统的功能需求················································17
3.4实体分析及E-R图··········································································20
3.4.1医药企业综合业务管理系统实体联系分析····································21
3.4.2医药企业综合业务管理系统E-R图·············································22
3.5数据词典·······················································································25
3.6小结····························································································26
第4章系统设计·················································································27
4.1系统总体设计·················································································27
4.1.1系统设计原则········································································27
4.1.2系统体系结构········································································28
4.2系统功能设计·················································································28
4.2.1购进药品管理功能··································································29
4.2.2销售开票管理功能··································································31
4.2.3药品库存管理功能··································································33
4.2.4盘点调价管理功能··································································34
4.2.5GSP规范管理········································································36
4.2.6系统维护功能········································································37
4.3数据库设计···················································································38
4.3.1数据库设计原则····································································38
4.3.2SOLServer2000关系数据库的约束条件····································38
4.3.3关系数据库的规范化设计······················································39
4.3.4数据库表逻辑结构设计···························································40
4.4系统安全设计·················································································43
4.5小结·····························································································43
第5章系统实现·················································································47
5.1系统环境配置·················································································47
5.1.1系统硬件环境········································································47
5.1.2系统软件环境········································································48
5.2系统实现的关键技术········································································48
5.2.1PowerBuilder的数据窗口技术··················································48
5.2.2数据库事务处理·····································································48
5.2.3数据库的数据连接··································································49
5.3系统主要功能的实现········································································50
5.3.1系统登录模块的实现·······························································50
5.3.2药品购进模块的实现·······························································51
5.3.3药品购进查询管理模块····························································53
5.3.4药品销售管理模块··································································55
5.3.5药品销售出库查询管理模块······················································56
5.3.6药品效期管理模块··································································58
5.4小结·····························································································59
第6章系统测试·················································································61
6.1软件测试原则和过程········································································61
6.1.1软件测试原则········································································61
6.1.2软件测试的过程·····································································62
6.2测试用例的设计及测试过程·······························································63
6.2.1登录安全性测试·····································································63
6.2.2系统基础数据字典维护测试······················································64
6.2.3药品购进入库系列模块测试······················································64
6.2.4药品销售出库系列模块测试······················································65
6.2.5药品效期管理模块··································································66
6.3测试结论·······················································································66
6.4小结·····························································································66
第7章结论·························································································67
参考文献······························································································69
致谢·················································
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 硕士 本科 论文 医药企业 综合 业务 管理 系统 设计 实现
![提示](https://static.bdocx.com/images/bang_tan.gif)