【正文】 2020 年度專業(yè)碩士學位論文 學號： 511500185 監(jiān)獄物資采購管理系統(tǒng)的設計與實施 院 系： 軟件學院 類 別： 工程碩士 姓 名： 巫 立 忠 班 級： 11 春 學 號： 460000500185 2020 年 3 月完成 I 摘要 一直以來， 監(jiān)獄中各種日常用品的采購都是采用人工記錄統(tǒng)計，即使是使用計算機管理，也只是使用簡單的 EXCEL 報表進行最基本的入庫，出庫記錄，為此花費大量的人力、物力。 隨著計算機應用的發(fā)展，信息系統(tǒng)的管理已不再靠人工進行處理，人工數(shù)據(jù)處理只能提供定期的報表， 已經(jīng) 難以根據(jù)需要 ， 提供各種綜合分析的數(shù)據(jù)，使得監(jiān)獄日常用品等采購的管理 常常只能根據(jù)經(jīng)驗做出 決定 ，帶有一定的盲目性 ， 這種 管理 方式是一種低水平的運作，會造成大量的浪費。而 如果 通過計算機系統(tǒng)將數(shù)據(jù)組織起來， 就 可以隨時提供所需的數(shù)據(jù) ， 保證決策的 更加 正確、及時 ；再者通過計算機可 以規(guī)劃 監(jiān)獄日常用品的采購 管理 ,為數(shù)據(jù)處理提供明確的尺度，使之標準化、規(guī)范化 ；此外還最大限度地 可以節(jié)省人力，提高 工作 效率。 本文介紹了一個解決當今監(jiān)獄采購活動的低效益的軟件，即 監(jiān)獄物資采購管理系統(tǒng) 。 與一般采購系統(tǒng)相比，擁有以用戶為開發(fā)中心，易于操作和理解等特點。該系統(tǒng)有查詢物資、生成采購單、管理庫存、數(shù)據(jù)統(tǒng)計等功能。本文將詳細 該系統(tǒng)的需求分析系統(tǒng)結構，功能模塊劃分以及數(shù)據(jù)庫模式分析等，以及對應用程序的實際開發(fā)實現(xiàn)作了介紹。該軟件達到了數(shù)據(jù)的一致性和安全性，且應用程序功能完備，符合了當今監(jiān)獄物資采購管理的需求。 關鍵字： 監(jiān)獄 物資采購，管理系統(tǒng)， 設計 ， 實現(xiàn) II Abstract Ever since, Prison Procurement is anized by hand in China. There is some exception that, might handled on puter basis. However, most of them are still with Microsoft excel format. It’s obvious laborwasted amp。 not effective. Along with the development of puter application, there is no need to manage of information system by real labor on their own. Information data which is managed by humaninput can only offer reports periodically. It’s hard to offer diversified analytical data which is in need. It es to result that, decision to be made with personal need purpose on prison procurement by prison administration. Do goods purchased could really fulfill prison required? Is it effective? From long term of past decades, it’s proved that previous procurement method of prison management is highwasted procedure, using modernized and motivate method is an acquired need. So, we should anize procurement data through puter system which can analyze data and real requirement amp。 solution we need momentarily, correctly and timely. With the standardized puter system, we can manage of daily procurement of prison easily and trendy。 What’s more, it can save manpower and improve working efficiency. This article introduces a administrative system which can solve the problem of daily purchasing in Chinese prison with great efficiency. Compare with a usual 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 國內外研究現(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圖 .......