Method, device and equipment for managing regulatory information of vehicle parts

Abstract

The application discloses a kind of management methods, devices and equipment of the regulation information of vehicle parts, belong to vehicle technical field.The method includes: based on the user account and user password of first user login information management system;Display the first Excel table corresponding to the information management system, including regulation button in the work column of the first Excel table;In response to the regulation button being triggered, display a plurality of management buttons of regulation information;In response to the target management button in the plurality of management buttons being triggered, display the management interface corresponding to the target management button, the management interface includes the input box corresponding to a plurality of management options;Based on the management interface, the regulation information of vehicle parts input in the input box corresponding to the plurality of management options is respectively obtained;The regulation information of vehicle parts is stored in Access database.The application improves the management efficiency of the regulation information of vehicle parts.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of vehicles, in particular to a management method, device and equipment of regulation information of vehicle parts. BACKGROUND

[0002] A vehicle is obtained by installing a plurality of parts, and vehicle parts need to comply with a series of regulations when manufacturing and selling to ensure their safety, performance and environmental protection; for example, vehicle parts need to comply with automobile product quality regulations, motor vehicle safety technical conditions, fuel economy standards, automobile emission standards, material safety regulations, etc. Therefore, during the design process of the vehicle, the regulation information of the vehicle parts needs to be managed to ensure that the vehicle parts meet the regulatory requirements. SUMMARY

[0003] The embodiments of the present application provide a management method, device and equipment of regulation information of vehicle parts, which can improve the management efficiency of the regulation information of vehicle parts. The technical solution is as follows:

[0004] In one aspect, a management method of regulation information of vehicle parts is provided, and the method comprises:

[0005] Logging into an information management system based on a user account and a user password of a first user, the first user being a user who creates or updates the regulation information of the vehicle parts;

[0006] Displaying a first Excel table corresponding to the information management system, and a regulation button is included in a work column of the first Excel table;

[0007] In response to the regulation button being triggered, displaying a plurality of management buttons of regulation information;

[0008] In response to a target management button in the plurality of management buttons being triggered, displaying a management interface corresponding to the target management button, and the management interface includes input boxes corresponding to a plurality of management options;

[0009] Based on the management interface, obtaining the regulation information of the vehicle parts input in the input boxes corresponding to the plurality of management options respectively;

[0010] Storing the regulation information of the vehicle parts into an Access database of a relational database management system.

[0011] In one possible implementation, the target management button is a creation button, and the management interface is a creation interface;

[0012] The display of the management interface corresponding to the target management button comprises:

[0013] display a creation interface corresponding to the creation button, the creation interface including an input box corresponding to the work number of the first user, an input box corresponding to the part number, an input box corresponding to the part name, an input box corresponding to the applicable vehicle model, an input box corresponding to the vehicle module to which the part is applied, an input box corresponding to the regulation part name, an input box corresponding to the responsible department of the part, and an input box corresponding to the responsible department of the part.

[0014] In another possible implementation, the target management button is an update button, and the management interface is an update interface.

[0015] The display of the management interface corresponding to the target management button includes:

[0016] display a first query interface, the first query interface including an input box corresponding to the work number and an input box corresponding to the part number.

[0017] obtain the input work number in the input box corresponding to the work number and the input part number in the input box corresponding to the part number.

[0018] Based on the input work number and the input part number, display an update interface corresponding to the update button, the update interface including regulation information of a vehicle part of a current node and a node input box of at least one other node, the regulation information of the vehicle part of the current node including the input work number, the input part number, a part name, an applicable vehicle model, a vehicle module to which the part is applied, a regulation part name, a responsible department of the part, and a responsible department of the part; the node input box of the other node is used to input regulation information of an updated vehicle part.

[0019] In another possible implementation, the update interface further includes a picture upload button; and the method further includes:

[0020] In response to the picture upload button being triggered, display a picture upload interface.

[0021] Based on the picture upload interface, obtain a target picture uploaded.

[0022] Store the target picture in a shared folder and generate a picture link of the target picture, the picture link being used to retrieve the target picture from the shared folder.

[0023] Store the picture link of the target picture in the Access database.

[0024] In another possible implementation, the method further includes:

[0025] logging into the information management system based on a user account and a user password of a second user, the second user being an administrator;

[0026] displaying a second query interface corresponding to the information management interface, the second query interface including input boxes corresponding to a plurality of query options;

[0027] obtaining input query information based on an input box corresponding to a target query option;

[0028] obtaining queried regulation information of vehicle parts from the Access database based on the input query information;

[0029] generating a second Excel table including the regulation information of the queried vehicle parts.

[0030] In another possible implementation, the method further includes:

[0031] determining a built-in Extensible Markup Language (XML) file of the first Excel table;

[0032] reprogramming the built-in XML file using an XML language, the reprogramming being used to add the regulation button in the first Excel table;

[0033] determining a VBA callback function, the VBA callback function being used to functionize a VBA source program corresponding to the regulation button;

[0034] binding the regulation button and the VBA callback function;

[0035] in response to the regulation button being triggered, displaying a plurality of management buttons of regulation information, including:

[0036] in response to the regulation button being triggered, obtaining a VBA callback function bound to the regulation button;

[0037] based on the callback function, displaying the plurality of management buttons of the regulation information.

[0038] In another aspect, a device for managing regulation information of vehicle parts is provided, and the device includes:

[0039] a logging module configured to log into an information management system based on a user account and a user password of a first user, the first user being a user who creates or updates regulation information of vehicle parts;

[0040] a first display module configured to display a first Excel table corresponding to the information management system, the first Excel table including a regulation button in a work column thereof;

[0041] a second display module, configured to display a plurality of management buttons of regulation information in response to the regulation button being triggered;

[0042] a third display module, configured to display a management interface corresponding to a target management button in the plurality of management buttons in response to the target management button being triggered, the management interface comprising input boxes corresponding to a plurality of management options;

[0043] a first acquisition module, configured to acquire regulation information of a vehicle part input in the input boxes corresponding to the plurality of management options based on the management interface;

[0044] a first storage module, configured to store the regulation information of the vehicle part into an Access database of a relational database management system.

[0045] In a possible implementation, the target management button is a creation button, and the management interface is a creation interface.

[0046] The third display module is configured to display the creation interface corresponding to the creation button, and the creation interface comprises an input box corresponding to a work number of the first user, an input box corresponding to a part number, an input box corresponding to a part name, an input box corresponding to a vehicle model, an input box corresponding to a vehicle module to which the part is applied, an input box corresponding to a regulation part name, an input box corresponding to a responsible department of the part, and an input box corresponding to a responsible department of the part.

[0047] In another possible implementation, the target management button is an update button, and the management interface is an update interface.

[0048] The third display module is configured to display a first query interface, the first query interface comprising an input box corresponding to a work number and an input box corresponding to a part number; acquire a work number input in the input box corresponding to the work number and a part number input in the input box corresponding to the part number; based on the input work number and the input part number, display an update interface corresponding to the update button, the update interface comprising regulation information of a vehicle part of a current node and node input boxes of at least one other node, the regulation information of the vehicle part of the current node comprising the input work number, the input part number, a part name, a vehicle model, a vehicle module to which the part is applied, a regulation part name, a responsible department of the part, and a responsible department of the part; and the node input boxes of the other nodes are used to input regulation information of an updated vehicle part.

[0049] In another possible implementation, the update interface further comprises a picture upload button; and the device further comprises:

[0050] A fourth display module is configured to display a picture uploading interface in response to the picture uploading button being triggered.

[0051] A second acquisition module is configured to acquire a target picture uploaded based on the picture uploading interface.

[0052] A second storage module is configured to store the target picture into a shared folder, and generate a picture link of the target picture, the picture link being used to call the target picture from the shared folder; and store the picture link of the target picture into the Access database.

[0053] In another possible implementation, the apparatus further includes:

[0054] The login module is further configured to log in the information management system based on a user account and a user password of a second user, the second user being an administrator.

[0055] A fifth display module is configured to display a second query interface corresponding to the information management interface, the second query interface including input boxes corresponding to a plurality of query options.

[0056] A third acquisition module is configured to acquire query information input based on an input box corresponding to a target query option.

[0057] A fourth acquisition module is configured to acquire regulation information of a vehicle part queried from the Access database based on the query information input.

[0058] A generation module is configured to generate a second Excel table, the second Excel table including the regulation information of the vehicle part queried.

[0059] In another possible implementation, the apparatus further includes:

[0060] A first determination module is configured to determine a built-in Extensible Markup Language (XML) file of the first Excel table.

[0061] A writing module is configured to re-write the built-in XML file using an XML language, the re-writing being used to add the regulation button in the first Excel table.

[0062] A second determination module is configured to determine a VBA callback function, the VBA callback function being used to functionize a VBA source program corresponding to the regulation button.

[0063] A binding module is configured to bind the regulation button with the VBA callback function.

[0064] The second display module is configured to, in response to the regulation button being triggered, acquire a VBA callback function bound to the regulation button, and display a plurality of management buttons of the regulation information based on the callback function.

[0065] In another aspect, a computer device is provided, which includes a processor and a memory having at least one program code stored therein, the at least one program code being loaded and executed by the processor to implement the above-mentioned method for managing regulation information of vehicle parts.

[0066] In another aspect, a computer readable storage medium is provided, which has at least one program code stored therein, the at least one program code being loaded and executed by a processor to implement the above-mentioned method for managing regulation information of vehicle parts.

[0067] In another aspect, a computer program product is provided, which stores at least one program code for being executed by a processor to implement the above-mentioned method for managing regulation information of vehicle parts.

[0068] In the embodiments of the present application, the first Excel table is secondarily developed by the information management system, and the operation function of the first user on the regulation information of the vehicle parts is visually packaged, so that the operation function of the first user on the regulation information of the vehicle parts is used as the function of the first Excel table itself for the user, the function operation is simple and conforms to the user habit, and thus the management efficiency of the regulation information of the vehicle parts is improved.

[0069] It should be understood that the foregoing general description and the following detailed description are only exemplary and are not limiting to the present disclosure. BRIEF DESCRIPTION OF DRAWINGS

[0070] Figure 1 is a schematic diagram of an implementation environment of a method for managing regulation information of vehicle parts according to an exemplary embodiment of the present application;

[0071] Figure 2 is a flowchart of a method for managing regulation information of vehicle parts according to an exemplary embodiment of the present application;

[0072] Figure 3 is a schematic diagram of an interface of an installation information management system according to an exemplary embodiment of the present application;

[0073] Figure 4 is a schematic diagram of a login interface according to an exemplary embodiment of the present application;

[0074] Figure 5is a schematic view of a first Excel workbench shown in an example embodiment of the present application;

[0075] Figure 6 is a flow chart of a method for managing regulation information of vehicle parts shown in an example embodiment of the present application;

[0076] Figure 7 is a schematic view of a creation interface shown in an example embodiment of the present application;

[0077] Figure 8 is a schematic view of displaying first prompt information shown in an example embodiment of the present application;

[0078] Figure 9 is a flow chart of a method for managing regulation information of vehicle parts shown in an example embodiment of the present application;

[0079] Figure 10 is a schematic view of a first query interface shown in an example embodiment of the present application;

[0080] Figure 11 is a schematic view of an update interface shown in an example embodiment of the present application;

[0081] Figure 12 is a flow chart of a method for managing regulation information of vehicle parts shown in an example embodiment of the present application;

[0082] Figure 13 is a schematic view of a picture uploading interface shown in an example embodiment of the present application;

[0083] Figure 14 is a flow chart of a method for managing regulation information of vehicle parts shown in an example embodiment of the present application;

[0084] Figure 15 is a schematic view of a second query interface shown in an example embodiment of the present application;

[0085] Figure 16 is a schematic view of displaying second prompt information shown in an example embodiment of the present application;

[0086] Figure 17 is a schematic view of displaying pictures shown in an example embodiment of the present application;

[0087] Figure 18 is a flow chart of a method for managing regulation information of vehicle parts shown in an example embodiment of the present application;

[0088] Figure 19 is a schematic view of a development architecture of an information management system shown in an example embodiment of the present application;

[0089] Figure 20 is a block diagram of a management apparatus of regulation information of vehicle parts according to an example embodiment of the present application;

[0090] Figure 21 is a block diagram of a computer device according to an example embodiment of the present application. DETAILED DESCRIPTION

[0091] In order to make the technical solutions and advantages of the present application clearer, the embodiments of the present application are described in further detail below.

[0092] The terms "first", "second", "third", and "fourth" and the like in the description and claims of the present application and the accompanying drawings are used to distinguish different objects, and are not used to describe a particular order. In addition, the terms "comprise" and "have" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but can optionally include steps or units not listed, or can optionally include other steps or units inherent to the process, method, product or device.

[0093] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data for analysis, stored data, displayed data, etc.) and signals involved in the present application are all authorized by the user or fully authorized by all parties, and the collection, use and processing of related data need to comply with relevant laws, regulations and standards of relevant countries and regions. For example, the user account and user password, regulation information, etc. involved in the present application are obtained under full authorization.

[0094] Reference is made to Figure 1 , which shows a schematic diagram of an implementation environment of a regulation information management method of vehicle parts according to an example embodiment of the present application. The implementation environment includes a first computer device 101 and a second computer device, and an information management system is installed on the first computer device 101 and the second computer device 102, and the information management system is used to manage the regulation information of vehicle parts. The first computer device 101 can be a computer device used by a first user, and the first user is a user who creates or updates the regulation information of vehicle parts, i.e. the first user is a project engineer; the information management system can be a regulation conformity checking system. The second computer device 102 can be a computer device used by a second user, and the second user is an administrator, i.e. the second user is a project manager.

[0095] The first computer device 101 is configured to create or update the regulatory information of the vehicle parts via the information management system, and the second computer device 102 is configured to view and manage the regulatory information of the vehicle parts via the information management system. In addition, the first computer device and the second computer device are in the same local area network.

[0096] In some embodiments, the first computer device 101 can be any terminal installed with the information management system, for example, a tablet computer, a notebook computer, a desktop computer, a vehicle terminal, or the like, but is not limited thereto. The second computer device 102 can be any terminal installed with the information management system, for example, a tablet computer, a notebook computer, a desktop computer, a vehicle terminal, or the like, but is not limited thereto.

[0097] In some other embodiments, the first computer device 101 and the second computer device 102 can be the same computer device or different computer devices. In the embodiments of the present application, the first computer device 101 and the second computer device 102 are taken as an example of the same computer device, that is, in the embodiments of the present application, the first user and the second user log in the information management system installed on the computer device via different user accounts and user passwords, so that different users can perform different operations via the same information management system.

[0098] Please refer to Figure 2 which shows a flowchart of a method for managing the regulatory information of the vehicle parts according to an example embodiment of the present application. Please refer to Figure 2 The method comprises the following steps.

[0099] In step 201, the first user logs in the information management system based on a user account and a user password of the first user, and the first user is a user for creating or updating the regulatory information of the vehicle parts.

