CN112948384B

CN112948384B - DCS wiring table automatic generation method, readable storage medium and computer program product

Info

Publication number: CN112948384B
Application number: CN202110224374.1A
Authority: CN
Inventors: 俞洋
Original assignee: Nanjing Guolian Electric Power Engineering Design Co ltd
Current assignee: Nanjing Guolian Electric Power Engineering Design Co ltd
Priority date: 2021-03-01
Filing date: 2021-03-01
Publication date: 2024-04-26
Anticipated expiration: 2041-03-01
Also published as: CN112948384A

Abstract

The invention provides an automatic generation method of a DCS wiring table, a readable storage medium and a computer program product, comprising the steps of determining the signal end point equipment name of an IO point according to the acquired IO name; determining a cable number according to the IO type, and identifying the repeated cable number; determining cable specifications according to IO names and IO types of the IO points, and identifying repeated cable specifications; generating a cable core logarithm according to the signal end point equipment name of each IO point and the IO type corresponding to each IO point; determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, and if the protection pipes are needed, determining the number of the protection pipes and the diameter of the needed protection pipes; and generating a DCS wiring table according to the determined parameters. According to the invention, the DCS wiring table is automatically generated by extracting the IO names and IO types in the IO point attributes in the DCS wiring table and comparing the extracted IO names and IO types with the acquired various albums, so that the productivity is fully liberated, and the accuracy and the efficiency are remarkably improved.

Description

DCS wiring table automatic generation method, readable storage medium and computer program product

Technical Field

The invention relates to an automatic generation method and system of a DCS wiring table, belonging to the interdisciplinary subjects in the field of thermal control and computers.

Background

DCS is an abbreviation of Distributed Control System, called distributed or distributed control system, which is a microprocessor-based integrated control system for centralized monitoring, operation management and decentralized control of production, integrating computer, control, communication and display technologies. Because of the characteristic of centralized control, all devices, sensors and the like which need to be controlled and monitored are connected with the DCS system. The larger the enterprise scale of the modern factory is, the worse the new energy technology and the control method are layered, so that the DCS wiring is more and more complex. A slightly large scale project has thousands of sensors and tens of thousands of IO signal points including electrically activated devices. Along with the fact that a factory identification system is more and more perfect, coding rules are more and more complex, a DCS wiring table is used as a final result of thermal control design, meanwhile, the DCS wiring table is the most important construction basis, each IO signal has more than ten corresponding attributes to be filled in, each IO signal is subjected to about 8 file comparison, one line can be filled in only through fifty steps of judgment, and thousands of wiring exist. Manually filling a form takes 10 days to half a month to complete, and the error is not prevented and can hardly be checked.

Disclosure of Invention

The invention aims to provide an automatic generation method and an automatic generation system for a DCS wiring table, aiming at the problems of complex operation, low efficiency and data accuracy to be improved in the existing generation method for the DCS wiring table.

In order to achieve the technical purpose, the invention adopts the following technical scheme:

The invention provides an automatic generation method of a DCS wiring table, which comprises the following steps: extracting IO names and IO types in each IO point attribute in the DCS wiring table; determining parameters of a DCS wiring table according to IO names and IO types, wherein the parameters comprise the following specific steps: determining the signal terminal equipment name of the IO point according to the acquired IO name; determining a cable number according to the IO type, and identifying the repeated cable number; determining cable specifications according to IO names and IO types of the IO points, and identifying repeated cable specifications; generating the cable core logarithm according to the signal end point equipment name of each IO point and the IO type corresponding to each IO point; determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, and if the protection pipes are needed, determining the number of the protection pipes and the diameter of the needed protection pipes; and generating a DCS wiring table according to the determined DCS wiring table parameters.

