Disclosure of Invention
The invention aims to provide a workshop inspection management system which provides a complete functional module to replace paper and Excel forms for systematic management of inspection data.
The invention provides the following technical scheme:
the workshop inspection management system comprises a handheld terminal and a background server which are connected with each other, wherein the handheld terminal scans corresponding places and position bar codes to be inspected according to inspection tasks issued by the data background server, inputs inspection results of the places, and meanwhile, periodically downloads the tasks and uploads the inspection results through the background server, so that the handheld terminal and a database of the background server are synchronized, and task management, inspection management and background management are performed through the background server, so that inspection and analysis of the places are completed.
Preferably, the handheld terminal and the background server perform bidirectional copying of the data file through a USB serial line, an embedded database file with the same structure as a database of the background server is built in a handheld terminal system, when the handheld terminal is connected to a PC or a server provided with a synchronous servo program, the system is firstly connected through mobile phone synchronous software, the mobile phone synchronous software uses an event triggering program to remind the servo program, after the servo program receives reminding, the terminal database is copied to a specific file directory in an operating system where the servo program is located, then the data in the database is downloaded and updated to the database file, and after the completion, the database file is copied back to the handheld terminal by using a mobile phone synchronous software data copying API, so that the data synchronous downloading work is completed.
Preferably, the bar code data reading is written in C++ language, and secondary development is provided by using a standard interface function form.
Preferably, the patrol task includes daily patrol task in a period and special patrol task issued in a special period, the database formulates a task template and carries out regularization processing on the task template, and the task template under each activation state is completed by regularly calling a storage process written in the operation through the background database, so that the task generating function of generating conditions is met.
Preferably, the background server establishes a dynamic graph result display curve and a graph, periodic analysis and traceability of the inspection condition and an electronic billboard management function based on the uploaded data.
The beneficial effects of the invention are as follows: the system can carry out electronic informatization on-site auxiliary management on the environment, article placement and the like of a dispatching place, thereby standardizing on-site inspection management and solving the problems of missed inspection, no closed loop of management flow and the like in on-site management; the system provides various visual data analysis means to collect and count data in multiple directions. The problems that the existing work is still finished by manpower, the statistics and summarization efficiency is low, the probability of errors is high, the statistics and analysis flexibility is insufficient and the like are solved, and the working efficiency of management staff is improved; the system continuously improves the production operation management level through means of scientific management, technical innovation and the like, and enables the management platform to better provide informationized management service through leak detection and deficiency repair.
Detailed Description
As shown in fig. 1, the workshop inspection management system is a workshop inspection management system combining software and hardware, can provide complete functional modules, can intuitively, conveniently and seamlessly realize key services such as data acquisition, data analysis statistics, report presentation, follow-up tracking and the like, can replace paper and Excel forms to carry out inspection data systematic management, adopts a system platform to carry out intelligent management on places, and realizes standardization of the place management system, standardization of management contents, high efficiency of management processes, daily feedback instantaneity of the place management, abnormal tracking systemization of the place management and abnormal analysis systemization of the place management through four functions such as task management, data synchronization, inspection management, background management and the like.
Specifically, the system realizes the intelligent inspection tool of the dispatching control place through terminal equipment selection and intelligent equipment embedded software development, develops matched intelligent background management software based on the intelligent inspection tool, and establishes flexible management functions of inspection point, customizable requirement specification, task period generation and the like. And the bidirectional copying technology of the data file is carried out through the USB serial line, so that the synchronous management of the terminal equipment data and the background database is realized under the internal and external network isolation environment. Based on the uploading data, the system establishes a dynamic graph result display curve and a graph, and realizes the electronic billboard management functions of regular analysis, traceability and the like of the inspection condition under the management of 5S adjustment.
As shown in fig. 2, the automatic synchronization between the terminal and the background data of the system is realized: the handheld terminal needs to download and synchronize a large amount of ledger data from the background at a time, and the current handheld device system supports CF or SD card big data storage no matter the android or WM operating system. Because the MIS network belongs to the power supply system intranet, the wireless network access and data synchronization scheme is not adopted, and therefore, the bidirectional copying of the data file is carried out through the USB serial line in a network-free environment, which is certainly the preferred scheme of data synchronization. We will first build an embedded database file of the same structure as the server database in the terminal system. When the terminal is connected to a PC or a server provided with a synchronous servo program, the system firstly establishes connection through an ActiveSync (Mobile phone synchronous software), the ActiveSync uses an event trigger program to remind the servo program, after the servo program receives the reminding, a terminal database is copied to a specific file directory in an operating system where the servo program is located, then the data in the database is downloaded and updated to the database file, and after the completion, the database file is copied back to the terminal by using an ActiveSync data copying API. Thus, the synchronous downloading of the data is completed. In the program structure, DLL files are used for encapsulation management, firstly, an ActiveSync is used as Microsoft universal data synchronization software, the ActiveSync is supported and compatible with each computer hardware environment and terminal chip binary data transmission drive at the bottom end, and simultaneously, standard API interfaces, such as professional API functions of file reading and writing, identification, read-write code rate setting and the like, are provided for the outside, and the system realizes function functions of file copying, event reminding and the like by calling each professional API of the ActiveSync and encapsulates the function functions into the DLL files. And the application program invokes and combines all the functional points to realize the program operation flow.
The bar code data reading of the handheld terminal software is realized: the barcode data is read and written in C++ language, secondary development is provided by using a standard interface function form, and the standard interface function mainly comprises functions such as ScanStart (Open laser scanning), scan_Open (Open hardware), scan_close (Close hardware), messageBeep (error prompt), scanSoundOpen (scanning success voice report), and the like, so that a technician can quickly complete development and management of the functions of the barcode part without knowing hardware driving details by using an integrated language development function module.
As shown in fig. 3, task templating and intelligent task allocation management: the patrol task includes daily patrol tasks, weekly, etc., and special patrol tasks issued in a special period. The task management can select inspection objects (places, articles, responsible persons and the like) and associated inspection tables (projects, standards, methods and the like), the automatic generation frequency (days, weeks, months, quarters, years and the like) of the tasks, the starting/stopping state of automatic template generation, the effective period of the task template (the starting/stopping date of automatic task generation), the task inspector and the like, and the system can automatically generate corresponding inspection tasks according to the designated period. The system designs a task template through a database during design, and regularizes the task template, namely a user can customize the cycle frequency of the task template copying and generating task and the time when the cycle frequency is finished, and the task template under each activation state is completed through a storage process written in a background SQL SERVER database periodically, so that the task generating function of generating conditions is met, and the complexity of inspection task management work is reduced.
As shown in figures 1-3, in practical application, the workshop inspection management system mainly comprises a system server, a system server and a system server, wherein the system server is used for hosting system database services and Web services, and a neural center of the whole system is deployed; the local area network is a network link of the whole system, which is an information channel of the whole system and is required to provide a network channel for stable operation, and can be a wired network or a wireless network; the WEB client is mainly used for managing the basic data and generating a statistical analysis report; the data acquisition terminal is characterized in that the inspection data acquisition module is embedded in the handheld inspection terminal, inspection personnel can connect the handheld inspection terminal to a dispatching place for inspection, the operation is simple, and the system has the functions of photographing, bar code acquisition and the like.
The foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.