[0100] The information management system can be a regulatory compliance verification system, and the first user is a project engineer. Before performing the present step, the computer device used by the first user is installed with the information management system, and the process of installing the information management system on the computer device can be that the computer device receives a compressed package program corresponding to the information management system, decompresses the compressed package program, and then installs the decompressed compressed package program to obtain the information management system. For example, please refer to Figure 3When the computer device receives the compressed package program corresponding to the information management system, a decompression interface is displayed, the decompression interface including a decompression button and a cancel button; when the user wants to decompress and install the information management system, the user can click the decompression button, and in response to the decompression button being triggered, the computer device decompresses the compressed package program, and then installs the decompressed compressed package program to obtain the information management system, at which time the computer device displays an icon of the information management system on the desktop, as shown in the right part of FIG. 2. Figure 3

[0101] The computer device displays an icon of the information management system on the desktop; when the first user clicks or double-clicks the icon of the information management system, the computer device displays a login interface, the login interface including an account input box, a password input box, a login system button, and a quit system button; the first user can input a user account in the account input box, input a user password in the password input box, and then click the login system button; at this time, the computer device checks the user account and the user password of the first user, and in a case where the user account and the user password of the first user are matched and correct, it is indicated that the first user successfully logs in the information management system, at which time step 202 is performed; when the first user wants to cancel logging in the information management system, the first user can click the quit system button, and the computer device, in response to the quit system button being triggered, quits the information management system. The login interface of the information management system is shown in FIG. 3. Figure 4 The user account and the user password of the first user are the work number of the first user by default; of course, the user password of the first user can also be modified by the first user.

[0102] In the whole vehicle development process of a vehicle, some vehicle parts may involve some regulatory parts, and the regulatory parts refer to parts that need to meet regulatory requirements (vehicle parts can also be referred to as regulatory parts). Therefore, during the design process, regulatory checking work needs to be performed on the vehicle parts, and due to different projects and different personnel, the regulatory information of the vehicle parts is too scattered; it is necessary for a project manager to master the regulatory information of the whole vehicle regulatory parts and ensure that each project meets the regulatory requirements; therefore, an information management system is developed and researched, which is used by engineers and project managers, thereby facilitating management of the regulatory information of the vehicle parts.

[0103] In the embodiments of the present application, the information management system supports real-time operation of multiple users, that is, multiple users can simultaneously log in the information management system through their own user accounts and user passwords, thereby managing the regulatory information of the vehicle parts through the information management system.

[0104] Step 202: A first Excel table corresponding to the information management system is displayed, and the work column of the first Excel table includes a regulation button. ​

[0105] In addition to the regulation button, the work column of the first Excel table further includes a plurality of original work buttons of Excel; for example, the work column of the Excel table further includes a file button, a start button, an insert button, a page layout button, a formula button, a data button, a review button, a view button and a development tool button; the work column of the first Excel table is as shown in Figure 5 .

[0106] When the first user wants to manage the regulation information of the vehicle parts based on the first Excel table; for example, the first user wants to create the regulation information of the parts, or the first user wants to update the regulation information of the parts, the first user can click the regulation button, and then step 203 is performed.

[0107] Step 203: In response to the regulation button being triggered, a plurality of management buttons of the regulation information are displayed.

[0108] The plurality of management buttons include a creation button and an update button, the creation button is used for creating the regulation information of the vehicle parts, and the update button is used for updating the regulation information of the vehicle parts; the plurality of management buttons can further include at least one of a password change button, an inquiry button and a clear button; the password change button is used for changing the user password, the inquiry button is used for inquiring the regulation information of the vehicle parts, and the clear button is used for clearing the created regulation information of the vehicle parts.

[0109] For example, when the first user wants to create the regulation information of the vehicle parts, the first user can click the creation button, and then step 204 is performed; for another example, when the first user wants to update the regulation information of the vehicle parts, the first user can click the update button, and then step 204 is performed.

[0110] Step 204: In response to a target management button in the plurality of management buttons being triggered, a management interface corresponding to the target management button is displayed, and the management interface includes input boxes corresponding to a plurality of management options.

[0111] The target management button can be a creation button or an update button; the input box corresponding to any management option is used to input the regulation information corresponding to the management option. For example, the target management button is a creation button, and the plurality of management options include the work number of the first user, the part number, the part name, the applicable vehicle model, the vehicle module to which the part is applied, the regulation part name, the responsible department of the part, and the responsible department of the part. For another example, the target management button is an update button, and the plurality of management options include the management options corresponding to at least one node; for example, the plurality of management options include the plurality of management options corresponding to the P3 node, and the plurality of management options corresponding to the P3 node include the regulation part model, the model identification position, the technical feature description, the traceable or non-traceable part barcode, the technical agreement number, the CCC identification position, the supplier name, the E-mark identification position, the regulation part model, the I identification position, the drawing number, other international market certification identification, and the regulation part model (drawing).

[0112] In step 205, based on the management interface, the regulation information of the vehicle part input in the input box corresponding to each management option is obtained.

[0113] The first user can input the regulation information of the vehicle part in the input box corresponding to each management option, and the regulation information includes the part number, the part name, the applicable vehicle model, the vehicle module to which the part is applied, the regulation part name, the responsible department of the part, and the responsible department of the part.

[0114] In step 206, the regulation information of the vehicle part is stored in the Access database of the relational database management system.

[0115] The computer device stores the regulation information of the vehicle part as a record in the Access database. In some embodiments, the computer device can also store the user account of the first user and the regulation information of the vehicle part after association, so as to facilitate querying the regulation information of the vehicle part managed by the first user based on the user account of the first user. In other embodiments, the computer device can also store the work number and the part number as index information, and store the index information and the regulation information after association, so as to facilitate querying the corresponding regulation information based on the index information including the work number and the part number.

[0116] In the embodiments of the present application, the first Excel table is developed twice through the information management system, and the operation function of the first user on the regulation information of the vehicle part is visually packaged, so that the operation function of the first user on the regulation information of the vehicle part is used as the function of the first Excel table itself, the function operation is simple and conforms to the user habit, thereby improving the management efficiency of the regulation information of the vehicle part.

[0117] Reference is made to Figure 6 which shows a flow chart of a method for managing regulation information of vehicle parts according to an example embodiment of the present application. Reference is made to Figure 6 The method comprises the following steps:

[0118] Step 601: The computer device logs into the information management system based on the user account and user password of the first user, the first user being a user who creates or updates the regulation information of the vehicle parts.

[0119] In some embodiments, this step is the same as step 201, which will not be repeated here.

[0120] Step 602: The computer device displays a first Excel table corresponding to the information management system, the work column of the first Excel table including a regulation button.

[0121] In some embodiments, this step is the same as step 202, which will not be repeated here.

[0122] Step 603: In response to the regulation button being triggered, the computer device displays a plurality of management buttons of the regulation information.

[0123] In some embodiments, this step is the same as step 203, which will not be repeated here.

[0124] Step 604: In response to a creation button in the plurality of management buttons being triggered, the computer device displays a creation interface corresponding to the creation button.

[0125] The creation interface includes an input box corresponding to the work number of the first user, an input box corresponding to the part number, an input box corresponding to the part name, an input box corresponding to the applicable vehicle model, an input box corresponding to the vehicle module to which the part is applied, an input box corresponding to the regulatory part name, an input box corresponding to the responsible department of the part, and an input box corresponding to the responsible office of the part. The input box corresponding to the work number of the first user is used to input the work number of the first user; the input box corresponding to the part number is used to input the number identification of the vehicle part; the input box corresponding to the part name is used to input the name of the vehicle part; the input box corresponding to the applicable vehicle model is used to input the first applicable vehicle model of the vehicle part (the applicable vehicle model can also be referred to as the first use vehicle model); the input box corresponding to the vehicle module to which the part is applied is used to input the vehicle module to which the vehicle part is applied (the vehicle module to which the part is applied can also be referred to as the responsible professional module); the input box corresponding to the regulatory part name is used to input the regulatory part name, and in the case of a vehicle part being a regulatory part, the regulatory part name and the part name are the same; the input box corresponding to the responsible department of the part is used to input the responsible department of the part; and the input box corresponding to the responsible office of the part is used to input the responsible office of the part. Correspondingly, the regulatory information includes the work number of the first user, the part number, the part name, the applicable vehicle model, the vehicle module to which the part is applied, the regulatory part name, the responsible department of the part, and the responsible office of the part.

