【正文】 I 摘 要 隨著科學(xué)技術(shù)的不斷提高，其強(qiáng)大的功能已為人們深刻認(rèn)識(shí)， “ 現(xiàn)代化管理 ” 的理念隨之也成為企業(yè)發(fā)展的原動(dòng)力。 “ 現(xiàn)代化管理 ” 手段具有檢索迅速、可靠性高、存儲(chǔ)量大、保密性好等優(yōu)點(diǎn)。這些優(yōu)點(diǎn)能夠極大的提高一個(gè)企業(yè)、公司銷售管理的效率。 利用網(wǎng)絡(luò)和數(shù)據(jù)庫(kù)技術(shù)， 基于 B/S 模式開發(fā)了網(wǎng)上銷售訂單管理系統(tǒng)這一 應(yīng)用程序。本系統(tǒng)開發(fā)平臺(tái)采用 Visual Studio 2020，開發(fā)語(yǔ)言采用 C，后臺(tái)數(shù)據(jù)庫(kù)采用 SQL Server 2020。本系統(tǒng)是一個(gè)典型的信息管理系統(tǒng) (MIS)，它運(yùn)用方便，操作簡(jiǎn)單，效率 很高， 實(shí)現(xiàn) 了對(duì)銷售訂單登記、訂單確認(rèn)、貨物發(fā)送、訂單查詢及退貨結(jié)賬等功能。它取代了傳統(tǒng)的手工對(duì)訂單管理，從而減少了銷售數(shù)據(jù)誤差并實(shí)現(xiàn)了數(shù)據(jù)規(guī)范化，能夠滿足 銷售單位高效管理 要求。 本文介紹了網(wǎng)上銷售訂單管理系統(tǒng)的開發(fā)工具、開發(fā)平臺(tái)；系統(tǒng)需求分析部分主要包括業(yè)務(wù)流程圖、 數(shù)據(jù)流圖 、功能需求等；系統(tǒng)設(shè)計(jì)部分主要介紹了系統(tǒng)功能設(shè)計(jì)、數(shù)據(jù)庫(kù)設(shè)計(jì)及代碼設(shè)計(jì)；系統(tǒng)實(shí)現(xiàn)部分說(shuō)明了幾個(gè)主要模塊的算法，并附帶了一些主要的窗口和程序。 關(guān)鍵詞 銷售管理；訂單管理；結(jié)賬處理 II Abstract With the continuous improvement of the science amp。 technology, its great function has been recognized deeply by human, along with that “the modern management” also bees the motility of business development. “The modern management” has such advantages like rapid searching, high reliability, large storage level, good confidentiality, and so on. These advantages could increase the efficiency of a business or pany’s sales management in a large extent. By use of the skill of work and database, we develop the order control of online marketing which is an application program that base on B/S mode. This system development platform adopts Visual Studio 2020, the development language adopts C＃ ,the background database adopts the SQL Server system is a typical Management Information System (MIS) that is very convenient to handle, easy to operate, high efficiency, could carry out the registration of sales order, confirmation of order, delivery of goods, order inquires, goods returned and settle account ,and so on functions. It takes the place of the traditional handwork order control, thus reduces the sales data error and pletes the data’s standardization, could satisfy the requirement about high efficiency management of marketing unit. This article introduces the development instrument and development latform of the order control of online marketing。 system requirements analysis contains operation flow chart, data flow chart, functional requirements。 system design mainly introduces the system functional design, data base design and code design。 system implementation explains the algorithm about some major module, and with some main windows and programs. Key words sales management order control settle account III 目 錄 摘 要 .......................................................................................................................... I Abstract....................................................................................................................II 第 1 章 緒 論 ......................................................................................................... 1 課題背景 ............................................................................................... 1 課題意義 ............................................................................................... 1 系統(tǒng)設(shè)計(jì)思想 ....................................................................................... 2 系統(tǒng)開發(fā)模式 ............................................................................. 2 系統(tǒng)開發(fā)平臺(tái) ............................................................................. 3 系統(tǒng)運(yùn)行環(huán)境 ............................................................................. 4 系統(tǒng)設(shè)計(jì)原則 ............................................................................. 4 系統(tǒng)設(shè)計(jì)目標(biāo) ............................................................................. 5 第 2 章 需求分析 ................................................................................................. 7 需求分析重要性 ................................................................................... 7 可行性分析 ........................................................................................... 7 經(jīng)濟(jì)可行性 ................................................................................. 8 技術(shù)可行性 ................................................................................. 8 運(yùn)行可行性 ................................................................................. 9 業(yè)務(wù)流程圖 ........................................................................................... 9 數(shù)據(jù)流圖 ............................................................................................. 11 數(shù)據(jù)字典 ............................................................................................. 13 本章小結(jié) ............................................................................................. 15 第 3 章 概要設(shè)計(jì) ............................................................................................... 16 系統(tǒng)功能設(shè)計(jì) ..................................................................................... 16 數(shù)據(jù)庫(kù)設(shè)計(jì) ......................................................................................... 17 數(shù)據(jù)庫(kù)設(shè)計(jì)的特點(diǎn) ................................................................... 18 數(shù)據(jù)庫(kù)設(shè)計(jì)基本步驟 ............................................................... 18 數(shù)據(jù)庫(kù)邏輯設(shè)計(jì)（ ER 圖） .................................................... 20 數(shù)據(jù)庫(kù)表結(jié)構(gòu) ........................................................................... 21 本章小結(jié) ............................................................................................. 23 第 4 章 詳細(xì)設(shè) 計(jì) ............................................................................................... 24 IV 系統(tǒng)主界面設(shè)計(jì) ................................................................................. 24 基本信息管理功能設(shè)計(jì) ..................................................................... 24 商品進(jìn)貨管理功能設(shè)計(jì) ..................................................................... 26 銷售訂單管理功能設(shè)計(jì) ..................................................................... 27 查詢統(tǒng)計(jì)功能設(shè)計(jì) ............................................................................. 29 賬務(wù)管理功能設(shè)計(jì) ............................................................................. 31 本章小結(jié) ..............