CN106250459A - A kind of customer information auto-associating system and correlating method - Google Patents
A kind of customer information auto-associating system and correlating method Download PDFInfo
- Publication number
- CN106250459A CN106250459A CN201610607125.XA CN201610607125A CN106250459A CN 106250459 A CN106250459 A CN 106250459A CN 201610607125 A CN201610607125 A CN 201610607125A CN 106250459 A CN106250459 A CN 106250459A
- Authority
- CN
- China
- Prior art keywords
- customer information
- telnet
- integration test
- information
- product
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/22—Detection or location of defective computer hardware by testing during standby operation or during idle time, e.g. start-up testing
- G06F11/2273—Test methods
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention discloses a kind of customer information auto-associating system and correlating method, it includes that database table module, integration test module and barcode scanning print label model；Database table module sets up database table structure, and by customer information typing customer information table；Integration test module, carries out the integration test of multiple stage product；Barcode scanning prints label model, the customer information will bound after integration test, by sweeping SN information, calls corresponding printing template and prints corresponding label.The method uses automatization's batch to write Flash information, one-dimension code is associated with the automatic barcode scanning of data base and prints label, facilitate follow-up reviewing and control.
Description
Technical field
The present invention relates to a kind of customer information auto-associating system and correlating method.
Background technology
It is all that code is write in separate unit manual operation and the correspondence again that labels in batches is labelled before packaging, so writes code efficiency low,
And when labelling, easily because manual operation problem, correspondence is made mistakes.
Summary of the invention
It is an object of the invention to overcome the deficiencies in the prior art, it is provided that a kind of customer information auto-associating system and association
Method, the method uses automatization's batch to write Flash information, one-dimension code is associated with the automatic barcode scanning of data base and prints label, side
Continue after an action of the bowels reviews and controls.
It is an object of the invention to be achieved through the following technical solutions: a kind of customer information auto-associating system, its bag
Include database table module, integration test module and barcode scanning and print label model；
Database table module sets up database table structure, and by customer information typing customer information table；
Integration test module, carries out the integration test of multiple stage product；
Barcode scanning prints label model, the customer information will bound after integration test, by sweeping SN information, calls corresponding printing
Stencil marking goes out corresponding label.
Described customer information includes client location and product type.
The correlating method of a kind of customer information auto-associating system, it comprises the steps:
S1: set up database table structure, by customer information typing customer information table；
S2: carry out multiple stage product integration test, binds customer information for product；
S3: scanning product SN, SN is associated with customer information；
S4: print label, be attached on product.
Described product integration test includes following sub-step:
S201: whether detection light cat reaches the standard grade；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge depositor check whether by or data base's T4 information whether have record, meet any of which condition
Representative completes T4, if not completing, and jump procedure S214；If completing T4, jump procedure S205；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name；
S207: compare province's code, it may be judged whether identical；If identical, jump procedure S208, if differing, reset province's code；
S208: comparison software version, it may be judged whether identical, if identical, jump procedure S209, if differing, software version of upgrading
This；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name, compares province's code, comparison software version；
S212: judging to save code the most identical, software version number is the most identical, if one of them differs, then jump procedure S214；
S213: write Flash, it is judged that write is the most successful, if writing unsuccessfully, jump procedure S214, if writing successfully, write
Data base, test completes；
S214: wait that Ping disconnects, restarts test next time.
The invention has the beneficial effects as follows: the invention provides a kind of customer information auto-associating system and correlating method, should
Method uses automatization's batch to write Flash information, one-dimension code is associated with the automatic barcode scanning of data base and prints label, facilitate follow-up
Review and control.
Accompanying drawing explanation
Fig. 1 is system architecture diagram；
Fig. 2 is product integration test flow chart.
Detailed description of the invention
Technical scheme is described in further detail below in conjunction with the accompanying drawings, but protection scope of the present invention is not limited to
The following stated.
As it is shown in figure 1, a kind of customer information auto-associating system, it include database table module, integration test module and
Barcode scanning prints label model；
Database table module sets up database table structure, and by customer information typing customer information table；
Integration test module, carries out the integration test of multiple stage product；
Barcode scanning prints label model, the customer information will bound after integration test, by sweeping SN information, calls corresponding printing
Stencil marking goes out corresponding label.
Described customer information includes client location and product type.
The correlating method of a kind of customer information auto-associating system, it comprises the steps:
S1: set up database table structure, by customer information typing customer information table；
S2: carry out multiple stage product integration test, binds customer information for product；
S3: scanning product SN, SN is associated with customer information；
S4: print label, be attached on product.
Database table structure is set up in design, and the customer information of the different regions every time used and model is entered into client's letter
Breath table, after integration test multiple stage writes code, then believes the relation write binding client of association by reading interiors of products SN
The table of breath.Table is all by setting up unique index design, so ensure that all of unit type will not the most on the database
Repeat.Unique corresponding relation label will be up to below scanning barcode prints label when.
As in figure 2 it is shown, described product integration test includes following sub-step:
S201: whether detection light cat reaches the standard grade；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge depositor check whether by or data base's T4 information whether have record, meet any of which condition
Representative completes T4, if not completing, and jump procedure S214；If completing T4, jump procedure S205；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name；
S207: compare province's code, it may be judged whether identical；If identical, jump procedure S208, if differing, reset province's code；
S208: comparison software version, it may be judged whether identical, if identical, jump procedure S209, if differing, software version of upgrading
This；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name, compares province's code, comparison software version；
S212: judging to save code the most identical, software version number is the most identical, if one of them differs, then jump procedure S214；
S213: write Flash, it is judged that write is the most successful, if writing unsuccessfully, jump procedure S214, if writing successfully, write
Data base, test completes；
S214: wait that Ping disconnects, restarts test next time.
Claims (4)
1. a customer information auto-associating system, it is characterised in that: it includes database table module, integration test module and sweeps
Code prints label model；
Database table module sets up database table structure, and by customer information typing customer information table；
Integration test module, carries out the integration test of multiple stage product；
Barcode scanning prints label model, the customer information will bound after integration test, by sweeping SN information, calls corresponding printing
Stencil marking goes out corresponding label.
A kind of customer information auto-associating system the most according to claim 1, it is characterised in that: described customer information bag
Include client location and product type.
3. the correlating method of a kind of customer information auto-associating system as described in claim 1-2, it is characterised in that it includes
Following steps:
S1: set up database table structure, by customer information typing customer information table；
S2: carry out multiple stage product integration test, binds customer information for product；
S3: scanning product SN, SN is associated with customer information；
S4: print label, be attached on product.
The correlating method of a kind of customer information auto-associating system the most according to claim 3, it is characterised in that: described
Product integration test includes following sub-step:
S201: whether detection light cat reaches the standard grade；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge depositor check whether by or data base's T4 information whether have record, meet any of which condition
Representative completes T4, if not completing, and jump procedure S214；If completing T4, jump procedure S205；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name；
S207: compare province's code, it may be judged whether identical；If identical, jump procedure S208, if differing, reset province's code；
S208: comparison software version, it may be judged whether identical, if identical, jump procedure S209, if differing, software version of upgrading
This；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, arranges ipv6 and open, and obtains version information, obtains
Profile name, compares province's code, comparison software version；
S212: judging to save code the most identical, software version number is the most identical, if one of them differs, then jump procedure S214；
S213: write Flash, it is judged that write is the most successful, if writing unsuccessfully, jump procedure S214, if writing successfully, write
Data base, test completes；
S214: wait that Ping disconnects, restarts test next time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610607125.XA CN106250459B (en) | 2016-07-29 | 2016-07-29 | A kind of customer information auto-associating system and correlating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610607125.XA CN106250459B (en) | 2016-07-29 | 2016-07-29 | A kind of customer information auto-associating system and correlating method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106250459A true CN106250459A (en) | 2016-12-21 |
| CN106250459B CN106250459B (en) | 2019-04-26 |
Family
ID=57603994
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610607125.XA Active CN106250459B (en) | 2016-07-29 | 2016-07-29 | A kind of customer information auto-associating system and correlating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106250459B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109754093A (en) * | 2018-12-13 | 2019-05-14 | 四川天邑康和通信股份有限公司 | A kind of smooth cat maintenance system and management method |
| CN111775572A (en) * | 2020-07-17 | 2020-10-16 | 浪潮商用机器有限公司 | Method and related device for replacing label printer content |
| CN112477443A (en) * | 2020-11-06 | 2021-03-12 | 苏州索芙特威尔软件科技有限公司 | Bar code label printing method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101804896A (en) * | 2010-02-05 | 2010-08-18 | 东华大学 | Thin-type material intensive warehouse management system and method thereof |
| CN102750983A (en) * | 2011-04-19 | 2012-10-24 | 上海博泰悦臻电子设备制造有限公司 | Method and system for production test burning |
| CN204116915U (en) * | 2014-08-28 | 2015-01-21 | 梯梯电子集成制造服务(苏州)有限公司 | Row control in industrial production line and manufacturing execution system |
| CN104802527A (en) * | 2015-03-27 | 2015-07-29 | 深圳极智联合科技股份有限公司 | Online product label printing system and method |
| CN105338147A (en) * | 2014-06-30 | 2016-02-17 | 展讯通信（上海）有限公司 | Mobile phone test station site error tracking method and system |
-
2016
- 2016-07-29 CN CN201610607125.XA patent/CN106250459B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101804896A (en) * | 2010-02-05 | 2010-08-18 | 东华大学 | Thin-type material intensive warehouse management system and method thereof |
| CN102750983A (en) * | 2011-04-19 | 2012-10-24 | 上海博泰悦臻电子设备制造有限公司 | Method and system for production test burning |
| CN105338147A (en) * | 2014-06-30 | 2016-02-17 | 展讯通信（上海）有限公司 | Mobile phone test station site error tracking method and system |
| CN204116915U (en) * | 2014-08-28 | 2015-01-21 | 梯梯电子集成制造服务(苏州)有限公司 | Row control in industrial production line and manufacturing execution system |
| CN104802527A (en) * | 2015-03-27 | 2015-07-29 | 深圳极智联合科技股份有限公司 | Online product label printing system and method |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109754093A (en) * | 2018-12-13 | 2019-05-14 | 四川天邑康和通信股份有限公司 | A kind of smooth cat maintenance system and management method |
| CN109754093B (en) * | 2018-12-13 | 2021-04-09 | 四川天邑康和通信股份有限公司 | Optical modem maintenance system and management method |
| CN111775572A (en) * | 2020-07-17 | 2020-10-16 | 浪潮商用机器有限公司 | Method and related device for replacing label printer content |
| CN112477443A (en) * | 2020-11-06 | 2021-03-12 | 苏州索芙特威尔软件科技有限公司 | Bar code label printing method and system |
| CN112477443B (en) * | 2020-11-06 | 2021-07-09 | 苏州索芙特威尔软件科技有限公司 | Bar code label printing method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106250459B (en) | 2019-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102849088B (en) | Locomotive servicing work flow, Apparatus and system | |
| CN109697160B (en) | Automatic testing system and method for Ethernet interface software | |
| CN1245675C (en) | Apparatus and method for identificating data input table through touch pen moving | |
| CN106250459A (en) | A kind of customer information auto-associating system and correlating method | |
| CN203929791U (en) | A kind of sample rack induction system and biochemical immunity all-in-one thereof of sample rack RFID identification | |
| CN104802527A (en) | Online product label printing system and method | |
| CN103390163A (en) | Letter address automatic-collection method | |
| CN207731313U (en) | A kind of online printing and detecting system based on RFID tag | |
| CN105139149B (en) | A kind of method of quick counting server assets configuration information | |
| CN103963483A (en) | Unique code printing screening industrial fool-proofing device and printing method thereof | |
| CN1521597A (en) | Data input system | |
| CN111144079A (en) | Method and device for intelligently acquiring learning resources, printer and storage medium | |
| CN111814779A (en) | Bill text recognition method, device, equipment and storage medium | |
| CN100416587C (en) | Bar code identification based product inspection method, system, and its apparatus | |
| CN114049540A (en) | Method, device, equipment and medium for detecting marked image based on artificial intelligence | |
| CN104182416A (en) | File downloading system and method | |
| CN111382710A (en) | Drawing comparison method based on image recognition | |
| CN111767973A (en) | Design method of logistics management software function based on associated label | |
| CN207051938U (en) | Case stocker cigarette electronic tag automatic code-printing and check system | |
| US20050149225A1 (en) | Feeder control system and method | |
| CN113247402B (en) | Transponder labeling device and label checking method | |
| CN112287828A (en) | Financial statement generation method and device based on machine learning | |
| DK1702293T3 (en) | Method of printing and / or cutting an image | |
| CN112529855A (en) | Detection method and detection device for remote controller and computer readable storage medium | |
| CN209199143U (en) | RFID automatic jig system suitable for logistic storage system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 610000 No. 198, Xueshan Avenue Section, Jinyuan Town, Dayi County, Chengdu City, Sichuan Province Applicant after: Sichuan Tianyi Kanghe Communication Co., Ltd. Address before: 610000 No. 198 Industrial Avenue, Jinyuan Town, Dayi County, Chengdu City, Sichuan Province Applicant before: Sichuan Tianyi Kanghe Communication Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |