标准模块和类模块编程在土地质量地球化学调查建库辅助系统设计中的应用  

The application of standard module and class module in program design of database building assistant system for the land quality geochemical survey

作　　者：王增辉[1] WANG Zenghui(Shandong Institute of Geological Survey(Shandong Engineering Research Center of Land Quality Geochemistry and Pollution Prevention),Ji'nan 250014,China)

机构地区：[1]山东省地质调查院,山东省土地质量地球化学与污染防治工程技术研究中心,济南250014

出　　处：《物探化探计算技术》2020年第6期805-813,共9页Computing Techniques For Geophysical and Geochemical Exploration

基　　金：山东省地勘项目(鲁勘字(2019)4号)。

摘　　要：VB是编制地球化学数据处理程序的常用工具之一,合理利用VB提供的标准模块和类模块进行模块化程序设计,可极大提高代码通用性和可维护性。通过模块化编程方法,设计了一种用于土地质量地球化学调查原始信息录入的建库辅助系统(DBAS),在提高大比例尺土地质量地球化学评价项目数据电子化效率方面取得了良好的效果。该系统界面参照土地质量地球化学调查相关规范和技术要求进行设计,通过多个匹配功能模块对数据库记录表、GPS坐标信息表、预布点信息表以及字典信息表的交叉匹配,并对录入项目进行合理性和逻辑检查,从而实现了大量信息的自动录入或辅助录入。此外,本系统还包含了一种可预览点位信息的数据检查窗体,提供了一种可视化的数据检验途径。该系统不仅提高了数据录入效率,也极大地降低了人为错误几率,为土地质量地球化学调查数据库建设提供了更为高效的工作手段,可以为类似项目所借鉴。VB is one of the common tools for compiling geochemical data processing program.Modular program design using standard module and class module provided by VB can greatly improve the universality and maintainability of code.Through the modular programming method,a database building assistant system(DBAS)for the input of the original information of the land quality geochemical survey,is designed.This has achieved good results in improving the data electronic efficiency of large-scale land quality geochemical evaluation project.The interface of the system is designed by referring to the relevant specifications and technical requirements of land quality geochemical survey.Through multiple matching function modules,the database record table,the GPS coordinate information table,the pre distribution information table and the dictionary information table are cross matched.The rationality and logic of the entry items are checked to realize the automatic or auxiliary entry of a large number of information.In addition,the system also includes a data check window which can preview the points'information,providing a visual way of data check.The system not only improves the efficiency of data entry,but also greatly reduces the probability of human error.It provides a more efficient working method for the construction of land quality geochemical survey database,which can be used for reference by similar projects.

关 键 词：土地质量地球化学调查 数据库 模块 VBA 建库辅助系统 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]