辽宁科技大学毕业设计（论文） 第I页
生产管理系统
摘 要
生产部门如果没有专业化管理的工具，都会受到如周期、库存、人力、发货、废品、引入新产品和满足客户要求等问题的困扰。如果没有一个有效的计划，生产部门对以上这些问题以及其他一些类似的问题是很难回答的。由于缺乏公认的专业工具和知识体系以及其有效系统，也很难准确的衡量生产部门的工作业绩。由此可见，生产管理系统的引入迫在眉睫。在应用生产管理系统的环境下，在制定销售与运作规划时先要通过资源计划来估算为生产一定数量的某类产品所需的资源，以保证销售与运作规划的合理性。生产信息管理系统是一套集生产物料、订单、生产领料、产品入库、质量检验于一体的完整信息系统框架。根据实际情况前台程序开发采用VISUAL BASIC 6.0完成，后台数据库建设本系统采用SQL SERVER 2000完成。系统实现了生产一系列基本信息的设置、生产计划单的管理、生产物料与生产领料的入库、生产完工产品的入库和常用工具的快速打开，并且能够根据实际需要进行查询和打印功能。当用户以不同的权限登录时具有不同的操作，操作员可以随时修改自己的口令，管理员可以设置操作员的权限。
关键词 管理系统；生产；数据库
辽宁科技大学毕业设计（论文） 第II页
Abstract
If the production department does not have the specialized tool for management, it will puzzled by question such as cycle, stock, manpower, shipping, waste product, introduction of the new product and satisfaction of customer request and so on. If it does not have an effective plan, the production department is very difficult to reply to all above these questions and all that some similar questions. For the lack of authorized specialty instrument and knowledge hierarchies as well as effective system, it is also very difficult to weight the work achievement of production department accurately. From here we see that the production management system’s introduction is imminent. In the application of production management system, at the time of establish sales and operational planning, we should estimate required resource for producing any kind of certainly product according to resource planning to ensure rationality of establish sales and operational planning. The production information management system is a complete information system frame, which is a set of manufacturing supplies, order form, getting the material in production; the product goes into storage, the quality inspection. According to the actual situation, uses VISUAL BASIC6.0 to complete the development of onstage procedure, the construction of backstage database system use SQL SERVER 2000 to complete. The production system to achieve a series of basic information settings, the management-production planning, production of materials and production materials from the storage, production and storage of the completed products commonly used tool for the rapid open, according to actual needs and can query and print Function. When users log in with a different authority at a different operation, operators can modify their own passwords, the administrator can set up the competence of the operators.
Keywords Management system；Production；Database
辽宁科技大学毕业设计（论文） 第III页
辽宁科技大学毕业设计（论文） 第IV页
目录
摘要 ........................................................................................................... IAbstract .................................................................................................... II第1章 绪论 ............................................................................................ 11.1 应用背景 ..................................................................................... 21.2 开发工具简介 ............................................................................. 31.3 相关技术支持 ............................................................................. 31.4 管理信息系统的发展历史 ......................................................... 41.5 管理信息系统的特点 ................................................................. 51.6 系统的开发过程 ......................................................................... 5第2章 系统分析 .................................................................................... 62.1 需求分析 ..................................................................................... 62.2 设计目标 ..................................................................................... 82.3 开发及运行环境 ......................................................................... 82.4 数据流图 ..................................................................................... 82.4.1 系统数据流图顶层图 ........................................................... 92.4.2 系统数据流图一层图 ........................................................... 92.4.3 系统数据流图二层图 ......................................................... 102.5 数据字典 ................................................................................... 11第3章 系统的总体设计 ...................................................................... 133.1 系统功能架构图 ....................................................................... 143.2 系统数据库结构设计 ............................................................... 153.2.1 数据表概要说明 ................................................................ 163.2.2 数据表 ................................................................................ 16第4章 系统的详细设计 ...................................................................... 204.1 文件架构图 ............................................................................... 214.2 公共模块设计 ........................................................................... 224.3 主窗体的设计 ........................................................................... 234.4 系统登录窗体的设计 ............................................................... 25
辽宁科技大学毕业设计（论文） 第V页
4.5 物料信息设置的窗体设计 ....................................................... 264.6 权限设置 ................................................................................... 27结论 ........................................................................................................ 29致谢 ........................................................................................................ 30参考文献 ................................................................................................ 31附录A ..................................................................................................... 32附录B ..................................................................................................... 37