【正文】 I 庫存信息管理系統(tǒng) 的 設(shè)計 與 開發(fā) 摘 要 庫存信息管理系統(tǒng) 是典型的信息管理系統(tǒng) (MIS)，其開發(fā)主要包括后臺數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個方面。對于前者要求建立起一個數(shù)據(jù)一致性和完整性強(qiáng) 、 數(shù)據(jù)安全性好的庫；而對于后者則要求應(yīng)用程序 具有 功能完備 、 易使用等特點(diǎn)。 經(jīng)過分析 以上 情況，我采用微軟公司的 Visual Studio 2021作為前端應(yīng)用程序開發(fā)工具， SQL Server 2021建立后臺數(shù)據(jù)庫 ，在本次畢業(yè)設(shè)計中開發(fā)了這套 庫存信息管理系統(tǒng) 。本系統(tǒng)利用 Visual Studio 2021提供 的各種面向?qū)ο蟮拈_發(fā)工具，尤其是 ADO，能方便而簡潔地 實現(xiàn)應(yīng)用程序和 數(shù)據(jù)庫 的互訪 ， 是一款能讓 用戶滿意的可行系統(tǒng)。 關(guān)鍵詞 庫存 管理； ； 面向?qū)ο?； 數(shù)據(jù)庫 II Inventory information management system design and development Abstract Inventory management system is a typical management information system , which mainly includes database creation and maintenance, and frontend application development aspects. The former requires a strong consistency and integrity of data, and data with good security。 while the latter requires the application functional, easy to use and so on. After analyzing of the above, I use Microsoft39。s Visual C . NET as a frontend application development tool, SQL Server 2021 establishing the background database, to develop the inventory management system in this graduation project. The system uses a variety of objectoriented development tools which Visual C . NET Provides, especially the ADO, which can be simple and easy to manipulate the database, so it is a viable system which allows the user’s satisfaction. Key words Inventory Management。 。 Objectoriented。 Database III 目 錄 第 1 章 緒論 ................................................................................................................................ 5 引言 ................................................................................................................................ 5 編寫目的及意義 ............................................................................................................... 5 系統(tǒng)分析 ......................................................................................................................... 6 選題的背景 .............................................................................................................. 6 系統(tǒng)需求分析 .......................................................................................................... 7 可行性分析 ...................................................................................................................... 8 可行性研究的目的 ................................................................................................ 8 經(jīng)濟(jì)可行性分析 .................................................................................................... 8 技術(shù)可行性 分析 .................................................................................................... 9 操作可行性分析 .................................................................................................... 9 系統(tǒng)的開發(fā)及功能描述 ................................................................................................ 9 開發(fā)方法的選擇 .................................................................................................... 9 系統(tǒng)功能描述及系統(tǒng)安全性 .................................................................................10 系統(tǒng)邏輯模型 ...............................................................................................................10 第 2 章 系統(tǒng)設(shè)計 ........................................................................................................................13 系統(tǒng)總體結(jié)構(gòu)設(shè)計 ...........................................................................................................13 系統(tǒng)功能分析 ........................................................................................................13 系統(tǒng)功能模塊圖 .....................................................................................................13 數(shù)據(jù)庫設(shè)計 .....................................................................................................................14 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 ..............................................................................................14 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計 ..............................................................................................15 設(shè)置引用完整性 .....................................................................................................20 數(shù)據(jù)庫鏈接的實現(xiàn) .................................................................................................20 系統(tǒng)功能模塊的詳細(xì)設(shè)計 .................................................................................................20 身份驗證模塊的設(shè)計 ...............................................................................................20 系統(tǒng)主界面的實現(xiàn) .................................................................................................23 入庫管理模塊的實現(xiàn) ..............................................................................................23 出庫管 理模塊的實現(xiàn) ..............................................................................................25 報表統(tǒng)計模塊的實現(xiàn) ..............................................................................................26 系統(tǒng)設(shè)置模塊的實現(xiàn) ..............................................................................................26 庫存管理模塊的實現(xiàn) ..............................................................................................27 第 3 章 系統(tǒng)實現(xiàn) ........................................................................................................................28 用戶登錄界面 ..................................................................................................................28 IV 系統(tǒng)主界面 .....................................................................................................................29 系統(tǒng)子界面 .....................................................................................................................30 系統(tǒng)信息設(shè)置 ........................................................................................................30 入庫管理 ..................