【正文】
畢業(yè)設(shè)計 ( 論文 ) 汽車銷售 管理 系統(tǒng)的設(shè)計與 開發(fā) 論文作者姓名: 申請學(xué)位專業(yè): 申請學(xué)位類別: 指導(dǎo)教師姓名(職稱): 論文提交日期: 汽車銷售 管理 系統(tǒng)的設(shè)計與 開發(fā) 摘 要 本設(shè)計講述如何為一個汽車 4S 店鋪建立一個汽車銷售管理系統(tǒng)。首先進行系統(tǒng)的 需求 分析, 提出系統(tǒng)任務(wù)和系統(tǒng)業(yè)務(wù)流程的分析 。其次,用 SQL Server 2021建立系統(tǒng)運行所要的后臺數(shù)據(jù)庫。在數(shù)據(jù)庫設(shè)計中, 本設(shè)計 又先對數(shù)據(jù)庫進行 需求 分析 和概念設(shè)計結(jié)構(gòu)的列出 ,這樣得到了較合理的 邏輯 數(shù)據(jù)結(jié) 構(gòu), 利用此數(shù)據(jù)的結(jié)構(gòu) 才能支持系統(tǒng)的 各模塊的實現(xiàn)。然后 通過 Microsoft Visual Studio .NET 2021 進行各個系統(tǒng)功能模塊的創(chuàng)建和 系統(tǒng)的 實現(xiàn)。在創(chuàng)建過程中, 本設(shè)計 先從系統(tǒng)主模塊著手,再實現(xiàn)各個小的模塊功能。最后 在系統(tǒng)實現(xiàn)的過程中 將數(shù)據(jù)庫連接起來,實現(xiàn)整個系 統(tǒng)的正常運行。一個正常進行的汽車銷售需要管理所擁有的汽車信息的設(shè)置、銷售人員的信息和 客戶的信息等,更重要的還要提供汽車信息管理。面對各種不同種類的信息,需要合理的數(shù)據(jù)庫結(jié)構(gòu)來保存數(shù)據(jù)信息以及有效的程序結(jié)構(gòu)支持各種數(shù)據(jù)操作的執(zhí)行。 關(guān)鍵 詞 :網(wǎng)上訂購;數(shù)據(jù)庫;信息管理 Design and Implementation of the Automobile Sale System Abstract This design is mean to state how to build a automobile sales management system for a is to analyze the system, pointing out the analysis of systematic mission and the process of it.. Then the author build a background database by using SQL Server designing the database, the author analyze the need of the data structure and list all the designs of the concept, through which the author get a relatively reasonable logic data structure and realize each systematic module by using it. And then the author builds each function of the systematic module and realizes the system. In the process of creation, the author starts from the main systematic module and then realizes each small one. In the final process of realizing the system, the author connects the databases, realizing the normal operation of the whole system. A normally operated sales of automobiles need the administration of the set of the occupied automobiles, the information of the sales people and the of the customers and so on .What is more important is the information management of the automobiles .In face of the variety of information, what the author need is the structure of the database to store the information and the effective structure of the process to support the operation of the various data. Key words: Online order。 Database。 Information Management 目 錄 論文總頁數(shù): 25頁 1 引言 ............................................................................................................................................................... 0 課題研究背景 ................................................................................................................................ 0 本課題的研究意義 ....................................................................................................................... 0 本課題的研究方法 ....................................................................................................................... 0 2 開發(fā)工具的選擇 .................................................................................................................................... 0 SQL SERVER數(shù)據(jù)庫管理系統(tǒng)簡介 ................................................................................................ 0 C#語言簡介 .................................................................................................................................. 1 3 系統(tǒng)需求分析與設(shè)計 ............................................................................................................................ 1 系統(tǒng)功能結(jié)構(gòu) ................................................................................................................................ 1 系統(tǒng)管理模塊分析 ....................................................................................................................... 1 4 數(shù)據(jù)庫的詳細(xì)設(shè)計與實現(xiàn) ................................................................................................................... 1 數(shù)據(jù)庫需求與功能分析 ............................................................................................................... 1 數(shù)據(jù)庫模塊設(shè)計結(jié)構(gòu) ................................................................................................................... 2 數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計 ................................................................................................................... 4 各數(shù)據(jù)表關(guān)系圖 ........................................................................................................................... 6 數(shù)據(jù)庫結(jié)構(gòu)實現(xiàn) ........................................................................................................................... 6 數(shù)據(jù)庫的連接 ....................................................................................................................... 6 數(shù)據(jù)庫連接后實現(xiàn)數(shù)據(jù)的調(diào)用 .......................................................................................... 6 數(shù)據(jù)存儲過程的實現(xiàn) .......................................................................................................... 7 實現(xiàn)數(shù)據(jù)庫調(diào)用的部分關(guān)鍵語句 ...................................................................................... 7 5 汽車銷售管理系統(tǒng)前臺模塊實現(xiàn) .....................................................................................................10 模塊實現(xiàn)部分:運行主登錄界面 ............................................................................................10 銷售人員登陸頁面 ........................................................................................................................... 11 客戶管理服務(wù)頁面 ...........................................................................................................................13 客戶定購信息以及回饋頁面 ...........................................................................................................16 6 系統(tǒng)測試總結(jié) ......................................................................................................................................20 系統(tǒng)實現(xiàn)的特點 .........................................................................................................................20 系統(tǒng)實現(xiàn)的功能測試總結(jié) .........................................................................................................20 結(jié) 論 .............