The Development And Application Of Mine Ventilation Network Graph Automatic Drawing System Based On VBA

First of all, through analyzing the domestic and foreign research progress of mine ventilation network graph automatic drawing, and the four generations of AutoCAD secondary development, selecting VBA technology based on the ActiveX Automation as the AutoCAD secondary development method, And then after researching on the basic graph feature of the mine ventilation network, the storage method of network topological structure, the relative knowledge and some algorithm about graph theory, adopting the expanding node adjacency matrix to store the ventilation network topological information, and the depth-first algorithm to search the network passage.Through analyzing the relation and difference between the mine ventilation network graph automatic drawing and manual drawing, summarizing the procedure of the ventilation network graph automatic drawing, dividing this system into five function modules hereby:collecting the network structure information, generating the network passage, drawing the network graph, query and help. Then realizing the whole system development by the advanced visual program language VB (VBA) and the ADO database access technology to connect the background database Microsoft Office Access. Last running the system by the data material of the TianYe coal mine, found its operation convenient and brief, its result accurate and reliable.