CN104574026A - Head office system for integrated system of the Internet of things for drilling machine parts - Google Patents

Head office system for integrated system of the Internet of things for drilling machine parts Download PDF

Info

Publication number
CN104574026A
CN104574026A CN201510034107.2A CN201510034107A CN104574026A CN 104574026 A CN104574026 A CN 104574026A CN 201510034107 A CN201510034107 A CN 201510034107A CN 104574026 A CN104574026 A CN 104574026A
Authority
CN
China
Prior art keywords
module
information
parts
shipping
rig
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
Application number
CN201510034107.2A
Other languages
Chinese (zh)
Inventor
田永生
姜华
刘峰
宋允
王立超
梁凯
郑晨
王瑞瑛
钟安武
杨进
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Petroleum Technology and Development Corp
Original Assignee
China Petroleum Technology and Development Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by China Petroleum Technology and Development Corp filed Critical China Petroleum Technology and Development Corp
Priority to CN201510034107.2A priority Critical patent/CN104574026A/en
Publication of CN104574026A publication Critical patent/CN104574026A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/083Shipping
    • G06Q10/0831Overseas transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0611Request for offers or quotes

Landscapes

  • Business, Economics & Management (AREA)
  • Economics (AREA)
  • Engineering & Computer Science (AREA)
  • General Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • Finance (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses an integrated system of the Internet of things for drilling machine parts and parts composing the integrated system of the Internet of things. The integrated system of the Internet of things comprises five C/S subsystems, namely a basic database subsystem, an oversea enquiry subsystem, a forwarding subsystem, an overseas on-site handover subsystem and a storage subsystem, and a B/S main system of the Internet of things for the drilling machine parts. A logistics integrated system is composed of the five C/S subsystems and the B/S main system, an efficient measure for data importing, maintaining, inquiring and statistical managing is provided, and a powerful basis for subsequent manufacturing, decision making and long term planning is provided. Accordingly, an efficient and rapid modernized information communication channel is established.

Description

A kind of general headquarters' system of rig parts Internet of Things integral system
Technical field
The invention belongs to rig parts Internet of things system field, particularly relate to a kind of general headquarters' system of rig parts Internet of Things integral system.
Background technology
Along with the growth of corporate business, the diversified development of rig type, and the different geology in international market, reservoir condition customization rig parts demand is got more and more;
But existing rig components supplying system response speed is slow, technical clarify spended time is long, duplication of labour time and effort consuming; The on-the-spot transition issue of rig parts is many, user complain many, directly affect company's production efficiency and business growth.
And the Integrated Logistics system of other industry is all the shipping of standard component, hoc scenario is simple, can not meet the customization of rig parts, diversified feature.
Therefore, set up comprehensive rig parts basic database, the flow integrated system of constituent, for data importing, maintenance, inquiry, statistical management provide efficient means, and provide strong foundation for subsequent production decision-making and longterm planning; Set up efficiently, the channel of modernization information communication efficiently, facilitate between intra-company, overseas administrative body, manufacturer, user effective, link up in time; Promoting rig inbound logistics automatization level energetically, conscientiously solve the various problems run in real work, is the only way of improving development of company core competitiveness, promoting corporate business fast development.
Summary of the invention
The invention provides a kind of general headquarters' system of rig parts Internet of Things integral system, rig parts Internet of Things integral system comprises: basic database subsystem, abroad to inquire the price subsystem, shipping subsystem, overseas on-the-spot handing-over subsystem, storage subsystem five C/S subsystems 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 in the basic data import system such as all kinds of rig parts atlas, rig information, Shipping information for original numerous and disorderly complexity, carry out standardized administration, and reduced data can be distributed to other each systems as data source.
System advantage:
1. one-touch importing rig summary sheet, rig handbook and all kinds of Back ground Information, easy to operate;
2. manage by rig model-> rig sequence number-> rig catalogue tertiary level, be equal to visual rig parts handbook, be convenient to browse;
3. support diversified inquiry parts mode: fuzzy query and the catalogue form by similar rig handbook check parts;
4. can simultaneously display unit and corresponding component distribution picture, intuitively, convenient operation;
5. support that multilingual catalogue handbook imports and browses;
6. classification control of authority, operation log recording
Basic database subsystem comprises: basic data imports unit, basic data maintenance unit, basic data release unit, System Management Unit, help unit.
Basic data importing unit mainly comprises rig numbering summary sheet and imports module, rig parts handbook importing module, rig parts handbook Shipping information importing module, supplier information importing module, overseas customer's information importing module.Rig parts handbook imports module by rig parts handbook data import system, supports that the handbook batch of Chinese, English, Spanish, Russian four kinds of language imports.In importing process, check the form of guidance document, the guidance document not meeting specification is pointed out.After importing, eject and import result statistical information.After importing, can check and derive and read result.Rig parts handbook imports module and imports the detailed data of rig parts through arranging, comprises the detail list of parts and subassembly at the location map of father's parts and other component diagram sheets.Rig parts handbook Shipping information imports module and realizes, for the importing of Shipping information and management, comprising project, contract batch, delivery schedule and affiliated spare part information.
Basic data maintenance unit mainly comprises rig numbering summary sheet maintenance module, rig parts handbook enquiry module, rig parts handbook maintenance module, supplier information maintenance module, overseas customer's maintenance of information module.
In actual applications, run into the situation that the rig numbering summary table data of importing is wrong sometimes, so need rig numbering summary sheet maintenance module to modify to the data imported, to keep the accurate of data and consistance.
Rig parts handbook enquiry module, after having imported rig manual information, is directly checked rig manual information, is found corresponding manual information by multiple querying condition in system.
Rig parts handbook maintenance module is in the inaccurate situation of rig parts handbook data imported, and the manual data to mistake are modified in systems in which, deletes, also manually can increase some parts handbook datas.
Supplier information maintenance module mainly manages the information of supplier.
Overseas customer's maintenance of information module manages overseas customer's information.
Basic data release unit mainly comprises rig numbering summary sheet release module, rig parts handbook release module, Shipping information release module, supplier information derives module, overseas subscriber information derives module.
Rig numbering summary sheet release module gives the rig numbering summary sheet Information issued in import system the supplier or client that need.
Rig parts handbook data is distributed to supplier or the client of needs by rig parts handbook release module.
System Management Unit mainly comprises password amendment, subscriber information management, System Operation Log.
Unit is helped mainly to comprise about native system, instructions to the user, frequently asked questions and corresponding answer
For the ease of joining the use of scene, warehouse, operation field, rig parts Internet of Things integral system also supports rig parts handbook to derive, and be stored into rig parts handbook terminal device, for scene handing-over personnel, warehousing management personnel and equipment construction personnel at any time.Rig parts handbook terminal mainly comprises: components information memory module, display module, parts handbook enquiry module, parts handbook update module, parts handbook maintenance module.Wherein:
Components information memory module realizes rig components information and imports to rig parts handbook terminal from basic database subsystem, closes the data lock of components information memory module, realizes data read-only, can not be exported or change.Display module carries out processing process to components information, shows in modes such as picture, form, animation simulations.Parts handbook enquiry module arranges querying condition and inquires about, and can check the information of any parts in system, provide intelligent reminding simultaneously, recommend the selective contrast of similar components information.Parts handbook update module, by the data line interconnection network of handbook terminal, by safety verification, realizes handbook data and upgrades.Parts handbook maintenance module marks the mistake found in use procedure, invalid information, automatically submits to basic database subsystem when Data Update, but itself can not increase newly data, revise, delete, the operation such as derivation.
Overseas inquiry subsystem
Overseas inquiry subsystem is intended to the problem that quick solution overseas subscriber runs in inquiry link, simplifies inquiry operating process, effectively avoids back and forth wasting time and energy of technical clarify, improve accuracy and the promptness of follow-up supply.
System advantage:
1. the packet of one-touch importing parts basic database issue, easy to operate;
2. rig parts handbook is intuitively shown, synchronous with papery handbook, reference convenient;
3. much information search method, fast and easy can search information needed data, and navigate to the position of parts place handbook;
4. imitate the generation of the functional realiey inquiry sheet of shopping cart, simple to operate;
5. can browse history inquiry sheet, and a history inquiry sheet can be copied as current inquiry sheet, eliminate the work reselecting parts;
6. the inquiry sheet of generation can be derived, also mail can be directly sent to appointment mailbox as annex.
7. classification control of authority, every category information can arrange different administration authorities and read authority;
8. operation log recording, each operation of the involved business personnel of record.
Overseas inquiry subsystem mainly comprises: rig components information unit, inquiry sheet unit, data publication unit.
Rig components information unit comprises rig components information receiver 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 receiver module receives the packet of being derived by basic database subsystem, according to rig sequence number, under being placed on corresponding directory tree rig sequence number.After rig parts handbook imports, inquiry can be carried out to rig parts and select.The data received comprise: rig numbering summary sheet, rig parts handbook, rig parts shipping list.
Rig parts handbook maintenance module is shown according to tree structure the parts handbook imported, and demonstrates details and pictorial information; Search parts.The parts found are put into the parts list of inquiry sheet, and deletion, continuation interpolation parts can be performed, empty parts list operation parts list.
Rig parts handbook enquiry module, by arranging querying condition inquiry parts, shows Query Result in lists, the picture that display unit is relevant, by inquiry, conveniently finds the parts of needs, adds parts to current inquiry sheet.
Supply of material inventory maintenance module display supply of material inventory, point rig model display, adds supply of material inventory parts in inquiry sheet list.
Supply of material inventory enquiry module presses delivery lot, rig model, query display shipping list parts, adds parts to current inquiry sheet.
Inquiry sheet unit comprises current inquiry sheet module, pending inquiry sheet module, history inquiry sheet module.
Current inquiry sheet module, after user adds parts, generates current inquiry sheet.Can safeguard current inquiry sheet parts list in current interface, components information can be revised, remove parts, empty list, also can return and continue to add parts, inquiry sheet information solicitation interface is jumped to after editor, input inquiry sheet essential information, inquiry user profile, by inquiry user profile, terms of agreement, generate inquiry sheet.
The inquiry sheet of pending inquiry sheet module to " establishment " state can be revised, deletes, prints, send, and can check the inquiry sheet of " transmission " state, arrange state, printing, transmission.
The inquiry sheet of history inquiry sheet to be state be " completing " and " locking ".History inquiry sheet module is inquired about by setting model, shows Query Result in lists.To the inquiry sheet of " completing " state, can check, copy, delete, lock, derive, print, send E-mail, to the inquiry sheet of " locking " state, can check, copy, delete, unlock.
Data publication unit comprises rig parts handbook derives module, rig parts handbook renewal release module.
Rig parts handbook derives module when some information of handbook have amendment, and derive the db file that rig parts handbook is encryption, off-line sends to general headquarters to carry out upgrading to keep data consistent.
Rig parts handbook upgrades release module when some information of handbook have amendment, uploads the handbook annex after renewal, sends to general headquarters to upgrade by network, to keep data consistent by mail.
Shipping subsystem
Shipping subsystem is an important step of logistics management, is the important guarantee that logistics runs well.Shipping ADMINISTRATION SUBSYSTEM help shipping personnel complete the timely shipping process to goods, label bar code is introduced in this link, open by skill the bar code rule determined and carry out unique identification parts, and by bar code acquisition technique, automatically the various lists required for generating in systems in which, decrease the workload of shipping personnel, heighten work efficiency, ensure the accuracy of data.
System advantage:
1. manage by a project-> contract batch-> delivery lot tertiary level, be close to operation field;
2. automatically generate bar-code label by pre-defined rule, and support the single and bulk print function of label;
3. use collector collection vanning bar code and automatically generate packing list mode, greatly alleviating workload, increase work efficiency and accuracy;
4. can follow the tracks of the vanning situation of parts, very clear;
5. whether being complete by arranging delivery state, conveniently carrying out shipping management;
6. the shipping result of current delivery lot is distributed to headquarters server, the packet after issuing is encrypted, is compressed, safe and reliable;
7. much information search method, fast and easy can search information needed data;
8. classification control of authority, every category information can arrange different administration authorities and read authority;
9. operation log recording, each operation of the involved business personnel of record;
Shipping subsystem mainly comprises delivery schedule unit, label bar code unit, packing list unit, data publication unit.
Delivery schedule unit comprises: delivery schedule receiver module, shipping project management module, shipping spare part maintenance of information module, shipping spare part information check module.
Delivery schedule receiver module imports the delivery schedule from rig parts Internet of Things B/S general headquarters system, and performs the operation flow of shipping on this basis.Finally need delivery schedule to upgrade to issue, synchronous with what keep with rig parts Internet of Things B/S general headquarters system datas.
Shipping project management module is by project-> contract batch-> delivery lot+delivery schedule) tertiary level carries out shipping project management, can check on-the-spot shipping situation intuitively.By arranging current registration, system default carries out corresponding shipping business processing to current registration.Shipping spare part maintenance of information module, when mistake appears in the delivery schedule data imported, is modified to data, is deleted or increase new data.What shipping spare part information checked that module mainly checks is raw data, the delivery schedule namely imported.
Label bar code unit comprises label bar code and generates print module, label bar code maintenance module.
Label bar code generates print module by the generate rule bar code pre-established, and prints together with other information of parts, generating labels, above the external packing being attached to parts.Label bar code maintenance module retains print record, and the time-write interval, information on label, is convenient to later checking.
Label bar code is the exclusive identification code of rig parts.
General commodity bar code is generally made up of prefix part, manufacturer's code, commercial product code and check code.Prefix code in commodity bar code is used to identify the code of country, endowed power in International Article Numbering Association, as 00-09 represents the U.S., Canada, 45,49 Japan is represented, 69 represent China's Mainland, and 471 represent Taiwan, and 489 represent the Hong Kong Special Administrative Region; The article code tissue at every country or area is weighed in the tax of manufacturer's code, and China gives manufacturer's code by national article code center.Commercial product code is used to the code identifying commodity, and endowed power is exercised by production enterprise oneself, and manufacturing enterprise according to the rules condition oneself determines to use which arabic numeral for commodity bar code on which kind of commodity of oneself.Commodity bar code finally verifies the correctness of 1-12 digital code from left to right in commodity bar code with 1 bit check code.Commodity bar code refers to the mark be made up of one group of regularly arranged bar, sky and corresponding character thereof, in order to represent the symbol of certain merchandise news.Its discal patch is dark, empty is white, and the scanning for bar code reading facility is distinguished.Its corresponding character is made up of one group of arabic numeral, directly distinguish for people or by keyboard to computer input data.Empty and represented by corresponding character the information of this group bar is identical.
Drilling well parts due to itself diversity and customize trend, and the secret of the trade etc. itself comprised, general bar code can not be used, the special bar code of rig parts that its label bar code is made up of jointly hyte and end group on termination group, component information group, parts, wherein termination group is for recording process of exchange information; Component information group is for recording structural information and the customized information of rig parts; On parts, hyte is for recording rig parts position relationship in use; End group is for recording overseas handing-over information; Wherein, on termination group, component information group, parts, hyte and end group all use bar code or RFID code technology to carry out record.
Packing list unit comprises packing list generation derivation and maintenance module, container list generates derives and maintenance module, spare part vanning enquiry module, shipping list generation derivation module.
Packing list generates derivation and first maintenance module determines packing list essential information, and when then selecting each iron sheet case of operation field to case, the collection file of pick-up slip code composition, selects the parts in packing list, import in shipping subsystem and generate packing list.Packing list after generation all retains historical record, can inquire about, revises, deletes, derive packing list.Container list generates derives and maintenance module determination container list essential information, then selects all packing lists belonging to this container list, the packing list spanning set packing slip that batch modification is selected, finally merges the quantity of the identical parts in same container list.Spare part vanning enquiry module is by project-" contract batch-" delivery lot-" container number-" case number (CN)-" level of spare part list or the position of directly input rig model, P/N or certain parts of foreign trade sequence number quick position.Shipping list generates to derive and requiredly in CMOS macro cell shipping flow process in units of rig model, generates list.
Data publication unit is after shipping work completes, 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 can be derived, then be sent to appointment mailbox.
Overseas scene handing-over subsystem
Overseas scene handing-over subsystem can simplify the formality of rig parts scene handing-over, goes to identify spare part one by one, utilize bar code scanner technology and computer information technology without the need to professional person, greatly improves efficiency and the accuracy of on-the-spot handing-over.
System advantage:
1. support Chinese, western language, English three kinds of language;
2. manage by a project-> contract batch-> delivery lot tertiary level, be close to operation field
3. whether being complete by arranging hand-off state, conveniently carrying out handing-over management;
4. checking by carrying out scanning to arrival article, automatically carrying out goods and checking, the different colour code of discrepancy of quantity item;
5. tag code printing function, carries out benefit to loss label and signs;
6. delivery status inquiry statistical function is provided, contrasts with contract quantity, see and whether complete this procurement contract;
7. derive the various lists needed, conveniently carry out data summarization and statistics etc.
8. much information search method, fast and easy can search information needed data;
9. classification control of authority, operation log recording.
Overseas scene handing-over subsystem comprises data receipt unit and handing-over processing unit.
The data receipt unit at overseas scene receives the Shipping information of basic database subsystem issue,
Handing-over processing unit comprises: Shipping information display module, project maintenance module, parts vanning enquiry module, goods check module, goods loss Registration Module, hand-off state arranges module, result of receiving derives module, goods handing-over situation statistical module, shipping and receiving status inquiry module and handing-over information issuing module.
Shipping information display module is by project-" contract batch-" delivery lot-" container number-" hierarchical structure of Order No. shows, can carry out checking, deriving the operations such as container list information simultaneously.Project maintenance module is by project-" contract batch-" delivery lot-" container number-" hierarchical structure of Order No. carries out displaying and safeguards.Parts vanning enquiry module can the position at certain parts place of fast finding, and Query Result can be derived and print.In addition, if check out in transportation acceptance of the bid the situation that existing wearing and tearing come off, label can be checked and again print.Goods is checked module and is taked analyzing spot cargo interests formula, is contrasted by the consignment sheet of container list or packing list and scanning generation with man-to-man form, if find difference, significantly to mark display, and the statistical information of comparison simultaneously.Goods loss Registration Module selectes container or iron sheet case, checks registered goods loss situation, and find by inquiry the parts that will register, input loss quantity, loss reason are registered.Hand-off state arranges module in units of iron sheet case, container, delivery lot, arranges handing-over and completes and do not complete two states.Result of receiving derives module and derives to the iron sheet case and container that complete handing-over result of receiving, and then sends to storage subsystem, imports this result of receiving, complete in-stockroom operation in storage subsystem.The handing-over that goods handing-over situation statistical module is corresponding to each delivery, provides statistics in real time, provides total items amount, completes the situation of checking over goods, do not complete all defect parts situations registered in the situation of checking over goods and handshaking.Shipping and receiving status inquiry module carries out query statistic by rig model, shipment data and foreign trade contract is contrasted, statistics shipping and receiving situation.Handing-over information issuing module is after goods has joined, derive the handing-over information that this delivery is corresponding, send to rig parts Internet of Things B/S general headquarters system, rig parts Internet of Things B/S general headquarters system imports in system again, handing-over information is processed, arranges whether to carry out supplementing delivery etc.
Material fluid recognition hand-held set be used in overseas in on-the-spot handshaking to operations such as the tag control of rig parts, identification, location and spot checks.Mainly comprise: tag control unit, product spot check unit and data synchronisation unit.
Before tag control unit is used for overseas on-the-spot handing-over, electronic tag installed to rig parts or use hand-held set electronic tag to be checked to the operation of functions such as searching, comprising: label is enabled module, mended and sign module, tag recognition module, rig position components module.Label is enabled module and product information is write label, sets up the incidence relation of label and rig parts; Mending and signing module is the situation preventing product from tag misses or damage occurring in shipping process, mends sign rig parts; Tag recognition module, by scanning label, can see the rig components information associated by label, the convenient quick identification to rig parts; Rig position components module locates specific rig parts by input inquiry parameter scanning.
Register and spot check operation rig parts when product spot check unit is mainly used in overseas on-the-spot handing-over, comprise Registration Module and spot check module, Registration Module is registered before the handing-over of rig parts; The situation of spot check module check product quantity and Product labelling, carries out benefits and signs operation when lacking or damage, spot check generation inventory can automatically and shipping inventory compare, and provide comparison result.
Data synchronisation unit mainly cell phone and shipping subsystem carries out data interaction, comprises download basic data module, downloads attribute information module, uploads binding information module and upload spot check checklist module.Download basic data module for downloading the basic data of rig parts underlying attribute code table, thus hand-held set is not before importing any product information, by reading tag, also can aid identification product.The shipping rig components information downloading the supplier that shipping subsystem is derived by attribute information module imports in hand-held set.Upload binding information module and the binding information of product and label is uploaded to shipping subsystem; Upload spot check checklist module and the rig parts inventory generated during spot check is uploaded to shipping subsystem, be convenient to generate corresponding document.
Storage subsystem
Storage subsystem mainly realize rig parts from warehouse-in, outbound, allot, tracking that overall process is carried out in the kinds of goods logistics such as to make an inventory, effective management is provided.Support bar code and the management of single product code, by the kinds of goods bar code scan of the unique sequence numbers of outbound shipment data, the tracing management for kinds of goods provides important foundation, promotes management level and the warehouse logistics Link Efficiency of kinds of goods further.
System advantage:
1. what the mode record by putting registration and outbound registration in storage was each goes out to put record in storage;
2. adopt scanning warehouse-in and import handing-over packet two kinds of mode batch warehouse-ins, also support manually warehouse-in, flexibly and easily simultaneously;
3. adopt scanning outbound and manually select outbound two kinds of modes to generate outbound list, meet practical operation business demand;
4. perfect stock control function is provided, comprises inquiring stock maintenance, stock-taking, stock's warning, monthly stock control, fill rat report etc.;
5. can follow the tracks of kinds of goods in transit;
6. derive the form of various needs, as storage bill, outbound list, stock report etc.;
7. much information search method, fast and easy can search information needed data;
8. by current stock's Information issued to headquarters server, to issue after packet be encrypted, compress, safe and reliable;
9. the online packet sending issue, if there is network condition, can directly by Packet Generation email;
10. classification control of authority, every category information can arrange different administration authorities and read authority;
11. operation log recordings, each operation of the involved business personnel of record.
Storage subsystem mainly comprises: stock-keeping unit, put unit in storage, go out library unit, delivery indicating member, in-transit management unit, data publication unit.
Stock-keeping unit comprises: make an inventory module, parts of inquiring stock maintenance module, stockpile number are come in and gone 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 is understood Current Library and is deposited situation, carries out the essential information changing parts as required, mends and sign, arrange the corresponding operatings such as alarm limit, complete the maintenance to parts such as stocks.Stockpile number makes an inventory module first by the bar code of parts in collector scanning warehouse, select in systems in which to gather file, automatically the data in the data of collection file and database are compared, and go out firm offer quantity and the discrepant item of book data with different color markings, complete the operation of making an inventory.Parts come in and go out library inquiry module by arranging querying condition, inquire about a certain or some parts go out to put details in storage, comprise operator, outbound date, outbound quantity, warehouse-in date, warehousing quantity etc.Stock's alarm module is by arranging parts essential information, current stock, stock's upper limit, stock's lower limit, upper limit alarm, lower limit warning, and timing judges the warehouse compartment situation of parts, once exceed bound, provide alarm.Monthly inventory management module adds up warehousing quantity, the outbound quantity in various parts this month, generates monthly stock control table.The inventories in stock report query statistic module added up certain warehouse in certain year each month, and with comparing the previous year, draw chain rate amplification and chain rate speedup.Carry out Data Comparison, analysis according to report, calculate fill rat by following formula.
Fill rat=actual outbound quantity/parts plan outbound quantity * 100%
Warehouse-in unit comprises: newly-built warehouse-in Registration Module, warehouse-in logging modle, parts warehouse-in enquiry module.
Newly-built warehouse-in Registration Module is registered warehouse-in parts, and to register title, operator, warehouse-in date three determine a unique registration.Warehouse-in logging modle record is registered and each corresponding storage bill generated at every turn, and user carries out checking, derive or carry out some relevant operations in this module.Parts warehouse-in enquiry module can be inquired about by parts rig model, P/N, title, specifications and models, general rig, initial sum termination time, or according to barcode inquiry, determines warehouse situation.
Go out library unit to comprise: newly-built outbound Registration Module, outbound logging modle, parts outbound enquiry module.
Newly-built outbound Registration Module is registered outbound parts, and to register title, operator, outbound date three determine a unique registration.Outbound logging modle record is registered and each corresponding outbound list generated at every turn, and user carries out checking, derive or carry out some relevant operations in this module.Parts outbound enquiry module can be inquired about by parts rig model, P/N, title, specifications and models, general rig, initial sum termination time, or according to barcode inquiry, determines outbound situation.
Delivery indicating member comprises: newly-built delivery instruction sheet module, delivery instruction sheet logging modle;
The newly-built delivery instruction sheet registration of newly-built delivery instruction sheet module, generates delivery instruction sheet by registration.Delivery instruction sheet logging modle record is registered and each corresponding delivery instruction sheet generated at every turn, safeguards register information and delivery instruction sheet.
In-transit management unit comprises: newly-built Registration Module in transit, in-transit management module;
Newly-built Registration Module in transit, to the newly-built registration of parts in transit, by registration management components information in transit, records parts in transit, follows the tracks of logistics information.The registration in transit that in-transit management module record generates at every turn and parts information in transit, safeguard register information and components information in transit.
Data publication unit arranges addressee, the people that makes a copy for, theme, carry out inventory data issue.
Storage identifies that hand-held set is used in warehousing management operations such as the tag control of rig parts, identification, location and spot checks.Mainly comprise: tag control unit, product spot check unit and data synchronisation unit.
Tag control unit is installed electronic tag for the production of factory to the rig parts that will dispatch from the factory or is used hand-held set electronic tag to be checked to the operation of functions such as searching, comprising: label is enabled module, mended and sign module, tag recognition module, rig position components module.Label is enabled module and product information is write label, sets up the incidence relation of label and rig parts; Mend sign module be prevent product in storing process and transport harbour to process in there is the situation of tag misses or damage, rig parts are mended and sign; Tag recognition module, by scanning label, can see the rig components information associated by label, the convenient quick identification to rig parts; Rig position components module locates specific rig parts by input inquiry parameter scanning.
Rig parts are mail to the operation of carrier of customs by product spot check unit mainly for the production of factory, registration spot check when comprising registration spot check when dispatching from the factory and pay.Comprise Registration Module and spot check module, Registration Module carries out when rig parts dispatch from the factory registration of dispatching from the factory; Carry out payment registration when rig parts being consigned to logistics department, both persons's information is paid in registration simultaneously; The situation of spot check module check product quantity and Product labelling, carries out benefits and signs operation when lacking or damage, spot check generation inventory can automatically and shipping inventory compare, and provide comparison result.
Data synchronisation unit mainly cell phone and shipping subsystem carries out data interaction, comprises download basic data module, downloads attribute information module, uploads binding information module and upload spot check checklist module.Download basic data module for downloading the basic data of rig parts underlying attribute code table, thus hand-held set is not before importing any product information, by reading tag, also can aid identification product.The shipping rig components information downloading the supplier that shipping subsystem is derived by attribute information module imports in hand-held set.Upload binding information module and the binding information of product and label is uploaded to shipping subsystem; Upload spot check checklist module and the rig parts inventory generated during spot check is uploaded to shipping subsystem, be convenient to generate corresponding document.
Rig parts Internet of Things B/S general headquarters system
Rig parts Internet of Things B/S general headquarters system comprises: basic database, daily inquiry quotation unit, purchasing management unit, shipping unit, on-the-spot handing-over administrative unit, warehousing management unit and System Management Unit and display screen.Basic database comprise store comprise rig numbering summary sheet, rig parts handbook rig parts database and comprise the personal information database of support personnel's information, customer information and business personnel's information.
Daily inquiry price list head first carries out inquiry quotation registration, then receives the inquiry sheet that overseas inquiry subsystem generates and processes, decompose afterwards, generate multiple domestic inquiry sheet after decomposing by producer's title, and issues corresponding supplier and inquire the price.Typing quotation information in systems in which after supplier's quotation, generates to the price list of business personnel finally by rate of exchange option program.
Purchasing management unit mainly comprises non-conformance report processing module.Non-conformance report processing module mainly overseas subscriber forms non-conformance report feedback problematic parts document, then these parts are decomposed to form site problems feedback by supplier and issue each supplier, supplier confirms the parts in site problems feedback, processes parts according to confirmation situation.
Shipping unit comprises Shipping information receiver module, Shipping information browses module and Shipping information search module, and Shipping information receiver module receives components information in the project information at each shipping scene after the ciphered compressed derived by shipping ADMINISTRATION SUBSYSTEM, container information, iron sheet case information and iron sheet case.Shipping information browses the shipping situation that module can see all items, and can add up separately the data of each node.Shipping information search module searches for the information of certain container, and can navigate to this container place shipping item destination node, directly just can check Shipping information.
Scene mainly joins in the data file import system of ADMINISTRATION SUBSYSTEM issue by on-the-spot handing-over administrative unit, checks Shipping information and handing-over information, statistical study handing-over result, and processes the parts of defect in handing-over.
Warehousing management unit comprises storage information importing module, storage information browses module.Storage information imports the inventory information that module imports each warehouse, automatically deletes the file of mistake simultaneously, and shows that this derives the statistics of stock.
Storage information is browsed module and is shown with the country one belongs to's title in all warehouses in the form of a list, the storage information in the different warehouses of import system is checked by display screen, show detail information and the history inventory information of single parts, show total inventory analysis curve map, browse storage information and the parts statistical information in each warehouse easily.
System Management Unit, comprises notification module, questionnaire administration module, system management module.Important information is notified user by notification module, mainly comprises notice and notices management, consults notice announcement function.Questionnaire administration module mainly in order to realize common survey function, and to be safeguarded questionnaire and statistical information is checked.System management module comprises and managing account, organizational structure, address list etc.
Accompanying drawing explanation
Fig. 1: rig parts Internet of things system figure
Embodiment
General headquarters' system of rig parts Internet of Things integral system, rig parts Internet of Things integral system comprises: basic database subsystem, abroad to inquire the price subsystem, shipping subsystem, overseas on-the-spot handing-over subsystem, storage subsystem five C/S subsystems and a rig parts Internet of Things B/S general headquarters system.Wherein:
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 in the basic data import system such as all kinds of rig parts atlas, rig information, Shipping information for original numerous and disorderly complexity, carry out standardized administration, and reduced data can be distributed to other each systems as data source.
Basic database subsystem comprises: basic data imports unit, basic data maintenance unit, basic data release unit, System Management Unit, help unit.
Basic data importing unit mainly comprises rig numbering summary sheet and imports module, rig parts handbook importing module, rig parts handbook Shipping information importing module, supplier information importing module, overseas customer's information importing module.Rig parts handbook imports module by rig parts handbook data import system, supports that the handbook batch of Chinese, English, Spanish, Russian four kinds of language imports.In importing process, check the form of guidance document, the guidance document not meeting specification is pointed out.After importing, eject and import result statistical information.After importing, can check and derive and read result.Rig parts handbook imports module and imports the detailed data of rig parts through arranging, comprises the detail list of parts and subassembly at the location map of father's parts and other component diagram sheets.Rig parts handbook Shipping information imports module and realizes, for the importing of Shipping information and management, comprising project, contract batch, delivery schedule and affiliated spare part information.
Basic data maintenance unit mainly comprises rig numbering summary sheet maintenance module, rig parts handbook enquiry module, rig parts handbook maintenance module, supplier information maintenance module, overseas customer's maintenance of information module.
In actual applications, run into the situation that the rig numbering summary table data of importing is wrong sometimes, so need rig numbering summary sheet maintenance module to modify to the data imported, to keep the accurate of data and consistance.
Rig parts handbook enquiry module, after having imported rig manual information, is directly checked rig manual information, is found corresponding manual information by multiple querying condition in system.
Rig parts handbook maintenance module is in the inaccurate situation of rig parts handbook data imported, and the manual data to mistake are modified in systems in which, deletes, also manually can increase some parts handbook datas.
Supplier information maintenance module mainly manages the information of supplier.
Overseas customer's maintenance of information module manages overseas customer's information.
Basic data release unit mainly comprises rig numbering summary sheet release module, rig parts handbook release module, Shipping information release module, supplier information derives module, overseas subscriber information derives module.
Rig numbering summary sheet release module gives the rig numbering summary sheet Information issued in import system the supplier or client that need.
Rig parts handbook data is distributed to supplier or the client of needs by rig parts handbook release module.
System Management Unit mainly comprises password amendment, subscriber information management, System Operation Log.
Unit is helped mainly to comprise about native system, instructions to the user, frequently asked questions and corresponding answer;
For the ease of joining the use of scene, warehouse, operation field, rig parts Internet of Things integral system also supports rig parts handbook to derive, and be stored into rig parts handbook terminal device, for scene handing-over personnel, warehousing management personnel and equipment construction personnel at any time.Rig parts handbook terminal mainly comprises: components information memory module, display module, parts handbook enquiry module, parts handbook update module, parts handbook maintenance module.Wherein:
Components information memory module realizes rig components information and imports to rig parts handbook terminal from basic database subsystem, closes the data lock of components information memory module, realizes data read-only, can not be exported or change.Display module carries out processing process to components information, shows in modes such as picture, form, animation simulations.Parts handbook enquiry module arranges querying condition and inquires about, and can check the information of any parts in system, provide intelligent reminding simultaneously, recommend the selective contrast of similar components information.Parts handbook update module, by the data line interconnection network of handbook terminal, by safety verification, realizes handbook data and upgrades.Parts handbook maintenance module marks the mistake found in use procedure, invalid information, automatically submits to basic database subsystem when Data Update, but itself can not increase newly data, revise, delete, the operation such as derivation.
Overseas inquiry subsystem is intended to the problem that quick solution overseas subscriber runs in inquiry link, simplifies inquiry operating process, effectively avoids back and forth wasting time and energy of technical clarify, improve accuracy and the promptness of follow-up supply.
Overseas inquiry subsystem mainly comprises: rig components information unit, inquiry sheet unit, data publication unit.
Rig components information unit comprises rig components information receiver 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 receiver module receives the packet of being derived by basic database subsystem, according to rig sequence number, under being placed on corresponding directory tree rig sequence number.After rig parts handbook imports, inquiry can be carried out to rig parts and select.The data received comprise: rig numbering summary sheet, rig parts handbook, rig parts shipping list.
Rig parts handbook maintenance module is shown according to tree structure the parts handbook imported, and demonstrates details and pictorial information; Search parts.The parts found are put into the parts list of inquiry sheet, and deletion, continuation interpolation parts can be performed, empty parts list operation parts list.
Rig parts handbook enquiry module, by arranging querying condition inquiry parts, shows Query Result in lists, the picture that display unit is relevant, by inquiry, conveniently finds the parts of needs, adds parts to current inquiry sheet.
Supply of material inventory maintenance module display supply of material inventory, point rig model display, adds supply of material inventory parts in inquiry sheet list.
Supply of material inventory enquiry module presses delivery lot, rig model, query display shipping list parts, adds parts to current inquiry sheet.
Inquiry sheet unit comprises current inquiry sheet module, pending inquiry sheet module, history inquiry sheet module.
Current inquiry sheet module, after user adds parts, generates current inquiry sheet.Can safeguard current inquiry sheet parts list in current interface, components information can be revised, remove parts, empty list, also can return and continue to add parts, inquiry sheet information solicitation interface is jumped to after editor, input inquiry sheet essential information, inquiry user profile, by inquiry user profile, terms of agreement, generate inquiry sheet.
The inquiry sheet of pending inquiry sheet module to " establishment " state can be revised, deletes, prints, send, and can check the inquiry sheet of " transmission " state, arrange state, printing, transmission.
The inquiry sheet of history inquiry sheet to be state be " completing " and " locking ".History inquiry sheet module is inquired about by setting model, shows Query Result in lists.To the inquiry sheet of " completing " state, can check, copy, delete, lock, derive, print, send E-mail, to the inquiry sheet of " locking " state, can check, copy, delete, unlock.
Data publication unit comprises rig parts handbook derives module, rig parts handbook renewal release module.
Rig parts handbook derives module when some information of handbook have amendment, and derive the db file that rig parts handbook is encryption, off-line sends to general headquarters to carry out upgrading to keep data consistent.
Rig parts handbook upgrades release module when some information of handbook have amendment, uploads the handbook annex after renewal, sends to general headquarters to upgrade by network, to keep data consistent by mail.
Shipping subsystem is an important step of logistics management, is the important guarantee that logistics runs well.Shipping ADMINISTRATION SUBSYSTEM help shipping personnel complete the timely shipping process to goods, label bar code is introduced in this link, open by skill the bar code rule determined and carry out unique identification parts, and by bar code acquisition technique, automatically the various lists required for generating in systems in which, decrease the workload of shipping personnel, heighten work efficiency, ensure the accuracy of data.
Shipping subsystem mainly comprises delivery schedule unit, label bar code unit, packing list unit, data publication unit.
Delivery schedule unit comprises: delivery schedule receiver module, shipping project management module, shipping spare part maintenance of information module, shipping spare part information check module.
Delivery schedule receiver module imports the delivery schedule from rig parts Internet of Things B/S general headquarters system, and performs the operation flow of shipping on this basis.Finally need delivery schedule to upgrade to issue, synchronous with what keep with rig parts Internet of Things B/S general headquarters system datas.
Shipping project management module is by project-> contract batch-> delivery lot+delivery schedule) tertiary level carries out shipping project management, can check on-the-spot shipping situation intuitively.By arranging current registration, system default carries out corresponding shipping business processing to current registration.Shipping spare part maintenance of information module, when mistake appears in the delivery schedule data imported, is modified to data, is deleted or increase new data.What shipping spare part information checked that module mainly checks is raw data, the delivery schedule namely imported.
Label bar code unit comprises label bar code and generates print module, label bar code maintenance module.
Label bar code generates print module by the generate rule bar code pre-established, and prints together with other information of parts, generating labels, above the external packing being attached to parts.Label bar code maintenance module retains print record, and the time-write interval, information on label, is convenient to later checking.
Label bar code is the exclusive identification code of rig parts.General commodity bar code is generally made up of prefix part, manufacturer's code, commercial product code and check code.Prefix code in commodity bar code is used to identify the code of country, endowed power in International Article Numbering Association, as 00-09 represents the U.S., Canada, 45,49 Japan is represented, 69 represent China's Mainland, and 471 represent Taiwan, and 489 represent the Hong Kong Special Administrative Region; The article code tissue at every country or area is weighed in the tax of manufacturer's code, and China gives manufacturer's code by national article code center.Commercial product code is used to the code identifying commodity, and endowed power is exercised by production enterprise oneself, and manufacturing enterprise according to the rules condition oneself determines to use which arabic numeral for commodity bar code on which kind of commodity of oneself.Commodity bar code finally verifies the correctness of 1-12 digital code from left to right in commodity bar code with 1 bit check code.Commodity bar code refers to the mark be made up of one group of regularly arranged bar, sky and corresponding character thereof, in order to represent the symbol of certain merchandise news.Its discal patch is dark, empty is white, and the scanning for bar code reading facility is distinguished.Its corresponding character is made up of one group of arabic numeral, directly distinguish for people or by keyboard to computer input data.Empty and represented by corresponding character the information of this group bar is identical.
Drilling well parts due to itself diversity and customize trend, and the secret of the trade etc. itself comprised, general bar code can not be used, the special bar code of rig parts that its label bar code is made up of jointly hyte and end group on termination group, component information group, parts, wherein termination group is for recording process of exchange information; Component information group is for recording structural information and the customized information of rig parts; On parts, hyte is for recording rig parts position relationship in use; End group is for recording overseas handing-over information; Wherein, on termination group, component information group, parts, hyte and end group all use bar code or RFID code technology to carry out record.
Packing list unit comprises packing list generation derivation and maintenance module, container list generates derives and maintenance module, spare part vanning enquiry module, shipping list generation derivation module.
Packing list generates derivation and first maintenance module determines packing list essential information, and when then selecting each iron sheet case of operation field to case, the collection file of pick-up slip code composition, selects the parts in packing list, import in shipping subsystem and generate packing list.Packing list after generation all retains historical record, can inquire about, revises, deletes, derive packing list.Container list generates derives and maintenance module determination container list essential information, then selects all packing lists belonging to this container list, the packing list spanning set packing slip that batch modification is selected, finally merges the quantity of the identical parts in same container list.Spare part vanning enquiry module is by project-" contract batch-" delivery lot-" container number-" case number (CN)-" level of spare part list or the position of directly input rig model, P/N or certain parts of foreign trade sequence number quick position.Shipping list generates to derive and requiredly in CMOS macro cell shipping flow process in units of rig model, generates list.
Data publication unit is after shipping work completes, 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 can be derived, then be sent to appointment mailbox.
Overseas scene handing-over subsystem can simplify the formality of rig parts scene handing-over, goes to identify spare part one by one, utilize bar code scanner technology and computer information technology without the need to professional person, greatly improves efficiency and the accuracy of on-the-spot handing-over.
Overseas scene handing-over subsystem comprises data receipt unit and handing-over processing unit.
The data receipt unit at overseas scene receives the Shipping information of basic database subsystem issue,
Handing-over processing unit comprises: Shipping information display module, project maintenance module, parts vanning enquiry module, goods check module, goods loss Registration Module, hand-off state arranges module, result of receiving derives module, goods handing-over situation statistical module, shipping and receiving status inquiry module and handing-over information issuing module.
Shipping information display module is by project-" contract batch-" delivery lot-" container number-" hierarchical structure of Order No. shows, can carry out checking, deriving the operations such as container list information simultaneously.Project maintenance module is by project-" contract batch-" delivery lot-" container number-" hierarchical structure of Order No. carries out displaying and safeguards.Parts vanning enquiry module can the position at certain parts place of fast finding, and Query Result can be derived and print.In addition, if check out in transportation acceptance of the bid the situation that existing wearing and tearing come off, label can be checked and again print.Goods is checked module and is taked analyzing spot cargo interests formula, is contrasted by the consignment sheet of container list or packing list and scanning generation with man-to-man form, if find difference, significantly to mark display, and the statistical information of comparison simultaneously.Goods loss Registration Module selectes container or iron sheet case, checks registered goods loss situation, and find by inquiry the parts that will register, input loss quantity, loss reason are registered.Hand-off state arranges module in units of iron sheet case, container, delivery lot, arranges handing-over and completes and do not complete two states.Result of receiving derives module and derives to the iron sheet case and container that complete handing-over result of receiving, and then sends to storage subsystem, imports this result of receiving, complete in-stockroom operation in storage subsystem.The handing-over that goods handing-over situation statistical module is corresponding to each delivery, provides statistics in real time, provides total items amount, completes the situation of checking over goods, do not complete all defect parts situations registered in the situation of checking over goods and handshaking.Shipping and receiving status inquiry module carries out query statistic by rig model, shipment data and foreign trade contract is contrasted, statistics shipping and receiving situation.Handing-over information issuing module is after goods has joined, derive the handing-over information that this delivery is corresponding, send to rig parts Internet of Things B/S general headquarters system, rig parts Internet of Things B/S general headquarters system imports in system again, handing-over information is processed, arranges whether to carry out supplementing delivery etc.
Material fluid recognition hand-held set be used in overseas in on-the-spot handshaking to operations such as the tag control of rig parts, identification, location and spot checks.Mainly comprise: tag control unit, product spot check unit and data synchronisation unit.
Before tag control unit is used for overseas on-the-spot handing-over, electronic tag installed to rig parts or use hand-held set electronic tag to be checked to the operation of functions such as searching, comprising: label is enabled module, mended and sign module, tag recognition module, rig position components module.Label is enabled module and product information is write label, sets up the incidence relation of label and rig parts; Mending and signing module is the situation preventing product from tag misses or damage occurring in shipping process, mends sign rig parts; Tag recognition module, by scanning label, can see the rig components information associated by label, the convenient quick identification to rig parts; Rig position components module locates specific rig parts by input inquiry parameter scanning.
Register and spot check operation rig parts when product spot check unit is mainly used in overseas on-the-spot handing-over, comprise Registration Module and spot check module, Registration Module is registered before the handing-over of rig parts; The situation of spot check module check product quantity and Product labelling, carries out benefits and signs operation when lacking or damage, spot check generation inventory can automatically and shipping inventory compare, and provide comparison result.
Data synchronisation unit mainly cell phone and shipping subsystem carries out data interaction, comprises download basic data module, downloads attribute information module, uploads binding information module and upload spot check checklist module.Download basic data module for downloading the basic data of rig parts underlying attribute code table, thus hand-held set is not before importing any product information, by reading tag, also can aid identification product.The shipping rig components information downloading the supplier that shipping subsystem is derived by attribute information module imports in hand-held set.Upload binding information module and the binding information of product and label is uploaded to shipping subsystem; Upload spot check checklist module and the rig parts inventory generated during spot check is uploaded to shipping subsystem, be convenient to generate corresponding document.
Storage subsystem mainly realize rig parts from warehouse-in, outbound, allot, tracking that overall process is carried out in the kinds of goods logistics such as to make an inventory, effective management is provided.Support bar code and the management of single product code, by the kinds of goods bar code scan of the unique sequence numbers of outbound shipment data, the tracing management for kinds of goods provides important foundation, promotes management level and the warehouse logistics Link Efficiency of kinds of goods further.
Storage subsystem mainly comprises: stock-keeping unit, put unit in storage, go out library unit, delivery indicating member, in-transit management unit, data publication unit.
Stock-keeping unit comprises: make an inventory module, parts of inquiring stock maintenance module, stockpile number are come in and gone 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 is understood Current Library and is deposited situation, carries out the essential information changing parts as required, mends and sign, arrange the corresponding operatings such as alarm limit, complete the maintenance to parts such as stocks.Stockpile number makes an inventory module first by the bar code of parts in collector scanning warehouse, select in systems in which to gather file, automatically the data in the data of collection file and database are compared, and go out firm offer quantity and the discrepant item of book data with different color markings, complete the operation of making an inventory.Parts come in and go out library inquiry module by arranging querying condition, inquire about a certain or some parts go out to put details in storage, comprise operator, outbound date, outbound quantity, warehouse-in date, warehousing quantity etc.Stock's alarm module is by arranging parts essential information, current stock, stock's upper limit, stock's lower limit, upper limit alarm, lower limit warning, and timing judges the warehouse compartment situation of parts, once exceed bound, provide alarm.Monthly inventory management module adds up warehousing quantity, the outbound quantity in various parts this month, generates monthly stock control table.The inventories in stock report query statistic module added up certain warehouse in certain year each month, and with comparing the previous year, draw chain rate amplification and chain rate speedup.Carry out Data Comparison, analysis according to report, calculate fill rat by following formula.
Fill rat=actual outbound quantity/parts plan outbound quantity * 100%
Warehouse-in unit comprises: newly-built warehouse-in Registration Module, warehouse-in logging modle, parts warehouse-in enquiry module.
Newly-built warehouse-in Registration Module is registered warehouse-in parts, and to register title, operator, warehouse-in date three determine a unique registration.Warehouse-in logging modle record is registered and each corresponding storage bill generated at every turn, and user carries out checking, derive or carry out some relevant operations in this module.Parts warehouse-in enquiry module can be inquired about by parts rig model, P/N, title, specifications and models, general rig, initial sum termination time, or according to barcode inquiry, determines warehouse situation.
Go out library unit to comprise: newly-built outbound Registration Module, outbound logging modle, parts outbound enquiry module.
Newly-built outbound Registration Module is registered outbound parts, and to register title, operator, outbound date three determine a unique registration.Outbound logging modle record is registered and each corresponding outbound list generated at every turn, and user carries out checking, derive or carry out some relevant operations in this module.Parts outbound enquiry module can be inquired about by parts rig model, P/N, title, specifications and models, general rig, initial sum termination time, or according to barcode inquiry, determines outbound situation.
Delivery indicating member comprises: newly-built delivery instruction sheet module, delivery instruction sheet logging modle
The newly-built delivery instruction sheet registration of newly-built delivery instruction sheet module, generates delivery instruction sheet by registration.Delivery instruction sheet logging modle record is registered and each corresponding delivery instruction sheet generated at every turn, safeguards register information and delivery instruction sheet.
In-transit management unit comprises: newly-built Registration Module in transit, in-transit management module
Newly-built Registration Module in transit, to the newly-built registration of parts in transit, by registration management components information in transit, records parts in transit, follows the tracks of logistics information.The registration in transit that in-transit management module record generates at every turn and parts information in transit, safeguard register information and components information in transit.
Data publication unit arranges addressee, the people that makes a copy for, theme, carry out inventory data issue.
Storage identifies that hand-held set is used in warehousing management operations such as the tag control of rig parts, identification, location and spot checks.Mainly comprise: tag control unit, product spot check unit and data synchronisation unit.
Tag control unit is installed electronic tag for the production of factory to the rig parts that will dispatch from the factory or is used hand-held set electronic tag to be checked to the operation of functions such as searching, comprising: label is enabled module, mended and sign module, tag recognition module, rig position components module.Label is enabled module and product information is write label, sets up the incidence relation of label and rig parts; Mend sign module be prevent product in storing process and transport harbour to process in there is the situation of tag misses or damage, rig parts are mended and sign; Tag recognition module, by scanning label, can see the rig components information associated by label, the convenient quick identification to rig parts; Rig position components module locates specific rig parts by input inquiry parameter scanning.
Rig parts are mail to the operation of carrier of customs by product spot check unit mainly for the production of factory, registration spot check when comprising registration spot check when dispatching from the factory and pay.Comprise Registration Module and spot check module, Registration Module carries out when rig parts dispatch from the factory registration of dispatching from the factory; Carry out payment registration when rig parts being consigned to logistics department, both persons's information is paid in registration simultaneously; The situation of spot check module check product quantity and Product labelling, carries out benefits and signs operation when lacking or damage, spot check generation inventory can automatically and shipping inventory compare, and provide comparison result.
Data synchronisation unit mainly cell phone and shipping subsystem carries out data interaction, comprises download basic data module, downloads attribute information module, uploads binding information module and upload spot check checklist module.Download basic data module for downloading the basic data of rig parts underlying attribute code table, thus hand-held set is not before importing any product information, by reading tag, also can aid identification product.The shipping rig components information downloading the supplier that shipping subsystem is derived by attribute information module imports in hand-held set.Upload binding information module and the binding information of product and label is uploaded to shipping subsystem; Upload spot check checklist module and the rig parts inventory generated during spot check is uploaded to shipping subsystem, be convenient to generate corresponding document.
Rig parts Internet of Things B/S general headquarters system comprises: basic database, daily inquiry quotation unit, purchasing management unit, shipping unit, on-the-spot handing-over administrative unit, warehousing management unit and System Management Unit and display screen; Rig parts Internet of Things B/S general headquarters system gathers the subsystem data of each operation field, also give by general headquarters' system distributing data the subsystem needed simultaneously, whole system is the system of closed loop, jointly complete rig parts from asking quotation, buying, shipping, logistics, being handover to the total system operation of storage.
Basic database comprise store comprise rig numbering summary sheet, rig parts handbook rig parts database and comprise the personal information database of support personnel's information, customer information and business personnel's information.
Daily inquiry price list head first carries out inquiry quotation registration, then receives the inquiry sheet that overseas inquiry subsystem generates and processes, decompose afterwards, generate multiple domestic inquiry sheet after decomposing by producer's title, and issues corresponding supplier and inquire the price.Typing quotation information in systems in which after supplier's quotation, generates to the price list of business personnel finally by rate of exchange option program.
Purchasing management unit mainly comprises non-conformance report processing module.Non-conformance report processing module mainly overseas subscriber forms non-conformance report feedback problematic parts document, then these parts are decomposed to form site problems feedback by supplier and issue each supplier, supplier confirms the parts in site problems feedback, processes parts according to confirmation situation.
Shipping unit comprises Shipping information receiver module, Shipping information browses module and Shipping information search module, and Shipping information receiver module receives components information in the project information at each shipping scene after the ciphered compressed derived by shipping ADMINISTRATION SUBSYSTEM, container information, iron sheet case information and iron sheet case.Shipping information browses the shipping situation that module can see all items, and can add up separately the data of each node.Shipping information search module searches for the information of certain container, and can navigate to this container place shipping item destination node, directly just can check Shipping information.
Scene mainly joins in the data file import system of ADMINISTRATION SUBSYSTEM issue by on-the-spot handing-over administrative unit, checks Shipping information and handing-over information, statistical study handing-over result, and processes the parts of defect in handing-over.
Warehousing management unit comprises storage information importing module, storage information browses module.Storage information imports the inventory information that module imports each warehouse, automatically deletes the file of mistake simultaneously, and shows that this derives the statistics of stock.
Storage information is browsed module and is shown with the country one belongs to's title in all warehouses in the form of a list, the storage information in the different warehouses of import system is checked by display screen, show detail information and the history inventory information of single parts, show total inventory analysis curve map, browse storage information and the parts statistical information in each warehouse easily.
System Management Unit, comprises notification module, questionnaire administration module, system management module.Important information is notified user by notification module, mainly comprises notice and notices management, consults notice announcement function.Questionnaire administration module mainly in order to realize common survey function, and to be safeguarded questionnaire and statistical information is checked.System management module comprises and managing account, organizational structure, address list etc.

Claims (1)

1. general headquarters' system of rig parts Internet of Things integral system, rig parts Internet of Things integral system comprises: basic database subsystem, abroad to inquire the price subsystem, shipping subsystem, overseas on-the-spot handing-over subsystem, storage subsystem five C/S subsystems and a rig parts Internet of Things B/S general headquarters system; Wherein:
Basic database subsystem comprises: basic data imports unit, basic data maintenance unit, basic data release unit, System Management Unit, help unit; Complete the rig information on all kinds of bases for original numerous and disorderly complexity, in the report data import systems such as Shipping information, carry out standardized administration, and reduced data can be distributed to other each systems as data source;
Overseas inquiry subsystem mainly comprises: rig components information unit, inquiry sheet unit, data publication unit; The problem that quick solution overseas subscriber runs in inquiry link, simplifies inquiry operating process, effectively avoids back and forth wasting time and energy of technical clarify, improve accuracy and the promptness of follow-up supply;
Shipping subsystem mainly comprises delivery schedule unit, label bar code unit, packing list unit, data publication unit; Complete the timely shipping process to goods, in this link, introduce label bar code, open by skill the bar code rule determined and carry out unique identification parts, and by bar code acquisition technique, the various lists required for automatically generating in systems in which;
Overseas scene handing-over subsystem comprises data receipt unit and handing-over processing unit;
The data receipt unit at overseas scene receives the Shipping information of basic database subsystem issue;
Handing-over processing unit comprises: Shipping information display module, project maintenance module, parts vanning enquiry module, goods check module, goods loss Registration Module, hand-off state arranges module, result of receiving derives module, goods handing-over situation statistical 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-" Order No. " and hierarchical structure show, can carry out checking, deriving the operations such as container list information simultaneously; Project maintenance module by " project-" contract batch-" delivery lot-" container number-" Order No. " and hierarchical structure carry out displayings maintenance; Parts vanning enquiry module can the position at certain parts place of fast finding, and Query Result can be derived and print; In addition, if check out in transportation acceptance of the bid the situation that existing wearing and tearing come off, label can be checked and again print; Goods is checked module and is taked analyzing spot cargo interests formula, is contrasted by the consignment sheet of container list or packing list and scanning generation with man-to-man form, if find difference, significantly to mark display, and the statistical information of comparison simultaneously; Goods loss Registration Module selectes container or iron sheet case, checks registered goods loss situation, and find by inquiry the parts that will register, input loss quantity, loss reason are registered; Hand-off state arranges module in units of iron sheet case, container, delivery lot, arranges handing-over and completes and do not complete two states; Result of receiving derives module and derives to the iron sheet case and container that complete handing-over result of receiving, and then sends to storage subsystem, imports this result of receiving, complete in-stockroom operation in storage subsystem; The handing-over that goods handing-over situation statistical module is corresponding to each delivery, provides statistics in real time, provides total items amount, completes the situation of checking over goods, do not complete all defect parts situations registered in the situation of checking over goods and handshaking; Shipping and receiving status inquiry module carries out query statistic by rig model, shipment data and foreign trade contract is contrasted, statistics shipping and receiving situation; Handing-over information issuing module is after goods has joined, derive the handing-over information that this delivery is corresponding, send to rig parts Internet of Things B/S general headquarters system, rig parts Internet of Things B/S general headquarters system imports in system again, handing-over information is processed, arranges whether to carry out supplementing delivery etc.;
Storage subsystem mainly comprises: stock-keeping unit, put unit in storage, go out library unit, delivery indicating member, in-transit management unit, data publication unit; Realize rig parts from warehouse-in, outbound, allot, tracking that overall process is carried out in the kinds of goods logistics such as to make an inventory; Support bar code and the management of single product code, by the kinds of goods bar code scan of the unique sequence numbers of outbound shipment data, the tracing management for kinds of goods provides important foundation;
Rig parts Internet of Things B/S general headquarters system comprises: basic database, daily inquiry quotation unit, purchasing management unit, shipping unit, on-the-spot handing-over administrative unit, warehousing management unit and System Management Unit and display screen;
Basic database comprise store comprise rig numbering summary sheet, rig parts handbook rig parts database and comprise the personal information database of support personnel's information, customer information and business personnel's information;
Daily inquiry price list head first carries out inquiry quotation registration, then receives the inquiry sheet that overseas inquiry subsystem generates and processes, decompose afterwards, generate multiple domestic inquiry sheet after decomposing by producer's title, and issues corresponding supplier and inquire the price; Typing quotation information in systems in which after supplier's quotation, generates to the price list of business personnel finally by rate of exchange option program;
Purchasing management unit mainly comprises non-conformance report processing module; Non-conformance report processing module mainly overseas subscriber forms non-conformance report feedback problematic parts document, then these parts are decomposed to form site problems feedback by supplier and issue each supplier, supplier confirms the parts in site problems feedback, processes parts according to confirmation situation;
Shipping unit comprises Shipping information receiver module, Shipping information browses module and Shipping information search module, and Shipping information receiver module receives components information in the project information at each shipping scene after the ciphered compressed derived by shipping ADMINISTRATION SUBSYSTEM, container information, iron sheet case information and iron sheet case; Shipping information browses the shipping situation that module can see all items, and can add up separately the data of each node; Shipping information search module searches for the information of certain container, and can navigate to this container place shipping item destination node, directly just can check Shipping information;
Scene mainly joins in the data file import system of ADMINISTRATION SUBSYSTEM issue by on-the-spot handing-over administrative unit, checks Shipping information and handing-over information, statistical study handing-over result, and processes the parts of defect in handing-over;
Warehousing management unit comprises storage information importing module, storage information browses module; Storage information imports the inventory information that module imports each warehouse, automatically deletes the file of mistake simultaneously, and shows that this derives the statistics of stock;
Storage information is browsed module and is shown with the country one belongs to's title in all warehouses in the form of a list, the storage information in the different warehouses of import system is checked by display screen, show detail information and the history inventory information of single parts, show total inventory analysis curve map, browse storage information and the parts statistical information in each warehouse easily;
System Management Unit, comprises notification module, questionnaire administration module, system management module; Important information is notified user by notification module, mainly comprises notice and notices management, consults notice announcement function; Questionnaire administration module mainly in order to can be common survey function, and questionnaire to be safeguarded and statistical information is checked; System management module comprises and managing account, organizational structure, address list etc.
CN201510034107.2A 2015-01-22 2015-01-22 Head office system for integrated system of the Internet of things for drilling machine parts Pending CN104574026A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510034107.2A CN104574026A (en) 2015-01-22 2015-01-22 Head office system for integrated system of the Internet of things for drilling machine parts

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510034107.2A CN104574026A (en) 2015-01-22 2015-01-22 Head office system for integrated system of the Internet of things for drilling machine parts

