A PCB component information comparison method, device, terminal and storage medium
By constructing a coordinate file comparison table, the increase or decrease of components in the PCB file is determined, which solves the problem of BOM error caused by designers' inability to know the increase or decrease of components, and achieves the accuracy of BOM.
Patent Information
- Application Number
- CN202111136836.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-27
- Publication Date
- 2024-12-03
- Estimated Expiration
- 2041-09-27
AI Technical Summary
In PCB design, designers cannot know which components need to be added or deleted, which makes it impossible to reflect in the schematic diagram, which in turn leads to the problem of missing components in the BOM production.
By obtaining the PCB files before and after the modified board, constructing a coordinate file comparison table to determine the increase or decrease of components, so as to promptly understand the changes of components and avoid BOM production errors.
Effectively determine the increase or decrease of components before and after the board modification, avoid errors during BOM production, and ensure the accuracy of the bill of materials.
Smart Images

Figure CN113836843B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of information comparison, and in particular to a PCB component information comparison method, device, terminal and storage medium. Background Art
[0002] Currently, when designing a single-sided PCB (printed circuit board), some non-registered components are added or deleted by the designer. These components are not included in the schematic diagram. Because in the schematic design stage, these components are manually added or deleted when the PCB design is modified, and the designer has no way of knowing which components will need to be added or deleted on which network. Therefore, the designer has no way to reflect the added or deleted components in the schematic diagram. The BOM (bill of materials) is derived from the schematic diagram, which will cause components to be omitted or deleted from the BOM, resulting in errors in BOM production.
[0003] Therefore, the prior art still needs to be improved and enhanced. Summary of the invention
[0004] The technical problem to be solved by the present invention is that, in view of the above-mentioned defects of the prior art, a PCB component information comparison method, device, terminal and storage medium are provided, aiming to solve the problem in the prior art that the designer cannot know which components to add or reduce and cannot reflect the added or reduced components in the schematic diagram, thus causing errors in BOM production.
[0005] In order to solve the above technical problems, the technical solution adopted by the present invention is as follows:
[0006] In a first aspect, the present invention provides a PCB component information comparison method, wherein the method comprises:
[0007] Obtaining a PCB file before and after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified;
[0008] Constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file;
[0009] According to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification are determined.
[0010] In one implementation, the step of obtaining a PCB file before and after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification includes:
[0011] Acquire the PCB file before the board is modified, and derive the first coordinate file from the PCB file before the board is modified;
[0012] The modified PCB file is obtained, and the second coordinate file is derived from the modified PCB file.
[0013] In one implementation, constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file includes:
[0014] Calling and matching the data in the first coordinate file and the data in the second coordinate file in sequence, and filling the data obtained by calling and matching into a blank table to obtain a first table;
[0015] The data in the second coordinate file and the data in the first coordinate file are called and matched in sequence, and the data obtained by the calling and matching are filled into the first table to obtain the coordinate file comparison table.
[0016] In one implementation, calling and matching the data in the first coordinate file and the second coordinate file in sequence, and filling the data obtained by calling and matching into a blank table to obtain a first table, includes:
[0017] According to a preset first function, the second column of data in the first coordinate file is called, and the second column of data in the called first coordinate file is filled into the first column of the blank table;
[0018] According to a preset second function, searching for a plurality of columns of matching data in the first coordinate file, and sequentially filling the plurality of columns of matching data from the first coordinate file into the blank table;
[0019] According to the second column of data in the first coordinate file, the second function is used to find a plurality of matching columns of data in the second coordinate file, and the plurality of matching columns of data from the second coordinate file are sequentially filled into the blank table to obtain the first table.
[0020] In one implementation, calling and matching the data in the second coordinate file and the data in the first coordinate file in sequence, and filling the data obtained by calling and matching into the first table to obtain the coordinate file comparison table, includes:
[0021] According to the first function, the second column of data in the second coordinate file is called, and the second column of data in the called second coordinate file is filled into the first table;
[0022] According to a preset second function, searching for a plurality of columns of matching data in the second coordinate file, and sequentially filling the plurality of columns of matching data from the second coordinate file into the first table;
[0023] According to the second column of data in the second coordinate file, the second function is used to find several columns of matching data in the first coordinate file, and the several columns of matching data from the first coordinate file are filled into the first table in sequence to obtain the coordinate file comparison table.
[0024] In one implementation, determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification includes:
[0025] Obtain data in the first table portion of the coordinate file comparison table;
[0026] According to a preset third function, the data in the first table portion is screened to determine the components deleted from the PCB file after the board is modified relative to the PCB file before the board is modified.
[0027] In one implementation, determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification includes:
[0028] Acquire the data except the first table part in the coordinate file comparison table;
[0029] According to a preset third function, the data in the coordinate file comparison table except the first table part is screened to determine the components added to the PCB file after the board modification relative to the PCB file before the board modification.
[0030] In a second aspect, an embodiment of the present invention provides a PCB component information comparison device, wherein the device comprises:
[0031] A coordinate file acquisition module, used to acquire a PCB file before and after the board is modified, and obtain a first coordinate file according to the PCB file before the board is modified, and obtain a second coordinate file according to the PCB file after the board is modified;
[0032] A coordinate file comparison table construction module, used to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file;
[0033] The component comparison module is used to determine the components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification according to the coordinate file comparison table.
[0034] In a third aspect, an embodiment of the present invention further provides a terminal, wherein the terminal includes a memory, a processor, and a PCB component information comparison program or a data decryption processing program stored in the memory and executable on the processor, and when the processor executes the PCB component information comparison program or the data decryption processing program, the steps of the PCB component information comparison method described in any one of the above schemes are implemented.
[0035] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a PCB component information comparison program or a data decryption processing program is stored. When the PCB component information comparison program or the data decryption processing program is executed by a processor, the steps of the PCB component information comparison method described in any one of the above schemes are implemented.
[0036] Beneficial effect: Compared with the prior art, the present invention provides a method for comparing PCB component information, the method comprising: obtaining a PCB file before board modification and a PCB file after board modification, and obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification; constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining the components deleted and / or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. The present invention constructs the coordinate file comparison table, and can determine the components deleted and / or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table, so as to timely learn about the changes in components before and after PCB modification, so as to avoid errors in BOM production. BRIEF DESCRIPTION OF THE DRAWINGS
[0037] Figure 1 A flowchart of a specific implementation of the PCB component information comparison method provided in an embodiment of the present invention.
[0038] Figure 2 A schematic diagram of a first coordinate file in a PCB component information comparison method provided in an embodiment of the present invention.
[0039] Figure 3 A schematic diagram of a second coordinate file in a PCB component information comparison method provided in an embodiment of the present invention.
[0040] Figure 4 A schematic diagram of setting the coordinate file comparison table in a screening form in the PCB component information comparison method provided in an embodiment of the present invention.
[0041] Figure 5A schematic diagram of components determined to be deleted in the PCB component information comparison method provided in an embodiment of the present invention.
[0042] Figure 6 A schematic diagram of determining added components in the PCB component information comparison method provided in an embodiment of the present invention.
[0043] Figure 7 It is a principle block diagram of a PCB component information comparison device provided by an embodiment of the present invention.
[0044] Figure 8 It is a block diagram of the internal structure principle of the terminal provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0045] In order to make the purpose, technical solution and effect of the present invention clearer and more specific, the present invention is further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.
[0046] It will be understood by those skilled in the art that, unless expressly stated, the singular forms "one", "said", and "the" used herein may also include plural forms. It should be further understood that the term "comprising" used in the specification of the present invention refers to the presence of the features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or groups thereof. It should be understood that when we refer to an element as being "connected" or "coupled" to another element, it may be directly connected or coupled to the other element, or there may be intermediate elements. In addition, the "connection" or "coupling" used herein may include wireless connection or wireless coupling. The term "and / or" used herein includes all or any unit and all combinations of one or more associated listed items.
[0047] It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as generally understood by those skilled in the art in the art to which the present invention belongs. It should also be understood that terms such as those defined in general dictionaries should be understood to have meanings consistent with the meanings in the context of the prior art, and will not be interpreted with idealized or overly formal meanings unless specifically defined as herein.
[0048] According to research, some unregistered components are added or deleted by designers during the design of single-sided PCB (printed circuit board). These components are not included in the schematic diagram. During the schematic diagram design stage, these components are manually added or deleted when the PCB design is modified. Designers cannot know which components need to be added or deleted on which network. Therefore, designers have no way to reflect the added or deleted components in the schematic diagram. The BOM (bill of materials) is derived from the schematic diagram, which will cause components to be omitted or deleted from the BOM, resulting in errors in the BOM production. The coordinate file exported from the PCB file has components added or deleted, and the order is different. The ordinary comparison method cannot meet the requirements.
[0049] In order to solve the existing problems, this embodiment provides a PCB component information comparison method. During specific implementation, this embodiment first obtains the PCB file before and after the board is modified, and obtains a first coordinate file based on the PCB file before the board is modified, and obtains a second coordinate file based on the PCB file after the board is modified; a coordinate file comparison table is constructed based on the first coordinate file and the second coordinate file; and components deleted and / or added in the PCB file after the board is modified relative to the PCB file before the board is modified are determined based on the coordinate file comparison table. The present invention constructs the coordinate file comparison table, and can determine the components deleted and / or added in the PCB file after the board is modified relative to the PCB file before the board is modified based on the coordinate file comparison table, so as to timely learn about the changes in components before and after the PCB board is modified, so as to avoid errors in BOM production.
[0050] Exemplary Methods
[0051] The PCB component information comparison method of this embodiment can be applied to a terminal, and the terminal can be an intelligent terminal product such as a mobile phone or a computer. Figure 1 As shown, the PCB component information comparison method in this embodiment includes the following steps:
[0052] Step S100, obtaining a PCB file before the board is modified and a PCB file after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified.
[0053] In this embodiment, since it is necessary for the designer to be informed of the components added or removed in the PCB before and after the board modification in a timely manner so as to avoid errors in making the BOM (bill of materials), this embodiment first obtains the PCB file before the board modification and the PCB file after the board modification, and obtains the first coordinate file based on the PCB file before the board modification, and obtains the second coordinate file based on the PCB file after the board modification. In specific implementation, after obtaining the PCB file before the board modification, this embodiment exports the first coordinate file from the PCB file before the board modification, and saves the first coordinate file as "BOOK1.xls", such as Figure 2 After obtaining the modified PCB file, the second coordinate file is exported from the modified PCB file, and the second coordinate file is saved as "BOOK2.xls", as shown in FIG. Figure 3 The first coordinate file and the second coordinate file in this embodiment respectively reflect the components on the PCB board before and after the board is modified.
[0054] After the first coordinate file and the second coordinate file are obtained, this embodiment executes step S200 to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file.
[0055] Since the first coordinate file and the second coordinate file respectively reflect the components on the PCB board before and after the board is changed, the present embodiment can generate a coordinate file comparison table based on the first coordinate file and the second coordinate file, so that the difference of the components on the PCB board before and after the board is changed can be determined based on the coordinate file comparison table, and whether there are increased or decreased components. Specifically, the present embodiment first calls and matches the data in the first coordinate file and the second coordinate file in turn, and fills the data obtained by calling and matching into a blank table to obtain a first table. After obtaining the first table, the present embodiment continues to call and match the data in the second coordinate file and the first coordinate file in turn, and fills the data obtained by calling and matching into the first table to obtain the coordinate file comparison table. That is to say, the coordinate file comparison table in the present embodiment is to create a first table based on a blank table, and then to create a table based on the first table.
[0056] In specific application, when creating the first table, the present embodiment firstly calls the second column data in the first coordinate file (i.e., BOOK1) according to the preset first function, and fills the second column data in the called first coordinate file (i.e., BOOK1) into the first column of the blank table. Then, according to the preset second function, find out several columns of matching data in the first coordinate file (i.e., BOOK1), and fill the several columns of matching data from the first coordinate file (i.e., BOOK1) into the blank table in sequence, that is, fill the matched data found in BOOK1 into the 2nd, 3rd, 4th, ... Nth, etc. columns of the blank table. Then, the second column data in the first coordinate file (i.e., BOOK1) is used, and the second function is used to find out several columns of matching data in the second coordinate file (i.e., BOOK2), and the several columns of matching data from the second coordinate file (i.e., BOOK2) are filled into the blank table in sequence to obtain the first table. That is, in the created first table, the several columns of matching data from the second coordinate file (i.e., BOOK2) are filled into the N+1st, N+2nd, ... N+Mth columns.
[0057] After the first table is created, the present embodiment continues to call the second column of data in the second coordinate file (i.e., BOOK2) according to the first function, and fills the second column of data in the called second coordinate file (i.e., BOOK2) into the first table. Therefore, the second column of data in the called second coordinate file (i.e., BOOK2) is filled in the N+M+1th column. Then, according to the preset second function, several matching columns of data are found in the second coordinate file (i.e., BOOK2), and the several columns of data matched from the second coordinate file (i.e., BOOK2) are filled into the first table in sequence. In other words, the several columns of data matched from the second coordinate file (i.e., BOOK2) are filled in the N+M+2, N+M+3, N+M+4...N+M+H and other columns in sequence. Finally, this embodiment uses the second function to find out a number of matching columns of data in the first coordinate file (i.e., BOOK1) based on the second column of data in the second coordinate file (i.e., BOOK2) (i.e., using the data in the N+M+1th column), and sequentially fills the number of columns of data matched from the first coordinate file (i.e., BOOK1) into the first table to obtain the coordinate file comparison table. In other words, in the coordinate file comparison table created, the number of columns of data matched from the first coordinate file (i.e., BOOK1) are filled in starting from the N+M+Hth column.
[0058] In this embodiment, the first function is used to call the data of a certain cell in a certain table; the second function is used to match the data of the corresponding column in the subsequent column of a certain basic data.
[0059] After the coordinate file comparison table is constructed, the present embodiment executes step S300 to determine the components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification according to the coordinate file comparison table.
[0060] In specific implementation, this embodiment first obtains the data of the first table part in the coordinate file comparison table; then, according to the preset third function, the data of the first table part is filtered to determine the components deleted in the PCB file after the board modification relative to the PCB file before the board modification. In specific application, this embodiment compares the data of the same columns in the first table part of the coordinate file comparison table to determine the difference cells. In order to highlight the effect of the difference cells, this embodiment can set the "conditional format" of these comparison result tables, such as setting the cells with the result of "different" to gray, and making the first row of the coordinate file comparison table into a data screening form, such as Figure 4 As shown in , if you select the M1 cell for screening and select "#N / A", the bit numbers that are not in the second coordinate file (i.e. BOOK2) are J63 and R257. The second coordinate file is derived based on the PCB file after the PCB is modified. Therefore, when the PCB is modified, these two bit numbers are deleted. Figure 5 As shown, therefore, it is determined that the components deleted from the PCB file after the board modification relative to the PCB file before the board modification are located at J63 and R257.
[0061] In another implementation, the present embodiment can also obtain data other than the first table portion in the coordinate file comparison table; then, according to a preset third function, the data other than the first table portion in the coordinate file comparison table is filtered to determine the components added to the PCB file after the board modification relative to the PCB file before the board modification. Similarly, the present embodiment compares the data in columns with the same meaning, selects the cell AE1 for filtering, selects "#N / A", and filters out the position numbers that are not in the first coordinate file (i.e., BOOK1), namely, C551, J64, J90, and R266. Therefore, it is determined that the components added to the PCB file after the board modification relative to the PCB file before the board modification are located at C551, J64, J90, and R266. Figure 6 .
[0062] It should be noted that the components compared in this embodiment are unregistered components. Even if registered components are deleted or added, the differences can be directly derived from the schematic diagram to change the BOM. Unregistered components require designers to change the BOM, but designers do not know whether components have been deleted or added. Therefore, it is necessary to use the PCB component information comparison method of this embodiment to determine the components deleted and / or added in the PCB file after the board is modified relative to the PCB file before the board is modified, so that designers can be informed in time to avoid errors in making the BOM.
[0063] Exemplary Devices
[0064] Based on the above embodiments, this embodiment also provides a PCB component information comparison device, such as Figure 7 As shown in , the device includes: a coordinate file acquisition module 10, a coordinate file comparison table construction module 20 and a component comparison module 30. Specifically, the coordinate file acquisition module 10 is used to obtain the PCB file before the board is changed and the PCB file after the board is changed, and obtain a first coordinate file according to the PCB file before the board is changed, and obtain a second coordinate file according to the PCB file after the board is changed. The coordinate file comparison table construction module 20 is used to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file. The component comparison module 30 is used to determine the components deleted and / or added in the PCB file after the board is changed relative to the PCB file before the board is changed according to the coordinate file comparison table.
[0065] Based on the above embodiment, the present invention further provides a terminal, which can be set on the above wardrobe device. Its principle block diagram can be as follows: Figure 8 As shown. The terminal includes a processor, a memory, a network interface, a display screen, a temperature sensor, etc. connected through a system bus. Among them, the processor of the terminal is used to provide computing and control capabilities. The memory of the terminal includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the terminal is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a PCB component information comparison program is implemented. The display screen of the terminal can be a liquid crystal display screen, an electronic ink display screen, or an interactive screen. The temperature sensor of the terminal is pre-set inside the terminal to detect the operating temperature of the internal device.
[0066] Those skilled in the art will understand that Figure 8The principle block diagram shown in the figure is only a block diagram of a partial structure related to the scheme of the present invention, and does not constitute a limitation on the terminal to which the scheme of the present invention is applied. The specific terminal may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0067] In one embodiment, a terminal is provided, the terminal including a memory, a processor, and a PCB component information comparison program stored in the memory and executable on the processor, and when the processor executes the PCB component information comparison program, the following operation instructions are implemented:
[0068] Obtaining a PCB file before and after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified;
[0069] Constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file;
[0070] According to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification are determined.
[0071] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided by the present invention can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
[0072] In summary, the present invention discloses a PCB component information comparison method, device, terminal and storage medium, the method comprising: obtaining a PCB file before board modification and a PCB file after board modification, and obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification; constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining the components deleted and / or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. The present invention can determine the components deleted and / or added in the PCB file after board modification relative to the PCB file before board modification, so as to timely learn about the changes in components before and after PCB modification, so as to avoid errors in BOM production.
[0073] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims
1. A PCB component information comparison method, characterized in that: The method comprises: Obtaining a PCB file before and after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified; Constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file; Determine, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification; The step of constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file includes: Calling and matching the data in the first coordinate file and the data in the second coordinate file in sequence, and filling the data obtained by calling and matching into a blank table to obtain a first table; sequentially calling and matching the data in the second coordinate file and the data in the first coordinate file, and filling the data obtained by calling and matching into the first table to obtain the coordinate file comparison table; The step of sequentially calling and matching the data in the first coordinate file and the data in the second coordinate file, and filling the data obtained by calling and matching into a blank table to obtain a first table includes: According to a preset first function, the second column of data in the first coordinate file is called, and the second column of data in the called first coordinate file is filled into the first column of the blank table; According to a preset second function, searching for a plurality of columns of matching data in the first coordinate file, and sequentially filling the plurality of columns of matching data from the first coordinate file into the blank table; According to the second column of data in the first coordinate file, using the second function, searching for a plurality of matching columns of data in the second coordinate file, and sequentially filling the plurality of matching columns of data from the second coordinate file into the blank table to obtain the first table; The first function is used to call the data of a certain cell in a certain table, and the second function is used to match the data of the corresponding column in the subsequent column of a certain basic data; The obtaining of the PCB file before the board is modified and the PCB file after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified, includes: Acquire the PCB file before the board is modified, and derive the first coordinate file from the PCB file before the board is modified; Acquire the modified PCB file, and derive the second coordinate file from the modified PCB file; The step of determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification comprises: Obtain data in the first table portion of the coordinate file comparison table; According to a preset third function, the data in the first table portion is screened to determine the components deleted in the PCB file after the board modification relative to the PCB file before the board modification; The step of determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification comprises: Acquire the data except the first table part in the coordinate file comparison table; According to a preset third function, the data other than the first table part in the coordinate file comparison table is screened to determine the components added to the PCB file after the board modification relative to the PCB file before the board modification; The first coordinate file and the second coordinate file respectively reflect the components on the PCB board before and after the revision.
2. The PCB component information comparison method according to claim 1, characterized in that: The step of sequentially calling and matching the data in the second coordinate file and the data in the first coordinate file, and filling the data obtained by calling and matching into the first table to obtain the coordinate file comparison table includes: According to the first function, the second column of data in the second coordinate file is called, and the second column of data in the called second coordinate file is filled into the first table; According to a preset second function, searching for a plurality of columns of matching data in the second coordinate file, and sequentially filling the plurality of columns of matching data from the second coordinate file into the first table; According to the second column of data in the second coordinate file, the second function is used to find several columns of matching data in the first coordinate file, and the several columns of matching data from the first coordinate file are sequentially filled into the first table to obtain the coordinate file comparison table.
3. A PCB component information comparison device, characterized in that: The device comprises: A coordinate file acquisition module, used to acquire a PCB file before and after the board is modified, and obtain a first coordinate file according to the PCB file before the board is modified, and obtain a second coordinate file according to the PCB file after the board is modified; The obtaining of the PCB file before the board is modified and the PCB file after the board is modified, and obtaining a first coordinate file according to the PCB file before the board is modified, and obtaining a second coordinate file according to the PCB file after the board is modified, includes: Acquire the PCB file before the board is modified, and derive the first coordinate file from the PCB file before the board is modified; Acquire the modified PCB file, and derive the second coordinate file from the modified PCB file; The first coordinate file and the second coordinate file respectively reflect the components on the PCB board before and after the revision; A coordinate file comparison table construction module, used to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file; The step of constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file includes: Calling and matching the data in the first coordinate file and the data in the second coordinate file in sequence, and filling the data obtained by calling and matching into a blank table to obtain a first table; sequentially calling and matching the data in the second coordinate file and the data in the first coordinate file, and filling the data obtained by calling and matching into the first table to obtain the coordinate file comparison table; The step of sequentially calling and matching the data in the first coordinate file and the data in the second coordinate file, and filling the data obtained by calling and matching into a blank table to obtain a first table includes: According to a preset first function, the second column of data in the first coordinate file is called, and the second column of data in the called first coordinate file is filled into the first column of the blank table; According to a preset second function, searching for a plurality of columns of matching data in the first coordinate file, and sequentially filling the plurality of columns of matching data from the first coordinate file into the blank table; According to the second column of data in the first coordinate file, using the second function, searching for a plurality of matching columns of data in the second coordinate file, and sequentially filling the plurality of matching columns of data from the second coordinate file into the blank table to obtain the first table; The first function is used to call the data of a certain cell in a certain table, and the second function is used to match the data of the corresponding column in the subsequent column of a certain basic data; A component comparison module, used for determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification; The step of determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification comprises: Obtain data in the first table portion of the coordinate file comparison table; According to a preset third function, the data in the first table portion is screened to determine the components deleted in the PCB file after the board modification relative to the PCB file before the board modification; The step of determining, according to the coordinate file comparison table, components deleted and / or added in the PCB file after the board modification relative to the PCB file before the board modification comprises: Acquire the data except the first table part in the coordinate file comparison table; According to the preset third function, the data in the coordinate file comparison table except the first table part is screened to determine the components added in the PCB file after the board modification relative to the PCB file before the board modification. 。 4. A terminal, characterized in that: The terminal includes a memory, a processor, and a PCB component information comparison program or a data decryption processing program stored in the memory and executable on the processor. When the processor executes the PCB component information comparison program or the data decryption processing program, the steps of the PCB component information comparison method as described in any one of claims 1 to 2 are implemented.
5. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a PCB component information comparison program or a data decryption processing program. When the PCB component information comparison program or the data decryption processing program is executed by the processor, the steps of the PCB component information comparison method as described in any one of claims 1-2 are implemented.
