CN107247975A - A kind of online Product labelling automatic printing method and system based on database - Google Patents
A kind of online Product labelling automatic printing method and system based on database Download PDFInfo
- Publication number
- CN107247975A CN107247975A CN201710532049.5A CN201710532049A CN107247975A CN 107247975 A CN107247975 A CN 107247975A CN 201710532049 A CN201710532049 A CN 201710532049A CN 107247975 A CN107247975 A CN 107247975A
- Authority
- CN
- China
- Prior art keywords
- product
- label
- stage
- machine
- database
- 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
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K15/00—Arrangements for producing a permanent visual presentation of the output data, e.g. computer output printers
- G06K15/02—Arrangements for producing a permanent visual presentation of the output data, e.g. computer output printers using printers
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
Abstract
The present invention relates to a kind of online Product labelling automatic printing method and system based on database.The present invention needs the various label machines for printing label to be networked by database and product line each stage, various label machines are printed according to pre-set programs, include the label of a whole set of flowline such as product serial number label, test label, quality management and control label, packaging label, shipping labels；And the relevant information to product in each stage carries out data-bound, the tracking that database carries out product each stage is uniformly aggregated into, accomplishes traceability and visualized operation, reduces artificial error rate, production efficiency and accuracy rate is improved, product total quality is improved.
Description
Technical field
The invention belongs to label printing field, it is related to a kind of online Product labelling automatic printing method based on database.
Background technology
In current existing industrial production, product, which is labelled, is used in record product sequence number, each stage test mode of semi-finished product,
OQC is inspected by random samples, finished product shipment state and finished product sampling observation etc., and routine work mode gives birth to pipe and is connected to specification production letter after production information
The sequence number of production label is ceased and printed, product stage condition or QC sampling observation marks are pasted after line inspector has tested greenware condition
Label, stick shipping labels after finished product is complete, quality indication is sticked in finished product sampling observation test, and the above is after carrying out networking Data Synthesis and being
Continuous to do product quality and review, the integrated higher system of industry Online integration and can also do factory's visualized operation, but make at present
It is not high for this label automaticity, and the operation factors of people cause many leakage patches, mistake patch is integrated to reprocess larger draw of ging wrong
Play client's complaint discontented.
The content of the invention
The present invention is intended to provide a kind of online Product labelling automatic printing method and system based on database, existing to solve
The problem of with the presence of Product labelling leakage patch, wrong patch.Therefore, the concrete technical scheme that the present invention is used is as follows：
A kind of online Product labelling automatic printing method based on database, comprises the following steps：
S1, in the production stage, product information input database automatically generates product ID, and pass through product mark
Label printer printed product sequence number；
S2, in the product test stage, pass through the first scanning machine and scan product ID and and database on Product labelling
In product ID be compared, if product ID is consistent, is tested, printed after test passes by test label
Machine printing test message code is simultaneously bundled test uploading information data to database with corresponding product sequence number；
S3, product inspect by random samples the stage, by the second scanning machine scanning by the product serial on the Product labelling of selective examination product
Number, then made a random inspection, if qualified, by spot-check label machine printing selective examination message code and Information Number will be spot-check
Bundled according to database is uploaded to corresponding product sequence number；
S4, in the product packaging stage, pass through the 3rd scanning machine and scan product serial on the Product labelling of product to be packaged
Number, after packaging by packaging label printer printing packaging bar code and by packaged information data be uploaded to database with it is corresponding
Product ID is bundled；
S5, in the product turnout stage, the product information that packaging bar code obtains treating shipment is scanned by the 4th scanning machine, then
Shipment information bar code is printed by shipping labels printer and shipment information data are uploaded to database and corresponding product sequence
Row number is bundled.
Further, the product sampling observation stage includes semi-finished product selective examination stage and finished product selective examination stage, the selective examination mark
Label printer includes being respectively used to the semi-finished product selective examination stage and finished product spot-check the selective examination label machine in stage, second scanning
Machine includes being respectively used to the semi-finished product selective examination stage and finished product spot-check second scanning machine in stage.
Further, the Product labelling printer, test label printer, selective examination label machine, packaging label are beaten
Print machine, shipping labels printer, the first scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine by wired and/or
Wirelessly enter row data communication with database.
A kind of online Product labelling automatic print system based on database, including：Server and with the server
The Product labelling printer of communication connection, test label printer, selective examination label machine, packaging label, shipping labels printing
Machine, the first scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine, the server are provided with database and accordingly beaten
The driver of print machine and scanning machine, the Product labelling printer is used in production stage printing product ID, institute
Stating the first scanning machine is used to scan the product ID on Product labelling in the product test stage and is uploaded to the server, institute
Stating test label printer is used for printing test message code；Second scanning machine is used in product selective examination stage scanning product
Product ID on label is simultaneously uploaded to the server, and the selective examination label machine is used to print selective examination message code；
3rd scanning machine is used to scan the product ID on Product labelling in the product packaging stage and is uploaded to the server,
The packaging label printer is used to print packaging bar code, and the 4th scanning machine is used in product turnout stage scanning packaging mark
The packaging bar code signed simultaneously is uploaded to the server, and the shipping labels printer is used to print shipment information bar code.
Further, the product sampling observation stage includes semi-finished product selective examination stage and finished product selective examination stage, the selective examination mark
Label printer includes being respectively used to the semi-finished product selective examination stage and finished product spot-check the selective examination label machine in stage, second scanning
Machine includes being respectively used to the semi-finished product selective examination stage and finished product spot-check second scanning machine in stage.
Further, the server and the Product labelling printer, test label printer, selective examination label printing
Machine, packaging label, shipping labels printer, the first scanning machine, the second scanning machine, the 3rd scanning machine, the communication of the 4th scanning machine
Connected mode is wiredly and/or wirelessly to communicate to connect mode.
The present invention uses above-mentioned technical proposal, has an advantageous effect in that：The present invention can be realized in production process
Each stage carries out automatic printing label, it is to avoid the wrong note of human factor, leakage patch, substantially increases production efficiency.In addition, logical
Cross the relevant information to product in each stage and carry out data-bound, be uniformly aggregated into the tracking that database carries out product each stage,
Traceability and visualized operation can be accomplished.
Brief description of the drawings
Fig. 1 shows the flow of the online Product labelling automatic printing method according to embodiments of the present invention based on database
Figure；
Fig. 2 shows the principle of the online Product labelling automatic print system according to embodiments of the present invention based on database
Figure.
Embodiment
To further illustrate each embodiment, the present invention is provided with accompanying drawing.These accompanying drawings are the invention discloses the one of content
Point, it is mainly to illustrate embodiment, and can coordinate the associated description of specification to explain the operation principles of embodiment.Coordinate ginseng
These contents are examined, those of ordinary skill in the art will be understood that other possible embodiments and advantages of the present invention.In figure
Component be not necessarily to scale, and similar element numbers are conventionally used to indicate similar component.
In conjunction with the drawings and specific embodiments, the present invention is further described.As shown in figure 1, a kind of based on database
Online Product labelling automatic printing method, comprises the following steps：
S1, in the production stage, product information input database automatically generates product ID, and pass through product mark
Label printer printed product sequence number；
S2, in the product test stage, pass through the first scanning machine and scan product ID and and database on Product labelling
In product ID be compared, if product ID is consistent, is tested, printed after test passes by test label
Machine printing test message code is simultaneously bundled test uploading information data to database with corresponding product sequence number；
S3, product inspect by random samples the stage, by the second scanning machine scanning by the product serial on the Product labelling of selective examination product
Number, then made a random inspection, if qualified, by spot-check label machine printing selective examination message code and Information Number will be spot-check
Bundled according to database is uploaded to corresponding product sequence number；
S4, in the product packaging stage, pass through the 3rd scanning machine and scan product serial on the Product labelling of product to be packaged
Number, after packaging by packaging label printer printing packaging bar code and by packaged information data be uploaded to database with it is corresponding
Product ID is bundled；
S5, in the product turnout stage, the product information that packaging bar code obtains treating shipment is scanned by the 4th scanning machine, then
Shipment information bar code is printed by shipping labels printer and shipment information data are uploaded to database and corresponding product sequence
Row number is bundled.
It should be understood that the product sampling observation stage may include semi-finished product selective examination stage and finished product selective examination stage.Therefore, it is described
Selective examination label machine may include that being respectively used to semi-finished product selective examination stage and finished product spot-check the selective examination label machine in stage, described
Second scanning machine may include that being respectively used to semi-finished product selective examination stage and finished product spot-check second scanning machine in stage.
In addition, the Product labelling printer, test label printer, selective examination label machine, packaging label printer,
Shipping labels printer, the first scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine are by wiredly and/or wirelessly
Mode enters row data communication with database.
As shown in Fig. 2 a kind of online Product labelling automatic print system based on database may include：Server and with
The Product labelling printer of server communication connection, test label printer, selective examination label machine, packaging label, go out
Label label printer, the first scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine.The server is provided with data
Storehouse and the driver of corresponding printer and scanning machine, the Product labelling printer are used in production stage printing product
Sequence number, first scanning machine is used to scan the product ID on Product labelling in the product test stage and is uploaded to described
Server, the test label printer is used for printing test message code；Second scanning machine is used to spot-check rank in product
Section scans the product ID on Product labelling and is uploaded to the server, and the selective examination label machine, which is used to print, to be spot-check
Message code；3rd scanning machine is used to scan the product ID on Product labelling in the product packaging stage and is uploaded to institute
Server is stated, the packaging label printer is used to print packaging bar code, and the 4th scanning machine was used in the product turnout stage
Scan the packaging bar code on packaging label and be uploaded to the server, the shipping labels printer is used to print shipment information
Bar code.
It should be understood that the product sampling observation stage may include semi-finished product selective examination stage and finished product selective examination stage.Therefore, it is described
Selective examination label machine may include that being respectively used to semi-finished product selective examination stage and finished product spot-check the selective examination label machine in stage, described
Second scanning machine may include that being respectively used to semi-finished product selective examination stage and finished product spot-check second scanning machine in stage.
In addition, the server and the Product labelling printer, test label printer, selective examination label machine, bag
Fill label, shipping labels printer, the first scanning machine, the second scanning machine, the 3rd scanning machine, the communication connection side of the 4th scanning machine
Formula is wiredly and/or wirelessly to communicate to connect mode.
Although specifically showing and describing the present invention with reference to preferred embodiment, those skilled in the art should be bright
In vain, do not departing from the spirit and scope of the present invention that appended claims are limited, in the form and details can be right
The present invention makes a variety of changes, and is protection scope of the present invention.
Claims (6)
1. a kind of online Product labelling automatic printing method based on database, it is characterised in that comprise the following steps：
S1, in the production stage, product information input database automatically generates product ID, and beat by Product labelling
Print machine printed product sequence number；
S2, in the product test stage, by the first scanning machine scan product ID on Product labelling and with database
Product ID is compared, if product ID is consistent, is tested, is beaten after test passes by test label printer
Print test message code is simultaneously bundled test uploading information data to database with corresponding product sequence number；
S3, in product inspect the stage by random samples, by the scanning of the second scanning machine by the product ID on the Product labelling of selective examination product, so
Made a random inspection afterwards, if qualified, by spot-check label machine printing selective examination message code and will spot-check in information data
Database is reached to be bundled with corresponding product sequence number；
S4, in the product packaging stage, pass through the 3rd scanning machine and scan product ID on the Product labelling of product to be packaged, bag
Bar code is packed by the printing of packaging label printer after installing and packaged information data are uploaded to database and corresponding product
Sequence number is bundled；
S5, in the product turnout stage, the product information that packaging bar code obtains treating shipment is scanned by the 4th scanning machine, then passed through
Shipping labels printer prints shipment information bar code and shipment information data is uploaded into database and corresponding product sequence number
Bundled.
2. the product information label automatic printing method as claimed in claim 1 based on database, it is characterised in that the production
The product sampling observation stage includes semi-finished product and spot-check stage and finished product selective examination stage, the selective examination label machine include being respectively used to half into
Product spot-check the stage and finished product spot-check the selective examination label machine in stage, and second scanning machine includes being respectively used to semi-finished product selective examination
Stage and finished product spot-check second scanning machine in stage.
3. the product information label automatic printing method as claimed in claim 1 based on database, it is characterised in that the production
Product label machine, test label printer, selective examination label machine, packaging label printer, shipping labels printer, first
Scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine enter line number by way of wiredly and/or wirelessly with database
According to communication.
4. a kind of online Product labelling automatic print system based on database, it is characterised in that including：Server and with institute
State server communication connection Product labelling printer, test label printer, selective examination label machine, packaging label, shipment
Label machine, the first scanning machine, the second scanning machine, the 3rd scanning machine, the 4th scanning machine, the server are provided with database
And the driver of corresponding printer and scanning machine, the Product labelling printer is in production stage printing product sequence
Row number, first scanning machine is used to scan the product ID on Product labelling in the product test stage and is uploaded to the clothes
Business device, the test label printer is used for printing test message code；Second scanning machine is used to spot-check the stage in product
Scan the product ID on Product labelling and be uploaded to the server, the selective examination label machine is used to print selective examination letter
Cease code；3rd scanning machine is used to scan the product ID on Product labelling in the product packaging stage and is uploaded to described
Server, the packaging label printer is used to print packaging bar code, and the 4th scanning machine is used to sweep in the product turnout stage
Retouch the packaging bar code on packaging label and be uploaded to the server, the shipping labels printer is used to print shipment information bar
Code.
5. the product information label automatic print system as claimed in claim 4 based on database, it is characterised in that the production
The product sampling observation stage includes semi-finished product and spot-check stage and finished product selective examination stage, the selective examination label machine include being respectively used to half into
Product spot-check the stage and finished product spot-check the selective examination label machine in stage, and second scanning machine includes being respectively used to semi-finished product selective examination
Stage and finished product spot-check second scanning machine in stage.
6. the product information label automatic print system as claimed in claim 4 based on database, it is characterised in that the clothes
Business device is printed with the Product labelling printer, test label printer, selective examination label machine, packaging label, shipping labels
Machine, the first scanning machine, the second scanning machine, the 3rd scanning machine, the communication connection mode of the 4th scanning machine are wiredly and/or wirelessly to lead to
Believe connected mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710532049.5A CN107247975B (en) | 2017-07-03 | 2017-07-03 | Database-based automatic printing method and system for online product label |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710532049.5A CN107247975B (en) | 2017-07-03 | 2017-07-03 | Database-based automatic printing method and system for online product label |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107247975A true CN107247975A (en) | 2017-10-13 |
| CN107247975B CN107247975B (en) | 2020-12-08 |
Family
ID=60014820
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710532049.5A Active CN107247975B (en) | 2017-07-03 | 2017-07-03 | Database-based automatic printing method and system for online product label |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107247975B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107748995A (en) * | 2017-11-06 | 2018-03-02 | 深圳开发微电子有限公司 | The method that internal memory can be traced |
| CN111591046A (en) * | 2020-05-19 | 2020-08-28 | 欧拓飞科技(珠海)有限公司 | Bar code binding system and method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140195455A1 (en) * | 2013-01-09 | 2014-07-10 | Position Logic Llc | Asset delivery visualization system and method |
| CN104008475A (en) * | 2014-06-20 | 2014-08-27 | 北京京东尚科信息技术有限公司 | Commodity ex-warehouse method |
| US20140244536A1 (en) * | 2013-02-22 | 2014-08-28 | Farshad Jason Far-Hadian | Postage-free mail delivery using a mobile device |
| CN104802527A (en) * | 2015-03-27 | 2015-07-29 | 深圳极智联合科技股份有限公司 | Online product label printing system and method |
| TW201606661A (en) * | 2014-08-08 | 2016-02-16 | Hai-Tang Lin | Product traceability management and authentication mechanism |
| CN105654246A (en) * | 2016-01-08 | 2016-06-08 | 滁州嘉泰科技有限公司 | Detection system used for scanning barcodes of produced goods |
-
2017
- 2017-07-03 CN CN201710532049.5A patent/CN107247975B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140195455A1 (en) * | 2013-01-09 | 2014-07-10 | Position Logic Llc | Asset delivery visualization system and method |
| US20140244536A1 (en) * | 2013-02-22 | 2014-08-28 | Farshad Jason Far-Hadian | Postage-free mail delivery using a mobile device |
| CN104008475A (en) * | 2014-06-20 | 2014-08-27 | 北京京东尚科信息技术有限公司 | Commodity ex-warehouse method |
| TW201606661A (en) * | 2014-08-08 | 2016-02-16 | Hai-Tang Lin | Product traceability management and authentication mechanism |
| CN104802527A (en) * | 2015-03-27 | 2015-07-29 | 深圳极智联合科技股份有限公司 | Online product label printing system and method |
| CN105654246A (en) * | 2016-01-08 | 2016-06-08 | 滁州嘉泰科技有限公司 | Detection system used for scanning barcodes of produced goods |
Non-Patent Citations (1)
| Title |
|---|
| 曹志英: "基于条形码的轮胎生产信息管理系统的研究与开发", 《中国优秀硕士学位论文全文数据库（信息科技辑）》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107748995A (en) * | 2017-11-06 | 2018-03-02 | 深圳开发微电子有限公司 | The method that internal memory can be traced |
| CN111591046A (en) * | 2020-05-19 | 2020-08-28 | 欧拓飞科技(珠海)有限公司 | Bar code binding system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107247975B (en) | 2020-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102176233B (en) | Method for assigning drug electronic supervision code and code assigning device | |
| CN102514768B (en) | Wire harness quality detection method | |
| CN106096978A (en) | A kind of clothing information retroactive method based on Quick Response Code identification technology | |
| CN104859909B (en) | Packaging method and control device of mobile phone | |
| CN106841212B (en) | A kind of bottle mouth defect detection method based on local PCA and BP neural network | |
| CN107247975A (en) | A kind of online Product labelling automatic printing method and system based on database | |
| CN104226610A (en) | Automatic sorting system with weighting and checking functions and use method of automatic sorting system | |
| CN107203841A (en) | The method of inspection and device of product quality | |
| CN107219826A (en) | For setting the method and apparatus that equipment/process is intended for single use | |
| CN107672325A (en) | It is automatically positioned the Laser Jet method of product | |
| CN101667273A (en) | Interlocking and fail-safe method during detection process and system thereof | |
| CN107092792A (en) | A kind of Pathologic specimen management method | |
| CN206725006U (en) | A kind of offline automatic detection of elevator door-motor and traceability system | |
| CN104639620B (en) | A kind of automation ID management methods and system | |
| CN114884731A (en) | Information remote transmission system for industrial automation instrument | |
| CN105205676A (en) | Label composed of two-dimension code and variable information, source tracing method and source tracing system | |
| CN110135737A (en) | A kind of industrial production management system and method | |
| CN102897356B (en) | Label comparison automatic detection system and detection method thereof | |
| CN104008410B (en) | Label information detection method and device | |
| JP5156883B2 (en) | Diagnostic method for container inspection system | |
| JP2017010239A (en) | Traceability management device and program | |
| CN112951736B (en) | Intelligent sampling method for detection procedure | |
| CN109102232A (en) | It is a kind of informationization aluminium ingot go out Input System and out storage method | |
| CN105488506B (en) | For pointer gauge outfit and the automatic verification system of simple digital watch | |
| CN208902081U (en) | A kind of coordinate measuring machine |
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 |