CN107239923B - Method and device for generating material application form - Google Patents
Method and device for generating material application form Download PDFInfo
- Publication number
- CN107239923B CN107239923B CN201710426707.2A CN201710426707A CN107239923B CN 107239923 B CN107239923 B CN 107239923B CN 201710426707 A CN201710426707 A CN 201710426707A CN 107239923 B CN107239923 B CN 107239923B
- Authority
- CN
- China
- Prior art keywords
- characteristic value
- data
- application form
- material number
- empty
- 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.)
- Expired - Fee Related
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
Abstract
The invention discloses a method and a device for generating a material application form. The method comprises the following steps: acquiring an original BOM generated according to a design drawing; acquiring a column where a characteristic value in the original BOM is located, wherein the characteristic value comprises a material number; reading characteristic value data corresponding to each row according to the column of the characteristic values; and generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the column of the material number is empty and the characteristic value data corresponding to each row and the column of the characteristic value, wherein the material application form comprises a purchased material application form and/or a material application form of a spare part. The invention improves the generation efficiency of the material application form, avoids the possibility of artificial mistakes and improves the accuracy of the generated material application form.
Description
Technical Field
The embodiment of the invention relates to a data processing technology, in particular to a method and a device for generating a material application form.
Background
In the process of designing a project, an engineer needs to complete a design drawing firstly, then generates an original BOM (Bill of Material ) according to the design drawing, and manually fills Material information into a corresponding Excel form according to the original BOM by the engineer to output a corresponding Material application form.
Because the material application form is generated by an engineer according to the initial BOM through manual editing, the problems of low efficiency and easy error exist.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for generating a material application form, so as to improve the generation efficiency and accuracy of the material application form.
In a first aspect, an embodiment of the present invention provides a method for generating a material application form, where the method includes:
acquiring an original BOM generated according to a design drawing;
acquiring a column where a characteristic value in the original BOM is located, wherein the characteristic value comprises a material number;
reading characteristic value data corresponding to each row according to the column of the characteristic values;
and generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the column of the material number is empty and the characteristic value data corresponding to each row and the column of the characteristic value, wherein the material application form comprises a purchased material application form and/or a material application form of a spare part.
In a second aspect, an embodiment of the present invention further provides an apparatus for generating a material application form, where the apparatus includes:
the original BOM obtaining module is used for obtaining an original BOM generated according to the design drawing;
the characteristic value position acquisition module is used for acquiring a row where a characteristic value in the original BOM is located, wherein the characteristic value comprises a material number;
the characteristic value data reading module is used for reading the characteristic value data corresponding to each row according to the column where the characteristic value is located;
and the material application form generation module is used for generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the row of the material number is empty and the characteristic value data corresponding to each row and the row of the characteristic value, and the material application form comprises a purchased material application form and/or a material application form of a spare part.
According to the technical scheme of the embodiment of the invention, the original BOM generated according to the design drawing is obtained, the characteristic value column and the corresponding characteristic value data in the original BOM are obtained, and the corresponding material application form is generated according to whether the characteristic value data corresponding to each row in the material number column is empty or not, so that the generation efficiency of the material application form is improved, the possibility of artificial mistakes is avoided, and the accuracy of the generated material application form is improved.
Drawings
Fig. 1 is a flowchart of a method for generating a material application form according to an embodiment of the present invention;
fig. 2 is a flowchart of a method for generating a material application form according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an apparatus for generating a material application form according to a third embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some but not all of the relevant aspects of the present invention are shown in the drawings.
Example one
Fig. 1 is a flowchart of a method for generating a material application form according to an embodiment of the present invention, where the embodiment is applicable to a case of generating a material application form according to a design drawing, and the method may be executed by an apparatus for generating a material application form, where the apparatus may be implemented by software and/or hardware, and may be generally integrated in a computer, and the method specifically includes the following steps:
The BOM (Bill Of Material) is used to record all the lower-level materials and related attributes used in an item, that is, to record the dependency relationship, unit usage and other attributes Of the parent component and all the child components. It includes the following information: the structure level, material number, name, specification, figure number, metering unit, quantity yield, source type (self-making/outsourcing), lead period (accumulated lead period), and effective period (effective period/ineffective period) can be marked. The bill of material file list is hierarchical and displays the number of items (the number of components and members) of the next level required for each unit of finished product. The material number is a code given to each material by each enterprise for the convenience of producing the material and the flow in each link, and is used for determining the material type in production; the figure number is the number of a material in a design drawing and is used for determining the assembly relation in the design. In the original BOM, data corresponding to the drawing number is also blank, and when the drawing number is specifically determined, an engineer is required to number each material after the drawing is designed, so that the drawing number is determined.
After an engineer designs a finished product design drawing (such as a mechanical structure drawing or a circuit drawing) through design software such as Creo or UG, the original BOM of the finished product can be derived through the design software, wherein in the original BOM, a standard part and a universal part have material numbers, while a newly designed part has no material number, so that the corresponding material number of the newly designed part in the original BOM is empty. When the original BOM is obtained, the original BOM can be obtained according to a storage path of the original BOM specified by a user; design software can also be started to directly export the original BOM, so that the original BOM is obtained. The Creo is a novel CAD (Computer aided design) design software package integrating three software of Pro/ENGINEER, CoCreate and ProductView and redistributing, a simpler sub-application mode is adopted for different task applications, all sub-applications adopt a uniform file format, and the Creo aims to solve the problems that a CAD system is difficult to use, data of a plurality of CAD systems are shared and the like. UG (Unigraphics NX) is a product engineering solution produced by Siemens PLM Software company, provides a digital modeling and verification means for product design and processing of users, is an interactive CAD/CAM (Computer Aided Manufacturing) system, has powerful functions, and can easily realize the construction of various complex entities and models.
And step 120, obtaining a list of characteristic values in the original BOM, wherein the characteristic values comprise material numbers.
The characteristic value refers to a general name of information of the materials, such as a name, a material number, a figure number, a quantity and the like of each material.
The characteristic value in the original BOM can be recognized through a text recognition technology, the column number of the column where the characteristic value is located is obtained, and corresponding data are recognized through the text recognition technology. And reading data in the original BOM by calling an Excel shared library, so as to obtain the column number of the column where each characteristic value in the original BOM is located. For example, the name column is the first column, the material number column is the second column, the figure number column is the third column, and the number column is the fourth column. The Excel shared Library is a dll (Dynamic Link Library) file registered by Excel in an operating system, an instruction for operating an Excel form is contained in the Excel shared Library, the instruction can be combined after the shared Library is loaded, and the combination mode (equivalent to creating an Excel macro command) is stored, so that designers can process part data quickly.
And step 130, reading the characteristic value data corresponding to each row according to the column of the characteristic value.
The characteristic value data is specific data of each material or part corresponding to a characteristic value, for example, the specific material number data corresponds to each material when the characteristic value is a material number, and the specific name corresponds to each material when the characteristic value is a name.
And reading the characteristic value data corresponding to each line according to the column of the characteristic value, namely reading the characteristic value data in the original BOM line by line. All the part data in the original BOM can be cached in the memory in order by reading one line by one line. When the characteristic value is the material number, the characteristic value data corresponding to each row, namely the material number data, may have a specific material number, and may also be empty, namely, no specific material number exists.
And 140, generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the column of the material number is empty and the characteristic value data corresponding to each row and the column of the characteristic value, wherein the material application form comprises a purchased material application form and/or a material application form of a spare part.
And different material application forms can be generated according to whether the characteristic value data corresponding to each row in the column of the material number is empty or not. The materials with the material numbers not empty are standard parts or universal parts and exist in the stock, so that the material application form of spare parts can be generated by the related data of the materials with the material numbers not empty; the material with an empty material number is a newly designed part, and no material is distributed to the part, so that the material number is empty, the part does not exist in the stock and needs to be purchased, and a material application form for purchasing is generated. Since in the original BOM it is possible to use all standard or generic parts, it is also possible to use all newly designed parts, and it is also possible to use both standard and newly designed parts. Therefore, when all standard parts or universal parts are used, only a material application form of spare parts needs to be generated; when all the parts are newly designed, only a purchased material application form needs to be generated; when the standard part and the newly designed part are used simultaneously, a material application form of the spare part and a material application form of purchasing are generated.
According to the technical scheme of the embodiment, the original BOM generated according to the design drawing is obtained, the characteristic value column and the corresponding characteristic value data in the original BOM are obtained, and the corresponding material application form is generated according to whether the characteristic value data corresponding to each row in the material number column is empty or not, so that the generation efficiency of the material application form is improved, the possibility of artificial mistakes is avoided, the accuracy of the generated material application form is improved, the document processing work of an engineer can be reduced, and the working efficiency is improved.
On the basis of the above embodiment, after generating the corresponding material application form, the method may further include:
and submitting the material application form to a material application system so as to prepare corresponding materials by staff after the approval is passed.
Wherein the material application system is a system for managing material applications.
After a material application form for purchasing and/or a material application form for spare parts are generated, the material application form for purchasing and/or the material application form for spare parts are submitted to a material application system for an engineer to examine and approve, and after the examination and approval are passed, a worker takes the material application form in the material application system to prepare corresponding materials, namely, corresponding materials are purchased according to the material application form for purchasing, and corresponding materials are extracted from inventory according to the material application form for spare parts. The material application form is managed through the physical application system, so that an engineer can quickly examine and approve and prepare corresponding materials.
Example two
Fig. 2 is a flowchart of a method for generating a material application form according to a second embodiment of the present invention, where the second embodiment is optimized based on the foregoing embodiment, and the characteristic values may further include names and numbers, and the method specifically includes the following steps:
And step 230, reading the characteristic value data corresponding to each row according to the column of the characteristic value.
And 240, when the characteristic value is the material number, extracting a data line with the corresponding characteristic value data being null as a material number null data line, and extracting a data line with the corresponding characteristic value data not being null as a material number non-null data line.
Wherein, the data line is a specific line of characteristic value data in the original BOM.
Because the standard part and the spare part have material numbers, corresponding parts exist in stock, and newly designed parts have no material numbers, and need to be purchased after corresponding material numbers are allocated, the two parts need to be separated and respectively processed according to whether the material numbers are empty or not. Inquiring whether the characteristic value data corresponding to the material number in each row is empty or not according to the material number in the characteristic values, and extracting all the characteristic value data in the row when the characteristic value data corresponding to the material number in one row is empty, wherein the data row is used as a material number empty data row; and when the characteristic value data corresponding to the material number in one row is not empty, extracting all the characteristic value data in the row, wherein the data row is used as a non-empty data row of the material number.
And 250, merging the data rows with the same name in the material number empty data rows, distributing corresponding material numbers for the materials with the same name, counting the corresponding number, and generating a material purchase request form.
The data rows having the same name indicate that, when the feature value is a name, at least two rows of the corresponding feature value data in the column having the name are the same.
In the material number empty data line, a plurality of lines of data may exist, when the plurality of lines of data exist, when the characteristic value is a name, whether the characteristic value data (namely specific name) corresponding to the name of each line is the same is inquired, if the characteristic value data are the same, the data lines with the same name are determined, the data lines with the same name are merged into one line, and the number in the data line before merging with the name is counted as the number corresponding to the material with the name; if the characteristic value data of one line corresponding to the name is different from the characteristic value data of other lines corresponding to the name, the characteristic value data of the line is reserved. After data rows with the same name are combined, corresponding material numbers are distributed to materials with different names in each row, when the corresponding material numbers are distributed to the materials, the corresponding material numbers can be distributed to the materials with the names according to the specification of the materials, information of the materials with the material numbers to be distributed can also be displayed to an engineer, and the engineer distributes the corresponding material numbers according to the properties of the materials. The specification usually refers to a specified quality standard of a produced finished product or used raw materials, and the like, and includes a material and a processing type of a piece of material, and is also one of characteristic values.
After the material number of the material with a specific name is obtained, counting the quantity of the material with the name according to the characteristic value data in the original BOM, or counting the quantity when the name is combined to be used as the quantity corresponding to the material with the name, and generating a purchased material application form according to the characteristic value data in the data row after the name is combined and the corresponding quantity, so that a worker can purchase the corresponding material after the purchased material application form is approved.
And step 260, merging the data rows with the same name in the non-empty data rows of the material number, counting the corresponding number, and generating a material application form of the spare part.
In the non-empty data line of the material number, there may be a plurality of lines of data, when there are a plurality of lines of data, when the characteristic value is queried as a name, whether the characteristic value data (i.e. specific name) corresponding to each line is the same, if so, it is determined as the data line with the same name, the data lines with the same name are merged into one line, and the number in the data line with the name is counted as the number corresponding to the material with the name. And meanwhile, counting the number of data rows with different characteristic value data of the names corresponding to other rows as the number of the materials with the names. And generating a material application form of the spare part by combining the characteristic value data and the corresponding quantity in the data rows with the same name so as to facilitate the spare part to be prepared by the working personnel after the material application form of the spare part is approved.
Merging data rows with the same name in the non-empty data rows of the material number, counting the corresponding number, generating a material application form of the spare part, and optionally including:
according to the names in the characteristic values, combining the data rows with the same name in the material number non-empty data rows, and counting the number of the corresponding materials;
and filling the corresponding characteristic value data and the quantity of the corresponding materials in the data row of the materials with the same names into a material application form template to generate a material application form of the spare part.
According to the names in the characteristic values, whether the characteristic value data (namely specific names) of each row corresponding to the row where the name is located are the same is determined, the data rows with the same corresponding characteristic value data are combined, the quantity of the materials in each row of data with the same name is counted, the corresponding characteristic value data and the corresponding quantity in the data rows where each type of materials (distinguished by the specific names) are located after combination are filled into corresponding positions in a material application form template, and a material application form of a spare part is generated. The corresponding material application form is generated by using the material application form template, so that the style of the material application form is fixed, and the data in the material application form is more easily identified.
The method comprises the following steps of filling corresponding characteristic value data and the quantity of corresponding materials in a data line where the materials with the same name are combined into a material application form template, generating a material application form of a spare part, and optionally comprising the following steps:
adding a set allowance to the counted quantity of the corresponding materials to serve as the specific quantity of the materials;
and filling the corresponding characteristic value data and the specific quantity of the corresponding materials in the data row of the materials with the same names into a material application form template to generate a material application form of the spare part.
The addition of the amount of the corresponding materials obtained by statistics is used for setting allowance, and as the specific amount of the materials, the situation that the materials are lacked when the problems such as damage occur in the using process of the materials can be avoided, so that the project time is ensured.
According to the technical scheme, when the characteristic value is the material number, the data in the material number empty data row and the data in the material number non-empty data row are respectively extracted, the data in the material number empty data row are processed and the corresponding material number is distributed, a material application form for purchase is generated, the data in the material number non-empty data row are processed, and a material application form for a spare part is generated.
On the basis of the technical scheme, merging the data rows with the same name in the material number empty data rows, distributing the corresponding material numbers for the materials with the same name, counting the corresponding number, and generating a material purchase request form, wherein the method optionally comprises the following steps:
merging the data rows with the same name in the material number empty data rows to generate a material number application table of the materials with the same name;
submitting the material number application table to a material number application system to wait for the material number application system to distribute material numbers to the materials;
receiving a material number distribution table returned by the material number application system after distributing the material number for the material;
counting the corresponding quantity of the materials in the material number null data line;
and generating a material application form for purchase according to the material number distribution table, the material number application table and the corresponding quantity.
The material number application table is used for applying material numbers for materials, wherein the characteristic values comprise names, material types, specifications, drawing numbers, material numbers and the like, the material numbers do not have specific material number data, specific material number data are blank, and the drawing numbers are numbers of the materials in a design drawing and are used for determining the assembly relation in the design. The material number application system is a system for distributing material numbers, can automatically distribute corresponding material numbers for each material according to data in a material number application table, can also display the material number application table to an engineer, and distributes corresponding material numbers for each material by the engineer according to the data in the material number application table.
And after merging the data rows with the same name in the empty data row of the material number, generating a material number application table of all the materials with the same name according to all the characteristic values and the corresponding data with the same name, wherein the material number application table is used for applying for the corresponding material number. Will material number application form submits to material number application system, and material number application system can show the material number application form, by the engineer for the material number that every kind of material distribution corresponds according to the material number application form, and material number application system can also be according to the specification of every kind of material and the numbering rule of material number, the automatic material number that corresponds for every kind of material distribution. After distributing the corresponding material number for each material, the material number application system generates a material number distribution table and returns the material number distribution table, wherein the material number distribution table can only comprise the name of the material and the corresponding material number. And after receiving a material number distribution table returned by the material number application system, counting the number of the materials with the same name in each row in the material number empty data row as the specific number of the materials. Filling the material number of each material in the material number distribution table, the corresponding data of the corresponding material in the material number application table and the specific quantity obtained by statistics into a material application form template to generate a purchased material application form. After the material number application table is generated, the material number corresponding to each material is allocated by the specific material number application system for allocating the material numbers, the allocated material numbers are accurate, and therefore the accuracy of the generated purchased material application form is further improved.
On the basis of the technical scheme, merging the data rows with the same name in the material number empty data rows to generate a material number application table of the materials with the same name, wherein the step optionally comprises the following steps:
merging the data rows with the same name in the material number empty data rows according to the name in the characteristic value;
and filling corresponding characteristic value data in the data row of the materials with the same name into a material number application table template to generate a material number application table.
According to the name in the characteristic value, determining whether the characteristic value data (namely the specific name) of each row corresponding to the column of the name is the same, combining the data rows with the same corresponding characteristic value data, and filling the corresponding characteristic value data in the data row of each combined material (distinguished by the specific name) into the corresponding position in the material number application table template to generate the material number application table. The corresponding material number application table is generated by using the material number application table template, so that the style of the material number application table is fixed, and the data in the material number application table is easier to identify.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a device for generating a material application form according to a third embodiment of the present invention, where the device for generating a material application form according to the present embodiment may be implemented by software and/or hardware, and may be generally integrated in a computer, as shown in fig. 3, the device for generating a material application form according to the present embodiment includes: the system comprises an original BOM acquisition module 310, a characteristic value position acquisition module 320, a characteristic value data reading module 330 and a material application form generation module 340.
The original BOM obtaining module 310 is configured to obtain an original BOM generated according to the design drawing;
a feature value position obtaining module 320, configured to obtain a column where a feature value in the original BOM is located, where the feature value includes a material number;
the characteristic value data reading module 330 is configured to read characteristic value data corresponding to each row according to the column where the characteristic value is located;
the material application form generating module 340 is configured to generate a corresponding material application form according to whether characteristic value data corresponding to each row in the row where the material number is located is empty, and the characteristic value data corresponding to each row and the row where the characteristic value is located, where the material application form includes a material application form for purchase and/or a material application form for spare parts.
Optionally, the feature value further includes a name and a number;
the material application form generation module comprises:
the material number distinguishing unit is used for extracting a data line with corresponding characteristic value data being empty as a material number empty data line and extracting a data line with corresponding characteristic value data not being empty as a material number non-empty data line when the characteristic value is a material number;
the purchase order generating unit is used for merging the data rows with the same name in the material number empty data rows, distributing the corresponding material numbers for the materials with the same name, counting the corresponding number and generating a material purchase request order;
and the spare part list generating unit is used for merging the data rows with the same name in the material number non-empty data rows, counting the corresponding number and generating a material application list of the spare part.
Optionally, the purchase order generating unit includes:
the material number application table generating subunit is used for merging the data rows with the same name in the material number empty data rows and generating a material number application table of the materials with the same name;
the material number application table submitting subunit is used for submitting the material number application table to a material number application system so as to wait for the material number application system to distribute the material number to the material;
the material number distribution table receiving subunit is used for receiving a material number distribution table returned by the material number application system after the material number is distributed to the material;
the material number counting subunit is used for counting the number corresponding to the material in the material number null data line;
and the purchase order generating subunit is used for generating a material application order for purchase according to the material number distribution table, the material number application table and the corresponding quantity.
Optionally, the material number application table generating subunit is specifically configured to:
merging the data rows with the same name in the material number empty data rows according to the name in the characteristic value;
and filling corresponding characteristic value data in the data row of the materials with the same name into a material number application table template to generate a material number application table.
Optionally, the spare part list generating unit includes:
the quantity counting subunit is used for merging the data rows with the same name in the material number non-empty data rows according to the name in the characteristic value and counting the quantity of the corresponding materials;
and the spare part list generating subunit is used for filling the corresponding characteristic value data and the quantity of the corresponding materials in the data row of the materials with the same names into the material application list template to generate a material application list of the spare part.
Optionally, the spare part list generating subunit is specifically configured to:
adding a set allowance to the counted quantity of the corresponding materials to serve as the specific quantity of the materials;
and filling the corresponding characteristic value data and the specific quantity of the corresponding materials in the data row of the materials with the same names into a material application form template to generate a material application form of the spare part.
Optionally, the method further includes:
and the material application form submitting module is used for submitting the material application form to a material application system after the corresponding material application form is generated so as to wait for corresponding materials to be prepared by staff after the approval is passed.
The device for generating the material application form can execute the method for generating the material application form provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method. For technical details that are not described in detail in this embodiment, reference may be made to a method for generating a material application form provided in any embodiment of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (8)
1. A method of generating a material application form, the method comprising:
acquiring an original bill of material BOM generated according to a design drawing;
acquiring a list of characteristic values in the BOM, wherein the characteristic values comprise material numbers, names and quantities;
reading characteristic value data corresponding to each row according to the column of the characteristic values;
generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the column of the material number is empty and the characteristic value data corresponding to each row and the column of the characteristic value, wherein the material application form comprises a material application form for purchasing and/or a material application form for spare parts;
generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the column of the material number is empty and the characteristic value data corresponding to each row and the column of the characteristic value, wherein the method comprises the following steps:
when the characteristic value is a material number, extracting a data line with corresponding characteristic value data being empty as a material number empty data line, and extracting a data line with corresponding characteristic value data not being empty as a material number non-empty data line;
merging the data rows with the same name in the material number empty data rows, distributing corresponding material numbers for the materials with the same name, counting the corresponding number, and generating a material purchase request form;
and combining the data rows with the same name in the non-empty data rows of the material number, counting the corresponding number, and generating a material application form of the spare part.
2. The method of claim 1, wherein merging the data rows with the same name in the empty data rows of the material numbers, assigning the corresponding material numbers to the materials with the same name, counting the corresponding number, and generating a material purchase request form, comprises:
merging the data rows with the same name in the material number empty data rows to generate a material number application table of the materials with the same name;
submitting the material number application table to a material number application system to wait for the material number application system to distribute material numbers to the materials;
receiving a material number distribution table returned by the material number application system after distributing the material number for the material;
counting the corresponding quantity of the materials in the material number null data line;
and generating a material application form for purchase according to the material number distribution table, the material number application table and the corresponding quantity.
3. The method according to claim 2, wherein merging the data rows with the same name in the empty data row of the material number to generate a material number application table of the material with the same name, comprises:
merging the data rows with the same name in the material number empty data rows according to the name in the characteristic value;
and filling corresponding characteristic value data in the data row of the materials with the same name into a material number application table template to generate a material number application table.
4. The method of claim 1, wherein merging the data rows with the same name in the non-empty data rows of the material number, counting the corresponding number, and generating a material application form of a spare part comprises:
according to the names in the characteristic values, combining the data rows with the same name in the material number non-empty data rows, and counting the number of the corresponding materials;
and filling the corresponding characteristic value data and the quantity of the corresponding materials in the data row of the materials with the same names into a material application form template to generate a material application form of the spare part.
5. The method of claim 4, wherein the step of filling the characteristic value data corresponding to the data row of the materials with the same name and the quantity of the corresponding materials into a material application form template to generate a material application form of the spare part comprises the following steps:
adding a set allowance to the counted quantity of the corresponding materials to serve as the specific quantity of the materials;
and filling the corresponding characteristic value data and the specific quantity of the corresponding materials in the data row of the materials with the same names into a material application form template to generate a material application form of the spare part.
6. The method of any one of claims 1-5, further comprising, after generating the corresponding material application form:
and submitting the material application form to a material application system so as to prepare corresponding materials by staff after the approval is passed.
7. An apparatus for generating a material application form, the apparatus comprising:
the original BOM obtaining module is used for obtaining an original BOM generated according to the design drawing;
the characteristic value position acquisition module is used for acquiring a column where a characteristic value in the original bill of material BOM is located, wherein the characteristic value comprises a material number, a name and a quantity;
the characteristic value data reading module is used for reading the characteristic value data corresponding to each row according to the column where the characteristic value is located;
the material application form generation module is used for generating a corresponding material application form according to whether the characteristic value data corresponding to each row in the row of the material number is empty and the characteristic value data corresponding to each row and the row of the characteristic value, and the material application form comprises a material application form for purchase and/or a material application form for spare parts;
the material application form generation module comprises:
the material number distinguishing unit is used for extracting a data line with corresponding characteristic value data being empty as a material number empty data line and extracting a data line with corresponding characteristic value data not being empty as a material number non-empty data line when the characteristic value is a material number;
the purchase order generating unit is used for merging the data rows with the same name in the material number empty data rows, distributing the corresponding material numbers for the materials with the same name, counting the corresponding number and generating a material purchase request order;
and the spare part list generating unit is used for merging the data rows with the same name in the material number non-empty data rows, counting the corresponding number and generating a material application list of the spare part.
8. The apparatus of claim 7, wherein the purchase order generation unit comprises:
the material number application table generating subunit is used for merging the data rows with the same name in the material number empty data rows and generating a material number application table of the materials with the same name;
the material number application table submitting subunit is used for submitting the material number application table to a material number application system so as to wait for the material number application system to distribute the material number to the material;
the material number distribution table receiving subunit is used for receiving a material number distribution table returned by the material number application system after the material number is distributed to the material;
the material number counting subunit is used for counting the number corresponding to the material in the material number null data line;
and the purchase order generating subunit is used for generating a material application order for purchase according to the material number distribution table, the material number application table and the corresponding quantity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710426707.2A CN107239923B (en) | 2017-06-08 | 2017-06-08 | Method and device for generating material application form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710426707.2A CN107239923B (en) | 2017-06-08 | 2017-06-08 | Method and device for generating material application form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107239923A CN107239923A (en) | 2017-10-10 |
| CN107239923B true CN107239923B (en) | 2020-08-18 |
Family
ID=59987441
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710426707.2A Expired - Fee Related CN107239923B (en) | 2017-06-08 | 2017-06-08 | Method and device for generating material application form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107239923B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108229875A (en) * | 2017-11-27 | 2018-06-29 | 郑州云海信息技术有限公司 | A kind of Service Parts method under server module BOM frameworks |
| CN108388743A (en) * | 2018-03-06 | 2018-08-10 | 深圳市图敏智能视频股份有限公司 | A kind of bill of materials method for sorting |
| CN109886623A (en) * | 2019-01-30 | 2019-06-14 | 美林数据技术股份有限公司 | The group packet processing method and device of product data |
| CN110570082A (en) * | 2019-07-31 | 2019-12-13 | 苏宁云计算有限公司 | Data flow processing method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920835A (en) * | 2005-08-26 | 2007-02-28 | 鸿富锦精密工业（深圳）有限公司 | Materials list generation system and method |
| CN101673373A (en) * | 2009-09-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | Method and device for generating production order material-preparing journal entry |
| CN101727611A (en) * | 2008-10-13 | 2010-06-09 | 名硕电脑(苏州)有限公司 | System and method for making material table |
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
| CN103778487A (en) * | 2012-10-18 | 2014-05-07 | 捷达世软件（深圳）有限公司 | Material number application method and system |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101510277A (en) * | 2009-02-20 | 2009-08-19 | 浪潮集团山东通用软件有限公司 | Method for rolling computation of material requirement in production management process |
| EP2811439A1 (en) * | 2013-06-05 | 2014-12-10 | Accenture Global Services Limited | Master bill of materials creation |
| CN105069568A (en) * | 2015-08-03 | 2015-11-18 | 北京工商大学 | Merging unit identifying code management method and merging unit identifying code management system |
| US10445695B2 (en) * | 2015-09-04 | 2019-10-15 | Dell Products L.P. | Method and system for providing continuous reference architecture and bill of material modeling |
| CN105389653A (en) * | 2015-10-30 | 2016-03-09 | 广东石油化工学院 | Adaptive material requirement plan (MRP) calculation method |
-
2017
- 2017-06-08 CN CN201710426707.2A patent/CN107239923B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1920835A (en) * | 2005-08-26 | 2007-02-28 | 鸿富锦精密工业（深圳）有限公司 | Materials list generation system and method |
| CN101727611A (en) * | 2008-10-13 | 2010-06-09 | 名硕电脑(苏州)有限公司 | System and method for making material table |
| CN101673373A (en) * | 2009-09-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | Method and device for generating production order material-preparing journal entry |
| CN103778487A (en) * | 2012-10-18 | 2014-05-07 | 捷达世软件（深圳）有限公司 | Material number application method and system |
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
Non-Patent Citations (1)
| Title |
|---|
| 基于SP95标准的工厂模型设计与建模方法研究;里鹏 等;《计算机集成制造系统》;20090331;第458-462页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107239923A (en) | 2017-10-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107239923B (en) | Method and device for generating material application form | |
| US7606743B2 (en) | Method for identifying product assets in a supply chain used to satisfy multiple customer demands | |
| EP1862956A1 (en) | Systems and methods for assignment generation in a value flow environment | |
| US20150363725A1 (en) | Systems and Methods for Flexible Sourcing Systems | |
| CN111506444A (en) | Form approval method and device, storage medium and electronic equipment | |
| JP2003535389A (en) | Automated method and system for selection and acquisition of electronic components used in circuit and chip design | |
| CN104408605A (en) | Order splitting method and system | |
| CN104657274B (en) | software interface test method and device | |
| CN104008485A (en) | Intelligent order generation device and method | |
| US20120010739A1 (en) | Design configurator system | |
| CN105204834B (en) | A kind of visual software modeling editing machine for constructing software model | |
| US8050785B2 (en) | Apparatus and method for handling orders | |
| Gutgutia et al. | A closed-form solution for the distribution free continuous review integrated inventory model | |
| CN111813739A (en) | Data migration method and device, computer equipment and storage medium | |
| US6856857B2 (en) | Method and system for planning disassembly and production of recyclable products and for planning procurement of parts for production | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN1963849A (en) | Conformity method of managing system of data of product | |
| CN114298585A (en) | Material purchasing quota distribution method and device for purchasing scene | |
| CN113807773A (en) | Method, device and equipment for generating steel structure industry manufacturing list and storage medium | |
| CN113254455A (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN112328680A (en) | Electronic component data processing method, data interface and management system | |
| JP6091975B2 (en) | production management system | |
| WO2016009483A1 (en) | Assembly line organizing system and assembly line organizing method | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| JP5706248B2 (en) | Product handling standard creation system and method |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200818 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |