Method, equipment, storage medium and device for constructing stamping parts atlas

Abstract

The present invention belongs to the field of vehicle technology and discloses a stamping part atlas construction method, equipment, storage medium and device. The present invention obtains a first file version number corresponding to a target part number in a local file list based on Python; compares the first file version number with a second file version number corresponding to the target part number in a preset database, determines whether to update the part parameters based on the comparison result, and updates the preset database based on the updated part parameters; constructs a stamping part atlas based on the updated part parameters in the preset database. Compared with the existing method for managing automobile part inspection tables, which has limitations and cannot effectively ensure that the version of the inspection table is updated in time, thereby affecting the automobile production cycle, the present invention realizes version control and content viewing restriction of the inspection table through a cloud database and special tools, effectively ensuring that the version of the inspection table is updated in time, shortening the automobile production cycle.

Description

Technical Field

[0001] The present invention relates to the field of vehicle technology, and in particular to a method, equipment, storage medium and device for constructing a stamping part atlas. Background Art

[0002] With the development of internet technology, remote control and data management are becoming increasingly important. Part inspection and quality control are crucial in the stamping parts production process. Therefore, an effective method is needed to ensure timely updates of test sheets and prevent the continued use of expired sheets. However, existing methods for managing automotive parts test sheets have limitations and cannot effectively ensure timely updates, thus impacting vehicle production cycles. Summary of the Invention

[0003] The main purpose of the present invention is to provide a method, equipment, storage medium and device for constructing a stamping parts atlas, aiming to solve the technical problem that the existing technology for managing automobile parts inspection tables has limitations and cannot effectively ensure that the version of the inspection table is updated in a timely manner, thereby affecting the automobile production cycle.

[0004] To achieve the above object, the present invention provides a method for constructing a stamping parts atlas, which comprises the following steps:

[0005] Obtain the first file version number corresponding to the target part number in the local file list based on Python;

[0006] Comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters;

[0007] A stamping parts atlas is constructed based on the updated part parameters in the preset database.

[0008] Optionally, before the step of obtaining the first file version number corresponding to the target part number in the local file list based on Python, the method further includes:

[0009] Based on the Python HTTP request library, the first database file of each parts inspection table version number is obtained from the cloud direct link download record;

[0010] Use Python's os module to detect whether a local database file exists locally;

[0011] If yes, then replace the local database file with the first database file;

[0012] If not, download the first database file to the local computer.

[0013] Optionally, the step of obtaining the first file version number corresponding to the target part number in the local file list based on Python includes:

[0014] Obtaining a local file list from the local database file based on a global variable method stored in a built-in standard library of Python;

[0015] Perform regular expression matching on the file names corresponding to the local file list based on the Python re module to obtain matching results;

[0016] Determine the first file version number corresponding to the target part number in the local file list according to the matching result.

[0017] Optionally, before the steps of comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters, the steps further include:

[0018] Open the stamping parts inspection table based on Python's openpyxl module and query the target part number;

[0019] According to the Python sqlite3 module, the preset database is connected to query the second file version number corresponding to the target part number.

[0020] Optionally, the step of comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update part parameters based on the comparison result, and updating the preset database based on the updated part parameters includes:

[0021] Compare the first file version number with the second file version number to obtain a comparison result;

[0022] Determine whether to update the part parameters corresponding to the target part number according to the comparison result, and obtain a determination result;

[0023] The part parameters are updated according to the judgment result, and the preset database is updated according to the updated part parameters.

[0024] Optionally, the part parameters include an effective date and a file version number; and the step of constructing a stamping part atlas based on the updated part parameters in the preset database includes:

[0025] Transforming the original atlas parameters based on the conditional format corresponding to EXCEL and the updated effective date and file version number in the preset database to obtain transformed atlas parameters;

[0026] A stamping part atlas is constructed according to the transformed atlas parameters and the updated effective date and file version number.

[0027] Optionally, the atlas parameters include an atlas background color and a font color, and the step of constructing a stamping part atlas according to the transformed atlas parameters and the updated effective date and file version number includes:

[0028] A stamping parts atlas is constructed based on the transformed atlas background color and font color, the updated effective date and file version number.

[0029] In addition, to achieve the above-mentioned purpose, the present invention also proposes a stamping part atlas construction device, which includes a memory, a processor, and a stamping part atlas construction program stored on the memory and runnable on the processor, and the stamping part atlas construction program is configured to implement the steps of stamping part atlas construction as described above.

[0030] In addition, to achieve the above-mentioned purpose, the present invention also proposes a storage medium, on which a stamping part atlas construction program is stored. When the stamping part atlas construction program is executed by a processor, the steps of the stamping part atlas construction method described above are implemented.

[0031] In addition, to achieve the above-mentioned purpose, the present invention also proposes a stamping parts atlas construction device, the stamping parts atlas construction device comprising:

[0032] An information acquisition module, used to obtain the first file version number corresponding to the target part number in the local file list based on Python;

[0033] a parameter updating module, configured to compare the first file version number with a second file version number corresponding to the target part number in a preset database, determine whether to update the part parameters based on the comparison result, and update the preset database based on the updated part parameters;

[0034] The atlas construction module is used to construct a stamping part atlas based on the updated part parameters in the preset database.

[0035] The present invention obtains the first file version number corresponding to the target part number in the local file list based on Python; compares the first file version number with the second file version number corresponding to the target part number in the preset database, determines whether to update the part parameters based on the comparison result, and updates the preset database according to the updated part parameters; constructs a stamping part atlas based on the updated part parameters in the preset database. Compared with the existing method for managing automobile parts inspection tables, which has limitations and cannot effectively ensure that the version of the inspection table is updated in time, thereby affecting the automobile production cycle, the present invention realizes version control and content viewing restriction of the inspection table through cloud databases and special tools, effectively ensuring that the version of the inspection table is updated in time and shortening the automobile production cycle. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 It is a structural diagram of a stamping parts atlas building device in a hardware operating environment involved in an embodiment of the present invention;

[0037] Figure 2 This is a flow chart of the first embodiment of the method for constructing a stamping parts atlas of the present invention;

[0038] Figure 3 A schematic diagram of the system architecture of the first embodiment of the method for constructing a stamping part atlas of the present invention;

[0039] Figure 4 This is a schematic diagram of the operation flow of the first embodiment of the method for constructing a stamping part atlas of the present invention;

[0040] Figure 5 This is a flow chart of a second embodiment of the method for constructing a stamping parts atlas according to the present invention;

[0041] Figure 6 This is a structural block diagram of the first embodiment of the stamping parts atlas construction device of the present invention.

[0042] The purpose, features and advantages of the present invention will be further described with reference to the accompanying drawings and in conjunction with the embodiments. DETAILED DESCRIPTION

[0043] It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0044] Reference Figure 1 , Figure 1 A schematic diagram of the device structure is provided for constructing a stamping parts atlas for the hardware operating environment involved in the embodiment of the present invention.

[0045] like Figure 1As shown, the stamping part atlas construction device may include: a processor 1001, such as a central processing unit (CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), and optionally the user interface 1003 may also include a standard wired interface and a wireless interface. The wired interface of the user interface 1003 may be a USB interface in the present invention. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a wireless fidelity (Wi-Fi) interface). The memory 1005 may be a high-speed random access memory (RAM) or a stable memory (NVM), such as a disk memory. The memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0046] Those skilled in the art will understand that Figure 1 The structure shown in does not constitute a limitation on the stamping part atlas building device, and may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently.

[0047] like Figure 1 As shown, the memory 1005 identified as a computer storage medium may include an operating system, a network communication module, a user interface module, and a stamping part atlas building program.

[0048] exist Figure 1 In the stamping part atlas construction device shown, the network interface 1004 is mainly used to connect to the background server and communicate data with the background server; the user interface 1003 is mainly used to connect to the user device; the stamping part atlas construction device calls the stamping part atlas construction program stored in the memory 1005 through the processor 1001, and executes the stamping part atlas construction method provided by the embodiment of the present invention.

[0049] Based on the above hardware structure, an embodiment of the stamping parts atlas construction method of the present invention is proposed.

[0050] Reference Figure 2 , Figure 2 This is a flow chart of the first embodiment of the method for constructing a stamping part atlas of the present invention, and proposes the first embodiment of the method for constructing a stamping part atlas of the present invention.

[0051] In this embodiment, the method for constructing a stamping parts atlas includes the following steps:

[0052] Step S10: Obtain the first file version number corresponding to the target part number in the local file list based on Python.

[0053] It should be noted that the execution subject in this embodiment can be a device including a remote management system for stamping parts inspection tables. Figure 3 As shown in the schematic diagram of the system architecture, the remote management system for stamping part inspection tables can include a file management module, a database management module, an inspection table management module, a local database, a cloud database, and other components. The remote management system for stamping part inspection tables includes a stamping part atlas construction function. The device can be a computer, a vehicle-mounted computer, a tablet, a mobile phone, or a notebook. Other devices that can achieve the same or similar functions are also possible, and this embodiment does not limit this. In this embodiment and the following embodiments, a computer is used as an example to illustrate the stamping part atlas construction method of the present invention.

[0054] It should be understood that the local file list refers to a file list consisting of inspection tables corresponding to automobile parts stored in the local database. The file list contains part numbers, inspection table versions, and validity dates corresponding to various part types. In this solution, the inspection table of stamping parts is updated, so the target part number refers to the part number corresponding to the target stamping part, and the first file version number refers to the inspection table version number corresponding to the part number corresponding to the target stamping part. For example: the part inspection table version number corresponding to part X is V1.0.

[0055] In the specific implementation, this solution uses Python tools to complete the version update and data update of the parts inspection table, among which the local file list can be updated by using Python tools to complete the database update.

[0056] Furthermore, in order to illustrate how to complete the file update in the database with the help of Python tools, before step S10, it also includes: using the Python-based HTTP request library to obtain the first database file with the version number of each part inspection table from the cloud direct link download record; using the Python-based os module to detect whether there is a local database file locally; if so, replacing the local database file with the first database file; if not, downloading the first database file to the local.

[0057] It should be noted that the version database is updated based on Python, wherein, by using the get method of Python's request module, the get method of the request module is based on Python's HTTP request library to obtain the first database file corresponding to the part inspection table version number corresponding to each stamping part from the cloud database, and the first database file contains data such as the part inspection table version number, part number and part validity date.

[0058] It is understood that Python's os module can refer to a module in the Python standard library for accessing operating system functions. Cross-platform access can be achieved by using the interfaces provided in the os module. The os module can represent the operating system where the program is running and is primarily used to obtain relevant information about the operating system where the program is running. The os module provides functional interface functions for most operating systems. Once the os module is imported, it automatically adapts to different operating systems and performs corresponding operations based on different platforms. It is often used for file and directory detection and identification in Python programming. Therefore, in this solution, when detecting and identifying files in the database, it is necessary to call the os module.

[0059] In the specific implementation, the version database is updated based on Python, wherein the get method of the Python request module is used to obtain the database file last.db of the version number of each part inspection table from the cloud direct link download record, and the Python os module is used to check whether there is a file last.db locally. If so, the local database file is replaced with the first database file. If not, the first database file is directly downloaded to the local.

[0060] Step S20: comparing the first file version number with the second file version number corresponding to the target part number in the preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters.

[0061] It should be noted that the preset database refers to a pre-set cloud database, which stores the latest version of the file. Therefore, by comparing the first file version number with the second file version number corresponding to the target part number in the preset database, it can be determined whether the part parameters need to be updated, so as to update the preset database according to the updated part parameters.

[0062] Step S30: Constructing a stamping part atlas based on the updated part parameters in the preset database.

[0063] It should be noted that the parts atlas can be a map constructed based on a graph neural network, which contains the correspondence between part numbers and parts inspection table versions, and the map can be represented in a tabular form.

[0064] In the specific implementation, a stamping parts atlas is constructed by presetting the updated part parameters in the database so that users can intuitively determine the latest parts inspection table corresponding to each part.

[0065] Furthermore, the part parameters include an effective date and a file version number; the step S30 also includes: transforming the original atlas parameters based on the conditional format corresponding to EXCEL and the updated effective date and file version number in the preset database to obtain transformed atlas parameters; constructing a stamping part atlas based on the transformed atlas parameters and the updated effective date and file version number.

[0066] It should be noted that in order to make the detection table more intuitive, the updated data can be converted through the corresponding conditional format of EXCEL and a graph can be generated for display. Among them, the corresponding conditional format of EXCEL can be to color-mark the expired data in combination with the effective date. For example: the data in the expired state with the same cell background color and font color is changed from invisible to visible, and the cell background color and font color are inverted, thereby obtaining the graph parameters.

[0067] It is understandable that the stamping part atlas is constructed by using the transformed atlas parameters and the part parameters corresponding to the target part.

[0068] Furthermore, the atlas parameters include atlas background color and font color, and the step of constructing a stamping part atlas based on the transformed atlas parameters and the updated effective date and file version number includes: constructing a stamping part atlas based on the transformed atlas background color and font color, the updated effective date and file version number.

[0069] It should be noted that, in order to further illustrate the operation process of this solution, you can refer to Figure 4 The operation process diagram shown in the figure constructs a stamping part atlas by transforming the atlas background color and font color, the updated effective date and file version number, which can effectively realize the remote version control and content viewing restriction of the stamping part inspection table, enhance the collaborative working ability with external suppliers during the stamping die development and factory debugging, and improve production efficiency and quality control level.

[0070] This embodiment obtains the first file version number corresponding to the target part number in the local file list based on Python; compares the first file version number with the second file version number corresponding to the target part number in the preset database, determines whether to update the part parameters based on the comparison result, and updates the preset database based on the updated part parameters; constructs a stamping part atlas based on the updated part parameters in the preset database. Compared with the existing method of managing automobile parts inspection tables, which has limitations and cannot effectively ensure that the version of the inspection table is updated in time, thereby affecting the automobile production cycle, this embodiment realizes version control and content viewing restriction of the inspection table through cloud databases and special tools, effectively ensuring that the version of the inspection table is updated in time and shortening the automobile production cycle.

[0071] Reference Figure 5 , Figure 5 This is a flow chart of the second embodiment of the method for constructing a stamping parts atlas of the present invention, based on the above Figure 2 The first embodiment shown provides a second embodiment of the stamping parts atlas construction method of the present invention.

[0072] In this embodiment, step S10 further includes:

[0073] Step S101: obtaining a local file list from the local database file based on a global variable method stored in a built-in standard library of Python.

[0074] It should be noted that when obtaining the local file list, the local file list can be obtained from the local database file by using the global variable method stored in Python's built-in standard library. The global variable method stored in Python's built-in standard library can refer to the global method in the pathlib module in the Python tool. The Python pathlib module can be a standard library newly added in Python 3.4 for managing path and file operations. Unlike the os module, it provides a more object-oriented interface, allowing file operations to be managed in a more intuitive manner in the code.

[0075] It should be understood that the "global" keyword in Python is a global variable keyword. Variables are divided into local and global. Local variables, also known as internal variables, are usually local variables. Variables created by an object or function are only referenced internally and cannot be referenced by other objects or functions. Global variables, on the other hand, can be created by an object or function or anywhere else in the program. Global variables can be referenced by all objects or functions in the program. The global keyword is used to make a local variable global.

[0076] In the specific implementation, the global method in Python's pathlib module can be used to obtain all files in each folder in the file list where the "stamping parts inspection table" is stored, and the file name of each file can be obtained.

[0077] Step S102: Perform regular expression matching on the file names corresponding to the local file list based on the Python re module to obtain a matching result.

[0078] It should be noted that the Python-based re module can refer to a regular expression operation module, in which the re module is used to match and search strings, and regular expressions are used to find patterns in text. Regular expressions can be used to match specific characters, words, sentences or paragraphs. The re module provides some functions that can be used to process regular expressions. The most commonly used functions are re.match() and re.search(). These two functions have similar functions and are both used to find patterns in strings. However, re.match() will only match the beginning of the string, while re.search() will match the entire string. In addition, the re.findall() function can be used to find all matching patterns in a string and return a list.

[0079] It is understood that in this solution, the re.findall() function is called to perform regular expression matching on the file names corresponding to the local file list to obtain a matching result, which may include a part number and a version number.

[0080] In the specific implementation, you can use the findall method of Python's re module to perform regular matching on the file name. The matching basis is: (V\d.\d(.\d){0,1}). For example, the file name is: "M6-5401208-Right Door Ring B Pillar Lower Reinforcement Plate-Detection Process Card-V1.0.xlsm". The matching rule can be V+number+any character+number+0 or 1 time (any character+number), so as to obtain the version number, such as: V.1.0. And you can use the findall method of Python's re module to perform regular matching on the file name. The matching basis is: M6-\d{7}. For example, the file name is: "M6-5401208-Right Door Ring B Pillar Lower Reinforcement Plate-Detection Process Card-V1.0.xlsm". The matching rule can be M6+7 numbers, so as to obtain the part number: such as: M6-5401208, where M6 is the project name and changes with the project.

[0081] Step S103: Determine the first file version number corresponding to the target part number in the local file list according to the matching result.

