CN114090611A - Method and device for generating cable inventory by terminal wiring table and electronic equipment - Google Patents
Method and device for generating cable inventory by terminal wiring table and electronic equipment Download PDFInfo
- Publication number
- CN114090611A CN114090611A CN202111347512.1A CN202111347512A CN114090611A CN 114090611 A CN114090611 A CN 114090611A CN 202111347512 A CN202111347512 A CN 202111347512A CN 114090611 A CN114090611 A CN 114090611A
- Authority
- CN
- China
- Prior art keywords
- cable
- information
- database
- inventory
- repeated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90344—Query processing by using string matching techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90348—Query processing by searching ordered data, e.g. alpha-numerically ordered data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/12—Geometric CAD characterised by design entry means specially adapted for CAD, e.g. graphical user interfaces [GUI] specially adapted for CAD
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/16—Cables, cable trees or wire harnesses
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Geometry (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Computational Mathematics (AREA)
- Mathematical Physics (AREA)
- Mathematical Analysis (AREA)
- Mathematical Optimization (AREA)
- Probability & Statistics with Applications (AREA)
- Human Computer Interaction (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Fuzzy Systems (AREA)
- Software Systems (AREA)
- Architecture (AREA)
- Quality & Reliability (AREA)
- Electric Cable Installation (AREA)
Abstract
The invention discloses a method, a device and electronic equipment for generating a cable inventory by a terminal wiring table, belonging to the technical field of electrical professional design of a thermal power plant, comprising the following steps of S1, identifying the terminal wiring table to extract cable information, sequencing the extracted cable information, and storing the sequenced cable information into a database, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface. The invention achieves the technical effects of saving consumed time, improving efficiency and improving accuracy.
Description
Technical Field
The invention belongs to the technical field of electrical professional design of thermal power plants, and particularly relates to a method and a device for generating a cable list by a terminal wiring meter and electronic equipment.
Background
With the popularization of computer application, AutoCAD drawing plays an important role in engineering drawing, and has been comprehensively applied to each link in engineering construction to replace the traditional manual drawing. AutoCAD has found widespread application as a successful piece of computer-aided software in engineering drawing, which can assist designers in drawing designs. The function of the CAD software in some professional fields is insufficient or lacked, secondary development is carried out on the CAD software, and a professional module which accords with the specific field is designed.
At present, in the electrical professional design technology of a thermal power plant, manual work is usually performed to complete cable inventory making under AUTOCAD drawing software, but in the process of manually making the cable inventory, a large amount of time is consumed, the efficiency is low, and the accuracy is poor because a large amount of data input and processing work needs to be manually completed. In summary, in the existing electrical professional design technology of the thermal power plant, there are technical problems of long consumed time, low efficiency and poor accuracy.
Disclosure of Invention
The invention aims to solve the technical problems that the operation effect of emergency treatment on the fault of the gas boiler is difficult to visually show and the efficiency of operation training is low.
In order to solve the technical problem, the invention provides a method for generating a cable inventory by a terminal connection table, which comprises the following steps: step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
Further, the step S2 is followed by: if not, the step S4 is executed.
Further, the identifying the terminal connection table to extract the cable information includes: selecting a layer where a drawing frame in the terminal wiring table is located, and sorting the cable information in each layer of drawing so as to extract different types of cable information through a ' text ' under category ' value; the sorting the extracted cable information includes: the different kinds of cable information are ordered by "position X" and "position Y information" under the "geometry" category, and "height" under the "text" category.
Further, the storing the sorted cable information into a database includes: and establishing a database corresponding to the cable information by taking the cable inventory as a template, wherein each line in the template is a cable, and each column in the template is an attribute of the cable, and storing the sequenced cable information into the established database.
Further, the judging whether the cable information stored in the database is duplicated includes: comparing the character strings in the database to judge whether repeated character strings exist in the cable number information column; if yes, judging that the cable information stored in the database is repeated; if not, judging that the cable information stored in the database is not repeated.
Further, the deleting duplicate cable information includes: and deleting the repeated character strings in the database.
Further, the human-computer interaction interface comprises: importing and exporting an operation area of a database, editing an information editing area of CAD template information, selecting selection areas of different CAD templates, and generating a function area of a statistical material and a CAD drawing.
According to another aspect of the present invention, the present invention also provides an apparatus for generating a cable inventory of a terminal connection table, the apparatus comprising: an extraction and storage module, configured to, in step S1, identify the terminal connection table to extract cable information, and sort the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; a judging module, configured to judge whether the cable information stored in the database is duplicated in step S2; a deleting module, configured to delete the duplicated cable information if the duplicate cable information is deleted in step S3; and the automatic generation module is used for automatically generating corresponding result information according to the cable information and the contents selected in the human-computer interaction interface in the step S4, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
According to yet another aspect of the present invention, the present invention further provides an electronic device for generating a cable inventory by using a termination table, comprising a memory, a processor and a computer program stored in the memory and running on the processor, wherein the processor executes the program to realize the following steps: step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
According to yet another aspect of the present invention, there is also provided a computer-readable storage medium for generating a cable inventory of a terminal connection table, having a computer program stored thereon, which when executed by a processor, performs the steps of: step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
Has the advantages that:
the invention provides a method for generating a cable list by a terminal connection table, which comprises the following steps of identifying the terminal connection table through step S1 to extract cable information, sequencing the extracted cable information, and storing the sequenced cable information into a database, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
Fig. 1 is a flowchart of a method for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a human-computer interaction interface in a method for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention;
fig. 3 is a block diagram of a device for generating a cable inventory of a terminal connection table according to an embodiment of the present invention;
fig. 4 is a structural diagram of an electronic device for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention;
fig. 5 is a block diagram of a computer-readable storage medium for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention.
Detailed Description
The invention discloses a method for generating a cable list by a terminal wiring table, which comprises the following steps of identifying the terminal wiring table through a step S1 to extract cable information, sequencing the extracted cable information, and storing the sequenced cable information into a database, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present invention; the "and/or" keyword referred to in this embodiment represents sum or two cases, in other words, a and/or B mentioned in the embodiment of the present invention represents two cases of a and B, A or B, and describes three states where a and B exist, such as a and/or B, which represents: only A does not include B; only B does not include A; including A and B.
It will be understood that, although the terms first, second, etc. may be used herein to describe various elements, components, regions, layers and/or sections, these elements, components, regions, layers and/or sections should not be limited by these terms. These terms are only used to distinguish one element, component, region, layer or section from another element, component, region, layer or section. Thus, a first element, component, region, layer or section discussed below could be termed a second element, component, region, layer or section without departing from the teachings of the example embodiments. Spatially relative terms, such as "below," "above," and the like, may be used herein to facilitate describing one element or feature's relationship to another element or feature. It will be understood that the spatially relative terms are intended to encompass different orientations of the device in use or operation in addition to the orientation depicted in the figures. For example, if the device in the figures is turned over, elements or features described as "lower" would then be oriented "upper" other elements or features. Thus, the exemplary term "below" can encompass both an orientation of above and below. The device may be oriented (rotated 90 degrees or at other orientations) and the spatially relative descriptors used herein interpreted accordingly.
Also, in embodiments of the invention where an element is referred to as being "secured to" another element, it can be directly on the other element or intervening elements may also be present. When a component is referred to as being "connected" to another component, it can be directly connected to the other component or intervening components may also be present. When a component is referred to as being "disposed on" another component, it can be directly on the other component or intervening components may also be present. The terms "vertical," "horizontal," "left," "right," and the like as used in the embodiments of the present invention are for illustrative purposes only and are not intended to limit the present invention.
Example one
Referring to fig. 1, fig. 1 is a flowchart of a method for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention. The embodiment of the invention provides a method for generating a cable list by a terminal connection table, which comprises the following steps:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
the identifying the terminal wiring table to extract the cable information includes: selecting a layer where a drawing frame in the terminal wiring table is located, and sorting the cable information in each layer of drawing so as to extract different types of cable information through a ' text ' under category ' value; the sorting the extracted cable information includes: the different kinds of cable information are ordered by "position X" and "position Y information" under the "geometry" category, and "height" under the "text" category. The storing the sequenced cable information into a database comprises: and establishing a database corresponding to the cable information by taking the cable inventory as a template, wherein each line in the template is a cable, and each column in the template is an attribute of the cable, and storing the sequenced cable information into the established database.
Specifically, a computer program is adopted to arrange the cable information in each drawing of the drawing layer where the drawing frames in the terminal wiring table are located, different types of cable information are extracted according to the value under the category of ' text ', and then the different types of cable information are sorted according to the position X ' and the position Y information under the category of ' geometric figure ', and the height under the category of ' text '. Meanwhile, a cable inventory is taken as a main template, each line in the template is a cable, each column is one attribute of the cable, a computer program is adopted to establish a database which corresponds to cable information one by one, namely, a database corresponding to different cables is established, and then the extracted information is stored in the corresponding database.
Step S2, judging whether the cable information stored in the database is repeated;
comparing the character strings in the database to judge whether repeated character strings exist in the cable number information column;
if yes, judging that the cable information stored in the database is repeated; if not, judging that the cable information stored in the database is not repeated.
Specifically, the computer program compares the character strings in the database in step S1, and if the cable number information series have the same character string, it is determined that the cable information stored in the database is duplicated, and the process proceeds to step S3 described below. If the cable number information sequences do not have the same character string, it is determined that the cable information stored in the database is not duplicated, and the process proceeds to step S4 described below.
Step S3, if yes, deleting the repeated cable information;
the deleting duplicate cable information includes: and deleting the repeated character strings in the database.
Specifically, by determining that the cable information stored in the database is duplicated in step S2, duplicated cable information and useless information can be deleted, for example, by deleting the remaining several duplicated character strings, only one line of the character string is reserved.
The step S2 may further include: if not, the step S4 is executed.
Specifically, if it is determined in step S2 that the cable number information string is a character string that is not repeated, the following step S4 may be executed.
And step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Wherein, the human-computer interaction interface comprises: importing and exporting an operation area of a database, editing an information editing area of CAD template information, selecting selection areas of different CAD templates, and generating a function area of a statistical material and a CAD drawing.
Specifically, referring to fig. 2, fig. 2 is a schematic diagram of a human-computer interaction interface in a method for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention. The dialog box may be set using the ShowDialog () function in the Form class provided by NETAPI; and setting a 'create Excel' button in a dialog box, operating the 'create Excel' button corresponding to a CadToexcel function in a program, and selecting to add a cable information extraction part in the cad, or arrange data in the cad into a data part, or import database information into the Excel part. Establishing a corresponding window Form, adding a TextBox control, and returning information such as a project name, a drawing number, a sequence number and the like which need to be filled in the CAD to a program from the filling of a designer; and adding an Optionbutton control, wherein the corresponding generated drawings are common drawings, combined drawings and Chinese and English drawings. A CheckBox control is added as an option to choose whether to add a cable path column. Add CommandButton control and add Command _ Click () function as buttons for "statistics" and "generate Cad drawings". Thus, an operation area (operation area for short) for importing and exporting the database is formed in the man-machine interaction interface; an information editing area (information editing area for short) for editing CAD template information, such as information of project names, project projects, dates, serial numbers and the like; a selection area (simply referred to as a selection area) for selecting different CAD templates; and the functional area (functional area for short) is used for generating statistical materials and CAD drawings. The designer can automatically generate a cable inventory Excel edition, a cable inventory CAD edition or a cable information statistical table and the like by performing corresponding operation in the operation area, the information editing area, the selection area and the function area according to the content selected by the designer, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved.
The invention provides a method for generating a cable list by a terminal connection table, which comprises the following steps of identifying the terminal connection table through step S1 to extract cable information, sequencing the extracted cable information, and storing the sequenced cable information into a database, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
In order to describe the device for generating the cable inventory by the terminal connection table provided by the invention in detail, the method for generating the cable inventory by the terminal connection table in the embodiment has been described in detail.
Example two
Referring to fig. 3, fig. 3 is a block diagram of a device for generating a cable list by using a terminal connection table according to an embodiment of the present invention. The second embodiment of the present invention provides an apparatus for generating a cable inventory by using a terminal connection table, which includes an extraction storage module 200, configured to, in step S1, identify the terminal connection table to extract cable information, and sort the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
a judging module 210, configured to, in step S2, judge whether the cable information stored in the database is duplicated;
a deleting module 220, configured to, in step S3, delete duplicate cable information if yes;
and an automatic generation module 230, configured to, in step S4, automatically generate corresponding result information according to the cable information and the content selected in the human-computer interaction interface, where the result information includes a cable inventory Excel version, a cable inventory CAD version, or a cable information statistical table.
The invention provides a device for generating a cable list by a terminal wiring table, which is characterized in that an extraction storage module 200 is used in step S1, the terminal wiring table is identified to extract cable information, the extracted cable information is sorted to store the sorted cable information into a database, and the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; the judging module 210 is configured to, in step S2, judge whether the cable information stored in the database is duplicated; the deleting module 220 is configured to step S3, and if yes, delete the duplicate cable information; the automatic generation module 230 is configured to, in step S4, automatically generate corresponding result information according to the cable information and the content selected in the human-computer interaction interface, where the result information includes a cable inventory Excel version, a cable inventory CAD version, or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
In order to describe the electronic device for generating the cable inventory by the terminal wiring table in the third embodiment in detail, the method for generating the cable inventory by the terminal wiring table in the third embodiment is described in detail.
EXAMPLE III
Referring to fig. 4, fig. 4 is a structural diagram of an electronic device for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention. The third embodiment of the present invention provides an electronic device for generating a cable inventory by using a terminal connection table, which includes a memory 310, a processor 320, and a computer program 311 stored in the memory 310 and operable on the processor 320, where the processor 320 executes the program 311 to implement the following steps:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
step S2, judging whether the cable information stored in the database is repeated;
step S3, if yes, deleting the repeated cable information;
and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
The invention provides an electronic device for generating a cable inventory by a terminal connection table, which identifies the terminal connection table to extract cable information and sorts the extracted cable information to store the sorted cable information into a database through step S1, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
In order to provide a computer-readable storage medium for generating a cable inventory by using a terminal connection table, the above embodiments describe in detail a method for generating a cable inventory by using a terminal connection table one by one.
Example four
Referring to fig. 5, fig. 5 is a block diagram of a computer-readable storage medium 400 for generating a cable inventory by using a terminal connection table according to an embodiment of the present invention. A fourth embodiment of the present invention provides a computer-readable storage medium 400 for generating a cable inventory by using a terminal connection table, wherein a computer program 411 is stored thereon, and when being executed by a processor 320, the computer program implements the following steps:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
step S2, judging whether the cable information stored in the database is repeated;
step S3, if yes, deleting the repeated cable information;
and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
The invention provides a computer readable storage medium for generating a cable inventory by a terminal connection table, identifying the terminal connection table to extract cable information and sequencing the extracted cable information to store the sequenced cable information in a database by step S1, wherein the cable information comprises: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information; step S2, judging whether the cable information stored in the database is repeated; step S3, if yes, deleting the repeated cable information; and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table. Therefore, in the process of compiling the cable inventory, a designer can generate different results by checking different contents in a human-computer interaction interface, such as generating a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table, so that the repeated work of machinery is reduced, the input and processing work of a large amount of data is reduced, the consumed time is saved, the efficiency is improved, and the accuracy is improved. Therefore, the technical effects of saving consumed time, improving efficiency and improving accuracy are achieved.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention has been described in detail with reference to examples, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, which should be covered by the claims of the present invention.
Claims (10)
1. A method for generating a cable inventory for a terminal wiring table, the method comprising:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
step S2, judging whether the cable information stored in the database is repeated;
step S3, if yes, deleting the repeated cable information;
and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
2. The method for generating a cable inventory for a terminal wiring list as recited in claim 1, wherein said step S2 is followed by:
if not, the step S4 is executed.
3. The method of claim 1, wherein the method further comprises the steps of:
the identifying the terminal wiring table to extract the cable information includes: selecting a layer where a drawing frame in the terminal wiring table is located, and sorting the cable information in each layer of drawing so as to extract different types of cable information through a ' text ' under category ' value;
the sorting the extracted cable information includes: the different kinds of cable information are ordered by "position X" and "position Y information" under the "geometry" category, and "height" under the "text" category.
4. The method of claim 1, wherein storing the sorted cable information in a database comprises:
and establishing a database corresponding to the cable information by taking the cable inventory as a template, wherein each line in the template is a cable, and each column in the template is an attribute of the cable, and storing the sequenced cable information into the established database.
5. The method of claim 1, wherein said determining whether there is duplication of cable information stored in the database comprises:
comparing the character strings in the database to judge whether repeated character strings exist in the cable number information column;
if yes, judging that the cable information stored in the database is repeated;
if not, judging that the cable information stored in the database is not repeated.
6. The method of claim 1, wherein the deleting duplicate cable information comprises:
and deleting the repeated character strings in the database.
7. The method of claim 1, wherein the human-machine interface comprises:
importing and exporting an operation area of a database, editing an information editing area of CAD template information, selecting selection areas of different CAD templates, and generating a function area of a statistical material and a CAD drawing.
8. An apparatus for generating a cable inventory for a termination list, the apparatus comprising:
an extraction and storage module, configured to, in step S1, identify the terminal connection table to extract cable information, and sort the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
a judging module, configured to judge whether the cable information stored in the database is duplicated in step S2;
a deleting module, configured to delete the duplicated cable information if the duplicate cable information is deleted in step S3;
and the automatic generation module is used for automatically generating corresponding result information according to the cable information and the contents selected in the human-computer interaction interface in the step S4, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
9. An electronic device for generating a cable inventory for a termination table, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the following steps when executing the program:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
step S2, judging whether the cable information stored in the database is repeated;
step S3, if yes, deleting the repeated cable information;
and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
10. A computer-readable storage medium for a terminal connection table generating cable inventory, having a computer program stored thereon, wherein the program when executed by a processor performs the steps of:
step S1, identifying the terminal connection table to extract cable information, and sorting the extracted cable information to store the sorted cable information in a database, where the cable information includes: the method comprises the following steps of (1) cable number information, protective pipe type information, protective pipe length information, cable model information, cable specification information, cable length information, cable starting point information and cable end point information;
step S2, judging whether the cable information stored in the database is repeated;
step S3, if yes, deleting the repeated cable information;
and step S4, automatically generating corresponding result information according to the cable information and the content selected in the human-computer interaction interface, wherein the result information comprises a cable inventory Excel version, a cable inventory CAD version or a cable information statistical table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111347512.1A CN114090611A (en) | 2021-11-15 | 2021-11-15 | Method and device for generating cable inventory by terminal wiring table and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111347512.1A CN114090611A (en) | 2021-11-15 | 2021-11-15 | Method and device for generating cable inventory by terminal wiring table and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114090611A true CN114090611A (en) | 2022-02-25 |
Family
ID=80300665
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111347512.1A Pending CN114090611A (en) | 2021-11-15 | 2021-11-15 | Method and device for generating cable inventory by terminal wiring table and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114090611A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115795767A (en) * | 2023-02-07 | 2023-03-14 | 西安军捷新创电子科技有限公司 | Method for designing wiring meter of satellite land detection cable network |
-
2021
- 2021-11-15 CN CN202111347512.1A patent/CN114090611A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115795767A (en) * | 2023-02-07 | 2023-03-14 | 西安军捷新创电子科技有限公司 | Method for designing wiring meter of satellite land detection cable network |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US4635208A (en) | Computer-aided design of systems | |
| US6738957B2 (en) | Schematic organization tool | |
| US5281558A (en) | Cloning method and system for hierarchical compaction | |
| CN103605660B (en) | Graphic processing method for SCD (Substation Configuration Description) file | |
| CN107679276B (en) | Generation method and device of power system tide wiring diagram and electronic equipment | |
| JP3194823B2 (en) | CAD library model creation device | |
| CN102508654B (en) | Method for designing ladder diagram editing software of embedded PLC (Programmable Logic Controller) | |
| JPS61276059A (en) | Data input control | |
| CN101196963B (en) | Indexing system and method of generic chemical structure | |
| CN106484892A (en) | Data manipulation method and device | |
| CN112861384A (en) | CATIA-based electrostatic dust collector three-dimensional model construction method | |
| CN114090611A (en) | Method and device for generating cable inventory by terminal wiring table and electronic equipment | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| JP2001216142A (en) | Program preparation aiding device | |
| CN114595494A (en) | Auxiliary design tool kit based on AutoCAD software and construction method | |
| JPH09212353A (en) | Method and device for supporting reused design | |
| CN108563898B (en) | Man-machine interactive single-line digital modeling method for power grid | |
| CN110222050A (en) | Method and system is transferred for nuclear power plant's three-dimensional database instrument association items | |
| CN115391173A (en) | Method for converting Simulink-Stateflow model into NuSMV model | |
| CN113220664B (en) | Satellite telemetering intelligent interpretation system and method for rapidly generating Lua script rule | |
| CN113885937A (en) | RPA element repairing method based on universality | |
| CN109828985B (en) | Form difference query method and device | |
| CN106599499A (en) | Method for automatically generating XilinxFPGA constraint file | |
| Infante et al. | An interactive graphics system for the design of integrated circuits | |
| CN101604342B (en) | Method and device for making metal oxide semiconductor (MOS) transistor on integrated circuit simulating platform |
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 |