基于VBA的矿山设备布置图系统开发与应用

Development and application of mining equipment layout system based on VBA

对AutoCAD二次开发工具进行了分析,并通过与GIS解决方案进行对比,提出以VBA为开发工具和CAD二次开发方式来实现矿山设备软件模拟布置、定位功能。解决如何在AutoCAD中基于VBA建立设备图块与远程数据库的关联,并实现如何在AutoCAD内部建立与外部远程数据库的动态响应机制,以及就如何对VBA程序打包进行了说明。通过对煤矿井下设备布置图系统的研发和实际使用,结果表明系统为实现设备可视化管理的思路具有可借鉴性。

This paper analyses the secondary development tools of AutoCAD and gives a detail compar- ison with GIS solutions. Then the paper gived a solution to implement the mining equipment layout and location functions, which is by the way of AutoCAD secondary development and the develop tool is VBA. The problems that how to set up the connection between equipment block and remote data- base based on VBA in AutoCAD and how to establish a dynamic response mechanism in AutoCAD and external remote database are solved, In Addition, how to pack VBA program are illustrated. Through the development and apply of the coal mine underground equipment layout system, the idea to achieve the visual management are proved being feasibility. The system has certain applied value in equip- ment position and information management based on AutoCAD.