CN114036911A - Production batch energy copying method, device, equipment and storage medium - Google Patents

Production batch energy copying method, device, equipment and storage medium Download PDF

Info

Publication number
CN114036911A
CN114036911A CN202111315754.2A CN202111315754A CN114036911A CN 114036911 A CN114036911 A CN 114036911A CN 202111315754 A CN202111315754 A CN 202111315754A CN 114036911 A CN114036911 A CN 114036911A
Authority
CN
China
Prior art keywords
batch
production
energy consumption
time
consumption 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.)
Pending
Application number
CN202111315754.2A
Other languages
Chinese (zh)
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.)
Foshan Jiyan Zhilian Technology Co ltd
Original Assignee
Foshan Jiyan Zhilian 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 Foshan Jiyan Zhilian Technology Co ltd filed Critical Foshan Jiyan Zhilian Technology Co ltd
Priority to CN202111315754.2A priority Critical patent/CN114036911A/en
Publication of CN114036911A publication Critical patent/CN114036911A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/3331Query processing
    • 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/103Workflow collaboration or project management
    • 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
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management
    • 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)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Human Resources & Organizations (AREA)
  • Data Mining & Analysis (AREA)
  • Health & Medical Sciences (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • General Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • General Business, Economics & Management (AREA)
  • General Engineering & Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Artificial Intelligence (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Databases & Information Systems (AREA)
  • Manufacturing & Machinery (AREA)
  • Primary Health Care (AREA)
  • General Factory Administration (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the application discloses a production batch energy copying method, device, equipment and storage medium. The technical scheme provided by the embodiment of the application comprises the following steps: determining the starting time, the ending time and the batch information of a production batch, and creating a corresponding batch record table according to the starting time, the ending time and the batch information; inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time; and associating and recording the energy consumption data and the corresponding batch information into a batch record table. By the technical means, the problems that the energy consumption of the existing manual copying production batch is easy to be wrong and leaked and the copying efficiency is low are solved, and the copying efficiency is improved while the copying accuracy is ensured.

Description

Production batch energy copying method, device, equipment and storage medium
Technical Field
The embodiment of the application relates to the technical field of metering, in particular to a production batch energy copying method, device, equipment and storage medium.
Background
Energy metering management is an important part in the production and operation process of enterprises, and factories routinely relate to energy consumption statistics of water, electricity, steam and the like. In the textile printing and dyeing industry, meters with various energy consumptions are installed on dyeing machines, boarding machines, mercerizing machines and other equipment in workshops, and workers need to manually copy the energy consumptions recorded by the meters.
At present, the energy consumption recording mode of the production batch is to manually record the energy consumption of the production batch by workers, manually record a meter before equipment production, manually record the meter after the production is finished, and calculate the difference value of the meter before and after the production. The existing manual recording mode for energy consumption of production batches is low in recording efficiency, and when the production batches are more, the manual recording is easy to have the problems of error, leakage and the like.
Disclosure of Invention
The embodiment of the application provides a production batch energy copying method, device, equipment and storage medium, solves the problems that the energy consumption of the existing manual copying production batch is easy to be mistaken and leaked and the copying efficiency is low, and improves the copying efficiency while ensuring the copying accuracy.
In a first aspect, an embodiment of the present application provides a production lot energy transcription method, including:
determining the starting time, the ending time and the batch information of a production batch, and creating a corresponding batch record table according to the starting time, the ending time and the batch information;
inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time;
and associating and recording the energy consumption data and the corresponding batch information into the batch record table.
Further, the determining the start time and the end time of the production lot comprises:
receiving a computer-on instruction sent by a controller of production equipment, and determining the starting time of the production batch according to the trigger time of the computer-on instruction;
receiving a machine-off instruction sent by the controller, and determining the end time of the production batch according to the trigger time of the machine-off instruction;
and acquiring a batch identifier corresponding to a production batch from the on-machine instruction or the off-machine instruction, and determining batch information of the production batch according to the batch identifier.
Further, the determining the start time and the end time of the production lot comprises:
receiving a machine-off instruction sent by a controller of production equipment, and acquiring batch information of the production batch according to the machine-off instruction, wherein the batch information comprises the running time of the production batch;
and determining the starting time and the ending time of the production batch according to the triggering time and the running time of the machine-off instruction.
Further, the batch information includes meter identification;
the querying, according to the batch information, the start time, and the end time, corresponding energy consumption data in a preset database includes:
inquiring energy consumption data of the corresponding meter in the database according to the meter identification;
and inquiring the energy consumption data of the meters of the corresponding time nodes according to the starting time and the ending time to obtain the energy consumption data of the corresponding production batches.
Further, the batch information comprises the conversion rate of the meter;
the associating and recording the energy consumption data and the corresponding batch information into the batch record table comprises:
and calculating an actual energy consumption value corresponding to the energy consumption data according to the conversion rate, and recording the actual energy consumption value into a corresponding batch record table.
Further, after the associating and recording the energy consumption data and the corresponding batch information into the batch record table, the method further includes:
summarizing the batch record table generated in the first preset time period to obtain a batch record statistical table;
summarizing the batch identifiers in the off-line instruction received in the first preset time period to obtain a batch identifier table;
comparing the batch identifier in the batch identifier table with the batch identifier in the batch record statistical table to determine the missing batch record table in the batch record statistical table;
and creating a corresponding first batch record table and recording corresponding energy consumption data according to the batch identifier of the missing batch record table.
Further, after the associating and recording the energy consumption data and the corresponding batch information into the batch record table, the method further includes:
scanning the energy consumption data of all the batch record lists generated in a second preset time period one by one, and determining a second batch record list lacking the energy consumption data in all the batch record lists;
and inquiring corresponding energy consumption data in the database according to the batch identification of the second batch record table, and recording the energy consumption data into the second batch record table.
In a second aspect, an embodiment of the present application provides a production lot energy copying apparatus, including:
the record table creating module is configured to determine the starting time, the ending time and the batch information of a production batch, and create a corresponding batch record table according to the starting time, the ending time and the batch information;
the data query module is configured to query corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time;
and the data entry module is configured to associate and enter the energy consumption data and the corresponding batch information into the batch record table.
In a third aspect, an embodiment of the present application provides a production lot energy copying apparatus, including:
one or more processors; a storage device storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement the method for energy transcription of a production lot as described in the first aspect.
In a fourth aspect, embodiments of the present application provide a storage medium containing computer-executable instructions for performing the method for energy transcription of a production lot as described in the first aspect when executed by a computer processor.
According to the method and the device, the corresponding batch record table is established according to the starting time, the ending time and the batch information by determining the starting time, the ending time and the batch information of the production batch; inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time; and associating and recording the energy consumption data and the corresponding batch information into a batch record table. By the technical means, the energy consumption data of the production batch are copied according to the starting time, the ending time and the batch information of the production batch, so that the energy consumption data of the production batch are automatically copied without manual copying of workers, the copying efficiency is improved, and the manual copying cost is saved. And querying the database to obtain the energy consumption data of the production batch, and inputting the energy consumption data into a corresponding batch record table to ensure the copying accuracy of the energy consumption data. And the historical batch record table is subjected to leakage detection and vacancy filling, and energy consumption data or the batch record table which is lost due to network faults is filled, so that the reliability of automatic copying is improved.
Drawings
FIG. 1 is a flow chart of a method for energy transcription of a production lot according to one embodiment of the present application;
FIG. 2 is a flowchart for determining a production lot according to an on-machine instruction and an off-machine instruction according to an embodiment of the present disclosure
FIG. 3 is a flow chart for determining a production lot based on a machine-coming instruction and a runtime provided by an embodiment of the present application;
FIG. 4 is a schematic structural diagram of a production system provided in an embodiment of the present application;
FIG. 5 is a flowchart illustrating a server querying energy consumption data of a production lot according to an embodiment of the present application;
FIG. 6 is a flowchart of a recording list of a missing batch according to an embodiment of the present application;
FIG. 7 is a flowchart of energy data in a patch batch record table according to an embodiment of the present disclosure;
FIG. 8 is a schematic diagram of an energy transcription apparatus for a production lot according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of a production lot energy transcription device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, specific embodiments of the present application will be described in detail with reference to the accompanying drawings. It is to be understood that the specific embodiments described herein are merely illustrative of the application and are not limiting of the application. It should be further noted that, for the convenience of description, only some but not all of the relevant portions of the present application are shown in the drawings. Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the operations (or steps) as a sequential process, many of the operations can be performed in parallel, concurrently or simultaneously. In addition, the order of the operations may be re-arranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.
The terms first, second and the like in the description and in the claims of the present application are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that embodiments of the application may be practiced in sequences other than those illustrated or described herein, and that the terms "first," "second," and the like are generally used herein in a generic sense and do not limit the number of terms, e.g., the first term can be one or more than one. In addition, "and/or" in the specification and claims means at least one of connected objects, a character "/" generally means that a preceding and succeeding related objects are in an "or" relationship.
The production batch energy resource transcription method provided in the embodiment of the application can be executed by production batch energy resource transcription equipment, the production batch energy resource transcription equipment can be realized in a software and/or hardware mode, and the production batch energy resource transcription equipment can be formed by two or more physical entities or one physical entity. For example, the energy transcription equipment for production batches can be equipment with strong computing power such as a server. In addition, the production batch energy copying device can execute the application program of the production batch energy copying method, and therefore, the production batch energy copying device can also be the application program itself running on the server.
For convenience of understanding, the present embodiment is described by taking the server as an example of the main body for executing the energy copying method for the production lot.
In one embodiment, a plurality of dyeing and finishing devices such as dyeing machines, boarding machines, mercerizing machines and the like are arranged in the textile printing and dyeing workshop, and each dyeing and finishing device is provided with a meter for recording energy consumption of water, electricity, steam and the like for counting energy consumption cost of each dyeing and finishing device. At present, the energy consumption data of each production batch of dyeing and finishing equipment needs to be counted so as to account the energy consumption cost of each order. However, the existing energy consumption copying mode of production batches is to manually copy meters by workers before production of equipment, and then to manually copy meters after production is finished, and calculate the difference between the meters before and after production. The energy consumption of production batches is copied by workers on the site of a workshop in real time, and the required labor cost is high. Moreover, the manual transcription has low transcription efficiency, and the manual transcription is easy to have the problems of error and leakage when the production batch is more. Once the manual copying is missed, follow-up copying is difficult to carry out, and the energy consumption statistical efficiency is seriously influenced. In view of the above, the embodiment of the application provides a production batch energy transcription method, and aims to improve transcription efficiency while ensuring transcription accuracy.
Fig. 1 is a flowchart illustrating a method for energy transcription of a production lot according to an embodiment of the present application. Referring to fig. 1, the energy source transcription method for production batches specifically includes:
s110, determining the starting time, the ending time and the batch information of the production batch, and creating a corresponding batch record table according to the starting time, the ending time and the batch information.
The production batch refers to the whole production flow of the dyeing and finishing equipment when the dyeing and finishing equipment executes a certain production task configured by workers. Illustratively, the staff can dispose the equipment sign of dyeing and finishing equipment at the management end in advance, count the strapping table sign of the strapping table of dyeing and finishing equipment energy consumption, the batch number of production batch, information such as output, the management end generates the production task according to above-mentioned information to this production task sends the controller that corresponds dyeing and finishing equipment. Or the staff directly configures the information in the controller of the dyeing and finishing equipment to generate the corresponding production task. The controller controls the dyeing and finishing equipment to start executing the production task as the starting time of the production batch, and the time when the dyeing and finishing equipment stops executing the production task is the ending time of the production batch.
In an embodiment, the server may determine the start time, the end time, and the lot information of the corresponding production lot according to the on-machine instruction and the off-machine instruction triggered by the controller. For example, fig. 2 is a flowchart for determining a production lot according to an on-machine instruction and an off-machine instruction according to an embodiment of the present application. As shown in fig. 2, the step of determining the start time, the end time and the batch information of the production batch according to the on-machine instruction and the off-machine instruction specifically includes S1101-S1103:
s1101, receiving a computer instruction sent by a controller of the production equipment, and determining the starting time of the production batch according to the trigger time of the computer instruction.
Wherein, the production equipment is the dyeing and finishing equipment in the embodiment. And after receiving the production task sent by the management end, the controller controls the dyeing and finishing equipment to automatically start executing the production task, and simultaneously triggers a computer-operating instruction after receiving the production task. The computer instruction includes a trigger time and a lot number of the production lot, and the computer instruction is understood to be a controller of the dyeing and finishing apparatus for notifying the server that the dyeing and finishing apparatus starts to process information of the production lot corresponding to the lot number at the trigger time. And after the server receives the computer instruction sent by the controller, determining that the dyeing and finishing equipment starts to process the production batch corresponding to the batch number at the triggering time, and taking the triggering time of the computer instruction as the starting time of the production batch. It is understood that the finishing and finishing equipment triggers the computer instruction at the same time when processing the production lot, so the trigger time of the computer instruction is equal to the start time of the production lot.
In another embodiment, after the controller receives the production task sent by the management terminal, the worker manually starts the dyeing and finishing equipment to start executing the production task. Illustratively, a worker scans the code and prints the card through the circulation card or a starting button of the controller triggers the controller to control the dyeing and finishing equipment to start executing the production task, and meanwhile, the controller triggers a computer-on instruction and sends the computer-on instruction to the server.
And S1102, receiving a machine-off instruction sent by the controller, and determining the end time of the production batch according to the trigger time of the machine-off instruction.
The next instruction includes a trigger time and a batch number of the production batch, and the next instruction can be understood as information that the controller of the dyeing and finishing apparatus notifies the server that the dyeing and finishing apparatus stops processing the production batch corresponding to the batch number at the trigger time. For example, after the dyeing and finishing device has processed the production lot, the worker scans the code and checks the card through the circulation card or a stop button of the controller triggers the controller to control the dyeing and finishing device to stop executing the production task, and at the same time, the controller triggers a machine-off instruction and sends the machine-off instruction to the server. And after the server receives the machine-unloading instruction sent by the controller, determining that the dyeing and finishing equipment stops processing the production batch corresponding to the batch number within the triggering time, and taking the triggering time of the machine-unloading instruction as the end time of the production batch. It is understood that the dyeing and finishing equipment stops processing the production lot and triggers the machine-down command, so the trigger time of the machine-down command is equal to the end time of the production lot.
In another embodiment, the production task includes a running time of the corresponding production lot, which is the time required for the worker to complete the production task according to the estimated dyeing and finishing equipment yield. The controller controls the dyeing and finishing equipment to start timing after the production batch is processed, and determines that the dyeing and finishing equipment finishes processing the production batch when the accumulated time is equal to the running time. Therefore, when the accumulated time is equal to the running time, the computer-operated instruction is triggered and sent to the server, and the server determines the end time of the production batch according to the trigger time of the computer-operated instruction.
S1103, obtaining the batch identification of the corresponding production batch from the on-machine instruction and the off-machine instruction, and determining the batch information of the production batch according to the batch identification.
The batch identifier refers to information for representing the identity of a production batch, and the batch identifier in this embodiment is a batch number of the production batch. The batch information comprises information such as dyeing and finishing equipment identification, meter identification and yield of a production batch. For example, after the management terminal generates the production task, the management terminal sends the production task to the server, and the server forwards the production task to the controller of the dyeing and finishing device, or the server may store the production task. And the server determines the corresponding production task according to the batch numbers in the on-machine instruction and the off-machine instruction, and acquires the batch information of the corresponding production batch from the production task.
In another embodiment, the server may determine the start time, the end time and the lot information of the corresponding production lot according to the down command triggered by the controller and the running time of the production lot. For example, fig. 3 is a flowchart for determining a production lot according to a machine-off instruction and a runtime, provided by an embodiment of the present application. As shown in fig. 3, the step of determining the start time, the end time and the batch information of the production batch according to the machine-unloading instruction and the running time specifically includes S1104-S1105:
s1104, receiving a machine-off instruction sent by a controller of the production equipment, and acquiring batch information of the production batch according to the machine-off instruction, wherein the batch information includes running time of the production batch.
Illustratively, the corresponding production task is determined according to the batch number in the machine-unloading instruction, and information such as the meter identification, the dyeing and finishing equipment identification and the running time of the corresponding production batch is obtained from the production task.
And S1105, determining the starting time and the ending time of the production batch according to the triggering time and the running time of the machine-off instruction.
Illustratively, the trigger time is obtained from the order of the shutdown and is taken as the end time of the production lot. The run time was subtracted from the end time to obtain the start time of the production lot.
Further, after receiving the shutdown instruction sent by the controller, the server determines that the production batch corresponding to the batch number in the shutdown instruction has been processed, and at the same time, triggers the energy consumption copying operation. And after the server triggers the energy consumption copying operation, creating a batch record table of the production batch according to the batch number, the starting time, the ending time, the dyeing and finishing equipment identifier, the meter identifier and other information of the production batch.
And S120, inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time.
In an embodiment, fig. 4 is a schematic structural diagram of a production system provided in an embodiment of the present application. As shown in FIG. 4, the production system comprises a dyeing and finishing device, a meter, a server and a management end, wherein the meter is installed on the dyeing and finishing device, the meter is connected with the server through a bus interface, the management end is connected with the server through a network, and the server is connected with a controller of the dyeing and finishing device. The meter is used for recording the energy consumption data of the dyeing and finishing equipment and storing the energy consumption data to a data warehouse DataHub of the server. The server is used for receiving the production task sent by the management end and sending the production task to the controller of the dyeing and finishing equipment. And the controller of the dyeing and finishing equipment is used for sending the machine-on instruction and the machine-off instruction to the server. The energy consumption data collected by the current time node are stored in a data warehouse DataHub of the server every one minute by the meter, and the meter identification and the collection timestamp are associated when the energy consumption data are stored in the data warehouse DataHub.
On the basis of the above embodiment, fig. 5 is a flowchart of querying, by a server, energy consumption data of a production lot provided by the embodiment of the present application. As shown in fig. 5, the step of querying the corresponding energy consumption data in the database by the server according to the meter identifier, the start time, and the end time specifically includes S1201-S1202:
and S1201, inquiring energy consumption data of the corresponding meter in the database according to the meter identification.
And S1202, inquiring energy consumption data of the meters of the corresponding time nodes according to the starting time and the ending time to obtain the energy consumption data of the corresponding production batches.
For example, the server may obtain the meter identifier from the batch information, and query the energy consumption data recorded in the corresponding meter in the data warehouse DataHub according to the meter identifier. And matching the starting time and the ending time with the acquisition time stamp of the energy consumption data recorded by the meter so as to inquire the energy consumption data acquired by the meter at the starting time and the energy consumption data acquired by the meter at the ending time. Further, the energy consumption data collected by the meter at the starting time is subtracted from the energy consumption data collected by the meter at the ending time, so that the energy consumption data required by the dyeing and finishing equipment for processing the production batch is obtained.
And S130, associating and recording the energy consumption data and the corresponding batch information into a batch record table.
In one embodiment, the batch information further includes a scaling factor of the meter. Because the energy consumption consumed by a plurality of large-scale devices far exceeds the upper limit value of the meter, the meter can be provided with conversion multiplying power, and the energy consumption data recorded by the meter is converted into an actual energy consumption value through the conversion multiplying power. The energy consumption data are directly stored into the data warehouse DataHub without multiplying factor conversion after the energy consumption data are collected by the meters, so that the actual energy consumption value of a production batch is calculated according to the conversion multiplying factor corresponding to the meters after the energy consumption data corresponding to the shift time are inquired, and the actual energy consumption value is recorded into the corresponding batch recording table. In this embodiment, when the worker configures the production task, the conversion rate of the meter may be configured in the production task together with the meter identifier, so that the subsequent server may obtain the conversion rate of the meter from the batch information corresponding to the production task.
In one embodiment, the server may not be able to create the batch table in time due to network jitter or network failure after receiving the order to download. Therefore, the present embodiment proposes to perform missing filling on all the batch record tables created within a certain time period to fill the missing batch record tables. In this embodiment, fig. 6 is a flowchart of an entry-missing batch record table provided in this embodiment of the present application. As shown in fig. 6, the step of supplementing the missing batch record table specifically includes steps S1401 to S1404:
s1401, summarizing the batch record table generated in the first preset time period to obtain a batch record statistical table.
The first preset time period is a time period configured by the staff according to actual needs, and may be one or more days, or a certain time period in one day. The batch record table generated in the first preset time period refers to a batch record table with the creation time within the first preset time period. And summarizing the batch record tables with the creation time within the first preset time period to obtain a batch record statistical table of the first preset time period. For example, assuming that the server checks whether the batch record table generated on the previous day is missing every day, all the batch record tables generated on the previous day may be queried according to the current date, and all the batch record tables may be summarized to obtain the batch record statistical table on the previous day. Table 1 is a statistical table of batch records provided in the embodiments of the present application.
TABLE 1
Creation time Batch number Energy consumption Yield of the product
08:50 in 25 days 1 40 20
25 days 10:50 2 30 30
25 days 12:50 3 20 10
25 days 14:50 4 10 10
As shown in table 1, assuming that the current date is 26, the server summarizes all the batch record tables created by 25, and obtains the batch record statistical table shown in table 1. The batch record statistical table comprises all batch record tables created under No. 25, and each batch record table records corresponding creation time, batch number, energy consumption and yield.
S1402, summarizing the batch identifiers in the off-line instruction received in the first preset time period to obtain a batch identifier table.
The batch identification table refers to a summary of the batch numbers in all the next-machine instructions received by the server within the same preset time period corresponding to the batch record statistical table. Illustratively, the server collects the batch record table created in the previous day to obtain a batch record statistical table in the previous day, and correspondingly collects the batch numbers in all the off-line instructions received in the previous day to obtain a batch identification table in the previous day. It should be noted that the time when the server receives the shutdown instruction is equivalent to the trigger time of the shutdown instruction, i.e., the end time of the production lot. And the server creates the batch record table after receiving the off-line instruction, namely the creation time of the batch record table is equivalent to the receiving time of the production batch. Therefore, in the same time period, if the server only receives the off-line instruction but does not create the corresponding batch record table, it indicates that the server is interfered by the outside world so that the creation step of the batch record table cannot be executed.
S1403, comparing the batch identifier in the batch identifier table with the batch identifier in the batch record statistical table to determine the missing batch record table in the batch record statistical table.
Illustratively, the number of the lot numbers in the lot identifier table is compared with the number of the lot record tables in the lot record statistical table, and if the number of the lot record tables in the lot record statistical table is smaller than the number of the lot numbers in the lot identifier table, it is determined that the lot record statistical table lacks the lot record tables. Further, comparing the batch numbers in the batch identification table with the batch numbers in the batch record statistical table one by one to determine the batch number of the missing batch record table in the batch record statistical table. If the batch numbers in the batch record statistical table are 1, 2, 3 and 5, and the batch numbers in the batch identification table are 1, 2, 3, 4 and 5, it can be determined that the batch record table missing in the batch record statistical table is the batch record table with the batch number of 4.
And S1404, creating a corresponding first batch record table according to the batch identifier of the missing batch record table and recording corresponding energy consumption data.
Illustratively, the corresponding machine unloading instruction and the machine loading instruction are inquired according to the batch number of the missing batch record table, and the starting time and the ending time are obtained from the machine loading instruction and the machine unloading instruction. And determining corresponding batch information according to the batch number, and creating a first batch record table of the batch number according to the starting time, the ending time and the batch information. The first batch record table refers to the additionally recorded batch record table.
Further, meter identification is obtained from the batch information, and corresponding energy consumption data in the data warehouse DataHub are inquired according to the meter identification, the starting time and the ending time. And recording a first batch of record tables after multiplying power conversion is carried out on the energy consumption data of the production batches, and summarizing the first batch of record tables to a batch record statistical table.
In an embodiment, when the server queries the energy consumption data in the data warehouse DataHub, problems such as network jitter or network failure may not be timely read to the energy consumption data. Therefore, the present embodiment proposes to perform missing and missing repair on all the batch record tables created within a certain time period to repair and record the missing energy consumption data. In this embodiment, fig. 7 is a flowchart of energy data in the supplementary batch record table provided in this embodiment. As shown in fig. 7, the specific steps of recording the energy data in the batch record table include S1501-S1502:
s1501, scanning the energy consumption data of all the batch record lists generated in the second preset time period one by one, and determining a second batch record list lacking the energy consumption data in all the batch record lists.
The second preset time period is a time period configured by the staff according to actual needs, and may be one or more days, or a certain time period in one day. For example, assuming that the server checks whether the energy consumption data in all the batch record tables generated in the previous day is missing every day, all the batch record tables generated in the previous day may be queried according to the current date, and the all the batch record tables may be summarized to obtain the batch record statistical table in the previous day. Table 2 is another statistical table of batch records provided in the examples of the present application.
TABLE 2
Creation time Batch number Energy consumption Yield of the product
08:50 in 25 days 1 40 20
25 days 10:50 2 30
25 days 12:50 3 20 10
25 days 14:50 4 10 10
As shown in Table 2, one row of the batch record table corresponds to one batch record table. And scanning the energy consumption data in the batch record statistical table line by line, determining the line number lacking the energy consumption data, and further determining a second batch record table lacking the energy consumption data and a corresponding batch number. The second batch table with missing energy consumption data as in table 2 is the batch table with batch number 2.
S1502, inquiring corresponding energy consumption data in the database according to the batch identification of the second batch record table, and recording the energy consumption data into the second batch record table.
Illustratively, the corresponding start time, end time and meter identification are obtained according to the batch number of the second batch record table, and the corresponding energy consumption data in the data warehouse DataHub is queried according to the meter identification, the start time and the end time. And performing magnification conversion on the energy consumption data of the production batch, and recording the energy consumption data into a second batch recording table. Illustratively, the batch statistical record table shown in table 1 is obtained after the missing energy consumption data in table 2 is recorded.
In summary, according to the method for copying the energy of the production batch provided by the embodiment of the application, by determining the starting time, the ending time and the batch information of the production batch, a corresponding batch record table is created according to the starting time, the ending time and the batch information; inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time; and associating and recording the energy consumption data and the corresponding batch information into a batch record table. By the technical means, the energy consumption data of the production batch are copied according to the starting time, the ending time and the batch information of the production batch, so that the energy consumption data of the production batch are automatically copied without manual copying of workers, the copying efficiency is improved, and the manual copying cost is saved. And querying the database to obtain the energy consumption data of the production batch, and inputting the energy consumption data into a corresponding batch record table to ensure the copying accuracy of the energy consumption data. And the historical batch record table is subjected to leakage detection and vacancy filling, and energy consumption data or the batch record table which is lost due to network faults is filled, so that the reliability of automatic copying is improved.
Fig. 8 is a schematic structural diagram of an energy transcription apparatus for production lot according to an embodiment of the present application. Referring to fig. 8, the production lot energy copying apparatus provided in this embodiment specifically includes: a record table creation module 21, a data query module 22 and a data entry module 23.
The record table creating module is configured to determine the starting time, the ending time and the batch information of a production batch, and create a corresponding batch record table according to the starting time, the ending time and the batch information;
the data query module is configured to query corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time;
and the data entry module is configured to associate and enter the energy consumption data and the corresponding batch information into the batch record table.
On the basis of the above embodiment, the record table creating module includes: the starting time determining unit is configured to receive an on-machine instruction sent by a controller of the production equipment and determine the starting time of the production batch according to the trigger time of the on-machine instruction; the first end time determining unit is configured to receive a machine-off instruction sent by the controller and determine the end time of the production batch according to the trigger time of the machine-off instruction; and the batch information determining unit is configured to acquire the batch identifier corresponding to the production batch from the on-machine instruction and the off-machine instruction and determine the batch information of the production batch according to the batch identifier.
On the basis of the above embodiment, the record table creating module includes: the system comprises a machine-unloading instruction receiving unit, a machine-unloading instruction receiving unit and a processing unit, wherein the machine-unloading instruction receiving unit is configured to receive a machine-unloading instruction sent by a controller of the production equipment, and the batch information of a production batch is acquired according to the machine-unloading instruction, and comprises the running time of the production batch; and the time determining unit is configured to determine the starting time and the ending time of the production batch according to the triggering time and the running time of the machine-off instruction.
On the basis of the above embodiment, the batch information includes meter identification; the data query module comprises: a first query unit configured to query energy consumption data of a corresponding meter in a database according to the meter identification; and the second query unit is configured to query the energy consumption data of the meters corresponding to the time nodes according to the starting time and the ending time to obtain the energy consumption data corresponding to the production batches.
On the basis of the embodiment, the batch information comprises the conversion multiplying power of the meter; the data entry module includes: and the conversion unit is configured to calculate an actual energy consumption value corresponding to the energy consumption data according to the conversion rate, and record the actual energy consumption value into a corresponding batch record table.
On the basis of the above embodiment, the production lot energy copying device further includes: the first summarizing module is configured to summarize the batch record table generated in a first preset time period to obtain a batch record statistical table; the second summarizing module is configured to summarize the batch identifiers in the off-line instruction received in the first preset time period to obtain a batch identifier table; the missing record table checking module is configured to compare the batch identifier in the batch identifier table with the batch identifier in the batch record statistical table to determine a missing batch record table in the batch record statistical table; and the first supplementing module is configured to create a corresponding first batch record table and record corresponding energy consumption data according to the batch identification of the missing batch record table.
On the basis of the above embodiment, the production lot energy copying device further includes: the missing energy consumption checking module is configured to scan the energy consumption data of all the batch record lists generated in a second preset time period one by one and determine a second batch record list which lacks the energy consumption data in all the batch record lists; and the second additional recording module is configured to query the corresponding energy consumption data in the database according to the batch identifier of the second batch record table, and record the energy consumption data into the second batch record table.
To sum up, the production batch energy copying device provided by the embodiment of the application establishes a corresponding batch record table according to the starting time, the ending time and the batch information by determining the starting time, the ending time and the batch information of a production batch; inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time; and associating and recording the energy consumption data and the corresponding batch information into a batch record table. By the technical means, the energy consumption data of the production batch are copied according to the starting time, the ending time and the batch information of the production batch, so that the energy consumption data of the production batch are automatically copied without manual copying of workers, the copying efficiency is improved, and the manual copying cost is saved. And querying the database to obtain the energy consumption data of the production batch, and inputting the energy consumption data into a corresponding batch record table to ensure the copying accuracy of the energy consumption data. And the historical batch record table is subjected to leakage detection and vacancy filling, and energy consumption data or the batch record table which is lost due to network faults is filled, so that the reliability of automatic copying is improved.
The production batch energy copying device provided by the embodiment of the application can be used for executing the production batch energy copying method provided by the embodiment, and has corresponding functions and beneficial effects.
Fig. 9 is a schematic structural diagram of a production lot energy transcription device provided in an embodiment of the present application, and referring to fig. 9, the production lot energy transcription device includes: a processor 31, a memory 32, a communication module 33, an input device 34, and an output device 35. The number of processors 31 in the production lot of energy copying machines may be one or more, and the number of memories 32 in the production lot of energy copying machines may be one or more. The processor 31, the memory 32, the communication module 33, the input device 34 and the output device 35 of the energy transcription apparatus for the production lot can be connected through a bus or other means.
The memory 32 is a computer readable storage medium, and can be used for storing software programs, computer executable programs, and modules, such as program instructions/modules corresponding to the production lot energy transcription method described in any embodiment of the present application (for example, the record table creation module 21, the data query module 22, and the data entry module 23 in the production lot energy transcription device). The memory 32 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the device, and the like. Further, the memory 32 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory may further include memory located remotely from the processor, and these remote memories may be connected to the device over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The communication module 33 is used for data transmission.
The processor 31 executes various functional applications of the equipment and data processing by running software programs, instructions and modules stored in the memory 32, so as to implement the production batch energy transcription method.
The input device 34 may be used to receive entered numeric or character information and to generate key signal inputs relating to user settings and function controls of the apparatus. The output device 35 may include a display device such as a display screen.
The production batch energy copying equipment can be used for executing the production batch energy copying method provided by the embodiment, and has corresponding functions and beneficial effects.
Embodiments of the present application also provide a storage medium containing computer-executable instructions that, when executed by a computer processor, perform a production lot energy transcription method, the production lot energy transcription method comprising: determining the starting time, the ending time and the batch information of a production batch, and creating a corresponding batch record table according to the starting time, the ending time and the batch information; inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time; and associating and recording the energy consumption data and the corresponding batch information into a batch record table.
Storage medium-any of various types of memory devices or storage devices. The term "storage medium" is intended to include: mounting media such as CD-ROM, floppy disk, or tape devices; computer system memory or random access memory such as DRAM, DDR RAM, SRAM, EDO RAM, Lanbas (Rambus) RAM, etc.; non-volatile memory such as flash memory, magnetic media (e.g., hard disk or optical storage); registers or other similar types of memory elements, etc. The storage medium may also include other types of memory or combinations thereof. In addition, the storage medium may be located in a first computer system in which the program is executed, or may be located in a different second computer system connected to the first computer system through a network (such as the internet). The second computer system may provide program instructions to the first computer for execution. The term "storage medium" may include two or more storage media residing in different locations, e.g., in different computer systems connected by a network. The storage medium may store program instructions (e.g., embodied as a computer program) that are executable by one or more processors.
Of course, the storage medium provided in the embodiments of the present application includes computer-executable instructions, and the computer-executable instructions are not limited to the production lot energy transcription method described above, and may also perform related operations in the production lot energy transcription method provided in any embodiment of the present application.
The production batch energy recording device, the storage medium, and the production batch energy recording apparatus provided in the above embodiments may execute the production batch energy recording method provided in any embodiment of the present application, and refer to the production batch energy recording method provided in any embodiment of the present application without detailed technical details described in the above embodiments.
The foregoing is considered as illustrative of the preferred embodiments of the invention and the technical principles employed. The present application is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present application has been described in more detail with reference to the above embodiments, the present application is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present application, and the scope of the present application is determined by the scope of the claims.

Claims (10)

1. A production batch energy transcription method is characterized by comprising the following steps:
determining the starting time, the ending time and the batch information of a production batch, and creating a corresponding batch record table according to the starting time, the ending time and the batch information;
inquiring corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time;
and associating and recording the energy consumption data and the corresponding batch information into the batch record table.
2. The method of claim 1, wherein determining the start time and the end time of the production lot comprises:
receiving a computer-on instruction sent by a controller of production equipment, and determining the starting time of the production batch according to the trigger time of the computer-on instruction;
receiving a machine-off instruction sent by the controller, and determining the end time of the production batch according to the trigger time of the machine-off instruction;
and acquiring batch identification corresponding to the production batch from the on-machine instruction and the off-machine instruction, and determining the batch information of the production batch according to the batch identification.
3. The method of claim 1, wherein determining the start time and the end time of the production lot comprises:
receiving a machine-off instruction sent by a controller of production equipment, and acquiring batch information of the production batch according to the machine-off instruction, wherein the batch information comprises the running time of the production batch;
and determining the starting time and the ending time of the production batch according to the triggering time and the running time of the machine-off instruction.
4. The production lot energy transcription method as recited in claim 1, wherein the lot information includes meter identification;
the querying, according to the batch information, the start time, and the end time, corresponding energy consumption data in a preset database includes:
inquiring energy consumption data of the corresponding meter in the database according to the meter identification;
and inquiring the energy consumption data of the meters of the corresponding time nodes according to the starting time and the ending time to obtain the energy consumption data of the corresponding production batches.
5. The method for transcribing an energy resource of a production lot of claim 1, wherein the lot information includes a conversion factor of a meter;
the associating and recording the energy consumption data and the corresponding batch information into the batch record table comprises:
and calculating an actual energy consumption value corresponding to the energy consumption data according to the conversion rate, and recording the actual energy consumption value into a corresponding batch record table.
6. The method according to claim 1, wherein after the associating the energy consumption data with the corresponding batch information into the batch record table, the method further comprises:
summarizing the batch record table generated in the first preset time period to obtain a batch record statistical table;
summarizing the batch identifiers in the off-line instruction received in the first preset time period to obtain a batch identifier table;
comparing the batch identifier in the batch identifier table with the batch identifier in the batch record statistical table to determine the missing batch record table in the batch record statistical table;
and creating a corresponding first batch record table and recording corresponding energy consumption data according to the batch identifier of the missing batch record table.
7. The method according to claim 1, wherein after the associating the energy consumption data with the corresponding batch information into the batch record table, the method further comprises:
scanning the energy consumption data of all the batch record lists generated in a second preset time period one by one, and determining a second batch record list lacking the energy consumption data in all the batch record lists;
and inquiring corresponding energy consumption data in the database according to the batch identification of the second batch record table, and recording the energy consumption data into the second batch record table.
8. A production batch energy resource transcription device is characterized by comprising:
the record table creating module is configured to determine the starting time, the ending time and the batch information of a production batch, and create a corresponding batch record table according to the starting time, the ending time and the batch information;
the data query module is configured to query corresponding energy consumption data in a preset database according to the batch information, the starting time and the ending time;
and the data entry module is configured to associate and enter the energy consumption data and the corresponding batch information into the batch record table.
9. An energy resource transcription device for production batches, comprising: one or more processors; a storage device storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement the method for energy transcription of a production lot as recited in any one of claims 1-7.
10. A storage medium containing computer-executable instructions for performing the method of energy transcription of a production lot of any one of claims 1-7 when executed by a computer processor.
CN202111315754.2A 2021-11-08 2021-11-08 Production batch energy copying method, device, equipment and storage medium Pending CN114036911A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111315754.2A CN114036911A (en) 2021-11-08 2021-11-08 Production batch energy copying method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111315754.2A CN114036911A (en) 2021-11-08 2021-11-08 Production batch energy copying method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN114036911A true CN114036911A (en) 2022-02-11

Family

ID=80143450

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111315754.2A Pending CN114036911A (en) 2021-11-08 2021-11-08 Production batch energy copying method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN114036911A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114756595A (en) * 2022-06-14 2022-07-15 希望知舟技术(深圳)有限公司 Data processing method for database and related device

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050040220A1 (en) * 2003-08-22 2005-02-24 Kuehr-Mclaren David G. Methods, systems and computer program products for communicating product status information
CN102053608A (en) * 2010-12-10 2011-05-11 浙江大学 Method for energy consumption interactive processing in production process

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050040220A1 (en) * 2003-08-22 2005-02-24 Kuehr-Mclaren David G. Methods, systems and computer program products for communicating product status information
CN102053608A (en) * 2010-12-10 2011-05-11 浙江大学 Method for energy consumption interactive processing in production process

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114756595A (en) * 2022-06-14 2022-07-15 希望知舟技术(深圳)有限公司 Data processing method for database and related device

Similar Documents

Publication Publication Date Title
CN104809030A (en) Android-based exception handling system and method
CN112597014B (en) Automatic test method and device based on data driving, medium and electronic equipment
CN111626443A (en) Operation and maintenance method, system, device, equipment and storage medium of power equipment
CN107015842B (en) Server-side program compiling and publishing management method and system
CN114036911A (en) Production batch energy copying method, device, equipment and storage medium
CN113049935A (en) Semiconductor intelligent detection system, intelligent detection method and storage medium
CN101153830B (en) Method, device and collecting terminal for measuring availability
CN112583610A (en) System state prediction method, system state prediction device, server and storage medium
CN112148574B (en) Performance data acquisition method, computer equipment and storage medium
CN110597198B (en) Quality control device, quality control system and quality control method for TFT substrate glass
CN103684814A (en) Method and device for comparing data of communication system
CN116796929A (en) Intelligent dynamic bottleneck detection method and system based on hybrid production line model
CN111654425A (en) Fault recording information acquisition method based on Modbus protocol and related equipment
CN111368353A (en) CAD drawing rollover method, system, device and storage medium
CN116126832A (en) Database switching method, switching device, electronic equipment and storage medium
CN116228103A (en) Inventory life cycle real-time management method and system
CN109685682A (en) The method of regulator control system inspection operation ticket is intelligently generated based on relational database
CN115114275A (en) Data acquisition method, device and medium
CN115456503A (en) Cable storage management system and method
CN102053571A (en) Data acquisition method of information acquisition terminal
CN111209138A (en) Operation and maintenance method and device of data storage system
CN114036910A (en) Energy consumption copying method, device, equipment and storage medium
CN112416995B (en) Data statistics method, device, computer equipment and storage medium
CN112199294A (en) Automatic software testing method and device
CN112395012A (en) Data clearing method and device based on double-core intelligent electric meter 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
RJ01 Rejection of invention patent application after publication

Application publication date: 20220211

RJ01 Rejection of invention patent application after publication