CN106372944A - Data table-based product tracing method and system - Google Patents
Data table-based product tracing method and system Download PDFInfo
- Publication number
- CN106372944A CN106372944A CN201610703166.9A CN201610703166A CN106372944A CN 106372944 A CN106372944 A CN 106372944A CN 201610703166 A CN201610703166 A CN 201610703166A CN 106372944 A CN106372944 A CN 106372944A
- Authority
- CN
- China
- Prior art keywords
- product
- information
- station
- data table
- producing line
- 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
- G06Q30/00—Commerce
- G06Q30/018—Certifying business or products
Landscapes
- Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data table-based product tracing method and system. Products enter a first workstation and a production line equipment master station establishes data table information of the products; and after the processing of the products is finished, the first workstation updates the data table information to the production line equipment master station. The products enter a subsequent workstation, the workstation queries the data table information from the production line equipment master station; and the products leave the workstation, the workstation updates the data table information to the production line equipment master station, after the defective products are removed or the last product leaves the line, the production line equipment master station transmits the data table information of the products to a server PC and deletes the data table information from a data table, and the server PC integrates, files and stores the information through a product tracing module according to the data table information of the products. According to the method and system disclosed by the invention, each technological processing link of the production line products can be traced in real time, and the production and processing information of related products can be collected, so that the online real-time tracing and offline product information tracing of the production line products are realized, and benefits are brought to timely and correctly trace the product fault stages and then solve the problems.
Description
Technical field
The invention belongs to production automation technical field, more particularly, to a kind of product back-tracing method based on tables of data and be
System.
Background technology
With the development of industrial technology, automatization's industry is promoted to develop towards intelligent, informationalized direction.Traditional
Automatic production line, machine replaces artificial, production product automatically.Each technique processing link of automatic production line may
Performance on product and quality produce impact, when producing line output defective products it is impossible to fault of finding out promptly and accurately goes out at this stage,
Due to lacking the production information of each process procedure of product, the analysis improvement of the diagnosis to subsequent product fault and product quality is non-
Chang Buli, whole production process cannot real-time tracing on line, also the production of product cannot be reviewed under line, the production of whole producing line
Efficiency reduces, and product quality is difficult to control to and improves.
Therefore, it is necessary to offer is a kind of be solved the above problems based on the product back-tracing method and system of tables of data.
Content of the invention
It is an object of the invention to provide a kind of product back-tracing method and system based on tables of data.
The present invention is achieved through the following technical solutions above-mentioned purpose:
A kind of product back-tracing method based on tables of data, comprises the following steps:
When s1: product enters the first station, product bar code information is read in the barcode scanner scanning of the first station equipment, and should
Product bar code information is transmitted to producing line equipment main website, and producing line equipment main website sets up the data table information adding this product；
S2: the first station equipment completes the processing of product, and the data table information of this product is updated to producing line equipment master
Stand；
S3: product enters the second station, and product bar code information is read in the barcode scanner scanning of the second station equipment, and to producing line
Product data sheet information is inquired about by equipment main website, and whether inquiry Product Status are defective products, if not defective products, then the second station
Complete the processing of product, and the data table information of this product is updated to producing line equipment main website；If defective products, then product stream
Go to defective products outlet, enter step s5；
S4: repeat s3, until product enters last station；
To producing line equipment main website, producing line equipment main website is by the data table information of this product for s5: product data sheet information updating
Transmit to server pc, server pc product back-tracing module of product back-tracing information according to specific definition, by data table information
Tracing information definition format sorted generalization according to product achieves, so that product information is reviewed and product quality analysis and management and control,
And the data table information in producing line equipment main website is deleted.
Further, pass through cclink network service between described producing line equipment main website and each station equipment, realize product
The interpolation of data table information, feedback, renewal and deletion action.
Further, pass through ethernet communication between described server pc and described producing line equipment main website, complete product number
According to the archive operations of table information, to review under product quality analysis and product line.
Further, described barcode scanner is transmitted this product bar code information to described producing line equipment master by cclink network
Stand.
Further, described data table information includes product bar code, frock carrier bar code, station, product shape residing for product
State, product enter the station the time, product outbound time, product are bad occurs station, bad code, poor prognostic cause description, product crucial
Technological parameter type, product key process parameter value and the good or bad result of product key process parameter.
Further, described product back-tracing information includes product identification information, product flame, product critical process ginseng
Number and product information out of the station.
A kind of product back-tracing system based on tables of data, is connected including some station and respectively corresponding being communicated with described station
Some barcode scanner, described station and described barcode scanner be connected with producing line equipment main website communication respectively, described producing line equipment main website
It is connected with server pc communication, described server pc is connected with product back-tracing module.
Compared with prior art, the present invention provides a kind of product back-tracing method and system based on tables of data, can be real-time
Follow the trail of each technique processing link of producing line product, and collect the production and processing information of Related product it is achieved that production
Tracing product information under real-time tracing and line on line, is conducive to tracing product failure phase promptly and accurately and solves in time to ask
Topic, the analysis improvement of the diagnosis to subsequent product fault and product quality provides effective data message, improves producing line
Production efficiency, has controlled links product quality, and can provide rational Improving Measurements.
Brief description
Fig. 1 is the method flow diagram of the embodiment of the present invention；
Fig. 2 is the structural representation of the embodiment of the present invention.
Specific embodiment
Embodiment:
As shown in Figure 1-2, a kind of product back-tracing method based on tables of data of the present embodiment, comprises the following steps:
When s1: product enters the first station, product bar code information is read in the barcode scanner scanning of the first station equipment, and should
Product bar code information is transmitted to producing line equipment main website, and producing line equipment main website sets up the data table information adding this product, tables of data
When information includes product bar code, frock carrier bar code, station residing for product, Product Status, product enter the station time, product outbound
Between, product bad occur station, bad code, poor prognostic cause description, product key process parameter type, product critical process join
Numerical value and the good or bad result of product key process parameter etc.；
S2: the first station equipment completes the processing of product, and the data table information of this product is updated to producing line equipment master
Stand, by way of the data table information of setting up product in producing line equipment main website and software tags, realize chasing after online of production
Track；
S3: product enters the second station, and product bar code information is read in the barcode scanner scanning of the second station equipment, and to producing line
Product data sheet information is inquired about by equipment main website, and whether inquiry Product Status are defective products, by obtaining in real time to producing line equipment main website
Take the data table information of product, the status information according to product intelligently selects processed or clearance to process, and realizes producing line
Intelligence produces.If not defective products, then the second station completes the processing of product, and the data table information of this product is updated to
Producing line equipment main website；If defective products, then product stream goes to defective products outlet, enters step s5；
S4: repeat s3, until product enters last station；
To producing line equipment main website, producing line equipment main website is by the data table information of this product for s5: product data sheet information updating
Transmit to server pc, server pc product back-tracing module of product back-tracing information according to specific definition, by data table information
Tracing information definition format sorted generalization according to product achieves, so that product information is reviewed and product quality analysis and management and control,
And the data table information in producing line equipment main website is deleted, reduce the burden of producing line equipment main website.Producing line is passed through initial station and is set up
Product data sheet information, miss the stop upgrading products data table information, and terminal or defective products outlet achieve and delete data table information,
Complete in whole producing line production process product identification circulation and product information collection work, realize following the trail of on the line that produces and line under
Review and producing line quality management and control, to review product in the condition of production of each station and the timely work adjusting critical process station
Skill parameter value, improves Data Source to producing line product quality analysis, very high producing line quality management and control dynamics.
Wherein, pass through cclink network service between producing line equipment main website and each station equipment, realize product data sheet letter
The interpolation of breath, feedback, renewal and deletion action.Barcode scanner is transmitted this product bar code information to producing line by cclink network
Equipment main website.The data table information of each product of producing line is set up in producing line equipment main website, and each station obtains according to barcode scanner scanning
Product bar code, carries out product data sheet information exchange with producing line equipment main website, realizes intellectuality, the e-manufacturing of product, real
The information real-time tracing of existing process of producing product.
Pass through ethernet communication between server pc and producing line equipment main website, complete the archive behaviour of product data sheet information
Make, to review under product quality analysis and product line.
Product back-tracing information includes product identification information, product flame, product key process parameter and product turnover
Stand information.
A kind of product back-tracing system based on tables of data, is connected with station 1 communication including some station 1 and respectively correspondence
Some barcode scanner 2, station 1 and barcode scanner 2 are connected with producing line equipment main website 3 communication respectively, producing line equipment main website 3 and server
Pc4 communication connects, and server pc4 is connected with product back-tracing module 5.Wherein barcode scanner 2 is used for scanning acquisition product bar code, each work
Stand 1 according to product bar code pass through cclink network to producing line equipment main website 3 application set up product data sheet information, inquiry product number
According to table information, require to update the data table information, require to delete data table information；In producing line, the data table information of all products is set up
In producing line equipment main website 3, producing line equipment main website 3 is used for passing through cclink network service interactive product number with each station equipment
According to table information, corresponding station 1 is asked, and adds, feeds back, updates, deletes data table information；Server p4c is received by Ethernet
The product data sheet information of producing line equipment main website 3 transmission, integrates according to product back-tracing module definition and concludes product data sheet information,
And store file, so that subsequent product information tracing, producing line attributional analysis, product processing technique Parameter analysis and technological parameter
Adjustment, whole system realizes producing line production information, intellectuality it is achieved that reviewing it is achieved that producing under tracking and line on the line of product
The quality management and control that line produces, improves the production efficiency of producing line.
The a kind of of the present embodiment is had the advantage that based on the product back-tracing method and system of tables of data
1st, whole system realizes the software identification of product in the form of tables of data, has saved the cost of producing line；
2nd, ensure that and review it is achieved that the intelligence of producing line produces and information-based under tracking and line on the line of product information；
3rd, according to the product key process parameter information in the data table information achieving, the quality problem of analysis product, and
The technique of Shi Gengzheng producing line, improves the quality of production management and control of producing line, improves the production efficiency of producing line.
Above is only some embodiments of the present invention.For the person of ordinary skill of the art, without departing from
On the premise of the invention design, some deformation can also be made and improve, these broadly fall into protection scope of the present invention.
Claims (7)
1. a kind of product back-tracing method based on tables of data is it is characterised in that comprise the following steps:
When s1: product enters the first station, product bar code information is read in the barcode scanner scanning of the first station equipment, and by this product
Bar code information is transmitted to producing line equipment main website, and producing line equipment main website sets up the data table information adding this product；
S2: the first station equipment completes the processing of product, and the data table information of this product is updated to producing line equipment main website；
S3: product enters the second station, and product bar code information is read in the barcode scanner scanning of the second station equipment, and to producing line equipment
Product data sheet information is inquired about by main website, and whether inquiry Product Status are defective products, and if not defective products, then the second station completes
The processing of product, and the data table information of this product is updated to producing line equipment main website；If defective products, then product stream goes to
Defective products outlet, enters step s5；
S4: repeat s3, until product enters last station；
The data table information of this product is transmitted by s5: product data sheet information updating to producing line equipment main website, producing line equipment main website
To server pc, server pc product back-tracing module of product back-tracing information according to specific definition, by data table information according to
The tracing information definition format sorted generalization of product achieves, and the data table information in producing line equipment main website is deleted.
2. a kind of product back-tracing method based on tables of data according to claim 1 it is characterised in that: described producing line equipment
Pass through cclink network service between main website and each station equipment.
3. a kind of product back-tracing method based on tables of data according to claim 1 it is characterised in that: described server pc
Pass through ethernet communication and described producing line equipment main website between.
4. a kind of product back-tracing method based on tables of data according to claim 1 it is characterised in that: described barcode scanner lead to
Cross cclink network to transmit this product bar code information to described producing line equipment main website.
5. a kind of product back-tracing method based on tables of data according to claim 1 it is characterised in that: described tables of data letter
Breath includes product bar code, frock carrier bar code, station residing for product, Product Status, product enter the station the time, the product outbound time,
Product is bad to there is station, bad code, poor prognostic cause description, product key process parameter type, product key process parameter
Value and the good or bad result of product key process parameter.
6. a kind of product back-tracing method based on tables of data according to claim 1 it is characterised in that: described product back-tracing
Information includes product identification information, product flame, product key process parameter and product information out of the station.
7. a kind of product back-tracing system based on tables of data it is characterised in that: include some station and corresponding respectively and described work
Some barcode scanner that communication of standing connects, described station and described barcode scanner are communicated with producing line equipment main website respectively and are connected, described product
Line equipment main website is connected with server pc communication, and described server pc is connected with product back-tracing module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610703166.9A CN106372944A (en) | 2016-08-23 | 2016-08-23 | Data table-based product tracing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610703166.9A CN106372944A (en) | 2016-08-23 | 2016-08-23 | Data table-based product tracing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106372944A true CN106372944A (en) | 2017-02-01 |
Family
ID=57878630
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610703166.9A Pending CN106372944A (en) | 2016-08-23 | 2016-08-23 | Data table-based product tracing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106372944A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108345276A (en) * | 2017-12-26 | 2018-07-31 | 湖北世纪联合创新科技有限公司 | A kind of production process of liquid crystal displays execution system |
| WO2018205195A1 (en) * | 2017-05-11 | 2018-11-15 | 深圳市柘叶红实业有限公司 | Production work order management system and management method therefor |
| CN109872166A (en) * | 2019-02-21 | 2019-06-11 | 苏州天准科技股份有限公司 | A kind of quality of production retroactive method based on big data technology |
| CN110058151A (en) * | 2018-01-19 | 2019-07-26 | 群光电子(苏州)有限公司 | A kind of keypad function test method |
| CN110110821A (en) * | 2019-04-10 | 2019-08-09 | 珠海梅西互动技术有限公司 | A kind of two-dimensional code data state tracking method and system of automatic detection system |
| CN112348432A (en) * | 2020-10-27 | 2021-02-09 | 深圳效率科技有限公司 | Production management system |
| CN112966836A (en) * | 2021-02-03 | 2021-06-15 | 天津杰士电池有限公司 | Internet of things-based battery production recovery overall process tracing method and system |
| CN115496426A (en) * | 2022-11-16 | 2022-12-20 | 承德石油高等专科学校 | Industrial big data intelligent analysis decision-making method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819658A (en) * | 2010-04-09 | 2010-09-01 | 浙江大学 | Visual production management and control method for discrete workshop |
| CN103592898A (en) * | 2012-08-13 | 2014-02-19 | 上海斐讯数据通信技术有限公司 | An electronic product production automatic control system and a method |
-
2016
- 2016-08-23 CN CN201610703166.9A patent/CN106372944A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819658A (en) * | 2010-04-09 | 2010-09-01 | 浙江大学 | Visual production management and control method for discrete workshop |
| CN103592898A (en) * | 2012-08-13 | 2014-02-19 | 上海斐讯数据通信技术有限公司 | An electronic product production automatic control system and a method |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018205195A1 (en) * | 2017-05-11 | 2018-11-15 | 深圳市柘叶红实业有限公司 | Production work order management system and management method therefor |
| CN108345276A (en) * | 2017-12-26 | 2018-07-31 | 湖北世纪联合创新科技有限公司 | A kind of production process of liquid crystal displays execution system |
| CN108345276B (en) * | 2017-12-26 | 2019-02-26 | 湖北世纪联合创新科技有限公司 | A kind of production process of liquid crystal displays execution system |
| CN110058151A (en) * | 2018-01-19 | 2019-07-26 | 群光电子(苏州)有限公司 | A kind of keypad function test method |
| CN109872166A (en) * | 2019-02-21 | 2019-06-11 | 苏州天准科技股份有限公司 | A kind of quality of production retroactive method based on big data technology |
| CN110110821A (en) * | 2019-04-10 | 2019-08-09 | 珠海梅西互动技术有限公司 | A kind of two-dimensional code data state tracking method and system of automatic detection system |
| CN112348432A (en) * | 2020-10-27 | 2021-02-09 | 深圳效率科技有限公司 | Production management system |
| CN112966836A (en) * | 2021-02-03 | 2021-06-15 | 天津杰士电池有限公司 | Internet of things-based battery production recovery overall process tracing method and system |
| CN115496426A (en) * | 2022-11-16 | 2022-12-20 | 承德石油高等专科学校 | Industrial big data intelligent analysis decision-making method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106372944A (en) | Data table-based product tracing method and system | |
| CN107942966A (en) | Production information management system, numerically-controlled machine tool and production management system | |
| CN109358574A (en) | A kind of intelligent data acquisition, monitor and analysis system and method | |
| CN108681878A (en) | The acquisition of intelligent plant production line data and billboard management system and method | |
| CN111461520B (en) | Intelligent analysis method for distribution network line automatic switch distribution | |
| CN106372777A (en) | Product production information and process management control method | |
| CN101477368A (en) | Clothing product line equipment control method and system | |
| CN102222270B (en) | Manufacture and perform management system and production curves device | |
| CN108829048A (en) | A kind of information analysis system and method based on liquid crystal glass base production and processing | |
| CN107679873A (en) | A kind of stamp information tracing management method for mounting product online based on SMT | |
| CN114003998A (en) | Steel structure digital factory cooperation system and method based on digital twin technology | |
| CN111459116B (en) | Efficient tube intelligent production line digital management system | |
| CN101739010A (en) | Embedded data acquisition device | |
| CN214067660U (en) | Monitoring system based on Internet of things | |
| WO2021147347A1 (en) | Acquisition network system for industrial big data and application method therefor | |
| CN107392434A (en) | Industrial big data plateform system framework and control flow | |
| CN111898848A (en) | SAP system and MES system production information transmission method | |
| CN109870966A (en) | A kind of industry internet control system | |
| CN115392832A (en) | Intelligent control system for plate processing | |
| CN109213744A (en) | A kind of intelligent O&M technology based on big data | |
| CN205486248U (en) | Automatic quotation system | |
| CN114820868A (en) | Method, device and system for intelligently mapping distribution network line | |
| CN114037397A (en) | Power plant production report generating and sending system | |
| CN113589770A (en) | Production system based on MES | |
| CN108632290B (en) | Real-time data forwarding system and method for power dispatching automation system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: The 215200 West Jiangsu city of Suzhou province Wujiang economic and Technological Development Zone No. 666 Applicant after: Bo Seiko Polytron Technologies Inc Address before: The 215200 West Jiangsu city of Suzhou province Wujiang economic and Technological Development Zone No. 666 Applicant before: Suzhou Bozhong Precision Industry Technology Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170201 |
|
| RJ01 | Rejection of invention patent application after publication |