3
ÓÃÓÑƱ¾Ýͨרҵ°æ ¿ìËÙÈëÃÅÖ¸ÄÏÊÖ²á
1
3
Ç°ÑÔ
ÓÃÓÑÈí¼þÊÇÑÇÌ«±¾ÍÁ×î´ó¹ÜÀíÈí¼þ¹©Ó¦ÉÌ£¬ÊÇÖйú×î´óµÄ¹ÜÀíÈí¼þ¡¢ERPÈí¼þ¡¢²ÆÎñÈí¼þ¡¢¼¯ÍŹÜÀíÈí¼þ¡¢ÈËÁ¦×ÊÔ´¹ÜÀíÈí¼þ¼°Ð¡Ð͹ÜÀíÈí¼þ¹©Ó¦ÉÌ¡£Ä¿Ç°£¬Öйú¼°ÑÇÌ«µØÇø³¬¹ý50Íò¼ÒÆóÒµÔËÐÐÓÃÓÑÈí¼þ£¬Ã¿Ä곬¹ý5Íò¼ÒÆóҵѡÔñÓÃÓÑÈí¼þ£¬Ã¿Ì쳬¹ý300ÍòÓû§Ê¹ÓÃÓÃÓÑÈí¼þ¡£ÓÃÓÑÈí¼þÈÃÆóÒµÒµÎñ¸ü¼Ó¸ßЧ£¬·´Ó¦¸ü¼ÓѸËÙ£¬Ð§Òæ¸ü¼ÓÏÔÖø¡£
±±¾©ÓÃÓÑ»ª±íÈí¼þ¼¼ÊõÓÐÏÞ¹«Ë¾ÊÇ
ÓÃÓÑÈí¼þ¹É·ÝÓÐÏÞ¹«Ë¾µÄ¿Ø¹É×Ó¹«Ë¾£¬
ÊÇ¡°×¨ÒµµÄ±¨±í&±íµ¥¡±Èí¼þ¹©Ó¦ÉÌ£¬ÖÂÁ¦ÓÚרҵµÄ±¨±í¼¼ÊõÓë±íµ¥¼¼ÊõµÄÈí¼þ¿ª·¢¼°Êг¡Íƹ㡣¹«Ë¾Ä¿Ç°ÒÑÓµÓÐCell×é¼þ¡¢²å¼þ±¨±í¼¼Êõ²úÆ·¡¢UF ReportÓÃÓѱ¨±í¿ª·¢Æ½Ì¨¡¢E-CellºÍÓÃÓÑƱ¾ÝͨϵÁвúÆ·£¬²úÆ·½øÈëÃÀ¹ú¡¢ÈÕ±¾µÈ20¶à¸ö¹ú¼ÒºÍµØÇø¡£
Ëæ×ŵç×ÓÉÌÎñºÍµç×ÓÕþÎñµÄ¼ÓËÙ·¢Õ¹ºÍÆÕ¼°£¬Æ±¾Ý¹ÜÀíµç×Ó»¯Í¬ÑùÊÆÔÚ±ØÐУ¬ÔÚ2007Äê6ÔÂÖйúÈËÃñÒøÐÐÐû²¼Ö§Æ±¿ÉÔÚÈ«¹úͨÓôóµÄÊг¡±³¾°Ï£¬ÓÃÓÑƱ¾ÝͨÖØй滮Éè¼ÆºóÓ¦ÓöøÉú¡£±¾Èí¼þÊÇÃæÏò´òÓ¡Êг¡µÄÒ»¿îרҵ¼¶µÄƱ¾Ý´òÓ¡¹ÜÀí¹¤¾ßÀàÐÍÈí¼þ£¬¼¯³ÉƱ¾ÝÉè¼Æ¹¦ÄÜ£¬²»½öÂú×ãÓû§´òÓ¡¸÷ÖÖÒøÐÐÍùÀ´Æ±¾Ý£¬Èç֧Ʊ¡¢½øÕ˵¥¡¢»ãƱ£¬Í¬Ê±Óû§»¹¿É×ÔÐÐËæÐèÉè¼Æ¸÷ÀàÄÚ²¿Æ±¾Ý£¬È緢Ʊ¡¢¿ìµÝµ¥¾Ý¡¢½è¿î½è¾Ý¡¢µ÷²¦µ¥¡¢³ö/Èë¿âµ¥µÈµÈ£¬Ê¹±¾Èí¼þµÄÓ¦Ó÷¶Î§À©³äµ½ÆóÊÂÒµµ¥Î»¸÷¸ö²¿ÃÅ£»¸ß¾«×¼µÄ´òÓ¡¼¼ÊõÖ§³Å±ã½ÝµÄµ¥ÕÅ´òÓ¡»òÕßÅúÁ¿´òӡģʽ£¬´òÓ¡¾«×¼µ½0.1ºÁÃ×Îó²î·¶Î§ÄÚ£»ÖÇÄܵÄƱ¾ÝÄÚÈݼÈëģʽ£¬ÊäÈë°¢À²®Êý×Ö¿É×Ô¶¯×ª»»½ð¶î´óд£¬Òà»òÊäÈë¹Ø¼ü×Öºó¿É×Ô¶¯¼ìË÷¶¨Î»ËùÐèÐÅÏ¢£»Ç¿´óµÄÊý¾Ý´æ´¢¹¦ÄÜ¿ÉÂú×ãÓû§¸÷ÖÖ¸öÐÔ»¯µÄƱ¾Ý²éѯÐèÒª£¬Í¬Ê±¿ÉÂú×ãÓû§È«³Ì»¯¼à¹ÜƱ¾ÝÒµÎñµÄÍùÀ´ÐèÇó¡£»¹¿É½áºÏÕ×ÈÕµÈÆ·ÅÆÖ§¸¶ÃÜÂëÆ÷²úÆ·£¬ÀûÓÃÃÜÂëÆ÷µÄÁª»ú¹¦ÄÜÖ±½Ó½«Ö§¸¶ÃÜÂëµ÷ÈëÈí¼þ£¬¼òµ¥¡¢ÊµÐ§¡¢°²È«µØ´¦ÀíÄúµÄ¸÷Àà²ÆÎñƱ¾Ý¡£Í¬Ê±£¬Äú¿Éͨ¹ý±¾Èí¼þµÄËù¼û¼´ËùµÃµÄÌîдƱ¾ÝµÄ·½Ê½£¬Ò»Ä¿ÁËȻƱÃæÉÏÏÔʾµÄÖ§¸¶ÃÜÂëÏÒÔ¼°ËùÓÐƱ¾Ý´òÓ¡¹ýºóËù±£´æµÄÏêϸÐÅÏ¢¡£ÌṩÄúƱ¾Ý´òÓ¡¡¢Éè¼ÆºÍ¹ÜÀíµÄÒ»Ì×ÍêÕû½â¾ö·½°¸£¡
ΪÁËÄúÄܸüѸËÙµØÕÆÎÕ±¾Èí¼þµÄʹÓ÷½·¨£¬ÎÒÃǽ«Èí¼þµÄ³õʼ»¯°²×°¡¢ÅäÖá¢ÒÔ¼°×îÖ±¹ÛµÄ¹¦ÄÜÒÔͼÎIJ¢Ã¯µÄ·½Ê½Äâ±à³É±¾ÊֲᣬּÔÚΪÄúÌṩ¿ìËÙÓ¦Óñ¾Èí¼þµÄ°ïÖú£¬Äܹ»Ê¹ÄúһĿÁËÈ»µØ¿ìËÙÉÏÊÖ¡£
½¨ÒéÄúä¯ÀÀµÚ¶þ²¿·ÖµÄ¿ìËÙÈëÃÅƪÕ£¬×ñÑÿ¸öÕ½ڵÄÏêϸ½éÉÜÖð²½½øÐвÙ×÷¡£¸ü¶àÏêϸ¹¦Äܽ¨ÒéÄú²ÎÔÄÈí¼þÖеĵç×Ó°æ°ïÖúÎĵµ¡£
ÔٴθÐлÄúÑ¡ÔñºÍʹÓÃÎÒÃǵIJúÆ·£¡ÎÒÃǵķ¢Õ¹Àë²»¿ªÄúµÄÐèÇóºÍ½¨Ò飬ÔÚ½ñºóµÄ·¢Õ¹¹ý³ÌÖÐÎÒÃÇÈÔ»áÒÔÂú×ãÓû§ÐèÇóΪ¼ºÈΣ¬Å¬Á¦´òÔì×îÌù½üÓû§µÄ²úÆ·¡£
±±¾©ÓÃÓÑ»ª±íÈí¼þ¼¼ÊõÓÐÏÞ¹«Ë¾
2007Äê11ÔÂ
2
3
Ŀ¼
µÚÒ»²¿·Ö »¶ÓʹÓÃ................................................................................................................................................4 ²úÆ·¼ò½é ................................................................................................................................................................4 ·þÎñÖ§³Ö ................................................................................................................................................................6 µÚ¶þ²¿·Ö ¿ìËÙÈëÃÅ................................................................................................................................................8 µÚÒ»Õ 1.1
1.1.1 1.1.2
°²×°Èí¼þ ............................................................................................................................................8 Èí¼þÔËÐл·¾³ .......................................................................................................................................8
Èí¼þ»·¾³.......................................................................................................................................... 8 Ó²¼þ»·¾³.......................................................................................................................................... 9
1.2 1.3
°²×°SQL ServerÊý¾Ý¿â ....................................................................................................................9 °²×°Æ±¾ÝͨÈí¼þ.................................................................................................................................11
µÚÒ»ÖÖģʽ¡°µ¥»ú°æ°²×°¡± .......................................................................................................... 11 µÚ¶þÖÖģʽ¡°ÍøÂç°æ°²×°¡± .......................................................................................................... 14
1.3.1 1.3.2
1.4 1.5 1.6 1.7 2.1 2.2 2.3 2.4
°²×°Æ±¾Ýͨ¼ÓÃܹ· ............................................................................................................................20 Æô¶¯Æ±¾Ýͨ·þÎñ³ÌÐò........................................................................................................................20 Ê״εǼÈí¼þн¨ÕËÌ× ...................................................................................................................22 ¼ÓÃܹ·¼¤»î .........................................................................................................................................26 ÕËÌ×¹ÜÀí ..............................................................................................................................................29 ÕËÌײÎÊýÉèÖà .....................................................................................................................................30 ÐÂÔö¶à¸öÓû§¼°ÉèÖÃÆäȨÏÞ ..........................................................................................................32 »ù´¡Êý¾Ý ..............................................................................................................................................34
µÚ¶þÕ ³õʼ»¯ÅäÖà ..........................................................................................................................................29
µÚÈýÕ Èí¼þ¹¦ÄÜ¿ìËÙÈëÃÅ .............................................................................................................................36 3.1ÈçºÎµÇ¼ÇÈÕ¼ÇÕËн¨ÏÖ½ð/ÒøÐÐÈÕ¼ÇÕË.............................................................................................36
3.1.1 ½¨Á¢ÏÖ½ð/ÒøÐÐÕË»§............................................................................................................................. 36 3.1.2 Ìí¼ÓÈÕ¼ÇÕË.......................................................................................................................................... 38
3.2 ÈçºÎ¿ìËÙ´òÓ¡Ò»ÕÅ֧Ʊ .......................................................................................................................40 3.3 ÈçºÎ½«´òӡƱ¾Ý½á¹û×Ô¶¯µÇ¼ÇÈÕ¼ÇÕË.............................................................................................43 3.4 ÈçºÎ¹ÜÀí֧Ʊ .........................................................................................................................................48 µÚÈý²¿·Ö ³£¼ûÎÊÌâ..............................................................................................................................................52
ÎÊÌâÒ» ±¾Èí¼þÖ§³ÖµÄ´òÓ¡»úÀàÐÍÓÐÄÄЩ£¿ .........................................................................................52 ÎÊÌâ¶þ ±¾Èí¼þ¿ÉÒÔ´òÓ¡µÄƱ¾ÝÀàÐÍÓÐÄÄЩ£¿ .....................................................................................52 ÎÊÌâÈý Èç¹ûƱ¾ÝµÄ´òӡЧ¹ûÕûÌå·¢ÉúÆ«ÒÆÈçºÎµ÷Õû£¿ ...................................................................52 ÎÊÌâËÄ ÎªºÎÕýÏò½øÖ½´òӡ֧Ʊºó£¬Ð¡Ð´½ð¶î×îºóÁ½Î»´ò²»³öÀ´£¿ .............................................55 ÎÊÌâÎå ΪºÎµÇ¼Èí¼þʱ»áµ¯³ö´°¿Ú£¬Ìáʾ¡°Äú»¹¿ÉÒÔʹÓÃXXÌì??¡±£¿ .............................55
3
3
µÚÒ»²¿·Ö »¶ÓʹÓÃ
²úÆ·¼ò½é
ÓÃÓÑƱ¾Ýͨרҵ°æÔÚÆÕ¼°°æ»ù´¡ÉϷḻÁËƱ¾Ý´¦ÀíÒµÎñ£¬ÐÂÔö³öÄɹ¤×÷Ä£¿é£¬ÅäºÏȫеÄÈË»úÕ¹ÏÖ½çÃ棬ʹƱ¾ÝÊý¾ÝÔÚÕËÎñÄ£¿éÖÐͬ²½ÌåÏÖ¡£
ÔÚÕËÎñ´¦Àí²ãÃ棬Èí¼þÌṩ¶ÀÁ¢µÄÈÕ¼ÇÕ˹ÜÀí¹¦ÄÜ£¬Ö§³ÖÈÕ¼ÇÕ˶àÖÖ;¾¶µÄÌí¼Ó£»ÊµÏÖÔÂÄ©µÄÒøÐжÔÕË£»×Ô¶¯Éú³ÉÓà¶îµ÷½Ú±í£»ÌṩÔ¡¢ÖÜ¡¢¼¾µÈ²ÆÎñ±¨±íµÄ²éѯ¼°´òÓ¡£»Èç¹ûÅäºÏÓÃÓÑU8»òÓÃÓÑͨ²úƷʹÓ㬻¹¿ÉÏòÆäÖ±½ÓÉú³Éƾ֤£¬ÔÂĩʵÏÖƱ¾ÝͨÖеijöÄÉÕËÓëU8»òͨÖеÄ×ÜÕ˶ÔÕË¡£
ÔÚƱ¾Ý´¦Àí²ãÃ棬²»½ö°üÀ¨Æ±¾ÝͨÆÕ¼°°æµÄËùÓй¦ÄÜ£¬»¹ÌṩÁ˶àÀàƱ¾ÝµÄÃ÷ϸ²éѯ¼°»ã×ܲéѯ£»¶àÀàƱ¾ÝµÄÅúÁ¿´òÓ¡£¬ÊµÏÖÕý·´Ãæ½»²æ´òÓ¡£»¸ù¾ÝÓû§¼¶±ðÉèÖÿªÆ±»òÉóÅúȨÏÞ£¬ÔöǿƱ¾Ý¹ÜÀíµÄ°²È«ÐÔ£»Ôö¼ÓÖ§³Ö¸÷ÀàƱ¾ÝµÄÁ÷³Ì»¯¹ÜÀíÄ£¿é£¬ÀàËÆ֧Ʊ²¾ÐÎʽ£¬´ÓƱ¾ÝµÄÌí¼Ó¡¢ÁìÓõ½ºËÏú¸÷½×¶ÎÈ«³Ì¹ÜÀí¸÷ÀàƱ¾Ý£»Í¬Ê±£¬²»ÂÛƱ¾Ý´òÓ¡»¹ÊÇƱ¾ÝÁìÓþù¿ÉʵÏÖƱ¾ÝÊý¾ÝÒ»¼üµÇ¼Çµ½³öÄÉÈÕ¼ÇÕËÖУ¬±ÜÃâÓû§¶þ´Î¼ÈëµÄ¹¤×÷£¬±£Ö¤ÁËÊý¾ÝµÄ׼ȷÐÔ£¬Îª×ʽðÉϱ¨µÄ׼ȷÌṩÁ˱£Ö¤£¬ÎªÍ³¼Æ·ÖÎöÌṩÁËÓÐЧµÄ¹ÜÀíƽ̨¡£Ê¹²ÆÎñÈËÔ±³¹µ×ÍÑÀë·±Öع¤×÷Á¿£¬Íƶ¯²ÆÎñ¹ÜÀíÐÅÏ¢»¯¡£
¼¯³ÉƱ¾ÝͨÆÕ¼°°æËùÓй¦ÄÜÍ⣬»¹ÐÂÔöÁËÒÔÏ°˴ó¹¦ÄÜ£º ¹¦ÄÜÒ» ÍêÉƵÄÈÕ¼ÇÕ˱༹¦ÄÜ
Èí¼þÌṩ¶àÖÖÏÖ½ð¡¢ÒøÐÐÈÕ¼ÇÕ˱à¼Ä£Ê½£¬Ö§³ÖÍâ±Ò¡¢¼¯ÖÐÖ§¸¶¶þ¼¶¿ÆÄ¿¡£ÔÂÄ©ÈÕ¼ÇÕËÓëÒøÐжÔÕ˵¥ÊµÏÖ×Ô¶¯¶ÔÕË£¬²¢¾Ý´Ë×Ô¶¯Éú³ÉÓà¶îµ÷½Ú±í¡£Ö§³ÖÏòÓÃÓÑU8»òÓÃÓÑͨ²úÆ·Ö±½ÓÉú³É¼ÇÕËƾ֤¡£
¹¦Äܶþ ×Ô¶¯Éú³É¸÷ÖÖ×ʽ𱨱í
Èí¼þÌṩ×Ô¶¨Òå¸ñʽÈÕ¼ÇÕ˲¾µÄÔ¤ÀÀ¡¢´òÓ¡»òµ¼³ö¡£Éú³É×ʽðÈÕ±¨¡¢Öܱ¨¡¢Ô±¨ºÍ¼¾¶È±¨±í¡£
¹¦ÄÜÈý Ʊ¾Ý´òÓ¡¶à¼¶ÉóÅú¹ÜÀí
¸ù¾Ý²»Í¬Óû§È¨ÏÞ£¬É趨ÔÊÐí¿ªÆ±»òÉóÅúµÄÏ޶±£Ö¤Öð¼¶ÉóÅú¡¢°²È«¹ÜÀí¸÷ÀàƱ¾Ý¡£
¹¦ÄÜËÄ Æ±¾ÝÕËÎñÊý¾Ýͬ²½´¦Àí
Ʊ¾Ý´òÓ¡»òÁìÓûò±¨Ïúºó£¬Æ±¾Ý¼Ç¼¾ù¿É×Ô¶¯Ìí¼ÓÖÁÒøÐÐÈÕ¼ÇÕ˲¾ÖУ¬ÊµÏÖƱ¾ÝÊý¾ÝÓë³öÄÉÕËÎñͬ²½´¦Àí¡£
¹¦ÄÜÎå ¼¯³ÉͨÓÃƱ¾Ý¹ÜÀí¹¦ÄÜ
È«ÃæÖ§³Ö¸÷ÀàƱ¾ÝµÄÁ÷³Ì»¯¼à¹Ü£¬Ã¿ÕÅƱ¾Ý״̬ʵʱ±¸²é¡£
¹¦ÄÜÁù ¶àÖÖƱ¾ÝºÏ²¢²éѯ»ã×Ü
Èí¼þ³ýÖ§³Öµ¥ÕÅƱ¾ÝµÄ²éѯ£¬»¹Ö§³Ö¶àÖÖÀàÐÍƱ¾ÝµÄ»ã×ܲéѯ£¬²éѯ½á¹û¿ÉʵÏÖµ¼³ö»ò´òÓ¡¡£
¹¦ÄÜÆß Ö§³Ö²ÆÎñÈí¼þÊý¾Ý½»»¥
Èí¼þÖ§³ÖÏòÓÃÓÑU8»òÓÃÓÑͨ²úÆ·Ö±½ÓÉú³É¼ÇÕËƾ֤¡£ ʵÏÖÓëÓÃÓÑU8»òÓÃÓÑͨµÈ²úÆ·×ÜÕ˶ÔÕË¡£
¹²ÏíÓÃÓÑU8¡¢ÓÃÓÑͨ¡¢½ðµûKIS¡¢K3µÈϵÁвúÆ·»ù´¡Êý¾Ý¡£
¹¦ÄÜ°Ë ÍøÂ绯ӦÓÃÓëÊý¾Ý¹²Ïí
4