某企業(yè)供銷存管理信息系統(tǒng)分析與設(shè)計(jì)
本文共計(jì)65頁，4.1萬余字
摘 要

隨著經(jīng)濟(jì)的發(fā)展，市場的不斷變化，許多大型家具企業(yè)已經(jīng)實(shí)現(xiàn)了企業(yè)管理信息化和網(wǎng)絡(luò)化，提高了管理效率。但是，在大多數(shù)中小家具企業(yè)，仍然以傳統(tǒng)人工管理為主，特別是在家具的采購、銷售、庫存環(huán)節(jié)，傳統(tǒng)的手工管理處理信息混亂，賬目管理困難，效率低下，浪費(fèi)嚴(yán)重，造成了資源的流失。
本系統(tǒng)主要針對(duì)家具企業(yè)管理上的問題進(jìn)行設(shè)計(jì)，使用本系統(tǒng)，可以使管理人員從大量繁瑣的手工操作中解放出來，方便企業(yè)管理者對(duì)家具企業(yè)供銷存管理的實(shí)際情況進(jìn)行集中的查詢與管理工作，改進(jìn)管理的手段，提高工作效率和服務(wù)質(zhì)量，同時(shí)可以適應(yīng)家具企業(yè)發(fā)展與社會(huì)進(jìn)步的需求，減少資源的浪費(fèi)和流失。
經(jīng)過實(shí)際調(diào)查和綜合分析，本系統(tǒng)是基于C/S結(jié)構(gòu)，使用Microsoft Visual Studio 2008作為開發(fā)環(huán)境，使用編程語言Visual Basic 對(duì)整個(gè)系統(tǒng)進(jìn)行設(shè)計(jì)與開發(fā)，后臺(tái)數(shù)據(jù)庫使用Microsoft SQL Server 2000。本系統(tǒng)可以根據(jù)實(shí)際應(yīng)用的具體情況，適當(dāng)加以修改，以便更好的應(yīng)用。本系統(tǒng)操作簡單，靈活性好，系統(tǒng)安全性高，運(yùn)行穩(wěn)定。
關(guān)鍵詞：供銷存 C/S結(jié)構(gòu) Visual Basic

Enterprise supply and marketing stock management information system analysis and design of deposit Stock
ABSTRACT

With economic development, the market changing, many furniture companies have implemented enterprise management information and networking, improved management efficiency. However, in most small and medium sized furniture industry is still dominated by traditional labor management, Special is in the furniture procurement, sales, inventory areas, the traditional manual process information management chaos, accounts management problems, low efficiency, serious waste,make resources loss.
This system is mainly for the furniture business management problems to design,
use of the system allows managers from a large number of cumbersome manual operation freed to facilitate the supply and marketing stock managers keep the furniture business for centralized management of the actual situation of the search and management work to improve the management of the means to improve efficiency and service quality, while the furniture industry can adapt to the needs of development and social progress, reduce resource waste and loss.
Through practical investigation and comprehensive analysis of the system is based on C/S structure, using Microsoft Visual Studio 2008 as development environment, Visual Basic programming language to use the entire system design and development, back-end database using Microsoft SQL Server 2000. The system can be based on the actual application of the actual circumstances, be modified to better application. The system is simple, good flexibility, the system safe and stable operation.
Key words: Supply and Marketing Stock C/S structure Visual Basic

目 錄