Further, the specific method for determining the signal endpoint device name of the IO point according to the acquired IO name comprises the following steps: comparing the acquired IO name with a transmitter list in a transmitter protection box acquired in advance, and taking the transmitter protection box name where the IO point is located as the signal end point equipment name of the IO point if the signal end point of the IO point is judged to be the transmitter protection box; otherwise, comparing the obtained IO name with the suffix of the preset coding rule, if the IO name contains the coding suffix, replacing the coding suffix with a null value, and determining the replaced IO name as the signal terminal equipment name of the IO point; if the IO name is judged to not contain the coded suffix, judging whether the IO name contains a standby character string, and if the IO name does not contain the coded suffix, judging that the signal terminal equipment name is a null value; if the 'standby' character string does not exist, judging whether the signal end point equipment is a sensor or a thermal resistor or a thermocouple according to the suffix of the corresponding IO name, and further determining the signal end point equipment. The invention determines the algorithm of the sensor connection end point. If the method is not adopted, each IO point needs to be manually input with a connecting end point. Each sensor placed in the incubator/protection box requires manual identification in the DCS wiring meter for later cable numbering, and such IO points are on average thousands of giant per project. The right completely eliminates the possibility of human error.

Further, determining the cable number according to the IO type specifically includes: the determining the cable number according to the IO type specifically comprises: and comparing the IO type with a cable rule acquired in advance, or comparing the IO name with a cable list acquired in advance to determine the cable number of each IO point, and if the cable number cannot be determined, generating the cable number of the IO point according to the IO name and the IO type of the IO point according to a preset cable number rule.

Further, determining the cable specification according to the IO name and the IO type of each IO point specifically includes: determining the cable specification of each IO point by the IO name of the IO point and a cable album acquired in advance; if the type of the IO point cannot be determined, determining the cable specification according to a preset cable specification selection rule and the IO type of the IO point. The method directly eliminates the possibility of other professions participating in the compiling of the DCS wiring table, and as a non-control professional, other professions also have control functions to be realized through the DCS, but the compiling of the DCS system wiring is not well known. In actual engineering, because the DCS wiring table is repeatedly published due to filling to other professionals, the event of repeated adjustment of site construction often occurs.

Further, the IO types include AI, AO, RTD, DI, DO, SOE, TC, PO and PI types, where AI represents analog input, AO represents analog output, DI represents digital input, DO represents digital output, PI and PO respectively represent pulse input and output, RTD represents thermal resistance, SOE represents switching value input module, TC represents thermocouple millivolt signal, and the specific method for generating the cable core logarithm according to the signal endpoint device name of each IO point and the IO type corresponding to each IO point includes:

counting the number of times of occurrence of IO types corresponding to the names of the signal terminal equipment in the DCS wiring table;

If the IO type corresponding to the name of a certain signal terminal device is AI or AO or RTD or TC, when the occurrence number of the certain IO type is more than 2, the actual required core logarithm of the cable needed by the IO type corresponding to the name of the signal terminal device is 1 added to the occurrence number of the IO type; when the occurrence frequency of one IO type is less than or equal to 2, the actual required core pair number of the cable required by the IO type corresponding to the signal terminal equipment name is the occurrence frequency of the IO type;

If the IO type is DI or DO or SOE or PO or PI, according to the actual cable specification, when the product of the number of times of occurrence of a certain IO type corresponding to the signal end point equipment name multiplied by 2 is larger than a and smaller than or equal to b, the actual required core logarithm of the cable required by the IO type corresponding to the signal end point equipment name is b core; where a is the lower limit of the actual cable gauge core pair number and b is the upper limit of the actual cable gauge core pair number.

Still further, the method further includes determining a spare core logarithm according to the IO type of each IO point, and specifically includes the following steps: when the IO type is AI or AO or RTD or TC, the standby core number of the cable needed by one IO type corresponding to the signal end point equipment name is the actual cable specification core number minus the occurrence frequency of the IO type corresponding to each signal end point equipment name; if the cable is of other IO types except AI, AO, RTD or TC, the spare core number of the cable needed by the IO type corresponding to the signal end point equipment name is the difference value before the actual cable specification core number minus 2 times of the occurrence times of the IO type corresponding to the signal end point equipment names. The invention performs automatic specification classification and automatic core number matching. Because the DCS clamping pieces are arranged, different core cables of part of equipment can be arranged on different clamping pieces, namely, different cores of one cable can be disassembled and distributed at a plurality of places from head to tail of a form, if the DCS clamping pieces depend on manpower, the problem that multiple wirings are generated due to incapability of traversing each cable core is unavoidable, and the step is tedious and error-prone. The method greatly releases manpower.

Further, the parameters determined according to the IO name and the IO type further comprise equipment numbers, specifically, the signal terminal equipment name is matched with a pre-acquired equipment album, and the equipment code corresponding to the signal terminal equipment name is acquired.

