CN109376159B - Batch record automatic generation method - Google Patents
Batch record automatic generation method Download PDFInfo
- Publication number
- CN109376159B CN109376159B CN201811480795.5A CN201811480795A CN109376159B CN 109376159 B CN109376159 B CN 109376159B CN 201811480795 A CN201811480795 A CN 201811480795A CN 109376159 B CN109376159 B CN 109376159B
- Authority
- CN
- China
- Prior art keywords
- data
- cells
- reference path
- database
- equipment
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses an automatic batch record generation method, which comprises the following steps: acquiring equipment attribute data and monitoring data of equipment in a production process, and establishing a production database; extracting equipment attribute data and indexing the equipment attribute data and the monitoring data; establishing a data model for the indexed monitoring data and the equipment attributes; configuring equipment attribute data in the cells, setting a reference path, and referencing the reference path to a background operation area; setting and associating all signature columns in the cells, configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells; applying the established data model to a background operation area, automatically filling monitoring data into the cells according to the data model, and automatically filling signatures into the signature columns; the method realizes automatic filling of monitoring data, automatic uniform signature, acquisition of analysis data and automatic filling of the analysis data in the form, so that the operation is more convenient, the time is saved, and the working efficiency is improved.
Description
Technical Field
The invention relates to the field of enterprise transaction management, in particular to an automatic batch record generation method.
Background
The workflow technology of the production process of the process enterprise aims to solve the production coordination problem of a plurality of links in the production process of a complex process. Manufacturing Execution System (MES) is an information execution system facing the inter-vehicle space between a plan management system at the upper layer of a production type enterprise and an industrial control system at the field layer, and is used for carrying out production information management and data processing on the whole production process from production order issuing to product completion, including the contents of order data issuing, production instruction data issuing, production process execution monitoring, field production data acquisition, data statistical processing and reporting and the like, which are the keys of realizing production information processing and man-machine interaction in the production process of a complex flow, however, the MES can generate various monitoring data in the production process, and because corresponding equipment data are preset in unit cells of a form, the monitoring data acquired in the production process is required to carry out data filling on the unit cells according to the configuration information of the unit cells; and to sign a large number of forms that are automatically generated during the operation of the device.
In the prior art, an operator performs one-to-one correspondence on preset device data of a cell according to acquired monitoring data, and then performs one-to-one filling, so that an autonomously configured form cannot be automatically filled; operators need to sign all the forms one by one, and cannot sign a large number of automatically generated forms in a unified manner; leading to complex operation in the production process, further wasting a large amount of time and reducing the work efficiency.
Disclosure of Invention
The invention provides an automatic batch record generation method, which aims to solve the technical problems that an automatically configured form cannot be automatically filled in and a large number of automatically generated forms cannot be uniformly signed, so that the automatically configured form can be automatically filled in and the large number of automatically generated forms can be uniformly signed, and the beneficial effects of saving time and improving the working efficiency are achieved.
In order to solve the above technical problem, an embodiment of the present invention provides an automatic batch record generation method, including:
acquiring equipment attribute data and monitoring data of the equipment in a production process, and establishing a production database;
extracting the equipment attribute data and indexing the equipment attribute data and the monitoring data;
establishing a data model for the indexed monitoring data and the equipment attributes;
configuring device attribute data in a cell, setting a reference path, and referencing the reference path to a background operation area;
setting and associating all signature columns in the cells, configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells;
and applying the established data model to a background operation area, automatically filling monitoring data into the cells according to the data model, and automatically filling signatures into the signature columns.
As a preferred scheme, the batch record automatic generation method further includes:
and acquiring the processed analysis data to establish an analysis database, connecting the analysis database with the data model through a reference path, and calling the data model through the reference path to automatically fill the analysis data.
As a preferred scheme, the extracting the device attribute data and indexing with the monitoring data includes:
extracting equipment attribute data in a database, and performing feature extraction on the attribute data;
extracting monitoring data in a database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
As a preferred scheme, the establishing a data model for the indexed monitoring data and the device attributes includes:
copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
and transmitting the data in the test database to the integrated data model, repeatedly testing the data model, and optimizing the data model until the test threshold and the test accuracy are reached.
As a preferred scheme, configuring device attribute data and setting a reference path in a cell, and referencing the reference path to a background operation area includes:
calling a cell program command, and configuring the equipment attribute data in the cells;
setting a reference path for the cells configured by the attribute data, and associating the reference path to all the cells;
and the reference path is referred to a background operation area through a background starting program, the background operation area is started after the cell is triggered, and the attribute data of the configuration equipment is started.
Preferably, the associating all the signature column settings in the cells and configuring a reference path, and connecting the reference path with the data model and disassociating the unmatched cells includes:
calling all signature columns in the cells through a cell program command to set association, and inputting a forbidden macro command to realize that the cells associated with the signature columns are forbidden after triggering the signature column cells;
setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data is directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column is realized;
and connecting the quote path with the data model, judging whether the monitoring data of all the cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and canceling the forbidden macro command for the unmatched cells.
As a preferred scheme, the applying the established data model to the background operation area, automatically filling the monitoring data to the cells according to the data model, and automatically filling the signatures to the signature bar includes:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
connecting the reference path with the data model, starting and configuring equipment attribute data after triggering the cells, and entering the data model through attribute data indexes, so as to call monitoring data corresponding to the equipment attribute data and automatically fill the monitoring data;
after the signature column in the cell is triggered, the matched cell is forbidden, and the signature in the cell in the signature column is automatically filled into other corresponding cells according to the equipment attribute data and the monitoring data associated with the equipment attribute data by combining the data model.
As a preferred scheme, the acquiring processed analysis data to establish an analysis database, connecting the analysis database with the data model through a reference path, and invoking the data model through the reference path to automatically fill the analysis data includes:
acquiring processed analysis data, establishing an analysis database, and storing the analysis database in a background working area;
connecting the analysis database with the data model through a reference path;
triggering the cell to start originally configured equipment attribute data, and entering a data model through a corresponding attribute data index so as to call monitoring data corresponding to the equipment attribute data;
entering an analysis database through a reference path according to the equipment attribute data to call related data;
and automatically filling the called monitoring data and analysis data associated with the equipment attribute data in the cells into the corresponding cells.
Preferably, the training threshold is 20 ten thousand times, the training accuracy is 90%, the testing threshold is 20 ten thousand times, and the testing accuracy is 90%.
Preferably, the device attribute data includes a device name, a device specification, and a device power.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
1. the automatically configured form can be automatically filled in, so that the operation is convenient, the time is saved, and the efficiency is improved.
2. And the table in the signature column is associated, so that unified automatic signature of the signature column is realized, and the working efficiency is further improved.
3. Automatically collecting the analysis data after analysis processing, and automatically filling the analysis data in the corresponding form, thereby realizing intelligent full-automatic form generation.
Drawings
FIG. 1: a flow chart of the specific steps of the embodiment of the batch record automatic generation mode of the invention;
FIG. 2: a detailed flowchart of step S2 in the embodiment of the batch record automatic generation mode of the present invention;
FIG. 3: a detailed flowchart of step S3 in the embodiment of the batch record automatic generation mode of the present invention;
FIG. 4: a detailed flowchart of step S4 in the embodiment of the batch record automatic generation mode of the present invention;
FIG. 5: a detailed flowchart of step S5 in the embodiment of the batch record automatic generation mode of the present invention;
FIG. 6: a detailed flowchart of step S6 in the embodiment of the batch record automatic generation mode of the present invention;
FIG. 7: a detailed flowchart of step S7 in the embodiment of the batch record automatic generation mode of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a preferred embodiment of the present invention provides an automatic batch record generation method, including:
s1, acquiring equipment attribute data and monitoring data of the equipment in the production process, and establishing a production database;
s2, extracting the equipment attribute data and indexing with the monitoring data;
s3, establishing a data model for the indexed monitoring data and the equipment attributes;
s4, configuring the device attribute data in the cell and setting a reference path, and referencing the reference path to a background operation area;
s5, setting all signature columns in the cells to be associated and configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells;
and S6, applying the established data model to a background operation area, automatically filling monitoring data into the cells according to the data model, and automatically filling signatures into the signature columns.
In the embodiment, the monitoring data is mainly divided into two parts, wherein one part of data is bottom layer data, the other part of data is composite data after analysis and processing, and an operator needs to collect both the bottom layer data and the composite data into a table; in the prior art, the system can automatically collect and fill the bottom data in the form, but the system cannot automatically collect and fill the analyzed and processed composite data in the form, and an operator needs to manually collect and fill the composite data in the form, so that the operator is complicated to implement and operate in the operation process, a large amount of time is wasted, and the working efficiency is reduced.
Therefore, in this embodiment, the method for automatically generating batch records further includes:
and S7, acquiring the processed analysis data to establish an analysis database, connecting the analysis database with the data model through a reference path, and calling the data model through the reference path to automatically fill the analysis data.
Referring to fig. 2, in this embodiment, the extracting the device attribute data of step S2 and indexing the device attribute data with the monitoring data includes:
s21, extracting the device attribute data in the database, and extracting the characteristics of the attribute data;
and S22, extracting the monitoring data in the database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
Referring to fig. 3, in this embodiment, the step S3 is to establish a data model for the indexed monitoring data and the device attributes, and includes:
s31, copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
s32, establishing a data model, transmitting the data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
and S33, transmitting the data in the test database to the integrated data model, repeatedly testing the data model, and optimizing the data model until reaching the test threshold and the test accuracy.
Referring to fig. 4, in this embodiment, the step S4 configures device attribute data in a cell and sets a reference path, and refers the reference path to a background operation area, where the method includes:
s41, calling a cell program command, and configuring the device attribute data in the cell;
s42, setting a reference path for the cells configured by the attribute data, and associating the reference path to all the cells;
and S43, the reference path is referred to the background operation area through the background start program, the background operation area is started after the cell is triggered, and the attribute data of the configured equipment is started.
Referring to fig. 5, in this embodiment, the step S5 associates all signature bar settings in a cell and configures a reference path, connects the reference path with the data model, and disassociates a unmatched cell, including:
s51, calling all signature columns in the cells through a cell program command to set association, and inputting a disabling macro command to realize that after the signature column cells are triggered, the cells associated with the signature columns are disabled;
s52, setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data can be directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column are realized;
and S53, connecting the reference path with the data model, judging whether the monitoring data of all the cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and canceling the forbidden macro command for the unmatched cells.
Referring to fig. 6, in this embodiment, the step S6 applies the created data model to the background operation area, and automatically fills the monitoring data in the cells and the signature in the signature bar according to the data model, including:
s61, applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
s62, connecting the reference path with the data model, triggering the cells, starting to configure the device attribute data, entering the data model through the attribute data index, calling the monitoring data corresponding to the device attribute data, and automatically filling the monitoring data;
and S63, after the signature column in the cell is triggered, the matched cell is forbidden, and the signature in the cell of the signature column is automatically filled into the corresponding other cells according to the device attribute data and the monitoring data associated with the device attribute data by combining the data model.
Referring to fig. 7, in this embodiment, the step S7 acquiring the processed analysis data to build an analysis database, and connecting the analysis database to the data model through a reference path, and invoking the data model through the reference path to automatically fill the analysis data includes:
s71, acquiring the processed analysis data, establishing an analysis database, and storing the analysis database in a background working area;
s72, connecting the analysis database with the data model through a reference path;
s73, triggering the cells to start originally configured equipment attribute data, and entering a data model through corresponding attribute data indexes, so as to call monitoring data corresponding to the equipment attribute data;
s74, entering an analysis database through a reference path according to the equipment attribute data to call related data;
and S75, automatically filling the called monitoring data and analysis data associated with the device attribute data in the cells into the corresponding cells.
In this embodiment, the training threshold is 20 ten thousand times, the training accuracy is 90%, the testing threshold is 20 ten thousand times, and the testing accuracy is 90%.
In this embodiment, the device attribute data includes a device name, a device specification, and a device power.
In the embodiment, the specific implementation flow of the invention is as follows:
firstly, acquiring equipment attribute data including an equipment name, an equipment specification and equipment power, and monitoring data of the equipment in a production process, and establishing a production database; secondly, extracting the equipment attribute data in a database, and performing feature extraction on the attribute data; extracting monitoring data in a database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data; then, copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database; establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a characteristic integration data structure, and stopping training until a training threshold value of 20 ten thousand times and a training accuracy of 90% are reached; transmitting the data in the test database to the integrated data model, repeatedly testing the data model, optimizing the data model until the test threshold is reached for 20 ten thousand times and the test accuracy is 90 percent, and stopping testing; then, calling a cell program command, and configuring the device attribute data in the cells; setting a reference path for the cells configured by the attribute data, and associating the reference path to all the cells; the reference path is referred to a background operation area through a background starting program, the background operation area is started after the cell is triggered, and the attribute data of the configuration equipment is started; next, calling all signature columns in the cells through a cell program command to set association, and inputting a forbidden macro command to realize that after the signature column cells are triggered, the cells associated with the signature columns are forbidden; setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data is directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column is realized; connecting the quote path with the data model, judging whether the monitoring data of all cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and cancelling a forbidden macro command for the unmatched cells; then, applying the established data model to a background operation area through a background starting program, and storing the data model in a background server; connecting the reference path with the data model, starting and configuring equipment attribute data after triggering the cells, and entering the data model through attribute data indexes, so as to call monitoring data corresponding to the equipment attribute data and automatically fill the monitoring data; after the signature column in the cell is triggered, the matched cell is forbidden, and the signature in the cell in the signature column is automatically filled into other corresponding cells according to the equipment attribute data and the monitoring data associated with the equipment attribute data by combining a data model; finally, acquiring the processed analysis data to establish an analysis database, and storing the analysis database in a background working area; connecting the analysis database with the data model through a reference path; triggering the cell to start originally configured equipment attribute data, and entering a data model through a corresponding attribute data index so as to call monitoring data corresponding to the equipment attribute data; entering an analysis database through a reference path according to the equipment attribute data to call related data; and automatically filling the called monitoring data and analysis data associated with the equipment attribute data in the cells into the corresponding cells.
According to the invention, by establishing the data model and setting the reference path, the automatic filling of the self-configured form is realized, so that the operation of an operator is convenient, the time is saved, and the efficiency is improved; the table in the signature column is set to be associated, so that uniform automatic signature of the signature column is realized, and the working efficiency is further improved; automatically collecting the analysis data after analysis processing, and automatically filling the analysis data in the corresponding form, thereby realizing intelligent full-automatic form generation.
The above-mentioned embodiments are provided to further explain the objects, technical solutions and advantages of the present invention in detail, and it should be understood that the above-mentioned embodiments are only examples of the present invention and are not intended to limit the scope of the present invention. It should be understood that any modifications, equivalents, improvements and the like, which come within the spirit and principle of the invention, may occur to those skilled in the art and are intended to be included within the scope of the invention.
Claims (8)
1. An automatic batch record generation method is characterized by comprising the following steps:
acquiring equipment attribute data and monitoring data of the equipment in a production process, and establishing a production database;
extracting the equipment attribute data and indexing the equipment attribute data and the monitoring data;
establishing a data model for the indexed monitoring data and the equipment attributes;
configuring device attribute data in a cell, setting a reference path, and referencing the reference path to a background operation area;
setting and associating all signature columns in the cells, configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells;
applying the established data model to a background operation area, automatically filling monitoring data into the cells according to the data model, and automatically filling signatures into the signature columns;
the establishing of the data model of the indexed monitoring data and the equipment attributes comprises:
copying the production database into a training database and a testing database, and respectively storing the indexed production data and equipment attribute data in the training database and the testing database;
establishing a data model, transmitting data in the training database to the data model for repeated training, extracting a feature integration data structure, and stopping training until a training threshold and training accuracy are reached;
transmitting the data in the test database to the integrated data model, repeatedly testing the data model, optimizing the data model, and stopping testing until a test threshold and test accuracy are reached;
the associating all signature column settings in the cells and configuring a reference path, connecting the reference path with the data model and disassociating unmatched cells includes:
calling all signature columns in the cells through a cell program command to set association, and inputting a forbidden macro command to realize that the cells associated with the signature columns are forbidden after triggering the signature column cells;
setting a reference path for the cells of the signature column, and associating the reference path to all the cells, so that the configuration data is directly and automatically filled into other associated cells through the reference path when the configuration data of the cells of the signature column is realized;
and connecting the quote path with the data model, judging whether the monitoring data of all the cells are matched with the original equipment attribute data in the cells of the trigger signature bar through the data model, and canceling the forbidden macro command for the unmatched cells.
2. The batch record automatic generation method according to claim 1, further comprising:
and acquiring the processed analysis data to establish an analysis database, connecting the analysis database with the data model through a reference path, and calling the data model through the reference path to automatically fill the analysis data.
3. The method for automatically generating batch records according to claim 1, wherein the extracting and indexing the equipment attribute data with the monitoring data comprises:
extracting equipment attribute data in a database, and performing feature extraction on the attribute data;
extracting monitoring data in a database, carrying out relevant correspondence on the extracted equipment attribute data and the monitoring data in the database, and indexing the attribute data and the monitoring data.
4. The batch record automatic generation method according to claim 1, wherein configuring the device attribute data and setting a reference path in the cell, and referencing the reference path to the background operation area comprises:
calling a cell program command, and configuring the equipment attribute data in the cells;
setting a reference path for the cells configured by the attribute data, and associating the reference path to all the cells;
and the reference path is referred to a background operation area through a background starting program, the background operation area is started after the cell is triggered, and the attribute data of the configuration equipment is started.
5. The batch record automatic generation method as claimed in claim 1, wherein the applying the established data model to the background operation area and automatically filling the monitoring data to the cells and the signature to the signature column according to the data model comprises:
applying the established data model to a background operation area through a background starting program, and storing the data model in a background server;
connecting the reference path with the data model, starting and configuring equipment attribute data after triggering the cells, and entering the data model through attribute data indexes, so as to call monitoring data corresponding to the equipment attribute data and automatically fill the monitoring data;
after the signature column in the cell is triggered, the matched cell is forbidden, and the signature in the cell in the signature column is automatically filled into other corresponding cells according to the equipment attribute data and the monitoring data associated with the equipment attribute data by combining the data model.
6. The method for automatically generating batch records according to claim 2, wherein the obtaining of the processed analysis data to establish an analysis database and connecting the analysis database with the data model through a reference path, and the invoking of the data model through the reference path to automatically populate the analysis data comprises:
acquiring processed analysis data, establishing an analysis database, and storing the analysis database in a background working area;
connecting the analysis database with the data model through a reference path;
triggering the cell to start originally configured equipment attribute data, and entering a data model through a corresponding attribute data index so as to call monitoring data corresponding to the equipment attribute data;
entering an analysis database through a reference path according to the equipment attribute data to call related data;
and automatically filling the called monitoring data and analysis data associated with the equipment attribute data in the cells into the corresponding cells.
7. The method of claim 1, wherein the training threshold is 20 ten thousand, the training accuracy is 90%, the testing threshold is 20 ten thousand, and the testing accuracy is 90%.
8. The batch record automatic generation method according to any one of claims 1 to 7, characterized in that the equipment attribute data includes an equipment name, an equipment specification and an equipment power.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811480795.5A CN109376159B (en) | 2018-12-05 | 2018-12-05 | Batch record automatic generation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811480795.5A CN109376159B (en) | 2018-12-05 | 2018-12-05 | Batch record automatic generation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109376159A CN109376159A (en) | 2019-02-22 |
| CN109376159B true CN109376159B (en) | 2021-08-20 |
Family
ID=65375561
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811480795.5A Active CN109376159B (en) | 2018-12-05 | 2018-12-05 | Batch record automatic generation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109376159B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110197142A (en) * | 2019-05-16 | 2019-09-03 | 谷东科技有限公司 | Object identification method, device, medium and terminal device under faint light condition |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103530127A (en) * | 2013-10-22 | 2014-01-22 | 北京奇虎科技有限公司 | Icon display method and device |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105441774A (en) * | 2015-11-15 | 2016-03-30 | 丹阳市德源精密工具有限公司 | Ferroboron mold |
| CN105511791A (en) * | 2015-12-08 | 2016-04-20 | 刘炳林 | Handwriting processing method and device for electronic test and quality control record chart |
| CN106547729A (en) * | 2016-12-01 | 2017-03-29 | 长城计算机软件与***有限公司 | A kind of dynamic creation method and system of data sheet |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN108762203A (en) * | 2018-04-20 | 2018-11-06 | 广州中浩控制技术有限公司 | A kind of production executive system and management method based on electronics batch record |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9251360B2 (en) * | 2012-04-27 | 2016-02-02 | Intralinks, Inc. | Computerized method and system for managing secure mobile device content viewing in a networked secure collaborative exchange environment |
-
2018
- 2018-12-05 CN CN201811480795.5A patent/CN109376159B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103530127A (en) * | 2013-10-22 | 2014-01-22 | 北京奇虎科技有限公司 | Icon display method and device |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105441774A (en) * | 2015-11-15 | 2016-03-30 | 丹阳市德源精密工具有限公司 | Ferroboron mold |
| CN105511791A (en) * | 2015-12-08 | 2016-04-20 | 刘炳林 | Handwriting processing method and device for electronic test and quality control record chart |
| EP3296864A1 (en) * | 2016-09-20 | 2018-03-21 | Siemens Aktiengesellschaft | Storing and retrieving documentation |
| CN106547729A (en) * | 2016-12-01 | 2017-03-29 | 长城计算机软件与***有限公司 | A kind of dynamic creation method and system of data sheet |
| CN108762203A (en) * | 2018-04-20 | 2018-11-06 | 广州中浩控制技术有限公司 | A kind of production executive system and management method based on electronics batch record |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109376159A (en) | 2019-02-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102117306B (en) | Method and system for monitoring ETL (extract-transform-load) data processing process | |
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN111857470B (en) | Unattended control method and device for production equipment and controller | |
| CN101888655A (en) | Method and device for configuring network element data in template way in network management system | |
| CN112257993B (en) | Production recording method and recording device based on table | |
| CN103886119A (en) | Intelligent auxiliary designing system for sheet metal components | |
| CN109376159B (en) | Batch record automatic generation method | |
| CN109522536B (en) | Automatic form filling method | |
| CN102591808B (en) | System and method for DCS (distributed control system) hardware configuration based on Excel | |
| CN109508953B (en) | Form template generation method | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN109492209B (en) | Automatic generation method of form signature column | |
| CN109446182B (en) | Composite acquisition method | |
| CN112269569A (en) | Visual script online editing verification and automatic execution device | |
| CN109242357B (en) | Process editing method of MES system | |
| CN110930120A (en) | MES test method and system | |
| CN108920547A (en) | Based on full-service uniform data center data among heterogeneous databases library field type mapping boosts method | |
| CN110109980B (en) | Method and device for generating scheduled inspection material, computer equipment and storage medium | |
| CN102053571A (en) | Data acquisition method of information acquisition terminal | |
| CN111796868B (en) | Method for realizing interaction of CAD enhanced attribute block and Excel data | |
| CN113887964A (en) | Production line simulation system based on man-machine method | |
| CN113034032A (en) | Intelligent anti-error analysis system and method | |
| CN112485483A (en) | Relay protection test state sequence generation method and platform | |
| CN112487770A (en) | Table data management method, storage medium and computer | |
| CN101646191A (en) | Data processing method and device |
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 | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: An automatic generation method of batch records Effective date of registration: 20220518 Granted publication date: 20210820 Pledgee: Bank of China Limited Guangzhou Yuexiu Branch Pledgor: GUANGZHOU CH CONTROL TECHNOLOGY Co.,Ltd. Registration number: Y2022980005858 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |