CN114036910A - Energy consumption copying method, device, equipment and storage medium - Google Patents
Energy consumption copying method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN114036910A CN114036910A CN202111315750.4A CN202111315750A CN114036910A CN 114036910 A CN114036910 A CN 114036910A CN 202111315750 A CN202111315750 A CN 202111315750A CN 114036910 A CN114036910 A CN 114036910A
- Authority
- CN
- China
- Prior art keywords
- energy consumption
- shift
- time
- meter
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- 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
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses an energy consumption copying method, device, equipment and storage medium. The technical scheme provided by the embodiment of the application comprises the following steps: determining meter identification of a meter to be copied and configured first shift information according to the meter reading task, wherein the first shift information comprises first shift time; inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification; and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time. By the technical means, the problems that errors and leakage easily occur and the copying efficiency is low in the existing manual meter reading are solved, and the copying efficiency is improved while the copying accuracy is ensured.
Description
Technical Field
The embodiment of the application relates to the technical field of metering, in particular to an energy consumption 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 and electricity and the like. In the textile printing and dyeing industry, meters for various energy consumptions are installed on dyeing machines, setting machines, mercerizing machines and other equipment in workshops, and workers manually copy the energy consumptions recorded by the meters according to shifts.
However, because of the fact that a lot of devices are arranged in a workshop, the types of installed meters are complex, and the copying modes of different devices or different meters are different, errors and omissions are easy to occur in manual copying, and the copying efficiency is low.
Disclosure of Invention
The embodiment of the application provides an energy consumption copying method, device, equipment and storage medium, solves the problems that errors and leakage easily occur in the existing manual meter reading 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 an energy consumption copying method, including:
determining meter identification of a meter to be copied and configured first shift information according to the meter reading task, wherein the first shift information comprises first shift time;
inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification;
and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time.
Further, the first shift time comprises a first start time and a first end time;
according to the first shift time and the meter identification, inquiring corresponding energy consumption data in a preset database comprises the following steps:
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 corresponding to the time nodes according to the first starting time and the first ending time to obtain the energy consumption data corresponding to the first shift time.
Further, the generating a first record table of the meter reading task according to the energy consumption data and the first shift time includes:
determining conversion multiplying power of the meter to be copied according to the meter reading task, and calculating an actual energy consumption value corresponding to the energy consumption data according to the conversion multiplying power;
and creating a first record table according to the first shift time, and recording the actual energy consumption value into a cell associated with the first shift time of the first record table.
Further, the first shift information includes shift dates; the energy consumption copying method further comprises the following steps:
receiving an editing operation, and adjusting the first shift time of the first shift information corresponding to the shift date according to the editing operation to obtain the second shift information corresponding to the shift date.
Furthermore, the meter reading task is configured with a time-of-day node;
after the second scheduling information corresponding to the scheduling date is obtained, the method further comprises the following steps:
comparing a first time node with the cross-day time node every interval of first preset time to determine the scheduling date of the first record list;
determining corresponding second scheduling information according to the scheduling date of the first record list, and determining whether the scheduling date of the second scheduling information is a working date according to a working calendar in the second scheduling information;
and when the scheduling date of the second scheduling information is determined to be the working date, inquiring corresponding energy consumption data in the database according to the second shift time of the second scheduling information and generating a second record table.
Further, the querying the corresponding energy consumption data in the database and generating a second record table according to the second shift time of the second shift information includes:
comparing the second shift time to the first shift time;
deleting the first record table and creating a second record table according to the second shift time when the second shift time is different from the first shift time;
and inquiring corresponding energy consumption data in the database according to the second shift time and the meter identification and recording the energy consumption data into a cell associated with the second shift time of the second record table.
Further, after the determining the shift schedule date of the first record table, the method further includes:
determining a third record table generated in a second preset time period according to the shift schedule date of the first record table;
and when the data volume in the third recording table is determined to be less than a preset data volume threshold value, inquiring corresponding energy consumption data in the database according to the third shift time lacking energy consumption data, and recording the energy consumption data into the third recording table.
In a second aspect, an embodiment of the present application provides an energy consumption copying apparatus, including:
the meter reading configuration module is configured to determine a meter identifier of a meter to be read and configured first shift information according to a meter reading task, wherein the first shift information comprises first shift time;
the data query module is configured to query corresponding energy consumption data in a preset database according to the first shift time and the meter identification;
and the data copying module is configured to generate a first recording table of the meter reading task according to the energy consumption data and the first shift time.
In a third aspect, an embodiment of the present application provides an energy consumption 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 of energy consumption transcription 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 of energy consumption transcription as described in the first aspect when executed by a computer processor.
According to the meter reading method and the meter reading device, the meter identification of the meter to be read and the configured first shift information are determined according to the meter reading task, and the first shift information comprises first shift time; inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification; and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time. Through the technical means, the energy consumption data are automatically copied according to the meter reading task after the worker configures the meter reading task, manual copying of the worker is not needed, the copying efficiency is improved, and the manual copying cost is saved. And inquiring the corresponding energy consumption data in the database according to the meter identification corresponding to the meter reading task and the shift time, and automatically copying the energy consumption data to the corresponding recording table, so that the copying accuracy of the energy consumption data is ensured. And the historical record table is subjected to leakage detection and defect filling, so that energy consumption data loss caused by network faults is avoided, and the reliability of automatic copying is improved.
Drawings
FIG. 1 is a flow chart of a method for energy consumption transcription provided by an embodiment of the present application;
FIG. 2 is a schematic structural diagram of an energy consumption transcription system provided in an embodiment of the present application;
FIG. 3 is a flow chart for querying energy consumption data in a database provided by an embodiment of the present application;
FIG. 4 is a flow chart of generating a record table provided by an embodiment of the present application;
FIG. 5 is a flowchart of updating a record table according to second shift information of a current shift date according to an embodiment of the present application;
FIG. 6 is a flowchart illustrating energy data transcription based on second shift schedule information according to an embodiment of the present disclosure;
FIG. 7 is a flow chart of energy consumption data entry provided by an embodiment of the present application;
FIG. 8 is a schematic diagram of an energy consumption transcription apparatus according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of an energy consumption 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 energy consumption copying method provided in the embodiment of the application may be executed by an energy consumption copying device, the energy consumption copying device may be implemented in a software and/or hardware manner, and the energy consumption copying device may be formed by two or more physical entities or may be formed by one physical entity. For example, the energy consumption copying device may be a terminal device such as a server with strong computing power. In addition, the energy consumption transcription device may execute an application program of the energy consumption transcription method, and thus, the energy consumption transcription device may also be an application program running on a server.
For convenience of understanding, the present embodiment is described by taking a server as an example of a main body for executing the energy consumption copying method.
In one embodiment, a plurality of dyeing and finishing devices such as dyeing machines, boarding machines and mercerizing machines are arranged in the textile printing and dyeing workshop, and each dyeing and finishing device is provided with a meter for recording water and electricity consumption for counting the energy consumption cost of each dyeing and finishing device. And the staff responsible for energy consumption recording manually records the energy consumption data of each meter from the shift time of the working day to the workshop site. When the types and the number of the meters configured in the workshop are large, the manual copying speed is low, and the copying efficiency is low. And manual copying is easy to have errors and omissions, and once errors and omissions occur, follow-up copying is difficult to achieve, so that the energy consumption statistical efficiency is seriously influenced. Therefore, in order to solve the problems of low manual transcription efficiency and low accuracy, the embodiment of the application provides an energy consumption transcription method, and aims to improve the transcription efficiency while the transcription accuracy is improved.
Fig. 1 is a flowchart illustrating a method for energy consumption transcription according to an embodiment of the present application. Referring to fig. 1, the energy consumption transcription method specifically includes:
s110, meter identification of a meter to be copied and configured first shift information are determined according to the meter reading task, wherein the first shift information comprises first shift time.
The meter reading task is a task of reading energy consumption data recorded by a corresponding meter, and is configured by a worker through a management terminal according to actual needs. The meter to be copied is the meter to be copied in the meter reading task. When configuring the meter reading task, the worker can select the corresponding meter identification of the meter to be copied, and then the energy consumption data of the meter to be copied is determined according to the meter identification in the meter reading task. In addition, the staff can also refer to the scheduling information of the dyeing and finishing equipment corresponding to the meter to be copied when configuring the meter reading task. The scheduling information refers to work information such as a work calendar, a shift time, a shift name and a belonging shift group of the corresponding dyeing and finishing equipment. The dyeing and finishing equipment operates according to the working time of a shift, and the energy consumption data recorded by the meter installed on the dyeing and finishing equipment also changes along with the operation of the dyeing and finishing equipment, so that the shift information corresponding to the dyeing and finishing equipment is directly quoted when the meter reading task is configured in the embodiment, and the energy consumption data corresponding to each shift of the dyeing and finishing equipment is accurately copied according to the shift time in the shift information.
In an embodiment, fig. 2 is a schematic structural diagram of an energy consumption transcription system provided in the embodiment of the present application. As shown in FIG. 2, the energy consumption copying 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, and the management end is connected with the server through a network. 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. And the server is used for receiving the meter reading task transmitted by the management terminal, inquiring and recording the energy consumption data in the data warehouse DataHub according to the meter reading task. Illustratively, a worker logs in an energy consumption transcription platform through a management terminal, inputs a meter identifier of a meter to be transcribed in a meter reading setting window of the energy consumption transcription platform, refers to shift information of dyeing and finishing equipment corresponding to the meter to be transcribed, and generates a meter reading task after inputting a day-crossing time node and various meter reading rules. After the worker configures the meter reading task on the energy consumption recording platform, the energy consumption recording platform sends the meter reading task to the server. In an embodiment, before configuring the meter reading task, configuring operation rules of a shift group, a shift name, shift time, a working calendar and the like of each dyeing and finishing device in a shift setup window to generate shift information, and operating the dyeing and finishing devices at corresponding shift time according to corresponding shift information.
Further, the server receives a meter reading task sent by the energy consumption recording platform, acquires the meter identification of the meter to be recorded and the referenced scheduling information of the dyeing and finishing equipment from the meter reading task, and acquires the shift time from the scheduling information. Wherein, the meter identification can be understood as the identity information of the meter, and referring to fig. 2, when the energy consumption data recorded by the meter is stored in the data warehouse DataHub, the meter identification and the energy consumption data recorded by the meter are stored in the data warehouse DataHub in a correlated manner, so as to inquire the corresponding energy consumption data through the meter identification in the following. The shift time comprises a starting time and an ending time corresponding to the shift, if the shift information is provided with an early shift and a late shift, the shift time of the early shift is 08: 00-20: 00, the shift time of the late shift is 20: 00-08: 00, and the starting time and the ending time of the early shift are 08:00 and 20:00 respectively.
It should be noted that the shift in the shift information may be a shift that is commonly used in the morning, the evening, the morning and the evening, or may be a shift that is custom-set by the staff according to actual needs, for example, one shift every hour. The number of shifts and the shift time can be configured in a shift arrangement window of the energy consumption copying platform, and the server performs energy consumption copying according to the shift received in the shift arrangement information.
And S120, inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification.
In one embodiment, the first scheduling information refers to the scheduling information currently used by the server. In the scheduling information, a plurality of shifts, such as an early shift and a late shift, are generally configured. The first shift time refers to the shift time of a shift in the shift information currently used by the server and comprises a first start time and a first end time, and the server transcribes the energy consumption data of the corresponding meters at the first start time and the first end time. In this embodiment, fig. 3 is a flowchart for querying energy consumption data in a database according to an embodiment of the present application. As shown in fig. 3, the step of querying the energy consumption data in the database 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 corresponding to the time nodes according to the first starting time and the first ending time to obtain the energy consumption data corresponding to the first shift.
Illustratively, referring to fig. 2, every one minute, the energy consumption data collected by the current time node is stored by the meter into the data warehouse DataHub of the server, and the energy consumption data is stored into the data warehouse DataHub by associating the meter identification and the collection timestamp. The server can inquire the energy consumption data recorded by the corresponding metering table in the data warehouse DataHub according to the metering table identification in the scheduling information. And matching the first starting time and the first ending time with the acquisition time stamp of the energy consumption data recorded by the metering table so as to inquire the energy consumption data acquired at the first starting time and the energy consumption data acquired at the first ending time. And taking the energy consumption data collected at the first starting time and the energy consumption data collected at the first ending time as the energy consumption data corresponding to the shift.
And S130, generating a first recording table of the meter reading task according to the energy consumption data and the first shift time.
In an embodiment, fig. 4 is a flowchart of generating a record table according to an embodiment of the present application. As shown in fig. 4, the step of generating the first record table specifically includes S1301-S1302:
and S1301, determining the conversion multiplying factor of the meter to be copied according to the meter reading task, and calculating the actual energy consumption value corresponding to the energy consumption data according to the conversion multiplying factor.
For example, since the energy consumption consumed by many large devices far exceeds the upper limit value of the meter, the meter may be provided with a conversion rate, and the energy consumption data recorded by the meter is converted into an actual energy consumption value through the conversion rate. The energy consumption data are directly stored in a data warehouse DataHub without multiplying factor conversion after the energy consumption data are collected by the meters, so that after the energy consumption data corresponding to the shift time are inquired, the actual energy consumption value is calculated according to the conversion multiplying factor corresponding to the meters, and the actual energy consumption value is recorded into the corresponding recording table. It should be noted that, when the staff configures the meter reading task, the conversion magnification of the meter and the meter identifier may be configured together in the meter reading task, so that the subsequent server may obtain the conversion magnification of the meter to be read from the meter reading task.
S1302, creating a first record table according to the first shift time, and recording the actual energy consumption value into a cell associated with the first shift time of the first record table.
In this embodiment, the server creates a record table for the shift at the time node of the first start time. If the earliest shift time in the scheduling information is 08: 00-20: 00, a record table with the shift time of 08: 00-20: 00 is created at 8 o' clock. After a record table with the shift time of 08: 00-20: 00 is created, energy consumption data collected at 08:00 of meters in a data warehouse DataHub are inquired within a certain time after 08: 00. The 08:00 energy consumption data is converted into a corresponding actual energy consumption value and is recorded into the 08:00 associated cell of the first record table. Likewise, energy consumption data collected by meters in the data warehouse DataHub at 20:00 is queried for a certain time after 20: 00. The energy consumption data of 20:00 is converted into the corresponding actual energy consumption value and is recorded into the cell associated with 20:00 of the first record table. It should be noted that the timestamp in the data warehouse further includes a collection date, and the energy consumption data of the day of the collection date is queried when the data warehouse is queried.
In an embodiment, after receiving the meter reading task, the server records the energy consumption data of all shifts according to a working calendar in the first shift scheduling information when the current date is the working date, and stops recording when the current date is the rest date. The energy consumption transcription platform provides a meter reading task editing function, and when a worker wants to modify a meter reading task of a certain shift date in a working calendar, the worker can modify the meter reading task through the energy consumption transcription platform. The shift schedule is a date of any day in the working calendar, and may be a rest date or a working date of the working calendar. In this embodiment, after the staff inputs the editing operation for adjusting the meter reading task on a certain shift date on the energy consumption recording platform of the management end, the server receives the editing operation, and adjusts the first shift time in the first shift information corresponding to the shift date according to the editing operation, so as to obtain the second shift information of the shift date. The second scheduling information is the latest scheduling information of a certain scheduling date obtained by adjusting the first scheduling information of the certain scheduling date. The editing operation is an operation of adjusting the shift of a certain shift date input by the staff. The shift adjustment includes adjusting the shift date from the work date to the rest date or adjusting the shift date from the rest date to the work date, deleting a part of the shift in the shift date or adding the shift, and modifying the shift time. And the server carries out energy consumption copying corresponding to the shift days according to the second shift information.
In an embodiment, as the staff can modify the meter reading task in real time from the management end, when the server uses the scheduling information of the current scheduling date to perform energy resource transcription, the first scheduling information of the current scheduling date is adjusted to be the second scheduling information, and at this time, the server needs to perform energy resource transcription according to the second scheduling information, so that the transcription accuracy is ensured. Therefore, the present embodiment provides that whether the scheduling information of the current scheduling date is adjusted can be determined at a certain time interval, so as to generate a new record table according to the adjusted second scheduling information. In this embodiment, fig. 5 is a flowchart of updating a record table according to second shift information of a current shift date according to an embodiment of the present application. As shown in fig. 5, the step of updating the record table according to the second shift information of the current shift date specifically includes S1401-S1403:
and S1401, comparing the first time node with the cross-day time node at intervals of first preset time, and determining the shift schedule of the first record list.
The first preset time is an interval time for judging whether the scheduling information is adjusted, and is generally set to be 5 minutes, and the first time node is a current time node. The day-crossing time node is a time node for distinguishing shift dates of two adjacent days, and can be set when a meter reading task is configured. The scheduled date means that the shift corresponds to a date in the work calendar, which may be a work day or a break day in the work calendar. It should be noted that the schedule date of a shift is different from the actual date of the transcription.
Illustratively, when the server transcribes the energy consumption data of a certain shift in the first shift information, the current time node and the cross-day time node are compared at intervals of 5 minutes, and if the current time node is smaller than the cross-day time node, the previous day of the real date corresponding to the current time node is used as the shift date of the current transcribed shift. And if the current time node is larger than the day-crossing time node, taking the real date corresponding to the current time node as the scheduling date of the current transcription shift. Assuming that the node of the time of day is 08:00, the server begins to copy the shift of 20: 00-08: 00 at 25 # 20: 00. And when the server judges that the number 21:00 is larger than the cross-day time node when the number 25 is 21:00, the server can determine that the scheduling date of the current copied shift is 25, and when the number 26 is 7:00, the number 7:00 is smaller than the cross-day time node, the server can determine that the scheduling date of the current shift is 25.
S1402, determining corresponding second scheduling information according to the scheduling date of the first record list, and determining whether the scheduling date of the second scheduling information is a working date according to a working calendar in the second scheduling information.
For example, a shift corresponds to a record table, and the shift date of the shift is the shift date of the corresponding record table. And acquiring corresponding second scheduling information according to the scheduling date of the current copied shift. And acquiring the work calendar from the second scheduling information, and determining whether the current scheduling date is a work date or a rest date according to the arrangement of the work calendar on the current scheduling date. When the scheduling date of the current copy shift is determined to be the rest date, the fact that the scheduling date of the current day in the working calendar is adjusted from the working date to the rest date by the staff at the management end can be known. And when the scheduling date is the rest date, the copy of the current shift is cancelled, and the corresponding record table is deleted.
It should be noted that if there is no second scheduling information corresponding to the scheduling date of the current copied shift, which indicates that the staff does not modify the scheduling information of the scheduling date of the current copied shift, the next procedure of updating the record table according to the scheduling date of the current copied shift is executed after 5 minutes.
And S1403, when the scheduling date of the second scheduling information is determined to be the working date, inquiring corresponding energy consumption data in the database according to the second shift time of the second scheduling information and generating a second recording table.
Illustratively, when the scheduling date of the current copy shift is determined to be the working date, it indicates that the server needs to execute the meter reading task modified by the staff according to the second scheduling information. In this embodiment, fig. 6 is a flowchart illustrating energy data transcription based on the second shift schedule information according to an embodiment of the present application. As shown in fig. 6, the step of copying the energy data according to the second shift information specifically includes steps S14031 to S14033:
and S14031, comparing the second time with the first time.
S14032, determining that the second time is different from the first time, deleting the first record table corresponding to the first time, and creating a second record table according to the second time.
S14033, inquiring the corresponding energy consumption data in the database according to the second shift time and the meter identification and recording the energy consumption data into a cell related to the second shift time of the second record table.
The second shift time refers to the shift time of each shift in the second shift information. When the staff adjusts the scheduling information of the scheduling date of the current recorded shift, part of the shift may be modified, so that the time of the second shift is compared with the time of the first shift to determine the modified shift. If the second time is the same as the first time, the fact that the worker does not modify the time corresponding to the first time is indicated, namely, the first record table corresponding to the first time is not required to be adjusted. If the second time is different from the first time, the staff member is indicated to modify the time corresponding to the first time. Since the first shift time is modified by the staff member, the energy data in the first record table is invalid data, and the first record table can be deleted. In this embodiment, if the current time node has exceeded the second-shift time, the corresponding second record table is directly created, the energy consumption data in the data warehouse DataHub is queried according to the second-shift time, and the actual energy consumption value is calculated according to the conversion rate and then recorded into the cell associated with the second-shift time of the second record table. And if the current time node does not reach the second-shift time, subsequently creating a corresponding second recording table when the second-shift time comes, and copying the energy consumption data to the corresponding cell. It should be noted that the second shift information is only for the corresponding shift date, and after the shift date passes, the server executes the meter reading task according to the first shift information.
In an embodiment, fig. 7 is a flowchart of energy consumption data entry provided in an embodiment of the present application. As shown in fig. 7, the energy consumption data entry step includes S1501 to S1502:
s1501, determining a third record table generated in a second preset time period according to the shift schedule date of the first record table.
S1502, when the data volume in the third record table is determined to be smaller than the preset data volume threshold, inquiring corresponding energy consumption data in the database according to the third shift time lacking the energy consumption data, and recording the energy consumption data into a cell associated with the second shift time of the third record table.
The second preset time period is a time period before the current shift scheduling date, and is set according to actual requirements. The third record table refers to a record table generated in a time period before the current shift schedule day, and if the current shift schedule date is 25, and the second preset time period is the previous day, the third record table is a record table generated when the shift schedule date is 24. The preset data volume threshold is the data volume when the third record table records energy consumption data of all shifts in the corresponding shift date, and is generally twice of the shift, that is, the start time of the shift corresponds to one data, and the end time of the shift corresponds to one data. After the corresponding record table is inquired according to the scheduling information, whether the total amount of data recorded in the record table is less than twice of the number of shifts or not is judged, if so, the record table does not copy the energy consumption data of all the shifts, and the shift lacking the energy consumption data can be subjected to energy consumption data additional recording. Wherein the third shift time refers to the shift times of all shifts in the third record table. And when the third recording table does not record the energy consumption data of all the shifts, determining the third shift time of the shift in which the energy consumption data is recorded through the third recording table, and inquiring the energy consumption data in the data warehouse DataHub according to the third shift time. And calculating the actual energy consumption value of the energy consumption data according to the conversion multiplying power, and then recording the actual energy consumption value into a cell corresponding to the third shift time of the third recording table.
In summary, according to the energy consumption copying method provided by the embodiment of the application, the meter identification of the meter to be copied and the configured first shift information are determined according to the meter reading task, and the first shift information includes the first shift time; inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification; and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time. Through the technical means, the energy consumption data are automatically copied according to the meter reading task after the worker configures the meter reading task, manual copying of the worker is not needed, the copying efficiency is improved, and the manual copying cost is saved. And inquiring the corresponding energy consumption data in the database according to the meter identification corresponding to the meter reading task and the shift time, and automatically copying the energy consumption data to the corresponding recording table, so that the copying accuracy of the energy consumption data is ensured. And the historical record table is subjected to leakage detection and defect filling, so that energy consumption data loss caused by network faults is avoided, and the reliability of automatic copying is improved.
Fig. 8 is a schematic structural diagram of an energy consumption transcription apparatus according to an embodiment of the present application. Referring to fig. 8, the energy consumption copying apparatus provided in this embodiment specifically includes: a copy configuration module 21, a data query module 22 and a data copy module 23.
The meter reading configuration module is configured to determine a meter identifier of a meter to be read and configured first shift information according to a meter reading task, wherein the first shift information comprises first shift time;
the data query module is configured to query corresponding energy consumption data in a preset database according to the first shift time and the meter identification;
and the data copying module is configured to generate a first recording table of the meter reading task according to the energy consumption data and the first shift time.
On the basis of the above embodiment, the first shift time includes a first start time and a first end time; 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 first starting time and the first ending time to obtain the energy consumption data corresponding to the first shift time.
On the basis of the above embodiment, the data transcription module includes: the conversion unit is configured to determine conversion multiplying power of the meter to be copied according to the meter reading task and calculate an actual energy consumption value corresponding to the energy consumption data according to the conversion multiplying power; and the first recording unit is configured to create a first record table according to the first shift time, and record the actual energy consumption value into the cell associated with the first shift time of the first record table.
On the basis of the above embodiment, the first shift information includes shift dates; the energy consumption copying device further comprises: the editing module is configured to receive editing operation, and adjust the first shift time of the first shift information corresponding to the shift date according to the editing operation to obtain second shift information corresponding to the shift date.
On the basis of the above embodiment, the meter reading task is configured with a time-of-day node, and the energy consumption recording device further includes: the shift schedule determining module is configured to compare the first time node with the cross-day time node every interval of first preset time and determine the shift schedule of the first record list; the working date judging module is configured to determine corresponding second scheduling information according to the scheduling date of the first record table and determine whether the scheduling date of the second scheduling information is the working date according to a working calendar in the second scheduling information; and the record table updating module is configured to query the corresponding energy consumption data in the database according to the second shift time of the second scheduling information and generate a second record table when the scheduling date of the second scheduling information is determined to be the working date.
On the basis of the above embodiment, the record table updating module includes: a time comparison unit configured to compare the second time of the shift with the first time of the shift; the record table updating unit is configured to delete the first record table corresponding to the first shift time and create a second record table according to the second shift time when the second shift time is determined to be different from the first shift time; and the second entry unit is configured to query the corresponding energy consumption data in the database according to the second shift time and the meter identification and enter the cell associated with the second shift time of the second record table.
On the basis of the above embodiment, the energy consumption transcription apparatus further includes: the additional recording table determining module is configured to determine a third recording table generated in a second preset time period according to the scheduling date of the first recording table; and the data supplement module is configured to query the corresponding energy consumption data in the database according to the third shift time lacking the energy consumption data when the data amount in the third record table is determined to be less than the preset data amount threshold, and record the energy consumption data into a cell associated with the second shift time of the third record table.
In summary, the energy consumption copying device provided in the embodiment of the present application generates the first record table according to the preset first shift information, where the first shift information includes the first shift time and the meter identifier; inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification; and associating and recording the energy consumption data and the corresponding first scheduling information into a first recording table. Through the technical means, the energy consumption data are automatically copied according to the scheduling information after the staff configures the scheduling information, manual copying of the staff is not needed, the copying efficiency is improved, and the manual copying cost is saved. And inquiring the energy consumption data corresponding to the shift time in the database and automatically copying the energy consumption data to a corresponding recording table, thereby ensuring the copying accuracy of the energy consumption data. And the historical record table is subjected to leakage detection and defect filling, so that energy consumption data loss caused by network faults is avoided, and the reliability of automatic copying is improved.
The energy consumption copying device provided by the embodiment of the application can be used for executing the energy consumption copying method provided by the embodiment, and has corresponding functions and beneficial effects.
Fig. 9 is a schematic structural diagram of an energy consumption transcription apparatus provided in an embodiment of the present application, and referring to fig. 9, the energy consumption transcription apparatus 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 energy consumption transcription device may be one or more, and the number of memories 32 in the energy consumption transcription device 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 consumption transcription apparatus may be connected by 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 energy consumption transcription method described in any embodiment of the present application (for example, the transcription configuration module 21, the data query module 22, and the data transcription module 23 in the energy consumption 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 and data processing of the device by executing software programs, instructions and modules stored in the memory 32, that is, the above-mentioned energy consumption transcription method is realized.
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 energy consumption copying equipment provided by the embodiment can be used for executing the energy consumption 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, which when executed by a computer processor, are configured to perform a method for energy consumption transcription, where the method for energy consumption transcription includes: determining meter identification of a meter to be copied and configured first shift information according to the meter reading task, wherein the first shift information comprises first shift time; inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification; and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time.
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 energy consumption transcription method described above, and may also perform related operations in the energy consumption transcription method provided in any embodiment of the present application.
The energy consumption copying device, the storage medium, and the energy consumption copying apparatus provided in the above embodiments may execute the energy consumption copying method provided in any embodiment of the present application, and refer to the energy consumption copying 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. An energy consumption transcription method is characterized by comprising the following steps:
determining meter identification of a meter to be copied and configured first shift information according to the meter reading task, wherein the first shift information comprises first shift time;
inquiring corresponding energy consumption data in a preset database according to the first shift time and the meter identification;
and generating a first recording table of the meter reading task according to the energy consumption data and the first shift time.
2. The method of energy consumption transcription as claimed in claim 1, characterized in that the first shift time comprises a first start time and a first end time;
according to the first shift time and the meter identification, inquiring corresponding energy consumption data in a preset database comprises the following steps:
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 corresponding to the time nodes according to the first starting time and the first ending time to obtain the energy consumption data corresponding to the first shift time.
3. The method of energy consumption transcription as claimed in claim 1, wherein said generating a first log of said meter reading task based on said energy consumption data and said first shift time comprises:
determining conversion multiplying power of the meter to be copied according to the meter reading task, and calculating an actual energy consumption value corresponding to the energy consumption data according to the conversion multiplying power;
and creating a first record table according to the first shift time, and recording the actual energy consumption value into a cell associated with the first shift time of the first record table.
4. The energy consumption transcription method as recited in claim 1, wherein the first shift information comprises shift dates; the energy consumption copying method further comprises the following steps:
receiving an editing operation, and adjusting the first shift time of the first shift information corresponding to the shift date according to the editing operation to obtain the second shift information corresponding to the shift date.
5. The energy consumption transcription method according to claim 4, characterized in that the meter reading task is configured with time-of-day nodes;
after the second scheduling information corresponding to the scheduling date is obtained, the method further comprises the following steps:
comparing a first time node with the cross-day time node every interval of first preset time to determine the scheduling date of the first record list;
determining corresponding second scheduling information according to the scheduling date of the first record list, and determining whether the scheduling date of the second scheduling information is a working date according to a working calendar in the second scheduling information;
and when the scheduling date of the second scheduling information is determined to be the working date, inquiring corresponding energy consumption data in the database according to the second shift time of the second scheduling information and generating a second record table.
6. The energy consumption transcription method as claimed in claim 5, wherein the querying the corresponding energy consumption data in the database according to the second shift time of the second shift information and generating a second record table comprises:
comparing the second shift time to the first shift time;
deleting the first record table and creating a second record table according to the second shift time when the second shift time is different from the first shift time;
and inquiring corresponding energy consumption data in the database according to the second shift time and the meter identification and recording the energy consumption data into a cell associated with the second shift time of the second record table.
7. The energy consumption transcription method as recited in claim 5, further comprising, after said determining a shift schedule date for said first record table:
determining a third record table generated in a second preset time period according to the shift schedule date of the first record table;
and when the data volume in the third record table is determined to be less than a preset data volume threshold, inquiring corresponding energy consumption data in the database according to the third shift time lacking the energy consumption data, and recording the energy consumption data into a cell associated with the second shift time of the third record table.
8. An energy consumption transcription device, comprising:
the meter reading configuration module is configured to determine a meter identifier of a meter to be read and configured first shift information according to a meter reading task, wherein the first shift information comprises first shift time;
the data query module is configured to query corresponding energy consumption data in a preset database according to the first shift time and the meter identification;
and the data copying module is configured to generate a first recording table of the meter reading task according to the energy consumption data and the first shift time.
9. An energy consumption transcription apparatus, 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 energy transcription method as recited in any of claims 1-7.
10. A storage medium containing computer-executable instructions for performing the method of energy transcription as claimed in any one of claims 1 to 7 when executed by a computer processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111315750.4A CN114036910A (en) | 2021-11-08 | 2021-11-08 | Energy consumption copying method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111315750.4A CN114036910A (en) | 2021-11-08 | 2021-11-08 | Energy consumption copying method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114036910A true CN114036910A (en) | 2022-02-11 |
Family
ID=80143454
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111315750.4A Pending CN114036910A (en) | 2021-11-08 | 2021-11-08 | Energy consumption copying method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114036910A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053608A (en) * | 2010-12-10 | 2011-05-11 | 浙江大学 | Method for energy consumption interactive processing in production process |
| CN108898818A (en) * | 2018-09-18 | 2018-11-27 | 深圳市迅想网络科技有限公司 | A kind of wireless meter system and its meter register method |
| CN112163728A (en) * | 2020-08-24 | 2021-01-01 | 珠海格力电器股份有限公司 | Energy consumption data processing method and device, electronic equipment and storage medium |
-
2021
- 2021-11-08 CN CN202111315750.4A patent/CN114036910A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053608A (en) * | 2010-12-10 | 2011-05-11 | 浙江大学 | Method for energy consumption interactive processing in production process |
| CN108898818A (en) * | 2018-09-18 | 2018-11-27 | 深圳市迅想网络科技有限公司 | A kind of wireless meter system and its meter register method |
| CN112163728A (en) * | 2020-08-24 | 2021-01-01 | 珠海格力电器股份有限公司 | Energy consumption data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113452145B (en) | Method and system for monitoring power utilization condition of low-voltage transformer area user | |
| KR101648272B1 (en) | Method for forecasting household water demand and detecting water leakage based on complex event processing and machine learning | |
| CN111583622B (en) | Metering information distribution processing system and method of double-core intelligent ammeter management unit | |
| CN109682436B (en) | Method for additionally reading meter reading data of gas meter of Internet of things | |
| CN101673363A (en) | Method and system for evaluating energy-consuming efficiency | |
| CN110097275A (en) | A kind of family change relational checking method and device based on platform area power failure data | |
| CN101153830B (en) | Method and device for measuring availability and collecting terminal | |
| CN111913933B (en) | Power grid historical data management method and system based on unified support platform | |
| WO2022267865A1 (en) | Workflow creation method and system, and electronic device and computer-readable storage medium | |
| CN113034307B (en) | Data acquisition method for power enterprise | |
| CN118333347B (en) | Steelmaking wastewater environmental protection treatment monitored control system | |
| CN108491432B (en) | Electric power system accumulated quantity storage and extraction method based on message abstract, electronic equipment and storage medium | |
| CN114036910A (en) | Energy consumption copying method, device, equipment and storage medium | |
| CN113570075A (en) | Remote monitoring software system for water meter | |
| CN111459720B (en) | Mysql data recovery method based on transaction log | |
| CN110737722B (en) | Substation monitoring background database, SCD and RCD synchronization system and method | |
| CN107578192A (en) | The operation indicator monitoring method of aviation settlement system | |
| CN114036911A (en) | Production batch energy copying method, device, equipment and storage medium | |
| CN111654425A (en) | Fault recording information acquisition method based on Modbus protocol and related equipment | |
| CN115114275A (en) | Data acquisition method, device and medium | |
| CN109918363A (en) | The method for carrying out data model coherency management based on view integration across database type | |
| CN115471092A (en) | Food production work reporting method and device, electronic equipment and storage medium | |
| CN115496379A (en) | Distribution network data verification application system and method | |
| CN115618825A (en) | Financial statement merging method and device, computer readable medium and terminal equipment | |
| CN110633270B (en) | Multi-strategy electric meter daily freezing value automatic substitution method and device based on priority |
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 |