CN104766118B

CN104766118B - A kind of fixed petroleum steel pipe RFID device

Info

Publication number: CN104766118B
Application number: CN201510033734.4A
Authority: CN
Inventors: 张瑞; 李学武; 夏宇文; 王齐; 王军民; 屠俊文; 王文博; 戴树涛; 田利; 王克
Original assignee: China Petroleum Technology and Development Corp
Current assignee: China Petroleum Technology and Development Corp
Priority date: 2015-01-22
Filing date: 2015-01-22
Publication date: 2018-03-16
Anticipated expiration: 2035-01-22
Also published as: CN104766118A

Abstract

The invention discloses a kind of fixed petroleum steel pipe RFID device, the fixation applied to rig parts Internet of Things integral system RFID label tag.Mainly it is made up of shank 1, connection-peg 2, locating ring 3, RFID anti-shieldings label 4；The tubing of different tube diameters is can be applied to, smaller, simple installation is invaded and harassed for existing plant production processes flow, it is high for the big temperature difference fitness in different regions due to no by the way of bonding；The RFID label tag of installation is vacantly hit exactly in the mouth of pipe, and equipment read-write discrimination is high, is not easy to damage during logistic storage；Subsequent recovery is convenient, and material is cheap with cost of labor, is adapted to large-scale mass production.

Description

A kind of fixed petroleum steel pipe RFID device

Technical field

The invention belongs to rig parts Internet of things system field, more particularly to a kind of fixed petroleum steel pipe RFID electronics Label apparatus.

Background technology

With the growth of corporate business, the diversified development of rig type, and international market difference geology, reservoir condition Customization it is more and more to rig parts demand；

But existing rig components supplying system response speed is slow, technology clarification spends time length, duplication of labour consumption When it is laborious；Rig parts scene transition issue is more, user's complaint is more, directly affect company's production efficiency and business increases.

And the Integrated Logistics system of other industry is all the shipping of standard component, hoc scenario is simple, it is impossible to meets rig Parts customize, diversified feature.

Comprehensive rig parts basic database is established, forms logistics integration system, imports, safeguard, look into for data Ask, statistical management provides efficient means, and provides strong foundation for subsequent production decision-making and long-term plan；Establish high Effect, information communication channel is efficiently modernized, facilitate having between intra-company, overseas administrative body, manufacturer, user Effect, link up in time；Rig inbound logistics automatization level is lifted energetically, and solve to run into real work conscientiously various asks Topic, it is to improve development of company core competitiveness, promote the fast-developing only way of corporate business.

Industrially, unique manufacture historical record, this part are produced because pipe-type product all has to pass through certification Record must can be traced to all technical parameters used in tubing manufacture, for example, steel manufacture special heat number, the information of logistics, Specific interface modes.Situation complexity is stacked in product, in the case of product packaging is approximate, we must determine different brackets steel Material, different type interface structure will not be obscured together.And the information of pipe material product needed for navigating to can be gathered in real time. RFID label tag device and installation method are with regard to particularly important, existing mounting means, the problem of being primarily present following several respects：

1. the problem of metallic shield：The installation of ordinary RFID tag, generally it is pasted onto inside metal watch, pipe-type product For circular metal structure, natural metal screen layer be present, because tubing is during warehouse logisticses, meeting stacked multilayer, and Tubing, which is asked, mutually to be overstock, therefore all inadvisable using pasting pipe material inner wall or hanging mode outside tubing, label or can not be Identify during scanning, or damaged in extruding.

2. the problem of because of temperature difference tag defeat：In addition pipe material product often stores stockyard out of doors, and the world wide temperature difference can To reach 100 degrees Celsius.For device mode of the RFID label tag on product, it is proposed that very big test, similar routine Glue is bonded, and can rapidly be failed in the case of the larger temperature difference, can not be met the requirement of long-term device.

3. the problem of logistics is loaded and unloaded：During logistics transportation, cargo handling process in the wild, in outer surface mount RFID label tag, unavoidable abrasion be present, a large amount of damages can not avoid.For the RFID label tag in interior surface mount, due to Bonded adhesives residue problem be present, it is necessary to manpower cleaning largely be spent, to reach the technological requirement of tube wall smooth pieces.

4. the problem of streamline is transformed：Because each existing production technology of tubing oil producer and flow are very ripe steady It is fixed, the RFID label tag for increasing device newly, it is impossible to change the technological process of original producer.Increase too many workload.This is just needed Easy for installation, dismounting is simple.

Therefore, exploitation one kind can meet that rig parts Internet of things system gathers demand, and and can ensures label validity, just The RFID device of victory is just particularly important.

The content of the invention

The invention provides a kind of fixed petroleum steel pipe RFID device, applied to rig parts Internet of Things The fixation of integral system RFID label tag.

Rig parts Internet of Things integral system includes：Basic database subsystem, subsystem of abroad inquiring the price, shipping System, overseas scene handing-over subsystem, storage five C/S subsystems of subsystem and a rig parts Internet of Things B/S general headquarters System.Each system introduction is as follows：

Basic database subsystem

Basic database subsystem is the data source of a whole set of rig parts Internet of Things integral system.Basic database Subsystem helps operating personnel to complete to believe for original numerous and disorderly complicated all kinds of rig parts atlas, rig information, shipping In the basic data import systems such as breath, standardized administration is carried out, and reduced data can be distributed to other each systems and made For data source.

System advantage：

1. one-touch importing rig summary sheet, rig handbook and all kinds of Back ground Informations, easy to operate；

2. by rig model->Rig sequence number->Rig catalogue tertiary level is managed, and is equal to visualization rig zero Part handbook, it is easy to browse；

3. support diversified inquiry part mode：Fuzzy query checks portion with the catalogue form by similar rig handbook Part；

4. can simultaneously display unit and corresponding component distribution picture, it is intuitively, easy to operation；

5. multilingual catalogue handbook is supported to import and browse；

