Method and system for synchronously and automatically updating roadway information in real time

Abstract

The invention provides a real-time synchronous automatic updating method and system for roadway information, and particularly relates to the technical field of mine digitization and informatization construction.The method comprises the steps that roadway parameters are input through a graphical user interface, a roadway calculation model is established for analog calculation, parameter reasonability is judged according to coal mine roadway specifications, and feedback adjustment is conducted till the parameters meet the specifications. And designing a database structure to store roadway parameters and a fit-scale simulation result, realizing interaction between the AutoCAD and the database, and automatically updating roadway information. Furthermore, according to the parameters and simulation results, a roadway geometric model is generated, a topological structure is constructed and integrated into a CAD roadway drawing, and the roadway geometric model and the topological structure are synchronously updated into a database and a system in real time, so that the accuracy and the real-time performance of roadway information are ensured. According to the method, the technical problem that the working efficiency of business personnel is low because the drawing data of the roadway cannot be automatically identified and utilized by the management system in real time is solved, so that seamless joint and real-time sharing of the coal mine design drawing data and the management system data are realized.

Description

Technical Field

[0001] The present invention relates to the technical field of mine digitalization and information construction, and in particular to a method and system for real-time synchronous automatic updating of tunnel information. Background Art

[0002] With the continuous advancement of information technology, the coal mining industry is gradually transforming towards digitalization and intelligence. Against this background, the production and management of coal mine design drawings have also ushered in new changes. However, most of the coal mine design drawing manufacturers on the current market are still limited to the update and production of traditional drawings, and have not fully adapted to the widespread application of web-based management systems. While these management systems have improved management efficiency, they have also exposed the problem of poor data sharing. Due to the mismatch between the drawing data and the system data format, business personnel need to repeatedly enter data in the management system, which not only increases the workload, but also causes a split between systems, affecting the overall management efficiency. This problem not only hinders the digital transformation process of the coal mining industry, but also makes coal mining companies resistant to the existing management system.

[0003] In the face of the problem of poor data sharing, traditional technologies mainly adopt a "secondary entry" solution. That is, after the drawing is completed, the business personnel need to re-enter the key information in the drawing into the system according to the data format required by the management system. Although this method has achieved data integration and presentation to a certain extent, it does not essentially solve the fundamental problem of data sharing. Secondary entry is not only time-consuming and labor-intensive, but also prone to errors during the entry process, reducing the accuracy and timeliness of the data. In addition, this solution cannot fundamentally break the barriers between systems and achieve true data interoperability and sharing. The essence of this problem lies in breaking the barriers between data formats and systems, ensuring that the drawing data can be directly and accurately identified and used by the management system, thereby avoiding duplication of work by business personnel and improving overall management efficiency. Solving this problem will not only help promote the digital transformation process of the coal mining industry, but also improve the management level and competitiveness of coal mining enterprises and achieve true intelligent management.

[0004] To sum up, the technical problem that the tunnel drawing data cannot be recognized and utilized by the management system in real time and automatically, resulting in low work efficiency of business personnel, is a core technical problem that needs to be solved urgently. Summary of the invention

[0005] The main purpose of the present invention is to provide a method and system for real-time synchronous automatic updating of tunnel information, so as to solve the technical problem that the tunnel drawing data cannot be recognized and utilized by the management system in real time and automatically, resulting in low work efficiency of business personnel, thereby realizing seamless connection and real-time sharing of coal mine design drawing data and management system data.

[0006] In order to achieve the above-mentioned purpose, the present invention provides a method and system for real-time synchronous automatic updating of lane information.

[0007] In a first aspect, the present invention provides a method for real-time synchronous automatic updating of lane information, the method comprising: Using AutoCAD as a platform, designing a graphical user interface using a .NET development environment on the platform, and inputting lane parameters into the graphical user interface; According to the input tunnel parameters, a tunnel calculation model is established to perform simulation calculation, the rationality of the tunnel parameters is judged according to the coal mine tunnel specifications and the results of the simulation calculation, and according to the rationality judgment results, the tunnel parameters are adjusted by feedback until the coal mine tunnel specifications are met; Designing a database structure to store the laneway parameters and the results of the simulation calculation that meet the coal mine laneway specifications, and automatically updating the laneway information in the database through the interaction between the platform and the database, wherein the laneway information is used to indicate the laneway parameters and the results of the simulation calculation that meet the coal mine laneway specifications; Generate a logical roadway geometry model according to the roadway parameters and the results of the simulation calculation that meet the coal mine roadway specifications, and construct a roadway topology structure according to the roadway geometry model; The CAD lane map of the platform is obtained, the lane information and the data of the topological structure are integrated into the CAD lane map, and the CAD lane map is automatically and synchronously updated in real time to the database to update the lane information and the corresponding lane map in the real-time synchronously and automatically updating system.

[0008] Optionally, the process of using AutoCAD as a platform, designing a graphical user interface using a .NET development environment on the platform, and inputting lane parameters in the graphical user interface includes: Build the development environment for AutoCAD and .NET; Performing format and logic verification on the lane parameters input by the user; The verified lane parameters are input into the graphical user interface.

[0009] Optionally, establishing a tunnel calculation model for simulation calculation according to the input tunnel parameters includes: Establishing a tunnel calculation model according to the input tunnel parameters; A calculation script is written in a programming language or an external calculation program is called to perform simulation calculations on the tunnel through the tunnel calculation model. The simulation calculations include but are not limited to: simulation calculations of stability, ventilation, and drainage.

[0010] Optionally, generating a logical roadway geometry model according to the roadway parameters and the result of the simulation calculation that meets the coal mine roadway specification, and constructing a roadway topology structure according to the roadway geometry model includes: Generate a logical roadway geometry model according to the roadway parameters and the simulation calculation results that meet the coal mine roadway specifications; Automatically connecting different lane segments according to the logical relationship of the lanes of the lane geometry model to form a connection relationship of the lanes; The topological structure of the lanes is constructed based on the connection relationship of the lanes.

[0011] Optionally, the step of obtaining a CAD lane map of the platform, integrating the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously updating the CAD lane map to a database in real time to update the lane information and the corresponding lane map in the real time and automatic synchronous updating system includes: Acquire a CAD lane map of the platform, and integrate the lane information and the data of the topological structure into the CAD lane map; Digitally processing the CAD lane map to obtain digital lane graphic data; The digitalized lane graphic data is automatically and synchronously updated in real time to the database to update the lane information and the corresponding lane map in the system is automatically and synchronously updated in real time.

[0012] In a second aspect, the present invention provides a system for real-time synchronous automatic updating of lane information, the automatic updating system being applied to the automatic updating method described in the first aspect, the automatic updating system comprising: A graphical user interface input unit is used to design a graphical user interface using AutoCAD as a platform and a .NET development environment on the platform, and input lane parameters on the graphical user interface; A simulation calculation unit, the simulation calculation unit is connected to the graphical user interface input unit, the simulation calculation unit is used to establish a tunnel calculation model for simulation calculation according to the input tunnel parameters, judge the rationality of the tunnel parameters according to the coal mine tunnel specifications and the results of the simulation calculation, and according to the judgment result of the rationality, feedback and adjust the tunnel parameters until the coal mine tunnel specifications are met; A database interaction unit, the database interaction unit is connected to the simulation calculation unit, the database interaction unit is used to design a database structure to store the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications, and automatically update the tunnel information in the database through the interaction between the platform and the database, wherein the tunnel information is used to indicate the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications; A topology structure construction unit, the topology structure construction unit is connected to the database interaction unit, and the topology structure construction unit is used to generate a logical roadway geometry model according to the roadway parameters and the result of the simulation calculation that meets the coal mine roadway specification, and construct a topology structure of the roadway according to the roadway geometry model; A real-time synchronous automatic updating unit is connected to the topological structure building unit, and is used to obtain the CAD lane map of the platform, integrate the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously update the CAD lane map to the database in real-time to update the lane information and the corresponding lane map in the real-time synchronous automatic updating system.

[0013] Optionally, the graphical user interface input unit is specifically used to build a development environment for AutoCAD and .NET; perform format and logic verification on the lane parameters input by the user; and input the verified lane parameters into the graphical user interface.

[0014] Optionally, the simulation calculation unit is connected to the graphical user interface input unit, and the simulation calculation unit is specifically used to establish a tunnel calculation model according to the input tunnel parameters; use a programming language to write a calculation script or call an external calculation program, and perform simulation calculations on the tunnel through the tunnel calculation model. The simulation calculations include but are not limited to: simulation calculations of stability, ventilation, and drainage.

[0015] Optionally, a topology structure construction unit, the topology structure construction unit is connected to the database interaction unit, and the topology structure construction unit is specifically used to generate a logical roadway geometry model according to the roadway parameters and the results of the simulation calculation that meet the coal mine roadway specifications; Different lane sections are automatically connected according to the logical relationship of the lanes in the lane geometry model to form a connection relationship of the lanes; and a topological structure of the lanes is constructed according to the connection relationship of the lanes.

[0016] Optionally, the real-time synchronous automatic update unit is connected to the topological structure construction unit, and the real-time synchronous automatic update unit is specifically used to obtain the CAD lane map of the platform, integrate the lane information and the topological structure data into the CAD lane map; digitize the CAD lane map to obtain digitized lane graphic data; and automatically and synchronously update the digitized lane graphic data to the database in real-time to update the lane information and the corresponding lane map in the real-time synchronous automatic update system.

[0017] Optionally, the automatic update system further includes: A lane diagram graphic display unit, the lane diagram graphic display unit is connected to the real-time synchronous automatic updating unit, and is used to display the CAD lane diagram in the database.

[0018] The present application provides a method and system for real-time synchronous automatic update of tunnel information. The method uses AutoCAD as a platform and combines the .NET development environment to design a graphical user interface to facilitate users to input tunnel parameters. According to the input tunnel parameters, the system establishes a tunnel calculation model for simulation calculation, and judges the rationality of the parameters according to the coal mine tunnel specifications, and adjusts the parameters through a feedback mechanism until the specifications are met. The method also designs a special database structure for storing tunnel parameters and compliance simulation calculation results. Through the interaction between the platform and the database, the system can automatically update the tunnel information to ensure the real-time and accuracy of the data. Further, according to the tunnel parameters and simulation results, the method generates a logical tunnel geometry model and constructs the topological structure of the tunnel. Finally, the tunnel information and topological structure data are integrated into the CAD tunnel diagram, and updated to the database in real-time synchronization, thereby updating the corresponding tunnel diagram in the tunnel information real-time synchronization automatic update system. The method solves the technical problem that the tunnel drawing data cannot be recognized and used by the management system in real time and automatically, resulting in low work efficiency of business personnel, thereby realizing seamless connection and real-time sharing of coal mine design drawing data and management system data. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings constituting a part of the present application are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings: Figure 1 A schematic diagram of the process of the method for real-time synchronization and automatic updating of lane information provided in this application; Figure 2 Schematic diagram of the real-time synchronous automatic update system of lane information provided in this application.

[0020] The above drawings have shown clear embodiments of the present application, which will be described in more detail later. These drawings and text descriptions are not intended to limit the scope of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION

[0021] In order to make the purpose, technical solutions and advantages of this application clearer, the technical solutions in this application will be clearly and completely described below in conjunction with the drawings in this application. Obviously, the described embodiments are part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0022] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the terms used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in sequences other than those illustrated or described herein.

[0023] In the present invention, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in this application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0024] The method and system for real-time synchronous automatic update of tunnel information provided in this application uses AutoCAD as the platform and combines .NET to develop a graphical interface to input tunnel parameters. By establishing a tunnel calculation model for simulation calculation, the rationality of the parameters is judged according to the coal mine specifications and feedback is adjusted. The database is designed to store compliance parameters and simulation results to achieve automatic update of AutoCAD and database interaction. Further generate a logical tunnel geometry model, construct a topological structure, integrate it into the AutoCAD drawing, and synchronize and update it to the database in real time, so as to achieve fast, accurate and real-time synchronous update of tunnel information.

[0025] The technical solution of the present application and how the technical solution of the present application solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below in conjunction with the accompanying drawings.

[0026] Figure 1 A flow chart of a method for real-time synchronization and automatic updating of lane information provided in this application is shown in FIG. Figure 1 As shown, the method for real-time synchronous automatic updating of lane information provided in this embodiment includes: S101: Using AutoCAD as a platform, designing a graphical user interface using a .NET development environment on the platform, and inputting lane parameters into the graphical user interface.

[0027] Among them, this step specifically includes: Build the development environment for AutoCAD and .NET; Performing format and logic verification on the lane parameters input by the user; The verified lane parameters are input into the graphical user interface.

[0028] The following is the detailed execution process of step S101: 1. Build the development environment for AutoCAD and .NET Environment configuration: Make sure that the AutoCAD software and .NET Framework are installed on your computer. In a .NET development environment such as VisualStudio, create a new C# or VB.NET project and add a reference to the AutoCAD API.

[0029] Project creation: Use the design tools in Visual Studio to design a graphical user interface (GUI). The interface should contain necessary text boxes, drop-down menus, buttons and other controls to allow users to enter tunnel parameters (such as tunnel width, height, length, support type, etc.).

[0030] 2. Format and logic verification of lane parameters input by users Format validation: For each lane parameter entered by the user, format validation is first performed. Make sure that the numeric parameter is a valid number and conforms to the expected unit; for enumeration parameters, make sure that the input value is in the predefined enumeration list.

[0031] Logical verification: After the format verification is passed, check whether the tunnel parameters meet the requirements of the coal mine tunnel specifications, such as whether the tunnel width and height are within the specified range, and whether the support type matches the geological conditions of the tunnel.

[0032] Error handling: If format or logic validation fails, display an error message to the user and allow re-entry.

[0033] 3. Input the verified lane parameters into the graphical user interface Parameter storage: Store the verified lane parameters in variables or data structures in memory.

[0034] Interface update: According to the lane parameters input by the user, the corresponding controls in the GUI are updated to confirm whether the input parameters are correct.

[0035] Data preparation: Prepare data for subsequent calculation model establishment and simulation calculation, including converting the roadway parameters into the format required by the calculation model and storing them in the appropriate data structure.

[0036] Through the above steps, the graphical user interface was successfully designed on the AutoCAD platform using the .NET development environment, and the format and logic of the tunnel parameters input by the user were verified, providing an accurate data basis for the subsequent tunnel calculation model establishment and simulation calculation.

[0037] S102: Based on the input tunnel parameters, a tunnel calculation model is established to perform simulation calculations, and the rationality of the tunnel parameters is judged according to coal mine tunnel specifications and the results of the simulation calculations. Based on the rationality judgment results, feedback is provided to adjust the tunnel parameters until the coal mine tunnel specifications are met.

[0038] Wherein, establishing a tunnel calculation model for simulation calculation according to the input tunnel parameters specifically includes: Establishing a tunnel calculation model according to the input tunnel parameters; A calculation script is written in a programming language or an external calculation program is called to perform simulation calculations on the tunnel through the tunnel calculation model. The simulation calculations include but are not limited to: simulation calculations of stability, ventilation, and drainage.

[0039] The following is the detailed execution process of step S102: 1. Overview of Step S102 In step S102, we establish a tunnel calculation model based on the input tunnel parameters and perform simulation calculations. The results of the simulation calculations will be used to determine the rationality of the tunnel parameters, and the tunnel parameters will be adjusted based on the judgment results until they meet the coal mine tunnel specifications.

[0040] 2. Establish the tunnel calculation model based on the input tunnel parameters Parameter parsing: First, the tunnel parameters input by the user are read from the graphical user interface (GUI), which include but are not limited to the tunnel width, height, length, support type, geological conditions, etc.

[0041] Model construction: Based on the read tunnel parameters, the tunnel calculation model is constructed using AutoCAD API and .NET development environment. The model should be able to reflect the geometric characteristics, support structure and geological conditions of the tunnel.

[0042] 3. Use programming language to write calculation scripts or call external calculation programs for simulation calculations Calculation script writing: In the .NET environment, use C# or VB.NET and other programming languages ​​to write calculation scripts. The script will use the tunnel calculation model to simulate the tunnel stability, ventilation, drainage and other aspects.

[0043] Stability simulation calculation: The stability of the tunnel is simulated using recognized geotechnical mechanics algorithms such as the Moore-Coulomb criterion or the Drucker-Prager criterion. These algorithms take into account the strength characteristics and stress state of the rock mass and can evaluate the stability of the tunnel under specific support conditions.

[0044] Ventilation simulation calculation: Using the basic principles of fluid mechanics, such as the mass conservation equation, momentum conservation equation, and energy conservation equation, the ventilation conditions of the tunnel are simulated and calculated. The ventilation effect of the tunnel is evaluated by calculating the tunnel's ventilation resistance, air volume distribution and other parameters.

[0045] Drainage simulation calculation: Based on the seepage theory of fluid mechanics, the drainage situation of the tunnel is simulated and calculated. The drainage capacity of the tunnel is evaluated by calculating the seepage velocity, seepage volume and other parameters of the tunnel.

[0046] Calling external calculation programs: If the internal calculation script cannot meet the needs of simulation calculation, you can call external professional calculation programs, such as FLAC3D, ANSYS and other geotechnical engineering and fluid mechanics simulation software. These software provide a rich algorithm and model library, which can more accurately simulate the stability and fluid behavior of the tunnel.

[0047] 4. Judgment of simulation results and adjustment of tunnel parameters Result judgment: According to the simulation calculation results and the coal mine roadway specifications, the rationality of the roadway parameters is judged. If there are problems with the stability, ventilation, drainage, etc. of the roadway, the parameters need to be adjusted.

[0048] Parameter adjustment: According to the judgment results, feedback is given to adjust the tunnel parameters, such as increasing the support strength, adjusting the tunnel size, optimizing the ventilation layout, etc. The adjusted parameters will be re-entered into the tunnel calculation model for a new round of simulation calculation until the coal mine tunnel specifications are met.

[0049] Through the above steps, we successfully established the tunnel calculation model and carried out simulation calculations on stability, ventilation, drainage, etc. According to the simulation calculation results and coal mine tunnel specifications, the tunnel parameters were reasonably adjusted, providing a scientific basis for subsequent design work.

[0050] S103: Design a database structure to store the tunnel parameters and the results of the simulation calculation that meet the coal mine tunnel specifications, and automatically update the tunnel information in the database through the interaction between the platform and the database.

[0051] The tunnel information is used to indicate the tunnel parameters and the results of the simulation calculation that meet the coal mine tunnel specifications.

[0052] The following is the detailed execution process of step S103: 1. Overview of Step S103 In step S103, our main task is to design a database structure to store tunnel parameters and simulation calculation results that meet coal mine tunnel specifications. At the same time, we need to realize the interaction between AutoCAD and the database so as to automatically update the tunnel information in the database.

[0053] 2. Design the database structure Determine the data table: Tunnel parameter table: used to store tunnel parameters entered by the user, such as tunnel width, height, length, support type, geological conditions, etc.

[0054] Simulation calculation result table: used to store the results of simulation calculation, such as the stability coefficient, ventilation resistance, drainage capacity, etc. of the tunnel.

[0055] Roadway information table: used to store integrated roadway information, including roadway parameters and simulation calculation results that meet coal mine roadway specifications.

[0056] Define fields and data types: In the tunnel parameter table, define fields such as tunnel ID (primary key, uniquely identifying each tunnel), width (floating point number), height (floating point number), length (floating point number), support type (string), geological conditions (string), etc.

[0057] In the simulation calculation result table, define fields such as tunnel ID (foreign key, associated with the tunnel parameter table), stability coefficient (floating point number), ventilation resistance (floating point number), drainage capacity (floating point number), etc.

[0058] In the lane information table, define fields such as lane ID (primary key, associated with the lane parameter table and simulation calculation result table), integration parameters (string, storing integrated lane parameter information), integration results (string, storing integrated simulation calculation result information), etc.

[0059] Establish relationship: Through the lane ID field, a foreign key relationship is established between the lane parameter table and the simulation calculation result table to ensure the data integrity and consistency of each lane.

[0060] Integrate the data in the tunnel parameter table and simulation calculation result table into the tunnel information table for subsequent use.

[0061] 3. Realize the interaction between AutoCAD and database Database connection: Use database access technologies provided by the .NET framework, such as ADO.NET or Entity Framework, to establish a connection with the database.

[0062] Configure the database connection string to ensure that you can connect to the database correctly.

[0063] Data reading and writing: In AutoCAD, write code through .NET API to read the lane parameters entered by the user and write them into the lane parameter table.

[0064] Call the simulation calculation program and write the calculation results into the simulation calculation result table.

[0065] After integrating the data in the tunnel parameter table and the simulation calculation result table, write them into the tunnel information table.

[0066] Automatic update mechanism: Write triggers or stored procedures to automatically update the data in the lane information table when the data in the lane parameter table or simulation calculation result table changes.

[0067] Use AutoCAD's API to monitor changes in the database and update the information in the CAD roadway diagram in real time.

[0068] The updated CAD lane map is synchronized to the database in real time so that the corresponding lane map can be updated in the lane information real-time synchronization automatic update system.

[0069] Through the above steps, we successfully designed a database structure to store tunnel parameters and simulation calculation results that meet coal mine tunnel specifications. At the same time, we realized the interaction between AutoCAD and the database, which can automatically update the tunnel information in the database. This provides strong data support for subsequent tunnel design and management work.

[0070] S104: Generate a logical tunnel geometry model based on the tunnel parameters and the results of the simulation calculation that meet the coal mine tunnel specifications, and construct a tunnel topology structure based on the tunnel geometry model.

[0071] This step specifically includes: Generate a logical roadway geometry model according to the roadway parameters and the simulation calculation results that meet the coal mine roadway specifications; Automatically connecting different lane segments according to the logical relationship of the lanes of the lane geometry model to form a connection relationship of the lanes; The topological structure of the lanes is constructed based on the connection relationship of the lanes.

[0072] The following is the detailed execution process of step S104: 1. Overview of Step S104 In step S104, our core task is to generate a logical roadway geometry model based on the input roadway parameters and simulation calculation results (these results must meet the coal mine roadway specifications). Further, based on this geometry model, we will automatically connect different roadway segments to form a roadway connection relationship and finally construct the roadway topology.

[0073] 2. Generate a logical tunnel geometry model Data preparation: Extract verified tunnel parameters and simulation calculation results from the database.

[0074] Ensure that these data meet all requirements of coal mine tunnel specifications.

[0075] Geometric model construction: Using AutoCAD API and .NET development environment, generate preliminary lane geometry based on lane parameters (such as width, height, length, etc.).

[0076] According to the simulation calculation results (such as stability analysis, ventilation resistance, etc.), necessary adjustments are made to the tunnel geometry to ensure that it conforms to both physical laws and engineering requirements.

[0077] Logical verification: Verify whether the generated tunnel geometry model is logical, such as checking whether the tunnel dimensions are consistent, whether the support structure is reasonable, etc.

[0078] If any logical errors are found, return to the data preparation stage for correction.

[0079] 3. Automatically connect different lane segments to form a lane connection relationship Connection rule formulation: According to the conventional logic of tunnel design and coal mine tunnel specifications, the connection rules of tunnel sections are formulated.

[0080] These rules may include the intersection angles of tunnels, connection methods (such as right-angle connection, bevel connection, etc.), continuity of support structures, etc.

[0081] Automatic connection algorithm: Use relevant algorithms in graph theory (such as depth-first search DFS, breadth-first search BFS, etc.) to automatically connect different lane segments.

[0082] Ensure that each tunnel segment is correctly connected with other tunnel segments according to the predetermined connection rules.

[0083] Connection relationship verification: Verify whether the tunnel segments after automatic connection have formed the correct connection relationship.

[0084] Check whether the connection points are smooth, whether the supporting structure is continuous, etc.

[0085] 4. Constructing the topological structure of the lane Topological structure definition: The topological structure of a laneway refers to the connection relationship and relative position between laneway segments in the laneway network.

[0086] It can be represented by a graph data structure, where nodes represent lane segments or connection points and edges represent the connection relationships between lane segments.

[0087] Topology construction: Construct the topology structure of the lane according to the automatically connected lane segments and connection relationships.

[0088] Use graph data structures (such as adjacency lists, adjacency matrices, etc.) to store and represent topological structures.

[0089] Topology verification and optimization: Verify whether the constructed topology meets the requirements of coal mine tunnel specifications.

[0090] The topological structure is optimized as needed to improve the traffic efficiency and ventilation effect of the alley.

[0091] Through the above steps, we have successfully generated a logical tunnel geometry model and built the tunnel topology based on this model. These achievements provide a solid foundation for the subsequent integration of tunnel information and topology data into CAD tunnel drawings. At the same time, they also provide strong support for tunnel design, construction and management.

[0092] S105: Acquire the CAD lane map of the platform, integrate the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously update the CAD lane map to the database in real time to update the lane information and automatically update the corresponding lane map in the system.

[0093] This step specifically includes: Acquire a CAD lane map of the platform, and integrate the lane information and the data of the topological structure into the CAD lane map; Digitally processing the CAD lane map to obtain digital lane graphic data; The digitalized lane graphic data is automatically and synchronously updated in real time to the database to update the lane information and the corresponding lane map in the system is automatically and synchronously updated in real time.

[0094] The following is the detailed execution process of step S105: 1. Overview of Step S105 In step S105, our main task is to integrate the lane information and topological structure data into the CAD lane map, and ensure that the CAD lane map can be automatically updated to the database in real time, so as to update the lane information and automatically update the corresponding lane map in the system in real time. This step is the key link of the entire system process, which ensures the integrity and consistency of the data.

[0095] 2. Integrate the lane information and topological structure data into the CAD lane diagram Data preparation: Extract verified tunnel parameters, simulation calculation results, and topological structure data from the database.

[0096] Ensure the accuracy and completeness of this data.

