CN101414319B

CN101414319B - Method for automatically identifying positive and negative sides part of mainboard parts list

Info

Publication number: CN101414319B
Application number: CN2008101753671A
Authority: CN
Inventors: 吴锋
Original assignee: Shenzhen HASEE Computer Co Ltd
Current assignee: Kunshan Shenzhou Computer Co., Ltd.
Priority date: 2008-11-07
Filing date: 2008-11-07
Publication date: 2011-03-23
Anticipated expiration: 2028-11-07
Also published as: CN101414319A

Abstract

The invention provides a method for automatically marking the front and back parts in a motherboard part list; operation is carried out on an EXCEL form by a VC program language; a part on the back surface of a PCB is read by combining the form automatically generated by Allegro software, the part is compared with the part form and marked, thus omitting the fussy steps of manually carrying out front and back marking on the parts and ensuring the accuracy of the marking.

Description

The method of pros and cons part in a kind of Automatic Logos mainboard parts list

Technical field

The present invention relates to the making of mainboard parts list, in particular, relate to the method for pros and cons part in a kind of Automatic Logos mainboard parts list.

Background technology

PCB need finish the making and the layout part of schematic diagram in the design phase, after finishing, layout can form a PCB data, can generate a form according to this part PCB data automatically by Allegro software and (can be described as the BOM table, as shown in Figure 1), the item of each part on the pcb board and indicate that this part is in the pcb board front or reverse side (show NO be reverse side) is arranged in this form.

For cooperating production, BOM table slip-stick artist will make a parts list (as shown in Figure 2) by hand according to circuit theory diagrams, can write down the item number of each part, the position that re-packs, description etc. in the table.For guaranteeing smooth production, need indicate that also part is front or the reverse side of beating at pcb board.Because part is numerous on the mainboard, only depend on the manual positive and negative sign that part is re-packed to record one by one in the parts list, not only lose time, resource, and as easy as rolling off a log makeing mistakes.

Summary of the invention

The technical problem to be solved in the present invention is, at the above-mentioned defective of prior art, provides the method for pros and cons part in a kind of Automatic Logos mainboard parts list.

The technical scheme that its technical matters of solution of the present invention is adopted is: construct the method for pros and cons part in a kind of Automatic Logos mainboard parts list, by the VC program language Microsoft Excel is operated, comprise following steps:

Step 1: the path that obtains BOM table and parts list by the method for calling the CFileDialog class respectively;

Step 2: according to object SS1, the SS2 of the newly-built CSpreadSheet class in path that step 1 obtains, represent the BOM table with SS1, SS2 represents parts list;

Step 3: judging whether form is up to specification, not, then eject the information that reports an error, is then to continue;

Step 4: choose that the SYM_MIRROR value is the part of NO in SS1 table (BOM table) Part Reference row, be combined into a big character string, i.e. the object SS1PARTSUM of a CString class, and as next step storehouse that will search for;

Step 5: choose in the SS2 table (parts list) each line character string in DES row, in the SS1PARTSUM storehouse, search for successively and whether exist, and do respective handling;

Step 6: at last the SS2 table of having handled (parts list) is preserved Hui Yuanbiao in internal memory.

What pay particular attention in step 5 is that some cell may comprise a plurality of parts in the DES row, so need cut apart it, respectively each part is searched for.

Processing mode can be set according to the requirement of oneself by the user, becomes black matrix italic or underscore etc. as the part mark that in parts list the mainboard back side is used.

Implement the present invention and carry out the making of mainboard parts list, has following beneficial effect: by the form that generates automatically in conjunction with Allegro software, read the part of beating at the PCB reverse side, itself and parts list are done contrast and sign, save manual loaded down with trivial details step of carrying out part pros and cons mark, also guaranteed the correctness of sign.

Description of drawings

The invention will be further described below in conjunction with drawings and Examples, in the accompanying drawing:

Fig. 1 is the local figure of BOM table that Allegro software generates;

Fig. 2 is the local figure of BOM table slip-stick artist home built parts list;

Fig. 3 is a workflow diagram of the present invention;

Fig. 4 is that scheme the part pros and cons sign parts list part that has of implementing to generate behind the present invention.

Embodiment

As shown in Figure 1, BOM table is the PCB data that produces finishing according to layout after, is generated automatically by Allegro software, comprises " Part Reference " and " SYM_MIRROR " two and is listed as.The item of part is shown in " Part Reference " tabulation; " SYM_MIRROR " tabulation shows that part beats at pcb board front or reverse side, and " YES " expression is beaten in the front, and " NO " represents to beat at reverse side.

As shown in Figure 2, parts list is that BOM table slip-stick artist carries out home built according to circuit theory diagrams, according to making standard separately and requiring that some row are arranged respectively, wherein mainly contain the number of plies " level " row (which layer expression is used in), item number " HASEEP/N " row (expression part material item number), the position that re-packs " DES " row (expression part re-pack position), part is described " Description " row (carrying out the description to part) etc.

As shown in Figure 3, realize that concrete steps of the present invention are as follows:

Step 2: BOM table and parts list are indicated again,, represent that with SS1 BOM table, SS2 represent parts list according to object SS1, the SS2 of the newly-built CSpreadSheet class in path that step 1 obtains;

Step 3: judging form whether (whether having tableau format etc. as the row that will compare) up to specification, not, then eject the information that reports an error, is then to continue;

Step 5: choose in the SS2 table (parts list) each line character string in DES row, in the SS1PARTSUM storehouse, search for successively and whether exist, and do respective handling.What pay particular attention to here is that some cell may comprise a plurality of parts in the DES row, so need cut apart it, respectively each part is searched for.Processing mode can be set according to the requirement of oneself by the user, becomes black matrix italic or underscore etc. as the part mark that in parts list the mainboard back side is used;

As shown in Figure 4, the parts list that generates behind enforcement the present invention, its item of part of beating at the pcb board back side is designated the black matrix italic.

Claims

1. the method for pros and cons part in the Automatic Logos mainboard parts list is operated Microsoft Excel by the VC program language, it is characterized in that, comprises following steps:

2. the method for pros and cons part is characterized in that in a kind of Automatic Logos mainboard parts list according to claim 1, and some cell comprises a plurality of parts in the DES row, need cut apart it, respectively each part is searched for.

3. the method for pros and cons part is characterized in that in a kind of Automatic Logos mainboard parts list according to claim 1, and processing mode can be set according to the requirement of oneself by the user.