6. it is classified control of authority, operation log recording

Basic database subsystem includes：Basic data import unit, basic data maintenance unit, basic data issue are single Member, System Management Unit, help unit.

Basic data import unit mainly includes rig numbering summary sheet import modul, rig parts handbook imports mould Block, rig parts handbook Shipping information import modul, supplier information import modul, overseas customer's information import modul.Bore Rig parts handbook data import system is supported Chinese, English, Spanish, Russian by machine parts handbook import modul The handbook batch of four kinds of language imports.In importing process, the form of guidance document is checked, the handbook text for not meeting specification Part is prompted.After importing, ejection imports result statistical information.It can check after importing and export reading knot Fruit.Rig parts handbook import modul imports the detailed data of the rig parts by arranging, and includes the detail of parts The location map and other component diagram pieces of table and subassembly in father's part.Rig parts handbook Shipping information import modul is real Referring now to the importing and management of Shipping information, including project, contract batch, delivery schedule and affiliated spare part information.

Basic data maintenance unit mainly includes rig numbering summary sheet maintenance module, rig parts handbook inquiry mould Block, rig parts handbook maintenance module, supplier information maintenance module, overseas customer's maintenance of information module.

In actual applications, the wrong situation of the rig numbering summary table data of importing is run into sometimes, so needing to bore Machine numbering summary sheet maintenance module is modified to the data having been introduced into, to keep the accurately and consistently property of data.

Rig parts handbook enquiry module directly checks rig hand after rig manual information has been imported in system Volume information, corresponding manual information is found by a variety of querying conditions.

Rig parts handbook maintenance module is in the case of the rig parts handbook data inaccuracy of importing, in system In manually to mistake data modify, delete, some parts handbook datas can also be increased manually.

Supplier information maintenance module is mainly managed to the information of supplier.

Overseas customer's maintenance of information module is managed to overseas customer's information.

Basic data release unit mainly includes rig numbering summary sheet release module, rig parts handbook issue mould Block, Shipping information release module, supplier information export module, overseas subscriber information export module.

Rig numbering summary sheet release module is distributed to the rig numbering summary sheet information in import system the confession of needs Answer business or client.

Rig parts handbook data is distributed to the supplier or client of needs by rig parts handbook release module.

System Management Unit mainly includes password modification, subscriber information management, System Operation Log.

Unit is helped mainly to include on the system, instructions to the user, frequently asked questions and corresponding answer

For the ease of joining the use at scene, warehouse, operation field, rig parts Internet of Things integral system is also supported Rig parts handbook is exported, and is stored into rig parts handbook terminal device, for live handing-over personnel, warehousing management people Member and equipment construction personnel use at any time.Rig parts handbook terminal mainly includes：Components information memory module, display mould Block, parts handbook enquiry module, parts handbook update module, parts handbook maintenance module.Wherein：

Components information memory module realizes that rig components information imported into zero, rig from basic database subsystem Part handbook terminal, the data lock of components information memory module is closed, realizes that data are read-only, it is impossible to be exported or change.Display Module is processed to components information, is shown in a manner of picture, form, animation simulation etc..Parts handbook inquires about mould Block sets querying condition to be inquired about, and can check the information of any parts in system, while provides intelligent reminding, recommends similar The selective contrast of components information.Parts handbook update module connects network by the data wire of handbook terminal, passes through peace Full checking, realize that handbook data updates.Parts handbook maintenance module is carried out to the mistake, the invalid information that are found during use Mark, basic database subsystem is submitted to when data update automatically, but itself data can not be increased newly, changed, The operations such as deletion, export.

Overseas inquiry subsystem

Overseas inquiry subsystem is intended to quickly solve overseas subscriber in inquiry link problem encountered, simplified inquiry operation Flow, wasting time and energy for technology clarification is effectively avoided back and forth, improve the accuracy and promptness subsequently supplied.

System advantage：

1. the one-touch packet for importing the issue of parts basic database, easy to operate；

2. rig parts handbook is intuitively shown, synchronous with papery handbook, reference convenient；

3. much information search method, can fast and easy search information needed data, and navigate to handbook where parts Position；

4. the function of imitating shopping cart realizes the generation of inquiry sheet, simple to operate；

5. can be browsed to history inquiry sheet, and a history inquiry sheet can be replicated as current inquiry sheet, saved The work of parts is gone to reselect；

6. the inquiry sheet of generation can be exported, mail can also be directly transmitted as annex to specified mailbox.

7. being classified control of authority, different administration authorities can be set per category information and read authority；

8. operation log recording, each operation of business personnel involved by record.

Overseas inquiry subsystem mainly includes：Rig components information unit, inquiry single unit, data publication unit.

Rig components information unit include rig components information receiving module, rig parts handbook maintenance module, Rig parts handbook enquiry module, supply of material inventory maintenance module, supply of material inventory enquiry module.

Rig components information receiving module receives the packet as derived from basic database subsystem, according to rig sequence Number, it is placed under corresponding directory tree rig sequence number.After rig parts handbook imports, rig parts can be inquired the price Selection.The data of reception include：Rig numbering summary sheet, rig parts handbook, rig parts shipping list.

Rig parts handbook maintenance module is shown to the parts handbook of importing according to tree structure, and is shown in detail Information and pictorial information；Search parts.The parts found are put into the parts list of inquiry sheet, and can be to zero Part list performs deletion, continues to add parts, empties parts list operation.

Rig parts handbook enquiry module by set querying condition inquire about part, show Query Result in lists, The related picture of display unit, by inquiry, the part of needs is conveniently found, adds part to current inquiry sheet.

Inventory maintenance module of supplying shows supply of material inventory, divides rig model to show, addition supply of material inventory part to inquiry sheet In list.

Inventory enquiry module supply by delivery lot, rig model, query display shipping list part, addition part is to ought Preceding inquiry sheet.

