A production process recording method

Abstract

The present invention discloses a production process recording method, which realizes the construction of production process by configuring table process record templates and adjusting the sequence of worksheets, or realizes the construction of production process by flowchart technology and binds corresponding process record templates by process, so as to realize the execution of different process records in different technological stages; after the execution is completed, a complete process record can be formed according to the actual execution sequence, so that only specific record templates are executed for specific processes during the execution process. This method realizes the flexible adjustment of the recording sequence and recording content of the process through the configuration scheme when facing the production process environment in which manufacturing engineering is diverse and frequently adjusted, so that similar processes and flows can be reused, thereby shortening the customization implementation cycle while meeting the actual production needs.

Description

Technical Field

[0001] The present invention relates to the technical field of industrial automated production, and in particular to a production process recording method. Background Art

[0002] Recording production procedures is an essential part of the industrial production process. The recorded production procedures can be used as a "reproduction" of the corresponding production process to trace the details of the production process. At the same time, the recorded production procedures can also be used as a basis for analyzing the degree of operational standardization in the production process, determining the quality status of the products produced, etc., and comprehensively reflecting the product quality and equipment operation in the production process, providing a basis for taking corrective and preventive measures and improving the process.

[0003] During the production process of workshop operators, manufacturing enterprises need to record the key process parameters of each process in the production process. At present, common recording methods include Word / Excel, paper documents, and self-built systems. These solutions are insufficient in flexibility and reusability in the actual application of enterprises. This is mainly reflected in the following aspects: using document editing tools such as Word / Excel, it is impossible to quickly locate the current production record template according to the current production process. Using paper documents, it is impossible to generate record templates in a timely and flexible manner according to the needs of the production enterprise; when adjusting, the electronic template needs to be re-edited, and then printing and copying operations are performed. When using the self-built system of the enterprise, a detailed production record template needs to be customized for each production line / production process; when the production process is adjusted and the record content is adjusted, the customized production module needs to be modified accordingly; the production templates of each production workshop and process need to be customized, and cannot be reused in other workshops with different processes, which has poor flexibility and a long development cycle and cost. Summary of the invention

[0004] In view of the deficiencies in the prior art, the present invention provides a production process recording method, which specifically includes: obtaining a target production process flow corresponding to a production process, the target production process flow including at least one production process on a production line, and configuring a record template for each process; generating a process table document containing information on each process of the target production process flow, the process table document being provided with a plurality of worksheets, each worksheet corresponding to a specific process record template; obtaining an arrangement order of each worksheet in the process table document, and sequentially calling corresponding worksheets according to a preset calling order; performing execution operations on cell controls in the called worksheets according to preset execution rules and generating operation records, and collecting input production process data according to the corresponding process record template to generate process execution record information; splicing the execution record information of each process in the execution order to generate batch record information recording the production process.

[0005] Preferably, the step obtains the arrangement order of each worksheet in the process table document, and calls the corresponding worksheet in sequence according to a preset calling order, specifically including: obtaining the arrangement order of each worksheet in the process table document; calling each worksheet in sequence according to the arrangement order of the worksheets in the process table document.

[0006] Preferably, the step performs operations on the cell controls in the called worksheet according to preset execution rules and generates operation records, specifically including: executing the cell controls located in the specified area in the called worksheet according to preset execution requirements according to preset execution rules, and the preset execution requirements include specifying execution of the entire worksheet or a specific part of the worksheet, and the specific part of the worksheet includes a specific number of rows or columns or cells of the worksheet.

[0007] Preferably, the cell controls include but are not limited to one or more of a numeric control, a text control, an enumeration control, an electronic signature control, and a label jump control; the numeric control is used to obtain operator input information and record key process parameters; the text control is used to obtain operator input information and record a description of the production process; the enumeration control is used to obtain operator input and record alternative operation actions; the electronic signature control is used to obtain signature information of the operator / reviewer to confirm the operation in the production process; the label jump control is used to configure the next execution content of the process to jump to a specified label when the obtained input parameters or records meet certain conditions.

[0008] The present invention also discloses another production process recording method, comprising: obtaining a target production process flow corresponding to a production process, the target production process flow including at least one production process on a production line, and configuring a record template for each process; calling a process flow chart configuration tool according to the target production process flow to create a process flow chart, wherein each step of the process flow chart is bound to a corresponding process worksheet or a specific area in a process worksheet, and the process worksheet includes a corresponding process record template; calling the corresponding process worksheet bound to the current step in sequence according to the execution sequence of the process flow chart; executing operations on cell controls located in a specific area of ​​the called process worksheet or the process worksheet according to preset execution rules and generating operation records, and collecting input production process data according to the corresponding process record template to generate process execution record information; splicing the execution record information of each process in the execution sequence to generate batch record information recording the production process.

[0009] Preferably, the step performs an operation on a cell control located in a called process worksheet or a specific area in the process worksheet according to a preset execution rule and generates an operation record, specifically including: obtaining flowchart step binding information, when a step is bound to the entire process worksheet, then when executing the process worksheet, each cell control is executed and recorded in sequence according to the execution rules from top to bottom and from left to right; when a step is bound to a specific area in the process worksheet, the specific area includes a specific number of rows or columns or cells in the process worksheet, and each cell control in the specific area is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

[0010] Preferably, when executing a specific area in a process worksheet bound to a step, only the record content of the specific area is displayed, and the process worksheet content outside the specific area is not displayed.

[0011] The present invention also discloses a production recording device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any of the above-mentioned production recording methods when executing the computer program.

[0012] The present invention also discloses a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of any of the above-mentioned production record methods are implemented.

[0013] A production process recording method of the present invention realizes the construction of the production process by configuring the table process record template and adjusting the sequence of the worksheet, or uses the flowchart technology to realize the construction of the production process and bind the corresponding process record template by process, so as to realize the execution of different process records in different technological stages; after the execution is completed, a complete process record can be formed according to the actual execution sequence. It is realized that only specific record templates are executed for specific processes during the execution process. Through this method, in the face of a production process environment in which manufacturing engineering is diverse and frequently adjusted, the recording sequence and content of the processes can be flexibly adjusted through the configuration scheme, and similar processes and flows can be reused, thereby shortening the customization implementation cycle while meeting the actual production needs.

[0014] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0016] Figure 1 The present invention is a flowchart of a production recording method disclosed in an embodiment of the present invention.

[0017] Figure 2 A schematic flow chart of a production recording method disclosed in another embodiment of the present invention.

[0018] Figure 3 A schematic flow chart of a production recording method disclosed in another embodiment of the present invention.

[0019] Figure 4 A schematic diagram of an electronic process record template disclosed in an embodiment of the present invention.

[0020] Figure 5 The figure is a flowchart of a method for executing the first process disclosed in one embodiment of the present invention.

[0021] Figure 6 A schematic diagram of the steps of creating a process flow chart disclosed in one embodiment of the present invention.

[0022] Figure 7 A schematic diagram of binding corresponding process steps to a process flow chart disclosed in an embodiment of the present invention.

[0023] Figure 8 The figure is a flow chart of a method for executing the second process disclosed in one embodiment of the present invention.

[0024] Fig. 9 A schematic diagram of a process table document disclosed in an embodiment of the present invention.

[0025] Fig.10 This is a specific schematic diagram of step S232 disclosed in one embodiment of the present invention.

[0026] Fig.11 A schematic diagram of a worksheet sequence adjustment function disclosed in an embodiment of the present invention.

[0027] Fig.12 This is a schematic diagram of the principle of a production process recording device disclosed in one embodiment of the present invention. DETAILED DESCRIPTION

[0028] In order to make the purpose, technical solution and advantages of the embodiment of the present invention clearer, the technical solution of the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiment of the present invention. Obviously, the described embodiment is a part of the embodiment of the present invention, not all of the embodiments. Based on the described embodiment of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0029] In the present invention, unless otherwise clearly specified and limited, the technical terms or scientific terms used herein shall have the common meanings understood by persons with ordinary skills in the field to which the present invention belongs. The words "first", "second" and similar words used in the patent application specification and claims of the present invention do not indicate any order, quantity or importance, but are only used to distinguish different components. Similarly, words such as "one" or "an" do not indicate a quantity limitation, but indicate the existence of at least one.

[0030] Batch production record, referred to as BPR (Batch Process Record), is a document that records the raw and auxiliary materials used and the operations performed during the manufacturing process of a batch of products, including the details of the control in the manufacturing process. During the production process of workshop operators, manufacturing companies need to record the key process parameters of each process in the production process, as well as operation records. Currently, common recording methods include Word / Excel, paper documents, and self-built systems. These solutions are insufficient in flexibility and reusability in actual enterprise applications. The present invention discloses a process recording method based on flow charts and tables, which can be applied to various batch recording systems.

[0031] Attached Figure 1 A production process recording method disclosed in an embodiment of the present invention may include the following steps:

[0032] S101, obtaining a target production process flow corresponding to a production process, wherein the target production process flow includes at least one production process on a production line, and configuring a record template for each process.

