CN104376415B - Cable volume management system - Google Patents

Abstract

The invention discloses a kind of cable volume management system, the management system includes user profile, the user being connected with user profile logins interface, the project information storehouse and rights management storehouse being connected with user profile for user according to affiliated allocation of items logon rights, interface is logined with Technology design management system to be connected, Technology design management system is connected with cable management system and rights management storehouse simultaneously, cable management system is that cable specification safeguards storehouse including the total storehouse of cable data, project master data storehouse, cable inventory, cable laying and laying daily record, storehouse is safeguarded with cable specification in project information storehouse simultaneously, project master data storehouse is connected, user profile simultaneously with rights management storehouse, laying daily record is connected.The present invention has the advantages of multi-user is simultaneously online, progress data processing and inquiry LAN services.

Description

Cable volume management system

Technical field

The invention belongs to engineer applied, is directed to multi-user, entry, multidisciplinary while online editing and inquiry cable volume Software platform, the complicated heavy construction of many control and power system is built and had applied to extra large work.

Background technology

Cable volume is a kind of inventory form for providing manufacture bases in ship and extra large work building course for cable laying, comprising A large amount of production informations such as device name, position, path and cable model.Workmen relies on this inventory, can plan in order Complete the cable laying work of whole project.General every cable includes following information：Sequence number, said system figure number, drawing Version number, cable code name, cable specification, cable initial plant information（Equipment code name, device name, device location）, terminate set Standby information（Ibid）, type of cable, cable junctions path, cable estimated length, cable actual use length, outside diameter of cable etc. it is near 20 contents.

Node：Cable laying, by setting node on cable louding figure, must provide the node that every cable passes through through point To describe cable pulling route.And the cable required for each node is judged by the cable specification by each node, quantity Bracket and cable pass through the perforate size of bulkhead.

For ship and extra large work construction applications, common bulk freighter, oil carrier project only have 3000 ~ 4000 cables, It is complicated also with regard to 5000, number of nodes 150 ~ 200 or so, the myriametre of cable overall length 8 ~ 18.Cable trace is simple and clear, is typically , by cable information craft typing mode, it can be completed by one by one in 2 ~ 3 months.But for extra large work project, Fixed platform（Jack up, anchoring coordinate fixed derrick）6000 ~ 8000, cable, node 400 ~ 1000, cable length 18 ~ 24 myriametres；Special operation vessel（Windmill vessel, pipe laying barge）12000 ~ 18000, cable, node 1000 ~ 1500, cable length Spend 40 ~ 80 myriametres；15000 ~ 16000 or so, semisubmersible drilling platform cable, node 1400 ~ 1800 or so, cable length 45 ~ 70 myriametres；18000 ~ 20000, semi-submersible type accommodation platform cable, number of nodes 1200 ~ 2000, cable length 40 ~ 650,000 Rice.Floating platform often possesses dynamic positioning ability, and the segmentation trend to cable trace has extra particular/special requirement, cable point Cloth is intricate.The workload of cable volume=cable radical X（Cable junctions number X30%）.The double engineer in common ship time-consuming 6 Wheat harvesting period is possible to accomplish.

Traditional cable volume mainly has following several forms：

1.Excel forms（It is the steady of the speed of service and data for this patent, the defects of Excel maximums Qualitative, extremely obvious when number of cables is more than 10,000, Excel file is opened the time for needing a few minutes, and screening arranges also very Slowly, it usually needs in units of minute, and internal memory burden of often going out excessive causes system crash.）

The 1.1 pure manual one man operations of Excel（Operated relative to more people, it is clear that speed is very slow and is difficult to check）；

1.2 pure Excel VB programmings+Excel formula, more people operate simultaneously（Belong to one man operation's modified version, it is allowed to more People operates simultaneously.But it is much worse than greatly relative to the software of server database form, its stability and accuracy rate.Reason is this Method needs more people simultaneously or asynchronously operated, and shares an Excel form, everyone is divided exclusive space, causes form In content the system resource number taken is needed into the increase wasted space of geometric progression, the capacity of the form greatly increased, form The computer memory taken required for times cable volume essential information of itself.Not only the speed of service is very slow, and a kind of relatively upper shape Formula, spliced Excel tables are easier system crash occur.And in cable volume renewal process, due to version mistake can cause it is more Personal summary information is inconsistent, malfunction, phenomenon of doing over again it is frequent）.

2.Excel VB or Access users to share（Relative to Excel forms above, relative to upper one kind There is the advantage of the obvious speed of service, accuracy and stability, and calculation function once can be provided as needed, but phase Still there is a big difference for this patent, essentially consists in the fatal shortcoming on data processing amount and processing speed, Yi Jiduo Project multi-user operates simultaneously on.Because although the method make use of network, but this single file can only allow a user Use, other users can only check and can not operate that operating efficiency returns to 1.1 states when someone takes this Document Editing）.

Several cable volumes described above also have the shortcomings that several same：

1. the protection extreme difference of a large amount of important informations, once cable volume is in itself or the computer of storage cable volume goes wrong, then Work of several weeks even more than the moon is likely to result in lose.

2. the help of cost control is extremely limited, because cable length is artificially to measure one by one, often occur one or When multidigit engineer measures the length of the different cables of zone similarity within several working days relatively far apart, the surplus provided is not Together, cable length " only for reference " is caused.

3. cable length estimated speed is slow.

4. cable trace is manually entered, speed is slow, and thinking is discontinuous.

5. without detection function, accuracy rate can only lean on field test, and error detection is too late.

6. it is slow to change renewal speed, easily omit.

7. can not trace, numerous numerous and complicated operations are without any reliably historical record.

8. the deletion situation of cable can not be found.

In summary, if extra large work project using conventional practice must be very difficult arduous, novel cable volume The appearance of software is inexorable trend.

The content of the invention

The invention aims to overcome the shortcomings of the above, there is provided a kind of multi-user is simultaneously online, carries out data processing With the cable volume management system of inquiry LAN service platform.

The purpose of the present invention is achieved through the following technical solutions：A kind of cable volume management system, the management system bag User profile is included, the user being connected with user profile logins interface, is connected with user profile for user according to affiliated project point Project information storehouse and rights management storehouse with logon rights, login interface and are connected with Technology design management system, Technology design pipe Reason system is connected with cable management system and rights management storehouse simultaneously, and cable management system is cable rule including the total storehouse of cable data Lattice safeguard that storehouse, project master data storehouse, cable inventory, cable laying and laying daily record, project information storehouse are tieed up with cable specification simultaneously Shield storehouse, project master data storehouse are connected, and user profile is connected with rights management storehouse, laying daily record simultaneously.

Further improvement of the present invention is：The cable laying includes node editing interface storehouse, allograph enters cable, I signs Enter cable and cable recycle bin.

Further improvement of the present invention is：The cable inventory includes batch importing cable volume, cable inventory is issued, become More variance analysis.

Further improvement of the present invention is：The cable specification safeguard storehouse include global cable specification it is tree-like displaying storehouse, Form displaying storehouse, cable standard safeguard that storehouse, project cable specification storehouse are safeguarded in storehouse, cable producer.

Further improvement of the present invention is：The project master data storehouse includes type of cable maintenances, regional maintenance, electric Equipment library, Dp master datas and the project cable specification storehouse being used in conjunction with storehouse is safeguarded with cable specification.

Further improvement of the present invention is：The node editing interface storehouse includes node editing machine, node batch uploads, Node uploads by cable, node layout, node display and calling, querying node and management, euclidean distance between node pair batch.

The present invention has the advantage that compared with prior art：

1. network platform formula operation interface is in addition to above advantage, it is maximum the characteristics of be to itemize and the complete of database and intersect Get in touch with.For preferably control plant construction cost, newly making project can be according to the actual use situation of conventional project and stock Surplus, make and relatively more accurately estimate and purchase.The preferably waste situation at control scene.

2. in addition to design department, convenient construction, inspection declaration etc. obtain up-to-date information using department's online query, the very first time.

3. the expansion of platform is good, personal plan and plan tracking can be done, in addition to cable volume is produced, full side can also be Position log query, working time report, equipment library form, cable junctions form, cable dosage form etc. more than ten is with this platform data Diversified forms form based on storehouse, can serve the softwares such as MCT and Smart 3D.

4. LAN server form data storage, dual redundant object amount storage protection.

5. cable length calculates precisely, cable headroom data storehouse, it is uniform to ensure that cable length is estimated.

6. cable junctions mouse selective type typing, thinking link up, speed is fast.

7. database information monitoring function, can be with preliminary test cable typing accuracy.

8. cable volume batch import function can quickly establish cable volume essential information, efficient is cable trace designer Member（Produce designer）Design basis is provided.And this work can be made a living by being more familiar with the detailed design human users of system Production designer strives for substantial amounts of path design time.This work accounts for the 30% of cable volume design work, is designed equivalent to production Personnel's amount of work reduces 30%.Relatively conventional duplication, bonding method one by one, this function will reduce 60% ~ 75% design time, The project overall design time will reduce 15% ~ 20%.

9. cable trace directly picks up from CAD layout drawings, compared to conventional duplication, paste, two software parts are mutually cut Change, i.e., it is directly perceived quick and accurate coherent.This function will reduce 10% ~ 15% design time.

10. node occupancy monitors, it can intuitively check whether the design of each node is reasonable in real time, this is anticipation Whether the important evidence of code requirement disclosure satisfy that in actual production.Traditional approach is difficult effective control node occupancy situation, Coordinated using Excel formula cells and conditional formats all seldom.

11. the maximum advantage of cable information data base administration form is that later maintenance is good, efficiency high.Phase can be reduced Associations change process, improve modification speed, and are not in omit.Design time will reduce 20%~25%.

12. this cable volume management method will shorten 45% ~ 60% when will design chief engineer, when having striven for substantial amounts of valuable for production Between, anticipation checking function makes a large amount of problems optimised before manufacture, reduces rework rate.

13. journal function, each every cable operation overall process of project can be inquired about.

14. recycle bin function, can undelete cable at any time, and can be repaiied with cable in complete traceability Project Process Change and deletion amount.

Brief description of the drawings：

Fig. 1 is the structural representation of the present invention；

Fig. 2 is login interface；

Fig. 3 is rights management；

Fig. 4 is cable laying interface；

Fig. 5 is cable junctions editing interface；

The cable interface that Fig. 6 checks in for me；

If Fig. 7 is cable inventory；

If Fig. 8 is supporting program；

1- user profile, 2- login interface, 3- project information storehouse, 4- rights managements storehouse, 5- Technology designs management system, 6- Cable management system, 7- cable specifications safeguard storehouse, 8- project master datas storehouse, 9- cables inventory, 10- cable layings, 11- laying days Will, 12- node editing interfaces storehouse, 13- allographs enter cable, 14-, and I checks in cable, 15- cables recycle bin, 16- batches and imports electricity Cable volume, 17- cable inventorys issue, the tree-like displaying storehouse of 18- changes variance analysis, 19- overall situation cable specifications, 20- forms displaying storehouse, 21- cable standards safeguard that storehouse, 23- project cable specifications storehouse, the maintenance of 24- type of cables, 25- regions are safeguarded in storehouse, 22- cables producer Maintenance, 26- electrical equipments storehouse, 27-Dp master datas.

Embodiment：

In order to deepen the understanding of the present invention, below in conjunction with embodiment, the invention will be further described, the embodiment It is only used for explaining the present invention, is not intended to limit the scope of the present invention..

As Fig. 1 shows a kind of embodiment of cable volume management system of the present invention, the management system includes using Family information 1, the user being connected with user profile 1 login interface 2, are connected with user profile 1 for user according to affiliated project point Project information storehouse 3 and rights management storehouse 4 with logon rights, login interface 2 and are connected with Technology design management system 5, technology is set Meter management system 5 is connected with cable management system 6 and rights management storehouse 4 simultaneously, and cable management system 6 includes the total storehouse of cable data I.e. cable specification safeguards storehouse 7, project master data storehouse 8, cable inventory 9, cable laying 10 and laying daily record 11, project information storehouse 3 With the cable specification safeguard that storehouse 7, project master data storehouse 8 are connected simultaneously, user profile 1 simultaneously with the rights management storehouse 4, deposited If daily record 11 is connected, cable laying 10 includes node editing interface storehouse 12, allograph enters cable 13, I checks in cable 14 and cable returns Station 15 is received, cable inventory 9 includes batch importing cable volume 16, cable inventory issues 17, change variance analysis 18, cable specification dimension Shield storehouse 7 includes the tree-like displaying storehouse 19 of global cable specification, form shows that storehouse 20, cable standard safeguard that storehouse 21, cable producer are safeguarded Storehouse 22, project cable specification storehouse 23, project master data storehouse 8 include type of cable and safeguard 24, regional maintenance 25, electrical equipment storehouse 26th, Dp master datas 27 and the project cable specification storehouse 23 being used in conjunction with storehouse 7, node editing interface storehouse are safeguarded with cable specification 12 include node editing machine, node batch upload, node by cable, node layout, node display and calling, querying node and Management, euclidean distance between node pair batch upload.

It is simultaneously online the invention discloses a kind of multi-user, data processing and inquiry LAN service platform are carried out, can be expired The production requirement that ten several extra large work projects of foot operate simultaneously, average each project are tens of thousands of to ten tens of thousands of individual electrical equipments（Each electricity Gas equipment one, two at least, at most hundreds of cables）, average each hundreds thousand of cable datas of project, joint current data processing amount It is up to millions of, input engineer nearly hundred.Believe that the marine engineering product control in future can be more complicated advanced, it acts on meeting It is more obvious.And this system can not only be applied and built with extra large work, other complicated heavy constructions can all have many control And power system, this software can be applied.The advantage of its efficient data sampling and processing and project management etc. is particularly Substantially.Rights management is the limitation of two-dimentional staggered form system, i.e. project management authority and level Four user right of compilation.Clear layer is easy to Management, all data use 24 hours online management forms of dual redundant physics public server, securely and reliably.Backstage cable sum Can be as the reliable basis that cable buying, distribution and offer cable are estimated between each project of macro adjustments and controls according to storehouse.In addition, engineering In design process, system framework, which is built, no doubt to be taken, but later maintenance modification amount is also huge, traditional construction design pattern Under, the time of later maintenance at least accounts for the 30% ~ 40% of the overall design time.It is to lead one to start whole body, especially electric specialty, no By being that the modification of this specialty pure electrical system or machinery, the modification of ventilation specialty, the change of any point can all cause some extremely The modification of tens points, there is this platform to significantly improve the operating efficiency for safeguarding modification significantly.

The development language of cable volume management system of the present invention is C# (IDE: Visual Studio 2010)、 Architecture:.NET Framework 3.0, operational mode:C/S (client-server structure), database:Microsoft SQLServer database servers, system architecture：Three layers of (presentation layer（UI）, Business Logic（BLL）, data access layer （DAL）), data or message-oriented middleware：Increase income Apache-ActiveMQ, system Web Service：Integrated Hprose, SAP The technologies such as RFC, realize the calling of common interface function.

It is illustrated in figure 2 registration and login interface, it can be seen that user is according to affiliated allocation of items logon rights, such as Fig. 3 show user right editing interface, and operation user is divided into following level Four, possesses the different rights of the software respectively：Technology Electric panel room（Cable information typing and editing）；Technology electric panel room data person（In addition to above authority, also possess project data Storehouse, primary database are safeguarded）；Technology electric panel room is responsible for（In addition to above authority, also possess cable volume formally export and recycle bin cable Complete deletion）；Technology electric panel room keeper（In addition to above authority, also possess and assign other users editing authority and allocation of items Authority）；In addition also many compound roles, such as technical director, other departments employee, supervisor, manager, general manager, Fig. 4 are Cable laying interface includes：

1. cable junctions editing interface, the information diversification provided compared with previous mode, have it is directly perceived, facilitate user's Human oriented design, framework as shown in Figure 5, including：

I node editing machines：Individual cable nodal information（Node code name, node space, node affiliated area）Editor, lead to Node space utilization rate is often checked by node display and calling interface when cable trace design reaches more than 70%, if hair Existing space is insufficient or excessive can be adjusted individually.

II nodes batch uploads：As other batch modification modules in the system, this module also comprising template download and Information batch upload function.System will establish tree graph structure automatically by batch upload information and be reflected in cable displaying and call Interface.

III nodes pass through cable：The cable information by each node, including electricity can be checked and exported by this interface Cable code name, cable specification, the outside diameter of cable, derived inventory are used directly for the calculating of MCT cable packages software, produce MCT moulds Block selects layout viewing.MCT is modular watertight, pressurizing cable penetration piece, belongs to crossing cabin sealing more advanced during extra large work is built Part.

IV node layouts：System can be by counting the node paths of all cables in cable volume, to conclude each section of extraction The cable information that point passes through, so as to generate the cross-section of cable figure of each node.Egress can be intuitively seen from figure（Put electricity The bracket or cable of cable pass through perforate during metal wall）Size and all cables for passing through the node section arrangement.Can See actual conditions of the cable by node with open-and-shut, understand remaining space situation.The position of every cable can Position is manually adjusted in this figure, can also be generated CAD forms and be gone out figure.

V node display and calling：Show that all events Node distribution, node size, node space account for by tree graph mode With information such as rates.Node space utilization rate is to coordinate display by percentage figures and coloured bar graph, can intuitively be found out The space availability ratio of each node, space occupancy rate algorithm is based on ship and extra large work build specification.Color can be with space Utilization rate from small to large and from it is green to Huang to red change.The numerical monitor of space availability ratio contains real space occupancy simultaneously Rate and according to user need set spare space after space occupancy rate.

This interface can be used cooperatively with node by cable interface and node layout interface, because whole node editor circle Face can be shown multiple windows simultaneously and be hidden unnecessary window using automatic hiding and drawing pin thinking.Selected on node tree graph In certain node when in node will show that the node is corresponding by cable interface and node layout interface, be so advantageous to system money Source optimization and operation display interface space it is flexible.

VI querying nodes and management：When cable junctions system is excessively huge, the fast search by way of fuzzy query The function of some destination nodes is also necessary.

VII euclidean distance between node pair batch uploads：After main cable, which moves towards preliminary, to be established, project implementation supervisor is responsible for will be whole Range measurement between all nodes of project one time simultaneously provides surplus, disposably uploads in system database.Cable length calculates Directly obtained by internal system computing, cable trace designer only needs to be responsible for the addition of cable junctions and ensures node institute The accuracy in the path of description.It so can greatly save measurement estimated time and accuracy and the essence of every cable Degree.

2. cable to be checked in；

The cable that user can be checked by this module in project cable storehouse by other users occupancy situation, so as to determine Respective cable editing plan.This function is to preferably realize multi-user's on-line operation purpose simultaneously, is resource profit Optimum allocation is realized with rate.Fuzzy inspection can be carried out needed for user's inquiry during the cable information of editor by 22 cable information points Rope, it can also be searched by the quick arrangement mode of 16 information.When simultaneity factor caused by Query Result can employ red height certainly The bright occupied cable of display, and prompt to be that who user takes or edited these cables, inquiry user can be according to need The arrangement of these cables of editor is linked up with taking user.Other cables check-in that oneself needs first can also be arrived into " I simultaneously Maintenance of the cable of the check-in " interface through row cable junctions path and other information.

3. the cable that I checks in, as shown in Figure 6：

By cable module to be checked in, user selects the cable to be edited from cable storehouse, puts it into the editor of oneself Edlin is entered in space, is referred to as " check-in ", and the major function at this interface is the design of cable run, efficiently, intuitively Route designing method, simplicity, quick, accurately length estimates the characteristics of method is this system and advantage；

