Õª Òª
Ëæ×ÅÈËÃÇÉú»îˮƽµÄ²»¶ÏÌá¸ß£¬ÈËÃǶÔÆû³µµÄÏû·ÑºÍÐèÇóÒ²Ô½À´Ô½ÍúÊ¢¡£ºÜ¶àÆû³µÏúÊÛ¹«Ë¾ÈÔÈ»²ÉÓÃÈ˹¤¼ÇÕ˵Ĵ«Í³·½·¨£¬¼ÈÈÝÒ׳ö´íÓֻᵼÖÂÕËÄ¿»ìÂÒ£¬²éѯºÍͳ¼ÆÆðÀ´Ò²·Ç³£²»·½±ã£¬·ÑʱÓÖ·ÑÁ¦£¬ÑÏÖØʱ»á¸ø¹«Ë¾Ôì³ÉÄÑÒÔÍì»ØµÄËðʧ¡£ÈçºÎ×öºÃÏúÊÛ¹ÜÀí£¬Ê¹Õû¸ö¹«Ë¾Ð­µ÷Ò»Ö¡¢¸ßЧÂʵØÔËת£¬ÊǸ÷¹«Ë¾¼±´ý½â¾öµÄÎÊÌâ¡£
±¾Éè¼ÆÖ÷Òª¸ù¾Ýʵ¼ÊÐèÇ󣬻®·ÖÁËÊÛÇ°¹ÜÀí¡¢³µÁ¾¹ÜÀí¡¢¶©»õ¹ÜÀí¡¢²éѯ¹ÜÀí¡¢ÊÛºó¹ÜÀíºÍϵͳÉ趨Áù´óÄ£¿é£¬²¢Ê¹ÓÃC££ÓïÑÔºÍ SQL Server 2000Êý¾Ý¿â£¬²ÉÓÃB/SģʽʵÏÖÁË¿Í»§À´·Ã¡¢±¨¼Û¡¢¶©¹ºµÈ¶à¸ö»·½ÚÊý¾ÝµÄ¸ú×Ù¹ÜÀí·þÎñ£¬»ù±¾ÉÏÂú×ãÁËÆû³µÏúÊÛ¹ÜÀíÁ÷³ÌµÄ¹¦ÄÜÐèÇó¡£Æû³µÏúÊÛ¹ÜÀíϵͳ²»µ«ÄÜʹ¸÷ÒµÎñ»·½ÚЭµ÷Ò»Ö£¬¶øÇÒ²Ù×÷¼òµ¥£¬ÕËÄ¿ÇåÎú¡£Í¨¹ýÕËÄ¿²éѯ£¬¹«Ë¾ÄÜÔÚ×î¶ÌµÄʱ¼äÄÚ»ñµÃÊг¡ÐÅÏ¢£¬´Ó¶øÖƶ©ÏàÓ¦µÄ¾ö²ß¡£
¹Ø¼ü´Ê ÏúÊÛ¹ÜÀí£»B/Sģʽ£»Êý¾Ý¿â£»C#

Design and Development of the Automobile Sale Management System

Abstract
With the continuous improvement of people's living standard, people's consumption and demand for cars has become increasingly strong. A lot of auto sales businesses still use traditional methods of accounting manual, error-prone will not only lead to confusion in the accounts, inquiries and statistics are also very inconvenient for them, time-consuming and laborious, will cause serious irreversible damage. How to do a good job in sales management, so that the entire company coordinated, efficient operation is the company most pressing problem.
Primarily on the basis of the actual needs of the design division of the pre-sale management, vehicle management, order management, query management, after-sale management and system settings of six modules, and use the C # language and SQL Server 2000 database, the use of B / S mode visiting customers, pricing, ordering, and many other aspects of the tracking data management services to meet the basic needs of the automotive sales management processes, functional requirements. Car sales management system will enable not only the business aspects of a coherent and simple, clear accounts. Inquiries through the accounts, the company can in the shortest time possible access to market information, in order to formulate the corresponding decision-making.
Key words: Sale management; B/S model; Database; C#

Ŀ ¼
Ŀ¼
µÚÒ»ÕÂ Òý ÑÔ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  5
1.1 ϵͳ¿ª·¢±³¾°¼°ÒâÒå¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 5
1.2 ϵͳĿ±ê ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  6

µÚ¶þÕ ÐèÇó·ÖÎöºÍÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  6
2.1 ϵͳÐèÇó ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  6
2.2 ¹¦ÄÜÐèÇó ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 6
2.3 ÔËÐÐÐèÇó ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  7

µÚÈýÕ ϵͳ½â¾ö·½°¸ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 8
3.1 ϵͳµÄ½â¾ö·½°¸ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  8
3.2 B/S½á¹¹ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  8

µÚËÄÕ ϵͳ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  13
4.1 Óû§µÇ¼ģ¿éÉè¼Æ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  13
4.2 Ê×Ò³½çÃæÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 14
4.3 ÊÛÇ°¹ÜÀíÄ£¿éµÄ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 14
4.3.1 Ìí¼Ó¿Í»§ÐÅÏ¢ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  14
4.3.2 Ìí¼Ó³µÁ¾ÐÅÏ¢ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  15
4.4 ³µÁ¾¹ÜÀíÄ£¿éµÄ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  16
4.5 ¶©»õ¹ÜÀíÄ£¿éµÄ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  16
4.6 ²éѯͳ¼ÆÄ£¿éµÄ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  18
4.7 ÊÛºó¹ÜÀíÄ£¿éµÄ¾ßÌåʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  19

µÚÎåÕ ϵͳ²âÊÔ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 21
5.1 ϵͳ¹¦ÄÜÄ£¿é²âÊÔ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  21
5.1.1 ÊÛÇ°Ä£¿é¹¦ÄܲâÊÔ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  21
5.1.2 ³µÁ¾¹ÜÀíÄ£¿é²âÊÔ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  23
5.2 ϵͳÍêÉÆÓëÓÅ»¯ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  24

½á ÂÛ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 24

Ö л ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 25

²Î¿¼ÎÄÏ× ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  26

µÚÒ»ÕÂ Òý ÑÔ

Æû³µ¹¤Òµ¾­ÀúÁËÒ»°Ù¶àÄêµÄ·¢Õ¹£¬¶Ô¹ú¼Ò¾­¼ÃµÄ·¢Õ¹ºÍÌÚ·ÉÒÔ¼°ÈËÀàÉç»áµÄÎÄÃ÷´øÀ´Á˾޴óÓ°Ïì¡£Æû³µ¹¤ÒµÒѳÉΪÐí¶à¹ú¼ÒµÄÖ§Öù²úÒµ£¬Ëæ×ÅÈËÃÇÉú»îˮƽÒÔ¼°Æû³µÐÔÄܵIJ»¶ÏÌá¸ß£¬ÈËÃǶÔÆû³µµÄÏû·ÑºÍÐèÇóÒ²Ô½À´Ô½ÍúÊ¢£¬ÊÀ½çÆû³µ¹¤ÒµÒ²±£³ÖÅÓ´óµÄÊг¡ÐèÇóºÍÉú²ú¹æÄ£¡£½üÄêÀ´£¬ÖйúÆû³µÊг¡·¢Õ¹Ñ¸ÃÍ£¬ÒÔ½Ó½ü40£¥µÄËÙ¶ÈÔö³¤¡£¾Þ´óµÄÊг¡ÈÝÁ¿ºÍ¿É¹ÛµÄ¾­¼ÃЧÒ棬ÒýÆð¸÷Æû³µ³§¼Ò(°üÀ¨ÊÀ½ç¸÷ÖøÃûÆû³µ³§¼ÒµÄÔÚ»ªÆóÒµ)·×·×¼Ó´óͶ×Ê£¬Æû³µÊг¡·éÑÌËÄÆð£¬Æû³µÏúÊÛ²ßÂÔºÍģʽÐÂÕÐƵ³ö£¬¾ºÕùÒÑÊÇ¿ÕÇ°µÄ¼¤ÁÒ¡£ÔÚÈç´ËÐÎʽÏ£¬Ò»ÖÖ½éÓÚÉú²ú³§¼ÒºÍÓû§Ö®¼äµÄÇÅÁº£¬Æû³µÏúÊÛ¹«Ë¾ÕýÔÚ²»¶ÏµÄ²úÉúºÍ·¢Õ¹×³´ó¡£

