The key technology of function design and implemen

  • Detail

The main goal of the system is to integrate all products and production process management information of the enterprise, eliminate the information islands of workshops and departments, and increase the sharing and integrity of information. The whole system takes the product as the center to set various functions, which is convenient for the monitoring and management of the whole process of product production

2 design and description of main functions of the system

2.1 drawing document management subsystem

drawing document (hereinafter referred to as drawing document) refers to engineering technical drawings and technical data. Drawing document management is an important part of PDM system

drawing documents can be divided into two categories: customer product drawing documents and internal process tooling drawings and technical data of foundry enterprises. These drawings and documents are divided into paper and electronic drawings, but at present, they are mainly focused on biological thermoplastic high molecular material documents. The drawing document information is mainly used by the design department and the production department. The author once learned from a small and medium-sized foundry enterprise which has been established for less than 10 years that they have saved more than 2000 drawings and technical data, and they do not have a special management system, so they feel very inconvenient to find and use. Therefore, the graph document management function is very necessary

2.1.1 the main information of the drawing document

can include the drawing document identification number, product number, drawing number, product name, material, trademark, weight, type, format, drawing quality type, storage location, number of copies, number on hand, production date, user number, etc. The "drawing document identification number" is used for internal management of the system and cannot be repeated in the system. "Product number" is the code generated by the enterprise according to product category and serial number. You can enter "drawing number" directly for the drawing, and "document number" for the document. "User number" can be extracted from CRM system material certification: ROHS certification, UL yellow card certification, CQC certification system (if small and medium-sized foundry enterprises do not have a CRM system, you can also directly enter the user name). "Type" refers to whether the drawing document is directly related to the product or the drawing document within the production enterprise. "Image quality type" refers to whether it is paper or electronic

2.1.2 paper map document management

the information management function of paper map documents is mainly used by documenters. In order to facilitate its storage and borrowing services. The "storage location" is a code corresponding to the room number, cabinet number, cabinet floor number and grid number of the reference room. "Number of copies" refers to the total number of copies. "Amount on hand" refers to the amount that has not been lent. In addition, the module should also include a map document borrowing registration and query management function

2.1.3 electronic drawing document management

the main function of this module is to upload and download drawing documents in the internal network environment of the enterprise. The "format" of drawing documents is generally unified within the enterprise, but customers (especially in different places) may provide a wide variety of drawings, which may be developed by AutoCAD, pro/e, UG and other drawing software. "Storage location" refers to the directory on the system server (URL in the system). Different formats and types of drawing documents are placed in different directories. After the user passes the system authentication, it is allowed to download. There are two situations for uploading drawing documents: newly designed (drawn) or written drawing documents; And the revised drawing documents (mainly process tooling drawings and technical data). The drawing documents can only be uploaded to the Engineer in charge. After review, it is uploaded to the corresponding directories of production drawing documents. All upload and download operations of users are prompted on the page

2.2 product proportioning management

users extract casting alloy type, brand, batch and other information through the product attribute data management subsystem. The raw material technical index information is extracted through the purchase management module of ERP for batching (if the enterprise has not established an ERP system, the corresponding data management module should be established in this system). Users can use the linear programming method to obtain the formula with the lowest cost for batching. The formula of core sand is input by the product process management personnel, and the material consumption data is input into the system by the sand treatment department, melting department and other relevant departments

through this subsystem, users can count the raw material consumption data of the whole plant in each time period, which can be used by the ERP cost management module, and also generate BOM data for the ERP production planning module

2.3 product production process management

if the material and brand of castings are different, the production process is different. Such as ordinary gray cast iron, nodular cast iron, cast steel or non-ferrous alloy, their production processes are very different, and even the melting equipment is different. Even if the material and brand are the same, the casting structure is different, the technical requirements of users are different, and the production process is also different. For example, for castings with the same gray iron HT200 brand, for products with complex structure and high requirements for surface quality and dimensional accuracy, resin sand mold and core production may be used, and even special casting methods such as investment casting may be used; The general medium and small gray iron castings are produced with low production cost wet clay sand (in order to cooperate with the production line, resin sand cores may be used). Therefore, in this system, there should be clear production process and production method information for each casting product. The factory can input the production process flow and relevant process data of each product that has been formulated and passed the review into the system. Especially for small and medium-sized casting enterprises, each casting has a clear production process flow, which is convenient for on-site quality monitoring, and will not cause confusion in production. The relevant data are entered by the technical department and can be used by the workshop production and quality supervision departments

2.4 tooling and mold management

tooling of foundry enterprises is public and special. For example, sand boxes are mostly public, and core boxes are mostly private. The subsystem can be divided into two parts: tooling and die design management and tooling and die use management. The former mainly manages the tooling and die design process. For the use and management of tooling, due to the different structure of each casting product, most tooling is basically dedicated. Some castings also have multiple sets of core boxes, so they must be used in complete sets. The information of tooling can include product number, product drawing number, tooling drawing number, tooling name, status, storage location, specification, manufacturing date, production date, etc. For public tooling, enter the tooling drawing number in the "product number" column. Among them, "specification" mainly refers to public tooling, such as sand box size, etc. "Status" means that the tooling is currently available, sent for repair, to be repaired, scrapped, etc. Some of the information can be extracted from the drawing document management subsystem, and other information is entered into the system by the tooling management personnel. When the production workshop needs relevant casting product tooling, the management personnel can use the "product number" as the index to retrieve all tooling and die information related to the product, including storage location, status and other information. For professional casting enterprises, there are many tooling and dies, and the tooling and die management function is also essential

3 system operation environment

the system can run in b/s mode in the local area network within the enterprise. This is convenient for system maintenance, because all programs are installed on the server. As long as the client computer has a browser installed and has a legal account, it can easily use the system

3.1 selection of web server

the web server of the system can be selected according to the specific situation. If the number of concurrent users of the system is not particularly large, and the J2EE environment is adopted for development, free open-source Web servers such as tomcat, resin or JBoss can be selected, which can save money. For the case of large number of concurrent users (large enterprises), large commercial web servers such as Weblogic or WebSphere can be considered (but it requires tens of thousands of dollars of investment). For adoption Net environment, the system can directly use the Ⅱ s of windows server and the necessary plug-ins

3.2 selection of database management system

for super large systems, Oracle, DB2, Sybase, MS SQL Server 2005 and other database management systems can be selected; Generally, open source database management systems such as MySQL can be selected for small and medium-sized systems, which can meet the needs and save money

3.3 selection of development tools

at present, the mainstream web application development tools are Java of Sun company and Microsoft company, which can be used to develop systems that meet user requirements. The main difference between the two is that the former has the ability to cross server operating system platforms, while the latter can only run under Windows operating system. It can be decided according to which kind of developers are more familiar with

4 key technology of system implementation

now take eclipse+myeclipse as the integrated development environment (IDE) of J2EE system development, resin 3.0.25 as the web server, SQL Server2000 as the background database as an example to illustrate the key technology of system implementation

4.1 system architecture

a few years ago, jsp+javabean and some servlets were generally used to develop java web projects. It mixes business logic and presentation layer, which is very unfavorable for the development and maintenance of large projects. The current popular J2EE application architecture is struts+spring+hibernate (the author once integrated Struts2 and EJB3 into a new framework, dropping hibernate and spring). Struts2 is an extensible and excellent MVC (model view controller) framework. At present, the latest version is 2.1.2. It has strutsl X, and has all the functions of webwork. It divides the system into three layers, M is the model layer, V is the presentation layer of user interaction, and C is the business logic management layer. Each layer only focuses on its own business, reducing the coupling between layers. This facilitates the development and maintenance of the system. Among the new architectures integrated by the above three architectures, hibernate is a data persistence architecture, which is responsible for extracting records from the database to the data model, or persisting the data in the data model to the database. Spring is responsible for business logic management and database connection management. It belongs to the control layer. Its is to call the appropriate action bean or other JavaBeans to execute the relevant business logic at the appropriate time. In the presentation layer, extremecomponents and FCKeditor plug-in are used to cooperate with struts2se. The former is used to display recordsets, which has paging and dataset export functions, and the interface is relatively beautiful; The latter is used for text dynamics in pages. After configuring the above three frameworks and related plug-ins under eclipse, you can carry out development. After successful development and debugging, it can be deployed to resin

4.2 application of filter technology

when the user logs in, the system saves the user ID, user role or permission level of the legal user to the session. When the user accesses some sensitive modules (such as the download of figure and document), the filter technology can be applied to protect the business secrets of the enterprise (although the main operations are recorded in the system log, it can only be checked after the event). Using filters can directly deny illegal users access to sensitive modules. The filter is essentially a special servlet, which must be configured in the L file when it is deployed to the web server. When the system starts, it always monitors all URLs accessed by users in the server (it will work until the web server is shut down). When a user accesses some sensitive modules, it first checks the user permission information in the session. If it encounters illegal users (including users with insufficient permissions), it refuses to pass the link

4.3 integration with other management information systems


Copyright © 2011 JIN SHI