CN113127486B - Information collection and storage method, device, equipment and storage medium - Google Patents

Information collection and storage method, device, equipment and storage medium Download PDF

Info

Publication number
CN113127486B
CN113127486B CN202110395848.9A CN202110395848A CN113127486B CN 113127486 B CN113127486 B CN 113127486B CN 202110395848 A CN202110395848 A CN 202110395848A CN 113127486 B CN113127486 B CN 113127486B
Authority
CN
China
Prior art keywords
information
mainboard
mainboard information
database
operator
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202110395848.9A
Other languages
Chinese (zh)
Other versions
CN113127486A (en
Inventor
邓亚隆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shandong Yingxin Computer Technology Co Ltd
Original Assignee
Shandong Yingxin Computer Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shandong Yingxin Computer Technology Co Ltd filed Critical Shandong Yingxin Computer Technology Co Ltd
Priority to CN202110395848.9A priority Critical patent/CN113127486B/en
Publication of CN113127486A publication Critical patent/CN113127486A/en
Application granted granted Critical
Publication of CN113127486B publication Critical patent/CN113127486B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K7/00Methods or arrangements for sensing record carriers, e.g. for reading patterns
    • G06K7/10Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
    • G06K7/10544Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Electromagnetism (AREA)
  • Health & Medical Sciences (AREA)
  • Toxicology (AREA)
  • Artificial Intelligence (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Human Computer Interaction (AREA)
  • General Health & Medical Sciences (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses an information collection and storage method, device, equipment and storage medium, wherein the method comprises the following steps: receiving mainboard information input by an operator through code scanning of a code scanner; displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information; and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information. It can be seen that this application can realize sweeping of mainboard information sign indicating number and type in automatically to realize the storage of mainboard information again after operator's checking, thereby not only can save the type time of mainboard information greatly, and can effectively improve the accuracy of mainboard information type.

Description

Information collection and storage method, device, equipment and storage medium
Technical Field
The present invention relates to the technical field of PC (Personal Computer) testing, and more particularly, to a method, an apparatus, a device and a storage medium for collecting and storing information.
Background
In the process of producing and testing the domestic PC, three information of a main board Serial Number (QN), a Media Access Control Address (MAC Address) and a device Serial Number (SN) are required to be correspondingly stored in a database of a diag (production test system) system in the PC assembly stage, and the diag system can identify the corresponding device Serial Number according to the two information of the main board Serial Number and the MAC Address of the network card in the test stage after the assembly is finished, so that the corresponding PC test is realized, otherwise, the machine is required to be in a task and does not exist, and the PC cannot be tested. At present, manual writing operation of writing three information, namely a mainboard serial number, a network card MAC address and an equipment serial number, into a database needs to be manually realized in a PC assembling stage, and when PCs are produced in the whole country, due to the fact that the yield is high, more than thousands of machines are assembled on a production line every day, time is wasted due to the fact that each machine needs to manually write the information into the database, manual input can be caused by errors of input information due to subjective reasons, and accuracy is low.
Disclosure of Invention
The invention aims to provide an information collection and storage method, device, equipment and storage medium, which can greatly save the recording time of mainboard information and effectively improve the accuracy of mainboard information recording.
In order to achieve the above purpose, the invention provides the following technical scheme:
an information collection and storage method, comprising:
receiving mainboard information input by an operator through code scanning of a code scanner;
displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information;
and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information.
Preferably, after determining that the operation instruction indicates that the checking and verification of the motherboard information is passed, the method further includes:
and judging whether the number of the parameters contained in the mainboard information is the same as the preset number, if so, continuing to execute the step of storing the mainboard information into a specified database, and otherwise, reporting an error.
Preferably, after determining that the number of parameters included in the motherboard information is the same as a preset number, the method further includes:
respectively judging whether the length of each parameter contained in the mainboard information is the same as the length of each preset parameter, whether a network card MAC address contained in the mainboard information is not recorded before the current moment, whether the network card MAC address contained in the mainboard information and a corresponding mainboard serial number are not stored in the database, and whether the mainboard serial number contained in the mainboard information starts with MBL, if so, continuing to execute the step of storing the mainboard information into a specified database, otherwise, reporting an error.
Preferably, the storing the motherboard information into a designated database includes:
and judging whether the equipment serial number contained in the mainboard information is not stored in the database, if so, directly storing the mainboard information into the database, otherwise, updating the network card MAC address and the mainboard serial number contained in the mainboard information into the database.
Preferably, after receiving an operation instruction input by the operator after checking and verifying the displayed main board information, the method further includes:
and after a preset time interval from the moment of receiving the operation instruction input by the operator, clearing the displayed mainboard information to indicate that the operator can continue to scan and enter the code.
Preferably, the storing the motherboard information into a designated database includes:
and transmitting the mainboard information to a processing script in a command line parameter transmission mode so as to instruct the processing script to store the mainboard information into a specified database.
Preferably, the method further comprises the following steps:
and displaying the execution result, the log information and the error reporting content of each step.
An information collection storage device comprising:
a receiving module to: receiving mainboard information input by an operator through code scanning of a code scanner;
a display module to: displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information;
a storage module to: and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information.
An information collecting and storing apparatus comprising:
a database for storing a computer program;
a processor for implementing the steps of the information collection and storage method as described in any one of the above when the computer program is executed.
A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, implements the steps of the information collecting and storing method of any one of the above.
The invention provides an information collection and storage method, device, equipment and storage medium, wherein the method comprises the following steps: receiving mainboard information input by an operator through code scanning of a code scanner; displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information; and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information. This application can receive the mainboard information that the operator used the bar code scanner to sweep the PC of sign indicating number entry, shows mainboard information to check the check-up at the operator to mainboard information and pass the back, use mainboard information direct storage to the database in, use when supplying follow-up to the PC test. It can be seen that this application can realize sweeping of mainboard information sign indicating number and type in automatically to realize the storage of mainboard information again after operator's checking, thereby not only can save the type time of mainboard information greatly, and can effectively improve the accuracy of mainboard information type.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a flowchart of an information collection and storage method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a GUI tool interface at an assembly stage in an information collection and storage method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a GUI tool interface in a maintenance phase of an information collection and storage method according to an embodiment of the present invention;
fig. 4 is a schematic diagram illustrating various information displays executed by steps in an information collection and storage method according to an embodiment of the present invention;
fig. 5 is an architecture diagram implemented in an information collection and storage method according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of an information collection and storage device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, belong to the protection scope of the present invention.
Referring to fig. 1, a flowchart of an information collecting and storing method according to an embodiment of the present invention is shown, where the method includes:
s11: and receiving the mainboard information which is input by the scanning code of the scanner by an operator.
According to the method, a humanized GUI (Graphical User Interface) tool can be written based on python and the like to collect various information, so that an execution main body of the information collection and storage method can be the GUI tool, and the GUI tool can be integrated with an information collection and storage device. In the PC assembling and maintaining stage, an operator can use a scanner to scan the information code on the PC, and the scanned mainboard information can be automatically input into a GUI tool; the mainboard information may include a mainboard serial number, a network card MAC address, and a device serial number.
S12: displaying the mainboard information, and receiving an operation instruction input by an operator after checking and verifying the displayed mainboard information.
After receiving mainboard information input by an operator through code scanning by a code scanner, the GUI tool can display the mainboard information on an interface of the GUI tool so that the operator can acquire the mainboard information obtained through code scanning; and after obtaining the mainboard information through the interface, the operator can check and verify the mainboard information, if the result of the check and verification is passed, an operation instruction for continuing to execute the subsequent steps can be sent to the GUI tool, otherwise, an operation instruction for stopping executing the subsequent steps can be sent to the GUI tool. The checking and verifying of the mainboard information by the operator includes, but is not limited to, checking whether all the parameters included in the mainboard information are recorded, whether the length of each parameter included in the mainboard information meets the expectation, and the like, and of course, other settings performed according to actual needs are also within the protection scope of the present invention.
S13: and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information.
After receiving an operation instruction input by an operator, the GUI tool automatically analyzes the operation instruction, and if the operation instruction indicates that the mainboard information is checked and verified by the operator, the mainboard information can be directly stored in a database of the diag system for subsequent testing of a PC corresponding to the mainboard information; otherwise, the mainboard information can be refused to be stored in the database of the diag system, and the operator can be instructed to realize the code scanning entry of the mainboard information again.
This application can receive the mainboard information that the operator used the PC that the code entered that the bar code was swept to the bar code scanner to show mainboard information, with the operator check the check-up to mainboard information after passing, with mainboard information direct storage to the database in, use when supplying follow-up to PC test. It is thus clear that this application can realize sweeping of mainboard information sign indicating number and typeeing automatically to realize the storage of mainboard information again after checking of operator, thereby not only can save the type time of mainboard information greatly, and can effectively improve the accuracy of mainboard information type.
In the information collecting and storing method provided in the embodiment of the present invention, after determining that the operation instruction indicates that the checking and verification of the motherboard information is passed, the method may further include:
and judging whether the quantity of the parameters contained in the mainboard information is the same as the preset quantity, if so, continuing to execute the step of storing the mainboard information into a specified database, and otherwise, reporting an error.
It should be noted that, the general motherboard information includes three parameters, which are a motherboard serial number, a network card MAC address, and an equipment serial number respectively; therefore, in order to further ensure the accuracy of the motherboard information, after the operator checks and verifies the motherboard information, the method and the device can determine whether the number of parameters contained in the motherboard information is the preset number (for example, 3), and if so, the number of parameters contained in the motherboard information can be determined to be correct, so that the step of storing the motherboard information in the database can be continuously executed, otherwise, an error can be reported, and the error reporting in the embodiment of the method and the device can specifically be realized by displaying the error reported information on an interface of a GUI tool.
The information collection and storage method provided in the embodiment of the present invention may further include, after determining that the number of parameters included in the motherboard information is the same as the preset number:
respectively judging whether the length of each parameter contained in the mainboard information is the same as the length of each preset parameter, whether a network card MAC address contained in the mainboard information is not recorded before the current moment, whether the network card MAC address contained in the mainboard information and a corresponding mainboard serial number are not stored in a database, and whether the mainboard serial number contained in the mainboard information starts with MBL, if yes, continuing to execute the step of storing the mainboard information into a specified database, and if not, reporting an error.
It should be noted that, after receiving the motherboard information and determining that the number of parameters included in the motherboard information is correct, the embodiment of the present application may further perform corresponding information processing on the motherboard information, and the processing logic may be summarized as follows: 1. judging whether the length of each parameter contained in the mainboard information is correct 2, judging whether the network card MAC address in the mainboard information has no historical repeatability 3 (namely whether the network card MAC address is not recorded), judging whether the format content of the mainboard serial number starts with MBL 4, and judging whether a repeated mainboard serial number and a network card MAC address having a corresponding relation with the mainboard serial number do not exist in a database (which can be a mysql table). If the judgment results are yes, the mainboard information is accurate, and therefore the mainboard information can be stored in the database, and otherwise, an error can be reported. Therefore, the correctness and completeness of the writing-in of the database content are greatly improved through the 4 verification processes of the information of the main board, and a series of error problems which are easy to occur in manual input are avoided.
The information collection and storage method provided by the embodiment of the invention stores mainboard information into a specified database, and can include:
and judging whether the equipment serial number contained in the mainboard information is not stored in the database, if so, directly storing the mainboard information into the database, and otherwise, updating the network card MAC address and the mainboard serial number contained in the mainboard information into the database.
The main board information input can be realized by two stages, namely an assembly stage and a maintenance stage of the PC; after the mainboard information is received in the assembly stage and passes a series of checks on the mainboard information, the mainboard information can be directly stored in the database, and the mainboard information of the corresponding PC is already stored in the database in the maintenance stage, so that after the mainboard information passes a series of checks, the equipment serial number which is the same as the equipment serial number in the currently received mainboard information can be inquired in the database, and then the network card MAC address and the mainboard serial number in the currently received mainboard information are replaced, and the network card MAC address and the mainboard serial number which correspond to the same equipment serial number in the database, thereby realizing the updating of the mainboard information. Therefore, the effective storage of the information of the PC at different stages can be realized in different modes.
The information collection and storage method provided by the embodiment of the present invention, after receiving an operation instruction input by an operator after checking and verifying displayed motherboard information, may further include:
and after a preset time interval from the moment of receiving the operation instruction input by the operator, emptying the displayed mainboard information to indicate that the operator can continue to scan and enter the code.
After receiving the operating instruction input by the operator, in order to facilitate the operator to confirm whether the input operating instruction is correct again, and then take corresponding measures in time when the input operating instruction is incorrect, the embodiment of the application can empty the displayed mainboard information after a certain time interval (preset time interval, such as 5 s) set according to actual needs from the moment of receiving the operating instruction, so as to allow the operator to continue to scan the code for entry, and further effectively improve the accuracy of the stored mainboard information.
The information collection and storage method provided by the embodiment of the present invention stores motherboard information in a designated database, and may include:
and transmitting the mainboard information to the processing script in a command line parameter transmission mode so as to instruct the processing script to store the mainboard information into a specified database.
This application can set up corresponding processing script to after the code scanning of bar code scanner enters corresponding mainboard information, can pass the mode of participating with the command line with mainboard information and transmit for processing script, the execution processing script to in mainboard information storage to the database that will transmit for processing script, thereby improve mainboard information storage's convenience and validity.
The information collection and storage method provided by the embodiment of the invention can further comprise the following steps:
and displaying the execution result, the log information and the error reporting content of each step.
According to the method and the device, in the process of realizing mainboard information collection and storage, the execution result, the log information and the error reporting content of each step can be displayed, so that an operator can know corresponding information based on the displayed content, and corresponding error repair and other processing are realized.
It should be noted that, in the embodiment of the present application, each parameter in the motherboard information may be sequentially scanned and entered, that is, each parameter is entered, the parameter is directly displayed until three parameters of the motherboard information are entered and displayed, and then an operation instruction input by an operator for the displayed motherboard information may be received; the mode of inputting the operation instruction by the operator may be that the interface of the GUI tool includes two buttons, which are "determine" and "quit", respectively, the operator clicks the "determine" button to indicate that the checking and verification of the operator on the motherboard information is passed, and the operator clicks the "quit" button to indicate that the checking and verification of the operator on the motherboard information is not passed; of course, other settings can be made according to actual needs, and are within the protection scope of the present invention.
The method can be realized based on python, java, NET, c # and the like, and in a specific mode realized based on python, in order to achieve an efficient process of domestic PC mainboard information collection and storage, a humanized GUI tool can be compiled based on python to collect various inspection information, and interfaces of the GUI tool in the PC assembling stage and the PC maintaining stage can be respectively shown in FIG. 2 and FIG. 3. The GUI tool comprises windows executable files a and b (a source file a. Py assembly version and a source file b. Py repair version), shell scripts c.sh (assembly version) under linux, and shell scripts d.sh (repair version) under linux. And operators in the assembling and maintaining stages can perform code scanning entry and modification operation on the integrated machine carried by the stations.
The principle of the executable file a under Windows is as follows: utilizing Tkinter class in python to make graphic interfacing window, button, prompting character and input box; the paramiko class implements SSH2 remote secure connection/login to Linux system addresses. After detecting that the content of the first row (machine SN, i.e. the device serial number) is input by a code scanner (e.g. a code scanning gun), the input cursor is automatically jumped to the next row (main board QN, i.e. the main board serial number), and when the main board QN is also code scanned and recorded, the input cursor is automatically jumped to a main board BMC _ MAC item (network card MAC address) for the code scanning gun to scan information. In the program, c.sh is automatically called, the input parameters in the figure 2 are transmitted to a shell script under Linux in a COMMAND line parameter transmission mode, after an inspector clicks a confirmation button, a GUI tool written by python calls EXEC _ COMMAND, the obtained parameters call the shell script c.sh under a diag server in a c.sh machine SN + mainboard QN + network card MAC (in the form of shell.sh 1 3), and all the parameters input by an operator are transmitted. Finally, the results of the execution in the shell script (including steps, log information, error contents, execution results) are displayed back below the interface of the GUI tool (stdout. Read (). Split lines ()) as shown in FIG. 4. And 5s after clicking to confirm that the execution is finished (calling the sleep delay attribute), automatically emptying the contents in the three input boxes for the secondary use of an operator, wherein the delete attribute of the window class is called for emptying.
The principle of the executable file b under Windows is basically consistent with that of the executable file a, but the shell script under the diag server is called by the code logic to be changed into d.sh, and the interface typeface is changed from an assembly version to a maintenance version.
The principle of shell script c.sh under linux is as follows: if the parameter transmitted by a is received, firstly judging whether the number of the transmitted parameters is consistent with the preset number, if so, continuing to process, otherwise, reporting an error, and then performing data processing on the data, wherein the logic of the processing can be basically summarized as follows: 1. judging whether the length of the three transmitted data is correct 2, judging whether the MAC address of the network card has historical repeatability, if the three data are repeated, abandoning error reporting and no-permission recording 3, judging whether the format content of the main board QN starts from MBL 4, judging whether repeated main board QN and network card MAC exist in the mysql to be written in, and if repeated information is repeated, prompting that the information is repeatedly recorded, and prompting that the error reporting and no-permission repeated binding information exists. The correctness and the integrity of the writing-in of the content of the database are greatly improved through the 4 verification processes, and a series of errors easily caused by manual entry are avoided. And the database writing function of the shell script c.sh is used for scanning the assembly line GUI assembly version code to perform database insert operation. The shell script can be replaced by any other scripting language such as: python, expect, prel, etc. only need to realize the same function.
The principle of shell script d.sh under linux is as follows: the principle of the script is basically the same as that of c.sh, but the operation in the script is the updating operation of original data, and when a main board is replaced in a maintenance working section, the code needs to be scanned again to record a main board QN and a network card MAC, so that the equipment serial number SN and the two information are bound again, which is equivalent to the update operation of a database.
The architecture diagram implemented by the application can be as shown in fig. 5, and specifically, a visualized GUI operation interface under windows can be written by python, and input parameters are transmitted to a shell script under a linux system of a server host (data entry needs to be performed in a server security environment because of data security, and data can also be written by directly connecting a database in python); the shell script collects information transmitted by the python tool, processes data and judges logic, and writes the data into a database for storage after the data are confirmed to be correct; and mysql stores the corresponding information of the homemade PC mainboard QN, the network card MAC and the serial number. The production line only needs to correspondingly scan the contents of three bar codes by using a code scanning gun, the writing in of the database can be realized by clicking confirmation, and a large amount of data logic judgment and verification are performed before the writing in, so that the accuracy of data input is ensured. Therefore, one-key collection, input and modification of the mainboard information code scanning are realized, and the method is more convenient, simpler and more accurate; for the information collection of the main boards of thousands of equipment, the operation difficulty is greatly reduced, the data accuracy and safety are improved, the time and labor cost are saved, the production time period is shortened, and the yield is improved; the intelligent level of new nationwide production plants is improved.
An embodiment of the present invention further provides an information collecting and storing apparatus, as shown in fig. 6, which may include:
a receiving module 11, configured to: receiving mainboard information input by an operator through code scanning of a code scanner;
a display module 12 for: displaying the mainboard information, and receiving an operation instruction input by an operator after checking and verifying the displayed mainboard information;
a storage module 13 for: and if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information.
The information collecting and storing device provided by the embodiment of the invention can further comprise:
a first determining module, configured to: and after the operation instruction is determined to indicate that the checking and verification of the mainboard information are passed, judging whether the quantity of the parameters contained in the mainboard information is the same as the preset quantity, if so, continuing to execute the step of storing the mainboard information into a specified database, otherwise, reporting an error.
The information collecting and storing device provided by the embodiment of the invention can further comprise:
a second determining module configured to: after the quantity of the parameters contained in the mainboard information is determined to be the same as the preset quantity, whether the length of each parameter contained in the mainboard information is the same as the length of each preset parameter, whether a network card MAC address contained in the mainboard information is not recorded before the current moment, whether the network card MAC address contained in the mainboard information and a corresponding mainboard serial number are not stored in a database, and whether the mainboard serial number contained in the mainboard information starts with MBL are respectively judged, if yes, the step of storing the mainboard information into a specified database is continuously executed, and if not, an error is reported.
In an information collecting and storing apparatus provided in an embodiment of the present invention, a storage module may include:
a storage unit to: and judging whether the equipment serial number contained in the mainboard information is not stored in the database, if so, directly storing the mainboard information into the database, and otherwise, updating the network card MAC address and the mainboard serial number contained in the mainboard information into the database.
The information collecting and storing device provided by the embodiment of the invention can also comprise:
an emptying module for: after receiving an operation instruction input by an operator after checking and verifying displayed mainboard information, emptying the displayed mainboard information after a preset time interval from the moment of receiving the operation instruction input by the operator so as to indicate that the operator can continue to scan and enter codes.
In an information collecting and storing apparatus provided in an embodiment of the present invention, the storage unit may include:
a storage subunit to: and transmitting the mainboard information to the processing script in a command line parameter transmission mode so as to instruct the processing script to store the mainboard information into a specified database.
In an information collecting and storing apparatus provided in an embodiment of the present invention, the display module may be further configured to: and displaying the execution result, the log information and the error reporting content of each step.
An embodiment of the present invention further provides an information collecting and storing device, which may include:
a database for storing computer programs;
and the processor is used for realizing the steps of the information collection and storage method in any one of the above modes when executing the computer program.
The embodiment of the invention also provides a computer-readable storage medium, wherein a computer program is stored on the computer-readable storage medium, and when being executed by a processor, the computer program realizes the steps of any one of the information collection and storage methods.
It should be noted that for the description of the relevant parts in the information collection and storage apparatus, the device and the storage medium provided in the embodiments of the present invention, reference is made to the detailed description of the corresponding parts in the information collection and storage method provided in the embodiments of the present invention, and details are not repeated here. In addition, parts of the technical solutions provided in the embodiments of the present invention that are consistent with the implementation principle of the corresponding technical solutions in the prior art are not described in detail, so as to avoid redundant description.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (8)

1. An information collection and storage method, comprising:
receiving mainboard information input by an operator through code scanning of a code scanner;
displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information;
if the operation instruction indicates that the checking and verification of the mainboard information are passed, judging whether the number of the parameters contained in the mainboard information is the same as the preset number, and if the number of the parameters contained in the mainboard information is determined to be different from the preset number, reporting an error; if the number of the parameters contained in the mainboard information is determined to be the same as the preset number, respectively judging whether the length of each parameter contained in the mainboard information is the same as the length of each preset parameter, whether a network card MAC address contained in the mainboard information is not recorded before the current moment, whether the network card MAC address contained in the mainboard information and a corresponding mainboard serial number are not stored in a database, and whether the mainboard serial number contained in the mainboard information starts with MBL, if yes, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information, otherwise, reporting an error.
2. The method of claim 1, wherein storing the motherboard information in a designated database comprises:
and judging whether the equipment serial number contained in the mainboard information is not stored in the database, if so, directly storing the mainboard information into the database, otherwise, updating the network card MAC address and the mainboard serial number contained in the mainboard information into the database.
3. The method according to claim 2, further comprising, after receiving the operation instruction input by the operator after checking and verifying the displayed motherboard information, the method further comprising:
and after a preset time interval from the moment of receiving the operation instruction input by the operator, clearing the displayed mainboard information to indicate that the operator can continue to scan and enter the code.
4. The method of claim 3, wherein storing the motherboard information in a specified database comprises:
and transmitting the mainboard information to a processing script in a command line parameter transmission mode so as to instruct the processing script to store the mainboard information into a specified database.
5. The method of claim 4, further comprising:
and displaying the execution result, the log information and the error reporting content of each step.
6. An information collection and storage device, comprising:
a receiving module to: receiving mainboard information input by an operator through code scanning of a code scanner;
a display module to: displaying the mainboard information, and receiving an operation instruction input by the operator after checking and verifying the displayed mainboard information;
a storage module to: if the operation instruction indicates that the checking and verification of the mainboard information are passed, storing the mainboard information into a specified database for testing a PC corresponding to the mainboard information;
a first determining module, configured to: after the operating instruction is determined to indicate that the checking and verification of the mainboard information are passed, judging that the quantity of parameters contained in the mainboard information is the same as the preset quantity, if so, continuing to execute the step of storing the mainboard information into a specified database, otherwise, reporting an error;
a second determination module configured to: after determining that the quantity of the parameters contained in the mainboard information is the same as the preset quantity, respectively judging whether the length of each parameter contained in the mainboard information is the same as the length of each preset parameter, whether a network card MAC address contained in the mainboard information is not recorded before the current moment, whether the network card MAC address contained in the mainboard information and a corresponding mainboard serial number are not stored in the database, and whether the mainboard serial number contained in the mainboard information starts with MBL, if yes, continuing to execute the step of storing the mainboard information into a specified database, otherwise, reporting an error.
7. An information collection storage device, comprising:
a database for storing computer programs;
a processor for implementing the steps of the information collection and storage method according to any one of claims 1 to 5 when executing the computer program.
8. A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the information collecting and storing method according to any one of claims 1 to 5.
CN202110395848.9A 2021-04-13 2021-04-13 Information collection and storage method, device, equipment and storage medium Active CN113127486B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110395848.9A CN113127486B (en) 2021-04-13 2021-04-13 Information collection and storage method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110395848.9A CN113127486B (en) 2021-04-13 2021-04-13 Information collection and storage method, device, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN113127486A CN113127486A (en) 2021-07-16
CN113127486B true CN113127486B (en) 2023-03-14

Family

ID=76776079

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110395848.9A Active CN113127486B (en) 2021-04-13 2021-04-13 Information collection and storage method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113127486B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115102843B (en) * 2022-05-26 2023-07-14 苏州浪潮智能科技有限公司 Method and device for obtaining server serial number and computer equipment
CN115825704B (en) * 2023-02-14 2023-07-04 深圳新智联软件有限公司 Method, device, system, equipment and medium for testing projection mainboard

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102625939A (en) * 2009-07-10 2012-08-01 塞尔蒂卡姆公司 System and method for managing electronic assets
CN105892351A (en) * 2016-03-28 2016-08-24 宁波麦博韦尔移动电话有限公司 Electrical control system for automatic reading and writing main board tag information of mobile phone
CN106469322A (en) * 2016-08-31 2017-03-01 广州小百合信息技术有限公司 CI PLus certificate method for burn-recording, system and device
CN107664989A (en) * 2017-09-29 2018-02-06 郑州云海信息技术有限公司 One kind customizes information binding and collection method automatically
CN110427287A (en) * 2019-07-10 2019-11-08 深圳市福瑞祥电器有限公司 Main board function test all-purpose system and method
CN111783916A (en) * 2020-07-29 2020-10-16 上海英杰制模有限公司 SONY product bar code scanning management system

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070100895A1 (en) * 2005-11-02 2007-05-03 Naonori Sakata Data maintenance apparatus, data maintenance method, and data maintenance system
CN101286848A (en) * 2008-05-23 2008-10-15 杨筑平 Login authentication method and login signature procedure
CN107147743B (en) * 2017-06-29 2020-04-03 深圳市劳沃智能科技有限公司 Communication method of Internet of things system based on simplified Internet of things communication protocol
US10776346B2 (en) * 2018-06-22 2020-09-15 Paypal, Inc. Systems and methods for providing flexible data access

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102625939A (en) * 2009-07-10 2012-08-01 塞尔蒂卡姆公司 System and method for managing electronic assets
CN105892351A (en) * 2016-03-28 2016-08-24 宁波麦博韦尔移动电话有限公司 Electrical control system for automatic reading and writing main board tag information of mobile phone
CN106469322A (en) * 2016-08-31 2017-03-01 广州小百合信息技术有限公司 CI PLus certificate method for burn-recording, system and device
CN107664989A (en) * 2017-09-29 2018-02-06 郑州云海信息技术有限公司 One kind customizes information binding and collection method automatically
CN110427287A (en) * 2019-07-10 2019-11-08 深圳市福瑞祥电器有限公司 Main board function test all-purpose system and method
CN111783916A (en) * 2020-07-29 2020-10-16 上海英杰制模有限公司 SONY product bar code scanning management system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
快销品行业中如何实现序列号出入库;管家婆物联网;《搜狐网》;20191219;全文 *
移动环境下企业库存管理系统设计与实现;王中宝;《中国优秀硕士学位论文全文数据库信息科技辑》;20170615;全文 *

Also Published As

Publication number Publication date
CN113127486A (en) 2021-07-16

Similar Documents

Publication Publication Date Title
US11281570B2 (en) Software testing method, system, apparatus, device medium, and computer program product
CN113127486B (en) Information collection and storage method, device, equipment and storage medium
US8276126B2 (en) Determining causes of software regressions based on regression and delta information
CN108509344B (en) Daily cutting batch test method, equipment and readable storage medium
CN107102947B (en) ATM transaction flow testing device and method
CN109426611A (en) A kind of method for testing software and device
CN112231213A (en) Web automatic testing method, system, storage medium and terminal equipment
CN112115055A (en) Multi-machine automatic testing method and device and computer equipment
CN112650670A (en) Application testing method, device, system, electronic equipment and storage medium
CN115408228A (en) Automatic testing method, device and system for touch screen equipment
CN111782117A (en) Interface display method and device, storage medium and electronic device
CN113126993B (en) Automatic test method and system applied to vehicle detection software
CN115080389A (en) Test system, method, equipment and storage medium for improving index statistical efficiency
CN112911283B (en) Smart television testing method and device
CN111966575B (en) Graphic automatic test method for aviation onboard display software
CN113127280A (en) API interface automatic input method and system
CN115963379A (en) Automatic test method, device, equipment and storage medium for circuit board
CN111008140B (en) Cross-platform UI (user interface) automatic testing method and device
CN110543424B (en) Test method and device for electronic tax platform
CN114328185A (en) Continuously integrated information aggregation system
CN210650758U (en) Test system of robot demonstrator
CN113094281B (en) Test method and device for hybrid App
CN108920363A (en) A kind of multi-platform software automated testing method
CN113791818B (en) Code improvement method, device, medium and equipment based on measurement platform
CN113903368B (en) Automatic test method, device and equipment for disc and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant