項目實訓(xùn)指導(dǎo)書

版本歷史版本/狀態(tài)修訂人修改日期備注1.0.0鄧?yán)^林2014-08-20創(chuàng)建文檔

開發(fā)背景為了系統(tǒng)的，成體系的將客戶管理起來，通過客戶類型、狀態(tài)、過程的跟進和分析，調(diào)整公司的實際客戶戰(zhàn)略方向，有效的通過對于客戶關(guān)系的管理提升銷售額，減少銷售環(huán)節(jié)，促進銷售成單，且加強客戶管理，公司需要開發(fā)一套用于管理客戶關(guān)系的CRM系統(tǒng)

。CRM客戶關(guān)系管理軟件是企業(yè)的一種營銷手段和營銷策略，是通過與客戶密切溝通、聯(lián)絡(luò)，形成良性互動的關(guān)系，來達到不斷完善企業(yè)自身管理或改善營銷策略，最終促進企業(yè)發(fā)展、提升營銷效益的一種管理機制?？蛻絷P(guān)系管理的目的，在于建立一種企業(yè)與客戶的良性、協(xié)調(diào)、密切配合的互動關(guān)系。項目目的ASP.NETMVC3模式運用掌握EF(EntityFrameWork)技術(shù)知識點準(zhǔn)備ASP.NETMVC3框架：框架搭建Razor視圖引擎EF(EntityFrameWork)：插件安裝ADO.NET4.0.1+CodeFirst1.0.1數(shù)據(jù)模型建立代碼生成JQuery：JQuery語法AJAX處理鞏固的知識點ASP.NETMVC3架構(gòu)JQuery框架的綜合運用ASP.NET中AJAX的靈活運用EF框架

需求分析系統(tǒng)流程系統(tǒng)中關(guān)于服務(wù)的處理流程如下：功能結(jié)構(gòu)系統(tǒng)用例

