CN106250459B - 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
- CN106250459B CN106250459B CN201610607125.XA CN201610607125A CN106250459B CN 106250459 B CN106250459 B CN 106250459B CN 201610607125 A CN201610607125 A CN 201610607125A CN 106250459 B CN106250459 B CN 106250459B
- Authority
- CN
- China
- Prior art keywords
- customer information
- information
- telnet
- module
- integration test
- 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.)
- Active
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Discharge Of Articles From Conveyors (AREA)
- Warehouses Or Storage Devices (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Automatic Analysis And Handling Materials Therefor (AREA)
Abstract
The invention discloses a kind of customer information auto-associating system and correlating methods, it includes database table module, integration test module and barcode scanning print label module；Database table module establishes database table structure, and by customer information typing client information table；Integration test module carries out the integration test of more products；Barcode scanning print label module, the customer information that will have been bound after integration test call corresponding printing template to print corresponding label by sweeping SN information.This method writes Flash information using automation batch, and one-dimension code is associated with the automatic barcode scanning print label of database, facilitates subsequent retrospect and control.
Description
Technical field
The present invention relates to a kind of customer information auto-associating system and correlating methods.
Background technique
It is all that separate unit manual operation writes code and batch labels again corresponding labelling before packaging, it is low to write code efficiency in this way,
And in labelling, it is easy because of manual operation problem, corresponding error.
Summary of the invention
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of customer information auto-associating system and associations
Method, this method write Flash information using automation batch, one-dimension code are associated with the automatic barcode scanning print label of database, side
Just subsequent retrospect and control.
The purpose of the present invention is achieved through the following technical solutions: a kind of customer information auto-associating system, it is wrapped
Include database table module, integration test module and barcode scanning print label module；
Database table module establishes database table structure, and by customer information typing client information table；
Integration test module carries out the integration test of more products；
Barcode scanning print label module, the customer information that will have been bound after integration test are called corresponding by sweeping SN information
Printing template prints corresponding label.
The customer information includes client location and product type.
A kind of correlating method of customer information auto-associating system, it includes the following steps:
S1: establishing database table structure, by customer information typing client information table；
S2: carrying out more product integration tests, binds customer information for product；
S3: scanning product SN is associated with SN with customer information；
S4: print label is attached on product.
The product integration test includes following sub-step:
S201: whether detection light cat is online；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge register check whether by or database T4 information whether have record, meet any one
Condition, which represents, completes T4, the jump procedure S214 if not completing；The jump procedure S205 if completing T4；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information,
Obtain profile name；
S207: compare province's code, judge whether identical；Then jump procedure S208 if they are the same, resets province if not identical
Code；
S208: comparison software version judges whether identical, and then jump procedure S209, upgrades soft if not identical if they are the same
Part version；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information,
Profile name is obtained, province's code, comparison software version are compared；
S212: judging save whether code is identical, and whether software version number is identical, if one of them is not identical, jump procedure
S214；
S213: write-in Flash judges whether write-in succeeds, the jump procedure S214 if failure is written, if being written successfully
Database is written, test is completed；
S214: it waits Ping to disconnect, restarts next test.
The beneficial effects of the present invention are: the present invention provides a kind of customer information auto-associating system and correlating method, it should
Method writes Flash information using automation batch, and one-dimension code is associated with the automatic barcode scanning print label of database, is facilitated subsequent
Retrospect and control.
Detailed description of the invention
Fig. 1 is system structure diagram；
Fig. 2 is product integration test flow chart.
Specific embodiment
Technical solution of the present invention is described in further detail with reference to the accompanying drawing, but protection scope of the present invention is not limited to
It is as described below.
As shown in Figure 1, a kind of customer information auto-associating system, it include database table module, integration test module and
Barcode scanning print label module；
Database table module establishes database table structure, and by customer information typing client information table；
Integration test module carries out the integration test of more products；
Barcode scanning print label module, the customer information that will have been bound after integration test are called corresponding by sweeping SN information
Printing template prints corresponding label.
The customer information includes client location and product type.
A kind of correlating method of customer information auto-associating system, it includes the following steps:
S1: establishing database table structure, by customer information typing client information table；
S2: carrying out more product integration tests, binds customer information for product；
S3: scanning product SN is associated with SN with customer information；
S4: print label is attached on product.
Database table structure is established in design, and the customer information of the different regions used every time and model is entered into client's letter
Table is ceased, after integration test more are write code, binding client's letter then is written into associated relationship by reading interiors of products SN
The table of breath.Table is designed by establishing unique index, so just ensure that all device models will not on the database
It repeats.Unique corresponding relationship label will be typed it out when scanning bar code print label below.
As shown in Fig. 2, the product integration test includes following sub-step:
S201: whether detection light cat is online；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge register check whether by or database T4 information whether have record, meet any one
Condition, which represents, completes T4, the jump procedure S214 if not completing；The jump procedure S205 if completing T4；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information,
Obtain profile name；
S207: compare province's code, judge whether identical；Then jump procedure S208 if they are the same, resets province if not identical
Code；
S208: comparison software version judges whether identical, and then jump procedure S209, upgrades soft if not identical if they are the same
Part version；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information,
Profile name is obtained, province's code, comparison software version are compared；
S212: judging save whether code is identical, and whether software version number is identical, if one of them is not identical, jump procedure
S214；
S213: write-in Flash judges whether write-in succeeds, the jump procedure S214 if failure is written, if being written successfully
Database is written, test is completed；
S214: it waits Ping to disconnect, restarts next test.
Claims (3)
1. a kind of customer information automatic correlation method, which is characterized in that it includes the following steps:
S1: establishing database table structure, by customer information typing client information table；
S2: carrying out more product integration tests, binds customer information for product；
S3: scanning product SN is associated with SN with customer information；
S4: print label is attached on product；
The product integration test includes following sub-step:
S201: whether detection light cat is online；
S202:Telnet enters light cat, enables Telnet, logs in Telnet, obtains SN order；
S203: the information of reading database T4；
S204: judge register check whether by or database T4 information whether have record, meet any one condition
It represents and completes T4, the jump procedure S214 if not completing；The jump procedure S205 if completing T4；
S205:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information, obtains
Profile name；
S207: compare province's code, judge whether identical；Then jump procedure S208 if they are the same resets province's code if not identical；
S208: comparison software version judges whether identical, and then jump procedure S209, upgrades software version if not identical if they are the same
This；
S209: restart plank；
S21O:Telnet enters light cat, enables Telnet, logs in Telnet, and setting ipv6 is opened, and obtains version information, obtains
Profile name compares province's code, comparison software version；
S212: judging save whether code is identical, and whether software version number is identical, if one of them is not identical, jump procedure S214；
S213: write-in Flash judges whether write-in succeeds, and the jump procedure S214 if failure is written successfully is written if being written
Database, test are completed；
S214: it waits Ping to disconnect, restarts next test.
2. a kind of interconnected system of customer information automatic correlation method according to claim 1, it is characterised in that: it includes
Database table module, integration test module and barcode scanning print label module；
Database table module establishes database table structure, and by customer information typing client information table；
Integration test module carries out the integration test of more products；
Barcode scanning print label module, the customer information that will have been bound after integration test call corresponding printing by sweeping SN information
Stencil marking goes out corresponding label.
3. a kind of interconnected system of customer information automatic correlation method according to claim 2, it is characterised in that: described
Customer information includes client location and product type.
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 CN106250459A (en) | 2016-12-21 |
| CN106250459B true 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) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN112477443B (en) * | 2020-11-06 | 2021-07-09 | 苏州索芙特威尔软件科技有限公司 | 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106250459A (en) | 2016-12-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106250459B (en) | A kind of customer information auto-associating system and correlating method | |
| CN101840233B (en) | Equipment failure detection device and method | |
| CN102849088B (en) | Locomotive servicing work flow, Apparatus and system | |
| CN106649089B (en) | A kind of program crashing analysis method and system | |
| CN106776339B (en) | Automated testing method and device | |
| CN102799519A (en) | Automatic test method for cluster file system | |
| CN102479138A (en) | System and method for detecting error by utilizing image | |
| US20120254662A1 (en) | Automated test system and automated test method | |
| CN205193846U (en) | Automatic recorder that circulates of laboratory sample based on only identification code | |
| CN104802527A (en) | Online product label printing system and method | |
| CN108804305A (en) | A kind of method and device of automatic test | |
| CN108122014B (en) | Bar code printing real-time detection and error prevention method, storage medium and printing terminal | |
| CN105320553A (en) | Method and system for updating network card firmware based on domestic processor platform | |
| CN113159212A (en) | OCR recognition model training method, device and computer readable storage medium | |
| CN106776340A (en) | A kind of general server S ensor automatic test approach | |
| EP3428848A1 (en) | Car damage image angle correction method, electronic device and readable storage medium | |
| CN117421217B (en) | Automatic software function test method, system, terminal and medium | |
| CN108415886A (en) | A kind of data label error correction method and device based on production process | |
| CN108712496A (en) | A kind of Port Mirroring method and device of OLT device | |
| CN110852247A (en) | Abnormality detection method, abnormality detection device, electronic apparatus, and computer-readable storage medium | |
| CN105338147B (en) | Method and system for error tracking of mobile phone test site | |
| CN106294132A (en) | A kind of method and device managing daily record | |
| CN108920297A (en) | A kind of method and system diagnosing PCIE error information in black box log | |
| CN111966394B (en) | ETL-based data analysis method, device, equipment and storage medium | |
| CN105046609A (en) | RFID based college student status file system having automatic log records and method of 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 | ||
| 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. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |