CN111080208A - BOM (bill of material) matching device and method, electronic equipment and storage medium - Google Patents
BOM (bill of material) matching device and method, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN111080208A CN111080208A CN201911379406.4A CN201911379406A CN111080208A CN 111080208 A CN111080208 A CN 111080208A CN 201911379406 A CN201911379406 A CN 201911379406A CN 111080208 A CN111080208 A CN 111080208A
- Authority
- CN
- China
- Prior art keywords
- product
- information
- matching
- preset
- matched
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a BOM (bill of material) bill matching device, method, equipment and medium, comprising the following steps: the file acquisition module is used for acquiring a BOM file and determining information of a product to be matched in the BOM file; the list acquisition module is used for acquiring a preset packaging code list; the product matching module is used for searching whether target product information corresponding to the information of the product to be matched exists in a preset product library; and the information modification module is used for modifying the information of the product to be matched according to the preset packaging code table if the product is not matched, and re-matching the modified product information in a preset product library. The method and the device introduce the preset packaging code table for storing the corresponding relation between the brands and the packaging codes, modify the information to be matched by using the preset packaging code table after the original information is not successfully matched, and then can use the modified product information to re-match the product information with different packaging standards in the preset product library, thereby increasing the recognition probability of the information to be matched and improving the automatic matching rate of the system.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a BOM billing apparatus, a method, an electronic device, and a computer-readable storage medium.
Background
Electronic components are a general term for various electronic components and electronic devices, and are classified into two major categories, i.e., active components and passive components, according to whether an external energy source is required during operation. The passive element is a circuit component which does not contain a controlled power supply and comprises a capacitor, a resistor, an inductor and the like; the active elements include discrete devices, Integrated Circuits (ICs), and the like. There are more than five hundred million models and many varieties of electronic components all over the world.
BOM (bill of materials) refers to the list of parts and the composition structure required by a product, i.e. the sub-parts required for producing a product and the complete combination of the number of parts in the product. In the manufacture of electronic products, engineers make product design plans according to product requirements, and manufacture BOMs based on the product design plans. BOM bill matching refers to the process of purchasing corresponding materials according to BOM requirements by bill matching personnel. In the actual matching process, a user is required to give an original model, but the original model may be lack of characters or multiple characters due to irregular writing, so that the model cannot be correctly recognized, and the automatic matching rate of the system is reduced. Therefore, how to solve the above problems is a great concern for those skilled in the art.
Disclosure of Invention
The application aims to provide a BOM matching device, a BOM matching method, electronic equipment and a computer readable storage medium, which can increase the recognition probability of information to be matched and improve the automatic matching rate of a system.
To achieve the above object, the present application provides a BOM billing device, including:
the file acquisition module is used for acquiring a BOM file and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand;
the list acquisition module is used for acquiring a preset packaging code list; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
the product matching module is used for matching the information of the product to be matched in a preset product library and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library;
the information modification module is used for modifying the product information to be matched according to the preset packaging code table if the product information to be matched is not matched with the preset product library, and the modified product information is used for carrying out re-matching in the preset product library;
and the information returning module is used for returning all the target product information in the matching result to the interactive interface so as to select the specified supplier through the interactive interface based on all the target product information and complete the bill matching of the BOM file.
Optionally, the information modifying module includes:
the code searching unit is used for searching all corresponding target packaging codes in the preset packaging code table according to the labels in the information of the products to be matched;
the first modification unit is used for sequentially adding all the target packaging codes to the tail part of the original electronic component model in the product information to be matched to obtain a first type of modified model;
and the first matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the modified model of the first type.
Optionally, the information modifying module further includes:
the code matching unit is used for matching all the target packaging codes with the tail part of the original electronic element model in sequence if the product information containing the first modified model fails to be matched;
the second modification unit is used for deleting the current packaging code at the tail part of the original electronic component model to obtain a second type of modified model if the target packaging code is successfully matched with the tail part of the original electronic component model;
and the second matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the second type of modified model.
Optionally, the information modifying module further includes:
a third modification unit, configured to, if matching of the product information including the second type of modified model fails, sequentially add all the target package codes to a tail of the second type of modified model to obtain a third type of modified model;
and the third matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the third type of modified model.
Optionally, the information returning module includes:
the information display unit is used for returning all target product information in the matching result to the interactive interface so as to display the supplier names, product inventory, order amount and product price corresponding to all the target product information;
and the instruction receiving unit is used for receiving a selection instruction aiming at a supplier and issued by a user according to the goods requirement and the target product information through the interactive interface.
In order to achieve the above object, the present application provides a BOM billing method, including:
acquiring a BOM file, and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand;
acquiring a preset packaging code table; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
matching the information of the product to be matched in a preset product library by utilizing the information of the product to be matched, and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library;
if the target product information does not exist in the preset product library, modifying the product information to be matched according to the preset packaging code table, and performing re-matching in the preset product library by using the modified product information;
and returning all target product information in the matching result to an interactive interface so as to select a specified supplier through the interactive interface based on all the target product information and complete the bill of the BOM file.
Optionally, the modifying the information of the product to be matched according to the preset package code table, and performing re-matching in the preset product library by using the modified product information includes:
searching all corresponding target packaging codes in the preset packaging code table according to the labels in the information of the products to be matched;
sequentially adding all the target packaging codes to the tail part of the original electronic component model in the product information to be matched to obtain a first type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the modified model of the first type.
Optionally, after the product information including the first type of modified model is re-matched in the preset product library, the method further includes:
if the product information containing the first modified type fails to be matched, sequentially matching the tail parts of the original electronic element types by using all the target packaging codes;
if the target package code is successfully matched with the tail part of the original electronic component model, deleting the current package code at the tail part of the original electronic component model to obtain a second type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the second type of modified model.
Optionally, after the product information including the second type of modified model is re-matched in the preset product library, the method further includes:
if the product information containing the second type of modified model fails to be matched, sequentially adding all the target packaging codes to the tail part of the second type of modified model to obtain a third type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the third type of modified model.
To achieve the above object, the present application provides an electronic device including:
a memory for storing a computer program;
a processor for implementing the steps of any of the aforementioned BOM billing methods when executing the computer program.
To achieve the above object, the present application provides a computer-readable storage medium, on which a computer program is stored, the computer program, when being executed by a processor, implementing the steps of any one of the BOM billing methods disclosed in the foregoing disclosure.
According to the above scheme, the BOM billing device provided by the present application includes: the file acquisition module is used for acquiring a BOM file and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand; the list acquisition module is used for acquiring a preset packaging code list; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes; the product matching module is used for matching the information of the product to be matched in a preset product library and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library; the information modification module is used for modifying the product information to be matched according to the preset packaging code table if the product information to be matched is not matched with the preset product library, and the modified product information is used for carrying out re-matching in the preset product library; and the information returning module is used for returning all the target product information in the matching result to the interactive interface so as to select the specified supplier through the interactive interface based on all the target product information and complete the bill matching of the BOM file. According to the method and the device, the preset packaging code table used for storing the corresponding relation between the labels and the packaging codes is introduced, after the original information to be matched is not successfully matched, the information to be matched is modified by using the preset packaging code table, and then the modified product information can be used for being matched with the product information of different packaging standards in the preset product library again, so that the recognition probability of the information to be matched is increased, and the automatic matching rate of the system is improved.
The application also discloses a BOM (bill of material) allocation method, an electronic device and a computer readable storage medium, and the technical effects can be realized.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a block diagram of a BOM billing device disclosed in an embodiment of the present application;
FIG. 2 is a detailed structural diagram of an information modification module disclosed in an embodiment of the present application;
FIG. 3 is a flowchart of a BOM billing method disclosed in an embodiment of the present application;
FIG. 4 is a schematic diagram of a specific BOM recipe method disclosed in an embodiment of the present application;
fig. 5 is a block diagram of an electronic device disclosed in an embodiment of the present application;
fig. 6 is a block diagram of another electronic device disclosed in the embodiments of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. 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 application.
In the prior art, in the actual matching process, a user is required to give an original model, but the original model may be lack of characters or multiple characters due to irregular writing, so that the model cannot be correctly recognized, and the automatic matching rate of the system is reduced.
Therefore, the embodiment of the application discloses a BOM matching device, which increases the recognition probability of the information to be matched and improves the automatic matching rate of the system.
Referring to fig. 1, a BOM billing apparatus disclosed in the embodiment of the present application includes:
the file acquisition module 11 is configured to acquire a BOM file, and determine that the BOM file includes an original electronic component model and product information to be matched of a brand;
in the embodiment of the application, a BOM file designed by an engineer according to product requirements is obtained, and information of a product to be matched is determined from the BOM file. The product information to be matched comprises an original electronic component model and a corresponding brand input by a user. It can be understood that each electronic component has a model assigned by its original manufacturer according to a specific rule, the specific rule that the original manufacturer of the electronic component defines its product model is an electronic component naming rule, and the corresponding electronic component can be precisely located in a mode of adding a manufacturer according to the model.
A list obtaining module 12, configured to obtain a preset package code list; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
it should be noted that, in the embodiment of the present application, a preset package code table is created in advance, where all package codes corresponding to the brand and each factory are specifically stored. Naming rules of various factories for electronic components are different, wherein the model suffix comprises a performance code, an environmental protection code and a packaging code, and the performance code represents the working performance of the chip, such as the working frequency of a processor, the response speed of a memory chip and the like; the environmental protection code represents the corresponding environmental protection grade, and different models of the environmental protection code cannot be completely replaced; the packaging code means that only the packaging mode and the number are different, the products have no difference, and the models with different packaging codes can be mutually replaced.
In order to avoid selecting wrong environment-friendly code models, the environment-friendly suffix can be removed from the package code in the preset package code table in the embodiment of the application, so that the different models of the environment-friendly suffix are prevented from being identified as the same model.
The product matching module 13 is configured to match the information of the product to be matched in a preset product library, and find whether target product information corresponding to the information of the product to be matched exists in the preset product library;
in specific implementation, the information of the product to be matched, including the original electronic component model and the brand, can be used for matching in a preset product library, and if the original electronic component model input by the user is accurate, the corresponding target product information can be matched in the preset product library.
The information modification module 14 is configured to modify the information of the product to be matched according to the preset package code table if the matching result is not obtained, and re-match the modified information of the product in the preset product library;
if the target product information corresponding to the to-be-matched product information cannot be found in the preset product library, modifying the to-be-matched product information by using a packaging code corresponding to a brand in the current to-be-matched product information stored in the preset packaging code table, for example, adding a packaging code to the electronic component model, deleting the packaging code, and the like to obtain modified product information, and matching the modified product information in the preset product library again to obtain electronic components with the same models of different packaging codes through matching.
And the information returning module 15 is configured to return all target product information in the matching result to the interactive interface, so that a specified supplier is selected through the interactive interface based on all the target product information, and the bill of the BOM file is completed.
It can be understood that, in the actual order matching process, the matching staff needs to purchase the lowest-price material under the condition of meeting the model requirement in addition to purchasing the correct electronic components according to the BOM requirement so as to reduce the product cost. Therefore, all target product information obtained by successful matching can be returned to the interactive interface to be displayed to the order matching personnel, the order matching personnel can determine the target product with the lowest price according to the content displayed by the interactive interface, and select the corresponding supplier to complete the order matching of the BOM file.
The information returning module 15 may specifically include: the information display unit is used for returning all target product information in the matching result to the interactive interface so as to display the supplier names, product inventory, order amount and product price corresponding to all the target product information; and the instruction selection unit is used for receiving a selection instruction aiming at a supplier and issued by a user according to the goods requirement and the target product information through the interactive interface. That is, the basic information of the target product information can be displayed for the user, so that the user can select the supplier with the product inventory and the order amount meeting the demand quantity of goods and the lowest product price according to the basic information, and the cost is effectively saved.
According to the above scheme, the BOM billing device provided by the present application includes: the file acquisition module is used for acquiring a BOM file and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand; the list acquisition module is used for acquiring a preset packaging code list; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes; the product matching module is used for matching the information of the product to be matched in a preset product library and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library; the information modification module is used for modifying the product information to be matched according to the preset packaging code table if the product information to be matched is not matched with the preset product library, and the modified product information is used for carrying out re-matching in the preset product library; and the information returning module is used for returning all the target product information in the matching result to the interactive interface so as to select the specified supplier through the interactive interface based on all the target product information and complete the bill matching of the BOM file. According to the method and the device, the preset packaging code table used for storing the corresponding relation between the labels and the packaging codes is introduced, after the original information to be matched is not successfully matched, the information to be matched is modified by using the preset packaging code table, and then the modified product information can be used for being matched with the product information of different packaging standards in the preset product library again, so that the recognition probability of the information to be matched is increased, and the automatic matching rate of the system is improved.
The embodiment of the present application discloses another BOM billing device, and compared with the previous embodiment, the present embodiment further describes and optimizes the technical scheme for the information modification module 14. Referring to fig. 2, in particular, the information modification module 14 may include:
the code searching unit 41 is configured to search all target package codes corresponding to the preset package code table according to the labels in the information of the products to be matched;
the first modifying unit 42 is configured to sequentially add all the target package codes to the tail of the original electronic component model in the product information to be matched, so as to obtain a first type of modified model;
a first matching unit 43, configured to perform re-matching in the preset product library by using the product information including the first type of modified model;
in the embodiment of the application, if the target product information corresponding to the information of the product to be matched cannot be found in the preset product library, the information of the product to be matched is modified by using the packaging code corresponding to the brand in the information of the product to be matched currently stored in the preset packaging code table. Specifically, all target package codes corresponding to the labels in the current product information to be matched in the preset package code table are obtained. And then all the target package codes are sequentially added to the tail part of the original electronic component model for matching and identification.
A code matching unit 44, configured to, if matching of the product information including the first type of modified model fails, sequentially match the tail of the original electronic component model with all the target package codes;
a second modifying unit 45, configured to delete the current package code at the tail of the original electronic component model if the target package code is successfully matched with the tail of the original electronic component model, so as to obtain a second type of modified model;
a second matching unit 46, configured to perform re-matching in the preset product library by using the product information including the second type of modified model;
and if the corresponding target product information cannot be successfully matched in the preset product library after all the target packaging codes are sequentially added to the tail part of the original electronic component model for matching and identification, sequentially matching the tail part of the original electronic component model by using all the target packaging codes. If the matching is successful, the current original electronic component model is represented to designate a packaging code, and the packaging code can be deleted and then matched again so as to match the target product information of different packaging codes of the model.
A third modifying unit 47, configured to, if matching of the product information including the second type of modified model fails, sequentially add all the target package codes to a tail of the second type of modified model to obtain a third type of modified model;
a third matching unit 48, configured to perform a re-matching in the preset product library by using the product information including the third type of modified model.
If the corresponding target product information cannot be matched after the modification of adding and deleting the packaging codes, all the target packaging codes are sequentially added at the tail part of the second type of modified model of the deleted packaging codes for re-matching so as to improve the model matching rate of the system.
In the following, a BOM list matching method provided by an embodiment of the present application is introduced, and a BOM list matching method described below and a BOM list matching apparatus described above may be referred to each other.
Referring to fig. 3, a BOM-issuer method provided in the embodiment of the present application includes:
s101: acquiring a BOM file, and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand;
s102: acquiring a preset packaging code table; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
s103: matching the information of the product to be matched in a preset product library by utilizing the information of the product to be matched, and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library;
s104: if the target product information does not exist in the preset product library, modifying the product information to be matched according to the preset packaging code table, and performing re-matching in the preset product library by using the modified product information;
in this step, the process of modifying the information of the product to be matched according to the preset package code table and performing re-matching in the preset product library by using the modified product information may specifically include: searching all corresponding target packaging codes in the preset packaging code table according to the labels in the information of the products to be matched; sequentially adding all the target packaging codes to the tail part of the original electronic component model in the product information to be matched to obtain a first type of modified model; and carrying out re-matching in the preset product library by utilizing the product information containing the modified model of the first type.
If the product information containing the first modified type fails to be matched, sequentially matching the tail parts of the original electronic element types by using all the target packaging codes; if the target package code is successfully matched with the tail part of the original electronic component model, deleting the current package code at the tail part of the original electronic component model to obtain a second type of modified model; and carrying out re-matching in the preset product library by utilizing the product information containing the second type of modified model.
If the product information containing the second type of modified model fails to be matched, sequentially adding all the target packaging codes to the tail part of the second type of modified model to obtain a third type of modified model; and carrying out re-matching in the preset product library by utilizing the product information containing the third type of modified model.
S105: and returning all target product information in the matching result to an interactive interface so as to select a specified supplier through the interactive interface based on all the target product information and complete the bill of the BOM file.
For the specific implementation process of the above steps, reference may be made to the corresponding contents disclosed in the foregoing embodiments, and details are not repeated here.
Next, a specific example is used to introduce the BOM recipe method provided in the embodiment of the present application, as shown in fig. 4, specifically, according to the determined recipe model a and the brand X, an accurate matching is performed in a preset commodity library, N matching results meeting the requirement of the model a, the model a and the package code 1, or the model a and the package code 2, and the brand X are found, and a result meeting the requirement of the required quantity is selected from the N matching results, so as to preferentially select a matching result with the lowest price, that is, a result 4.
For example, if the correct and complete model of the electronic component is: AD626AR-REEL7, where-REEL 7 is the package code, and the original electronic component model number entered by the user due to irregular writing is: AD626 arrel 7. According to the BOM matching method provided by the embodiment, matching identification is carried out in a commodity library according to the original electronic component model input by a user. The matching result fails because the model input is incorrect. After the matching fails, acquiring a package code suffix corresponding to the brand input by the user from the preset package code table, wherein the current brand is an ADI brand, and the corresponding package code suffix can include REEL, REEL7, -REEL7, RL7, -RL7 and the like. And adding all package code tailors in sequence by utilizing the original electronic component model, and inputting the package code tailors into a commodity library for re-matching. Matching fails because the original electronic component model, after being added with the package code suffix, still does not belong to the correct model. And then matching the tail of the original electronic element model by using the package code tail affix corresponding to the current brand, namely successfully matching when the package code tail affix is matched with the REEL7, deleting the REEL7 from the tail of the original electronic element model, and obtaining the modified electronic element model AD626 AR. And the AD626AR is the correct product model, and the matching is successful when the matching is performed again in the commodity library. After a successful match of the AD626AR, the system compares this model with the AD626AR-REEL7, i.e., the model with the large number of package tailors added, according to the rules shown in fig. 4, and selects the lower priced AD626AR-REEL7 from the model.
Generally, model prices corresponding to a large number of packages in a standard package of electronic components are 5% to 20% lower than model prices corresponding to a small number of packages, so that more choices are provided for users on the premise of meeting the model requirements of the users in the embodiment of the application, that is, products of the same model and different package specifications may be provided with product choices of lower prices, and the purchase cost of the products is reduced.
The present application further provides an electronic device, and as shown in fig. 5, an electronic device provided in an embodiment of the present application includes:
a memory 100 for storing a computer program;
the processor 200, when executing the computer program, may implement the steps provided by the above embodiments.
Specifically, the memory 100 includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer-readable instructions, and the internal memory provides an environment for the operating system and the computer-readable instructions in the non-volatile storage medium to run. The processor 200 may be a Central Processing Unit (CPU), a controller, a microcontroller, a microprocessor or other data processing chip in some embodiments, and provides computing and controlling capability for the electronic device, and when executing the computer program stored in the memory 100, the steps of the BOM billing method disclosed in any of the foregoing embodiments may be implemented.
On the basis of the above embodiment, as a preferred implementation, referring to fig. 6, the electronic device further includes:
and an input interface 300 connected to the processor 200, for acquiring computer programs, parameters and instructions imported from the outside, and storing the computer programs, parameters and instructions into the memory 100 under the control of the processor 200. The input interface 300 may be connected to an input device for receiving parameters or instructions manually input by a user. The input device may be a touch layer covered on a display screen, or a button, a track ball or a touch pad arranged on a terminal shell, or a keyboard, a touch pad or a mouse, etc.
And a display unit 400 connected to the processor 200 for displaying data processed by the processor 200 and for displaying a visualized user interface. The display unit 400 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch panel, or the like.
And a network port 500 connected to the processor 200 for performing communication connection with each external terminal device. The communication technology adopted by the communication connection can be a wired communication technology or a wireless communication technology, such as a mobile high definition link (MHL) technology, a Universal Serial Bus (USB), a High Definition Multimedia Interface (HDMI), a wireless fidelity (WiFi), a bluetooth communication technology, a low power consumption bluetooth communication technology, an ieee802.11 s-based communication technology, and the like.
While FIG. 6 shows only an electronic device having the assembly 100 and 500, those skilled in the art will appreciate that the configuration shown in FIG. 6 is not intended to be limiting of electronic devices and may include fewer or more components than those shown, or some components may be combined, or a different arrangement of components.
The present application also provides a computer-readable storage medium, which may include: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk. The storage medium stores thereon a computer program which, when executed by a processor, implements the steps of the BOM billing method disclosed in any of the foregoing embodiments.
The method and the device introduce the preset packaging code table for storing the corresponding relation between the labels and the packaging codes, modify the information to be matched by using the preset packaging code table after the original information to be matched is not successfully matched, and then can use the modified product information to re-match the product information with different packaging standards in the preset product library, thereby increasing the recognition probability of the information to be matched and improving the automatic matching rate of the system.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. For the system disclosed by the embodiment, the description is relatively simple because the system corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make several improvements and modifications to the present application without departing from the principle of the present application, and such improvements and modifications also fall within the scope of the claims of the present application.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Claims (11)
1. A BOM billing device, comprising:
the file acquisition module is used for acquiring a BOM file and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand;
the list acquisition module is used for acquiring a preset packaging code list; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
the product matching module is used for matching the information of the product to be matched in a preset product library and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library;
the information modification module is used for modifying the product information to be matched according to the preset packaging code table if the product information to be matched is not matched with the preset product library, and the modified product information is used for carrying out re-matching in the preset product library;
and the information returning module is used for returning all the target product information in the matching result to the interactive interface so as to select the specified supplier through the interactive interface based on all the target product information and complete the bill matching of the BOM file.
2. The BOM orchestration device according to claim 1, wherein the information modification module comprises:
the code searching unit is used for searching all corresponding target packaging codes in the preset packaging code table according to the labels in the information of the products to be matched;
the first modification unit is used for sequentially adding all the target packaging codes to the tail part of the original electronic component model in the product information to be matched to obtain a first type of modified model;
and the first matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the modified model of the first type.
3. The BOM billing device of claim 2 wherein the information modification module further comprises:
the code matching unit is used for matching all the target packaging codes with the tail part of the original electronic element model in sequence if the product information containing the first modified model fails to be matched;
the second modification unit is used for deleting the current packaging code at the tail part of the original electronic component model to obtain a second type of modified model if the target packaging code is successfully matched with the tail part of the original electronic component model;
and the second matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the second type of modified model.
4. The BOM orchestration device according to claim 3, wherein the information modification module further comprises:
a third modification unit, configured to, if matching of the product information including the second type of modified model fails, sequentially add all the target package codes to a tail of the second type of modified model to obtain a third type of modified model;
and the third matching unit is used for carrying out re-matching in the preset product library by utilizing the product information containing the third type of modified model.
5. The BOM orchestration device according to any one of claims 1-4, wherein the information return module comprises:
the information display unit is used for returning all target product information in the matching result to the interactive interface so as to display the supplier names, product inventory, order amount and product price corresponding to all the target product information;
and the instruction receiving unit is used for receiving a selection instruction aiming at a supplier and issued by a user according to the goods requirement and the target product information through the interactive interface.
6. A BOM (bill of material) matching method is characterized by comprising the following steps:
acquiring a BOM file, and determining that the BOM file comprises the model of an original electronic element and the information of a product to be matched of a brand;
acquiring a preset packaging code table; the preset packaging code table is a list which is established in advance and used for storing the corresponding relation between the brands and the packaging codes;
matching the information of the product to be matched in a preset product library by utilizing the information of the product to be matched, and searching whether target product information corresponding to the information of the product to be matched exists in the preset product library;
if the target product information does not exist in the preset product library, modifying the product information to be matched according to the preset packaging code table, and performing re-matching in the preset product library by using the modified product information;
and returning all target product information in the matching result to an interactive interface so as to select a specified supplier through the interactive interface based on all the target product information and complete the bill of the BOM file.
7. The BOM matching method according to claim 6, wherein the modifying the product information to be matched according to the preset package code table and the re-matching in the preset product library by using the modified product information comprises:
searching all corresponding target packaging codes in the preset packaging code table according to the labels in the information of the products to be matched;
sequentially adding all the target packaging codes to the tail part of the original electronic component model in the product information to be matched to obtain a first type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the modified model of the first type.
8. The BOM billing method of claim 7, wherein after the re-matching in the preset product library using the product information containing the first type of modified model, further comprising:
if the product information containing the first modified type fails to be matched, sequentially matching the tail parts of the original electronic element types by using all the target packaging codes;
if the target package code is successfully matched with the tail part of the original electronic component model, deleting the current package code at the tail part of the original electronic component model to obtain a second type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the second type of modified model.
9. The BOM-recipe method of claim 8, wherein after the re-matching in the predetermined product library using the product information including the second type of modified model, further comprising:
if the product information containing the second type of modified model fails to be matched, sequentially adding all the target packaging codes to the tail part of the second type of modified model to obtain a third type of modified model;
and carrying out re-matching in the preset product library by utilizing the product information containing the third type of modified model.
10. An electronic device, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the BOM billing method of any of claims 6 to 9 when executing said computer program.
11. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the steps of the BOM billing method according to any of claims 6 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911379406.4A CN111080208B (en) | 2019-12-27 | 2019-12-27 | BOM (bill of material) matching device and method, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911379406.4A CN111080208B (en) | 2019-12-27 | 2019-12-27 | BOM (bill of material) matching device and method, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111080208A true CN111080208A (en) | 2020-04-28 |
| CN111080208B CN111080208B (en) | 2020-09-01 |
Family
ID=70318722
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911379406.4A Active CN111080208B (en) | 2019-12-27 | 2019-12-27 | BOM (bill of material) matching device and method, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111080208B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112580685A (en) * | 2020-11-19 | 2021-03-30 | 青岛檬豆网络科技有限公司 | MLCC (multilayer ceramic capacitor) capacitance parameter matching method |
| CN112613660A (en) * | 2020-12-23 | 2021-04-06 | 云汉芯城（上海）互联网科技股份有限公司 | Order matching method, device and storage medium |
| CN112633802A (en) * | 2020-12-23 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Material matching method and system, electronic equipment and computer storage medium |
| CN112722766A (en) * | 2020-12-25 | 2021-04-30 | 苏州索芙特威尔软件科技有限公司 | Feeding error-proofing control method and system |
| CN113051450A (en) * | 2021-03-12 | 2021-06-29 | 云汉芯城（上海）互联网科技股份有限公司 | Device model automatic classification method and device, storage medium and equipment |
| CN113627136A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Component recommendation method, device and system |
| CN114022086A (en) * | 2022-01-06 | 2022-02-08 | 深圳前海硬之城信息技术有限公司 | Purchasing method, device, equipment and storage medium based on BOM identification |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479256A (en) * | 2010-11-25 | 2012-05-30 | 爱信艾达株式会社 | Searching device, searching method and computer-readable storage medium |
| CN105068994A (en) * | 2015-08-13 | 2015-11-18 | 易保互联医疗信息科技（北京）有限公司 | Natural language processing method and system for drug information |
| CN106202240A (en) * | 2016-06-29 | 2016-12-07 | 华能国际电力股份有限公司 | Materiel code data processing method and device |
| CN108268604A (en) * | 2017-12-25 | 2018-07-10 | 广州视源电子科技股份有限公司 | BOM tables data transfer device, system |
| CN108388743A (en) * | 2018-03-06 | 2018-08-10 | 深圳市图敏智能视频股份有限公司 | A kind of bill of materials method for sorting |
| CN108629174A (en) * | 2018-05-08 | 2018-10-09 | 阿里巴巴集团控股有限公司 | The method and device of character string verification |
| CN109754200A (en) * | 2017-11-07 | 2019-05-14 | 深圳前海硬之城信息技术有限公司 | Bill of material management method, apparatus and computer readable storage medium |
| CN110502384A (en) * | 2019-08-28 | 2019-11-26 | 云汉芯城（上海）互联网科技股份有限公司 | Parameter verification method, apparatus, equipment and the storage medium of electronic component |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| WO2019235966A1 (en) * | 2018-06-08 | 2019-12-12 | Obchestvo S Ogranichennoy Otvetstvennostyu "Maxima Group" | Method for automated inventory control of imported products delivery |
-
2019
- 2019-12-27 CN CN201911379406.4A patent/CN111080208B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479256A (en) * | 2010-11-25 | 2012-05-30 | 爱信艾达株式会社 | Searching device, searching method and computer-readable storage medium |
| CN105068994A (en) * | 2015-08-13 | 2015-11-18 | 易保互联医疗信息科技（北京）有限公司 | Natural language processing method and system for drug information |
| CN106202240A (en) * | 2016-06-29 | 2016-12-07 | 华能国际电力股份有限公司 | Materiel code data processing method and device |
| CN109754200A (en) * | 2017-11-07 | 2019-05-14 | 深圳前海硬之城信息技术有限公司 | Bill of material management method, apparatus and computer readable storage medium |
| CN108268604A (en) * | 2017-12-25 | 2018-07-10 | 广州视源电子科技股份有限公司 | BOM tables data transfer device, system |
| CN108388743A (en) * | 2018-03-06 | 2018-08-10 | 深圳市图敏智能视频股份有限公司 | A kind of bill of materials method for sorting |
| CN108629174A (en) * | 2018-05-08 | 2018-10-09 | 阿里巴巴集团控股有限公司 | The method and device of character string verification |
| WO2019235966A1 (en) * | 2018-06-08 | 2019-12-12 | Obchestvo S Ogranichennoy Otvetstvennostyu "Maxima Group" | Method for automated inventory control of imported products delivery |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN110502384A (en) * | 2019-08-28 | 2019-11-26 | 云汉芯城（上海）互联网科技股份有限公司 | Parameter verification method, apparatus, equipment and the storage medium of electronic component |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112580685A (en) * | 2020-11-19 | 2021-03-30 | 青岛檬豆网络科技有限公司 | MLCC (multilayer ceramic capacitor) capacitance parameter matching method |
| CN112580685B (en) * | 2020-11-19 | 2022-10-28 | 青岛檬豆网络科技有限公司 | MLCC (multilayer ceramic capacitor) capacitor parameter matching method |
| CN112613660A (en) * | 2020-12-23 | 2021-04-06 | 云汉芯城（上海）互联网科技股份有限公司 | Order matching method, device and storage medium |
| CN112633802A (en) * | 2020-12-23 | 2021-04-09 | 云汉芯城（上海）互联网科技股份有限公司 | Material matching method and system, electronic equipment and computer storage medium |
| CN112722766A (en) * | 2020-12-25 | 2021-04-30 | 苏州索芙特威尔软件科技有限公司 | Feeding error-proofing control method and system |
| CN112722766B (en) * | 2020-12-25 | 2023-03-14 | 苏州索芙特威尔软件科技有限公司 | Feeding error-proofing control method and system |
| CN113051450A (en) * | 2021-03-12 | 2021-06-29 | 云汉芯城（上海）互联网科技股份有限公司 | Device model automatic classification method and device, storage medium and equipment |
| CN113051450B (en) * | 2021-03-12 | 2023-04-07 | 云汉芯城（上海）互联网科技股份有限公司 | Device model automatic classification method and device, storage medium and equipment |
| CN113627136A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | Component recommendation method, device and system |
| CN114022086A (en) * | 2022-01-06 | 2022-02-08 | 深圳前海硬之城信息技术有限公司 | Purchasing method, device, equipment and storage medium based on BOM identification |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111080208B (en) | 2020-09-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111080208B (en) | BOM (bill of material) matching device and method, electronic equipment and storage medium | |
| CN112837118B (en) | Commodity recommendation method and device for enterprise users | |
| US20190392374A1 (en) | Computer processing method executed on goods shipment management system | |
| CN106372961A (en) | Commodity recommendation method and device | |
| CN105718184A (en) | Data processing method and apparatus | |
| CN103578008A (en) | Method and device for recommending garment products | |
| CN109903111A (en) | For the sort method of personalized recommendation, order models training method and ordering system | |
| CN108334568A (en) | Source of houses method for pushing, device, equipment and computer readable storage medium | |
| CN106919625A (en) | A kind of internet customer attribute recognition methods and device | |
| CN111027895A (en) | Stock prediction and behavior data collection method, apparatus, device and medium for commodity | |
| CN103699549B (en) | The renewal of a kind of graphic code storehouse, querying method and relevant apparatus | |
| CN112044784B (en) | Intelligent object carrying box matching method, equipment and storage medium | |
| CN113779460A (en) | Information display method and device, electronic equipment and storage medium | |
| CN112053211A (en) | Method of laying out commodities, apparatus for laying out commodities, electronic device, and readable storage medium | |
| CN110276660A (en) | A kind of goods distribution method, device and its system | |
| CN111986553B (en) | Method, device and storage medium for map association based on semantic label | |
| US10672053B1 (en) | Systems, manufactures, and methods for comparative bid analysis and purchase order preparation | |
| CN107146098B (en) | Advertisement operation configuration method and equipment | |
| CN111460347A (en) | Page browsing control method and device and computer readable storage medium | |
| KR20220020605A (en) | Electronic logistics management system and logistics management method to manage safety inventory | |
| CN113034067A (en) | Warehouse management method, computer device and readable storage medium | |
| KR20100044394A (en) | Method and server for searching commodity | |
| CN110335417A (en) | The application system and method for electronics water ticket | |
| CN105677776A (en) | Data processing method and device | |
| CN101518174A (en) | Inventory manager for PCB manufacturing |
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 |