【導(dǎo)讀】畢業(yè)設(shè)計（論文）--馨凱房地產(chǎn)公司客戶關(guān)系管理系統(tǒng)。隨著市場經(jīng)濟的深入發(fā)展市場競爭行業(yè)競爭越演越烈產(chǎn)品和服務(wù)的差異。越來越小以生產(chǎn)為中心以銷售產(chǎn)品為目的的市場戰(zhàn)略逐漸被以客戶為中心以服。務(wù)為目的的市場戰(zhàn)略所取代誰能掌握客戶的需求趨勢加強與客戶的關(guān)系有效發(fā)。掘和管理客戶資源誰就能獲得市場競爭優(yōu)勢在激烈的競爭中立于不敗之地企業(yè)。供應(yīng)商分銷商及客戶連成一片的價值鏈成為企業(yè)之間競爭的核心客戶關(guān)系管理。該系統(tǒng)所面向的對象為整個系統(tǒng)從符合操作簡便界面友好靈活使用安全的。要求出發(fā)采用NET作為前臺開發(fā)工具SQLServer作為后臺數(shù)據(jù)庫平臺基于BS. 的三層模式的系統(tǒng)旨在實現(xiàn)利用數(shù)據(jù)庫來存儲管理大量數(shù)據(jù)信息設(shè)計并完成對。其各種數(shù)據(jù)的分類查詢和統(tǒng)計盡可能實現(xiàn)友好的操作界面。提高客戶滿意度和忠誠度發(fā)掘客戶價值從而提高企業(yè)盈利。關(guān)鍵詞CRM客戶關(guān)系管理房地產(chǎn)ASPNET數(shù)據(jù)庫。13課題主要的研究工作2. 14論文結(jié)構(gòu)的計劃安排2. ASPNET的概念和特點3. ASPNET頁面主要的優(yōu)點5. 72存在問題及解決44

　　

【正文】 hinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_customer_customer_bank] DEFAULT [customer_bank_account] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_customer_customer_bank_account] DEFAULT [customer_local_tax_no] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_customer_customer_local_tax_no] DEFAULT [customer_national_tax_no] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_customer_customer_national_tax_no] DEFAULT [customer_status] [char] 1 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_customer_customer_status] DEFAULT 1 CONSTRAINT [PK_cst_customer] PRIMARY KEY CLUSTERED [customer_no] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 5 客戶交往記錄表 cst_activity 的實現(xiàn)該表用于存儲公司與客戶的交往記錄 CREATE TABLE [dbo][cst_activity] [activity_id] [int] IDENTITY 11 NOT NULL [activity_customer_no] [char] 17 COLLATE Chinese_PRC_CI_AS NOT NULL [activity_cust_name] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NULL [activity_date] [datetime] NOT NULL CONSTRAINT [DF_cst_activity_activity_date] DEFAULT getdate [activity_place] [nvarchar] 200 COLLATE Chinese_PRC_CI_AS NOT NULL [activity_title] [nvarchar] 500 COLLATE Chinese_PRC_CI_AS NOT NULL [activity_desc] [nvarchar] 2021 COLLATE Chinese_PRC_CI_AS NULL [activity_momo] [nvarchar] 2021 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [PK_cst_activity] PRIMARY KEY CLUSTERED [activity_id] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 6 聯(lián)系人信息表 cst_linkman 的實現(xiàn)該表用于存儲客戶的聯(lián)系方式 CREATE TABLE [dbo][cst_linkman] [linkman_id] [int] IDENTITY 11 NOT NULL [linkman_customer_no] [char] 17 COLLATE Chinese_PRC_CI_AS NOT NULL [linkman_customer_name] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NULL [linkman_name] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL [linkman_sex] [nvarchar] 5 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_linkman_linkman_sex] DEFAULT N 男 [linkman_postion] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_linkman_linkman_postion] DEFAULT [linkman_tel] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_cst_linkman_linkman_tel] DEFAULT [linkman_mobile] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL [linkman_memo] [nvarchar] 300 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [PK_cst_linkman] PRIMARY KEY CLUSTERED [linkman_id] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 7 客戶流失表 cst_lost 的實現(xiàn)該表用于對流失客戶進行詳細的記錄 CREATE TABLE [dbo][cst_lost] [lost_id] [int] IDENTITY 11 NOT NULL [lost_customer_no] [char] 17 COLLATE Chinese_PRC_CI_AS NOT NULL [lost_customer_name] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NULL [lost_customer_manager_id] [int] NOT NULL [lost_customer_manager_name] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL [lost_last_order_date] [datetime] NULL [lost_lost_date] [datetime] NULL [lost_delay] [nvarchar] 4000 COLLATE Chinese_PRC_CI_AS NULL [lost_reason] [nvarchar] 2021 COLLATE Chinese_PRC_CI_AS NULL [lost_status] [nvarchar] 10 COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_cst_lost_lost_status] DEFAULT 1 CONSTRAINT [PK_cst_lost] PRIMARY KEY CLUSTERED [lost_id] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 8 客戶服務(wù)表 cst_service 的實現(xiàn)該表用于存儲服務(wù)信息 CREATE TABLE [dbo][cst_service] [service_id] [int] NOT NULL [service_type] [nvarchar] 20 COLLATE Chinese_PRC_CI_AS NOT NULL [service_title] [nvarchar] 500 COLLATE Chinese_PRC_CI_AS NOT NULL [service_customer_no] [char] 17 COLLATE Chinese_PRC_CI_AS NOT NULL [service_customer_name] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NOT NULL [service_status] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_cst_service_service_status] DEFAULT 新創(chuàng)建 [service_request] [nvarchar] 3000 COLLATE Chinese_PRC_CI_AS NOT NULL [service_create_id] [int] NOT NULL [service_create_by] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL [service_create_date] [datetime] NOT NULL CONSTRAINT [DF_cst_service_service_create_date] DEFAULT getdate [service_due_id] [int] NULL [service_due_to] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL [service_due_date] [datetime] NULL [service_deal] [nvarchar] 3000 COLLATE Chinese_PRC_CI_AS NULL [service_deal_id] [int] NULL [service_deal_by] [nvarchar] 50 COLLATE Chinese_PRC_CI_AS NULL [service_deal_date] [datetime] NULL [service_result] [nvarchar] 500 COLLATE Chinese_PRC_CI_AS NULL [service_satisfy] [int] NULL CONSTRAINT [PK_cst_service] PRIMARY KEY CLUSTERED [service_id] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 9 訂單表 orders 的實現(xiàn)該表用于存儲客戶定購地產(chǎn)的信息 CREATE TABLE [dbo][orders] [orders_id] [int] IDENTITY 11 NOT NULL [orders_customer] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NOT NULL [orders_date] [datetime] NOT NULL CONSTRAINT [DF_orders_orders_date] DEFAULT getdate [louPanName] [varchar] 200 COLLATE Chinese_PRC_CI_AS NOT NULL [houseNumber] [varchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL [money] [varchar] 50 COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [PK_orders] PRIMARY KEY CLUSTERED [orders_id] ASC WITH IGNORE_DUP_KEY OFF ON [PRIMARY] ON [PRIMARY] GO 10 地產(chǎn)信息表 products 的實現(xiàn)該表用于存儲地產(chǎn)的相關(guān)信息 CREATE TABLE [dbo][product] [product_id] [int] IDENTITY 11 NOT NULL [product_name] [nvarchar] 200 COLLATE Chinese_PRC_CI_AS NOT NULL [product_type] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NOT NULL [product_batch] [nvarchar] 100 COLLATE Chinese_PRC_CI_AS NULL [product_unit] [nvarchar] 10 COLLATE Chinese_PRC_CI_AS NULL [product_price] [decimal] 19 2 NULL [product_memo] [nvarchar] 200 COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [PK_product] PRIMARY KEY CLUSTERED [product_id] ASC WIT