TWI475499B - Tackle modify management system and management method using the same - Google Patents

Description

Fixture design change management system and management method thereof

The invention relates to a fixture design change management system and a management method thereof, in particular to a system and a management method for design change management of a fixture by using a database management software.

For enterprises, especially manufacturing enterprises, how to properly and effectively manage various fixtures such as size inspection, positioning, preloading, etc. used in production is particularly important. The effective management of fixtures is related to the production of enterprises. Efficiency and increase in corporate profits. The design change of fixtures is an important part of the management of fixtures. The fixture design change refers to the recovery of the fixture that the enterprise will put into production due to the change of the production product or specification, and then the size or specification of the fixture is corrected on the basis of the fixture, or the design is redesigned to meet the requirements. The new fixture will replace the parameters of the new fixture that meet the product with the original fixture data.

The conventional fixture design change method is generally: the control number, name, specification model, resume, change record, license record, verification record, user, storage location, user unit, management responsible person, etc. The data is stored in a file that is created. When a design change is required, the relevant personnel can check one or more sets of fixtures from a file to a certain control number that needs to be changed, and then fill in the application form to change, and the supervisor completes the application form. After the audit, the relevant responsible person will retrieve the fixture to be changed from the scene. After changing or re-manufacturing a new fixture, the changed fixture parameters are stored in the file, and the changed fixture is put into production. However, when there are a large number of identical fixtures that need to be changed, since multiple sets of fixtures are usually scattered in a plurality of different factories or different workshops, the above method may miss a set of fixtures that have not been changed, and affect the later use and production. Moreover, this method is likely to affect the speed of design changes due to delays in the sign-off process, and the efficiency is low.

In view of this, it is necessary to provide a system and a management method thereof that can efficiently and accurately complete the design change management of the jig.

A fixture design change management system for implementing design change management of a fixture, the fixture design change management system includes a database, wherein the fixture basic information and a fixture detection report data, the fixture detection report The data includes a plurality of fixture electronic file detection reports; a server, comprising: a design change application module for generating a design change application form, and issuing a design change request, the design change application form including the fixture control to be changed Numbering and change information; a change processing module for extracting the fixture control number, change information and corresponding staff information to be changed in the database according to the received change request, and comparing the design after the design change is completed Whether the change information of the application for changing the application module is consistent with the corresponding change information of the fixture to be changed stored in the database, to determine whether the fixture to be changed in the database is changed, and a mail generation and transmission module for transmitting E-mail to the corresponding staff to inform the corresponding staff to work as soon as possible; a report entry module for Entering the modified electronic file detection report of the fixture; and a plurality of client computers, the database and the plurality of client computers are connected to the server, and the server extracts the data in the database and implements the design change application, The server triggers the mail generation and transmission module to send Sending the mail and reminding the corresponding staff to sign the change request, the plurality of client computers are used for the corresponding staff to sign the change request and control the change application process.

A method for performing fixture design change management using the fixture design change management system, comprising the steps of: generating a design change application form, and initiating a design change request, wherein the design change application form includes a fixture control number to be changed and Change the information; process the change request to extract the fixture control number, change information and corresponding staff information to be changed; send an email to the corresponding staff and remind the corresponding staff to complete the change process; The fixture electronic report inspection report; and whether the information in the change application form and the information of the plurality of fixtures to be changed stored in the database are consistent, to determine whether all fixtures to be changed in the database have completed the design change.

Compared with the prior art, the jig design change management system reminds and reminds the relevant personnel to complete the sign-off process in the form of mail, so that the jig can be changed as soon as possible after the sign-off process is completed, and the efficiency is high. In addition, the fixture design change management system can also detect fixtures that have not completed design changes in multiple sets of fixtures with the same control number, effectively preventing omissions and having high accuracy.

10‧‧‧ computer

20‧‧‧Network

30‧‧‧Server

301‧‧‧Design Change Request Module

303‧‧‧Change Processing Module

305‧‧‧Mail Generation and Transfer Module

307‧‧‧Report Entry Module

40‧‧‧Database

1 is a hardware structure diagram of a fixture design change management system of the present invention.

2 is a diagram showing a server function module of the jig design change management system of the present invention.

3 is a flow chart of the design change management of the jig of the present invention.

Referring to FIG. 1 together, the fixture design change management system of the present invention includes a plurality of client computers 10, a plurality of networks 20, a server 30, and a database 40. The several uses The client computer 10 and the database 40 are respectively connected to the server 30 via the network 20. The network 20 is connected to an intranet, and may also be an Internet or other type of communication network. The client computer 10 is distributed among various management departments within the enterprise for use by the relevant responsible persons, and each client computer 10 is installed with a Lotus Notes platform. The server 30 is used to control the entire process of implementing the fixture design change. The database 40 stores the basic information of the jig and the test report data of the jig. The basic information of the jig includes the control number, name, specification model, resume, change record, license record, verification record, user, storage location, user unit, management responsibility person, etc. of the fixture. The fixture detection report data includes a plurality of fixture electronic file detection reports, and the fixture electronic file detection report records parameters to be controlled by the fixture, such as the length, width and diameter of the fixture, and the recorded projects include such items. The control size, nominal size, upper deviation and lower deviation of the parameters and the measured values of the parameters, etc., respectively generate a fixture electronic report detection report for each fixture.

Please refer to the functional module diagram of the server 30 of the preferred embodiment of the jig design change management system of the present invention shown in FIG. The server 30 includes a design change request module 301, a change processing module 303, a mail generation and transfer module 305, and a report entry module 307.

The design change request module 301 can generate a design change request form for applying for design changes to the corresponding fixture. The manager fills in the control number of the fixture and the information to be changed in the corresponding field of the application form, and fills in the handling opinions of the fixture. If the change, scrapping, no change, etc., the form can be completed and the form will be completed. The application form is sent to the change processing module. If a control number corresponds to multiple sets of fixtures with the same specifications and need to be designed and changed, the management personnel must fill in the treatment opinions for all fixtures before completing the design change request, effectively preventing the omission of a pending change. With.

The change processing module 303 is configured to process the application submitted by the design change request module 301. After receiving the change request for the fixture of a certain control number sent by the design change request module 301, the change processing module 303 extracts the information of the corresponding control number fixture in the database 40, if the database If there is no fixture with corresponding control number in 40, the fixture control number may be incorrect or the fixture is not included in the database 40, and the change processing module 303 will return the application for the design change application module 301; The fixture 40 has a fixture corresponding to the control number, and the change processing module 303 will retrieve the user, the person in charge of the fixture, and the supervisor who needs to sign the fixture design change from the database 40. The method is sent to the mail generating and transmitting module 305 to trigger the sending of the mail to remind the relevant personnel to process in time. After the design change is completed, the change processing module 303 can also compare the change information provided by the design change request module 301 with the corresponding information of the same control number fixture in the database 40, if the same control number in the database 40 The corresponding information of the multiple sets of jigs is consistent with the information of the application change, indicating that the sets of jigs have been changed. If the information of one or several sets of jigs of the same control number is inconsistent with the information of the application change, the sets of jigs have not been changed. Then, the change processing module 303 captures the relevant personnel information corresponding to the unmodified fixture, and sends the information to the mail generation and transmission module 305 to trigger the information to notify the relevant management personnel to complete the design change of the fixture to be changed as soon as possible. .

The mail generation and transmission module 305 is configured to notify the relevant responsible person to perform a design change operation. After receiving the trigger information of the change processing module 303, the mail generating and transmitting module 305 will automatically notify the relevant personnel of the jig change as soon as possible by e-mail: if the relevant supervisor is notified to complete the signing and notification process as soon as possible The user, the responsible person of the custody and the manager of the jig will complete the handover and change of the jig as soon as possible after the completion of the signing of the supervisor. If some of the plurality of sets of jigs of the same control number are not changed, the mail generating and transmitting module 305 receives the trigger information of the change processing module 303. The relevant personnel will be notified to make a design change request in order to complete the design change of the fixture as soon as possible. In this process, if the relevant person notified by the email confirms the processing of the mail, the mail generating and transmitting module 305 will stop sending the mail to the confirmed; otherwise, the mail generating and transmitting module 305 will press the set time interval. Follow the reminders.

The report entry module 307 is configured to record and store the electronic test report of the modified jig in the database 40, so that the change processing module 303 can detect the report data according to the electronic file of the fixture of the database 40. The change information submitted by the design change request module 301 is compared to determine whether the jig stored in the database 40 has been changed.

Referring to FIG. 3 together, the method for designing change management of the fixture includes the following steps:

S101: Initiating a design change request. Specifically, the design change request module 301 generates a design change application form, and inputs the control number and the change information of the fixture to be changed (such as the size of the fixture after the fixture is changed) in the corresponding field in the design change request form, and fills in If there is a change in the design of the fixture, if there are multiple fixtures that need to be changed at the same time, the change request can be submitted before the change request can be submitted.

S102: Process the change request. Specifically, the change processing module 303 searches for the jig in the database 40 by the control number. If the jig corresponding to the control number is not retrieved in the database 40, the process returns to step S101; if the corresponding control number is detected, Then, the relevant responsible person data of the grabbing jig is sent to the mail generating and transmitting module 305 to trigger the mail generating and transmitting module 305.

S103: Send an email to the relevant person in charge to remind him to complete the change process as soon as possible. The mail generating and transmitting module 305 receives the trigger signal of the change processing module 303. After that, the person in charge will be sent an email and reminder. If it is detected that the mail has not been processed and confirmed, the relevant person in charge will be detected according to the set time until it completes the processing confirmation.

S104: The fixture is changed, and the changed fixture electronic file detection report is entered and stored in the database 40. After the completion of the sign-off process, the relevant responsible person implements the change of the jig, and stores the changed jig electronic file test report in the database 40 to replace the original data.

S105: The change processing module 303 compares whether the information in the change request form matches the correspondence information of the jig of the same control number in the database 40. If the sets of jigs of the same control number in the database 40 match the information of the application change, it means that all the jigs for the application change have been changed, that is, the design change of the jig is completed. If some sets of jigs of the same control number in the database 40 do not match the information of the application change, it means that several sets of jigs of the application change have not been changed, and the change processing module 303 will trigger the generation and transmission of the mail. The module 305 sends an email to the relevant person in charge to remind him to initiate a design change request, and then returns to step S101.

10‧‧‧ computer

20‧‧‧Network

30‧‧‧Server

40‧‧‧Database

Claims (6)

A fixture design change management system for implementing design change management of a fixture, the improvement being: the fixture design change management system comprises: a database, wherein the storage fixture basic information and the fixture detection report data, The fixture detection report data includes a plurality of fixture electronic file detection reports; a server includes: a design change application module for generating a design change application form, and issuing a design change request, wherein the design change application form includes a pending change request form Fixture control number and change information; a change processing module for extracting the fixture control number, change information and corresponding staff information to be changed in the database according to the received change request, and completing the design change Whether the change information of the design change request module application is consistent with the corresponding change information of the fixture to be changed stored in the database, to determine whether the fixture to be changed in the database is changed or not; a mail generation and transmission module , to send an email to the corresponding staff to inform the corresponding staff to work as soon as possible; a report The module is configured to input the changed electronic document detection report of the fixture; and the plurality of client computers, wherein the database and the plurality of client computers are connected to the server, and the server extracts the data in the database and implements The design change request, the server triggers the mail generation and transmission module to send an email and prompts the corresponding staff to sign the change request, and the plurality of client computers are used for the corresponding staff to sign the change request and control the change application process. The jig design change management system according to claim 1, wherein the design change application module simultaneously submits a design change request to a plurality of sets of jigs having the same specifications. The fixture design change management system described in claim 1, wherein the change processing The module detects the change of the same set of fixtures in the database, and reminds the corresponding staff who have not changed the fixture to apply for the change as soon as possible by email. A method for performing fixture design change management using the fixture design change management system described in claim 1 of the patent application scope, comprising the steps of: generating a design change application form, and initiating a design change request, wherein the design change request form includes The fixture control number and change information to be changed; processing the change request to extract the fixture control number to be changed, the change information and the corresponding staff information; send an email to the corresponding staff member and remind the corresponding staff member Complete the change process; enter the changed electronic test report of the fixture; and compare the information in the change request form with the information of the complex fixtures stored in the database to determine whether all the fixtures need to be changed in the database. Whether the design changes have been completed. For example, the method for designing change management of the jig according to item 4 of the patent application scope, wherein if the change processing module judges that all the jigs in the database have been changed, the jig design change is completed; if the change processing module judges the data The jig to be changed in the library will trigger the mail generation and transmission module to send an e-mail to remind the relevant personnel to submit a design change request. The method for designing a change management of the jig according to item 4 of the patent application scope, wherein in the step of initiating a design change request by the design change request module, when there are multiple jigs to be simultaneously changed, all the items are simultaneously given The design change request can be completed by changing the fixture.