本科生毕业设计(论文)I办公自动化系统摘要随着Internet技术的推广,基于Web的应用系统得到了飞速发展。.NET框架为Web应用系统提供了全新的平台,成为开发Web应用程序的主流技术之一。本系统设计与实现了基于B/S架构的办公自动化系统,系统的开发采用了.NET框架技术,后台数据库采用SQLServer2005,前台采用C#、HTML语言等进行程序和界面的编写。实现了用户登录和注册、用户和角色管理、部门管理、职位管理、员工管理、短信管理、公文管理等功能。本文先阐述了系统的背景和研究的意义,对系统使用的技术进行了说明,并详细说明了系统的实现过程和系统数据库实现的过程,最后指出了系统存在的不足以及今后的发展方向。关键词办公自动化;ASP.NET;ADO.NET;本科生毕业设计(论文)IIOfficeautomationsystemAbstractWiththepromotionofInternettechnology,Web-basedapplicationshasbeenrapiddevelopment.NETFrameworkforWebapplicationsprovideanewplatformtobecomeoneofthemainstreamtechnologyinthedevelopmentofWebapplications.SystemDesignandImplementationofofficeautomationsystembasedonB/Sarchitecture,thedevelopmentofthesystemused.NETFrameworktechnology,back-enddatabaseusingSQLServer2005,frontC#,HTMLlanguageproceduresandthepreparationoftheinterface.Userloginandregistration,userandrolemanagement,departmentalmanagement,positionmanagement,staffmanagement,messagemanagement,documentmanagementfunctions.Thisarticlefirstdescribesthebackgroundandsignificanceofthestudyofsystems,thesystemusesthetechnologyaredescribed,anddetaileddescriptionofthesystemimplementationprocessandsystemdatabaseimplementation,andfinallypointedouttheshortcomingsofthesystemandthefuturedirectionofdevelopment.Keywordsofficeautomation;ASP.NET;ADO.NET;本科生毕业设计(论文)III目录第1章绪论................................................................................................................................-1-1.1引言..........................................................................................................................-1-1.2课题研究的背景和意义..........................................................................................-1-第2章开发环境介绍和系统开发工具....................................................................................-4-2.1系统开发环境介绍..................................................................................................-4-2.2系统开发工具介绍..................................................................................................-4-2.2.1B/S结构体系......................................................................................................-4-2.2.2VisualStudio2005..............................................................................................-5-2.2.3HTML(HyperTextMarkupLanguage)介绍.......................................................-6-2.2.4SQLServer数据库软件....................................................................................-6-第3章系统可行性分析和需求分析........................................................................................-8-3.1系统可行性分析......................................................................................................-8-3.1.1经济可行性..................................................................................................-8-3.1.2技术可行性..................................................................................................-8-3.2系统需求分析................................................................................................................-8-3.2.1系统各模块需求分析..................................................................................-9-3.2.2系统各用户角色需求分析........................................................................-10-第4章数据库设计和概要设计..............................................................................................-11-4.1数据库设计............................................................................................................-11-4.1.1数据库概念模型设计......................................................................................-11-4.1.2数据库数据模型设计......................................................................................-14-4.2系统概要设计........................................................................................................-16-第5章系统的详细设计..........................................................................................................-17-5.1用户登录界面设计与实现....................................................................................-18-5.2系统主界面的设计与实现....................................................................................-21-5.3部门管理职位设计与实现....................................................................................-23-5.3.1部门添加模块设计与实现........................................................................-23-5.3.2职位添加界面设计...........................................................................................-25-5.3.3查询模块...........................................................................................................-26-5.4短信平台模块........................................................................................................-28-第六章系统测试....................................................................................................................-34-6.1测试...........................................................................................................................-34-6.1.1用户登录模块测试........................................................................................-34-