Further, the IO type comprises AI, AO, RTD, DI, DO, SOE, TC, PO and PI type, wherein AI represents analog quantity input, AO represents analog quantity output, DI represents digital quantity input, DO represents digital quantity output, PI and PO respectively represent pulse quantity input and output, RTD represents thermal resistance, SOE represents a switching value input module, and TC represents thermocouple millivolt signals;

Determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, if the protection pipes are determined to be needed, determining the number of the protection pipes and the diameter of the needed protection pipes specifically comprises the following steps: judging whether the signal terminal equipment belongs to a screen cabinet or whether the I0 type of the IO point is a heat control professional signal according to the name of the signal terminal equipment of the IO point, if the signal terminal equipment belongs to the screen cabinet or the IO type is the heat control professional signal, a protection tube is not needed, otherwise, the following steps are executed:

judging that when the terminal equipment is an electric door according to the signal terminal equipment name of the IO point, if the IO type corresponding to the IO point is DI or DO type, the protection tube signal is DN20, and if the IO type corresponding to the IO point is AI, the protection tube model is DN15;

Judging that when the terminal equipment is an adjusting gate according to the signal terminal equipment name of the IO point, if the IO type corresponding to the IO point is DI type, the protection tube signal is DN15, and if the IO type corresponding to the IO point is AI or AO, the protection tube model is DN20;

Traversing the IO type corresponding to each IO point, and judging as follows:

If the IO type is DI or DO or SOE or PO or PI, judging whether the name of the previous signal end point device corresponds to the same DI or DO or SOE or PO or PI, and if so, sharing a protection tube with the previous signal end point device;

If the IO type is AI or AO or RTD or TC, judging whether the same type of AI or AO or RTD or TC appears at the previous IO point, and if so, sharing a protection tube with the previous signal terminal equipment;

The cables with repeated cable numbers share a protection tube;

when the name of the signal terminal equipment judges that the terminal equipment is an electric door or an electromagnetic valve, the cables with the IO types DI and DO corresponding to the name of the signal terminal equipment share a protection pipe;

1 cable in the protection tube adopts the protection tube model to be DN15, 2 cables in the protection tube adopt the protection tube model to be DN20, and 3 cables in the protection tube adopt the protection tube model to be DN25.

The invention carries out computer logic transformation on the manual selection method of the protective tube with more than ten steps, and the method reduces the error quantity to 0 for thousands of IO points because of delivering to a computer for operation.

The invention also provides a computer readable storage medium storing a program which, when executed by a processor, causes the processor to execute the DCS wiring table automatic generation method as provided by any one of the possible embodiments of the above technical scheme.

The present invention also provides a computer program product comprising operations that when loaded and executed on a computer system cause the computer system to implement the DCS wiring table automatic generation method provided according to any one of the possible embodiments of the present invention.

The beneficial technical effects obtained by the invention are as follows:

According to the method, the IO names and IO types in the IO point attributes in the DCS wiring table are extracted and compared with the acquired various albums, the determination method of the necessary parameters in the wiring table is determined, the DCS wiring table is automatically generated according to the finally determined DCS wiring table parameters, the productivity is fully liberated, and the accuracy and the efficiency are remarkably improved.

Based on the object-oriented design method, BIM is always done, but specific information specific to a specific function is required, based on BIM, the attribute can only be given to an object, the attribute is checked, the logic operation is performed on the attribute of the sensor itself, the minimum information amount required for the logic operation is not clear, and so-called BIM can only be achieved by inputting information as many as possible. Aiming at the process of the DCS wiring table, the invention designs the minimum information required to be input in factory informatization, thereby avoiding invalid manual waste.

The invention divides each item of content to be filled in for the DCS wiring table into secondary attributes, and designs a classification method by a computer after calculating for each secondary attribute.

The DCS wiring table automatic generation method provided by the invention points out the minimum attribute required by object-oriented design in the DCS wiring table range in the thermal control automatic design informatization, and lays a foundation for the informatization of thermal control software.

Drawings

FIG. 1 is a schematic flow chart of a method for automatically generating a DCS wiring table according to an embodiment of the present invention.

Detailed Description

The invention is further described below with reference to the drawings and specific examples.

Example 1: the DCS wiring table automatic generation method, as shown in figure 1, comprises the following steps: extracting IO names and IO types in each IO point attribute in the DCS wiring table; determining parameters of a DCS wiring table according to IO names and IO types, wherein the parameters comprise the following specific steps: determining the signal terminal equipment name of the IO point according to the acquired IO name; determining a cable number according to the IO type, and identifying the repeated cable number; determining cable specifications according to IO names and IO types of the IO points, and identifying repeated cable specifications; generating the cable core logarithm according to the signal end point equipment name of each IO point and the IO type corresponding to each IO point; determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, and if the protection pipes are needed, determining the number of the protection pipes, the types and the diameters of the needed protection pipes; and generating a DCS wiring table according to the determined parameters.

The initial wiring table is shown in table 1. For ease of description, table 1 is a simplified wiring table. Wherein the attributes of the IO points include: IO name, IO type, cable specification, cable model, standby core, protection tube specification, etc. Each IO point may be considered an object to which properties are assigned using object-oriented design methods.

TABLE 1 initial wiring schematic diagram

In the embodiment, firstly, the contents of IO points, serial numbers, roll names, measuring point descriptions, station numbers, system cabinets, module addresses, channel numbers and the like in a DCS wiring table are extracted. And generating a class, wherein an IO point is taken as an instance object, and the object attribute comprises an IO point, a signal end point equipment number, an IO point, a cable model, an IO point, a standby core and the like.

The specific method for determining the signal endpoint device name of the IO point according to the acquired IO name in the embodiment comprises the following steps: comparing the acquired IO name with a transmitter list in a transmitter protection box acquired in advance, and taking the transmitter protection box name where the IO point is located as the signal end point equipment name of the IO point if the signal end point of the IO point is judged to be the transmitter protection box; otherwise, comparing the obtained IO name with the suffix of the preset coding rule, if the IO name contains the coding suffix, replacing the coding suffix with a null value, and determining the replaced IO name as the signal terminal equipment name of the IO point; if the IO name is judged to not contain the coded suffix, judging whether the IO name contains a standby character string, and if the IO name does not contain the coded suffix, judging that the signal terminal equipment name is a null value; if the 'standby' character string does not exist, judging whether the signal end point equipment is a sensor or a thermal resistor or a thermocouple according to the suffix of the corresponding IO name, and further determining the signal end point equipment.

Wherein the transmitter album in the transmitter protection box is shown in table 2.

Table 2 transmitter album in transmitter protection box

In this embodiment, the transmitter list in the transmitter protection box shown in table 2 is imported, the signal endpoint device names of the IO points in the DCS wiring table are extracted one by one, and compared with the transmitter list in the transmitter protection box, if the signal endpoint device name of one IO point is completely consistent with the "in-box installation unit name" in the transmitter list, the transmitter protection box name of the IO point in the transmitter list is output. As with reference to Table 1, where the IO name of the IO point numbered 11 is "#1 electric boiler outlet pressure signal 2", it is compared to the transmitter album in the transmitter protection box of Table 2 to determine the transmitter incubator name #1 transmitter incubator.

And taking the insulation box of the #1 transmitter as the signal end point equipment name of the IO point with the IO name of the #1 electric boiler outlet water pressure signal 2.

If the signal end point of the IO point is judged not to be the transmitter protection box, extracting the IO name in the DCS wiring table, then carrying out gradual comparison after sequencing the IO name and the suffix of the obtained coding rule (shown in table 3 in the embodiment) from large to small according to the byte length, and if the IO name contains the coding suffix, replacing the coding suffix with a null value and outputting the null value to the signal end point equipment name.

Table 3 coding rules schematic table of the switch in the embodiment

If the IO name in table 1 is "#1 electric boiler primary side three-way valve opening command", and the signal end point of the IO point is not the transmitter protection box, comparing "#1 electric boiler primary side three-way valve opening command" with table 3, replacing "opening command" in the IO name with a null value if the IO name contains the coded suffix "opening command", and using "#1 electric boiler primary side three-way valve" as the signal end point device name of the IO point if the replaced IO name is "#1 electric boiler primary side three-way valve". If the IO name contains a "spare" string, such as "spare 10AO_1006" in Table 1, the destination device name of the IO point is null.

If the IO type in the table 1 is RTD, the terminal equipment can be judged to be thermal resistor;

If the IO type in the table 1 is TC, the end point device can be judged to be a thermocouple;

if any of the above logics is not satisfied in table 1, the IO name + "sensor" is taken as the device endpoint.

In a specific embodiment, the parameters determined according to the IO name and the IO type further include a device number, specifically, the signal end point device name is matched with a pre-acquired device album, and a device code corresponding to the signal end point device name is acquired. By comparing the signal end point device name of the IO point with the device album, if the signal end point device name is the same as the device name in the device album, the device code corresponding to the device can be obtained, and whether the signal end point device name is a thermal control device can be confirmed.

In this embodiment, determining the cable number according to the IO type specifically includes: and comparing the IO name with a pre-acquired cable album (such as a thermal control drawing cable album and other professional cable albums), determining the cable number of each IO point, and if the cable is the thermal control professional cable, comparing the IO name with a pre-acquired cable rule according to the IO type, and generating the cable number of the IO point according to the IO name and the IO type of the IO point according to a preset cable number rule.

In a specific embodiment, if the cable number corresponding to the IO point cannot be determined in the cable album or the cable rule, the device is encoded by itself. Optionally, performing a string connection operation on the name and the type of each IO point one by one, generating a multi-condition query attribute, generating a list of the multi-condition query attribute, querying whether the control cable of the device appears in the multi-condition query list, defaulting the serial number of the cable to 1, if so, querying the serial number when the first appears and adding 1, and if not, returning the serial number of the cable to 1. And finally, the cable numbers below a certain number are in a unified format according to the requirements.

Alternatively, if there is a thermal control drawing cable album and other specialty cable albums, the cable number in the thermal control drawing cable album and other specialty cable albums is preferentially used as the final cable number.

In this embodiment, the repeated cable numbers are identified, which specifically includes traversing each cable number, performing a duplication checking operation on the final cable number, and for the cable numbers appearing for the first time, not operating, and for the cable numbers appearing for the second and above, using the cable numbers with the cable appearing for the first time. Optionally, the combined cable does not list the cable number, length, protective tubing, etc. alone at a later stage.

In this embodiment, determining the cable specification according to the IO name and the IO type of each IO point specifically includes: determining the cable specification of each IO point by the IO name of the IO point and a cable album acquired in advance; if the type of the IO point cannot be determined, determining the cable specification according to a preset cable specification selection rule and the IO type of the IO point. Judging the cable specification one by one according to the IO type, if the IO type is DI or DO or SOE or PI point, using a control cable ZR-KVVP, if the IO type is AI or AO or RTD point, using a computer cable ZR-DJYJPVP, and if the IO type is TC signal, using a compensation lead ZR-KX-VVP.

The IO type comprises AI, AO, RTD, DI, DO, SOE, TC, PO and PI type, wherein AI represents analog quantity input, AO represents analog quantity output, DI represents digital quantity input, DO represents digital quantity output, PI and PO respectively represent pulse quantity input and output, RTD represents thermal resistor, SOE switch quantity input module is used for judging switch action time sequence, and is mainly used for fault judgment, and TC represents thermocouple millivolt signal.

Based on the second embodiment, the DCS wiring table automatic generation method provided in the present embodiment further includes: the specific method for generating the cable core logarithm according to the signal end point equipment names of the IO points and the IO types corresponding to the signal end point equipment names comprises the following steps:

Counting the number of times that IO types corresponding to the names of all signal terminal equipment in a DCS wiring table respectively appear, and in a specific embodiment, determining 'IO points, IO names and IO points', wherein a comprehensive character string 'consisting of the signal types' appears for several times in a multi-condition query list;

If the IO type corresponding to a certain signal terminal equipment name is AI or AO or RTD, when the occurrence frequency of the certain IO type is more than 2, the actual required core logarithm of the cable needed by the IO type corresponding to the signal terminal equipment name is 1 added to the occurrence frequency of the IO type; when the occurrence frequency of one IO type is less than or equal to 2, the actual required core pair number of the cable required by the IO type corresponding to the signal terminal equipment name is the occurrence frequency of the IO type;

If the IO type is DI or DO or SOE or PO or PI, multiplying the occurrence number of one IO type corresponding to the signal end point equipment name by 2 products which are larger than a and smaller than or equal to b according to the actual cable specification, and taking the actual required core logarithm of the cable required by the IO type corresponding to the signal end point equipment name as b core; where a is the lower limit of the actual cable gauge core pair number and b is the upper limit of the actual cable gauge core pair number.

In this embodiment, if the cable is combined in the front, the core pair number of the cable is not displayed for convenience of construction and statistics.

An empty list is generated, each multi-conditional query is traversed, and the multi-conditional queries are added to the list one by one. And counting the occurrence times of a multi-condition query in the list once for each additional time, wherein the cable specification and the core number are not displayed when the occurrence times are more than or equal to 2.

When the number of occurrences is less than 2

Judging the IO type and outputting the result

When the IO type is AI or AO, the core logarithm=the actual required core logarithm + "+2x1.0" is finally selected "

When the IO type is RTD, the final core logarithm=the actual required core logarithm + "+3×1.0" is selected:

when the IO type is TC, the core logarithm=the actual required core logarithm + ". 2×2.5" is finally selected:

When the IO type is DI or DO or SOE or PI, the final selected core logarithm=the actual required core logarithm + "1.0"

In a specific embodiment, the method further comprises the step of determining the standby core logarithm of the cable with the IO point, and comprises the following steps:

traversing each IO point, when the IO type is AI or AO or RTD or TC, the spare core number = actual required core pair number-multi-condition statistics. Otherwise, the standby core number=the actual required core log-multi-condition statistics x 2.

Example 3: on the basis of the above embodiment, the DCS wiring table automatic generation method provided in the present embodiment further includes the steps of: determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, if the protection pipes are determined to be needed, determining the number of the protection pipes and the types of the needed protection pipes specifically comprises the following steps: judging whether the signal terminal equipment belongs to a screen cabinet or whether the I0 type of the IO point is a heat control professional signal according to the name of the signal terminal equipment of the IO point, if the signal terminal equipment belongs to the screen cabinet or the IO type is the heat control professional signal, a protection tube is not needed, otherwise, the following steps are executed:

Traversing the IO type corresponding to each IO point, and judging as follows:

The cables with repeated cable numbers share a protection tube;

Specifically, the keywords "tray", "cabinet" and "screen" may be used to determine whether the end point of the signaling device is a cabinet. By traversing each signal endpoint device name, a determination can be made as to whether the endpoint is a transmitter protection box.

Traversing each signal end point device name, and classifying keywords such as an electric door, a shut-off door, an isolation door, an electric valve, an isolation valve, a shut-off valve, an electric baffle, a shut-off baffle, an isolation baffle and the like as the electric door when the signal end point device name comprises the electric door, the shut-off door, the isolation door, the electric valve, the isolation valve, the shut-off valve, the electric baffle, the shut-off baffle, the isolation baffle and the like; when the signal terminal equipment names comprise keywords such as 'adjusting door', 'three-way door', 'adjusting valve', 'three-way valve', 'adjusting baffle' and the like, the keywords are classified as adjusting doors; when the signal terminal equipment name contains keywords such as electromagnetic valve, pneumatic door and the like, the keywords are classified as electromagnetic/pneumatic door.

In a specific embodiment, optionally, determining the diameter of the insulating tube further includes the steps of: initializing the counter to 0

Traversing the type of each IO point

If the IO point is a DI or DO or SOE or PI signal

Counter +1 when the signal endpoint DI or DO or SOE or PI signal is searched

Same reason

Initializing the counter to 0

Traversing the type of each IO point

If the IO point is an AI or AO or RTD or TC signal

The AI or AO or RTD or TC signal of this signal is searched for counter +1

Judging the counter

This IO point tube diameter=dns 15 when counter=1;

this IO point tube diameter=dns 20 when counter=2;

this IO point tube diameter = DN25 when the counter > 2;

judging whether the IO signal end point equipment is a transmitter protection box or not, and if so, judging that the IO signal end point equipment is a DN25 protection pipe.

The nominal diameter is indicated by the letter "DN" followed by a numerical designation, the designation being followed by the designation of the size in millimeters. The nominal diameter is the nominal diameter of pipes such as cast iron pipes, seamed steel pipes, concrete pipes, etc., but seamless steel pipes do not use this representation. For example DN50, i.e. a tube with a nominal diameter of 50 mm.

In specific implementation, a person skilled in the art may use the prior art or estimate the length of the protection tube required for the IO point according to common general knowledge, and the present invention will not be described in detail. After the parameters of the wiring table are determined, in order to prevent different cable merging principles adopted by different engineers in the drawing, one review operation is performed on the final merged cable. When one cable has the same end point and the same end point, the check drawing is output at the remark column and the cable is manually split under the condition that the start point and the start point are not in the same DCS cabinet. Since the final drawing is human-oriented, this step is added, for example, to a factory or robot, and no further review is necessary.

And finally, outputting the IO point attribute according to the human reading habit. And carrying out the operation of merging the same cells for the signal end point device name column. And copies the column format to each generated column by format brush. In order to ensure that the list generation of the computer language does not skip the null value, all the cells displayed as null in the algorithm are null, the data types in the computer memory are NoneType, and all the cells are deleted after the program is finished, so that the list generation is not listed for simplicity.

The DCS wiring table automatic generation method provided by the invention can be finally realized through various computer languages, and optionally, functions and grammar are expressed by adopting python language. The implementation language is not limited to the python language and various changes in form and detail may be made therein without departing from the spirit and scope of the invention.

It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

The embodiments of the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to the above-described embodiments, which are merely illustrative and not restrictive, and many forms may be made by those having ordinary skill in the art without departing from the spirit of the present invention and the scope of the claims, which are all within the protection of the present invention.

Claims

The DCS wiring table automatic generation method is characterized by comprising the following steps: extracting IO names and IO types in each IO point attribute in the DCS wiring table; determining parameters of a DCS wiring table according to IO names and IO types, wherein the parameters comprise the following specific steps: determining the signal terminal equipment name of the IO point according to the acquired IO name; determining a cable number according to the IO type, and identifying the repeated cable number; determining cable specifications according to IO names and IO types of the IO points, and identifying repeated cable specifications; generating a cable core logarithm according to the signal end point equipment name of each IO point and the IO type corresponding to each IO point; determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, and if the protection pipes are needed, determining the number of the protection pipes and the diameter of the needed protection pipes; generating a DCS wiring table according to the determined DCS wiring table parameters;

the specific method for determining the signal end point device name of the IO point according to the acquired IO name comprises the following steps:

Comparing the acquired IO name with a transmitter list in a transmitter protection box acquired in advance, and taking the transmitter protection box name where the IO point is located as the signal end point equipment name of the IO point if the signal end point of the IO point is judged to be the transmitter protection box; otherwise, comparing the obtained IO name with the suffix of the preset coding rule, if the IO name contains the coding suffix, replacing the coding suffix with a null value, and determining the replaced IO name as the signal terminal equipment name of the IO point; if the IO name is judged to not contain the coded suffix, judging whether the IO name contains a standby character string, and if the IO name does not contain the coded suffix, judging that the signal terminal equipment name is a null value; if the standby character string does not exist, judging whether the signal terminal equipment is a sensor, a thermal resistor or a thermocouple according to the suffix of the corresponding IO name so as to further determine the signal terminal equipment;

the IO type comprises AI, AO, RTD, DI, DO, SOE, TC, PO and PI type, wherein AI represents analog quantity input, AO represents analog quantity output, DI represents digital quantity input, DO represents digital quantity output, PI and PO respectively represent pulse quantity input and output, RTD represents thermal resistance, SOE represents a switching value input module, and TC represents thermocouple millivolt signals;

determining whether protection pipes are needed according to IO types of all IO points and signal end point equipment names, if the protection pipes are determined to be needed, determining the number of the protection pipes to be equal to the diameter of the needed protection pipes specifically comprises the following steps: judging whether the signal terminal equipment belongs to a screen cabinet or whether the I0 type of the IO point is a thermal control professional signal according to the name of the signal terminal equipment of the IO point, if the signal terminal equipment belongs to the screen cabinet or the IO point is a non-thermal control professional signal, a protection tube is not needed, otherwise, the following steps are executed:

judging that when the terminal equipment is an electric door according to the signal terminal equipment name of the IO point, if the IO type corresponding to the IO point is DI or DO type, the protection tube signal is DN20, and if the IO type corresponding to the IO point is AI, the protection tube model is DN15;

Judging that when the terminal equipment is an adjusting gate according to the signal terminal equipment name of the IO point, if the IO type corresponding to the IO point is DI type, the protection tube signal is DN15, and if the IO type corresponding to the IO point is AI or AO, the protection tube model is DN20;

