Steel industry data monitoring system and method based on table display

Abstract

The invention provides an iron and steel industry data monitoring system and method based on table display, and the method comprises the steps: responding to login information inputted by a user in a login interface, and verifying the login information; if the verification succeeds, acquiring network security information in a preset time period; performing an access test according to preset important system information to obtain a test result; importing the network security information and the test result into a corresponding area in a preset file template to generate a target table file; and controlling the display to display the target form file on the user desktop, and displaying the content of the target form file on the user desktop in response to a click operation of the user on the target form file. According to the system provided by the invention, intelligent operation and maintenance can be realized by means of a software tool, data verification is carried out while required data are collected, a result is exported, operation and maintenance personnel are helped to reduce repeated work, the time for technical personnel to process information is prolonged and shortened, and the data can be monitored in time.

Description

Technical Field

[0001] The present application relates to the field of data monitoring technology, and in particular to a steel industry data monitoring system and method based on table display. Background Art

[0002] At present, with the increasing development of the Internet, network security has become an increasingly important link that cannot be ignored. In the operation and maintenance units of steel enterprises, some systematic and repetitive work needs to be carried out regularly, such as: daily collection of system weak password information, security incident information, risk asset information, etc. and collating the results; daily testing of the operating status of important systems and collating the results; daily monitoring of the operating status of important production lines and reporting.

[0003] However, taking the daily testing of weak password information as an example, there are a large number of weak password information in the system every day, and many of them have been modified by the parties. If each item is manually verified by the system, it will greatly increase the workload of personnel and reduce their work efficiency. Summary of the invention

[0004] The present application provides a steel industry data monitoring system and method based on table display to solve the problems of low verification efficiency and inconvenience for daily maintenance in existing data sorting.

[0005] In a first aspect, the present application provides a steel industry data monitoring system based on table display, comprising:

[0006] A display, used to display the user's desktop;

[0007] The controller is configured as:

[0008] In response to login information input by the user on the login interface, verify the login information; the login information includes a verification code and personnel identity information;

[0009] If the verification is successful, obtain the network security information within the preset time period; the network security information includes the information of the lost risk assets and security events;

[0010] Perform access test based on preset important system information to obtain test results;

[0011] Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file;

[0012] Control the display to display the target table file on the user's desktop, and in response to the user's click operation on the target table file, display the content of the target table file on the user's desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data.

[0013] In some feasible embodiments, before executing in response to the login information input by the user on the login interface, the controller is further configured to:

[0014] Obtaining a file template date of the preset file template;

[0015] If the file template date is one day before the current time, controlling the display to display the login interface on the user desktop;

[0016] If the file template date is not the day before the current time, or the preset file template cannot be obtained, a first prompt message is generated; the first prompt message is used to remind the user to update the preset file template.

[0017] In some feasible embodiments, the personnel identity information includes the names of at least two testing personnel and the name of one form filling person.

[0018] In some feasible embodiments, the controller, in executing the step of verifying the login information, is further configured to:

[0019] Obtain weak password information within a preset time period;

[0020] Perform login tests on different systems according to the weak password information to obtain verification results;

[0021] Save information related to weak passwords involved in the login test process.

[0022] In some feasible embodiments, the login interface includes a verification code input control, a first detection personnel input control, a second detection personnel input control, and a form filling personnel input control; the controller is further configured to:

[0023] When the verification code input control, the first detection person input control, the second detection person input control, and the form filling person input control all input content, controlling the display to display a login control on the login interface;

[0024] In response to a user clicking operation on the login control, the login information is verified.

[0025] In some feasible embodiments, the controller imports the network security information and the test results into corresponding areas in a preset file template to generate a target table file, and is further configured to:

[0026] Call the Epplus plug-in in the system;

[0027] The Epplus plug-in is used to fill the network security information and the test results into the corresponding areas in the preset file template.

[0028] In some feasible embodiments, when the controller generates the target table file, it is further configured to:

[0029] Get the first table file generated one day before the current time;

[0030] The network security information and the test results are filled into corresponding areas in the first table file to update the first table file and obtain the target table file.

[0031] In some feasible embodiments, the controller is further configured to:

[0032] The first table file is cleared according to a preset period, and the target table file is generated according to the cleared first table file.

[0033] In a second aspect, the present application provides a steel industry data monitoring method based on table display, the method comprising:

[0034] In response to login information input by the user on the login interface, verify the login information; the login information includes a verification code and personnel identity information;

[0035] If the verification is successful, obtain the network security information within the preset time period; the network security information includes the information of the lost risk assets and security events;

[0036] Perform access test based on preset important system information to obtain test results;

[0037] Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file;

[0038] Controlling the display to display the target table file on the user desktop, and in response to a user clicking operation on the target table file, displaying the content of the target table file on the user desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data;

