【正文】 畢業(yè)設(shè)計 1 摘 要 隨著時代的進步，全球信息化已經(jīng)不是一個遙不可及的目標(biāo)，而企業(yè)信息化是這個領(lǐng)域的主導(dǎo)者，銷售與庫存管理更是關(guān)系到一個企業(yè)命脈的環(huán)節(jié)如何更好的將其進行管理起來從而有效的提高企業(yè)效率是一個企業(yè)必須要考慮的問題，所以開發(fā)一套 銷售與庫存管理系統(tǒng) 對于任何企業(yè)都是最好的解決方案，使用 銷售與庫存管理系統(tǒng) 的主要目標(biāo)是為了企業(yè)提供一個可以實時查看和實時下訂單的平臺，節(jié)約銷售人員與庫房管理聯(lián)系的時間，同時也使得企業(yè)現(xiàn)狀更加透明，可讓決策者能更好的把握企業(yè)方向，從根本上提高企業(yè)的綜合競爭力。 銷售與庫存管理系統(tǒng) 是使用結(jié)構(gòu) 化設(shè)計方法，使用 Visual Studio 和 SQL Server聯(lián)合開發(fā)的 ，前者是用于系統(tǒng)開發(fā)后者是用于數(shù)據(jù)的搭載。該系統(tǒng)使用瀏覽器 \服務(wù)器模式，基于 WEB 摒棄了傳統(tǒng)客戶端的形式，使得系統(tǒng)在使用上更加的方便快捷。 關(guān)鍵詞 :SQL Server Visual Studio 銷售與庫存管理系統(tǒng) 畢業(yè)設(shè)計 2 Abstract With the progress of the times, the global information technology has not a distant goal, the enterprise informatization is the leader in this field, sales and inventory management is more related to a enterprise is the lifeblood of the link to the management to improve enterprise efficiency is an enterprise must be taken into consideration, so the development of a set of sales and inventory management system is the best solution for any enterprise, the main target of sales and inventory management system is to provide a realtime view and realtime order platform, time saving sales staff and warehouse management link, but also makes the enterprise present situation more transparent, grasp the business direction allows decision makers to better, improve the prehensive petitiveness of enterprises fundamentally. Sales and inventory management system is the use of structured design method, using Visual Studio and SQL Server jointly developed, the former is used for system development and the latter is used for data with. The system uses the browser \ server mode, WEB to abandon the traditional client based on the forms, causes the system to use more convenient. Key Words: SQL Server Visual Studio Sales and inventory management system 畢業(yè)設(shè)計 3 目 錄 引 言 ...................................................................................................................................... 1 1緒論 ......................................................................................................................................... 2 課題背景 .............................................................................................................................. 2 國內(nèi)外研究現(xiàn)狀 .................................................................................................................. 2 課題研究的目的和意義 ...................................................................................................... 3 論文組織結(jié)構(gòu) ...................................................................................................................... 3 2系統(tǒng)分析 ................................................................................................................................. 4 系統(tǒng)可行性分析 .................................................................................................................. 4 需求分析 .............................................................................................................................. 4 功能需求分析 ...................................................................................................................... 5 系統(tǒng)業(yè)務(wù)流程圖 .................................................................................................................. 5 數(shù)據(jù)流程圖 .......................................................................................................................... 5 數(shù)據(jù)字典 .............................................................................................................................. 7 決策樹 .................................................................................................................................. 9 .................................................................................................... 9 .................................................................................................. 10 3系統(tǒng)設(shè)計 ............................................................................................................................... 11 系統(tǒng)實現(xiàn)技術(shù)介紹 ............................................................................................................ 11 .....................................................................................................11 Server2021數(shù)據(jù)庫 ........................................................................................ 12 ...................................................................................................... 13 系統(tǒng)體系結(jié)構(gòu)選擇 ............................................................................................................ 13 系統(tǒng)目標(biāo)設(shè)計 .................................................................................................................... 14 系統(tǒng)功能結(jié)構(gòu)設(shè)計 ............................................................................................................ 14 系統(tǒng)總體物理結(jié)構(gòu) ............................................................................................................ 15 畢業(yè)設(shè)計 4 HIPO 圖 .............................................................................................................................. 15 系統(tǒng)流程圖 ........................................................................................................................ 17 代碼設(shè)計 ............................................................................................................................ 17 用戶界面設(shè)計 .................................................................................................................... 18 ...................