A device file updating method based on data comparison and automatic processing

Abstract

The present invention relates to a device file updating method based on data comparison and automatic processing, including: S1, creating a new device file project, and importing the device file ledger; S2, formatting the equipment number in a consistent manner; S3, matching the consistent device number with the device number in the scrapped device ledger; if they match, adding a scrapped device identifier; S4, matching the consistent device number with the device number in the on-account device ledger one by one; if the device number does not match in the scrapped device ledger and the on-account device ledger, marking the marked position as unknown; S5, counting the device status information corresponding to each file according to the equipment status, and generating ledgers of different equipment statuses. The method of the present invention can realize the updating of the data of the equipment file ledger, which is more efficient and accurate than the manual verification method.

Description

Technical Field

[0001] The present invention relates to the field of data processing, and in particular to a device file updating method based on data comparison and automatic processing. Background Art

[0002] In the prior art, equipment archive management generally uses manual statistics and classification to record information. Taking shipbuilding enterprises as an example, it involves the use, update, and scrapping of a large number of equipment. Due to the untimely update of information and the untimely update of archive management information, some data in the equipment archive ledger deviates from the data in the equipment management ledger. Due to the accumulation of time, the amount of information data in the archive management is large. If the management information of the equipment is updated one by one by manual verification, the workload is large, and manual proofreading is prone to errors, which is not conducive to the management of equipment archive data. In particular, when it is necessary to migrate archives, the archive data of some scrapped equipment is no longer needed, and the archive data of these scrapped equipment needs to be eliminated. Due to the inaccuracy of the archive data, the archive data of the scrapped equipment cannot be eliminated. Summary of the invention

[0003] In order to realize the verification and data simplification of equipment archive ledger data, the present invention provides an equipment archive updating method based on data comparison and automatic processing, so as to realize the automatic updating and proofreading of accumulated equipment archive ledgers.

[0004] The technical objectives of the present invention are achieved through the following technical solutions:

[0005] A device file updating method based on data comparison and automatic processing, the method comprising:

[0006] S1. Create a new equipment file project, read the equipment file ledger that needs to be updated and import the data of the equipment file ledger into the new equipment file project;

[0007] S2. Perform format unification processing on the equipment number corresponding to each file number in the newly created equipment file project and generate the equipment number of each equipment;

[0008] S3. Read the scrapped equipment ledger and match the consistent equipment numbers with the equipment numbers in the scrapped equipment ledger one by one;

[0009] If the consistent equipment number matches the equipment number in the scrapped equipment ledger, a scrapped equipment identifier is added to the matching equipment number in the newly created equipment file item; if not, a vacant identifier is set for the unmatched equipment number in the newly created equipment file item;

[0010] S4. Read the equipment ledger in the account, and match the equipment numbers processed in a consistent manner with the equipment numbers in the equipment ledger in the account one by one;

[0011] If the consistent device number matches the device number in the on-account device ledger, and there is an empty identifier in the device number, the empty identifier is updated to the on-account device identifier;

[0012] If the consistent device number matches the device number in the on-account device ledger, and the device number has a scrapped device identifier, the scrapped device identifier is updated to the data to be confirmed identifier;

[0013] If the equipment number is not matched in the scrapped equipment ledger or in the on-account equipment ledger, the mark position is marked as unknown;

[0014] S5. Count the equipment status information corresponding to each file according to the equipment status, and generate ledgers of different equipment statuses according to the equipment status.

[0015] Furthermore, the file number of each file in the equipment file ledger includes at least one equipment number, and the file number format is "file position number-equipment type number-equipment number". When at least two equipment are included under the same file position number and equipment type number, the consecutive equipment numbers are connected by "~", and the non-consecutive equipment numbers are connected by "、";

[0016] When performing equipment number consistency processing, determine whether "," and / or "~" exist in the equipment number of the file number. If so, generate the equipment number of each device in the format of "equipment type number-equipment number".

[0017] Further, when determining whether "," and / or "~" exist in the device number of the file number, first determine whether "," exists, and then determine whether "~" exists;

[0018] When there is a "," the device type number is increased at the front of each device number after the first "," after the device type number;

[0019] When there is “~”, read the value a at the front end of “~” and the value b at the back end to generate “device type number - a”, “device type number - (a+1)”, “device type number - (a+2)”... “device type number - b”.

[0020] Furthermore, in step S3, when adding a scrapped equipment identifier to the matched equipment number, it also includes adding a scrapped supplementary information item, and saving the equipment information corresponding to the matched equipment number in the scrapped equipment ledger in the supplementary information item.

[0021] Furthermore, in step S4, an on-account supplementary information supplementary item is added to the device corresponding to the on-account device identifier, and the device information corresponding to the device number matched in the on-account device is saved in the on-account information supplementary item.

[0022] Furthermore, each file number in the equipment file ledger imported into the newly created equipment file project has a serial number, the equipment number of the uniformly processed number has the same serial number as the file number, and the scrapped information supplementary item and the in-account information supplementary item do not have a serial number;

[0023] The equipment status under each file number is counted according to the serial number, including the number of scrapped equipment, the number of equipment on account, and the number of unknown equipment.

[0024] Furthermore, when there are at least two identical serial numbers, the number of scrapped devices, on-account devices, and unknown devices under the same serial number are counted cumulatively.

[0025] Compared with the prior art, the beneficial effect of the present invention is that the data of the equipment archive ledger can be updated through the method of the present invention, which is more efficient and accurate than the manual verification method; in addition, the method of the present invention can also be used to count the updated archive ledger data, and the archive ledger data can be decomposed into different ledgers according to different states, which is convenient for the management of equipment archives. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 It is a schematic diagram of the equipment file ledger page in an embodiment of the present invention.

[0027] Figure 2 It is a schematic diagram of the Equipment Document List table page for importing equipment archive ledger data in an embodiment of the present invention.

[0028] Figure 3 It is a schematic diagram of the Equipment Document List Expanded table page in an embodiment of the present invention.

[0029] Figure 4 It is a schematic diagram of the Equipment Document ListExpanded table page after matching with the scrapped equipment ledger in an embodiment of the present invention.

[0030] Figure 5 It is a schematic diagram of the Equipment Document ListExpanded table page after matching with the on-account equipment ledger in an embodiment of the present invention.

[0031] Figure 6 It is a schematic diagram of a device status statistics page in an embodiment of the present invention.

[0032] Figure 7 It is a schematic diagram of the scrapped equipment ledger page obtained by decomposition in an embodiment of the present invention.

[0033] Figure 8 It is a schematic diagram of the equipment ledger page obtained by decomposition in an embodiment of the present invention.

[0034] Fig. 9 It is a schematic diagram of the unknown equipment ledger page obtained by decomposition in an embodiment of the present invention. DETAILED DESCRIPTION

[0035] The technical solution of the present invention is further described below in conjunction with specific embodiments:

[0036] A device archive updating method based on data comparison and automatic processing, the process of the method is realized by an archive ledger statistical system, the archive ledger statistical system includes an archive ledger reading module, an archive ledger format processing module, a cross comparison module, a statistical module, and an archive ledger input module;

[0037] The ledger reading module is used to read the equipment file ledger that needs to be updated from the hard disk, and store the read equipment file ledger data in the memory of the file ledger statistics system.

[0038] The archive ledger format processing module is used to extract the equipment number from the data of the equipment archive ledger stored in the memory of the archive ledger statistics system, and after the equipment number is processed in the same format, the number is expanded and stored.

[0039] The cross comparison module is used to read the contents of the scrapped equipment ledger and the on-account equipment ledger, cross-match the equipment numbers with the equipment numbers in the scrapped equipment ledger and the on-account equipment ledger item by item, and save the matching results;

[0040] The statistics module is used to count the status information of each file stored after the cross comparison module, count the equipment's on-account status, scrapped status and unknown status, and store the statistical results;

[0041] The ledger output module is used to output equipment ledgers in different states according to the equipment states saved after comparison by the cross-comparison module.

[0042] More specifically, the archive ledger statistics system in this embodiment runs on a computer, the computer system is at least Windows XP, the framework requires .NET Framework 4.0, 512MB RAM, 100MB of free hard disk space, Intel Pentium III or equivalent processor, and a display card that supports a high-color display adapter with a resolution of 1024×768 and above; programming language: C#9.0, compilation environment: Microsoft Visual Studio 2019.

[0043] The method includes:

[0044] S1. Create a new device file project through the file reading module, read the device file ledger that needs to be updated and import the data of the device file ledger into the new device file project:

[0045] In this embodiment, the equipment file ledger is in Excel file format or database format and is displayed in the form of a table. The table of the equipment file ledger includes six elements: serial number, file number, equipment name, equipment model, manufacturer and unit information of the equipment, such as Figure 1 As shown;

[0046] In the Equipment Document List table of the newly created equipment document project, add three elements: equipment number, equipment original value, and marking position, and import the data of the equipment archive ledger into the newly created equipment document project, such as Figure 2 As shown;

[0047] The vacant position identifier, scrapped equipment identifier, on-account equipment identifier and data to be confirmed identifier are marked in the marking position. In this embodiment, the vacant position identifier is a space, the scrapped equipment identifier is "1", the on-account equipment identifier is "2", and the data to be confirmed identifier is "3".

[0048] S2. Perform format consistency processing on the equipment number corresponding to each file number in the newly created equipment file project through the file ledger format processing module and generate the equipment number of each equipment; when at least two equipment are included under the same file position number and equipment type number, the consecutive equipment numbers are connected by "~", and the non-consecutive equipment numbers are connected by "、";

[0049] The file number of each file in the equipment file ledger includes at least one equipment number. The file number format is "file location number-equipment type number-equipment number", such as Figure 3 As shown, if the file number of sequence number 1 is "6-362-443", 6 represents the file position number, 362 represents the equipment type number, and 443 represents the equipment number, the file number of sequence number 1 includes one equipment;

[0050] For example, the file number of serial number 6 is "6-362-1484~1488, 1491", where 6 represents the file location number, 362 represents the equipment type number, 1484~1488, 1491 represent the numbers of multiple devices, and 1484~1488 represents that the equipment numbers from 1484 to 1488 are continuous, that is, the file number of serial number 6 includes 6 devices.

[0051] When performing the consistency processing of the device number, in this embodiment, the consistency processing is mainly performed on the device number when the file number contains multiple devices. First, it is determined whether there is "," and then whether there is "~". Taking the file number of sequence number 6 as an example, the specific process of consistency processing is as follows:

[0052] First, determine whether there is a "," under the file number of sequence number 6. If so, add the device type number to the front of each device number after the first "," after the device type number, and "6-362-1484~1488, 1491" becomes "362-1484~1488" and "362-1491";

[0053] Then determine whether there is "~". If there is "~" in "362-1484~1488", read the value 1484 at the front end of "~" and the value 1488 at the back end, and "362-1484~1488" becomes "362-1484", "362-1485", "362-1486", "362-1487" and "362-1488". The final converted output numbers are: "362-1484", "362-1485", "362-1486", "362-1487", "362-1488" and "362-1491". Fill the numbers obtained by the consistent processing into the "Equipment Number" of the EquipmentDocument List table, and each equipment number forms a row, such as Figure 3 As shown, save the EquipmentDocument List table as Equipment Document List Expanded table.

[0054] S3. Read the scrapped equipment ledger through the ledger reading module, and match the consistent equipment numbers with the equipment numbers in the scrapped equipment ledger one by one through the cross comparison module;

[0055] like Figure 4 As shown, when matching, the equipment numbers are extracted one by one from the Equipment Document List Expanded table and matched with the equipment numbers in the scrapped equipment ledger, which is an Excel table or database:

[0056] Taking the number "362-443" as an example, if there is equipment with the number "362-443" in the scrapped equipment ledger, mark "1" in the mark position of the Equipment Document List Expanded table and add the scrap supplementary information item, and save the equipment information corresponding to the matching equipment number in the scrapped equipment ledger in the scrap supplementary information item. The scrap supplementary information item includes four elements: equipment name, equipment model, manufacturer and unit where the equipment is located; if there is no equipment with the number "362-443" in the scrapped equipment ledger, set a space in the mark position of the Equipment Document List Expanded table.

