汽车4S店经销商管理系统的设计与实施

汽车4S店经销商管理系统的设计与实施 北京航空航天大学硕士学位论文 摘 要 进入新世纪以来，我国对汽车的消费迅速增加，随之而来的是各品牌的4S店纷纷开张。 面对如此巨大的市场，如何使4S店有效的管理汽车销售中的各项数据，成了各企业面临的 一个重大课题。 为了解决这一问题，帮助4S店有效提高销售业绩，我们通过对多数汽车品牌4S店的实际 调研，设计出了汽车4S店经销商管理系统。该系统要对买家信息、车辆信息、销售信息、 售后信息、维修信息等进行存储与处理。并且对以上信息进行正确地关联，实现数据共享。 鉴于本系统的总体需求与目前主流技术情况， 通过对本系统的设计与实现，成功解决了4S店在处理大量复杂数据方面的难题，将以往 需要人工完成的工作全部改由计算机自动执行。有效的整合了企业资源，简化了办公流程; 降低了出错率;精简了员工规模;最大限度挖掘了企业的商业潜力，使卖家提高了业绩，使 买家得到了优良的售后服务。 关键词:客户关系管理，C/S模式，数据共享 - 1 - stract stract In entering in the new century, the need for cars in China has increased quickly, and follows the 4s stores of all brands open one by one. Facing this huge market, how to manage many kinds of data of car sales effectively has become a big theme to enterprises. To solve this problem and help 4s stores increase sales performance, I have done some surveys and investigations to several kinds of automobile 4s stores, and design an Automobile 4s Store Dealer Management System. This system will store and deal with the buyer, car, sales, customer service and maintenance information, correctly link the above the information and realize data sharing. Based the major demands of this system and current mainstream technology, I use C# to develop in .NET platform, the system use a structure combined by C/S and B/S modules. The seller management system’s client uses C/S module, and server uses B/S module. Five subsystems are connected to two database server (one of them is used for back up) by inner internet of the enterprise. There is a firewall set between Outer internet and inner server to protect the enterprise from hostile attacking. It uses SQLServer2000 as background database. By designing and realizing this system, I have successfully solved the problem of dealing with a large amount of complex data in 4s stores, the burden and ineffective work previously done by people was not done by computers, this change effectively integrated the enterprise resources, simplified the office process, descend the mistake rate, cut off the member scale, exploit the business potential of this enterprise at maximized extent, improved the performance of seller and made the buyer get excellent after-sales service. key words: CRM、C#、C/S mode、data share - 2 - 北京航空航天大学硕士学位论文 目 录 第一章 绪论 .................................................................... - 1 - 1.1 课题来源............................................................. - 1 - 1.2 国需求分析 ................................................................ - 5 - 2.1业务流程分析 ......................................................... - 5 - 2.2功能需求概述 ......................................................... - 6 - 2.4本章小结 ............................................................. - 9 - 第三章 系统总体设计............................................................. - 10 - 3.1系统总体设计的原则 .................................................. - 10 - 3.2系统的功能模块设计 .................................................. - 10 - 3.5数据库设计 .......................................................... - 20 - 3.5.1数据库概念模型设计 ............................................. - 21 - 3.5.2数据库实体模型设计 ............................................. - 21 - 3.5.3数据库逻辑模型设计 ............................................. - 23 - 3.5本章小结 ............................................................ - 26 - 第四章 系统设计与实现.......................................................... - 27 - 4.1 整车销售管理模块设计 ................................................ - 27 - 4.2维修管理模块的设计 .................................................. - 28 - 4.3 配件管理模块的设计 .................................................. - 30 - 4.4人事管理模块的设计 .................................................. - 31 - 4.5客户关系管理模块的设计 .............................................. - 32 - 4.6系统安全 ............................................................ - 37 - 4.6.1安全因素 ....................................................... - 37 - 4.6.2系统安全策略 ................................................... - 38 - 4.7 系统部分实现 ........................................................ - 40 - 4.8本章小结 ............................................................ - 45 - 第五章 系统测试与实施.......................................................... - 46 - 5.1 测试概述及目的 ...................................................... - 46 - 5.2 系统测试............................................................ - 46 - 5.3 测试环境及工具 ...................................................... - 47 - 5.5 典型的测试用例 ...................................................... - 47 - 5.4 测试方法............................................................ - 48 - 参考文 献 ....................................................................... - 66 - 致 谢 .......................................................................... - 68 - - 3 -