[0039] In some feasible embodiments, the production line operation status includes startup, shutdown and annual maintenance; the production line data includes the operation line name, startup and shutdown status, occurrence time and operation status statistics.

[0040] The system provided in this application can be implemented through a Windows system window application, and can be applied to the processing of network security data monitoring, important system operation status testing, result export tables, important production line operation status checking and other tasks by management and technical personnel in various industries. According to the actual situation required by the demand report, it is built using the Unity engine, using the C# high-level programming language, and output as a Windows executable file. After the user enters the relevant information, the login button is displayed. After clicking login, the system automatically collects network information security information within 24 hours of the previous day, exports the table after verification, and tests the operation status of important systems at that time for display. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] In order to more clearly illustrate the technical solution of the present application, the drawings required for use in the embodiments are briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0042] Figure 1 A structural diagram of a steel industry data monitoring system based on table display provided for this application;

[0043] Figure 2 A display interface of the login interface in one embodiment;

[0044] Figure 3 A schematic diagram of the contents of a target table file in one embodiment;

[0045] Figure 4 A display interface that prompts the user to import a new template file. DETAILED DESCRIPTION

[0046] The following embodiments are described in detail, and examples thereof are shown in the accompanying drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementation methods described in the following embodiments do not represent all implementation methods consistent with the present application. They are only examples consistent with some aspects of the present application detailed in the claims.

[0047] See also Figure 1 , which is a structural diagram of a steel industry data monitoring system based on table display provided in this application, such as Figure 1 As shown, the steel industry data monitoring system based on table display provided by this application includes:

[0048] A display for displaying a user's desktop; in the present application, the display may be a display device on a variety of devices for displaying a user's desktop, such as a computer display screen, a mobile electronic device display screen, etc.; a user may complete a series of operations such as data acquisition and system login by viewing the interface of the display and performing certain interactions with the interface.

[0049] The controller is configured as:

[0050] In response to the login information input by the user in the login interface, the login information is verified; the login information includes a verification code and personnel identity information; wherein the personnel identity information may include the names of at least two testing personnel and the name of one form filling person.

[0051] For example, Figure 2 What is shown is a display interface of the login interface in one embodiment. Figure 2 In the example, four input boxes are provided, which respectively correspond to the verification code input control, the first detection personnel input control, the second detection personnel input control and the form filling personnel input control in the login interface;

[0052] The controller is also configured to:

[0053] When the verification code input control, the first detection person input control, the second detection person input control, and the form filling person input control all input content, controlling the display to display a login control on the login interface;

[0054] In response to a user clicking operation on the login control, the login information is verified.

[0055] In this embodiment, when logging into the system, it is necessary to verify the verification code, the name of the tester, and the name of the person filling out the form at the same time, wherein the verification code may be a unique login code distributed in advance to the person filling out the form or the tester, that is, only the person related to the monitoring has the right to log in to the monitoring system to view the monitoring results. Considering that the plain code may be leaked as a verification code, the verification code may also be set as a dynamic code that changes with time, such as using a U shield or a security token as a verification code.

[0056] In this embodiment, at least two testing personnel are required to ensure the accuracy of the monitoring data. At the same time, if the name of at least one of the testing personnel and the form fillers is filled in incorrectly, the login cannot be verified successfully. Therefore, the above scheme has the effect of preventing irrelevant personnel from logging into the system and ensuring that the correct person logs into the system.

[0057] In this embodiment, the login control (such as Figure 2The dashed box position in the middle can also be set to any position covering the other four controls), which can prevent users from clicking the login control when no content is entered in the control, thereby causing invalid verification steps and saving system operating resources.

[0058] When the user clicks the login control (e.g., the login button), the system may start the verification step. During the verification, a weak password test may be performed. Specifically, the controller is further configured to:

[0059] Get weak password information within a preset time period; the weak password information can be a simple password composed of numbers and letters, or a password specified by the system or set by the user when registering; based on the correspondence between the weak password information and the person's name within a certain time period, it can be used for login information verification operations; in this embodiment, the preset time period can be within 24 hours of the previous day of the system, or other time periods can be set according to actual needs.

[0060] According to the weak password information, login tests are performed on different systems to obtain verification results. It should be noted that, in this embodiment, the steel industry data that needs to be obtained may come from different systems or subsystems, and different systems can obtain corresponding data through different verification codes. Therefore, the weak password information can be used to test multiple systems through preset addresses to obtain the operating status of multiple systems and save the test results.

[0061] Save the weak password related information involved in the login test process. Among them, in addition to the entity of the weak password information, the weak password related information may also include the timestamp of inputting the weak password information, the result of whether the weak password information is verified, the cumulative number of weak password information, etc.

[0062] After the above verification operation, the tester or form filler can log in to the system to view the data monitoring results. Before the controller generates the data monitoring results, it needs to perform the following steps:

[0063] If the verification is successful, obtain the network security information within the preset time period; the network security information includes the information of the compromised risk assets and security events; the preset time period can be set to the 24 hours of the previous day of the system, or to other time periods;

[0064] Access tests are performed according to preset important system information to obtain test results. In this embodiment, important systems preset in the software system are automatically accessed and tested one by one to ensure stable operation of important systems and timely discovery of problems, which greatly facilitates the operation of technical personnel. Through the preset of supporting software tools, it can be ensured that important systems are missed or forgotten to be inspected, which is convenient for management technicians to conduct statistics on the operation of important systems.

[0065] Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file;

[0066] Specifically, the controller is further configured as follows:

[0067] Call the Epplus plug-in in the system;

[0068] The Epplus plug-in is used to fill the network security information and the test results into the corresponding areas in the preset file template.

[0069] The exported test results, as a basic function of the system provided by this application, are used to display the collection and test results of network security and other related information in the form of files. After obtaining network security related information and corresponding test results through the supporting software tools, the corresponding area in the Excel template is filled with the Epplus plug-in, which facilitates the technicians to quickly complete the work of data collection, testing and outputting results.

[0070] After the controller generates the target table file, it can transfer the target table file to the user's desktop, control the display to display the target table file on the user's desktop, and, in response to the user's click operation on the target table file, display the content of the target table file on the user's desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data.

[0071] like Figure 3 As shown, the target table file can contain the following information:

[0072] The time when the target table file is generated;

[0073] The production line operation status of start-up, shutdown and scheduled maintenance; the production line data in the table can include the name of the operation line, start-up and shutdown status, occurrence time and operation status statistics, etc. Figure 3 The example shown in the figure can also add other data that the user wants to view in the target table file according to the actual situation, and there is no limitation here.

[0074] It should be noted that the controller in this application can be implemented with software tools, specifically developed using the Unity engine, using the C# high-level programming language as the scripting language, using the Epplus plug-in to read and write Excel tables, and using the File class in C# to implement file operations. For the file type of the target table file, it may not be limited to, for example, an .EXE executable file applicable to Windows, or other versions, or table files generated by other software with similar functions.

[0075] It can be seen from the above technical solution that the steel industry data monitoring system based on table display provided by this application can be used by management and technical personnel in various industries to handle network security data monitoring, important system operation status testing, result export tables, important production line operation status viewing and other tasks, thereby ensuring the implementation of daily management and operation and maintenance work, reducing the burden on staff, and improving the daily work efficiency of management and technical personnel.

[0076] Furthermore, in some feasible embodiments, before executing in response to the login information input by the user on the login interface, the controller is further configured to:

[0077] Obtaining a file template date of the preset file template;

[0078] If the file template date is one day before the current time, it means that the system is kept in a real-time updating state, and the display is controlled to display the login interface on the user's desktop to continue the subsequent operations.

[0079] If the file template date is not the day before the current moment, or the preset file template cannot be obtained, it means that the target table file may be damaged, or there may be a problem with the system software. At this time, the controller can generate a first prompt message; the first prompt message is used to remind the user to update the preset file template.

[0080] For example, Figure 4 In one implementation method shown, a prompt word can be displayed on the user's desktop to remind the user to import a new template file, and a control for importing a new template file can be displayed on the user's desktop. When the user clicks the control, the operation of uploading the template file can be performed to update the preset file template of the target table file in the system.

[0081] Furthermore, in some feasible embodiments, when the controller generates the target table file, it is further configured to:

[0082] Get the first table file generated one day before the current time;

[0083] The network security information and the test results are filled into corresponding areas in the first table file to update the first table file and obtain the target table file.

[0084] In this embodiment, the target table file can be generated in a cumulative form, that is, the data obtained each day are the comprehensive results of the previous historical data. Since the items of the table file can be the same, it is convenient to arrange the data of different dates according to the corresponding items to form a complete set of data. The data added later can be located in front of or behind the historical data (for example, in the upper and lower rows or left and right columns of the Excel table).

[0085] At the same time, considering that premature data does not have a high reference value, it will also increase the space occupied by the target table file and affect the data output efficiency. In some feasible embodiments, the controller is further configured as follows:

[0086] The first table file is cleared according to a preset period, and the target table file is generated according to the cleared first table file. For example, the target table file generated in each month only contains the data of the current month in a manner of resetting on the first day of each natural month.

[0087] It can be seen from the above scheme that the data monitoring system provided by this application, for on-site management data, can assist steel industry management and technical personnel in monitoring network security data, testing the operating status of important systems, exporting results to tables, checking the operating status of important production lines, etc., thereby ensuring the implementation of daily management and operation and maintenance work, reducing the burden on staff, and improving the daily work efficiency of management and technical personnel.

[0088] The system provided in this application can achieve intelligent operation and maintenance with the help of software tools, verify the data while collecting the required data, and export the results, helping operation and maintenance personnel to reduce repetitive work, greatly reduce the time for technical personnel to process information, and enable timely monitoring of data.

[0089] In combination with the above, the present application also provides a steel industry data monitoring method based on table display, the method comprising:

[0090] In response to login information input by the user on the login interface, verify the login information; the login information includes a verification code and personnel identity information;

[0091] If the verification is successful, obtain the network security information within the preset time period; the network security information includes the information of the lost risk assets and security events;

[0092] Perform access test based on preset important system information to obtain test results;

[0093] Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file;

[0094] Controlling the display to display the target table file on the user desktop, and in response to a user clicking operation on the target table file, displaying the content of the target table file on the user desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data;

[0095] Furthermore, the operating status of the production line includes startup, shutdown and annual maintenance; the production line data includes the name of the operation line, startup and shutdown status, occurrence time and operating status statistics.

[0096] The technical effects produced by the method provided in this application in the application can be found in the description of the aforementioned system embodiment and will not be elaborated here.

[0097] Similar parts between the embodiments provided in this application can be referenced to each other. The specific implementation methods provided above are only a few examples under the general concept of this application and do not constitute a limitation on the protection scope of this application. For those skilled in the art, any other implementation methods expanded based on the scheme of this application without creative work belong to the protection scope of this application.

Claims

1. A steel industry data monitoring system based on table display, characterized in that: include: A display, used to display the user's desktop; The controller is configured as: In response to login information input by the user on the login interface, verify the login information; the login information includes a verification code and personnel identity information; If the verification is successful, obtain the network security information within the preset time period; The cybersecurity information includes information on lost risk assets and security incidents; Perform access test based on preset important system information to obtain test results; Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file; Control the display to display the target table file on the user's desktop, and in response to the user's click operation on the target table file, display the content of the target table file on the user's desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data.

2. A steel industry data monitoring system based on table display according to claim 1, characterized in that: Before executing the operation in response to the login information input by the user on the login interface, the controller is further configured to: Obtaining a file template date of the preset file template; If the file template date is one day before the current time, controlling the display to display the login interface on the user desktop; If the file template date is not the day before the current time, or the preset file template cannot be obtained, a first prompt message is generated; the first prompt message is used to remind the user to update the preset file template.

3. The steel industry data monitoring system based on table display according to claim 1 is characterized in that: The personnel identity information includes the names of at least two testing personnel and the name of one form filling person.

4. The steel industry data monitoring system based on table display according to claim 1 is characterized in that: In executing the step of verifying the login information, the controller is further configured to: Obtain weak password information within a preset time period; Perform login tests on different systems according to the weak password information to obtain verification results; Save information related to weak passwords involved in the login test process.

5. The steel industry data monitoring system based on table display according to claim 3 is characterized in that: The login interface includes a verification code input control, a first detection personnel input control, a second detection personnel input control, and a form filling personnel input control; the controller is also configured to: When the verification code input control, the first detection person input control, the second detection person input control, and the form filling person input control all input content, controlling the display to display a login control on the login interface; In response to a user clicking operation on the login control, the login information is verified.

6. The steel industry data monitoring system based on table display according to claim 1 is characterized in that: The controller imports the network security information and the test results into corresponding areas in a preset file template to generate a target table file, and is further configured to: Call the Epplus plug-in in the system; The Epplus plug-in is used to fill the network security information and the test results into the corresponding areas in the preset file template.

7. The steel industry data monitoring system based on table display according to claim 1 is characterized in that: When the controller generates the target table file, it is also configured as follows: Get the first table file generated one day before the current moment; The network security information and the test results are filled into corresponding areas in the first table file to update the first table file and obtain the target table file.

8. The steel industry data monitoring system based on table display according to claim 7 is characterized in that: The controller is also configured to: The first table file is cleared according to a preset period, and the target table file is generated according to the cleared first table file.

9. A steel industry data monitoring method based on table display, characterized in that: The method comprises: In response to login information input by the user on the login interface, verify the login information; the login information includes a verification code and personnel identity information; If the verification is successful, obtain the network security information within the preset time period; the network security information includes the information of the lost risk assets and security events; Perform access test based on preset important system information to obtain test results; Importing the network security information and the test results into corresponding areas in a preset file template to generate a target table file; Control the display to display the target table file on the user's desktop, and in response to the user's click operation on the target table file, display the content of the target table file on the user's desktop; wherein the content of the target table file is displayed in the form of a list, and the content includes the production line operation status and production line data.

10. The steel industry data monitoring method based on table display according to claim 9, characterized in that: The production line operation status includes startup, shutdown and scheduled maintenance; the production line data includes the operation line name, startup and shutdown status, occurrence time and operation status statistics.

Images