某公司庫存管理系統的設計與實現

論文字數:19705,頁數:54  有開題報告，任務書
摘要

    隨著現代工業的發展，企業信息管理系統越來越受到企業重視。為了適應新形勢下企業庫存管理的需要,降低成本,提高經濟效益,非常有必要制定合理的庫存策略、從而有效的控制和降低企業高量庫存,減少和消除庫存報廢的風險。當今企業競爭范圍的擴大，要求在企業的各個方面加強管理，并要求企業有更高的信息化集成，要求對企業的整體資源進行集成管理，而不僅僅對制造資源進行集成管理。本文根據庫存管理系統的現狀及未來的發展方向結合有關的實踐信息設計了企業庫存管理系統。
本文設計、實現了某公司庫存管理系統，從而克服了原來的手工輸入效率低、容易出錯的缺點，對企業的發展有一定的幫助。本文介紹了C++ builder編程環境和Access數據庫管理系統的功能特點、表單的制作過程、程序的編寫和編譯過程，給出了系統的需求分析、設計與實現，從入出庫、查詢、打印、設置等多方面對系統做了設計與分析。經測試，系統運行穩定，能基本滿足公司對系統在功能和性能上的需求。
 
關鍵詞：庫存，庫存管理，數據庫

The design and implementation of some company’s warehouse management system

Abstract
Following the development of the modern industry, the Enterprise Resource Management (ERP) system has been thought much by enterprises. In order to accommodate the warehouse management system requirements under new environment, increasing the economic benefit, it is necessary to establish a reasonable warehouse control policy. This can easily control and reduce the tremendous warehouse overstock, limited the risk of store-reject. The increasing competition among companies required the corporation itself enhance its own management, and need more information integration. The companies not only need to make well management for their manufacture but for there whole resource. This paper designed a new enterprise warehouse management system depends on its actuality and future works.
This paper designed and realized a company’s warehouse management system. This WMS overcome the demerit, such as low efficiency or tendency to mistakes, when using the manual way, can provide a certain assist to the company. This paper has introduced C++ Builder tool and Access database management system, give out there functional character, table setup procedure, program encoding and also the project compile process. Pointed out the requirements analysis, system design and realization. Analyses based on in/out warehouse, query, print, configuration, etc. also been complemented. After a well quality assessing, the warehouse management system which the paper provided can run smoothly and fulfill the requirements on both function and performance

Keywords: warehouse, the storehouse management system, database

目  錄
1 緒論 1
1.1 課題背景及研究意義 1
1.2 課題研究現狀及存在問題 1
1.3 國內外同類管理軟件的研究現狀與發展趨勢 3
1.4 本人主要工作 5
1.5 課題研究方法 5
1.6 論文結構及研究內容 5
2 庫存管理系統的開發環境 7
2.1 硬件環境 7
2.2 軟件環境 7
2.2.1 操作系統 7
2.2.2 開發語言 7
2.2.3 數據庫 7
3 系統需求與功能說明 9
3.1 系統需求 9
3.2 功能說明 9
3.2.1 系統初始 9
3.2.2 機器管理 9
3.2.3 基本信息管理 14
3.2.4 帳戶管理 18
3.2.5 退出 20
4 系統的設計與實現 21
4.1 概要設計 21
4.2 數據庫設計 21
4.2.1 數據庫介紹 21
4.2.2 數據庫的特點 22
4.2.3 數據庫技術 23
4.2.4 管理員信息表 24
4.2.5 倉庫信息表 24
4.2.6 提貨單信息表 25
4.2.7 商品入庫信息表 25
4.2.8 貨品信息記錄表 26
4.2.9 供貨商信息表 27
4.2.10 提貨信息表 28
4.2.11 員工信息記錄表 29
4.2.12 系統信息表 29
4.3 數據精度 29
4.4 機器管理模塊的詳細設計與實現 30
4.4.1 入庫單管理信息模塊 30
4.4.2 出庫單管理信息模塊 34
4.4.3 提貨單管理模塊 35
4.4.4 整機信息管理模塊 38
5 測試 41
5.1 測試方法 41
5.2 測試環境 41
5.3 測試計劃 41
5.4 測試用例 41
5.5 測試結果 44
5.6 測試結論 44
6 總結與展望 45
6.1 總結 45
6.2 展望 45
致謝  47
參考文獻 48