摘要 …………………………………………………………Ⅰ
ABSTRACT ……………………………………………………Ⅱ
1概況…………………………………………………………1
1.1系統(tǒng)開發(fā)背景…………………………………………………1
1.2企業(yè)現(xiàn)狀………………………………………………………1
1.3系統(tǒng)開發(fā)意義…………………………………………………2
2系統(tǒng)規(guī)劃……………………………………………………3
2.1研究目標(biāo)………………………………………………………3
2.2研究內(nèi)容………………………………………………………3
2.3擬解決的關(guān)鍵問題……………………………………………3
2.4研究的基本思路和方法………………………………………3
2.4.1結(jié)構(gòu)化系統(tǒng)設(shè)計(jì)方法………………………………………4
2.4.2研究的技術(shù)路線……………………………………………4
2.4.3實(shí)驗(yàn)方案……………………………………………………5
2.5可行性分析………………………………………………5
2.5.1經(jīng)濟(jì)可行性…………………………………………………5
2.5.2技術(shù)可行性…………………………………………………5
2.5.3社會(huì)可行性…………………………………………………6
3系統(tǒng)分析……………………………………………………7
3.1業(yè)務(wù)流程圖……………………………………………………7
3.2數(shù)據(jù)流程圖……………………………………………………8
3.3數(shù)據(jù)字典………………………………………………………9
3.3.1數(shù)據(jù)項(xiàng)表……………………………………………………9
3.3.2數(shù)據(jù)流………………………………………………………12
3.3.3數(shù)據(jù)存儲(chǔ)……………………………………………………14
3.3.4數(shù)據(jù)處理……………………………………………………15
4系統(tǒng)設(shè)計(jì)……………………………………………………17
4.1模塊結(jié)構(gòu)設(shè)計(jì)…………………………………………………17
4.1.1系統(tǒng)功能模塊圖……………………………………………17
4.1.2系統(tǒng)IPO圖…………………………………………………18
4.2界面設(shè)計(jì)………………………………………………………20
4.3輸入設(shè)計(jì)………………………………………………………23
4.3.1輸入設(shè)計(jì)的設(shè)計(jì)原則………………………………………23
4.3.2輸入界面設(shè)計(jì)………………………………………………23
4.3.3輸入設(shè)備選擇………………………………………………24
4.3.4輸入數(shù)據(jù)正確性校驗(yàn)………………………………………24
4.4輸出設(shè)計(jì)………………………………………………………25
4.4.1輸出設(shè)計(jì)的內(nèi)容……………………………………………25
4.4.2輸出界面設(shè)計(jì)………………………………………………25
4.4.3輸出設(shè)計(jì)原則………………………………………………26
4.4.4輸出設(shè)計(jì)的方法……………………………………………26
4.5菜單設(shè)計(jì)………………………………………………………27
4.5.1系統(tǒng)菜單介紹………………………………………………27
4.5.2系統(tǒng)菜單界面設(shè)計(jì)…………………………………………27
4.6數(shù)據(jù)庫結(jié)構(gòu)設(shè)計(jì)………………………………………………27
4.6.1數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì)E-R圖………………………………28
4.6.2數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì)………………………………………31
4.7代碼設(shè)計(jì)………………………………………………………35
5系統(tǒng)實(shí)施……………………………………………………36
5.1實(shí)施過程中難點(diǎn)及解決方案…………………………………36
5.2系統(tǒng)實(shí)現(xiàn)特色設(shè)計(jì)……………………………………………37
5.2.1主界面背景音樂設(shè)計(jì)………………………………………37
5.2.2系統(tǒng)數(shù)據(jù)備份設(shè)計(jì)…………………………………………37
5.2.3系統(tǒng)數(shù)據(jù)還原設(shè)計(jì)…………………………………………37
5.2.4溫馨提示設(shè)計(jì)………………………………………………39
5.2.5高級(jí)權(quán)限管理員發(fā)布企業(yè)新聞通知設(shè)計(jì)…………………40
5.2.6庫存報(bào)警設(shè)計(jì)………………………………………………40
5.2.7窗體管理設(shè)計(jì)………………………………………………41
5.2.8 Textbox輸入小數(shù)限制設(shè)計(jì)………………………………41
5.2.9 Textbox輸入整數(shù)限制設(shè)計(jì)………………………………42
5.2.10快捷啟動(dòng)設(shè)計(jì) ……………………………………………42
5.3系統(tǒng)測試………………………………………………………43
5.3.1系統(tǒng)測試目標(biāo)………………………………………………43
5.3.2系統(tǒng)測試方法………………………………………………43
5.3.3系統(tǒng)測試內(nèi)容與步驟………………………………………44
5.4系統(tǒng)維護(hù)與管理………………………………………………45
結(jié)論 …………………………………………………………46
參考文獻(xiàn) ……………………………………………………47
附錄 …………………………………………………………48
謝辭 …………………………………………………………57

參考文獻(xiàn)
[11]侯杰：《Thinking in Java》[M]，機(jī)械工業(yè)出版社，第510-527頁。
[12]閻宏：《Java與模式》[M]，電子工業(yè)出版社 (2002-10出版)，第31-76頁。
[13]李剛:《輕量級(jí)J2EE企業(yè)應(yīng)用實(shí)戰(zhàn)——Struts+Spring+Hibernate整合開發(fā)》[M], 電子工業(yè)出版社,第302-400頁。
[14]李興華：《Java開發(fā)實(shí)戰(zhàn)經(jīng)典》[M]，清華大學(xué)出版社，第235-249頁。