»¶Ó­¹âÁÙ£¬×ÉѯÁ˽â¼ÆËã»ú±ÏÒµÉè¼ÆÏîÄ¿£¬±¾Õ¾ËùÓбÏÒµÉè¼Æ×÷Æ·¾ù±£Ö¤ÔËÐгɹ¦£¬¿É½Ó¶¨ÖÆ£¡

  Äúµ±Ç°ËùÔÚλÖãºÍøÕ¾Ê×Ò³¼ÆËã»ú±ÏÒµÉè¼Æ > ASP.NET >

OA°ì¹«×Ô¶¯»¯ÏµÍ³Éè¼Æasp.net1044(±ÏÒµÉè¼Æ+ÂÛÎÄ)
×÷Õߣº admin    ÏÂÔØËùÐèÔƱңº150 Ã¶      ä¯ÀÀ£º1386 ´Î     ÏÂÔØ£º0 ´Î     Êղأº1 ´Î     ¸üÐÂÈÕÆÚ£º2016-11-12
 
 

¸÷Àà´óѧÉú±ÏÒµÉè¼ÆÔ´Âë³ÌÐò£¬ËùÓгÌÐò°üÊÛºó¡¢°üÔËÐС¢°üµ÷ÊÔ£¡»¶Ó­×Éѯ...

 
  Ìáʾ£º±¾×ÊÁÏÒÑÉóºË¹ý£¬ÄÚÈÝÑϸñ±£ÃÜ£¬¸ñʽ±ê×¼£¬ÖÊÁ¿±£Ö¤¡£Ö±½Ó¿ÉÒÔ³äÖµÏÂÔØ
    1.ÏÂÔØ»òÕß³äÖµÓöµ½ÎÊÌ⣬¿É×Éѯ¿Í·þÈËÔ±2783277386
    2.±¾Õ¾ÌṩËùÓбÏÒµÉè¼Æ¶¼°üÊÛºó¡¢°üÔËÐС¢°ü½²½â¡¢°üµ÷ÊÔ¡£¡£
 
 ÈçÐèÒªÍêÕûÉè¼Æ×ÊÁÏÇë³äÖµÔƱҽøÐÐÏÂÔØ£¬³äÖµºÍÏÂÔض¼ËÍ»ý·Ö¡£¡£ Ò²¿ÉÒÔÖ±½ÓÖ§¸¶¹ºÂò

         
 

»ùÓÚ.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


 
 
  Éè¼Æ 
 
»ùÓÚSSMÂÃÓξ°µã¾ÆµêÔ¤¶©ÍøÕ¾Éè¼Æ
»ùÓÚunityµÄ·É»ú´óÕ½ÓÎÏ·Éè¼Æ
¹«Ë¾ÈËʹÜÀíϵͳµÄÉè¼ÆÓëʵÏÖJSP141
JSPµçӰƱԤ¶¨ÍøÕ¾µÄÉè¼ÆÓ뿪·¢142(±
JSPµÄ·¿ÎÝÏúÊÛÍøÕ¾µÄÉè¼ÆÓëʵÏÖ143(±
»ùÓÚPHPµÄÍøÉϹºÎïÍøÕ¾PHP1017(±ÏÒµÉ
»ùÓÚandroidµÄ¼ÒÍ¥Àí²ÆͨÉè¼ÆAndroid
³µÁ¾×âÁÞ¹ÜÀíϵͳPHP1006(±ÏÒµÉè¼Æ+Â
»ùÓÚAndroidµÄÆû³µ¶©Æ±ÏµÍ³Android10
»ùÓÚPHPµÄ¾Æµê¹ÜÀíϵͳPHP1008(±ÏÒµÉ

  ×îбÏÒµÉè¼Æ 
 
»ùÓÚSSMÂÃÓξ°µã¾ÆµêÔ¤¶©ÍøÕ¾Éè¼Æ
»ùÓÚunityµÄ·É»ú´óÕ½ÓÎÏ·Éè¼Æ
¹«Ë¾ÈËʹÜÀíϵͳµÄÉè¼ÆÓëʵÏÖJSP141
JSPµçӰƱԤ¶¨ÍøÕ¾µÄÉè¼ÆÓ뿪·¢142(±
JSPµÄ·¿ÎÝÏúÊÛÍøÕ¾µÄÉè¼ÆÓëʵÏÖ143(±
»ùÓÚPHPµÄÍøÉϹºÎïÍøÕ¾PHP1017(±ÏÒµÉ
»ùÓÚandroidµÄ¼ÒÍ¥Àí²ÆͨÉè¼ÆAndroid
³µÁ¾×âÁÞ¹ÜÀíϵͳPHP1006(±ÏÒµÉè¼Æ+Â
»ùÓÚAndroidµÄÆû³µ¶©Æ±ÏµÍ³Android10
»ùÓÚPHPµÄ¾Æµê¹ÜÀíϵͳPHP1008(±ÏÒµÉ

 
³ÏÑû¼¼Êõ¼ÓÃ˺Ï×÷£¬IOS¼¼Êõ¡¢Android¡¢Delphi¡¢Î¢ÐÅС³ÌÐò¡¢C++µÈ¼¼ÊõºÏ×÷ £¡³ÏÑû¸÷´óѧУͬѧ¼ÓÃË´úÀíºÏ×÷£¬ÕÐƸѧУ´úÀí£¬Íò·Ý¼ÆËã»ú³ÉÆ·×÷Æ·´úÀíȨ£¡
 
ÍøÕ¾·þÎñQQ£º2783277386  ÍøÕ¾·þÎñQQ2£º2783277386 
 
ȨËùÓУºCopyright 2007-2021 öÎÔÆ´´ÍøÂç¿Æ¼¼ www.ycbs114.com ¼ÆËã»ú±ÏÒµÉè¼ÆÍø¿Í·þ·þÎñ£¡£¡ÊñICP±¸08107142ºÅ     51LAͳ¼Æ