I cable junctions selective type typings, certain system are also supported to be manually entered.This function operates user " windows " changes, and conventional cable junctions typing mode is to input one by one manually, and the node that engineer's reference cable is moved towards in figure is anti- Answer image switching or using shuangping san, see that trend is schemed while path planning, input node.This design is defeated by double-clicking Enter bar, system will be switched to the moving towards in figure of CAD forms, directly be clicked the node of desired process successively with mouse.Ten It is convenient to divide, and operating efficiency greatly improves.Using ten thousand cables as radix, the man-hour in two to three weeks can be probably saved.Work as node Into before cable volume management system, whether system can exist in the cable junctions database of automatic detection typing, if do not had Have, system can provide newly-increased nodal interface and list all new nodes detected, whether judge newfound node by user , can be by fast adding interface by the title, size, affiliated area of these newly-increased nodes as errorless in the presence of description mistake Increase to database etc. information, as wrong, reject.

II node paths space, system is that every cable all provides 8 node path spaces, for adding " i " institute above The node path stated, when certain root cable passes through multiple regions, certain is inserted in the path in oneself region by each Regional Champion In one path spacing, all paths will be connected to form fullpath by system automatically according to nodename, there is provided path Integrity check, and provide prompting.

III euclidean distance between node pair is self contained data base, the node that system can pass through according to cable, these cable sections of accumulation calculating Distance between point, this will reduce cable length significantly and measure the time, compared with traditional cable length measures, using ten thousand cables as Radix, it can probably save the man-hour in two to three weeks, it is often more important that cable length is combined into by ordered one spacing, if The accuracy and precision for counting length are ensured well.And euclidean distance between node pair, when being varied from, the key of cable length one refreshes It is convenient and swift.

To 20 remainders such as the code name of cable, type, said system, cable specification, starting termination device, cable three-level inspections Information carries out one by one or batch is safeguarded.Based on database information, information inquiry and replacement are uniform for all operations, it is ensured that The uniformity of all operating personnel's edit structures.Starting and termination device realize " class " management, and domestic consumer only needs more exchange device Code name, device-dependent other information will follow renewal automatically to modification target cable, the information such as the description of equipment, position Such as need to update, managed being unified in equipment library, system can give facility information last state synchronized update to cable volume automatically, both Improve operating efficiency and ensure accuracy rate again, while prevent from omitting.This function will in cable volume later maintenance effect it is particularly evident. Especially cable starting or termination device change in location when, the path of cable may change, if now by should Some cables of equipment " lock "（I.e. cable information, path and length are improved and audited and passes through）, system can because The position of the cable changes, and it is automatically become released state, and operating personnel can unify to calibrate after finding, it is ensured that cable is believed Breath is fast and accurately passed on and updated.The operating efficiency of multi-user's online editing simultaneously is improved to greatest extent.More conventional cable 2 ~ 5 times of man-hours are shortened in volume maintenance work, can save 10~30 days everyone man-hours（Depending on production designer's quantity and item Mesh size）.

III can link relevant cables system diagram, equipment data therewith.So there are individual equipment up to ten thousand for extra large work, number The version degree of upgrading in time of the engineering of ten thousand parts of data, drawing and the inquiry velocity of data and these data and drawing, all will be very big Influence project process ride comfort.

4. cable recycle bin：

During project progress, system design often is caused to change by a variety of causes, and it is also wherein one that cable, which is deleted, Kind.

The maximum benefit of I recycle bins is to prevent from deleting by mistake,

If II in addition, find that this cable still needs during system update, can be replied directly in recycle bin, Save part entry time.

III assesses for project conclusion certain help, and after project terminates, the summary of data statistic analysis is to closing weight Will, this software can retain foundation and the deletion situation of all cables in design process, facilitate query statistic.

Cable inventory is illustrated in figure 7, including：

1. batch imports cable volume：

Database in addition to adding one by one manually, and to provide operating efficiency, the foundation of database can use Mass production Method.The cable information in the system diagram of CAD forms can be generated in a manner of clicking just the small routine that CAD VB are developed The cable volume framework of step, template is then uploaded by downloading data, these Data Integrations are uploaded in this software.When system is examined Measuring in database does not have some equipment or cable information, will automatically generate equipment list and cable model inventory, and user can be with Checked in the two interfaces and finally decide whether to increase these information.Equipment library formation speed is greatly improved, this work( It can save the working time of two weeks, equipment radix 10,000.Cable essential information can be by system or by area according to design schedule Domain imports in batches, can be with batch import system after the cable volume essential information of upload is completely by system test.So may be used To ensure the information self-consistentency of cable volume.

2. cable inventory issues：

By above many effort, final purpose is to be formed to be the cable volume of production service, and issues production.In item Production is synchronously carried out with design in mesh implementation procedure, and design can continuous renolation.Therefore, the cable volume issued is also Constantly update, cable can issue the time twice in system and judge the changing, increase newly of cable, deletion state.

3. change variance analysis：

Cable modification state is most complicated, including the modification for going out all information outside cable code name, traditional design side Formula is to mark out to come one by one by the modification situation of each cable manually, it now is possible to is arranged automatically by variance analysis and log query Go out the modification situation of every cable.Often a project has 3 to 4 editions cable volumes, rises version modification amount hundreds of to thousands of every time .This can save 10 ~ 15 workaday work.

It is illustrated in figure 8 supporting program introduction：

The database of this patent is divided into global data base and project database two major parts.

Global data base mainly includes customer data base, project database and the total storehouse of cable data.

Advanced level user can be inquired about, analyze and be allocated the use of cable between each project by the total storehouse of cable data.

Project master data

Following items are included at present, such as with good grounds project needs and improved software automation degree, can also extend again. Mainly include：Electrical equipment storehouse, project cable specification, regional maintenance, type of cable maintenance, DP master datas.

Lay daily record：For convenience of the tracking of each design details in project process, history design data analysis, design alteration Issue, notice production, laying daily record is necessary.

Instant message：As its name suggests, all online users can select oneself to want the information understood, such as certain as needed The instant notification line or offline notification of district cable change in location.

When in use, first, installation " cable volume management software " is on computers for cable volume management system of the present invention. After installation, cable volume management software is opened, registers and logs in.

1st, cable volume system manager process for using：

1）Land cable volume software, create " user profile ", " project information ".

2）Into " rights management " in " system administration ", distributing user permission and project.

2nd, cable volume database Establishing process：

1）First, " cable volume management software " is installed on computers.After installation, cable volume management software, note are opened Volume simultaneously logs in.

2）Pass through " personal information customization "：

A, can " personal information setting " to " Chinese name ", " department/section office ", " email address ", " job number ", Information such as " specialties " is modified；

B, modification logging is modified in " modification modification logging "；

C, in " application logs in project ", " active user can log in project " can be checked, as user needs more items Authority, the sundry item authority in addition to current entitlement can be applied in this function, after system manager receives application information, To related supervisor confirm it is errorless after assign the new authority of the user.

D, in " message subscribing module ", cable modification information can be subscribed to, especially device location modification is logical in real time Knowing can facilitate user to grasp whether oneself responsible cable needs more new route.

3）Into in " maintenance of cable specification ", cable standard storehouse is established, by " cable producer by " cable standard maintenance " Cable producer is established in maintenance " and the code name of each project is used for the exclusive special cable storehouse of stock item；By batch upload or Addition manner one by one, typing and safeguard more new cable specification and its corresponding cross-section of cable product diameter, cable unit weight, The information such as cable producer, cable standard.

4）Into " project master data "

A, uploaded by batch or addition manner typing and maintenance update one by one, " electrical equipment storehouse ".Pay attention to：Device location Modification can influence the path of all cables by this equipment；By double-click or right button equipment code name activation equipment code name editor, Other information can be changed directly in the window.It can be seen that the actual number of cables by each equipment in this equipment library.And Cable inventory corresponding to can generating.

B, " project cable specification " plucks cable specification needed for option in batches from joint current storehouse；

C, full ship region division storehouse is created by " regional maintenance "；

D, all type of cable storehouses of project needs are created by " type of cable maintenance "；Item is created by " DP master datas " All trunk and important path storehouses in mesh, such as DP paths（According to the power and letter of dynamic positioning system class requirement, separately redundancy Number cable run）, well system path, the information such as main power system path.

5）The floating frame " node editing interface " hidden automatically by left side into " cable laying "

A, by " node batch uploads inventory ", " node list template " batch uploading nodes inventory is utilized, creates node Database, or addition manner increases node newly to database one by one by " node editing machine "." node editing machine " can be with simultaneously Change the information such as capacity, the region of each node.

B, by " euclidean distance between node pair batch imports ", distance between " nodal distance safeguards template " batch uploading nodes is utilized.

3rd, cable laying process for using

1) cable in CAD diagram paper is extracted into by Excel formatted files by CAD " point beans " modes, " cable is clear for utilization " cable volume template is imported in volume " " cable is imported into cable volume management software, complete cable volume essential information framework and build. （After cable inventory uploads, " data analysis " please be click on, through row cable inventory automatic detection.After analyzing no problem, cable volume software Upper right side occurs that " starting to import " orders, and clicks this order button and completes to import.Wrong or cable in such upload information It is not present in volume system database, system can be marked with yellow and prompt concrete reason.As cable model is not present, data are notified Library manager adds, and can also carry out maintenance holding, maintenance mode in " treating maintenance cable specification ":Into " wait safeguard electricity Cable specification ", after right button selection defines the outside diameter of cable and cable density, holding；As equipment TAG is not present, notification database Keeper adds, and can also safeguard and keep through row in " treating maintained equipment ", maintenance mode:It is right into " treating maintained equipment " Key selection defines estimated number of cables, behind location and specification of equipment, holding）.

2) in " cable laying " " cable to be checked in " the lower cable that needs are found by multi information search engine, such as Some cables are occupied to be marked with red, and prompt to take people.The cable to be edited is selected, right button clicks check-in, will After " cable that I checks in " is arrived in cable check-in, enter edlin." cable to be checked in " search interface can see fuzzy query and arrive Number of cables, all inquiry restrictive conditions all can see in system cable sum for space-time.In addition, user can also pass through The mode of row ascending order, the title of each information row in click system, realize and arranged with this as standard ascending order or descending arrangement, quickly looked for To desired information.

3) individual cable to be edited of left double click activation in " cable that I checks in ", " section in " cable editor " " path x ", system can be switched to the cable trace figure opened in advance for double-click in point input pattern "（CAD forms）, picked up by clicking After taking mode to plan good collect, click on " complete and exit ", return to cable volume management system.（If system discovery has newly Nodename, newly-increased nodal interface can be prompted and eject automatically, by artificially checking whether this increase node is correct, such as checks knot Fruit is affirmative, then according to prompting increase node to database, or notifies data administrator to increase node.）

A, when path has been completed（All paths that cable passes through are to complete）, " having completed on current road " please be click on, and select Select " examine and calculate cable length ", system, which can produce complete cable trace and provide, estimates length.Preserve and check out.By Locking is clicked after supervisor or Regional Admin's inspection are errorless, and then this cable design is completed to enter arm-to-arm.Such as initial plant to first When the length of individual node and last node to termination device is safeguarded first, system prompt needs designer to add length, Do not prompted if existing in system.Length is also in this way, but length is to save in advance between normal conditions lower node between node Uniformly safeguarded in length data storehouse between point.Need to notify data person or supervisor to confirm length if any newly-increased.

B, such as, cable passes through multiple regions, and the Area Node that oneself is responsible for is added to by each Regional Champion according to agreement Specified path region, click on area path completing button, and preserve." examine and calculate cable length " now is not needed, when most Computational length is clicked on again after latter name designer checking path is complete and is preserved.

C, such as cable is very short, between equipment without node in the case of, " having completed on current road ", Improving Equipment please be click directly on Between length.

D, it if necessary to which cable title is revised as into B by A, can double-click or right button cable denominational, modify, system meeting It is recorded as former cable A to be deleted, increases cable B newly.

E, if necessary to modification cable specification：It can be selected in cable specification drop-down menu, drop-down dish can also be clicked Button behind list is opened this item purpose cable specification tree graph and selected.

When f, if necessary to modification type of cable or DP paths：It can be selected in type of cable and DP paths drop-down menu Select.

G, if desired for the initial plant or termination device of modification cable：Cable starting or termination device button are clicked, in item Mesh equipment tree graph midpoint is selected or the equipment of search needs and confirmation.Pay attention to：The starting of cable and termination device position belong to equipment Base attribute, if only changing cable whole story end position, ask data administrator unified modification, system meeting in project equipment storehouse All associated cables are updated simultaneously, and detect what is completed in these cables with the presence or absence of path design, if There is meeting automatic unlocking and send timely message to all booking readers, and be recorded in historical operation.（Pay attention to：Only equipment position When putting change, system can just activate unlocking motion and send unlocking information.）

H, the modification of other cable Back ground Informations only needs to input modification information in corresponding pane and preserved.

I, above-mentioned all information changes can be carried out at batch modification interface.Multiple target right buttons are selected to be repaiied into batch Change.Complete backed off after random batch modification interface.

J, in " cable that I checks in ", newly-increased pattern is switched to, cable volume can be increased one by one.

K, in " cable that I checks in ", click cable by right key, cable can be carried out deleting and arrive " cable recycle bin ", prevented Delete by mistake.In " cable recycle bin ", right button clicks cable and cable can be replied and deleted.

4）Check node capacity：The floating frame " node editing interface " hidden automatically by " cable laying " entrance left side

A, into " node display and calling " interface, the nodal information and electricity in each region are observed by node arborescence The information such as cable filling rate, " cable charging ratio " include the actual filling rate of cable and remove reserve level after occupancy, and coordinate it is red, Yellow, green three colors prompting.When actual filling rate surpasses 100%, this status bar takes on a red color, then it represents that this node cables capacity is beyond real The limit in space is laid on border；When the occupancy after removing reserve level reaches 100%, status bar is in yellow, then it represents that this node electricity Cable capacity has reached design critical point, in green during less than 100%.If it find that there is hidden danger or do not met in node space It is required that adjustment is then needed to remove other paths, or increase node capacity by the cable of this node.Activated by double-clicking nodename Node editor, capacity, the reserve level of node can be changed in " node editing machine ".It can also be looked into simultaneously by " node layout " The section arrangement of each node is seen and manually adjusted, CAD can also be produced and go out figure.

B, check the cable information that certain node passes through in " node passes through cable ", and can derived inventory be directly used in MCT cable packages software calculates, production MCT module selection layout viewings.

C, when node is excessive, destination node can be searched for by " querying node and management ".Right button, which is clicked, have been inquired about Node out, can be to information such as the capacity of node, filling rate, region, affiliated DP paths.

