【正文】 [int] IDENTITY(1,1) 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](2000) COLLATE Chinese_PRC_CI_AS NULL, [activity_momo] [nvarchar](2000) 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的實(shí)現(xiàn)，該表用于存儲(chǔ)客戶的聯(lián)系方式。CREATE TABLE [dbo].[cst_linkman]( [linkman_id] [int] IDENTITY(1,1) 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 (N39。男39。), [linkman_postion] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_cst_linkman_linkman_postion] DEFAULT (39。39。), [linkman_tel] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_cst_linkman_linkman_tel] DEFAULT (39。39。), [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的實(shí)現(xiàn)，該表用于對(duì)流失客戶進(jìn)行詳細(xì)的記錄。CREATE TABLE [dbo].[cst_lost]( [lost_id] [int] IDENTITY(1,1) 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](2000) 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的實(shí)現(xiàn)，該表用于存儲(chǔ)服務(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 (39。新創(chuàng)建39。), [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的實(shí)現(xiàn)，該表用于存儲(chǔ)客戶定購(gòu)地產(chǎn)的信息。CREATE TABLE [dbo].[orders]( [orders_id] [int] IDENTITY(1,1) 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的實(shí)現(xiàn)，該表用于存儲(chǔ)地產(chǎn)的相關(guān)信息。 CREATE TABLE [dbo].[product]( [product_id] [int] IDENTITY(1,1) 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)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO （11）用戶信息表Sys_user的實(shí)現(xiàn)，該表用于存儲(chǔ)管理員用戶的基本信息。CREATE TABLE [dbo].[sys_user]( [user_id] [int] IDENTITY(1,1) NOT NULL, [user_name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [user_password] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_sys_user] PRIMARY KEY CLUSTERED ( [user_id] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GO 系統(tǒng)功能模塊的設(shè)計(jì)與實(shí)現(xiàn) 根據(jù)需求分析，現(xiàn)確定登陸模塊的流程圖為，當(dāng)用戶登錄時(shí)服務(wù)器會(huì)對(duì)其進(jìn)行檢測(cè)，如果用戶名或密碼錯(cuò)誤或?yàn)榭眨?yè)面上會(huì)有相應(yīng)的提示。如果正確則會(huì)進(jìn)入系統(tǒng)主界面。 當(dāng)用戶在登陸頁(yè)面，輸入用戶名密碼后，點(diǎn)擊登錄時(shí)，系統(tǒng)會(huì)得到用戶輸入的用戶名和密碼，然后去數(shù)據(jù)庫(kù)表Sys_User中進(jìn)行查找，如果有匹配的項(xiàng)則會(huì)返回正確信息，并且將用戶信息存入Session中如果沒(méi)有匹配項(xiàng)則會(huì)返回錯(cuò)誤信息。具體實(shí)現(xiàn)如下： if ( != amp。amp。 != ) { if (((), (), out validUser)) { Sys_user users = (())。 Session[User] = users。