CN110781987B - Workshop inspection management system - Google Patents

Workshop inspection management system Download PDF

Info

Publication number
CN110781987B
CN110781987B CN201911048094.9A CN201911048094A CN110781987B CN 110781987 B CN110781987 B CN 110781987B CN 201911048094 A CN201911048094 A CN 201911048094A CN 110781987 B CN110781987 B CN 110781987B
Authority
CN
China
Prior art keywords
inspection
management
background server
database
data
Prior art date
Legal status (The legal status 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 status listed.)
Active
Application number
CN201911048094.9A
Other languages
Chinese (zh)
Other versions
CN110781987A (en
Inventor
郑国军
徐丽娟
杨鹏洁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nanjing Abas Information Technology Co ltd
Original Assignee
Yunnan Hengxie Science And Technology Co ltd
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
Application filed by Yunnan Hengxie Science And Technology Co ltd filed Critical Yunnan Hengxie Science And Technology Co ltd
Priority to CN201911048094.9A priority Critical patent/CN110781987B/en
Publication of CN110781987A publication Critical patent/CN110781987A/en
Application granted granted Critical
Publication of CN110781987B publication Critical patent/CN110781987B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K17/00Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
    • G06K17/0022Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
    • G06K17/0025Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/109Time management, e.g. calendars, reminders, meetings or time accounting
    • G06Q10/1093Calendar-based scheduling for persons or groups
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computing Systems (AREA)
  • Primary Health Care (AREA)
  • Manufacturing & Machinery (AREA)
  • Health & Medical Sciences (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • General Health & Medical Sciences (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

The invention provides a workshop inspection management system which 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 simultaneously downloads the tasks and uploads the inspection results periodically through the background server to realize the synchronization of the handheld terminal and a database of the background server, and performs task management, inspection management and background management through the background server to finish inspection and analysis of the places. The invention provides a complete functional module to replace paper and Excel form for systematic management of inspection data.

Description

Workshop inspection management system
Technical Field
The invention belongs to the technical field of workshop inspection, and particularly relates to a workshop inspection management system.
Background
The traditional inspection mode is to manually hold paper to directly record inspection results on site, and if unqualified inspection projects need to be reserved for evidence, a camera is additionally required to be taken for photographing, so that the whole inspection process is very complicated, and a large amount of paper and file storage space are required to be wasted. And the inspection process lacks auxiliary guarantee measures, and the phenomenon of inspection missing or inspection non-inspection exists. The supervision and guarantee means of the standard inspection process are weak, and the inspection-missing project in daily inspection and even direct filling performance without inspection are difficult to guarantee by means of manual recording and hooking. The patrol records and the on-site irregular photos are not traceable, and review summary of window construction work is not facilitated.
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.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a schematic diagram of a system deployment architecture of the present invention;
FIG. 2 is a schematic diagram of data synchronization in accordance with the present invention;
FIG. 3 is a flow chart of an inventive intelligent task allocation algorithm.
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.

Claims (4)

1. The workshop inspection management system is characterized by comprising 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, simultaneously downloads the tasks and uploads the inspection results regularly through the background server, realizes synchronization of the handheld terminal and a database of the background server, and performs task management, inspection management and background management through the background server, so that inspection and analysis of the places are completed;
the handheld terminal and the background server are used for bidirectional copying of data files through a USB serial line, an embedded database file with the same structure as a background server database 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 into a specific file directory in an operating system where the servo program is located, then the data in the database is downloaded and updated into 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.
2. The system of claim 1, wherein the barcode data reading is written in c++ language and the secondary development is provided using standard interface function formats.
3. The workshop inspection management system according to claim 1, wherein the inspection tasks comprise daily inspection tasks in a period and special inspection tasks released in a special period, the database makes task templates and carries out regularization processing on the task templates, and the task templates in all activation states are completed through a storage process written in a background database and meet a task generation function of the generation conditions.
4. The system according to claim 1, wherein the background server establishes dynamic graphic result display curves and charts, periodic analysis and traceability of inspection conditions and electronic billboard management functions based on the uploaded data.
CN201911048094.9A 2019-10-30 2019-10-30 Workshop inspection management system Active CN110781987B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911048094.9A CN110781987B (en) 2019-10-30 2019-10-30 Workshop inspection management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911048094.9A CN110781987B (en) 2019-10-30 2019-10-30 Workshop inspection management system

Publications (2)

Publication Number Publication Date
CN110781987A CN110781987A (en) 2020-02-11
CN110781987B true CN110781987B (en) 2023-06-20

Family

ID=69387958

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911048094.9A Active CN110781987B (en) 2019-10-30 2019-10-30 Workshop inspection management system

Country Status (1)

Country Link
CN (1) CN110781987B (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20080031889A (en) * 2008-03-03 2008-04-11 주식회사 골든오일 Public performance event output method from mobile phone
CN102567373A (en) * 2010-12-23 2012-07-11 上海鸣啸信息科技发展有限公司 Self-service terminal for Jiangsu speedway
CN104021503A (en) * 2014-05-08 2014-09-03 国家电网公司 Relaying cloud establishing method based on virtualized Hadoop cluster

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050246217A1 (en) * 2004-04-30 2005-11-03 Horn Mark W System and methods of mobile field inspection
JP4748819B2 (en) * 2009-01-28 2011-08-17 インターナショナル・ビジネス・マシーンズ・コーポレーション Client program, terminal, method, server system, and server program
CN103226622A (en) * 2013-04-19 2013-07-31 国家电网公司 Inspection mobile terminal for 10 kV user inspection
CN103578154B (en) * 2013-11-21 2016-03-30 国家电网公司 Based on the implementation method of the power equipment intelligent patrol detection of PDA
CN103679348A (en) * 2013-11-28 2014-03-26 国家电网公司 Operation-maintenance-integrated on-site data collection and feedback tour-inspection management system
CN205193900U (en) * 2015-11-19 2016-04-27 国家电网公司 Substation equipment electron system of patrolling and examining
CN106384208A (en) * 2016-10-12 2017-02-08 国网江苏省电力公司徐州供电公司 Interactive inspection system and method based on two-dimensional code technology
CN110276225A (en) * 2018-03-16 2019-09-24 上海远动科技有限公司 A kind of water factory's equipment routing inspection data system
CN109784788A (en) * 2019-03-20 2019-05-21 武汉瑞莱保能源技术有限公司 A kind of intelligent comprehensive patrol checking server, terminal and system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20080031889A (en) * 2008-03-03 2008-04-11 주식회사 골든오일 Public performance event output method from mobile phone
CN102567373A (en) * 2010-12-23 2012-07-11 上海鸣啸信息科技发展有限公司 Self-service terminal for Jiangsu speedway
CN104021503A (en) * 2014-05-08 2014-09-03 国家电网公司 Relaying cloud establishing method based on virtualized Hadoop cluster

Also Published As

Publication number Publication date
CN110781987A (en) 2020-02-11

Similar Documents

Publication Publication Date Title
WO2022094934A1 (en) Site location-based system and method for management of engineering quality acceptance
US10127507B2 (en) Project management system providing interactive issue creation and management
CN103578154A (en) PDA-based realization method for intelligent patrol of electric equipment
US10510044B2 (en) Project management system providing digital form-based inspections in the field
CN108376065A (en) The system for building the avionics software development environment of model-driven
CN105159831A (en) Method for automatically monitoring quality of software code
CN112396302A (en) Engineering quality acceptance management system and method based on field positioning
US9495132B2 (en) Release management systems and methods
CN109709918A (en) A kind of satellite intelligence production visualization managing and control system
CN111930354A (en) Framework component for software development and construction method thereof
CN110781987B (en) Workshop inspection management system
CN105868937B (en) Nuclear power station work order task switching device and method
CN113329129B (en) Material full-flow voice service automatic processing system and method
CN111124552A (en) PPT automatic manufacturing robot based on automation technology and manufacturing method
CN108960758A (en) Architectural engineering process control management system
CN116935320A (en) Image modeling and recognition method based on image template
CN112256544A (en) Early warning method and device for software problems
CN111626575A (en) Construction safety quality hidden danger management method based on internet environment
CN102053571B (en) Data acquisition method of information acquisition terminal
CN116796950A (en) Online review system and method for power distribution network project capable of being researched
CN104408556B (en) Remote units test installation system based on Android mobile terminal
CN104392506B (en) Data syn-chronization and data managing method are patrolled and examined in a kind of power station water conservancy project for supporting multiple terminals platform
CN110096638B (en) Irrigated area meteorological and remote sensing information monitoring platform
CN114612276A (en) Intelligent environmental sanitation synergy algorithm model management platform
CN110895732A (en) Wafer mapping production management method, device, system, medium and computer equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right
TR01 Transfer of patent right

Effective date of registration: 20240226

Address after: 210000 floors 1-5, building 01, Xincheng science and technology building, No. 69, Aoti street, Jianye District, Nanjing, Jiangsu Province

Patentee after: Nanjing Abas Information Technology Co.,Ltd.

Country or region after: China

Address before: 650000 no.1-401, building 21, phase III, international garden, high tech Zone, Kunming City, Yunnan Province

Patentee before: YUNNAN HENGXIE SCIENCE AND TECHNOLOGY CO.,LTD.

Country or region before: China