基于A - SPNET技术0A系统预算子系统 - 的设计与实现毕业论文

本科学生毕业论文

论文题目： 基于ASP.NET技术0A系统预算子系统

学 院： 年 级： 专 业： 姓 名： 学 号： 指导教师：

的设计与实现

摘要

摘要是对论文内容不加注随着信息技术的迅猛发展，利用网络进行数据传输以实现办公自动化已经成为企业发展的必然趋势。通过使用办公自动化系统，企业可以提高办公效率和质量，实现信息资源共享，增强部门间协同工作能力，促进企业管理工作的现代化、规范化以及网络化进程，全面提高企业的经营管理水平。

本课题主要研究预算管理系统。课题以企业业务流程为背景，在详细掌握预算管理需求的基础上，研究了OA系统中预算管理系统的设计与实现。该本系统使用UML建模语言对各业务逻辑模块进行建模，使用SQL Server 2005数据库与Visual C#语言，使用B/S结构与MVC设计模式，采用ASP.NET开发平台，在VisualStudio2005集成开发环境下实现。

本系统实现的功能完整，满足了企业需求，能够确保企业年度经营计划的实现，预算指标的实现，不仅仅提高了企业的工作效率，而且还提高了企业经营管理水平。

释和评论的简短陈述，要求扼要说明研究工作的目的、主要内容、研究结果、结论、科学意义或应用价值等，是一篇具有独立性和完整性的短文。摘要中不宜使用公式、图表以及非公知公用的符号和术语，不标注引用文献编号。

摘要内容应在200～400字左右，用宋体小四号字书写。摘要内容后空两行书写“关键词”。毕业论文、毕业设计行与行之间、段落和层次标题以及各段落之间均为1.5倍行距。

关键词

办公自动化系统；预算管理；UML；MVC；ASP.NET

I

Abstract

With the rapid development of computer technology, using network technology to transfer data to achieve office automation has become an inevitable trend of the development of the modern enterprise. Through using the office automation system can improve work efficiency and quality, and share information resources, and enhance the interoperability between different departments, promote the progress of modernization, standardization and network of enterprise management, and comprehensively improve the level of enterprise management.

The main subject of the research is budget management system. The background of the subject is the business progress. On the basis of detailed grasping the needs of budget management, I research the design and implementation of the budget management system in the OA system. This system use the UML modeling language to model the business logic module, and use the SQL Server 2005 database and Visual C # language, and use the B / S structure and the MVC design pattern, and use the ASP.NET development platform and implement under Visual Studio 2005 integrated development environment.

This system implements all of the functions and meets the enterprise’s needs. It also can ensure the implementation of annual enterprise’s plans and the budget targets. It not only to improve the efficiency of enterprises, but also increased the level of enterprise management.

Key words

Office automation; Budget management; UML; MVC; ASP.NET

II

目录

摘要 ............................................................................................................................................ I Abstract ................................................................................................................................... II

前言 ........................................................................................................................................... 1 第一章 绪论 ............................................................................................................................. 2

1.1 课题的背景及来源 ..................................................................................................... 2 1.2 与课题相关的国内外现状 ......................................................................................... 2

1.2.1 国外预算研究历史与现状 ............................................................................... 2 1.2.2 国内预算研究历史与现状 ............................................................................... 3 1.3 课题研究内容及特点 ................................................................................................. 4 1.4 课题的研究方法及采用技术 ..................................................................................... 5

1.4.1 研究方法 ........................................................................................................... 5 1.4.2 采用技术 ........................................................................................................... 5 1.5 论文组织结构 ............................................................................................................. 6 第二章 相关技术简介 ............................................................................................................. 7

2.1 B/S三层体系结构 ....................................................................................................... 7 2.2 ASP.NET相关技术 ...................................................................................................... 8

2.2.1 .NET开发平台 .................................................................................................. 8 2.2.2 Visual C#编程语言 ............................................................................................ 9 2.2.3 ASP.NET技术 .................................................................................................. 10 2.2.4 ADO.NET技术 ................................................................................................ 11 2.3 数据库相关技术 ....................................................................................................... 12

2.3.1 数据库概述 ..................................................................................................... 12 2.3.2 SQL Server 2005 数据库 ................................................................................ 14 2.4 UML简介 .................................................................................................................. 14 2.5本章小结 .................................................................................................................... 15 第三章 系统分析与设计 ....................................................................................................... 16

3.1 系统需求分析 ........................................................................................................... 16 3.2 总体设计思想 ........................................................................................................... 18 3.3 系统功能模块设计 ................................................................................................... 18 3.4 系统数据库设计 ....................................................................................................... 20

3.4.1 数据库相关理论 ............................................................................................. 20 3.4.2 数据库表设计 ................................................................................................. 21 3.4.3 数据库视图 ..................................................................................................... 24 3.4.4 数据库存储过程 ............................................................................................. 24 3.5本章小结 .................................................................................................................... 26 第四章 系统开发与实现 ....................................................................................................... 27

4.1 系统实现的架构 ....................................................................................................... 27 4.2 系统权限管理的实现 ............................................................................................... 28 4.3 登录模块的实现 ....................................................................................................... 30 4.4 用户管理模块的实现 ............................................................................................... 30 4.5 预算管理模块的实现 ............................................................................................... 31

4.5.1 预算编制的实现 ............................................................................................. 32 4.5.2 预算审核的实现 ............................................................................................. 33 4.5.3 预算查询的实现 ............................................................................................. 34 4.6 费用管理模块的实现 ............................................................................................... 35

4.6.1 费用录入的实现 ............................................................................................. 36 4.6.2 费用查询的实现 ............................................................................................. 37 4.7 统计分析管理模块的实现 ....................................................................................... 39 4.8本章小结 .................................................................................................................... 40 第五章 系统测试 ................................................................................................................... 41

5.1软件测试简介 ............................................................................................................ 41

5.1.1 软件测试目的 ................................................................................................. 41 5.1.2 软件测试分类 ................................................................................................. 41 5.2软件测试用例 ............................................................................................................ 42

5.2.1 系统登录测试 ................................................................................................. 42

本文来源：https://www.bwwdw.com/article/wk1h.html