[0126] In some embodiments, the creation interface further includes a save button; after the first user inputs the regulatory information of the vehicle part in the creation interface, the first user can click the save button, and then step 606 is performed.

[0127] For example, referring to Figure 7 , the first user clicks the create button, the computer device displays the creation interface, and the user inputs the regulatory information of the part in the creation interface, which is the work number 1, the part number 1012540513, the part name steering column, the first use vehicle model T1D, the responsible professional module base, the regulatory part name steering column, the responsible department steering department, and the responsible office steering transmission department. After the first user inputs the regulatory information of the vehicle part, the save button displayed in the creation interface is clicked, and then the computer device displays the first prompt information, which is used to prompt that the generation of the regulatory information of the vehicle part is completed; for example, referring to Figure 8 , the first prompt information can be "record generated".

[0128] Step 605: The computer device obtains the regulatory information of the vehicle part input in the input box corresponding to each of the plurality of management options based on the creation interface.

[0129] The computer device obtains the work number, part number, part name, applicable vehicle model, vehicle module to which the part is applied, regulation part name, responsible department of the part, and responsible department of the part based on the creation interface.

[0130] In step 606, the computer device stores the regulation information of the vehicle part into the Access database.

[0131] In some embodiments, this step is the same as step 206, which will not be described herein.

[0132] In some embodiments, the program can be written in MySQL language to realize the adding, deleting, modifying, and querying functions of the Access database. Correspondingly, the information management system also supports the adding, deleting, modifying, and querying functions. The creation button included in the plurality of management buttons displayed on the first Excel is used to add the regulation information of the vehicle part into the Access database. The querying button is used to query the regulation information of the vehicle part from the Access database (the process can refer to steps 1401-1405). Correspondingly, the plurality of management buttons further include a deleting button and a modifying button. When the first user wants to delete the regulation information of the vehicle part in the Access database, the first user can click the deleting button. Correspondingly, in response to the deleting button being triggered, the computer device displays a deleting interface including the regulation information of a plurality of vehicle parts. The regulation information of the selected vehicle part is obtained, and the regulation information of the selected vehicle part is deleted from the Access database.

[0133] When the first user wants to modify the regulation information of the vehicle part in the Access database, the first user can click the modifying button. Correspondingly, in response to the modifying button being triggered, the computer device displays a modifying interface including the regulation information of the vehicle part. The regulation information of the modified vehicle part in the modifying interface is obtained, and the regulation information of the vehicle part is modified to the regulation information of the modified vehicle part.

[0134] In the embodiments of the present application, the first Excel table is secondarily developed through the information management system, and the creation function of the first user for the regulation information of the vehicle part is visually packaged, so that the creation function of the first user for the regulation information of the vehicle part is used as a function of the first Excel table itself and is used by the user. The function operation is simple and conforms to the user habit, thereby improving the creation efficiency of the regulation information of the vehicle part.

[0135] Please refer to Figure 9 which shows a flowchart of a method for managing the regulation information of the vehicle part according to an example embodiment of the present application. Please refer to Figure 9 The method comprises the following steps.

[0136] Step 901: The computer device logs into the information management system based on the user account and user password of the first user, the first user being a user who creates or updates the regulatory information of the vehicle parts.

[0137] In some embodiments, the present step is the same as step 201, which will not be repeated here.

[0138] Step 902: The computer device displays a first Excel table corresponding to the information management system, and the work column of the first Excel table includes a regulatory button.

[0139] In some embodiments, the present step is the same as step 202, which will not be repeated here.

[0140] Step 903: In response to the regulatory button being triggered, the computer device displays a plurality of management buttons of the regulatory information.

[0141] In some embodiments, the present step is the same as step 203, which will not be repeated here.

[0142] Step 904: In response to an update button in the plurality of management buttons being triggered, the computer device displays a first query interface, the first query interface including an input box corresponding to a work number and an input box corresponding to a part number.

[0143] The first user can input a work number in the input box corresponding to the work number and input a part number in the input box corresponding to the part number; the first query interface further includes a confirmation button, which is clicked after the first user inputs the work number and the part number to trigger the computer device to execute step 905.

[0144] Step 905: The computer device acquires the work number input in the input box corresponding to the work number and the part number input in the input box corresponding to the part number.

[0145] For example, please refer to Figure 10 , the first user inputs 1 in the input box corresponding to the work number and 1012540513 in the input box corresponding to the part number, and then clicks the confirmation button; the computer device acquires the work number 1 and the part number 1012540513.

[0146] Step 906: The computer device displays an update interface corresponding to the update button based on the input work number and the input part number.

[0147] The computer device assembles the inputted work number and the inputted part number into index information, displays an update interface based on the index information and regulation information associated with the index information in the Access database, the update interface including regulation information of the vehicle part of the current node and node input boxes of at least one other node, the regulation information of the vehicle part of the current node including the inputted work number, the inputted part number, a part name, an applicable vehicle model, a vehicle module to which the part is applied, a regulation part name, a responsible department of the part, and a responsible department of the part; and the node input boxes of the other nodes are used for inputting regulation information of the vehicle part to be updated.

[0148] The regulation information of the vehicle part of the current node can also be referred to as node information of the current node. For example, refer to Figure 11 , the current node can be a P1 node; the at least one other node can include a P3 node, a P4 node, and P5-P7 nodes. Among them, the input box corresponding to the P3 node can include an input box corresponding to a regulation part model, an input box corresponding to a model identification position, an input box corresponding to a technical feature description, an input box corresponding to a traceable or non-traceable part barcode, an input box corresponding to a technical agreement number, an input box corresponding to a CCC identification position, an input box corresponding to a supplier name, an input box corresponding to an E-mark identification position, an input box corresponding to a regulation part item model, an input box corresponding to an I identification position, an input box corresponding to a drawing number, an input box corresponding to other international market certification identification, and an input box corresponding to a regulation part model (drawing). The input box corresponding to the P4 node includes an input box corresponding to a part intensive inspection report number and a regulation part model, an input box corresponding to an announcement number (vehicle model), an input box corresponding to a part CCC / self-declaration / voluntary certification report number and a regulation part item model, an input box corresponding to whether to fill in a record parameter table, an input box corresponding to a part E-mark certificate number and a regulation part item model, an input box corresponding to a regulation part model declared in a record parameter table, an input box corresponding to a part report / certificate manufacturer name (production unit), an input box corresponding to a supplier name declared in a record parameter table, and an input box corresponding to a part report / certificate validity (yes / no). The input box corresponding to the P5-P7 nodes includes an input box corresponding to whether the identification information defined by the drawing is consistent with the ESO appearance identification (yes / no) and an input box corresponding to a recognition report picture.

[0149] In some embodiments, the update interface further includes an input box corresponding to PVS consistency information, the input box corresponding to the PVS consistency information including an input box corresponding to whether the identification information defined by the drawing is consistent with the physical information (yes / no), an input box corresponding to a part report / certificate validity, an input box corresponding to a physical picture, an input box corresponding to a consistency state conclusion, and an input box corresponding to a confirmation person.

[0150] In some embodiments, the update interface further comprises an update button; the first user can click the update button after inputting the regulation information of the vehicle component in the input box corresponding to the at least one other node, so as to trigger the computer device to execute step 907. For example, the first user inputs the corresponding regulation information in the input box corresponding to the P3 node in the update interface; correspondingly, the first user inputs the regulation part model in the input box corresponding to the regulation part model, inputs the model identification position in the input box corresponding to the model identification position, inputs the technical feature description in the input box corresponding to the technical feature description, inputs the bar code in the input box corresponding to the traceable or non-traceable part bar code, inputs the technical protocol number in the input box corresponding to the technical protocol number, inputs the CCC identification in the input box corresponding to the CCC identification position, inputs the supplier name in the input box corresponding to the supplier name, inputs the E-mark identification position in the input box corresponding to the E-mark identification position, inputs the regulation part model in the input box corresponding to the regulation part model, inputs the I identification position in the input box corresponding to the I identification position, inputs the drawing number in the input box corresponding to the drawing number, inputs the other international market certification identification in the input box corresponding to the other international market certification identification, and inputs the regulation part model (drawing) in the input box corresponding to the regulation part model (drawing), and then triggers the computer device to execute step 907.

[0151] In some embodiments, the first user can update the regulation information of the vehicle component of the node in turn based on the order of the node; for example, when the first user creates the regulation information of the vehicle component (the node information of the P1 node) and updates the regulation information of the vehicle component for the first time, the first user can update the regulation information of the vehicle component in the input box corresponding to the P3 node, when the first user updates the regulation information of the vehicle component next time, the first user can input the corresponding regulation information in the input box corresponding to the P4 node; when the first user updates the regulation information of the vehicle component next time, the first user can input the corresponding regulation information in the input box corresponding to the P5-P7 node, and so on. The first user can also update the regulation information of the vehicle component of the node based on his own needs; for example, when the first user creates the regulation information of the vehicle component (the node information of the P1 node) and updates the regulation information of the vehicle component for the first time, the first user can update the regulation information of the vehicle component in the input box corresponding to the P4 node, when the first user updates the regulation information of the vehicle component next time, the first user can input the corresponding regulation information in the input box corresponding to the P4 node; when the first user updates the regulation information of the vehicle component next time, the first user can input the corresponding regulation information in the input box corresponding to the P5-P7 node.

[0152] In some embodiments, the first user can also update the regulatory information of the vehicle component of multiple nodes at one time; for example, when the first user creates the regulatory information of the vehicle component (the node information of the P1 node) and updates the regulatory information of the vehicle component for the first time, the first user can update the regulatory information of the vehicle component in the input box corresponding to the P3 node and the input box corresponding to the P4 node, and when the first user updates the regulatory information of the vehicle component for the next time, the first user can input the corresponding regulatory information in the input boxes corresponding to the P5-P7 nodes.

[0153] Step 907: The computer device obtains the updated regulatory information of the vehicle component based on the update interface.

[0154] The computer device obtains the regulatory information input in the input box corresponding to at least one other node based on the update interface, and the regulatory information input in the input box corresponding to at least one other node is the updated regulatory information of the vehicle component. For example, the computer device obtains the updated regulatory information of the vehicle component input in the input box corresponding to the P3 node based on the update interface, that is, the computer device obtains the regulatory part model input in the input box corresponding to the regulatory part model, the model identification position input in the input box corresponding to the model identification position, the technical feature description input in the input box corresponding to the technical feature description, the bar code input in the input box corresponding to the traceable or non-traceable part bar code, the technical protocol number input in the input box corresponding to the technical protocol number, the CCC identification position input in the input box corresponding to the CCC identification position, the supplier name input in the input box corresponding to the supplier name, the E-mark identification position input in the input box corresponding to the E-mark identification position, the regulatory part item model input in the input box corresponding to the regulatory part item model, the I identification position input in the input box corresponding to the I identification position, the drawing number input in the input box corresponding to the drawing number, the other international market certification identification input in the input box corresponding to the other international certification identification, and the regulatory part model (drawing) input in the input box corresponding to the regulatory part model (drawing).

[0155] Step 908: The computer device updates the updated regulatory information of the vehicle component to the Access database.

[0156] The computer device associates the original regulatory information of the vehicle component with the updated regulatory information and stores them in the Access database, so as to facilitate the user to obtain the updated regulatory information based on the original regulatory information of the vehicle component.

[0157] In the embodiment of the present application, the first Excel table is developed by the information management system, and the function of the first user updating the regulation information of the vehicle parts is visually packaged, so that the function of the first user updating the regulation information of the vehicle parts is used as the function of the first Excel table itself, the function operation is simple and conforms to the user habit, and the updating efficiency of the regulation information of the vehicle parts is improved.

[0158] Please refer to Figure 12 which shows a flowchart of a method for managing regulation information of vehicle parts according to an example embodiment of the present application. Please refer to Figure 12 The method comprises the following steps.

[0159] Step 1201: The computer device logs in the information management system based on the user account and user password of the first user, and the first user is a user who creates or updates the regulation information of the vehicle parts.

[0160] In some embodiments, this step is the same as step 201, and will not be repeated here.

[0161] Step 1202: The computer device displays the first Excel table corresponding to the information management system, and the work column of the first Excel table includes a regulation button.

[0162] In some embodiments, this step is the same as step 202, and will not be repeated here.

[0163] Step 1203: In response to the regulation button being triggered, the computer device displays a plurality of management buttons of the regulation information.

[0164] In some embodiments, this step is the same as step 203, and will not be repeated here.

[0165] Step 1204: In response to the update button in the plurality of management buttons being triggered, the computer device displays a first query interface, and the first query interface includes an input box corresponding to a work number and an input box corresponding to a part number.

[0166] In some embodiments, this step is the same as step 904, and will not be repeated here.

[0167] Step 1205: The computer device acquires the work number input in the input box corresponding to the work number and the part number input in the input box corresponding to the part number.

[0168] In some embodiments, this step is the same as step 905, and will not be repeated here.

[0169] Step 1206: The computer device displays an update interface corresponding to the update button based on the input work number and the input part number, and the update interface includes a picture upload button.

[0170] In some embodiments, this step is the same as step 906, which will not be repeated here. For example, please continue to refer to Figure 11 The update node includes an approval report picture and a physical picture, that is, a picture upload button.

[0171] Step 1207: In response to the picture upload button being triggered, the computer device displays a picture upload interface.

[0172] The picture upload interface includes multiple pictures in a picture library, and the first user can select a picture from the multiple pictures, and then trigger the computer device to execute step 1208. For example, please refer to Figure 13 The first user triggers the approval report picture button, and the computer device displays the picture upload interface.

[0173] Step 1208: The computer device obtains the target picture to be uploaded based on the picture upload interface.

[0174] Step 1209: The computer device stores the target picture into a shared folder, and generates a picture link of the target picture, and the picture link is used to call the target picture from the shared folder.

[0175] In the related art, the target picture is often directly stored into the Access database, however, since the maximum memory of the Access database is 20G, it is not suitable for directly storing pictures; therefore, in the embodiment of the present application, the computer device generates a picture link, stores the target picture into a shared folder, and stores the picture link of the target picture into the Access database, so that when a user views the target picture, the corresponding target picture is called from the shared folder based on the picture link, thereby saving the storage space of the Access database.

[0176] Step 1210: The computer device stores the picture link of the target picture into the Access database.

[0177] In the embodiment of the present application, when updating the regulation information of the vehicle parts, the uploading operation of pictures and texts is supported, thereby improving the convenience of updating the regulation information of the vehicle parts. The picture link is generated, the target picture is stored into a shared folder, and the picture link of the target picture is stored into the Access database, so that when a user views the target picture, the corresponding target picture is called from the shared folder based on the picture link, thereby saving the storage space of the Access database.