Traversing the IO type corresponding to each IO point, and judging as follows:

If the IO type is DI or DO or SOE or PO or PI, judging whether the name of the previous signal end point device corresponds to the same DI or DO or SOE or PO or PI, and if so, sharing a protection tube with the previous signal end point device;

If the IO type is AI or AO or RTD or TC, judging whether the same type of AI or AO or RTD or TC appears at the previous IO point, and if so, sharing a protection tube with the previous signal terminal equipment;

The cables with repeated cable numbers share a protection tube;

when the name of the signal terminal equipment judges that the terminal equipment is an electric door or an electromagnetic valve, the cables with the IO types DI and DO corresponding to the name of the signal terminal equipment share a protection pipe;

1 cable in the protection tube adopts the protection tube model to be DN15, 2 cables in the protection tube adopt the protection tube model to be DN20, and 3 cables in the protection tube adopt the protection tube model to be DN25.
2. The DCS wiring table automatic generation method of claim 1, wherein determining the cable number according to the IO type specifically comprises: and comparing the IO type with a cable rule acquired in advance, or comparing the IO name with a cable list acquired in advance to determine the cable number of each IO point, and if the cable number cannot be determined, generating the cable number of the IO point according to the IO name and the IO type of the IO point according to a preset cable number rule.
3. The DCS wiring table automatic generation method of claim 1, wherein determining the cable specification according to the IO name and IO type of each IO point specifically comprises: determining the cable specification of each IO point by the IO name of the IO point and a cable album acquired in advance; if the type of the IO point cannot be determined, determining the cable specification according to a preset cable specification selection rule and the IO type of the IO point.
4. The DCS wiring table automatic generation method of claim 1, wherein said IO types include AI, AO, RTD, DI, DO, SOE, TC, PO and PI types, wherein AI represents analog input, AO represents analog output, DI represents digital input, DO represents digital output, PI and PO represent pulse input and output, respectively, RTD represents thermal resistance, SOE represents switching value input module, TC represents thermocouple millivolt signal, and the specific method for generating said cable core logarithm according to the signal end point device name of each IO point and the IO type corresponding to each IO point comprises:

counting the number of times of occurrence of IO types corresponding to the names of the signal terminal equipment in the DCS wiring table;

If the IO type corresponding to a certain signal terminal equipment name is AI or AO or RTD or TC, when the occurrence number of the certain IO type is more than 2, the actual required core logarithm of the cable needed by the IO type corresponding to the signal terminal equipment name is 1 added to the occurrence number of the IO type; when the occurrence frequency of one IO type is less than or equal to 2, the actual required core pair number of the cable required by the IO type corresponding to the signal terminal equipment name is the occurrence frequency of the IO type;

If the IO type is DI or DO or SOE or PO or PI, according to the actual cable specification, when the product of the number of times of occurrence of a certain IO type corresponding to the signal end point equipment name multiplied by 2 is larger than a and smaller than or equal to b, the actual required core logarithm of the cable required by the IO type corresponding to the signal end point equipment name is b core; where a is the lower limit of the actual cable gauge core pair number and b is the upper limit of the actual cable gauge core pair number.
5. The DCS wiring table automatic generation method of claim 4, further comprising determining the spare core logarithm based on the IO type of each IO point, comprising the steps of:

when the IO type is AI or AO or RTD or TC, the standby core number of the cable needed by one IO type corresponding to the signal end point equipment name is the actual cable specification core number minus the occurrence frequency of the IO type corresponding to each signal end point equipment name; if the cable is of other IO types except AI, AO, RTD or TC, the spare core number of the cable needed by the IO type corresponding to the signal end point equipment name is the difference value before the actual cable specification core number minus 2 times of the occurrence times of the IO type corresponding to the signal end point equipment names.
6. The DCS wiring table automatic generation method of claim 1, wherein the parameters determined according to the IO name and the IO type further include a device number, specifically, a device code corresponding to the signal endpoint device name is obtained by matching the signal endpoint device name with a pre-obtained device album.
7. A computer readable storage medium storing a program which, when executed by a processor, causes the processor to perform the method of any one of claims 1-6.
8. A computer program product, characterized in that it comprises operations that when loaded and executed on a computer system cause said computer system to implement the method according to any of the preceding claims 1-6.