摘要
金属波纹管膨胀节作为一种新型的系统部件,因具有良好的稳定性及较高的可靠性等特点,使得它在冶金、炼油、石油化工、电力、热网、船舶、宇航等领域有着不可替代的作用。
金属波纹管膨胀节是非标装置。其结构形状和力学性能随温度、压力、位移量、循环寿命的变化而异,因此它的设计、计算、绘图、加工等工作十分繁冗。目前,膨胀节行业急需有一套准确可靠、实用性强的专业辅助设计软件,为此,本课题深入消化吸收了美国膨胀节制造协会(EJMA)标准2003第8版与GBT/12777-2008新标准的设计要求,在参考国内外已有的膨胀节设计计算软件的基础上,进行了全新的、有针对性的设计开发,以适应目前膨胀节行业的急迫需求。
本文详细论述了金属波纹管膨胀节计算机辅助设计系统的设计原理与开发过程。通过对系统的需求分析与功能分析,选择Visual Basic 6.0平台为开发环境,提出了利用动态链接库技术(DLL)建立了独有的膨胀节算法类;深入研究了金属波纹管膨胀节的焊接特点与常用的焊接方法,编写了焊接工艺CAPP智能模块;讨论分析了AutoCAD对象模型与自动绘图的实现方法;同时设计出简洁实用的成本核算模块,并且利用Word API技术实现了双向设计说明文档功能。从而编写完成了具有设计、计算、校核、焊接工艺指导、自动绘图、成本核算、双向设计说明等功能高度集成的金属波纹管膨胀节计算机辅助设计平台。
通过分析每个模块的功能特点,系统基于Microsoft Access 2003数据库软件建立了相应的数据库,并设计了对应数据库中的数据类型与表结构,利用ADO数据库访问技术读取与储存数据库内容,通过采用建立公共数据库访问模块的方法,优化数据处理,使程序结构更加合理,提高运行效率。
本系统经过多家波纹管生产制造企业使用证明,设计功能均达到了预定的开发目标,满足企业生产实际要求,大大节省了设计人员的设计时间、减少了出错概率。同时,为企业制定更合理的工时定额以及改善管理提供了科学依据,实现了波纹管设计制造工艺设计的标准化与最优化。
As a new type of system components, Metal bellows expansion joint played an irreplaceable role in the metallurgy, oil refining, petrochemical engineering, electricity, heating network, ships, aerospace and other fields due to its fine stability and high reliability.
Metal bellows expansion joint is non-standard device. Its structure and mechanical properties will be different by changing the temperature, pressure, displacement and cycle life. As a result, its design, calculation, drawing and processing turned to be very complicated. Recently, expansion joint industry need a set of accurate and reliable, practical and professional aided design software, therefore, this paper probes the expansion joint manufacturers association of the United States (EJMA) Standard 2003 Article 8 and version of the new standards GBT/12777-2008 to make a new and targeted design on the basis of the reference in calculation software bellows at home and abroad to meet the urgent need of this industry.
This paper discusses the design principles and development process of the computer aided system of the metal bellows expansion joint. According to the demand and functional analysis, the author chooses the Visual Basic 6.0 as the development environment, sets up a particular algorithm class of the expansion joint by using the dynamic-link library (DLL), this paper researches the welding features and the active welding methods of the metal bellows expansion joint in depth, compiles the intelligent Computer Aided Process Planning(CAPP) module of welding procedure; analyzes the method of object modeling and automatic mapping of AutoCAD; at the same time, the author designs a convenient and utility module of the cast accounting and realizes a function of the design book as a Two-way by using the Word API interface, then finishes the highly integrated computer aided platform of metal bellows expansion joint, which has design, calculation, calibration, welding technology guidance, automatic mapping, costing, two-way design book and a number of important functions.
According to analyze the features of each module, the system sets up the corresponding databases and designs their data type and list structure based on the Microsoft Access 2003 database software, reads and saves the contents of the database by means of the ADO database access technology, optimizes the date processing, makes the program structure more properly and increases the program operating efficiently through setting up a public module of database accessing.
The design functions of this system are proved to reach the prospective developing goals and meet the practical requirements of enterprise production through many metal bellows expansion joint-made enterprises, it saves designers design time, reduces the probability of error. Meanwhile, it provides a scientific evidence to develop a more reasonable man-hour quota and improves the management, realizes the standardization and the optimization of the design development of the metal bellows expansion joint.
引文
[1]马伟,李德雨,钟玉平.波纹管的发展与应用[J].河南科技大学学报:自然科学版,2004,25(04):28-29.
[2]刘俞铭.波纹管设计计算与生产新工艺新技术实务全书[M].北京:北方工业出版社,2006.1:4-6.
[3]李永生,李建国.波形膨胀节实用技术—设计、制造与应用[M].北京:化学工业出版社,2000.9:131-135.
[4]衰泽虎,戴锦养等.计算机辅助设计与制造[M].北京:中国水利水电出版社,2004:132-136.
[5]邓辉.走出行业应用软件发展之路[J].电信工程技术与标准化,2000,(01):18-20.
[6]EJMA.Standards of the Expansion joints Manufacturers Association(EJMA)INC[S],2003.
[7]中华人民共和国国家标准.GB/T12777-2008金属波纹管膨胀节通用技术条件[S].北京:中国标准出版社.
[8]Verroust A.,Schonek F.rule-oriented method for parameterized computer-aided Design [J].Computer-Aided Design,1992,24(10):377-382.
[9]刘颖,徐鸿,高海涛,寿比南.有限元法在膨胀节设计计算中的应用[J].压力容器,2001,(02):151-155.
[10]Roller D.An approach to computer aided parametric design[J].CAD,1991,23(5):385-391.
[11]张海藩.软件工程导论[M].北京:清华大学出版社,1987:12-16.
[12]周强.膨胀节的计算辅助设计及参数化绘图系统[D].南京:南京化工大学,2003:64-66.
[13]杜明霞.管网中膨胀节的选型设计及软件开发研究[D].南京:南京化工大,2003:37-47.
[14]李宝清,贾安东.计算机辅助焊接工艺评定的研究与进展[J].焊接.2000,8:6-9.
[15]李惠云,徐燕中等.CAPP:概念、现状、存的问题及发展趋势[D].河北工业科技,(7)2000.53-56.
[16]杨立军.基于VB的AutoCAD二次开发技术[J].现代制造工程,2004,(3):27-28.
[17]宗望远、冯责平.浅谈CAD技术的研究与应用[J].湖北农机所,2003.2:55-56.
[18]戴同.CAD/CAPP/CAM基本教程[M].北京:清华大学出版社,1997:152-154.
[19]范玉青,黄秀娟,周建华.CAD软件设计[M].北京:北京航空航天大学出版社,1996:133-134.
[20]杨芙清.软件工程技术发展思索[J].软件学报,2005,(01):164-166.
[21]刘瑞新,崔淼,等编著.VisualBasic程序设计[M].北京:机械工业出版社,2003:261-263.
[22]潘锦平.软件系统开发技术[M].西安:西安电子科技大学出版社,1989:12-14.
[23]苟建兵,倪维斗.基于DLL的混合语言编程[J].软件世界,1996,(09):172-177.
[24]罗晓沛.数据库技术[M].北京:清华大学出版社,1999:128-130.
[25]张炜.VisualBasic6.0数据库开发应用教程.航空工业出版社[M].2000年6月第1版:192-197.
[26]同志工作室.VisualBasic6.0数据库开发实例[M].人民邮电出版社,2001年1月第1版:177-179.
[27]乔美娥.ADO技术在VB系统开发中的高级应用[J].中国科技信息,2008,(24):84-85.
[28]葛玉华,霍立兴,张玉凤.焊接专家系统的应用与发展.焊接技术[J].2000,29(2):41-42.
[29]符朝兴,韩忠浩,等.基于数据库对CAPP系统中工序卡片的编辑与报表输出子系统的开发[J].机械制造,2004(4):16-20.
[30]AkmanV.,etal.A Fundamentaland Theoretical Frame Work for an intelligent CAD System.CAD[J].1991,22(6):352-367.
[31]陈春红.钢制压力容器焊接工艺设计及管理专家系统[D].西安交通大学.2000:33-36.
[32]Dimitris Kiritsis.Areview of knowledge-based expert systems for Process Planning Methodsand Problems[J].International Journal of Advanced.Manufacturing Technology,1995,10(4):240-262.
[33]Efraim Turban,LouisE.Frenzel.Expert systems and applied artificial intelligence[J].USA.Prentice Hall.1992.
[34]李敏,刘和平.波纹管膨胀节设计软件的模块化设计[J].洛阳工学院学报 1997,18(3):66-70.
[35]李富科,金军.波形膨胀节的设计[J].石油工程建设,2004,(01):46-50.
[36]杨玲吴海霞,谢守勇,杨国才.膨胀节波纹管优化设计系统研究[J].西南农业大学学报,2003,(06):146-151.
[37]刘春生.波形参数对波纹管性能的影响[J].炼油设计,1996,(01):57-63.
[38]EverettN.McKay.MicrosoftWindows用户界面开发[M].北京:北京大学出版社,2001.7:146-150.
[39]刘霞,左贵启,罗江勤.浅谈图形用户界面的设计[J].福建电脑,2003,3:30.1997,18(3):66-70.
[40]Jae Yeo Lee,Kwangsoo Kim.Geometric reasoning for knowledge-based parametric design using graph representation[J].Computer-aidedDesign,1996,28(10):321-327.
[41]Bodyako.MikhailN.Method of producing bellow from metal alloys.United States Patent 4369074.1983.1.18.
[42]Cyril J.A still,Peter Janzen,both of Deep River,Canada.Method of Producing a corrugated,multi-plymeta bellows.United States Patent 4453304.1984.6.12.
[43]Sutherland I.E.Sketchpad.A Man-machine Graphical Communication System[J].In:Proceedings of AFIIPS Spring Joint Computer Conference,1963:329-346.
[44]Li Yong-Sheng.Optimum Structural Design of U-shaped Expansion Joints[J].1994,17(10):52-56.
[45]赵海霞,王守城.焊接工艺数据库管理系统的开发[J].重庆科技学院学报(自然科学版),第9卷第2期2007年6月:167-169.
[46]琚春华,凌云,张益平.基于关系数据库的专家系统工具JEST的开发[D].黑龙江商学院学报,1994,10(4):12-19.
[47]胡玉忠.钢制压力容器焊接CAPP技术及实现[J].合肥工业大学.2003.1:237-247.
[48]Dewhurst P,Boothroyd G.journal of Manufacturing systems,1988,7(3):183.
[49]Cooper.R,Kaplan.R,Profit Prorities from Ac-tivity-Based Costing.Harvard Bus.Rev,(1991):130-131.
[50]王祯显,廖小健,杜晓玲.工程造价快速估算新方法及其应用[M].北京:中国建筑工业出版社,1998:22-26.
[51]谢泳.基于VB6.0的AutoCAD2000二次开发的研究[J].煤矿机械,2005,24(7):48-49.
[52]张晋西.VisualBasic与AutoCAD二次开发[M].北京:清华大学出版社,2002.1:139-145.
[53]岳震,张奉禄.基于VB的AutoCAD二次开发[J].机械设计与制造,2002(1):28-29.
[54]刘兴权,杨海燕,陈奇.应用软件帮助文档的制作方法初探[J].计算机时代,2005,7:30.
[55]文家炎,数据库系统原理和应用[M].北京:冶金出版社,2002:67-69.
[56]曾魁,邱岩.Microsoft Access的高级运用[J].中国计算机用户,1995,(09):78-79.