[0082] It should be noted that the first file version number corresponding to the target part number in the local file list is determined by using the version number and part number obtained in the matching result.

[0083] In this embodiment, before step S20, the method further includes: opening a stamping part detection table based on the Python openpyxl module and querying the target part number, and querying the second file version number corresponding to the target part number by connecting to a preset database using the Python sqlite3 module.

[0084] It should be noted that in order to determine whether the version needs to be updated and whether the part parameters need to be updated, it is also necessary to use Python's openpyxl module to open the stamping part inspection table, query the target part number, and combine Python's sqlite3 module to connect to the preset database to query the second file version number corresponding to the target part number, so as to facilitate the later comparison of the second file version number with the first file version number to determine whether the part parameters need to be updated.

[0085] It is understandable that the openpyxl module of Python refers to the file processing module in the Python tool, and the sqlite3 module refers to the database module in the Python tool.

[0086] In the specific implementation, the load_workbook method of Python's openpyxl module is used to open the stamping parts inspection table, read the cell content of the cover page target (such as: E16) of the stamping parts inspection table, obtain the part number, use the connect method in Python's sqlite3 module to connect to the database, use the cursor method to create a cursor, use the execute method in Python's sqlite3 module to execute the query statement, and query the effective date and version number according to the part number.

[0087] In this embodiment, step S20 further includes:

[0088] Step S201: Compare the first file version number with the second file version number to obtain a comparison result.

[0089] It should be noted that by comparing the obtained second file version number with the first file version number in the local list, a comparison result is obtained, and the comparison result includes two results: consistent comparison or inconsistent comparison. The inconsistent comparison also includes that the second file version number is less than the first file version number or the second file version number is greater than the first file version number.

[0090] Step S202: Determine whether to update the part parameters corresponding to the target part number based on the comparison result to obtain a determination result.

[0091] It should be noted that the determination results include two results: update and no update.

[0092] In the specific implementation, if the second file version number is less than or equal to the first file version number, no update is made and it is marked as the old version of the stamping parts inspection table. If the second file version number is greater than the first file version number, it is determined to update the part parameters corresponding to the target part number.

[0093] Step S203: updating the part parameters according to the judgment result, and updating the preset database according to the updated part parameters.

[0094] In the specific implementation, if the second file version number is greater than the first file version number, it is determined to update the part parameters corresponding to the target part number according to the part parameters corresponding to the second file version number, and the effective date in the stamping part inspection table can be read by using the worksheet.range.value method in the openpyxl module of Python and updated to the effective date corresponding to the second file version number, and the updated part parameters are updated to the preset database. For example: According to the compilation requirements, the compilation of the stamping parts inspection table is completed, and a version number is assigned to each file, such as: "M6-5401208-Right Door Ring B-Pillar Lower Reinforcement Plate-Inspection Process Card-V1.0.xlsm", the version number is: V1.0; in the Excel file of the stamping parts inspection table, use the conditional formatting rules to set the part of the content that needs to be restricted to be unavailable for viewing after the expiration (for example, set the font color and background color to the same), define this restricted date as the "effective date", fill in the inspection table cover, and use a password to protect the cell so that the user cannot modify it; create a sqlite3 database, use the part number as the index, define the latest version and effective date of the parts inspection table for each part, synchronize the db file to the cloud disk, and generate a download link; write an update tool in a programming language, and the user synchronizes the cloud database through a dedicated tool to retrieve the version number of the inspection table. If the retrieved version number is the latest, the dedicated tool will send a command to modify the effective date in the Excel file, thereby changing the conditional formatting rule so that the unviewable content can be viewed. If the retrieved version number is not the latest, the dedicated tool will prompt the user to update to the latest version, and the old file will be frozen and no longer updated. Through the above method, remote version control and content viewing restrictions of the stamping part inspection table are achieved.

[0095] This embodiment obtains a local file list from the local database file through a global variable method stored in a built-in standard library based on Python; performs regular matching on the file names corresponding to the local file list based on the re module of Python to obtain a matching result; determines the first file version number corresponding to the target part number in the local file list according to the matching result; compares the first file version number with the second file version number to obtain a comparison result; determines whether to update the part parameters corresponding to the target part number according to the comparison result to obtain a judgment result; updates the part parameters according to the judgment result, and updates the preset database according to the updated part parameters; constructs a stamping part atlas based on the updated part parameters in the preset database. Compared with the existing method for managing automobile parts inspection tables, which has limitations and cannot effectively ensure that the version of the inspection table is updated in time, thereby affecting the automobile production cycle, this embodiment realizes version control and content viewing restriction of the inspection table through a cloud database and special tools, effectively ensuring that the version of the inspection table is updated in time and shortening the automobile production cycle.

