Audit tracking method of glass coating production line and related device
By using a database-based electronic audit tracking method on the glass coating production line, the problems of inaccurate traceability and low audit accuracy caused by existing paper records are solved, and higher audit accuracy and operational convenience are achieved.
Patent Information
- Application Number
- CN202411555768.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-01
- Publication Date
- 2025-02-25
AI Technical Summary
The audit tracking method of existing glass coating production lines relies on paper records, resulting in inaccurate traceability, low audit tracking accuracy and easy to tamper with.
By receiving query instructions, the production parameter data of the target target is queried based on the preset database and a parameter curve is generated to achieve electronic audit tracking.
It improves the accuracy of audit trails, reduces paper usage, and brings greater convenience and reliability to monitoring personnel.
Smart Images

Figure CN119513128A_ABST
Abstract
Description
Technical Field
[0001] The embodiments of the present application relate to the field of equipment manufacturing, and in particular to an audit tracking method and related devices for a glass coating production line. Background Art
[0002] Glass coating is a chemical polymer material that has been widely used in various industries. The production process of glass coating is: glass loading, glass cleaning, entering the vacuum chamber, rotating or flat cathode sputtering coating, glass unloading, finished product inspection, exiting the vacuum chamber and glass unloading. In short, the glass is cleaned first, then coated, and quality inspection is performed after coating. In order to monitor the production line, the existing solution is for the monitoring personnel to record the production parameters and operations of the glass coating production process on paper.
[0003] However, in the existing solutions, relevant data and operations are recorded on paper, which is easy to be tampered with, and the traceability accuracy is inaccurate. The accuracy of audit tracking is low, which brings certain inconveniences to monitoring personnel. Summary of the invention
[0004] The embodiments of the present application provide an audit tracking method and related devices for a glass coating production line, which are used to improve the accuracy of audit tracking.
[0005] A first aspect of an embodiment of the present application provides an audit tracking method for a glass coating production line, comprising:
[0006] receiving a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried;
[0007] Based on a preset database, query the target target material identifier to obtain target data of at least one production parameter in the glass coating production process corresponding to the target target material;
[0008] For each of the production parameters, a parameter curve corresponding to the target material is generated according to the target data.
[0009] Optionally, before receiving the first query instruction, the method further includes:
[0010] Collecting data of at least one production parameter in the glass coating production process corresponding to the target material within a historical production period;
[0011] A preset target material identification corresponding to the target material is associated with data of at least one production parameter corresponding to the target material, and stored in the database.
[0012] Optionally, if there are multiple production parameters, after generating a parameter curve corresponding to the target material according to the target data for each production parameter, the method further includes:
[0013] receiving a second query instruction, wherein the second query instruction includes information of a target production parameter of the target target material, wherein the target production parameter is one of the at least one production parameter;
[0014] According to the information of the target production parameter, only the parameter curve corresponding to the target production parameter is displayed.
[0015] Optionally, after generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes:
[0016] The target data of the at least one production parameter is compared with a preset alarm range value to generate alarm information about the production parameter corresponding to the target data within the alarm range value.
[0017] Optionally, after generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes:
[0018] receiving a third query instruction, wherein the third query instruction includes a specified time period in a glass coating production process corresponding to the target target;
[0019] Only the parameter curve corresponding to the target material within the specified time period is displayed.
[0020] Optionally, after generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes:
[0021] receiving a fourth query instruction, wherein the fourth query instruction includes record selection information for the target material;
[0022] According to the record selection information, only the parameter curve of the target material corresponding to the record selection information is displayed.
[0023] Optionally, the production parameter is one of the photoeye status value, inverter status value, servo status value, vacuum degree, valve status value, pump status value, target barrel water flow switch on-off value, hydrogen, nitrogen and oxygen content of the main gas and auxiliary gas, Hoyenger power supply power, Hoyenger power supply voltage and Hoyenger power supply current.
[0024] A second aspect of an embodiment of the present application provides an audit tracking device for a glass coating production line, comprising:
[0025] A receiving unit, configured to receive a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried;
[0026] A query unit, configured to query the target target material identifier based on a preset structured query language SQL database to obtain target data of at least one production parameter in a glass coating production process corresponding to the target target material;
[0027] A generating unit is used to generate a parameter curve corresponding to the target material according to the target data for each of the production parameters.
[0028] A third aspect of the present application embodiment provides an audit tracking device, including:
[0029] CPU, memory and input / output interface;
[0030] The memory is a short-term storage memory or a persistent storage memory;
[0031] The central processing unit is configured to communicate with the memory and execute instructions in the memory to perform the aforementioned method.
[0032] A fourth aspect of an embodiment of the present application provides a computer-readable storage medium, comprising instructions, which, when executed on a computer, enable the computer to execute the aforementioned method.
[0033] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:
[0034] First, the first query instruction is received, and then based on the preset database, the target target material identification is queried to obtain the target data of at least one production parameter in the glass coating production process corresponding to the target target material, and finally, for each production parameter, a parameter curve corresponding to the target target material is generated according to the target data. Based on the preset database, the target data of the production parameters corresponding to the target material is pre-stored. When a traceability query is required, only the relevant information of the target target material needs to be entered to obtain the corresponding parameter curve, without the need for paper, and the audit tracking accuracy is greatly improved, which brings great convenience to the monitoring personnel. BRIEF DESCRIPTION OF THE DRAWINGS
[0035] Figure 1 A schematic diagram of an embodiment of an audit tracking method disclosed in this application;
[0036] Figure 2 A schematic diagram of another embodiment of an audit tracking method disclosed in this application;
[0037] Figure 3 This is a schematic diagram of the production parameters disclosed in this application;
[0038] Figure 4 A schematic diagram of relevant information of the target material of the glass coating production line disclosed in this application;
[0039] Figure 5 A schematic diagram of the audit tracking software disclosed in this application;
[0040] Figure 6 A schematic diagram of an embodiment of an audit tracking device disclosed in the present application;
[0041] Figure 7 A schematic diagram of another embodiment of an audit tracking device disclosed in this application;
[0042] Figure 8 A schematic diagram of another embodiment of an audit tracking device disclosed in this application. DETAILED DESCRIPTION
[0043] The present application is further described in detail below in conjunction with the accompanying drawings.
[0044] The embodiments of the present application provide an audit tracking method and related devices for a glass coating production line, which are used to improve the accuracy of audit tracking.
[0045] Glass coating is to coat one or more layers of metal, alloy or metal compound thin films on the surface of glass to meet different needs. Specifically, the target material, such as silver, copper, zinc aluminide and silicon aluminide, can be selected according to actual needs, and the target material can be plated on the surface of the glass with high voltage electricity and process gas. Among them, the process gas can be hydrogen, nitrogen, oxygen and argon, etc., and the high voltage electricity is divided into high voltage alternating current and high voltage direct current. In order to monitor the production line, the existing solution is to record relevant data and operations through paper. However, this leads to inaccurate traceability and low accuracy of audit tracking, and paper is easy to forge. In order to solve the above problems, the present application provides an audit tracking method and related devices for a glass coating production line, which greatly improves the accuracy of audit tracking in electronic form based on a preset database, without paper, and brings great convenience to monitoring personnel. In addition, audit tracking can ensure the traceability of all operational activities of electronic data and coating systems during the data life cycle, and maintain system security.
[0046] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0047] The terms "first", "second", "third", "fourth", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0048] The following is a description of an audit trail method for this application. Figure 1 , an audit tracking method of the present application includes:
[0049] 101. Receive a first query instruction;
[0050] A first query instruction is received, wherein the first query instruction includes a target target material identification corresponding to the target target material to be queried. Specifically, in the glass coating production process, the film coated on the glass is the target material, and the target material can be silver, copper, zinc aluminide and other materials, which can be set according to actual needs, and are not limited here. When a user wants to know the specific production situation of a certain glass coating, the target material of the glass coating can be determined as the target target material, and the first query instruction including the target target material identification corresponding to the target target material is input into the audit tracking device. The user can input a specific target target material identification, or the user can select the target target material identification on the device, and are not limited here.
[0051] 102. Based on a preset database, query the target material identifier to obtain target data of at least one production parameter in the glass coating production process corresponding to the target material;
[0052] Based on a preset database, the target target material identification is queried to obtain the target data of at least one production parameter in the glass coating production process corresponding to the target target material. Specifically, the database is pre-set, and stores the target material identification and the target data of at least one production parameter in the glass coating production process corresponding to the target material identification. For example, the target material identification is 402, and the corresponding data of one of the production parameters (such as current) at a certain moment is 10A. The database can be a structured query language (SQL) database, or other, which can be set according to actual needs, and is not limited here. After obtaining the target target material identification, the target data of at least one corresponding production parameter can be queried by entering it into the database.
[0053] 103. For each production parameter, a parameter curve corresponding to the target target is generated according to the target data.
[0054] For each production parameter, a parameter curve corresponding to the target target is generated according to the target data. After obtaining the target data, a parameter curve corresponding to the target target is generated according to all the target data, where one production parameter corresponds to one parameter curve, and the parameter curve is on a plane coordinate system, where one axis of the plane coordinate system represents time, and the other axis represents the data value of a certain production parameter. Users can intuitively perceive and analyze the changes in target data from the parameter curve.
[0055] In the embodiment of the present application, the first query instruction is first received, and then based on the preset database, the target target material identification is queried to obtain the target data of at least one production parameter in the glass coating production process corresponding to the target target material, and finally for each production parameter, a parameter curve corresponding to the target target material is generated according to the target data. Based on the preset database, the target data of the production parameters corresponding to the target material is pre-stored. When a retrospective query is required, only the relevant information of the target target material needs to be input to obtain the corresponding parameter curve, without the need for paper, and the audit tracking accuracy is greatly improved, which brings great convenience to the monitoring personnel.
[0056] See also Figure 2 Another embodiment of an audit tracking method of the present application includes:
[0057] 201. Collect data of at least one production parameter in a glass coating production process corresponding to a target material within a historical production period;
[0058] Collect data of at least one production parameter in the glass coating production process corresponding to the target material in the historical production time period. The historical production time period is the time period of the glass coating production process corresponding to all target materials, and the production parameter is the quantity involved in the glass coating production process. The production parameter can be one of the following: the photoeye state value, the inverter state value, the servo state value, the vacuum degree, the valve state value, the pump state value, the target barrel water flow switch on-off value, the hydrogen, nitrogen and oxygen content of the main gas and the auxiliary gas, the Hoyenger power supply power, the Hoyenger power supply voltage and the Hoyenger power supply current. Figure 3 Some production parameters are displayed, and the upstream uses the switch to operate the equipment such as the loading area, import area and sputtering area in the audit tracking device. Specifically, each device is equipped with a sensor to collect data on at least one production parameter of the equipment during the glass coating production process.
[0059] in, Figure 3In the process, the on and off of the photoelectric signal of the glass transmission is an important data for judging the glass travel position and offset; the operation and failure of the inverter in each process area is also an important data for the smooth travel and offset of the glass; the servo operation and failure in each process area are important data for the smooth travel and distance pursuit of the glass; the IG table, CG table and PG table in each area measure the vacuum degree of the coating process; the opening and closing of the pneumatic valves in each process area; the normal operation and fault alarm of the pump; the opening or closing of the water flow switch of the cathode position or the target barrel; the actual value curves of the main gas and auxiliary gas hydrogen, nitrogen and oxygen; the Huoyange high-voltage AC or DC power supply curve, etc. The above are important production parameters in the glass coating production process.
[0060] 202. Associating a preset target material identification corresponding to the target material with data of at least one production parameter corresponding to the target material, and storing the data in a database;
[0061] The preset target material identification corresponding to the target material is associated with the data of at least one production parameter corresponding to the target material, and stored in the database. Among them, the target materials on the glass coating are all pre-set with corresponding target material identifications, and the target material identifications are associated with the data of at least one corresponding production parameter, and then stored in the database. The database can be an SQL database for easy query, or other types, which are not limited here.
[0062] 203. Receive a first query instruction, where the first query instruction includes a target material identifier corresponding to a target material to be queried;
[0063] A first query instruction is received, wherein the first query instruction includes a target target material identification corresponding to the target target material to be queried. Specifically, in the glass coating production process, the film coated on the glass is the target material, and the target material can be silver, copper, zinc aluminide and other materials, which can be set according to actual needs, and are not limited here. When a user wants to know the specific production situation of a certain glass coating, the target material of the glass coating can be determined as the target target material, and the first query instruction including the target target material identification corresponding to the target target material is input into the audit tracking device. The user can input a specific target target material identification, or the user can select the target target material identification on the device, and are not limited here.
[0064] 204. Based on a preset database, query the target material identifier to obtain target data of at least one production parameter in a glass coating production process corresponding to the target material;
[0065] Based on a preset database, the target target material identification is queried to obtain target data of at least one production parameter in the glass coating production process corresponding to the target target material. Specifically, the database is pre-set, and stores the target material identification and the target data of at least one production parameter in the glass coating production process corresponding to the target material identification. After the target target material identification is obtained, the corresponding target data of at least one production parameter can be queried by inputting it into the database.
[0066] 205. For each of the production parameters, generate a parameter curve corresponding to the target material according to the target data.
[0067] For each production parameter, a parameter curve corresponding to the target target is generated according to the target data. After obtaining the target data, a parameter curve corresponding to the target target is generated according to all the target data, where one production parameter corresponds to one parameter curve, and the parameter curve is on a plane coordinate system, where one axis of the plane coordinate system represents time, and the other axis represents the data value of a certain production parameter. Users can intuitively perceive and analyze the changes in target data from the parameter curve.
[0068] After obtaining the parameter curve, subsequent operations can also be performed. If there are multiple production parameters, it is inevitable that it is not intuitive to directly view multiple parameter curves. In order to select a specific parameter curve for analysis, the user needs to operate. In one embodiment, the second query instruction is first received, and then only the parameter curve corresponding to the target production parameter is displayed according to the information of the target production parameter. Among them, the second query instruction includes information on the target production parameter of the target target material, and the target production parameter is one of at least one production parameter. Specifically, the user selects one of the multiple production parameters as the target production parameter, and after inputting it into the audit tracking device, only the parameter curve corresponding to the target production parameter will be displayed.
[0069] After obtaining the parameter curve, in order to facilitate analysis, it is also necessary to alarm some abnormal data. In one embodiment, the target data of at least one production parameter is compared with the preset alarm range value to generate alarm information about the production parameter corresponding to the target data in the alarm range value. Specifically, the target data of multiple production parameters are each compared with the corresponding preset alarm range value to generate alarm information of production parameters that meet the alarm conditions, wherein the alarm information includes the target data of the production parameters, the corresponding time period and other information. For example, assuming that there are only three production parameters, namely, the power of the Huoyinge power supply, the voltage of the Huoyinge power supply and the current of the Huoyinge power supply, the target data in the time period of 1-3s are 20KW, 500V, and 110A respectively, and the preset alarm range values are power 1KW-120KW, voltage 400V-1000V, and current 30A-200A respectively, then the target data of the three production parameters meet the alarm conditions, and the alarm information of the target target material about these three production parameters is generated.
[0070] After obtaining the parameter curve, the selected specified time period can be analyzed, such as zooming in, shortening, fast forwarding, rewinding, and other operations. In one embodiment, a third query instruction is first received, wherein the third query instruction includes a specified time period in the glass coating production process corresponding to the target target material, and then only the parameter curve corresponding to the target target material in the specified time period is displayed. Specifically, the time period is changed by zooming in, shortening, fast forwarding, rewinding, and other operations to become the required specified time period, and only the parameter curve of the target target material in the specified time period is displayed.
[0071] After obtaining the parameter curve, sometimes it is necessary to call other secondary records for comparison to facilitate analysis. In one embodiment, a fourth query instruction is first received, wherein the fourth query instruction includes record selection information for the target target material, and then only the parameter curve of the target target material corresponding to the record selection information is displayed according to the record selection information. Specifically, the user can present the parameter curve of the corresponding record through operation buttons such as "previous record" and "first record", or directly enter the record number to call the corresponding parameter curve, which is not limited here.
[0072] In addition, different users have different login accounts. After each account operates on relevant data, the account and the corresponding operation will be recorded in the database to facilitate the clarification of responsibilities.
[0073] The present embodiment is described below with examples. Figure 4 Relevant data corresponding to multiple target materials are displayed, among which the target materials are labeled 4102, 4103, 4104, 4109, ..., 4706 and 4709, totaling 36. Figure 5The audit trail software interface is displayed, where the x-axis represents time, the y-axis represents target data, the two vertical lines in the coordinate graph are curve scales, the production parameters and target data in the lower left box are reflected in the upper left coordinate graph, and the buttons between the upper left and lower left parts are all buttons for controlling time points, including fast forward and rewind, start and end settings, zoom in and out, fast forward and rewind time intervals, etc. In the lower left corner, there is a box for index search and a record call button, the upper right is an alarm information box, and the lower right is an operator information box.
[0074] When the user enters the target material ID of the target material in the index search box, the corresponding target data will be called to generate a parameter curve and displayed in the coordinate graph. If you only want to select one of them, select the required production parameter in the box on the lower left to display only the corresponding parameter curve. The alarm information and operator information will also be displayed on the right. Time control and record selection can be achieved through related buttons.
[0075] In the present embodiment, based on the preset database, the target data of the production parameters corresponding to the target material are pre-stored. When a traceability query is required, the corresponding parameter curve can be obtained by simply inputting the relevant information of the target target material, without paper, and the audit tracking accuracy is greatly improved, which brings greater convenience to the monitoring personnel. Input the target material identification and call the parameter curve with one key, which is efficient and greatly improves the degree of automation. In addition, the method of the present application is written in the currently internationally used SQL, C, VB high-level languages and API functions, with high reliability and reliable functions. The classes, objects, inheritance, encapsulation, and interfaces in the object are well supported, and configuration software such as wincc and IFIX at home and abroad can be seamlessly called, and no secondary compilation changes are required, with the advantages of robustness, security, reliability, easy operation, low fault tolerance, and strong portability.
[0076] An audit tracking method in an embodiment of the present application is described above, and an audit tracking device in an embodiment of the present application is described below. Figure 6 , an audit tracking device in an embodiment of the present application includes:
[0077] The receiving unit 601 is used to receive a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried;
[0078] A query unit 602 is used to query the target target material identifier based on a preset structured query language SQL database to obtain target data of at least one production parameter in the glass coating production process corresponding to the target target material;
[0079] The generating unit 603 is used to generate a parameter curve corresponding to the target target material according to the target data for each of the production parameters.
[0080] In the embodiment of the present application, the receiving unit 601 first receives the first query instruction, and then the query unit 602 queries the target target material identification based on the preset database to obtain the target data of at least one production parameter in the glass coating production process corresponding to the target target material, and finally the generating unit 603 generates a parameter curve corresponding to the target target material according to the target data for each production parameter. Based on the preset database, the target data of the production parameters corresponding to the target material are pre-stored. When a traceability query is required, only the relevant information of the target target material needs to be input to obtain the corresponding parameter curve, without the need for paper, and the audit tracking accuracy is greatly improved, which brings great convenience to the monitoring personnel.
[0081] The following is a detailed description of an audit tracking device in an embodiment of the present application. Figure 7 Another embodiment of an audit tracking device of an embodiment of the present application includes:
[0082] The receiving unit 701 is configured to receive a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried;
[0083] A query unit 702 is used to query the target target material identifier based on a preset structured query language SQL database to obtain target data of at least one production parameter in the glass coating production process corresponding to the target target material;
[0084] The generating unit 703 is used to generate a parameter curve corresponding to the target target material according to the target data for each of the production parameters.
[0085] The audit tracking device further includes a storage unit 704, which is specifically used for:
[0086] Collecting data of at least one production parameter in the glass coating production process corresponding to the target material within a historical production period;
[0087] A preset target material identification corresponding to the target material is associated with data of at least one production parameter corresponding to the target material, and stored in the database.
[0088] If the number of the production parameters is multiple, the audit tracking device further includes a processing unit 705, which is specifically used to:
[0089] receiving a second query instruction, wherein the second query instruction includes information of a target production parameter of the target target material, wherein the target production parameter is one of the at least one production parameter;
[0090] According to the information of the target production parameter, only the parameter curve corresponding to the target production parameter is displayed.
[0091] The audit tracking device also includes an alarm unit 706, which is specifically used to:
[0092] Comparing the target data of the at least one production parameter with a preset alarm range value to generate alarm information about the production parameter corresponding to the target data within the alarm range value;
[0093] The processing unit 705 is further configured to:
[0094] receiving a third query instruction, wherein the third query instruction includes a specified time period in a glass coating production process corresponding to the target target material;
[0095] Only the parameter curve corresponding to the target material within the specified time period is displayed;
[0096] The processing unit 705 is further configured to:
[0097] receiving a fourth query instruction, wherein the fourth query instruction includes record selection information for the target material;
[0098] According to the record selection information, only the parameter curve of the target material corresponding to the record selection information is displayed.
[0099] The production parameters in the query unit 702 are one of the photoeye status value, the inverter status value, the servo status value, the vacuum degree, the valve status value, the pump status value, the target barrel water flow switch on-off value, the hydrogen, nitrogen and oxygen content of the main gas and the auxiliary gas, the Hoyenger power supply power, the Hoyenger power supply voltage and the Hoyenger power supply current.
[0100] The functions and processes performed by each unit in the audit tracking device of this embodiment are similar to those described above. Figures 1 to 5 The functions and processes performed by the audit trail device are similar and will not be repeated here.
[0101] Figure 8 It is a schematic diagram of the structure of an audit tracking device provided in an embodiment of the present application. The audit tracking device 800 may include one or more central processing units (CPU) 801 and a memory 805. The memory 805 stores one or more application programs or data.
[0102] The memory 805 may be a volatile storage or a persistent storage. The program stored in the memory 805 may include one or more modules, each of which may include a series of instruction operations in the audit trail device 800. Furthermore, the central processor 801 may be configured to communicate with the memory 805 and execute a series of instruction operations in the memory 805 on the audit trail device 800.
[0103] The audit trail device 800 may also include one or more power supplies 802, one or more wired or wireless network interfaces 803, one or more input and output interfaces 804, and / or one or more operating systems, such as Windows ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, etc.
[0104] The CPU 801 can execute the aforementioned Figures 1 to 5 The operations performed by the audit tracking device in the illustrated embodiment will not be described in detail here.
[0105] An embodiment of the present application also provides a computer-readable storage medium, including instructions, which, when executed on a computer, enable the computer to execute the method in the aforementioned embodiment.
[0106] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0107] It should be noted that, although the steps in the flowcharts involved in the embodiments are drawn in sequence according to the indications of the arrows, unless otherwise clearly stated in this document, there is no strict order restriction on the execution of these steps, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the embodiments may include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.
[0108] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.
[0109] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0110] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0111] If the integrated unit 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 technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, read-only memory), random access memory (RAM, random access memory), disk or optical disk and other media that can store program code.
Claims
1. An audit tracking method for a glass coating production line, characterized in that: include: receiving a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried; Based on a preset database, query the target target material identifier to obtain target data of at least one production parameter in the glass coating production process corresponding to the target target material; For each of the production parameters, a parameter curve corresponding to the target material is generated according to the target data.
2. The audit tracking method according to claim 1, characterized in that: Before receiving the first query instruction, the method further includes: Collecting data of at least one production parameter in the glass coating production process corresponding to the target material within a historical production period; A preset target material identification corresponding to the target material is associated with data of at least one production parameter corresponding to the target material, and stored in the database.
3. The audit tracking method according to claim 1, characterized in that: If there are multiple production parameters, after generating a parameter curve corresponding to the target material according to the target data for each production parameter, the method further includes: receiving a second query instruction, wherein the second query instruction includes information of a target production parameter of the target target material, wherein the target production parameter is one of the at least one production parameter; According to the information of the target production parameter, only the parameter curve corresponding to the target production parameter is displayed.
4. The audit tracking method according to claim 1, characterized in that: After generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes: The target data of the at least one production parameter is compared with a preset alarm range value to generate alarm information about the production parameter corresponding to the target data within the alarm range value.
5. The audit tracking method according to claim 1, characterized in that: After generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes: receiving a third query instruction, wherein the third query instruction includes a specified time period in a glass coating production process corresponding to the target target; Only the parameter curve corresponding to the target material within the specified time period is displayed.
6. The audit tracking method according to claim 1, characterized in that: After generating a parameter curve corresponding to the target material according to the target data for each of the production parameters, the method further includes: receiving a fourth query instruction, wherein the fourth query instruction includes record selection information for the target material; According to the record selection information, only the parameter curve of the target material corresponding to the record selection information is displayed.
7. The audit tracking method according to claim 1, characterized in that: The production parameters are one of the photoeye status value, inverter status value, servo status value, vacuum degree, valve status value, pump status value, target barrel water flow switch on-off value, hydrogen, nitrogen and oxygen content of the main gas and auxiliary gas, Hoyenger power supply power, Hoyenger power supply voltage and Hoyenger power supply current.
8. An audit tracking device for a glass coating production line, characterized in that: include: A receiving unit, configured to receive a first query instruction, wherein the first query instruction includes a target material identifier corresponding to a target material to be queried; A query unit, configured to query the target target material identifier based on a preset structured query language SQL database to obtain target data of at least one production parameter in a glass coating production process corresponding to the target target material; A generating unit is used to generate a parameter curve corresponding to the target material according to the target data for each of the production parameters.
9. An audit tracking device, characterized in that: include: CPU, memory and input / output interface; The memory is a short-term storage memory or a persistent storage memory; The central processing unit is configured to communicate with the memory and execute instructions in the memory to perform the method according to any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that: The method comprises instructions, which, when executed on a computer, cause the computer to execute the method according to any one of claims 1 to 7.