1.1 ϵͳ¿ª·¢±³¾°¼°ÒâÒå
¸÷Æû³µÏúÊÛ¹«Ë¾ËüÃǶ¼ÓйÜÀí¡¢¼Æ»®¡¢ÏúÊÛ¡¢²ÆÎñ¡¢Åä¼þ¡¢ÊÛºó·þÎñµÈÖ°Äܲ¿ÃÅ¡£ÈçºÎ¹ÜÀíºÃÕâЩ²¿ÃÅ£¬Ê¹Õû¸ö¹«Ë¾Ð­µ÷Ò»Ö¡¢¸ßЧÂʵØÔËת£¬ÊǸ÷¹«Ë¾¼±´ý½â¾öµÄÎÊÌâ¡£µ«ÓеĹ«Ë¾ÈÔÈ»²ÉÓÃÈ˹¤¼ÇÕ˵Ĵ«Í³°ì·¨£¬¼ÈÈÝÒ׳ö´íÓֻᵼÖÂÕËÄ¿»ìÂÒ£¬²éѯºÍͳ¼ÆÆðÀ´·Ç³£²»·½±ã£¬·ÑʱÓÖ·ÑÁ¦£¬ÑÏÖØʱ»á¸ø¹«Ë¾Ôì³ÉÄÑÒÔÍì»ØµÄËðʧ¡£ÕâÖÖ¹«Ë¾¹ÜÀí·½·¨£¬ÒÑÔ¶¸ú²»ÉÏÏúÊÛÕþ²ßºÍÏúÊÛÐÎÊÆ·¢Õ¹µÄÐèÒª¡£Òò´Ë£¬ÈçºÎ¶ÔÆû³µÏúÊÛ¹ÜÀíÌṩһÕûÌ×µÄÐÅÏ¢»¯¹ÜÀíµÄ¹ÜÀí¸¨ÖúÊֶγÉΪ½¹µã¡£Æû³µÏúÊÛ¹ÜÀíϵͳµÄÌá³ö£¬¶ÔÆû³µÏúÊÛ¹«Ë¾À´½²ÒâÒåÖØ´ó¡£Ëü²»µ«ÄÜʹ¸÷ÒµÎñ»·½ÚЭµ÷Ò»Ö£¬¶øÇÒ²Ù×÷¼òµ¥£¬ÕËÄ¿ÇåÎú£¬Í¨¹ýÕËÄ¿²éѯ£¬¹«Ë¾ÄÜÔÚ×î¶ÌµÄʱ¼äÄÚ»ñµÃÊг¡ÐÅÏ¢£¬´Ó¶øÖƶ©ÏàÓ¦µÄ¾ö²ß¡£¡¢

1.2 ϵͳĿ±ê
±¾ÏµÍ³ÊÇÒÔÆû³µ»ù±¾ÐÅϢΪÖ÷Ì壬ÒÔÆû³µ¹©Ó¦É̺ÍÆû³µÐèÇóÉÌΪ·þÎñ¶ÔÏó£¬Í¨¹ý¶Ô¸÷ÖÖƱ¾ÝºÍÈÕÖ¾ÐÅÏ¢µÄ¹ÜÀí²Ù×÷ʵÏÖ´Ó¿Í»§À´·Ã¡¢×Éѯ¡¢±¨¼Û¡¢¶©¹º£¬µ½²É¹ºµÈ¶à¸öÏúÊÛ»·½ÚÉϵÄÑÏÃܵĸú×Ù¹ÜÀí·þÎñ¡£

˵Ã÷£º±¾Õ¾ËùÓгÌÐò¶¼±£Ö¤ÔËÐУ¬Ã¿¸öÌâÄ¿¶¼ÓжÔÓ¦µÄÊÓƵÑÝʾ¼Ïñ£¬½ØͼÎĵµµÈÄÚÈÝ¡£

ÈçÐèÒª¸ü¶à×ÊÁÏÇëÁªÏµ¿Í·þÈËQQ£º:1523433965