CN113032337B - Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding - Google Patents
Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding Download PDFInfo
- Publication number
- CN113032337B CN113032337B CN202110309187.3A CN202110309187A CN113032337B CN 113032337 B CN113032337 B CN 113032337B CN 202110309187 A CN202110309187 A CN 202110309187A CN 113032337 B CN113032337 B CN 113032337B
- Authority
- CN
- China
- Prior art keywords
- file
- attribute
- bit number
- information
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000003466 welding Methods 0.000 title claims abstract description 31
- 238000003860 storage Methods 0.000 title claims abstract description 20
- 238000006243 chemical reaction Methods 0.000 claims description 58
- 238000003491 array Methods 0.000 claims description 9
- 238000004590 computer program Methods 0.000 claims description 8
- 238000005476 soldering Methods 0.000 claims description 6
- 230000000704 physical effect Effects 0.000 description 13
- 230000008676 import Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012546 transfer Methods 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000012549 training Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 229910000679 solder Inorganic materials 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/156—Query results presentation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention relates to a material inquiry method, a system, an intelligent terminal and a computer readable storage medium for assisting the material welding of a printed circuit board, which comprise the steps of acquiring a list file and a template file, wherein the template file is used for storing material information to generate an inquiry file which can be read by an inquiry tool; and according to the template storage strategy, acquiring at least one attribute set and at least one bit number set based on the provided list file, updating the template file based on each attribute set and each bit number set, and generating a query file. The operator can obtain the position numbers of all materials related to one physical attribute only by selecting the physical attribute, and the position number information and the physical attribute information do not need to be checked one by one. The problem of operating personnel comparatively loaded down with trivial details when checking printed circuit board's bill of materials, work efficiency is lower when leading to operating personnel to weld the material is solved. The invention has the effect of improving the working efficiency.
Description
Technical Field
The invention relates to the technical field of material data processing methods, in particular to a material query method for assisting in welding printed circuit board materials.
Background
At present, a printed circuit board (also called a PCB) in the electronic industry is not separated from a welding process, and a plurality of welding methods are available for the printed circuit board, and when the printed circuit board is in trial production, the printed circuit board is generally welded by adopting a manual mode. In the manual welding process, operators need to check the bill of materials of the printed circuit board one by one so as to reduce the risks of accidents such as material welding dislocation or material loss.
With the rapid development of electronic technology, the types or the amounts of materials on the printed circuit board tend to be more and more, and the distribution of the materials also tends to be more and more complex, so that operators are more and more complicated in checking the bill of materials of the printed circuit board, and the working efficiency of the operators is lower when the operators weld the materials.
Disclosure of Invention
The invention aims to provide a query file generation method for assisting in welding printed circuit board materials, which has the characteristic of improving the working efficiency.
The first object of the present invention is achieved by the following technical solutions:
a query document generation method for assisting in soldering of printed circuit board materials, comprising,
acquiring a list file and a template file, wherein the template file is used for storing material information to generate a query file which can be read by a query tool;
according to a template storage strategy, acquiring at least one attribute set and at least one bit number set based on the provided list file, updating a template file based on each attribute set and each bit number set, and generating a query file;
wherein each attribute set corresponds to each position number set one by one, the attribute set comprises physical attribute information of the material, and the position number set comprises position number information of the material.
By adopting the technical scheme, the physical attribute information and/or the position number information of all materials can be acquired through the list file, the information is written into the template file according to a specific format, the query file can be acquired, and the relevance between the physical attribute information and the position number information is still reserved in the query file. In the process of generating the query file, the manifest file is used for providing attribute sets and bit number sets, the template file is used for providing the file format of the query file, and the physical attribute information and/or position number information is actually converted into the query file in a mode that all attribute sets and all bit number sets are transferred into the template file according to a specific format. After the query file is obtained, an operator can read the data in the query file through the query tool, and can query all the position numbers associated with one physical attribute by selecting one physical attribute by utilizing the relevance between the physical attribute information and the position number information, so that the step that the operator checks the physical attribute and the position number one by one is omitted, the working difficulty of the operator is reduced, and the working efficiency is improved.
Optionally, in a specific method for generating a query file by obtaining at least one attribute set and at least one bit number set based on a provided manifest file according to a template storage policy, updating a template file based on each attribute set and each bit number set, including,
establishing an array conversion unit, wherein the array conversion unit is used for temporarily storing physical attribute information and position number information;
adding a mark, and storing a mark in an array conversion unit, wherein the mark is used for marking physical attribute information and position number information for identification by a query tool;
data adding, based on the data acquired from the list file, storing a material information array in an array conversion unit, wherein the material information array comprises attribute elements in an attribute set and bit number elements in a bit number set corresponding to the attribute set;
repeating the data adding step until all attribute elements and all bit number elements are added;
and sequentially updating the identifiers and all material information arrays in the array conversion unit into the template file to generate a query file.
By adopting the technical scheme, the array conversion unit can temporarily store the physical attribute information and the position number information, and is equivalent to a transfer carrier in the process of transferring the physical attribute information and/or the position number information from the manifest file to the template file. The tag addition may be identified by a query tool to tag physical attribute information and/or location number information. Each bit number element and one attribute element corresponding to the bit number element form a material information array, so that the association relation between each bit number element and each attribute element is established. After all the material information arrays are sequentially added into the template file, the template file contains all the physical attribute information and all the position number information, so that the template file is updated into the query file.
Alternatively, in a specific method of data addition, including,
according to a preset format, writing a material information array in an array conversion unit, wherein the material information array comprises a bit number element in any bit number set and an attribute element in an attribute set corresponding to the bit number set.
By adopting the technical scheme, all bit number elements and all attribute elements can be grouped from the manifest file, wherein each bit number element associated with the same attribute element is contained in one bit number set. After each bit number set and each attribute set are obtained, one bit number element can be taken out from any bit number set, and then one attribute element is taken out from the attribute set corresponding to the bit number set, so that a material information array is formed.
The invention also aims to provide a material inquiry method for assisting in welding the printed circuit board materials, which has the characteristic of improving the working efficiency.
The second object of the present invention is achieved by the following technical solutions:
a material inquiry method for assisting the material welding of a printed circuit board comprises the steps of,
generating a query file based on the provided list file, wherein the query file comprises at least one material information array, each material information array comprises attribute elements and bit number elements, any attribute element corresponds to the bit number elements arranged in the same material information array, the attribute elements comprise physical attribute information of materials, and the bit number elements comprise position number information of the materials;
acquiring all bit number elements corresponding to the attribute elements by reading any one attribute element in the query file;
based on the acquired individual bit number elements, position number information associated with the individual bit number elements is displayed.
By adopting the technical scheme, the material query method is used for assisting in manually welding the materials, so that the material query difficulty of operators can be reduced, the working efficiency is improved, and especially when the materials with the same physical properties are more, the operators can obtain the position numbers of all the materials related to the physical properties only by selecting one of the physical properties, and the position number information and the physical property information do not need to be checked one by one. If 100 materials with the same physical attribute exist, an operator only needs to select the physical attribute, the positions of the 100 materials are lightened in the query tool, and then the operator welds the 100 materials on the positions displayed in the query tool.
Optionally, the manifest file is a BOM file.
Through adopting above-mentioned technical scheme, operating personnel can directly use the BOM file that is provided by material producer to carry out data conversion, and is more convenient direct.
Optionally, the template file and the query file are both ASC files.
By adopting the technical scheme, the ASC file can be used for most single-byte coding systems, and is convenient for a query tool to import.
The invention aims at providing a query file generation module for assisting in welding of printed circuit board materials, which has the characteristic of improving the working efficiency.
The third object of the present invention is achieved by the following technical solutions:
a query document generation module for assisting in the soldering of printed circuit board materials, comprising,
the information acquisition sub-module is used for acquiring the list file and the template file, wherein the template file is used for storing the material information to generate a query file which can be read by a query tool;
the data conversion sub-module is used for acquiring at least one attribute set and at least one bit number set based on the provided list file according to a template storage strategy, updating a template file based on each attribute set and each bit number set, and generating a query file; wherein each attribute set corresponds to each position number set one by one, the attribute set comprises physical attribute information of the material, and the position number set comprises position number information of the material.
The invention aims at providing a material inquiry system for assisting the welding of the printed circuit board materials, which has the characteristic of improving the working efficiency.
The fourth object of the present invention is achieved by the following technical solutions:
a material inquiry system for assisting the material welding of a printed circuit board comprises,
the material inquiry system further comprises a material identification display module, wherein the material identification display module is used for acquiring all bit number elements corresponding to any attribute element in the inquiry file by reading the attribute element; and based on the acquired individual bit number elements, displaying position number information associated with the individual bit number elements.
The invention also provides a method for inquiring the materials, which comprises the step of loading and executing the computer program.
A sixth object of the present invention is to provide a computer storage medium storing a computer program capable of being loaded by a processor and executing any one of the above-mentioned material inquiry methods.
Drawings
Fig. 1 is a schematic flow chart of material welding in the related art.
Fig. 2 is a flow chart of a material query method according to one embodiment of the invention.
Fig. 3 is a schematic diagram of an example of a manifest file in one embodiment of the invention.
FIG. 4 is a schematic diagram of a query document in one embodiment of the invention.
Fig. 5 is a flowchart of a query document generation method according to one embodiment of the present invention.
FIG. 6 is a software interface schematic of an example EXE tool in one embodiment of the invention.
FIG. 7 is a schematic flow chart of material welding according to one embodiment of the invention.
FIG. 8 is a system block diagram of a material query system in accordance with one embodiment of the present invention.
FIG. 9 is a schematic diagram of a computer-readable storage medium of one embodiment of the invention.
Fig. 10 is a schematic diagram of a smart terminal according to one embodiment of the present invention.
In the figure, 1, a query file generation module; 11. an information acquisition sub-module; 12. a data conversion sub-module; 2. a material inquiry display module; 3. an intelligent terminal; 4. computer readable storage media.
Detailed Description
As shown in fig. 1, in the related art, an operator is generally required to manually solder materials during a trial-production stage of a printed circuit board. In the process of manually welding materials, operators need to check a bill of materials of a printed circuit board one by one and weld the materials on the bill of materials on the circuit board, and the specific method comprises the following steps:
s1, opening a bill of materials file containing physical attribute information and position number information in a computer, and opening a PCB file containing all material position layouts;
s2, manually finding 1 material level number and material attribute of the material corresponding to the material level number in the bill of materials;
s3, taking out 1 material from the warehouse according to the material attribute;
s4, manually comparing the position of the material level number in the PCB file, and welding the material at the position;
s5, repeating the step S2 until all materials in the bill of materials are welded.
The method requires that operators check the position numbers and the physical properties one by one, namely, find the position number of a material and find the physical properties of the material, and then check and weld; when the next material is checked, the position number and physical attribute of the material need to be found again. If 100 materials exist, operators need to sequentially complete position number searching, physical attribute searching and manual welding of each material, and in the process, the position number searching and the physical attribute searching also need to be performed for about 100 times, so that the operation efficiency of the operators is influenced.
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In addition, the term "and/or" herein is merely an association relationship describing an association object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist together, and B exists alone. In this context, unless otherwise specified, the term "/" generally indicates that the associated object is an "or" relationship.
Embodiments of the present invention are described in further detail below in conjunction with the accompanying drawings of figures 2-10 of the specification.
The embodiment of the invention provides a material inquiry method for assisting the material welding of a printed circuit board,
as shown in fig. 2, the specific method includes the steps of,
and S01, generating a query file based on the provided manifest file.
Specifically, before the material is welded, a manifest file and a PCB file are required to be prepared, where the manifest file corresponds to the PCB file, and the manifest file is a BOM file provided by a producer of the material supply, and at least includes location number information and physical attribute information. Each position number information is a position number element, each material has only one position number, and the position numbers are not repeated; the PCB file stores PCB layout related to each position number, and each position number can find a corresponding position on the PCB file. Each piece of physical attribute information is an attribute element, and the physical attribute information can represent the physical characteristics of each material, such as resistance value, capacitance or other physical attribute information, so that the physical attribute information can also show the basic functions of the material in the PCB circuit or the PCB product. The PCB file contains a layout of a printed circuit board, and corresponding positions can be found in the PCB file for welding according to the position number information of each material.
Each attribute set comprises an attribute element, each bit number set comprises at least one bit number element, and each attribute set corresponds to each bit number set one by one. Any one attribute set and the corresponding bit number set are equivalent to any one physical attribute information and all position number information corresponding to the physical attribute, namely, by finding one material attribute, the position numbers of all materials meeting the material attribute can be found. Thus, all bit number elements within any one bit number set are associated with all attribute elements within the corresponding attribute set.
As shown in fig. 3, in one example of the manifest file, a plurality of rows are sequentially arranged in the manifest file along the Y-axis direction, and data of each row is data of all materials with the same physical attribute. The manifest file has 4 columns of data sequentially arranged in the X-axis direction, including an Item column, a Quantity column, a Part Reference column, and a Value column. Wherein the data in the Item column represents the serial numbers of all materials of each group of the same physical attribute; the data in the Quantity column represents the number of all materials for each set of the same physical attribute; the data in the Part Reference column represents the location numbers of all materials for each set of the same physical attribute; the data in the Value column represents the physical properties of all materials for each set of the same physical properties. For example, where the data of the first row may indicate that the data of the first row in the manifest file corresponds to a material having a capacitance of X1 μf, the row has a total of 5 materials, the 5 materials having the position numbers CB1, C12, C16, C18, and C709, i.e., the materials having the position numbers CB1, C12, C16, C18, and C709 are each associated with the physical attribute X1 μf. CB1, C12, C16, C18, and C709 in the above example correspond to a set of bit number sets, and X1 μf corresponds to an attribute set corresponding to the bit number set.
As shown in fig. 4, the query file refers to a file extracted from all location number information and all physical attribute information according to a preset format; the query file is an ASC file and can be read by a pre-packaged query tool so that an operator can query materials through the query tool. The query file comprises a plurality of material information arrays, and each material information array comprises an attribute element and a bit number element corresponding to the attribute element. The query tool refers to third-party software that can complete reading of the query file, which in this embodiment may be Pads Layout.
As shown in fig. 2 and 3, step S01 specifically includes,
s011, acquiring a manifest file and a template file.
The bill file refers to a BOM file provided by a producer, and the bill file contains material information of all materials, wherein the material information comprises physical attribute information and position number information. In order to generate the query file, the corresponding physical attribute information and location number information need to be extracted from the manifest file, and therefore, the manifest file needs to be imported into the computer memory to extract and convert the data in the manifest file. The template file refers to an ASC file which can be read by a query tool, and when the template file is stored with the physical attribute information and the position number information, an operator can read the template file by the query tool and query the material by utilizing the corresponding relation between the physical attribute information and the position number information. The template file corresponds to a query file in which the physical attribute information and the location number information have not been stored, and therefore, in order to generate the query file, it is necessary to import the template file into the memory of the computer and store the data extracted from the manifest file into the template file. It should be noted that the ASC file may be used in most single byte encoding systems to facilitate the importing of the query tool, and in other embodiments, the operator may change the file format of the query file and/or the template file according to the requirement of the query tool.
In addition, if the operator does not need to weld or inquire some materials in the process of welding the materials in the later period, the operator can modify the list file before importing the list file, and delete the data corresponding to the unnecessary materials; similarly, if the original list file has data missing of part of materials, the operator can also add data into the original list file according to own needs, and then the modified new list file is imported into the computer memory.
S012, according to the template storage strategy, at least one attribute set and at least one bit number set are obtained based on the provided list file, and the template file is updated based on each attribute set and each bit number set, so as to generate a query file.
Wherein, each attribute set is in one-to-one correspondence with one bit number set; each attribute set contains an attribute element representing a physical attribute; each set of bit numbers includes at least one bit number element representing all of the position numbers associated with one of the physical attributes. The template storing strategy refers to a strategy that each attribute set and each bit number set are sequentially extracted from the list file and then stored in the template file to update the template file into the query file.
As shown in fig. 5, step S012 specifically includes,
s0121, establishing an array conversion unit.
Wherein the array conversion unit is used for temporarily storing the physical attribute information and the position number information extracted from the list file, and the physical attribute information and the position number information can be stored in the array conversion unit through a specific format; and when all the physical attribute information and all the position number information are extracted, the data of the array conversion unit can be stored in the template file, so that the data conversion is completed.
S0122, adding the mark, and storing the mark in the array conversion unit.
The identifier is used for marking physical attribute information and position number information, and represents attribute elements and bit number elements to be written in for identification by a query tool.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired in the list file.
Each material information array comprises a bit number element and an attribute element associated with the bit number element, so that the bit number element and the attribute element are associated with each other to establish a reference relationship.
As shown in fig. 4 and 5, step S0123 specifically includes,
s01231, acquiring at least one bit number set and at least one attribute set corresponding to each bit number set one by one based on the list file.
Each row of data in the manifest file comprises a bit number set and an attribute set, wherein each bit number element in the bit number set is a position number, and each attribute element in the attribute set is a physical attribute.
S01232, writing a material information array in the array conversion unit according to a preset format.
The material information array comprises one bit number element in any bit number set and one attribute element in an attribute set corresponding to the bit number set, which is equivalent to grouping all bit number elements and all attribute elements from a list file, wherein each bit number element associated with the same attribute element is contained in one bit number set. After each bit number set and each attribute set are obtained, one bit number element can be taken out from any bit number set, and then one attribute element is taken out from the attribute set corresponding to the bit number set, so that a material information array is formed. It is noted that for at least two materials having the same physical properties, the two materials are disposed at different locations on the printed circuit board, respectively, and thus one property element may be associated with a plurality of bit number elements, each bit number element being associated with only one property element. The preset format refers to a format in which data in the material information array can be read by the query tool program, and in this embodiment, the writing format of the material information array is Part bit number element { Value attribute element }, where "Part" represents location number information and "Value" represents physical attribute information.
S0124, repeating the step S01231 until all bit number elements and all attribute elements associated with each bit number element are added.
The step of adding the data is repeated, which is equivalent to sequentially taking each bit number element and the attribute element associated with each bit number element as a material information array, and sequentially storing each material information array into an array conversion unit. When all bit number elements and all attribute elements associated with the respective bit number elements are written into the array conversion unit, data transfer from the manifest file to the array conversion unit is completed.
As shown in fig. 3, the manifest file exemplified in step S01 is a manifest file before data transfer, one example of an array conversion unit after data transfer is as follows,
*MISC*MISCELLANEOUS PARAMETERS
ATTRIBUTE VALUES
{
Part CB1
{
ValueX1μF
}
Part C12
{
ValueX1μF
}
Part C16
{
ValueX1μF
}
…
Part C1
{
ValueX2pF
}
…
}
it should be noted that, the sequence of each material information array is not limited in this embodiment, so long as each material information array includes an attribute element and a bit number element that are associated with each other.
As shown in fig. 5, S0125, the identifier and all material information arrays in the array conversion unit are sequentially updated into the template file, and a query file is generated.
Wherein, the identifier, all the physical attribute information and all the position number information are stored in the template file, and the template file is updated into the query file.
As shown in fig. 6, in particular, steps S011-S012 can be performed by means of a computer-side EXE tool, one example of which is shown below. The software interface of the EXE tool includes a select manifest file key, a select template file key, and a data conversion key. Firstly, an operator can click a 'select list file key', an EXE tool can pop up a list file import frame, and the operator can select a list file in a BOM format and import the list file into a computer memory; then, an operator can click a 'select template file key', the EXE tool can pop up a template file import frame, and the operator can select a template file in an ASC format and import the template file into a computer memory; then, an operator can use a data conversion key, an EXE tool can create a digital conversion unit, extract a material information array from the imported list file, write the identifier and each material information array into the digital conversion unit, write all data in the digital conversion unit into a template file, and finally generate an ASC format query file; finally, the operator can save the query file to the designated location.
As shown in fig. 2, S02, all bit number elements corresponding to an attribute element are obtained by reading any one attribute element in the query file.
All bit number elements in the query file are associated with one attribute element in the query file, and when any attribute element in the query file is selected, all bit number elements associated with the attribute element in the query file can be obtained; after selecting any one physical attribute, all the position numbers associated with the physical attribute can be acquired.
S03, based on the acquired bit number elements, displaying position number information associated with the bit number elements.
According to the acquired position number elements, the position number information represented by the position number elements can be presented according to a specific display mode so as to be inquired by operators. It is noted that the position number information of the material refers to the soldering position on the printed circuit board of the material, so the position number information needs to be combined with the PCB file to represent the soldering position of the material in the PCB layout.
Specifically, steps S02-S03 may be performed by means of a query tool, for example, pads Layout, and an operator may import the PCB file and the query file into the query tool, and select one of the attribute elements in a software interface of the query tool. According to the imported PCB file, the query tool can display the corresponding PCB layout; according to the imported query file, the query tool can establish the association between each attribute element and each bit number element; according to the selected attribute elements, the query tool can acquire all the associated bit number elements, and can lighten all the positions corresponding to each bit number element in the PCB layout by combining the preset material position distribution data in the PCB file and the position number information of each bit number element so as to query by operators. With the inquiry file and the inquiry tool, an operator can inquire the welding position of each material corresponding to any physical attribute on the printed circuit board by selecting the physical attribute.
As shown in fig. 7, based on the above-described material inquiry method, the steps of the specific method in which the operator manually welds the material are as follows,
s001, opening an EXE tool in a computer, selecting a bill and a template file, and storing a query file;
s002, opening a query tool in a computer, and selecting a PCB file and a query file;
s003, selecting any physical attribute, and taking out a sufficient amount of materials from a warehouse;
s004, welding each material on the corresponding position according to each position number displayed by the query tool.
S005, repeating the step S003 until all materials in the bill of materials are welded.
The implementation principle of the material query method for assisting the welding of the printed circuit board materials is as follows: by the aid of the material query method, the material query difficulty of operators can be reduced, the working efficiency is improved, and particularly when materials with the same physical properties are more, the operators can obtain the position numbers of all the materials related to the physical properties only by selecting one of the physical properties, and the position number information and the physical property information do not need to be checked one by one. If 100 materials with the same physical attribute exist, an operator only needs to select the physical attribute, the positions of the 100 materials are lightened in the query tool to indicate the positions of the 100 materials on the PCB, and then the operator welds the 100 materials on the PCB.
The method for acquiring the data extracted from the bit number set and the attribute set in the list file and converting the data into the query file is a method for actually converting the data based on the BOM file and generating the ASC file which can be read by the query tool, and in the step of converting the data, the relevance between each position number and each physical attribute is established, which is equivalent to the step of completing one-to-one check between each position number and each physical attribute, so that after any one physical attribute is selected by an operator, which is equivalent to the step of completing check work in the system, then leading out each position number corresponding to the physical attribute, reducing the complexity and the query difficulty of manually inquiring the material information, and further improving the production efficiency.
On the other hand, the manifest file is actually a BOM file directly provided by a producer, the query file is actually an ASC file updated by a template file, the data conversion method steps can be directly completed through a self-defined EXE tool, and an operator can generate the query file by only importing a preset file and the file provided by the producer into the EXE tool, so that the operation is simple and quick. Along with the high-speed development of electronic technology, the types or the number of materials on the printed circuit board tend to be more and more, so that the technical difficulty of operators in welding materials is more and more increased, and the material inquiry method provided in the embodiment is one of the direct means capable of relieving the current situation, reduces the complexity of material welding, and improves the design space of the printed circuit board.
The embodiment of the invention also provides a material query system for assisting the material welding of the printed circuit board, as shown in fig. 8, the material query system corresponds to the material query method in the first embodiment one by one, and the system comprises a query file generation module 1 and a material query display module 2. The functional modules are described in detail below,
the query file generation module 1 is configured to generate a query file based on the provided manifest file, where the query file includes at least one material information array, each material information array includes an attribute element and a bit number element, any one attribute element corresponds to the bit number element set in the same material information array, where the attribute element includes physical attribute information of a material, and the bit number element includes position number information of the material.
The material inquiry display module 2 is used for acquiring all bit number elements corresponding to any attribute element by reading any attribute element in the inquiry file; and based on the acquired individual bit number elements, displaying position number information associated with the individual bit number elements.
Specifically, the query document generation module 1 further includes,
an information obtaining sub-module 11, configured to obtain a manifest file and a template file, where the template file is used for storing material information to generate a query file that can be read by a query tool;
a data conversion sub-module 12, configured to obtain at least one attribute set and at least one bit number set based on the provided manifest file according to a template storage policy, update a template file based on each attribute set and each bit number set, and generate a query file; wherein each attribute set corresponds to each position number set one by one, the attribute set comprises physical attribute information of the material, and the position number set comprises position number information of the material.
The embodiment of the invention also provides an intelligent terminal,
as shown in fig. 9, the intelligent terminal 3 includes a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the memory stores training data, algorithm formulas, filtering mechanisms, and the like in a training model. The processor is configured to provide computing and control capabilities, and when executing the computer program, the processor performs the steps of:
and S01, generating a query file based on the provided manifest file.
S011, acquiring a manifest file and a template file.
S012, according to the template storage strategy, at least one attribute set and at least one bit number set are obtained based on the provided list file, and the template file is updated based on each attribute set and each bit number set, so as to generate a query file.
S0121, establishing an array conversion unit.
S01X2, adding a mark, and storing the mark in an array conversion unit.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired in the list file.
S01231, acquiring at least one bit number set and at least one attribute set corresponding to each bit number set one by one based on the list file.
S01232, writing a material information array in the array conversion unit according to a preset format.
S0124, repeating the step S01231 until all bit number elements and all attribute elements associated with each bit number element are added.
S0125, sequentially updating the identifiers and all material information arrays in the array conversion unit into the template file to generate a query file.
S02, all bit number elements corresponding to the attribute elements are obtained by reading any one attribute element in the query file.
S03, based on the acquired bit number elements, displaying position number information associated with the bit number elements.
Embodiments of the present invention also provide a computer-readable storage medium,
as shown in fig. 10, the computer-readable storage medium 4 stores a computer program that can be loaded by a processor and that performs the above-described material inquiry method, the computer program implementing the following steps when executed by the processor,
and S01, generating a query file based on the provided manifest file.
S011, acquiring a manifest file and a template file.
S012, according to the template storage strategy, at least one attribute set and at least one bit number set are obtained based on the provided list file, and the template file is updated based on each attribute set and each bit number set, so as to generate a query file.
S0121, establishing an array conversion unit.
S01X2, adding a mark, and storing the mark in an array conversion unit.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired in the list file.
S01231, acquiring at least one bit number set and at least one attribute set corresponding to each bit number set one by one based on the list file.
S01232, writing a material information array in the array conversion unit according to a preset format.
S0124, repeating the step S01231 until all bit number elements and all attribute elements associated with each bit number element are added.
S0125, sequentially updating the identifiers and all material information arrays in the array conversion unit into the template file to generate a query file.
S02, all bit number elements corresponding to the attribute elements are obtained by reading any one attribute element in the query file.
S03, based on the acquired bit number elements, displaying position number information associated with the bit number elements.
The computer readable storage medium includes, for example, a usb disk, a removable hard disk, a Read-only memory (ROM), a random access memory (RandomAccessMemory, RAM), a magnetic disk, or an optical disk, etc., which can store a program code.
The foregoing are all preferred embodiments of the present application, and are not intended to limit the scope of the present application in any way, therefore: all equivalent changes according to the structure and principle of the present application should be covered in the protection scope of the present application.
Claims (7)
1. A method for generating a query document for assisting in soldering of printed circuit board materials, the method comprising,
acquiring a list file and a template file, wherein the template file is used for storing material information to generate a query file which can be read by a query tool, the list file is a BOM file, and the template file is an ASC file;
according to a template storage strategy, at least one attribute set and at least one bit number set are obtained based on the provided list file, and a template file is updated based on each attribute set and each bit number set to generate a query file, which specifically comprises the following steps:
establishing an array conversion unit, wherein the array conversion unit is used for temporarily storing physical attribute information and position number information; adding a mark, and storing a mark in an array conversion unit, wherein the mark is used for marking physical attribute information and position number information for identification by a query tool; data adding, based on the data acquired from the list file, storing a material information array in an array conversion unit, wherein the material information array comprises attribute elements in an attribute set and bit number elements in a bit number set corresponding to the attribute set; repeating the data adding step until all bit number elements and all attribute elements associated with each bit number element are added; sequentially updating the identifiers and all material information arrays in the array conversion unit into a template file to generate a query file;
wherein each attribute set corresponds to each position number set one by one, the attribute set comprises physical attribute information of the material, and the position number set comprises position number information of the material.
2. The method of claim 1, wherein the specific method of data addition comprises,
according to a preset format, writing a material information array in an array conversion unit, wherein the material information array comprises a bit number element in any bit number set and an attribute element in an attribute set corresponding to the bit number set.
3. A material inquiry method for assisting the material welding of a printed circuit board is characterized in that the method comprises the following steps of,
generating a query file based on the provided list file, wherein the query file comprises at least one material information array, each material information array comprises attribute elements and bit number elements, any attribute element corresponds to the bit number elements arranged in the same material information array, the attribute elements comprise physical attribute information of materials, and the bit number elements comprise position number information of the materials;
acquiring all bit number elements corresponding to the attribute elements by reading any one attribute element in the query file;
based on the acquired bit number elements, displaying position number information associated with the bit number elements;
the generating a query file based on the provided manifest file specifically includes:
establishing an array conversion unit, wherein the array conversion unit is used for temporarily storing physical attribute information and position number information; adding a mark, and storing a mark in an array conversion unit, wherein the mark is used for marking physical attribute information and position number information for identification by a query tool; data adding, based on the data acquired from the list file, storing a material information array in an array conversion unit, wherein the material information array comprises attribute elements in an attribute set and bit number elements in a bit number set corresponding to the attribute set; repeating the data adding step until all bit number elements and all attribute elements associated with each bit number element are added; and sequentially updating the identifiers and all material information arrays in the array conversion unit into the template file to generate a query file.
4. A query document generation module for assisting in the soldering of printed circuit board materials is characterized by comprising,
the information acquisition sub-module (11) is used for acquiring a list file and a template file, wherein the template file is used for storing material information to generate a query file which can be read by a query tool, the list file is a BOM file, and the template file is an ASC file;
the data conversion sub-module (12) is used for acquiring at least one attribute set and at least one bit number set based on the provided list file according to a template storage strategy, updating a template file based on each attribute set and each bit number set, and generating a query file, wherein the data conversion sub-module (12) is specifically used for: establishing an array conversion unit, wherein the array conversion unit is used for temporarily storing physical attribute information and position number information; adding a mark, and storing a mark in an array conversion unit, wherein the mark is used for marking physical attribute information and position number information for identification by a query tool; data adding, based on the data acquired from the list file, storing a material information array in an array conversion unit, wherein the material information array comprises attribute elements in an attribute set and bit number elements in a bit number set corresponding to the attribute set; repeating the data adding step until all bit number elements and all attribute elements associated with each bit number element are added;
sequentially updating the identifiers and all material information arrays in the array conversion unit into a template file to generate a query file;
wherein each attribute set corresponds to each position number set one by one, the attribute set comprises physical attribute information of the material, and the position number set comprises position number information of the material.
5. A material inquiry system for assisting in the material welding of a printed circuit board, characterized by comprising the inquiry document generating module according to claim 4, the material inquiry system further comprising,
the material inquiry display module is used for acquiring all bit number elements corresponding to any attribute element by reading any attribute element in the inquiry file; and based on the acquired individual bit number elements, displaying position number information associated with the individual bit number elements.
6. An intelligent terminal comprising a memory and a processor, the memory having stored thereon a computer program capable of being loaded by the processor and performing the method according to any of claims 1 to 3.
7. A computer readable storage medium, characterized in that a computer program is stored which can be loaded by a processor and which performs the method according to any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110309187.3A CN113032337B (en) | 2021-03-23 | 2021-03-23 | Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110309187.3A CN113032337B (en) | 2021-03-23 | 2021-03-23 | Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113032337A CN113032337A (en) | 2021-06-25 |
| CN113032337B true CN113032337B (en) | 2024-02-06 |
Family
ID=76472908
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110309187.3A Active CN113032337B (en) | 2021-03-23 | 2021-03-23 | Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113032337B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108388743A (en) * | 2018-03-06 | 2018-08-10 | 深圳市图敏智能视频股份有限公司 | A kind of bill of materials method for sorting |
| CN109636266A (en) * | 2018-11-07 | 2019-04-16 | 金蝶蝶金云计算有限公司 | Material management method, device, computer equipment and storage medium |
| CN111400827A (en) * | 2018-12-13 | 2020-07-10 | 英业达科技有限公司 | System and method for generating insertion prompt according to material attribute data and insertion rule |
| CN111459599A (en) * | 2020-04-03 | 2020-07-28 | 上海闻泰信息技术有限公司 | Material list editing method, device, equipment and storage medium |
-
2021
- 2021-03-23 CN CN202110309187.3A patent/CN113032337B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108388743A (en) * | 2018-03-06 | 2018-08-10 | 深圳市图敏智能视频股份有限公司 | A kind of bill of materials method for sorting |
| CN109636266A (en) * | 2018-11-07 | 2019-04-16 | 金蝶蝶金云计算有限公司 | Material management method, device, computer equipment and storage medium |
| CN111400827A (en) * | 2018-12-13 | 2020-07-10 | 英业达科技有限公司 | System and method for generating insertion prompt according to material attribute data and insertion rule |
| CN111459599A (en) * | 2020-04-03 | 2020-07-28 | 上海闻泰信息技术有限公司 | Material list editing method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113032337A (en) | 2021-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101122899B (en) | Report generation method and device | |
| CN109636887B (en) | Two-dimensional electronic technology drawing format conversion and vectorization interaction system | |
| CN111079387B (en) | Automatic questionnaire generation method and device, computer equipment and storage medium | |
| CN101650711A (en) | Method for generating report | |
| CN109933311A (en) | A kind of information system creation method and relevant apparatus | |
| JPH09134349A (en) | Information processor and method for preparing document and business form | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN107463668A (en) | Serializing and method and device, computer equipment and the storage medium of unserializing | |
| CN113283228A (en) | Document generation method and device, electronic equipment and storage medium | |
| CN113032337B (en) | Material query method, system, intelligent terminal and computer readable storage medium for assisting printed circuit board material welding | |
| WO2011074942A1 (en) | System and method of converting data from a multiple table structure into an edoc format | |
| CN101369953B (en) | Font network distribution method and system | |
| CN102880893A (en) | Barcode displaying method | |
| CN113467369B (en) | Automatic drilling and riveting numerical control code visual interactive correction method | |
| CN108763127A (en) | The implementation method for the Modbus adapters that source data is mutually converted with target data | |
| CN113033162A (en) | Electronic document conversion method capable of controlling editing rule | |
| JP4627962B2 (en) | Database publishing method and apparatus | |
| CN112232032B (en) | Automatic conversion method for content style of docx document | |
| JP2000099545A (en) | Manufacture of recording medium | |
| CN109814922A (en) | A kind of method and system that wafer Map file is converted to ten piece files | |
| CN117574851B (en) | Method, device and storage medium for reconstructing circuit schematic diagram in EDA tool | |
| CN113763497B (en) | Link relation management method, device, computer equipment and storage medium | |
| CN116705171B (en) | Batch biological data processing method, device and medium | |
| CN107844349A (en) | A kind of control method and device based on user interface | |
| CN117688921A (en) | Method for unifying format and personalized data setting of automatically generated ppt |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |