Automatic work order reporting method, system and device and computer readable storage medium

Abstract

The invention belongs to the technical field of Internet of Things, and provides an automatic work order reporting method, system and device and a computer readable storage medium, and the method comprises the steps: S1, obtaining a work order source data table; s2, putting the work order source data table into a work order basic information catalog, and automatically inputting work order basic information; s3, when work order production begins, obtaining a work order information table needing to be produced, putting the work order information table into a work order production directory, and automatically updating state information of the work order; s4, in the work order production process, obtaining a work order reporting quantity table of the work order, putting the work order reporting quantity table into a work order reporting catalog, and automatically updating the work order reporting quantity of the work order; and S5, after work order production is completed, automatically counting the daily production quantity and the salary accounting of workers according to the finished quantity. According to the invention, the problem that the paper work order is easy to lose and damage is avoided, the production plan progress can be checked, the production data can be updated in real time, and the piece-counting salary can be automatically calculated, so that the problems in the prior art are effectively solved.

Description

Technical Field

[0001] The present invention belongs to the technical field of Internet of Things, and specifically, relates to a method, system, device and computer-readable storage medium for automatically reporting work orders. Background Art

[0002] Traditional manufacturing companies generally use paper to manage work orders, which results in the inability to count production in real time, the inability to track production progress, and increased difficulty in wage accounting. This is mainly due to the following shortcomings:

[0003] (1) Workers submit production reports verbally, and team leaders record them on paper documents. The entire production process is closed and has no system specifications. Data transmission is delayed, and production problems are difficult to trace.

[0004] (2) Production site management mainly relies on people, and data relies on paper and pen. The order progress cannot be clearly communicated to each link. When encountering special situations, such as inserting or changing orders, timely adjustments and tracking cannot be made, and the production status is relatively chaotic;

[0005] (3) The process is blocked, the progress is chaotic, and the workshop production data statistics are time-consuming and laborious, resulting in difficult wage calculations and large data deviations;

[0006] (4) If workers conceal, misreport, omit or delay reporting production data, it will lead to errors in reporting and statistics, making accurate reporting and statistics more difficult. Summary of the invention

[0007] The purpose of the present invention is to provide a method for automatically reporting work orders to solve the technical problems existing in the prior art.

[0008] In order to achieve the above object, the technical solution adopted by the present invention is as follows:

[0009] A method for automatically reporting a work order includes the following steps:

[0010] Step S1: Obtain the work order source data table;

[0011] Step S2: putting the work order source data table into the work order basic information directory to automatically enter the work order basic information;

[0012] Step S3: When the work order production starts, obtain the work order information table that needs to be produced, put it into the work order production directory, and automatically update the work order status information;

[0013] Step S4: During the work order production process, obtain the work order report quantity table, put it into the work report directory, and automatically update the work order report quantity;

[0014] Step S5: After the work order is completed, the daily production quantity and workers' salary calculation are automatically calculated based on the completed quantity.

[0015] In one implementation, the work order source data table, work order information table and reported work quantity table are all edited using EXCEL.

[0016] In one implementation, in step S2, the specific method for automatically entering the basic information of the work order is as follows:

[0017] Step S2.1: Check the file of the work order basic information directory;

[0018] Step S2.2: After the target file is detected, the basic data of the work order in the work order source data table is obtained through the EXECL reading method, and the obtained data is inserted into the database;

[0019] Step S2.3: Update the basic information of the work order and delete the target file.

[0020] In one embodiment, the EXECL reading method specifically comprises the following steps:

[0021] Step S2.1.1: Import the System.Data.OleDb namespace;

[0022] Step S2.1.2: Set the connection string to connect to the Excel file;

[0023] Step S2.1.3: Execute SQL statements to read data from the Excel file;

[0024] Step S2.1.4: The read data type is processed.

[0025] In one implementation, in step S3, the specific method for automatically updating the status information of the work order is as follows:

[0026] Step S3.1: Check the files in the work order production directory;

[0027] Step S3.2: After the target file is detected, the work order number and status information of the work order information table are obtained through the written EXECL reading method, and the obtained data is inserted into the database;

[0028] Step S3.3: Update the status information corresponding to the work order number and delete the target file information.

[0029] In one implementation, the specific method for automatically updating the reported work quantity of a work order is as follows:

[0030] Step S4.1: Check the files in the report directory;

[0031] Step S4.2: After the target file is detected, the reporting data information of the reporting quantity table is obtained through the written EXECL reading method, and the obtained data is inserted into the database;

[0032] Step S4.3: Update the reported work quantity corresponding to the work order number and delete the target file information.

[0033] In one embodiment, the database stores a work order basic data table, a work order information table, and a work quantity table.

[0034] To achieve the above object, the present invention also provides a work order automatic reporting system, comprising:

[0035] Work order source data table editing module: obtain the work order source data table;

[0036] Automatic entry module for basic work order information: puts the work order source data table into the work order basic information directory to automatically enter the work order basic information;

[0037] Work order status information automatic update module: when the work order production starts, obtain the work order information table to be produced, put it into the work order production directory, and automatically update the work order status information;

[0038] Automatic update module for work order reported quantity: During the work order production process, obtain the work order reported quantity table, put it into the work report directory, and automatically update the work order reported quantity;

[0039] Statistics module: After the work order is completed, the daily production quantity and workers' salary calculation are automatically calculated based on the completed quantity.

[0040] To achieve the above-mentioned purpose, the present invention also provides a computer-readable storage medium on which a computer program is stored. The computer program is executed by a processor to implement the method for automatically reporting work orders.

[0041] To achieve the above-mentioned purpose, the present invention also provides an automatic work order reporting device, including a processor and a memory; the memory is used to store computer programs; the processor is connected to the memory, and is used to execute the computer program stored in the memory, so that the automatic work order reporting device executes the above-mentioned automatic work order reporting method.

[0042] Compared with the prior art, the present invention has the following beneficial effects:

[0043] The present invention is based on a work order source data table, and realizes automatic update and statistics of work order status information, work order report quantity, production quantity and worker salary accounting at the beginning, during and after work order production, respectively. This not only avoids the problem of easy loss and damage of paper work orders, but also makes the production plan progress checkable, production data updated in real time, and piece-rate wages automatically calculated, thereby effectively solving the technical problems existing in the prior art. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 This is a schematic diagram of the process of Example 1 of the present invention.

[0045] Figure 2 This is a principle block diagram of Example 2 of the present invention.

[0046] Figure 3 This is a principle block diagram of Example 4 of the present invention. DETAILED DESCRIPTION

[0047] In order to enable those skilled in the art to have a clearer understanding and knowledge of the present invention, the present invention is further described in detail below in conjunction with the embodiments. It should be understood that the specific embodiments described below are only used to explain the present invention, and are convenient for understanding. The technical solutions provided by the present invention are not limited to the technical solutions provided by the following embodiments, and the technical solutions provided by the embodiments should not limit the protection scope of the present invention.

[0048] It should be noted that the illustrations provided in the following embodiments are only used to illustrate the basic concept of the present invention in a schematic manner. Therefore, the drawings only show components related to the present invention rather than being drawn according to the number, shape and size of components in actual implementation. In actual implementation, the form, quantity and proportion of each component may be changed arbitrarily, and the component layout may also be more complicated.

[0049] Example 1

[0050] like Figure 1 As shown, this embodiment provides a method for automatic reporting of work orders. The design principle of this method is: a console program is written in C# language, based on the work order source data table, and according to the characteristics of work order production, combined with the links at the beginning of work order production, during work order production, and after work order production is completed, to realize electronic processing of work order information.

[0051] In this embodiment, the specific steps of the work order automatic reporting method are as follows:

[0052] 1. Get the work order source data table

[0053] Use EXCEL to edit the basic information of the work order and obtain the sorted work order source data table; among them, the work order source data includes the work order number, work order quantity, production quantity, completion quantity, work order status, price (yuan / piece), work order start time, and work order end time.

[0054] 2. Automatic entry of basic work order information

[0055] The work order source data table is placed in the work order basic information directory to automatically enter the work order basic information. The method for automatically entering the work order basic information is as follows: (1) Detect the file in the work order basic information directory; (2) After detecting the target file, obtain the work order basic data in the work order source data table through the written EXECL reading method; (3) Insert the obtained work order basic data into the database and delete the target file. After completing the update of the work order basic information, it is displayed through the work order interface.

[0056] The EXECL reading method is as follows: (1) Introduce the System.Data.OleDb namespace; (2) Set the connection string to connect to the Excel file; (3) Execute the SQL statement to read the data in the Excel file; (4) Process the read data type. In this step, the data processing method is data format conversion, and the data format conversion is performed according to the type required by the database. For example, if a string type is required, the processing method is as follows: string name = reader.GetString (0).

[0057] It should be noted that the EXECL reading method described below also adopts this EXECL reading method. The database stores matching work order basic data tables, work order information tables, and reported work quantity tables. Based on different data table types, the data obtained by this EXECL reading method is inserted into the corresponding work order basic data tables, work order information tables, or reported work quantity tables in the database; therefore, it will not be repeated below.

[0058] 3. When the work order production starts, the status information of the work order is automatically updated

[0059] When the work order production starts, obtain the work order information table to be produced, put it into the work order production directory, and automatically update the work order status information. The work order information table is edited using EXCEL; the work order information table includes the work order number, work order quantity, and work order status. The method for automatically updating the work order status information is as follows: (1) Detect the file in the work order production directory; (2) After detecting the target file, obtain the work order number and status information of the work order information table through the written EXECL reading method, and insert the obtained data into the database; (3) According to the obtained work order number and status information, update the status information corresponding to the work order number, and delete the target file information. After the update is completed, the latest status information is displayed through the work order interface.

[0060] 4. Automatically update the number of work orders during the work order production process

[0061] During the work order production process, the work order's reported quantity table is obtained and placed in the report directory. The work order's reported quantity is automatically updated. The report quantity table is edited using EXCEL. The method for automatically updating the work order's reported quantity is as follows: (1) Detect the files in the report directory; (2) After detecting the target file, obtain the report data information of the report quantity table through the written EXECL reading method, and insert the obtained data into the database; (3) According to the obtained work order number and reported quantity, update the reported quantity corresponding to the work order number, and delete the target file information. After completing the update of the reported quantity, display the latest reported quantity through the work order interface.

[0062] 5. After the work order is completed, the production quantity and workers' wages are automatically counted

[0063] Automatically count the daily production quantity and workers' salary calculation based on the completed quantity. Specifically, query the completed quantity of the work order on that day based on the start and end time of the work order, and calculate the worker's salary based on the completed quantity.

[0064] Example 2

[0065] like Figure 2 As shown, this embodiment provides a work order automatic reporting system, including the following functional modules:

[0066] Work order source data table editing module: obtain the work order source data table;

[0067] Automatic entry module for basic work order information: puts the work order source data table into the work order basic information directory to automatically enter the work order basic information;

[0068] Work order status information automatic update module: when the work order production starts, obtain the work order information table to be produced, put it into the work order production directory, and automatically update the work order status information;

[0069] Automatic update module for work order reported quantity: During the work order production process, obtain the work order reported quantity table, put it into the work report directory, and automatically update the work order reported quantity;

[0070] Statistics module: After the work order is completed, the daily production quantity and workers' salary calculation are automatically calculated based on the completed quantity.

[0071] The working principle of each functional module described above corresponds to the method provided in Example 1, so it will not be described here. It should be noted that it should be understood that the division of each module of the above system is only a division of logical functions, and in actual implementation, all or part of it can be integrated into one physical entity.

[0072] Example 3

[0073] This embodiment provides a computer-readable storage medium, on which a computer program is stored, and the computer program is executed by a processor to implement a method for automatically reporting a work order provided in Example 1. A person of ordinary skill in the art can understand that all or part of the steps of implementing the method provided in Example 1 can be completed by hardware related to the computer program, and the above-mentioned computer program can be stored in a computer-readable storage medium, and when the program is executed, the steps of the method provided in Example 1 are executed; and the above-mentioned storage medium includes: ROM, RAM, magnetic disk or optical disk and other media that can store program codes.

[0074] Example 4

[0075] like Figure 3 As shown, this embodiment provides an automatic work order reporting device, including: a processor and a memory; the memory is used to store computer programs; the processor is connected to the memory, and is used to execute the computer program stored in the memory, so that an automatic work order reporting device executes an automatic work order reporting method provided in Example 1.

[0076] Specifically, the memory includes: ROM, RAM, disk, USB flash drive, memory card or CD and other media that can store program codes.

[0077] Preferably, the processor can be a general-purpose processor, including a central processing unit, a network processor, etc.; it can also be a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component.

[0078] The above embodiments are merely illustrative of the principles and effects of the present invention, and are not intended to limit the present invention. Anyone familiar with the art may modify or alter the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or alterations made by a person of ordinary skill in the art without departing from the spirit and technical concept disclosed by the present invention shall still be covered by the claims of the present invention.

Claims

1. A method for automatically reporting work orders, characterized in that: The following steps are involved: Step S1: Obtain the work order source data table; Step S2: putting the work order source data table into the work order basic information directory to automatically enter the work order basic information; Step S3: When the work order production starts, obtain the work order information table that needs to be produced, put it into the work order production directory, and automatically update the work order status information; Step S4: During the work order production process, obtain the work order report quantity table, put it into the work report directory, and automatically update the work order report quantity; Step S5: After the work order is completed, the daily production quantity and workers' salary calculation are automatically calculated based on the completed quantity.

2. The method for automatically reporting work orders according to claim 1, characterized in that: The work order source data table, work order information table and reported work quantity table are all edited using EXCEL.

3. The method for automatically reporting work orders according to claim 2, characterized in that: In step S2, the specific method for automatically entering the basic information of the work order is as follows: Step S2.1: Check the file of the work order basic information directory; Step S2.2: After the target file is detected, the basic data of the work order in the work order source data table is obtained through the EXECL reading method, and the obtained data is inserted into the database; Step S2.3: Update the basic information of the work order and delete the target file.

4. The method for automatically reporting work orders according to claim 3, characterized in that: The EXECL reading method specifically comprises the following steps: Step S2.1.1: Import the System.Data.OleDb namespace; Step S2.1.2: Set the connection string to connect to the Excel file; Step S2.1.3: Execute SQL statements to read data from the Excel file; Step S2.1.4: The read data type is processed.

5. The method for automatically reporting work orders according to claim 4, characterized in that: In step S3, the specific method of automatically updating the status information of the work order is as follows: Step S3.1: Check the files in the work order production directory; Step S3.2: After the target file is detected, the work order number and status information of the work order information table are obtained through the written EXECL reading method, and the obtained data is inserted into the database; Step S3.3: Update the status information corresponding to the work order number and delete the target file information.

6. The method for automatically reporting work orders according to claim 5, characterized in that: In step S4, the specific method for automatically updating the reported work quantity of the work order is as follows: Step S4.1: Check the files in the report directory; Step S4.2: After the target file is detected, the reporting data information of the reporting quantity table is obtained through the written EXECL reading method, and the obtained data is inserted into the database; Step S4.3: Update the reported work quantity corresponding to the work order number and delete the target file information.

7. The method for automatically reporting work orders according to claim 6, characterized in that: The database stores a work order basic data table, a work order information table and a work quantity report table.

8. A work order automatic reporting system, characterized in that: include: Work order source data table editing module: obtain the work order source data table; Automatic entry module for basic work order information: puts the work order source data table into the work order basic information directory to automatically enter the work order basic information; Work order status information automatic update module: when the work order production starts, obtain the work order information table to be produced, put it into the work order production directory, and automatically update the work order status information; Automatic update module for work order reported quantity: During the work order production process, obtain the work order reported quantity table, put it into the work report directory, and automatically update the work order reported quantity; Statistics module: After the work order is completed, the daily production quantity and workers' salary calculation are automatically calculated based on the completed quantity.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: The computer program is executed by a processor to implement a method for automatically reporting work orders as described in any one of claims 1 to 7.

10. A work order automatic reporting device, characterized in that: include: Processor and memory; The memory is used to store computer programs; the processor is connected to the memory and is used to execute the computer programs stored in the memory, so that the work order automatic reporting device executes the work order automatic reporting method as described in any one of claims 1 to 7.

Images