CN113127486A - 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
CN113127486A
CN113127486A CN202110395848.9A CN202110395848A CN113127486A CN 113127486 A CN113127486 A CN 113127486A CN 202110395848 A CN202110395848 A CN 202110395848A CN 113127486 A CN113127486 A CN 113127486A
Authority
CN
China
Prior art keywords
information
mainboard
mainboard information
operator
database
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.)
Granted
Application number
CN202110395848.9A
Other languages
Chinese (zh)
Other versions
CN113127486B (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, and 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, emptying 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 device comprising:
a database for storing computer programs;
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 being executed by a processor, carries out the steps of the information collecting and storing method according to any one of the preceding claims.
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 PC that the code was input to be swept to the bar code scanner, shows mainboard information to check at the operator to mainboard information and verify the check-up after passing, with mainboard information direct storage to the database, use when supplying follow-up to 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 derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within 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 scanning codes by an operator by using a code scanner.
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: and 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 using 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 acquiring 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 is 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 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.
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.
In the information collecting and storing method provided in the embodiment of the present invention, after determining that the number of parameters included in the motherboard information is the same as the preset number, the method may further include:
respectively judging whether the length of each parameter contained in the mainboard information is the same as that 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 (namely is not recorded) 3, judging whether the format content of the mainboard serial number is MBL (moving markup language) beginning 4, and judging whether a repeated mainboard serial number and a network card MAC address having a corresponding relation with the repeated 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 present invention stores motherboard information in a designated database, and may 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 operation instruction input by the operator, in order to facilitate the operator to confirm whether the input operation instruction is correct again, and then take corresponding measures in time when the input operation instruction is incorrect, the embodiment of the application can empty the displayed mainboard information after a certain time interval (preset time interval, such as 5s) set according to actual needs from the moment of receiving the operation 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 can be that the interface of the GUI tool includes two buttons, namely "confirm" and "quit", respectively, the operator clicks the "confirm" button to indicate that the checking and verification of the mainboard information by the operator is passed, and the operator clicks the "quit" button to indicate that the checking and verification of the mainboard information by the operator 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 tools contain windows executable files a, b (source file a. py assembly version, source file b. py repair version), shell script c.sh (assembly version) under linux, shell script d.sh (repair version) under linux. And in the assembling and maintaining stage, an operator can perform code scanning entry and modification operation on the integrated machine carried by the station.
The principle of 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, the c.sh is automatically called, the input parameters in the figure 2 are transmitted to a shell script under the 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 the diag server in a c.sh machine SN + mainboard QN + network card MAC (in the shell.sh 123) mode, 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 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 parameters transmitted by a are 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 transmitted data are repeated, discarding error reporting and no-permission recording 3, judging whether the format content of the main board QN starts with MBL 4, judging whether repeated main board QN and network card MAC exist in the mysql table to be written, if the information is repeatedly recorded, prompting error reporting and no-permission repeated binding information. The 4 verification processes greatly improve the correctness and completeness of the writing of the database content, and a series of errors easily caused by manual input are avoided. And a database writing function of the shell script c.sh is used for scanning the assembly version of the assembly line GUI 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. In order to solve the difficulty of information input in domestic PC production, a graphical interface information input tool is manufactured, a production line only needs to scan three bar codes into contents correspondingly by using a code scanning gun, the writing-in of a 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 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.
The information collecting and storing device provided by the embodiment of the invention can further comprise:
a second determination 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 further 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, a 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 above technical solutions provided in the embodiments of the present invention that are consistent with the implementation principles 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 (10)

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;
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.
2. The method of claim 1, wherein determining that the operation instruction indicates that the checkup verification of the motherboard information is passed further comprises:
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.
3. The method according to claim 2, wherein after determining that the number of parameters included in the motherboard information is equal to a preset number, the method further comprises:
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.
4. The method of claim 3, wherein storing the motherboard information in a specified 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, and otherwise, updating the network card MAC address and the mainboard serial number contained in the mainboard information into the database.
5. The method according to claim 4, wherein after receiving the operation instruction input by the operator after the verification of the displayed mainboard information, the method further comprises:
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.
6. The method of claim 5, 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.
7. The method of claim 6, further comprising:
and displaying the execution result, the log information and the error reporting content of each step.
8. 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: 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.
9. 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 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the information collection and storage method according to any one of claims 1 to 7.
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 true CN113127486A (en) 2021-07-16
CN113127486B 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)

Cited By (2)

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

Citations (10)

* 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
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
CN107147743A (en) * 2017-06-29 2017-09-08 深圳市劳沃智能科技有限公司 Communication means based on the Internet of things system for simplifying Internet of Things communication protocol
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
US20190392065A1 (en) * 2018-06-22 2019-12-26 Paypal, Inc. Systems and methods for providing flexible data access
CN111783916A (en) * 2020-07-29 2020-10-16 上海英杰制模有限公司 SONY product bar code scanning management system

Patent Citations (10)

* 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
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
CN107147743A (en) * 2017-06-29 2017-09-08 深圳市劳沃智能科技有限公司 Communication means based on the Internet of things system for simplifying Internet of Things communication protocol
CN107664989A (en) * 2017-09-29 2018-02-06 郑州云海信息技术有限公司 One kind customizes information binding and collection method automatically
US20190392065A1 (en) * 2018-06-22 2019-12-26 Paypal, Inc. Systems and methods for providing flexible data access
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
王中宝: "移动环境下企业库存管理系统设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 *
管家婆物联网: "快销品行业中如何实现序列号出入库", 《搜狐网》 *

Cited By (3)

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

Also Published As

Publication number Publication date
CN113127486B (en) 2023-03-14

Similar Documents

Publication Publication Date Title
CN113127486B (en) Information collection and storage method, device, equipment and storage medium
CN108509344B (en) Daily cutting batch test method, equipment and readable storage medium
CN112463580A (en) Test system and method based on virtualization device
CN109426611A (en) A kind of method for testing software and device
CN111782117A (en) Interface display method and device, storage medium and electronic device
CN115408228A (en) Automatic testing method, device and system for touch screen equipment
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
CN114218072A (en) Test script generation method and device, storage medium and computer equipment
CN111966575B (en) Graphic automatic test method for aviation onboard display software
CN113127280A (en) API interface automatic input method and system
CN117493188A (en) Interface testing method and device, electronic equipment and storage medium
CN110825617A (en) Method and device for simulating communication interaction between devices
CN115963379A (en) Automatic test method, device, equipment and storage medium for circuit board
CN114328185A (en) Continuously integrated information aggregation system
CN110543424B (en) Test method and device for electronic tax platform
CN113094281B (en) Test method and device for hybrid App
CN113220596B (en) Application testing method, device, equipment, storage medium and program product
CN113903368B (en) Automatic test method, device and equipment for disc and storage medium
JPH09259006A (en) Program evaluation system
CN117367546A (en) Automatic execution system and method for intelligent gas meter test cases
CN117193251A (en) Diagnostic protocol automatic test method and system based on TCP/IP protocol
CN114443487A (en) Universal computing module resource allocation testing method
CN117592491A (en) Method capable of intelligently testing code scanning performance of code scanning terminal
CN115424688A (en) Automatic data entry system and automatic data entry method

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