[0033] A production line generally includes multiple production processes, and each production process can be regarded as a production link in the production process. For increasingly modernized intelligent production lines, different production processes on a production line, or even different operating orders of the same production process, can be used to produce different products. For example, a production line includes production process 1, production process 2, and production process 3. Then, if production process 1 and production process 2 are run in this order, product A is produced; if production process 1, production process 2, and production process 3 are run in this order, product B is produced; if production process 2, production process 1, and production process 3 are run in this order, product C is produced. By preparing the relevant information of the production line to be implemented in advance, sorting out the production process flow, and configuring the electronic process record template according to the needs of the production process record, the electronic process record template can be as shown in the attached Figure 2As shown, the electronic process record template can be set according to the characteristics of the production line, or according to the data required for the production. Specifically, it can include: basic information corresponding to the production process (such as task name, start time, end time, task status, work center, work order number, temperature, pressure and other indicators), user operations corresponding to the production process (such as time, user, work center, operation station and operation behavior, etc.), and task details corresponding to the production process (recorded process data, such as input or output values, etc.). Among them, operation behaviors may include: signing, revising, and writing values; task details can also record the text of a production process of this production, which is used to provide users with analysis of this production, guidance and prompts for subsequent production, etc. The electronic process record template containing the above content can be saved in the form of a spreadsheet containing various cell controls. Among them, cell controls can be divided into general, value, text, enumeration, date and time, electronic signature, hyperlink, label jump and other controls according to type. The specific functions of each control are as follows:

[0034] Conventional controls: You can directly input content to display static text prompts in process records; you can also set label items to indicate when to jump to a specified label item based on different process parameters during execution.

[0035] Numeric controls: can be used for operators to input and record key process parameters; support integers and floating-point numbers; support setting the unit, format (i.e. integer digits and hour digits), maximum and minimum values ​​of the values; when the operator is recording, he can require forced input or choose to skip according to the pre-set settings, and the input value must fall within the range between the maximum and minimum values.

[0036] Text control: can be used for operators to input and record the description of the production process; when the operator is recording, it can be required to force input or choose to skip according to the pre-set; the text control can enter the initial value and prompt when entering.

[0037] Enumeration control: can be used for operators to input and record alternative operation actions; when the operator is recording, it can be required to force input or choose to skip according to pre-set; the enumeration control can set the operation selection style, provide radio button or drop-down list style, which is convenient for operators to use.

[0038] Date and time control: can provide operation certificate to input operation date and time; date and time control format is optional.

[0039] Electronic signature control: can be used for operators / reviewers to confirm their identities twice during the production process; electronic signature supports setting single signature or double signature, and can configure the display format after signature confirmation.

[0040] Hyperlink control: used to configure the pages that can be linked in the interface, generally used for production operation files that operators need to view during the recording process.

[0041] Label jump control: used to configure that when the parameters or records input by the operator meet certain conditions, the next execution content of the process can be jumped to the specified label; the target label to jump to when greater than, equal to, or less than the target can be configured.

[0042] Through the above-mentioned various controls, the electronic process record template can meet the needs of various production process records. Through these built-in controls, user mandatory input, optional input, read-only display, device communication data, third-party database data and other functions and table cell binding are realized to display the diverse collection and display of electronic data.

[0043] S102, generating a process table document containing information of each process of the target production process flow, as shown in the attached Fig. 9 As shown, the process table document is provided with a plurality of worksheets, and each worksheet corresponds to a specific process record template.

[0044] S103, obtaining the arrangement order of each worksheet in the process table document, and calling the corresponding worksheets in sequence according to the preset calling order. Fig.10 As shown, this step may also specifically include the following steps:

[0045] Obtain the arrangement order of each worksheet in the process table document. Specifically, the worksheet of the process record configuration tool can be used to complete the construction of the actual production process, as shown in the attached Figure 7 As shown in FIG. 1 , all process record templates are respectively configured in each worksheet of the table according to the process sequence. In some specific embodiments, the sequence of the worksheets is adjusted according to the actual sequence of the processes, as shown in FIG. Fig. 9 As shown, simple processes can be adjusted continuously and quickly by moving the processes forward or backward; for example, the order of the original worksheet is process 1, process 2, process 3; through the move function, the order of the worksheet can be adjusted to process 2, process 1, process 3.

[0046] Each worksheet is called in sequence according to the arrangement order of the worksheets in the process table document. All worksheets in the simple process flow are executed and records are generated in the order of arrangement.

[0047] S104, executing operations on the cell controls in the called worksheet according to preset execution rules and generating operation records, and collecting and inputting production process data according to the corresponding process record template to generate process execution record information.

[0048] Specifically, according to the preset execution requirements, the cell controls located in the specified area of ​​the called worksheet are executed according to the preset execution rules. The preset execution requirements include specifying the execution of the entire worksheet or a specific area within the worksheet, and the specific area within the worksheet includes a specific number of rows or columns or cells of the worksheet. For example, each worksheet can also pre-specify or bind its specific execution area, such as the entire worksheet of the corresponding process or a specific part of the worksheet. When a specific area of ​​a worksheet is selected for execution, such as a specific number of rows, the start row and end row of the process to be executed can be set. When the process is executed, only the record content between the start row and the end row is displayed, and the content outside the range is not displayed; through this function, each process step can only display the operation content of the step, ensuring the confidentiality between the processes and steps of the production process.

[0049] During the execution process, each process corresponding to each worksheet generates a to-do task; the operator enters the corresponding process data according to the pre-set process record template by executing the task, and forms a record. The numerical, text, enumeration, date and time, and electronic signature controls record the input data according to the user's operation content; the general controls keep the content unchanged when configured; the link control only generates a hyperlink and is not reflected in the record; the jump control dynamically jumps to the specified note box according to the process parameters and the set comparison conditions during the execution process, and executes again. During the execution process, the operator's task execution order and the corresponding process data entered by each operation are recorded and a record is formed. The simple process execution method can use the sequential worksheet to quickly realize the construction of a simple process flow chart for serial production. The simple process execution method is for production occasions with simple process flows and serial production. You can configure the table process record template and adjust the sequence of the worksheets to achieve a simple production process.

[0050] S105, splicing the execution record information of each process to generate batch record information recording the production process. According to the process execution sequence recorded in the above process execution method and the execution record of each process, splicing is formed into a complete process record. The complete record saves the records of all executed processes, and the records of unexecuted processes are not reflected in the complete record.

[0051] The above-mentioned production record method uses a spreadsheet to pre-configure the process record template that needs to be recorded, and realizes the configuration and preservation of multiple processes through a worksheet. The production record method is particularly suitable for production occasions with relatively simple process flows and serial production. The process record template can be configured in a table, and a simple production process can be built by adjusting the sequence of the worksheet, which simplifies the configuration of simple, serial production processes commonly seen in actual factory production. The process record template is configured in a table manner and bound to the process steps of the workflow, so that only specific record templates are executed during the execution of a specific process. The above-mentioned production record method simplifies the configuration of simple, serial production processes commonly seen in actual factory production. The process record template is configured in a table manner and bound to the process steps of the workflow, so that only specific record templates are executed during the execution of a specific process, which greatly improves the flexibility of the production record configuration method and improves the reusability of the process record template. The above-mentioned production record method is not limited to a specific industrial production industry and can be applied to any occasion with a production process record requirement.

[0052] Attached Figure 2 Another production process recording method disclosed in an embodiment of the present invention is applicable to various complex production process flows and may include the following steps:

[0053] S201, obtaining a target production process flow corresponding to a production process, wherein the target production process flow includes at least one production process on a production line, and configuring a record template for each process;

[0054] S202, as attached Figure 6 As shown in the figure, the process flow chart configuration tool is called according to the target production process flow to create a process flow chart. At the same time, each step of the process flow chart is bound to the corresponding process worksheet or a specific area in the process worksheet, as shown in the attached Figure 7 As shown, the process worksheet includes a corresponding process record template.

[0055] During specific operation, the electronic batch record software obtains the flowchart step binding information. When a step is bound to the entire process worksheet, when executing the process worksheet, each cell control is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

[0056] When a step is bound to a specific area in a process worksheet, the specific area includes a specific number of rows or columns or cells in the process worksheet, and each cell control in the specific area is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

[0057] Specifically, when it is determined that the target production process flow is a complex process, the process flow chart configuration module is used to configure the process records bound to each step of the process flow chart. The specific number of rows to be executed in the entire process worksheet or a certain process worksheet can be specified. Of course, in other specific embodiments, the specific number of columns or specific cells to be executed can also be specified.

[0058] S203, calling the corresponding process worksheets bound to the current step in sequence according to the execution order of the process flow chart.

[0059] Specifically, when you choose to execute the entire worksheet: when executing this process, the record executes the controls of each cell according to the execution rules from top to bottom and from left to right.

[0060] When a specific area of ​​a worksheet is selected for execution, such as a specific number of rows, the start and end rows of the process can be set. When the process is executed, only the record content between the start and end rows is displayed, and the content outside the range is not displayed; through this function, each process step can only display the operation content of the step, ensuring the confidentiality between the production processes and steps.

[0061] S204, executing operations on the cell controls located in the called process worksheet or a specific area in the process worksheet according to preset execution rules and generating operation records, and collecting input production process data according to the corresponding process record template to generate process execution record information.

[0062] Specifically, according to the pre-configured process flow and the process record template associated with each process, the process flow execution engine executes one by one in the set order. During the execution process, each process generates a to-do task; the operator enters the corresponding process data and forms a record by executing the task according to the pre-set process record template. The numerical, text, enumeration, date and time, and electronic signature controls record the input data according to the user's operation content; the general controls keep the content unchanged when configured; the link control only generates a hyperlink and is not reflected in the record; the jump control dynamically jumps to the specified note box according to the process parameters during the execution process and the set comparison conditions, and executes again. At the same time, during the execution process, the operator's task execution order is recorded.

[0063] S205, splicing the execution record information of each process in the execution order to generate batch record information recording the production process.

[0064] The production record method disclosed in the above embodiment realizes the pre-configuration of process records in electronic tables: through built-in controls, user mandatory input, optional input, read-only display, device communication data, third-party database data and other functions are bound to table cells to display the diverse collection and display of electronic data; flow chart technology is provided to realize the construction of the production process, and the corresponding process record template can be bound by process to realize the execution of different process records in different process stages. After the execution is completed, a complete process record can be formed according to the actual execution sequence. Through the production record method disclosed in the above embodiment, it is realized that in the face of diverse manufacturing projects and frequent adjustments, the order and content of the process records are flexibly adjusted through the configuration scheme, and similar processes and processes can be reused, thereby shortening the customization implementation cycle while meeting the actual production needs. The production record method disclosed in the above embodiment realizes the abstraction of the production process sequence through a flow chart. The flexibility of the production record configuration method of the production record method disclosed in the above embodiment is greatly improved, and the reusability of the process record template is improved. The production record method disclosed in the above embodiment is not limited to a specific industrial production industry, and can be applied to any occasion with production process record requirements.

[0065] Attached Figure 3 The present invention discloses a production process recording method based on a flow chart and a table. The method obtains a target production process flow corresponding to a production process, wherein the target production process flow includes at least one production process on a production line, and configures a record template for each process; the target production process flow is evaluated according to a preset process complexity standard, and if it is complex, a first process execution method is used to generate execution record information for each process; otherwise, a second process execution method is used to generate execution record information for each process, wherein the first process execution method obtains the process execution sequence through a process flow chart, and the second process execution method obtains the process execution sequence by sorting worksheets in a process table document containing multiple worksheets, wherein each worksheet corresponds to a process record template in the target production process; finally, the execution record information of each process is spliced ​​to generate batch record information recording the production process.

[0066] The method uses a spreadsheet to pre-configure the process record template that needs to be recorded, and realizes the configuration and preservation of multiple processes through a worksheet. At the same time, different process configuration methods are selected according to the production processes with different process complexity. For complex production processes, the flowchart technology is used to realize the construction of the production process, and the corresponding process record template can be bound to each process to realize the execution of different process records at different process stages; after the execution is completed, a complete process record can be formed according to the actual execution sequence. For production occasions with relatively simple process flows and serial production, the method of using a sequential worksheet to represent the serial production process simplifies the configuration of simple, serial sequential production processes commonly seen in actual factory production. The process record template is configured in a table manner and bound to the process steps of the workflow, so that only specific record templates are executed for specific processes during the execution process. Through this method, in the face of diverse, flat and frequently adjusted manufacturing projects, the order and content of the process records can be flexibly adjusted through the configuration scheme, and similar processes and processes can be reused. Thereby, the customization implementation cycle is shortened while meeting the actual production needs.

[0067] As attached Figure 3 As shown, the production recording method disclosed in this embodiment includes:

[0068] S1, obtaining a target production process flow corresponding to a production process, wherein the target production process flow includes at least one production process on a production line, and configuring a record template for each process.

[0069] A production line generally includes multiple production processes, and each production process can be regarded as a production link in the production process. For increasingly modernized intelligent production lines, different production processes on a production line, or even different operating orders of the same production process, can be used to produce different products. For example, a production line includes production process 1, production process 2, and production process 3. Then, if production process 1 and production process 2 are run in this order, product A is produced; if production process 1, production process 2, and production process 3 are run in this order, product B is produced; if production process 2, production process 1, and production process 3 are run in this order, product C is produced. By preparing the relevant information of the production line to be implemented in advance, sorting out the production process flow, and configuring the electronic process record template according to the needs of the production process record, the electronic process record template can be as shown in the attached Figure 2As shown, the electronic process record template can be set according to the characteristics of the production line, or according to the data required for the production. Specifically, it can include: basic information corresponding to the production process (such as task name, start time, end time, task status, work center, work order number, temperature, pressure and other indicators), user operations corresponding to the production process (such as time, user, work center, operation station and operation behavior, etc.), and task details corresponding to the production process (recorded process data, such as input or output values, etc.). Among them, operation behaviors may include: signing, revising, and writing values; task details can also record the text of a production process of this production, which is used to provide users with analysis of this production, guidance and prompts for subsequent production, etc. The electronic process record template containing the above content can be saved in the form of a spreadsheet containing various cell controls. Among them, cell controls can be divided into general, value, text, enumeration, date and time, electronic signature, hyperlink, label jump and other controls according to type. The specific functions of each control are as follows:

[0070] Conventional controls: You can directly input content to display static text prompts in process records; you can also set label items to indicate when to jump to a specified label item based on different process parameters during execution.

[0071] Numeric controls: can be used for operators to input and record key process parameters; support integers and floating-point numbers; support setting the unit, format (i.e. integer digits and hour digits), maximum and minimum values ​​of the values; when the operator is recording, he can require forced input or choose to skip according to the pre-set settings, and the input value must fall within the range between the maximum and minimum values.

[0072] Text control: can be used for operators to input and record the description of the production process; when the operator is recording, it can be required to force input or choose to skip according to the pre-set; the text control can enter the initial value and prompt when entering.

[0073] Enumeration control: can be used for operators to input and record alternative operation actions; when the operator is recording, it can be required to force input or choose to skip according to pre-set; the enumeration control can set the operation selection style, provide radio button or drop-down list style, which is convenient for operators to use.

[0074] Date and time control: can provide operation certificate to input operation date and time; date and time control format is optional.

[0075] Electronic signature control: can be used for operators / reviewers to confirm their identities twice during the production process; electronic signature supports setting single signature or double signature, and can configure the display format after signature confirmation.

[0076] Hyperlink control: used to configure the pages that can be linked in the interface, generally used for production operation files that operators need to view during the recording process.

[0077] Label jump control: used to configure that when the parameters or records input by the operator meet certain conditions, the next execution content of the process can be jumped to the specified label; the target label to jump to when greater than, equal to, or less than the target can be configured.

[0078] Through the above-mentioned various controls, the electronic process record template can meet the needs of various production process records. Through these built-in controls, user mandatory input, optional input, read-only display, device communication data, third-party database data and other functions and table cell binding are realized to display the diverse collection and display of electronic data.

[0079] S21, evaluating the target production process flow according to the preset process complexity standard.

[0080] Specifically, in some embodiments, the preset process complexity standard may include, but is not limited to, whether there are multiple steps in the production process flow in which one step is selected for execution, whether there are multiple steps in parallel, and whether there are one or more judgment conditions in a process selected for execution or skipped according to judgment conditions. For example, when there are multiple steps in a specific target production process flow in which one step needs to be selected for execution according to conditions, or there are multiple steps in parallel, or there are multiple judgment conditions in a process step selected for execution or skipped according to judgment conditions, the target production process flow can be identified as a complex production process flow. On the contrary, if there is only a simple serial step sequence in a specific target production process flow, the target production process flow can be identified as a simple production process flow. In other embodiments, the preset process complexity standard can also be directly determined by judging whether the target production process flow is a single serial production process. If so, it is judged as a simple production process flow, otherwise it is a complex production process flow.

[0081] S22: If it is complicated, the first process execution method is adopted to generate the execution record information of each process, and the first process execution method obtains the process execution sequence through the process flow chart.

[0082] As attached Figure 5 As shown, the first process execution mode is a complex process execution mode, and the first process execution mode is used to generate each process execution record information, which specifically includes:

[0083] S221, as attached Figure 6 As shown in the figure, the process flow chart configuration tool is called according to the target production process flow to create a process flow chart. At the same time, each step of the process flow chart is bound to the corresponding process worksheet or a specific area in the process worksheet, as shown in the attached Figure 7As shown, the process worksheet includes a corresponding process record template.

[0084] During specific operation, the electronic batch record software obtains the flowchart step binding information. When a step is bound to the entire process worksheet, when executing the process worksheet, each cell control is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

[0085] When a step is bound to a specific area in a process worksheet, the specific area includes a specific number of rows or columns or cells in the process worksheet, and each cell control in the specific area is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

[0086] Specifically, when it is determined that the target production process flow is a complex process, the process flow chart configuration module is used to configure the process records bound to each step of the process flow chart. The specific number of rows to be executed in the entire process worksheet or a certain process worksheet can be specified. Of course, in other specific embodiments, the specific number of columns or specific cells to be executed can also be specified.

[0087] S222, calling the corresponding process worksheets bound to the current step in sequence according to the execution order of the process flow chart.

[0088] Specifically, when you choose to execute the entire worksheet: when executing this process, the record executes the controls of each cell according to the execution rules from top to bottom and from left to right.

[0089] When a specific area of ​​a worksheet is selected for execution, such as a specific number of rows, the start and end rows of the process can be set. When the process is executed, only the record content between the start and end rows is displayed, and the content outside the range is not displayed; through this function, each process step can only display the operation content of the step, ensuring the confidentiality between the production processes and steps.

[0090] S223, executing operations on the cell controls located in the called process worksheet or a specific area in the process worksheet according to preset execution rules and generating operation records, and collecting input production process data according to the corresponding process record template to generate process execution record information.

[0091] Specifically, according to the pre-configured process flow and the process record template associated with each process, the process flow execution engine executes one by one in the set order. During the execution process, each process generates a to-do task; the operator enters the corresponding process data and forms a record by executing the task according to the pre-set process record template. The numerical, text, enumeration, date and time, and electronic signature controls record the input data according to the user's operation content; the general controls keep the content unchanged when configured; the link control only generates a hyperlink and is not reflected in the record; the jump control dynamically jumps to the specified note box according to the process parameters during the execution process and the set comparison conditions, and executes again. At the same time, during the execution process, the operator's task execution order is recorded.

[0092] S23, if it is simple, the second process execution method is adopted to generate each process execution record information. The second process execution method obtains the process execution order by sorting the worksheets in the process table document containing multiple worksheets. Each worksheet corresponds to a process record template in the target production process.

[0093] As attached Figure 8 As shown, the second process execution mode is a simple process execution mode, and the second process execution mode is used to generate each process execution record information, which specifically includes:

[0094] S231, generating a process table document containing information of each process of the target production process flow, as shown in the attached Figure 7 As shown, the process table document is provided with a plurality of worksheets, and each worksheet corresponds to a specific process record template.

[0095] S232, obtaining the arrangement order of each worksheet in the process table document, and calling the corresponding worksheets in sequence according to the preset calling order. Fig.10 As shown, this step may also specifically include the following steps:

[0096] S2321, obtaining the arrangement order of each worksheet in the process table document.

[0097] Specifically, you can use the worksheet of the process record configuration tool to complete the construction of the actual production process, as shown in the attached Fig. 9 As shown in FIG. 1 , all process record templates are respectively configured in each worksheet of the table according to the process sequence. In some specific embodiments, the sequence of the worksheets is adjusted according to the actual sequence of the processes, as shown in FIG. Fig.11 As shown, simple processes can be adjusted continuously and quickly by moving the processes forward or backward; for example, the order of the original worksheet is process 1, process 2, process 3; through the move function, the order of the worksheet can be adjusted to process 2, process 1, process 3.

[0098] S2322, calling each worksheet in sequence according to the arrangement order of the worksheets in the process table document. All worksheets in the simple process flow are executed and records are generated in the order of arrangement.

[0099] S233, executing operations on the cell controls in the called worksheet according to preset execution rules and generating operation records, and collecting input production process data according to the corresponding process record template to generate process execution record information.

[0100] Specifically, according to the preset execution requirements, the cell controls located in the specified area of ​​the called worksheet are executed according to the preset execution rules. The preset execution requirements include specifying the execution of the entire worksheet or a specific area within the worksheet, and the specific area within the worksheet includes a specific number of rows or columns or cells of the worksheet. For example, each worksheet can also pre-specify or bind its specific execution area, such as the entire worksheet of the corresponding process or a specific part of the worksheet. When a specific area of ​​a worksheet is selected for execution, such as a specific number of rows, the start row and end row of the process to be executed can be set. When the process is executed, only the record content between the start row and the end row is displayed, and the content outside the range is not displayed; through this function, each process step can only display the operation content of the step, ensuring the confidentiality between the processes and steps of the production process.

[0101] During the execution process, each process corresponding to each worksheet generates a to-do task; the operator enters the corresponding process data according to the pre-set process record template by executing the task, and forms a record. The numerical, text, enumeration, date and time, and electronic signature controls record the input data according to the user's operation content; the general controls keep the content unchanged when configured; the link control only generates a hyperlink and is not reflected in the record; the jump control dynamically jumps to the specified note box according to the process parameters and the set comparison conditions during the execution process, and executes again. During the execution process, the operator's task execution order and the corresponding process data entered by each operation are recorded and a record is formed. The simple process execution method can use the sequential worksheet to quickly realize the construction of a simple process flow chart for serial production. The simple process execution method is for production occasions with simple process flows and serial production. You can configure the table process record template and adjust the sequence of the worksheets to achieve a simple production process.

[0102] S3, splicing the execution record information of each process to generate batch record information recording the production process.

[0103] According to the process execution sequence recorded in the selected first process execution mode or second process execution mode, and the execution records of each process, a complete process record is formed. The complete record saves the records of all executed processes, and the records of unexecuted processes are not reflected in the complete record.

[0104] In the process recording method disclosed in the above embodiment, a spreadsheet is used to pre-configure the process record template that needs to be recorded, and the configuration and preservation of multiple processes are realized through a worksheet; the target production process is completed by building a production flow chart. Through a certain production tool step, the process record template and its number are associated to realize the required configuration of the complex process flow record flow. In particular, for production occasions where the process flow is relatively simple and serial production is carried out, a simple production process can be built by configuring a table process record template, and by adjusting the sequence of the worksheet, the configuration of simple, serial production processes commonly used in actual factory production is simplified. By configuring the process record template in a table manner and binding it to the process step of the workflow, it is realized that only specific record templates are executed for specific processes during the execution process.

[0105] The process recording method of the present invention realizes the pre-configuration of process records in electronic tables: through built-in controls, functions such as user forced input, optional input, read-only display, device communication data, third-party database data, etc. are bound to table cells to display the diverse collection and display of electronic data; flow chart technology is provided to realize the construction of the production process, and the corresponding process record templates can be bound according to the process, so as to realize the execution of different process records in different process stages. After the execution is completed, a complete process record can be formed according to the actual execution sequence. Through this technical method, in the face of the diverse, flat and frequently adjusted manufacturing projects, the order of process records and the flexible adjustment of the record content can be realized through the configuration plan, and similar processes and flows can be reused, thereby shortening the customization implementation cycle while meeting the actual production needs.

[0106] The method of the present invention realizes the abstraction of the production process sequence through a flow chart; and provides a method for representing the serial production process with a sequential worksheet, which simplifies the configuration of simple, serial production processes commonly seen in actual factory production. The process record template is configured in a table manner and bound to the process steps of the workflow, so that only a specific record template is executed in a specific process during the execution process.

[0107] The present invention greatly improves the flexibility of the production record configuration mode and enhances the reusability of the process record template. At the same time, there are corresponding solutions for both complex production and simple production. The present invention is not limited to a specific industrial production industry, and can be applied to any occasion where there is a need for production process records.

[0108] Attached Fig.12The embodiment disclosed is a schematic diagram of the principle of a production recording device. The recording device 1 includes a memory 11, a processor 12, and a computer program stored in the memory and executable on the processor, such as electronic batch recording software. When the processor executes the computer program, the steps in the above-mentioned process recording method embodiments based on flowcharts and tables are implemented.

[0109] Exemplarily, the computer program may be divided into one or more modules / units, which are stored in the memory and executed by the processor to implement the present invention. The one or more modules / units may be a series of computer program instruction segments capable of implementing specific functions, which are used to describe the execution process of the computer program in the server.

[0110] The server may include, but is not limited to, a processor and a memory. Those skilled in the art will appreciate that the schematic diagram is merely an example of a server and does not constitute a limitation on the server device, and may include more or fewer components than shown in the diagram, or a combination of certain components, or different components, for example, the server device may also include input and output devices, network access devices, buses, etc.

[0111] The processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc. The processor is the control center of the server device, and uses various interfaces and lines to connect various parts of the entire server device.

[0112] The memory can be used to store the computer program and / or module, and the processor realizes various functions of the server device by running or executing the computer program and / or module stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SmartMedia Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0113] If the production process recording method based on the flowchart and the table is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned various method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electric carrier signals and telecommunication signals.

[0114] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

[0115] In conclusion, the above is only a preferred embodiment of the present invention, and all equivalent changes and modifications made according to the scope of the patent application of the present invention should fall within the scope of the patent of the present invention.

Claims

1. A production process recording method, characterized in that: include: Obtain a target production process flow corresponding to the production process, wherein the target production process flow includes at least one production process on the production line, and configure a record template for each process; Calling a process flow chart configuration tool to create a process flow chart according to the target production process flow, wherein each step of the process flow chart is bound to a corresponding process worksheet or a specific area in a process worksheet, and the process worksheet includes a corresponding process record template; The corresponding process worksheet bound to the current step is called in sequence according to the execution order of the process flow chart; when the entire worksheet is selected for execution, the records are executed from top to bottom and from left to right, and the controls of each cell are executed; when a specific area of ​​the process worksheet is selected for execution, the start and end rows of the process to be executed can be set, and when the process is executed, only the record contents between the start and end rows are displayed, and the contents outside the range are not displayed; According to the preset execution rules, the cell controls located in the called process worksheet or the specific area in the process worksheet are executed and the operation records are generated, and the production process data inputted are collected according to the corresponding process record template to generate the process execution record information; according to the pre-configured process flow and the process record template associated with each process, the process flow execution engine executes one by one in the set order; During the execution process, each process generates to-do tasks; By executing tasks, according to the pre-set process record template, input the corresponding process data and form records; The execution record information of each process is spliced ​​in the execution order to generate batch record information recording the production process.

2. The production process recording method according to claim 1, characterized in that: The process flow chart configuration tool is called according to the target production process flow to create a process flow chart, each step of the process flow chart is bound to a corresponding process worksheet or a specific area in the process worksheet, and the process worksheet contains a corresponding process record template, specifically including: Get the flowchart step binding information. When a step is bound to the entire process worksheet, when executing to the process worksheet, execute each cell control in sequence and record according to the execution rules from top to bottom and from left to right; When a step is bound to a specific area in a process worksheet, the specific area includes a specific number of rows or columns or cells in the process worksheet, and each cell control in the specific area is executed and recorded in sequence according to the execution rules from top to bottom and from left to right.

3. The production process recording method according to any one of claims 1-2, characterized in that: The cell control includes one or more of a numeric control, a text control, an enumeration control, an electronic signature control, and a label jump control; The numerical control is used to obtain operator input information and record key process parameters; The text control is used to obtain operator input information and record the production process description; The enumeration control is used to obtain operator input and record alternative operation actions; The electronic signature control is used to obtain signature information of the operator / reviewer confirming the operation in the production process; The label jump control is used to configure the next execution content of the process to jump to the specified label when the obtained input parameters or records meet certain conditions.

4. The production process recording method according to claim 3, characterized in that: The cell control also includes a conventional control, which is configured to directly input static text prompt content for displaying process records, and can be set to jump to a specified label item according to different process parameters during the execution process.

5. A production process recording device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the production process recording method according to any one of claims 1 to 4 are implemented.

6. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the production process recording method according to any one of claims 1 to 4 are implemented.

Images