Single unit of inquiring the price includes current inquiry single module, pending inquiry single module, history inquiry single module.

Current inquiry single module, after user adds parts, generates current inquiry sheet.Can be to current in current interface Inquiry sheet parts list is safeguarded, can be changed components information, be removed parts, empties list, can also return after Continuous addition parts, jump to inquiry sheet information solicitation interface after editor, input inquiry sheet essential information, inquiry user profile, By inquiry user profile, terms of agreement, inquiry sheet is generated.

Pending inquiry single module can be changed the inquiry sheet of " establishment " state, deletes, prints, sent, to " transmission " The inquiry sheet of state can be checked, setting state, printing, transmission.

History inquiry sheet is the inquiry sheet that state is " completion " and " locking ".History inquiry single module is looked into by setting condition Ask, show Query Result in lists.To the inquiry sheet of " completion " state, it can check, replicate, delete, lock, export, beat Print, E-mail is sent, to the inquiry sheet of " locking " state, can check, replicate, delete, unlock.

Data publication unit includes rig parts handbook export module, rig parts handbook renewal release module.

Rig parts handbook export module exports rig parts handbook when some information of handbook have modification For the db files of encryption, general headquarters are sent to offline and are updated to keep data consistent.

Rig parts handbook updates release module when some information of handbook have modification, is uploaded more by mail Handbook annex after new, is sent to general headquarters by network and is updated, to keep data consistent.

Ship subsystem

Shipping subsystem is an important step of logistics management, is the important guarantee that logistics runs well.Shipping management Subsystem is helped to ship timely shipping processing of personnel's completion to goods, and label bar code is introduced in this link, is opened by skill The bar code rule of determination carrys out unique mark parts, and by bar code acquisition technique, it is each required for automatically generating in systems Kind list, reduce the workload of shipping personnel, heighten operating efficiency, ensure the accuracy of data.

System advantage：

1. the project of pressing->Contract batch->Delivery lot tertiary level is managed, and is close to operation field；

2. automatically generating bar-code label by pre-defined rule, and support label single and bulk print function；

3. gathering vanning bar code using collector and automatically generating packing list mode, mitigate workload significantly, improve work effect Rate and accuracy；

4. the vanning situation of parts can be tracked, it is very clear；

5. by setting whether delivery state is to have completed, shipping management is conveniently carried out；

6. the shipping result of current delivery lot is distributed into headquarters server, the packet after issue is encrypted, Compression, securely and reliably；

7. much information search method, can fast and easy lookup information needed data；

8. being classified control of authority, different administration authorities can be set per category information and read authority；

9. operation log recording, each operation of business personnel involved by record；

Shipping subsystem mainly includes delivery schedule unit, label bar code unit, packing list unit, data publication unit.

Delivery schedule unit includes：Delivery schedule receiving module, shipping project management module, shipping spare part maintenance of information mould Block, shipping spare part information verification module.

Delivery schedule receiving module imports the delivery schedule from rig parts Internet of Things B/S general headquarters system, and herein On the basis of perform the operation flow of shipping.Finally need to update delivery schedule and issue, to keep and rig parts Internet of Things The synchronization of B/S general headquarters system data.

Ship project management module by project->Contract batch->Delivery lot+delivery schedule) tertiary level shipped Project management, it can intuitively check live shipping situation.By setting current registration, system default carries out phase to current registration The shipping business processing answered.Spare part maintenance of information module is shipped when mistake occur in the delivery schedule data of importing, to data Modify, delete or increase new data.What shipping spare part information verification module was mainly checked is initial data, that is, the hair imported Fortune plan.

Label bar code unit includes label bar code generation print module, label bar code maintenance module.

Label bar code generates print module by the rule generation bar code pre-established, and together with the other information one of parts Rise and print, generate label, be attached to above the outer packing of parts.Label bar code maintenance module retains print record, printing Time, information on label, it is easy to later check.

Label bar code is the exclusive identification code of rig parts.

General commodity bar code is typically made up of prefix part, manufacturer's code, commercial product code and check code.Commodity bar Prefix code in shape code is the code for identifying country, and endowed power represents in International Article Numbering Association, such as 00-09 The U.S., Canada, 45,49 represent Japan, and 69 represent China's Mainland, and 471 represent Taiwan, and 489 represent the Hong Kong Special Administrative Region； The tax power of manufacturer's code is assigned by national article code center and made in every country or regional article code tissue, China Make vendor code.Commercial product code is the code for identifying commodity, and endowed power is exercised by production enterprise oneself, manufacturing enterprise Determine on which kind of commodity of oneself be commodity bar code using which Arabic numerals according to regulation condition oneself.Commodity bar shaped Code is last to verify in commodity bar code the correctness of 1-12 digital codes from left to right with 1 bit check code.Commodity bar code refers to The mark being made up of one group of regularly arranged bar, sky and its corresponding character, to represent the symbol of certain merchandise news.Wherein Bar is dark, sky is white, and the scanning for bar code reading facility is distinguished.Its corresponding character is by one group of Arabic numerals group Into, directly distinguished for people or by keyboard to computer input data use.Represented by the empty and corresponding character of this group of bar Information be identical.

Drilling well parts are due to the diversity of itself and customize trend, and the business secret itself included Deng, it is impossible to general bar code is used, its label bar code is by hyte and end group on termination group, component information group, part The special bar code of rig parts collectively constituted, wherein termination group are used to record process of exchange information；Component information group is used to remember Record the structural information and customized information of rig parts；Hyte is used to record the position of rig parts in use on part Put relation；End group is used to record overseas handing-over information；

Wherein, label bar code is RFID, is fixed by fixed petroleum steel pipe RFID device.

