【正文】 I 摘 要 辦公用品管理系統(tǒng)是辦公自動(dòng)化管理系統(tǒng)的重要組成部分，它可以對(duì)辦公用品的入庫和領(lǐng)用進(jìn)行規(guī)范化管理，進(jìn)而提高工作效率，避免資源的浪費(fèi)。 此系統(tǒng)根據(jù)單位的辦公用品的購買，入庫，領(lǐng)用流程而設(shè)計(jì)的，特別適用于分批次購買，各部門領(lǐng)用的模式，具有完善的入庫登記，領(lǐng)用登記，查詢等功能。這樣就更可以合理規(guī)范對(duì)企事業(yè)單位辦公用品的管理。 本論文將介紹辦公用品管理系統(tǒng)的設(shè)計(jì)和開發(fā)過程。本系統(tǒng)采用 VISUAL C++作為開發(fā)工具， SQL SERVER 作為后臺(tái)數(shù)據(jù)庫，使用 ADO 數(shù)據(jù)庫訪問技術(shù)，利用 IOCP 模型設(shè)計(jì)而成。 此系 統(tǒng)包含了辦公共品的入庫登記，領(lǐng)用登記以及庫存管理等幾大模塊組成，本系統(tǒng)還具有強(qiáng)大的查詢功能，具體有快速查詢，關(guān)鍵字查詢以及按時(shí)間查詢，本系統(tǒng)還可以根據(jù)庫存量自動(dòng)給出缺貨通知的功能。此系統(tǒng)的開發(fā)， 采用計(jì)算機(jī)對(duì) 企事業(yè)單位的辦公 用品進(jìn)行管理，進(jìn)一步提高辦 公 效益和現(xiàn)代化水平 .幫助廣大 員工 提高工作效率，實(shí)現(xiàn)辦公用品信息管理工作流程的系統(tǒng)化、規(guī)范化和自動(dòng)化 ，避免企事業(yè)單位浪費(fèi)嚴(yán)重的問題 。 關(guān)鍵字 ： 辦公用品管理系統(tǒng)， 完成端口模型 ， ActiveX 數(shù)據(jù)對(duì)象 訪問技術(shù) II 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 puter 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 III 目 錄 摘 要 ............................................................................................................................ I ABSTRACT ................................................................................................................. II 1 引言 課題來源 .............................................................................................................. 1 項(xiàng)目開發(fā)背景 .................................................................................................... 1 項(xiàng)目開發(fā)的目標(biāo)及意義 .................................................................................... 2 系統(tǒng)開發(fā)所用的技術(shù) ......................................................................................... 3 系統(tǒng)開發(fā)環(huán)境 ...................................................................................................... 3 2 系統(tǒng) 分析 分析目標(biāo) .............................................................................................................. 4 功能需求分析 ...................................................................................................... 4 性能需求分析 ...................................................................................................... 4 簡便性 ............................................................................................................ 5 方便查詢 ........................................................................................................ 5 安全性 ............................................................................................................ 5 數(shù)據(jù)需求分析 ..................................................................................................... 6 3 系統(tǒng)概要設(shè)計(jì) 系統(tǒng)功能架構(gòu)設(shè)計(jì) .............................................................................................. 7 系統(tǒng)功能流程設(shè)計(jì) .............................................................................................. 7 系統(tǒng)數(shù)據(jù)庫概念模型設(shè)計(jì) ................................................................................. 8 系統(tǒng)功能界面設(shè)計(jì) ............................................................................................. 9 4 系統(tǒng)詳細(xì)設(shè)計(jì) 算法流程 ............................................................................................................ 10 登錄流程 ...................................................................................................... 10 入庫流程 ...................................................................................................... 12 領(lǐng)用流程 ...................................................................................................... 13 生 成缺貨單流程 .......................................................................................... 14 系統(tǒng)關(guān)系模型設(shè)計(jì) ............................................................................................ 14 辦公用品信息表 .......................................................................................... 14 辦公用品缺貨信息表 .................................................................................. 15 入庫登記表 .................................................................................................. 15 IV 領(lǐng)用登記表 .................................................................................................. 16 用戶信息表 .................................................................................................. 16 5 系統(tǒng)主要實(shí)現(xiàn) 環(huán)境安裝與配置 ................................................................................................ 17 SQL Server 安裝 .......................................................................................... 17 VISUAL C++ ...................................................................