[0178] Please refer to Figure 14 , which shows a flowchart of a method for managing the regulation information of the vehicle parts according to an example embodiment of the present application. Referring to Figure 14 , the method comprises:

[0179] Step 1401: The computer device logs into the information management system based on the user account and user password of the second user, and the second user is an administrator.

[0180] The second user is a project manager. In some embodiments, the process in which the computer device logs into the information management system based on the user account and user password of the second user is similar to the process in which the computer device logs into the information management system based on the user account and user password of the first user. For details, please refer to step 201, which will not be described here.

[0181] Step 1402: The computer device displays a second query interface corresponding to the information management interface, and the second query interface includes input boxes corresponding to a plurality of query options.

[0182] Please refer to Figure 15 The input boxes corresponding to the plurality of query options can include an input box corresponding to the work number of the first user, an input box corresponding to the part number, an input box corresponding to the part name, an input box corresponding to the applicable vehicle model, an input box corresponding to the vehicle module to which the part is applied, an input box corresponding to the regulation part name, an input box corresponding to the responsible department of the part, an input box corresponding to the responsible department of the part, an input box corresponding to the technical agreement code, an input box corresponding to the supplier name, and an input box corresponding to the regulation part item model (which can also be referred to as (CGBOM regulation part model)).

[0183] The second user can input query information in the input box corresponding to at least one query option (referred to as a target query option). For example, the second user inputs 1012540513 in the input box corresponding to the part number.

[0184] Step 1403: The computer device obtains the input query information based on the input box corresponding to the target query option.

[0185] The query interface further includes a determination button. After the second user inputs the query information in the input box corresponding to the target query option, the second user clicks the determination button, and at this time, the computer device obtains the input query information based on the input box corresponding to the target query option.

[0186] Step 1404: The computer device obtains the regulation information of the queried vehicle part from the Access database based on the input query information.

[0187] The computer device takes the input query information as index information, and obtains the regulation information of the vehicle part corresponding to the index information from the Access database based on the index information.

[0188] Step 1405: The computer device generates a second Excel table, and the second Excel table includes the regulatory information of the queried vehicle parts.

[0189] The computer device presents the regulatory information of the vehicle parts to the second user in the form of the second Excel table, thereby facilitating the second user to manage the regulatory information of the vehicle parts, to master the current state of the whole vehicle regulatory parts, and to ensure the smooth progress of the project. For example, please refer to Figure 16 , after the computer device generates the second Excel table, the computer device generates a second prompt information, and the second prompt information is used to indicate that the second Excel table has been generated; for example, the second prompt information can be "information extraction success, a total of 1 record".

[0190] In some embodiments, in the case that the regulatory information of the vehicle parts includes pictures, the computer device displays a view button in the bottom item column of the second Excel table, in response to the view button being triggered, a picture link is displayed, and in response to the picture link being triggered, the picture corresponding to the picture link is obtained from the shared folder based on the picture link. For details, please refer to Figure 17 .

[0191] In some embodiments, the information management system also supports the function of authority transfer; accordingly, after the second user logs in the information management system, the computer device displays the second query interface corresponding to the information management, and the second query interface further includes an authority transfer button, in response to the authority transfer button being triggered, the computer device displays a first authority transfer interface, and the first authority transfer interface includes at least one authority possessed by the second user and at least one user account of other users, the second user can select the transferred authority (referred to as the first target authority) from the at least one authority and select the first target user who undertakes the first target authority from the at least one user account of other users; the computer device associates and stores the user account of the first target user and the first target authority, so that after the first target user logs in the information management system, the computer device provides the first target user with the first target authority.

[0192] In some embodiments, the first user can also transfer the authority; accordingly, after the first user logs in the information management system, the computer device displays the first Excel table corresponding to the information management system, and the authority transfer button is included in the work column of the first Excel table; in response to the authority transfer button being triggered, the computer device displays a second authority transfer interface, the second authority transfer interface including at least one authority possessed by the first user and at least one user account of other users, the first user being able to select the authority to be transferred (referred to as a second target authority) from the at least one authority and select a second target user who undertakes the second target authority from the at least one user account of other users; the computer device stores the user account of the second target user and the second target authority after associating the user account of the second target user and the second target authority, so as to provide the second target user with the second target authority after the second target user logs in the information management system in the future.

[0193] In the embodiments of the present application, the second user can store the regulatory information of the vehicle parts in the Access database into the second Excel table by logging in the information management system, so that the user does not need to manually store the regulatory information into the second Excel table, and the collection efficiency and management efficiency of the regulatory information of the vehicle parts are improved.

[0194] Please refer to Figure 18 , which shows a flowchart of a method for managing the regulatory information of the vehicle parts according to an exemplary embodiment of the present application. Please refer to Figure 18 , which includes the following steps.

[0195] Step 1801: The computer device determines the built-in Extensible Markup Language (XML) file of the first Excel table.

[0196] A program is written through VBA (Visual Basic for Applications) to connect the Excel table and the Access database through the ADO interface, so as to open the data channel; then the first Excel table is compressed, and the built-in XML file of the compressed first Excel table is determined. For example, please refer to Figure 19 , after opening the data channel between the Excel table and the Access database, the Excel is equivalent to the client, the Access database is equivalent to the database in the back end, the interface between the Excel and the Access is ADO (ActiveX Data Objects, ActiveX data objects), and a program is written through the MySQL language, so as to realize the functions of adding, deleting, modifying and querying the Access database.

[0197] Step 1802: The computer device rewrites the built-in XML file using the XML language, and the rewriting is used to add the regulation button in the first Excel table.

[0198] Through the rewriting, the custom built-in control, which is the regulation button, can be added in the first Excel table.

[0199] Step 1803: The computer device determines the VBA callback function, which is used to functionize the VBA source program corresponding to the regulation button.

[0200] Step 1804: The computer device binds the regulation button with the VBA callback function.

[0201] Step 1805: The computer device logs in the information management system based on the user account and user password of the first user, and the first user is the user who creates or updates the regulation information of the vehicle part.

[0202] In some embodiments, this step is the same as step 201, which will not be repeated here.

[0203] Step 1806: The computer device displays the first Excel table corresponding to the information management system, and the regulation button is included in the work column of the first Excel table.

[0204] In some embodiments, this step is the same as step 202, which will not be repeated here.

[0205] Step 1807: In response to the regulation button being triggered, the computer device acquires the VBA callback function bound with the regulation button.

[0206] Step 1808: The computer device displays a plurality of management buttons of the regulation information based on the callback function.

[0207] Step 1809: In response to a target management button in the plurality of management buttons being triggered, the computer device displays a management interface corresponding to the target management button, and the management interface includes input boxes corresponding to a plurality of management options.

[0208] In some embodiments, this step is the same as step 204, which will not be repeated here.

[0209] Step 1810: The computer device acquires the regulation information of the vehicle part input in the input box corresponding to each of the plurality of management options based on the management interface.

[0210] In some embodiments, this step is the same as step 205, which will not be repeated here.

[0211] Step 1811: The computer device stores the regulation information of the vehicle part into the Access database.

[0212] In some embodiments, the present step is the same as step 206, which will not be repeated here.

[0213] In the embodiments of the present application, the regulation information of the vehicle parts is managed based on Excel+VBA+Access, the first Excel table is developed again through the information management system, the operation function of the first user on the regulation information of the vehicle parts is visually packaged, so that the operation function of the first user on the regulation information of the vehicle parts is used as the function of the first Excel table itself, the function operation is simple and conforms to the user habit, thereby improving the management efficiency of the regulation information of the vehicle parts.

[0214] Please refer to Figure 20 , which shows a block diagram of a device for managing the regulation information of vehicle parts according to an exemplary embodiment of the present application. The device comprises:

[0215] The login module 2001 is configured to log in the information management system based on the user account and the user password of the first user, and the first user is a user who creates or updates the regulation information of the vehicle parts;

[0216] The first display module 2002 is configured to display the first Excel table corresponding to the information management system, and the work column of the first Excel table includes the regulation button;

[0217] The second display module 2003 is configured to display a plurality of management buttons of the regulation information in response to the regulation button being triggered;

[0218] The third display module 2004 is configured to display a management interface corresponding to a target management button in response to the target management button being triggered, and the management interface includes input boxes corresponding to a plurality of management options;

[0219] The first acquisition module 2005 is configured to acquire the regulation information of the vehicle parts input in the input boxes corresponding to the plurality of management options based on the management interface;

[0220] The first storage module 2006 is configured to store the regulation information of the vehicle parts into the relational database management system Access database.

[0221] In a possible implementation manner, the target management button is a creation button, and the management interface is a creation interface;

[0222] The third display module 2004 is configured to display a creation interface corresponding to the creation button, and the creation interface includes an input box corresponding to the work number of the first user, an input box corresponding to the part number, an input box corresponding to the part name, an input box corresponding to the applicable vehicle model, an input box corresponding to the vehicle module to which the part is applied, an input box corresponding to the regulation part name, an input box corresponding to the responsible department of the part, and an input box corresponding to the responsible department of the part.

[0223] In another possible implementation, the target management button is an update button, and the management interface is an update interface.

[0224] The third display module 2004 is configured to display a first query interface, and the first query interface includes an input box corresponding to the work number and an input box corresponding to the part number; obtain the input work number in the input box corresponding to the work number and the input part number in the input box corresponding to the part number; based on the input work number and the input part number, display an update interface corresponding to an update button, and the update interface includes regulation information of a vehicle part of a current node and a node input box of at least one other node, the regulation information of the vehicle part of the current node includes the input work number, the input part number, the part name, the applicable vehicle model, the vehicle module to which the part is applied, the regulation part name, the responsible department of the part, and the responsible department of the part; and the node input box of the other node is used to input the regulation information of the updated vehicle part.

[0225] In another possible implementation, the update interface further includes a picture upload button; and the device further includes:

[0226] The fourth display module is configured to display a picture upload interface in response to the picture upload button being triggered.

[0227] The second acquisition module is configured to acquire a target picture uploaded based on the picture upload interface.

[0228] The second storage module is configured to store the target picture into a shared folder, and generate a picture link of the target picture, the picture link being used to call the target picture from the shared folder; and store the picture link of the target picture into an Access database.

[0229] In another possible implementation, the device further includes:

[0230] The login module 2001 is further configured to log in to the information management system based on the user account and the user password of the second user, and the second user is an administrator.

[0231] The fifth display module is configured to display a second query interface corresponding to the information management interface, and the second query interface includes input boxes corresponding to a plurality of query options.

[0232] The third obtaining module is configured to obtain the input query information based on the input box corresponding to the target query option;

[0233] The fourth obtaining module is configured to obtain the regulation information of the queried vehicle part from the Access database based on the input query information.

[0234] The generating module is configured to generate a second Excel table, and the second Excel table includes the regulation information of the queried vehicle part.

[0235] In another possible implementation, the apparatus further includes:

[0236] The first determining module is configured to determine a built-in Extensible Markup Language (XML) file of the first Excel table.

[0237] The compiling module is configured to recompile the built-in XML file using an XML language, and the recompilation is used to add a regulation button in the first Excel table.

[0238] The second determining module is configured to determine a VBA callback function, and the VBA callback function is used to functionize a VBA source program corresponding to the regulation button.

[0239] The binding module is configured to bind the regulation button and the VBA callback function.

[0240] The second display module 2003 is configured to, in response to the regulation button being triggered, obtain the VBA callback function bound to the regulation button, and display a plurality of management buttons of the regulation information based on the callback function.

[0241] In the embodiments of the present application, the first Excel table is secondarily developed by using the information management system, and the operation function of the first user on the regulation information of the vehicle part is visually packaged, so that the operation function of the first user on the regulation information of the vehicle part is used as a function of the first Excel table itself, the function operation is simple and conforms to the user habit, and thus the management efficiency of the regulation information of the vehicle part is improved.

[0242] It should be noted that the management apparatus of the regulation information of the vehicle part provided in the above embodiments is only used as an example for the division of the above functional modules when the regulation information of the vehicle part is managed, and in actual application, the above functions can be completed by different functional modules according to needs, that is, the internal structure of the computer device is divided into different functional modules to complete all or part of the above described functions. In addition, the management apparatus of the regulation information of the vehicle part provided in the above embodiments and the management method of the regulation information of the vehicle part belong to the same concept, and the specific implementation process is described in the method embodiments, which will not be repeated here.

[0243] Figure 21 is a structural block diagram of a computer device provided by an embodiment of the present application. Generally, the computer device 2100 includes a processor 2101, a memory 2102, a voice receiving apparatus 2103, and a controller 2104. The processor 2101 can include one or more processing cores, such as a 4-core processor, an 8-core processor, and the like. The processor 2101 can be implemented in at least one of a hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). The processor 2101 can also include a main processor and a coprocessor. The main processor is a processor for processing data in a wake-up state, also referred to as a CPU (Central Processing Unit). The coprocessor is a low-power processor for processing data in a standby state. In some embodiments, the processor 2101 can further include an AI (Artificial Intelligence) processor for processing a machine learning-related computing operation.

[0244] The memory 2102 can include one or more computer-readable storage media that can be non-transitory. The memory 2102 can also include a high-speed random access memory, and a nonvolatile memory such as one or more disk storage devices, flash storage devices. In some embodiments, the non-transitory computer-readable storage medium in the memory 2102 is used to store at least one instruction for being executed by the processor 2101 to implement the light control method provided by the method embodiment of the present application.

[0245] In some embodiments, the computer device 2100 can also optionally include a peripheral device interface 2105 and at least one peripheral device. The processor 2101, the memory 2102, and the peripheral device interface 2105 can be connected through a bus or a signal line. Each peripheral device can be connected to the peripheral device interface 2105 through a bus, a signal line, or a circuit board. Specifically, the peripheral device includes at least one of a radio frequency circuit 2106, an audio circuit 2107, and a power supply 2108.

[0246] The peripheral interface 2105 can be used to connect at least one I / O (Input / Output) related peripheral device to the processor 2101 and the memory 2102. In some embodiments, the processor 2101, the memory 2102 and the peripheral interface 2105 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 2101, the memory 2102 and the peripheral interface 2105 can be implemented on a separate chip or circuit board, and the present embodiments are not limited in this regard.

[0247] The radio frequency circuit 2106 is configured to receive and send RF (Radio Frequency) signals, also known as electromagnetic signals. The radio frequency circuit 2106 communicates with communication networks and other communication devices through electromagnetic signals. The radio frequency circuit 2106 converts electrical signals into electromagnetic signals for transmission, or converts electromagnetic signals received into electrical signals. Optionally, the radio frequency circuit 2106 includes an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and the like. The radio frequency circuit 2106 can communicate with other terminals through at least one wireless communication protocol. The wireless communication protocol includes, but is not limited to, a metropolitan area network, various generations of mobile communication networks (2G, 3G, 4G and 5G), a wireless local area network and / or a WiFi (Wireless Fidelity) network. In some embodiments, the radio frequency circuit 2106 can also include NFC (Near Field Communication) related circuitry, and the present application is not limited in this regard.

[0248] The audio circuit 2107 can include a microphone and a speaker. The microphone is used to collect sound waves of the user and the environment, and convert the sound waves into electrical signals input to the processor 2101 for processing, or input to the radio frequency circuit 2106 to realize voice communication. For the purpose of stereo sound collection or noise reduction, the microphone can be multiple, arranged at different parts of the computer device 2100. The microphone can also be an array microphone or an omnidirectional collection type microphone. The speaker is used to convert electrical signals from the processor 2101 or the radio frequency circuit 2106 into sound waves. The speaker can be a conventional diaphragm speaker, or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, not only can it convert electrical signals into sound waves audible to humans, but also can convert electrical signals into sound waves inaudible to humans for ranging purposes. In some embodiments, the audio circuit 2107 can also include a headphone jack.

[0249] The power supply 2108 is configured to supply power to various components in the computer device 2100. The power supply 2108 can be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power supply 2108 includes a rechargeable battery, the rechargeable battery can support wired charging or wireless charging. The rechargeable battery can also be configured to support fast charging technology.

[0250] Those skilled in the art can understand that the structure shown in the above embodiments does not constitute a limitation on the computer device 2100, and the computer device 2100 can include more or fewer components than those shown in the figure, or combine some components, or adopt a different arrangement of components. Figure 21

[0251] The embodiments of the present application also provide a computer readable storage medium, which stores at least one program code. The at least one program code is loaded and executed by a processor to implement the management method of the regulatory information of the vehicle part according to any of the above embodiments. Optionally, the storage medium can be a non-transitory computer readable storage medium, for example, the non-transitory computer readable storage medium can be a ROM (Read-Only Memory), a RAM (Random Access Memory), a CD-ROM (Compact Disc Read-Only Memory), a magnetic tape, a floppy disk, and an optical data storage device, etc.

[0252] The embodiments of the present application also provide a computer program product, which stores at least one program code. The at least one program code is loaded and executed by a processor to implement the management method of the regulatory information of the vehicle part according to any of the above embodiments.

[0253] In some embodiments, the computer program product related to the embodiments of the present application can be deployed on one computer device for execution, or on multiple computer devices located in one place for execution, or on multiple computer devices distributed in multiple places and interconnected through a communication network for execution. The multiple computer devices distributed in multiple places and interconnected through a communication network can constitute a blockchain system.

[0254] Those skilled in the art can understand that all or part of the steps of the above embodiments can be completed by hardware, or the program can instruct the related hardware to complete, and the program can be stored in a computer readable storage medium, and the storage medium mentioned above can be a read-only memory, a magnetic disk or an optical disk, etc.

[0255] ​The above merely describes the technical solutions of the present application for the purpose of enabling those skilled in the art to understand the technical solutions of the present application, and is not intended to limit the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method of managing regulation information of a vehicle component, characterized by, The method comprises: logging into an information management system based on user account and user password of a first user, the first user being a user who creates or updates regulation information of a vehicle part; displaying a first Excel table corresponding to the information management system, the first Excel table comprising a regulation button in a work column thereof; in response to the regulation button being triggered, displaying a plurality of management buttons of regulation information; in response to a target management button of the plurality of management buttons being triggered, displaying a management interface corresponding to the target management button, the management interface comprising input boxes corresponding to a plurality of management options; based on the management interface, obtaining regulation information of a vehicle part input in the input boxes corresponding to the plurality of management options respectively; storing the regulation information of the vehicle part into an Access database of a relational database management system; determining an internal extensible markup language (XML) file of the first Excel table; using the XML language to perform secondary writing on the internal XML file, the secondary writing being used to add the regulation button in the first Excel table; determining a VBA callback function, the VBA callback function being used to functionize a VBA source program corresponding to the regulation button; binding the regulation button and the VBA callback function; the response to the regulation button being triggered, the display of the plurality of management buttons of regulation information comprises: in response to the regulation button being triggered, obtaining the VBA callback function bound to the regulation button; based on the callback function, displaying the plurality of management buttons of regulation information.

2. The method of claim 1, wherein, the target management button is a creation button, and the management interface is a creation interface; the display of the management interface corresponding to the target management button comprises: displaying the creation interface corresponding to the creation button, the creation interface comprising an input box corresponding to a work number of the first user, an input box corresponding to a part number, an input box corresponding to a part name, an input box corresponding to a vehicle model, an input box corresponding to a vehicle module to which the part is applied, an input box corresponding to a regulation part name, an input box corresponding to a responsible department of the part, and an input box corresponding to a responsible department of the part.

3. The method of claim 1, wherein, the target management button is an update button, and the management interface is an update interface; the display of the management interface corresponding to the target management button comprises: displaying a first query interface, the first query interface comprising an input box corresponding to a work number and an input box corresponding to a part number; obtaining a work number input in the input box corresponding to the work number and a part number input in the input box corresponding to the part number; Display an update interface corresponding to the update button based on the inputted work number and the inputted part number, the update interface including regulation information of a vehicle part of a current node and a node input box of at least one other node, the regulation information of the vehicle part of the current node including the inputted work number, the inputted part number, a part name, an applicable vehicle model, a vehicle module to which the part is applied, a regulation piece name, a responsible department of the part, and a responsible office of the part, and the node input box of the other node being used to input regulation information of an updated vehicle part.

4. The method of claim 3, wherein, The update interface further includes a picture uploading button, and the method further includes: In response to the picture uploading button being triggered, display a picture uploading interface; Based on the picture uploading interface, obtain a target picture uploaded; Store the target picture into a shared folder and generate a picture link of the target picture, the picture link being used to call the target picture from the shared folder; Store the picture link of the target picture into the Access database.

5. The method of claim 1, wherein, The method further includes: Based on a user account and a user password of a second user, log in the information management system, the second user being an administrator; Display a second query interface corresponding to an information management interface, the second query interface including input boxes corresponding to a plurality of query options; Based on the input boxes corresponding to target query options, obtain inputted query information; Based on the inputted query information, obtain regulation information of a queried vehicle part from the Access database; Generate a second Excel table including the regulation information of the queried vehicle part.

6. A management device of regulation information of a vehicle part, characterized by, The device includes: A login module configured to log in an information management system based on a user account and a user password of a first user, the first user being a user who creates or updates regulation information of a vehicle part; A first display module configured to display a first Excel table corresponding to the information management system, the first Excel table including a regulation button in a work column; A second display module configured to, in response to the regulation button being triggered, display a plurality of management buttons of regulation information; A third display module configured to, in response to a target management button in the plurality of management buttons being triggered, display a management interface corresponding to the target management button, the management interface including input boxes corresponding to a plurality of management options; A first obtaining module configured to, based on the management interface, obtain regulation information of a vehicle part inputted in the input boxes corresponding to the plurality of management options respectively; A first storage module configured to store the regulation information of the vehicle part into an Access database of a relational database management system; A first determining module configured to determine an internal Extensible Markup Language (XML) file of the first Excel table; A compiling module configured to compile the internal XML file using an XML language, the compiling being used to add the regulation button in the first Excel table; A second determining module is configured to determine a VBA callback function, the VBA callback function being used to functionize a VBA source program corresponding to the regulation button; A binding module is configured to bind the regulation button with the VBA callback function; The second displaying module is configured to, in response to the regulation button being triggered, acquire the VBA callback function bound with the regulation button, and display a plurality of management buttons of the regulation information based on the callback function.

7. A computer device, comprising: The computer device comprises a processor and a memory, and the memory stores at least one program code, which is loaded and executed by the processor to implement the management method of the regulation information of the vehicle part according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The storage medium stores at least one program code, which is loaded and executed by the processor to implement the management method of the regulation information of the vehicle part according to any one of claims 1 to 5.

9. A computer program product, characterised in that, The product stores at least one program code, which is used to be executed by the processor to implement the management method of the regulation information of the vehicle part according to any one of claims 1 to 5.

Images