Õª Òª
Ëæ×ÅÐÅÏ¢Éç»áµÄ²»¶Ï½ø²½£¬¾¼ÃºÍ¿Æ¼¼¹¤×÷ÕߵķÉËÙ·¢Õ¹£¬ÍøÂçÒѳÉΪÐÂÊÀ¼ÍµÄÖ÷Ҫƽ̨¡£ÍøÕ¾µÄ½¨ÉèÈçÓêºó´ºËñ°ã¶øÀ´£¬ÍøÕ¾³ÉΪÍøÂçÉç»áÖд«µÝÐÅÏ¢µÄÖ÷Òª·½Ê½¡£¶ÔÓÚÒ»¸öÆóÒµÀ´Ëµ£¬ÆóÒµµÄ¹Ì¶¨×ʲúÊÇÆóÒµµÄÖ÷Òª×ʲúÖ®Ò»£¬Ëæ×ÅÆóÒµµÄ²»¶Ï·¢Õ¹£¬ÆóÒµµÄ¹Ì¶¨×ʲú½«²»¶ÏÔö¼Ó£¬ÆóÒµµÄ¹Ì¶¨×ʲúµÄ¹ÜÀí³ÉΪÆóÒµ¹ÜÀíÖÐÒ»¸öÖØÒªµÄ²¿·Ö¡£±¾ÏµÍ³Ö÷ÒªÊÇÕë¶Ôµ±Ç°ÆóÒµÖеĹ̶¨×ʲúÓÉÓÚ¹ÜÀí²»ÉƶøÔì³É×ʲúÁ÷ʧ»ò×ÊÔ´ÏÐÖÃÇé¿ö¶øÉè¼ÆµÄÒ»¸öÆóÒµµÄ¹Ì¶¨×ʲú¹ÜÀíϵͳ¡£±¾ÏµÍ³¾¹ýʵ¼ÊµÄÐèÇó·ÖÎö²ÉÓÃÁËB/SÌåϵ½á¹¹£¬Í¨¹ý¹¦ÄÜÇ¿´óµÄMicrosoft Visual Studio 2005×öΪ¿ª·¢¹¤¾ß¿ª·¢³öÀ´Ò»¿î»ùÓÚwebµÄÆóÒµµÄ¹Ì¶¨×ʲú¹ÜÀíϵͳ¡£Õû¸öϵͳ´Ó·ûºÏ²Ù×÷¼ò±ã¡¢½çÃæÓѺá¢Áé»î¡¢ÊµÓᢰ²È«µÄÒªÇó³ö·¢£¬Íê³É×ʲú¹ÜÀíµÄÈ«¹ý³Ì£¬°üÀ¨×ʲú»ù±¾ÐÅÏ¢¹ÜÀí¡¢×ʲúά»¤¹ÜÀí¡¢×ʲúµ÷²¦¹ÜÀí¡¢×ʲú±¨·Ï¡¢²éѯͳ¼Æ¹ÜÀí¡¢ÏµÍ³¹ÜÀí¼¸´ó¹¦ÄÜÄ£¿é¡£
±¾ÎÄͨ¹ý·ÖÎö£¬Ìá³öÁËÒ»ÖÖÀûÓÃASP.NET¼¼Êõ½øÐпª·¢ÏµÍ³µÄ·½°¸£¬ÒÔÆÚ´ïµ½¹¦ÄÜÇ¿´ó£¬·ÑÓõÍÁ®£¬Í¨ÓÃÐÔÇ¿£¬ÊʺÏÎÒ¹ú¹úÇéµÄÖÐСÆóÒµ¹Ì¶¨×ʲú¹ÜÀíϵͳ¡£±¾ÎÄÏêϸµÄ½éÉÜÁËϵͳÖÆ×÷µÄÕû¸ö¹ý³Ì¡£°´ÕÕÈí¼þ¹¤³ÌÉè¼Æ˼Ï룬²ÉÓÃÉúÃüÖÜÆÚ·¨½øÐÐÈ«³Ì¿ª·¢£¬°üÀ¨ÐèÇó·ÖÎö£¬ÏµÍ³×ÜÌåÉè¼Æ£¬ÏµÍ³ÏêϸÉè¼ÆµÈ¡£
¹Ø¼ü´Ê£º×ʲú£»B/S£»ÐÅÏ¢¹ÜÀí£»ASP.NET
Abstract
With the development of information society, economy and science and technology rapid development, the network has become the main platform for the new century. Website construction and website like bamboo shoots after a spring rain, become social network in the transmission of information is the main mode. For an enterprise, the enterprise fixed assets of enterprises is one of the main assets, with the continuous development of enterprises, enterprises fixed assets will continue to increase, the fixed assets of the enterprise management enterprise management has become an important part of. The system is mainly for the enterprises in fixed assets as a result of poor management caused by loss of assets or resources idle and design of an enterprise's fixed assets management system. In this system, after the actual needs analysis by using B / S system structure, through the powerful Microsoft Visual Studio 2005 as a development tool developed a web based on enterprise fixed assets management system. With the entire system from the simple, friendly interface, flexible, practical, safety requirements, the completion of the asset management of the entire process, including the asset basic information management, asset maintenance management, asset allocation, asset management, query statistics management, system management, several major functional modules.
This article through the analysis, put forward a kind to use ASP.NET technology development system, in order to achieve strong function, low cost, strong versatility, is suitable for the situation of our country small and medium-sized enterprise fixed assets management system. This paper introduces the system throughout the production process. According to the software engineering design ideas, using the method of life cycle for the whole development, including demand analysis, system design, system detailed design.
Keywords: assets; B / S; information management; ASP.NET
Ŀ ¼
Õª Òª I
Abstract II
1 Ð÷ÂÛ 1
1.1¿ÎÌâ±³¾° 1
1.2Ñо¿µÄÄ¿µÄ¼°ÒâÒå 1
2¿ª·¢¼¼Êõ¼°»·¾³ 2
2.1 ASP.NET¼ò½é 2
2.2 C#½éÉÜ 3
2.3 Visual Studio 2005 ¼°SQL Server¼ò½é 4
2.4¿ÎÌâ±³¾° 5
3¿ÉÐÐÐÔ·ÖÎö 5
3.1¼¼Êõ¿ÉÐÐÐÔ·ÖÎö 5
3.2 ¾¼Ã¿ÉÐÐÐÔ·ÖÎö 5
3.3 ²Ù×÷¿ÉÐÐÐÔ·ÖÎö 5
3.4 Éç»á¿ÉÐÐÐÔ·ÖÎö 6
4ÐèÇó·ÖÎö 6
4.1ϵͳ¹¦ÄÜÐèÇó 6
4.2Êý¾ÝÁ÷ͼ 7
4.3Êý¾Ý×Öµä 8
4.3.1Êý¾Ý´æ´¢ 10
4.3.2Êý¾ÝÁ÷ 11
4.3.3Êý¾Ý´¦Àí 11
5×ÜÌåÉè¼Æ 12
5.1ϵͳ×ÜÌåÉè¼Æ 12
5.2ϵͳģ¿éͼ 13
5.2.1ϵͳ×ÜÌå½á¹¹ 13
5.2.2ϵͳģ¿éÃèÊö 14
5.3Êý¾Ý¿âÉè¼Æ 15
5.3.1Êý¾Ý¿â½éÉÜ 15
5.3.2Êý¾Ý¿âÉè¼ÆµÄ²½Öè 17
5.3.3ϵͳE-Rͼ 18
5.3.3Êý¾Ý¿âÎïÀíÉè¼Æ 20
5.3.4°²È«±£ÃÜÉè¼Æ 22
6ÏêϸÉè¼ÆÓëϵͳʵÏÖ 23
6.1ÏêϸÉè¼ÆºÍϵͳʵÏÖ²½Öè 23
6.2¹¦ÄÜÄ£¿éµÄÉè¼ÆºÍʵÏÖ 23
6.2.1ϵͳµÇ¼ģ¿éÉè¼Æ 24
6.2.2¹ÜÀíÔ±¹ÜÀíÄ£¿éÉè¼Æ 25
6.2.3¼Èë×ʲúÄ£¿éÉè¼Æ 26
6.2.4 ά»¤×ʲú¼Ç¼ģ¿éÉè¼Æ 27
6.2.5×éÖ¯»ú¹¹¹ÜÀíÄ£¿éÉè¼Æ 28
6.2.6×ʲúÖÖÀà¹ÜÀíÄ£¿é 30
6.2.7ÈËÔ±¹ÜÀíÄ£¿éÉè¼Æ 30
6.2.8ÆÕͨÓû§²éѯģ¿éÉè¼Æ 31
6.2.9άÐÞͳ¼Æ²éѯģ¿éÉè¼Æ 33
6.2.10µ÷²¦Í³¼Æ²éѯģ¿éÉè¼Æ 33
7ϵͳ²âÊÔ 34
7.1²âÊÔµÄÈÎÎñ¼°Ä¿±ê 34
7.1.1²âÊÔµÄÈÎÎñ 34
7.1.2 ²âÊÔµÄÄ¿±ê 34
7.2²âÊÔ·½°¸ 34
7.2.1Ä£¿é²âÊÔ 34
7.2.2 ¼¯³É²âÊÔ 35
7.2.3 ÑéÊÕ²âÊÔ 35
7.2.4 ƽÐÐÔËÐÐ 35
8ϵͳʹÓÃά»¤ 36
7.1ϵͳʹÓÃ˵Ã÷ 36
8.2ϵͳµÄά»¤ 36
½á ÂÛ 38
ÖÂл 40
¸½Â¼ 41
1 Ð÷ÂÛ
1.1¿ÎÌâ±³¾°
ÏÖÔÚ£¬¿Æѧ¼¼ÊõµÄ·ÉËÙ·¢Õ¹°ÑÈËÀàÉç»áÍÆÏòÁËÒ»¸öոеÄʱ´ú¡ª¡ªÐÅϢʱ´ú¡£ÕâÒÑÊÇÎÞ¿ÉÕùÒéµÄÊÂʵ£»ÐÅÏ¢¶ÔÉç»á¾¼Ã·¢Õ¹µÄ¾Þ´óÍƶ¯×÷Óã¬Ê¹ÆäÓëÎïÖÊÄÜÔ´Ò»Æð²¢ÁÐΪÏÖ´úÉç»áµÄÈý´óÖ§Öù£¬ÕâÒÑÔÚÈ«Éç»á´ïµ½¹²Ê¶¡£Ëæ×ŶÔÐÅÏ¢×÷ΪһÖÖ×ÊÔ´À´¹ÜÀíµÄÐèÇóÈÕÒæ¼ÓÇ¿£¬ÐÅÏ¢Ñо¿ÁìÓò³öÏÖÁËÒ»ÖÖеĹÜÀí˼ÏëºÍģʽ¡ª¡ªÐÅÏ¢¹ÜÀí¡£Òò´Ë£¬¾Íµ®ÉúÁË¡°ÐÅÏ¢¹ÜÀí¡±ÕâÑùÒ»¸ö¸ÅÄî¡£ÓÉÓÚÐÅÏ¢ÊÇÆÕ±é´æÔڵģ¬ÈËÀàÐÅÏ¢¹ÜÀí»î¶¯µÄ·¶Î§Ò²ÊÇÊ®·Ö¹ã·ºµÄ£¬ÐÅÏ¢¹ÜÀí²»½öÊÇÐÅÏ¢¹¤×÷µÄÒ»²¿·Ö£¬¶øÇÒÒѱ»ÈÏΪÊÇÏÖ´ú¹ÜÀíµÄÖØÒª×é³É²¿·Ö¡£ÐÅÏ¢¹ÜÀíµÄ¸ÅÄîÔ´ÓÚÎ÷·½£¬Ò²ÊÇÔÚÊÀ½çÐÅÏ¢Á¿Ñ¸ËÙÔö³¤¡¢ÐÅÏ¢¼¼ÊõÈÕÐÂÔÂÒì¡¢ÐÅÏ¢²úҵǿ¾¢·¢Õ¹µÄÁùÆßÊ®Äê´ú³öÏֵġ£Ê±ÖÁ½ñÈÕ£¬ÐÅÏ¢¹ÜÀíÒѲ»½ö½öÊÇÒ»¸ö¸ÅÄ¶øÊÇÐÅϢѧºÍ¹ÜÀíѧÖеÄÖØÒªÄÚÈÝÁË¡£¶ÔÐÅÏ¢¹ÜÀíµÄÀí½â£¬Ò»ÖÖÈÏΪÊÇ£¬ÐÅÏ¢¹ÜÀí ¾ÍÊǶÔÐÅÏ¢µÄ¹ÜÀí¡£ÔÚ´Ë£¬ÐÅÏ¢¹ÜÀíÊÇÖ¸ÏÁÒåµÄÐÅÏ¢×ÊÔ´¹ÜÀí£¬Êµ¼ÊÉϾÍÊǶÔÐÅÏ¢±¾ÉíµÄ¹ÜÀí£»ÁíÒ»ÖÖÈÏΪ£¬ÐÅÏ¢¹ÜÀí²»½öÊǶÔÐÅÏ¢µÄ¹ÜÀí£¬¶øÊǶÔÉæ¼°ÐÅÏ¢»î¶¯µÄ¸÷ÖÖÒªËØ£¬ÈçÐÅÏ¢¡¢¼¼Êõ¡¢ÈËÔ±¡¢×éÖ¯½øÐкÏÀíµÄ×éÖ¯ºÍÓÐЧµÄ¿ØÖÆ£¬´Ó¶øÂú×ãÉç»áµÄÐÅÏ¢ÐèÇó¡£ÔÚ´Ë£¬ÐÅÏ¢¹ÜÀíÊÇÖ¸¹ãÒåµÄÐÅÏ¢×ÊÔ´¹ÜÀí¡£×ÛºÏÁ½ÖÖÀí½â£¬ÐÅÏ¢¹ÜÀíÊÇÖ¸¶ÔÈËÀàÐÅÏ¢»î¶¯Ëù²úÉúµÄÉç»áÐÅÏ¢½øÐйÜÀí£¬ÐÅÏ¢¹ÜÀíÊǹÜÀíµÄÒ»ÖÖ£¬¼ÈÒª¶ÔÐÅÏ¢½øÐйÜÀí£¬Ò²Òª¶ÔÐÅÏ¢»î¶¯½øÐйÜÀí¡£ÐÅÏ¢ºÍÐÅÏ¢»î¶¯¶¼ÊÇÐÅÏ¢¹ÜÀíµÄ¿ÍÌå¡£¼ò¶øÑÔÖ®£¬ÐÅÏ¢¹ÜÀí¾ÍÊǶÔÐÅÏ¢ºÍÐÅÏ¢»î¶¯µÄ¹ÜÀí£¬Õâ¾ÍÊÇÎÒÃǶÔÐÅÏ¢¹ÜÀíµÄÈ«ÃæÀí½â¡£
ÊÀ½ç¾¼Ã·¢Õ¹ÒѽøÈëÒ»¸ö¼¤ÁÒ¾ºÕùµÄÄê´ú£¬¿ÉÒÔ˵£¬ËÏÈ»ñµÃÐÅÏ¢£¬Ë¾ÍÓпÉÄÜץס·¢Õ¹¾¼ÃµÄ»úÓö¡£Í¬Ñù£¬ËÄܺܺõعÜÀíºÍÀûÓúÃÐÅÏ¢£¬Ë¾ÍÓпÉÄÜÕ¼ÁìÊг¡£¬»ñµÃЧÒæ¡£¹úÄÚÍâ´óÁ¿ÊÂʵÒÑ˵Ã÷£ºÔÚÄ¿Ç°Õâ¸ö¼¤ÁÒ¾ºÕùµÄÊг¡¾¼ÃÖУ¬ËµÄÐÅÏ¢¹ÜÀíÏÖ´ú»¯Ë®Æ½¸ß£¬ËÖØÊÓÐÅÏ¢×ÊÔ´µÄ¿ª·¢ºÍÀûÓã¬Ë¾ÍÄÜץס»úÓö£¬ÔÚ¾ºÕùÖÐȡʤ¡£