A pre-switching automobile part selection method, device, equipment and storage medium
By matching production data in the quota database, the production data with the smallest scheduling date and the smallest number of planned items is selected as the first automotive component to be switched over, which solves the problem of low accuracy in the pre-switching process and achieves efficient component switching and accurate material allocation.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- DONGFENG LIUZHOU MOTOR
- Filing Date
- 2023-03-20
- Publication Date
- 2026-06-19
AI Technical Summary
In existing technologies, the pre-switching process for automotive components suffers from low switching accuracy and low work efficiency.
By acquiring the coding data of the pre-switched automotive parts, matching the corresponding production data in the preset quota database, and selecting the production data with the smallest production date and the smallest number of planned items as the first pre-switched automotive part based on the production line number, production date, and number of planned items, the system automatically locks the data.
It improves the accuracy and efficiency of pre-switching automotive parts on the production line, reduces manual calculation costs and material backlog, and meets the company's need for synchronized production.
Smart Images

Figure CN116361359B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of electronic digital data processing, and more particularly to a method, apparatus, device, and storage medium for selecting pre-switched automotive components. Background Technology
[0002] During vehicle production, the daily quota for the entire vehicle needs to be calculated daily. The manufacturing technology department's process engineers need to mark the first vehicle to be switched based on this quota, prompting the issuance of a switchover order. The switchover order number is then written into a visual card, allowing for the identification of the first component to be produced on each production line and enabling the switchover. However, currently, querying vehicle information related to project switchovers can only be done manually from the production management system, resulting in a high error rate and low efficiency.
[0003] Therefore, there is an urgent need for a selection strategy for pre-switched automotive components to solve the problem of low accuracy in switching pre-switched automotive components on the production line. Summary of the Invention
[0004] This invention provides a method, apparatus, equipment, and storage medium for selecting pre-switched automotive components, thereby improving the accuracy of pre-switched automotive component switching on the production line.
[0005] To address the aforementioned problems, one embodiment of the present invention provides a method for selecting pre-switched automotive components, comprising:
[0006] Obtain the coded data of the vehicle components to be switched;
[0007] Based on the coding data of the pre-switched automotive parts, multiple sets of production data corresponding to the pre-switched automotive parts are matched in a preset quota database; wherein, the preset quota database includes the coding data and production data of each planned automotive part; the production data includes: production line number, production scheduling date, and number of planned items;
[0008] Based on the production line number, scheduling date, and number of planned items for each set of production data, the production data corresponding to the smallest scheduling date and the smallest number of planned items is selected from the several production data corresponding to each production line number as the production data for the first pre-switching automotive component; wherein, different production line numbers correspond to different first pre-switching automotive components.
[0009] As an improvement to the above scheme, the coding data includes: component type, vehicle model code, and switching reference part drawing number; the step of matching multiple sets of production data corresponding to the pre-switched vehicle component in a preset quota database based on the coding data of the pre-switched vehicle component includes:
[0010] The component types of the pre-switched automotive components are classified.
[0011] When the category of component type is chassis, the combination of vehicle model code and switching reference part drawing number of the chassis category coding data is matched in the preset quota database to obtain multiple sets of production data corresponding to the chassis category coding data.
[0012] When the component category is cab assembly, the system matches the vehicle model code of the cab assembly category in the preset quota database to obtain several planned data corresponding to the vehicle model code of the cab assembly category. Then, based on the switching reference part drawing number of the cab assembly category, the system matches the several planned data corresponding to the vehicle model code of the cab assembly category to obtain multiple sets of production data corresponding to the coded data of the cab assembly category.
[0013] As an improvement to the above scheme, the step of selecting the production data corresponding to the smallest production date and the smallest number of planned items from among several production data corresponding to each production line number, based on the production line number, production scheduling date, and number of planned items in each group of production data, as the production data for the first pre-switching automotive component, includes:
[0014] Based on the production line number, scheduling date, and number of planned items for each set of production data, the minimum scheduling date corresponding to each production line number is determined to be the same day for several production data corresponding to each production line number.
[0015] If the minimum production scheduling date corresponding to each production line number is the same, then in the production data corresponding to each production line number, the production data corresponding to the smallest number of planned items is selected as the first production data for switching automotive parts;
[0016] If the minimum production schedule date corresponding to each production line number is different, then in the production data corresponding to each production line number, filter the production data of the day with the minimum production schedule date, and select the production data corresponding to the day with the minimum number of planned items as the first production data for switching automotive parts.
[0017] As an improvement to the above scheme, the production data further includes: production code; after selecting the production data corresponding to the smallest scheduling date and the smallest number of planned items as the production data for the first pre-switching automotive component, it also includes:
[0018] The production data corresponding to the production line number of the first pre-switched automotive component is marked, and the selection operation of the first pre-switched automotive component is stopped on the marked production data;
[0019] After the production data corresponding to all production line numbers is labeled, the production code of the first pre-switching automotive component corresponding to each production line number is transmitted to the control terminal, so that the control terminal can retrieve the production data corresponding to the received production code and perform material allocation control of the pre-switching automotive component based on the retrieved production data.
[0020] As an improvement to the above solution, the preset quota database performs data cleaning on the coding data and production data of each planned automobile part, including:
[0021] The preset quota database performs a superposition calculation on the vehicle model code value and the switching reference part drawing number value of each planned production vehicle part, and judges the superposition calculation result.
[0022] When the result of the superposition operation is greater than a preset value, the preset quota database stores the coding data and production data of the planned production of the automobile parts corresponding to the superposition operation result being greater than the preset value;
[0023] When the result of the superposition operation is less than a preset value or is empty, the preset quota database deletes the coding data and production data of the planned production of automobile parts corresponding to the superposition operation result being less than the preset value or being empty.
[0024] Accordingly, one embodiment of the present invention also provides a selection device for pre-switching automotive components, including: a data acquisition module, a data matching module, and a data filtering module;
[0025] The data acquisition module is used to acquire the coded data of the pre-switched automotive components;
[0026] The data matching module is used to match multiple sets of production data corresponding to the pre-switched automotive parts in a preset quota database based on the coding data of the pre-switched automotive parts; wherein, the preset quota database includes the coding data and production data of each planned automotive part; the production data includes: production line number, production scheduling date, and number of planned items;
[0027] The data filtering module is used to select the production data with the smallest production date and the smallest number of planned items from the production data corresponding to each production line number, based on the production line number, production scheduling date and number of planned items of each group of production data; wherein, different production line numbers correspond to different first pre-switching automotive parts.
[0028] As an improvement to the above solution, the encoded data includes: component type, vehicle model code, and switching reference part drawing number; the data matching module includes: category judgment unit, chassis unit, and cab assembly unit;
[0029] The category determination unit is used to determine the category of the pre-switched automotive component;
[0030] The chassis unit is used to match the combination of vehicle model code and switching reference part drawing number in a preset quota database when the component type is chassis, based on the chassis type coding data; to obtain multiple sets of production data corresponding to the chassis type coding data.
[0031] The cab assembly unit is used to, when the component type is cab assembly, match the vehicle model code of the cab assembly type in a preset quota database to obtain several planned data corresponding to the vehicle model code of the cab assembly type, and match the switching reference part drawing number of the cab assembly type in the several planned data corresponding to the vehicle model code of the cab assembly type to obtain multiple sets of production data corresponding to the coded data of the cab assembly type.
[0032] As an improvement to the above solution, the data filtering module includes: a same-day judgment unit, a first judgment result unit, and a second judgment result unit;
[0033] The same-day judgment unit is used to determine the same-day status of the minimum production scheduling date corresponding to each production line number for several production data corresponding to each production line number, based on the production line number, scheduling date and number of planned items of each group of production data.
[0034] The first judgment result unit is used to select the production data with the smallest number of planned items as the first production data for switching automotive parts if the minimum production schedule date corresponding to each production line number is the same.
[0035] The second judgment result unit is used to, if the minimum production schedule date corresponding to each production line number is not the same, filter the production data corresponding to the minimum production schedule date in the production data corresponding to each production line number, and select the production data corresponding to the minimum number of planned items in the production data of that day as the first production data for switching automotive parts.
[0036] As an improvement to the above scheme, the production data further includes: production code; after selecting the production data corresponding to the smallest scheduling date and the smallest number of planned items as the production data for the first pre-switching automotive component, it also includes:
[0037] The production data corresponding to the production line number of the first pre-switched automotive component is marked, and the selection operation of the first pre-switched automotive component is stopped on the marked production data;
[0038] After the production data corresponding to all production line numbers is labeled, the production code of the first pre-switching automotive component corresponding to each production line number is transmitted to the control terminal, so that the control terminal can retrieve the production data corresponding to the received production code and perform material allocation control of the pre-switching automotive component based on the retrieved production data.
[0039] As an improvement to the above solution, the preset quota database performs data cleaning on the coding data and production data of each planned automobile part, including:
[0040] The preset quota database performs a superposition calculation on the vehicle model code value and the switching reference part drawing number value of each planned production vehicle part, and judges the superposition calculation result.
[0041] When the result of the superposition operation is greater than a preset value, the preset quota database stores the coding data and production data of the planned production of the automobile parts corresponding to the superposition operation result being greater than the preset value;
[0042] When the result of the superposition operation is less than a preset value or is empty, the preset quota database deletes the coding data and production data of the planned production of automobile parts corresponding to the superposition operation result being less than the preset value or being empty.
[0043] Accordingly, one embodiment of the present invention also provides a computer terminal device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor executes the computer program to implement a method for selecting pre-switching automotive components as described in the present invention.
[0044] Accordingly, one embodiment of the present invention also provides a computer-readable storage medium, the computer-readable storage medium including a stored computer program, wherein, when the computer program is executed, it controls the device where the computer-readable storage medium is located to perform a method for selecting a pre-switching automotive component as described in the present invention.
[0045] As can be seen from the above, the present invention has the following beneficial effects:
[0046] This invention provides a method for selecting the first automotive component. After obtaining the coding data of the automotive component to be switched, the coding data of the automotive component to be switched is matched with the coding data of each planned automotive component in a preset quota database to obtain multiple sets of production data corresponding to the automotive component to be switched. Among the production data corresponding to each production line number, the production data corresponding to the smallest scheduling date and the smallest number of planned items is selected as the first automotive component to be switched, thereby finding the first automotive component to be switched for each production line. This method facilitates the rapid search of the first automotive component to be switched for each production line, which is beneficial for the physical allocation control of the switchover work in advance. Compared with manual inspection, this invention matches the production data of planned automotive components with the coding data of the automotive component to be switched, and automatically locks the first automotive component to be switched based on the production line number, scheduling date, and number of planned items. This is beneficial for improving the accuracy and efficiency of the automotive component switchover on the production line. Attached Figure Description
[0047] Figure 1 This is a flowchart illustrating a method for selecting pre-switched automotive components according to an embodiment of the present invention.
[0048] Figure 2 This is a schematic diagram of the structure of a pre-switching automotive component selection device provided in an embodiment of the present invention;
[0049] Figure 3 This is a schematic diagram illustrating the marking of the minimum production scheduling date being the same among several production data corresponding to each production line number, provided in an embodiment of the present invention;
[0050] Figure 4 This is a schematic diagram illustrating the markings when the minimum production scheduling dates among several production data corresponding to each production line number are different, according to an embodiment of the present invention.
[0051] Figure 5 This is a schematic diagram of a terminal device structure provided in an embodiment of the present invention. Detailed Implementation
[0052] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0053] Example 1
[0054] See Figure 1 , Figure 1This is a flowchart illustrating a method for selecting pre-switched automotive components according to an embodiment of the present invention, as shown below. Figure 1 As shown, this embodiment includes steps 101 to 103, and the specific steps are as follows:
[0055] Step 101: Obtain the encoding data of the pre-switched automotive components.
[0056] In this embodiment,
[0057] Step 102: Based on the coding data of the pre-switched automotive component, match multiple sets of production data corresponding to the pre-switched automotive component in a preset quota database; wherein, the preset quota database includes the coding data and production data of each planned automotive component; the production data includes: production line number, production scheduling date, and number of planned items.
[0058] In this embodiment, the encoded data includes: component type, vehicle model code, and switching reference part drawing number; the step of matching multiple sets of production data corresponding to the pre-switched vehicle component in a preset quota database based on the encoded data of the pre-switched vehicle component includes:
[0059] The component types of the pre-switched automotive components are classified.
[0060] When the category of component type is chassis, the combination of vehicle model code and switching reference part drawing number of the chassis category coding data is matched in the preset quota database to obtain multiple sets of production data corresponding to the chassis category coding data.
[0061] When the component category is cab assembly, the system matches the vehicle model code of the cab assembly category in the preset quota database to obtain several planned data corresponding to the vehicle model code of the cab assembly category. Then, based on the switching reference part drawing number of the cab assembly category, the system matches the several planned data corresponding to the vehicle model code of the cab assembly category to obtain multiple sets of production data corresponding to the coded data of the cab assembly category.
[0062] In this embodiment, the preset quota database performs data cleaning on the coding data and production data of each planned automotive component, including:
[0063] The preset quota database performs a superposition calculation on the vehicle model code value and the switching reference part drawing number value of each planned production vehicle part, and judges the superposition calculation result.
[0064] When the result of the superposition operation is greater than a preset value, the preset quota database stores the coding data and production data of the planned production of the automobile parts corresponding to the superposition operation result being greater than the preset value;
[0065] When the result of the superposition operation is less than a preset value or is empty, the preset quota database deletes the coding data and production data of the planned production of automobile parts corresponding to the superposition operation result being less than the preset value or being empty.
[0066] In a specific embodiment, in the quota database, quota data with a quantity of zero or negative (mainly production code and part drawing number, which can be used to identify a unique automobile part to be produced) are excluded as this information is meaningless for subsequent calibration processing. Then, the quota data with a quantity greater than zero in the daily quota is matched according to the production code and part drawing number, and the two quantities are added together. If the sum is greater than zero, it is retained; if it is equal to or less than zero, it is deleted.
[0067] In a specific embodiment, the relevant data for each planned production automotive component in the quota database is stored in the form of Table 1; wherein, the planned date is the production scheduling date as described in this invention, the assembly sequence is the number of planned items as described in this invention, and the assembly line is the production line number as described in this invention.
[0068]
[0069] Table 1
[0070] In one specific embodiment, production data matching is performed separately based on the different vehicle type (LB) involved in the switching project:
[0071] When category LB is chassis 1, the model code of the pre-switched vehicle part + the switching reference part drawing number is compared and searched with the model CPDM + part drawing number SUB_LJBH in the quota data;
[0072] When category LB is cab assembly 2, first find the model code (cab drawing number) of the vehicle part to be switched in the quota data table to find the cab assembly (part) SUB_LJBH involved in the switch, and then find the switching reference part drawing number in the parts involving cab assembly SUB_LJBH.
[0073] Step 103: Based on the production line number, scheduling date, and number of planned items for each set of production data, select the production data with the smallest scheduling date and the smallest number of planned items from the several production data corresponding to each production line number as the production data for the first pre-switching automotive component; wherein, different production line numbers correspond to different first pre-switching automotive components.
[0074] In a specific embodiment, this application monitors the first pre-switched automotive component by using a project switching record table (as shown in Table 2); wherein, the project number is the user-selected project related to the pre-switched automotive component, and is defined adaptively by the user; the vehicle type is the component type described in this invention; the quota effective date is the execution time of the user-selected project related to the pre-switched automotive component, and is defined by the user; the planned date for switching vehicle models is the production scheduling date described in this invention; and the production line is the production line number described in this invention.
[0075] The specific monitoring process is as follows: The project number, vehicle model code, vehicle model category, quota effective date, and switching reference part drawing number of the pre-switched automotive component in the switching project are overwritten into the project switching record table. Based on the vehicle model category, vehicle model code, and switching reference part drawing number, the production data of the planned automotive component is matched in the quota database. The matching production schedule date, production line number, and production code are then filled into the planned date, production line, and production code for the switching vehicle model, respectively. Different production data correspond to different pre-switched automotive components for the same switching project; therefore, different project switching record tables are created for the same pre-switched automotive component, forming the project switching database. By comparing the production schedule date and the number of planned items in the project switching database, the first unit on each production line is identified (if the first pre-switched component is marked on production line 1, then all project switching records are marked). The nullable of QHBZ_1 in the switching record table is Y; if the first pre-switching component is not marked in production line 1, then the nullable of QHBZ_1 in all project switching record tables is 0 (the same applies to production line 2); if there are a total of 2 production lines, and the first unit of production lines 1 and 2 is marked as completed, that is, the nullables of QHBZ_1 and QHBZ_2 are both Y, then QHBZ in all project switching record tables is Y. At this time, if the project switching record table has the earliest scheduling date and the smallest number of planned items for production line 1, then the nullable of ST in the project switching record table is marked as Y. Except for the project switching record table marked as Y, the nullable of ST in other project switching record tables related to production line 1 is 0. Table 2 involves 2 production lines, and the completion status of the first unit switching marking of multiple production lines can be controlled according to the specific production conditions.
[0076]
[0077] Table 2
[0078] In this embodiment, the step of selecting the production data corresponding to the smallest production date and the smallest number of planned items from among several production data corresponding to each production line number, based on the production line number, production scheduling date, and number of planned items in each group of production data, as the production data for the first pre-switching automotive component includes:
[0079] Based on the production line number, scheduling date, and number of planned items for each set of production data, the minimum scheduling date corresponding to each production line number is determined to be the same day for several production data corresponding to each production line number.
[0080] If the minimum production scheduling date corresponding to each production line number is the same, then in the production data corresponding to each production line number, the production data corresponding to the smallest number of planned items is selected as the first production data for switching automotive parts;
[0081] If the minimum production schedule date corresponding to each production line number is different, then in the production data corresponding to each production line number, filter the production data of the day with the minimum production schedule date, and select the production data corresponding to the day with the minimum number of planned items as the first production data for switching automotive parts.
[0082] In one specific embodiment, please refer to Figure 3 , Figure 3 A diagram illustrating the marking of the same minimum production schedule date among several production data corresponding to each production line number: If the vehicle model code + switching reference part number appears in multiple different sequences on line 1 and also in multiple different sequences on line 2, and all the production schedule dates are the same (2021 / 3 / 8), then it is only necessary to mark the minimum JHXS (planned number of items) of 49 on line 1 and the minimum JHXS of 106 on line 2 as Y in the ST of the switching item record table. The production schedule dates of the first unit on line 1 (line 1 sequence 49) and the first unit on line 2 (line 2 sequence 106) should be listed in the markings on line 1 and line 2, respectively. After marking, the completion status of marking on line 1 and marking on line 2 should be set to Y.
[0083] In one specific embodiment, please refer to Figure 4 , Figure 4 This is a diagram illustrating the marking when the minimum production scheduling dates in several production data corresponding to each production line number are different: If only Line 1 has a changeover of the first model on June 2nd, then the production scheduling date of the first model (Sequence 1 of Line 1) on Line 1 is listed in the changeover project record table, and the completion status of Line 1 is set to Y. If only Line 1 has a marking (QHBZ_1 = Y) on June 2nd, then in the production scheduling after June 2nd, the model of Line 1 will no longer be searched, but the search for the first model of Line 2 to be changed will continue. When the first model to be changed is also found in the marking of Line 2 (QHBZ_2 = Y), the one-time planned date JHRQ of the changeover model is updated to the production scheduling date of the first model of Line 2, and the marking of Line 2 QHBZ_2 is set to Y for the first model of the assembly line. At this point, the marking of the first model of the assembly line changeover is completed.
[0084] In this embodiment, the production data further includes: a production code; after selecting the production data corresponding to the smallest production scheduling date and the smallest number of planned items as the production data for the first pre-switching automotive component, it further includes:
[0085] The production data corresponding to the production line number of the first pre-switched automotive component is marked, and the selection operation of the first pre-switched automotive component is stopped on the marked production data;
[0086] After the production data corresponding to all production line numbers is labeled, the production code of the first pre-switching automotive component corresponding to each production line number is transmitted to the control terminal, so that the control terminal can retrieve the production data corresponding to the received production code and perform material allocation control of the pre-switching automotive component based on the retrieved production data.
[0087] In one specific embodiment, after finding the first pre-switching automotive component for each production line number, all production data corresponding to all production line numbers are marked as first-unit marking completed. This eliminates the need for the marked production data to participate in subsequent first-unit marking calculations, greatly reducing the software's operational burden. When all production data is marked as first-unit marking completed, it indicates that the project corresponding to the pre-switching automotive component has completed the first-unit marking for all production lines. By extracting the production code of the first pre-switching automotive component for each production line and sending it to the control terminal, the control terminal can extract the production time and materials of the corresponding first pre-switching automotive component based on the production code, and then make advance allocations.
[0088] In one specific embodiment, when the switchover project is completed, the process engineer can issue a switchover notification to the final assembly line based on the switchover project record sheet to prepare for the switchover loading.
[0089] In this embodiment, after obtaining the coding data of the pre-switched automotive components, the coding data of the pre-switched automotive components is matched with the coding data of each planned production automotive component in a preset quota database. This yields multiple sets of production data corresponding to the pre-switched automotive components. Among the production data corresponding to each production line number, the production data corresponding to the smallest scheduling date and the smallest number of planned items is selected as the first pre-switched automotive component. This allows for the rapid retrieval of the first pre-switched automotive component for each production line, facilitating the early physical allocation and control of the switchover work. Compared to manual inspection, this invention improves the accuracy and efficiency of pre-switched automotive component switching on production lines. After the daily quota plan calculation is completed, the quota data is cleaned, and the first production model of each production line terminal for the switching project is automatically marked based on the switching project data. This effectively reduces manual calculation costs and the costs associated with heavy labor positions and material backlog at the line. This method triggers calculation and marking on a timed basis and reflects the results in real time, supporting continuous optimization and improvement of the calculation model. This embodiment not only efficiently meets the needs of enterprises for synchronized production, but also effectively reduces the costs of labor, material backlog, and operation, and can be extended to other industries.
[0090] Example 2
[0091] See Figure 2 , Figure 2 This is a schematic diagram of the structure of a pre-switching automotive component selection device provided in an embodiment of the present invention, including: a data acquisition module 201, a data matching module 202, and a data filtering module 203;
[0092] The data acquisition module 201 is used to acquire the coded data of the pre-switched automotive components;
[0093] The data matching module 202 is used to match multiple sets of production data corresponding to the pre-switched automotive parts in a preset quota database based on the coding data of the pre-switched automotive parts; wherein, the preset quota database includes the coding data and production data of each planned automotive part; the production data includes: production line number, production scheduling date, and number of planned items;
[0094] The data filtering module 203 is used to select the production data with the smallest production date and the smallest number of planned items from the production data corresponding to each production line number, based on the production line number, production scheduling date and number of planned items of each group of production data; wherein, different production line numbers correspond to different first pre-switching automotive parts.
[0095] As an improvement to the above solution, the encoded data includes: component type, vehicle model code, and switching reference part drawing number; the data matching module 202 includes: category judgment unit, chassis unit, and cab assembly unit;
[0096] The category determination unit is used to determine the category of the pre-switched automotive component;
[0097] The chassis unit is used to match the combination of vehicle model code and switching reference part drawing number in a preset quota database when the component type is chassis, based on the chassis type coding data; to obtain multiple sets of production data corresponding to the chassis type coding data.
[0098] The cab assembly unit is used to, when the component type is cab assembly, match the vehicle model code of the cab assembly type in a preset quota database to obtain several planned data corresponding to the vehicle model code of the cab assembly type, and match the switching reference part drawing number of the cab assembly type in the several planned data corresponding to the vehicle model code of the cab assembly type to obtain multiple sets of production data corresponding to the coded data of the cab assembly type.
[0099] As an improvement to the above solution, the data filtering module 203 includes: a same-day judgment unit, a first judgment result unit, and a second judgment result unit;
[0100] The same-day judgment unit is used to determine the same-day status of the minimum production scheduling date corresponding to each production line number for several production data corresponding to each production line number, based on the production line number, scheduling date and number of planned items of each group of production data.
[0101] The first judgment result unit is used to select the production data with the smallest number of planned items as the first production data for switching automotive parts if the minimum production schedule date corresponding to each production line number is the same.
[0102] The second judgment result unit is used to, if the minimum production schedule date corresponding to each production line number is not the same, filter the production data corresponding to the minimum production schedule date in the production data corresponding to each production line number, and select the production data corresponding to the minimum number of planned items in the production data of that day as the first production data for switching automotive parts.
[0103] As an improvement to the above scheme, the production data further includes: production code; after selecting the production data corresponding to the smallest scheduling date and the smallest number of planned items as the production data for the first pre-switching automotive component, it also includes:
[0104] The production data corresponding to the production line number of the first pre-switched automotive component is marked, and the selection operation of the first pre-switched automotive component is stopped on the marked production data;
[0105] After the production data corresponding to all production line numbers is labeled, the production code of the first pre-switching automotive component corresponding to each production line number is transmitted to the control terminal, so that the control terminal can retrieve the production data corresponding to the received production code and perform material allocation control of the pre-switching automotive component based on the retrieved production data.
[0106] As an improvement to the above solution, the preset quota database performs data cleaning on the coding data and production data of each planned automobile part, including:
[0107] The preset quota database performs a superposition calculation on the vehicle model code value and the switching reference part drawing number value of each planned production vehicle part, and judges the superposition calculation result.
[0108] When the result of the superposition operation is greater than a preset value, the preset quota database stores the coding data and production data of the planned production of the automobile parts corresponding to the superposition operation result being greater than the preset value;
[0109] When the result of the superposition operation is less than a preset value or is empty, the preset quota database deletes the coding data and production data of the planned production of automobile parts corresponding to the superposition operation result being less than the preset value or being empty.
[0110] This embodiment acquires the coded data of the pre-switched automotive components through a data acquisition module, matches the coded data of the pre-switched automotive components with multiple sets of production data through a data matching module, and selects the first pre-switched automotive component in each set of production data on each production line through a data filtering module, thereby obtaining the production data of the first pre-switched automotive component and completing the rapid search for the first pre-switched automotive component on each production line. Compared with manual inspection, this invention matches the planned production data of automotive components with the coded data of the pre-switched automotive components, and automatically locks the first pre-switched automotive component based on the production line number, scheduling date, and number of planned items. This helps improve the accuracy and efficiency of the pre-switched automotive component switching on the production line.
[0111] Example 3
[0112] See Figure 5 , Figure 5 This is a schematic diagram of the terminal device structure provided in an embodiment of the present invention.
[0113] One terminal device in this embodiment includes: a processor 501, a memory 502, and a computer program stored in the memory 502 and executable on the processor 501. When the processor 501 executes the computer program, it implements the steps of the selection method for each of the aforementioned pre-switching automotive components in this embodiment, for example... Figure 1 All steps of the pre-switching vehicle component selection method shown. Alternatively, when the processor executes the computer program, it implements the functions of each module in the above-described device embodiments, for example: Figure 2 All modules of the pre-switching vehicle component selection device are shown.
[0114] In addition, embodiments of the present invention also provide a computer-readable storage medium, the computer-readable storage medium including a stored computer program, wherein, when the computer program is executed, it controls the device where the computer-readable storage medium is located to perform the pre-switching vehicle component selection method as described in any of the above embodiments.
[0115] Those skilled in the art will understand that the schematic diagram is merely an example of a terminal device and does not constitute a limitation on the terminal device. It may include more or fewer components than shown in the diagram, or combine certain components, or different components. For example, the terminal device may also include input / output devices, network access devices, buses, etc.
[0116] The processor 501 may be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor. The processor 501 is the control center of the terminal device, connecting various parts of the terminal device through various interfaces and lines.
[0117] The memory 502 can be used to store the computer programs and / or modules. The processor 501 implements various functions of the terminal device by running or executing the computer programs and / or modules stored in the memory and calling the data stored in the memory 502. The memory 502 may mainly include a program storage area and a data storage area. The program storage area may store the operating system, at least one application program required for a function (such as sound playback function, image playback function, etc.), etc.; the data storage area may store data created according to the use of the mobile phone (such as audio data, phonebook, etc.). In addition, the memory may include high-speed random access memory, and may also include non-volatile memory, such as hard disk, memory, plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, at least one disk storage device, flash memory device, or other volatile solid-state storage device.
[0118] Wherein, if the modules / units integrated in the terminal device are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the methods of the above embodiments of the present invention can also be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when the computer program is executed by a processor, it can implement the steps of the various method embodiments described above. Wherein, the computer program includes computer program code, which can be in the form of source code, object code, executable file, or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, portable hard drive, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal, and software distribution medium, etc.
[0119] It should be noted that the device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Furthermore, in the accompanying drawings of the device embodiments provided by this invention, the connection relationships between modules indicate that they have communication connections, which can be specifically implemented as one or more communication buses or signal lines. Those skilled in the art can understand and implement this without any creative effort.
[0120] The above description represents the preferred embodiments of the present invention. It should be noted that those skilled in the art can make various improvements and modifications without departing from the principles of the present invention, and these improvements and modifications are also considered to be within the scope of protection of the present invention.
Claims
1. A method for selecting pre-switching automotive components, characterized in that, include: Obtain the coded data of the vehicle components to be switched; Based on the coding data of the pre-switched automotive components, multiple sets of production data corresponding to the pre-switched automotive components are matched in a preset quota database; wherein, the preset quota database includes coding data and production data for each planned automotive component; the production data includes: production line number, production scheduling date, and number of planned items; the coding data includes: component type, vehicle model code, and switching reference part drawing number; the matching of multiple sets of production data corresponding to the pre-switched automotive components in the preset quota database based on the coding data of the pre-switched automotive components includes: classifying the component type of the pre-switched automotive components; in the component type When the category is chassis, the combination of vehicle model code and switching reference part drawing number of the chassis category coding data is matched in the preset quota database to obtain multiple sets of production data corresponding to the chassis category coding data; when the component category is cab assembly, the vehicle model code of the cab assembly category is matched in the preset quota database to obtain several planning data corresponding to the cab assembly category vehicle model code, and the switching reference part drawing number of the cab assembly category is matched in the several planning data corresponding to the cab assembly category vehicle model code to obtain multiple sets of production data corresponding to the cab assembly category coding data. Based on the production line number, scheduling date, and number of planned items for each set of production data, the production data with the smallest scheduling date and the smallest number of planned items is selected from the several production data corresponding to each production line number as the production data for the first pre-switching automotive component; wherein, different production line numbers correspond to different first pre-switching automotive components; the step of selecting the production data with the smallest scheduling date and the smallest number of planned items from the several production data corresponding to each production line number as the production data for the first pre-switching automotive component includes: based on the production line number, scheduling date, and number of planned items for each set of production data... For each production line number, the minimum production scheduling date corresponding to each production line number is compared with the minimum production scheduling date. If the minimum production scheduling dates are the same for each production line number, the production data with the smallest number of planned items is selected as the first production data for switching automotive parts. If the minimum production scheduling dates are different for each production line number, the production data with the smallest scheduling date is selected from the production data for that day, and the production data with the smallest number of planned items is selected as the first production data for switching automotive parts. The number of planned items includes the assembly sequence.
2. The method for selecting pre-switching automotive components according to claim 1, characterized in that, The production data also includes: production codes; after selecting the production data corresponding to the smallest production scheduling date and the smallest number of planned items as the production data for the first pre-switching automotive component, it also includes: The production data corresponding to the production line number of the first pre-switched automotive component is marked, and the selection operation of the first pre-switched automotive component is stopped on the marked production data; After the production data corresponding to all production line numbers is labeled, the production code of the first pre-switching automotive component corresponding to each production line number is transmitted to the control terminal, so that the control terminal can retrieve the production data corresponding to the received production code and perform material allocation control of the pre-switching automotive component based on the retrieved production data.
3. The method for selecting pre-switching automotive components according to claim 2, characterized in that, The preset quota database performs data cleaning on the coding data and production data of each planned automotive component, including: The preset quota database performs an overlay calculation on the vehicle model code value and the switching reference part drawing number value of each planned automotive component, and judges the overlay calculation result. When the result of the superposition operation is greater than a preset value, the preset quota database stores the coding data and production data of the planned production of the automobile parts corresponding to the superposition operation result being greater than the preset value; When the result of the superposition operation is less than a preset value or is empty, the preset quota database deletes the coding data and production data of the planned production of automobile parts corresponding to the superposition operation result being less than the preset value or being empty.
4. A selection device for pre-switching automotive components, characterized in that, include: Data acquisition module, data matching module, and data filtering module; The data acquisition module is used to acquire the coded data of the pre-switched automotive components; The data matching module is used to match multiple sets of production data corresponding to the pre-switched automotive component in a preset quota database based on the coding data of the pre-switched automotive component. The preset quota database includes coding data and production data for each planned automotive component. The production data includes: production line number, production date, and number of planned items. The coding data includes: component type, vehicle model code, and switching reference part drawing number. The data matching module includes: a category judgment unit, a chassis unit, and a cab assembly unit. The category judgment unit is used to perform category judgment on the component type of the pre-switched automotive component. The chassis unit is used to determine the category of the component type. When the component is a chassis, the system matches the combination of the vehicle model code and the switching reference part drawing number in the chassis coding data with a preset quota database to obtain multiple sets of production data corresponding to the chassis coding data. The cab assembly unit, when the component type is cab assembly, matches the vehicle model code of the cab assembly with a preset quota database to obtain several sets of plan data corresponding to the cab assembly vehicle model code, and matches the switching reference part drawing number of the cab assembly with the several sets of plan data corresponding to the cab assembly vehicle model code to obtain multiple sets of production data corresponding to the cab assembly coding data. The data filtering module is used to select the production data with the smallest production date and the smallest number of planned items from the several production data corresponding to each production line number, based on the production line number, production scheduling date, and number of planned items for each group of production data. Different production line numbers correspond to different first pre-switching automotive parts. The data filtering module includes: a same-day judgment unit, a first judgment result unit, and a second judgment result unit. The same-day judgment unit is used to perform a process for each production line number on the several production data corresponding to each production line number, based on the production line number, production scheduling date, and number of planned items for each group of production data. The first judgment result unit is used to determine if the minimum production schedule date corresponding to each production line number is the same, and select the production data with the smallest number of planned items from the production data corresponding to each production line number as the first production data for switching automotive parts; the second judgment result unit is used to filter the production data of the day with the smallest production schedule date from the production data corresponding to each production line number if the minimum production schedule date corresponding to each production line number is different, and select the production data with the smallest number of planned items from the production data of the day as the first production data for switching automotive parts; the number of planned items includes: assembly sequence.
5. A computer terminal device, characterized in that, It includes a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, wherein the processor executes the computer program to implement a method for selecting a pre-switching automotive component as described in any one of claims 1 to 3.
6. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored computer program, wherein, when the computer program is executed, it controls the device on which the computer-readable storage medium is located to perform a method for selecting a pre-switching automotive component as described in any one of claims 1 to 3.