【正文】 . 1資 訊類 型管 理2 . 3 . 1廣 告類 型管 理2 . 4 . 1 圖 系統(tǒng)功能模塊的劃分 數(shù)據(jù)流設(shè)計(jì) 系統(tǒng)數(shù)據(jù)流設(shè)計(jì)，主要描述系統(tǒng)中產(chǎn)生的數(shù)據(jù)走向，和存儲(chǔ)位置。該圖為系統(tǒng)結(jié)構(gòu)層次圖，可以很清楚的看出本系統(tǒng)由兩部分組成：前臺(tái)訪問(wèn)和后臺(tái)管理。網(wǎng)站的每一個(gè)商品都有唯一的品牌與其對(duì)應(yīng)。新聞信息必須實(shí)事求是。 3． 訂單管理 實(shí)體店有發(fā)票證明有商品要出售或已出售，網(wǎng)店有記錄單據(jù)。 唯一的區(qū)別在于我的收藏只能瀏覽添加的商品，不能直接購(gòu)買?？梢灾苯淤?gòu)買 ，也可以將商品放入購(gòu)物車，留待參考，再購(gòu)買 ?？蛻粼诘顷懡缑孑斎氲卿浢艽a，然后判斷是否登錄成功，如果不成功則留在登錄頁(yè)面，否則進(jìn)入系統(tǒng)。顧名思義，就是實(shí)現(xiàn)在網(wǎng)上管理訂單的下方與實(shí)現(xiàn)。 應(yīng)用技術(shù)： 技術(shù)， SQL Server 2021 數(shù)據(jù)庫(kù)系統(tǒng)實(shí)現(xiàn)系統(tǒng)的數(shù)據(jù)管理。 總體需求分析 近年來(lái)，電子商務(wù)在國(guó)內(nèi)飛速發(fā)展，網(wǎng)上購(gòu)物也越來(lái)越受到大眾的追捧。而且使用在線訂單管理系統(tǒng)還可以給企業(yè)經(jīng)營(yíng)管理帶來(lái)好處，如提高企業(yè)的知名度、提高網(wǎng)站的訪問(wèn)量、減少操作的重復(fù)性，使訂單信息化易于管理。通過(guò)這些前期的準(zhǔn)備后，陜西理工學(xué)院 畢業(yè)設(shè)計(jì) 第 7 頁(yè) 共 37 頁(yè) 我對(duì)本系統(tǒng)從以下三個(gè)方面進(jìn)行了分析，確定 本 系統(tǒng) 必須做什么 ：總體需求分析、可行性分析、系統(tǒng)功能分析 可行性分析 如何使用最小的代價(jià)在盡可能短的時(shí)間里確定問(wèn)題是否能解決，這就是可行性分析的目的，我們具體從 技術(shù)可行性、操作可行性、經(jīng)濟(jì)可行性三 個(gè)方面考慮： 技術(shù)可行 性 由于本系統(tǒng)開發(fā)，使用 C語(yǔ)言開發(fā)設(shè)計(jì)主界面，并用 SQL Server 2021 做數(shù)據(jù)庫(kù)，它們都是現(xiàn)今比較流行的開發(fā)組件，且比較容易實(shí)現(xiàn)。商家建立網(wǎng)站，將商家各方面的宣傳與服務(wù)展現(xiàn)于網(wǎng)絡(luò)中，通過(guò)網(wǎng)絡(luò)可實(shí)現(xiàn)如何購(gòu)物，信息查詢等功能，這些在改變我們?cè)械慕?jīng)營(yíng)方式與經(jīng)營(yíng)理念的同時(shí)，也為商家?guī)?lái)了更高的效益。是的更多宅男宅女工作狂又多了一種購(gòu)物方式的選擇，對(duì)于公司和自身都是一個(gè)很好的機(jī)會(huì)，可以通過(guò)網(wǎng)站與現(xiàn)實(shí)的結(jié)合很好的推廣自己的品牌，通過(guò)網(wǎng)上與現(xiàn)實(shí)專賣店的互動(dòng)來(lái)拉攏更多的客源。它是實(shí)現(xiàn)網(wǎng)上交易必不可少的環(huán)節(jié)，便于購(gòu)物者不受傳統(tǒng)購(gòu)物方式的限制自由購(gòu)物。 （ 3）更低的成本：目前計(jì)算機(jī)價(jià)格的下跌與互聯(lián)網(wǎng)寬帶的大力建設(shè)為 網(wǎng)上購(gòu)物提供了更廣大的市場(chǎng)和更低的成本，無(wú)需租鋪裝修等麻煩手續(xù)。 ［關(guān)鍵字］ 在線訂單 C技術(shù) SQL Server2021 MVC 設(shè)計(jì)模式 數(shù)據(jù)庫(kù) 陜西理工學(xué)院 畢業(yè)設(shè)計(jì) III Design and Implementation of Online Order management system Yuan Yiyi (Grade10,Class1,Information and puting science Major,School of Mathematics and Computer Science, Shaanxi University of Technology, Hanzhong 723000) Tutor: Tuo Shouheng Abstract: Using the technology of work and database, bining the advantages of the popularization of puter and work, developing a online order management system with friendly interface, which is easy to use, easy to operate. It is the indispensable link of realizing online trading, which is advantageous for the shoppers free shopping who do not accept the restriction of traditional shopping way. Let izen never leave home can rest assured shopping mall to buy modities, understand all kinds of news information, never leave home can also broaden their horizons, Enrich their knowledge. This is the purpose of developing this system. This system mainly is to realize the customers in the offline order online offer goods and for sellers to offer goods for the customers to choose, and the process to receive the order, in this process , it will take some permit problems. Concretely it is divided into two modules, front desk access: customers can browse the website of modity information at any time as a tourist, adding or deleting items of a shopping cart, or have a ment. New customers need to register as a member in order to execute the query goods outside of the operation, such as buying goods, add or delete my ments, my collection etc. After the success of the background management: the administrator login, can perform product management, brand management, information management, advertising management, member management, user management and order management. This system uses technology to build development platform, it can run on Windows 7 and above version, using c language, bined with SQL Server 2021 to build this system. The basic framework of the use of the MVC pattern development, realize the operating function of the system, the realization of the specific request from the Server, the request will be accepted by SQL Server, according to the different request of SQL Server to invoke the corresponding database information, business logic operations specified database and change the status of model, SQL Server will passed model of database to the view after the business changed, c present the results to client. This system is operated simply, you can preview goods as visitors, if you have the willing you can register as a member, to order online. The merchandise and customer information is unified management by the administrator, the customer can change the personal information online. So it is strengthen the efficiency of data, better realizing to share of resources, helping to reduce repeated labor and achieved good social benefits. Key Words: Online Order C technology SQL Server2021 MVC design pattern Database 陜西理工學(xué)院 畢業(yè)設(shè)計(jì) IV 目錄 1 引言 .................................................. 6 在線訂單管理系統(tǒng)研究背景及應(yīng)用 ........................ 6 本文研究目標(biāo)及意義 ................................... 6 本文主要完成工作 ..................................... 6 2 系統(tǒng)的需求分析 ........................................ 6 可行性分析 ............................................ 7 技術(shù)可行性 .......................................... 7 操作 可行性 .......................................... 7 經(jīng)濟(jì)可行性 .......................................... 7 總體需求分析 .......................................... 7 系統(tǒng)約束分析 ......................................... 7 系統(tǒng)功能分析 ......................................... 7 系統(tǒng)結(jié)構(gòu)分析 ........................................ 8 3 系統(tǒng)總體設(shè)計(jì) .......................................... 9 項(xiàng)目規(guī)劃 ............................................. 9 數(shù)據(jù)流設(shè)計(jì) .......................................... 10 業(yè)務(wù)流程 ........................................... 10 數(shù)據(jù)流程圖 ......................................... 10 開發(fā)及運(yùn)行環(huán)境 ...................................... 11 開發(fā)環(huán)境 .......................................... 11 運(yùn)行環(huán)境 .......................................... 11 數(shù)據(jù)庫(kù)設(shè)計(jì) ........................................... 11 系統(tǒng)中的實(shí)體 ER 圖： ................................ 11 數(shù)據(jù)庫(kù)表 ........................................... 20 數(shù)據(jù)庫(kù)表關(guān)系 ......................................... 21 4 系統(tǒng)詳細(xì)設(shè)計(jì) ......................................... 21 前臺(tái)開發(fā) ............................................ 21 會(huì)員登錄與注冊(cè) ..................................... 21 信息展示功能 ....................................... 22 購(gòu)物車功能 ......................................... 22 收藏功能