CN110059121A - A kind of method, system, device and the storage medium of quick export bill of materials - Google Patents
A kind of method, system, device and the storage medium of quick export bill of materials Download PDFInfo
- Publication number
- CN110059121A CN110059121A CN201910185501.4A CN201910185501A CN110059121A CN 110059121 A CN110059121 A CN 110059121A CN 201910185501 A CN201910185501 A CN 201910185501A CN 110059121 A CN110059121 A CN 110059121A
- Authority
- CN
- China
- Prior art keywords
- bill
- materials
- content
- file
- default
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/15—Vehicle, aircraft or watercraft design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/20—Design optimisation, verification or simulation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Geometry (AREA)
- Computer Hardware Design (AREA)
- Databases & Information Systems (AREA)
- Evolutionary Computation (AREA)
- Pure & Applied Mathematics (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Aviation & Aerospace Engineering (AREA)
- Automation & Control Theory (AREA)
- Human Computer Interaction (AREA)
- Mathematical Analysis (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses method, system, device and the storage mediums of a kind of quickly export bill of materials, after wherein method is the following steps are included: choose object derived from multiple needs by CATIA software interface, according to input acquisition of information and more parts of bill of materials files are exported;Pass sequentially through Excel second development interface derived bill of materials file is handled after, the final bill of materials file of batch signatures.After the present invention exports material inventory file in CATIA software, automatically it is opened in Excel software, and the final material inventory file of rear batch signatures is performed corresponding processing according to pre-set programs, without artificially carrying out cumbersome operation, the speed of export is greatly improved, improves production efficiency indirectly, avoids the mistake artificially occurred, the quality for improving design production can be widely applied to the file export technical field of CATIA software.
Description
Technical field
The present invention relates to the files of CATIA software to export technical field, more particularly to one kind quickly exports bill of materials
Method, system, device and storage medium.
Background technique
Currently, being widely used in the Fixture Design of motor vehicle equipment integrator up to the Three-dimensional Design Software CATIA under rope
With automobile and the curved design of aircraft etc..In process of production, since design lower dept needs design department to provide material number
The characteristic of the associated property data of amount and material, therefore designer needs the object export portion of design or even more parts of materials
Inventory.
When exporting the bill of materials of design object in application software CATIA, the present way of designer is will first to set
Meter object is put in order by its corresponding professional standard form, and the design pair for needing to export bill of materials is then chosen on structure tree
As opening new window, choosing the member for needing to export bill of materials in the sub- member property of object, confirm errorless
Afterwards, so that design object is entered CATIA load module, and double-click design object node, then in " analysis " menu bar of CATIA
" bill of materials " order is found, clicks, clicks definition format again in the window of pop-up, by attribute according to bill of materials demand
Format arrangement is correct, closes pop-up window, clicks and save as at bill of materials interface, fill in design object bill of materials file
Name, and saves as " .xls " format, then opens file with Excel, deletes extra, mistake row and column, and by remaining content
It is arranged by corresponding industry standard formats or filling is correct.When the device object for needing to export more parts of bill of materials, then need to design
The above process is repeated several times in personnel.Above-mentioned this way is excessively cumbersome, needs designer that the more time is spent to operate,
The serious working time for consuming designer also reduces the efficiency of production, and operating process is easy to appear mistake, shadow
The quality of design production is rung.
Summary of the invention
In order to solve the above-mentioned technical problem, the object of the present invention is to provide one kind can automate rapid batch export material
Method, system, device and the storage medium of inventory.
First technical solution of the present invention is:
A kind of method of quick export bill of materials, comprising the following steps:
After choosing object derived from multiple needs by CATIA software interface, according to input acquisition of information and more parts are exported
Bill of materials file;
Pass sequentially through Excel second development interface derived bill of materials file is handled after, batch signatures are most
Whole bill of materials file.
Further, the second development interface for passing sequentially through Excel carries out handling this to derived bill of materials file
One step, specifically includes the following steps:
The second development interface for passing sequentially through Excel deletes corresponding content in bill of materials file;
It modifies to the content after deletion, and the position of Suitable content.
Further, the second development interface for passing sequentially through Excel delete in bill of materials file corresponding content this
One step specifically includes the following steps:
After opening bill of materials file using Excel format, the first default column are successively identified in bill of materials file
The content of cell, and after obtaining the line number for the first unit lattice that content is the first default mark, delete the row before the line number;
Bill of materials file is ranked up according to the content of the cell of the first default column;
Successively obtain the second unit lattice of the second default column of bill of materials file, and judge second unit lattice whether be
Sky, and when it is empty for determining second unit lattice, the row where second unit lattice is deleted.
Further, the content of the cell according to the first default column is ranked up this step to bill of materials file
Suddenly, specifically:
Selection area ascending sort is extended to bill of materials file according to the content of the cell of the first default column.
Further, described pair delete after content modify, and the step for the position of Suitable content, specifically include with
Lower step:
The third unit lattice of the default column of third are successively obtained, and judge whether the content of third unit lattice is the second pre- bidding
Know, and when the content for determining third unit lattice is the second default mark, the content of third unit lattice is changed to preset
Content;
The content of acquiring unit lattice is the 4th cell and cell of the default mark of third respectively in the first default column
Content be the 4th default mark the 5th cell, and by the traveling where the row and the 5th cell where the 4th cell
Row is exchanged;
Whether the content for judging the cell of the 4th default column of the row where the 4th cell is the 5th default mark, and
When determining the content not is the 5th default mark, the cell of the 4th default column is shown using default display format.
Second technical solution of the present invention is:
A kind of system of quick export bill of materials, comprising:
Export module, after choosing object derived from multiple needs by CATIA software interface, simultaneously according to input acquisition of information
Export more parts of bill of materials files;
Sorting module, the second development interface for passing sequentially through Excel handle derived bill of materials file
Afterwards, the final bill of materials file of batch signatures.
Further, the sorting module includes deleting unit and modification unit;
The unit of deleting is used to pass sequentially through in corresponding in the second development interface deletion bill of materials file of Excel
Hold;
The modification unit is for modifying to the content after deletion, and the position of Suitable content.
Further, the deletion unit in the following manner deletes the content of bill of materials file:
After opening bill of materials file using Excel format, the first default column are successively identified in bill of materials file
The content of cell, and after obtaining the line number for the first unit lattice that content is the first default mark, delete the row before the line number;
Bill of materials file is ranked up according to the content of the cell of the first default column;
Successively obtain the second unit lattice of the second default column of bill of materials file, and judge second unit lattice whether be
Sky, and when it is empty for determining second unit lattice, the row where second unit lattice is deleted.
Third technical solution of the present invention is:
A kind of computer code automatically generating device, including memory and processor, the memory is for storing at least
One program, the processor is for loading at least one described program to execute the above method.
4th technical solution of the present invention is:
A kind of storage medium, wherein be stored with the executable instruction of processor, the executable instruction of the processor by
For executing such as the above method when processor executes.
The beneficial effects of the present invention are: after the present invention exports material inventory file in CATIA software, it is automatically soft in Excel
It is opened in part, and performs corresponding processing the final material inventory file of rear batch signatures according to pre-set programs, carried out without artificial
Cumbersome operation greatly improves the speed of export, improves production efficiency indirectly, avoids the mistake artificially occurred
Accidentally, the quality of design production is improved.
Detailed description of the invention
Fig. 1 is a kind of step flow chart of the method for quickly export bill of materials of the invention;
Fig. 2 is a kind of structural block diagram of the system of quickly export bill of materials of the invention.
Specific embodiment
Embodiment one
As shown in Figure 1, a kind of method for present embodiments providing quickly export bill of materials, comprising the following steps:
S1, it after choosing object derived from multiple needs by CATIA software interface, according to input acquisition of information and exports more
Part bill of materials file;
After S2, the second development interface for passing sequentially through Excel handle derived bill of materials file, batch signatures
Final bill of materials file.
The technology of existing export material inventory file, or by artificially being operated, it is very cumbersome, consume work people
The more time cost of member.For using CATIA to export vehicle side tack-welding jig equipment, the process of bill of materials is made
Include: selection needs the node of derived fixture unit, opens fixture unit in new window, by under fixture unit self-made components,
Fastener, Purchased Item and emblem mark part check one by one and have chosen bill of materials attribute, and fixture is made to enter trim designs module, double-click
Fixture unit node is selected, the bill of materials order in " analysis " menu bar is clicked, by bill of materials attribute by " SAP ", " note
Release ", " version ", " blank ", " dash number ", " source ", " quantity ", " product description ", " blank 1 ", the sequence of " definition " arrangement
It is good, cell parts are numbered into filling filename after closing window and save as " .xls " format, file is opened with Excel, deletes
Extra useless row and column, by gauge outfit first row according to " serial number ", " father figure number (must fill out) ", " father title ", " father material
Group ", " subitem figure number/model (must fill out) ", " subitem 2D figure number ", " subitem quantity (must fill out) ", " subitem title ", " subitem material
Group ", " subitem brand " are sequentially filled in, remaining row is arranged according to the sequence of self-made components, Purchased Item, emblem mark part, fastener, is pressed
The populated remaining content of standard.This operating method will do more repetitive operation, and be familiar with the standard of operator
Degree has certain requirement, such as need to export inventory it is big to vector in the case where, not only the use process of bill of materials order is numerous
Trivial time-consuming, designer also easily malfunction in modification and sequencer procedure, cause to continue to return to modification in the later period, cause working hour
It is multiplied.
A kind of method for present embodiments providing quickly export bill of materials, is repeated using tradition export material listing procedure
Property the fixed feature of high and bill of materials format, pass through the second development interface AssemblyConvertor of CATIA
SetSecondaryFormat (CATSafeArrayVariant ilistProps) determines that bill of materials needs derived information;
Pass through AssemblyConvertor Print (CATBSTR iFileType, CATBSTR iFile, CATIAProduct again
IProduct the process of CATIA export material inventory file) is realized;Followed by the second development interface of Excel to derived
Bill of materials file is handled, to form the bill of materials file for meeting production requirement.Specifically, user only need to
The object (unit) that product is selected on CATIA software, then passes through the second development interface of CATIA software, exports each product
The bill of materials file of object, wherein derived Formats User can predefine.Specifically, user can be directly in CATIA software
Graphic interface on selecting object (unit), selected object can highlight, after choosing, call CATIA software secondary development it is macro
Program simultaneously makes its operation, final output.Wherein, it there are many call macro program mode (PM)s, can be called out by Alt+F8 shortcut key
Then macros window clicks operation, also can generate button in toolbar or menu bar in advance and then click operation, essence is all
It is to call the macroprogram write in advance and make its operation.After exporting material inventory file, pass through the secondary development of Excel software
Interface opens bill of materials file, and after handling file, exports final bill of materials file, for example delete hereof
It except extra, mistake row and column, and arranges or is filled correctly by corresponding industry standard formats, finally becoming portion can be used for
The bill of materials file of production.This method is by automation export material inventory file, without manually carrying out the cumbersome of repeatability
Operation improves the efficiency of export material inventory file, improves the efficiency of production indirectly;Manual errors are avoided the occurrence of, are improved
The quality of production.
Wherein, the second development interface that Excel is passed sequentially through in step S2 handles derived bill of materials file
The step for, specifically include step A1~A2:
A1, the second development interface for passing sequentially through Excel delete corresponding content in bill of materials file.
A2, it modifies to the content after deletion, and the position of Suitable content.
After programming program, across software operation is carried out using using second development interface, has passed through secondary development
Interface borrows Excel software function and deletes content extra in bill of materials file, such as the row of some blank, or
There is no the row or column of the information content, after being deleted, then the content of bill of materials file arranged or filled, by it is some compared with
It is shown in front of file for important data, to meet corresponding requirement.
The step A1 specifically includes step A11~A13:
A11, after opening bill of materials file using Excel format, successively identify that first is default in bill of materials file
The content of the cell of column, and after obtaining the line number for the first unit lattice that content is the first default mark, before deleting the line number
Row.
A12, bill of materials file is ranked up according to the content of the cell of the first default column.Specifically: according to
The content of the cell of one default column is extended selection area ascending sort to bill of materials file.
A13, the second default second unit lattice arranged for successively obtaining bill of materials file, and whether judge second unit lattice
For sky, and when it is empty for determining second unit lattice, the row where second unit lattice is deleted.
Step A2 specifically includes step A21~A23:
A21, the third unit lattice for successively obtaining the default column of third, and judge whether the content of third unit lattice is second pre-
Bidding is known, and when the content for determining third unit lattice is the second default mark, the content of third unit lattice is changed to pre-
If content;
A22, the content of acquiring unit lattice is the 4th cell and list of the default mark of third respectively in the first default column
The content of first lattice is the 5th cell of the 4th default mark, and will be where the row and the 5th cell where the 4th cell
Row is exchanged;
Whether A23, the 4th content for presetting the cell of column for judging the row where the 4th cell are the 5th pre- bidding
Know, and when determining the content not is the 5th default mark, the unit of the 4th default column is shown using default display format
Lattice.
When being handled using Excel second development interface, firstly, by Range in Excel (Row,
Column) .Value interface, the content of the cell of the default column of identification first, and content is obtained as the first of the first default mark
After the line number of cell, the row before the line number is deleted.In the present embodiment, described first default it is classified as bill of materials file
First row, described first it is default be identified as " SAP ", i.e., cell content is cell and the acquisition of " SAP " in identification first row
Its line number, all rows before then leaving out its line number.Then, by Worksheet.Sort interface, with Excel table first row
Ascending order be according to be extended selection area sequence;Then, the second of the second default column of bill of materials file is successively obtained
Cell, and judge whether second unit lattice are empty, and when it is empty for determining second unit lattice, it will be where second unit lattice
Row is deleted.In the present embodiment, (i.e. " subitem figure number/model (must for the described second default the 5th column for being classified as bill of materials file
Fill out) " column), if the cell of the column is sky, delete full line.By aforesaid operations, it is extra or wrong to delete
Row, is next adjusted and fills to remaining content.The third unit lattice of the default column of third are obtained, and judge third unit
Whether the content of lattice is the second default mark, and when the content for determining third unit lattice is the second default mark, by third
The content of cell is changed to preset content;In the present embodiment, default the 6th column for being classified as bill of materials file of the third
(i.e. " subitem 2D figure number " arrange), described second it is default be identified as " self-control ", the preset content is the same as the 5th column unit in a line
The content of lattice then will be where its cell when judging the cell content of the 6th column (i.e. " subitem 2D figure number " arranges) for " self-control "
The content of the 5th column unit lattice of row is copied to the cell, meanwhile, the 9th column of change (i.e. " subitem material group " arranges) content is
"C0300".Then, the content of acquiring unit lattice is the 4th cell and list of the default mark of third respectively in the first default column
The content of first lattice is the 5th cell of the 4th default mark, and will be where the row and the 5th cell where the 4th cell
Row is exchanged;In the present embodiment, the third is default is identified as " D01 ", the row where the mark corresponding " Purchased Item ", institute
State the 4th it is default be identified as " C02 ", the row where the mark corresponding " emblem mark part " passes through identification first row (i.e. " SAP " is arranged)
Whether 3 be " C02 " and " D01 " before cell content, the row where " emblem mark part " and " Purchased Item " is obtained, by the position of their rows
Set exchange;The row where " Purchased Item " can be promoted to before Purchased Item by exchange, related personnel is facilitated to check.Finally,
Whether the content for judging the cell of the 4th default column of the row where the 4th cell is the 5th default mark, and is being determined
When the content is not the 5th default mark, the cell of the 4th default column is shown using default display format;In the present embodiment
In, the cell of the described 4th default column is the 5th column unit lattice, the described 5th it is default be identified as whether first 3 be " M-J ", institute
Stating default display format is that cell is revised as red, i.e., 3 before judgement " emblem mark part " the 5th column unit lattice content of the row
It whether is " M-J ", if it is not, then the cell is revised as red.By above-mentioned after the processing step of Excel software,
Final batch signatures material inventory file, the material inventory file may be directly applied to design lower dept, greatly improve and lead
The efficiency of bill of materials out.
Embodiment two
As shown in Fig. 2, the system for present embodiments providing a kind of quickly export bill of materials, comprising:
Export module, after choosing object derived from multiple needs by CATIA software interface, simultaneously according to input acquisition of information
Export more parts of bill of materials files;
Sorting module, the second development interface for passing sequentially through Excel handle derived bill of materials file
Afterwards, the final bill of materials file of batch signatures.
It is further used as preferred embodiment, the sorting module includes deleting unit and modification unit;
The unit of deleting is used to pass sequentially through in corresponding in the second development interface deletion bill of materials file of Excel
Hold;
The modification unit is for modifying to the content after deletion, and the position of Suitable content.
It is further used as preferred embodiment, the deletion unit is in the following manner to the content of bill of materials file
It is deleted:
After opening bill of materials file using Excel format, the first default column are successively identified in bill of materials file
The content of cell, and after obtaining the line number for the first unit lattice that content is the first default mark, delete the row before the line number;
Bill of materials file is ranked up according to the content of the cell of the first default column;
Successively obtain the second unit lattice of the second default column of bill of materials file, and judge second unit lattice whether be
Sky, and when it is empty for determining second unit lattice, the row where second unit lattice is deleted.
The system that one kind of the present embodiment quickly exports bill of materials, can be performed provided by embodiment of the present invention method one
It is corresponding to have this method for a kind of method of quick export bill of materials, any combination implementation steps of executing method embodiment
Function and beneficial effect.
Embodiment three
The present embodiment provides a kind of computer code automatically generating device, including memory and processor, the memories
For storing at least one program, the processor is for loading at least one described program to execute side described in embodiment one
Method.
A kind of computer code automatically generating device of the present embodiment can be performed provided by embodiment of the present invention method one
It is corresponding to have this method for a kind of method of quick export bill of materials, any combination implementation steps of executing method embodiment
Function and beneficial effect.
Example IV
The present embodiment provides a kind of storage mediums, wherein being stored with the executable instruction of processor, the processor can be held
Capable instruction is used to execute when executed by the processor such as one the method for embodiment.
A kind of quick export thereof provided by embodiment of the present invention method one can be performed in a kind of storage medium of the present embodiment
Expect that the method for inventory, any combination implementation steps of executing method embodiment have the corresponding function of this method and beneficial to effect
Fruit.
It is to be illustrated to preferable implementation of the invention, but the invention is not limited to the implementation above
Example, those skilled in the art can also make various equivalent variations on the premise of without prejudice to spirit of the invention or replace
It changes, these equivalent deformations or replacement are all included in the scope defined by the claims of the present application.
Claims (10)
1. a kind of method of quickly export bill of materials, which comprises the following steps:
After choosing object derived from multiple needs by CATIA software interface, according to input acquisition of information and more parts of materials are exported
Inventory file;
Pass sequentially through Excel second development interface derived bill of materials file is handled after, batch signatures are final
Bill of materials file.
2. a kind of method of quickly export bill of materials according to claim 1, which is characterized in that described to pass sequentially through
The step for second development interface of Excel handles derived bill of materials file, specifically includes the following steps:
The second development interface for passing sequentially through Excel deletes corresponding content in bill of materials file;
It modifies to the content after deletion, and the position of Suitable content.
3. a kind of method of quickly export bill of materials according to claim 2, which is characterized in that described to pass sequentially through
The second development interface of Excel delete the step for corresponding content in bill of materials file specifically includes the following steps:
After opening bill of materials file using Excel format, the unit of the first default column is successively identified in bill of materials file
The content of lattice, and after obtaining the line number for the first unit lattice that content is the first default mark, delete the row before the line number;
Bill of materials file is ranked up according to the content of the cell of the first default column;
The second unit lattice of the second default column of bill of materials file are successively obtained, and judge whether second unit lattice are empty, and
When it is empty for determining second unit lattice, the row where second unit lattice is deleted.
4. a kind of method of quickly export bill of materials according to claim 3, which is characterized in that described pre- according to first
If the step for content of the cell of column is ranked up bill of materials file, specifically:
Selection area ascending sort is extended to bill of materials file according to the content of the cell of the first default column.
5. a kind of method of quickly export bill of materials according to claim 3, which is characterized in that after described pair is deleted
Content is modified, and the step for the position of Suitable content, specifically includes the following steps:
The third unit lattice of the default column of third are successively obtained, and judge whether the content of third unit lattice is the second default mark,
And when the content for determining third unit lattice is the second default mark, the content of third unit lattice is changed in preset
Hold;The content of acquiring unit lattice is the content of the 4th cell and cell of the default mark of third respectively in the first default column
The 5th cell of mark is preset for the 4th, and the row where the 4th cell is adjusted with the row where the 5th cell
It changes;Whether the content for judging the cell of the 4th default column of the row where the 4th cell is the 5th default mark, and is being sentenced
Break to the content when not being the 5th default mark, the cell of the 4th default column is shown using default display format.
6. a kind of system of quickly export bill of materials characterized by comprising
Export module after choosing object derived from multiple needs by CATIA software interface, according to input acquisition of information and exports
More parts of bill of materials files;
Sorting module, after the second development interface for passing sequentially through Excel handles derived bill of materials file, batch
Amount exports final bill of materials file.
7. a kind of system of quickly export bill of materials according to claim 6, which is characterized in that the sorting module packet
It includes and deletes unit and modification unit;
The unit of deleting is used to pass sequentially through corresponding content in the second development interface deletion bill of materials file of Excel;
The modification unit is for modifying to the content after deletion, and the position of Suitable content.
8. a kind of system of quickly export bill of materials according to claim 7, which is characterized in that the deletion unit is logical
Following manner is crossed to delete the content of bill of materials file:
After opening bill of materials file using Excel format, the unit of the first default column is successively identified in bill of materials file
The content of lattice, and after obtaining the line number for the first unit lattice that content is the first default mark, delete the row before the line number;
Bill of materials file is ranked up according to the content of the cell of the first default column;
The second unit lattice of the second default column of bill of materials file are successively obtained, and judge whether second unit lattice are empty, and
When it is empty for determining second unit lattice, the row where second unit lattice is deleted.
9. a kind of computer code automatically generating device, which is characterized in that including memory and processor, the memory is used for
At least one program is stored, the processor requires any one of 1-5 institute for loading at least one described program with perform claim
State method.
10. a kind of storage medium, wherein being stored with the executable instruction of processor, which is characterized in that the processor is executable
Instruction be used to execute such as any one of claim 1-5 the method when executed by the processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910185501.4A CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910185501.4A CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110059121A true CN110059121A (en) | 2019-07-26 |
CN110059121B CN110059121B (en) | 2021-09-03 |
Family
ID=67316950
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910185501.4A Active CN110059121B (en) | 2019-03-12 | 2019-03-12 | Method, system, device and storage medium for rapidly exporting bill of materials |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110059121B (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110471653A (en) * | 2019-08-16 | 2019-11-19 | 四川长虹电器股份有限公司 | BOM automatic arranging method based on C# |
CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
CN112860701A (en) * | 2021-03-01 | 2021-05-28 | 成都理工大学 | Non-modal frame data transmission system and method based on Revit |
CN112860245A (en) * | 2021-03-10 | 2021-05-28 | 厦门极致互动网络技术股份有限公司 | Batch remarking method based on Jira system |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030176994A1 (en) * | 2000-09-06 | 2003-09-18 | Steven Spitz | Boundary representation per feature methods and systems |
CN102096727A (en) * | 2009-12-15 | 2011-06-15 | 鸿富锦精密工业(深圳)有限公司 | System and method for generating bill of materials |
CN104050206A (en) * | 2013-10-12 | 2014-09-17 | 惠州华阳通用电子有限公司 | Material bill rapid exporting method and system thereof |
CN104657512A (en) * | 2015-03-19 | 2015-05-27 | 中铁二局第五工程有限公司 | Method and device for realizing steel truss arch bridge engineering quantity statistics by employing BIM (building information modeling) |
CN105005642A (en) * | 2015-06-25 | 2015-10-28 | 北京航空航天大学 | Three-dimensional model batch format conversion and weight reduction method |
CN105205038A (en) * | 2015-09-18 | 2015-12-30 | 昆山龙腾光电有限公司 | Complete material list table generation method and device |
CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
US20170168666A1 (en) * | 2015-12-15 | 2017-06-15 | International Business Machines Corporation | Extracting skill-level-based command execution patterns from catia command log |
CN107480374A (en) * | 2017-08-14 | 2017-12-15 | 中国铁道科学研究院铁道建筑研究所 | A kind of bridge BIM model creation methods based on CATIA |
CN108334724A (en) * | 2018-05-08 | 2018-07-27 | 滨州学院 | A kind of construction method of civil engineering BIM quantities models |
-
2019
- 2019-03-12 CN CN201910185501.4A patent/CN110059121B/en active Active
Patent Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030176994A1 (en) * | 2000-09-06 | 2003-09-18 | Steven Spitz | Boundary representation per feature methods and systems |
CN102096727A (en) * | 2009-12-15 | 2011-06-15 | 鸿富锦精密工业(深圳)有限公司 | System and method for generating bill of materials |
CN104050206A (en) * | 2013-10-12 | 2014-09-17 | 惠州华阳通用电子有限公司 | Material bill rapid exporting method and system thereof |
CN104657512A (en) * | 2015-03-19 | 2015-05-27 | 中铁二局第五工程有限公司 | Method and device for realizing steel truss arch bridge engineering quantity statistics by employing BIM (building information modeling) |
CN105005642A (en) * | 2015-06-25 | 2015-10-28 | 北京航空航天大学 | Three-dimensional model batch format conversion and weight reduction method |
CN105205038A (en) * | 2015-09-18 | 2015-12-30 | 昆山龙腾光电有限公司 | Complete material list table generation method and device |
US20170168666A1 (en) * | 2015-12-15 | 2017-06-15 | International Business Machines Corporation | Extracting skill-level-based command execution patterns from catia command log |
CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
CN107480374A (en) * | 2017-08-14 | 2017-12-15 | 中国铁道科学研究院铁道建筑研究所 | A kind of bridge BIM model creation methods based on CATIA |
CN108334724A (en) * | 2018-05-08 | 2018-07-27 | 滨州学院 | A kind of construction method of civil engineering BIM quantities models |
Non-Patent Citations (1)
Title |
---|
许峰: ""PDM系统与ERP系统集成技术研究与实践"", 《江苏科技信息》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110471653A (en) * | 2019-08-16 | 2019-11-19 | 四川长虹电器股份有限公司 | BOM automatic arranging method based on C# |
CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
CN112860701A (en) * | 2021-03-01 | 2021-05-28 | 成都理工大学 | Non-modal frame data transmission system and method based on Revit |
CN112860245A (en) * | 2021-03-10 | 2021-05-28 | 厦门极致互动网络技术股份有限公司 | Batch remarking method based on Jira system |
Also Published As
Publication number | Publication date |
---|---|
CN110059121B (en) | 2021-09-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110059121A (en) | A kind of method, system, device and the storage medium of quick export bill of materials | |
CN107844424B (en) | Model-based testing system and method | |
US8291329B2 (en) | Automatically merging graphical programs | |
US9037549B2 (en) | System and method for testing data at a data warehouse | |
US7694278B2 (en) | Data cube script development and debugging systems and methodologies | |
WO2001014969A1 (en) | Software rehosting system and method | |
EP1686466A1 (en) | Process automation | |
CN108830554B (en) | Task model-based intelligent detection method and system for data result information quality | |
AU2010201974A1 (en) | System and Method for Managing Information | |
CN109918299A (en) | A kind of method of comparison database architectural difference | |
CN112270116A (en) | Product packaging and transporting statics analysis method, platform, storage medium and application | |
CN113168497A (en) | Improved electronic form and method for updating electronic form | |
CN111984882A (en) | Data processing method, system and equipment | |
WO2023236301A1 (en) | Data mining control method and system | |
US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
US7035752B2 (en) | Semiconductor test data analysis system | |
Nevliudov et al. | Development of a software module for operational dispatch control of production based on cyber-physical control systems | |
CN109086985B (en) | Professional test information management system for spacecraft assembly | |
CN114969085A (en) | Method and system for algorithm modeling based on visualization technology | |
CN110347976A (en) | Method, system, device and the storage medium of quick equipment leading out data model | |
CN112508520A (en) | Method, system, device and storage medium for rapidly checking bill of material | |
CN112699032A (en) | Method for analyzing performance test result of vdbench based on Excel | |
JPH02275539A (en) | Debugging system | |
US11947905B1 (en) | Template builder for dynamically generated executables | |
CN109117124A (en) | A kind of function programming method of more return values |
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 |