【正文】 purchasing system, the Prison Material Purchasing Management System has its own as it is developed center on customer, it is easy for customer to control and understand. And the custsomer could serch goods, create a stock order, manage storage, Statistical data through the system. The article mainly represent on several perspectives, . system structure of requirement analysis, partitioning of function module, analysis of databased module, and so on. It fulfills needs to solve actual exploitation of application procedure. The advantage of applying this system is, easily keeping data contingency accordingly and safely. III Keyword: Prison material purchasing, Mangement System, Disign, Implement IV 目錄 第 1章 緒論 .................................................................................................................... 1 前言 ................................................................................................................... 1 國內(nèi)外研究現(xiàn)狀 ................................................................................................. 1 研究的意義 ........................................................................................................ 2 本文結構 ............................................................................................................ 4 第 2章 理論基礎 ............................................................................................................. 5 SQL語言介紹 ....................................................................................................... 5 VB編程語言介紹 .................................................................................................. 6 數(shù)據(jù)庫理論介紹 ................................................................................................. 9 Access 2020簡述 ............................................................................................ 10 第 3章 監(jiān)獄采購系統(tǒng)需求分析 ...................................................................................... 12 .......................................................................................................... 12 ....................................................................................................... 12 ............................................................................................ 13 ................................................................................................... 16 ................................................................................................... 16 ................................................................................................ 16 第 4章 監(jiān)獄物資采購系統(tǒng)設計 ...................................................................................... 17 .......................................................................................................... 17 模塊功能介紹與設計 ..................................................................................... 19 ......................................................................................... 19 ......................................................................................... 20 ......................................................................................... 21 ......................................................................................... 22 ......................................................................................... 23 ....................................................................................................... 24 ER圖 ................................................................................................... 25 數(shù)據(jù)表文件設計 .............................................................................................. 30 第 5章 監(jiān)獄采購系統(tǒng)實現(xiàn) ............................................................................................. 34 登陸 .................................................................................................................. 34 資料管理模塊 .................................................................................................... 36 采購管理模塊 .................................................................................................... 39 庫存管理模塊 .................................................................................................... 44 統(tǒng)計管理模塊 .................................................................................................... 46 用戶管理模塊 .................................................................................................... 46 數(shù)據(jù)庫連接實現(xiàn) ................................................................................................. 49 第 6章 監(jiān)獄采購系統(tǒng)測試 ............................................................................................. 53 .......................................................................................................... 53 .......................................................................................................... 54 ................................................................................................................. 54 第 7章 總結與展望 ........................................................................................................ 59 ................................................................................................................. 59 V ................................................................................................ 59 參考文獻 ........................................................................................................................ 61 致謝 ............................................................................................................................... 63 監(jiān)獄物資采購管理系統(tǒng)的設計與實施 1 第 1 章 緒論 前言 在信息時代的今天，計算機以其快速、準確的信息處理功能滲透于我們周圍的方方面面，同時隨著網(wǎng)絡技術和軟件技術的飛速發(fā)展，當今社會也正快速向信息 化社會前進，信息系統(tǒng)的作用也越來越大，監(jiān)獄內(nèi)部信息管理也日漸體現(xiàn)出運用計