1、I *公司客户管理系统开发与实现 摘 要 本课题所设计的系统能够统一管理与企业相关的客户及其联系人信息。客户 与相关联系人信息是企业最重要的资源之一,通过客户管理系统能够有效地管理 客户信息,提高企业客户管理效率。在此基础之上,进一步展开,才能对客户之 间发生的活动、机会、销售、费用等进行详细管理。本课题实现了基础信息维护 (包括:域信息设置、企业性质设置、企业类型设置、企业资信设置、客户级别 设置、客户满意程度设置) ;客户信息维护(包括:客户信息、联系人信息、业务 往来、发送邮件) ;客户服务(包括客户反馈、客户投诉、客户反馈满意程度分析、 客户投诉满意程度分析) ;客户信息查询(包括:客
2、户信息报表、联系人信息报表、 业务往来报表、客户反馈报表、客户投拆报表) ;辅助工具以及管理模块,真正实 现了客户资源管理的一体化。 关键词:CRM;客户管理系统;MS Sql Server 2005 II The Development And Implementation of Hongda Customer Management System ABSTRACT Designed by the subject to unified management system associated with the enterprise customers and their contact inf
3、ormation. Customers with relevant contact information is one of the most important resource, through the customer management system to effectively manage customer information and improve the efficiency of enterprise customer management. On this basis, further to between customer activities, opportun
4、ities, sales, management, etc.To achieve this task the maintenance of the basic information(including: domain information settings, the nature of an enterprise set up, business type, business credit establishment, customer-level settings, set the level of customer satisfaction); maintenance of custo
5、mer information (including: customer information,contact information,business contacts,send e-mail); customer service(including customer feedback,customer complaints,customer satisfaction feedback analysis, satisfaction with the analysis of customer complaints); customer information (including:custo
6、mer information statements, contact information statements, business reports, customer feedback statements, statements of customer complaints); aids as well as the management module,Customers realize the integration of resource management. Keywords: CRM; Management System Customer;MS Sql Server2005 III 目目 录录 引 言 . 1 第 1 章 系统分析 . 2 1.1 需求分析 2 1.2 可行性分析 2 第 2 章 系统设计 . 5 2.1 设计目标 5 2.2 开发及运行环境 5 2.3 项目规划 5 第 3 章 系统数据库设计 . 7 3.1 数据库概要设计 7 3.2 数据库物理设计 9 第 4 章 主要功能模块设计 17 4.1 主窗体设计 . 17 4.2 数据模块 . 2