中文摘要：

工程中大量的实体对象基本都是以AutoCAD图纸的形式表现出来,露天矿开采也不例外,AutoCAD电子版图纸可以灵活、详细地表现和编辑工程实体对象的各项内容,在生产过程中有着无可替代的作用。但AutoCAD的缺点也是明显的：不能对图形中大量数据信息进行处理。如何利用AutoCAD天然的优势在AutoCAD平台上实现生产管理功能,就是要借助Auto CAD链接外部数据库和其他应用程序,利用它们的数据存储、数据查询、数据处理及数据交换的能力,弥补AutoCAD的缺点,使图形具备智能化。利用AutoCAD平台下的数据库链接功能Dbconnect,通过Active X Data Object（ADO）外部数据通信技术和Connectivity Automation Objects（CAO）对象数据库链接技术,结合服务器型数据库SQL的多条件查询、存储数据功能和EXCEL的快捷方便的数据处理能力,编制AutoCAD VBA二次开发程序,实现了某露天矿生产工艺的信息化管理。

英文摘要：

Abundant entity objects in engineering are basically displayed by the AutoCAD＇s drawing,including the openpit mine. AutoCAD electronics drawing can express and edit various contents of engineering entity object vividly and totally.This function can not be substituted in the production process. But the AutoCAD＇s weakness is also obvious： no ability in dealing with a great deal of data information in the drawing. How to make use of Auto CAD＇s natural advantage to carry out production management function in the AutoCAD＇s platform is with aid of AutoCAD linking an external database and other application procedures,and making use of their datum saving,and the ability of the datum search,the datum processing and datum commutation to make up Auto CAD＇s weakness,and make the drawing intelligent. Dbconnect function about databank link in the platform of AutoCAD is used to design Auto CAD VBA ＇s secondary program for achieving informationizing management in some open pit mine＇s mining system by the technology of Active X Data Object（ ADO） and Connectivity Automation Objects（ CAO）,combining with server SQL of multiple-inquiry,datum storage and EXCEL＇s advantageous datum treatment ability.