[0096] In addition, to achieve the above-mentioned purpose, the present invention also proposes a storage medium, on which a stamping part atlas construction program is stored. When the stamping part atlas construction program is executed by a processor, the steps of the stamping part atlas construction method described above are implemented.

[0097] Reference Figure 6 , Figure 6 This is a structural block diagram of the first embodiment of the stamping parts atlas construction device of the present invention.

[0098] like Figure 6 As shown, the stamping parts atlas construction device proposed in the embodiment of the present invention includes:

[0099] An information acquisition module 10 is used to obtain a first file version number corresponding to a target part number in a local file list based on Python;

[0100] a parameter updating module 20 for comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters;

[0101] The atlas construction module 30 is used to construct a stamping part atlas based on the updated part parameters in the preset database.

[0102] This embodiment obtains the first file version number corresponding to the target part number in the local file list based on Python; compares the first file version number with the second file version number corresponding to the target part number in the preset database, determines whether to update the part parameters based on the comparison result, and updates the preset database based on the updated part parameters; constructs a stamping part atlas based on the updated part parameters in the preset database. Compared with the existing method of managing automobile parts inspection tables, which has limitations and cannot effectively ensure that the version of the inspection table is updated in time, thereby affecting the automobile production cycle, this embodiment realizes version control and content viewing restriction of the inspection table through cloud databases and special tools, effectively ensuring that the version of the inspection table is updated in time and shortening the automobile production cycle.

[0103] Furthermore, the parameter update module 20 is also used to obtain the first database file of each part inspection table version number from the cloud direct link download record based on Python's HTTP request library; based on Python's os module, detect whether there is a local database file locally; if so, replace the local database file with the first database file; if not, download the first database file to the local.

[0104] Furthermore, the parameter update module 20 is also used to obtain a local file list from the local database file based on the global variable method stored in Python's built-in standard library; perform regular matching on the file names corresponding to the local file list based on Python's re module to obtain a matching result; and determine the first file version number corresponding to the target part number in the local file list based on the matching result.

[0105] Furthermore, the parameter update module 20 is also used to open the stamping part detection table based on Python's openpyxl module and query the target part number; and connect to the preset database according to Python's sqlite3 module to query the second file version number corresponding to the target part number.

[0106] Furthermore, the parameter update module 20 is also used to compare the first file version number with the second file version number to obtain a comparison result; determine whether to update the part parameters corresponding to the target part number based on the comparison result to obtain a judgment result; update the part parameters based on the judgment result, and update the preset database based on the updated part parameters.

[0107] Furthermore, the part parameters include an effective date and a file version number; the atlas construction module 30 is also used to transform the original atlas parameters based on the corresponding conditional format of EXCEL and the updated effective date and file version number in the preset database to obtain transformed atlas parameters; and construct a stamping part atlas based on the transformed atlas parameters and the updated effective date and file version number.

[0108] Furthermore, the atlas parameters include atlas background color and font color, and the atlas construction module 30 is further used to construct a stamping part atlas according to the transformed atlas background color and font color, the updated effective date and file version number.

[0109] It should be understood that the above is only an example and does not constitute any limitation to the technical solution of the present invention. In specific applications, those skilled in the art can make settings as needed, and the present invention does not impose any limitation on this.

[0110] It should be noted that the workflow described above is merely illustrative and does not limit the scope of protection of the present invention. In practical applications, technicians in this field can select part or all of it according to actual needs to achieve the purpose of the embodiment scheme, and no limitation is made here.

[0111] In addition, for technical details not fully described in this embodiment, reference can be made to the stamping parts atlas construction method provided in any embodiment of the present invention, and will not be repeated here.

[0112] It should be noted that, in this document, the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or system comprising a series of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or system. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of other identical elements in the process, method, article, or system comprising the element.

[0113] The serial numbers of the embodiments of the present invention are for descriptive purposes only and do not represent superiority or inferiority of the embodiments. In a unit claim that enumerates several means, several of these means may be embodied by the same item of hardware. The use of the terms first, second, and third, etc., does not denote any order; these terms should be interpreted as designations.

