生产管理系统的设计与实现—产品库存管理模块-毕业论文.docVIP

摘要 随着我国改革开放的不断深入，企业发展已经从面向区域市场转向面向对国内外广阔的市场，过去长期采用的传统手工或手工加微机的管理方式已无法对经营过程中多层次、多品种、多批量的生产计划进行管理，也无法对任何一种产品生产过程的动态信息进行管理。生产管理系统正是在这种背景之下，以信息技术为基础，以基本MRP理论为指导，通过对主生产计划（MPS）、物料清单（BOM）、库存信息的协调管理来实现对企业生产经营诸因素进行优化组合和合理配置，提高企业的经营质量和效率，降低企业生产成本，优化生产管理，全面增强企业的生存竞争能力。 本系统以灯饰产品的生产管理为例进行设计编写，后台数据库采用SQL Server 2000，以保证数据的安全、高效和稳定；前台采用Microsoft Visual Basic 6.0作为主要的开发工具，它可与SQL Server 2000数据库无缝链接。主要实现企业生产的基础信息管理、计划信息管理、生产设备管理、物料库存管理和用户管理以及打印相关报表等。 关键词: 生产管理系统；Visual Basic；SQL Server 2000  Abstract With our reform and opening up unceasing developing and consummating, the enterprise development has be transformed from catering for the regional market to the vast market of domestic and overseas. The past long-term use of traditional manual or hand plus management of computer operations has been unable to administrate the multi-level , numerous in variety and the mass distribution of production plan administration during operating process, nor can manage the dynamic information in any form of a product of the production process. Production management system is in this context, based on information technology, which directed by basic MRP theory, through the master production schedule, bill of material and inventory information management to achieve the coordination of production management and to optimize the combination of various factors and rational allocation. And it can also improve the quality and efficiency of enterprise management, reduce production costs, optimize production management, and enhance the overall competitiveness to survive. This system is designed by the sample of lighting products and accessories production management. The background partition database use SQL Server 2000, to ensure the data security, efficient and stable. For the foreground partition, which adopt Microsoft Visual Basic 6.0 as a major development tool, can be linked with SQL Server 2000 database seamlessly. The main intention of the Production Management System is to achieve based informatio