Publications (1)

Publication Number Publication Date
CN104574026A true CN104574026A (en) 2015-04-29

Family

ID=53090035

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510034107.2A Pending CN104574026A (en) 2015-01-22 2015-01-22 Head office system for integrated system of the Internet of things for drilling machine parts

Country Status (1)

Country Link
CN (1) CN104574026A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107292572A (en) * 2017-07-21 2017-10-24 河钢股份有限公司邯郸分公司 A kind of method of SAP system steel industry spare part sequence number logistic track
CN112150075A (en) * 2020-09-30 2020-12-29 中远海运科技股份有限公司 Container and material management system

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1373436A (en) * 2001-02-28 2002-10-09 杨承喜 Trade method and system using computer for network shopping

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1373436A (en) * 2001-02-28 2002-10-09 杨承喜 Trade method and system using computer for network shopping

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
黄敏: "基于供应链的钢铁物流信息平台", 《中国优秀硕士学位论文全文数据库经济与管理科学辑》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107292572A (en) * 2017-07-21 2017-10-24 河钢股份有限公司邯郸分公司 A kind of method of SAP system steel industry spare part sequence number logistic track
CN112150075A (en) * 2020-09-30 2020-12-29 中远海运科技股份有限公司 Container and material management system

Similar Documents

Publication Publication Date Title
CN105096083B (en) Information system for warehouse
CN103593723A (en) Liquor storage management system based on RFID
CN104573974A (en) Drilling machine part Internet of Things integrated system based on RFID code recognition
CN103745333A (en) Furniture safe circulation source tracing system and method based on cloud computing
US20130179309A1 (en) Methods and Systems For Restocking Inventory
CN105590187A (en) WMS system based on bar code technology
US20130179307A1 (en) Methods And Systems For Restocking Inventory
CN106528701B (en) Cross-border merchandise news sending method and system
CN114140045B (en) Material management method, system, storage medium and equipment
CN107330745A (en) A kind of invoice information automatic input system and method
CN104573976A (en) Drill rig part Internet of things integrating system comprising logistics recognition hand-held set
CN104573975A (en) Drill rig part Internet of things integrating system comprising storage recognition hand-held set
CN111210178A (en) Warehouse management system
CN106127426A (en) A kind of the Internet shopping platform kinds of goods management method and system
CN104599104A (en) Drill rig part Internet of Things integrated system including drill rig part manual terminal
CN106504007A (en) A kind of commodity counterfeit prevention management system based on NFC electronic tags
CN104574026A (en) Head office system for integrated system of the Internet of things for drilling machine parts
CN104574025A (en) Drilling rig part internet-of-things integration system based on bar code identification
CN104205134A (en) Mobile terminal management server, and mobile terminal management program
CN108960707A (en) A kind of auto parts and components packing management system
CN104766118B (en) A kind of fixed petroleum steel pipe RFID device
US20040254863A1 (en) Asset maintaining, controlling and accessing program
CN104599105A (en) Oversea inquiry subsystem of drilling machine component and part Internet-of-things integration system
CN104598594A (en) Basic database subsystem of integration system for Internet of Things of drilling machine parts
CN104636899A (en) Storage subsystem of drilling machine part Internet of Things integrated system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20150429

WD01 Invention patent application deemed withdrawn after publication