【正文】 I 醫(yī)藥 進(jìn)銷存 管理系統(tǒng) II 摘 要 當(dāng)今時代是飛速發(fā)展的信息時代。在各行各業(yè)中都離不開信息的處理。這正是計算機(jī)被廣泛用于信息管理系統(tǒng)的原因，計算 機(jī)的最大好處就是利用它能夠進(jìn)行信息管理。使用計算機(jī)進(jìn)行信息控制， 不僅提高了工作效率，而且大大提高了其安全性，尤其對復(fù)雜的信息管理，計算機(jī)能夠充分的發(fā)揮它的優(yōu)越性。計算機(jī)進(jìn)行信息管理與信息管理系統(tǒng)的開發(fā)密切相關(guān)。 系統(tǒng) 的開發(fā)是系統(tǒng)管理的前提。 醫(yī)藥管理系統(tǒng)是現(xiàn)代化在線醫(yī)藥管理必不可少的基礎(chǔ)設(shè)施與技術(shù)支撐環(huán)境。本系統(tǒng)前臺采用 DreamWeaver 開發(fā)，后臺采用 SQServer 2020 作為數(shù)據(jù)庫開發(fā)工具，這些技術(shù)目前相對比較成熟，方便產(chǎn)品的維護(hù)。本系統(tǒng)可以實現(xiàn)用戶在線注冊、登錄、修改個人信息，用戶進(jìn)行藥品選購、查看藥品詳細(xì)信息、提交訂單信息，管理員對藥品、藥品分類、用戶信息和訂單信息進(jìn)行在線維護(hù)和管理。 關(guān)鍵詞： 醫(yī)藥管理系統(tǒng) ； 醫(yī)藥 ； 管理系統(tǒng) III Abstract Today is the rapid development of the information age. In professions rely heavily on information processing. This is the puter which is widely used in information management system reason, the biggest advantage of using puter is information management that it can. Using puter information control, not only improves work efficiency, but also greatly improves its safety, especially for plex information management, the puter can fully exert its advantages. Computer information management and information management system development are closely related. The development of integration is the premise of system management. Medical management system is essential to modern online medicine management of infrastructure and technology support environment. This system receptionist DreamWeaver development by using SQLServer 2020, backstage database development tools, 2020 as these technologies currently relatively mature, convenient products maintenance. This system can realize users online register, login, modify, personal information, drug users in the choose and buy, check drug detailed information, submitting an order for drugs, the information, the administrator drug classification, user information and order information for online maintenance and management. Keywords: Medical Administrative System。Medicine。Administrative System IV 目 錄 1 引言 ................................................................................................................................... 1 研究課題的背景 ........................................................................................................ 1 項目提出的意義 ........................................................................................................ 1 2 研究現(xiàn)狀及設(shè)計目標(biāo) ....................................................................................................... 3 醫(yī)藥進(jìn)銷存系統(tǒng)的現(xiàn)狀 ............................................................................................ 3 醫(yī)藥進(jìn)銷 存管理系統(tǒng)的特點 .................................................................................... 4 現(xiàn)行研究存在的問題 ................................................................................................ 4 此系統(tǒng)要達(dá)到的設(shè)計目標(biāo) ........................................................................................ 4 經(jīng)濟(jì)效益分析 ............................................................................................................ 5 3 關(guān)鍵問題及分析 ............................................................................................................... 6 研究設(shè)計中要解決的問題 ........................................................................................ 6 研究的方法及措施 .................................................................................................... 6 具體實現(xiàn)中采用的關(guān)鍵技術(shù)分析 ............................................................................ 7 4 需求分析 ........................................................................................................................... 8 usecase 用例圖分析 ................................................................................................... 8 系統(tǒng)主要業(yè)務(wù)流程 .................................................................................................... 8 功能需求 .................................................................................................................... 9 開發(fā)環(huán)境及工具 ........................................................................................................ 9 5 系統(tǒng)設(shè)計 ......................................................................................................................... 11 系統(tǒng)構(gòu)架 .................................................................................................................. 11 系統(tǒng)模塊設(shè)計 .......................................................................................................... 12 系統(tǒng) ER 圖設(shè)計 ...................................................................................................... 12 6 系統(tǒng)實現(xiàn)及測試 ............................................................................................................. 14 系統(tǒng)實現(xiàn) .................................................................................................................. 14 數(shù)據(jù)庫的邏輯設(shè)計 ............................................................................................ 14 數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計 ............................................................................................ 14 系統(tǒng)登錄模塊的實現(xiàn) ........................................................................................ 19 V 藥品信息管理模塊的實現(xiàn) ................................................................................ 21 客戶信息管理模塊的實現(xiàn) ................................................................................ 22 銷售信息管理模塊的實現(xiàn) ................................................................................ 24 供應(yīng)商信息管理模塊的實現(xiàn) ............................................................................ 25 采購信息管理模塊的實現(xiàn) ................................................................................ 25 庫存信息管理模塊的實現(xiàn) ................................................................................ 26 用戶管理模塊的實現(xiàn) ...................................................................................... 28 系統(tǒng)測試 .................................................................................................................. 28 軟件測試的目的和原則 .................................................................