Method and system for generating multiple lines of water delivery and power generation system based on database driving

Abstract

The invention belongs to the technical field of water delivery and power generation systems, and discloses a method and a system for generating multiple lines of a water delivery and power generation system based on database driving, a control point table and a line segment table are updated and stored through a database storage and calculation module, and parameters of control points and line segments are calculated; the control point processing module judges whether the control points need to be processed or not, processes adjacent break angle control points, generates smooth turning sections at the control points, judges whether the smooth turning sections at the control points exceed a design limit value or not through the control point adjusting module, and adjusts the control points exceeding the design limit value. And the control point table is updated and stored through a database storage and calculation module, finally, a water diversion system line and a tail water system line are generated through fitting of a water delivery line generation module, and finally, all water delivery lines are generated. According to the method, a plurality of water delivery lines can be automatically fitted and generated by setting the line generation logic and the constraints, so that three-dimensional dynamic adjustment is realized, and the problems of item missing and errors during line optimization are reduced.

Description

Technical Field

[0001] The present invention belongs to the technical field of water transmission and power generation systems, and in particular relates to a method and system for generating multiple lines of a water transmission and power generation system based on database drive. Background Art

[0002] At present, the line design of the water transmission and power generation system of pumped storage power stations is mainly based on two-dimensional design of horizontal and longitudinal sections. Some scholars have also explored the three-dimensional design of the line, but the accuracy and depth are not enough. It can only meet the needs of rapid output of the plan for the early project, and cannot meet the requirements of the three special and feasibility study review. It realizes local driving parameters but the scope of application is relatively limited, lacks flexibility, and can only meet relatively typical layout forms. The main problem is that there is a lack of complex logical judgment in the generation of multiple lines, and the accuracy does not meet the requirements of the recommended plan. At the same time, there is a lack of flexible adjustment strategies, which cannot meet the needs of scheme adjustment and optimization. In the three-dimensional design process of the water transmission and power generation system of the pumped storage power station, the generation of multiple lines for the water transmission line is relatively complex, and the work of local repair and adjustment is large, resulting in poor accuracy of the generated multiple lines. Summary of the invention

[0003] The present invention aims to address the deficiencies in the prior art and provides a method and system for generating multiple lines for a water transmission and power generation system based on database drive, which sets line generation logic and constraint restrictions, adjusts control points that exceed the set limits, automatically fits and generates multiple water transmission lines, realizes three-dimensional dynamic adjustment, and reduces omissions and errors during line optimization.

[0004] In order to achieve the above technical objectives, the present invention adopts the following technical solutions:

[0005] A method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0006] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0007] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0008] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0009] S4, connect the control points to generate multiple lines;

[0010] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0011] S6, processing the corner control points to generate smooth turning segments at the control points;

[0012] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0013] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0014] Preferably, in step S1, the water supply line information includes a three-dimensional multi-segment line formed in sequence of control points, parameters of each segment, the starting point, end point and length of the line, the location, spacing, direction, water supply form and number of units of the buildings.

[0015] Preferably, in step S3, the control points include: the water inlet and outlet of the upper reservoir as control point F, the water diversion accident gate well as control point G, the water diversion pressure regulating well as control point J, the center point of the water diversion branch pipe or the center point of the tailwater branch pipe as control point K, the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse as control point P, the center point of the unit as control point C, the bottom tunnel of the tail lock chamber as control point L, the tailwater pressure regulating chamber as control point M, the tailwater maintenance gate well as control point Q, the water inlet and outlet of the lower reservoir as control point R, and the intersection of the center line of the line turning section as control point H. The control points are sorted in sequence according to the main pipe of the water transmission line, the branch pipe of the water transmission line and the direction of water flow.

[0016] Preferably, in step S3, the spacing includes: the spacing LF of the water inlet and outlet of the upper reservoir, the spacing LG of the water diversion accident gate well, the spacing LJ of the water diversion pressure regulating well, the spacing LK of the center points of the diversion / tailwater bifurcations, the spacing LP of the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse, the spacing LC of the center points of the units, the spacing LL of the tunnel at the bottom of the tailwater lock chamber, the spacing LM of the tailwater pressure regulating chamber, the spacing LQ of the tailwater maintenance gate well, and the spacing LR of the water inlet and outlet of the lower reservoir; the position of the control point is determined according to the number of main pipes of the water transmission line, the number of branches of the water transmission line and the spacing, and the control points are connected in sequence.

[0017] Preferably, in step S4, multiple lines are formed based on the control points: the control points are connected in sequence to form the multiple lines, and the connection order is FGJKPCKLMQR.

[0018] Preferably, step S5 specifically includes:

[0019] Step S5 specifically includes:

[0020] S501, screening corner or non-straight line control points and marking them: analyzing and calculating the control points and multiple line segments in the database, screening the corner control points forming corners between lines through angle calculation, marking them, storing the marked corner control points and corner angle information in a marking table, and updating the marking table to the database;

[0021] S502, detect adjacent corner control points: query the marking table, obtain the sequence of corner control points, confirm whether they are adjacent points according to the line segment table, filter out adjacent corner control points, store adjacent corner control points in the database, and the line segments between adjacent corner control points need to be adjusted. The line segments that need to be adjusted are added to the adjustment queue, and the adjustment queue is updated to the database. The line segments between adjacent corner control points are marked as being in a state to be optimized.

[0022] Preferably, step S6 specifically includes:

[0023] S601, deleting a line segment: performing a deletion operation on the line segment between adjacent corner control points marked as being in a state to be optimized in step S5, and updating the line segment between adjacent corner control points in the database to a deleted state;

[0024] S602, calculating and storing the intersection points of the extended lines: filtering out the line segments between the adjacent corner control points marked as deleted, making extension lines along the line segments where the adjacent corner control points have not been deleted, calculating the intersection points of the extended lines, recording the intersection points of the extended lines as newly generated intersection control points, adding the newly generated intersection control points to the control point table, calculating the positional relationship and connection information between the intersection points of the extended lines and their corresponding adjacent corner control points through database analysis, updating the line table, and updating the new control point table and line table to the database;

[0025] S603, generate new control points, chamfer and store: chamfer the newly generated intersecting control points in the database, record the chamfer information in the turning field, store the turning field in the control point table, and define the chamfer information as a smooth turning segment at the control point.

[0026] Preferably, in step S7, the design limit includes a turning radius requirement and a turning angle requirement, and step S7 specifically includes:

[0027] S701, storing and checking turning radius requirements: storing the turning radius requirements in a checking field, updating the checking field in a control point table, calculating the turning radius of a smooth turning segment at a control point through a database, generating a reminder for a smooth turning segment at a control point whose turning radius does not meet the turning radius requirements, recording the reminder in a storage notification table, and storing the storage notification table in a database;

[0028] S702, storing and checking the turning angle requirement: storing the turning angle requirement in the checking field, updating the checking field to the control point table, calculating the turning angle of the smooth turning segment at the control point stored in the notification table through the database, marking the smooth turning segment at the control point whose turning angle does not meet the turning angle requirement as a confirmation-required state, and adjusting the position of the intersection control point newly generated in step S603 for the smooth turning segment at the control point in the confirmation-required state;

[0029] S703: Record the position of the newly generated intersection control point after adjustment as the adjusted intersection control point, store it in the control point table, and update the database.

[0030] Preferably, in step S701, the turning radius requirement is that the turning radius of the turning section is not less than 5 times the hole diameter.

[0031] Preferably, in step S702, the turning angle requirement is that the turning angle is not greater than 120°.

[0032] The present invention also provides a system for generating multiple lines of a water transmission and power generation system using the method for generating multiple lines of a water transmission and power generation system based on database drive as described above, comprising a database storage module, a control point processing module, a control point adjustment module and a water transmission line generation module;

[0033] The database storage and calculation module is used to update and store the control point table and the line segment table, and calculate the parameters of the control points and line segments;

[0034] The control point processing module is used to determine whether the control point needs to be processed, process adjacent corner control points, and generate a smooth turning section at the control point;

[0035] The control point adjustment module is used to determine whether the smooth turning section at the control point exceeds the design limit, adjust the control point that exceeds the design limit, and update and store the control point table through the database storage and calculation module;

[0036] The water transmission line generation module is used to fit and generate the water diversion system line and tailwater system line, and finally generate the entire water transmission line.

[0037] Compared with the prior art, the beneficial effects of the present invention are:

[0038] (1) The present invention uses the proposed water transmission lines already in the database as the reference data, and based on the layout parameters such as the location and spacing direction of the buildings and the direction of the water transmission lines, adjusts the control points that exceed the set limits by setting the line generation logic and constraint limits, updates the control point table and line segment table in the database, and automatically generates multiple water transmission lines by fitting, which greatly improves the efficiency of designers in designing water transmission line plans;

[0039] (2) The present invention fine-tunes the control points within the set constraint limit range, and then adjusts the corresponding lines and related lines, thereby realizing three-dimensional dynamic adjustment, providing convenience for designers to modify and optimize the lines, effectively reducing the occurrence of omissions and errors, and improving the quality and efficiency of water transmission line adjustment. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] Figure 1 A flowchart of a method for generating multiple lines of a water transmission and power generation system based on a database drive according to an embodiment of the present invention;

[0041] Figure 2 An example diagram of generating a smooth turning segment according to an embodiment of the present invention;

[0042] Figure 3 This is an example diagram of adjusting intersection control points according to an embodiment of the present invention. DETAILED DESCRIPTION

[0043] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0044] Example 1

[0045] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0046] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0047] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0048] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0049] S4, connect the control points to generate multiple lines;

[0050] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0051] S6, processing the corner control points to generate smooth turning segments at the control points;

[0052] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0053] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0054] Example 2

[0055] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0056] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0057] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0058] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0059] S4, connect the control points to generate multiple lines;

[0060] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0061] S6, processing the corner control points to generate smooth turning segments at the control points;

[0062] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0063] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0064] On this basis, specifically, in step S1, the water transmission line information includes multiple three-dimensional multi-segment lines formed in the order of initial control points, and the parameters of each segment of the line include the starting point, end point and length of the line, the location, spacing, direction, water supply form and number of units of the building;

[0065] The water transmission line information has been stored in the database at the initial line planning stage. The initial control points are extracted from the control point table to sequentially form the data of multiple three-dimensional multi-segment lines of the water transmission line, and the water transmission line information is stored in the line segment table; each line segment is uniquely identified in the database, and the starting point, end point and line length information are recorded to ensure the complete record of the initial line structure;

[0066] Further, in step S3, the control points include: the water inlet and outlet of the upper reservoir is the control point F, the water diversion accident gate well is the control point G, the water diversion pressure regulating well is the control point J, the center point of the water diversion branch pipe or the center point of the tailwater branch pipe is the control point K, the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse is the control point P, the center point of the unit is the control point C, the bottom tunnel of the tail lock chamber is the control point L, the tailwater pressure regulating chamber is the control point M, the tailwater maintenance gate well is the control point Q, the water inlet and outlet of the lower reservoir is the control point R, and the intersection of the center line of the line turning section is the control point H. The control points are sorted in sequence according to the main pipe of the water transmission line, the branch pipe of the water transmission line and the direction of water flow;

[0067] The spacing includes: the spacing LF of the water inlet and outlet of the upper reservoir, the spacing LG of the water diversion accident gate well, the spacing LJ of the water diversion pressure regulating well, the spacing LK of the center points of the diversion / tailwater branch pipes, the spacing LP of the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse, the spacing LC of the center points of the units, the spacing LL of the tunnel at the bottom of the tailwater lock chamber, the spacing LM of the tailwater pressure regulating chamber, the spacing LQ of the tailwater maintenance gate well, and the spacing LR of the water inlet and outlet of the lower reservoir; determine the location of the control points according to the number of main pipes of the water transmission line, the number of branches of the water transmission line and the spacing, and connect the control points in sequence;

[0068] The adjacent control points of buildings are determined by spacing and direction. For example, the spacing between water diversion and pressure regulating well 1 and water diversion and pressure regulating well 2 is expressed as LJ1-LJ2.

[0069] Further, in step S4, multiple lines are formed based on the control points: the control points are connected in sequence to form multiple lines, and the connection order is FGJKPCKLMQR;

[0070] Further, in step S6, the line segment between the adjacent corner control points to be processed is deleted, an extension line is drawn along the line segment where the adjacent corner control points have not been deleted, the intersection point of the extension line is calculated, the intersection point of the extension line is recorded as a newly generated intersection control point, the newly generated intersection control point is chamfered, and the chamfer information is defined as a smooth turning segment at the control point;

[0071] Furthermore, in step S7, the turning radius requirement and the turning angle requirement are stored in the control point table and updated to the database, the turning radius and the turning angle of the smooth turning section at the control point are calculated through the database, the smooth turning sections at the control points that do not meet the turning radius requirement and the turning angle requirement are screened out, and marked as requiring confirmation, and it is determined whether the smooth turning sections at the control points requiring confirmation exceed the design limit. For the smooth turning sections at the control points that exceed the design limit, the position of the newly generated intersection control point in step S6 is adjusted, the adjusted position of the newly generated intersection control point is recorded as the adjusted intersection control point, and stored in the control point table, and the database is updated.

[0072] Example 3

[0073] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0074] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0075] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0076] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0077] S4, connect the control points to generate multiple lines;

[0078] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0079] S6, processing the corner control points to generate smooth turning segments at the control points;

[0080] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0081] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0082] On this basis, step S5 specifically includes:

[0083] S501, screening corner or non-straight line control points and marking them: analyzing and calculating the control points and multiple line segments in the database, screening the corner control points forming corners between lines through angle calculation, marking them, storing the marked corner control points and corner angle information in a marking table, and updating the marking table to the database;

[0084] Specifically, if the line segments on both sides of the control point are non-straight lines, they are angle control points;

[0085] S502, detect adjacent corner control points: query the marking table, obtain the sequence of corner control points, confirm whether they are adjacent points according to the line segment table, filter out adjacent corner control points, store adjacent corner control points in the database, and the line segments between adjacent corner control points need to be adjusted. The line segments that need to be adjusted are added to the adjustment queue, and the adjustment queue is updated to the database. The line segments between adjacent corner control points are marked as being in a state to be optimized.

[0086] Example 4

[0087] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0088] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0089] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0090] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0091] S4, connect the control points to generate multiple lines;

[0092] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0093] S6, processing the corner control points to generate smooth turning segments at the control points;

[0094] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0095] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0096] Step S5 specifically includes:

[0097] S501, screening corner or non-straight line control points and marking them: analyzing and calculating the control points and multiple line segments in the database, screening the corner control points forming corners between lines through angle calculation, marking them, storing the marked corner control points and corner angle information in a marking table, and updating the marking table to the database;

[0098] S502, detecting adjacent corner control points: querying the marking table, obtaining the sequence of corner control points, confirming whether they are adjacent points according to the line segment table, screening out adjacent corner control points, storing the adjacent corner control points in the database, and if the line segment between the adjacent corner control points needs to be adjusted, adding the line segment to be adjusted to the adjustment queue, and updating the adjustment queue to the database, marking the line segment between the adjacent corner control points as a state to be optimized;

[0099] On this basis, step S6 specifically includes:

[0100] S601, deleting a line segment: performing a deletion operation on the line segment between adjacent corner control points marked as being in a state to be optimized in step S5, and updating the line segment between adjacent corner control points in the database to a deleted state;

[0101] S602, calculating and storing the intersection points of the extended lines: filtering out the line segments between the adjacent corner control points marked as deleted, making extension lines along the line segments where the adjacent corner control points have not been deleted, calculating the intersection points of the extended lines, recording the intersection points of the extended lines as newly generated intersection control points, adding the newly generated intersection control points to the control point table, calculating the positional relationship and connection information between the intersection points of the extended lines and their corresponding adjacent corner control points through database analysis, updating the line table, and updating the new control point table and line table to the database;

[0102] S603, generating new control points, chamfering and storing: chamfering the newly generated intersecting control points in the database, recording the chamfering information into the turning field, storing the turning field into the control point table, and defining the chamfering information as a smooth turning segment at the control point;

[0103] like Figure 2 As shown, the adjacent corner control points G2 and J2 are processed to generate a smooth turning segment at the control points.

[0104] Example 5

[0105] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0106] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0107] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0108] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0109] S4, connect the control points to generate multiple lines;

[0110] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0111] S6, processing the corner control points to generate smooth turning segments at the control points;

[0112] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0113] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0114] Step S5 specifically includes:

[0115] S501, screening corner or non-straight line control points and marking them: analyzing and calculating the control points and multiple line segments in the database, screening the corner control points forming corners between lines through angle calculation, marking them, storing the marked corner control points and corner angle information in a marking table, and updating the marking table to the database;

[0116] S502, detecting adjacent corner control points: querying the marking table, obtaining the sequence of corner control points, confirming whether they are adjacent points according to the line segment table, screening out adjacent corner control points, storing the adjacent corner control points in the database, and if the line segment between the adjacent corner control points needs to be adjusted, adding the line segment to be adjusted to the adjustment queue, and updating the adjustment queue to the database, marking the line segment between the adjacent corner control points as a state to be optimized;

[0117] Step S6 specifically includes:

[0118] S601, deleting a line segment: performing a deletion operation on the line segment between adjacent corner control points marked as being in a state to be optimized in step S5, and updating the line segment between adjacent corner control points in the database to a deleted state;

[0119] S602, calculating and storing the intersection points of the extended lines: filtering out the line segments between the adjacent corner control points marked as deleted, making extension lines along the line segments where the adjacent corner control points have not been deleted, calculating the intersection points of the extended lines, recording the intersection points of the extended lines as newly generated intersection control points, adding the newly generated intersection control points to the control point table, calculating the positional relationship and connection information between the intersection points of the extended lines and their corresponding adjacent corner control points through database analysis, updating the line table, and updating the new control point table and line table to the database;

[0120] S603, generating new control points, chamfering and storing: chamfering the newly generated intersecting control points in the database, recording the chamfering information into the turning field, storing the turning field into the control point table, and defining the chamfering information as a smooth turning segment at the control point;

[0121] On this basis, in step S7, the design limits include turning radius requirements and turning angle requirements, specifically:

[0122] S701, storing and checking turning radius requirements: storing the turning radius requirements in a checking field, updating the checking field in a control point table, calculating the turning radius of a smooth turning segment at a control point through a database, generating a reminder for a smooth turning segment at a control point whose turning radius does not meet the turning radius requirements, recording the reminder in a storage notification table, and storing the storage notification table in a database;

[0123] Specifically, the turning radius requirement is that the turning radius of the turning section should not be less than 5 times the tunnel diameter;

[0124] S702, storing and checking the turning angle requirement: storing the turning angle requirement in the checking field, updating the checking field to the control point table, calculating the turning angle of the smooth turning segment at the control point stored in the notification table through the database, marking the smooth turning segment at the control point whose turning angle does not meet the turning angle requirement as a confirmation-required state, and adjusting the position of the intersection control point newly generated in step S603 for the smooth turning segment at the control point in the confirmation-required state;

[0125] Specifically, the turning angle requirement is that the turning angle is no greater than 120°;

[0126] S703, recording the position of the newly generated intersection control point after adjustment as the adjusted intersection control point, storing it in the control point table, and updating the database;

[0127] like Figure 3 As shown, the newly generated intersection control point H1 is adjusted to obtain an adjusted intersection control point H1'.

[0128] Example 6

[0129] Combination Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water transmission and power generation system based on database drive, comprising the following steps:

[0130] S1. The database contains water transmission line information, and the water transmission line information in the database is read;

[0131] S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings;

[0132] S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points;

[0133] S4, connect the control points to generate multiple lines;

[0134] S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points;

[0135] S6, processing the corner control points to generate smooth turning segments at the control points;

[0136] S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0137] S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

[0138] Based on this method, an embodiment of the present invention further provides a system for generating multiple lines of a water transmission and power generation system, including a database storage module, a control point processing module, a control point adjustment module and a water transmission line generation module;

[0139] The database storage and calculation module is used to update and store the control point table and the line segment table, and calculate the parameters of the control points and line segments;

[0140] The control point processing module is used to determine whether the control point needs to be processed, process adjacent corner control points, and generate a smooth turning section at the control point;

[0141] The control point adjustment module is used to determine whether the smooth turning section at the control point exceeds the design limit, adjust the control point that exceeds the design limit, and update and store the control point table through the database storage and calculation module;

[0142] The water transmission line generation module is used to fit and generate the water diversion system line and tailwater system line, and finally generate the entire water transmission line.

[0143] The water transmission line generation module is used to fit and generate the water diversion system line and tailwater system line, and finally generate the entire water transmission line.

[0144] The above description is only an embodiment of the present invention and is not intended to limit the present invention. Any modification, equivalent replacement and improvement made within the application scope of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for generating multiple lines of a water transmission and power generation system based on database drive, characterized in that: The following steps are involved: S1. The database contains water transmission line information, and the water transmission line information in the database is read; S2, obtaining the location, spacing, and direction of buildings on the water transmission line and splitting the control points of the buildings; S3. Obtain the location, spacing, and direction of buildings on the water transmission line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branches of the water transmission line based on the water supply form and the number of units, generate control points of multiple lines based on the location, spacing, direction, number of main pipes, and number of branches, and the control points of the buildings and the control points of the multiple lines are all recorded as control points; S4, connect the control points to generate multiple lines; S5, judging whether the control points need to be processed, screening the corner control points, and detecting and screening the adjacent corner control points from the corner control points; S6, processing the corner control points to generate smooth turning segments at the control points; S7, determining whether the smooth turning section at the control point exceeds the design limit; if the smooth turning section at the control point exceeds the design limit, adjusting the position of the control point, and repeating steps S4 to S7 until the smooth turning section at the control point meets the design limit; S8. Update the control point table, update the database, generate the water diversion system route and the tailwater system route through program fitting based on the updated control point table, and finally produce all the water transmission routes through program fitting.

2. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 1, characterized in that: In step S1, the water transmission line information includes a three-dimensional multi-segment line formed in sequence of control points, parameters of each segment, the starting point, end point and length of the line, the location, spacing, direction, water supply form and number of units of the buildings.

3. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 2, characterized in that: In step S3, the control points include: the water inlet and outlet of the upper reservoir is the control point F, the water diversion accident gate well is the control point G, the water diversion pressure regulating well is the control point J, the center point of the water diversion branch pipe or the center point of the tailwater branch pipe is the control point K, the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse is the control point P, the center point of the unit is the control point C, the bottom tunnel of the tail lock chamber is the control point L, the tailwater pressure regulating chamber is the control point M, the tailwater maintenance gate well is the control point Q, the water inlet and outlet of the lower reservoir is the control point R, and the intersection of the center line of the line turning section is the control point H. The control points are sorted in sequence according to the main pipe of the water transmission line, the branch pipe of the water transmission line and the direction of water flow.

4. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 3, characterized in that: In step S3, the spacing includes: the spacing LF of the water inlet and outlet of the upper reservoir, the spacing LG of the water diversion accident gate well, the spacing LJ of the water diversion pressure regulating well, the spacing LK of the center points of the diversion / tailwater bifurcations, the spacing LP of the intersection of the axis of the water diversion branch pipe and the axis of the powerhouse, the spacing LC of the center points of the units, the spacing LL of the tunnel at the bottom of the tailwater lock chamber, the spacing LM of the tailwater pressure regulating chamber, the spacing LQ of the tailwater maintenance gate well, and the spacing LR of the water inlet and outlet of the lower reservoir; the position of the control point is determined according to the number of main pipes of the water transmission line, the number of branches of the water transmission line and the spacing, and the control points are connected in sequence.

5. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 4, characterized in that: In step S4, multiple lines are formed based on the control points: the control points are connected in sequence to form multiple lines, and the connection order is FGJKPCKLMQR.

6. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 5, characterized in that: Step S5 specifically includes: S501, screening corner or non-straight line control points and marking them: analyzing and calculating the control points and multiple line segments in the database, screening the corner control points forming corners between lines through angle calculation, marking them, storing the marked corner control points and corner angle information in a marking table, and updating the marking table to the database; S502, detect adjacent corner control points: query the marking table, obtain the sequence of corner control points, confirm whether they are adjacent points according to the line segment table, filter out adjacent corner control points, store adjacent corner control points in the database, and the line segments between adjacent corner control points need to be adjusted. The line segments that need to be adjusted are added to the adjustment queue, and the adjustment queue is updated to the database. The line segments between adjacent corner control points are marked as being in a state to be optimized.

7. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 6, characterized in that: Step S6 specifically includes: S601, deleting a line segment: performing a deletion operation on the line segment between adjacent corner control points marked as being in a state to be optimized in step S5, and updating the line segment between adjacent corner control points in the database to a deleted state; S602, calculating and storing the intersection points of the extended lines: filtering out the line segments between the adjacent corner control points marked as deleted, making extension lines along the line segments where the adjacent corner control points have not been deleted, calculating the intersection points of the extended lines, recording the intersection points of the extended lines as newly generated intersection control points, adding the newly generated intersection control points to the control point table, calculating the positional relationship and connection information between the intersection points of the extended lines and their corresponding adjacent corner control points through database analysis, updating the line table, and updating the new control point table and line table to the database; S603, generate new control points, chamfer and store: chamfer the newly generated intersecting control points in the database, record the chamfer information in the turning field, store the turning field in the control point table, and define the chamfer information as a smooth turning segment at the control point.

8. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 7, characterized in that: In step S7, the design limit includes a turning radius requirement and a turning angle requirement. Step S7 specifically includes: S701, storing and checking turning radius requirements: storing the turning radius requirements in a checking field, updating the checking field in a control point table, calculating the turning radius of a smooth turning segment at a control point through a database, generating a reminder for a smooth turning segment at a control point whose turning radius does not meet the turning radius requirements, recording the reminder in a storage notification table, and storing the storage notification table in a database; S702, storing and checking the turning angle requirement: storing the turning angle requirement in the checking field, updating the checking field to the control point table, calculating the turning angle of the smooth turning segment at the control point stored in the notification table through the database, marking the smooth turning segment at the control point whose turning angle does not meet the turning angle requirement as a confirmation-required state, and adjusting the position of the intersection control point newly generated in step S603 for the smooth turning segment at the control point in the confirmation-required state; S703: Record the position of the newly generated intersection control point after adjustment as the adjusted intersection control point, store it in the control point table, and update the database.

9. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 8, characterized in that: In step S701, the turning radius requirement is that the turning radius of the turning section is not less than 5 times the hole diameter.

10. The method for generating multiple lines of a water transmission and power generation system based on database drive according to claim 8, characterized in that: In step S702, the turning angle requirement is that the turning angle is not greater than 120°.

11. A system for generating multiple lines of a water transmission and power generation system using the method for generating multiple lines of a water transmission and power generation system based on database drive as described in any one of claims 1 to 10, characterized in that: It includes a database storage module, a control point processing module, a control point adjustment module and a water transmission line generation module; The database storage and calculation module is used to update and store the control point table and the line segment table, and calculate the parameters of the control points and line segments; The control point processing module is used to determine whether the control point needs to be processed, process adjacent corner control points, and generate a smooth turning section at the control point; The control point adjustment module is used to determine whether the smooth turning section at the control point exceeds the design limit, adjust the control point that exceeds the design limit, and update and store the control point table through the database storage and calculation module; The water transmission line generation module is used to fit and generate the water diversion system line and tailwater system line, and finally generate the entire water transmission line.

Images