Design and implementation of software management s

Design and implementation of CMT tool software management system

in machining center, tool management is an important task. It not only provides effective technical support for intelligent manufacturing technology system and pdm/erp system, but also lays a technical foundation for the research and development of Networked Virtual Manufacturing Technology in manufacturing industry. It is a key link related to the technical progressiveness, quality reliability, supply cycle and manufacturing cost of processed products

at present, Tianjin qinmeida Industrial Co., Ltd. (hereinafter referred to as CMT) uses more than 600 kinds of cutting tools, 90% of which are imported. The monthly material consumption cost of cutting tools is more than 600000 yuan. The large number and variety of cutting tools bring great inconvenience to the management of cutting tools. Otherwise, it may have a negative impact on patients, ensuring the orderly and smooth production of the production front line, It is necessary to build a system that can quickly query and count the relevant tool parameters. For example, at the beginning of the month, we can roughly calculate which model of cutting tools we need, how much we need, and which manufacturer's products we want to buy according to the production order quantity; It is also necessary to irregularly check whether the inventory is lower than the safety stock, so as to achieve timely purchase

effectively organizing tools is also an important factor affecting the efficiency of machining centers and even flexible manufacturing systems. The existing problems are mainly the following aspects: how to make the access of tools more convenient, how to schedule tools to minimize their exchange times, and how to select and match tools to minimize the preparation time and maximize the utilization rate of tools. In a word, studying the management of tool resources is to use the smallest tool resources to meet the production requirements and minimize the occupation of tool resources

after a lot of research and analysis, the CMT tool software management system uses Visual FoxPro as the development tool to establish a database and construct a DBMS (data management system)

database design

the DBMS of workshop tools must meet the needs and requirements of different users. Here, only the conceptual structure design and safety design in the design process are described in detail

1) at the same time, conceptual structure design

the database is a set of high-end data management system, which can manage the tool list, such as tool drawings and related data, tool inventory, tool demand table, picking information, tool consumption report, user information, tool supplier information, etc. the following is the creation of ERD (entity relationship diagram) related to the database, as shown in Figure 1

Figure 1 overall E-R diagram of tool database

formulate a tool demand table based on the use of tools and the existing inventory, and feed it back to the purchasing department by the tool room. The purchasing department can also browse the tool inventory at any time to see whether the tool is lower than the safety inventory, so as to achieve timely purchase; After the purchased tools arrive at the company, they should go through the warehouse and then go to the tool room, and then be distributed to the site by the tool room. The tool room should use this system to record the warehousing information, return information and collection information; The accounting department can directly count the tool material consumption cost in a certain period of time by using this system; The production technology development department can call the relevant tool data and drawings in the system at will

2) security design

because the system needs to meet the needs of different departments, it needs to be shared. In order to ensure the confidentiality and accuracy of software system data, the data table must be encrypted. Different users can only log in to the working environment of their own work scope in the application software with their own account, access the database through the application software, and refuse other ways to access and rewrite the database. Encrypt the password of the user account to ensure that there is no clear text of the password anywhere

determine the operation permissions of each role on the database table, and then assign roles to users during application. The permissions of roles are shown in Table 1. Table 1 role permission table

role permission the system administrator can add and delete all data tables. The tool demand table of the purchasing department, the tool requisition and consumption table of the accounting department, the tool consumption report, the tool basic data of the development department, and the same parts room collection documents, warehousing documents, receipt documents The CEO of the return document browses all tables

the implementation of the background database

the specific design process includes several steps, such as establishing a database, establishing tables, establishing relationships, and realizing data integrity. The following are introduced respectively:

establishing a database. The name of the database is "tool data". The implementation steps are:

(1) enter the project manager of Visual FoxPro to design the database and change the database data; (2) Name the database, enter the database name and data text, and the company's technicians will answer for you one by one! Location of files and log files; (3) Specify data and log files; (4) Define the size and growth rate of the file

Figure 2 create a database

create a table

create collecting documents, inventory information, grinding tool inventory information, user tables, customer information tables, warehousing documents, etc. in the tool database

Figure 3 Create tool collecting doc

the creation of other tables is similar to this table method, which is omitted

establish the relationship between tables. In the tool database, you can directly create the relationship between tables by index. Figure 4 is the relationship diagram between the repair tool consumption table, tool consumption report, and tool requisition consumption table. You can create other relationships in turn, which is omitted here

Figure 4 Relationship between tool tables

the advantage of establishing a relationship is that the application can read different fields of different tables at the same time, making the attribute description entity more complete

realization of functional requirements, loading data and system operation

Figure 5 operation interface

realization of functional requirements first needs to establish a visual window, and then establish a data display interface and some command buttons on the visual window. The display interface can be any chart and control. The set buttons include: "exit", "add", "Statistics", "query", "delete", "next record", etc, Write the application program under the command button according to the functional requirements. After compilation, it is an independent application tool. You can click different buttons to realize different functions. Figure 5 shows the main operation interface of the system, which loads all data and sub display interfaces, writes applications under the command button, and realizes the display of different data and sub interfaces through the command button. Use the same method to establish visual interfaces for different object-oriented entities. Figure 6 is the window for querying tool drawings and related parameters:

Figure 6 query of tool drawings and related data

with this tool, you can directly find the tool drawings and simple parameters of tools stored in the library. If you want to print the queried drawings, you can double-click the drawings on the window with the mouse and directly connect to AutoCAD for printing

the system loads a large number of internal attribute parameters and physical parameters of the tool, including the CAD drawing of the tool. The application system can call in time according to the user's intention, so as to greatly reduce the processing preparation time, improve the automation level of tool management, and achieve the purpose of rapid query and effective use of tool resources

Tianjin qinmeida Industry Co., Ltd. fan Benjun, Guo Peilong (end)