Õª Òª
Ëæ׿ÆËã»úÍøÂçµÄ·ÉËÙ·¢Õ¹£¬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
ÌâÄ¿£º»ùÓÚ.NETµÄ·¿ÎÝÏúÊÛϵͳ II
Õª Òª V
Abstract VI
µÚÒ»Õ ¸ÅÊö 1
1£®1¿ÎÌâµÄÑо¿±³¾° 1
1£®2 ¿ÎÌâµÄÑо¿Ä¿µÄ¼°ÒâÒå 2
1£®3·¢Õ¹ÏÖ×´ÓëÇ÷ÊÆ 3
1£®4ϵͳÉè¼Æ˼Ïë 3
1£®5±¾ÏµÍ³²ÉÓõÄÉè¼Æ½á¹¹ 4
1£®6 ¿ª·¢¹¤¾ß¼°¼¼Êõ 6
µÚ¶þÕ ϵͳÐèÇó·ÖÎöÓë×ÜÌåÉè¼Æ 8
2£®1ϵͳÐèÇó·ÖÎö 8
2£®2¹¦ÄÜÐèÇó·ÖÎö 8
2£®3 ϵͳ¿ÉÐÐÐÔ·ÖÎö 9
2£®4 ϵͳ×ÜÌåÉè¼Æ 10
2.4.1 ASP.NET¿ª·¢Êý¾Ý¿â¼¼Êõ 10
2.4.2ϵͳ¹¦Äܽṹͼ 11
2.4.3Éè¼ÆÄ¿±ê 13
µÚÈýÕ Êý¾Ý¿âÉè¼Æ 15
3.1Êý¾Ý¿â½éÉÜ 15
3.1.1Êý¾Ý¿âϵͳµÄ²úÉú 15
3.1.2Êý¾Ý¿âϵͳµÄ¹¹³É 15
3.1.3Êý¾Ý¿âÉè¼ÆµÄÖ÷ÒªÄÚÈÝ 17
3.2ʵÌåÁªÏµÄ£ÐÍ 17
3.3 SQL Server 2000µÄ¹¦ÄÜÌصã 18
3.3 E-RʵÌåͼÉè¼Æ 19
3.4Êý¾Ý×Öµä 21
µÚËÄÕ ϵͳÏêϸÉè¼Æ 24
4£®1Óû§µÇ¼ģ¿éÉè¼Æ 24
4. 2ǰ̨ϵͳ¹¦ÄÜÄ£¿éÉè¼Æ 25
4.2.1Ê×Ò³½çÃæÉè¼Æ 25
4.2.2Ìí¼Ó¿ª·¢ÉÌÐÅϢģ¿éÉè¼Æ 27
4.3.2Ìí¼ÓÏúÊÛ·¿ÎÝÄ£¿éÉè¼Æ 28
µÚÎåÕ ϵͳ²âÊÔ 30
5.1 ²âÊÔµÄÈÎÎñ¼°Ä¿±ê 30
5.1.1²âÊÔµÄÈÎÎñ 30
5.1.2²âÊÔµÄÄ¿±ê 30
5.2²âÊÔ·½°¸ 30
5.2.1Ä£¿é²âÊÔ 30
5.2.2¼¯³É²âÊÔ 31
5.2.3ÑéÊÕ²âÊÔ 31
5.2.4ƽÐÐÔËÐÐ 31
µÚÁùÕ ϵͳʹÓÃά»¤ 32
6.1ϵͳʹÓÃ˵Ã÷ 32
6.2ϵͳµÄά»¤ 32
½á¡¡ÂÛ 34
Ö л 35
²Î¿¼ÎÄÏ× 36
µÚÒ»Õ ¸ÅÊö
1£®1¿ÎÌâµÄÑо¿±³¾°
Ëæ×Å·¿µØ²úÒµµÄ²»¶Ï·¢Õ¹£¬·¿ÎÝ¿ª·¢É̸üÉîÇеظÐÊܵ½Á˼ÆËã»ú¼¼ÊõÔÚ·¿µØ²úÒµÖеÄ×÷ÓÃÔ½À´Ô½ÖØÒª£¬Ô½À´Ô½ÒªÇóÏúÊÛÈËÔ±ÐèÒª¾ßÓÐÒ»¶¨¼ÆËã»úµÄÓ¦Óü¼ÄÜ¡£ÕÆÎÕ¼ÆËã»úÊÇÖ°ÒµµÄÐèÒª£¬¸üÊDzúÒµ·¢Õ¹µÄÐèÒª£¬¸üÊÇΪÁË´´Ôì¸ü¸ßµÄ¾¼ÃÀûÈóµÄÐèÒª¡£ÐÅÏ¢ÔÚÉç»áºÍ¾¼ÃµÄ·¢Õ¹ÖÐËùÆðµÄ×÷ÓÃÔ½À´Ô½ÎªÈËÃÇËùÖØÊÓ¡£ÐÅÏ¢×ÊÔ´µÄ¿ª·¢ÀûÓÃˮƽÒѳÉΪºâÁ¿Ò»¸ö·¿ÎÝ¿ª·¢ÉÌÄÇÖÁÒ»¸ö¹ú¼Ò×ۺϾºÕùʵÁ¦µÄÖØÒª±êÖ¾Ö®Ò»¡£ÔÚ¼ÆËã»úµÄÈý´óÖ÷ÒªÓ¦ÓÃÁìÓò(¿Æѧ¼ÆËã¡¢Êý¾Ý´¦ÀíÓë¹ý³Ì¿ØÖÆ)ÖУ¬Êý¾Ý´¦ÀíµÄ±ÈÖØÔ¼Õ¼70%×óÓÒ¡£¼ÆËã»ú×÷ΪÐÅÏ¢´¦ÀíµÄ¹¤¾ß£¬ÎªÊÊÓ¦Êý¾Ý´¦ÀíÐèÇóµÄѸËÙÌá¸ß£¬Âú×ã¸÷ÀàÐÅϢϵͳ¶ÔÊý¾Ý¹ÜÀíµÄÒªÇó£¬ÔÚÎļþϵͳµÄ»ù´¡ÉÏ·¢Õ¹ÆðÁËÊý¾Ý¿âϵͳ¡£
Êý¾Ý¿â¼¼Êõ²úÉúÓÚ60Äê´úÄ©£¬70Äê´ú³õÆÚ£¬ÆäÖ÷ҪĿµÄÊÇÓÐЧµØ¹ÜÀíºÍ´æÈ¡´óÁ¿µÄÊý¾Ý×ÊÔ´¡£Êý¾Ý¿â¼¼ÊõÖ÷ÒªÑо¿ÈçºÎ´æ´¢¡¢Ê¹Óú͹ÜÀíÊý¾Ý£¬ÊǼÆËã»úÊý¾Ý¹ÜÀí¼¼Êõ·¢Õ¹µÄ×îн׶Ρ£Êý¾Ý¿â´æ´¢µÄÊÇͨÓû¯µÄÏà¹ØÊý¾Ý¼¯ºÏ£¬Ëü²»½ö°üÀ¨Êý¾Ý±¾Éí£¬¶øÇÒ°üÀ¨Êý¾ÝÖ®¼äµÄÁªÏµ¡£30¶àÄêÀ´£¬Êý¾Ý¿âÔÚÀíÂÛÉÏ¡¢ÊµÏÖ¼¼ÊõÉϾùµÃµ½ºÜ´óµÄ·¢Õ¹£¬ÑÐÖƳöÐí¶àÉÌÓÃÊý¾Ý¿â¹ÜÀíϵͳ£¬Ê¹µÃ¼ÆËã»úÓ¦ÓÃÉø͸µ½¸÷Ðи÷ÒµµÄ¸÷Àà¹ÜÀí¹¤×÷ÖС£ÏÖÔÚ£¬Êý¾Ý¿â¼¼ÊõÒѳÉΪ¼ÆËã»úÁìÓòÀï×îÖØÒªµÄ¼¼ÊõÖ®Ò»£¬ÊÇÈí¼þѧ¿ÆµÄÒ»¸ö¶ÀÁ¢·ÖÖ§¡£½üÄêÀ´£¬Êý¾Ý¿â¼¼ÊõºÍ¼ÆËã»úÍøÂç¼¼ÊõµÄ·¢Õ¹Ï໥Éø͸¡¢Ï໥´Ù½ø£¬ÒѳÉΪµ±½ñ¼ÆËã»úÁìÓòÄÚ·¢Õ¹Ñ¸ËÙ¡¢Ó¦Óù㷺µÄÁ½´óÁìÓò¡£Êý¾Ý¿âϵͳÊÇÊý¾Ý´¦ÀíµÄºËÐÄ»ú¹¹£¬ÊÛÂ¥¹ÜÀíϵͳ¡¢°ì¹«×Ô¶¯»¯ÏµÍ³¡¢¾ö²ßÖ§³ÖϵͳµÈ¶¼ÊÇʹÓÃÁËÊý¾Ý¿â¹ÜÀíϵͳ»òÊý¾Ý¿â¼¼ÊõµÄ¼ÆËã»úÓ¦ÓÃϵͳ¡£
Êý¾Ý¿â·½·¨Ô±¾ÊÇÕë¶ÔÊÂÎñ´¦ÀíÉê´óÁ¿Êý¾Ý¹ÜÀíÐèÇóµÄ£¬µ«ÊÇËüµÄÓ¦Ó÷¶Î§²»¶ÏÀ©´ó£¬²»½öÓ¦ÓÃÓÚÊÂÎñ´¦Àí£¬²¢ÇÒ½øÒ»²½Ó¦Óõ½Ç鱨¼ìË÷¡¢È˹¤ÖÇÄÜ¡¢×¨¼Òϵͳ¡¢¼ÆËã»ú¸¨ÖúÉè¼ÆµÈ£¬Éæ¼°µ½·ÇÊýÖµ¼ÆËã¸÷·½ÃæµÄÓ¦Óá£Ó¦Ó÷¶Î§µÄÀ©´óÓÖ½øÒ»²½´Ù½øÁËÊý¾Ý¿â¼¼ÊõµÄÉîÈë·¢Õ¹£¬¿ÉÒÔ˵Êý¾Ý¿âϵͳÒѳÉΪ¼ÆËã»úÓ¦ÓÃϵͳµÄÖØÒª×é³É²¿·ÖÖ®Ò»¡£