[0114] Through the description of the above embodiments, those skilled in the art can clearly understand that the above embodiment methods can be implemented by means of software plus the necessary general hardware platform, or of course by hardware, but in many cases the former is a better embodiment. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as a read-only memory image (ROM) / random access memory (RAM), a magnetic disk, or an optical disk), and includes a number of instructions for enabling a terminal device (which can be a mobile phone, a computer, a server, or a network device, etc.) to execute the methods described in each embodiment of the present invention.

[0115] The above are only preferred embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention description and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for constructing a stamping parts atlas, characterized in that: The stamping parts atlas construction method comprises the following steps: Obtaining the first file version number corresponding to the target part number in the local file list based on Python, where the first file version number refers to the inspection table version corresponding to the part number corresponding to the target stamping part; Comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters; Constructing a stamping parts atlas based on the updated part parameters in the preset database; The part parameters include an effective date and a file version number, and the atlas parameters include an atlas background color and a font color. The step of constructing a stamping part atlas based on the updated part parameters in the preset database includes: Transforming the original atlas parameters based on the conditional format corresponding to EXCEL and the updated effective date and file version number in the preset database to obtain transformed atlas parameters; A stamping parts atlas is constructed based on the transformed atlas background color and font color, the updated effective date and file version number.

2. The method for constructing a stamping parts atlas according to claim 1, wherein: Before the step of obtaining the first file version number corresponding to the target part number in the local file list based on Python, the method further includes: Based on the Python HTTP request library, the first database file of each parts inspection table version number is obtained from the cloud direct link download record; Use Python's os module to detect whether a local database file exists locally; If yes, then replace the local database file with the first database file; If not, download the first database file to the local computer.

3. The method for constructing a stamping parts atlas according to claim 2, wherein: The step of obtaining the first file version number corresponding to the target part number in the local file list based on Python includes: Obtaining a local file list from the local database file based on a global variable method stored in a built-in standard library of Python; Perform regular expression matching on the file names corresponding to the local file list based on the Python re module to obtain matching results; Determine the first file version number corresponding to the target part number in the local file list according to the matching result.

4. The method for constructing a stamping parts atlas according to claim 1, wherein: Before the steps of comparing the first file version number with the second file version number corresponding to the target part number in the preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters, the method further includes: Open the stamping parts inspection table based on Python's openpyxl module and query the target part number; According to the sqlite3 module of Python, a preset database is connected to query the second file version number corresponding to the target part number.

5. The stamping parts atlas construction method according to claim 4, characterized in that: The step of comparing the first file version number with a second file version number corresponding to the target part number in a preset database, determining whether to update the part parameters based on the comparison result, and updating the preset database based on the updated part parameters includes: Compare the first file version number with the second file version number to obtain a comparison result; Determine whether to update the part parameters corresponding to the target part number according to the comparison result, and obtain a determination result; The part parameters are updated according to the judgment result, and the preset database is updated according to the updated part parameters.

6. A stamping parts atlas construction device, characterized in that: The stamping part atlas construction device includes: a memory, a processor, and a stamping part atlas construction program stored in the memory and runnable on the processor. When the stamping part atlas construction program is executed by the processor, the stamping part atlas construction method according to any one of claims 1 to 5 is implemented.

7. A storage medium, characterized in that: The storage medium stores a stamping part atlas construction program, and when the stamping part atlas construction program is executed by the processor, the stamping part atlas construction method according to any one of claims 1 to 5 is implemented.

8. A stamping parts atlas construction device, characterized in that: The stamping parts atlas construction device comprises: An information acquisition module is used to obtain a first file version number corresponding to a target part number in a local file list based on Python, where the first file version number refers to a test table version corresponding to the part number corresponding to the target stamping part; a parameter updating module, configured to compare the first file version number with a second file version number corresponding to the target part number in a preset database, determine whether to update the part parameters based on the comparison result, and update the preset database based on the updated part parameters; A map construction module, used for constructing a stamping part map based on the updated part parameters in the preset database; The part parameters include the effective date and file version number, and the diagram parameters include the diagram background color and font color; The atlas construction module is also used to transform the original atlas parameters based on the corresponding conditional format of EXCEL and the updated effective date and file version number in the preset database to obtain the transformed atlas parameters; and construct the stamping part atlas according to the transformed atlas background color and font color, the updated effective date and file version number.

Images