示波器自动检定系统与数据库管理
摘要
NH4602示波器程控校准仪是我教研室几年前为贵州南华仪器厂研制开发的一台校准检验仪器，可用于示波器校准检验。最早的自动测试程序是在DOS平台下采用ESBASIC编制完成，使用时较为繁琐，而且界面也不清晰、直观。由于操作系统的更新，使得我们在新形势下提出在WINDOWS环境下重新编制NH4602示波器程控校准仪的测试程序。不仅要解决界面问题，因为有好的用户界面，才能开始设计程序的结构，以便完成要求的任务；同时还要完善整个测试功能。根据新的示波器检定规则来设计该软件包。
本文介绍了在Windows环境下采用可视化的程序设计方法，用Visual Basic编制示波器自动检定系统软件包，这使得编程过程变的轻松。该软件的测试部分主要用于完成对示波器扫描时间系数、扩展扫描时间系数、△t时间测量、△V电压测量、垂直偏转系数、频带宽度、校准信号、脉冲瞬态响应、扫描线性误差时等参数的测试检定任务，并对测试结果进行及时的分析和判断，由于界面清晰，而且对测试过程中由于用户的误操作都有及时的错误提示，使得整个测试过程简单易行，对于用户来讲掌握起来也更为方便些。
该软件系统的数据库部分是针对测试过程及测试结果的需求所建立的。测试前对各被测示波器的各项检定参数要建立一个参数库，这是示波器检定所必须的；测试后为方便用户查询和了解所有检定过的示波器及其测试结果要建立一个查询库、证书库等等。Visual Basic提供了从Visual Basic程序访问并操纵大量数据资源的能力。我们采用其所支持的Microsoft Access数据库格式来建立数据库。从而保证了该示波器检定系统软件功能的完整性。
由于该软件系统是应南华仪器厂的需求而开发的，它实现了所提出的各项测试和检定功能，数据库较为完善。同时优化了人机界面，操作上更为方便。在该软件系统的开发过程中，设计了许多错误提示，这使得用户在使用该软件系统进行工作时能及时发现操作上的错误，并能够及时纠正，这使得用户的操作过程更为简单、方便，具有一定的实用价值。
NH4602, the program-controlled calibration instrument of oscillograph, was designed in our laboratory for the need of NanHua device manufacturer in GuiZhou province several years ago which can be used to regulate and adjust the oscillograph into expected precision. The earliest automatic test procedure is completed under the DOS platform which adopt the ESBASIC .Not only usage was more cockamamie but also the user interface was not clear and intuitionistic. Because of the operating system's update, it makes us to re-design the test procedure of the oscillograph calibration instrument under the WINDOWS system. We must resolve the user's interface firstly because good user interface is the most important precondition to the design of the construction of the procedure in order to complete tasks requested. At the same time we have to perfect the whole test function. The software package is designed according to the new oscillograph's test rule.
This paper introduces visualization's procedure design method under the Windows environment with Visual Basic that makes the programming process more convenient. That test part of the software is primarily used to complete the test of some parameters, such as time base, time-expand, time interval, voltage interval, vertical, stable state, transient state and scanning linearity. The result of the test needs to be analyzed and judged. Clear user interface and timely warnings for mistakes of testing process inside because of the user's fault operating make whole test process more easier than it did on a time. For users, the grasp of whole process becomes more convenient.
The database part of the software's system is created for the need of the test process and the test result. Of the beginning of the test, the parameter databases for test-required scillograph must be created, and this is what oscillograph examination need. At the end of the test, the databases, such as query database, certification database, etc. are required to create for users. Visual Basic provides capabilities of calling and operating mass datum resources. We adopt the Microsoft Access database which is supported by the Visual Basic to create the database so that we guarantee the integrity of oscillograph examined system software.
At the request of Nanhua apparatus plant, the software system is developed. It realizes various tests of station suggested and testing functions with more integral database. At the same time it optimizes the users interface and makes operation more
convenient. In the course of development, we added many bug information, this makes the users detect bugs more easily when they are operating. Rectification will be done in time. All these advantages make the whole operating course more simple and easy and demonstrate that the software system has the value of definite application.
本文介绍了在Windows环境下采用可视化的程序设计方法，用Visual Basic编制示波器自动检定系统软件包，这使得编程过程变的轻松。该软件的测试部分主要用于完成对示波器扫描时间系数、扩展扫描时间系数、△t时间测量、△V电压测量、垂直偏转系数、频带宽度、校准信号、脉冲瞬态响应、扫描线性误差时等参数的测试检定任务，并对测试结果进行及时的分析和判断，由于界面清晰，而且对测试过程中由于用户的误操作都有及时的错误提示，使得整个测试过程简单易行，对于用户来讲掌握起来也更为方便些。
该软件系统的数据库部分是针对测试过程及测试结果的需求所建立的。测试前对各被测示波器的各项检定参数要建立一个参数库，这是示波器检定所必须的；测试后为方便用户查询和了解所有检定过的示波器及其测试结果要建立一个查询库、证书库等等。Visual Basic提供了从Visual Basic程序访问并操纵大量数据资源的能力。我们采用其所支持的Microsoft Access数据库格式来建立数据库。从而保证了该示波器检定系统软件功能的完整性。
由于该软件系统是应南华仪器厂的需求而开发的，它实现了所提出的各项测试和检定功能，数据库较为完善。同时优化了人机界面，操作上更为方便。在该软件系统的开发过程中，设计了许多错误提示，这使得用户在使用该软件系统进行工作时能及时发现操作上的错误，并能够及时纠正，这使得用户的操作过程更为简单、方便，具有一定的实用价值。
NH4602, the program-controlled calibration instrument of oscillograph, was designed in our laboratory for the need of NanHua device manufacturer in GuiZhou province several years ago which can be used to regulate and adjust the oscillograph into expected precision. The earliest automatic test procedure is completed under the DOS platform which adopt the ESBASIC .Not only usage was more cockamamie but also the user interface was not clear and intuitionistic. Because of the operating system's update, it makes us to re-design the test procedure of the oscillograph calibration instrument under the WINDOWS system. We must resolve the user's interface firstly because good user interface is the most important precondition to the design of the construction of the procedure in order to complete tasks requested. At the same time we have to perfect the whole test function. The software package is designed according to the new oscillograph's test rule.
This paper introduces visualization's procedure design method under the Windows environment with Visual Basic that makes the programming process more convenient. That test part of the software is primarily used to complete the test of some parameters, such as time base, time-expand, time interval, voltage interval, vertical, stable state, transient state and scanning linearity. The result of the test needs to be analyzed and judged. Clear user interface and timely warnings for mistakes of testing process inside because of the user's fault operating make whole test process more easier than it did on a time. For users, the grasp of whole process becomes more convenient.
The database part of the software's system is created for the need of the test process and the test result. Of the beginning of the test, the parameter databases for test-required scillograph must be created, and this is what oscillograph examination need. At the end of the test, the databases, such as query database, certification database, etc. are required to create for users. Visual Basic provides capabilities of calling and operating mass datum resources. We adopt the Microsoft Access database which is supported by the Visual Basic to create the database so that we guarantee the integrity of oscillograph examined system software.
At the request of Nanhua apparatus plant, the software system is developed. It realizes various tests of station suggested and testing functions with more integral database. At the same time it optimizes the users interface and makes operation more
convenient. In the course of development, we added many bug information, this makes the users detect bugs more easily when they are operating. Rectification will be done in time. All these advantages make the whole operating course more simple and easy and demonstrate that the software system has the value of definite application.
引文
1．(美)佩雷(Perry，G．)，学用Visal Basic 6.0，北京：清华大学出版社，1999
2．张浩，中文Visual Basic 5.0程序开发适用技术，南京大学出版社出版，1999
3．张更路，Visual Basic 6.0数据库程序设计实用教程；北京希望电子出版社，2000
4．中华人民共和国国家计量检定规程汇编 无线电 (六) 1992—1996；中国计量出版社，1997
5．东箭工作室 编著 Access97中文版块递；电子工业出版社，1997
6．Douglas Hergert 著 Visual Basic 5宝典；电子工业出版社，1998
7．周光明 著 Visual Basic for Windows语言参考详解；北京航空航天大学出版社，1995
2．张浩，中文Visual Basic 5.0程序开发适用技术，南京大学出版社出版，1999
3．张更路，Visual Basic 6.0数据库程序设计实用教程；北京希望电子出版社，2000
4．中华人民共和国国家计量检定规程汇编 无线电 (六) 1992—1996；中国计量出版社，1997
5．东箭工作室 编著 Access97中文版块递；电子工业出版社，1997
6．Douglas Hergert 著 Visual Basic 5宝典；电子工业出版社，1998
7．周光明 著 Visual Basic for Windows语言参考详解；北京航空航天大学出版社，1995