办公用品管理系统的设计与实现

办公用品管理系统是办公自动化管理系统的重要组成部分，它可以对办公用品的入库和领用进行规范化管理，进而提高工作效率，避免资源的浪费。

此系统根据单位的办公用品的购买，入库，领用流程而设计的，特别适用于分批次购买，各部门领用的模式，具有完善的入库登记，领用登记，查询等功能。这样就更可以合理规范对企事业单位办公用品的管理。

本论文将介绍办公用品管理系统的设计和开发过程。本系统采用VISUAL C++作为开发工具，SQL SERVER作为后台数据库，使用ADO数据库访问技术，利用IOCP模型设计而成。此系统包含了办公共品的入库登记，领用登记以及库存管理等几大模块组成，本系统还具有强大的查询功能，具体有快速查询，关键字查询以及按时间查询，本系统还可以根据库存量自动给出缺货通知的功能。此系统的开发，采用计算机对企事业单位的办公用品进行管理，进一步提高办公效益和现代化水平.帮助广大员工提高工作效率，实现办公用品信息管理工作流程的系统化、规范化和自动化，避免企事业单位浪费严重的问题。

关键字：办公用品管理系统，完成端口模型，ActiveX数据对象访问技术

Abstract

Office supplies management system is office automation management system, it can be an important part of office supplies of warehousing and carries out standard management, and then according to enhance work efficiency, avoid the waste of resources.

This system according to the unit of the purchase, storage of office supplies, recipients process and design, especially suitable for several times the purchase, various departments recipients, with perfect inventory model according to register, inquires register, etc. Function. So the more can reasonable rules for enterprises and institutions of the office supplies management.

This paper will introduce office supplies management system design and development process. This system USES VISUAL c + + as development tools, SQL SERVER as backend database, using ADO database access technology, using the IOCP model design and into. This system consists of the office storage products were registered, registration, and inventory management, and other recipients of several major modules, the system also has a powerful query capabilities, specifically fast search, keyword search and by time, the system can also According to automatically give out stock notification feature. The development of this system, the use of computer enterprises to manage office supplies, to further improve office efficiency and modernization. to help improve the efficiency of the staff, office supplies to achieve the systematic process of information management, standardization and automation, enterprises and institutions to avoid Unit waste problem.

Keywords: office supplies management system, IOCP model, ADO database access technology

摘要 ......................................................................................... 错误！未定义书签。ABSTRACT ................................................................................................................. I I 1 引言

1.1课题来源 (1)

1.2项目开发背景 (1)

1.3项目开发的目标及意义 (2)

1.4系统开发所用的技术 (3)

1.5系统开发环境 (3)

2 系统分析

2.1分析目标 (4)

2.2功能需求分析 (4)

2.3性能需求分析 (4)

2.3.1简便性 (5)

2.3.2方便查询 (5)

2.3.3安全性 (5)

2.4数据需求分析 (6)

3 系统概要设计

3.1系统功能架构设计 (7)

3.2系统功能流程设计 (7)

3.3系统数据库概念模型设计 (8)

3.4系统功能界面设计 (9)

4 系统详细设计

4.1算法流程 (10)

4.1.1登录流程 (10)

4.1.2入库流程 (12)

4.1.3领用流程 (13)

4.1.4生成缺货单流程 (14)

4.2系统关系模型设计 (14)

4.2.1办公用品信息表 (14)

4.2.2办公用品缺货信息表 (15)

4.2.3入库登记表 (15)