基于PB倉庫進(jìn)銷存管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)

論文字?jǐn)?shù):19502,頁數(shù):64

摘要
 倉庫進(jìn)銷存管理是企業(yè)經(jīng)營管理中的重要環(huán)節(jié)，也是一個企業(yè)能夠取得效益的關(guān)鍵，如果能夠做到合理生產(chǎn)，及時銷售，庫存量最小，減少積壓，那么企業(yè)就能取得最佳的效益。由此可見，進(jìn)銷存管理決策的正確與否直接影響了企業(yè)的效益。
 在手工管理的情況下，生產(chǎn)狀況和市場的需求很難正確反映到生產(chǎn)中去，部門之間的溝通也經(jīng)常不暢通，這在激烈競爭的市場中是非常不利的，企業(yè)進(jìn)銷存管理系統(tǒng)就是在這種狀況下出現(xiàn)的。它利用計(jì)算機(jī)的技術(shù)，使得企業(yè)生產(chǎn)、庫存和銷售能夠有利結(jié)合起來，產(chǎn)銷銜接，提高企業(yè)的效率和效益。
 本畢業(yè)設(shè)計(jì)通過對倉庫進(jìn)銷存管理系統(tǒng)的開發(fā)，運(yùn)用專業(yè)課中學(xué)習(xí)到的關(guān)于軟件開發(fā)的理論和技術(shù)知識，對軟件開發(fā)的方法和步驟進(jìn)行了充分地實(shí)踐和認(rèn)真地探索，做到了用理論來指導(dǎo)實(shí)踐工作。倉庫進(jìn)銷存管理系統(tǒng)基本設(shè)計(jì)思想是把整個系統(tǒng)按照實(shí)現(xiàn)模塊進(jìn)行分解，利用，基于Windows XP、SQL Server2000為開發(fā)環(huán)境進(jìn)行開發(fā)。

關(guān)鍵詞：進(jìn)銷存；Microsoft SQL Server； PowerBuilder語言

ABSTRACT

 Warehouse inventory management is not only an important part of operation management of an enterprise but also a key to gain economic benefit. An enterprise can achieve best economic benefit by reasonable production, in-time sale, minimum inventory and reducing overstock. Thus is can be seen that the economic benefit of an enterprise is directly influenced by decision of inventory management.
 In the case of manual management, production conditions and market demand is difficult to accurately reflect the production of, and communication between departments are often not smooth, which in a highly competitive market is very negative, enterprise management system Invoicing In such a situation is emerging. It uses computer technology, makes production, inventory and sales can be beneficial to combine the production and marketing of convergence and improve the efficiency and effectiveness of enterprises.
 The Graduation Project Invoicing of warehouse management systems, learning to use specialized software development on the theoretical and technical knowledge of software development methods and steps to practice fully and seriously explored, so the theory to guide practical work. Purchase, Sales and Inventory Management System Warehouse basic design idea is to achieve the whole system in accordance with the decomposition of modules, utilization, based on Windows XP, SQL Server2000 as the development environment for development.
 
Keywords: Purchase,Sales and Inventory Management; Microsoft SQL Server; PowerBuilder Language
目錄
摘要 I
ABSTRACT II
第1章 引言 1
1.1 背景 1
1.2 研究內(nèi)容 1
第2章 管理信息系統(tǒng)基礎(chǔ)知識 3
2.1 MIS的基本概念 3
2.2管理信息系統(tǒng)的組成 4
2.3 MIS系統(tǒng)的開發(fā)原則 4
第3章  系統(tǒng)平臺的選用 5
3.1 PB面向?qū)ο蟮某绦蛟O(shè)計(jì) 5
3.1.1 PB的對象 5
3.1.2 PB面向?qū)ο蟮奶匦?nbsp;6
3.2 SQL 2000 數(shù)據(jù)庫 7
第四章 系統(tǒng)設(shè)計(jì) 9
4.1 設(shè)計(jì)思想 9
4.2 系統(tǒng)流程分析 9
4.3 系統(tǒng)結(jié)構(gòu)設(shè)計(jì) 10
4.3.1設(shè)計(jì)原則 12
4.4 數(shù)據(jù)庫設(shè)計(jì) 12
4.4.1數(shù)據(jù)庫需求分析 12
4.4.2  數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) 13
4.5 關(guān)鍵技術(shù) 16
第5章  系統(tǒng)關(guān)鍵模塊設(shè)計(jì)與實(shí)現(xiàn) 18
5.1 登錄界面設(shè)計(jì) 18
5.1.1窗口控件設(shè)置 18
5.1.2主要代碼 19
5.2主程序界面設(shè)計(jì) 21
5.2.1窗口控件設(shè)置 22
5.2.2主要代碼 22
5.3菜單設(shè)計(jì) 23
5.4到貨管理 24
5.4.1 物資到貨信息記錄 24
5.4.2 物資入庫信息記錄 28
5.5 庫房管理 31
5.6 物資查詢 35
5.7 資料維護(hù) 41
5.7.1 物資資料維護(hù) 41
5.7.2 操作員管理 43
5.8 圖形統(tǒng)計(jì) 44
5.8.1 物資信息統(tǒng)計(jì) 44
5.9 報(bào)表輸出 47
5.9.1 入庫報(bào)表輸出 47
第6章  系統(tǒng)的編譯和發(fā)布 48
6.1 創(chuàng)建工程對象 48
6.2 編譯生成和測試 49
6.3 發(fā)布 49
第7章 結(jié)束語 50
7.1 系統(tǒng)的優(yōu)點(diǎn) 50
7.2 系統(tǒng)的缺點(diǎn) 50
7.2.1工具欄目固定不變 50
7.2.2計(jì)算公式固定不變 50
7.2.3網(wǎng)絡(luò)化程度不夠 51
7.3將來可能提出的要求 51
7.3.1 網(wǎng)絡(luò)化 51
7.3.2多媒體化 51
致謝 52
參考文獻(xiàn) 53
附錄 源代碼 54