D, cable volume management system can be according to the DP paths of cable and the DP route matchings of cable junctions, with the type of cable To distinguish standard, the node batch included in default main cable path or specific DP paths is added to, active force In the path of cable or DP cables, cable trace trans-regional over long distances is automatically generated.

5）Cable volume issues：By " cable inventory issues " interface in " cable inventory ", cable form and lower generating are exported Cable

A, all cables of " only check and locked cable " and project can be checked by " checking project cable ".（It can lead to Cross the cable that " beginning date edited " and " end date edited " are checked in special time period）

B, by " cable volume form " can informal export current queries cable, for internal communication and checking

C, the cable of current queries can be exported by " issue cable and achieve ", formally issues cable inventory.And achieve and lead The date gone out, to carry out " contrast difference "

D, by " comparison in difference " in " change variance analysis ", cable derived from the cable and history of current queries can be entered The contrast differences such as row " newly-increased cable " " modification cable " " deletion cable ".（It may be selected formally to issue by " history exports the date " The specific date of archive is contrasted）

The modification state of every cable is added into preparation using " Match " program of Excel VB exploitations to issue most New edition cable volume remarks arrange.

6）Lay daily record：" cable management " drop-down is selected, can be according to Object Name, " operation thing into " laying daily record " Any record in the information inquiry project cable volume design overall process such as item ", " operating personnel ".

Cable volume management system of the present invention can be used to assist in realizing the cable laying of various Larger Engineering Projects And company's cable dosage management aspect.For example, the cable laying in offshore engineering, is to put into practice by multiple projects, effect Significantly.General semi-submersible type sea work project, in the case of the cable volume of traditional approach modified version, nearly 10 engineer's nights with After day, overtime work daily to evening very late, still needs to complete within 5 to 6 months, and it is full existing that many places bracket often occurs As not meeting code requirement, designing quality causes anxiety, and has a strong impact on manufacturing schedule.Seem awkward.For improve operating efficiency and Designing quality, guarantee project are steadily promoted, and row cable volume management system, cable volume forming process have above been pushed away in multiple extra large work projects All control at 4 months or so, and accuracy rate and bracket prevent the quality aspect such as full also apparently higher than the project of traditional approach.Section Save 30 to 60 working days, account for the 45%~60% of the cable volume overall design time, for project construction progress add one layer it is strong Guarantee.This system day cable trace locking situation of radical more than 1000 repeatedly occurs.Conventional method odd-numbered day design flow is most Not over 300.Because this system is made up of numerous information association programs, in terms of later stage cable volume information changes maintenance Advantage renewal is obvious, and single single-point operation can be by disposably renewal is not in omit in place with the information to be updated.Than Such as the change in location of some equipment, or the change of certain euclidean distance between node pair, only it need to update and refresh in database.For another example certain Cross-section of cable diameter change, the information only need to be updated in cable storehouse, the filling rate of all associated nodes can all be unified Renewal.All users can obtain the last state of cable volume, traditional cable volume by this network service platform, the very first time Issuing flow at least needs the time, for the project later stage, strive point more than second sprint stage, per minute is all most valuable 's.It can also avoid simultaneously because information delay causes to do over again.

Claims (2)

1. A kind of 1. cable volume management system, it is characterised in that：The management system includes user profile（1）, believe with the user Breath（1）Connected user logins interface（2）, with the user profile（1）It is connected and is logged in for user according to affiliated allocation of items The project information storehouse of authority（3）With rights management storehouse（4）, it is described to login interface（2）With Technology design management system（5）It is connected, The Technology design management system（5）While and cable management system（6）With the rights management storehouse（4）It is connected, the cable Management system（6）It is that cable specification safeguards storehouse including the total storehouse of cable data（7）, project master data storehouse（8）, cable inventory（9）, electricity Cable is laid（10）With laying daily record（11）, the project information storehouse（3）Simultaneously storehouse is safeguarded with the cable specification（7）, the item Mesh primary database（8）It is connected, the user profile（1）Simultaneously with the rights management storehouse（4）, the laying daily record（11）Phase Even；

   The cable laying（10）Including node editing interface storehouse（12）, allograph enter cable（13）, I check in cable（14）And electricity Cable recycle bin（15）；

   The cable inventory（9）Cable volume is imported including batch（16）, cable inventory issues（17）, change variance analysis（18）；

   The cable specification safeguards storehouse（7）Including the tree-like displaying storehouse of global cable specification（19）, form displaying storehouse（20）, cable mark Standard safeguards storehouse（21）, cable producer safeguard storehouse（22）, project cable specification storehouse（23）；

   The project master data storehouse（8）Safeguarded including type of cable（24）, regional maintenance（25）, electrical equipment storehouse（26）, Dp master Data（27）And safeguard storehouse with the cable specification（7）In the project cable specification storehouse that is used in conjunction with（23）.
2. 2. cable volume management system according to claim 1, it is characterised in that：The node editing interface storehouse（12）Including section Point editing machine, node batch upload, node is by cable, node layout, node display and calling, querying node and management, section Distance Batch uploads between point.