Application of VB in Processing Data of Quantitative Packaged Goods Inspection

The processing of data in the inspection of the net content of quantitatively packaged goods, if calculated by an ordinary calculator, has a very large amount of data processing. For example, when a commodity with a sample size of 3O is to be inspected by the mass method, 4 bits per data are used. Even if the input is correct, press the calculator button for more than 2000 times. The data of the specific gravity method or the density method is even more. If the data is handled manually, it will not only take F--] a lot of time, but it is also very easy to misjudge because of calculation errors. When printing the inspection report, and it is easy to input errors, we can use Visual Basic 6.0 as the main function of the program function in the design. Use the j Microsoft Access design database to connect with the VB program. Just input the raw data. Once, you can automatically calculate the data and conclusions needed later. And can edit, save, and count data. The report printing function makes the report printing easier. Friendly human interface and user-friendly design make data input very convenient. The function covers the later data processing and report printing of the quantitative packaged goods inspection.

In the interface design, use the Text text box control as a basic input output tool, use the Option selection button control as a function selection box. Using Bottom button controls to achieve a variety of functions, the interface shown in Figure l.

For the convenience of data input, the design uses the sequence of the Tabindex property of the data input text box, and the input text box is set as the sequential input. In the design of the program code, the basic flow is shown in Figure 2. Since the rules for the revision of data in the standard specification are not exactly the same as those for the general computer. Therefore, the data calculated directly by the computer must be processed with necessary procedures before it can be used. For example, for the data to retain 2 decimal places, because the computer generally only for "rounded" processing. While the revision of the data in the standard specification is based on the “Five-six-six-five-spouse” rule. Therefore, each calculation result needs to be independently processed to meet the requirements of the standard specification. In addition, the computer is imaginary after the decimal point. "O" is generally not displayed. For example, "235.20" is only displayed as "235.2". And this begins to create new records in the standard specification and input the original data to calculate the corresponding data. Correspondingly processing the calculated results and displaying and saving the data records. Printing reports. Viewing edits or printings is also not allowed. Therefore, it is also necessary to perform program processing on each input and output data. These handlers cannot be called directly in VB software. Designers can only write their own according to their own data processing requirements.

Data records are mainly saved with Mi. Crosoft Access software designed in the database file

, The database file is first designed according to the number of records that need to be saved with Access software.

The CCP wants to design two tables. One of the tables is used to store all data records, and the other is used to protect the data.

Store temporary data records to print. In the main program calls the Data control to connect VB and database files

, Through the sQL language on the database file to read, rewrite and add a variety of operations.

Another major feature of this design is that it has a relatively complete test report printing function. First use water

The crystal report software designs the inspection report template. Then call the crystal report control in the VB main program interface

Crytal Report, Using Crystal Report Controls to Place Sub-tables and Inspection Report Templates in Database Files

Connect it and start printer printing. Because Crystal Reports do not specify the format of the print template

. Users can design their own according to actual needs, so the printing function is very flexible and can be printed out

The inspection report can also print various statistical results as required.

This design has been applied in the data processing of the quantitative packaged goods inspection by the Institute. Practice has proved that not only

Greatly improved the accuracy of the calculation results and greatly improved the work efficiency. It has become our inspection.

An important tool for data processing and result statistics.

Zhong Wenbin China Metering-2005 No.5