[0097] AutoCAD graphical interface operation: Use AutoCAD's API and .NET development environment to create lane diagrams in the AutoCAD graphical interface.

[0098] Based on the tunnel parameters and topological structure data, elements such as tunnel sections, connection points, and support structures are drawn in the tunnel diagram.

[0099] Ensure that the drawing of the tunnel map complies with the requirements of coal mine tunnel specifications.

[0100] Data integration: Attach lane parameter and topology data as attribute information to the corresponding elements in the CAD lane diagram.

[0101] In this way, each tunnel segment, connection point and other elements contain the corresponding tunnel parameters and topological structure information.

[0102] 3. Digitalize the CAD laneway diagram to obtain digital laneway graphic data Digital processing: Use the graphics export function provided by AutoCAD to export the roadway diagram into common digital graphics formats (such as DWG, DXF, etc.).

[0103] These digital graphic formats contain all the geometric and attribute information of the roadway diagram.

[0104] Data verification: Verify the exported digital roadway graphic data to ensure the integrity and accuracy of the data.

[0105] If data errors or missing are found, return to the AutoCAD graphics interface to make corrections.

[0106] 4. Automatically update the digital roadway graphics data to the database in real time to update the roadway information. Automatically update the corresponding roadway graphics in the system in real time. Database connection: Use database access technologies provided by the .NET framework, such as ADO.NET or Entity Framework, to establish a connection with the database.

[0107] Ensure the stability and reliability of database connections.

[0108] Data update: Store the digitized roadway graphic data in the database as a binary large object (BLOB) or other appropriate data type.

[0109] At the same time, the metadata table related to the lane map in the database is updated to record the latest version of the lane map and update time and other information.

[0110] Real-time synchronization: Use triggers, stored procedures, or application logic to ensure that digitalized laneway graphics data can be synchronized to the laneway information real-time synchronization automatic update system in real time.

[0111] When the tunnel map data in the database changes, the update operation is automatically triggered to synchronize the latest tunnel map to the system.

[0112] System verification: Verify whether the updated lane map is displayed correctly in the lane information real-time synchronization automatic update system.

[0113] Ensure that other functions of the system (such as query, analysis, reporting, etc.) can use the updated lane map data normally.

[0114] Through the above steps, we have successfully integrated the data of the tunnel information and topological structure into the CAD tunnel diagram, and realized the digital processing of the CAD tunnel diagram and the real-time synchronization and automatic update to the database. The completion of this step ensures the integrity and consistency of the tunnel data, and provides strong support for the subsequent tunnel design, construction and management. At the same time, it also improves the automation level of the system and the user experience.

[0115] The method for real-time synchronization and automatic updating of tunnel information provided in this embodiment uses AutoCAD as a platform and makes full use of the advantages of the .NET development environment to realize a series of functions such as input of tunnel parameters, simulation calculation, rationality judgment and parameter adjustment, database storage and update, tunnel geometry model and topological structure construction, and integration and real-time synchronization update of tunnel diagrams. The method simplifies the input process of tunnel parameters through a graphical user interface, ensures the rationality of tunnel parameters by using advanced simulation calculation technology, and realizes the automatic management of tunnel information through the interaction between the database and AutoCAD. When constructing the tunnel geometry model and topological structure, the method can accurately reflect the connection relationship and relative position between tunnels, providing a reliable basis for tunnel design. At the same time, by digitizing the tunnel diagram and synchronizing it in real time to the database, the method ensures the real-time and accuracy of tunnel information, providing strong support for tunnel construction and management. In general, the method for real-time synchronization and automatic updating of tunnel information provided in this embodiment not only improves the efficiency and accuracy of tunnel design, but also realizes the automatic management and real-time update of tunnel information, providing a new solution for the design, construction and management of coal mine tunnels. This method successfully solved the technical problem that the tunnel drawing data could not be recognized and utilized by the management system in real time and automatically, resulting in low work efficiency of business personnel, thereby achieving seamless connection and real-time sharing of coal mine design drawing data and management system data.

[0116] Figure 2 The schematic diagram of the lane information real-time synchronization automatic update system provided in this application is a detailed description of the lane information real-time synchronization automatic update system, such as Figure 2 As shown, the lane information real-time synchronization automatic update system provided in this embodiment is applied to Figure 1 The automatic updating method described in the embodiment, the automatic updating system comprises: A graphical user interface input unit is used to design a graphical user interface using AutoCAD as a platform and a .NET development environment on the platform, and input lane parameters on the graphical user interface; A simulation calculation unit, the simulation calculation unit is connected to the graphical user interface input unit, the simulation calculation unit is used to establish a tunnel calculation model for simulation calculation according to the input tunnel parameters, judge the rationality of the tunnel parameters according to the coal mine tunnel specifications and the results of the simulation calculation, and according to the judgment result of the rationality, feedback and adjust the tunnel parameters until the coal mine tunnel specifications are met; A database interaction unit, the database interaction unit is connected to the simulation calculation unit, the database interaction unit is used to design a database structure to store the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications, and automatically update the tunnel information in the database through the interaction between the platform and the database, wherein the tunnel information is used to indicate the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications; A topology structure construction unit, the topology structure construction unit is connected to the database interaction unit, and the topology structure construction unit is used to generate a logical roadway geometry model according to the roadway parameters and the result of the simulation calculation that meets the coal mine roadway specification, and construct a topology structure of the roadway according to the roadway geometry model; A real-time synchronous automatic updating unit is connected to the topological structure building unit, and is used to obtain the CAD lane map of the platform, integrate the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously update the CAD lane map to the database in real-time to update the lane information and the corresponding lane map in the real-time synchronous automatic updating system.

[0117] Optionally, the graphical user interface input unit is specifically used to build a development environment for AutoCAD and .NET; perform format and logic verification on the lane parameters input by the user; and input the verified lane parameters into the graphical user interface.

[0118] Optionally, the simulation calculation unit is connected to the graphical user interface input unit, and the simulation calculation unit is specifically used to establish a tunnel calculation model according to the input tunnel parameters; use a programming language to write a calculation script or call an external calculation program, and perform simulation calculations on the tunnel through the tunnel calculation model. The simulation calculations include but are not limited to: simulation calculations of stability, ventilation, and drainage.

[0119] Optionally, a topology structure construction unit, the topology structure construction unit is connected to the database interaction unit, and the topology structure construction unit is specifically used to generate a logical roadway geometry model according to the roadway parameters and the results of the simulation calculation that meet the coal mine roadway specifications; Different lane sections are automatically connected according to the logical relationship of the lanes in the lane geometry model to form a connection relationship of the lanes; and a topological structure of the lanes is constructed according to the connection relationship of the lanes.

[0120] Optionally, the real-time synchronous automatic update unit is connected to the topological structure construction unit, and the real-time synchronous automatic update unit is specifically used to obtain the CAD lane map of the platform, integrate the lane information and the topological structure data into the CAD lane map; digitize the CAD lane map to obtain digitized lane graphic data; and automatically and synchronously update the digitized lane graphic data to the database in real-time to update the lane information and the corresponding lane map in the real-time synchronous automatic update system.

[0121] Preferably, the automatic updating system further comprises: A lane diagram graphic display unit, the lane diagram graphic display unit is connected to the real-time synchronous automatic updating unit, and is used to display the CAD lane diagram in the database.

[0122] The following is a detailed description of the components of the system and how they are connected.

[0123] This embodiment provides a system for real-time synchronous automatic update of lane information. Figure 1 The automatic update method described in the embodiment is constructed to realize the functions of lane parameter input, simulation calculation, rationality judgment, database storage and update, topology structure construction, and lane map integration and real-time synchronous update. The following is a detailed description of each component of the system: 1. Graphical User Interface Input Unit This unit uses AutoCAD as the platform and .NET development environment to design the graphical user interface. Users can easily input tunnel parameters such as tunnel width, height, length, support structure type, etc. These input parameters will serve as the basis for subsequent simulation calculations.

[0124] 2. Analog computing unit The simulation calculation unit is connected to the graphical user interface input unit to receive the tunnel parameters input by the user. The unit establishes a tunnel calculation model based on these parameters, performs simulation calculations, and judges the rationality of the tunnel parameters based on the coal mine tunnel specifications and the results of the simulation calculations. If the parameters are unreasonable, they will be fed back to the user for adjustment until they meet the specifications.

[0125] 3. Database Interaction Unit The database interaction unit is connected to the simulation calculation unit and is responsible for designing the database structure to store the lane parameters and the simulation calculation results. The unit also realizes the automatic update of the lane information through the interaction between the platform and the database. The lane information includes the lane parameters and their corresponding simulation calculation results, which will be used for the subsequent generation and update of the lane map.

[0126] 4. Topological Structure Building Unit The topology construction unit is connected with the database interaction unit, and generates a logical lane geometry model according to the stored lane parameters and simulation calculation results. Then, the topology structure of the lane is constructed based on the geometry model, including the connection relationship and relative position between lane segments.

[0127] 5. Real-time synchronization automatic update unit The real-time synchronization automatic update unit is connected to the topology structure construction unit and is responsible for integrating the lane information and topology data into the CAD lane diagram. The unit also realizes the real-time synchronization automatic update function of the CAD lane diagram, that is, the updated lane diagram is synchronized to the database in real time to update the lane information and the corresponding lane diagram in the real-time synchronization automatic update system.

[0128] 6. Laneway map graphic display unit (preferred) The tunnel diagram graphic display unit is connected to the real-time synchronous automatic update unit to display the CAD tunnel diagram stored in the database. Users can intuitively view the tunnel diagram and its update status through this unit, which facilitates tunnel design, construction and management.

[0129] The connection between the units is mainly realized through data interface and communication protocol. For example, the graphical user interface input unit transmits the tunnel parameters to the simulation calculation unit through the data interface; the simulation calculation unit transmits the calculation results to the database interaction unit through the communication protocol; the database interaction unit interacts with the database through the data interface; the topology structure construction unit reads the tunnel parameters and simulation calculation results from the database to generate the tunnel geometry model and topology structure; the real-time synchronization automatic update unit obtains data from the topology structure construction unit to generate and update the CAD tunnel diagram; the tunnel diagram graphic display unit obtains the updated tunnel diagram from the real-time synchronization automatic update unit for display.

[0130] The real-time synchronous automatic updating system of tunnel information provided in this embodiment realizes the real-time updating and automatic management of tunnel information through the collaborative work among various units, and provides strong support for the design, construction and management of coal mine tunnels.

