CN107766465B - Method for automatically inquiring model of repair table - Google Patents
Method for automatically inquiring model of repair table Download PDFInfo
- Publication number
- CN107766465B CN107766465B CN201710901280.7A CN201710901280A CN107766465B CN 107766465 B CN107766465 B CN 107766465B CN 201710901280 A CN201710901280 A CN 201710901280A CN 107766465 B CN107766465 B CN 107766465B
- Authority
- CN
- China
- Prior art keywords
- information
- repair
- rework
- data
- excel
- 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
Images
Classifications
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/245—Query processing
-
- 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/01—Customer relationship services
- G06Q30/015—Providing customer assistance, e.g. assisting a customer within a business location or via helpdesk
- G06Q30/016—After-sales
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Finance (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for automatically inquiring a model of a repair table, belongs to the technical field of repair table management, and particularly relates to a method for automatically inquiring a model of a repair table; in the invention, through five steps of sending the repair data, reading the repair data, analyzing the repair data, processing the repair data and circularly operating, the method for automatically inquiring the model of the repair table, which has the advantages of high efficiency, rapidness, low cost and low error rate and can well improve the satisfaction degree of a customer on after-sale service, can be realized.
Description
Technical Field
The invention belongs to the technical field of repair table management, and particularly relates to a method for automatically inquiring a model of a repair table.
Background
With the development of economy, people have higher and higher requirements on after-sale services, the sales volume of high-grade products is better and better, and the corresponding after-sale services of the products are more and more important. In actual life, products purchased by people are easy to damage due to various reasons, and in the repair process of the existing products, a warranty card or other documents are checked manually and then compared with data stored by a merchant, and the products are maintained and processed correspondingly after being accurate, but the processing mode mainly depends on manual processing, and the efficiency is low; in addition, data is easy to lose in storage, and errors are easy to occur in the checking process, so that the error rate of the whole repair process is high; due to the above problems, customer satisfaction with the consumption and service is not high and the cost of dealing with rework issues is high.
Disclosure of Invention
In order to solve the above problems, the present invention aims to provide a method for automatically querying a model of a rework table; the method for automatically inquiring the model of the repair table is efficient and rapid, low in cost and error rate, and capable of well improving the satisfaction degree of a customer on after-sale service.
In order to achieve the above object, the technical solution of the present invention is as follows.
The invention provides a method for automatically inquiring a model of a repair table, which mainly comprises five steps of repair data sending, repair data reading, repair data analysis, repair data processing and cycle operation, and specifically comprises the following steps:
101, sending repair data: the method comprises the steps that a repairer delivers a watch and a receipt which need to be repaired to a seller, and the seller makes data of all repaired watches received within a period of time into an Excel form;
102 repair data reading: the method comprises the steps that a seller reads manufactured Excel form information through an established rework system and compares the read Excel form information with information preset by the rework system;
103, analyzing the repair data: the rework system queries the object of Excel form information in each behavior, compares the object with the information preset by the rework system, and if the Excel form information is partially or completely matched with the information preset by the rework system, the step 104 is performed; if the Excel table information cannot find the adaptive information in the information preset by the repair system, skipping the Excel table information of the current line number, and entering step 105;
104, processing repair data: marking data which are partially or completely matched with the information preset by the repair system in the read Excel table by the repair system;
105, circulating operation: and returning to the step 101, and continuously circulating after sequentially entering the steps 102, 103, 104 and 105 until all information in the Excel table is compared. In the invention, through five steps of sending the repair data, reading the repair data, analyzing the repair data, processing the repair data and circularly operating, the method for automatically inquiring the model of the repair table, which has the advantages of high efficiency, rapidness, low cost and low error rate and can well improve the satisfaction degree of a customer on after-sale service, can be realized; in step 101, the setting of sending the repair data effectively and intensively processes the repair table information, and the information of the repair table is not required to be registered and processed sporadically, so that the working efficiency is greatly improved; in the step 104, data which is partially or completely matched with the information preset by the repair system is marked in the Excel table in the repair data processing, so that the repair information of the repair table and the authenticity of the information of the repair table can be rapidly and accurately determined.
Further, in the step 101, the seller is determined according to the actual accumulated number of the rework tables in a period of time, that is, the seller sets an early warning value of the rework tables, and when the number of the rework tables reaches the early warning value, the Excel tables are uniformly manufactured. The arrangement aims to effectively and intensively process the repair list information, and the repair list information is not required to be sporadically registered and processed, so that the working efficiency is greatly improved.
Further, the information preset by the rework system in step 102 includes watch numbers, manufacturer models, watch lever numbers, and movement models of all watches sold by the seller. In the invention, the watch numbers, the manufacturer models, the watch rod numbers and the movement models of all watches sold by a seller are arranged in the system, and the information is further integrated into an Excel form information form, after the repaired watch information is input into the system, whether the repaired watch is the sold watch or not can be automatically matched, the information of manufacturers and the like can be determined, the repaired watch information can be efficiently confirmed, related manufacturers can be pertinently contacted and corresponding materials can be prepared according to the matched information, and compared with the original manual registration, comparison and distribution, the efficiency and the accuracy are greatly improved.
Further, the method includes step 106 of rework data supplement: in the step 103 of repairing data analysis, if the Excel form information cannot find the adaptive information in the information preset by the repairing system and the seller confirms that the data of the repairing table is real, the information in the Excel form is supplemented into the repairing system. The arrangement of one step can effectively improve the repair system, so that the repair system can continuously keep high efficiency, stability and reliability in the operation process.
The invention has the advantages that: compared with the prior art, the method for automatically inquiring the model of the repair table has the advantages of high efficiency, rapidness, low cost and low error rate, and can well improve the satisfaction degree of a customer on after-sales service; in step 101, the setting of sending the repair data effectively and intensively processes the repair table information, and the information of the repair table is not required to be registered and processed sporadically, so that the working efficiency is greatly improved; in the step 104, data which is partially or completely matched with the information preset by the repair system is marked in the Excel table in the repair data processing, so that the repair information of the repair table and the authenticity of the information of the repair table can be rapidly and accurately determined.
Drawings
FIG. 1 is a block flow diagram of a method for automatically querying a repair table for a model number according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
In order to achieve the above object, the technical solution of the present invention is as follows.
Referring to fig. 1, the present invention provides a method for automatically querying a model of a repair table, which mainly includes five steps of repair data transmission, repair data reading, repair data analysis, repair data processing and cycle operation, and specifically includes the following steps:
101, sending repair data: the method comprises the steps that a repairer delivers a watch and a receipt which need to be repaired to a seller, and the seller makes data of all repaired watches received within a period of time into an Excel form;
102 repair data reading: the method comprises the steps that a seller reads manufactured Excel form information through an established rework system and compares the read Excel form information with information preset by the rework system;
103, analyzing the repair data: the rework system queries the object of Excel form information in each behavior, compares the object with the information preset by the rework system, and if the Excel form information is partially or completely matched with the information preset by the rework system, the step 104 is performed; if the Excel table information cannot find the adaptive information in the information preset by the repair system, skipping the Excel table information of the current line number, and entering step 105;
104, processing repair data: marking data which are partially or completely matched with the information preset by the repair system in the read Excel table by the repair system;
105, circulating operation: and returning to the step 101, and continuously circulating after sequentially entering the steps 102, 103, 104 and 105 until all information in the Excel table is compared. In the invention, through five steps of sending the repair data, reading the repair data, analyzing the repair data, processing the repair data and circularly operating, the method for automatically inquiring the model of the repair table, which has the advantages of high efficiency, rapidness, low cost and low error rate and can well improve the satisfaction degree of a customer on after-sale service, can be realized; in step 101, the setting of sending the repair data effectively and intensively processes the repair table information, and the information of the repair table is not required to be registered and processed sporadically, so that the working efficiency is greatly improved; in the step 104, data which is partially or completely matched with the information preset by the repair system is marked in the Excel table in the repair data processing, so that the repair information of the repair table and the authenticity of the information of the repair table can be rapidly and accurately determined.
In this embodiment, in step 101, the seller is determined according to the actual accumulated number of rework tables, that is, the seller sets an early warning value for the rework tables, and when the number of the rework tables reaches the early warning value, the Excel tables are uniformly created. The arrangement aims to effectively and intensively process the repair list information, and the repair list information is not required to be sporadically registered and processed, so that the working efficiency is greatly improved.
In this embodiment, the information preset by the rework system in step 102 includes the watch number, the manufacturer model, the watch lever number, and the movement model of all watches sold by the seller. In the invention, the watch numbers, the manufacturer models, the watch rod numbers and the movement models of all watches sold by a seller are arranged in the system, and the information is further integrated into an Excel form information form, after the repaired watch information is input into the system, whether the repaired watch is the sold watch or not can be automatically matched, the information of manufacturers and the like can be determined, the repaired watch information can be efficiently confirmed, related manufacturers can be pertinently contacted and corresponding materials can be prepared according to the matched information, and compared with the original manual registration, comparison and distribution, the efficiency and the accuracy are greatly improved.
In this embodiment, the method further includes step 106 of rework data supplement: in the step 103 of repairing data analysis, if the Excel form information cannot find the adaptive information in the information preset by the repairing system and the seller confirms that the data of the repairing table is real, the information in the Excel form is supplemented into the repairing system. The arrangement of one step can effectively improve the repair system, so that the repair system can continuously keep high efficiency, stability and reliability in the operation process.
The invention has the advantages that: compared with the prior art, the method for automatically inquiring the model of the repair table has the advantages of high efficiency, rapidness, low cost and low error rate, and can well improve the satisfaction degree of a customer on after-sales service; in step 101, the setting of sending the repair data effectively and intensively processes the repair table information, and the information of the repair table is not required to be registered and processed sporadically, so that the working efficiency is greatly improved; in the step 104, data which is partially or completely matched with the information preset by the repair system is marked in the Excel table in the repair data processing, so that the repair information of the repair table and the authenticity of the information of the repair table can be rapidly and accurately determined.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.
Claims (3)
1. A method for automatically inquiring models of repair tables is characterized by mainly comprising five steps of repair data sending, repair data reading, repair data analysis, repair data processing and cyclic operation, and specifically comprises the following steps:
101, sending repair data: the method comprises the steps that a repairer delivers a watch and a receipt which need to be repaired to a seller, and the seller makes data of all repaired watches received within a period of time into an Excel form;
102 repair data reading: the method comprises the steps that a seller reads manufactured Excel form information through an established rework system and compares the read Excel form information with information preset by the rework system;
103, analyzing the repair data: the rework system queries the object of Excel form information in each behavior, compares the object with the information preset by the rework system, and if the Excel form information is partially or completely matched with the information preset by the rework system, the step 104 is performed; if the Excel table information cannot find the adaptive information in the information preset by the repair system, skipping the Excel table information of the current line number, and entering step 105;
104, processing repair data: marking data which are partially or completely matched with the information preset by the repair system in the read Excel table by the repair system;
105, circulating operation: returning to the step 101, and continuously circulating after sequentially entering the steps 102, 103, 104 and 105 until all information in the Excel table is compared; the method further includes step 106 of rework data supplement: in the step 103 of repairing data analysis, if the Excel form information cannot find the adaptive information in the information preset by the repairing system and the seller confirms that the data of the repairing table is real, the information in the Excel form is supplemented into the repairing system.
2. The method for automatically querying the model of the rework table as claimed in claim 1, wherein the time period in step 101 is determined by the seller according to the accumulated number of the actual rework tables, that is, the seller sets an early warning value of the rework table, and when the number of the rework tables reaches the early warning value, the Excel table is uniformly made.
3. The method for automatically querying the model number of the rework table as recited in claim 1, wherein the preset information of the rework system in step 102 comprises watch number, manufacturer model number, watch lever number and movement model number of all watches sold by the seller.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901280.7A CN107766465B (en) | 2017-09-28 | 2017-09-28 | Method for automatically inquiring model of repair table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901280.7A CN107766465B (en) | 2017-09-28 | 2017-09-28 | Method for automatically inquiring model of repair table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107766465A CN107766465A (en) | 2018-03-06 |
| CN107766465B true CN107766465B (en) | 2021-06-22 |
Family
ID=61266307
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710901280.7A Active CN107766465B (en) | 2017-09-28 | 2017-09-28 | Method for automatically inquiring model of repair table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107766465B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN202563547U (en) * | 2012-02-17 | 2012-11-28 | 深圳市英创立电子有限公司 | Element list processing system for electronic components |
| CN103559273A (en) * | 2013-11-05 | 2014-02-05 | 北京深思数盾科技有限公司 | Hardware equipment information processing method and inquiry method |
| CN103577961A (en) * | 2013-11-13 | 2014-02-12 | 北京深思数盾科技有限公司 | Hardware equipment management system and method for processing and querying information of hardware equipment management system |
| CN105049572A (en) * | 2015-08-12 | 2015-11-11 | 深圳市财富之舟科技有限公司 | Method for finding repair parameters of mobile phone |
| CN105929697A (en) * | 2016-04-19 | 2016-09-07 | 珠海格力电器股份有限公司 | Maintenance method of smart home, device and terminal |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP5452517B2 (en) * | 2011-02-09 | 2014-03-26 | 三菱電機株式会社 | Search processing device |
| CN104156358B (en) * | 2013-05-13 | 2018-09-18 | 腾讯科技（深圳）有限公司 | A kind of batch read method of table for database, device and system |
| US9262476B2 (en) * | 2014-01-10 | 2016-02-16 | Red Hat, Inc. | System and method for batch query processing |
| CN104463494A (en) * | 2014-12-25 | 2015-03-25 | 贵阳康祥浩科技有限公司 | Client side student dormitory management system |
| CN105512824A (en) * | 2015-12-15 | 2016-04-20 | 重庆腾帆科技有限公司 | Method for batch verification registration of books |
| CN106098575B (en) * | 2016-06-23 | 2018-11-09 | 宁波麦博韦尔移动电话有限公司 | A kind of chip repairing batch ball-establishing method |
-
2017
- 2017-09-28 CN CN201710901280.7A patent/CN107766465B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN202563547U (en) * | 2012-02-17 | 2012-11-28 | 深圳市英创立电子有限公司 | Element list processing system for electronic components |
| CN103559273A (en) * | 2013-11-05 | 2014-02-05 | 北京深思数盾科技有限公司 | Hardware equipment information processing method and inquiry method |
| CN103577961A (en) * | 2013-11-13 | 2014-02-12 | 北京深思数盾科技有限公司 | Hardware equipment management system and method for processing and querying information of hardware equipment management system |
| CN105049572A (en) * | 2015-08-12 | 2015-11-11 | 深圳市财富之舟科技有限公司 | Method for finding repair parameters of mobile phone |
| CN105929697A (en) * | 2016-04-19 | 2016-09-07 | 珠海格力电器股份有限公司 | Maintenance method of smart home, device and terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107766465A (en) | 2018-03-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11244404B2 (en) | VIN based insurance claim system | |
| US10818103B2 (en) | Engine health and life cycle tracking system | |
| CN110634021A (en) | Big data based vehicle estimation method, system, device and readable storage medium | |
| CN110502384A (en) | Parameter verification method, apparatus, equipment and the storage medium of electronic component | |
| CN112800044A (en) | Data quality determination and monitoring method, management system, storage medium and terminal | |
| CN112348530A (en) | Automatic server production inspection and repair method | |
| CN106557419B (en) | Program testing method and device | |
| CN107766465B (en) | Method for automatically inquiring model of repair table | |
| CN109635001B (en) | Product reliability improving method and system based on equipment failure data analysis | |
| CN112087320B (en) | Abnormality positioning method and device, electronic equipment and readable storage medium | |
| CN111080364A (en) | Engineering cost data center management system and device | |
| CN112561333A (en) | Assessment data processing method and device, electronic equipment and storage medium | |
| CN110795308A (en) | Server inspection method, device, equipment and storage medium | |
| CN111581110A (en) | Method, device and system for detecting accuracy of service data and storage medium | |
| CN111126634A (en) | Rail train overhauling method and device | |
| CN109934722A (en) | Verify adjustment method, device and the electronic equipment of rule | |
| CN115757169A (en) | Interface automation test-based judgment method and device and storage medium | |
| CN112684319B (en) | Chip inspection tracking method and device | |
| CN115168217A (en) | Defect discovery method and device for source code file | |
| CN105049572B (en) | A kind of mobile phone reprocesses parameter lookup method | |
| CN112185058A (en) | Monitoring alarm method, system, equipment and storage medium | |
| CN103281440B (en) | A kind of Intelligent Measurement also repairs method and the device of calibration parameter exception | |
| CN114757314A (en) | Laboratory instrument management method and system based on bar code technology | |
| CN114880508A (en) | Method, device and system for inquiring adaptation relation between automobile type and accessory | |
| CN116541389A (en) | Data quality detection method, device, equipment and medium |
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 | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1247678 Country of ref document: HK |
|
| TA01 | Transfer of patent application right |
Effective date of registration: 20210520 Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Applicant after: Shenzhen Qianhai Heying Technology Co.,Ltd. Address before: No.8 Xinfu Road, lincun, Tangxia Town, Dongguan City, Guangdong Province, 523000 Applicant before: DONGGUAN JIATAI WATCH Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |