Technology contents
The invention provides the conforming method and apparatus of a kind of inspection, to overcome inefficiency in the prior art, shortcoming that accuracy is not enough.
For addressing the above problem, the invention provides following technical scheme:
The conforming method of a kind of inspection, it comprises following steps:
Read the printed circuit board (PCB) BOM of examine, and generate first tables of data, described first tables of data comprises each material sequence number and location number;
Read the COM code inventory of circuit theory diagrams, the on-line testing table of PCB, and generate second tables of data, described second tables of data comprises each material sequence number and location number;
Set up association by the material sequence number between described first tabulation and described second tabulation, utilize the Part list table of first and second tables of data comparison circuit plate BOM, schematic diagram and the ICT file of PCB, obtain comparative result.
The conforming device of a kind of inspection, it includes:
Download module is used to read the printed circuit board (PCB) BOM of examine, and generates first tables of data;
Read in module, be used to read the Part list table of circuit theory diagrams, the ICT file of PCB, and generate second tables of data;
The checking comparison module is used for the Partlist table of comparison printed circuit board (PCB) BOM, circuit theory diagrams and the ICT file of PCB;
Output module is used to export comparative result.
The printed circuit board (PCB) BOM that described download module reads current examine generates first tables of data, and the described module of reading in reads the Part list table of circuit theory diagrams, the ICT file of PCB, and generate second tables of data, these tables of data are delivered to described checking comparison module respectively and are compared, obtain comparative result, by described output module output comparative result.
The conforming method and apparatus of a kind of inspection provided by the invention, it can check out the inconsistent problem between printed circuit board (PCB) BOM and circuit theory diagrams, the PCB fast and effectively, solve in the design of printed circuit board (PCB) BOM and how effectively to guarantee circuit theory diagrams, PCB and printed circuit board (PCB) BOM consistency problem, specifically, the present invention mainly contains following advantage:
1), comparative result is accurate, can really locate the consistency problem between printed circuit board (PCB) BOM and circuit theory diagrams, the PCB, the problem classification shows that content is clear, easy, friendly interface, can provide information orientation problem accurately for the personnel of designing and developing;
2), the audit of each version BOM of printed circuit board (PCB) and the audit of engineering change (EC) each time are provided, make things convenient for the designer to the audit of various version, various changes checking;
3), substitute the loaded down with trivial details manpower work that makes mistakes easily by computer, relatively speed fast (in 1 minute) has improved operating efficiency greatly.
Introduce the present invention in detail below in conjunction with description of drawings and embodiment.
Embodiment
After printed board circuit schematic diagram and PCB design are finished, the printed circuit board (PCB) BOM is defined into ERP (Enterprise Resources Planning: Enterprise Resources Plan) system, prepare to walk to file flow process now, then need to verify the consistency of three's data, the embodiment of the invention is used for finishing printed circuit board (PCB) BOM and circuit theory diagrams, the inspection of PCB difference exactly.
Be illustrated in figure 3 as the embodiment of the invention and check the structural representation of conforming device, this device includes:
Printed circuit board (PCB) BOM download module is used to read the printed circuit board (PCB) BOM of examine, and generates corresponding first tables of data;
The ICT file of circuit theory diagrams COM code inventory (Part list) table and PCB reads in module, is used to read the Part list table of circuit theory diagrams, the ICT file of PCB, and generates corresponding second tables of data;
The checking comparison module is used for the Partlist table of comparison printed circuit board (PCB) BOM, circuit theory diagrams and the ICT file of PCB;
Output module is used to export comparative result;
Above-mentioned four modules can realize that with the Delphi exploitation, in the operation of Windows interface, dynamic link library (DLL) directly is cured in the program, need not install fully by program.
As shown in Figure 4, the conforming method of the described a kind of inspection of the embodiment of the invention, its specific implementation method is as follows:
The first, read the printed circuit board (PCB) BOM of examine, and generate corresponding first tables of data;
Printed circuit board (PCB) BOM download module is by the server client connection mode, read the printed circuit board (PCB) BOM of certain version according to the time period of engineering change (EC), be that it downloads the printed circuit board (PCB) BOM from ERP system, suppose the file by name 03023333 of current version, and generate corresponding first tables of data, as shown in Figure 5, first tables of data of printed circuit board (PCB) BOM is that a location number and corresponding Part deposit in same the record.
This moment, the user determined whole checkings, promptly the Part list table of printed circuit board (PCB) BOM, circuit theory diagrams and the ICT file of PCB was all compared.
The second, read the Part list table of circuit theory diagrams, the ICT file of PCB, and generate corresponding second tables of data;
The ICT file of circuit theory diagrams Part list/PCB reads in the characteristics of module according to file type, and by different file suffixes, the file suffixes of showing as circuit theory diagrams Part list is ' .lst ' or ' .bom '; The file suffixes of the ICT file of PCB is ' .asc ' or ' .val ', judge that current file reads in type and form, the file of current circuit theory diagrams Part list table is SS62TST.lst, the file of the ICT file of PCB is SS62TST.val, deposit in after reading in the second corresponding tables of data, the Part list table of these circuit theory diagrams, the printed circuit board (PCB) BOM, its data message divides two tables to deposit, tables of data 1 is to deposit the quantity of Part (COM code), encapsulation etc. are man-to-man data messages with Part, tables of data 2 is to deposit Part and is the location number information (i.e. corresponding a plurality of location numbers of part) of many-one relationship with Part, two tables are set up related with item no (sequence number) and part, as shown in Figure 5; ICT file table for PCB, data message leaves in the tables of data, is the encapsulation of a location number and location number correspondence is deposited as a record, as shown in Figure 6, again by each location number to encapsulation, Part compares, thereby compare the difference under the various situations.
The idiographic flow that circuit theory diagrams Part list table reads in is as shown in Figure 7: the select File suffix is the Part list file of ' .lst ' or ' .bom ', check file format, correct format then reads in the intermediate data table to Item no, Part in the Partlist file, encapsulation, Quantity (usage quantity), location number, and then Item no, Part, encapsulation and Quantity information in the intermediate data table read in tables of data 1, Item no, Part and location number information are read in tables of data 2;
The idiographic flow that the ICT of PCB table reads in is as shown in Figure 8: the select File suffix is the ICT file of ' .asc ' or ' .val ' PCB, checks file format, and correct format then reads in tables of data to the encapsulation in the ICT file of PCB, location number information;
Three, compare the Partlist table of printed circuit board (PCB) BOM, circuit theory diagrams and the ICT file of PCB by its tables of data, obtain comparative result;
The checking comparison module is at first searched more once the device link position in the printed circuit board (PCB) BOM, if whether relatively encapsulating again of identical link position be consistent; And then the device link position in the ICT file of the PartList of circuit theory diagrams or PCB searched more once; Record difference relatively, all relatively finishing then shows.The specific implementation method as shown in Figure 9;
C1, find out the device link position of printed circuit board (PCB) BOM in the ICT of the Part of circuit theory diagrams list and/or PCB file, if there is this device link position, then relatively whether its encapsulation is consistent; If there is no this device link position then finds out non-existent device link position in the ICT of the Part of circuit theory diagrams list and/or PCB file;
The ICT file of c2, the Part list that finds out circuit theory diagrams and/or PCB non-existent device link position in the printed circuit board (PCB) BOM;
C3, record comparative result.
The key of this step is to choose the benchmark comparison other: the device link position of promptly at first choosing in the printed circuit board (PCB) BOM is that benchmark compares, and then the device link position in the ICT file of the Partlist table of selection circuit theory diagrams or PCB is that benchmark compares; And on the implementation method be: find out earlier that the printed circuit board (PCB) BOM exists and non-existent device link position number in the ICT of the Part of circuit theory diagrams list and/or PCB file, secondly the pairing encapsulation situation of device link position that exists is compared; And then search the Part list of circuit theory diagrams and/or ICT file non-existent device link position in the printed circuit board (PCB) BOM of PCB; Export diversity ratio result at last.
Four, comparative result is exported.
As shown in figure 10, output module shows the result according to following classification output:
1. the device link position is not on the circuit theory diagrams and on the printed circuit board (PCB) BOM;
2. the device link position is not on the printed circuit board (PCB) BOM and on circuit theory diagrams;
3. circuit theory diagrams are consistent with the device link position in the printed circuit board (PCB) BOM, and corresponding encapsulation is inconsistent;
4. the device link position is not on the PCB and on the printed circuit board (PCB) BOM;
5. the device link position is at the printed circuit board (PCB) BOM and no longer on the PCB;
6.PCB consistent with the device link position in the printed circuit board (PCB) BOM, corresponding encapsulation is inconsistent.
Be the output result of present embodiment below:
Wherein, board B OM is described printed circuit board (PCB) BOM, and schematic diagram BOM is described circuit theory diagrams Part list table.
Make amendment at last according to difference results orientation problem relatively, and to the BOM/PCB of printed circuit board (PCB).
Utilize method and apparatus of the present invention, can check out the inconsistent problem between printed circuit board (PCB) BOM and PCB, the circuit theory diagrams fast and effectively, solve in the design of printed circuit board (PCB) BOM how effectively to guarantee circuit theory diagrams, PCB and printed circuit board (PCB) BOM consistency problem, specifically its advantage is meant:
1) comparative result is accurate, can really locate the consistency problem between printed circuit board (PCB) BOM and circuit theory diagrams, the PCB, and the problem classification shows that content is clear, easy, friendly interface, can provide information orientation problem accurately for the personnel of designing and developing;
2) provide the audit of each version BOM of printed circuit board (PCB) and the audit of engineering change (EC) each time, make things convenient for the audit checking of designer various version, various changes;
3) the method appliance computer can be finished, substitute the loaded down with trivial details manpower work that makes mistakes easily, relatively speed fast (in 1 minute) is increased work efficiency greatly.