[0057] S4. After all equipment numbers are matched with the scrapped equipment ledger, the equipment ledger in the account is read through the ledger reading module. The equipment ledger in the account is an Excel table or database. The cross-comparison module is used to match the consistent equipment numbers with the equipment numbers in the equipment ledger in the account one by one, such as Figure 5 As shown;

[0058] Taking the number "362-615" as an example, after matching it with the scrapped equipment ledger, set a space in the marked position, and then match the number "365-615" with the on-account equipment ledger. If there is equipment with the number "362-615" in the on-account equipment ledger, change the space in the marked position to "2", add the on-account supplementary information supplementary item, and save the equipment information corresponding to the equipment number matched in the on-account equipment to the on-account information supplementary item. The on-account information supplementary item includes five elements: equipment name, equipment model, manufacturer, equipment unit and equipment original value;

[0059] If the equipment numbered "362-615" is matched in the scrapped equipment ledger, the marking position is set to "1". If the equipment numbered "362-615" is matched in the on-account equipment ledger, the marking position of the equipment numbered "362-615" is changed from "1" to "3";

[0060] If the equipment number is not matched in the scrapped equipment ledger or in the on-equipment ledger, the marking position will be marked as unknown. For example, the equipment numbered "362-1004" will be marked as "unknown" in the marking position.

[0061] Each file number has a serial number, that is, a serial number. The equipment number of the consistent processing number has the same serial number as the file number. No serial number is set for the scrap information supplementary items and the account information supplementary items.

[0062] For the equipment with the marking position "3", the equipment status can be determined manually, or the equipment with the marking position "3" can be automatically determined as scrapped equipment and the marking position can be changed to "1". Figure 6 The device status of device serial number "362-1491" in the table.

[0063] S5. The statistical module counts the device status information corresponding to each file according to the device status, and the ledger output module generates ledgers of different device statuses according to the device status.

[0064] The equipment status of each file number is counted according to the serial number, including the number of scrapped equipment, the number of on-account equipment and the number of unknown equipment. Taking the file number with serial number 4 as an example, there are 0 scrapped equipment, 0 on-account equipment and 1 unknown equipment.

[0065] When there are at least two identical serial numbers, the number of scrapped devices, on-account devices, and unknown devices under the same serial number are counted separately. Taking the file number with serial number 5 as an example, there are 7 devices, 2 scrapped devices, 5 on-account devices, and 0 unknown devices.

[0066] Specifically, when counting, only table rows with serial numbers are counted; the serial number of the row where the currently counted serial number is located is i, the serial number of the row where the previous serial number is located is j, and when the currently counted serial number is the first row, j=0;

[0067] If i≠j, the status of the row where serial number i is located is counted; if i=j, the statistical result of the row where the current serial number i is located is superimposed with the statistical result of the row where the previous serial number j is located, and a "status statistics" column is generated and the statistical results are displayed in the order of "on account / scrapped / unknown", such as Figure 6 shown.

[0068] Specifically, the statistics are started from the row where the file with serial number 1 is located. The row where serial number 1 is located is the first row, then i=1, j=0, i≠j, and the statistical result of the row where serial number 1 is located is 0 / 1 / 0;

[0069] Move to the next column where the sequence number is, i=2, j=1, at this time i≠j, the statistical result of the row where the sequence number is 2 is 1 / 0 / 0; the statistics of the rows where the sequence numbers are located are performed one by one in this order;

[0070] When the 5th row is counted, that is, i=5, j=4, at this time i≠j, the statistical result of the 5th row is 1 / 0 / 0; when the 6th row is counted, i=5, j=5, i=j, the statistical result of the 6th row is superimposed on the statistical result of the 5th row, that is, the statistical results of the 6th row are no longer counted separately, and the statistical result of the 6th row is superimposed on the statistical result of the 5th row; according to this process, the statistical results of the 7th row, the 8th row, the 9th row, the 10th row, and the 11th row are all superimposed on the statistical result of the 5th row;

[0071] In the 12th row, i=6, j=5, at this time i≠j, the statistical result of the 12th row is no longer superimposed on the statistical result of the 5th row, and is calculated separately. The statistical result of the 12th row with sequence number 6 is 1 / 0 / 0. When there are multiple rows with sequence number 6 in the 12th row, the results are superimposed according to the statistical method of sequence number 5.

[0072] After the statistics are completed, the scrapped equipment, on-account equipment and unknown equipment are decomposed according to their status to generate scrapped equipment ledger, on-account equipment ledger and unknown equipment ledger, such as Figure 7-Figure 9 shown.

[0073] This embodiment is only a further explanation of the present invention, not a limitation of the present invention. After reading this specification, those skilled in the art may make non-creative modifications to this embodiment as needed, but as long as it is within the scope of the claims of the present invention, it will be protected by the patent law.

Claims

1. A device file updating method based on data comparison and automatic processing, characterized in that: The method includes: S1. Create a new equipment file project, read the equipment file ledger that needs to be updated and import the data of the equipment file ledger into the new equipment file project; S2. Perform format unification processing on the equipment number corresponding to each file number in the newly created equipment file project and generate the equipment number of each equipment; S3. Read the scrapped equipment ledger and match the consistent equipment numbers with the equipment numbers in the scrapped equipment ledger one by one; If the consistent equipment number matches the equipment number in the scrapped equipment ledger, a scrapped equipment identifier is added to the matching equipment number in the newly created equipment file item; if not, a vacant identifier is set for the unmatched equipment number in the newly created equipment file item; S4. Read the equipment ledger in the account, and match the equipment numbers processed in a consistent manner with the equipment numbers in the equipment ledger in the account one by one; If the consistent device number matches the device number in the on-account device ledger, and there is an empty identifier in the device number, the empty identifier is updated to the on-account device identifier; If the consistent device number matches the device number in the on-account device ledger, and the device number has a scrapped device identifier, the scrapped device identifier is updated to the data to be confirmed identifier; If the equipment number is not matched in the scrapped equipment ledger or in the on-account equipment ledger, the mark position is marked as unknown; S5. Count the equipment status information corresponding to each file according to the equipment status, and generate ledgers of different equipment statuses according to the equipment status.

2. The device file updating method based on data comparison and automatic processing according to claim 1 is characterized in that: The file number of each file in the equipment file ledger includes at least one equipment number, and the file number format is "file position number-equipment type number-equipment number". When at least two equipment are included under the same file position number and equipment type number, the consecutive equipment numbers are connected by "~", and the non-consecutive equipment numbers are connected by "、"; When performing equipment number consistency processing, determine whether "," and / or "~" exist in the equipment number of the file number. If so, generate the equipment number of each device in the format of "equipment type number-equipment number".

3. The device file updating method based on data comparison and automatic processing according to claim 2 is characterized in that: When judging whether "," and / or "~" exist in the equipment number of the file number, first judge whether "," exists, and then judge whether "~" exists; When "、" exists, the device type number is increased at the front of each device number after the first "、" following the device type number; When "~" exists, read the value a at the front end of "~" and the value b at the back end to generate "device type number - a", "device type number - (a+1)", "device type number - (a+2)"..."device type number - b".

4. The device file updating method based on data comparison and automatic processing according to claim 1 is characterized in that: In the step S3, when adding a scrapped equipment identifier to the matched equipment number, it also includes adding a scrapped supplementary information item, and saving the equipment information corresponding to the matched equipment number in the scrapped equipment ledger in the supplementary information item.

5. The device file updating method based on data comparison and automatic processing according to claim 4 is characterized in that: In the step S4, an on-account supplementary information supplement item is added to the device corresponding to the on-account device identifier, and the device information corresponding to the device number matched in the on-account device is saved in the on-account information supplement item.

6. The device file updating method based on data comparison and automatic processing according to claim 5 is characterized in that: Each file number in the equipment file ledger imported into the newly created equipment file project has a serial number. The equipment number with the consistent number has the same serial number as the file number. The scrap information supplementary items and the in-account information supplementary items do not have serial numbers. The equipment status under each file number is counted according to the serial number, including the number of scrapped equipment, the number of equipment on account, and the number of unknown equipment.

7. The device file updating method based on data comparison and automatic processing according to claim 6 is characterized in that: When there are at least two identical serial numbers, the number of scrapped devices, on-account devices, and unknown devices under the same serial number are counted separately.

Images