成 都 信 息 工 程 学 院
学 位 论 文
公文管理系统的设计与实现
论 文 作 者 姓 名 ：
申 请 学 位 专 业 ：
申 请 学 位 类 别 ：
指导教师姓名（职称）：
论 文 提 交 日 期 ：
公文管理系统的设计与实现
摘 要
随着网络信息化的高度发展，传统的以字符为主题的信息传播形式已不再满
足需要。基于 Web 的办公系统显得越来越必要。本系统正是为了满足这样的需求
而设计开发的。程序在 Visual Studio 2003 平台下使用 VB.NET 编程语言，数据
库使用 SQL SERVER 2000。
本公文系统实现了公文处理的自动化流转，包括公文起草、已发公文、待办
公文、已办公文、公文委托、流程监控以及类别定制。系统完成了创建公文流的
路径；起草的公文能按照已创建的公文流路径流转；能对其起草的公文进行统计
及实时的监控；能够查看自己审批过的公文；能委托其他人代自己审批公文；能
够添加、维护人员信息。
关键词：公文管理系统；B/S 模式；VB.NET；SQL SERVER
The Design and Implementation of the Document
Management System
Abstract
Along with the drastic development of network information, the traditional way
of information dissemination has no longer satisfied people’s requirements. To meet
the above needs, this system is developed. This procedure was developed under
Visual Studio 2003 with VB.NET language. The SQL SERVER 2000 is used as
database management system.
This document system has implemented the automatic document transmission
and dealing with. It includes the draft of documents, the documents which has been
sent, the documents which has to be done, the documents which has been done, the
documents which was entrusted, the flow monitoring and the drafting of identification.
This system has accomplished the path of documents. The draft of documents can be
transported by following the flows which have been founded.This system can
summarize and control the documents drafted in time. User can examine the
documents which have been examined by themselves and can entrust others with the
privileges of examining and approving documents.It also can increase and maintain
people’s information.
Key words: Document Management System; B/S Model; VB.NET; SQL
SERVER
目 录
论文总页数：23 页
1 引言............................................................................................................................................1
2 公文管理系统系统分析............................................................................................................2
2.1 系统需求分析 ..................................................................................................................2
2.1.1 用户身份级别要求 ...................................................................................................2
2.1.2 系统功能模块设置 ...................................................................................................2
2.2 系统设计目标 ..................................................................................................................3
2.3 开发环境 ..........................................................................................................................3
2.3.1 .NET 框架 ..................................................................................................................3
2.3.2 ASP.NET 的工作原理 ................................................................................................3
2.3.3 VB.NET .......................................................................................................................4
2.3.4 MVC 介绍 ....................................................................................................................4
2.3.5 编程运行环境 ...........................................................................................................4
3 公文管理系统系统设计............................................................................................................5
3.1 数据库设计与实现 ..........................................................................................................5
3.1.1 数据库的需求分析 ...................................................................................................5
3.1.2 数据库的逻辑设计 ...................................................................................................5
3.1.3 数据库存储过程 .......................................................................................................9
3.2 系统模块分析与设计 ....................................................................................................10
3.3 界面设计 ........................................................................................................................11
3.3.1 系统色彩规划 .........................................................................................................11
3.3.2 系统框架设计 .........................................................................................................11
3.4 系统总体功能设计 ........................................................................................................12
3.5 功能模块设计 ................................................................................................................13
4 功能模块具体实现..................................................................................................................15
4.1 公文流的实现代码 ........................................................................................................15
4.2 数据管理代码 ................................................................................................................16
5 系统测试..................................................................................................................................16
5.1 软件测试 ........................................................................................................................16
5.2 调试 ................................................................................................................................17
结 论..........................................................................................................................................17
参考文献..........................................................................................................................................18
附录..................................................................................................................................................19
致 谢..........................................................................................................................................22
声 明..........................................................................................................................................23
