【正文】 倉庫管理，各制藥生產(chǎn)車間所需原料時到倉庫領(lǐng)取，生產(chǎn)制作成成品藥再調(diào)到倉庫 ,而成品藥由銷售部統(tǒng)一銷售。 Fireworks 8：它 是用來設(shè)計和制作專業(yè)化網(wǎng)頁圖形的終極解決方案。 Eclipse ：它 是一個開放源代碼、基于 Java 的可擴(kuò)展開發(fā)平臺 。 通過參考一些比較著名的進(jìn)銷存管理系統(tǒng)，如一博醫(yī)藥進(jìn)銷存管理系統(tǒng)（下載網(wǎng)址： 解，設(shè)計并確定了本系統(tǒng)的基本功能，它具有生產(chǎn)管理，庫存管理，銷售管理，往來管理等操作，能滿足制藥企業(yè)日常管理的一般要求。一個是藥品的銷售工作是非常復(fù)雜的銷售工作。在法規(guī)健全的國家中，除 OTC（ Over the Counter，非處方產(chǎn)品）產(chǎn)品外，藥品在 大眾媒介上直接面對患者作廣告是違法的（我國在這方面限定不是很嚴(yán)格，目前趨向越來越嚴(yán)格）。據(jù)預(yù)測，到 2020年，中國將取代美國，成為世界上最大的醫(yī)療保健品市場（ Business Week 援引WHO的預(yù)測）。本課題針對制藥企業(yè)的情況，設(shè)計開發(fā)了一個具有基本功能的“進(jìn)銷存信息管理系統(tǒng)”，實現(xiàn)企業(yè)信息管理的現(xiàn)代化。因此，對企業(yè)管理信息系統(tǒng)的研究具有良好的實際運用價值。 關(guān)鍵詞 ：進(jìn)銷存管理系統(tǒng)，制藥企業(yè)， JSP， SQL Server2021 I ABSTRACT The MIS system has already got an extensive usage in every trade, obtained good economy and the performance of management, in the meantime, the business enterprise manage of informationbased is the marking of modern and successful business enterprise. Therefore manage the research of information system to have good actual usage value to the business enterprise. This topic aims at a circumstance of make the medicine business enterprise and the design developped a enter to sell to save an information management system which has basic function and carry out the modernization of management of the business enterprise information. That system adoption B/S structure, according to the WEB method, have an enter of business enterprise product, raw material to sell, stock management etc. operation. The system operation is simple, interface amity, vivid and practical, the safety be stable, basic match to make a medicine business enterprise into sell a request of save the information management. Keywords: ERP , pharmacy corporation, JSP, SQL Server2021 II 目錄 摘要 .................................................................................................................................... I ABSTRACT ....................................................................................................................... I 第 1 章 緒論 ..................................................................................................................... 1 背景 ........................................................................................................................ 1 研究內(nèi)容 ................................................................................................................ 2 第 2 章 需求分析 ............................................................................................................. 3 調(diào)查分析 ................................................................................................................. 3 生產(chǎn)管理 .......................................................................................................... 3 銷售業(yè)務(wù) .......................................................................................................... 3 庫存管理 .......................................................................................................... 3 往來管理 .......................................................................................................... 4 存在的問題 ............................................................................................................. 4 生產(chǎn)管理主要問題 .......................................................................................... 4 藥品銷售主要問題 .......................................................................................... 4 庫存管理主要問題 .......................................................................................... 5 往來管理主要問題 .......................................................................................... 5 系統(tǒng)要求 ................................................................................................................ 5 生產(chǎn)管理 .......................................................................................................... 5 基礎(chǔ)信息管理 .................................................................................................. 6 銷售管理 .......................................................................................................... 6 庫存管理 .......................................................................................................... 6 往來管理 .......................................................................................................... 7 查詢統(tǒng)計管理 .................................................................................................. 7 系統(tǒng)設(shè)置 .......................................................................................................... 7 可行性分析 ............................................................................................................ 7 本章小結(jié) ................................................................................................................ 8 III 第 3 章 總體設(shè)計 ............................................................................................................. 9 項目規(guī)劃 ................................................................................................................ 9 系統(tǒng)功能結(jié)構(gòu)圖及流程圖 .................................................................................. 10 本章小結(jié) .............................................................................................................. 12 第 4 章 系統(tǒng)設(shè)計 ........................................................................................................... 13 設(shè)計目標(biāo) .............................................................................................................. 13 開發(fā)及運行環(huán)境 .................................................................................................. 13 數(shù)據(jù)庫設(shè)計 .......................................................................................................... 14 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 ....................................................................................