CN104392506B - Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods - Google Patents

Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods Download PDF

Info

Publication number
CN104392506B
CN104392506B CN 201410736030 CN201410736030A CN104392506B CN 104392506 B CN104392506 B CN 104392506B CN 201410736030 CN201410736030 CN 201410736030 CN 201410736030 A CN201410736030 A CN 201410736030A CN 104392506 B CN104392506 B CN 104392506B
Authority
CN
Grant status
Grant
Patent type
Application number
CN 201410736030
Other languages
Chinese (zh)
Other versions
CN104392506A (en )
Inventor
艾永平
易魁
肖海斌
邱小弟
卢吉
陈豪
张鹏
毛莺池
周晓峰
王龙宝
陈亚明
李洪波
熊孝中
李耀德
廖贵能
彭欣欣
郝灵
吕鑫
Original Assignee
华能澜沧江水电有限公司
河海大学
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Grant date

Links

Abstract

本发明公开了一种支持多终端平台的水电站水工巡检系统,包括移动设备同步历史数据、移动设备采集水工巡检数据、移动设备上传最新巡检数据和PC端管理巡检数据并自动生成报表。 The present invention discloses a support for multi-terminal platform inspection station hydraulic system, including a mobile device synchronization historical data, mobile hydraulic equipment inspection data collection, mobile device to upload the latest inspection data and PC client management and automatic data logging Generate reports. 移动设备从PC端下载最新的水工巡检数据至移动终端,方便用户在每次巡检时获得上次巡检的结果信息,并可以与当前巡检现场情况进行比较。 Download the mobile device from the PC side of the hydraulic latest inspection data to the mobile terminal, user-friendly information to obtain the results of the last inspection at each inspection, and the inspection can be compared with the current situation. 使用移动终端将水工巡检现场数据进行记录。 Hydraulic mobile terminal using field inspection data is recorded. 将移动设备中的水工巡检数据信息导入到PC端中,通过对巡检数据的分类处理,可以将基本数据信息转化为数据对象,存入数据库,将多媒体数据存入多媒体数据库,可以有效管理巡检数据。 Introducing hydraulic inspection data in the mobile device information to the PC side by the sorting process of inspection data, basic data can be converted to data objects stored in the database, the multimedia data stored in the multimedia database to be effective management inspection data. PC端管理巡检数据并自动生成报表,将最新上传的数据以报表格式显示。 PC client management data and automatically generate inspection reports, the latest data is uploaded to a report format. 本发明提高了巡检人员工作效率和准确性。 The invention improves the efficiency and accuracy of inspection personnel.

Description

一种支持多终端平台的水电站水工巡检数据同步和数据管理方法 Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods

技术领域 FIELD

[0001] 本发明涉及一种支持多终端平台的水电站水工巡检系统,结合水工巡检业务的需求,有效地解决了传统水工巡检中所有数据需要手工记录、手动整理录入数据库和填写报表而带来的效率低、错误多等问题,可方便水工巡检基本数据、多媒体数据采集和记录、巡检日报表的自动生成,使得巡检数据能够自动、及时、准确入库和及时上报,节省巡检数据处理和报表生成时间,提高巡检人员工作效率和准确性。 [0001] The present invention relates to a multi-terminal support platform inspection station hydraulic system, hydraulic binding inspection requirements of business, effectively solve the need to manually record all data in a conventional hydraulic inspection, and entered into the database manually organize fill in the report brought low efficiency, error of many other issues, easy inspection of hydraulic basic data, multimedia data acquisition and recording, inspection automatically generated daily report, making inspection data automatically, timely, accurate and storage timely reporting, saving inspection data processing and report generation time and increase staff productivity and inspection accuracy.

背景技术 Background technique

[0002] 巡检是水电站引水发电系统不可缺少的一个环节,能及时发现缺陷并解决缺陷,因此巡检在水电站日常管理中有着极其重要的地位。 [0002] inspection conduits of hydropower stations is an indispensable link, and can find and resolve defects defects, so the inspection has an extremely important role in the daily management of hydropower stations. 目前,水工巡检方式主要是通过填写纸质报表实现,包括创建巡检任务,执行巡检任务,提交巡检记录,处理巡检问题和生成分析报告等流程。 Currently, the main way to achieve hydraulic inspection by filling out paper statements, including the creation of the inspection task, perform inspection tasks, submit inspection records, inspection deal with the problem and generate analysis reports and other processes. 现有水工巡检依靠巡检人员填写纸质报表的方式进行操作,面对繁多的巡检部位,每次的巡检过程均可以产生大量的巡检数据,纸质报表的数据需要巡检人员回办公地后手动录入数据库,耗时耗力,容易出错,且造成了巨大的资源浪费。 Patrol officers patrol rely on existing hydraulic fill out paper statements ways to operate in the face of many polling sites, each of the inspection process can be a large amount of inspection data, the paper reports required inspection after returning to the office staff manually entered into the database, time-consuming and labor-intensive, error-prone, and caused a huge waste of resources. 另一方面,巡检过程中产生的多媒体数据,比如大坝缺陷、险情等图片信息及视频信息,采用传统方式不易集中管理,且不易将缺陷、险情的图片视频与出险部位进行数据关联,增大了险情处理人员处理险情的难度。 On the other hand, generated during the inspection of multimedia data, such as dams defects, and other dangerous information and video image information, the traditional way is not easy to centrally manage and easy defect, video and image data of the dangerous condition of danger associated parts, by the difficulty of handling large staff to handle dangerous situations of danger. 为了提高水工巡检工作效率,更好地服务于水电站日常数据处理工作,开发电站水工巡检系统,将水工安全巡检过程中业务流程信息化,辅助巡检人员记录现场水工缺陷信息,实现巡检工作、消缺工作统一管理,提高工作人员的工作效率。 In order to improve the efficiency of hydraulic inspection, to better serve the daily data processing work station, the development of hydraulic power station inspection system, the hydraulic safety inspection process, business process information technology, auxiliary hydraulic defect inspection personnel records site information to achieve the inspection work, the work of eliminating defects unified management, improve the efficiency of the staff.

[0003]由于受到大坝内部无线通信条件的限制,现有的水电站水工巡检系统无法完全实现终端数据的采集和监测智能化,也无法要求各个现场移动终端的数据与PC端实时保持同步,因此以PDA作为水工巡检系统终端数据采集和设置节点,构建基于多终端平台的水工巡检系统就孕育而生。 [0003] Due to limitations of wireless communication conditions inside the dam, the conventional inspection system hydraulic station not be fully realized data collection and monitoring of intelligent terminals, it can not require data and PC each field to synchronize the mobile terminal in real time , so as to PDA hydraulic system inspection and data collection terminal node set, built on the platform of the hydraulic multi-terminal system is born out inspection.

[0004] 个人数码助理PDA (Personal Digital Assistant),其优点是轻便、小巧、可移动性强,但是目前PDA多用于个人娱乐,很少能够在水工巡检中使用,在实际中使用需要能够整合多平台的资源进行统一协调。 [0004] personal digital assistants PDA (Personal Digital Assistant), its advantages are lightweight, compact, mobile and strong, but the PDA is currently used for personal entertainment, rarely used in the hydraulic inspection, the need to be able to use in practice integration of resources multi-platform unified coordination. 同时,传统水电站水工巡检中人工记录数据存在诸多缺陷,也无法记录多媒体数据。 Meanwhile, the conventional hydraulic inspection station there is data recorded in doing many defects, the multimedia data can not be recorded.

发明内容 SUMMARY

[0005] 发明目的:为了满足用户水工巡检信息化的需求,针对水电站水工巡检业务和移动终端协助巡检业务的现状,本发明提供一种支持多终端平台的水电站水工巡检系统,结合水工巡检业务的需求,本发明需要解决移动终端采集的水电站水工巡检数据的本地存储,保持各个移动终端采集的水工巡检数据与PC端存储的巡检数据的同步性,并自动根据当日巡检信息自动生成报表,实现水工巡检从同步到采集,从上传到管理的全过程信息化。 [0005] Object of the invention: the status quo in order to meet the needs of users of hydraulic inspection information to assist the inspection service for hydraulic inspection station and mobile terminal, the present invention provides a support for multi-terminal platform Hydraulic inspection station system, the combined demand for hydraulic service inspection, the present invention requires the acquisition of a mobile terminal to solve the locally stored data hydraulic inspection station, each mobile terminal synchronized hydraulic collected inspection data and PC data stored patrol sex, and date of inspection information according to automatically generate reports automatically, to achieve hydraulic inspection from the synchronization acquisition, the whole process from the upload information management. 有效地解决了传统水工巡检中所有数据需要手工记录、手动整理录入数据库和填写报表而带来的效率低、错误多等问题,可方便水工巡检基本数据、多媒体数据采集和记录、巡检日报表的自动生成,使得巡检数据能够自动、及时、准确入库和及时上报,节省巡检数据处理和报表生成时间,提高巡检人员工作效率和准确性。 Effective solution to the traditional hydraulic inspection of all the data required to manually record low manually entered into the database sorting and filing reports brought efficiency, errors of many other issues, easy inspection of hydraulic basic data, multimedia data acquisition and recording, patrol daily report automatically generated, making inspection data automatically, timely, accurate and timely reporting of storage, saving inspection data processing and report generation time and increase staff productivity and inspection accuracy.

[0006] 技术方案:一种支持多终端平台的水电站水工巡检系统,主要包括移动设备同步历史数据、移动设备采集水工巡检数据、移动设备上传最新巡检数据、PC端管理巡检数据并自动生成报表四个部分。 [0006] technical solutions: A support system inspection station hydraulic multi-terminal platforms, including mobile device synchronization historical data, mobile hydraulic equipment inspection data collection, mobile device to upload the latest inspection data, PC client management inspection data and automatically generate a report of four parts.

[0007] (I)移动终端巡检同步历史数据,其具体步骤如下: [0007] (I) synchronizing the mobile terminal inspection history data, and specific steps are as follows:

[0008] 步骤1:测试移动设备是否与PC计算机正确连接,如果正确连接,则进入步骤2;否贝IJ,进入步骤6; [0008] Step 1: Test mobile device is properly connected to a PC, if properly connected, the process proceeds to step 2; NO shell IJ, proceeds to step 6;

[0009] 步骤2:将巡检部位表、高程表、用户信息表、注意事项表的信息全部取出,保存成文件到指定目录下,文件名称为def.json,操作成功则进入步骤3,否则,进入步骤6 ; [0009] Step 2: The inspection site table, the elevation table, the user information table, information table of all precautions taken, saved as the file to the specified directory, the file name is def.json, successful operation proceeds to step 3, otherwise proceeds to step 6;

[0010] 步骤3:从巡检数据库中取出所有检查项目最近一次的记录,若巡检项目有η个,则生成相应的η个巡检记录文件,并保存到指定目录下,操作成功则进入步骤4,否则,进入步骤6; Once removed from the inspection database record of all test items recently, if a patrol projects η, η generating a corresponding inspection records file and save to the specified directory, the operation proceeds to successful: [0010] Step 3 step 4, otherwise, to step 6;

[0011] 步骤4:解析出导出的所有巡检部位的巡检时间,将所有对应时间文件夹下的文件从ftp服务器中下载到指定目录下,操作成功则进入步骤5,否则,进入步骤6; [0011] Step 4: parsing all derived patrol inspection site time, the time corresponding to the file folder all downloaded from the ftp server to the specified directory, the operation proceeds to step 5 is successful, otherwise, to step 6 ;

[0012] 步骤5:将指定文件夹中的所有数据均拷贝到移动终端中的指定目录中,操作成功,流程结束,否则,进入步骤6; [0012] Step 5: all of the data in the specified folder are copied to the mobile terminal in the specified directory, the operation is successful, the procedure ends, otherwise, to step 6;

[0013] 步骤6:记录错误日志并将出错提示信息发送给用户,结束流程。 [0013] Step 6: log errors and an error message sent to the user, the process ends.

[0014] (2)移动设备采集水工巡检数据,其具体步骤如下: [0014] (2) Hydraulic mobile device acquired inspection data, the specific steps are as follows:

[0015] 步骤1:用户使用移动设备登录移动端水工巡检系统软件,操作成功则进入步骤2,否则,进入步骤6; [0015] Step 1: the user using the mobile device moving end hydraulic log inspection system software, successful operation proceeds to step 2, otherwise, to step 6;

[0016] 步骤2:用户选择需要巡检的部位。 [0016] Step 2: The user selects the required inspection site. 根据小湾水工巡检任务的自身状况,设置了8个巡检部位。 According to their own situation Xiaowan Hydraulic inspection tasks, set up eight polling sites. 选择完成后进入步骤3; After selection proceeds to step 3;

[0017] 步骤3:确认和录入基本信息。 [0017] Step 3: Basic information entry and confirmation. 基本信息是指巡检时间、负责人、巡检人员和巡检记录员。 Basic information refers to the time of inspection, the person in charge, patrol officers and patrol recorder. 录入完成后进入步骤4; After completion of entry proceeds to step 4;

[0018] 步骤4:录入巡检环境量。 [0018] Step 4: the amount of entry inspection environment. 巡检环境量是指上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况。 Amount refers to the environment inspection upstream water level, the water level downstream, spillway, the rainfall, and discharge structures operation. 录入完成后进入步骤5 ; After completion of entry proceeds to step 5;

[0019] 步骤5:录入巡检过程信息。 [0019] Step 5: Process input inspection information. 选择需要巡检的具体部位,添加缺陷基本信息和多媒体信息。 Selecting a particular portion of the required inspection, adding basic defect information and multimedia information. 操作成功则可以退出系统; The operation is successful, you can withdraw from the system;

[0020] 步骤6:记录错误日志并将出错提示信息发送给用户,结束流程。 [0020] Step 6: log errors and an error message sent to the user, the process ends.

[0021] (3)移动设备上传最新数据,其具体步骤如下: [0021] (3) the mobile device to upload the latest data, the specific steps are as follows:

[0022] 步骤1:测试移动设备是否与PC计算机正确连接,如果正确连接,则进入步骤2;否贝IJ,进入步骤6; [0022] Step 1: Test mobile device is properly connected to a PC, if properly connected, the process proceeds to step 2; NO shell IJ, proceeds to step 6;

[0023] 步骤2:将移动设备存储卡中指定目录下所有文件均拷贝到PC计算机的指定盘符(如D盘)下的指定文件夹中,拷贝内容包括巡检属性数据文件及多媒体文件,拷贝操作成功则进入步骤3,否则,进入步骤6; [0023] Step 2: The mobile device memory card specified file specified directory files are all copied to the specified letter PC computer (e.g., D drive) under the folder, copying of contents including attribute data logging files and multimedia files, successful copy operation proceeds to step 3, otherwise, to step 6;

[0024] 步骤3:开始解析巡检属性数据,先将指定盘符文件夹目录下的所有文件内容进行循环遍历读取,这些文件中包含着巡检过程中产生的属性数据。 [0024] Step 3: patrol starts to parse the attribute data, the first letter of all the folders specified contents of the directory cycle through reading these files contain the attribute data generated during the inspection. 然后,根据水工巡检数据的数据库存储要求,将读取到上述各文件中的内容转化为json数据,再解析这些j son数据,并同时转化成标准的json数据,最终将属性数据解析入库,属性数据入库成功则进入步骤4,否则,进入步骤6; Then, according to the database storage requirements of hydraulic inspection data, the respective contents of the read file into json data, and then parse the data j son, and at the same time converted to standard json data, attribute data parsed into the final library, attribute data warehousing successfully proceed to step 4. otherwise, proceed to step 6;

[0025] 步骤4:开始解析多媒体数据,将指定盘符文件夹目录下的所有文件进行循环遍历解析,并将每个解析后的文件与多媒体数据库中存在的文件进行对比校验,若多媒体数据库中不存在该文件,则文件上传入库,否则,跳过该文件继续操作,直至所有文件操作过为止,多媒体数据入库成功则进入步骤5,否则,进入步骤6; [0025] Step 4: begin parsing the multimedia data, assign a drive letter to all the files in a folder directory cycle through parsing, checking and comparing after each parsing the multimedia file exist in the database file, if the multimedia database in the file does not exist, then the file upload storage, otherwise, skips the file operation continues until all files operated until the multimedia data storage successfully proceeds to step 5, otherwise, to step 6;

[0026] 步骤5:移动设备至PC端数据同步操作成功,向用户给出提示信息,流程结束; [0026] Step 5: the mobile device to the PC-side data synchronization operation is successful, prompt information to the user, the flow ends;

[0027] 步骤6:记录错误日志并将出错提示信息发送给用户,结束流程。 [0027] Step 6: log errors and error message information to the user, the process ends.

[0028] (4) PC端管理巡检数据并自动生成报表 [0028] (4) PC client management inspection data and automatically generate reports

[0029] PC端管理巡检数据具体功能可划分为巡检信息管理、缺陷管理、报表管理、用户权限管理、日志管理等五个部分。 [0029] PC client management data patrol inspection specific functions can be divided into management information, the defect five parts management, report management, user rights management, log management.

[0030] PC端自动生成报表具体步骤如下: [0030] PC terminal automatically generate reports the following steps:

[0031] 步骤I:报表标题录入。 [0031] Step I: report title entry. 查询此次巡检任务基本信息中的巡检时间、巡检部位,生成报表标题。 The query inspection time scanning task basic information, site inspection, report title. 格式为:YYYY-MM-DD XXXX部位巡检记录报表。 Format: YYYY-MM-DD XXXX site inspection records report.

[0032] 步骤2:报表标签录入。 [0032] Step 2: entry reporting labels. 报表标签由基本信息标签和环境变量标签组成。 Reports from the basic information label labels and environment variables tags. 查询此次巡检任务基本信息中的巡检负责人、巡检人员和巡检记录员,生成报表基本信息标签;查询此次巡检任务环境变量中的上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况,生成报表环境变量标签。 The person in charge of inquiries patrol inspection task basic information, patrol officers and members of inspection records, generate reports basic information on the label; the query upstream water level inspection task environment variables, downstream water level, flood situation, rain operation conditions and discharge structures, reporting environment variable labels.

[0033] 步骤3:报表段落标题录入。 [0033] Step 3: report entry section headings. 段落标题的个数根据主巡检部位的不同而不同。 Depending on the number of main section headings in different parts of the inspection. 段落标题由巡检状态和缺陷数目组成。 Section headings and number of defects from the inspection state composition. 巡检状态是指是否完成巡检,查询此次巡检任务中对应巡检部位的巡检状态和缺陷数目,生成段落标题,格式为:主巡检部位,巡检部位已处理(或者为:未处理)完成巡检未发现缺陷(或者为:存在η处缺陷)。 Refers to a state inspection is completed inspection, inspection status query and the number of defects corresponding to the scanning task inspection site, to generate the title paragraph format: main site inspection, inspection site treated (or of: untreated) No defect inspection is completed (or a: the presence of the defect η).

[0034] 步骤4:段落内容录入。 [0034] Step 4: Paragraph content entry. 段落内容是指当前巡检任务中对应巡检部位具体巡检结果。 Content refers to the current paragraph patrol inspection site specific task corresponding inspection results. 水工巡检系统中一般存在四类缺陷:渗漏,环境,裂缝、沉陷、变形,供排水系统。 Inspection System typically present hydraulic four defects: leakage, environmental, cracks, subsidence and deformation, for the drainage system. 查询每类缺陷存在的个数和描述信息,分别列举出来。 The number of queries and information describing each type of defect present, are enumerated.

[0035] 步骤5:段落多媒体数据录入。 [0035] Step 5: Paragraph multimedia data entry. 多媒体数据是指当前巡检任务中为描述对应巡检部位具体缺陷而使用移动设备拍摄的图片和视频。 It refers to multimedia data for the current scan job site specifically described in the corresponding defect inspection using a mobile device captured pictures and videos. 查询每类缺陷中存在的多媒体文件,以附件形式粘贴在对应巡检部位具体巡检结果缺陷描述之后。 Each defect class query multimedia files exist, then the corresponding attachment paste patrol inspection result of the defect site specifically described.

[0036] 有益效果:本发明提供的一种支持多终端平台的水工巡检系统,在每次水工巡检工作前,用户需要从PC端的数据库中下载最新的巡检数据至PDA中,用于用户本次巡检与上次巡检结果可以进行现场对比。 [0036] The beneficial effects: a platform for supporting multiple terminals hydraulic inspection system, before each hydraulic inspection work, the user needs to download the latest inspection data from the PC to the PDA database provided by the present invention, for the user that the last inspection and inspection results on-site comparison. 水工巡检过程中,用户可以使用PDA来记录水工巡检基本信息,由于PDA配置较好的拍照功能,可以使用其进行缺陷部位的拍照或者录像,使巡检信息更加生动全面。 Hydraulic inspection process, the user can use the PDA to record basic information about Hydraulic inspection, due to the configuration of PDA good camera, you can use it to take pictures or video for defective parts, making inspection more vivid and comprehensive information. 每次水工巡检完毕后,用户需要将此次巡检采集的数据上传至PC端的数据库中,用于对巡检信息进行管理、处理巡检问题跟踪、及水工安全分析报告等。 Hydraulic after each inspection is completed, the user will need to collect inspection data uploaded to the PC side of the database, for inspection information management, processing inspection issue tracking, and hydraulic safety analysis reports. PC端对移动终端采集到的巡检信息、缺陷信息以及报表进行管理,并自动根据采集的信息生成报表。 PC side to the mobile terminal information acquired inspection, defect management information, and reporting, and automatically generates reports based on the collected information. 本发明结合水工巡检业务的需求,有效地解决了传统水工巡检中所有数据需要手工记录、手动整理录入数据库和填写报表而带来的效率低、错误多等问题,可方便水工巡检基本数据、多媒体数据采集和记录、巡检日报表的自动生成,使得巡检数据能够自动、及时、准确入库和及时上报,节省巡检数据处理和报表生成时间,提高巡检人员工作效率和准确性。 The present invention combines the needs of hydraulic inspection services, effective solution to the traditional hydraulic inspection of all the data required to manually record low manually entered into the database sorting and filing reports brought efficiency, errors of many other issues, can be easily hydraulic basic inspection data, multimedia data acquisition and recording, the inspection date report generated automatically, so that the inspection data automatically, timely, accurate and timely reporting storage, data processing and save the inspection report generation time, to improve inspection personnel work efficiency and accuracy.

附图说明 BRIEF DESCRIPTION

[0037]图1是支持多终端平台的水电站水工巡检系统总体结构图; [0037] FIG. 1 is a hydraulic system polling station the overall structure of a multi-terminal support platform;

[0038]图2是支持多终端平台的水电站水工巡检系统移动设备下载历史数据流程图; [0038] FIG 2 is a hydraulic support multiple mobile inspection system station platform terminal download history data flow;

[0039]图3是支持多终端平台的水电站水工巡检系统移动设备采集水工巡检数据流程图; [0039] FIG. 3 is a hydraulic support system polling station mobile terminal platform hydraulic multiple inspection data flow collection;

[0040]图4是支持多终端平台的水电站水工巡检系统移动设备上传最新数据流程图。 [0040] FIG. 4 is a flowchart of a mobile device to upload the latest data hydraulic multi-station inspection system of the terminal support platform.

具体实施方式 detailed description

[0041]下面结合具体实施例,进一步阐明本发明,应理解这些实施例仅用于说明本发明而不用于限制本发明的范围,在阅读了本发明之后,本领域技术人员对本发明的各种等价形式的修改均落于本申请所附权利要求所限定的范围。 [0041] The following embodiments with reference to specific embodiments, further illustrate the present invention, it should be understood that these embodiments are illustrative only and the present invention is not intended to limit the scope of the present invention, after reading this disclosure, those skilled in the art of the various invention the modifications are equivalents fall within the present application as defined by the appended claims scope.

[0042]图1是本实施例的系统总体结构图。 [0042] FIG. 1 is a configuration diagram of the overall system of the present embodiment. 在本实施例中,移动设备(I3DA)在进行水电站水工巡检前需要从PC端下载最新的水工巡检数据,下载过程中会从ftp服务器将所有对应时间文件夹下的文件下载到PC端指定目录下,方便用户在每次巡检时获得上次巡检的结果信息,并可以与当前巡检现场情况进行比较,评判水工安全情况;移动设备完成水工巡检后,需要把最新的水工巡检数据上传到PC端,将移动设备中的巡检属性基本信息和多媒体数据信息导入到PC端中,通过对巡检数据的分类处理,可以将基本数据信息转化为数据对象,存入数据库,将多媒体数据存入多媒体数据库,可以有效管理巡检数据。 In the present embodiment, the mobile device (I3DA) carrying hydraulic need to download the latest inspection data from the PC before the hydraulic inspection station, all the file download process will correspond to the time of the file from a ftp server to download folder under the PC side specified directory, user-friendly information to obtain the results of the last inspection at each inspection, and can be compared with the current situation on-site inspection, evaluation of hydraulic security situation; the mobile device to complete hydraulic inspection is required Upload hydraulic latest inspection data to the PC, import inspection property mobile device's information and the multimedia data to the PC side by the sorting process of inspection data, basic data can be converted into data objects stored in the database, the multimedia data into a multimedia database, you can effectively manage inspection data.

[0043] 支持多终端平台的水电站水工巡检系统可以完成从移动设备信息采集水工巡检信息到巡检信息自动生成报表全过程的处理,下面将以“2014年9月11日,admin在巡检坝基排水廊道这一主巡检部位中的坝基主排水廊道(EL.959m)这一巡检部位发现距22坝段左10米存在微小渗漏”这一缺陷信息为例,对这个过程进行详细说明。 [0043] support multi-terminal platform system can complete the inspection of hydraulic station hydraulic inspection information gathering information from the mobile device to automatically generate inspection information report processing the whole process, the following will be "September 11, 2014, admin in the inspection dam foundation drainage gallery of the main polling site in the main dam foundation drainage gallery (EL.959m) the site inspection found 10 meters away from the left 22 there is a slight leakage dam, "the defect information, for example, this process is described in detail.

[0044]图2是支持多终端平台的水电站水工巡检系统移动设备下载历史数据流程图。 [0044] FIG 2 is a hydraulic support multiple mobile inspection system station platform terminal download history data flow. 该过程可以将历史数据下载到移动设备中,以便在巡检过程中查看之前是否存在类似缺陷,下面结合图2对移动终端下载历史数据方法进行详细说明。 The process historical data can be downloaded to the mobile device in order to see whether there is a similar defect in the inspection process prior to, in conjunction with FIG. 2 below download history data to the mobile terminal the method described in detail.

[0045] (SlOl)执行拷贝命令,将移动终端中预先存储的测试文件拷贝到PC端中指定路径; [0045] (SlOl) execute copy command, the mobile terminal pre-stored copy of the test file to the path specified in the PC;

[0046] (S102)查询PC端指定目录下是否存在测试文件,若存在,则说明移动终端与PC端连接正常,转入(S103);否则,说明移动终端与PC端连接存在问题,提示用户检查连接设备或数据连接线,转入(S109); [0046] query whether there is a test file under PC end (S102) the specified directory, if there is, then the mobile terminal and PC terminal is connected properly, turn (S103); otherwise, the problem is with the mobile terminal and PC connection, the user is prompted check the connection device or a data cable, transferred (S109);

[0047] (S103)删除PC端指定目录下的测试文件,防止对后续验证操作产生影响; [0047] (S103) test files in the specified directory PC side, prevent influence on the subsequent verification operation;

[0048] (S104)将PC端数据库表(巡检部位表、高程表、用户表、注意事项表)中的信息全部取出,存储在一个json文件中,并将此文件保存在指定目录下。 [0048] (S104) The information of the PC-side database table (table inspection site, the elevation table, a user table, note table) all removed json stored in a file, and save the file in the specified directory.

[0049] (S105)从数据库中取出所有巡检项目最近一次的记录,将属性信息封装成数据模型对象,再转化为json格式; A recording [0049] (S105) removed from the database for all inspection items recently, the attribute information of the package into a data model object, and then converted to json format;

[0050] (S106)循环获取导出的每个巡检部位的巡检时间,将其保存在一个HashSet中; [0050] (S106) of acquiring each loop portion derived patrol inspection time, which is stored in a the HashSet;

[0051] (S107)获取巡检时间结束后,循环遍历上述HashSet,将所有对应时间文件夹下的文件从ftp服务器中下载到tempFile/file目录下,每次下载的文件格式如下:文件夹以YYYY-MM-DD形式命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个一级目录,分别为image和video。 [0051] (S107) after time acquisition completion inspection, loop through HashSet above, the time corresponding to the file folder all downloaded from the ftp server to tempFile / file directory, each download file format is as follows: in a folder YYYY-MM-DD form name, date and time on behalf of multimedia files generated under each date folder contains two level directory, respectively, image and video. 其中image文件夹中保存该日期中产生的所有图片信息,video文件夹中保存该日期中产生的所有视频信息。 In which the image folder to save all the pictures of the date the information generated, video folder to save all the video information generated by that date.

[0052] (S108)执行文件的拷贝操作,将指定目录下的所有文件拷贝到移动设备中; Copying operation [0052] (S108) of executable file, all files in the specified directory are copied to the mobile device;

[0053] (S109)记录错误日志并将出错信息发送给用户。 [0053] (S109) log errors and error information to the user.

[0054]图3是支持多终端平台的水工巡检系统移动设备采集水工巡检数据流程图。 [0054] FIG. 3 is a hydraulic support multiple mobile inspection system of the terminal platform hydraulic inspection data flow collection. 下面结合图3对移动终端采集水工巡检数据方法进行详细说明。 Hydraulic inspection data collected following the method described in detail in conjunction with FIG. 3 to the mobile terminal.

[0055] (S201)用户根据系统提示输入用户名和密码; [0055] (S201) a user to enter a user name and password prompt system according to;

[0056] (S202)判断用户是否登陆成功;若登陆成功,则进入(S203)。 [0056] (S202) determines whether the user login is successful; if the login is successful, the process proceeds to (S203).

[0057] (S203)选择巡检部位,水工巡检系统可以根据自身情况设置需要巡检的部位,选择需要巡检的部位;比如,选择“坝基排水廊道”可以开始坝基排水廊道的巡检。 [0057] (S203) to select the site inspection, the inspection system can be provided hydraulic require inspection according to their locations, select inspection site; for example, select the "Foundation drainage gallery" start of drainage gallery Foundation inspection.

[0058] (S204)确定和录入基本信息,基本信息是指巡检时间、负责人、巡检人员和巡检记录员。 [0058] (S204) to determine the entry and basic information, basic information refers to the time of inspection, the person in charge, patrol officers and patrol recorder. 比如,巡检时间设置为2014年9月11日,负责人、巡检人员和巡检记录员选择admin。 For example, the inspection time is set to September 11, 2014, the person in charge, patrol officers and inspection records selects admin.

[0059] (S205)录入巡检环境量。 [0059] (S205) an amount of entry inspection environment. 巡检环境量是指上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况。 Amount refers to the environment inspection upstream water level, the water level downstream, spillway, the rainfall, and discharge structures operation. 根据实际情况设置上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况。 Disposed upstream water level according to the actual situation, the downstream water level, the flood discharge, the discharge structures rainfall and operation.

[0060] (S206)录入巡检过程信息。 [0060] (S206) inspection process input information. 选择需要巡检的具体部位,添加缺陷基本信息和多媒体信息。 Selecting a particular portion of the required inspection, adding basic defect information and multimedia information. 比如,选择“坝基主排水廊道(EL.959m) ”,开始巡检坝基主排水廊道(EL.959m),巡检过程中发现该巡检部位存在渗漏现象,添加缺陷信息“距22坝段左10米存在微小渗漏”,并拍摄图片和视频。 For example, select the "primary dam foundation drainage gallery (EL.959m)", start the main drain Foundation inspection gallery (EL.959m), found during inspection leakage inspection of the site, adding defect information "from 22 Monolith left 10 meters there is a slight leakage "and take pictures and video.

[0061] (S207)记录错误日志并将出错提示信息发送给用户,结束流程。 [0061] (S207) log errors and error message information to the user, the process ends.

[0062]图4是支持多终端平台的水电站水工巡检系统移动设备上传最新数据流程图。 [0062] FIG. 4 is a flowchart of a mobile device to upload the latest data hydraulic multi-station inspection system of the terminal support platform. 下面结合图4对移动终端上传最新数据方法进行详细说明。 Below in connection with FIG. 4 upload the latest data to the mobile terminal the method described in detail.

[0063] (S301)执行拷贝命令,将移动终端中预先存储的测试文件拷贝到PC端中指定路径; [0063] (S301) performs the copy command to copy the mobile terminal stored in advance in the test file to the path specified in the PC;

[0064] (S302)查询PC端指定目录下是否存在测试文件,若存在,则说明移动终端与PC端连接正常,转入(S303);否则,说明移动终端与PC端连接存在问题,提示用户检查连接设备或数据连接线,转入(S317); [0064] query whether there is a test file under PC end (S302) the specified directory, if there is, then the mobile terminal and PC terminal is connected properly, turn (S303); otherwise, the problem is with the mobile terminal and PC connection, the user is prompted check the connection device or a data cable, transferred (S317);

[0065] (S303)删除PC端指定目录下的测试文件,防止对后续验证操作产生影响。 [0065] (S303) test files in the specified directory PC side, prevent influence on the subsequent verification operation.

[0066] (S304)执行拷贝命令,将移动终端中指定目录的所有文件拷贝到PC端指定目录下。 [0066] (S304) performs the copy command to copy all files in the specified directory of the mobile terminal to the PC in the current directory. 在指定目录中,所有巡检属性数据信息保存在PC端指定文件夹中,其中所有文件均以“数字.json”的格式命名,其中数字代表文件保存的巡检部位编号,每个json文件保存了某巡检部位的所有巡检属性数据信息。 In the specified directory, all inspection data attribute information stored in the PC end of the specified folder, where all documents are "Digital .json" naming format, which represents the preservation of digital file inspection site number, each file is saved json the inspection of a site inspection of all property data.

[0067]多媒体信息包含照片和视频文件,按照生成日期进行分类存储,多媒体文件保存在指定文件夹中,文件夹下一级目录以日期命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个一级目录,分别为image和video,其中image文件夹中保存该日期中产生的所有图片信息,video文件夹中保存该日期中产生的所有视频信息。 [0067] multimedia messages containing photos and video files, creation date are classified according to storage, multimedia files saved in the specified folder, a folder named catalog to date, represents the date and time of multimedia files generated each date folder under that contains two-level directory, respectively, image and video, in which the image folder to save all the pictures of the date the information generated, video folder to save all the video information generated by that date.

[0068] (S305)判断拷贝操作是否成功,成功则继续,转入(S306);否则,失败,转入(S317)并报错。 [0068] (S305) determines whether the copy operation is successful, success continues, transferred (S306); otherwise, the failure transferred (S317) and error.

[0069] (S306)解析巡检属性数据入库。 [0069] (S306) attribute data warehousing analytic inspection. 巡检属性数据是指巡检属性数据信息,包括巡检部位表、高程表、用户信息表、注意事项表。 Patrol inspection data refers to the attribute information of the attribute data, including site inspection table, the elevation table, the user information table, footnote. 将文件夹目录下的所有文件的文件路径循环获取,并存放在命名为List_fileName的List文件中通过该List文件可以查询到所有属性数据信息文件的路径信息。 The file paths of all the files in the folder directory cycle acquired and stored in a file named List_fileName List of all the properties that can be queried by the data file List file path information.

[0070] (S307)循环遍历Li st_f i IeName文件,依次读取文件内容并转化为j son格式的文件,解析过程是通过将每个文件的数据内容进行json标准化操作。 [0070] (S307) Loop through Li st_f i IeName file, and sequentially reads the contents of the file into a file format j son, parsing process is carried out by the standard operating json data contents of each file.

[0071] (S308)将进行过json标准化操作的巡检属性数据按照模型对象结构转化为数据模型对象,并保存成一个用于存储数据模型对象命名为List_dataModel的List文件中。 [0071] (S308) The attribute data subjected to inspection in accordance with standard operating json structure into a model object data model object, and save it as a model for storing data of the object is named List_dataModel List file.

[0072] (S309)循环遍历List_dataModel.1 ist文件,将文件中的属性数据存入属性信息数据库中。 [0072] (S309) Loop through List_dataModel.1 ist file, file attribute data in the attribute information stored in the database.