RFID device is made up of the two parts of shank 1 and RFID anti-shieldings label 4：Shank 1 is by elastic material Material is formed, a connection-peg 2 for back-off, a vertical connection RFID anti-shieldings label 4.The bar footpath of shank 1, which need to be less than, waits to pacify The diameter of tubular threading protectors air vent is filled, there is locating ring 3 in shank stage casing, and the diameter of locating ring 3 is more than ventilation bore dia. The diameter of connection-peg 2 of button need to be more than the diameter of tubular threading protectors air vent, to prevent plug-in type RFID device Abjection；The good RFID chip of the enclosed inside of RFID anti-shieldings label 4 and respective antenna, it is overall to form RFID device.This RFID device is conveniently applied on the tubing of a variety of different bores, after installation due to using general shank RFID anti-shieldings label 4 is hit exactly positioned at empty in mouth of pipe threading protectors.It is minimum due to being acted on by metallic shield, therefore discrimination is big It is big to improve, and the RFID label tag device transports in tubing, it is not easily damaged in cargo handling process, improve the stabilization of operation system Property.

In use, the device shank 1 is inserted in the air vent of threading protectors, due to there is locating ring 3 to obstruct, avoid Shank 1 inserts too deep, and package unit can be positioned on required position.Now RFID anti-shieldings label 4 is parallel with orifice plane, Label substance can be identified by accessible read.If needing to reclaim, directly tubing mouth RFID label tag device is extracted.

Packing list unit includes packing list generation export and maintenance module, packaging packing list generation export and maintenance module, spare part dress Case enquiry module, shipping list generation export module.

Packing list generation export and maintenance module determine packing list essential information first, then select each iron sheet case of operation field The collection file that pick-up slip code forms during vanning, the parts in packing list are selected, imported into shipping subsystem and generate packing list.It is raw Packing list after all retains historical record, can inquire about, changes, deletes, export packing list.The generation of packaging packing list exports and safeguarded mould Block determines packaging packing list essential information, and then selection belongs to all packing lists of the packaging packing list, the packing list life of batch modification selection Into packaging packing list, finally merge the quantity of the identical parts in same packaging packing list.Spare part vanning enquiry module passes through item Mesh-》Contract batch-》Delivery lot-》Container number-》Case number (CN)-》The level of spare part list directly inputs rig model, zero The position of some parts of part number or foreign trade sequence number fast positioning.Institute in shipping list generation export module generation shipping flow What is needed generates list in units of rig model.

Data publication unit is after the completion of work is shipped, and project information and packing list, delivery schedule are distributed to rig zero Part Internet of Things B/S general headquarters system, to accomplish data syn-chronization.If scene does not have network condition, related data can be led Go out, be subsequently sent to specify mailbox.

Overseas scene handing-over subsystem

Overseas scene handing-over subsystem can simplify the formality of rig parts scene handing-over, be gone one by one without professional person Spare part is identified, using bar code scanner technology and computer information technology, greatly improves efficiency and accuracy that scene joins.

System advantage：

1. support Chinese, western language, English three kinds of language；

2. the project of pressing->Contract batch->Delivery lot tertiary level is managed, and is close to operation field

3. by setting whether hand-off state is to have completed, handing-over management is conveniently carried out；

4. checked by being scanned to arrival article, it is automatic to carry out goods verification, the different color of discrepancy of quantity item Mark；

5. label bar code printing function, benefit label are carried out to losing label；

6. providing delivery status inquiry statistical function, contrasted with contract quantity, see that whether having completed this buying closes Together；

7. the various lists needed are exported, it is convenient to carry out data summarization and statistics etc.

8. much information search method, can fast and easy lookup information needed data；

9. it is classified control of authority, operation log recording.

Overseas scene handing-over subsystem includes data receipt unit and handover process unit.

The data receipt unit at overseas scene receives the Shipping information of basic database subsystem issue,

Handover process unit includes：Shipping information display module, project maintenance module, parts vanning enquiry module, goods Thing verification module, goods loss Registration Module, hand-off state setup module, result of receiving export module, goods handing-over situation system Count module, shipping and receiving status inquiry module and handing-over information issuing module.

Shipping information display module by project-》Contract batch-》Delivery lot-》Container number-》The level knot of Order No. Structure is shown, while can be checked, export the operation such as packaging packing list information.Project maintenance module by project-》Contract batch Secondary-》Delivery lot-》Container number-》The hierarchical structure of Order No. is shown maintenance.Parts vanning enquiry module can be fast Check the position looked for where some parts quickly, and Query Result can be exported and printed.If the in addition, label in transportation There is the situation that abrasion comes off, label can be checked and printed again.Goods verification module takes scanning element cargo interests formula, by packaging Packing list or packing list and the consignment sheet of scanning generation are contrasted in the form of man-to-man, if it find that different then significantly to mark Note display, while compare statistical information.Goods loss Registration Module selectes container or iron sheet case, checks registered goods loss Situation, the parts to be registered are found by inquiry, input loss quantity, loss reason are registered.Hand-off state sets mould Block sets handing-over completion and unfinished two states in units of iron sheet case, container, delivery lot.Result of receiving exports mould Block exports result of receiving to the iron sheet case and container of having completed handing-over, is then sent to storage subsystem, in storage subsystem The middle importing result of receiving, complete in-stockroom operation.Goods joins situation statistical module to joining corresponding to delivery every time, gives in real time Go out statistics, provide total items amount, completed the situation of checking over goods, do not complete check over goods register in situation and handshaking it is all Defect parts situation.Shipping and receiving status inquiry module carries out query statistic by rig model, by shipment data and foreign trade contract Contrasted, count shipping and receiving situation.Join information issuing module after the completion of goods handing-over, export and handed over corresponding to this delivery Information is connect, is sent to rig parts Internet of Things B/S general headquarters system, rig parts Internet of Things B/S general headquarters system is imported into again In system, handing-over information is handled, whether arrangement carries out supplementing delivery etc..

Material fluid recognition hand-held set is used in live handshaking in overseas to the tag control of rig parts, identification, determined The operation such as position and point inspection.Mainly include：Tag control unit, product point inspection unit and data synchronisation unit.

Tag control unit installs electronic tag to rig parts before being used for overseas scene handing-over or uses hand-held set pair Electronic tag check the operation of the functions such as lookup, including：Label enables module, mends label module, tag recognition module, rig Position components module.Label enables module and product information is write into label, establishes the incidence relation of label and rig parts； It is the situation for preventing product from tag misses or damage occurring in shipping process to mend label module, and rig parts are mended and signed；Label Identification module is by scanning label, it can be seen that the rig components information associated by label, it is convenient to the fast of rig parts Speed identification；Rig position components module positions specific rig parts by input inquiry parameter scanning.

Product point inspection unit is mainly used in registering rig parts and putting inspection operation during overseas scene handing-over, including Registration Module and point inspection module, Registration Module are registered before the handing-over of rig parts；Point inspection module check product quantity and The situation of Product labelling, carry out mending in the case of missing or damage and sign operation, point inspection generation inventory can be automatically clear with shipping Singly it is compared, and provides comparison result.

Data synchronisation unit is mainly that cell phone and shipping subsystem carry out data interaction, including downloads basic data Module, attribute information module is downloaded, upload binding information module and uploads point inspection checklist module.Basic data module is downloaded to be used for The basic data of rig parts underlying attribute code table is downloaded, so as to which hand-held set is not before any product information is imported, is passed through Label is read, product can also be assisted in identifying.Download the shipping that attribute information module will ship supplier derived from subsystem Rig components information is imported into hand-held set.Upload binding information module and the binding information of product and label is uploaded into shipping Subsystem；Point inspection checklist module being uploaded when will examine, the rig parts inventory that generates uploads to shipping subsystem, is easy to generate Corresponding document.

Storage subsystem

Storage subsystem mainly realize rig parts from storage, outbound, allot, the kinds of goods logistics such as make an inventory progress overall process Tracking, there is provided effectively management.Bar code and single product code management are supported, passes through the kinds of goods of the unique sequence numbers of outbound shipment data Bar code scan, important foundation is provided for the tracing management of kinds of goods, further lift the managerial skills and warehouse logistics ring of kinds of goods Save efficiency.

System advantage：

1. record each storage that goes out by way of storage registration and outbound registration to record；

2. being put in storage using scanning storage and importing handing-over packet two ways batch, while also support manual storage, spirit It is living convenient；

3. using scanning outbound and manually selecting outbound two ways generation outbound list, meet practical operation business demand；

4. perfect stock control function is provided, including inquiring stock maintenance, stock-taking, stock's alarm, monthly stock Management, fill rat report etc.；

5. can be to being tracked in way kinds of goods；

6. the form of the various needs of export, such as storage bill, outbound list, stock report；

8. current inventory information is distributed into headquarters server, the packet after issue is encrypted, compressed, safely may be used Lean on；

9. the online packet for sending issue, if network condition, can directly send the packet within email；

10. being classified control of authority, different administration authorities can be set per category information and read authority；

11. operation log recording, each operation of business personnel involved by record.

Storage subsystem mainly includes：Stock-keeping unit, be put in storage unit, go out library unit, delivery indicating member, in-transit management list Member, data publication unit.

Stock-keeping unit includes：Inquiring stock maintenance module, stockpile number make an inventory module, parts come in and go out library inquiry module, Stock's alarm module, monthly inventory management module, stock report query statistic module, fill rat reporting modules.

The inquiry of inquiring stock maintenance module understands current inventories, is modified the basic letter of parts as needed Breath, label are mended, the corresponding operatings such as alarm limit are set, complete the maintenance to parts such as stocks.Stockpile number makes an inventory module first with adopting The bar code of parts, in systems selection gather file in storage scanning warehouse, will gather the data and database of file automatically In data be compared, and go out firm offer quantity and the discrepant item of book data with different color markings, complete what is made an inventory Operation.Parts come in and go out library inquiry module by setting querying condition, and that inquires about a certain or some parts goes out storage letter in detail Breath, including operator, outbound date, outbound quantity, storage date, warehousing quantity etc..Stock's alarm module is by setting zero Part essential information, current stock, stock's upper limit, stock's lower limit, upper limit alarm, lower limit alarm, timing judge the warehouse compartment of parts Situation, once exceeding bound, to provide alarm.Monthly inventory management module counts the of that month storage number of various parts Amount, outbound quantity, generate monthly stock control table.The storehouse in stock report query statistic module counted certain warehouse in certain year each month Situation is deposited, and is compared with the previous year, show that ring compares speedup than amplification and ring.Data comparison, analysis are carried out according to report, Fill rat is calculated by following formula.

Fill rat=actual outbound quantity/part plan outbound quantity * 100%

Storage unit includes：Newly-built storage Registration Module, storage logging modle, parts storage enquiry module.

It is newly-built storage Registration Module to storage parts register, with register title, operator, storage date three it is true A fixed unique registration.The logging modle record storage bill of registration and each corresponding generation every time is put in storage, user is in the module It is middle to be checked, exported or carried out some related operations.Parts storage enquiry module can press parts rig model, zero Part number, title, specifications and models, general rig, starting and termination time are inquired about, or according to barcode inquiry, it is determined that storage Situation.

Going out library unit includes：Newly-built outbound Registration Module, outbound logging modle, parts outbound enquiry module.

Newly-built outbound Registration Module is registered to outbound parts, true to register title, operator, outbound date three A fixed unique registration.The outbound list of generation is registered and corresponded to every time to outbound logging modle record every time, and user is in the module It is middle to be checked, exported or carried out some related operations.Parts outbound enquiry module can press parts rig model, P/N, title, specifications and models, general rig, starting and termination time are inquired about, or according to barcode inquiry, are determined Storehouse situation.

Delivery indicating member includes：Newly-built delivery instruction single module, delivery instruction unirecord module；

The newly-built newly-built single registration of delivery instruction of delivery instruction single module, it is single to generate delivery instruction by registration.Delivery instruction is single The delivery instruction of registration and each corresponding generation is single every time for logging modle record, and register information and instruction of delivering singly are tieed up Shield.

In-transit management unit includes：It is newly-built in way Registration Module, in-transit management module；

It is newly-built in way Registration Module to the newly-built registration of parts on way, by registration management in way components information, record In way parts, logistics information is tracked.In-transit management module record generate every time in way registration and part in way information, to stepping on Remember information and safeguarded in way components information.

Data publication unit sets addressee, makes a copy for people, theme, carries out inventory data issue.

Storage identification hand-held set is used in warehousing management to the tag control of rig parts, identification, positioning and point The operation such as inspection.Mainly include：Tag control unit, product point inspection unit and data synchronisation unit.

Tag control unit is used for production plant and installs electronic tag or using hand-held to the rig parts that will be dispatched from the factory Machine to electronic tag check the operation of the functions such as lookup, including：Label enable module, mend label module, tag recognition module, Rig position components module.Label enables module and product information is write into label, establishes associating for label and rig parts Relation；It is the feelings for preventing product in storing process and tag misses or damage occurring during transporting harbour to mend label module Condition, rig parts are mended and signed；Tag recognition module is by scanning label, it can be seen that the rig parts letter associated by label Breath, the convenient quick identification to rig parts；Rig position components module is positioned specific by input inquiry parameter scanning Rig parts.

Rig parts are sent to the operation of carrier of customs mainly for the production of factory by product point inspection unit, including go out Registration point inspection when registration point during factory is examined and delivered.Including Registration Module and point inspection module, Registration Module is in rig parts Registration of dispatching from the factory is carried out when dispatching from the factory；Delivery registration is carried out when rig parts are consigned into logistics department, while registers and delivers both sides Personal information；The situation of point inspection module check product quantity and Product labelling, carry out mending label behaviour in the case of missing or damage Make, point inspection generation inventory can be compared with shipping inventory automatically, and provide comparison result.

Rig parts Internet of Things B/S general headquarters system

Rig parts Internet of Things B/S general headquarters system includes：Basic database, daily inquiry quotation unit, purchasing management list Member, shipping unit, scene handing-over administrative unit, warehousing management unit and System Management Unit and display screen.Basic database bag Include storage comprising rig numbering summary sheet, rig parts handbook rig parts database and comprising support personnel's information, The personal information database of customer information and business personnel's information.

Daily inquiry price list head first carries out asking quotation registration, and the inquiry sheet for then receiving overseas inquiry subsystem generation enters Row processing, is decomposed by vendor name, multiple domestic inquiry sheets is generated after decomposition afterwards, and is issued corresponding supplier and carried out Inquiry.Typing quotation information in systems after Bidding is supplied, the report to business personnel is generated finally by rate of exchange option program Valency list.

Purchasing management unit mainly includes non-conformance report processing module.Non-conformance report processing module is mainly overseas to be used Problematic parts document is formed non-conformance report feedback by family, and these parts are then decomposed to form scene by supplier Non-conformance report issues each supplier, and the parts during supplier feeds back to site problems confirm, according to confirmation situation Parts are handled.

Shipping unit includes Shipping information receiving module, Shipping information browsing module and Shipping information search module, ships The project information at each shipping scene after information receiving module reception ciphered compressed as derived from shipping management subsystem, container Components information in information, iron sheet case information and iron sheet case.Shipping information browsing module can see the shipping feelings of all items Condition, and the data of each node can individually be counted.Shipping information search module searches for the information of certain container, and can Item destination node is shipped where the container to navigate to, direct can checks Shipping information.

Handing-over administrative unit in scene mainly joins at scene in the data file import system for managing subsystem issue, checks Shipping information and handing-over information, statistical analysis handing-over result, and handle the parts of defect in handing-over.

Warehousing management unit includes storage information import modul, storage information browsing module.Storage information import modul is led Enter the inventory information in each warehouse, while the file of mistake is automatically deleted, and show the statistical result of this export stock.

Storage information browsing module is in the form of a list shown in all warehouses with the country one belongs to's title, by aobvious Display screen checks the storage information in the different warehouses for the system of having been introduced into, and shows the detail information and history stock letter of single parts Breath, shows total inventory analysis curve map, easily browses the storage information and part statistical information in each warehouse.

System Management Unit, including notification module, application form management module, system management module.Notification module will be important Information notifies user, main to include notice notice management, consult notice announcement function.Application form management module is primarily to reality Existing common survey function, and questionnaire is safeguarded and statistical information is checked.System management module is included to account, group Loom structure, address list etc. are managed.

Brief description of the drawings

Fig. 1：Rig parts Internet of things system figure

Fig. 2：Fixed petroleum steel pipe RFID device

Embodiment

The invention provides a kind of fixed petroleum steel pipe RFID device, applied to rig parts Internet of Things The fixation of integral system RFID label tag, rig parts Internet of Things integral system include：It is basic database subsystem, overseas Inquiry subsystem, shipping subsystem, overseas scene handing-over subsystem, store in a warehouse five C/S subsystems of subsystem and a rig zero Part Internet of Things B/S general headquarters system.Wherein：

Basic data import unit mainly includes rig numbering summary sheet import modul, rig parts handbook imports mould Block, rig parts handbook Shipping information import modul, supplier information import modul, overseas customer's information import modul.Bore Rig parts handbook data import system is supported Chinese, English, Spanish, Russian by machine parts handbook import modul The handbook batch of four kinds of language imports.In importing process, the form of guidance document is checked, the handbook text for not meeting specification Part is prompted.After importing, ejection imports result statistical information.It can check after importing and export reading knot Fruit.Rig parts handbook import modul imports the detailed data of the rig parts by arranging, and includes the detail of parts The location map and other component diagram pieces of table and subassembly in father's part.Rig parts handbook Shipping information import modul Realize the importing and management for Shipping information, including project, contract batch, delivery schedule and affiliated spare part information.

Unit is helped mainly to include on the system, instructions to the user, frequently asked questions and corresponding answer；

Label bar code is the exclusive identification code of rig parts.General commodity bar code is typically by prefix part, manufactory Shang dynasty code, commercial product code and check code composition.Prefix code in commodity bar code is the code for identifying country, is assigned Code weight represents the U.S., Canada in International Article Numbering Association, such as 00-09, and 45,49 represent Japan, and 69 represent China's Mainland, 471 represent Taiwan, and 489 represent the Hong Kong Special Administrative Region；Article of the tax power of manufacturer's code in every country or area Tissue is encoded, China assigns manufacturer's code by national article code center.Commercial product code is the code for identifying commodity, Endowed power is exercised by production enterprise oneself, and manufacturing enterprise determines make on which kind of commodity of oneself according to regulation condition oneself Which Arabic numerals to be commodity bar code with.Commodity bar code is finally verified in commodity bar code from left to right with 1 bit check code The correctness of 1-12 digital codes.Commodity bar code refers to what is be made up of one group of regularly arranged bar, sky and its corresponding character Mark, to represent the symbol of certain merchandise news.Wherein bar is dark, sky is white, for bar code reading facility Scanning recognition.Its corresponding character is made up of one group of Arabic numerals, is directly distinguished for people or by keyboard to computer input Data use.Information represented by the empty and corresponding character of this group of bar is identical.

Packing list generation export and maintenance module determine packing list essential information first, then select each iron sheet case of operation field The collection file that pick-up slip code forms during vanning, the parts in packing list are selected, imported into shipping subsystem and generate packing list.It is raw Packing list after all retains historical record, can inquire about, changes, deletes, export packing list.Packaging packing list generation export and maintenance Module determines packaging packing list essential information, and then selection belongs to all packing lists of the packaging packing list, the packing list of batch modification selection Spanning set packing slip, finally merge the quantity of the identical parts in same packaging packing list.Spare part vanning enquiry module passes through item Mesh-》Contract batch-》Delivery lot-》Container number-》Case number (CN)-》The level of spare part list directly inputs rig model, zero The position of some parts of part number or foreign trade sequence number fast positioning.Institute in shipping list generation export module generation shipping flow What is needed generates list in units of rig model.

Fill rat=actual outbound quantity/part plan outbound quantity * 100%

Delivery indicating member includes：Newly-built delivery instruction single module, delivery instruction unirecord module

In-transit management unit includes：It is newly-built in way Registration Module, in-transit management module

Rig parts Internet of Things B/S general headquarters system includes：Basic database, daily inquiry quotation unit, purchasing management list Member, shipping unit, scene handing-over administrative unit, warehousing management unit and System Management Unit and display screen；Rig parts thing Networking B/S general headquarters system collects the subsystem data of each operation field, while also by general headquarters' system issue data to needs Subsystem, whole system are the systems of closed loop, it is common complete rig parts from asking quotation, buying, shipping, logistics, friendship It is connected to the total system operation of storage.

Basic database includes storage and includes rig numbering summary sheet, the rig parts database of rig parts handbook With the personal information database comprising support personnel's information, customer information and business personnel's information.

Claims

A kind of 1. fixed petroleum steel pipe RFID device, applied to rig parts Internet of Things integral system RFID The fixation of label；Rig parts Internet of Things integral system includes：Basic database subsystem, abroad inquire the price subsystem, hair Transport subsystem, overseas scene handing-over subsystem, storage five C/S subsystems of subsystem and a rig parts Internet of Things B/S General headquarters' system；Wherein：

Basic database subsystem includes：Basic data import unit, basic data maintenance unit, basic data release unit, System Management Unit, help unit；Complete for original numerous and disorderly complicated all kinds of basic rig information, Shipping information form In data import system, standardized administration is carried out, and reduced data can be distributed to other each systems as data source；

Overseas inquiry subsystem mainly includes：Rig components information unit, inquiry single unit, data publication unit；Quick solution Certainly overseas subscriber inquiry link problem encountered, simplify inquiry operating process, effectively avoid back and forth technology clarify it is time-consuming Arduously, the accuracy and promptness subsequently supplied are improved；

Shipping subsystem mainly includes delivery schedule unit, label bar code unit, packing list unit, data publication unit；Completion pair The timely shipping processing of goods, label bar code is introduced in this link, the bar code rule of determination is opened come unique mark by skill Parts, and by bar code acquisition technique, required various lists are automatically generated in systems；

Delivery schedule unit includes：Delivery schedule receiving module, shipping project management module, shipping spare part maintenance of information module, Ship spare part information verification module；

Delivery schedule receiving module imports the delivery schedule from rig parts Internet of Things B/S general headquarters system, and basic herein The upper operation flow for performing shipping；Finally need to update delivery schedule and issue, to keep total with rig parts Internet of Things B/S The synchronization of portion's system data；

Ship project management module by project->Contract batch->Delivery lot+delivery schedule tertiary level carries out shipping project pipe Reason, intuitively checks live shipping situation；By setting current registration, system default carries out corresponding shipping industry to current registration Business is handled；Spare part maintenance of information module is shipped when mistake occur in the delivery schedule data of importing, data are modified, deleted Remove or increase new data；Ship spare part information verification module checks is initial data, that is, the delivery schedule imported；

Label bar code unit includes label bar code generation print module, label bar code maintenance module；

Label bar code generates print module by the rule generation bar code pre-established, and is beaten together with the other information of parts Print off and, generate label, be attached to above the outer packing of parts；The reservation print record of label bar code maintenance module, the time-write interval, Information on label, it is easy to later check；

