CAD在工程实践中的二次开发

摘要为了解决困扰工程地质界的隧道地质编录绘图难题，探索实现隧洞设计及施工地质展示图绘图自动化和计算机化的可能途径，本文以田坝岭隧道施工地质为范例，说明铁路隧道地质编录自动成图系统概念和实施要点，通过对AutoCAD平台的二次开发最终实现自动成图的目的。通过本设计过程，使学生掌握计算机辅助设计的基本技能，并具备AutoCAD二次开发的初步技能，提高其应用计算机解决实际问题的能力水平，预期达到以下要求：熟练掌握AutoCAD平台Axtivex开发技术；初步具备利用关系型数据库管理工程数据的能力。本设计可以实现加入窗体模块编程，每确认一个窗体模块即可实现一项模块功能。使工作量由软件从已编写的数据库文件中提取数据自动生成图形。用铁路隧道地质编录自动成图系统绘制隧道展示图比手工快几十倍甚至更多。关键词：地质展示图数据库二次开发AbstractInordertosolvethetroubleDeZhiJietunnelengineeringgeologicalrecorddrawingproblem,exploreandrealizetunnelinthedesignandconstructionofgeologicaldisplayfiguredrawingautomationandcomputerizedpossibleapproach,basedonthetunnelconstructiongeologicalfielddamasanexample,explainrailwaytunnelgeologicalrecordtobeautomaticmappingsystemconceptandthekeypoints,realizedthroughtotheseconddevelopmentAutoCADplatformeventuallyrealizethepurposeofautomaticmapping.Throughthedesignprocess,makethestudentsmasterthebasicskillsofcomputeraideddesign,andwithAutoCADsecondarydevelopmentpreliminaryskills,improveitsapplicationcomputersolutionactualproblemabilitylevel,expectedtoreachthefollowingrequirements:masterAutoCADplatformdevelopmenttechnologyAxtivex;Initiallyhaveuseofrelationaldatabasemanagementengineeringdataability.Thisdesigncanrealizetojoinformmoduleprogramming,eachconfirmedaformmodulecanberealizedamodulefunction.Makeworkfromalreadywrittenbysoftwaredatabasefileextractdataautomaticallygenerategraphics.Userailwaytunnelgeologicalrecordtobeautomaticmappingsystemdrawtunnelshowthanafewtimesfastfigurebyevenmore.Keyword：GeologicaldisplayfiguredatabaseSeconddevelopment目录第1章绪论................................................................................11.1开发的意义、背景.........................................................................11.2本设计解决的问题.........................................................................11.3采用的方法和步骤.........................................................................21.3.1方法...................................................................................................21.3.2步骤...................................................................................................21.4预期成果.........................................................................................3第2章数据库结构设计..............................................................42.1数据库中的表.................................................................................42.2数据库中表的关联图.....................................................................7第3章程序结构..........................................................................93.1模块.................................................................................................93.1.1Caidan模块......................................................................................93.1.2Caidanxianshi模块...........................................................................93.1.3CommASS模块.............................................................................103.1.4DZSub模块....................................................................................103.2窗体...............................................................................................103.2.1工程管理窗体.................................................................................103.2.2工程数据管理窗体.........................................................................113.2.3平面数据管理.................................................................................123.2.4岩性表的管理.................................................................................133.2.5编录出图.........................................................................................133.2.6打印.................................................................................................14第4章重点算法........................................................................154.1平面线路方位角的计算...............................................................154.1.1任意里程的方位角计算.................................................................154.1.2线路走向计算.................................................................................16第5章主要应用技术................................................................195.1ADO技术简介..............................................................................195.1.1Connection连接对象.....................................................................195.1.2Recordset对象.................................................................................205.2AUTOCADVBA简介...................................................................235.2.1什么是AutoCADVBA.................................................................235.2.2用VBA管理器组织工程............................................................245.2.3处理宏.............................................................................................255.2.4VBAIDE编辑工程........................................................................26第6章工程实例........................................................................286.1工程名称的录入...........................................................................286.2岩性表设置........................