CN111105216B - Cable statistical method based on local area network and application - Google Patents
Cable statistical method based on local area network and application Download PDFInfo
- Publication number
- CN111105216B CN111105216B CN201911374490.0A CN201911374490A CN111105216B CN 111105216 B CN111105216 B CN 111105216B CN 201911374490 A CN201911374490 A CN 201911374490A CN 111105216 B CN111105216 B CN 111105216B
- Authority
- CN
- China
- Prior art keywords
- client
- information
- cable
- main server
- clients
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000007619 statistical method Methods 0.000 title claims description 7
- 238000000034 method Methods 0.000 claims abstract description 24
- 238000001514 detection method Methods 0.000 claims description 6
- 238000012790 confirmation Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 2
- 238000013461 design Methods 0.000 abstract description 13
- 238000010276 construction Methods 0.000 abstract description 3
- 238000013500 data storage Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 abstract description 2
- 238000012795 verification Methods 0.000 abstract 1
- 238000004891 communication Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000013178 mathematical model Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G06Q50/40—
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/50—Reducing energy consumption in communication networks in wire-line communication networks, e.g. low power modes or reduced link rate
Abstract
The invention discloses a cable statistics method based on a local area network and application thereof, and mainly aims to solve the problems of repeated cable numbers, heavy cable statistics workload and the like in the design of electric construction diagrams of power stations and substations. The method comprises a main server and a plurality of clients in a local area network, wherein the main server and the clients are communicated by the local area network, and the functions of data storage, information verification, automatic export and the like of a multi-user simultaneous compiling statistical cable are completed. The problems that the construction period is short, the workload is heavy, the accuracy cannot be guaranteed and the like in cable compiling statistics in electrical design are effectively solved.
Description
Technical Field
The invention relates to a cable statistical method, in particular to a cable statistical method based on a local area network and application thereof.
Background
In the prior art, the method for cable statistics faces the problems of easiness in repetition and overhigh communication cost when the multi-person collaborative design is carried out. At present, cable compiling statistics is mainly implemented in two methods, namely, a manual design matching and statistics method and a method most applied at present. When the design work is carried out, a rough compiling statistical rule is formulated in advance, a plurality of designers carry out compiling statistics on the cable according to the preset rule, the cable compiling conditions of other designers related to the system are continuously inquired in the process, the cable compiling conditions are timely modified, finally, the special personnel are responsible for statistics to EXCEL, and whether repeated or missing items exist or not is searched, so that the accuracy of cable compiling statistics is difficult to guarantee, and a great deal of effort is also necessary to be spent on the work. And secondly, along with the application of three-dimensional design software, establishing a node corresponding to each electric loop and a mathematical model of an edge corresponding to a wire pipe or a bridge for connecting two adjacent electric devices according to a pre-established three-dimensional design model corresponding to the electric system, establishing each relation tree corresponding to each electric loop according to a control logic relation corresponding to each electric loop, calculating the cable length corresponding to each relation tree according to the mathematical model diagram and each relation tree, and obtaining the cable engineering quantity of the corresponding electric loop according to the cable length corresponding to each relation tree, thereby completing the compiling statistics of the cables. The second method needs to be established under the condition that the civil engineering related professional three-dimensional model is completely free of problems and all the electrical equipment is arranged, and in the actual design work, the arrangement of all the electrical equipment and the electrical construction drawing are often carried out simultaneously, and as the design goes deep, more modification can occur in the arrangement, so that the repeated operation of the cable compiling statistics is caused. In the collaborative design of multiple electrical engineers, the three-dimensional model itself does not have the function of guaranteeing the uniqueness of each cable weave.
How to ensure the accuracy of cable establishment statistics in the electrical professional multi-person collaborative design, the large workload of cable establishment statistics and high time cost become the problem to be solved in the electrical design work .
Disclosure of Invention
The invention aims to solve the technical problem of providing a cable statistical method and application based on a local area network, which can automatically check repetition in real time through clients during collaborative design of multiple persons, and ensure the consistency of information in each client through recording and synchronizing time information.
In order to solve the technical problems, the invention adopts the following technical scheme: a cable statistical method based on local area network is applied to a plurality of clients and a main server in the local area network, wherein the main server is only used for synchronizing and backing up data in the clients, and when no host is detected or can not be connected due to reasons, the plurality of clients can normally complete statistics, and the method comprises the following steps:
(1) The main server manually inputs a new user name and a corresponding password by an administrator, and manually exports backup data of a certain project in the main server;
(2) The client detects whether the newly input cable data of the user is repeated with the existing data, and prompts the user to modify the repeated data; the client data comes from the data synchronized by the local data and the main server, and when the main server cannot be connected, the client can maintain data consistency by exchanging data with other clients in the local area network.
The method specifically comprises the following steps:
(1) An administrator adds, modifies or deletes a user name and a corresponding password through a main server side, a client side synchronizes user name and password information through a server, and a user logs in the client side by using the user name and the password;
(2) When a user logs in a client, if the client can be connected to a main server, the main server sends an IP address in a local area network and login time to the main server, and after receiving the information, the main server packages the local area network IP address in the information and the last local area network IP address information logged in by other clients and sends back the current login client; when the client cannot be connected to the main server for login, the client tries to connect with other clients by using the IP address list acquired in the last login, and synchronizes the user name and password information from the other clients;
(3) After a user logs in a client, a main server sends the current time which is accurate to 0.1 second and the network delay time length measured in milliseconds to the client, the client calculates the time difference between the local time and the main server according to the current time, and the client converts the information into the main server time and records the server time under the condition that the client needs to record the time in the subsequent operation;
(4) When the client cannot access the main server, sending a request for synchronizing time to other connectable clients, and calculating the main server time according to a method for calculating the main server after receiving the current time information of the server sent by other clients; temporarily storing the data to the client, and automatically synchronizing the data to a main server database after the main server works;
(5) In the process that a user inputs new cable information into a client, the client compares the information with local existing cable information, checks for no repetition or conflict, then sends secondary confirmation to the user, after the user confirms that no error exists, the client packages and sends the cable information, a local IP and MAC address and operation time taking a main server as a reference to other clients, the other clients detect whether the cable information is repeated, all received information is added into a local cable database if the detection is correct, and if the detection is correct, the information containing relevant conflict/repeated cable information is sent to an information source client;
(6) When the client receives information returned by other clients, the received information is compared with the information locally containing the same cable name, and the client is informed of checking the same record by taking one piece of information with earlier operation time as the reference;
(7) When a user deletes or modifies one cable information record at a client, the original record is not changed, and only one new cable information record is added to indicate that the original record is replaced or deleted, and other clients are required to check when the operation is performed;
(8) And the client classifies and outputs the cables according to the cable information in the local database.
The computer program of the cable statistics method based on the local area network.
The information data processing terminal based on the local area network cable statistics method.
A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the local area network based cable statistics method described above.
The beneficial effects of the invention are as follows: in the process of centralized engineering design, a plurality of persons cooperate to complete cable statistics work, a computer completes cable checking, re-checking and checking work, local data of all participants are ensured to be consistent, time of manual communication is reduced, and mistakes and heavy items in engineering statistics are effectively avoided. And independent statistics work is not needed to be carried out on the cable according to the drawing. In practical tests, the statistical workload of the cable can be effectively reduced for about one week.
Drawings
Fig. 1 is a flow chart of the local area network based cable statistics of the present invention.
Detailed Description
The invention is described in further detail below with reference to the attached drawings and detailed description:
as shown in fig. 1, the cable statistics method based on local area network of the present invention is applied to a plurality of clients and a main server in the local area network, the main server is only used for synchronizing and backing up data in the clients, and when no host is detected or cannot be connected due to reasons, the plurality of clients can normally complete statistics, comprising the following steps:
(1) The main server manually inputs a new user name and a corresponding password by an administrator, and manually exports backup data of a certain project in the main server;
(2) The client detects whether the newly input cable data of the user is repeated with the existing data, and prompts the user to modify the repeated data; the client data comes from the data synchronized by the local data and the main server, and when the main server cannot be connected, the client can maintain data consistency by exchanging data with other clients in the local area network.
The method specifically comprises the following steps:
(1) An administrator adds, modifies or deletes a user name and a corresponding password through a main server side, a client side synchronizes user name and password information through a server, and a user logs in the client side by using the user name and the password;
(2) When a user logs in a client, if the client can be connected to a main server, the main server sends an IP address in a local area network and login time to the main server, and after receiving the information, the main server packages the local area network IP address in the information and the last local area network IP address information logged in by other clients and sends back the current login client; when the client cannot be connected to the main server for login, the client tries to connect with other clients by using the IP address list acquired in the last login, and synchronizes the user name and password information from the other clients;
(3) After a user logs in a client, a main server sends the current time which is accurate to 0.1 second and the network delay time length measured in milliseconds to the client, the client calculates the time difference between the local time and the main server according to the current time, and the client converts the information into the main server time and records the server time under the condition that the client needs to record the time in the subsequent operation;
(4) When the client cannot access the main server, sending a request for synchronizing time to other connectable clients, and calculating the main server time according to a method for calculating the main server after receiving the current time information of the server sent by other clients; temporarily storing the data to the client, and automatically synchronizing the data to a main server database after the main server works;
(5) In the process that a user inputs new cable information into a client, the client compares the information with local existing cable information, checks for no repetition or conflict, then sends secondary confirmation to the user, after the user confirms that no error exists, the client packages and sends the cable information, a local IP and MAC address and operation time taking a main server as a reference to other clients, the other clients detect whether the cable information is repeated, all received information is added into a local cable database if the detection is correct, and if the detection is correct, the information containing relevant conflict/repeated cable information is sent to an information source client;
(6) When the client receives information returned by other clients, the received information is compared with the information locally containing the same cable name, and the client is informed of checking the same record by taking one piece of information with earlier operation time as the reference;
(7) When a user deletes or modifies one cable information record at a client, the original record is not changed, and only one new cable information record is added to indicate that the original record is replaced or deleted, and other clients are required to check when the operation is performed;
(8) And the client classifies and outputs the cables according to the cable information in the local database.
In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When used in whole or in part, is implemented in the form of a computer program product comprising one or more computer instructions. When loaded or executed on a computer, produces a flow or function in accordance with embodiments of the present invention, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by a wired (e.g., coaxial cable, fiber optic, digital Subscriber Line (DSL), or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid State Disk (SSD)), etc.
The above-described embodiments are only for illustrating the technical spirit and features of the present invention, and it is intended to enable those skilled in the art to understand the content of the present invention and to implement it accordingly, and the scope of the present invention is not limited to the embodiments, i.e. equivalent changes or modifications to the spirit of the present invention are still within the scope of the present invention.
Claims (3)
1. The cable statistical method based on the local area network is characterized by comprising the following steps of:
(1) An administrator adds, modifies or deletes a user name and a corresponding password through a main server side, a client side synchronizes user name and password information through a server, and a user logs in the client side by using the user name and the password;
(2) When a user logs in a client, if the client can be connected to a main server, the main server sends an IP address in a local area network and login time to the main server, and after receiving the information, the main server packages the local area network IP address in the information and the last local area network IP address information logged in by other clients and sends back the current login client; when the client cannot be connected to the main server for login, the client tries to connect with other clients by using the IP address list acquired in the last login, and synchronizes the user name and password information from the other clients;
(3) After a user logs in a client, a main server sends the current time which is accurate to 0.1 second and the network delay time length measured in milliseconds to the client, the client calculates the time difference between the local time and the main server according to the current time, and the client converts the information into the main server time and records the server time under the condition that the client needs to record the time in the subsequent operation;
(4) When the client cannot access the main server, sending a request for synchronizing time to other connectable clients, and calculating the main server time according to a method for calculating the main server after receiving the current time information of the server sent by other clients; temporarily storing the data to the client, and automatically synchronizing the data to a main server database after the main server works;
(5) In the process that a user inputs new cable information into a client, the client compares the information with local existing cable information, checks for no repetition or conflict, then sends secondary confirmation to the user, after the user confirms that no error exists, the client packages and sends the cable information, a local IP and MAC address and operation time taking a main server as a reference to other clients, the other clients detect whether the cable information is repeated, all received information is added into a local cable database if the detection is correct, and if the detection is correct, the information containing relevant conflict/repeated cable information is sent to an information source client;
(6) When the client receives information returned by other clients, the received information is compared with the information locally containing the same cable name, and the client is informed of checking the same record by taking one piece of information with earlier operation time as the reference;
(7) When a user deletes or modifies one cable information record at a client, the original record is not changed, and only one new cable information record is added to indicate that the original record is replaced or deleted, and other clients are required to check when the operation is performed;
(8) And the client classifies and outputs the cables according to the cable information in the local database.
2. An information data processing terminal for implementing the local area network-based cable statistics method of claim 1.
3. A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the local area network based cable statistics method of claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911374490.0A CN111105216B (en) | 2019-12-27 | 2019-12-27 | Cable statistical method based on local area network and application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911374490.0A CN111105216B (en) | 2019-12-27 | 2019-12-27 | Cable statistical method based on local area network and application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111105216A CN111105216A (en) | 2020-05-05 |
| CN111105216B true CN111105216B (en) | 2023-08-25 |
Family
ID=70424145
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911374490.0A Active CN111105216B (en) | 2019-12-27 | 2019-12-27 | Cable statistical method based on local area network and application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111105216B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101771723A (en) * | 2010-01-05 | 2010-07-07 | 深圳中兴网信科技有限公司 | Data synchronization method |
| CN103873451A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团公司 | Data synchronization method, equipment and system |
| CN104376415A (en) * | 2014-11-17 | 2015-02-25 | 南通中远船务工程有限公司 | Cable book management system |
| CN106599149A (en) * | 2016-12-07 | 2017-04-26 | 爱普（福建）科技有限公司 | Encoding method of engineering text |
| CN106797402A (en) * | 2014-10-14 | 2017-05-31 | 佳能株式会社 | Information processing system, information processor and its control method, image processing system and its control method and program |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004086284A (en) * | 2002-08-23 | 2004-03-18 | Tdk Corp | Log-in method of client server system, computer program, and recording medium |
-
2019
- 2019-12-27 CN CN201911374490.0A patent/CN111105216B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101771723A (en) * | 2010-01-05 | 2010-07-07 | 深圳中兴网信科技有限公司 | Data synchronization method |
| CN103873451A (en) * | 2012-12-17 | 2014-06-18 | 中国移动通信集团公司 | Data synchronization method, equipment and system |
| CN106797402A (en) * | 2014-10-14 | 2017-05-31 | 佳能株式会社 | Information processing system, information processor and its control method, image processing system and its control method and program |
| CN104376415A (en) * | 2014-11-17 | 2015-02-25 | 南通中远船务工程有限公司 | Cable book management system |
| CN106599149A (en) * | 2016-12-07 | 2017-04-26 | 爱普（福建）科技有限公司 | Encoding method of engineering text |
Non-Patent Citations (1)
| Title |
|---|
| 林妍.局域网内即时通讯系统的设计.中国新通信.2013,(第12期),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111105216A (en) | 2020-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109274557B (en) | Intelligent CMDB management and cloud host monitoring method in cloud environment | |
| CN109254922B (en) | Automatic testing method and device for BMC Redfish function of server | |
| CN105989140B (en) | A kind of data block processing method and equipment | |
| CN109683911A (en) | A kind of system for realizing automation application deployment and impact analysis | |
| CN110659255A (en) | Data migration method, device and system and storage medium | |
| CN103441861A (en) | Method and device for generating data records | |
| CN110706800A (en) | Automatic management method and device for equipment maintenance, computer equipment and storage medium | |
| CN111105216B (en) | Cable statistical method based on local area network and application | |
| CN106998271B (en) | Automatic adaptation processing system and method | |
| CN105095024A (en) | File backup method and device | |
| CN113746684B (en) | Network equipment management method and device, computer equipment and storage medium | |
| CN109683860A (en) | A kind of computer software project management platform, equipment and readable storage medium storing program for executing | |
| US10353365B2 (en) | Electric power facilities identification number generation apparatus and method | |
| CN114116288A (en) | Fault processing method, device and computer program product | |
| CN112579699A (en) | Quality monitoring method, system and storage medium for service data processing link | |
| CN113014416A (en) | Method, system, device and storage medium for automatically configuring and managing network device | |
| CN111143315A (en) | Version management method of transformer substation secondary circuit information model based on Git | |
| CN110716726A (en) | Client updating method and device, electronic equipment and computer readable storage medium | |
| CN108667932A (en) | One kind two-shipper big data application attachment management device and method under load operation conditions | |
| CN113363965B (en) | Dynamic identification method for topological structure of low-voltage power distribution network | |
| CN107341250A (en) | A kind of quick-searching Database Systems suitable for the planning of extensive power grid | |
| CN115203876A (en) | Red and black image updating method, device, equipment and medium | |
| CN107124293A (en) | The protocol managerial approach and system of a kind of distributed network system (DNS) | |
| CN109656519B (en) | Method and device for automatically accessing service data | |
| CN117938909A (en) | Data transmission method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |