Automatic filling method for SOR form of vehicle part

Abstract

The invention discloses an automatic filling method of a vehicle part SOR form, and belongs to the field of data processing. The method comprises the steps of obtaining a 3D assembly drawing of vehicle purchase-level parts or assemblies and constructing an assembly structure tree document of the vehicle purchase-level parts or assemblies; according to the assembly structure tree document, performing screenshot and storage on 3D assembly drawings of purchase-level parts, assemblies and assembly sub-parts of all vehicles; and acquiring attribute information of corresponding parts, assemblies and assembly sub-parts by traversing the assembly structure tree document of the vehicle purchase-level parts or assemblies, and matching corresponding screenshots and automatically filling the screenshots in an SOR form. The invention aims to realize automatic filling of the SOR form, and solves the problems of manual screenshot one by one, manual filling of the content of the SOR form and manual insertion of pictures in the form.

Description

Technical Field

[0001] The invention belongs to the field of data processing, and in particular relates to a method for automatically filling in a vehicle parts SOR form. Background Art

[0002] The SOR form is a technical form that describes the procurement-level parts information and sub-parts information of the vehicle body. The form is divided into two parts. The left part of the form is the procurement-level parts or assembly information, and the right part is the sub-parts information.

[0003] The list contains a large amount of information. Traditional SOR form filling is almost entirely done manually, with pictures inserted one by one. This requires developers to repeat operations and adjustments. For a large number of parts in the car body, this requires a lot of time and experience from developers. At the same time, human errors are prone to occur during repeated operations and adjustments.

[0004] In the prior art, the material form command provided by software such as Catia is usually used to construct the SOR form, but it also requires repeated copying and pasting, and pictures still need to be inserted and adjusted item by item. To this end, the present application proposes an automatic filling method for the vehicle parts SOR form. Summary of the invention

[0005] The present invention aims to overcome the deficiencies of the prior art and proposes an automatic filling method for a vehicle parts SOR form, which solves the problems of manually taking screenshots one by one, manually filling in the SOR form content, and manually inserting pictures into the form.

[0006] In order to achieve the above object, the technical solution adopted by the present invention is: a method for automatically filling in a vehicle parts SOR form, the method comprising the following steps:

[0007] Step S1, obtaining a 3D assembly drawing of a vehicle procurement-level part or assembly and constructing its assembly structure tree document; based on the assembly structure tree document, taking screenshots of the 3D assembly drawings of each vehicle procurement-level part, assembly, and assembly sub-part and saving them;

[0008] Step S2: traverse the assembly structure tree document of the vehicle procurement-level parts or assemblies to obtain the attribute information of the corresponding parts, assemblies, and assembly sub-parts, and automatically fill in the SOR form by matching the corresponding screenshots.

[0009] Preferably, the step S1 comprises:

[0010] Step S11, obtaining a 3D assembly drawing of a vehicle procurement-level part or assembly and constructing an assembly structure tree document thereof, wherein the vehicle procurement-level part or assembly is at the second level of the assembly structure tree document, and the third level under each second level includes sub-parts belonging to the corresponding vehicle procurement-level assembly;

[0011] Step S12, traverse all second levels and set all parts, assemblies, and sub-assembly parts therein to an inactive state;

[0012] Step S13, traverse all the second levels again, wherein, after activating and taking a screenshot of a single part, assembly, or assembly sub-part, the corresponding part, assembly, or assembly sub-part is restored to an inactive state again, and this cycle is repeated until all parts, assemblies, and assembly sub-parts have completed screenshots; the screenshot name is the part number of the corresponding part, assembly, or assembly sub-part.

[0013] Preferably, the step S2 comprises:

[0014] Step S21, initialize the SOR form, and automatically fill in the SOR form header; the header includes various attribute information of the vehicle procurement level part or assembly, and various attribute information of the sub-parts of the vehicle procurement level part or assembly; the attribute information is arranged in rows or columns in the form; the attribute information includes the part or assembly name, part number, usage, weight, sub-part name;

[0015] Step S22, traverse the assembly structure tree document, identify whether the corresponding product is a part or an assembly, and capture the corresponding attribute information and match the corresponding screenshot to automatically fill in the SOR form.

[0016] Preferably, step S22 includes: if the corresponding product is a part, filling in the attribute information of the corresponding vehicle procurement-level part and the attribute information of the sub-parts of the vehicle procurement-level part according to the SOR form header, and inserting the corresponding screenshot according to the part number; for a single part, the attribute information and screenshots of the corresponding part and the sub-parts of the part are the same; at this time, the number of rows or columns in the form is increased by one.

