»ùÓÚס·¿¹«»ý½ð¹ÜÀíÖÐÐĵÄÑо¿_ÐÅÏ¢¹ÜÀíÂÛÎÄ·¶ÎÄ
·¢²¼Ê±¼ä£º
2015-03-15
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
ÐÅÏ¢¹ÜÀíÂÛÎÄ·¶ÎÄ
Ŀ ¼
µÚÒ»ÕÂÒý ÑÔ1
µÚÒ»½ÚÑ¡ÌâÒâÒå1
µÚ¶þ½Ú¿ª·¢¹¤¾ßºÍÊý¾Ý¿â·ÃÎʼ¼ÊõµÄÑ¡Ôñ2
µÚ¶þÕÂס·¿¹«»ý½ð¹ÜÀíÖÐÐÄOAϵͳÐèÇó·ÖÎö3
µÚÒ»½ÚϵͳÉè¼Æ·½°¸·ÖÎö3
Ò»¡¢×ÜÌåÉè¼ÆÄ¿±ê3
¶þ¡¢·½°¸Éè¼ÆÔÔò3
Èý¡¢ÏµÍ³¹¦ÄÜÐèÇó4
ËÄ¡¢ÏµÍ³¼¼ÊõÒªÇó4
Î塢ϵͳ°²È«ÒªÇó4
Áù¡¢ÏµÍ³ÍøÂçÍØÆË5
µÚ¶þ½Úϵͳ¹¹½¨·½°¸5
µÚÈý½Úϵͳʵʩ¼Æ»®6
µÚÈýÕÂס·¿¹«»ý½ð¹ÜÀíÖÐÐÄOAϵͳÉè¼Æ˼Ïë7
µÚÒ»½Úϵͳ×ÜÌåÉè¼Æ·½°¸7
Ò»¡¢ÏµÍ³½¨ÉèÄ¿±ê7
¶þ¡¢ÏµÍ³Éè¼ÆÔÔò7
µÚ¶þ½Úϵͳ¹¦ÄÜÉè¼Æ·½°¸8
Ò»¡¢ÏµÍ³Æ½Ì¨¿ª·¢Ñ¡Ôñ8
¶þ¡¢ÏµÍ³¹¦ÄÜ»®·Ö9
µÚÈý½Ú¹¦ÄÜʵÏÖ¼¼ÊõÖØҪģ¿é10
µÚËĽÚϵͳ°²È«Éè¼Æ·½°¸10
µÚÎå½ÚÍøվϵͳ¹¹½¨·½°¸11
µÚÁù½ÚÐÅÏ¢´¦Ö°Ô±µÄÐèÒª¼ÓÇ¿µÄ¼¼ÄÜ£¨Ñ§Ï°¡¢Åàѵ£©11
µÚËÄÕÂס·¿¹«»ý½ð¹ÜÀíÖÐÐÄOAϵͳ¹¦ÄÜ·ÖÎöÓëʵÏÖ12
µÚÒ»½ÚϵͳÔËÐмܹ¹¼°Ó¦Ó÷½°¸12
µÚ¶þ½Úϵͳ¸ÅÒªÉè¼Æ13
Ò»¡¢ÏµÍ³½á¹¹Éè¼Æ13
¶þ¡¢Êý¾Ý¿âÉè¼Æ14
µÚÈý½ÚϵͳÏêϸÉè¼Æ17
µÚËĽڼ¼ÊõʵÏÖ18
µÚÎå½ÚϵͳÓû§Ó¦ÓÃÄ£¿é20
Ò»¡¢Óû§¸öÈËÐÅÏ¢²éѯģ¿éµÄʵÏÖ21
¶þ¡¢Óû§´û¿î¶î¶ÈÊÔËãÄ£¿éµÄʵÏÖ23
Èý¡¢Óû§ÃÜÂëÈ¡»ØÄ£¿éµÄʵÏÖ30
µÚÎåÕ½á ÂÛ33
¡¾²Î¿¼ÎÄÏס¿34
Ö л35
SQL+ASPµÄOAϵͳʵÏÖ£º»ùÓÚס·¿¹«»ý½ð¹ÜÀíÖÐÐĵÄÑо¿
ÕªÒª
°ì¹«×Ô¶¯»¯ÊÇÖ¸ÔÚÆóÊÂÒµµ¥Î»ÖУ¬²ÉÓÃInternet/Intranet¼¼Êõ£¬»ùÓÚ¹¤×÷Á÷µÄ¸ÅÄÒÔ¼ÆËã»úΪÖÐÐÄ£¬²ÉÓÃһϵÁÐÏÖ´ú»¯µÄ°ì¹«É豸ºÍÏȽøµÄͨÐż¼Êõ£¬¹ã·º¡¢È«Ã桢ѸËÙµØÊÕ¼¯¡¢ÕûÀí¡¢¼Ó¹¤¡¢´æ´¢ºÍʹÓÃÐÅÏ¢£¬Ê¹ÆóÒµÄÚÍⲿÈËÔ±·½±ã¿ì½ÝµØ¹²ÏíÐÅÏ¢£¬¸ßЧµØÐͬ¹¤×÷£»°ì¹«×Ô¶¯»¯¸Ä±äÁ˹ýÈ¥¸´ÔÓ¡¢µÍЧµÄÊÖ¹¤°ì¹«·½Ê½£¬Îª¿Æѧ¹ÜÀíºÍ¾ö²ß·þÎñÌṩÁ˼¼ÊõÖ§³Ö£¬´Ó¶ø´ïµ½Ìá¸ßÐÐÕþ¹ÜÀí¼°·þÎñЧÂʵÄÄ¿µÄ¡£
±¾ÎÄÑ¡ÔñÁ˶ÔËùʵϰµ¥Î»µÄOAϵͳµÄ½¨ÉèËù²ÉÓõļ¼Êõ·½°¸½øÐÐÑо¿£¬ÏµÍ³²ÉÓÃSQL Server Êý¾Ý¿â£¬²¢Ê¹ÓÃMacromedia Dreamweaver MX 2004 £¨¼ò³ÆDW MX 2004£©½áºÏASPÀ´¶ÔWebÕ¾µã¡¢WebÒ³ºÍ WebÓ¦ÓóÌÐò½øÐÐÉè¼Æ¡¢±àÂëºÍ¿ª·¢¡£ÂÛÎÄÖ÷Òª½éÉÜÁ˱¾¿ÎÌâµÄ¿ª·¢±³¾°£¬·ÖÎöÁËËùÒªÍê³ÉµÄ¹¦ÄܺͿª·¢µÄ¹ý³Ì¡£
±¾ÎÄÊ×ÏȲûÃ÷ÁËÑ¡¿ÎÌâµÄÒâÒå¼°¿ª·¢¹¤¾ßµÄÑ¡Ôñ¡£È»ºó¶Ô¹«»ý½ð¹ÜÀíÖÐÐÄOAϵͳ½øÐÐÁËÐèÇó·ÖÎö£¬ÎªÉè¼ÆºÍÀí½âÓ¦ÓóÌÐò×öÁËÆ̵档µÚÈýÕ¶Թ«»ý½ð¹ÜÀíÖÐÐÄOAϵͳµÄÖ÷ÒªÉè¼Æ˼Ïë½øÐÐÁË̽ÌÖ¡£Ö®ºóÊǸÅÒªÉè¼ÆºÍÏêϸÉè¼Æ£¬²¢¸ù¾ÝÇ°¼¸ÕÂÐèÇó·ÖÎöºÍÉè¼Æ˼ÏëµÄ·ÖÎö½á¹ûÀûÓÃSQL ServerºÍASP½øÐÐÁ˾ßÌåµÄÄ£¿éºÍ¹¦ÄÜÉè¼Æ¡£×îºó£¬×ܽáÁËÉè¼ÆÌå»áºÍ±à³ÌÌå»á£¬²¢Ö¸³öÁËϵͳÉè¼ÆÖеIJ»×ãºÍ¸Ä½øµÄ·½Ïò¡£
¹Ø¼ü´Ê£º
Êý¾Ý¿â£¬SQLÓïÑÔ£¬ASP£¬SQL Server£¬°ì¹«×Ô¶¯»¯£¨OA£©
ABSTRACT
The office automation is refers in the enterprises and institutions, uses the Internet/Intranet technology, is the concept based on the work flows, take the computer as the center, uses a series of modernized the office equipment and the advanced communication, widespread, comprehensive, collects, the reorganization, the processing, the memory and the use information rapidly, causes the enterprise internal and external personnel to facilitate shares the information quickly, highly effective joint operation; The office automation changed the past complex, the low efficiency manual work way, serves for the scientific management and the decision-making, as achieved the goal of enhances the administrative efficiency.
The Microsoft office SQL Server was used as the database. And the Dreamweaver MX 2004 combine with ASP was used for design, editing code and developing Web sites, Web pages and Web applications. In this paper, we mainly discuss the developing background of this topic, what the functions needed to be finished and the procedure of development.
This paper first introduced this system topic origin and the choice of the database development kit. Then the introduced the demand analysis of the common reserve fund administrative center OA system, has made the upholstery for the design and the understanding application procedure. Third chapter introduced the main design concept of the common reserve fund administrative center OA system. Finally is the main part of this article, according to the OA system demand, first introduced in detail the system develops the platform choice the reason, finally arrives the detailed design after the outline design, completes for the overall system design. And has carried on the concrete module and the functional design using SQL Server and ASP acted according to the first several chapters of demand analysis and the design concept analysis result. The summary part introduced the design realized and programs the experience, and pointed out the insufficiency and the improvement direction in the system design.
KEYWORDS£º
DB, SQL Language, ASP, SQL Server, Office Automation(OA)