水泵性能试验自动处理软件的开发
|
摘要
水泵是国民生产、生活中重要的机械设备,被广泛使用在与人民生活息息相关的能源、矿山、化工、水处理等各个重要行业。水泵的结构虽然比较简单,但水泵内部的流动却十分复杂,至今还不能完全用解析的方法确定水泵在不同工况下的特性。目前获得水泵性能参数及这些参数之间的相互关系,主要依赖于性能试验,它对水泵的设计、生产、使用都非常重要,是提高水泵技术水平的重要措施之一。水泵性能测试所需的公式比较繁杂、不易计算,在水泵性能试验中运用有一定难度。随着科学技术的发展,生产企业对水泵性能试验的自动化和智能化的要求与日俱增。因此,利用计算机技术、检测技术、通信技术和数据处理技术,开发一个集参数采集、数据处理、曲线拟合、质量判定和试验报告于一体的水泵性能试验自动处理软件,对于提高水泵测试精度和测试效率,完善测试手段,提高产品质量和性能都具有重要作用。
本文首先分析了软件开发的背景和意义,介绍了PowerBuilder和SQL Server的技术特点,并对水泵性能试验自动处理的需求作了比较详细的分析,阐述了该软件系统管理、系统初始化、通信试验、数据处理等模块的功能及程序编码实现。特别对数据通讯采集与处理、曲线拟合程序等模块的实现过程进行了重点论述,同时也分析了软件的数据库设计,给出了相应的表结构。该软件的功能基本实现了水泵性能试验自动分析、计算、变换。
Water pump is an important mechanical device in the national production and people's life, which is widely used in energy industry, mine, chemical industry, water treatment and other important industries closely related to people's life. Although water pump's structure is quite simple, but the internal flow is extremely complex. So that it has not been able to use the analytic methods to determine the general characteristics of water pumps under different operating modes. At present, performance test is the main way to obtain the performance parameters and their relationships of water pump, which is one of the essential measures to improve the water pump technical level and is very important in its design, production and using. The formula about water pump performance test is quite complicated and hard to calculate, so it is difficult to be utilized in water pump performance test. Along with the development of science and technology, enterprises require higher automation and intellectualization water pump performance test day by day. It uses the computer technology, the examination technology, the communication technology and data processing to develop a water pump performance test which integrates automatic analysis and processing system collected parameter gathering, data processing, curve fitting, quality determination and test report. It is important to improve the precision and efficiency of water pump test, consummating the test method, improving the product quality and the performance.
Based on the generalized analysis of the water pump performance test domestic and overseas, the water pump performance test automated analysis processing system has been designed and implemented. In this paper, the development background and the significance is firstly analyzed, then the essential method gathering Power builder and SQL Server in developing this system is introduced, the quite detailed analysis of the automatic analysis and processing demand of the water pump performance test is made, and the principle as well as programming of various functional module such as system administration, initialization, correspondence experiment and data processing is elaborated. The data communication gathering and processing together with the curve fitting procedure are emphasized in particular. Meanwhile, the database design is explained with the corresponding table structure. This system has basically implemented the automated analysis, calculation and transformation of water pump performance test and increased the precision and the efficiency of water pump performance test remarkably.
本文首先分析了软件开发的背景和意义,介绍了PowerBuilder和SQL Server的技术特点,并对水泵性能试验自动处理的需求作了比较详细的分析,阐述了该软件系统管理、系统初始化、通信试验、数据处理等模块的功能及程序编码实现。特别对数据通讯采集与处理、曲线拟合程序等模块的实现过程进行了重点论述,同时也分析了软件的数据库设计,给出了相应的表结构。该软件的功能基本实现了水泵性能试验自动分析、计算、变换。
Water pump is an important mechanical device in the national production and people's life, which is widely used in energy industry, mine, chemical industry, water treatment and other important industries closely related to people's life. Although water pump's structure is quite simple, but the internal flow is extremely complex. So that it has not been able to use the analytic methods to determine the general characteristics of water pumps under different operating modes. At present, performance test is the main way to obtain the performance parameters and their relationships of water pump, which is one of the essential measures to improve the water pump technical level and is very important in its design, production and using. The formula about water pump performance test is quite complicated and hard to calculate, so it is difficult to be utilized in water pump performance test. Along with the development of science and technology, enterprises require higher automation and intellectualization water pump performance test day by day. It uses the computer technology, the examination technology, the communication technology and data processing to develop a water pump performance test which integrates automatic analysis and processing system collected parameter gathering, data processing, curve fitting, quality determination and test report. It is important to improve the precision and efficiency of water pump test, consummating the test method, improving the product quality and the performance.
Based on the generalized analysis of the water pump performance test domestic and overseas, the water pump performance test automated analysis processing system has been designed and implemented. In this paper, the development background and the significance is firstly analyzed, then the essential method gathering Power builder and SQL Server in developing this system is introduced, the quite detailed analysis of the automatic analysis and processing demand of the water pump performance test is made, and the principle as well as programming of various functional module such as system administration, initialization, correspondence experiment and data processing is elaborated. The data communication gathering and processing together with the curve fitting procedure are emphasized in particular. Meanwhile, the database design is explained with the corresponding table structure. This system has basically implemented the automated analysis, calculation and transformation of water pump performance test and increased the precision and the efficiency of water pump performance test remarkably.
引文
[1]林锦荣,吴兆林,周志钢,顾开春.水泵测试系统数据处理的计算机分析[J]流体机械,2005,33(10)：28-31.
[2]陶耀星等.GB3216—89离心泵、混流泵、轴流泵和旋涡泵试验方法[S].北京：机械工业出版社,1989.
[3]关醒凡等.现代泵技术手册[M].北京：宇航出版社,1998.
[4]刘超,白玲.水泵性能试验自动处理系统的分析与设计.
[5]刘超,白玲.水泵性能试验分析处理软件的设计与实现[J].南昌航空工业学院学报,2005,19(3)：70-74.
[6]徐行健.泵行业的国内外情况[J].流体机械,1995,12.
[7]曹爱红.水泵综合参数自动测试系统的研究[D]：[硕士学位论文].兰州：兰州理工大学,2006.
[8]ACB walya, M W Johnson. Experimental Measurements in a Centrifugal Pump Impeller.Fluid Engineering,1996,692.
[9]刘小平.网络化大型水泵综合参数测控系统研究[D]：[硕士学位论文].合肥：合肥工业大学,2008.
[10]Erdal, A., Torbergsen et al. Flow development downstream of two simplified and One K-lab/Laws flow conditioners-exper iments and calculations. The 1997 ASME Fluids Engineering Division Summer Meeting, Vancouver, Canada, June 1997, 22-26.
[11]刘在伦,梁森呼,艳芬.水泵自动测试软件设计方法探讨[J].水泵技术,2007(6)：15-17.
[12]刘超,白玲.基于径向基函数神经网络拟合水泵特性曲线.机械设计[J],2008,25(6)：51-61.
[13]梁森.水泵开式台自动测试系统的研究[D]：[硕士学位论文].兰州：兰州理工大学,2007.
[14]赵朝光,王洋等.潜水电泵试验方法[S].北京标准化出版社；2002.
[15]李红连,陈次昌等.水泵微机测试系统研究.中国农村水利水电[J].2004,(4)：75—79.
[16]于春慧.基于虚拟仪器的水泵性能数据采集系统的研究[D]：[硕士学位论文]吉林：吉林大学,2004.
[17]胡懋昌等.回转动力泵、水力性能验收试验1级和2级.中国标准出版社,2006.
[18]卢东等.潜水泵性能的计算机辅助试验.水泵技术,2004(1)
[19]卢飒.潜水泵电性能的计算机辅助测试系统的研制.自动化与仪表[J],2001(6)：3-5.
[20]姚志青.多功能水泵综合试验台测控系统研究[D]：[硕士学位论文].江苏：江苏大学,2005.
[21]力昌兵.微机水泵综合参数测试系统的研究与开发[D]：[硕士学位论文].合肥：合肥工业大学,2002.
[22]杨新春.水泵性能检测试验数据处理及软件设计.科技信息,2008,29：92-93.
[23]林锦荣等.水泵测试系统数据处理的计算机分析.流体机械[J],2005,33(10)：28-30.
[24]袁雄俊.锅炉给水泵状态监测与故障诊断试验系统的研究[D]：[硕士学位论文].河北,华北电力大学,2003.
[25]余祖俊.微机检测与控制应用系统设计.北京：北方交通大学出版社,2001.
[26]顾伟驷,孙建辉.潜水电泵性能的计算机辅助测试系统.水泵技术[J],2004(1)：48.
[27]王琪,刘雪颖,王玉刚.小型离心式水泵性能试验台的研制[J].工业技术经济1997,16(4)：119-120.
[28]邱丽芳.基于微机的水泵性能测试系统的设计[J].湖南工业职业技术学院学报,2006,6(4)：11-13.
[29]成琰.基于LabWindows/CVI的汽车水泵综合性能试验台软件设计[J].测控技术,2005,24(5)：70-72.
[30]赵博,赵旭光,潘笑,郑玉民.基于B级精度的水泵数字化测试系统[J].中国 农村水利水电,2007(3)：85-90.
[31]王联,吕振.基于组态平台的泵测试系统[J].煤矿机电,2006(5)：47-49
[32]牛连强,王溪波,张荣存.水泵性能检测控制系统的软件设计[J].沈阳工业大学学报,1998,20(5)：18-21.
[33]吴安平.排灌泵试验系统的研制[D].[硕士学位论文].合肥：合肥工业大学,2005.
[34]王立峰,延伟东,章华编著.软件工程理论与实践[M].北京：清华大学出版社,2003,12.
[35]欧阳烔.水泵性能试验自动分析处理软件的研究与设计[D]：[硕士学位论文]江西：江西师范大学,2009.
[36]洪志全,洪学海.代计算机接口技术[M].北京：电子工业出版社,2001.
[37]郑人杰等.实用软件工程[M]第二版,北京：清华大学,2004.
[38]谌章义,伍临莉.VC6.0下的离心泵性能测试系统的程序开发[J].沈阳工业高等专科学校学报,2006,16(2)：44-45.
[2]陶耀星等.GB3216—89离心泵、混流泵、轴流泵和旋涡泵试验方法[S].北京：机械工业出版社,1989.
[3]关醒凡等.现代泵技术手册[M].北京：宇航出版社,1998.
[4]刘超,白玲.水泵性能试验自动处理系统的分析与设计.
[5]刘超,白玲.水泵性能试验分析处理软件的设计与实现[J].南昌航空工业学院学报,2005,19(3)：70-74.
[6]徐行健.泵行业的国内外情况[J].流体机械,1995,12.
[7]曹爱红.水泵综合参数自动测试系统的研究[D]：[硕士学位论文].兰州：兰州理工大学,2006.
[8]ACB walya, M W Johnson. Experimental Measurements in a Centrifugal Pump Impeller.Fluid Engineering,1996,692.
[9]刘小平.网络化大型水泵综合参数测控系统研究[D]：[硕士学位论文].合肥：合肥工业大学,2008.
[10]Erdal, A., Torbergsen et al. Flow development downstream of two simplified and One K-lab/Laws flow conditioners-exper iments and calculations. The 1997 ASME Fluids Engineering Division Summer Meeting, Vancouver, Canada, June 1997, 22-26.
[11]刘在伦,梁森呼,艳芬.水泵自动测试软件设计方法探讨[J].水泵技术,2007(6)：15-17.
[12]刘超,白玲.基于径向基函数神经网络拟合水泵特性曲线.机械设计[J],2008,25(6)：51-61.
[13]梁森.水泵开式台自动测试系统的研究[D]：[硕士学位论文].兰州：兰州理工大学,2007.
[14]赵朝光,王洋等.潜水电泵试验方法[S].北京标准化出版社；2002.
[15]李红连,陈次昌等.水泵微机测试系统研究.中国农村水利水电[J].2004,(4)：75—79.
[16]于春慧.基于虚拟仪器的水泵性能数据采集系统的研究[D]：[硕士学位论文]吉林：吉林大学,2004.
[17]胡懋昌等.回转动力泵、水力性能验收试验1级和2级.中国标准出版社,2006.
[18]卢东等.潜水泵性能的计算机辅助试验.水泵技术,2004(1)
[19]卢飒.潜水泵电性能的计算机辅助测试系统的研制.自动化与仪表[J],2001(6)：3-5.
[20]姚志青.多功能水泵综合试验台测控系统研究[D]：[硕士学位论文].江苏：江苏大学,2005.
[21]力昌兵.微机水泵综合参数测试系统的研究与开发[D]：[硕士学位论文].合肥：合肥工业大学,2002.
[22]杨新春.水泵性能检测试验数据处理及软件设计.科技信息,2008,29：92-93.
[23]林锦荣等.水泵测试系统数据处理的计算机分析.流体机械[J],2005,33(10)：28-30.
[24]袁雄俊.锅炉给水泵状态监测与故障诊断试验系统的研究[D]：[硕士学位论文].河北,华北电力大学,2003.
[25]余祖俊.微机检测与控制应用系统设计.北京：北方交通大学出版社,2001.
[26]顾伟驷,孙建辉.潜水电泵性能的计算机辅助测试系统.水泵技术[J],2004(1)：48.
[27]王琪,刘雪颖,王玉刚.小型离心式水泵性能试验台的研制[J].工业技术经济1997,16(4)：119-120.
[28]邱丽芳.基于微机的水泵性能测试系统的设计[J].湖南工业职业技术学院学报,2006,6(4)：11-13.
[29]成琰.基于LabWindows/CVI的汽车水泵综合性能试验台软件设计[J].测控技术,2005,24(5)：70-72.
[30]赵博,赵旭光,潘笑,郑玉民.基于B级精度的水泵数字化测试系统[J].中国 农村水利水电,2007(3)：85-90.
[31]王联,吕振.基于组态平台的泵测试系统[J].煤矿机电,2006(5)：47-49
[32]牛连强,王溪波,张荣存.水泵性能检测控制系统的软件设计[J].沈阳工业大学学报,1998,20(5)：18-21.
[33]吴安平.排灌泵试验系统的研制[D].[硕士学位论文].合肥：合肥工业大学,2005.
[34]王立峰,延伟东,章华编著.软件工程理论与实践[M].北京：清华大学出版社,2003,12.
[35]欧阳烔.水泵性能试验自动分析处理软件的研究与设计[D]：[硕士学位论文]江西：江西师范大学,2009.
[36]洪志全,洪学海.代计算机接口技术[M].北京：电子工业出版社,2001.
[37]郑人杰等.实用软件工程[M]第二版,北京：清华大学,2004.
[38]谌章义,伍临莉.VC6.0下的离心泵性能测试系统的程序开发[J].沈阳工业高等专科学校学报,2006,16(2)：44-45.