CN113032337A - Material query method and system for assisting in welding printed circuit board material, intelligent terminal and computer readable storage medium - Google Patents
Material query method and system for assisting in welding printed circuit board material, intelligent terminal and computer readable storage medium Download PDFInfo
- Publication number
- CN113032337A CN113032337A CN202110309187.3A CN202110309187A CN113032337A CN 113032337 A CN113032337 A CN 113032337A CN 202110309187 A CN202110309187 A CN 202110309187A CN 113032337 A CN113032337 A CN 113032337A
- Authority
- CN
- China
- Prior art keywords
- file
- attribute
- query
- bit number
- information
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000003466 welding Methods 0.000 title claims abstract description 39
- 238000003860 storage Methods 0.000 title claims abstract description 20
- 238000006243 chemical reaction Methods 0.000 claims description 49
- 238000003491 array Methods 0.000 claims description 9
- 238000004590 computer program Methods 0.000 claims description 7
- 238000005476 soldering Methods 0.000 claims description 2
- 230000008676 import Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 230000000704 physical effect Effects 0.000 description 4
- 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
- 238000005516 engineering process Methods 0.000 description 2
- 238000012549 training Methods 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 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
- 238000003825 pressing Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 229910000679 solder Inorganic materials 0.000 description 1
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Library & Information Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to a material query method, a system, an intelligent terminal and a computer readable storage medium for assisting material welding of a printed circuit board, which comprises an acquisition 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; and 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 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 the materials related to the physical attributes only by selecting one of the physical attributes, 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 material, 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 material welding of a printed circuit board.
Background
At present, a printed circuit board (also called PCB) in the electronic industry has a plurality of welding methods without a welding process, and when the printed circuit board is in a trial production, the welding is generally carried out in a manual mode. In the manual welding process, an operator needs to check the bill of materials of the printed circuit board one by one so as to reduce the risk of accidents such as material welding dislocation or material loss.
With the high-speed development of electronic technology, the types or the quantity of materials on the printed circuit board tend to be more and more, the distribution of the materials also tends to be more and more complex, and an operator is more and more tedious when checking a bill of materials of the printed circuit board, so that the working efficiency of the operator is lower when welding the materials.
Disclosure of Invention
The invention aims to provide a query file generation method for assisting in welding of printed circuit board materials, which has the characteristic of improving the working efficiency.
The above object of the present invention is achieved by the following technical solutions:
a query file generation method for assisting printed circuit board material welding comprises,
acquiring a list file and a template file, wherein the template file is used for storing material information so as 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 a provided list file, updating a template file based on each attribute set and each bit number set, and generating a query file;
and each attribute set corresponds to each bit number set one to one, wherein the attribute sets comprise physical attribute information of the materials, and the bit number sets comprise position number information of the materials.
By adopting the technical scheme, the physical attribute information and/or the position number information of all the materials can be acquired through the manifest 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 kept in the query file. In the process of generating the query file, the manifest file is used for providing the attribute set and the bit number set, the template file is used for providing the file format of the query file, and the physical attribute information and/or the position number information are actually converted into the query file in a mode of transferring all the attribute sets and all the bit number sets into the template file according to a specific format. After the query file is obtained, an operator can read data in the query file through a query tool, and can query all position numbers related to the physical attributes by selecting one of the physical attributes according to the relevance between the physical attribute information and the position number information, so that the step of checking the physical attributes and the position numbers one by the operator 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, the method 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 the array conversion unit, wherein the mark is used for marking physical attribute information and position number information for a query tool to mark;
data adding, namely storing a material information array in the array conversion unit based on the data acquired from the manifest file, wherein the material information array comprises attribute elements in an attribute set and a bit number element 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 identifier in the array conversion unit and all material information arrays 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 is recognizable by the 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, and therefore the incidence relation between each bit number element and each attribute element is established. And after all the material information arrays are sequentially added into the template file, the template file comprises all the physical attribute information and all the position number information, so that the template file is updated into an inquiry file.
Optionally, in the specific method of data addition, including,
and writing a material information array in the array conversion unit according to a preset format, 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 the bit number elements and all the attribute elements can be grouped from the list file, wherein each bit number element related to the same attribute element is contained in one bit number set. After each bit number set and each attribute set are obtained, a bit number element can be taken out from any bit number set, and then an 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 query method for assisting the welding of the printed circuit board material, which has the characteristic of improving the working efficiency.
The second aim of the invention is realized by the following technical scheme:
a material query method for assisting material welding of a printed circuit board comprises the following steps,
generating a query file based on a provided list file, wherein the query file comprises at least one material information array, each material information array comprises attribute elements and position number elements, any attribute element corresponds to the position number element arranged in the same material information array, the attribute elements comprise physical attribute information of materials, and the position number elements comprise position number information of the materials;
acquiring all bit number elements corresponding to the attribute elements by reading any attribute element in the query file;
based on the acquired respective number elements, position number information associated with the respective number elements is displayed.
By adopting the technical scheme, the welding materials are welded manually by the aid of the material query method, material query difficulty of operators can be reduced, work efficiency is improved, particularly when the materials with the same physical attributes are more, the operators can obtain position numbers of all the materials related to the physical attributes by selecting one of the physical attributes, and position number information and physical attribute information do not need to be checked one by one. If there are 100 materials with the same physical attribute, the operator only needs to select the physical attribute, the positions of the 100 materials are lighted up 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.
By adopting the technical scheme, an operator can directly use the BOM file provided by the material producer to perform data conversion, and the operation is more convenient and direct.
Optionally, the template file and the query file are ASC files.
By adopting the technical scheme, the ASC file can be universally used in most single-byte coding systems, and the import of a query tool is facilitated.
The invention aims to provide an inquiry file generation module for assisting the welding of printed circuit board materials, which has the characteristic of improving the working efficiency.
The third object of the invention is realized by the following technical scheme:
an inquiry file generating module for assisting the welding of printed circuit board materials comprises,
the information acquisition submodule is used for acquiring a list file and a template file, wherein the template file is used for storing material information so as to generate a query file which can be read by a query tool;
the data conversion sub-module is used for obtaining 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 the template file based on each attribute set and each bit number set and generating a query file; and each attribute set corresponds to each bit number set one to one, wherein the attribute sets comprise physical attribute information of the materials, and the bit number sets comprise position number information of the materials.
The invention aims at providing a material inquiry system for assisting the welding of the printed circuit board material, which has the characteristic of improving the working efficiency.
The fourth object of the invention is realized by the following technical scheme:
a material inquiry system for assisting material welding of a printed circuit board comprises,
a query file generation module, the material query system further comprises,
the material identification display module is used for reading any attribute element in the query file to obtain all position number elements corresponding to the attribute element; and displaying position number information associated with each bit number element based on the acquired each bit number element.
The fifth purpose of the present invention is to provide an intelligent terminal, which includes a memory and a processor, wherein the memory stores a computer program that can be loaded by the processor and execute the above material query method.
The sixth object of the present invention is to provide a computer storage medium storing a computer program that can be loaded by a processor and execute any of the above-mentioned material query 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 an embodiment of the present invention.
Fig. 3 is a schematic diagram of an example of a manifest file in one embodiment of the invention.
FIG. 4 is a diagram of a query document in one embodiment of the invention.
Fig. 5 is a flowchart illustrating a query file generating method according to an embodiment of the present invention.
FIG. 6 is a software interface diagram of an example EXE tool in one embodiment of the invention.
Fig. 7 is a schematic flow diagram of material welding according to one embodiment of the present 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 an intelligent terminal according to an embodiment of the invention.
In the figure, 1, a query file generation module; 11. an information acquisition submodule; 12. a data conversion submodule; 2. a material inquiry display module; 3. an intelligent terminal; 4. a computer readable storage medium.
Detailed Description
As shown in fig. 1, in the related art, when the printed circuit board is in the pre-production stage, the operator is usually required to manually solder the materials. In the process of manually welding materials, an operator needs to check the bill of materials of the 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 material 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 the 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 attributes;
s4, manually comparing the position of the material position number in the PCB file, and welding the material on the position;
and S5, repeating the step S2 until all materials in the bill of materials are welded.
The method needs an operator to check the position number and the physical properties one by one, namely, the position number of a material is found, the physical properties of the material are found, and then checking and welding are carried out; when checking the next material, the position number and the physical property of the material need to be found again. If there are 100 materials, then operating personnel need accomplish position number of each material in proper order and seek, physical attribute seeks and manual welding, and in this process, position number seeks and physical attribute seeks also need about 100 times, and is comparatively loaded down with trivial details, influences operating personnel's work efficiency.
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In addition, the term "and/or" herein is only one kind of association relationship describing an associated object, and means that there may be three kinds of relationships, for example, a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship, unless otherwise specified.
Embodiments of the present invention are described in further detail below with reference to figures 2-10 of the specification.
The embodiment of the invention provides a material query method for assisting 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 list file.
Specifically, before soldering the material, a manifest file and a PCB file need to be prepared, where the manifest file corresponds to the PCB file, and the manifest file is a BOM file provided by a material supplier's manufacturer, and the manifest file at least includes location number information and physical attribute information. Each position number information is a position number element, each material has one and only one position number, and the position numbers are not repeated; the PCB file is stored with a PCB layout related to each position number, and each position number can find a corresponding position on the PCB file. Each 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 reflect the basic functions of the material in a PCB circuit or a PCB product. The PCB file contains a layout of the printed circuit board, and the corresponding position in the PCB file can be found 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 attribute set and the bit number set corresponding to the attribute set are equivalent to representing any physical attribute information and all position number information corresponding to the physical attribute, namely, the position numbers of all materials meeting the material attribute can be found by finding one material attribute. Thus, all of the bit number elements within any one bit number set are associated with all of the attribute elements within the corresponding attribute set.
As shown in fig. 3, which is one example of a manifest file, a plurality of rows are sequentially arranged in the manifest file in the Y-axis direction, and data in each row is data of all materials with the same physical attribute. The manifest file is sequentially provided with 4 columns of data in the X-axis direction, wherein the 4 columns of data comprise an Item column, a Quantity column, a Part Reference column and a Value column. Wherein the data in the Item column represents the sequence numbers of all items of each group with the same physical attribute; the data in the Quantity column represents the Quantity of all materials with the same physical property in each group; data in the Part Reference column represents position numbers of all materials with the same physical attribute in each group; the data in the Value column represents the physical attributes of all materials for each set of the same physical attributes. For example, where the data of the first row may indicate that the data of the first row in the manifest file corresponds to an item having a capacitance of X1 μ F, the row has a total of 5 items, and the bit numbers of the 5 items are CB1, CB1, C12, C16, C18, and C709, i.e., the items having the bit numbers of CB1, CB1, C12, C16, C18, and C709 are all associated with the physical attribute of X1 μ F. CB1, CB1, C12, C16, C18, and C709 in the above example correspond to a set of bit numbers, and X1 μ F corresponds to a set of attributes corresponding to the set of bit numbers.
As shown in fig. 4, the query file refers to a file in which all the location number information and all the physical attribute information are extracted according to a preset format; the query file is an ASC file and can be read by a pre-installed query tool so that an operator can query the 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, and in this embodiment, may be Pads Layout.
As shown in fig. 2 and 3, step S01 specifically includes,
and S011, acquiring the manifest file and the template file.
The manifest file refers to a BOM file provided by a manufacturer, and 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, it is necessary to extract the corresponding physical attribute information and the location number information from the manifest file, and therefore, it is necessary to import the manifest file into the memory of the computer, and extract and convert the data in the manifest file. The template file refers to an ASC file which can be read by an inquiry tool, when the template file is stored in the physical attribute information and the position number information, an operator can read the template file through the inquiry tool and inquire the material by utilizing the corresponding relation between the physical attribute information and the position number information. The template file is equivalent to a query file which is not stored with the physical attribute information and the position number information, and therefore, in order to generate the query file, the template file needs to be imported into a computer memory, and data extracted from the manifest file needs to be stored in the template file. It should be noted that the ASC file can be commonly used in most single-byte coding systems, which facilitates the import of the query tool, and in other embodiments, the operator can also change the file format of the query file and/or the template file according to the requirement of the query tool.
In addition, if an operator welds materials in the later stage, part of the materials do not need to be welded or inquired, the operator can modify the manifest file before importing the manifest file and delete the data corresponding to the materials which are not needed; similarly, if the data of part of the materials in the original list file is missing, the operator can add the data in the original list file according to the requirement of the operator, and then introduce the modified new list file into the memory of the computer.
S012, according to the storage strategy of the template, based on the list file acquisition at least one attribute set and at least one bit number set, based on each attribute set and each bit number set update the template file, generate the inquiry file.
Each attribute set is in one-to-one correspondence with one bit number set; each attribute set comprises an attribute element which represents a physical attribute; each bit number set includes at least one bit number element representing all location numbers associated with one of the physical attributes. The template storage strategy refers to a strategy that all attribute sets and all bit number sets are sequentially extracted from a list file and then stored in a template file so as to update the template file into a query file.
As shown in fig. 5, step S012 specifically includes,
s0121, establishing an array conversion unit.
The array conversion unit is used for temporarily storing the physical attribute information and the position number information extracted from the manifest file, and the physical attribute information and the position number information can be stored in the array conversion unit through a specific format; and after 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 a mark, and storing the mark in the array conversion unit.
The identifier is used for identifying physical attribute information and position number information, and indicating an attribute element and a bit number element to be written for being identified by a query tool.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired from the manifest file.
Each material information array comprises a bit number element and an attribute element related to the bit number element, and the bit number element and the attribute element are related to each other to establish a reference relationship.
As shown in fig. 4 and 5, step S0123 specifically includes,
s01231, based on the list file, obtaining at least one bit number set and at least one attribute set corresponding to each bit number set one by one.
Each line of data in the manifest file comprises a bit number set and an attribute set, each bit number element in the bit number set is each position number, and the attribute elements in the attribute set are physical attributes.
S01232, writing a material information array in the array conversion unit according to a preset format.
The material information array comprises a bit number element in any bit number set and an attribute element in the attribute set corresponding to the bit number set, and equivalently, all the bit number elements and all the attribute elements are grouped from the manifest file, wherein each bit number element related to the same attribute element is contained in one bit number set. After each bit number set and each attribute set are obtained, a bit number element can be taken out from any bit number set, and then an 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 attribute, the two materials are disposed at different positions on the printed circuit board, and thus, one attribute element may be associated with a plurality of bit number elements, and each bit number element is associated with only one attribute element. The preset format refers to a format that enables data in the material information array to be read by the query tool program, and in this embodiment, the write format of the material information array is a Part bit number element { Value attribute element }, where "Part" represents position number information and "Value" represents physical attribute information.
S0124, repeating the step S01231 until all the bit number elements and all the attribute elements related to the bit number elements are added.
And the step of adding the repeated data is equivalent to sequentially taking each bit number element and the attribute elements related to each bit number element as material information arrays and sequentially storing each material information array into the array conversion unit. When all the bit number elements and all the attribute elements associated with the bit number elements are written into the array conversion unit, the data transfer from the manifest file to the array conversion unit is completed.
As shown in fig. 3, taking the manifest file exemplified in step S01 as the manifest file before data transfer, the following is one example of an array conversion unit after data transfer,
*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, as long as each material information array is guaranteed to include the attribute elements and the bit number elements that are associated with each other.
As shown in fig. 5, S0125, sequentially updating the identifier and all material information arrays in the array conversion unit to the template file, and generating the query file.
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 detail, steps S011 to S012 can be performed by a computer EXE tool having defined rules, and the following is an example of the EXE tool. The software interface of the EXE tool comprises a selection list file key, a selection 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 box, and the operator can select a list file in a BOM format and import the list file into a memory of a computer; then, an operator can click a 'select template file button', an 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 perform data conversion key pressing, the EXE tool can create an array conversion unit, material information arrays are extracted from the imported list file, the identifier and each material information array are written into the array conversion unit, all data in the array conversion unit are written into the template file, and finally an ASC format query file is generated; finally, the operator can save the query file to the specified location.
As shown in fig. 2, S02 obtains all the bit number elements corresponding to the attribute elements by reading any one of the attribute elements in the query file.
All the bit number elements in the query file are associated with one attribute element in the query file, and when any one attribute element in the query file is selected, all the bit number elements associated with the attribute element in the query file can be acquired; after selecting any one of the physical attributes, all the location numbers associated with the physical attribute can be obtained.
S03, based on the acquired respective position number elements, displaying position number information associated with the respective position number elements.
And according to the acquired position number elements, the position number information represented by each position number element can be presented according to a specific display mode so as to be inquired by an operator. It is worth noting that the position number information of the material refers to the welding position on the printed circuit board of the material, so the position number information needs to be combined with a PCB file to represent the welding position of the material in the PCB layout.
Specifically, the steps S02-S03 can be completed by a query tool, for example, Pads Layout, and the operator can 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 associated number elements, and by combining preset material position distribution data in the PCB file and position number information of each number element, the query tool can light all positions corresponding to each number element in the PCB layout for an operator to query. By using the inquiry file and the inquiry tool, an operator can inquire the welding positions of the materials corresponding to the physical attributes on the printed circuit board by selecting any one of the physical attributes.
As shown in fig. 7, based on the above material query method, the specific method for the operator to manually weld the materials includes the following steps,
s001, opening an EXE tool in a computer, selecting a list file and a template file, and storing a query file;
s002, opening a query tool in the computer, and selecting a PCB file and a query file;
s003, selecting any one physical attribute, and taking out a sufficient amount of materials from a warehouse;
and S004, welding the materials at the corresponding positions according to the position numbers displayed by the query tool.
And S005, repeating the step S003 until all the 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 material in the embodiment of the application is as follows: the welding material is welded manually by the aid of the material query method, material query difficulty of operators can be reduced, work efficiency is improved, particularly when the situation that materials with the same physical attributes are more is faced, the operators can obtain position numbers of all the materials related to the physical attributes by selecting one of the physical attributes, and position number information and physical attribute information do not need to be checked one by one. If there are 100 materials with the same physical attribute, the operator only needs to select the physical attribute, the positions of the 100 materials are lighted up in the query tool, the positions of the 100 materials on the PCB are indicated, and then the operator welds the 100 materials on the PCB.
The method comprises the steps of acquiring data extracted from a bit number set and an attribute set in a list file, and converting the data into a query file, namely, a method for performing data conversion based on a BOM file and generating an ASC file which can be read by a query tool, wherein in the step of data conversion, the relevance between each position number and each physical attribute is established, namely, the step of checking each position number and each physical attribute one by one is completed, therefore, when an operator selects any one physical attribute, the checking work is finished in a system, and then each position number corresponding to the physical attribute is led out, so that the complexity and the query difficulty of manually querying material information are reduced, and the production efficiency is improved.
On the other hand, the list file is actually a BOM file directly provided by the manufacturer, the query file is actually an ASC file after the template file is updated, the method steps of data conversion can be directly completed through a self-defined EXE tool, an operator can generate the query file only by importing the preset file and the file provided by the manufacturer into the EXE tool, and the operation is simple and rapid. Along with the high-speed development of electronic technology, the types or the quantity of materials on the printed circuit board tend to be more and more, so that the technical difficulty of operators in welding the materials is more and more high, the material query method provided in the embodiment is one of direct means capable of relieving the current situation, the material welding complexity is reduced, and the design space of the printed circuit board is improved.
The embodiment of the invention also provides a material inquiry system for assisting the welding of the printed circuit board material,
as shown in fig. 8, the material query system corresponds to the material query method in the first embodiment one to one, and the system includes a query file generation module 1 and a material query display module 2. The functional blocks will be described in detail below,
the query file generation module 1 is configured to generate a query file based on a 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 attribute element corresponds to a bit number element disposed 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 query display module 2 is used for reading any attribute element in the query file to obtain all position number elements corresponding to the attribute element; and displaying position number information associated with each bit number element based on the acquired each bit number element.
Specifically, the query file generating module 1 further comprises,
the information acquisition submodule 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 data conversion sub-module 12 is used for obtaining 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 the template file based on each attribute set and each bit number set, and generating a query file; and each attribute set corresponds to each bit number set one to one, wherein the attribute sets comprise physical attribute information of the materials, and the bit number sets comprise position number information of the materials.
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 in the memory and operable on the processor, wherein the memory stores training data, algorithm formulas, filtering mechanisms, and the like in the training model. The processor is used for providing calculation and control capability, and the processor realizes the following steps when executing the computer program:
and S01, generating a query file based on the provided list file.
And S011, acquiring the manifest file and the template file.
S012, according to the storage strategy of the template, based on the list file acquisition at least one attribute set and at least one bit number set, based on each attribute set and each bit number set update the template file, generate the inquiry file.
S0121, establishing an array conversion unit.
S01X2, adding a mark, and storing the mark in the array conversion unit.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired from the manifest file.
S01231, based on the list file, obtaining at least one bit number set and at least one attribute set corresponding to each bit number set one by one.
S01232, writing a material information array in the array conversion unit according to a preset format.
S0124, repeating the step S01231 until all the bit number elements and all the attribute elements related to the bit number elements are added.
S0125, sequentially updating the identifier in the array conversion unit and all material information arrays into a template file to generate a query file.
And S02, reading any attribute element in the query file to obtain all position number elements corresponding to the attribute element.
S03, based on the acquired respective position number elements, displaying position number information associated with the respective position 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 executes the above-mentioned material query method, and when executed by the processor, implements the following steps,
and S01, generating a query file based on the provided list file.
And S011, acquiring the manifest file and the template file.
S012, according to the storage strategy of the template, based on the list file acquisition at least one attribute set and at least one bit number set, based on each attribute set and each bit number set update the template file, generate the inquiry file.
S0121, establishing an array conversion unit.
S01X2, adding a mark, and storing the mark in the array conversion unit.
S0123, adding data, and storing a material information array in the array conversion unit based on the data acquired from the manifest file.
S01231, based on the list file, obtaining at least one bit number set and at least one attribute set corresponding to each bit number set one by one.
S01232, writing a material information array in the array conversion unit according to a preset format.
S0124, repeating the step S01231 until all the bit number elements and all the attribute elements related to the bit number elements are added.
S0125, sequentially updating the identifier in the array conversion unit and all material information arrays into a template file to generate a query file.
And S02, reading any attribute element in the query file to obtain all position number elements corresponding to the attribute element.
S03, based on the acquired respective position number elements, displaying position number information associated with the respective position 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 (RAM), a magnetic disk or an optical disk, and various media capable of storing program codes.
The above embodiments are preferred embodiments of the present application, and the protection scope of the present application is not limited by the above embodiments, so: all equivalent changes made according to the structure and principle of the present application shall be covered by the protection scope of the present application.
Claims (10)
1. A query file generation method for assisting printed circuit board material welding is characterized by comprising the following steps,
acquiring a list file and a template file, wherein the template file is used for storing material information so as 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 a provided list file, updating a template file based on each attribute set and each bit number set, and generating a query file;
and each attribute set corresponds to each bit number set one to one, wherein the attribute sets comprise physical attribute information of the materials, and the bit number sets comprise position number information of the materials.
2. The method of claim 1, wherein in generating the query file by obtaining at least one attribute set and at least one bit number set based on the provided manifest file according to the template deposit policy, updating the 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 the array conversion unit, wherein the mark is used for marking physical attribute information and position number information for a query tool to mark;
data adding, namely storing a material information array in the array conversion unit based on the data acquired from the manifest file, wherein the material information array comprises attribute elements in an attribute set and a bit number element in a bit number set corresponding to the attribute set;
repeating the data adding step until all bit number elements and all attribute elements related to the bit number elements are added;
and sequentially updating the identifier in the array conversion unit and all material information arrays into the template file to generate a query file.
3. The method of claim 2, wherein the specific method of data addition comprises,
and writing a material information array in the array conversion unit according to a preset format, 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.
4. A material inquiry method for assisting material welding of a printed circuit board is characterized by comprising the following steps,
generating a query file based on a provided list file, wherein the query file comprises at least one material information array, each material information array comprises attribute elements and position number elements, any attribute element corresponds to the position number element arranged in the same material information array, the attribute elements comprise physical attribute information of materials, and the position number elements comprise position number information of the materials;
acquiring all bit number elements corresponding to the attribute elements by reading any attribute element in the query file;
based on the acquired respective number elements, position number information associated with the respective number elements is displayed.
5. The method according to any one of claims 1 to 4, wherein the manifest file is a BOM file.
6. The method according to any one of claims 1 to 4, wherein the template file and the query file are ASC files.
7. An inquiry file generating module for assisting the welding 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 the material information to generate a query file which can be read by a query tool;
the data conversion sub-module (12) is used for storing strategies according to the templates, acquiring at least one attribute set and at least one bit number set based on the provided list files, updating the template files based on the attribute sets and the bit number sets and generating query files; and each attribute set corresponds to each bit number set one to one, wherein the attribute sets comprise physical attribute information of the materials, and the bit number sets comprise position number information of the materials.
8. A material inquiry system for assisting material soldering of a printed circuit board, comprising the inquiry document generating module (1) of claim 7, said material inquiry system further comprising,
the material query display module (2) is used for reading any attribute element in the query file to obtain all position number elements corresponding to the attribute element; and displaying position number information associated with each bit number element based on the acquired each bit number element.
9. An intelligent terminal, comprising a memory and a processor, the memory having stored thereon a computer program that can be loaded by the processor and that executes the method according to any one of claims 1 to 6.
10. A computer-readable storage medium, in which a computer program is stored which can be loaded by a processor and which executes the method of any one of claims 1 to 6.
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 true CN113032337A (en) | 2021-06-25 |
| CN113032337B 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 |
|---|---|
| CN113032337B (en) | 2024-02-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109948134B (en) | Report automatic generation method, system, electronic equipment and storage medium | |
| CN111079387B (en) | Automatic questionnaire generation method and device, computer equipment and storage medium | |
| US20020095444A1 (en) | Information processing apparatus and method for making document | |
| CN105404507A (en) | Process template construction method and system | |
| CN109933311A (en) | A kind of information system creation method and relevant apparatus | |
| CN112162712A (en) | Label printing method and system based on template editing | |
| KR20040107383A (en) | Parts catalog creating system and program therefor | |
| CN112784037B (en) | Binary function visual demonstration system and binary function visual demonstration method based on VBA | |
| US20030069656A1 (en) | Part selection aiding system | |
| CN113032337A (en) | Material query method and system for assisting in welding printed circuit board material, intelligent terminal and computer readable storage medium | |
| CN102880893A (en) | Barcode displaying method | |
| CN113467369B (en) | Automatic drilling and riveting numerical control code visual interactive correction method | |
| JP3126774B2 (en) | Drawing editing device and drawing editing method | |
| JP2000099545A (en) | Manufacture of recording medium | |
| CN114092641A (en) | Method, device and equipment for generating wiring board drawing and readable storage medium | |
| CN112199929A (en) | Form processing method and device, storage medium and electronic equipment | |
| 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 | |
| CN113360721B (en) | Music score real-time inter-translation method and terminal | |
| CN112232032B (en) | Automatic conversion method for content style of docx document | |
| CN112883448A (en) | Tire sidewall font graph parameter returning method | |
| JP2004133784A (en) | Method and device for publishing database | |
| JPH09153079A (en) | Drawing preparation system | |
| KR100216068B1 (en) | A method of converting dxf data format to informap database | |
| JPS59109967A (en) | System for inputting-outputting drawing for plant design calculation |
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 |