CN111950669A - Welding product production information acquisition method based on database and two-dimensional code - Google Patents
Welding product production information acquisition method based on database and two-dimensional code Download PDFInfo
- Publication number
- CN111950669A CN111950669A CN202010840974.6A CN202010840974A CN111950669A CN 111950669 A CN111950669 A CN 111950669A CN 202010840974 A CN202010840974 A CN 202010840974A CN 111950669 A CN111950669 A CN 111950669A
- Authority
- CN
- China
- Prior art keywords
- welding
- production information
- dimensional code
- production
- 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.)
- Pending
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 93
- 238000003466 welding Methods 0.000 title claims abstract description 92
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000010330 laser marking Methods 0.000 claims abstract description 12
- 238000012544 monitoring process Methods 0.000 claims description 10
- 230000003750 conditioning effect Effects 0.000 claims description 8
- 238000005070 sampling Methods 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000009499 grossing Methods 0.000 claims description 3
- 238000011958 production data acquisition Methods 0.000 abstract description 2
- 238000007726 management method Methods 0.000 description 14
- 238000005516 engineering process Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012356 Product development Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000007639 printing Methods 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
Images
Classifications
-
- 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
- G06K17/0025—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 the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
-
- 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
- G07—CHECKING-DEVICES
- G07C—TIME OR ATTENDANCE REGISTERS; REGISTERING OR INDICATING THE WORKING OF MACHINES; GENERATING RANDOM NUMBERS; VOTING OR LOTTERY APPARATUS; ARRANGEMENTS, SYSTEMS OR APPARATUS FOR CHECKING NOT PROVIDED FOR ELSEWHERE
- G07C3/00—Registering or indicating the condition or the working of machines or other apparatus, other than vehicles
- G07C3/08—Registering or indicating the production of the machine either with or without registering working or idle time
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a method for acquiring production information of a welding product based on a database and a two-dimensional code, which comprises the following steps: inputting the production information before welding into a welding production information management system established in advance; automatically converting the welding production serial number of the welding production information management system into the two-dimensional code picture information of the workpiece; recording the two-dimensional code on the software interface to a proper position on the surface of a workpiece to be processed through laser marking; scanning the two-dimensional code of the workpiece to obtain a corresponding production number, and finally obtaining production record information in a production information database through the production number; in the invention, the welding production database is established to complete the welding production information record, so that the completeness of the production information record and the data reliability are greatly improved, a large amount of data is recorded through selection and automatic acquisition, human errors are avoided, and the reliability advantage of production data acquisition is obvious.
Description
Technical Field
The invention relates to a welding product production information acquisition method based on a database and two-dimensional codes, and belongs to the technical field of information acquisition.
Background
The dimension code is a member of bar codes, and is a black and white pattern recording data information which is arranged in a two-dimensional direction according to a certain distribution rule by utilizing a certain specific geometric figure. Compared with the one-dimensional code, the two-dimensional code has the advantages of large information capacity, high density, strong error correction capability, good safety and wide coding range, and can introduce a check error correction code and have the capabilities of detecting errors and recovering and deleting errors. The two-dimensional code may store various information such as voice, fingerprint, photograph, and image, in addition to basic english, chinese, and numeric information. The bar code label can play the roles of data information storage and communication by itself, and has become an emerging technology in the application of modern bar code technology.
At present, the welding production information management is mostly recorded on site manually or directly recorded into a corresponding electronic document by a manager. The biggest problem of such document type information management is that once a welded product has a quality problem, it is often difficult to obtain a welding production record of the product in the first time and initiate quality tracing.
Disclosure of Invention
The invention aims to provide a method for acquiring production information of a welding product based on a database and a two-dimensional code, which aims to solve the defects that when the quality of the welding product in the prior art is poor, the welding production record of the product is difficult to acquire in the first time, and the quality tracing is started.
A welding product production information obtaining method based on a database and two-dimensional codes comprises the following steps:
inputting the production information before welding into a welding production information management system established in advance;
automatically converting the welding production serial number of the welding production information management system into the two-dimensional code picture information of the workpiece;
recording the two-dimensional code on the software interface to a proper position on the surface of a workpiece to be processed through laser marking;
and scanning the two-dimensional code of the workpiece to obtain a corresponding production number, and finally obtaining production record information in the production information database through the production number.
Further, the welding production information management system comprises the steps of recording production information before welding and monitoring and recording electric parameters in welding.
Further, the pre-welding production information comprises basic information registration, welding process selection, welder task allocation and welding equipment determination.
Furthermore, the monitoring and recording of the electric parameters in welding are realized by a current and voltage sensor to monitor and collect the current and voltage in real time in the welding process.
Furthermore, the current and voltage acquisition system comprises a current and voltage sensor, an AD data acquisition card and a signal acquisition display platform; the current and voltage sensor collects original signals of welding machine electrical parameters, the AD data acquisition card carries out input sampling on the original signals, and the signal acquisition display platform is used for displaying and storing the welding machine electrical parameters.
Furthermore, the input sampling is realized by a conditioning circuit, and the conditioning circuit is composed of a smoothing filter, a gain adjusting circuit, a safety protection circuit and an A/D (analog/digital) conversion circuit.
Compared with the prior art, the invention has the following beneficial effects: the existing welding production information management is difficult to trace the product development quality in the welding production management because the production information is imperfect in recording and poor in data reliability, information is difficult to store for a long time and is dispersed in different documents. The invention completes the comprehensive real-time acquisition of the welding production information by a database technology and an electric signal monitoring technology, and establishes a rapid, stable and rapid acquisition channel of the welding production information by means of a laser marking and two-dimensional code technology. Production information record is comprehensive, and it is stable convenient, specific to acquire the channel:
compared with the paper welding production ledger record, the method and the device have the advantages that the welding production database is established to complete the welding production information record, the completeness of the production information record and the data reliability are greatly improved, a large amount of data are recorded through selection and automatic acquisition, human errors are avoided, and the reliability advantage of production data acquisition is obvious.
Compared with the paper welding production machine account records, the laser marking technology is used in the invention to complete the two-dimensional code burning of the workpiece, and the two-dimensional code reading and writing technology is used to establish a rapid acquisition channel of the welding production information of the workpiece, so that production management personnel can timely trace the quality of the workpiece.
Drawings
FIG. 1 is a diagram illustrating the data management of the welding production information according to the embodiment of the present invention;
FIG. 2 is a schematic diagram of a "enter welding production information" window of the embodiment of the patent;
FIG. 3 is a system for monitoring and recording electrical parameters during a welding process according to an embodiment of the present invention;
FIG. 4 is a diagram of the analog input sampling front-end conditioning architecture of the embodiment of the present patent;
FIG. 5 is a schematic diagram of a welding production information fast acquisition channel according to an embodiment of the present disclosure;
fig. 6 is a schematic diagram of two-dimensional code reading according to an embodiment of the present disclosure.
Detailed Description
In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further described with the specific embodiments.
As shown in fig. 1-6, a method for acquiring production information of a welding product based on a database and a two-dimensional code is disclosed: the specific method comprises the following steps:
firstly, inputting production information before welding into a welding production information management system established in advance;
automatically converting the welding production serial number of the welding production information management system into the two-dimensional code picture information of the workpiece;
secondly, recording the two-dimensional code on the software interface to a proper position on the surface of the workpiece to be processed through laser marking;
and thirdly, scanning the two-dimensional code of the workpiece to obtain a corresponding production number, and finally obtaining production record information in the production information database through the production number.
Aiming at the steps, the method can be specifically divided into the following steps: firstly, establishing a welding production information management system to realize the datamation management of welding production information; and secondly, establishing a welding production information rapid acquisition channel based on a two-dimension code reading and writing technology, so that a user can conveniently realize the quality tracing of the welded product. As shown in fig. 1, the welding production information datamation management schematic diagram of the present patent is provided.
The welding production information datamation management comprises the following steps: and recording production information before welding and monitoring and recording electric parameters in welding.
As shown in fig. 2, the pre-weld production information entry includes: the basic information is registered (production number, production date, product number, product name and the like), a welding process is selected (a proper welding process file is selected according to a welding method, a base material brand, a plate thickness and a product type), a welder task is distributed (a welder capable of implementing the process is searched according to qualification information), and welding equipment (the welding equipment which can actually implement the process according to the welding method, the station and the equipment state to which the welder belongs) is determined.
The monitoring and recording of the electric parameters in the welding process mainly completes the real-time monitoring and acquisition of the current and the voltage in the welding process by means of a current and voltage sensor. According to the working condition requirement, a set of current and voltage acquisition system is designed by self, and can acquire 6 paths of current and 6 paths of voltage respectively to form 12 paths of signals. The current and voltage acquisition system mainly comprises a current and voltage sensor, a data acquisition card and a signal acquisition display platform.
As shown in fig. 3, the current and voltage sensor is mainly responsible for collecting the original signals of the electrical parameters of the welding machine, and the AD data acquisition card performs input sampling on the original signals. The input sampling is mainly realized by a front-end conditioning circuit, and the basic structure of the front-end conditioning circuit is shown in fig. 4. The conditioning circuit is basically composed of a smoothing filter, a gain adjusting circuit, a safety protection circuit and an A/D conversion circuit. The signal acquisition display platform is used as a software part of the system and is mainly used for displaying and storing electric parameters in welding. By the platform, real-time images of welding electrical parameters can be obtained, and collected data can be exported to Excel documents and stored in a welding production information database.
The welding production information is rapidly acquired mainly by automatic generation of a workpiece two-dimensional code, laser recording and code scanning reading. The automatic generation of the two-dimensional code is to automatically convert a welding production number into the information of a workpiece two-dimensional code picture, and the information conversion is realized by means of C # programming. Laser recording means that the two-dimensional code on the software interface is recorded to a proper position on the surface of the workpiece to be processed through laser marking. The scanning code acquisition is that the workpiece two-dimensional code is scanned through a handheld bar code reader to acquire a corresponding production serial number, and finally, production record information in a production information database is acquired, so that production personnel can trace the product quality conveniently. Fig. 5 is a schematic diagram of a rapid access channel for welding production information according to the present disclosure.
The key for rapidly acquiring welding production information lies in the successful realization of workpiece two-dimensional code burning and code scanning reading. The laser marking method is taken as a means for realizing two-dimensional code burning in consideration of the operational advantages of laser marking. The two-dimensional code laser recording process comprises the following steps:
s1, setting laser marking parameters (frequency, duty ratio, step length, time delay, repetition times and pause time) is completed, and a good marking effect is ensured to be obtained.
And S2, automatically generating the two-dimensional code, and transmitting the two-dimensional code to laser marking control software by the system.
And S3, manually selecting the marking position by a user to finish the two-dimensional code laser recording work of the workpiece.
S4, besides the laser marking is selected to complete the two-dimensional code burning of the workpiece, the two-dimensional code adding work can be realized by adopting a printing and pasting mode. However, the above technical solution is undoubtedly more suitable in view of the production efficiency and the work environment of welding the workpiece.
The two-dimensional code scanning reading is mainly realized by a handheld bar code reader. The hand-held barcode reader has the following advantages: the wireless connection is adopted, the operability is improved, and a user can quickly read the two-dimensional code; the automatic adjustment of parameters is realized through a function button, and the reading and setting are completed; various types of bar codes and various communication protocols are supported. Therefore, for a user, the user only needs to scan slightly to complete the two-dimensional code reading work.
In addition to the above-mentioned work piece two-dimensional code reading work that selects handheld barcode reader to accomplish, also can use customer terminals such as smart mobile phone and fixed barcode reader to read, but consider the security of production information and the reliability of reading work, the flexibility adopts handheld barcode reader more suitable.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.
Claims (6)
1. A welding product production information obtaining method based on a database and a two-dimensional code is characterized by comprising the following steps:
inputting the production information before welding into a welding production information management system established in advance;
automatically converting the welding production serial number of the welding production information management system into the two-dimensional code picture information of the workpiece;
recording the two-dimensional code on the software interface to a proper position on the surface of a workpiece to be processed through laser marking;
and scanning the two-dimensional code of the workpiece to obtain a corresponding production number, and finally obtaining production record information in the production information database through the production number.
2. The database and two-dimensional code based welding product production information acquisition method according to claim 1, wherein the welding production information management system comprises pre-welding production information entry and in-welding electrical parameter monitoring records.
3. The database and two-dimensional code based welding product production information acquisition method according to claim 2, wherein the pre-welding production information includes basic information registration, welding process selection, welder task allocation and welding equipment determination.
4. The database and two-dimensional code based welding product production information acquisition method according to claim 2, wherein the in-welding electrical parameter monitoring record completes real-time monitoring and acquisition of current and voltage in the welding process through a current and voltage sensor.
5. The database and two-dimensional code based welding product production information acquisition method according to claim 4, wherein the current and voltage acquisition system comprises a current and voltage sensor, an AD data acquisition card and a signal acquisition display platform; the current and voltage sensor collects original signals of welding machine electrical parameters, the AD data acquisition card carries out input sampling on the original signals, and the signal acquisition display platform is used for displaying and storing the welding machine electrical parameters.
6. The database and two-dimensional code based welding product production information obtaining method according to claim 5, wherein the input sampling is realized by a conditioning circuit, and the conditioning circuit is composed of a smoothing filter, a gain adjusting circuit, a safety protection circuit and an A/D conversion circuit.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010840974.6A CN111950669A (en) | 2020-08-20 | 2020-08-20 | Welding product production information acquisition method based on database and two-dimensional code |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010840974.6A CN111950669A (en) | 2020-08-20 | 2020-08-20 | Welding product production information acquisition method based on database and two-dimensional code |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111950669A true CN111950669A (en) | 2020-11-17 |
Family
ID=73358513
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010840974.6A Pending CN111950669A (en) | 2020-08-20 | 2020-08-20 | Welding product production information acquisition method based on database and two-dimensional code |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111950669A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112561017A (en) * | 2020-12-25 | 2021-03-26 | 东方电气集团科学技术研究院有限公司 | Snake-shaped pipe weld joint mark tracing system |
| CN114070864A (en) * | 2021-11-10 | 2022-02-18 | 江苏新格尔人居科技有限公司 | Method for calling door and window processing data on line |
| CN114594728A (en) * | 2022-02-07 | 2022-06-07 | 厦门聚视智创科技有限公司 | High-precision low-cost mobile phone motherboard machining position feedback system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040099648A1 (en) * | 2002-11-26 | 2004-05-27 | Hu Shixin Jack | Online monitoring system and method for a short-circuiting gas metal arc welding process |
| KR20040048078A (en) * | 2002-12-02 | 2004-06-07 | 현대중공업 주식회사 | Acquisition and Analysis system for real time monitoring welding condition |
| JP2008059116A (en) * | 2006-08-30 | 2008-03-13 | Hitachi-Ge Nuclear Energy Ltd | Welding work management and recording system using rfid tag |
| CN107755857A (en) * | 2016-08-23 | 2018-03-06 | 南京理工大学 | A kind of Robot Scanning welding gun system and its parameter assign method automatically |
| CN107838546A (en) * | 2017-11-20 | 2018-03-27 | 苏州凯尔博精密机械有限公司 | A kind of intelligent transport welding production line |
| CN108319998A (en) * | 2018-02-02 | 2018-07-24 | 江苏融昱药业有限公司 | A kind of product traceability system |
| CN109242072A (en) * | 2018-10-30 | 2019-01-18 | 南京中车浦镇城轨车辆有限责任公司 | A kind of fast acquiring method based on database and two dimensional code welding product information |
| CN110188843A (en) * | 2019-05-09 | 2019-08-30 | 上海赫丁格热处理有限公司 | Workpiece quality detection label record system |
| CN111091395A (en) * | 2019-12-19 | 2020-05-01 | 哈尔滨焊接研究院有限公司 | Welding product traceability system and application method thereof |
-
2020
- 2020-08-20 CN CN202010840974.6A patent/CN111950669A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040099648A1 (en) * | 2002-11-26 | 2004-05-27 | Hu Shixin Jack | Online monitoring system and method for a short-circuiting gas metal arc welding process |
| KR20040048078A (en) * | 2002-12-02 | 2004-06-07 | 현대중공업 주식회사 | Acquisition and Analysis system for real time monitoring welding condition |
| JP2008059116A (en) * | 2006-08-30 | 2008-03-13 | Hitachi-Ge Nuclear Energy Ltd | Welding work management and recording system using rfid tag |
| CN107755857A (en) * | 2016-08-23 | 2018-03-06 | 南京理工大学 | A kind of Robot Scanning welding gun system and its parameter assign method automatically |
| CN107838546A (en) * | 2017-11-20 | 2018-03-27 | 苏州凯尔博精密机械有限公司 | A kind of intelligent transport welding production line |
| CN108319998A (en) * | 2018-02-02 | 2018-07-24 | 江苏融昱药业有限公司 | A kind of product traceability system |
| CN109242072A (en) * | 2018-10-30 | 2019-01-18 | 南京中车浦镇城轨车辆有限责任公司 | A kind of fast acquiring method based on database and two dimensional code welding product information |
| CN110188843A (en) * | 2019-05-09 | 2019-08-30 | 上海赫丁格热处理有限公司 | Workpiece quality detection label record system |
| CN111091395A (en) * | 2019-12-19 | 2020-05-01 | 哈尔滨焊接研究院有限公司 | Welding product traceability system and application method thereof |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112561017A (en) * | 2020-12-25 | 2021-03-26 | 东方电气集团科学技术研究院有限公司 | Snake-shaped pipe weld joint mark tracing system |
| CN114070864A (en) * | 2021-11-10 | 2022-02-18 | 江苏新格尔人居科技有限公司 | Method for calling door and window processing data on line |
| CN114594728A (en) * | 2022-02-07 | 2022-06-07 | 厦门聚视智创科技有限公司 | High-precision low-cost mobile phone motherboard machining position feedback system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111950669A (en) | Welding product production information acquisition method based on database and two-dimensional code | |
| US5513264A (en) | Visually interactive encoding and decoding of dataforms | |
| US7154534B2 (en) | Image input apparatus, program executed by computer, and method for preparing document with image | |
| US8036431B1 (en) | Portable apparatus for identification verification | |
| CA2531497A1 (en) | Facsimile machine of internet terminal type | |
| CN106534608A (en) | Foldable authentication high-speed image shooting instrument | |
| CN103152505A (en) | Intelligent scanner and operative method | |
| CN206226557U (en) | Collapsible certification high photographing instrument | |
| CN108537078A (en) | Reading device and portable terminal | |
| US8843374B2 (en) | Voice recording for association with a dot pattern for retrieval and playback | |
| CN109242072B (en) | Method for rapidly acquiring welding product information based on database and two-dimensional code | |
| DE19638882A1 (en) | Telephone and CCD camera unit | |
| CN109788155A (en) | Image read-out and method | |
| CN113128192A (en) | Power transmission and transformation detection test data field interaction and centralized management and control method | |
| CN112735039A (en) | Power test equipment management system and method | |
| JP5138210B2 (en) | Code reading apparatus, control program for code reading apparatus, and recording medium recording control program for code reading apparatus | |
| CN111612112A (en) | Identification method and system based on digital twin subway station door | |
| US6972862B2 (en) | Portable fax machine | |
| CN110826668B (en) | Intelligent inspection recording system and method for concrete production equipment | |
| WO1999041621A2 (en) | Circuit board assembly inspection | |
| CN221038781U (en) | Intelligent assessment terminal for weld film | |
| CN212086284U (en) | Big data file acquisition and analysis device | |
| DE102008015652A1 (en) | Hand-guided detection device for detecting handwritten or printed symbols or texts, has detecting unit for detecting symbols or texts and transformation unit for transforming detected symbols or texts in digital data | |
| JP3711725B2 (en) | Image recognition device | |
| CN215041439U (en) | Hand-held type sweeps a yard label printing device |
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 |