Label bar code is the exclusive identification code of drilling well parts, and label bar code is by hyte on termination group, component information group, part The special bar code of rig parts collectively constituted with end group, wherein termination group are used to record process of exchange information；Component information Group is used for the structural information and customized information for recording rig parts；Hyte was using for recording rig parts on part Position relationship in journey；End group is used to record overseas handing-over information；Wherein, label bar code is RFID, passes through fixed oil Steel pipe RFID device is fixed；

Fixed petroleum steel pipe RFID device is made up of the two parts of shank 1 and RFID anti-shieldings label 4：Shank 1 is made up of elastomeric material, a connection-peg 2 for back-off, a vertical connection RFID anti-shieldings label 4；The bar footpath of shank 1 needs Less than the diameter of tubular threading protectors air vent to be installed, there is locating ring 3 in shank stage casing, and the diameter of locating ring 3 is more than ventilation Bore dia；The diameter of connection-peg 2 of back-off need to be more than the diameter of tubular threading protectors air vent, to prevent fixed petroleum steel pipe RFID device is deviate from；The good RFID chip of the enclosed inside of RFID anti-shieldings label 4 and respective antenna, form fixed stone Oily steel pipe RFID device is overall；This fixed petroleum steel pipe RFID device is due to using general grafting Bar, conveniently apply on the tubing of a variety of different bores, RFID anti-shieldings label 4 is located at sky in mouth of pipe threading protectors after installation Center；It is minimum due to being acted on by metallic shield, therefore discrimination greatly improves, and the fixed petroleum steel pipe RFID Device transports in tubing, not easily damaged in cargo handling process, improves the stability of operation system；

Packing list unit includes packing list generation export and maintenance module, the generation of packaging packing list exports and maintenance module, spare part vanning are looked into Ask module, shipping list generation export module；

Packing list generation export and maintenance module determine packing list essential information first, when then each chest of selection operation field is cased The collection file of pick-up slip code composition, selects the parts in packing list, imported into shipping subsystem and generates packing list；After generation Packing list all retains historical record, inquiry, modification, deletes, export packing list；Packaging packing list generation export and maintenance module determine packaging Packing list essential information, then selection belong to all packing lists of the packaging packing list, the packing list spanning set packing slip of batch modification selection, Finally merge the quantity of the identical parts in same packaging packing list；Spare part case enquiry module by project-》Contract batch-》 Delivery lot-》Container number-》Case number (CN)-》The level of spare part list directly inputs rig model, P/N or foreign trade sequence The position of some parts of number fast positioning；Shipping list generation export module generation shipping flow in required for rig type Number for unit generate list；

Data publication unit is after the completion of work is shipped, and project information and packing list, delivery schedule are distributed to rig parts Internet of Things B/S general headquarters system, to accomplish data syn-chronization；If scene does not have network condition, related data is exported, Ran Houfa It is sent to specified mailbox；

Overseas scene handing-over subsystem includes data receipt unit and handover process unit；

The data receipt unit at overseas scene receives the Shipping information of basic database subsystem issue；

Handover process unit includes：Shipping information display module, project maintenance module, parts vanning enquiry module, goods core To module, goods loss Registration Module, hand-off state setup module, result of receiving export module, goods handing-over situation statistics mould Block, shipping and receiving status inquiry module and handing-over information issuing module；

Shipping information display module by " project-》Contract batch-》Delivery lot-》Container number-》The hierarchical structure of Order No. " It is shown, while is checked, exports the operation of packaging packing list information；Project maintenance module by " project-》Contract batch-》Hair Goods batch-》Container number-》The hierarchical structure of Order No. " is shown maintenance；Parts vanning enquiry module quickly searches certain Position where individual parts, and Query Result is exported and printed；If come off in addition, checking out existing abrasion in transportation acceptance of the bid Situation, check label and print again；Goods verification module takes scanning element cargo interests formula, by packaging packing list or packing list and scanning The consignment sheet of generation is contrasted in the form of man-to-man, if it find that different then shown with obvious mark, is compared simultaneously Statistical information；Goods loss Registration Module selectes container or iron sheet case, checks registered goods loss situation, is looked for by inquiry To the parts to be registered, input loss quantity, loss reason are registered；Hand-off state setup module is with iron sheet case, packaging Case, delivery lot are unit, set handing-over completion and unfinished two states；Result of receiving export module is to having completed handing-over Iron sheet case and container export result of receiving, and are then sent to storage subsystem, the result of receiving is imported in subsystem of storing in a warehouse, Complete in-stockroom operation；Goods joins situation statistical module to joining corresponding to delivery every time, provides statistics in real time, it is total to provide goods Quantity, the situation of checking over goods completed, completed all defect parts situations registered in check over goods situation and handshaking；Receive Status inquiry module of delivering carries out query statistic by rig model, and shipment data and foreign trade contract are contrasted, statistics transmitting-receiving Goods situation；Join information issuing module after the completion of goods handing-over, export handing-over information corresponding to this delivery, be sent to rig Parts Internet of Things B/S general headquarters system, rig parts Internet of Things B/S general headquarters system are imported into system again, to joining information Handled, whether arrangement carries out supplement delivery；

Storage subsystem mainly includes：Stock-keeping unit, be put in storage unit, go out library unit, delivery indicating member, in-transit management unit, Data publication unit；Realize rig parts from storage, outbound, allot, kinds of goods logistics of making an inventory carry out overall process tracking；Support Bar code and single product code management, by the kinds of goods bar code scan of the unique sequence numbers of outbound shipment data, for the tracking pipe of kinds of goods Reason provides important foundation；

Rig parts Internet of Things B/S general headquarters system includes：Basic database, daily inquiry quotation unit, purchasing management unit, hair Transportation unit, scene handing-over administrative unit, warehousing management unit and System Management Unit and display screen；Rig parts Internet of Things B/ S general headquarters system collects the subsystem data of each operation field, while also gives the subsystem needed by general headquarters' system issue data, Whole system is the system of closed loop, it is common complete rig parts from asking quotation, buying, shipping, logistics, be handover to storage Total system operation.