【作者】 张涛；

【导师】 张传敏；

【作者基本信息】 吉林大学 ， 机械工程（专业学位）， 2018， 硕士

【摘要】 中小型机械制造企业生产线管理系统的建立对于机械制造业企业的信息化以及生产的智能化具有重要的意义,是促进现代工业进步和发展的基础条件之一。然而我国制造业仍属于大而不强,大部分制造企业的智能化和信息化程度都比较低,各种统计工作也依赖于人工作业,在中小型机械制造企业尤是如此。目前,大多数企业,一般采用制造执行系统(Manufacturing Execution System,MES)提升生产线的信息化,从而实现生产线升级改造。然而如此一来,不仅生产线升级改造成本大大提升。而且,各个企业生产线状况存在特殊性与差异性,现有的MES系统无法地满足企业生产线的个性化要求。在此背景之下,本文以解决机械加工车间生产线在实际生产中遇到的常见问题为研究目标,以C#、Java作为开发语言,使用数据库、Web Service、Android以及C#Winform等技术,最终开发出了一种切合实际、个性化定制的机械加工车间信息管理系统。该系统实现了以下基本功能:员工信息管理、机床信息管理、工件信息管理、加工过程信息管理、工资自主结算以及各类信息查询功能。即:对于每一件工件从入厂到加工完成的整个过程,利用二维码作为加工工件的唯一标识,结合开发的PC与Android端应用软体实现加工过程实时跟踪,实时记录、显示每个工件的基本信息与加工过程的数据信息;除此之外,实现了QC\IQC、报废、机床状态监控、查看工件的生产加工进度、查看员工的工作状态以及生产统计等各类信息的查询功能。在一系列数据收集的基础之上,可生成统计报表,自动结算工资,使生产过程的所有信息均纳入机械加工车间信息管理系统。机械加工车间信息管理系统主要分为两大部分:客户端与服务器端。客户端包括个人计算机(personal computer,PC)端与Android端,分别包含4款应用软件;服务器端包括数据库服务器、文件服务器以及应用服务器。其中客户端主要负责与工作员工进行交互,获取与显示加工过程中的数据。服务端用于存储数据、存储加工文件以及处理部分事务逻辑给客户端提供数据。本系统中,PC端应用软件采用常见的C/S设计模式,利用Visual Studio 2015作为集成开发环境,C#作为开发语言进行开发。Android端应用软件采用三层分层体系结构,使用Android Studio作为集成开发环境,利用Android移动应用开发技术,进行设计并实现。服务端,采用SQL Server2012作为数据库;应用服务器功能的实现是采用Web Service技术,定义Web Service的服务接口和调用方法,创建Web服务供客户端调用。通过实际的部署测试使用,证明该系统能够提高产线管理效率,使生产过程透明化信息化,从而有效节约成本,提高生产效率。更多还原

【Abstract】 The establishment of a production line management system for small and medium-sized machinery manufacturing enterprises is of great significance to the informationization of manufacturing enterprises and the intelligentization of production,and which is one of the basic conditions to promoting the progress and development of modern industry.However,China’s manufacturing industry is still large but not strong.Most of the manufacturing enterprises are relatively low-level in intelligence and information,and various statistical work also depends on manual operations.This is especially true for small and medium-sized machinery manufacturing enterprises.At present,for most companies,the existing mature MES(Manufacturing Execution System)is generally used to upgrade the production line information and complete the upgrading of the production line.However,in this way,the cost of upgrading the production line is too high.In addition,the production status of each company is unique and different.The existing MES system cannot meet the individual requirements of the production line of the company.Under this background,this paper aims at solving the common problems encountered in the actual production line of machining workshop.A practical and personalized information management system for machining workshop is developed by using C# and Java as the development language,using database,Web Service,Android and C# Winform.The system realizes the following basic functions: employee information management,machine tool information management,work piece information management,processing process information management,wage settlement and all kinds of information query functions.That is: for the whole process of each piece of work from entering the factory to processing,using QR code as the only identification of the workpiece,using the PC and Android application software to realize the real time tracking of the processing process,and thereby realize the goal to record and display the basic information of each workpiece in real time and the data information of the processing process.In addition,the system has realized the QC,IQC,scrap,machine tool condition monitoring,check the workpieceprocessing progress,view the employee’s working status,and other functions and production statistics and other kinds of information query function.On the basis of a series of data collection,statistical reports can be generated to automatically settle wages,so that all the information of the production process can be incorporated into the information management system of the machining workshop.The workshop information management system developed in this paper is mainly divided into two parts: client and server.The client includes the PC side and the Android side,each of which includes four application softwares.The server side includes a database server,a file server,and an application server.Among them,the client is mainly responsible for interacting with the working staff to obtain and display the data during the processing.The server is used to store data,store processing files,and process part of the transaction logic to provide data to the client.In this system,the PC-side application software adopts the common C/S design pattern,uses Visual Studio 2015 as the integrated development environment,and C# as the development language.The Android application software adopts a three-tiered hierarchical architecture,uses Android Studio as an integrated development environment,and uses Android mobile application development technology to design and implement it.The server uses SQL Server 2012 as the database;the application server function is implemented using Web Service technology,defining the Web Service service interface and calling method,so as to create a Web service for the client to call.Through the actual deployment test,it is proved that the system can improve the efficiency of line management and make the production process transparent,thus effectively saving the cost and improving the production efficiency.更多还原