基于SolidWorks和SQL的管壳式换热器辅助设计软件开发  

Development of adied design software of shell-and-tube heat exchanger based on SolidWorks and SQL

作　　者：雪冰锋 阎志祥 周安吉 史彬 鄢烈祥 Xue Bingfeng;Yan Zhixiang;Zhou Anji;Shi Bin;Yan Liexiang(School of Chemistry,Chemical Engineering and Life Sciences,Wuhan University of Technology,Wuhan 430070,China;Hubei Difeng Heat Exchanger Co.,Ltd.,Daye 435100,Hubei,China)

机构地区：[1]武汉理工大学化学化工与生命科学学院,武汉430070 [2]湖北迪峰换热器股份有限公司,大冶435100

出　　处：《现代制造工程》2019年第9期107-112,共6页Modern Manufacturing Engineering

基　　金：中央高校基本科研基金项目(2018zy184)

摘　　要：为解决现有管壳式换热器结构设计配置多、设计周期长的难题,提出了结合Solid Works软件参数化设计与SQL数据管理的管壳式换热器辅助设计软件开发。先采用“自顶向下”的设计思想建立不同管壳式换热器总成的Solid Works骨架模型,利用SQL数据库对换热器产品零/部件选型、标准零件数据信息进行管理,然后以VB. NET调用Solid Works API函数,实现不同型号管壳式换热器快速设计与工程出图。实践表明:所开发的软件可覆盖所有常规管壳式换热器不同型号产品的快速设计,换热器的平均设计周期可由16工时降至4工时,有效节省设计时间和开发成本,提高设计效率。To solve the problems of complex configuration and long design cycle in shell-and-tube heat exchanger design process, proposed the development of computer-aided design software for the shell-and-tube heat exchanger based on SolidWorks parameterized design and SQL data management. Firstly, SolidWorks skeleton models of different types of shell-and-tube heat exchanger assemblies were established by using the design idea of "top-down”. Then,SQL database was introduced to manage the heat exchanger *part s selection and the standard part information. Furthermore,the SolidWorks API functions were called in VB. NET environment to realize rapid design and engineering drawings plotting for different types of shell-and-tube heat exchangers. The results of commercial application showed that the developed software can realize the rapid design of all conventional shell-and-tube heat exchangers, the average design cycle can be reduced from 16 working hours to 4 working hours, which effectively saves design time and development cost, therefore significantly improves design efficiency.

关 键 词：管壳式换热器 参数化设计 骨架模型 Solid WORKS API SQL 

分 类 号：TP391.9[自动化与计算机技术—计算机应用技术]