基于.NET的门诊药品查询系统的设计与实现
毕业设计(论文)
基于.NET的门诊药品查询系统的设计与实现
论文作者姓名:
申请学位专业:
申请学位类别:
指导教师姓名,职称,:
论文提交日期:
基于.NET的门诊药品查询系统的设计与实现
摘 要
随着计算机技术的发展，越来越多的行业实现了管理的信息化和自动化，医药行业也不例外。然而在传统门诊药房中，医院极少给病人提供一个独立的平台来查询病人需要的药品信息。价格不透明，信息不完善等多方原因，导致医院乱收费、过度治疗、百姓看病难、看病贵等。
本文将介绍基于B/S模式的门诊药品查询系统的设计和开发工作，涵盖了以下三个方面的内容:1.介绍本系统开发中使用到的ASP.NET+SQL Server技术。2.介绍门诊药品查询系统的后台设计，包括数据库表的设计等。3.介绍门诊药品查询系统各功能的具体实现。本系统最终实现门诊药品信息公告，病人对药品的查询，药品管理，药品报警,系统管理等功能。
门诊药品查询系统有着很好的应用前景，用它来代替传统的手工查询，实现药品查询的网络化管理是一个必然的趋势。随着计算机技术和网络技术的发展。它的功能将会得到不断的发展和完善。
关键词:门诊药品;查询;药品报警;ASP.NET;SQL Server2000
The Design and Implementation for Outpatient Pharmacy
Query System
Abstract
As computer technique develops, more and more trades implement information retrieval and management automation, so as to pharmacy, however, in the traditional outpatient pharmacy, the hospital rarely provides an independent platform for patient
query, and the price is not transparent, The information is imperfect.
The paper introduces the design and implementation of outpatient pharmacy query system. And this paper contains three aspects: first, introduction ASP.NET and SQL Server technique; second, introduction the design of the database; third, introduction the implementation of query system’s sub-functions; At last,
implementation of information announcement, searching and pharmacy management and system management are introduced in detail.
Outpatient pharmacy query system holds good prospect, which could replace traditional manual query, accompany with computer and network techniques developing, its function will be improved more and more improvement.
Key words: Outpatient Pharmacy; Query; Pharmacy inventory alarm;
ASP.NET; SQL Server2000
目 录
论文总页数:24页
1引言 ................................................................................................................................... 1
1.1课题背景 ..................................................................................................................... 1 1.2课题意义 ..................................................................................................................... 1 2相关理论基础..................................................................................................................... 2 2.1 SQL SERVER2000数据库 ................................................................................................ 2 2.2 B/S模式介绍 .............................................................................................................. 2 2.3使用的开发语言和环境介绍 ........................................................................................ 3 2.3.1 C#语言 ................................................................................................................ 3 2.3.2 Visual Studio的使用........................................................................................ 4 2.4 ADO.NET的使用 .......................................................................................................... 4 3需求分析和设计方案 .......................................................................................................... 4 3.1需求分析 ..................................................................................................................... 4 3.1.1性能需求 ............................................................................................................. 4 3.1.2功能需求 ............................................................................................................. 5 3.2设计方案 ..................................................................................................................... 5 3.2.1系统设计和要求.................................................................................................... 5 3.3 系统流程 .................................................................................................................... 6 4门诊药品查询系统设计流程 ............................................................................................... 6 4.1数据库表设计 ............................................................................................................. 6 4.1.1 administrator(系统管理员表) ........................................................................ 7
4.1.2 tb_user(药房管理员和门诊医生表) ................................................................... 7
4.1.3 tb_medicine(药品表) ..................................................................................... 7 4.1.4 data(药品和用户类型表) ................................................................................... 8 4.1.5 databiao(公告表) .............................................................................................. 8 4.2具体页面实现 ............................................................................................................. 8 4.2.1系统登录 ............................................................................................................. 8 4.2.2门诊药品查询 .................................................................................................... 10 4.2.3药房管理 ........................................................................................................... 14 4.2.4首页公告栏模块: .............................................................................................. 20 4.2.5系统管理员操作页面 ......................................................................................... 21
5系统测试 .......................................................................................................................... 21 5.1测试环境 ................................................................................................................... 21 5.2测试结果 ................................................................................................................... 21 结 论 ............................................................................................................................. 22
参考文献 ............................................................................................................................. 22
致 谢 ............................................................................................................................. 23
声 明 ............................................................................................................................. 24