CN105787678A - Disassembly method for furniture product design and detail disassembly - Google Patents
Disassembly method for furniture product design and detail disassembly Download PDFInfo
- Publication number
- CN105787678A CN105787678A CN201610304587.4A CN201610304587A CN105787678A CN 105787678 A CN105787678 A CN 105787678A CN 201610304587 A CN201610304587 A CN 201610304587A CN 105787678 A CN105787678 A CN 105787678A
- Authority
- CN
- China
- Prior art keywords
- order
- list
- product
- detail
- data
- 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
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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a disassembly method for furniture product design and detail disassembly, and the method comprises the steps: building a basic data management database through Excel VBA programming combined with an SqlServer database, recording the basic information of product parts, and building a BOM hierarchical structure; developing a B/S framework order operating platform through the Asp.Net technology combined with the SqlServer database, filling in an order, and automatically generating a product part list through combining with the basic data management database; developing a detail list decomposition system through the Excel VBA programming combined with the SqlServer database, decomposing the detail list into a trial assembly list, a packing list and a detailed list, and uploading the trial assembly list, the packing list and the detailed list; developing a C/S framework order master control system through the Asp.Net technology combined with the SqlServer database, and arranging a production machining plan list according to the data of the above two steps. The method employs the software and database, carries out the disassembly and reassembly of a product, and achieves the centralized production of a customized product.
Description
Technical field
The present invention relates to Furniture manufacturing technical field, particularly to a kind of decomposition method disassembled for furniture item design and detail.
Background technology
Continuous expansion along with residential market, the design of antique traditional furniture product and order decomposition are assigned and can not be met far away demand rapid, precision by original mode of manually disassembling, whole wood custom order particular for furniture, belong to the multiple batches of order of small lot, data volume is huge especially, and existing market does not also have corresponding technical scheme.
Summary of the invention
The technical problem to be solved is for the deficiencies in the prior art, it is provided that a kind of reasonable in design, the easy to use decomposition method disassembled for furniture item design and detail.
The technical problem to be solved is to be realized by following technical scheme, and the present invention is a kind of decomposition method disassembled for furniture item design and detail, is characterized in, its step is,
(1) basic data management: by ExcelVBA programming in conjunction with SqlServer database development basic data management data base, by the Back ground Information typing basic data management data base of product component, build BOM hierarchical structure, incidence relation between product component is done corresponding process by corresponding mathematical model, and do increase, delete, change, the relevant updates of query statistic, query manipulation；
(2) order data is collected: by Asp.Net technology in conjunction with SqlServer database development B/S framework order operation platform, user is release order by this platform, and fill in corresponding product specification parameter, the product specification parameter that system is filled according to user, in conjunction with " basic data management data base ", automatically generate product component inventory and product price；
(3) order decomposition: by ExcelVBA programming in conjunction with SqlServer database development detail list decomposing system, the system information according to the corresponding order data of Customer orders pick-up corresponding in B/S framework order operation platform, product specification supplemental characteristic and product component listings data, decompose and generate " trial assembly list ", " packing list ", " detail list ", then, the detailed data disassembled is uploaded data base；
(4) plan master control: by Asp.Net technology in conjunction with SqlServer database development C/S framework order turn-key system, C/S framework order turn-key system is according to the obtained data of step (2) and step (3), distinguish according to date, order, the various processing request of parts is distinguished, the production and processing plan list of each product correspondence parts of layout respectively.
The technical problem to be solved can also be realized further by following technical scheme, described C/S framework order turn-key system is according to the obtained data of order operation platform and detail list decomposing system, according to order decomposition and plan marshal data rule model layout respectively.
The technical problem to be solved can also be realized further by following technical scheme, is provided with special order management module on described B/S framework order operation platform, for collecting and manage the order with special process and structure.
Compared with prior art, the present invention utilizes software, the database instrument feature according to furniture item, furniture item is carried out BOM staged care, by to the collection of order data and decomposition, realizing automatically generating the BOM hierarchical structure of customization product, production schedule list, packing list detail etc., it is reasonable in design, easy to operate, improve process velocity and the efficiency of furniture item, be particularly well-suited to the centralized production of small lot multi items furniture item.
Detailed description of the invention
Further describe the concrete technical scheme of the present invention, in order to those skilled in the art is further understood that the present invention, and does not constitute the restriction to its right.
Embodiment 1, a kind of decomposition method disassembled for furniture item design and detail, its step is,
(1) basic data management: by ExcelVBA programming in conjunction with SqlServer database development basic data management data base, in basic data management data base, by the Back ground Information typing basic data management data base of product component, build BOM hierarchical structure, incidence relation between product component is done corresponding process by corresponding mathematical model, and do increase, delete, change, the relevant updates of query statistic, query manipulation；
(2) order data is collected: by Asp.Net technology in conjunction with SqlServer database development B/S framework order operation platform, user is release order by this platform, and fill in corresponding product specification parameter, the product specification parameter that system is filled according to user, in conjunction with " basic data management data base ", automatically generate product component inventory and product price；
(3) order decomposition: by ExcelVBA programming in conjunction with SqlServer database development detail list decomposing system, the system information according to the corresponding order data of Customer orders pick-up corresponding in B/S framework order operation platform, product specification supplemental characteristic and product component listings data, decompose and generate " trial assembly list ", " packing list ", " detail list ", then, the detailed data disassembled is uploaded, forms order database；
(4) plan master control: by Asp.Net technology in conjunction with SqlServer database development C/S framework order turn-key system, C/S framework order turn-key system is according to the obtained data of step (2) and step (3), distinguish according to date, order, the various processing request of parts is distinguished, the production and processing plan list of each product correspondence parts of layout respectively；Finally, production and processing plan list is issued to corresponding workshop arrange production operation.
Embodiment 2, the decomposition method disassembled for furniture item design and detail described in embodiment 1, described C/S framework order turn-key system is according to the obtained data of order operation platform and detail list decomposing system, according to order decomposition and plan marshal data rule model layout respectively.
Embodiment 3, the decomposition method disassembled for furniture item design and detail described in embodiment 1, described B/S framework order operation platform is provided with special order management module, for collecting and manage the order with special process and structure.
Heretofore described ExcelVBA programming, SqlServer data base, Asp.Net technology are the known technology of art.
Claims (3)
1. the decomposition method disassembled for furniture item design and detail, it is characterised in that: its step is,
(1) basic data management: by ExcelVBA programming in conjunction with SqlServer database development basic data management data base, by the Back ground Information typing basic data management data base of product component, build BOM hierarchical structure, incidence relation between product component is done corresponding process by corresponding mathematical model, and do increase, delete, change, the relevant updates of query statistic, query manipulation；
(2) order data is collected: by Asp.Net technology in conjunction with SqlServer database development B/S framework order operation platform, user is release order by this platform, and fill in corresponding product specification parameter, the product specification parameter that system is filled according to user, in conjunction with " basic data management data base ", automatically generate product component inventory and product price；
(3) order decomposition: by ExcelVBA programming in conjunction with SqlServer database development detail list decomposing system, the system information according to the corresponding order data of Customer orders pick-up corresponding in B/S framework order operation platform, product specification supplemental characteristic and product component listings data, decompose and generate " trial assembly list ", " packing list ", " detail list ", then, the detailed data disassembled is uploaded data base；
(4) plan master control: by Asp.Net technology in conjunction with SqlServer database development C/S framework order turn-key system, C/S framework order turn-key system is according to the obtained data of step (2) and step (3), distinguish according to date, order, the various processing request of parts is distinguished, the production and processing plan list of each product correspondence parts of layout respectively.
2. the decomposition method disassembled for furniture item design and detail according to claim 1, it is characterized in that: described C/S framework order turn-key system is according to the obtained data of order operation platform and detail list decomposing system, according to order decomposition and plan marshal data rule model layout respectively.
3. the decomposition method disassembled for furniture item design and detail according to claim 1, it is characterised in that: on described B/S framework order operation platform, it is provided with special order management module, for collecting and manage the order with special process and structure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610304587.4A CN105787678A (en) | 2016-05-10 | 2016-05-10 | Disassembly method for furniture product design and detail disassembly |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610304587.4A CN105787678A (en) | 2016-05-10 | 2016-05-10 | Disassembly method for furniture product design and detail disassembly |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105787678A true CN105787678A (en) | 2016-07-20 |
Family
ID=56401943
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610304587.4A Pending CN105787678A (en) | 2016-05-10 | 2016-05-10 | Disassembly method for furniture product design and detail disassembly |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105787678A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107563839A (en) * | 2017-07-31 | 2018-01-09 | 厦门乐石信息科技有限公司 | A kind of singulated management method and system of shower house customization system |
| CN107578142A (en) * | 2017-07-31 | 2018-01-12 | 厦门乐石信息科技有限公司 | A kind of singulated management method and system of bathroom cabinet customization system |
| CN108898200A (en) * | 2018-07-05 | 2018-11-27 | 汕头市诸事帮科技有限公司 | The singulated system of intelligence, manufacturing schedule management system and its implementation, operating method |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN110992149A (en) * | 2019-12-04 | 2020-04-10 | 中山职业技术学院 | Sharing system of processing of mahogany furniture |
| CN111861249A (en) * | 2020-07-29 | 2020-10-30 | 上海控软网络科技有限公司 | Information processing method and device for laser equipment production, electronic equipment and medium |
| CN113592391A (en) * | 2021-07-15 | 2021-11-02 | 厦门沣达体育科技有限公司 | Order production method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050080502A1 (en) * | 2003-10-14 | 2005-04-14 | Chernyak Alex H. | PLM-supportive CAD-CAM tool for interoperative electrical & mechanical design for hardware electrical systems |
| CN1753820A (en) * | 2003-02-28 | 2006-03-29 | 本田技研工业株式会社 | Parts kit production support system and program |
| CN102890798A (en) * | 2010-11-09 | 2013-01-23 | 厦门金牌厨柜股份有限公司 | Method for splitting and arranging material for scale customized cupboard order |
| CN103984985A (en) * | 2014-04-22 | 2014-08-13 | 广东工业大学 | Method for optimizing customized furniture serial batch scheduling |
| CN104008488A (en) * | 2014-06-17 | 2014-08-27 | 东南大学成贤学院 | Cyclone separator customization system |
-
2016
- 2016-05-10 CN CN201610304587.4A patent/CN105787678A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1753820A (en) * | 2003-02-28 | 2006-03-29 | 本田技研工业株式会社 | Parts kit production support system and program |
| US20050080502A1 (en) * | 2003-10-14 | 2005-04-14 | Chernyak Alex H. | PLM-supportive CAD-CAM tool for interoperative electrical & mechanical design for hardware electrical systems |
| CN102890798A (en) * | 2010-11-09 | 2013-01-23 | 厦门金牌厨柜股份有限公司 | Method for splitting and arranging material for scale customized cupboard order |
| CN103984985A (en) * | 2014-04-22 | 2014-08-13 | 广东工业大学 | Method for optimizing customized furniture serial batch scheduling |
| CN104008488A (en) * | 2014-06-17 | 2014-08-27 | 东南大学成贤学院 | Cyclone separator customization system |
Non-Patent Citations (1)
| Title |
|---|
| 曹平祥，王福辕: "板式家具数字化制造技术浅谈", 《木材工业》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107563839A (en) * | 2017-07-31 | 2018-01-09 | 厦门乐石信息科技有限公司 | A kind of singulated management method and system of shower house customization system |
| CN107578142A (en) * | 2017-07-31 | 2018-01-12 | 厦门乐石信息科技有限公司 | A kind of singulated management method and system of bathroom cabinet customization system |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN109064246B (en) * | 2018-06-22 | 2022-06-07 | 广东美久舍住宅产业有限公司 | Order generation method and device for standardized customized furniture, storage medium and terminal |
| CN108898200A (en) * | 2018-07-05 | 2018-11-27 | 汕头市诸事帮科技有限公司 | The singulated system of intelligence, manufacturing schedule management system and its implementation, operating method |
| CN108898200B (en) * | 2018-07-05 | 2021-08-24 | 汕头市诸事帮科技有限公司 | Intelligent sheet splitting system, production progress management system, realization method and operation method thereof |
| CN110992149A (en) * | 2019-12-04 | 2020-04-10 | 中山职业技术学院 | Sharing system of processing of mahogany furniture |
| CN111861249A (en) * | 2020-07-29 | 2020-10-30 | 上海控软网络科技有限公司 | Information processing method and device for laser equipment production, electronic equipment and medium |
| CN113592391A (en) * | 2021-07-15 | 2021-11-02 | 厦门沣达体育科技有限公司 | Order production method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105787678A (en) | Disassembly method for furniture product design and detail disassembly | |
| CN109583762B (en) | System for production process modeling and product data tracking | |
| CN103279613B (en) | High-precision complex product assembly material automatic kitting method | |
| US8725678B2 (en) | System of centrally managing core reference data associated with an enterprise | |
| CN102651102A (en) | Product information modeling method in collaborative environment based on product entire life cycle | |
| CN105976040A (en) | Concentrated customization method based on small-amount multi-type household products | |
| CN108984895A (en) | A kind of model automatic identifying method based on XML heterogeneous platform | |
| CN101127104A (en) | Ship engineering material integrated handling computer management system | |
| CN102136109B (en) | Product structure tree-based design flow dynamic modeling method | |
| CN102012952A (en) | Long-distance design system and method for section product | |
| CN1763774A (en) | Modeling method for visible production process description of process industry | |
| CN109840754A (en) | A kind of device and method, intelligent terminal and the management system of customized production plan | |
| Mok et al. | Automation of mold designs with the reuse of standard parts | |
| CN112084646A (en) | Modular product customization method based on digital twinning | |
| CN111709702A (en) | Product full life cycle management system | |
| CN114066292A (en) | Development system for digital products of railway freight car | |
| CN104572740A (en) | Data storage method and device | |
| Avvaru et al. | Integration of PLM, MES and ERP systems to optimize the engineering, production and business | |
| CN106558105A (en) | Using method of the product Configurable BOM in virtual reality system | |
| WO2005114495A1 (en) | A system and method of a scalable and rule-based building chassis platform for planning, developing and implementing product family architecture solutions in multi-storey buildings | |
| CN102479257A (en) | Design and implementation method of intelligent numerical control machine tool | |
| CN106408178A (en) | Multi-dimensional data snapshot-based product BOM management method and device | |
| CN113327101A (en) | Technical management method for realizing product configuration by using PDM integrated system | |
| CN101441645B (en) | The System and method for of technical data analysis | |
| CN112508381A (en) | Computing system for project cost of mechanical industry and implementation method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160720 |
|
| RJ01 | Rejection of invention patent application after publication |