[0131] Those skilled in the art will appreciate that all or some of the steps in the methods disclosed above, and the functional modules / units in the systems and devices may be implemented as software, firmware, hardware, or a suitable combination thereof.

[0132] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary techniques in the art that are not disclosed in the present application. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present application are indicated by the following claims.

[0133] It should be understood that the present application is not limited to the precise structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present application is limited only by the appended claims.

Claims

1. A method for real-time synchronous automatic updating of lane information, characterized in that: The method comprises: Using AutoCAD as a platform, designing a graphical user interface using a .NET development environment on the platform, and inputting lane parameters into the graphical user interface; According to the input tunnel parameters, a tunnel calculation model is established to perform simulation calculation, the rationality of the tunnel parameters is judged according to the coal mine tunnel specifications and the results of the simulation calculation, and according to the rationality judgment results, the tunnel parameters are adjusted by feedback until the coal mine tunnel specifications are met; Designing a database structure to store the laneway parameters and the results of the simulation calculation that meet the coal mine laneway specifications, and automatically updating the laneway information in the database through the interaction between the platform and the database, wherein the laneway information is used to indicate the laneway parameters and the results of the simulation calculation that meet the coal mine laneway specifications; Generate a logical roadway geometry model according to the roadway parameters and the results of the simulation calculation that meet the coal mine roadway specifications, and construct a roadway topology structure according to the roadway geometry model; The CAD lane map of the platform is obtained, the lane information and the data of the topological structure are integrated into the CAD lane map, and the CAD lane map is automatically and synchronously updated in real time to the database to update the lane information and the corresponding lane map in the real-time synchronously and automatically updating system.

2. The method according to claim 1, characterized in that The method uses AutoCAD as a platform, designs a graphical user interface using a .NET development environment on the platform, and inputs lane parameters in the graphical user interface, including: Build the development environment for AutoCAD and .NET; Performing format and logic verification on the lane parameters input by the user; The verified lane parameters are input into the graphical user interface.

3. The method according to claim 2, characterized in that The step of establishing a tunnel calculation model and performing simulation calculation based on the input tunnel parameters includes: Establishing a tunnel calculation model according to the input tunnel parameters; A calculation script is written in a programming language or an external calculation program is called to perform simulation calculations on the tunnel through the tunnel calculation model. The simulation calculations include but are not limited to: simulation calculations of stability, ventilation, and drainage.

4. The method according to claim 1, characterized in that: The step of generating a logical roadway geometry model according to the roadway parameters and the result of the simulation calculation that meets the coal mine roadway specification, and constructing a roadway topology structure according to the roadway geometry model includes: Generate a logical roadway geometry model according to the roadway parameters and the simulation calculation results that meet the coal mine roadway specifications; Automatically connecting different lane segments according to the logical relationship of the lanes of the lane geometry model to form a connection relationship of the lanes; The topological structure of the lanes is constructed based on the connection relationship of the lanes.

5. The method according to claim 1, characterized in that The step of obtaining the CAD lane map of the platform, integrating the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously updating the CAD lane map to a database in real time to update the lane information and automatically and synchronously updating the corresponding lane map in the system in real time includes: Acquire a CAD lane map of the platform, and integrate the lane information and the data of the topological structure into the CAD lane map; Digitally processing the CAD lane map to obtain digital lane graphic data; The digitalized lane graphic data is automatically and synchronously updated in real time to the database to update the lane information and the corresponding lane diagram in the system is automatically and synchronously updated in real time.

6. A real-time synchronous automatic update system for lane information, characterized in that: The automatic updating system is applied to the automatic updating method according to any one of claims 1 to 5, and the automatic updating system comprises: A graphical user interface input unit is used to design a graphical user interface using AutoCAD as a platform and a .NET development environment on the platform, and input lane parameters on the graphical user interface; A simulation calculation unit, the simulation calculation unit is connected to the graphical user interface input unit, the simulation calculation unit is used to establish a tunnel calculation model for simulation calculation according to the input tunnel parameters, judge the rationality of the tunnel parameters according to the coal mine tunnel specifications and the results of the simulation calculation, and according to the judgment result of the rationality, feedback and adjust the tunnel parameters until the coal mine tunnel specifications are met; A database interaction unit, the database interaction unit is connected to the simulation calculation unit, the database interaction unit is used to design a database structure to store the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications, and automatically update the tunnel information in the database through the interaction between the platform and the database, wherein the tunnel information is used to indicate the tunnel parameters and the simulation calculation results that meet the coal mine tunnel specifications; A topology structure construction unit, the topology structure construction unit is connected to the database interaction unit, and the topology structure construction unit is used to generate a logical roadway geometry model according to the roadway parameters and the result of the simulation calculation that meets the coal mine roadway specification, and construct a topology structure of the roadway according to the roadway geometry model; A real-time synchronous automatic updating unit is connected to the topological structure building unit, and is used to obtain the CAD lane map of the platform, integrate the lane information and the data of the topological structure into the CAD lane map, and automatically and synchronously update the CAD lane map to the database in real-time to update the lane information and the corresponding lane map in the real-time synchronous automatic updating system.

7. The system according to claim 6, characterized in that The automatic updating system further comprises: A lane diagram graphic display unit, the lane diagram graphic display unit is connected to the real-time synchronous automatic updating unit, and is used to display the CAD lane diagram in the database.

Images