|
OA°ì¹«×Ô¶¯»¯ÏµÍ³Éè¼Æasp.net1044(±ÏÒµÉè¼Æ+ÂÛÎÄ) |
×÷Õߣº admin
ÏÂÔØËùÐèÔƱңº150 ö ä¯ÀÀ£º1386 ´Î ÏÂÔØ£º0 ´Î Êղأº1 ´Î ¸üÐÂÈÕÆÚ£º2016-11-12 |
»ùÓÚ.NETƽ̨µÄOA°ì¹«×Ô¶¯»¯ÏµÍ³Éè¼ÆÓëʵÏÖ ÕªÒª OA(Office Automation)°ì¹«×Ô¶¯»¯ÏµÍ³ÊÇÀûÓüÆËã»ú¼¼ÊõʵÏÖÓÐÖ½»¯°ì¹«ÏòÎÞÖ½»¯°ì¹«µÄת±ä£¬È˹¤Ïò×Ô¶¯»¯µÄת±ä¡£±¾ÏµÍ³ÃüÃûΪOffice Easy Now,ÒâΪ¼´¿ÌÆð°ì¹«¸ü¼Ó¼òµ¥£¬Ê¹ÓÃÕß¿ÉÒÔ³ä·Ö·¢»ÓÍøÂçµÄ±ã½ÝÐÔ£¬Ìá¸ß¹¤×÷ЧÂÊ£¡ ±¾´Î±ÏÒµÉè¼ÆÔÚWindows XP Professional»·¾³Ï²ÉÓÃVisual Studio 2005 +SQL Sever 2005¿ª·¢¡£±¾ÏµÍ³²ÉÓÃB/S£¨Browser/Server£©¹¹¼Ü£¬ÀûÓÃÍøÂ罫·þÎñÆ÷¶ËÓë¿Í»§¶ËÔÚÎïÀíÉÏ·Ö¿ª£¬²¢½«Êý¾Ý¿âÖÃÓÚ·þÎñÆ÷ÉÏ£¬Ê¹Êý¾ÝÂß¼ÉÏ·Ö¿ª£¬²»½ö·½±ãϵͳά»¤£¬ÇÒÊý¾Ý¸ü¾ßÓа²È«ÐÔ¡£Õû¸öϵͳĿǰÒѾʵÏÖµÄÄ£¿éÓУº»ú¹¹¹ÜÀí¡¢²¿ÃŹÜÀí¡¢Îļþ¹ñ³÷¡¢Èճ̹ÜÀí¡¢±ã¼ã¹ÜÀí¡¢ÏûÏ¢¹ÜÀí¡¢½ÇÉ«¹ÜÀí¡¢²Ëµ¥¹ÜÀí¡¢Óû§¹ÜÀí¡¢ÈÕÖ¾¹ÜÀíµÈÄ£¿é£¬ÁíÍⱾϵͳÔÚÉè¼Æʱ³ä·Ö¿¼ÂÇÁËÀ©Õ¹ÐÔ£¬¿ÉËæʱÌí¼ÓеÄÄ£¿é¡£ ϵͳÔÚÉè¼ÆÓëʵÏÖÉϲÉÓÃÁËÈý²ã¹¹¼Ü£¬Í¨¹ý½«ÏµÍ³¹¹¼Ü·ÖΪ±íÏֲ㣨UI£©¡¢ÒµÎñÂß¼²ã£¨BLL£©¡¢Êý¾Ý·ÃÎʲ㣨DAL£©£¬Ê¹µÃϵͳÄܹ»ÌåÏÖ¡°¸ßÄÚ¾Û£¬µÍñîºÏ¡±µÄ˼Ïë¡£ÕâÖÖ¹¹¼Ü£¬¿ÉÒÔ½µµÍ²ãÓë²ãÖ®¼äµÄÒÀÀµ£¬Ê¹µÃ¿ª·¢ÈËÔ±¿ÉÒÔÖ»¹Ø×¢Õû¸ö½á¹¹ÖеÄÆäÖÐijһ²ã£»Ò²ÀûÓÚ¸÷²ãÂß¼Éϵĸ´Óá£ÏµÍ³ÔÚUI¶ËʹÓÃjQueryÀ´Íê³ÉϵͳµÄ¿ØÖÆ¡£jQueryÊÇÒ»¸öjavaScript¿â£¬Ëü¿ìËÙ¡¢¼ò½à£¬Ê¹Óû§Äܸü·½±ãµØ´¦ÀíHTML Îĵµ¡¢Ê¼þ¡¢ÊµÏÖ¶¯»µÈЧ¹û£¬²¢¿É·½±ãµÄΪÍøÕ¾ÌṩAJAX½»»¥Ó¦Óá£ÎªÁËÄܹ»ÔöÇ¿Õû¸öϵͳµÄ¿ÉÀ©Õ¹ÐÔ£¬ÏµÍ³Öа²ÅÅÁ˽ÇÉ«¹ÜÀíÄ£¿é£¬¿ÉÒÔ·½±ãµÄÐÂÔö½ÇÉ«£¬²¢¿É¸³ÓèÆäÒ»¶¨µÄȨÏÞ£¬Í¨¹ý¿ØÖƽÇÉ«µÄȨÏÞÀ´¿ØÖÆÓû§¿ÉÒÔ×öʲô£¬²»¿ÉÒÔ×öʲô¡£ ¹Ø¼ü´Ê£ºOA°ì¹«×Ô¶¯»¯£»Èý²ã¹¹¼Ü£»È¨ÏÞ¹ÜÀí£»AJAX Design and Realizition of OA Office Automation System based on .NET platform Abstract OA(Office Automation) ,Office automation system realized by using computer technology to achieve paper-based office to the paperless office changing, manual to automatic changing. The system is named Office Easy Now, it means office easier from now on. Users can give full play to the network of convenience, improve work efficiency! The graduation project using Visual Studio 2005 with SQL Sever 2005 on Windows XP Professional development environment. This system uses B / S (Browser / Server) architecture, server and client physically separate by using network, and we put the database on the server, the data logically separated, this is not only helpful to system maintenance and the data is more secure . The entire system has been added these modules: Branch Management, Department Management, File Cabinets, Calendars, Notes, Information Management, Role Management, Menu(Module) Management, User Management, Log Management, the system also fully considered in the design scalability to add new modules at any time. The system is designed by Three Layers, by using this, the system is divided into the user interface layer (UI), business logic layer (BLL), Data Access Layer (DAL), this Allows the system to reflect the "high cohesion and low coupling" thinking. This architecture can reduce the layer and layer dependence, so developers only pay a close attention to the structure in which they should concern, also beneficial to all levels of logic reuse. The UI (User Interface) using jQuery to show the system. jQuery is a javaScript library, it is fast, simple, and allows users to more easily deal with HTML documents, events, to achieve animation effects, and can be convenient for the website AJAX interactive applications. In order to enhance the entire system scalability, the system provide role management module, you can easily add the role, and can be given certain privileges, by controlling the role of the authority to control the users¡¯ privileges, tell them what they can do and can not do. Key Words: OA(Office Automation);Three Lays; Priviledge Management;AJAX(Asynchronous JavaScript and XML) Ŀ¼ ÕªÒª I Abstract II Ŀ¼ III µÚ1Õ ÒýÑÔ 1 µÚ2Õ ¹¤¾ß½éÉÜ 2 2.1. .NET ½éÉÜ 2 2.1.1. .NET Framework 2 2.1.2. Visual Studio 2005 ½éÉÜ 2 2.1.3. C# ½éÉÜ 2 2.1.4. ASP.NET¼ò½é 3 2.2. SQL Server¼ò½é 4 2.3. jQuery¼ò½é 4 µÚ3Õ OA×Ô¶¯»¯°ì¹«ÏµÍ³¿ÉÐÐÐÔ·ÖÎö 5 3.1. ÏîÄ¿±³¾°ºÍ±ØÒªÐÔ 5 3.2. ʹÓÃOAϵͳµÄÓÅÊÆ 5 3.3. ¿ÉÐÐÐÔ·ÖÎö 6 µÚ4Õ OA×Ô¶¯°ì¹«»¯ÏµÍ³ÐèÇó·ÖÎöÓë×ÜÌåÉè¼Æ 7 4.1. ÒýÑÔ 7 4.2. ÈÎÎñ¸ÅÊö 7 4.3. ϵͳ£¨»òÓû§£©µÄÌصã 7 4.4. ¼Ù¶¨ºÍÔ¼Êø 7 4.5. ÐèÇó¹æ¶¨ 8 4.5.1. ¶Ô¹¦ÄܵÄÒ»°ãÐԹ涨 8 4.5.2. ¶ÔÐÔÄܵÄÒ»°ãÐԹ涨 8 4.5.3. ʱ¼äÌØÐÔÒªÇó 8 4.5.4. Áé»îÐÔ 8 4.5.5. ÊäÈëÊä³öÒªÇó 8 4.5.6. ¹ÊÕÏ´¦ÀíÒªÇó 8 4.5.7. ÆäËûרÃÅÒªÇó 8 4.6. ÔËÐл·¾³¹æ¶¨ 8 4.6.1. Ó²¼þÉ豸 8 4.6.2. Èí¼þÒªÇó 9 4.7. ϵͳ½á¹¹ 9 4.7.1. ϵͳ¹¦ÄÜÄ£¿éͼ 9 4.7.2. ϵͳ¹¦ÄÜÄ£¿é½éÉÜ 10 µÚ5Õ Êý¾Ý¿âµÄÉè¼ÆÓëʵÏÖ 13 5.1. Êý¾Ý¿â·ÖÎö 13 5.2. Êý¾Ý¿âÂß¼Éè¼Æ 13 5.2.1. Êý¾Ý¿âE-Rͼ 13 µÚ6Õ ϵͳÏêϸÉè¼Æ 19 6.1. ϵͳÉè¼Æ¸ÅÊö 19 6.2. Êý¾Ý·ÃÎʲã 19 6.2.1. SqlHelperÀà 19 6.2.2. UserDALÀà 20 6.2.3. messageDALÀàͼ 21 6.3. ÒµÎñÂß¼²ã 22 6.3.1. RoleRightBLLÀàͼ 22 6.3.2. fileBLLÀà 22 6.4. ±íʾ²ãÉè¼Æ 23 µÚ7Õ ½çÃæÉè¼Æ 25 7.1. ½çÃæÉè¼Æ 25 7.1.1. µÇ¼½çÃæÉè¼Æ 25 7.1.2. ϵͳÊ×Ò³Éè¼Æ 26 7.1.3. ²Ëµ¥Éè¼Æ 27 µÚ8Õ ¼¼ÊõÄѵã 29 8.1. Èý²ã¹¹¼Ü 29 8.1.1. Êý¾Ý·ÃÎʲã 29 8.1.2. ÒµÎñÂß¼²ã 29 8.1.3. ±íʾ²ã 30 8.1.4. Èý²ã¹¹¼ÜÏ໥µ÷ÓùØϵ 30 8.2. ȨÏÞ¹ÜÀí 30 8.3. Ê÷ÐοؼþTreeView 31 ×ܽá 33 ²Î¿¼ÎÄÏ× 34 ÖÂл 35 µÚ1Õ ÒýÑÔ Ëæ׿ÆËã»ú¼¼ÊõµÄ²»¶Ï·¢Õ¹£¬¼æ֮ͨѶ¼¼ÊõµÄ²»¶ÏÌáÉý£¬OAÒÑÓëÊ®¼¸ÄêÇ°µÄOA·¢ÉúÁ˺ܴóµÄ±ä»¯£¬¿ÉÒÔ½«×îеÄ˼Ïë¡¢¹ÜÀíÀíÄîÕûºÏ½øOA£¬Ê¹ÆóÒµÔÚ¸ßËÙ·¢Õ¹¹ý³ÌÖгÊÏÖ³öµÄ¶àÏîÄ¿¡¢¿çÇøÓò¡¢¼¯ÍÅ»¯µÄ·¢Õ¹£¬´Ó¶øÌáÉýÆóÒµµÄÕûÌ徺ÕùÁ¦ºÍÇ°½øËٶȡ£ OAÔÚ·¢Õ¹¹ý³ÌÖУ¬Ä¿Ç°ÒѾ¾ÀúÁËËĸöʱÆÚ£º¹¤¾ß½×¶Î¡¢MIS½×¶Î¡¢ÍøÂçÐͬ¹¤×÷ʱ´ú¡¢Òƶ¯»¯½×¶Î¡£OA´ÓÖ½ÕÅÐÅÏ¢Êý×Ö»¯ÒѾ·¢Õ¹µ½ÁËÏÖÔÚµÄÒƶ¯°ì¹«½×¶Î£¡ ÔÚ¹ÜÀí·½Ã棬´ó²¿·ÖÆóÒµµÄ¹ÜÀí·½Ê½ÒÑÓÉ´«Í³×ßÏòÊý×ֽ׶Ρ£ÐÅÏ¢µÄ¹ÜÀí¾ÍÊǶÔÆóÒµÒµÎñÖÐÎÞÐò¸´ÔÓµÄÐÅÏ¢½øÐÐϵͳ»¯¹ÜÀí£¬ÕâÑùµÄÐÅÏ¢¾ßÓпÉÊÕ¼¯¡¢¿É´¦Àí¡¢¿É¹²Ïí²¢ÇÒÊÇ¿ÉÔÙÀûÓõģ¬Í¨¹ý¶ÔÐÅÏ¢µÄ´¦Àí£¬ÌṩÆóÒµµÄÒµÎñˮƽºÍЧÂÊ¡£ÆóÒµ¶ÔÐÅÏ¢µÄ¹ÜÀí½«³ÉΪÉú´æ·¢Õ¹µÄ¹Ø¼üÐÔÒòËØ¡£ ÔÚÓû§·½Ã棬´ó²¿·ÖÓû§¶Ô¼ÆËã»úËùÖªÓÐÏÞ£¬¶Ô¸´ÔÓµÄÈí¼þÊìϤÖÜÆÚ½«»á¼Ó³¤£¬¹¦Äܸ´ÔÓµÄÈí¼þ½«»áÔö¼ÓÆóÒµµÄѧϰºÍÅàѵµÄѹÁ¦£¬²¢ÇÒÐí¶à¹¦Äܲ¢²»Äܵõ½³ä·ÖµÄÀûÓá£Òò´Ë£¬ºÏ¸ñµÄϵͳÐèÒªÓÐÊʺϴóСµÄ¹¦ÄÜ£¬ÒÔ¼°¼òµ¥Ò×ÓõÄÌØÐÔ¡£ ÔÚÕâÓÃÌõ¼þÏ£¬¿ª·¢Ò»¸öÊÕ¼¯´¦ÀíÆóÒµÐÅÏ¢£¬²¢ÇÒ¼òµ¥Ò×ÓõÄϵͳÖÁ¹ØÖØÒª¡£±¾ÏµÍ³²ÉÓÃÁËÏÖÏÂÁ÷ÐеÄASP.NET¼¼Êõ£¬Ê¹ÓÃSQL Server 2005±£´æÊý¾Ý£¬²¢Êʵ±¼ÓÈëjQuery´úÂ룬ʹ³ÌÐò¸ü¾ßÓбíÏÖÁ¦¼°Ò×ÓÃÐÔ¡£ ASP.NET ¼¼ÊõÔÚ΢Èí¹«Ë¾µÄ´óÁ¦ÍƹãÓëÖ§³ÖÏÂÒѾ±È½ÏÍêÉÆ£¬ËüʹÓÃÄ¿Ç°±È½ÏÁ÷ÐеÄC#ÃæÏò¶ÔÏóÓïÑÔ¿ª·¢£¬Ê¹Õû¸öϵͳÍêÈ«»ùÓÚ¡°¶ÔÏó¡±Ä£Ê½¡£¶øÇÒASP.NET ½«Ò»ÕÅÍøÒ³¿´³ÉÒ»¸öForm£¬ÐγɶÀÓеÄWebForm±à³Ìģʽ£¬ÕâÓëVBϵÄWinForm±à³Ì˼ÏëÓÐÒìÇúͬ¹¤Ö®ÃҲ¾ÍÊÇ˵ASP.NETÍêÈ«¼Ì³ÐÁËVBµÄ¼òµ¥±à³Ìģʽ£¬Õû¸öÍøÕ¾¿ÉÒÔµ±×÷ÊÇÒ»¸öWindowsÓ¦ÓóÌÐòÈ¥±à³Ì¡£¸üÓÐÀûµÄÊÇ£¬ASP.NETʹÓÃ΢Èí¿ª·¢µÄVisual Studio 2005×÷Ϊ³ÌÐò¿ª·¢µÄIDE(Integrated Development Environment,¼¯³É¿ª·¢»·¾³),ͨ¹ýʹÓÃVisual StudioÌṩµÄintelligence¼¼Êõ£¬¿É¼«´óµÄÌá¸ß±à³ÌЧÂÊ£¡ Internet/IntranetµÄ·ÉËÙ·¢Õ¹£¬ÎªÐÅÏ¢µÄ½»Á÷ºÍ¹²ÏíÌṩÁ˼¼ÊõµÄ±£Ö¤£¬Í¬Ê±Ò²Ô¤Ê¾×ÅÍøÂ绯°ì¹«Ê±´úÀ´ÁÙ£¬Îª°ì¹«×Ô¶¯»¯ÏµÍ³µÄ¿ª·¢ÌṩÁËÒ»¸öºÜºÃµÄÇ°¾°¡£ |
˵Ã÷£º±¾Õ¾ËùÓгÌÐò¶¼±£Ö¤ÔËÐУ¬Ã¿¸öÌâÄ¿¶¼ÓжÔÓ¦µÄÊÓƵÑÝʾ¼Ïñ£¬½ØͼÎĵµµÈÄÚÈÝ¡£
ÈçÐèÒª¸ü¶à×ÊÁÏÇëÁªÏµ¿Í·þÈËQQ£º:2783277386 |
|
|
|
|
|
|
|