άÐÞÏîÄ¿¹ÜÀíϵͳ½éÉÜ_ͨÐŹ¤³Ì±ÏÒµÂÛÎÄ·¶ÎÄ
·¢²¼Ê±¼ä£º
2015-01-30
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
άÐÞÏîÄ¿¹ÜÀíϵͳ½éÉÜ_ͨÐŹ¤³Ì±ÏÒµÂÛÎÄ·¶ÎÄ
άÐÞÏîÄ¿¹ÜÀíϵͳ½éÉÜ
Ò»¡¢½¨ÉèÄ¿µÄ
±¾ÏµÍ³Ö÷Òª½â¾ö·Ö¹«Ë¾¸÷ÖÖ½¨ÉèÏîÄ¿ÔÚ¿ª¹¤ºóÎÞ·¨¼°Ê±¹Ü¿ØµÄÎÊÌâ¡£
Ä¿Ç°·Ö¹«Ë¾ÔÚ¶Ô¸÷¸ö½¨ÉèÏîÄ¿ÉóÅúºóÄÑÒÔ¶ÔÆäʵʩ¹ý³Ì½øÐÐÓÐЧ¹Ü¿Ø£¬ÏîÄ¿½¨ÉèµÄ³ÉЧÄÑÒԵõ½±£Ö¤¡£ÎªÊµÊ©¾«È·»¯¹ÜÀí£¬ÓÐЧ¹ÜÀíÏîÄ¿µÄ½ø¶È£¬½¨Éè¸ÃÏîÄ¿¹ÜÀíϵͳ£¬¶ÔÏîĿʵʩ¹ý³Ì½øÐÐʵʱ¶½°ì¡£¸Ãϵͳ¸Ä±äÁËÄ¿Ç°ÏîÄ¿¹ÜÀíºÍʵʩÈËÔ±½»Á÷²»³©Í¨µÄ¾ÖÃ棬ÏîĿʵʩÈËÔ±¿ÉËæʱÔÚϵͳ·´Ó³ÏîÄ¿½¨ÉèµÄ½ø¶È£¬¹ÜÀíÈËÔ±¿ÉÔÚϵͳ²é¿´ÏîÄ¿µÄ½øÕ¹Çé¿ö£¬²¢¿É½øÐл¥¶¯¹µÍ¨¡£
¶þ¡¢ÏµÍ³¹¦ÄÜ
ÔÚ¿ªÊ¼Ò»¸öÏîÄ¿½¨ÉèÇ°£¬ÒªÏÈÔÚ±¾ÏµÍ³Â¼Èë¸ÃÏîÄ¿µÄ»ù±¾ÐÅÏ¢¡£
ÏîÄ¿¿ªÊ¼½¨Éèºó£¬Ê©¹¤ÈËÔ±ËæʱÔÚ±¾ÏµÍ³·´Ó³Ê©¹¤½ø¶ÈÇé¿ö£¬¹ÜÀíÈËÔ±¿ÉËæʱÕÆÎÕÏîÄ¿µÄ״̬£¬¼°Ê±½øÐж½´ÙÖ¸µ¼£¬²¢½øÐÐË«Ïò»¥¶¯¹µÍ¨¡£
×÷Ϊһ¸öÔÚ½¨ÏîÄ¿£¬ÆäÉúÃü״̬Ϊ£ºÁ¢ÏÅú¡¢ÄⶩºÏͬ¡¢²ÄÁϲɹº¡¢¿ª¹¤¡¢Í깤¡¢¿¢¹¤½áËã¡¢³õÑé¡¢ÖÕÑé¡¢Éó¼Æ¡£ÔÚÆäÿһÖÖ״̬Ï£¬Ê©¹¤ÈËÔ±¶¼¿ÉÒÔ¼ÈëÉϱ¨ÐÅÏ¢£¬È繤³ÌÎĵµ/²úÉú·ÑÓÃ/²ÎÓëÈËÔ±µÈ£¬¹ÜÀíÈËÔ±¿ÉËæʱÁ˽⹤³ÌµÄ½ø¶È×´¿ö²¢½øÐÐÖ¸µ¼¡£
ÏîÄ¿Íê³Éºó£¬¿É½«ÏîĿ״̬ÖÃΪÀúÊ·²¢´æµµ£¬ÒÔ±¸ÒÔºó²éÔÄ¡£
ϵͳҲ¿ÉÒÔ¸ù¾ÝÒªÇó¶ÔÏîÄ¿·ÑÓõȽøÐÐÁé»îµÄ²éѯºÍͳ¼Æ¡£
Èý¡¢¿ª·¢Çé¿ö
±¾ÏµÍ³²ÉÓÃB/SµÄ·½Ê½ÔËÐУ¬¿Í»§¶ËÖ±½ÓÓÃä¯ÀÀÆ÷ÔËÐм´¿É£¬ÏµÍ³Î¬»¤Ò²¼«Îª¼òµ¥¡£
ϵͳ²ÉÓÃASP.NETºÍC#ÓïÑÔ½øÐпª·¢£¬ºǫ́Êý¾Ý¿âΪSQLSERVER2000¡£
ϵͳÖ÷ÒªÓÃÁËÈýÕÅÖ÷±í½øÐÐÏîÄ¿½ø³ÌÊý¾ÝµÄ¼Ç¼£¬ÆäÖÐUDS_CM_ClientInfoÓÃÓڼǼÏîÄ¿µÄ»ù±¾Çé¿ö£¬È磺ÏîÄ¿Ãû³Æ£¬ÔðÈÎÈË£¬ËùÊô²¿ÃÅ£¬·ÖÀ࣬ÏîÄ¿±àºÅ£¬Ô¤Ë㣬¼ò½éµÈ¡£µ±ÓÐеÄÏîÄ¿´´½¨Ê±½«Æä¼Èë±¾±í¡£Æä´´½¨½Å±¾ÈçÏ£º
CREATE TABLE [UDS_CM_ClientInfo] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ChiefLinkmanID] [int] NULL ,
[Birthday] [datetime] NULL ,
[UpdateTime] [datetime] NULL ,
[Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ShortName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ContactTimes] [int] NULL CONSTRAINT [DF_UDS_CM_ClientInfo_ContactTimes] DEFAULT (0),
[SellPhase] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BargainPrognosis] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Fee] [decimal](18, 2) NULL ,
[AddManID] [int] NULL ,
[Linkman_Telephone] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CurStatus] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Type] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Affiliatedarea] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[URL] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ZIP] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[CompanyProperty] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Calling] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
[CompanySize] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Money] [decimal](18, 2) NULL ,
[Operation] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Introduce] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[ITGrade] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[PCNumber] [decimal](18, 2) NULL ,
[Net] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ITStaffs] [int] NULL ,
[ITDepartment] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Principal] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[System] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[Customer] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ClientInitiative] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[FirstContactTime] [datetime] NULL ,
[NextContactTime] [datetime] NULL ,
[ContactTime] [datetime] NULL ,
CONSTRAINT [PK_UDS_CM_ClientInfo] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
±íUDS_CM_ClientContactÓÃÓڼǼÏîÄ¿µÄÏêϸ¸ú×ÙÐÅÏ¢£¬È磺ÏîĿ״̬£¬²úÉú·ÑÓ㬸½¼þµÈ£¬Ò»Ìõ±íUDS_CM_ClientInfoµÄ¼Ç¼¿É¶ÔÓ¦¶àÌõ±íUDS_CM_ClientContactµÄ¼Ç¼¡£
Æä´´½¨½Å±¾ÈçÏ£º
CREATE TABLE [UDS_CM_ClientContact] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ClientID] [int] NOT NULL ,
[MarketmanID] [int] NULL ,
[UpdateTime] [datetime] NULL ,
[ContactTimes] [decimal](10, 2) NULL ,
[CurStatus] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ContactAim] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[SellMoney] [decimal](10, 2) NULL ,
[BargainPrognosis] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ContactType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Fee] [decimal](10, 2) NULL ,
[ContactContent] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[NextContactAim] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[NextContactTime] [datetime] NULL ,
[FeeUsed] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ContactTime] [datetime] NULL ,
CONSTRAINT [PK_UDS_CM_ClientContact] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
±íUDS_CM_AttachmentÓñí¼Ç¼¸½¼þÐÅÏ¢£¬Îª³ÌÐòÌáÈ¡¸½¼þÌṩÃû³ÆºÍ·¾¶µÈÐÅÏ¢¡£Æä´´½¨½Å±¾ÈçÏ£º
CREATE TABLE [UDS_CM_Attachment] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Path] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[Type] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[PertainID] [int] NULL ,
[Extension] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_UDS_CM_Attachment] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
ϵͳÓÚ2007Äê2Ô·ݿªÊ¼½øÐпª·¢£¬ÖÁ4Ô·ݽáÊø³ÌÐò²âÊÔ£¬ÀúʱÁ½¸ö¶àÔ¡£¿ª·¢Íê³Éºóϵͳ¼´Í¶ÈëÔËÐУ¬Ä¿Ç°³ÌÐòÔËÐÐ×´¿öÁ¼ºÃ¡£
±¾ÏµÍ³½øÐмòµ¥µÄÐ޸ļ´¿ÉÒÆÖ²µ½ÆäËü·þÎñÆ÷ÉÏ£¬Ò×ÓÚ½øÐÐÍƹ㡣
ËÄ¡¢Ó¦ÓÃÇé¿ö
ϵͳĿǰÔÚÎàÖÝÊеçÐÅ·Ö¹«Ë¾µÃµ½ÁËÍƹãÓ¦Ó㬲¢È¡µÃÁËÁ¼ºÃµÄЧ¹û¡£
¸÷²¿ÃÅ£¨ÌرðÊǸ÷ÏØ·Ö¹«Ë¾£©Ã¿Ä궼Óкܶà´ó´óССµÄÏîÄ¿¿ª¹¤½¨É裬άÐÞÏîÄ¿¸üÊDz»¼ÆÆäÊý¡£±¾ÏµÍ³½¨ÉèÒÔÇ°£¬ÕâЩÏîÄ¿ÔÚÉóÅúÍê³ÉºóºÜÄÑÕÆÎÕÆä½øÕ¹Çé¿ö£¬¶ÔÕâЩÏîÄ¿µÄ¹Ü¿Ø³ÉÁËÒ»¸öÄѵ㡣ÉõÖÁ³öÏÖÁ˸ö±ð²¿ÃŵÄÏîĿûÓа´ÒªÇó¿ªÊ¼½¨É裬µ½ÆÚ×îÖÕûÓÐÍê³É£¬³öÏÖÁ˺ܴóµÄÀË·Ñ¡£
ϵͳÉÏÏßÒÔÀ´£¬¸÷ÖÖ¹¤³Ì½¨ÉèÏîÄ¿ºÍάÐÞÏîÄ¿¶¼Â¼Èëϵͳ½øÐÐÁ˸ú×Ù¡£Ê©¹¤ÈËÔ±°´½ø¶ÈÇé¿ö½øÐм°Ê±µÄÉϱ¨¹¤×÷£¬¶ÔÏîÄ¿µÄÅú¸´ÈÕÆÚ¡¢ÔðÈÎÈËÔ±¡¢¸÷ʱ¼ä¶Î²úÉúµÄ·ÑÓᢵ±Ç°µÄ½øÕ¹Çé¿ö¼°¸÷½×¶ÎµÄ¹Ø¼üÐÔÎĵµ£¨ÈçºÏͬ£©¶¼½øÐÐÁËÏêϸµÄ¼Ç¼»ò´æµµ£¬ÎªÏîÄ¿µÄ¹Ü¿Ø¡¢ ¹¤³Ì·ÑÓõĹÜÀí¡¢Ô±¹¤µÄ¿¼ºËÒÔ¼°ÏîÄ¿µÄ²éѯ¶¼ÌṩÁ˼«´óµÄ¿É²Ù×÷ÐÔ¡£
±¾ÏµÍ³½¨Á¢Á˹¤³Ì·ÑÓÃËæʱÉϱ¨µÄͨµÀ£¬Îª¼õÉÙ¸÷ÖÖÀË·ÑÌṩÁËÒ»¸ö·½·¨£¬ÎªÏîÄ¿½¨ÉèµÄ¾«È·»¯¹ÜÀíÌṩÁ˱£Ö¤¡£
Îå¡¢¾¼ÃЧÒæ²âËã
±¾ÏµÍ³ÔËÐкó¸Ä±äÁ˸÷ÖÖÊ©¹¤ÏîÄ¿ÍÏí³»ìÂҵľÖÃ棬ÔöÇ¿ÁËÏîÄ¿Ê©¹¤ÈËÔ±µÄÔðÈÎÐÄ£¬±ÜÃâÁ˸÷ÖÖÏîÄ¿ÉóÅúºó×îÖÕûÓÐÍê³ÉµÄÇé¿ö£¬¶Å¾øÁ˸÷ÖÖ¹¤³Ì½¨ÉèÖеÄÀË·ÑÏÖÏó¡£
Áù¡¢ÏµÍ³½çÃæ½Øͼ
A£®ÐÂÔöÏîÄ¿
B£®ÏîÄ¿ä¯ÀÀ
C£®ÏîÄ¿¸ú×Ù
ËùÓиú×ÙÐÅÏ¢
D£®·ÑÓÃͳ¼Æ
¹ãÎ÷µçÐÅÍøÂçÔËÐÐά»¤¼¼Êõ´´Ð¾ºÈüÏîÄ¿É걨±í
£¨¸öÈËÏîÄ¿£©
ÐÕÃû Ì·Ìì ÐÔ±ð ÄÐ ÄêÁä 31 Ãñ×å ºº
ÎÄ»¯³Ì¶È ±¾¿Æ ¼¼ÊõÖ°³Æ ¹¤³Ìʦ Ö°Îñ Ö÷°ì ¸ÚλÃû³Æ ¿ª·¢Ö÷°ì
¸öÈËÔø¾ÈÙ»ñµÄ¼¼Êõ³É¹û£¨ÂÛÎÄ£©½±ÀøÇé¿ö ÎÞ
ÏîÄ¿É걨Ãû³Æ άÐÞÏîÄ¿¸ú×Ùϵͳ
³É¹û£¨ÂÛÎÄ£©¼òÒª½éÉÜ ¿É¶Ô¸÷ÖÖ½¨ÉèÏîĿʵʩ¾«È·»¯¹ÜÀí£¬ÓÐЧ¹ÜÀíÏîÄ¿µÄ½ø¶È£¬¶ÔÏîÄ¿½ø³Ì½øÐÐʵʱ¶½°ì£¬²¢ÊµÊ±·´Ó³¸÷¸öÏîÄ¿µÄ½¨ÉèÇé¿ö£¬Îª¹ÜÀíÈËÔ±ºÍʵʩÈËÔ±´ò¿ªÒ»¸ö¼°Ê±¹µÍ¨µÄͨµÀ£¬¸Ä±äÁËÒÔÇ°¹«Ë¾ÄÑÒÔ¶ÔÉóÅúºóµÄ¸÷ÖÖ½¨É輰άÐÞÏîÄ¿µÄʵʩ¹ý³Ì½øÐйܿصÄÇé¿ö¡£
³É¹ûËù´´Ôì¼ÛÖµ
¿ª·¢Çé¿ö ×ÔÖ÷¿ª·¢
ÓµÓÐ֪ʶ²úȨ
Ó¦Ó÷¶Î§ ÎàÖÝÊеçÐÅ·Ö¹«Ë¾¼°¸÷ÏØ·Ö¹«Ë¾
ÍƹãµÄ¿ÉÐÐÐÔ
ÓÐÎÞ»ñ½± ÎÞ
ÆÀѡר¼Ò×éÒâ¼û
ÆÀÑ¡ÉóºË×éÒâ¼û