數(shù)據(jù)庫設(shè)計邏輯設(shè)計系統(tǒng)的E-R圖如下：數(shù)據(jù)表設(shè)計表名：Bas_Dict序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Dict_Idbigint80是是否編號|l2Dict_Typenvarchar500否類別|sl3Dict_Itemnvarchar500否條目|sl4Dict_Valuenvarchar500否值|sl5Dict_Is_Editablebit10否1是否可編輯|s1-可以；0-不可以表名：Cst_Activity交往記錄序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Atv_Idbigint80是是否編號2Atv_Cust_Nochar170是是客戶編號，外鍵3Atv_Cust_Namenvarchar1000是客戶名稱4Atv_Datedatetime83否getdate時間|l5Atv_Placenvarchar2000否地點|l6Atv_Titlenvarchar5000否概要|l7Atv_Descnvarchar20000是詳細(xì)信息|l表名：Cst_Customer客戶表序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Cust_Nochar170是否客戶編號|ls2Cust_Namenvarchar1000否客戶名稱|ls3Cust_Regionnvarchar500是''地區(qū)|ls4Cust_Manager_Idbigint80是0客戶經(jīng)理編號5Cust_Manager_Namenvarchar500是''客戶經(jīng)理|ls6Cust_Levelint40是1客戶等級7Cust_Level_Labelnvarchar500是''客戶等級|ls8Cust_Satisfyint40是3滿意度9Cust_Creditint40是3信用度10Cust_Addrnvarchar3000是''地址11Cust_Zipchar100是''郵政編碼12Cust_Telnvarchar500是''電話13Cust_Faxnvarchar500是''傳真14Cust_Websitenvarchar500是''網(wǎng)址15Cust_Licence_Nonvarchar500是''營業(yè)執(zhí)照注冊號16Cust_ChiefTainnvarchar500是''法人17Cust_BankRollbigint80是0注冊資金18Cust_TurnOverbigint80是0營業(yè)額19Cust_Banknvarchar2000是''開戶銀行20Cust_Bank_Accountnvarchar500是''銀行賬號21Cust_Local_Tax_Nonvarchar500是''地稅登記號22Cust_National_Tax_Nonvarchar500是''國稅登記號23Cust_Statuschar10是1客戶狀態(tài)：1--正常；2--流失；3--刪除。表名：Cst_Linkman聯(lián)系人序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Lkm_Idbigint80是是否編號2Lkm_Cust_Nochar170是否客戶編號，外鍵3Lkm_Cust_Namenvarchar1000是客戶名稱4Lkm_Namenvarchar500否姓名|l5Lkm_Sexnvarchar50是'男'性別|l6Lkm_Postionnvarchar500是''職位|l7Lkm_Telnvarchar500否''辦公電話|l8Lkm_Mobilenvarchar500是手機|l9Lkm_Memonvarchar3000是備注|l表名：Cst_Lost客戶流失序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Lst_Idbigint80是是否編號2Lst_Cust_Nochar170是否客戶編號3Lst_Cust_Namenvarchar1000是客戶名稱|ls4Lst_Cust_Manager_Idbigint80否客戶經(jīng)理編號5Lst_Cust_Manager_Namenvarchar500否客戶經(jīng)理|ls6Lst_Last_Order_Datedatetime83是上次下單時間|l7Lst_Lost_Datedatetime83是確認(rèn)流失時間|l8Lst_Delaynvarchar40000是暫緩措施9Lst_Reasonnvarchar20000是流失原因10Lst_Statusvarchar100否1狀態(tài)|ls,1-警告，2-暫緩流失，3-已經(jīng)流失表名：Cst_Service客戶服務(wù)序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Svr_Idbigint80是是否編號|l2Svr_Typenvarchar200否服務(wù)類型|ls3Svr_Titlenvarchar5000否概要|ls4Svr_Cust_Nochar170是是客戶編號，外鍵5Svr_Cust_Namenvarchar1000否客戶|ls6Svr_Statusnvarchar100否'新創(chuàng)建'狀態(tài)|s7Svr_Requestnvarchar30000否服務(wù)請求8Svr_Create_Idbigint80否創(chuàng)建人9Svr_Create_Bynvarchar500否創(chuàng)建人|l10Svr_Create_Datedatetime83否getdate創(chuàng)建時間|ls11Svr_Due_Idbigint80是分配給12Svr_Due_Tonvarchar500是分配給|l13Svr_Due_Datedatetime83是分配時間14Svr_Dealnvarchar30000是服務(wù)處理15Svr_Deal_Idbigint80是處理人16Svr_Deal_Bynvarchar500是處理人17Svr_Deal_Datedatetime83是處理時間18Svr_Resultnvarchar5000是處理結(jié)果19Svr_Satisfyint40是滿意度表名：Sal_Chance序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Chc_Idbigint80是是否編號2Chc_Sourcenvarchar500是機會來源3Chc_Cust_Namenvarchar1000否客戶名稱4Chc_Titlenvarchar2000否5Chc_Rateint40否0成功機率6Chc_LinkMannvarchar500是聯(lián)系人7Chc_Telnvarchar500是聯(lián)系人電話8Chc_Descnvarchar20000否機會描述9Chc_Create_Idbigint80否創(chuàng)建人10Chc_Create_Bynvarchar500否創(chuàng)建人11Chc_Create_Datedatetime83否getdate創(chuàng)建時間12Chc_Due_Idbigint80是指派給13Chc_Due_Tonvarchar500是指派給14Chc_Due_Datedatetime83是指派時間15Chc_Statuschar100否1狀態(tài)：1--未指派；2--已指派；3--開發(fā)成功；4--終止開發(fā)。表名：Sal_Plan序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Pla_Idbigint80是是否編號2Pla_Chc_Idbigint80是否銷售機會編號|，外鍵3Pla_Datedatetime83否日期|l4Pla_ToDonvarchar5000否計劃項|l5Pla_Resultnvarchar5000是執(zhí)行結(jié)果|l表名：Sys_Right序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Right_Codevarchar500是否2Right_Parent_Codevarchar500是3Right_Typevarchar200是4Right_Textvarchar500是5Right_Urlvarchar1000是6Right_Tipvarchar500是表名：Sys_Role序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Role_Idbigint80是是否2Role_Namenvarchar500否3Role_Descnvarchar5000是4Role_Flagint40是表名：Sys_Role_Right序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Rf_Idbigint80是是否2Rf_Role_Idbigint80是否3Rf_Right_Codevarchar500否表名：Sys_User序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵外鍵允許空默認(rèn)值說明1Usr_Idbigint80是是否2Usr_Namenvarchar500否3Usr_Passwordnvarchar500否4Usr_Role_Idbigint80是是5Usr_Flagint40否數(shù)據(jù)庫相關(guān)數(shù)據(jù)表腳本創(chuàng)建數(shù)據(jù)表select*fromv_sine_dailysales_reportwherepk_corp='1020'andvsalestrucode='10105060102'andareaclcode='232'ifexists(select*fromsysobjectswhereid=OBJECT_ID('[Bas_Dict]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Bas_Dict]CREATETABLE[Bas_Dict]([Dict_Id][bigint]IDENTITY(1,1)NOTNULL,[Dict_Type][nvarchar](50)NOTNULL,[Dict_Item][nvarchar](50)NOTNULL,[Dict_Value][nvarchar](50)NOTNULL,[Dict_Is_Editable][bit]NOTNULLDEFAULT(1))ALTERTABLE[Bas_Dict]WITHNOCHECKADDCONSTRAINT[PK_Bas_Dict]PRIMARYKEYNONCLUSTERED([Dict_Id])SETIDENTITY_INSERT[Bas_Dict]ONINSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(2,N'服務(wù)類型',N'咨詢',N'1',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(3,N'服務(wù)類型',N'建議',N'2',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(4,N'服務(wù)類型',N'投訴',N'3',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(7,N'客戶等級',N'普通客戶',N'1',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(9,N'客戶等級',N'重點開發(fā)客戶',N'2',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(10,N'客戶等級',N'大客戶',N'3',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(11,N'客戶等級',N'合作伙伴',N'4',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(12,N'客戶等級',N'戰(zhàn)略合作伙伴',N'5',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(13,N'地區(qū)',N'河北',N'河北',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(14,N'地區(qū)',N'北京',N'北京',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(15,N'地區(qū)',N'東北',N'東北',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(16,N'地區(qū)',N'中南',N'中南',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(17,N'服務(wù)狀態(tài)',N'新創(chuàng)建',N'1',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(20,N'服務(wù)狀態(tài)',N'已分配',N'2',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(22,N'服務(wù)狀態(tài)',N'已處理',N'3',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(23,N'服務(wù)狀態(tài)',N'已歸檔',N'4',1)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(32,N'aaa',N'bbb',N'ccc',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(34,N'aaa',N'bbb',N'dd',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(35,N'aaa',N'bbb',N'dddd',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(36,N'aaa',N'dd',N'dd',0)INSERT[Bas_Dict]([Dict_Id],[Dict_Type],[Dict_Item],[Dict_Value],[Dict_Is_Editable])VALUES(37,N'1',N'1',N'1',0)SETIDENTITY_INSERT[Bas_Dict]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Cst_Activity]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Cst_Activity]CREATETABLE[Cst_Activity]([Atv_Id][bigint]IDENTITY(1,1)NOTNULL,[Atv_Cust_No][char](17)NULL,[Atv_Cust_Name][nvarchar](100)NULL,[Atv_Date][datetime]NOTNULLDEFAULT(getdate()),[Atv_Place][nvarchar](200)NOTNULL,[Atv_Title][nvarchar](500)NOTNULL,[Atv_Desc][nvarchar](2000)NULL)ALTERTABLE[Cst_Activity]WITHNOCHECKADDCONSTRAINT[PK_Cst_Activity]PRIMARYKEYNONCLUSTERED([Atv_Id])SETIDENTITY_INSERT[Cst_Activity]ONINSERT[Cst_Activity]([Atv_Id],[Atv_Cust_No],[Atv_Cust_Name],[Atv_Date],[Atv_Place],[Atv_Title],[Atv_Desc])VALUES(6,N'KH071207032218637',N'客戶1',N'2008/12/90:00:00',N'我1',N'我1',N'萬維網(wǎng)1')INSERT[Cst_Activity]([Atv_Id],[Atv_Cust_No],[Atv_Cust_Name],[Atv_Date],[Atv_Place],[Atv_Title],[Atv_Desc])VALUES(7,N'KH071207251',N'客戶3',N'2008/3/90:00:00',N'三',N'三',N'三')INSERT[Cst_Activity]([Atv_Id],[Atv_Cust_No],[Atv_Cust_Name],[Atv_Date],[Atv_Place],[Atv_Title],[Atv_Desc])VALUES(9,N'KH071207032218638',N'客戶1',N'2009/9/90:00:00',N'的',N'的的',N'三')INSERT[Cst_Activity]([Atv_Id],[Atv_Cust_No],[Atv_Cust_Name],[Atv_Date],[Atv_Place],[Atv_Title],[Atv_Desc])VALUES(12,N'KH20120423161957',N'122222',N'2014/8/20:00:00',N'1',N'1',N'1')SETIDENTITY_INSERT[Cst_Activity]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Cst_Customer]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Cst_Customer]CREATETABLE[Cst_Customer]([Cust_No][char](17)NOTNULL,[Cust_Name][nvarchar](100)NOTNULL,[Cust_Region][nvarchar](50)NULLDEFAULT(''),[Cust_Manager_Id][bigint]NULLDEFAULT(0),[Cust_Manager_Name][nvarchar](50)NULLDEFAULT(''),[Cust_Level][int]NULLDEFAULT(1),[Cust_Level_Label][nvarchar](50)NULLDEFAULT(''),[Cust_Satisfy][int]NULLDEFAULT(3),[Cust_Credit][int]NULLDEFAULT(3),[Cust_Addr][nvarchar](300)NULLDEFAULT(''),[Cust_Zip][char](10)NULLDEFAULT(''),[Cust_Tel][nvarchar](50)NULLDEFAULT(''),[Cust_Fax][nvarchar](50)NULLDEFAULT(''),[Cust_Website][nvarchar](50)NULLDEFAULT(''),[Cust_Licence_No][nvarchar](50)NULLDEFAULT(''),[Cust_ChiefTain][nvarchar](50)NULLDEFAULT(''),[Cust_BankRoll][bigint]NULLDEFAULT(0),[Cust_TurnOver][bigint]NULLDEFAULT(0),[Cust_Bank][nvarchar](200)NULLDEFAULT(''),[Cust_Bank_Account][nvarchar](50)NULLDEFAULT(''),[Cust_Local_Tax_No][nvarchar](50)NULLDEFAULT(''),[Cust_National_Tax_No][nvarchar](50)NULLDEFAULT(''),[Cust_Status][char](1)NULLDEFAULT(1))ALTERTABLE[Cst_Customer]WITHNOCHECKADDCONSTRAINT[PK_Cst_Customer]PRIMARYKEYNONCLUSTERED([Cust_No])INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH071207032218637',N'客戶1',N'華北',7,N'zhangsan',3,N'大客戶',4,2,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Addr],[Cust_Zip],[Cust_Tel],[Cust_Fax],[Cust_Website],[Cust_Licence_No],[Cust_ChiefTain],[Cust_BankRoll],[Cust_TurnOver],[Cust_Bank],[Cust_Bank_Account],[Cust_Local_Tax_No],[Cust_National_Tax_No],[Cust_Status])VALUES(N'KH071207032218638',N'聰海信息科技有限公司',N'北京',5,N'zhaoliu',4,N'普通客戶',2,5,N'addr1',N'zip1',N'tel1',N'fax1',N'web1',N'aaaa1',N'bbb1',10001,10001,N'xxxxx1',N'cccc1',N'eeeee1',N'fffff1',N'3')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH071207174',N'客戶3',N'華北',7,N'zhangsan',3,N'大客戶',3,5,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Addr],[Cust_Zip],[Cust_Tel],[Cust_Fax],[Cust_Website],[Cust_ChiefTain],[Cust_BankRoll],[Cust_TurnOver],[Cust_Bank],[Cust_Bank_Account],[Cust_Status])VALUES(N'KH071207251',N'客戶4',N'中南',5,N'zhaoliu',3,N'大客戶',3,3,N'6',N'6666',N'666666666',N'6',N'6666666666666666',N'666',0,0,N'6666666',N'66',N'3')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH07122406540272',N'客戶5',N'中南',7,N'zhangsan',3,N'大客戶',1,1,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Addr],[Cust_Zip],[Cust_Tel],[Cust_Fax],[Cust_Website],[Cust_Licence_No],[Cust_ChiefTain],[Cust_BankRoll],[Cust_TurnOver],[Cust_Bank],[Cust_Bank_Account],[Cust_Local_Tax_No],[Cust_National_Tax_No],[Cust_Status])VALUES(N'KH20120423010122',N'客戶6',N'北京',7,N'zhangsan',1,N'戰(zhàn)略合作伙伴',5,4,N'b',N'c',N'd',N'e',N'f',N'ggg',N'hhh',1111,2222,N'cccc',N'eee',N'fff',N'gggg',N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH20120423161957',N'122222',N'北京',3,N'admin',0,N'大客戶',0,0,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Addr],[Cust_Zip],[Cust_Tel],[Cust_Fax],[Cust_Website],[Cust_Licence_No],[Cust_ChiefTain],[Cust_BankRoll],[Cust_TurnOver],[Cust_Bank],[Cust_Bank_Account],[Cust_Local_Tax_No],[Cust_National_Tax_No],[Cust_Status])VALUES(N'KH20120425190713',N'新客戶',N'北京',5,N'zhaoliu',4,N'普通客戶',5,5,N'Addr',N'Zip',N'Tel',N'Fax',N'Web',N'xxxxxxxxxxxx',N'zhang',1000,1000,N'yyyyyyyyyy',N'xxxxxxxxxxxxxx',N'xxx',N'yyyy',N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH20120425190858',N'zhang',N'北京',5,N'zhaoliu',2,N'合作伙伴',4,4,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH20120425214930',N'NewUser',N'北京',3,N'admin',1,N'戰(zhàn)略合作伙伴',5,4,N'1')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Status])VALUES(N'KH20120425214959',N'NewUser2',N'華北',5,N'zhaoliu',3,N'大客戶',3,4,N'3')INSERT[Cst_Customer]([Cust_No],[Cust_Name],[Cust_Region],[Cust_Manager_Id],[Cust_Manager_Name],[Cust_Level],[Cust_Level_Label],[Cust_Satisfy],[Cust_Credit],[Cust_Addr],[Cust_Zip],[Cust_Tel],[Cust_Fax],[Cust_Website],[Cust_Licence_No],[Cust_ChiefTain],[Cust_BankRoll],[Cust_TurnOver],[Cust_Bank],[Cust_Bank_Account],[Cust_Local_Tax_No],[Cust_National_Tax_No],[Cust_Status])VALUES(N'KH20140820210025',N'111',N'北京',3,N'admin',1,N'戰(zhàn)略合作伙伴',5,5,N'1',N'1',N'1',N'1',N'1',N'1',N'1',1,1,N'1',N'1',N'1',N'1',N'1')ifexists(select*fromsysobjectswhereid=OBJECT_ID('[Cst_Linkman]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Cst_Linkman]CREATETABLE[Cst_Linkman]([Lkm_Id][bigint]IDENTITY(1,1)NOTNULL,[Lkm_Cust_No][char](17)NOTNULL,[Lkm_Cust_Name][nvarchar](100)NULL,[Lkm_Name][nvarchar](50)NOTNULL,[Lkm_Sex][nvarchar](5)NULLDEFAULT('男'),[Lkm_Postion][nvarchar](50)NULLDEFAULT(''),[Lkm_Tel][nvarchar](50)NOTNULLDEFAULT(''),[Lkm_Mobile][nvarchar](50)NULL,[Lkm_Memo][nvarchar](300)NULL)ALTERTABLE[Cst_Linkman]WITHNOCHECKADDCONSTRAINT[PK_Cst_Linkman]PRIMARYKEYNONCLUSTERED([Lkm_Id])SETIDENTITY_INSERT[Cst_Linkman]ONINSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(4,N'KH071207032218637',N'aaa',N'姓名1',N'男',N'職位1',N'辦公電話1',N'手機1',N'備注1')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(5,N'KH071207032218637',N'bbb',N'22',N'女',N'22',N'22',N'22',N'22')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Memo])VALUES(9,N'KH071207032218637',N'66666666666',N'女',N'666',N'6',N'666666666666666')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(10,N'KH071207032218637',N'6',N'男',N'66',N'6',N'6',N'6')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(11,N'KH071207032218637',N'7',N'女',N'7',N'7',N'7',N'7')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Tel])VALUES(12,N'KH07122406540272',N'2',N'5',N'男',N'6')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Name],[Lkm_Sex],[Lkm_Tel])VALUES(13,N'KH20120423161957',N'1s3',N'男',N)INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(21,N'KH071207032218637',N'客戶1',N'aaa',N'女',N'bbb',N'ccc',N'ddd',N'eee')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(22,N'KH071207032218637',N'客戶1',N'ccc',N'女',N'ddd',N'eee',N'fff',N'ggg')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(23,N'KH071207032218637',N'客戶1',N'ccc',N'男',N'ddd',N'eee',N'fff',N'ggg')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel],[Lkm_Mobile],[Lkm_Memo])VALUES(24,N'KH071207032218637',N'客戶1',N'abc',N'男',N'ddd',N'ee',N'1387766556',N'ggg')INSERT[Cst_Linkman]([Lkm_Id],[Lkm_Cust_No],[Lkm_Cust_Name],[Lkm_Name],[Lkm_Sex],[Lkm_Postion],[Lkm_Tel])VALUES(33,N'KH20140820210025',N'111',N'1',N'男',N'1',N'1')SETIDENTITY_INSERT[Cst_Linkman]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Cst_Lost]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Cst_Lost]CREATETABLE[Cst_Lost]([Lst_Id][bigint]IDENTITY(1,1)NOTNULL,[Lst_Cust_No][char](17)NOTNULL,[Lst_Cust_Name][nvarchar](100)NULL,[Lst_Cust_Manager_Id][bigint]NOTNULL,[Lst_Cust_Manager_Name][nvarchar](50)NOTNULL,[Lst_Last_Order_Date][datetime]NULL,[Lst_Lost_Date][datetime]NULL,[Lst_Delay][nvarchar](4000)NULL,[Lst_Reason][nvarchar](2000)NULL,[Lst_Status][varchar](10)NOTNULLDEFAULT(1))ALTERTABLE[Cst_Lost]WITHNOCHECKADDCONSTRAINT[PK_Cst_Lost]PRIMARYKEYNONCLUSTERED([Lst_Id])SETIDENTITY_INSERT[Cst_Lost]ONINSERT[Cst_Lost]([Lst_Id],[Lst_Cust_No],[Lst_Cust_Name],[Lst_Cust_Manager_Id],[Lst_Cust_Manager_Name],[Lst_Last_Order_Date],[Lst_Lost_Date],[Lst_Delay],[Lst_Reason],[Lst_Status])VALUES(8,N'KH071207032218637',N'客戶2',5,N'zhaoliu',N'2010/10/150:00:00',N'2012/5/420:07:47',N'aaaaaaaaaaaaaaaaaaaa',N'dddddddddddddddeeeffffddd',N'3')INSERT[Cst_Lost]([Lst_Id],[Lst_Cust_No],[Lst_Cust_Name],[Lst_Cust_Manager_Id],[Lst_Cust_Manager_Name],[Lst_Last_Order_Date],[Lst_Lost_Date],[Lst_Delay],[Lst_Reason],[Lst_Status])VALUES(9,N'KH071207032218637',N'客戶1',7,N'zhangsan',N'2011/3/130:00:00',N'2012/5/419:47:51',N'請客戶吃飯！dgadgagag請客戶吃飯！dgadgagag',N'dfdfdfdfdfdfdf',N'2')INSERT[Cst_Lost]([Lst_Id],[Lst_Cust_No],[Lst_Cust_Name],[Lst_Cust_Manager_Id],[Lst_Cust_Manager_Name],[Lst_Last_Order_Date],[Lst_Lost_Date],[Lst_Delay],[Lst_Reason],[Lst_Status])VALUES(10,N'KH07122406540272',N'客戶5',5,N'zhaoliu',N'2010/10/150:00:00',N'2012/5/420:07:47',N'aaaaaaaaaaaaaaaaaaaa',N'dddddddddddddddeeeffffddd',N'3')INSERT[Cst_Lost]([Lst_Id],[Lst_Cust_No],[Lst_Cust_Name],[Lst_Cust_Manager_Id],[Lst_Cust_Manager_Name],[Lst_Last_Order_Date],[Lst_Lost_Date],[Lst_Delay],[Lst_Reason],[Lst_Status])VALUES(11,N'KH20120423010122',N'客戶6',5,N'zhaoliu',N'2010/10/150:00:00',N'2012/5/420:07:47',N'aaaaaaaaaaaaaaaaaaaa',N'dddddddddddddddeeeffffddd',N'3')SETIDENTITY_INSERT[Cst_Lost]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Cst_Service]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Cst_Service]CREATETABLE[Cst_Service]([Svr_Id][bigint]IDENTITY(1,1)NOTNULL,[Svr_Type][nvarchar](20)NOTNULL,[Svr_Title][nvarchar](500)NOTNULL,[Svr_Cust_No][char](17)NULL,[Svr_Cust_Name][nvarchar](100)NOTNULL,[Svr_Status][nvarchar](10)NOTNULLDEFAULT('新創(chuàng)建'),[Svr_Request][nvarchar](3000)NOTNULL,[Svr_Create_Id][bigint]NOTNULL,[Svr_Create_By][nvarchar](50)NOTNULL,[Svr_Create_Date][datetime]NOTNULLDEFAULT(getdate()),[Svr_Due_Id][bigint]NULL,[Svr_Due_To][nvarchar](50)NULL,[Svr_Due_Date][datetime]NULL,[Svr_Deal][nvarchar](3000)NULL,[Svr_Deal_Id][bigint]NULL,[Svr_Deal_By][nvarchar](50)NULL,[Svr_Deal_Date][datetime]NULL,[Svr_Result][nvarchar](500)NULL,[Svr_Satisfy][int]NULL)ALTERTABLE[Cst_Service]WITHNOCHECKADDCONSTRAINT[PK_Cst_Service]PRIMARYKEYNONCLUSTERED([Svr_Id])SETIDENTITY_INSERT[Cst_Service]ONINSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(1,N'1',N'概要',N'客戶',N'4',N'請求',2,N'test',N'2007/12/80:00:00',2,N'hlliu',N'2007/12/60:00:00',N'處理方法',2,N'hlliu',N'2007/12/60:00:00',N'的',4)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(2,N'1',N'四',N'四',N'3',N'三',1,N'hlliu',N'2007/12/70:00:00',2,N'hlliu',N'2007/12/70:00:00',N'rrrrrrr',2,N'hlliu',N'2007/12/130:00:00',N'sdsd',2)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(3,N'2',N'三',N'三',N'2',N'三',1,N'hlliu',N'2007/12/70:00:00',2,N'hlliu',N'2007/12/70:00:00',N'四分',2,N'hlliu',N'2007/12/70:00:00',N'r',2)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(4,N'1',N'rrrrrrr',N'rrrrrrrrrrrrrrrrr',N'4',N'rrrrrrrrrrrrrrrrr',1,N'hlliu',N'2008/12/130:00:00',2,N'hlliu',N'2007/12/130:00:00',N'rrrrrrrrrreeeeeeeeeeeeeeerrrrrre',2,N'hlliu',N'2007/12/130:00:00',N'rrrrrrrrr',3)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date])VALUES(5,N'1',N'aaaaa',N'KH071207032218637',N'客戶1',N'3',N'dddddddddddddddddd',2,N'test',N'2012/5/111:52:14',3,N'admin',N'2012/5/422:45:00',N'dddddddddddddd',5,N'zhaoliu',N'2012/5/521:05:58')INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(6,N'1',N'詢問電腦價格',N'KH071207032218637',N'客戶1',N'4',N'關(guān)于IBM電腦的價格',5,N'zhaoliu',N'2012/5/420:35:03',5,N'zhaoliu',N'2012/5/422:46:29',N'按客戶要求處理！',5,N'zhaoliu',N'2012/5/521:08:44',N'nice',5)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(7,N'1',N'xxxxxxxxxxxx',N'KH071207032218638',N'聰海信息科技有限公司',N'5',N'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',5,N'zhaoliu',N'2012/5/420:54:38',5,N'zhaoliu',N'2012/5/422:50:34',N'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',5,N'zhaoliu',N'2012/5/521:11:42',N'ffffffffffffffff',4)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(8,N'2',N'xxsdfadfdaf',N'KH071207032218637',N'客戶1',N'1',N'dfafafafaf',5,N'zhaoliu',N'2012/5/421:01:38',5,N'zhaoliu',N'2012/5/422:52:48',N'ddddddddddddddddd',5,N'zhaoliu',N'2012/5/521:12:54',N'veryverybad!',2)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(9,N'3',N'aaaaaaaaa',N'KH071207032218637',N'客戶1',N'1',N'ddddddddddddddddddddddddddddddd',5,N'zhaoliu',N'2012/5/421:03:14',5,N'zhaoliu',N'2012/5/422:55:58',N'ddddddddddddddddd',5,N'zhaoliu',N'2012/5/521:14:46',N'很不滿意！',2)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date])VALUES(10,N'1',N'rtrrrrrrr',N'KH071207032218637',N'客戶1',N'2',N'dddddddddddddd',5,N'zhaoliu',N'2012/5/421:03:57',5,N'zhaoliu',N'2012/5/423:34:56')INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date])VALUES(11,N'2',N'ddddddddddd',N'KH071207032218637',N'客戶1',N'2',N'ddddddddddddddddd',5,N'zhaoliu',N'2012/5/421:05:49',5,N'zhaoliu',N'2012/5/423:40:33')INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date],[Svr_Deal],[Svr_Deal_Id],[Svr_Deal_By],[Svr_Deal_Date],[Svr_Result],[Svr_Satisfy])VALUES(12,N'2',N'dddddddddd',N'KH071207032218638',N'聰海信息科技有限公司',N'5',N'ddddddddddddd',5,N'zhaoliu',N'2012/5/421:08:43',5,N'zhaoliu',N'2012/5/423:43:56',N'ddddddddddddddddddddddddddddddd',5,N'zhaoliu',N'2012/5/521:27:17',N'ddddddddddddddddddddd',4)INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date])VALUES(13,N'3',N'dddddddddd',N'KH071207174',N'客戶3',N'2',N'ddddddddddddddd',5,N'zhaoliu',N'2012/5/421:09:46',3,N'admin',N'2012/5/423:44:26')INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date],[Svr_Due_Id],[Svr_Due_To],[Svr_Due_Date])VALUES(14,N'1',N'dddd',N'KH071207174',N'客戶3',N'2',N'dddd',5,N'zhaoliu',N'2012/5/421:12:40',5,N'zhaoliu',N'2012/5/520:07:26')INSERT[Cst_Service]([Svr_Id],[Svr_Type],[Svr_Title],[Svr_Cust_No],[Svr_Cust_Name],[Svr_Status],[Svr_Request],[Svr_Create_Id],[Svr_Create_By],[Svr_Create_Date])VALUES(17,N'2',N'ddddddddddd',N'KH071207174',N'客戶3',N'1',N'ddddddddddddd',5,N'zhaoliu',N'2012/5/