[0073] (S310)解析数据模型对象中的结果表数据,存入属性信息数据库。 [0073] The results of table data (S310) analysis data model object, the attribute information stored in the database. 结果表中存储着水工巡检的结果数据,命名为ResultList。 Results Table hydraulic inspection result data stored in the named ResultList.

[0074] (S311)结果表ResultList中的所有记录均关联上述存入的属性信息数据库记录。 [0074] (S311) The results of all records in the table are ResultList attribute information database record associated with the above-described deposited. 关联关系通过生成Map文件的方式建立。 Association established by way of generating Map file.

[0075] 存入过程中,生成一个Map文件,命名为Map_result,用于记录结果表中图片信息和其对应在数据库的编号,其key为数据模型对象中结果对象的id编号,其value为对应结果对象在数据库中的id编号。 [0075] stored in the process, generates a Map file named Map_result, for recording image information in the result table in the database and its corresponding number, which is a key object data model result object id number, which is a value corresponding to the result object id number in the database.

[0076] 将数据模型对象中的巡检图片表数据进行解析,存入属性数据库;在存入过程中,生成一个Map文件,将其命名为Map_image,其key为数据模型对象中图片对象的id编号,其value为对应图片对象在数据库中的id编号。 [0076] The inspection data model object image table data for parsing, stored in attribute database; stored in the process, generates a Map file names it Map_image, which is a key object data model id object image No, its value to the corresponding picture object id number in the database.

[0077] 将数据模型对象中的结果与图片对应表的数据进行解析,结合Map_resul t及Map_image,将图片数据转化为实际数据库表中的对应关系,最终存入属性数据库。 [0077] The model object data result analyzing image correspondence table, and binding Map_resul t Map_image, the image data is converted to the corresponding relationship between the actual database tables, the database attributes stored in the final.

[0078]同样的,对于视频数据的处理过程与上面相同。 [0078] Similarly, for the processing of video data the same as above. 将数据模型对象中的结果与视频对应表的数据进行解析,结合Map_result及Map_video,将数据转化为实际数据库表中的对应关系,最终存入属性数据库。 The data results with the model object table corresponding to the video parsing, and binding Map_result Map_video, the data is converted to the corresponding relationship between the actual database tables, the database attributes stored in the final.

[0079]上述过程均结束后,一个部位的所有巡检信息完整入库,循环遍历所有数据模型对象,将所有部位的巡检信息入库后,巡检属性数据入库操作结束。 After [0079] the above-described processes are completed, all the information is complete inspection of a storage site, loops through all the data model object, after the inspection of all parts of information storage, the attribute data storage patrol operation ends.

[0080] (S312)解析多媒体数据入库。 [0080] (S312) parsing multimedia data storage. 解析多媒体数据,将指定文件夹目录下的所有文件进行循环遍历解析,该文件夹目录下包含多个文件夹,以YYYY-MM-DD命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个目录,分别为image和video。 Parsing the multimedia data, all the files in the specified folder directory cycle through parsing, the folder comprising a plurality of directory folder to YYYY-MM-DD name, date and time on behalf of multimedia files generated, each date folder under that contains two directories, respectively, image and video.

[0081] (S313)解析过程中,比较多媒体数据文件夹目录下的多媒体数据文件和多媒体数据库中存在的文件。 [0081] (S313) the resolution process, the multimedia data comparison multimedia data file folders and files under the directory that exist in the multimedia database.

[0082] (S314)判断多媒体数据库中是否存在该文件,若存在,则转入(S315),否则,转入 [0082] (S314) determines whether the file exists in the multimedia database, if present, the process proceeds to (S315), otherwise, proceeds

(S316) ο (S316) ο

[0083] (S315)判断是否已经将所有文件上传完成,若已执行完所有文件,则此模块结束;否则,转入(S316)。 [0083] (S315) to determine whether all files uploaded, Ruoyi complete implementation of all the files, this module ends; otherwise transferred (S316).

[0084] (S316)文件通过移动终端上传入库,采用ftp文件上传的方式将多媒体文件上传至多媒体数据库。 [0084] (S316) the mobile terminal storage file upload, by way of ftp file upload multimedia files will be uploaded to a multimedia database.

[0085] (S317)记录错误日志并将出错信息发送给用户。 [0085] (S317) log errors and error information to the user.

[0086]图5是基于多终端平台的水电站水工巡检系统PC端自动生成报表流程图。 [0086] FIG. 5 is a flowchart illustrating a multi-terminal platform report hydraulic station inspection system automatically generated based on the PC side. 下面结合图5对PC端自动生成报表方法进行详细说明。 The method of automatically generate reports following detailed description in conjunction with FIG. 5 PC side.

[0087] 通过移动设备采集水工巡检信息和移动设备上传最新巡检数据,水工巡检系统中已经存储了最新的水工巡检数据,包括水工巡检基本数据和多媒体数据。 [0087] collected by a mobile device and mobile hydraulic equipment inspection information upload the latest inspection data, already stored hydraulic inspection system hydraulic latest inspection data, including multimedia data and the hydraulic data base inspection. PC端自动生成报表可以将这些数据以直观报表形式进行展示,报表展示的内容来源于移动设备采集到的数据。 The PC can automatically generate reports such data will be displayed in a visual form of the report, the report contents display data from the mobile device collected. 下面将以移动设备巡检过程中发现的“2014年9月11日,admin在巡检坝基排水廊道这一主巡检部位中的坝基主排水廊道(EL.959m)这一巡检部位发现距22坝段左10米存在微小渗漏”这一缺陷信息为例讲解自动生成报表的过程。 The following will move the main foundation drainage gallery "September 11, 2014, admin foundation drainage gallery in the inspection of the main parts of the inspection equipment inspection process found in (EL.959m) the inspection site 10 m from the left found the presence of 22 micro-dam leakage "this defect information as an example to explain the process to automatically generate the report. 数据录入采用多级控制的方式,在每次录入信息后都对此次录入的信息是否成功进行判断,确保自动生成的报表信息无遗漏。 Data entry using multi-level control of the way, all the information entered by the judge success after each entry information to ensure the automatically generated report information without omission.

[0088] (S401)报表标题录入。 [0088] (S401) report title entry. 查询此次巡检任务基本信息中的巡检时间、巡检部位,生成报表标题。 The query inspection time scanning task basic information, site inspection, report title. 格式为:YYYY-MM-DD XXXX部位巡检记录报表;如:2014-09-11坝基排水廊道部位巡检记录报表 Format: YYYY-MM-DD XXXX site inspection record report; as: 2014-09-11 Foundation drainage gallery site inspection records report

[0089] (S402)判断报表标题是否录入成功,若成功,则进入(403),若不成功,则返回(S401); [0089] (S402) to determine whether the report title entry is successful, if successful, the (403), if successful, returns (S401);

[0090] (S403)报表标签录入。 [0090] (S403) reporting label entry. 报表标签由基本信息标签和环境变量标签组成。 Reports from the basic information label labels and environment variables tags. 查询此次巡检任务基本信息中的巡检负责人、巡检人员和巡检记录员,生成报表基本信息标签;查询此次巡检任务环境变量中的上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况,生成报表环境变量标签;本例中,基本信息标签为:巡检负责人:admin巡检人员:admin巡检记录员:admin环境变量标签为:上游水位(m):1205.63下游水位(m):996.12泄洪情况(m3/s): 0.00降雨情况(mm): 0.00泄水建筑物运行情况:无运行。 The person in charge of inquiries patrol inspection task basic information, patrol officers and members of inspection records, generate reports basic information on the label; the query upstream water level inspection task environment variables, downstream water level, flood situation, rain discharge structures and operation situation, reporting environment variable tag; in the present embodiment, basic information tagged as: inspection Leader: admin inspection personnel: admin inspection recorder: admin tagged as environment variables: the upstream water level (m ): 1205.63 downstream water level (m): 996.12 Spillway case (m3 / s): 0.00 rainfall (mm): 0.00 Discharge structure operation: no operation.

[0091] (S404)判断报表标签是否录入成功,若成功,进入(S405),若不成功,则返回 [0091] (S404) determines whether the tag reports successful entry, if successful, to enter (S405), if successful, returns

(S403); (S403);

[0092] (S405)报表段落标题录入。 [0092] (S405) reports section headings entry. 段落标题的个数根据主巡检部位的不同而不同。 Depending on the number of main section headings in different parts of the inspection. 段落标题由巡检状态和缺陷数目组成。 Section headings and number of defects from the inspection state composition. 巡检状态是指是否完成巡检,查询此次巡检任务中对应巡检部位的巡检状态和缺陷数目,生成段落标题,格式为:主巡检部位,巡检部位已(或者为:未)完成巡检未发现缺陷(或者为:存在η处缺陷)。 Refers to a state inspection inspection is completed, the number of queries the inspection and a defect inspection task state corresponding inspection site, to generate the title paragraph format: main site inspection, inspection site has been (or is: Not ) to complete the inspection No defects found (or a: the presence of a defect η). 本例中,描述坝基排水廊道中的坝基主排水廊道(EL.959m)已完成巡检并发现缺陷的报表段落标题为:坝基排水廊道坝基主排水廊道(EL.959m)已完成巡检发现I处缺陷。 In the present embodiment, the main drainage gallery described Dam Foundation in drainage gallery (EL.959m) and completed inspection report found defects was Paragraph Titles: a main drainage Foundation Foundation drainage gallery gallery (EL.959m) patrol completed I found that the defect detection.

[0093] (S406)判断段落标题是否录入成功。 [0093] (S406) determines whether the entry section headings successful. 若录入成功,进入(S407),若不成功,则返回 If successful entry into (S407), if it succeeds, returns

(S405); (S405);

[0094] (S407)段落内容录入。 [0094] (S407) the contents of the paragraph entry. 段落内容是指当前巡检任务中对应巡检部位具体巡检结果。 Content refers to the current paragraph patrol inspection site specific task corresponding inspection results. 水工巡检系统中一般存在四类缺陷:渗漏,环境,裂缝、沉陷、变形,供排水系统。 Inspection System typically present hydraulic four defects: leakage, environmental, cracks, subsidence and deformation, for the drainage system. 查询每类缺陷存在的个数和描述信息,分别列举出来。 The number of queries and information describing each type of defect present, are enumerated. 本例中,描述坝基排水廊道中的坝基主排水廊道(EL.959m)存在I处渗漏缺陷的段落内容如下:坝基主排水廊道(EL.959m)存在渗漏缺陷I处,具体描述为“距22坝段左10米存在微小渗漏”。 In the present embodiment, the main drainage gallery described Dam Foundation in drainage gallery (EL.959m) is present at contents of paragraphs I leakage defects as follows: the presence of the main drain gallery Foundation (EL.959m) at I leakage defects, specifically described as "left 10 meters away from the dam 22 there is a slight leak."

[0095] (S408)判断段落内容是否录入成功。 [0095] (S408) determines whether the contents of the paragraph entry success. 若录入成功,进入(S409),若不成功,则返回 If successful entry into (S409), if it succeeds, returns

(S407); (S407);

[0096] (S409)段落多媒体数据录入。 [0096] (S409) paragraph multimedia data entry. 多媒体数据是指当前巡检任务中为描述对应巡检部位具体缺陷而使用移动设备拍摄的图片和视频。 It refers to multimedia data for the current scan job site specifically described in the corresponding defect inspection using a mobile device captured pictures and videos. 查询每类缺陷中存在的多媒体文件,以附件形式粘贴在对应巡检部位具体巡检结果缺陷描述之后。 Each defect class query multimedia files exist, then the corresponding attachment paste patrol inspection result of the defect site specifically described. 本例中,移动设备采集水工巡检数据时对发现的缺陷信息拍摄了图片和视频,查询可知,图片命名为:201409110101.jpg,视频命名为201409110102.avi。 In this example, the mobile device when collecting data on hydraulic inspection defect information found shot pictures and videos, queries can be seen, the picture is named: 201409110101.jpg, video named 201409110102.avi. 对多媒体数据的描述如下:现场对渗漏现场进行了拍摄,图片文件名为:201409110101.jpg,视频文件名为201409110102.avi。 A description of the multimedia data is as follows: the scene of the leak site has been taken, the picture file is named: 201409110101.jpg, video file named 201409110102.avi. 并将这两个附件附在报表最后,可以完成对这个缺陷信息的描述。 These two statements and annexed Finally, to complete the description of the defect information.

[0097] (S410)判断段落内容是否录入成功。 [0097] (S410) determines whether the contents of the paragraph entry success. 若录入成功,则结束,若不成功,则返回 If the entry is successful, the end, if successful, returns

(S409)ο (S409) ο

[0098] 本例中,移动设备采集水工巡检数据时发现的“2014年9月11日,admin在巡检坝基排水廊道这一主巡检部位中的坝基主排水廊道(EL.959m)这一巡检部位发现距22坝段左10米存在微小渗漏”这一缺陷信息,在上传到PC端并由PC端进行自动报表生成后得到的描述信息如下: In [0098] this embodiment, the hydraulic inspection data collected found mobile device, "September 11, 2014, in the inspection ADMIN Dam Foundation drain the main drain gallery (EL corridor of the main portion of the inspection. 959m) the inspection site found from the left 10 meters a minute leakage dam 22 is present, "the defect information, the information described in the PC after uploading to the PC by the end of automatic report generation are as follows:

[0099] 标题:2014-09-11坝基排水廊道部位巡检记录报表 [0099] Title: 2014-09-11 foundation drainage gallery site inspection records report

[0100] 基本信息标签:巡检负责人:admin巡检人员:admin巡检记录员:admin [0100] Basic Information tab: Patrol Leader: admin Patrol officers: admin inspection Recorder: admin

[0101] 环境变量标签:上游水位(m): 1205.63下游水位(m):996.12泄洪情况(m3/s):0.00降雨情况(mm): 0.00泄水建筑物运行情况:无运行 [0101] Tags environment variables: the upstream water level (m): 1205.63 downstream water level (m): 996.12 Spillway case (m3 / s): 0.00 rainfall (mm): 0.00 Discharge Structure Operation: No operation

[0102] 段落标题1:坝基排水廊道坝基主排水廊道(EL.959m)已完成巡检发现I处缺陷 [0102] The title paragraph 1: Foundation Foundation drainage gallery main drain gallery (EL.959m) defect inspection has been completed at the I found

[0103] 段落I内容:坝基主排水廊道(EL.959m)存在渗漏缺陷I处,具体描述为“距22坝段左10米存在微小渗漏” O现场对渗漏现场进行了拍摄,图片文件名为:201409110101.jpg,视频文件名为201409110102.avi。 [0103] SUMMARY Paragraph I: Foundation main drain gallery (EL.959m) I there is a leak at the defect, specifically described as "left 10 meters from the dam 22 there is a slight leak" O leakage field of the shooting scene, Image file named: 201409110101.jpg, video file named 201409110102.avi.

[0104] …… [0104] ......

[0105]附件 1:201409110101.jpg [0105] Annex 1: 201409110101.jpg

[0106]附件 2:201409110102.avi。 [0106] Annex 2: 201409110102.avi.

Claims (2)

  1. 1.一种支持多终端平台的水电站水工巡检数据同步和数据管理方法,其特征在于,其主要包括: (1)移动设备同步历史数据; (2)移动设备采集水工巡检数据; (3)移动设备上传最新巡检数据; (4) PC端管理巡检数据并自动生成报表; 所述步骤I中,移动设备同步历史数据是指从PC端下载最新的水工巡检数据至移动终端,其具体步骤为: (1.0测试移动终端与PC端是否正确连接; (1.2)将需要导出的数据库表巡检信息放入json文件中; (1.3)查找出数据库中最近一次巡检记录,生成巡检记录j son文件; (1.4)解析巡检时间,将对应时间文件夹下的文件下载到指定目录; (1.5)将最近一次巡检数据拷贝到移动终端中; 移动终端下载历史数据方法为: (5101)执行拷贝命令,将移动终端中预先存储的测试文件拷贝到PC端中指定路径; (5102)查询PC端指定目录下是否存在测试文件,若存 A hydraulic support multi-terminal platform inspection station data synchronization and data management method, characterized in that it includes: (1) historical data synchronous mobile device; (2) a mobile device to capture hydraulic inspection data; (3) the mobile device uploads the latest inspection data; (. 4) to inspect the data management PC side and automatically generate a report; step I, the mobile device synchronization history data hydraulic means to download the latest inspection data from the PC to the end mobile terminal, including the following steps: (1.0 test mobile terminal is properly connected with the PC side; (1.2) the need to export the information into a database table inspection json file; (1.3) to find out the last inspection records database , j son file generating inspection records; (1.4) analytical inspection time, the time corresponding to the folder in the downloaded file to the specified directory; (1.5) the most recent copy of the inspection data to the mobile terminal; the mobile terminal to download history data method: (5101) performs the copy command to copy the mobile terminal stored in advance in the test file to the path specified in the PC; (5102) Discover the PC file specifies whether there is a test directory, if the deposit ,则说明移动终端与PC端连接正常,转入S103;否则,说明移动终端与PC端连接存在问题,提示用户检查连接设备或数据连接线,转入S109; (5103)删除PC端指定目录下的测试文件,防止对后续验证操作产生影响; (5104)将PC端数据库表中的信息全部取出,存储在一个json文件中,并将此文件保存在指定目录下; (5105)从数据库中取出所有巡检项目最近一次的记录,将属性信息封装成数据模型对象,再转化为json格式; (5106)循环获取导出的每个巡检部位的巡检时间,将其保存在一个HashSet中; (5107)获取巡检时间结束后,循环遍历上述HashSet,将所有对应时间文件夹下的文件从ftp服务器中下载到tempFile/file目录下,每次下载的文件格式如下:文件夹以YYYY-MM-DD形式命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个一级目录,分别为image和video;其中image , Then the mobile terminal and the PC is connected, into S103; otherwise, there is an issue of the mobile terminal and the PC connection terminal, prompting the user to check the connection device or data cable into S109; (5103) to delete the specified directory the PC test file, prevent influence on the subsequent verification operation; (5104) PC terminal information database table all removed, stored in a json file and save the file in the specified directory; (5105) from the database a record of all recent inspection items, the attribute information into the data model object, and then converted to the format json; (5106) takes each loop portion derived patrol inspection time, save it in a HashSet; and ( 5107) acquired after the inspection time, the above-described loop iterates HashSet, all file folder corresponding to the time downloaded from the ftp server to tempFile / file directory, each download file format is as follows: the folder in YYYY-MM- DD form name, date and time on behalf of multimedia files generated under each date folder, a directory comprising two, respectively, and Video image; wherein the image 件夹中保存该日期中产生的所有图片信息,video文件夹中保存该日期中产生的所有视频信息; (5108)执行文件的拷贝操作,将指定目录下的所有文件拷贝到移动设备中; (5109)记录错误日志并将出错信息发送给用户; 所述步骤2中,移动设备采集水工巡检数据是指使用移动终端采集水工巡检系统数据,水工巡检系统数据主要是指:巡检用户信息、巡检部位、巡检基本信息、环境量和缺陷信息;其具体步骤为: (2.1)用户登录; (2.2)选择巡检部位; (2.3)确认和录入基本信息; (2.4)录入环境量信息; (2.5)录入缺陷信息和数据上传; 所述步骤3中,移动设备上传最新巡检数据是指将移动设备中的水工巡检数据信息导入到PC端和服务器中;其具体步骤为: (3.1)测试移动终端是否与PC端正确连接; (3.2)将移动终端中指定目录下文件拷贝到PC端指定文件夹中; (3.3)解析巡检 Folder to save all the pictures for date generated to save all the video information of the date generated folder video files; copy operation (5108) executable file, all files in the specified directory are copied to the mobile device; ( 5109) log errors and error information to the user; in the step 2, the mobile device to capture the hydraulic inspection data acquisition using a mobile terminal refers to a hydraulic inspection system data, hydraulic system data mainly refers inspection: user information inspection, parts inspection, inspection basic information, and defect information of the environment; including the following steps: (2.1) a user login; (2.2) selecting inspection site; (2.3) and to confirm basic information entry; (2.4 ) environmental amount information entry; (2.5) input defect information and data upload; step 3, the mobile device uploads the latest inspection data refers to the introduction of hydraulic inspection data information to the mobile device and the PC server; including the following steps: (3.1) a test mobile terminal is properly connected to the PC; (3.2) to the mobile terminal copies the file to the specified directory in the PC specified folder; (3.3) analytical inspection 属性数据,将巡检属性数据解析入库; (3.4)解析巡检多媒体数据,通过与巡检多媒体数据库中存在的文件进行对比校验,将不存在的文件上传入库; 移动终端上传最新数据方法为: (5301)执行拷贝命令,将移动终端中预先存储的测试文件拷贝到PC端中指定路径; (5302)查询PC端指定目录下是否存在测试文件,若存在,则说明移动终端与PC端连接正常,转入S303;否则,说明移动终端与PC端连接存在问题,提示用户检查连接设备或数据连接线,转入S317; (5303)删除PC端指定目录下的测试文件,防止对后续验证操作产生影响; (5304)执行拷贝命令,将移动终端中指定目录的所有文件拷贝到PC端指定目录下;在指定目录中,所有巡检属性数据信息保存在PC端指定文件夹中,其中所有文件均以“数字.json”的格式命名,其中数字代表文件保存的巡检部位编号,每个json文件 Attribute data, parse the data storage property inspection; (3.4) analytical inspection multimedia data file by comparing the checksum present in the multimedia database inspection, there will be no storage file upload; mobile terminal to upload the latest data method: (5301) performs the copy command to copy the mobile terminal stored in advance in the test file to the PC path specified; (5302) Discover the PC specifies whether there is a test file directory, if present, then the mobile terminal and the PC end of the connection is normal, proceeds to S303; otherwise, there is an issue of the mobile terminal and the PC connection terminal, prompting the user to check the connection device or data cable into S317; (5303) to delete the specified test the PC file in the directory, to prevent subsequent verification operation impact; (5304) performs the copy command to copy all files in the specified directory of the mobile terminal to the specified directory to the PC terminal; in the specified directory, the attribute data of all inspection information stored in the specified folder in the PC side, wherein All files are "digital .json" naming format, which represents the digital files saved polling site number, each json file 存了某巡检部位的所有巡检属性数据信息; 多媒体信息包含照片和视频文件,按照生成日期进行分类存储,多媒体文件保存在指定文件夹中,文件夹下一级目录以日期命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个一级目录,分别为image和video,其中image文件夹中保存该日期中产生的所有图片信息,video文件夹中保存该日期中产生的所有视频信息; (5305)判断拷贝操作是否成功,成功则继续,转入S306;否则,失败,转入S317并报错; (5306)解析巡检属性数据入库;巡检属性数据是指巡检属性数据信息,包括巡检部位表、高程表、用户信息表、注意事项表;将文件夹目录下的所有文件的文件路径循环获取,并存放在命名为List_fi IeName的List文件中通过该Li st文件可以查询到所有属性数据信息文件的路径信息; (5307)循环遍历List_f i IeName文件 Keep a certain part of the inspection all inspection data attribute information; multimedia information includes photos and video files, creation date are classified according to storage, multimedia files saved in the specified folder, a folder named catalog to date, on behalf of multimedia date and time the file generated under each date folder contains two level directory, respectively, image and video, in which the image folder to save all the pictures of the date the information generated, video folder generated in save the date All video information; (5305) determines whether the copy operation is successful, the success continues into S306; otherwise, failure, error and proceeds to S317; (5306) attribute data warehousing analytic inspection; attribute data refers to patrol inspection attribute information of the subject data, comprising inspection site table, the elevation table, the user information table, table considerations; the path of all files under the file directory of folders acquisition cycles, and stored in a named file List_fi IeName the List by the Li st file can query all the file attribute information of the data path information; (5307) loops through the file List_f i IeName 依次读取文件内容并转化为j son格式的文件,解析过程是通过将每个文件的数据内容进行json标准化操作; (5308)将进行过json标准化操作的巡检属性数据按照模型对象结构转化为数据模型对象,并保存成一个用于存储数据模型对象命名为List_dataModel的List文件中; (5309)循环遍历List_dataModel.list文件,将文件中的属性数据存入属性信息数据库中; (5310)解析数据模型对象中的结果表数据,存入属性信息数据库;结果表中存储着水工巡检的结果数据,命名为ResultList; (5311)结果表ResultList中的所有记录均关联上述存入的属性信息数据库记录;关联关系通过生成Map文件的方式建立; 存入过程中,生成一个Map文件,命名为Map_result,用于记录结果表中图片信息和其对应在数据库的编号,其key为数据模型对象中结果对象的id编号,其value为对应结果对象在数据库中的id编 And sequentially reads the contents of the file into a file format j son, parsing process is carried out by the standard operating json data contents of each file; (5308) will be over-normalized json patrol operation attribute data structure according to the model object into data model object, and save it as a model for storing data objects named List_dataModel List of documents; (5309) loop through List_dataModel.list file, the attribute data stored in the file attribute information database; (5310) analytical data the results of the model object table data, stored in the attribute information database; results table stored in the inspection result data hydraulic named resultList; (5311) results of all records in the table are related resultlist attribute information database stored in the above-described record; relationship established by way of generating a Map file; into the process, generates a Map file named Map_result, for recording image information in the result table in the database and its corresponding number, which is a key object data model results object id number, which corresponds to the result object id value is programmed in the database ; 将数据模型对象中的巡检图片表数据进行解析,存入属性数据库;在存入过程中,生成一个Map文件,将其命名为Map_image,其key为数据模型对象中图片对象的id编号,其value为对应图片对象在数据库中的id编号; 将数据模型对象中的结果与图片对应表的数据进行解析,结合Map_resul t及Map_image,将图片数据转化为实际数据库表中的对应关系,最终存入属性数据库; 同样的,对于视频数据的处理过程与上面相同;将数据模型对象中的结果与视频对应表的数据进行解析,结合Map_resul t及Map_video,将数据转化为实际数据库表中的对应关系,最终存入属性数据库; 上述过程均结束后,一个部位的所有巡检信息完整入库,循环遍历所有数据模型对象,将所有部位的巡检信息入库后,巡检属性数据入库操作结束; (5312)解析多媒体数据入库;解析多媒体数据,将指定 ; The inspection table picture data model object is parsed into property database; in the deposit process, generate a Map file will be named Map_image, which is key for the data model object id number of objects in the picture, whose value is the corresponding picture object id number in the database; the data model object result image correspondence table parsing binding Map_resul t and Map_image, the image data is converted to the corresponding relationship between the actual database tables, the final deposit the attribute database; Similarly, for the processing of video data is the same as above; the data result data model object video correspondence table parsing binding Map_resul t and Map_video, the data is converted to the corresponding relationship between the actual database table finally stored attribute database; after the above processes are completed, all the parts of a complete inspection information storage loops through all of the data model object, after the inspection of all parts of information storage, the attribute data storage operation ends patrol ; (5312) parsing the multimedia data storage; parsing the multimedia data, specified 件夹目录下的所有文件进行循环遍历解析,该文件夹目录下包含多个文件夹,以YYYY-MM-DD命名,代表多媒体文件产生的日期时间,每个日期文件夹下,包含两个目录,分别为image和video; (5313)解析过程中,比较多媒体数据文件夹目录下的多媒体数据文件和多媒体数据库中存在的文件; (5314)判断多媒体数据库中是否存在该文件,若存在,则转入S315,否则,转入S316; (5315)判断是否已经将所有文件上传完成,若已执行完所有文件,则此模块结束;否则,转入S316; (5316)文件通过移动终端上传入库,采用ftp文件上传的方式将多媒体文件上传至多媒体数据库; (5317)记录错误日志并将出错信息发送给用户。 All files in a folder directory cycle through parsing, the folder comprising a plurality of directory folder to YYYY-MM-DD name, date and time on behalf of multimedia files generated under each date folder, comprising two directories , respectively, image, and video; (5313) parsing process, the multimedia data file in the comparison multimedia data folder directory and display the database file exists; (5314) the presence of the document is determined multimedia database, if present, is transferred the S315, otherwise proceeds to S316; (5315) determines whether all files uploaded, Ruoyi finished performing all file, then the module ends; otherwise, proceeds to S316; (5316) by the mobile terminal to upload the file storage, by way of ftp file upload multimedia files will be uploaded to the multimedia database; (5317) log errors and error information to the user.
  2. 2.根据权利要求1所述的一种支持多终端平台的水电站水工巡检数据同步和数据管理方法,其特征在于,所述步骤4中,PC端管理巡检数据是指基于B/S架构的水工巡检系统,对移动终端采集到的巡检信息、缺陷信息以及报表、用户权限和日志进行管理;PC端自动生成报表是指将分类处理的巡检信息、缺陷信息数据按照一定格式自动生成为上报的报表;其中PC端自动生成报表的具体步骤为: (5.1)报表标题录入; (5.2)报表标签录入; (5.3)报表段落标题录入; (5.4)段落内容录入; (5.5)段落多媒体数据录入; 具体步骤为: (5401)报表标题录入;查询此次巡检任务基本信息中的巡检时间、巡检部位,生成报表标题;格式为:YYYY-MM-DD XXXX部位巡检记录报表; (5402)判断报表标题是否录入成功,若成功,则进入403,若不成功,则返回(S401); (5403)报表标签录入;报表标签由基本信息标 According to one of the claims 1 to support multi-terminal platform hydraulic inspection station data synchronization and data management method, wherein, in the step 4, PC client management means based on the inspection data B / S architecture hydraulic inspection system, the mobile terminal information acquired inspection, defect information, and reporting, and user permissions management log; end of the PC automatically generate reports information classification means to the inspection process, the information data according to a certain defect format is automatically generated as reported by the report; specific steps where the PC automatically generate reports as follows: (5.1) report title entry; (5.2) reporting labels entry; (5.3) report section headings entry; (5.4) paragraph is entered; (5.5 ) multimedia data entry passage; specific steps: (5401) report title entry; query the inspection time scanning task basic information, inspection site, report title; format: YYYY-MM-DD XXXX portion patrol subject record report; (5402) determines whether the entry of the title report success, if successful, the process proceeds to 403, if successful, returns (S401); (5403) report entry tag; standard reporting labels the basic information 和环境变量标签组成;查询此次巡检任务基本信息中的巡检负责人、巡检人员和巡检记录员,生成报表基本信息标签;查询此次巡检任务环境变量中的上游水位、下游水位、泄洪情况、降雨情况和泄水建筑物运行情况,生成报表环境变量标签; (5404)判断报表标签是否录入成功,若成功,进入S405,若不成功,则返回S403; (5405)报表段落标题录入;段落标题的个数根据主巡检部位的不同而不同;段落标题由巡检状态和缺陷数目组成;巡检状态是指是否完成巡检,查询此次巡检任务中对应巡检部位的巡检状态和缺陷数目,生成段落标题,格式为:主巡检部位,巡检部位已或者为:未完成巡检未发现缺陷或者为:存在η处缺陷; (5406)判断段落标题是否录入成功;若录入成功,进入S407,若不成功,则返回S405; (5407)段落内容录入;段落内容是指当前巡检任务中对应巡检部 And the composition of the environment variable label; query patrol person responsible for the inspection task basic information, patrol officers and members of inspection records, generate reports basic information on the label; the query upstream water level inspection task environment variables, downstream water level, flood situation, rainfall and discharge structures operation, reporting environment variable label; (5404) to determine whether the reporting label entry is successful, if successful, enter S405, if successful, returns S403; (5405) reports paragraphs title entry; depending on the number of section headings different parts of the primary inspection; section headings and number of defects from the inspection state composition; refers to a state inspection inspection is completed, the scanning task query corresponding inspection site the state of inspection and the number of defects generated section header format: main site inspection, inspection or a portion has: No defect inspection is not completed or is: the presence of a defect η; (5406) ​​determines whether the entry section headings success; If successful entry into S407, if successful, returns to S405; (5407) paragraph is entered; refers to the paragraph contents corresponding to the current scanning task inspection unit 具体巡检结果;水工巡检系统中存在四类缺陷:渗漏,环境,裂缝、沉陷、变形,供排水系统;查询每类缺陷存在的个数和描述信息,分别列举出来; (5408)判断段落内容是否录入成功;若录入成功,进入S409,若不成功,则返回S407; (5409)段落多媒体数据录入;多媒体数据是指当前巡检任务中为描述对应巡检部位具体缺陷而使用移动设备拍摄的图片和视频;查询每类缺陷中存在的多媒体文件,以附件形式粘贴在对应巡检部位具体巡检结果缺陷描述之后; (5410)判断段落内容是否录入成功;若录入成功,则结束,若不成功,则返回(S409)。 Leakage, environmental, cracks, subsidence, deformation, water supply and drainage systems; query number and description for each type of defect present, are enumerated; (5408):; specific defect inspection result of four hydraulic present Inspection System determining whether the paragraphs of successful entry; if successful entry into S409, if successful, returns to S407; (5409) paragraph multimedia data entry; refers to multimedia data for the current scan job describing particular defect site and a corresponding mobile patrol device captured pictures and videos; query multimedia file for each type of defect present in the form of paste after attachment portion corresponding to the inspection result of the defect inspection specifically described; (5410) determines whether the contents of the paragraph entry success; if successful entry, end , if it succeeds, it returns (S409).
CN 201410736030 2014-12-05 2014-12-05 Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods CN104392506B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201410736030 CN104392506B (en) 2014-12-05 2014-12-05 Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201410736030 CN104392506B (en) 2014-12-05 2014-12-05 Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods

Publications (2)

Publication Number Publication Date
CN104392506A true CN104392506A (en) 2015-03-04
CN104392506B true CN104392506B (en) 2017-03-29

Family

ID=52610404

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201410736030 CN104392506B (en) 2014-12-05 2014-12-05 Supporting Multi-platform terminal station hydraulic inspection data synchronization and data management methods

Country Status (1)

Country Link
CN (1) CN104392506B (en)

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7428419B2 (en) * 2003-07-29 2008-09-23 General Electric Company Method and apparatus for controlling site-specific operations
JP2007188358A (en) * 2006-01-13 2007-07-26 Chugoku Electric Power Co Inc:The Inspection system and inspection unit for apparatus
CN103578154B (en) * 2013-11-21 2016-03-30 国家电网公司 Implementation of electricity intelligent data logging devices based pda
CN103824337A (en) * 2014-02-26 2014-05-28 国家电网公司 Power transmission intelligent tour-inspection system
CN103941745B (en) * 2014-03-07 2016-06-01 国家电网公司 Mobile stations and the working methods used in the sub-transmission line inspection of UAV

Also Published As

Publication number Publication date Type
CN104392506A (en) 2015-03-04 application

Similar Documents

Publication Publication Date Title
US5307266A (en) Information processing system and method for processing document by using structured keywords
US20080064438A1 (en) Place Name Picture Annotation on Camera Phones
US5826024A (en) Multimedia information distributing system
US7286723B2 (en) System and method for organizing images
US20080189028A1 (en) Intelligent location-to-cell mapping using annotated media
US20120066178A1 (en) Systems and methods for construction field management and operations with building information modeling
CN102136162A (en) Power transmission line polling system
Hansen et al. Integrating the web and the world: contextual trails on the move
CN101944773A (en) Intelligent distribution patrol and management system and work flow thereof
CN102063500A (en) Data migration method and device
US20060026127A1 (en) Method and apparatus for classification of a data object in a database
CN101464903A (en) OCR picture and text recognition and retrieval method and system through web mode
CN101699454A (en) Method for exchanging and merging electric network models between control center of electric power system and substation
CN101976188A (en) OpenApi data automatic loading system oriented to AJAX protocol
US8467613B2 (en) Automatic retrieval of object interaction relationships
CN102761668A (en) Method and device for dialing telephone call based on telephone number information in pictures
Berra et al. Guest Editors' Introduction: Multimedia Information Systems
CN103984702A (en) XBRL (extensible business reporting language) reporting data-based system and XBRL reporting data-based method for constructing business intelligence industry analysis cloud
CN103941745A (en) Movable substation and working method for unmanned aerial vehicle electric transmission line inspection
CN103369003A (en) A method and a system for scanning redundancy files in a mobile device by using cloud computing
US20130018848A1 (en) Determining and presenting provenance and lineage for content in a content management system
CN102436624A (en) Method for processing flow and standard of power-marketing site services on basis of handheld terminal
CN1670726A (en) A method for inspecting garbage files in cluster file system
CN1949216A (en) Information searching method
US7975222B1 (en) System and method for dynamic linking between graphic documents and comment data bases

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
GR01