本科生畢業(yè)設(shè)計(jì)（2011屆）題目汽車(chē)銷(xiāo)售管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)系別計(jì)算機(jī)科學(xué)系專(zhuān)業(yè)計(jì)算機(jī)科學(xué)與技術(shù)班級(jí)2007級(jí)2班作者姓名學(xué)號(hào)指導(dǎo)教師職稱(chēng)副教授學(xué)歷研究生論文成績(jī)2010年5目錄摘要1ABSTRACT2緒論3第一章系統(tǒng)概述411本課題研究的背景412現(xiàn)有系統(tǒng)存在的問(wèn)題分析413系統(tǒng)開(kāi)發(fā)的目標(biāo)414系統(tǒng)開(kāi)發(fā)工具的介紹5141MICROSOFTVISUALSTUDIO2005簡(jiǎn)介5142MICROSOFTSQLSERVER2005簡(jiǎn)介與SQL技術(shù)515系統(tǒng)開(kāi)發(fā)方法616系統(tǒng)開(kāi)發(fā)的意義6第二章系統(tǒng)分析621可行性分析7211經(jīng)濟(jì)可行性7212技術(shù)可行性7213使用可行性722需求分析723系統(tǒng)設(shè)計(jì)背景824系統(tǒng)的功能簡(jiǎn)介825系統(tǒng)開(kāi)發(fā)的目標(biāo)8第三章概要設(shè)計(jì)831系統(tǒng)模塊設(shè)計(jì)9311系統(tǒng)功能模塊設(shè)計(jì)932數(shù)據(jù)庫(kù)設(shè)計(jì)9321數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)10322數(shù)據(jù)庫(kù)邏輯設(shè)計(jì)10第四章系統(tǒng)詳細(xì)設(shè)計(jì)1441登錄界面設(shè)計(jì)1542系統(tǒng)主要界面16421汽車(chē)銷(xiāo)售管理系統(tǒng)主控臺(tái)界面16422車(chē)輛信息管理界面18423售后管理界面設(shè)計(jì)20424查詢(xún)統(tǒng)計(jì)的界面設(shè)計(jì)21425客戶(hù)購(gòu)車(chē)界面的設(shè)計(jì)21426車(chē)輛進(jìn)貨界面的設(shè)計(jì)22第五章系統(tǒng)測(cè)試和運(yùn)行環(huán)境2251系統(tǒng)測(cè)試2352運(yùn)行環(huán)境23結(jié)束語(yǔ)25參考文獻(xiàn)261汽車(chē)銷(xiāo)售管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)摘要隨著時(shí)代的發(fā)展,居民的消費(fèi)水平逐漸提高，很多的家庭將會(huì)購(gòu)買(mǎi)汽車(chē)。但很多汽車(chē)銷(xiāo)售公司仍然運(yùn)用手工記錄的傳統(tǒng)方法，查詢(xún)和統(tǒng)計(jì)起來(lái)非常的不方便，費(fèi)時(shí)又費(fèi)力，手工記錄容易出錯(cuò)繼而導(dǎo)致賬目混亂，嚴(yán)重時(shí)會(huì)給公司造成難以挽回的損失。如何管理好這些，使整個(gè)公司協(xié)調(diào)一致、高效率地運(yùn)轉(zhuǎn)，是各公司急待解決的問(wèn)題。汽車(chē)銷(xiāo)售管理系統(tǒng)不但能使各業(yè)務(wù)環(huán)節(jié)協(xié)調(diào)一致，而且操作簡(jiǎn)單，賬目清晰。查詢(xún)和統(tǒng)計(jì)起來(lái)十分的方便。而且通過(guò)賬目查詢(xún)，公司能在G4523G1387的時(shí)G1975G2717G1894G1284G3271G1062G3824G3695，G1206而G4389G1352G3757G4075的決G1030。G4057G1198，G1566系統(tǒng)G4438G3985G1620G2156G3244G1949G3859G3024，G1827分G2420售G2957管理、車(chē)G2407管理、G2234G1820購(gòu)車(chē)管理、查詢(xún)統(tǒng)計(jì)、售G1802管理和系統(tǒng)G3201G1351G2466G1238G2662G2262，G969G3882用G57G76G86G88G68G79G54G87G88G71G76G82G17G49G40G55G21G19G19G24G2199發(fā)工G2158和G54G52G47G54G72G85G89G72G85G21G19G19G24G3316G2156G2255，G1008用G38G18G54G2662G3252G3244G3747G2420G1206G2234G1820G1288記、車(chē)G2407G881G1966、G1352購(gòu)G1289多個(gè)環(huán)節(jié)G3316G2156的管理G1531務(wù)，G1902G903G3176G2561G4512G2420汽車(chē)銷(xiāo)售管理G2464G1105。關(guān)鍵詞汽車(chē)銷(xiāo)售管理G290G38G18G54G2662G3252G290G3316G2156G2255G2902DESIGNANDDEVELOPMENTOFTHEAUTOMOBILESALEMANAGEMENTSYSTEMABSTRACTWITHTHEDEVELOPMENTOFTHETIMES,GRADUALLYINCREASINGTHECONSUMPTIONLEVELOFRESIDENTS,MANYFAMILIESWILLBUYACARBUTMANYCOMPANIESSTILLUSEMANUALCARSALESRECORDOFTHETRADITIONALMETHODSOFINQUIRYANDSTATISTICSITISVERYINCONVENIENT,TIMECONSUMINGANDLABORIOUS,ERRORPRONEMANUALRECORDOFTHEACCOUNTSANDTHENLEADTOCONFUSION,GIVETHECOMPANYCAUSESERIOUSIRREVERSIBLEDAMAGEHOWTOMANAGETHESESOTHATTHEWHOLECOMPANYCOORDINATED,EFFICIENTOPERATION,ISTHATCOMPANIESNEEDTOBESOLVEDPROBLEMSAUTOSALESMANAGEMENTSYSTEMNOTONLYENABLESTHEBUSINESSASPECTSOFCOHERENCE,ANDSIMPLE,CLEARACCOUNTSQUERYANDSTATISTICALTHEMVERYCONVENIENTBUTALSOTHROUGHTHEACCOUNTSOFINQUIRY,THECOMPANYINTHESHORTESTPOSSIBLETIMEACCESSTOMARKETINFORMATION,SOASTOFORMULATETHEAPPROPRIATEDECISIONMAKINGTHEREFORE,THESYSTEMISMAINLYBASEDONTHEACTUALDEMAND,BYTHEPREMANAGEMENT,VEHICLEMANAGEMENT,CUSTOMERCARMANAGEMENT,QUERYSTATISTICS,THESALEMANAGEMENTANDSYSTEMSETTINGSOFSIXMODULES,ANDUSEVISUALSTUDIONET2005DEVELOPMENTTOOLSANDSQLSERVER2005DATABASEBYC/SMODELREALIZEDFROMTHECUSTOMERREGISTRATION,VEHICLEPURCHASE,ORDERANDMANYOTHERASPECTSOFDATAMANAGEMENTSERVICES,BASICALLYMEETINGTHENEEDSOFTHEAUTOMOTIVESALESMANAGEMENTPROCESSKEYWORDSCARSALESMANAGEMENTC/SMODELDATABASE3緒論高效的汽車(chē)銷(xiāo)售管理系統(tǒng)是當(dāng)前信息化汽車(chē)公司管理系統(tǒng)的需要。面對(duì)G5234G3835的汽車(chē)銷(xiāo)售G2656庫(kù)存信息G712G4613需要有汽車(chē)管理系統(tǒng)G7481G6564高管理工G1328的效G10587。G17902G17819G5326G12447G17837G7691的系統(tǒng)G712可G1209G1582G2052汽車(chē)信息的G16280G14551管理G451G5567G17907查詢(xún)G2656G12197G4410統(tǒng)計(jì)G712G1186G13792G1955G4581管理方面的工G1328G18339。G1306G980G11464G1209G7481汽車(chē)銷(xiāo)售G1237G1006G17836是使用G1268統(tǒng)G1166工管理方G5347G712G17837G12193管理方G5347存在G11540G16780G3822G13582G9869,G3926G726G1457G4506性G5058G451效G10587G1314。G13792G1000G7114G19400G980G19283G712G4570G1147G10995G3835G18339的G7003G1226G2656數(shù)據(jù)G712G17837對(duì)G1122查G6226G451G7368G7044G2656G13512G6264G18129G5114G7481G1114G993G4581的G3268G19602。G19555G11540G12197G4410技術(shù)的G993G7041G6564高,計(jì)G12651G7438G12197G4410技術(shù)G7097G9188G6116G10099G712G1866G5390G3835的功能G5062G1038G1166G1216G9157G2063G16760G16794G712G4439G5062進(jìn)G1849G1166G12879G12050G1262的G2520G1022G20058G3507G5194發(fā)G6393G11540G17246G7481G17246G18337要的G1328用。G1328G1038計(jì)G12651G7438G5224用的G980G18108分G712使用計(jì)G12651G7438G5347管理,具有G11540G1166工G5347管理G6164G7092法G8616G6323的G1260G9869。G1375G3926查G6226方G1427G451存G1660G18339G3835G451G1457G4506性G3921G451可G19764性高G451G7828G13046G17817G17907G451G4563G2641G19283G451G6116本G1314G12573。G17837G1135G1260G9869能G3827G7509G3835G3332G6564高G1166G1119G2183G17176管理的效G10587G712也是G1237G1006的G12197G4410化G451正G16280化管理G712與世界接軌的G18337要條G1226。因此G17246G7481G17246G3822的汽車(chē)銷(xiāo)售G1237G1006開(kāi)始G5326G12447或計(jì)劃G5326G12447自己的管理系統(tǒng)G1209達(dá)G2052G1314G6116本G712高效G10587的管理G1237G1006。本系統(tǒng)采用G1114C/S模G5347的結(jié)構(gòu)設(shè)計(jì)G712G1038汽車(chē)銷(xiāo)售G1237G1006G6564供G1114G980套操G1328簡(jiǎn)易G451G5224用廣泛G451擴(kuò)展性G5390的銷(xiāo)售管理系統(tǒng)?？蒅1209對(duì)車(chē)輛G451G1237G1006員工的管理G7368加方G1427。G17837G12193采用計(jì)G12651G7438G5347管理的G3921處是可G1209對(duì)G1237G1006的眾G3822員工G451車(chē)輛的信息進(jìn)行動(dòng)態(tài)的管理G712修改G451添加G2656刪除G18129非常方G1427G712G993必再像原G7481準(zhǔn)備G980G1022巨G3835的檔案庫(kù)G712在諸G3822G7003擋中查G6226G17176料G712G1955G4581G1114G17837G1135G18337要工G1328出錯(cuò)的可能性。4第一章系統(tǒng)概述11本課題研究的背景數(shù)據(jù)庫(kù)技術(shù)體現(xiàn)G1114當(dāng)代先進(jìn)的數(shù)據(jù)管理方法G712使計(jì)G12651G7438的G5224用真正滲透G2052國(guó)民經(jīng)濟(jì)G2520G1022G18108門(mén)G712在數(shù)據(jù)處理G20058G3507發(fā)G6393G11540G17246G7481G17246G3835的G1328用。在我國(guó)G712G19555G11540改革開(kāi)放G2656市場(chǎng)經(jīng)濟(jì)的發(fā)展G712居民的消費(fèi)水平逐G9188G6564高G712很G3822的家庭也G4570G1262購(gòu)買(mǎi)汽車(chē)G712那么汽車(chē)在銷(xiāo)售G17819程中的管理G4613G993能僅僅只G19764手工的記錄G712G7368G5224該結(jié)合信息技術(shù)的支持。因此需要G980G1022G12197G4410的汽車(chē)銷(xiāo)售管理系統(tǒng)對(duì)公司的銷(xiāo)售起G2052高效的管理。12現(xiàn)有系統(tǒng)存在的問(wèn)題分析對(duì)G1122二十G980世紀(jì)的今天計(jì)G12651G7438的發(fā)展是G7097G7044月異的G712G1306是有的公司的G20058導(dǎo)G1166只見(jiàn)眼前利益G712G993關(guān)心G712甚至G993敢嘗試G7044興的G1119物。信息技術(shù)的G5224用G17836十分落后。有G1135汽車(chē)銷(xiāo)售公司雖然使用G1114計(jì)G12651G7438G712甚至管理系統(tǒng)G712G1306是仍然存在很G3822問(wèn)題G712問(wèn)題G980G7097G993解決G712效G10587G4613G980G7097G6564G993上去。G17836有的系統(tǒng)很G993完善G2052處是G13582G9869。G1375G3926G726數(shù)據(jù)冗余G451操G1328復(fù)雜G12573G17837G7691G7509G993完善的系統(tǒng)能有G1457障嗎G6164G1209開(kāi)發(fā)G980G1022G7368加完善的汽車(chē)銷(xiāo)售系統(tǒng)是勢(shì)在必行的。13系統(tǒng)開(kāi)發(fā)的目標(biāo)本系統(tǒng)是G4570現(xiàn)代化的計(jì)G12651G7438技術(shù)G2656G1268統(tǒng)的銷(xiāo)售管理工G1328相結(jié)合G712按G10043公司的工G1328G8981程設(shè)計(jì)完G6116的。G1038G1114使系統(tǒng)在公司的管理中發(fā)G6393G7368G3835的G1328用G712G4466現(xiàn)工G1328G17819程的計(jì)G12651G7438化G712G6564高工G1328效G10587G2656工G1328G17148G18339G712現(xiàn)G6564出G3926G991的系統(tǒng)開(kāi)發(fā)目標(biāo)G7261方G1427用戶(hù)的操G1328G712G4625G18339G1955G4581用戶(hù)的操G13282能G3827按G10043用戶(hù)G17885G6333的G993G2528的條G1226進(jìn)行簡(jiǎn)G2345查詢(xún)G2656復(fù)合查詢(xún)3對(duì)G2520G1022數(shù)據(jù)庫(kù)進(jìn)行動(dòng)態(tài)管理G712G19462G8502G9163G10934能G3827對(duì)銷(xiāo)售G20081G451G1849庫(kù)的統(tǒng)計(jì)G712方G1427管理G13785G993必G18337復(fù)的計(jì)G12651G2656管理5能G3827按G10043G993G2528G7447G19492的用戶(hù)分G18209G2004G993G2528的功能G712G1457障數(shù)據(jù)庫(kù)的G4445G1852性6系統(tǒng)G5224具有G4466用性G451可G19764性G2656G17878用性G712G2528G7114G8892意G2052先進(jìn)性514系統(tǒng)開(kāi)發(fā)工具的介紹141MICROSOFTVISUALSTUDIO2005簡(jiǎn)介MICROSOFTG49G40G55是G5506G17731開(kāi)發(fā)的平臺(tái)G712是G980G12193面G2533G13605G13488G712支持G3822G12193用戶(hù)G13468G12483的開(kāi)發(fā)平臺(tái)環(huán)境。VISUALSTUDIOG49G40G55是MICROSOFT公司G1038G4466現(xiàn)G1866G49G40G55技術(shù)G13792開(kāi)發(fā)的G980套工具G13464G1226。G4439G6238開(kāi)發(fā)功能G5390G3835G712性能可G19764的G1237G1006解決方案進(jìn)行G1114簡(jiǎn)化。利用VISUALSTUDIOG49G40G55G712用戶(hù)可G1209非常G17743G7506G3332G2031G5326具有自動(dòng)G1292G13565能G2159的可G19764的G5224用程G5219G2656G13464G1226A1A0A2。VISUALSTUDIO2005使開(kāi)發(fā)G1166員能G3827G17902G17819與MICROSOFTG50FFICESG92STEG80G2656SQLSERVER2005的G7368G3921G19610G6116G712在G7368廣泛的G5224用程G5219開(kāi)發(fā)方案中G5224用現(xiàn)有的技能。G38G6的功能G10317G9869主要有A1A3A2G7261G714簡(jiǎn)G8917的G16833法2G714與G58G40G37相結(jié)合3G714G12946心的面G2533對(duì)G16949設(shè)計(jì)4G714G9801G8975性與G1872G4493性5G714完G6984的G4445G1852性G8454錯(cuò)G16835處理G451G10268本處理技術(shù)142MICROSOFTSQLSERVER2005簡(jiǎn)介與SQL技術(shù)MICROSOFTSQLSERVER2005中G7003G10268G708G1209后簡(jiǎn)G12228G1038SQLSERVER2005或SQLSERVERG709G712是G3534G1122客戶(hù)G12483G18G7393G2165G3132模G5347的G7044G980代G3835G3423關(guān)系G3423數(shù)據(jù)庫(kù)管理系統(tǒng)G708G39G37MSG709。SQLSERVER2005是G980G1022G1852面的數(shù)據(jù)庫(kù)平臺(tái)G712使用G19610G6116的G2842G1006G7246能G11G37G44G12工具G6564供G1114G1237G1006G13435的數(shù)據(jù)管理A1A4A2。SQLSERVER2005數(shù)據(jù)庫(kù)G5353G6818G1038關(guān)系G3423數(shù)據(jù)G2656結(jié)構(gòu)化數(shù)據(jù)G6564供G1114G7368G4445G1852可G19764的存G1660功能G712使G5756可G1209構(gòu)G5326G2656管理用G1122G1006G2165的高可用G2656高性能的數(shù)據(jù)G5224用程G5219G4439在G11017G4388G2842G2165G451數(shù)據(jù)G1191庫(kù)G2656數(shù)據(jù)庫(kù)解決方案G12573G5224用中起G11540G18337要的G7692心G1328用G712G1038G1237G1006的數(shù)據(jù)管理G6564供G5390G3835的支持G712對(duì)數(shù)據(jù)庫(kù)中的數(shù)據(jù)G6564供有效的管理G712G5194采用有效的G6526G7057G4466現(xiàn)數(shù)據(jù)的完G6984性G2462數(shù)據(jù)G4445G1852性。SQLG16833G16340G1055G6164G1209能G3827G1038用戶(hù)G2656G1006界G6164接G2475G712G5194G6116G1038國(guó)G19481標(biāo)準(zhǔn)G712是因G1038G4439是G980G1022G13520合的G451功能G7509G5390G2528G7114G2460簡(jiǎn)G6475易G4410的G16833G16340A1A5A2。SQLG16833G16340G19610數(shù)據(jù)查詢(xún)G451數(shù)據(jù)操G13449G451數(shù)據(jù)G4462義G2656數(shù)據(jù)控G2058功能G1122G980體G712主要G10317G9869G2265G6336A1A6A2G72661G16833G16340簡(jiǎn)G6475G712易G4410易用2G13520合統(tǒng)G9803高G5242非G17819程化4面G2533G19610合的操G1328方G53475G1209G2528G980G12193G16833法結(jié)構(gòu)G6564供G1016G12193使用方G534715系統(tǒng)開(kāi)發(fā)方法在開(kāi)發(fā)方法的G17885G6333上G712采用G1114原G3423法G2656G10995G2641G2620G7411法相結(jié)合的方法。具體G7481G16840G712G4613是在系統(tǒng)開(kāi)發(fā)G1055前對(duì)系統(tǒng)有G980G1022G5647體G7706G7562設(shè)G5831G712G2520功能G2345G1815的結(jié)構(gòu)G2656功能也G8616G17751G9177G7982G712G1306是G17836G8821有具體G4466現(xiàn)。系統(tǒng)完G6116G1172么功能G712分G6116G2750G1972G1022G18108分G712G2520G1022G18108分G2460有G2750G1972G1022模塊G712G18129G5062理解G6496G6581G712G5194G1000在G1209后的設(shè)計(jì)G17819程中G993需要G1582G3838G3835的改動(dòng)G712只是具體G2052G8611G1022模塊G17836G8821有G1852G18108G4466現(xiàn)A1A7A2。具體G3332設(shè)計(jì)可能是完G1852G4466現(xiàn)G980G1022模塊G712也可能是用G980G1022效G10587高的模塊代G7379G980G1022G7099模塊。汽車(chē)銷(xiāo)售管理系統(tǒng)的開(kāi)發(fā)是G980G20045G8616G17751復(fù)雜的工G1328G712我G1216必須G17885用G12197G4410的有效的開(kāi)發(fā)方法。16系統(tǒng)開(kāi)發(fā)的意義汽車(chē)銷(xiāo)售管理系統(tǒng)是汽車(chē)公司管理管理系統(tǒng)非常G18337要的G980G1022環(huán)節(jié)G712汽車(chē)銷(xiāo)售管理的系統(tǒng)化G451計(jì)G12651G7438化是G6984G1022汽車(chē)公司管理中很G18337要的G980G1022G13464G6116G18108分G712能否G4466現(xiàn)G17837G980步關(guān)系G2052公司銷(xiāo)售水平的高G1314。因此G712汽車(chē)銷(xiāo)售管理系統(tǒng)G4613逐G9188G2475G2052G18337視G712G5194在公司的信息管理中占據(jù)G1114G17246G7481G17246G18337要的份G18339。第二章系統(tǒng)分析721可行性分析可行性研究的目的是用最小的代價(jià)在G4625可能短的G7114G19400內(nèi)確G4462問(wèn)題是否能G3827解決。也G4613是G16840可行性研究的目的G993是解決問(wèn)題G712G13792是確G4462問(wèn)題是否值得去解G712研究在當(dāng)前的具體條G1226G991G712開(kāi)發(fā)G7044系統(tǒng)是否具備必要的G17176源G2656G1866G4439條G1226A8A9A10。G980般G16840G7481G712G5224G1186經(jīng)濟(jì)可行性G451技術(shù)可行性G451運(yùn)行可行性G451法律可行性G2656開(kāi)發(fā)方案可行性G12573方面研究可行性。211經(jīng)濟(jì)可行性汽車(chē)銷(xiāo)售管理系統(tǒng)的編寫(xiě)只需要G980臺(tái)PG38G7438即可G712目前PG38G7438的G18209置均能滿(mǎn)足汽車(chē)銷(xiāo)售管理系統(tǒng)的編寫(xiě)G2656使用的要求。G13792銷(xiāo)售信息報(bào)表的打印則只需要增加G980臺(tái)打印G7438即可G712G17837是G980般公司G18129可G1209承擔(dān)的。212技術(shù)可行性G1328G1038計(jì)G12651G7438G12197G4410與技術(shù)專(zhuān)G1006的G4410G10995G712經(jīng)G17819四年的G4410習(xí)對(duì)編寫(xiě)程G5219G18129有獨(dú)G12447的動(dòng)手操G1328能G2159G712G13792對(duì)G980G1022簡(jiǎn)G2345的汽車(chē)銷(xiāo)售管理系統(tǒng)G7481G16840G712G1209我G1216目前的技術(shù)水平是完G1852可G1209勝任的。213使用可行性該系統(tǒng)只是G980G1022小G3423的汽車(chē)銷(xiāo)售管理系統(tǒng)G712使用起G7481簡(jiǎn)G2345方G1427G712另外G712現(xiàn)在的G16780G3822汽車(chē)銷(xiāo)售公司G18129G18209有專(zhuān)門(mén)的計(jì)G12651G7438G1166才G712只需要對(duì)該系統(tǒng)的使用G13785進(jìn)行簡(jiǎn)G2345的培訓(xùn)即可投G1849使用。22需求分析G17902G17819調(diào)查分析G712該汽車(chē)銷(xiāo)售管理系統(tǒng)G5224該G3534本G1209G991G980G1135的功能1G451銷(xiāo)售G451G1849庫(kù)的原始數(shù)據(jù)的錄G18492G451G17751G3921的G7447G19492管理83G451原始數(shù)據(jù)修改簡(jiǎn)G2345方G14274G451方G1427的數(shù)據(jù)查詢(xún)G712支持G3822條G1226查詢(xún)5G451相G5224的G7447G19492G991G712刪除數(shù)據(jù)方G1427簡(jiǎn)G2345G712數(shù)據(jù)穩(wěn)G4462性G39216G451數(shù)據(jù)統(tǒng)計(jì)自動(dòng)完G6116G712G4625G18339G1955G4581G1166工干預(yù)23系統(tǒng)設(shè)計(jì)背景本G20045目名G12228G726G980G1022小G3423汽車(chē)銷(xiāo)售管理系統(tǒng)。本G17731G1226G3534本上能具體化G451合理化得管理汽車(chē)銷(xiāo)售的銷(xiāo)售情況G2656員工信息G712用面G2533對(duì)G16949設(shè)計(jì)的思G13512方G5347去G1114解計(jì)G12651G7438的G3534本工G1328原理G2656高G13435程G5219G16833G16340設(shè)計(jì)。24系統(tǒng)的功能簡(jiǎn)介主要功能G726售前管理G451車(chē)輛管理G451客戶(hù)購(gòu)車(chē)管理G451查詢(xún)統(tǒng)計(jì)G451售后管理G451系統(tǒng)設(shè)G4462。25系統(tǒng)開(kāi)發(fā)的目標(biāo)出G1122本系統(tǒng)是汽車(chē)銷(xiāo)售公司的G980G1022G13520合性的系統(tǒng)G712本系統(tǒng)的設(shè)計(jì)目標(biāo)G4570最G13468G4462位G1122完G6116G1209上G6164述的系統(tǒng)主要G1006G2165的G3534本模G3423。第三章概要設(shè)計(jì)931系統(tǒng)模塊設(shè)計(jì)311系統(tǒng)功能模塊設(shè)計(jì)按G10043系統(tǒng)功能需求分析G712對(duì)系統(tǒng)進(jìn)行模塊分解G712可對(duì)系統(tǒng)G1328劃分G1038G726系統(tǒng)設(shè)G4462模塊G451售前管理模塊G451車(chē)輛管理模塊G451客戶(hù)購(gòu)車(chē)管理模塊G451查詢(xún)統(tǒng)計(jì)模塊G451售后管理模塊。1系統(tǒng)設(shè)G4462模塊G726用戶(hù)管理G451修改G4506碼G451員工管理G451退出系統(tǒng)。2售前管理模塊G726添加客戶(hù)信息G451車(chē)輛信息管理G451客戶(hù)信息管理。3車(chē)輛管理模塊G726添加進(jìn)貨信息G451添加退貨信息。4客戶(hù)購(gòu)車(chē)管理模塊G726客戶(hù)購(gòu)車(chē)G451客戶(hù)退車(chē)。5查詢(xún)統(tǒng)計(jì)模塊G726車(chē)輛進(jìn)貨查詢(xún)G451車(chē)輛退貨查詢(xún)G451車(chē)輛銷(xiāo)售查詢(xún)G451銷(xiāo)售退貨查詢(xún)G451車(chē)輛庫(kù)存查詢(xún)G451銷(xiāo)售排行查詢(xún)。6售后管理模塊G726車(chē)輛進(jìn)貨結(jié)賬G451車(chē)輛退貨結(jié)賬G451車(chē)輛銷(xiāo)售結(jié)賬G451銷(xiāo)售退貨結(jié)賬G451銷(xiāo)售盈利。根據(jù)系統(tǒng)功能分析設(shè)計(jì)得G2052G3926圖31G6164示的系統(tǒng)功能模塊圖。A11A12A13A14A15A16A17A18A19A20A1132數(shù)據(jù)庫(kù)設(shè)計(jì)10321數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)汽車(chē)銷(xiāo)售管理系統(tǒng)G4466體關(guān)系ER的分析是G5326G12447在系統(tǒng)功能模塊分析的G3534礎(chǔ)上的。在員工管理系統(tǒng)中存在的G4466體有G726員工信息G4466體G451車(chē)輛信息G4466體G451客戶(hù)信息G4466體G451銷(xiāo)售信息G4466體G451銷(xiāo)售退貨信息G4466體G451車(chē)輛G1849庫(kù)信息G4466體G451車(chē)輛退貨信息G4466體G451銷(xiāo)G18339信息G4466體G451G7447G19492信息G4466體G2656用戶(hù)信息G4466體。G2520G1022G4466體具體的描述ER圖G3926圖32G6164示。A11A12A13A21A15A16A22A13A23A1111322數(shù)據(jù)庫(kù)邏輯設(shè)計(jì)現(xiàn)在需要G4570上面的數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)轉(zhuǎn)化G1038SQLSERVER2005數(shù)據(jù)庫(kù)系統(tǒng)G6164支持的G4466G19481數(shù)據(jù)模G3423G712也G4613是數(shù)據(jù)庫(kù)的邏輯結(jié)構(gòu)。汽車(chē)銷(xiāo)售管理系統(tǒng)數(shù)據(jù)庫(kù)中G2520G1022表的設(shè)計(jì)結(jié)果G3926G991面表格G6164示。G8611G1022表格表示在數(shù)據(jù)庫(kù)中的G980G1022表。用戶(hù)表G11USERG12用G7481存放用戶(hù)信息G3926表31G6164示。A24A12A13A14A25A26A24A27A28A29A30A31A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A52A53A54A55A28A29A30A31A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A67A68A69A28A29A30A31A56A70A60A71A30A59A60A31A61A62A60A31A63A64A65A66A43A43A72A73A28A29A30A31A56A74A75A58A59A60A31A61A62A60A31A63A76A65A66A43A43A67A68A40A41A28A29A30A31A56A77A78A74A30A59A60A31A61A62A60A31A63A76A65A66A46A47A43用工信息表G708EMPLOYEESG709用G7481存放用工信息G3926表32G6164示。A79A80A81A76A52A53A82A83A79A35A84A71A74A85A86A78A30A30A29A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A54A55A30A71A74A85A86A78A30A30A29A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A69A33A30A71A74A85A86A78A30A30A29A56A70A60A71A30A59A60A31A61A62A60A31A63A64A65A66A43A43A52A53A87A88A30A71A74A85A86A78A30A30A29A56A74A86A29A77A57A86A70A59A60A31A61A62A60A31A63A76A65A66A43A43A89A90A30A71A74A85A86A78A30A30A29A56A29A30A91A59A60A31A61A62A60A31A63A76A66A43A43A92A93A94A95A30A71A74A85A86A78A30A30A29A56A96A57A31A77A62A58A60A78A29A71A60A85A85A58A60A77A30A77A57A71A30A43A42A93A97A98A55A30A71A74A85A86A78A30A30A29A56A61A60A31A58A59A60A31A61A62A60A31A63A64A99A66A43A43A100A101A30A71A74A85A86A78A30A30A29A56A77A30A85A59A60A31A61A62A60A31A63A76A65A66A43A43A102A103A30A71A74A85A86A78A30A30A29A56A74A62A86A77A86A57A71A60A104A30A43A43A105A106A30A71A74A85A86A78A30A30A29A56A60A58A58A31A30A29A29A59A60A31A61A62A60A31A63A107A65A66A43A43A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42客戶(hù)信息表G708CUSTOMERG709用G7481存放客戶(hù)信息G3926表33G6164示。A79A80A81A80A108A68A82A83A79A35A109A110A29A77A86A71A30A31A3212A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A108A68A54A55A109A110A29A77A86A71A30A31A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A108A68A69A33A109A110A29A77A86A71A30A31A56A70A60A71A30A59A60A31A61A62A60A31A63A64A65A66A43A43A89A90A109A110A29A77A86A71A30A31A56A29A30A91A59A60A31A61A62A60A31A63A76A66A43A43A92A111A94A95A109A110A29A77A86A71A30A31A56A96A57A31A77A62A58A60A78A29A71A60A85A85A58A60A77A30A77A57A71A30A43A42A108A68A93A97A109A110A29A77A86A71A30A31A56A74A31A86A112A30A29A29A57A86A70A59A60A31A61A62A60A31A63A107A65A66A43A42A113A114A52A31A30A61A30A74A30A31A59A60A31A61A62A60A31A63A64A65A66A43A42A93A97A98A55A109A110A29A77A86A71A30A31A56A61A60A31A58A59A60A31A61A62A60A31A63A64A99A66A43A43A100A101A109A110A29A77A86A71A30A31A56A77A30A85A59A60A31A61A62A60A31A63A76A65A66A43A42A84A81A71A60A57A85A109A110A29A77A86A71A30A31A56A71A60A57A85A59A60A31A61A62A60A31A63A107A65A66A43A42A105A106A109A110A29A77A86A71A30A31A56A60A58A58A31A30A29A29A59A60A31A61A62A60A31A63A107A65A66A43A42A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛信息信息表G708CARSG709用G7481存放車(chē)輛信息G3926表34G6164示。A79A80A81A115A116A117A82A83A82A83A79A35A109A60A31A29A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A116A117A54A55A61A60A31A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A116A117A69A118A61A60A31A56A70A60A71A30A59A60A31A61A62A60A31A63A71A60A91A66A43A43A116A117A40A41A61A60A31A56A77A78A74A30A59A60A31A61A62A60A31A63A76A66A43A43A116A117A119A120A96A31A60A70A58A29A71A60A85A85A58A60A77A30A77A57A71A30A43A42A116A117A121A122A61A60A31A56A74A31A57A61A30A59A60A31A61A62A60A31A63A107A65A66A43A42A116A117A123A105A61A60A31A56A74A85A60A61A30A59A60A31A61A62A60A31A63A64A99A66A43A43A92A124A125A126A61A60A31A56A74A31A86A58A110A77A57A86A70A77A57A71A30A59A60A31A61A62A60A31A63A76A65A66A43A42A116A117A102A103A74A62A86A77A86A59A60A31A61A62A60A31A63A107A65A66A43A42A127A128A129A130A104A86A86A58A29A57A70A56A77A57A71A30A59A60A31A61A62A60A31A63A107A65A66A43A42A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛進(jìn)貨信息表G708GOODSING709用G7481存放車(chē)輛進(jìn)貨信息G3926表35G6164示。A79A80A81A107A116A117A131A132A82A83A79A35A133A86A86A58A29A57A70A3213A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A131A132A54A55A104A86A86A58A29A57A70A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A116A117A69A118A61A60A31A56A70A60A71A30A59A60A31A61A62A60A31A63A71A60A91A66A43A43A131A132A121A122A74A31A57A61A30A71A86A70A30A78A43A43A131A132A52A86A74A30A31A60A77A86A31A59A60A31A61A62A60A31A63A64A65A66A43A43A38A134A60A71A86A110A70A77A57A70A77A43A43A131A132A129A130A104A86A86A58A29A57A70A56A77A57A71A30A29A71A60A85A85A58A60A77A30A77A57A71A30A43A43A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛退貨信息表G708RETURNG709用G7481存放車(chē)輛退貨信息G3926表36G6164示。A79A80A81A135A116A117A136A132A82A83A79A35A137A30A77A110A31A70A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A136A132A54A55A104A86A86A58A29A57A70A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A116A117A69A118A61A60A31A56A70A60A71A30A59A60A31A61A62A60A31A63A71A60A91A66A43A43A136A132A121A122A74A31A57A61A30A71A86A70A30A78A43A43A136A132A52A86A74A30A31A60A77A86A31A59A60A31A61A62A60A31A63A64A65A66A43A43A38A134A60A71A86A110A70A77A57A70A77A43A43A136A132A129A130A104A86A86A58A29A57A70A56A77A57A71A30A29A71A60A85A85A58A60A77A30A77A57A71A30A43A43A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛銷(xiāo)售信息表G708SALESG709用G7481存放車(chē)輛銷(xiāo)售信息G3926表37G6164示。A79A80A81A138A116A117A139A140A82A83A79A35A141A60A85A30A29A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A139A140A54A55A141A60A85A30A29A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A116A117A69A118A109A60A31A56A70A60A71A30A59A60A31A61A62A60A31A63A71A60A91A66A43A43A108A68A54A55A109A110A29A77A86A71A30A31A56A57A58A59A60A31A61A62A60A31A63A76A65A66A43A43A139A140A38A134A60A71A86A110A70A77A57A70A77A43A43A142A143A52A86A74A30A31A60A77A86A31A59A60A31A61A62A60A31A63A64A65A66A43A43A144A145A141A60A85A30A29A56A29A77A60A77A30A59A60A31A61A62A60A31A63A64A65A66A43A43A79A146A116A117A147A140A148A149A150A151A152A129A130A29A60A85A30A29A56A77A57A71A30A29A71A60A85A85A58A60A77A30A77A57A71A30A43A43A139A140A153A154A74A31A57A61A30A71A86A70A30A78A43A43A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛銷(xiāo)售退貨信息表G708SALESRETURNG709用G7481存放車(chē)輛銷(xiāo)售退貨信息G3926表38G6164示14A79A80A81A99A116A117A139A140A136A132A82A83A79A35A141A60A85A30A29A31A30A77A110A31A70A32A33A34A35A36A32A33A34A35A37A32A38A39A40A41A42A43A44A45A46A47A42A43A48A49A50A51A139A140A136A132A54A55A31A30A77A110A31A70A56A57A58A59A60A31A61A62A60A31A63A64A65A66A42A43A116A117A69A118A109A60A31A56A70A60A71A30A59A60A31A61A62A60A31A63A71A60A91A66A43A43A108A68A54A55A109A110A29A77A86A71A30A31A56A57A58A59A60A31A61A62A60A31A63A76A65A66A43A43A136A132A38A134A60A71A86A110A70A77A57A70A77A43A43A142A143A52A86A74A30A31A60A77A86A31A59A60A31A61A62A60A31A63A64A65A66A43A43A151A152A129A130A31A30A77A110A31A70A56A77A57A71A30A29A71A60A85A85A58A60A77A30A77A57A71A30A43A43A136A132A153A154A74A31A57A61A30A71A86A70A30A78A43A43A50A51A71A30A71A86A59A60A31A61A62A60A31A63A71A60A91A66A43A42車(chē)輛庫(kù)存信息表G708STOCKG709用G7481存放車(chē)輛庫(kù)存信息G3926表39G6164示。A79A80A81A155A116A117A156A157A82A83A79A35A141A77A86A61A158A32A33A34A35A36A32A33A34A35A