摘 要
摘 要
所谓MIS（管理信息系统--Management Information System）系统 ，是一个由人、计算机及其他外围设备等组成的能进行信息的收集、传递、存贮、加工、维护和使用的系统。一个完整的MIS应包括：辅助决策系统（DSS）、工业控制系统（CCS）、办公自动化系统（OA）以及数据库、模型库、方法库、知识库和与上级机关及外界交换信息的接口。而MRP(Material Requirement Planning 物料需求计划)是被设计并用于制造业库存管理信息处理的系统，它解决了如何实现制造业库存管理目标——在正确的时间按正确的数量得到所需的物料这一难题。MRP是当今众所周知的ERP的雏形，MRP与ERP的库存管理思想又源于求解制造业基本方程。
中小企业在我国经济发展中占有重要地位，随着全球经济一体化的发展及中国加入WTO，中小企业将面临外资企业和国外产品与服务的严峻挑战，因此，如果我国的中小企业不借助先进的管理思想转变经营观念、使用信息化提高企业的管理水平和工作效率，将很难在今后的国际竞争中取胜。企业管理在很多方面、很大程度上都必须借助信息化来完成。随着电脑知识日趋普及，同时市场经济快速多变，竞争激烈，因此企业采用计算机对生产计划进行管理已成为趋势及必然。
本问是采用Visual Basic作为开发工具，SQL Server作为后台数据库而开发的MRP管理信息系统，可以实现对产品信息、厂商信息、合同收账、合同信息、制造技术统计的管理。
关键词：管理信息系统; MRP; 商品库存调度; Visual Basic.NET; SQL Server2000
I
Abstract
Abstract
The so-called MIS (Management Information System) is composed of a people, computers and other peripheral devices and so on ,the usage of which contains information collection, transmission, storage, processing, maintenance and so on . A complete MIS should include: decision support system (DSS), industrial control systems (CCS), office automation (OA) and database, model base, method base, knowledge base and with the higher authorities and external exchange of information interfaces. MRP (Material. Requirement Planning Material Requirements Planning) is designed and used in manufacturing inventory management, information processing system.It solves the manufacturing inventory management objectives - at the right time to get the correct number of materials a problem. MRP is the prototype of today's well-known ERP, MRP and ERP inventory management thinking from solving manufacturing basic equation.
Playing an important role of SMEs in China's economic development, with the development of global economic integration and China's accession to the WTO, SMEs will face severe challenges of foreign-funded enterprises and foreign products and services. If China's small and medium enterprises lack the aid of advanced management thinking to change their management concepts and the use of information technology to improve enterprise management level and efficiency, it will be difficult to win in the future international competition. Business management in many respects, to a large extent have to rely on information technology to complete. With the growing
I
Abstract
popularity of computer knowledge, while the market economy is rapidly changing, highly competitive, so companies using the computer to manage the production planning has become a trend and inevitable.
Ask is using Visual Basic as a development tool, MRP management information system, developed by the SQL Server as the back-end database of product information, vendor information, contracts receivable, contract information, manufacturing, management of technical statistics.
Keywords: MIS; MRP; Visual Basic.NET; SQL Server2000
II
目 录
目 录
引 言 ......................................................... I 第一章 绪论 ................................................... 1
1. 1物料需求计划(MRP)简介 .................................. 1 1. 2国内现状 ............................................... 1 1.3项目意义 ................................................ 2 1.4系统目标 ................................................ 3 第二章 需求分析 ................................................ 4
2.1 功能需求 ............................................... 5 2.2性能需求 ................................................ 6 2.3 界面需求 ............................................... 7 第三章 系统分析 ............................................... 8
3.1 识别参与者 ............................................. 8 3.2识别用例 ................................................ 9 3.3 定义系统对象 .......................................... 12 3.4 定义类间的关系 ........................................ 13 第四章 系统设计 .............................................. 15
4.1建立交互作用图 ......................................... 15 4.2 建立活动图 ............................................ 16 4.3 建立时序图 ............................................ 17 4.4数据库设计 ............................................. 18 第五章 系统实现 .............................................. 25
I