sql企业物料需求计划管理系统论文

摘要

MRP II（Material Requirements Planning）是制造业资源计划的英文缩写。它的思想集中体现了制造企业生产经营过程中的客观规律和需求，其功能覆盖了市场预测、生产计划、物料需求、能力需求、库存控制、车间管理直到产品的销售的整个生产经营过程以及相关的所有财务活动，从而为制造业提供了有效的计划、控制工具和完整的知识体系。解决企业为了达到最大的客户服务、最小的库存投资和高效率的工厂作业三个目标所表现出来的矛盾。而该系统正是为了解决陶瓷企业现阶段中遇到的以上问题而开发的。

本子系统是计划管理系统,MRP是计划主导型的生产计划与控制系统。它是企业管理的首要职能，只有具备了强有力的计划能力，企业才能指导各项生产经营活动顺利进行。在计划管理子系统中，我们主要有两个方面的计划：一是需求计划，是确定企业进行生产的主要依据。二是供给计划，那是满足客户的需求的。它是企业进行生产计划安排的主要依据了。

在MRP II系统中，中上层计划是下层计划的依据，下层计划不能偏离上层计划的目标，从而整个企业遵从一个统一的计划。

本系统的前端开发工具为Microsoft Visual Studio 6.0 ,后台关系数据库选择的是大型的关系数据库Microsoft SQL Sever 2000。

关键词：MRP II、计划管理、Visual C++、SQL Server、ADO、范式。

Abstract

MRP II( Material Requirements Planning) is the English abbreviation that manufacturing industry resources are planned. Its thought embodies a concentrated reflection of the manufacturing company and produces the objective law and demand in the course of dealing in, Its function has covered market prediction , Whole of what production schedule, supplies demand, ability demand, inventory control, workshop manage until sale of the products produces and manage course and relevant financial activities, Thus offered the effective plan for manufacturing industry, control tools and intact knowledge system. Solve enterprise for reach most heavy customer service, minimum stock investment and factory homework three contradiction that goal show of high efficiency. And should develop systematically in order to solve the above problem that ceramic enterprises meet in the present stage .

The notebook system plans the administrative system, MRP plans the leading production schedule . It is primary function of business administration, have only possessed powerful plan ability , Enterprises could instruct every production and operating activities to go on smoothly . In the planned management subsystem, we have the plans of two respects mainly: First, demand plan, confirm enterprise go on main basis that produce. Second, supply the plan, that meets customer's demands. It is the main basis that an enterprise carried on the production schedule and arranged.

In MRP II system, the plan is the basis planned in lower floor at the middle and upper levels, the lower floor can't deviate from the goal that the upper strata plan to plan, Thus the whole enterprise comply with a unified plan.

The front developing instrument of this system is Microsoft Visual Studio 6.0, It was large-scale relation data base Microsoft SQL Sever 2000 that the backstage supporter chose relation data base.

Keywords: MRP II, planned management, , SQL Server, ADO, Visual C ++, Normal Form