Õª Òª
Ëæ׿ÆËã»úÍøÂçµÄ·ÉËÙ·¢Õ¹£¬Internet¼¼ÊõÔ½À´Ô½¹ã·ºµÄÓ¦Ó㬽üÄêÀ´£¬Ëæ×ÅÎÒ¹úÐÅÏ¢²úÒµµÄ·ÉËÙ·¢Õ¹£¬¼ÆËã»úµÄ¿ª·¢Ó¦ÓÃÒÑÉø͸µ½¸÷¸öÁìÓò£¬¶øÇÒÈÕÇ÷ÆÕ¼°£¬ÏúÊÛ¹ÜÀíÊÇÆóÒµ¹ÜÀíµÄÒ»¸öÖØÒª¹ÜÀí»·½Ú£¬ËüµÄÌصãÊÇÐÅÏ¢Á¿´ó£¬ÒªÇóÐÅÏ¢·´À¡Ñ¸ËÙ£¬¶ÔÆóÒµ¾¼ÃЧÒæÄܹ»²úÉúÖ±½ÓµÄÓ°Ï졣ͬʱ£¬ËüÓëËüµÄÆäËû¹ÜÀí»·½ÚÈç¿â´æ¹ÜÀí£¬ÏúÊÛÕËÎñ¹ÜÀíµÈ¹Øϵʮ·ÖÃÜÇС£Ëæ×ÅÒµÎñÁ¿µÄ²»¶ÏÔö´ó£¬ÄÚ²¿ÈËÔ±µÄÔö¼Ó£¬¿¿ÒÔÍùµÄÊÖ¹¤¹ÜÀí·½Ê½½øÐйÜÀí£¬ÒѲ»ÄÜÊÊÓ¦ÆóÒµµÄ·¢Õ¹¡£Õâ¾ÍÆÈÇÐÐèÒªÒ»¸öÄܽôÃÜÅäºÏÆóÒµ½øÐÐÊý¾Ý¹ÜÀí£¬¾ö²ß·ÖÎöµÄÏȽø¹ÜÀí·½Ê½£®°ÑһЩ¿Æѧ¹ÜÀíµÄ¼¼Êõ¼°¹ÜÀí·½Ê½ÈÚÈ˵½µçÄÔÆóÒµÏúÊÛ¹ÜÀíÖУ¬²ÅÄÜÌá¸ß¹¤×÷ЧÂʺÍÆóÒµµÄ¹ÜÀíˮƽ£¬Ê¹ÆóÒµÄܹ»Ëæ×ÅÊг¡µÄ¶¯Ì¬±ä»¯¶øËæʱµ÷Õû×ÔÉíµÄÏúÊÛÒµÎñÁ÷³Ì£¬ÔÚ˲ϢÍò±äµÄÊг¡¾ºÕù½íÍÑÓ±¶ø³ö¡£ÐÅÏ¢»¯¹ÜÀíÎÞÒÉÊÇ×îÓÐЧµÄ¹ÜÀíÊÖ¶ÎÖ®Ò»¡£±¾Éè¼ÆÖ÷Òª¸ù¾Ýʵ¼ÊÐèÇ󣬻®·ÖÁËϵͳ»ù±¾ÐÅÏ¢¹ÜÀí¡¢ÉÌÆ·ÏúÊ۹ܡ¢²éѯµÈ¹ÜÀí£¬²¢Ê¹ÓÃC££ÓïÑÔºÍ SQL Server 2000Êý¾Ý¿â£¬²ÉÓÃB/SģʽʵÏÖÁË¿Í»§À´·Ã¡¢±¨¼Û¡¢¶©¹ºµÈ¶à¸ö»·½ÚÊý¾ÝµÄ¸ú×Ù¹ÜÀí·þÎñ£¬»ù±¾ÉÏÂú×ãÁ˵çÄÔÉÌÆ·ÏúÊÛ¹ÜÀíÁ÷³ÌµÄ¹¦ÄÜÐèÇó¡£ÏúÊÛ¹ÜÀíϵͳ²»µ«ÄÜʹ¸÷ÒµÎñ»·½Úе÷Ò»Ö£¬¶øÇÒ²Ù×÷¼òµ¥£¬ÕËÄ¿ÇåÎú¡£Í¨¹ýÕËÄ¿²éѯ£¬¹«Ë¾ÄÜÔÚ×î¶ÌµÄʱ¼äÄÚ»ñµÃÊг¡ÐÅÏ¢£¬´Ó¶øÖƶ©ÏàÓ¦µÄ¾ö²ß¡£
¹Ø¼ü´Ê£ºÏúÊÛ¹ÜÀí B/S¡¢Êý¾Ý¿â ASP.NET SQL
Abstract
With the rapid development of computer network, Internet is more and more widely, in recent years, along with our country of information industry is developing rapidly, the development and application of computer has penetrated into all fields, but also increasingly popular, sales management is an important aspect of management, it is characterized by a large amount of information, information feedback quickly, the economic efficiency of enterprises can produce direct effect. At the same time, it with its other management aspects such as inventory management, sales management, the relationship is very close. With the increasing volume of business, internal staff increase, rely on traditional management methods to manage, already can not adapt to the development of enterprises. It is an urgent need to work closely with the enterprise data management, decision making analysis of the advanced management methods. Some scientific management technology and management into the enterprise sales management, in order to improve the work efficiency and the management level of enterprises, so that enterprises can as the market changes and adjust their business processes vary from minute to minute, in market competition towel talent showing itself. Information management is the most effective management means one. This design mainly according to the actual demand, divide the system of basic information management, merchandise sales, query management, and the use of C language and SQL Server 2000 database, using B / S mode to realize customer visit, quotes, orders and other multiple link data tracking management service, basically meet the sales management process functional requirements. Sales management system not only helps the business with coordinated, and the operation is simple, accounts clear. The account inquiries, the company can in the shortest possible time access to market information, so as to work out correct decision.
Key words: sales management, database ASP.NET SQL B / S
Ŀ ¼
±¾ ¿Æ Éú ±Ï Òµ ÂÛ ÎÄ£¨Éè¼Æ£© II
ÌâÄ¿£º»ùÓÚWebµÄÏúÊÛ¹ÜÀíϵͳµÄÉè¼ÆÓëʵÏÖ II
Õª Òª V
Abstract VI
µÚÒ»Õ ¸ÅÊö 1
1£®1Ñо¿µÄ±³¾°¼°ÒâÒå 1
1£®2¹úÄÚÍâÑо¿ÏÖ×´ºÍ·¢Õ¹Ç÷ÊÆ 2
1£®3±¾ÏµÍ³²ÉÓõÄÉè¼Æ½á¹¹ 3
1£®4 ¿ª·¢¹¤¾ß¼°¼¼Êõ 5
µÚ¶þÕ ϵͳÐèÇó·ÖÎöÓë×ÜÌåÉè¼Æ 7
2£®1ϵͳÐèÇó·ÖÎö 7
2£®2¹¦ÄÜÐèÇó·ÖÎö 7
2£®3 ϵͳ¿ÉÐÐÐÔ·ÖÎö 8
2£®4 ϵͳ×ÜÌåÉè¼Æ 9
2.4.1 ASP.NET¿ª·¢Êý¾Ý¿â¼¼Êõ 9
2.4.2ϵͳ¹¦Äܽṹͼ 10
2.4.3Éè¼ÆÄ¿±ê 12
µÚÈýÕ Êý¾Ý¿âÉè¼Æ 14
3.1Êý¾Ý¿â½éÉÜ 14
3.1.1Êý¾Ý¿âϵͳµÄ²úÉú 14
3.1.2Êý¾Ý¿âϵͳµÄ¹¹³É 14
3.1.3Êý¾Ý¿âÉè¼ÆµÄÖ÷ÒªÄÚÈÝ 16
3.2ʵÌåÁªÏµÄ£ÐÍ 16
3.3 SQL Server 2000µÄ¹¦ÄÜÌصã 17
3.3 E-RʵÌåͼÉè¼Æ 18
3.4Êý¾Ý×Öµä 20
µÚËÄÕ ϵͳÏêϸÉè¼Æ 23
4£®1Óû§µÇ¼ģ¿éÉè¼Æ 23
4. 2ǰ̨ϵͳ¹¦ÄÜÄ£¿éÉè¼Æ 24
4.2.1Ê×Ò³½çÃæÉè¼Æ 24
4.2.2Ìí¼Ó¿Í»§ÐÅϢģ¿éÉè¼Æ 26
4.3.2Ìí¼ÓÏúÊÛÐÅϢģ¿éÉè¼Æ 27
µÚÎåÕ ϵͳ²âÊÔ 29
5.1 ²âÊÔµÄÈÎÎñ¼°Ä¿±ê 29
5.1.1²âÊÔµÄÈÎÎñ 29
5.1.2²âÊÔµÄÄ¿±ê 29
5.2²âÊÔ·½°¸ 29
5.2.1Ä£¿é²âÊÔ 29
5.2.2¼¯³É²âÊÔ 30
5.2.3ÑéÊÕ²âÊÔ 30
5.2.4ƽÐÐÔËÐÐ 30
µÚÁùÕ ϵͳʹÓÃά»¤ 31
6.1ϵͳʹÓÃ˵Ã÷ 31
6.2ϵͳµÄά»¤ 31
½á¡¡ÂÛ 33
Ö л 34
²Î¿¼ÎÄÏ× 35
µÚÒ»Õ ¸ÅÊö
1£®1Ñо¿µÄ±³¾°¼°ÒâÒå
Ëæ׿ÆËã»úÍøÂçµÄ·ÉËÙ·¢Õ¹£¬Internet¼¼ÊõÔ½À´Ô½¹ã·ºµÄÓ¦Ó㬽üÄêÀ´£¬Ëæ×ÅÎÒ¹úÐÅÏ¢²úÒµµÄ·ÉËÙ·¢Õ¹£¬¼ÆËã»úµÄ¿ª·¢Ó¦ÓÃÒÑÉø͸µ½¸÷¸öÁìÓò£¬¶øÇÒÈÕÇ÷ÆÕ¼°£¬ÏúÊÛ¹ÜÀíÊÇÆóÒµ¹ÜÀíµÄÒ»¸öÖØÒª¹ÜÀí»·½Ú£¬ËüµÄÌصãÊÇÐÅÏ¢Á¿´ó£¬ÒªÇóÐÅÏ¢·´À¡Ñ¸ËÙ£¬¶ÔÆóÒµ¾¼ÃЧÒæÄܹ»²úÉúÖ±½ÓµÄÓ°Ï졣ͬʱ£¬ËüÓëËüµÄÆäËû¹ÜÀí»·½ÚÈç¿â´æ¹ÜÀí£¬ÏúÊÛÕËÎñ¹ÜÀíµÈ¹Øϵʮ·ÖÃÜÇС£Ëæ×ÅÒµÎñÁ¿µÄ²»¶ÏÔö´ó£¬ÄÚ²¿ÈËÔ±µÄÔö¼Ó£¬¿¿ÒÔÍùµÄÊÖ¹¤¹ÜÀí·½Ê½½øÐйÜÀí£¬ÒѲ»ÄÜÊÊÓ¦ÆóÒµµÄ·¢Õ¹¡£Õâ¾ÍÆÈÇÐÐèÒªÒ»¸öÄܽôÃÜÅäºÏÆóÒµ½øÐÐÊý¾Ý¹ÜÀí£¬¾ö²ß·ÖÎöµÄÏȽø¹ÜÀí·½Ê½£®°ÑһЩ¿Æѧ¹ÜÀíµÄ¼¼Êõ¼°¹ÜÀí·½Ê½ÈÚÈ˵½µçÄÔÆóÒµÏúÊÛ¹ÜÀíÖУ¬²ÅÄÜÌá¸ß¹¤×÷ЧÂʺÍÆóÒµµÄ¹ÜÀíˮƽ£¬Ê¹ÆóÒµÄܹ»Ëæ×ÅÊг¡µÄ¶¯Ì¬±ä»¯¶øËæʱµ÷Õû×ÔÉíµÄÏúÊÛÒµÎñÁ÷³Ì£¬ÔÚ˲ϢÍò±äµÄÊг¡¾ºÕù½íÍÑÓ±¶ø³ö¡£ÐÅÏ¢»¯¹ÜÀíÎÞÒÉÊÇ×îÓÐЧµÄ¹ÜÀíÊÖ¶ÎÖ®Ò»¡£
µçÄÔÏúÊÛ¹ÜÀíϵͳÊǵäÐ͵ÄÐÅÏ¢¹ÜÀíϵͳ£¬ËüµÄ³öÏÖΪÍƽø¼Òµç¹«Ë¾¼°¸÷µçÄÔÏúÊÛÉ̳¡¹ÜÀíµÄ×Ô¶¯»¯¡¢ÎÞÖ½»¯¾ßÓлý¼«µÄÒâÒå¡£Èç¹ûÔÚ½»Ò×¹ý³ÌÖеÄËùÓл·½ÚʵÐеçÄÔ¹ÜÀí£¬±ã¿ÉÒÔ´ó´ó½µµÍÓÉÓÚÊÖ¹¤¹ÜÀí´øÀ´µÄÎÊÌâ¡£Ê×ÏÈ£¬¶ÔÓÚÎÒÃÇ¿ª·¢ÕßÀ´Ëµ£¬±¾¿ÎÌâÄܹ»¶ÍÁ¶ÎÒÃÇÔÚÃæ¶ÔÒ»¸ö¾ßÌåµÄÏîĿʱ£¬Óöµ½ÎÊÌ⣬·ÖÎöÎÊÌ⣬½â¾öÎÊÌâµÄÄÜÁ¦£»»ñµÃ¶ÀÁ¢²ß»®¡¢ÊµÊ©¿ÎÌ⣬²¢°´Õռȶ¨¼Æ»®½øÐпª·¢µÄ¾Ñ飬ÒÔ¼°²éÕÒÏà¹ØÎÄÏ×µÄÄÜÁ¦¡£Í¨¹ýС×鹲ͬµÄŬÁ¦Ê¹µÃ¶ÔÓÚ.NETÓïÑÔºÍÖÆ×÷ϵͳÓÐÒ»¸öÈ«ÃæµÄ¡¢Éî¿ÌµÄÈÏʶ¡£ÎªÒÔºóÑз¢¹¤×÷´òϼáʵµÄ»ù´¡£¬»ýÀÛ±¦¹óµÄ¾Ñé¡£
Æä´Î£¬¶ÔÓÚÆóÒµÀ´Ëµ¡£ÒªÔÚ¼¤ÁÒµÄÊг¡¾ºÕùÖÐÁ¢ÓÚ²»°ÜÖ®µØ£¬³ýÁ˼ÓÇ¿ÆóÒµ¹ÜÀí£¬½µµÍÉú²ú³É±¾Ö®Í⣬±ØÐë¼ÓÇ¿ÏúÊÛºÍÏúÊÛ¹ÜÀí¡£Òò´Ë£¬¿ª·¢ºÍÓ¦ÓÃÏúÊÛ¹ÜÀíϵͳ£¬¾ÍÏÔµÃÓÈΪÖØÒª£¬Ò»·½Ãæ¿ÉÒÔʵÏÖÏúÊÛ¹ý³ÌÖÐÐÅÏ¢¹ÜÀíµÄÏÖ´ú»¯£¬Ê¹¹ÜÀí²ã¿ÉÒÔ¼°Ê±¡¢×¼È·µØÕÆÎÕÏúÊÛ¹ý³ÌÖи÷¸ö»·½ÚµÄ¾ßÌåÇé¿ö£¬¸ú×ÙÊг¡ÐèÇó±ä»¯£¬Îª¹ÜÀí²ã½øÐоö²ßÌṩ¼°Ê±¡¢×¼È·µÄÐÅÏ¢ÒÀ¾Ý¡£ÁíÒ»·½Ãæ¸Ä±äÁË´«Í³ÊÖ¹¤²Ù×÷·½Ê½ËÙ¶ÈÂý¡¢ÊÖÐø¸´ÔÓ¡¢ºËËã·Ñʱ·ÑÁ¦ÈÝÒ×·¢Éú´íÎóµÄÏÖÏ󣬿ÉÒÔÓÐЧµØ¶Å¾ø¼Ùµ¥¡¢¼ÙƱ£¬´Ó¶ø±ÜÃâÓÉÓÚÐÅÏ¢µÄ²»×¼È·¡¢²»¼°Ê±¿ÉÄÜÔì³ÉµÄËðʧ¡£