[0017] Preferably, step S22 includes: if the corresponding product is an assembly, traversing the assembly structure tree document, storing the part numbers of all sub-parts belonging to the assembly in the array of list 1, removing duplicate part numbers of all sub-parts and storing them in the array of list 2, and obtaining the usage quantity of the sub-parts belonging to the assembly based on statistics of list 1 and list 2.

[0018] Preferably, the step S22 includes: filling in the attribute information of the corresponding vehicle procurement-level assembly according to the SOR form header, and inserting the corresponding assembly screenshot according to the part number; then, filling in the attribute information of the sub-parts belonging to the corresponding vehicle procurement-level assembly according to the SOR form header, and inserting the corresponding screenshot according to the part number; at this time, the number of form rows or columns corresponds to the addition of the array length of the list 2.

[0019] Preferably, the step S22 further comprises: in the SOR form, the sub-parts belonging to the same vehicle procurement-level assembly are summarized, and the attribute information of the corresponding vehicle procurement-level assembly is merged into a whole.

[0020] Preferably, the 3D assembly drawing of the vehicle procurement-level parts or assemblies and the assembly structure tree document thereof are obtained through Catia.

[0021] Preferably, the SOR form is created via Excel.

[0022] Preferably, the method is programmed in Python.

[0023] The technical effect of the present invention is that it takes 4 to 5 people and 2 to 3 days to manually fill out the SOR form of the entire vehicle body system; while the present invention only requires one person to complete the SOR form in a short time. While improving efficiency, the accuracy of the form content is improved, and the standardization of the form can also be guaranteed. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 A flow chart of a batch screenshot method provided by an embodiment of the present invention;

[0025] Figure 2 A flow chart of a method for batch filling of SOR forms provided by an embodiment of the present invention;

[0026] Figure 3 This is an example diagram of a SOR form provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0027] The following is a further detailed description of the specific implementation of the present invention through the description of the embodiments with reference to the accompanying drawings, the purpose of which is to help those skilled in the art have a more complete, accurate and in-depth understanding of the inventive concept and technical solution of the present invention, and to facilitate its implementation. It should be noted that the words "first", "second" and the like described in this application are only for the convenience of describing the technical solution to distinguish different components, and are not used to limit this application. In order to make the technical solution of the present invention clearer, the present invention is explained through the following embodiments.

[0028] The existing SOR form filling has the problems of low manual efficiency, cumbersome operation, and easy statistical errors. Therefore, this embodiment provides a method for automatically filling in the vehicle parts SOR form, which mainly includes two parts. The first part is used to batch capture 3D assembly drawings of vehicle procurement-level parts, assemblies, and assembly sub-parts; the second part is used to capture the attribute information of parts, assemblies, and assembly sub-parts, count the number of sub-parts, and insert pictures in the SOR form.

[0029] Specifically, the method of this embodiment includes the following steps:

[0030] Step S1, obtaining a 3D assembly drawing of a vehicle procurement-level part or assembly and its assembly structure tree document; taking screenshots of the 3D assembly drawings of each vehicle procurement-level part, assembly, and assembly sub-part according to the assembly structure tree document and saving them;

[0031] Step S2: traverse the assembly structure tree document of the vehicle procurement-level parts or assemblies to obtain the attribute information of the corresponding parts, assemblies, and assembly sub-parts, and automatically fill in the SOR form by matching the corresponding screenshots.

[0032] In the above, in the present embodiment, the 3D assembly drawing of vehicle procurement level parts or assembly and the construction of its assembly structure tree document are obtained by Catia software. Catia is a kind of three-dimensional drawing software commonly used, when making and checking the 3D assembly drawing of parts or assembly, its assembly structure tree document can be constructed, for example, for the 3D assembly drawing of an assembly, the assembly is composed of a plurality of sub-parts assembling, then a certain level of the assembly structure tree is represented as the whole assembly, and the corresponding multiple branches of the plurality of sub-parts of the assembly are represented as the plurality of branches of this level. Meanwhile, Catia can also provide API interface, so as to import the program generated according to the inventive method to realize automatic batch screenshot, for example, the present embodiment is carried out by Python with the inventive method being programmed. The SOR form of the present embodiment is created by Excel. During specific implementation, other three-dimensional drawing software or table tools can also be selected according to actual conditions.

[0033] like Figure 1 The batch screenshot method flow shown in the figure, step S1 of this embodiment includes:

[0034] Step S11, obtaining the 3D assembly drawing of the vehicle procurement level parts or assemblies and constructing its assembly structure tree document. Specifically, the product 3D file provided by the supplier is used as the application object and opened through Catia, and the 3D assembly drawings of various vehicle procurement level parts or assembly products can be obtained after opening. At the same time, the window where the product is located can be adjusted in Catia as needed, such as setting a white background, hiding the compass, hiding the plane, setting the view size, etc., and finally obtaining the 3D assembly drawing of the vehicle procurement level parts or assemblies.

[0035] Then, a corresponding assembly structure tree document is constructed. In this embodiment, the vehicle procurement level parts or assemblies are arranged at the second level of the assembly structure tree document, and the sub-parts belonging to the corresponding vehicle procurement level assembly are arranged at the third level under each second level.

[0036] Step S12, traverse all second levels and set all parts, assemblies, and sub-assembly parts therein to an inactive state;

[0037] Step S13, traverse all the second levels again, wherein, after activating and taking a screenshot of a single part, assembly, or assembly sub-part, the corresponding part, assembly, or assembly sub-part is restored to an inactive state again, and this cycle is repeated until all parts, assemblies, and assembly sub-parts have completed screenshots; the screenshots are saved in a directory preset by the user; the screenshot name is set to the part number of the corresponding part, assembly, or assembly sub-part, which can be identified and captured from the opened product 3D file.

[0038] like Figure 2 The SOR form batch filling method shown in the embodiment includes step S2:

[0039] Step S21, create and initialize a SOR form through Excel, and automatically fill in the SOR form header; the header includes the attribute information of the vehicle procurement-level parts or assemblies, and the attribute information of the sub-parts of the vehicle procurement-level parts or assemblies; the attribute information is arranged in rows or columns in the form (in this embodiment, each attribute information occupies one column of the form); the attribute information includes the part or assembly name, part number, usage, weight, sub-part name, serial number, etc. During specific implementation, the attribute information can be expanded according to actual conditions; like the existing form, the form as a whole is divided into two parts, the left part of the form is the attribute information of the procurement-level parts or assemblies, and the right part is the attribute information of the corresponding sub-parts.

[0040] Step S22, traverse the assembly structure tree document, identify whether the corresponding product is a part or an assembly, and capture the corresponding attribute information and match the corresponding screenshot to automatically fill in the SOR form.

[0041] If the corresponding product is a part, fill in the attribute information of the corresponding vehicle procurement-level part and the attribute information of the sub-parts of the vehicle procurement-level part according to the SOR form header, and insert the corresponding screenshot according to the part number; for a single part, its sub-part is itself, so the attribute information and screenshot of the corresponding part and the sub-part of the part are the same; at this time, the number of rows or columns in the form is increased by one (in this embodiment, the number of rows in the form is increased by one).

[0042] If the corresponding product is an assembly, the assembly structure tree document is traversed, and the part numbers of all sub-parts belonging to the assembly are stored in the array of List 1. The part numbers of all sub-parts are removed and stored in the array of List 2. The usage quantity of the sub-parts belonging to the assembly is obtained according to the statistics of List 1 and List 2.

[0043] After obtaining the number of sub-parts used, step S22 can fill in the attribute information of the corresponding vehicle procurement-level assembly according to the SOR form header, and insert the corresponding assembly screenshot according to the part number; then, fill in the attribute information of the sub-parts belonging to the corresponding vehicle procurement-level assembly according to the SOR form header, and insert the corresponding screenshot according to the part number; at this time, the number of form rows or columns corresponds to the addition of the array length of the list 2 (in this embodiment: the number of form rows corresponds to the addition of the array length of list 2).

[0044] Finally, the SOR form needs to be organized to improve the standardization of the form, that is, in the SOR form, the sub-parts belonging to the same vehicle procurement level assembly are summarized, and the attribute information of the corresponding vehicle procurement level assembly is merged into a whole. Figure 3 shown.

[0045] It takes 4 to 5 people and 2 to 3 days to manually fill out the SOR form for the entire vehicle body system; however, the present invention only requires one person to complete the SOR form in a short time. While improving efficiency, the accuracy of the form content is improved, and the standardization of the form can also be guaranteed.

[0046] The present invention is described above by way of example in conjunction with the accompanying drawings. Obviously, the specific implementation of the present invention is not limited to the above-mentioned methods. As long as various non-substantial improvements are made using the method concept and technical solution of the present invention; or the above concept and technical solution of the present invention are directly applied to other occasions without improvement, they are all within the protection scope of the present invention.

Claims

1. A method for automatically filling in a vehicle parts SOR form, characterized in that: The method comprises the following steps: Step S1, obtaining a 3D assembly drawing of a vehicle procurement-level part or assembly and constructing its assembly structure tree document; based on the assembly structure tree document, taking screenshots of the 3D assembly drawings of each vehicle procurement-level part, assembly, and assembly sub-part and saving them; Step S2: traverse the assembly structure tree document of the vehicle procurement-level parts or assemblies to obtain the attribute information of the corresponding parts, assemblies, and assembly sub-parts, and automatically fill in the SOR form by matching the corresponding screenshots.

2. The method for automatically filling in a vehicle parts SOR form according to claim 1, characterized in that: The step S1 comprises: Step S11, obtaining a 3D assembly drawing of a vehicle procurement-level part or assembly and constructing an assembly structure tree document thereof, wherein the vehicle procurement-level part or assembly is at the second level of the assembly structure tree document, and the third level under each second level includes sub-parts belonging to the corresponding vehicle procurement-level assembly; Step S12, traverse all second levels and set all parts, assemblies, and sub-assembly parts therein to an inactive state; Step S13, traverse all the second levels again, wherein, after activating and taking a screenshot of a single part, assembly, or assembly sub-part, the corresponding part, assembly, or assembly sub-part is restored to an inactive state again, and this cycle is repeated until all parts, assemblies, and assembly sub-parts have completed screenshots; the screenshot name is the part number of the corresponding part, assembly, or assembly sub-part.

3. The method for automatically filling in a vehicle parts SOR form according to claim 1, characterized in that: The step S2 comprises: Step S21, initialize the SOR form, and automatically fill in the SOR form header; the header includes various attribute information of the vehicle procurement level part or assembly, and various attribute information of the sub-parts of the vehicle procurement level part or assembly; the attribute information is arranged in rows or columns in the form; the attribute information includes the part or assembly name, part number, usage, weight, sub-part name; Step S22, traverse the assembly structure tree document, identify whether the corresponding product is a part or an assembly, and capture the corresponding attribute information and match the corresponding screenshot to automatically fill in the SOR form.

4. The method for automatically filling in a vehicle parts SOR form according to claim 3, characterized in that: The step S22 includes: if the corresponding product is a part, filling in the attribute information of the corresponding vehicle procurement-level part and the attribute information of the sub-parts of the vehicle procurement-level part according to the SOR form header, and inserting the corresponding screenshot according to the part number; for a single part, the attribute information and screenshots of the corresponding part and the sub-parts of the part are the same; at this time, the number of rows or columns in the form is increased by one.

5. The method for automatically filling in a vehicle parts SOR form according to claim 4, characterized in that: The step S22 includes: if the corresponding product is an assembly, traversing the assembly structure tree document, storing the part numbers of all sub-parts belonging to the assembly in the array of list 1, removing duplicate part numbers of all sub-parts and storing them in the array of list 2, and obtaining the usage quantity of the sub-parts belonging to the assembly based on the statistics of list 1 and list 2.

6. The method for automatically filling in a vehicle parts SOR form according to claim 5, characterized in that: The step S22 includes: filling in the attribute information of the corresponding vehicle procurement level assembly according to the SOR form header, and inserting the corresponding assembly screenshot according to the part number; then, filling in the attribute information of the sub-parts belonging to the corresponding vehicle procurement level assembly according to the SOR form header, and inserting the corresponding screenshot according to the part number; at this time, the number of form rows or columns corresponds to the addition of the array length of the list 2.

7. The method for automatically filling in a vehicle parts SOR form according to claim 6, characterized in that: The step S22 further includes: in the SOR form, the sub-parts belonging to the same vehicle procurement level assembly are summarized, and the attribute information of the corresponding vehicle procurement level assembly is merged into a whole.

8. The method for automatically filling in a vehicle parts SOR form according to any one of claims 1 to 7, characterized in that: The 3D assembly drawing of the vehicle procurement-level parts or assemblies and the assembly structure tree document thereof are obtained through Catia.

9. The method for automatically filling in a vehicle parts SOR form according to any one of claims 1 to 7, characterized in that: The SOR form is created via Excel.

10. The method for automatically filling in a vehicle parts SOR form according to any one of claims 1 to 7, characterized in that: The method is programmed in Python.

Images