I
摘 要
本文介绍的主要内容是小型企业薪资管理系统的开发及维护， “小型企业薪资
管理系统”主要完成人事信息的录入、修改、查询、统计分析以及工资的核算、发放
等功能。其中内容广泛、复杂，除包括员工的各种基本信息（如姓名、性别、学历、
地址）外，还包括员工每天的考勤、加班情况；员工的合同信息；获得奖惩信息的情
况；员工的培训、考核以及调动情况；工资项的设置，公式的定义；工资的详细信息
等。本文就根据现已存在的问题，对小型企业薪资管理系统做了全面的分析和整体的
介绍。介绍了 ASP.NET+SQL 技术开发该系统的子系统的整个过程。该系统主要利用
了 ASP.NET 强大的网络数据库访问技术，实现了小型企业薪资管理系统的功能。本
系统的开发主要包括数据存储部分的建立，维护以及可供用户直接使用的 web 页面的
的开发两个方面。对于前者要求建立起一致性好，完整性强、安全性好的数据存储系
统。而对于后者则要求页面简洁，操作性好，功能完备的应用程序。经过分析，我决
定使用一种服务器端、跨平台的 HTML 嵌入式脚本语言——ASP.NET 开发语言，主
流 Web 服务器 IIS5.0，性能很强的数据库 SQL Server 2005，利用 APS.NET 提供的编
程优点，结合数据库所提供的优良功能，建立系统应用原型,然后,对初始原型系统进
行需求迭代分析和设计,经过不断的分析设计和测试，开发出用户满意的系统。
论文主要介绍了本课题的开发背景、系统分析、数据库设计和系统的设计与实现。
关键词：ASP.NET SQL Server 2005 数据库
II
Abstract
The main content of this paper is to develop and maintain employee management
system for small and medium enterprises, "staff management system" small enterprises
mainly completes the personnel information input, modify, query, statistical analysis and
wage accounting, payment functions. The extensive and complex, including all the staff's
basic information (such as name, gender, education, address), including staff daily
attendance, overtime; employee contract information; obtaining rewards and punishment
information; staff training, assessment and mobilize the situation; the setting of wages,
formula definition the detailed information of wages. According to the problems existing at
present, gives an overall analysis and introductions of staffer management system for
enterprises. This paper introduces the whole process of system development of the system
of ASP.NET+SQL technology. The system is mainly used ASP.NET web-based database
access technology, the realization of the staff management system of small enterprise
function. This system development mainly includes the establishment of the data storage
part, two aspects of maintenance and for users to directly use the web page development.
Request for the establishment of good consistency, integrity, good safety data storage
system. For the latter request page simple, good operation, complete function of
application. After the analysis, I decided to use a server, cross-platform HTML embedded
scripting language -- ASP.NET language development, the mainstream Web server IIS5.0,
strong performance of database SQL Server 2005, provided by the use of APS.NET
programming advantages, combined with good function offered by database, establishes
the system application prototype, then, carries on the demand analysis of iterative and the
design of the initial prototype system, after analysis and test design constantly, develop a
customer satisfaction system.
Key Words：ASP.NET SQL Server 2005 database
III
目录
摘 要 .......................................................................................................................................................I
Abstract ......................................................................................................................................................II
引 言.......................................................................................................................................................1
1 系统概况.................................................................................................................................................2
1.1 题目开发背景.................................................................................................................2
1.2 国内外研究现状.............................................................................................................3
2 开发工具和开发方法的选择.................................................................................................................4
2.1 开发工具的选择.............................................................................................................4
2.1.1 SQL Sever 2005 简介 ...................................................................................................4
2.1.2 Browser/Server（B/S）结构........................................................................................5
2.1.2 .NET ..............................................................................................................................5
3 系统分析.................................................................................................................................................7
3.1 预期目标.........................................................................................................................7
3.2 预期用户.........................................................................................................................7
3.3 系统需求分析.................................................................................................................7
3.3.1 基本功能需求分析.......................................................................................................8
3.3.2 操作需求分析..............................................................................................................9
3.4 系统可行性分析.............................................................................................................9
3.4.1 经济可行性分析...........................................................................................................9
3.4.2 技术可行性分析...........................................................................................................9
3.4.3 管理可行性分析...........................................................................................................9
3.4.4 结论...............................................................................................................................9
3.5 系统的运行要求.............................................................................................................9
IV
3.5.1 系统架构选择...............................................................................................................9
3.5.2 操作系统的选择.........................................................................................................10
3.6 系统功能模块分析.......................................................................................................11
4 系统的设计...........................................................................................................................................13
4.1 设计原则......................................................................................................................13
4.2 业务流程分析...............................................................................................................13
4.2.1 业务流程图符号说明............................................................................................13
4.2.2 员工信息管理流程................................................................................................14
4.2.3 工资信息管理流程................................................................................................14
4.2 系统功能模块设计.......................................................................................................15
4.2.1 登入模块.....................................................................................................................16
4.2.2 基本信息管理模块.....................................................................................................17
4.2.3 请假管理模块.............................................................................................................17
4.2.4 请假管理模块.............................................................................................................18
4.2.5 请假管理模块.............................................................................................................18
4.2.6 统计查询模块.............................................................................................................18
4.2.7 系统管理模块.............................................................................................................19
4.3 系统数据库的设计.......................................................................................................19
4.3.1 数据库需求分析.........................................................................................................19
4.3.2 数据库概念结构设计.................................................................................................20
4.3.3 数据库与数据表设计.................................................................................................21
4.4 系统关联图...................................................................................................................24
4.5 顶层图...........................................................................................................................26
4.6 数据流...........................................................................................................................26
V
4.7 数据存储.......................................................................................................................30
4.7 员工工资计算加工.......................................................................................................33
4.7 外部项...........................................................................................................................33
5 系统实施...............................................................................................................................................35
5.1 通用模块.......................................................................................................................35
5.1.2 数据库连接文件.........................................................................................................35
5.2 登入模块.......................................................................................................................41
5.3 账号管理模块...............................................................................................................42
5.4 部门管理模块...............................................................................................................43
5.5 假期审批模块...............................................................................................................43
5.6 奖惩管理模块...............................................................................................................43
5.7 工资统计模块...............................................................................................................44
5.8 系统公告模块..............................................................................................................44
5.9 考勤统计模块...............................................................................................................45
5.10 奖励统计模块.............................................................................................................45
5.11 惩罚统计模块.............................................................................................................45
6 系统测试................................................................................................................................................46
结 论.....................................................................................................................................................47
参考文献...................................................................................................................................................48
致 谢.....................................................................................................................................................49
