Method and system for generating multiple lines of a water conveyance and power generation system based on database drive

Abstract

The present invention belongs to the technical field of water conveyance and power generation systems, and discloses a method and system for generating multiple lines of a water conveyance and power generation system based on database driving. The control point table and line segment table are updated and stored through a database storage and calculation module, the parameters of the control points and line segments are calculated, the control point processing module determines whether the control points need to be processed, processes adjacent angled control points, and generates a smooth turning section at the control points. The control point adjustment module determines whether the smooth turning section at the control points exceeds the design limit, adjusts the control points that exceed the design limit, and updates and stores the control point table through the database storage and calculation module. Finally, the water conveyance line generation module fits and generates the water diversion system line and the tailrace system line, and finally generates all the water conveyance lines. The present invention can automatically fit and generate multiple water conveyance lines, achieve three-dimensional dynamic adjustment, and reduce missing items and error problems during line optimization by setting line generation logic and constraint limits.

Description

Technical Field

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

[0002] At present, the line design of the water conveyance and power generation system of pumped storage power stations is mainly two-dimensional design of horizontal and vertical profiles. Some scholars have also explored three-dimensional line design, but the accuracy and depth are insufficient. It can only meet the needs of quickly outputting solutions for preliminary projects, and cannot meet the requirements of three-special and feasibility study reviews. It can realize local driving parameters, but the applicable range is relatively limited and lacks flexibility, and can only meet relatively typical layout forms. There are mainly problems such as the lack of complex logical judgment in generating multiple lines, the accuracy not reaching the requirements of the recommended scheme, and at the same time, the lack of flexible adjustment strategies, unable to meet the needs of scheme adjustment and optimization. In the process of three-dimensional line design of the water conveyance and power generation system of pumped storage power stations, generating multiple water conveyance lines 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 at the deficiencies of the prior art and provides a method and system for generating multiple lines of a water conveyance and power generation system based on database drive, which adjusts control points exceeding the set limit value by setting line generation logic and constraint limits, automatically fits and generates multiple water conveyance lines, realizes three-dimensional dynamic adjustment, and reduces the problems of missing items and errors during line optimization.

[0004] To achieve the above technical objectives, the present invention adopts the following technical solutions:

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

[0006] S1. The database contains water conveyance line information, and reads the water conveyance line information in the database;

[0007] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0008] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of generating units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of generating units, generate control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes, and both the control points of the buildings and the control points of multiple lines are recorded as control points;

[0009] S4. Connect the control points to generate multiple line segments;

[0010] S5. Determine whether the control points need to be processed, screen the corner control points, and detect and screen out adjacent corner control points from the corner control points;

[0011] S6. Process the corner control points to generate a smooth turning section at the control points;

[0012] S7. Determine whether the smooth turning section at the control points exceeds the design limit. If the smooth turning section at the control points exceeds the design limit, adjust the positions of the control points, and repeat steps S4 to S7 until the smooth turning section at the control points meets the design limit;

[0013] S8. Update the control point table, update the database, and generate the water diversion system line and the tail water system line through program fitting based on the updated control point table, and finally generate all the water conveyance lines through program fitting.

[0014] Preferably, in step S1, the water conveyance line information includes a three-dimensional polyline formed in the order of control points, the parameters of each section of the line, the starting point, the ending point and the line length of the line, the position, the spacing, the direction, the water supply form and the number of units of the building.

[0015] Preferably, in step S3, the control points include: the water inlet and outlet of the upper reservoir is control point F, the diversion emergency gate shaft is control point G, the diversion surge tank is control point J, the center point of the diversion bifurcated pipe or the center point of the tail water bifurcated pipe is control point K, the intersection of the axis of the diversion branch pipe and the axis of the power house is control point P, the center point of the unit is control point C, the tunnel at the bottom of the tail gate chamber is control point L, the tail water surge tank is control point M, the tail water maintenance gate shaft is control point Q, the water inlet and outlet of the lower reservoir is control point R, and the intersection of the center lines of the line turning sections is control point H. Sort the control points in sequence according to the main water conveyance line, the branch water conveyance line and the water flow direction.

[0016] Preferably, in step S3, the spacing includes: the spacing LF between the water inlet and outlet of the upper reservoir, the spacing LG between the diversion emergency gate shafts, the spacing LJ between the diversion surge tanks, the spacing LK between the center points of the diversion / tail water bifurcated pipes, the spacing LP between the intersection of the axis of the diversion branch pipe and the axis of the power house, the spacing LC between the center points of the units, the spacing LL of the tunnel at the bottom of the tail gate chamber, the spacing LM of the tail water surge tank, the spacing LQ of the tail water maintenance gate shaft, the spacing LR between the water inlet and outlet of the lower reservoir; Determine the positions of the control points according to the number of main water conveyance lines, the number of branch water conveyance lines and the spacing, and connect the control points in sequence.

[0017] Preferably, in step S4, based on the connection of the control points to form multiple sections of lines: connect the control points in sequence to form multiple sections of lines, and the connection sequence is F - G - J - K - P - C - K - L - M - Q - R.

[0018] Preferably, step S5 specifically includes:

[0019] Step S5 specifically includes:

[0020] S501. Screen and mark the angled or non - straight control points: Analyze and calculate the control points and multi - segment lines in the database. Through angle calculation, screen out the angled control points formed between lines and mark them. Store the marked angled control points and angled angle information in the mark table, and update the mark table to the database;

[0021] S502. Detect adjacent angled control points: Query the mark table to obtain the sequence of angled control points. Confirm whether they are adjacent points according to the line segment table, screen out the adjacent angled control points, store the adjacent angled control points in the database. The line segments between adjacent angled control points need to be adjusted. Add the line segments to be adjusted to the adjustment queue, and update the adjustment queue to the database. Mark the line segments between adjacent angled control points as the state to be optimized.

[0022] Preferably, step S6 specifically includes:

[0023] S601. Delete the line segment: Perform a deletion operation on the line segment between adjacent angled control points marked as the state to be optimized in step S5, and update the line segment between adjacent angled control points in the database to the deleted state;

[0024] S602. Calculate and store the intersection point of the extension lines: Screen out the line segments between adjacent angled control points marked as the deleted state. Make extension lines along the non - deleted line segments of adjacent angled control points, calculate the intersection point of the extension lines, record the intersection point of the extension lines as the newly generated intersection control point, add the newly generated intersection control point to the control point table. Through database analysis and calculation of the positional relationship and connection information between the intersection point of the extension lines and its corresponding adjacent angled control points, update to the line table, and update the new control point table and line table to the database;

[0025] S603. Generate new control points, chamfer, and store: Perform chamfering on the newly generated intersection control points in the database, record the chamfering information in the turning field, store the turning field in the control point table, and define the chamfering information as a smooth turning section at the control point.

[0026] Preferably, in step S7, the design limits include the turning radius requirement and the turning angle requirement. Step S7 specifically includes:

[0027] S701. Store and check the turning radius requirement: Store the turning radius requirement in the check field, update the check field to the control point table. Calculate the turning radius of the smooth turning section at the control point through the database. Generate a reminder for the smooth turning section at the control point where the turning radius does not meet the turning radius requirement, record it in the deposit notice table, and store the deposit notice table in the database;

[0028] S702. Store and check the turning angle requirements: Store the turning angle requirements in the check field, update the check field to the control point table, calculate the turning angle of the smooth turning section at the control point stored in the notification table through the database, mark the smooth turning section at the control point where the turning angle does not meet the turning angle requirements as the to-be-confirmed status, and for the smooth turning section at the control point in the to-be-confirmed status, adjust the position of the newly generated intersecting control point in step S603;

[0029] S703. Record the position of the adjusted newly generated intersecting control point as the adjusted intersecting control point, and 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 limit.

[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 water conveyance and power generation system lines using the method for generating multiple water conveyance and power generation system lines based on database driving as described above, including a database storage module, a control point processing module, a control point adjustment module, and a water conveyance 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 the line segments;

[0034] The control point processing module is used to determine whether the control points need to be processed, process adjacent angled control points, and generate smooth turning sections at the control points;

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

[0036] The water conveyance line generation module is used to fit and generate the water diversion system line and the tail water system line, and finally generate all the water conveyance lines.

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

[0038] (1) The present invention takes the proposed water conveyance line already existing in the database as the reference data, based on the layout parameters such as the position and spacing direction of the buildings and the water conveyance line direction, adjusts the control points that exceed the set limit value by setting the line generation logic and constraint limits, updates the control point table and the line segment table in the database, and automatically fits and generates multiple water conveyance lines, greatly improving the efficiency of designers when designing water conveyance line schemes;

[0039] (2) The present invention makes fine adjustments to the control points within the set constraint set limit range, and accordingly adjusts the corresponding lines and associated lines, achieving three-dimensional dynamic adjustment, which provides convenience for designers to modify and optimize the lines, effectively reduces the occurrence of missing items and errors, and improves the quality and efficiency of the adjustment of the water conveyance line. Description of the Drawings

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

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

[0042] Figure 3 It is an example diagram of adjusting intersecting control points according to an embodiment of the present invention. Detailed Embodiments

[0043] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0044] Embodiment 1

[0045] Combined with Figure 1 As shown, an embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database driving, including the following steps:

[0046] S1. The database contains water conveyance line information, and reads the water conveyance line information in the database;

[0047] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0048] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of units, and generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes. The control points of the buildings and the control points of multiple lines are both recorded as control points;

[0049] S4. Connect the control points to generate multiple segments of lines;

[0050] S5. Determine whether the control points need to be processed, screen the corner control points, and detect and screen out adjacent corner control points from the corner control points;

[0051] S6. Process the corner control points to generate smooth turning segments at the control points;

[0052] S7. Determine whether the smooth turning segments at the control points exceed the design limits. If the smooth turning segments at the control points exceed the design limits, adjust the positions of the control points and repeat steps S4 to S7 until the smooth turning segments at the control points meet the design limits;

[0053] S8. Update the control point table and the database, and generate the water diversion system line and the tail water system line by program fitting based on the updated control point table. Finally, generate all the water conveyance lines by program fitting.

[0054] Embodiment 2

[0055] Combined with Figure 1 As shown in the figure, the embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database driving, including the following steps:

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

[0057] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0058] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of units, and generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes. The control points of the buildings and the control points of multiple lines are all recorded as control points;

[0059] S4. Connect the control points to generate multiple line segments;

[0060] S5. Determine whether the control points need to be processed, screen the corner control points, and detect and screen out adjacent corner control points from the corner control points;

[0061] S6. Process the corner control points to generate smooth turning segments at the control points;

[0062] S7. Determine whether the smooth turning segments at the control points exceed the design limits. If the smooth turning segments at the control points exceed the design limits, adjust the positions of the control points and repeat steps S4 to S7 until the smooth turning segments at the control points meet the design limits;

[0063] S8. Update the control point table, update the database, generate the water diversion system line and the tail water system line through program fitting based on the updated control point table, and finally generate all the water conveyance lines through program fitting.

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

[0065] The water conveyance line information has been stored in the database in the preliminary line stage. Extract the initial control points from the control point table, form the data of multiple three-dimensional polyline lines of the water conveyance line in order, and store the water conveyance line information in the line segment table; a unique identifier is established for each line segment in the database, and information such as the starting point, ending point and length of the line is recorded to ensure the complete record of the initial line structure.

[0066] Furthermore, in step S3, the control points include: the inlet / outlet of the upper reservoir is control point F, the diversion emergency gate shaft is control point G, the diversion surge chamber is control point J, the center point of the diversion bifurcation pipe or the center point of the tail water bifurcation pipe is control point K, the intersection of the axis of the diversion branch pipe and the axis of the powerhouse is control point P, the center point of the unit is control point C, the tunnel at the bottom of the tail gate chamber is control point L, the tail water surge chamber is control point M, the tail water maintenance gate shaft is control point Q, the inlet / outlet of the lower reservoir is control point R, and the intersection of the center lines of the line turning sections is control point H. Sort the control points in sequence according to the main water conveyance line, the branch water conveyance line and the water flow direction.

[0067] The spacing includes: the spacing LF of the inlet / outlet of the upper reservoir, the spacing LG of the diversion emergency gate shaft, the spacing LJ of the diversion surge chamber, the spacing LK of the center point of the diversion / tail water bifurcation pipe, the spacing LP of the intersection of the axis of the diversion branch pipe and the axis of the powerhouse, the spacing LC of the center point of the unit, the spacing LL of the tunnel at the bottom of the tail gate chamber, the spacing LM of the tail water surge chamber, the spacing LQ of the tail water maintenance gate shaft, and the spacing LR of the inlet / outlet of the lower reservoir; determine the positions of the control points according to the number of main water conveyance lines, the number of branch water conveyance lines and the spacing, and connect the control points in sequence.

[0068] The positions of adjacent control points of the building are determined by the spacing and direction. For example, the spacing between surge chamber 1 and surge chamber 2 is expressed as LJ1 - LJ2.

[0069] Furthermore, in step S4, form multiple line segments based on the connection of control points: connect the control points in sequence to form multiple line segments, and the connection sequence is F - G - J - K - P - C - K - L - M - Q - R.

[0070] Further, in step S6, perform a deletion operation on the line segments between adjacent corner control points to be processed, extend the line segments of the adjacent corner control points that are not deleted, calculate the intersection points of the extended lines, record the intersection points of the extended lines as newly generated intersection control points, perform chamfering on the newly generated intersection control points, and define the chamfering information as a smooth turning section at the control point;

[0071] Further, in step S7, store the turning radius requirement and the turning angle requirement in the control point table and update the database. Calculate the turning radius and the turning angle of the smooth turning section at the control point through the database, filter out the smooth turning sections at the control points that do not meet the turning radius requirement and the turning angle requirement, and mark them as to-be-confirmed status. Determine whether the smooth turning sections at the control points in the to-be-confirmed status exceed the design limit. For the smooth turning sections at the control points that exceed the design limit, adjust the positions of the newly generated intersection control points in step S6, record the adjusted positions of the newly generated intersection control points as the adjusted intersection control points, and store them in the control point table and update the database.

[0072] Embodiment 3

[0073] Combined with Figure 1 As shown, the embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database driving, including the following steps:

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

[0075] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0076] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of units, and generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes. The control points of the buildings and the control points of multiple lines are both recorded as control points;

[0077] S4. Connect the control points to generate multiple line segments;

[0078] S5. Determine whether the control points need to be processed, filter out the corner control points, and detect and filter out adjacent corner control points from the corner control points;

[0079] S6. Process the corner control points to generate a smooth turning section at the control point;

[0080] S7. Determine 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, adjust the position of the control point, and repeat steps S4 to S7 until the smooth turning section at the control point meets the design limit;

[0081] S8. Update the control point table and the database. Based on the updated control point table, generate the water diversion system line and the tail water system line through program fitting, and finally generate all the water conveyance lines through program fitting.

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

[0083] S501. Screen and mark the angled or non - straight control points: Analyze and calculate the control points and multi - segment lines in the database, screen out the angled control points where angles are formed between lines through angle calculation, and mark them. Store the marked angled control points and the angled information in the mark table, and update the mark table to the database;

[0084] Specifically, if the line segments on both sides of the control point are non - straight, it is an angled control point;

[0085] S502. Detect adjacent angled control points: Query the mark table to obtain the sequence of angled control points, confirm whether they are adjacent points according to the line segment table, screen out the adjacent angled control points, store the adjacent angled control points in the database. The line segments between adjacent angled control points need to be adjusted. Add the line segments to be adjusted to the adjustment queue, and update the adjustment queue to the database. Mark the line segments between adjacent angled control points as the state to be optimized.

[0086] Embodiment 4

[0087] Combined with Figure 1 As shown in the figure, the embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database driving, including the following steps:

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

[0089] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0090] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of units. Generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes. The control points of the buildings and the control points of multiple lines are both recorded as control points;

[0091] S4. Connect the control points to generate multiple line segments;

[0092] S5. Determine whether the control points need to be processed, screen the corner control points, and detect and screen adjacent corner control points from the corner control points;

[0093] S6. Process the corner control points to generate a smooth turning section at the control points;

[0094] S7. Determine whether the smooth turning section at the control points exceeds the design limit. If the smooth turning section at the control points exceeds the design limit, adjust the position of the control points, and repeat steps S4 to S7 until the smooth turning section at the control points meets the design limit;

[0095] S8. Update the control point table, update the database, and generate the water diversion system line and the tail water system line by program fitting based on the updated control point table. Finally, generate all the water conveyance lines by program fitting.

[0096] Step S5 specifically includes:

[0097] S501. Screen and mark the corner or non - straight control points: Analyze and calculate the control points and multiple line segments in the database, screen out the corner control points where there are corners formed between the line segments through angle calculation, and mark them. Store the marked corner control points and corner angle information in the mark table, and update the mark table to the database;

[0098] S502. Detect adjacent corner control points: Query the mark table to obtain the sequence of corner control points, confirm whether they are adjacent points according to the line segment table, screen out the adjacent corner control points, store the adjacent corner control points in the database. The line segments between adjacent corner control points need to be adjusted. Add the line segments to be adjusted to the adjustment queue, and update the adjustment queue to the database. Mark the line segments between adjacent corner control points as the to - be - optimized state;

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

[0100] S601. Delete the line segments: Perform a deletion operation on the line segments between the adjacent corner control points marked as the to - be - optimized state in step S5, and update the line segments between the adjacent corner control points in the database to the deleted state;

[0101] S602. Calculate the intersection point of the extension lines and store: Screen out the line segments between adjacent angled control points marked as deleted, draw extension lines along the non-deleted line segments of adjacent angled control points, calculate the intersection point of the extension lines, record the intersection point of the extension lines as the newly generated intersection control point, add the newly generated intersection control point to the control point table, analyze and calculate the positional relationship and connection information between the intersection point of the extension lines and its corresponding adjacent angled control points through the database, update it to the line table, and update the new control point table and line table to the database;

[0102] S603. Generate new control points, chamfer, and store: Chamfer the newly generated intersection 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;

[0103] As Figure 2 shown, process the adjacent angled control points G2 and J2 to generate a smooth turning segment at the control point.

[0104] Example 5

[0105] Combined with Figure 1 shown, the embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database drive, including the following steps:

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

[0107] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0108] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main water conveyance line pipes and the number of branch water conveyance line pipes based on the water supply form and the number of units, generate control points for multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes, and record the control points of the buildings and the control points of multiple lines as control points;

[0109] S4. Connect the control points to generate multiple line segments;

[0110] S5. Determine whether the control points need to be processed, screen out the angled control points, and detect and screen out adjacent angled control points from the angled control points;

[0111] S6. Process the angled control points to generate a smooth turning segment at the control point;

[0112] S7. Determine 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, adjust the position of the control point, and repeat 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 line and the tail water system line through program fitting based on the updated control point table, and finally generate all the water conveyance lines through program fitting.

[0114] Step S5 specifically includes:

[0115] S501. Screen and mark the angled or non - straight control points: Analyze and calculate the control points and multi - segment lines in the database, screen out the angled control points where angles are formed between lines through angle calculation, and mark them. Store the marked angled control points and angled information in the mark table, and update the mark table to the database;

[0116] S502. Detect adjacent angled control points: Query the mark table to obtain the sequence of angled control points, confirm whether they are adjacent points according to the line segment table, screen out the adjacent angled control points, store the adjacent angled control points in the database. The line segments between adjacent angled control points need to be adjusted. Add the line segments to be adjusted to the adjustment queue, and update the adjustment queue to the database. Mark the line segments between adjacent angled control points as the state to be optimized;

[0117] Step S6 specifically includes:

[0118] S601. Delete the line segment: Perform a deletion operation on the line segment between adjacent angled control points marked as the state to be optimized in step S5, and update the line segment between adjacent angled control points in the database to the deleted state;

[0119] S602. Calculate and store the intersection point of the extension lines: Screen out the line segments between adjacent angled control points marked as the deleted state. Extend the non - deleted line segments along the adjacent angled control points, calculate the intersection point of the extension lines, record the intersection point of the extension lines as the newly generated intersection control point, add the newly generated intersection control point to the control point table, analyze and calculate the positional relationship and connection information between the intersection point of the extension lines and its corresponding adjacent angled control points through the database, update it to the line table, and update the new control point table and line table to the database;

[0120] S603. Generate new control points, chamfer, and store: Chamfer the newly generated intersection 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 the smooth turning section at the control point;

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

[0122] S701. Store and check the turning radius requirement: Store the turning radius requirement into the check field, update the check field to the control point table, calculate the turning radius of the smooth turning section at the control point through the database, generate a reminder for the smooth turning section at the control point where the turning radius does not meet the turning radius requirement, record it into the deposit notice table, and store the deposit notice table into the database;

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

[0124] S702. Store and check the turning angle requirement: Store the turning angle requirement into the check field, update the check field to the control point table, calculate the turning angle of the smooth turning section at the control point in the deposit notice table through the database, mark the smooth turning section at the control point where the turning angle does not meet the turning angle requirement as the status to be confirmed, and for the smooth turning section at the control point in the status to be confirmed, adjust the position of the newly generated intersection control point in step S603;

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

[0126] S703. Record the position of the adjusted newly generated intersection control point as the adjusted intersection control point, store it into the control point table, and update the database;

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

[0128] Embodiment 6

[0129] Combined with Figure 1 shown, the embodiment of the present invention provides a method for generating multiple lines of a water conveyance and power generation system based on database driving, including the following steps:

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

[0131] S2. Obtain the positions, spacings, and directions of the buildings on the water conveyance line and split the control points of the buildings;

[0132] S3. Obtain the positions, spacings, and directions of the buildings on the water conveyance line, obtain the water supply form and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply form and the number of units, generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes, and the number of branch pipes, and record the control points of the buildings and the control points of multiple lines as control points;

[0133] S4. Connect the control points to generate multiple line segments;

[0134] S5. Determine whether the control points need to be processed, screen the angled control points, and detect and screen out adjacent angled control points from the angled control points;

[0135] S6. Process the angled control points to generate smooth turning segments at the control points;

[0136] S7. Determine whether the smooth turning segments at the control points exceed the design limit. If the smooth turning segments at the control points exceed the design limit, adjust the positions of the control points, and repeat steps S4 to S7 until the smooth turning segments at the control points meet the design limit;

[0137] S8. Update the control point table, update the database, and generate the water diversion system line and the tail water system line by program fitting based on the updated control point table, and finally generate all the water conveyance lines by program fitting.

[0138] Based on this method, an embodiment of the present invention further provides a system for generating multiple lines of a water conveyance and power generation system, including a database storage module, a control point processing module, a control point adjustment module, and a water conveyance 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 the line segments;

[0140] The control point processing module is used to determine whether the control points need to be processed, process the adjacent angled control points, and generate smooth turning segments at the control points;

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

[0142] The water conveyance line generation module is used to fit and generate the water diversion system line and the tail water system line, and finally generate all the water conveyance lines.

[0143] The water conveyance line generation module is used to fit and generate the water diversion system line and the tail water system line, and finally generate all the water conveyance lines.

[0144] The above are only the embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, and improvements made within the scope of the application 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 conveyance and power generation system based on database driving, characterized in that, It includes the following steps: S1. The database contains water conveyance line information, and reads the water conveyance line information in the database; S2. Obtain the positions, spacings, directions of the buildings on the water conveyance line and split the control points of the buildings; S3. Obtain the positions, spacings, directions of the buildings on the water conveyance line, obtain the water supply forms and the number of units of the buildings, determine the number of main pipes and the number of branch pipes of the water conveyance line based on the water supply forms and the number of units, generate the control points of multiple lines based on the positions, spacings, directions, the number of main pipes and the number of branch pipes, and both the control points of the buildings and the control points of multiple lines are recorded as control points; S4. Connect the control points to generate multiple sections of lines; S5. Judge whether the control points need to be processed, screen the corner control points, and detect and screen out adjacent corner control points from the corner control points; S6. Process the corner control points and generate a smooth turning section at the control points in combination with the database; S7. Judge whether the smooth turning section at the control points exceeds the design limit. If the smooth turning section at the control points exceeds the design limit, adjust the positions of the control points, and repeat steps S4 to S7 until the smooth turning section at the control points meets the design limit; S8. Update the control point table, update the database, generate the water intake system line and the tail water system line by program fitting based on the updated control point table, and finally generate all the water conveyance lines by program fitting.

2. The method for generating multiple lines of a water conveyance and power generation system based on database drive according to claim 1, wherein In step S1, the water conveyance line information includes a three-dimensional multi-section line formed in the order of control points, the parameters of each section of the line, the starting point, the ending point and the line length of the line, and the positions, spacings, directions, water supply forms and the number of units of the buildings.

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

4. The method for generating multiple lines of a water conveyance and power generation system based on database drive according to claim 3, characterized in that, In step S3, the spacings include: the spacing LF of the intake and outlet of the upper reservoir, the spacing LG of the diversion accident gate shaft, the spacing LJ of the diversion surge chamber, the spacing LK of the center point of the diversion / tail water bifurcation, the spacing LP of the intersection of the axis of the diversion branch pipe and the axis of the powerhouse, the spacing LC of the center point of the unit, the spacing LL of the bottom tunnel of the tail gate chamber, the spacing LM of the tail water surge chamber, the spacing LQ of the tail water maintenance gate shaft, the spacing LR of the intake and outlet of the lower reservoir; Determine the positions of the control points according to the number of main pipes of the water conveyance line, the number of branch pipes of the water conveyance line and the spacings, and connect the control points in sequence.

5. The method for generating multiple lines of a water conveyance and power generation system based on database driving according to claim 4, characterized in that, In step S4, multiple sections of lines are formed based on the connection of the control points: Connect the control points in sequence to form multiple sections of lines, and the connection sequence is F - G - J - K - P - C - K - L - M - Q - R.

6. The method for generating multiple lines of a water conveyance and power generation system based on database driving according to claim 5, wherein Step S5 specifically includes: S501. Screen and mark angled or non - straight control points: Analyze and calculate control points and multi - segment lines in the database. Through angle calculation, screen out angled control points where angles are formed between lines, and mark them. Store the marked angled control points and angled angle information in a mark table, and update the mark table to the database; S502. Detect adjacent angled control points: Query the mark table to obtain the sequence of angled control points. Confirm whether they are adjacent points according to the line segment table, screen out adjacent angled control points, store the adjacent angled control points in the database. The line segments between adjacent angled control points need to be adjusted. Add the line segments to be adjusted to an adjustment queue, and update the adjustment queue to the database. Mark the line segments between adjacent angled control points as the status to be optimized.

7. The method for generating multiple lines of a water conveyance and power generation system based on database drive according to claim 6, wherein Step S6 specifically includes: S601. Delete line segments: Perform a deletion operation on the line segments between adjacent angled control points marked as the status to be optimized in step S5, and update the line segments between adjacent angled control points in the database to the deleted status; S602. Calculate and store the intersection points of extended lines: Screen out the line segments between adjacent angled control points marked as the deleted status. Extend the non - deleted line segments along adjacent angled control points to calculate the intersection points of the extended lines. Denote the intersection points of the extended lines as newly generated intersection control points. Add the newly generated intersection control points to the control point table. Through database analysis and calculation of the positional relationship and connection information between the intersection points of the extended lines and their corresponding adjacent angled control points, update them to the line table. Update the new control point table and line table to the database; S603. Generate new control points, chamfer, and store: Perform chamfering on the newly generated intersection control points in the database. Record the chamfering information in the turning field, store the turning field in the control point table, and define the chamfering information as a smooth turning section at the control point.

8. The method for generating multiple lines of a water conveyance and power generation system based on database driving according to claim 7, wherein In step S7, the design limits include the turning radius requirement and the turning angle requirement. Step S7 specifically includes: S701. Store and check the turning radius requirement: Store the turning radius requirement in the check field, update the check field to the control point table. Calculate the turning radius of the smooth turning section at the control point through the database. Generate a reminder for the smooth turning section at the control point where the turning radius does not meet the turning radius requirement, record it in the deposit notice table, and store the deposit notice table in the database; S702. Store and check the turning angle requirement: Store the turning angle requirement in the check field, update the check field to the control point table. Calculate the turning angle of the smooth turning section at the control point in the deposit notice table through the database. Mark the smooth turning section at the control point where the turning angle does not meet the turning angle requirement as the status to be confirmed. For the smooth turning section at the control point in the status to be confirmed, adjust the position of the newly generated intersection control points in step S603; S703. Denote the position of the adjusted newly generated intersection control points as the adjusted intersection control points, and store them in the control point table, and update the database.

9. The method for generating multiple lines of a water conveyance and power generation system based on database driving according to claim 8, wherein 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 limit.

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

11. A system for generating multiple lines of a water conveyance and power generation system using the method for generating multiple lines of a water conveyance and power generation system based on database driving as described in any one of claims 1-10, characterized in that, It includes a database storage module, a control point processing module, a control point adjustment module, and a water conveyance 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 the line segments; The control point processing module is used to determine whether the control points need to be processed, process adjacent angled control points, and generate a smooth turning section at the control points; The control point adjustment module is used to determine whether the smooth turning section at the control points exceeds the design limit, adjust the control points that exceed the design limit, and update and store the control point table through the database storage and calculation module; The water conveyance line generation module is used to fit and generate the water diversion system line and the tail water system line, and finally generate all the water conveyance lines.

Images