CN107038555A - A kind of BOM tables introduction method and device - Google Patents
A kind of BOM tables introduction method and device Download PDFInfo
- Publication number
- CN107038555A CN107038555A CN201710229864.4A CN201710229864A CN107038555A CN 107038555 A CN107038555 A CN 107038555A CN 201710229864 A CN201710229864 A CN 201710229864A CN 107038555 A CN107038555 A CN 107038555A
- Authority
- CN
- China
- Prior art keywords
- user
- item
- project
- lead
- module
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 230000008676 import Effects 0.000 claims abstract description 11
- 230000004083 survival effect Effects 0.000 claims 1
- 230000008569 process Effects 0.000 description 5
- 230000008859 change Effects 0.000 description 3
- 230000004044 response Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
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/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Manufacturing & Machinery (AREA)
- General Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of BOM tables introduction method and device, method includes：Receive the request of user's lead-in item；Generating item mesh criteria table is asked according to user's lead-in item；Obtain the content that user inputs the project criteria table；Project management table is generated according to the content that the user inputs the project criteria table；Receive user and import parts list request；Parts list request is imported according to the user corresponding part is added in project management table.The BOM tables introduction method and device that the present invention is provided can solve the problem of low data handling procedure efficiency, high error rate and inconvenient inquiry by the importing and management of project form and part form.
Description
Technical field
Field, more particularly to a kind of BOM tables introduction method and device are imported the present invention relates to data.
Background technology
In manufacturing enterprise field, the data of all departments such as production, buying, sale are huge, and calculation process easily malfunctions, unified
Data processing speed is slow during management and inconvenience inquiry is, it is necessary to which special software is managed collectively data.
The content of the invention
In order to overcome the deficiencies in the prior art, it is an object of the invention to provide a kind of BOM tables introduction method and device, its
The problem of low data handling procedure efficiency, high error rate and inconvenient inquiry can be solved.
The purpose of the present invention is realized using following technical scheme：
A kind of BOM tables introduction method, including：
Receive the request of user's lead-in item；
Generating item mesh criteria table is asked according to user's lead-in item；
Obtain the content that user inputs the project criteria table；
Project management table is generated according to the content that the user inputs the project criteria table；
Receive user and import parts list request；
Parts list request is imported according to the user corresponding part is added in project management table.
It is preferred that, it is described to ask generating item mesh criteria table to include according to user's lead-in item：
Read user's lead-in item；
If user's lead-in item is system standard form, user's lead in item destination field is obtained；
If user's lead-in item is self-defined form, the self-defined form is entered with the system standard form
Row matches and obtains respective field.
It is preferred that, the reception user also includes after importing parts list request：
The parts list that user is imported is associated with the project in the project management table.
It is preferred that, the content that the user inputs the project criteria table is at least said including field corresponding with Part No.
It is bright.
The invention further relates to a kind of BOM tables gatherer, including：First receiving module, the first generation module, first obtain
Module, the second generation module, the second receiving module and add module；
First receiving module, for receiving the request of user's lead-in item；
First generation module, for asking generating item mesh criteria table according to user's lead-in item；
First acquisition module, the content of the project criteria table is inputted for obtaining user；
Second generation module, the content for inputting the project criteria table according to the user generates project pipe
Manage table；
Second receiving module, parts list request is imported for receiving user；
The add module, corresponding zero is added for importing parts list request according to the user in project management table
Part.
It is preferred that, in addition to：Read module, the second acquisition module and the 3rd acquisition module；
The read module, for reading user's lead-in item；
Second acquisition module, if being system standard form for user's lead-in item, obtains the user
Lead in item destination field；
3rd acquisition module, if being self-defined form for user's lead-in item, by the user-defined data table
Lattice are matched with the system standard form and obtain respective field.
It is preferred that, in addition to：Relating module；
The relating module, parts list and the project in the project management table for user to be imported are associated.
It is preferred that, the content that the user inputs the project criteria table is at least said including field corresponding with Part No.
It is bright.
The invention further relates to a kind of BOM tables gatherer, including：
Processor；
Memory for storing processor-executable instruction；
Wherein, the processor is configured as：
Receive the request of user's lead-in item；
Generating item mesh criteria table is asked according to user's lead-in item；
Obtain the content that user inputs the project criteria table；
Project management table is generated according to the content that the user inputs the project criteria table；
Receive user and import parts list request；
Parts list request is imported according to the user corresponding part is added in project management table.
Compared with prior art, the beneficial effects of the present invention are：By the importing and management of project form and part form,
User can carry out additions and deletions and modification to project and part form as needed, and be associated, and can solve data handling procedure
Efficiency is low, error rate is high and the problem of inconvenient inquiry.
Brief description of the drawings
Fig. 1 is BOM tables introduction method flow chart provided in an embodiment of the present invention；
The BOM table gatherer schematic diagrames that Fig. 2 provides for one embodiment of the invention；
The BOM table gatherer schematic diagrames that Fig. 3 provides for another embodiment of the present invention.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
As shown in figure 1, BOM tables introduction method provided in an embodiment of the present invention includes：
Step S101：Receive the request of user's lead-in item.
Specifically, user finds corresponding classification in client, lead-in item is selected, server performs corresponding response behaviour
Make.
Step S102：Generating item mesh criteria table is asked according to user's lead-in item.
Specifically, the step includes：
Step S1021：Read user's lead-in item.Specifically, user selects the option of lead-in item, service in client
Device is operated accordingly according to option response.
Step S1022：If user's lead-in item is system standard form, the word of user's lead-in item is obtained
Section.
Step S1023：If user's lead-in item is self-defined form, by the self-defined form and the system
Criteria table is matched and obtains respective field；User can add field according to actual needs and preserve template, convenient to use
Family uses and had a wide range of application.
Step S103：Obtain the content that user inputs the project criteria table.
Specifically, the content that user inputs the project criteria table at least includes explanation of field corresponding with Part No..
User fills in corresponding explanation of field according to the content of criteria table, for example Part No., part name, material number, drawing version,
The explanation of field of processing technology, price, date of receiving etc. and submission.
Step S104：Project management table is generated according to the content that the user inputs the project criteria table.
Specifically, server generates unified project management table, user according to the content of user's cuit criteria table
It can be inquired about in project management table and modification item destination field content, meanwhile, user can change project management as needed
The display order of field in table.
Step S105：Receive user and import parts list request.Specifically, user imports zero in the selection of project management surface and interface
Part table options, the corresponding operation of server response, if parts list is criteria table, directly read field contents, if parts list
It is User Defined form, then reads field contents after being matched with system field.
Step S106：The parts list that user is imported is associated with the project in the project management table.Specifically, same
One part is used for multiple projects, then is associated parts list with the project in project management table, when changing and adding form
It is more efficient and not error-prone.
Step S107：Parts list request is imported according to the user corresponding part is added in project management table.
BOM tables introduction method provided in an embodiment of the present invention, project and part classification are imported and is associated and adds,
Different departments have can show during data movement in client, with the format management purchase order of project in project management table,
Convenient inquiry, and data-handling efficiency is high, not error-prone；User can issue inquiry in project management table, track inquiry and order
Single progress.
As shown in Fig. 2 BOM tables gatherer provided in an embodiment of the present invention, including：First receiving module 11, first is given birth to
Into module 12, the first acquisition module 13, the second generation module 14, the second receiving module 15 and add module 16；
First receiving module 11, for receiving the request of user's lead-in item；
First generation module 12, for asking generating item mesh criteria table according to user's lead-in item；
First acquisition module 13, the content of the project criteria table is inputted for obtaining user；
Second generation module 14, the content for inputting the project criteria table according to the user generates project management
Table；
Second receiving module 15, parts list request is imported for receiving user；
Add module 16, corresponding zero is added for importing parts list request according to the user in project management table
Part.
It is preferred that, in addition to：Read module, the second acquisition module and the 3rd acquisition module；
Read module, for reading user's lead-in item；
Second acquisition module, if being system standard form for user's lead-in item, obtains the user and imports
Item destination field；
3rd acquisition module, if for user's lead-in item be self-defined form, will the self-defined form and
The system standard form is matched and obtains respective field.
It is preferred that, in addition to：Relating module；
Relating module, parts list and the project in the project management table for user to be imported are associated.
It is preferred that, the content that user inputs the project criteria table at least includes explanation of field corresponding with Part No..
The method in device and previous embodiment in the present embodiment be based on two aspects under same inventive concept,
Above method implementation process is described in detail, thus those skilled in the art can according to it is described above clearly
The structure and implementation process of the device in the present embodiment are solved, it is succinct for specification, just repeat no more herein.
For convenience of description, it is divided into various modules during description apparatus above with function to describe respectively.Certainly, this is being implemented
The function of each module can be realized in same or multiple softwares and/or hardware during invention.
As seen through the above description of the embodiments, those skilled in the art can be understood that the present invention can
Realized by the mode of software plus required general hardware platform.Understood based on such, technical scheme essence
On the part that is contributed in other words to prior art can be embodied in the form of software product, the computer software product
It can be stored in storage medium, such as ROM/RAM, magnetic disc, CD, including some instructions are to cause a computer equipment
(can be personal computer, server, or network equipment etc.) performs some of each of the invention embodiment or embodiment
Method described in part.
As shown in figure 3, the BOM table gatherers that another embodiment of the present invention is provided, including：
Processor 21；
Memory 22 for storing the executable instruction of processor 21；
Wherein, processor 21 is configured as：
Receive the request of user's lead-in item；
Generating item mesh criteria table is asked according to user's lead-in item；
Obtain the content that user inputs the project criteria table；
Project management table is generated according to the content that the user inputs the project criteria table；
Receive user and import parts list request；
Parts list request is imported according to the user corresponding part is added in project management table.
The method in device and previous embodiment in the present embodiment be based on two aspects under same inventive concept,
Above method implementation process is described in detail, thus those skilled in the art can according to it is described above clearly
The structure and implementation process of the device in the present embodiment are solved, it is succinct for specification, just repeat no more herein.
The BOM tables introduction method and device that the present invention is provided pass through the importing and management of project form and part form, energy
Solve the problem of low data handling procedure efficiency, high error rate and inconvenient inquiry.
It will be apparent to those skilled in the art that technical scheme that can be as described above and design, make other various
It is corresponding to change and deformation, and all these change and deformation should all belong to the protection domain of the claims in the present invention
Within.
Claims (9)
1. a kind of BOM tables introduction method, it is characterised in that including：
Receive the request of user's lead-in item；
Generating item mesh criteria table is asked according to user's lead-in item；
Obtain the content that user inputs the project criteria table；
Project management table is generated according to the content that the user inputs the project criteria table；
Receive user and import parts list request；
Parts list request is imported according to the user corresponding part is added in project management table.
2. BOM tables introduction method according to claim 1, it is characterised in that described to be asked according to user's lead-in item
Seeking survival into project criteria table includes：
Read user's lead-in item；
If user's lead-in item is system standard form, user's lead in item destination field is obtained；
If user's lead-in item is self-defined form, by the self-defined form and system standard form progress
Match somebody with somebody and obtain respective field.
3. BOM tables introduction method according to claim 1, it is characterised in that the reception user imports parts list request
Also include afterwards：
The parts list that user is imported is associated with the project in the project management table.
4. BOM tables introduction method according to claim 3, it is characterised in that the user inputs the project standard scale
The content of lattice at least includes explanation of field corresponding with Part No..
5. a kind of BOM tables gatherer, it is characterised in that including：First receiving module, the first generation module, first obtain mould
Block, the second generation module, the second receiving module and add module；
First receiving module, for receiving the request of user's lead-in item；
First generation module, for asking generating item mesh criteria table according to user's lead-in item；
First acquisition module, the content of the project criteria table is inputted for obtaining user；
Second generation module, the content for inputting the project criteria table according to the user generates project management
Table；
Second receiving module, parts list request is imported for receiving user；
The add module, corresponding part is added for importing parts list request according to the user in project management table.
6. BOM tables gatherer according to claim 5, it is characterised in that also include：Read module, second obtain mould
Block and the 3rd acquisition module；
The read module, for reading user's lead-in item；
Second acquisition module, if being system standard form for user's lead-in item, obtains the user and imports
Item destination field；
3rd acquisition module, if for user's lead-in item be self-defined form, will the self-defined form and
The system standard form is matched and obtains respective field.
7. BOM tables gatherer according to claim 5, it is characterised in that also include：Relating module；
The relating module, parts list and the project in the project management table for user to be imported are associated.
8. BOM tables gatherer according to claim 7, it is characterised in that the user inputs the project standard scale
The content of lattice at least includes explanation of field corresponding with Part No..
9. a kind of BOM tables gatherer, it is characterised in that including：
Processor；
Memory for storing processor-executable instruction；
Wherein, the processor is configured as：
Receive the request of user's lead-in item；
Generating item mesh criteria table is asked according to user's lead-in item；
Obtain the content that user inputs the project criteria table；
Project management table is generated according to the content that the user inputs the project criteria table；
Receive user and import parts list request；
Parts list request is imported according to the user corresponding part is added in project management table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710229864.4A CN107038555A (en) | 2017-04-10 | 2017-04-10 | A kind of BOM tables introduction method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710229864.4A CN107038555A (en) | 2017-04-10 | 2017-04-10 | A kind of BOM tables introduction method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107038555A true CN107038555A (en) | 2017-08-11 |
Family
ID=59535990
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710229864.4A Pending CN107038555A (en) | 2017-04-10 | 2017-04-10 | A kind of BOM tables introduction method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107038555A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110503378A (en) * | 2019-08-27 | 2019-11-26 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103955577A (en) * | 2014-04-24 | 2014-07-30 | 金丰（中国）机械工业有限公司 | Computer automatic design method for mechanical equipment |
| CN104778540A (en) * | 2015-03-27 | 2015-07-15 | 中材装备集团有限公司 | BOM (bill of material) management method and management system for building material equipment manufacturing |
-
2017
- 2017-04-10 CN CN201710229864.4A patent/CN107038555A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN103955577A (en) * | 2014-04-24 | 2014-07-30 | 金丰（中国）机械工业有限公司 | Computer automatic design method for mechanical equipment |
| CN104778540A (en) * | 2015-03-27 | 2015-07-15 | 中材装备集团有限公司 | BOM (bill of material) management method and management system for building material equipment manufacturing |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110503378A (en) * | 2019-08-27 | 2019-11-26 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3353672B1 (en) | Method and apparatus for transferring data between databases | |
| CN107230035A (en) | Information-pushing method and device | |
| US20140114822A1 (en) | Method and system for creating tax configuration templates | |
| CN109344162A (en) | Business data processing method and device | |
| CN104484766A (en) | Enterprise management application system | |
| CN106326243B (en) | Data processing method and device | |
| CN109446274A (en) | The method and apparatus of big data platform BI metadata management | |
| CN108369591A (en) | System and method for caching and parameterizing ir | |
| CN110135770B (en) | Method and device for generating ex-warehouse scheme | |
| JP7338820B2 (en) | Inventory quantity identification method and device | |
| US10671631B2 (en) | Method, apparatus, and computer-readable medium for non-structured data profiling | |
| CN110309142A (en) | The method and apparatus of regulation management | |
| CN107038555A (en) | A kind of BOM tables introduction method and device | |
| CN101702209A (en) | Method for receiving material and device thereof | |
| CN102930401B (en) | Technology providing enterprise resource planning (ERP) function from customer relation management (CRM) client side application | |
| CN108108392B (en) | Commodity data management method, commodity data management device, computer equipment and storage medium | |
| CN110163564B (en) | Method, system and storage medium for generating item service based on item model | |
| US9971801B2 (en) | Grid cell data requests | |
| CN107291923A (en) | Information processing method and device | |
| CN109255563A (en) | The determination method and apparatus in the storage space region of article | |
| CN108132936A (en) | Data lead-in method and device | |
| JP2010277571A (en) | Commodity selection system and method, and commodity selection computer program | |
| CN114757157A (en) | Method, apparatus, device and medium for generating aircraft work package | |
| CN112651538A (en) | Method and device for configuring rack | |
| CN106933913B (en) | Data processing method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170811 |
|
| RJ01 | Rejection of invention patent application after publication |