Data processing method and device, computer equipment and storage medium

Abstract

The invention belongs to the technical field of data processing, and relates to a data processing method and device, computer equipment and a storage medium, and the method comprises the steps: receiving a specified shared file from a main interface, and reading position information containing material information from the specified shared file based on a reading interface; receiving a target bill of material code based on the input interface; based on the position information, searching all target material information corresponding to the target material list code through a query interface; if a display instruction is received, performing display processing on the target material information based on the viewing interface; if a calculation instruction is received, performing price calculation on the target material information based on a calculation strategy to obtain price information; and if an export instruction is received, generating a target file based on the target material information and the price information and exporting the target file. The data query efficiency of the target material information can be improved, and the processing efficiency of price calculation can be improved.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to data processing methods, apparatus, computer equipment and storage media. Background Technology

[0002] In the realm of daily corporate management, data processing related to material cost accounting plays a crucial role, as its accuracy directly impacts core operational indicators such as product pricing, cost control, and corporate profits. With rapid technological advancements, various industries are placing increasingly stringent demands on data accuracy and work efficiency. However, currently, the vast majority of companies still manually calculate product material costs using Excel. This method requires manual extraction of material information and cost calculation, resulting in low processing efficiency and failing to meet the needs of modern enterprises for rapid decision-making and efficient operation, thus affecting the effectiveness of cost control and market competitiveness.

[0003] Therefore, there is an urgent need for an efficient data processing method related to material cost accounting to solve the problem of low processing efficiency in the existing material cost accounting methods. Summary of the Invention

[0004] The purpose of this application is to provide a data processing method, apparatus, computer equipment, and storage medium to solve the technical problem of low processing efficiency in existing material cost accounting methods.

[0005] Firstly, a data processing method is provided, including: Receive a specified shared file from the preset main interface, and read the location information containing material information from the specified shared file based on the preset reading interface; Receive the target bill of materials code based on the preset input interface; Based on the location information, all target material information corresponding to the target bill of materials code is retrieved through a preset query interface; If a display instruction for the target material information is received from the preset viewing interface, the target material information is displayed based on the preset viewing interface. If a calculation instruction for the target material information is received, the price of the target material information is calculated based on a preset calculation strategy to obtain the corresponding price information; If an export instruction is received, a corresponding target file is generated based on the target material information and the price information, and the target file is exported.

[0006] Secondly, a data processing apparatus is provided, comprising: A first processing module for receiving a specified shared file from a preset main interface and reading location information containing material information from the specified shared file based on a preset reading interface; A receiving module for receiving target bill of materials codes based on a preset input interface; A search module for finding all target material information corresponding to the target bill of materials code based on the location information through a preset query interface; A display module for displaying the target material information based on a preset viewing interface if a display instruction for the target material information is received from a preset viewing interface. A calculation module for performing price calculations on the target material information based on a preset calculation strategy to obtain the corresponding price information if a calculation instruction for the target material information is received. A second processing module is used to generate a corresponding target file based on the target material information and the price information, and to export the target file if an export instruction is received.

[0007] Thirdly, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the above-described data processing method.

[0008] Fourthly, a computer-readable storage medium is provided, which stores a computer program that, when executed by a processor, implements the steps of the above-described data processing method.

[0009] Fifthly, embodiments of this application provide a computer program product that, when run on a terminal device, causes the terminal device to execute the method described in any one of the first aspects.

[0010] In the above-described data processing method, apparatus, computer equipment, and storage medium, the following steps are implemented: First, a specified shared file is received from a preset main interface, and location information containing material information is read from the specified shared file based on a preset reading interface. Then, a target bill of materials code is received based on a preset input interface. Next, based on the location information, all target material information corresponding to the target bill of materials code is found through a preset query interface. If a display instruction for the target material information is received from a preset viewing interface, the target material information is displayed based on the preset viewing interface. If a calculation instruction for the target material information is received, a price calculation is performed on the target material information based on a preset calculation strategy to obtain the corresponding price information. If an export instruction is received, a corresponding target file is generated based on the target material information and the price information, and the target file is exported. Unlike existing manual processing methods, this application improves the data query efficiency of target material information by using pre-reading of location information containing material information to find all target material information corresponding to the received target bill of materials code. Furthermore, the price calculation processing for the target material information is automatically executed based on the use of the calculation strategy, thereby effectively improving the processing efficiency of price calculation. Attached Figure Description

[0011] To more clearly illustrate the solutions in this application, the accompanying drawings used in the description of the embodiments of this application will be briefly introduced below. Obviously, the accompanying drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0012] Figure 1 This is an exemplary system architecture diagram to which this application can be applied; Figure 2 This is a flowchart of an embodiment of the data processing method according to this application; Figure 3 This is a schematic diagram of the structure of an embodiment of the data processing apparatus according to this application; Figure 4 This is a schematic diagram of the structure of one embodiment of the computer device according to this application. Detailed Implementation

[0013] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application pertains; the terminology used herein in the specification of the application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having," and any variations thereof, in the specification, claims, and foregoing drawings of this application, are intended to cover non-exclusive inclusion. The terms "first," "second," etc., in the specification, claims, or foregoing drawings of this application are used to distinguish different objects, not to describe a particular order.

[0014] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0015] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings.

[0016] like Figure 1 As shown, system architecture 100 may include terminal device 101, network 102, and server 103. Terminal device 101 may be a laptop 1011, tablet 1012, or mobile phone 1013. Network 102 is used as a medium to provide a communication link between terminal device 101 and server 103. Network 102 may include various connection types, such as wired, wireless communication links, or fiber optic cables, etc.

[0017] Users can use terminal device 101 to interact with server 103 via network 102 to receive or send messages, etc. Various communication client applications can be installed on terminal device 101, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social media platform software, etc.

[0018] Terminal device 101 can be various electronic devices with a display screen and support web browsing. In addition to laptops 1011, tablets 1012, or mobile phones 1013, terminal device 101 can also be an e-book reader, an MP3 player (Moving Picture Experts Group Audio Layer III), an MP4 player (Moving Picture Experts Group Audio Layer IV), a laptop computer, and a desktop computer, etc.

[0019] Server 103 can be a server that provides various services, such as a backend server that provides support for the pages displayed on terminal device 101.

[0020] It should be noted that the data processing method provided in the embodiments of this application is generally executed by a server / terminal device, and correspondingly, the data processing device is generally located in the server / terminal device.

[0021] It should be understood that Figure 1 The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0022] Continue to refer to Figure 2 A flowchart illustrating an embodiment of the data processing method according to this application is shown. The order of steps in the flowchart can be changed, and some steps can be omitted, depending on different needs. The data processing method provided by this application embodiment can be applied to any scenario requiring data processing, and therefore can be applied to products in these scenarios. The data processing method includes the following steps: Step S201: Receive a specified shared file from the preset main interface, and read the location information containing material information from the specified shared file based on the preset reading interface.

[0023] In this embodiment, the data processing method runs on an electronic device (e.g., Figure 1The server / terminal device shown can obtain location information containing material information via wired or wireless connection. It should be noted that the aforementioned wireless connection methods may include, but are not limited to, 3G / 4G / 5G connections, WiFi connections, Bluetooth connections, WiMAX connections, Zigbee connections, UWB (ultra-wideband) connections, and other currently known or future-developed wireless connection methods. The implementing entity of this application is specifically a data processing system, also known as a query system, which can be simply referred to as the system. This application, based on the existing data storage model, develops a corresponding query system to achieve rapid querying of detailed material lists and prices. Through coded search and hierarchical extraction, users can quickly obtain detailed information such as specifications, models, prices, and quantities of the required materials, thereby providing strong support for procurement decisions and cost control.

[0024] After the system starts, locate the interface on the main interface that triggers the system to retrieve the shared file path and click it. A window or prompt will then appear, asking the user to enter the path to the shared folder. The user needs to accurately enter the shared folder's path on the network, such as "\server name\shared folder name". After entering the path, the system will attempt to connect to the specified shared folder and check if the current system has access permissions. If the connection is successful, the system can access the files in the shared folder normally; if the connection fails, the system will provide a corresponding error message, such as "Unable to access shared file, please check network connection or permission settings." The user needs to check the network connection, the shared folder's permission settings, etc., according to the prompts until successful access is achieved.

[0025] Because material information is typically stored in files within a shared folder, the software must have normal access to the shared folder to obtain the data source storing the material information. If access is unavailable, subsequent operations such as retrieving the data source location information and querying material information for specific bill of materials codes will be impossible.

[0026] BOM, short for Bill of Material, is a detailed list of all parts, components, and raw materials required to make up the final product, along with their quantities. It serves as the cornerstone for product cost calculation, procurement planning, and production scheduling. In manufacturing, the BOM plays a crucial role. It not only guides the purchasing department to place accurate orders, avoiding over-purchasing or shortages and ensuring a smooth supply chain, but also serves as the basis for production planning and scheduling, helping to optimize production processes and reduce waste. Furthermore, the BOM is an important reference for quality control, ensuring that the correct materials and specifications are used at every step.

[0027] In addition, after confirming successful access to the specified shared file, the system will trigger an interface to read the corresponding path and file location containing material information. A pop-up window or prompt will then ask the user to specify the shared file to be accessed. The user needs to select the specified shared files that have been configured in the background; these files typically contain information related to sub-material BOMs. Based on the user's selection, the system will read all location information containing sub-material BOMs from these files and store this information in the software's cache. This process only needs to be performed once when the software is opened. Subsequent queries for material information with different BOM codes can directly retrieve this location information from the cache without repeating the process. This step prepares the data for subsequent queries of material information with specific BOM codes. By reading and storing all location information containing sub-material BOMs, the system can clearly identify from which locations the required material data is obtained, facilitating the rapid and accurate retrieval of specific material information.

[0028] Step S202: Receive the target bill of materials code based on the preset input interface.

[0029] In this embodiment, by finding the input interface for the BOM code to be quoted on the main interface of the system, the user can accurately input the BOM code (target bill of materials code) to be quoted into the input interface according to the type of the corresponding code.

[0030] Step S203: Based on the location information, retrieve all target material information corresponding to the target bill of materials code through a preset query interface.

[0031] In this embodiment, the specific implementation process of finding all target material information corresponding to the target bill of materials code based on location information through a preset query interface will be described in more detail in subsequent specific embodiments of this application, and will not be elaborated on here.

[0032] Step S204: If a display instruction for target material information is received from a preset viewing interface, the target material information is displayed based on the preset viewing interface.

[0033] In this embodiment, after completing the query operation for the target material information, clicking the "View Query Results" interface will switch the system to a viewing interface for detailed BOM material information and price calculation. On this viewing interface, all material information in the current BOM is displayed clearly and intuitively, for example, in a table format. The table includes columns such as material name, specifications, model, and quantity. Users can scroll through the table or use the navigation buttons on the interface to view all material information and understand the detailed composition of the queried material. The step of displaying the target material information allows users to intuitively understand the detailed composition of the queried material, providing basic information for subsequent price calculation and data export. Just like viewing a product list, users can clearly see which sub-materials the material consists of and the relevant attributes of each sub-material, thereby enabling better cost analysis and decision-making.

[0034] Step S205: If a calculation instruction for target material information is received, the price of the target material information is calculated based on a preset calculation strategy to obtain the corresponding price information.

[0035] In this embodiment, after viewing the material information, clicking the "Calculate Total Price" button triggers a calculation instruction for the target material information. The system then calculates the cost level by level from low to high according to the hierarchical order of the sub-codes to obtain the price information corresponding to the target material information. For example, for a product containing multiple sub-components, the system first calculates the cost of each sub-component, then calculates the cost of the higher-level component based on the combination relationship of the sub-components, and finally synthesizes the total price of the material.

[0036] The specific implementation process of calculating the price of the target material information based on the preset calculation strategy to obtain the corresponding price information will be further described in detail in the subsequent specific embodiments of this application, and will not be elaborated on here.

[0037] Step S206: If an export instruction is received, a corresponding target file is generated based on the target material information and price information, and the target file is exported.

[0038] In this embodiment, an export button can be pre-set in the system. Clicking this export button can trigger an export command for the aforementioned target material information and price information. The specific implementation process of generating the corresponding target file based on the target material information and price information will be described in further detail in subsequent embodiments of this application, and will not be elaborated upon here.

[0039] In addition, the system provides an export function, allowing the generated target file to be exported to a local computer or a specified network location, ensuring the stability and reliability of the export process and preventing file corruption or data loss. Furthermore, it provides feedback information upon successful export, including the exported file path and filename. If any problems or errors occur during the export process, they are promptly reported to the relevant users and solutions are provided. This enables the export of target files containing target material information and price information. This process ensures the accuracy, completeness, and readability of the data, facilitating subsequent data processing and analysis for users.

[0040] Based on the above automated processing flow, this application receives a specified shared file from a preset main interface, reads the location information containing material information from the specified shared file based on a preset reading interface, then receives the target bill of materials code based on a preset input interface, and then, based on the location information, finds all target material information corresponding to the target bill of materials code through a preset query interface. If a display instruction for the target material information is received from a preset viewing interface, the target material information is displayed based on the preset viewing interface. Furthermore, if a calculation instruction for the target material information is received, the price information is calculated based on a preset calculation strategy to obtain the corresponding price information. Finally, if an export instruction is received, a target file is generated based on the target material information and price information, and the target file is exported. Thus, unlike existing manual processing methods, this application improves the data query efficiency of target material information by pre-reading the location information containing material information to find all target material information corresponding to the received target bill of materials code. Furthermore, it automatically performs price calculation processing for the target material information based on the calculation strategy, improving the processing efficiency and accuracy of price calculation, and enhancing the data accuracy of the subsequently exported target file.

[0041] In some alternative implementations, step S203 includes the following steps: Retrieves the code type corresponding to the preset bill of materials code.

[0042] In this embodiment, a standard form of Bill of Materials (BOM) code is pre-built according to actual business needs. For example, the BOM code is a specific format composed of numbers and letters, such as "BOM-2024001", which may contain specific prefixes, separators and number sequences.

[0043] Obtain the format specification corresponding to the encoding type.

[0044] In this embodiment, the above format specifications may include: Prefix: a fixed character (e.g., BOM-) to identify the type; Year / Version: a 4-digit number (e.g., 2024) or version number (e.g., V1.0); Serial Number: a 3-6 digit or letter combination (e.g., 001, A001); Separator: a hyphen (-) or underscore (_) is used uniformly. Example format: BOM-2024-001 (prefix + year + serial number), BOM-PC-V2.0 (prefix + product type + version).

[0045] The format specification is used to validate the format of the target bill of materials code.

[0046] In this embodiment, format validation is performed immediately after the user inputs each character of the bill of materials code. Validation rules are as follows: Prefix check: must start with BOM- (case-insensitive); Separator validation: check if the hyphen position is correct (e.g., BOM_2024_001 should prompt an error); Length limit: total length not exceeding 15 characters (adjusted according to rules); Character type: only numbers are allowed in the serial number part (or letters are allowed according to rules).

[0047] If the target bill of materials code passes the format validation, then based on the location information, the query interface will be used to find all target material information corresponding to the target bill of materials code.

[0048] In this embodiment, after the target bill of materials code passes format verification, a query interface is found on the system interface to trigger the software to query the BOM code. This query interface is usually a button, which may have words such as "Query" or "Search". By clicking this button, the system receives the query instruction and, based on the location information of the previously obtained BOM data source, begins searching for all sub-material information under the specified BOM code (the aforementioned target bill of materials code) in the specified shared file. This process is similar to finding the specific location of a book in a library by its title; the software searches for matching records one by one in the file storing the material information. During the query process, the system interface displays a query progress bar or prompts to let the user know the progress of the query. The progress bar can intuitively show the completion percentage of the query, and the prompts may inform the user of the current operation, such as "Reading file data" or "Matching BOM code".

[0049] Additionally, if the target BOM code fails format validation, a pop-up message box can be displayed explaining the error type (e.g., "Code BOM-2024-000 is invalid: Serial number cannot be 000") to guide the user in quickly correcting the format error until an accurate BOM code is obtained. Alternatively, the system may have automatic solutions for different error types. For example, for errors with missing prefixes, solutions might include automatic prefix completion (e.g., prompting "Is this BOM-2024-001?" when the user enters 2024-001); for errors with garbled formatting, solutions might include providing a "Format Correction" button to adjust separators and case (e.g., bom2024001 → BOM-2024-001); and for errors with non-existent codes, solutions might include displaying similar code suggestions (e.g., "Do you want to query BOM-2023-001?"). In addition, the system can also provide help and support functions: a "?" icon is added next to the input box. Clicking it will display an animated demonstration of the formatting rules and provide a "Still have problems? Contact IT support" link, which will automatically include the current input content to guide users to quickly correct the formatting errors in the target bill of materials code through suggestions and help until the target bill of materials code is formatted correctly.

[0050] In addition, triggering the query is a crucial step in obtaining detailed material information. This operation allows the extraction of relevant data for the required materials from the data source. Only after completing this step can users obtain detailed information such as specifications and models of sub-materials under a specified BOM code, providing a basis for subsequent price calculations and cost analysis. A query progress bar and prompts allow users to understand the query's progress, preventing anxiety caused by long waiting times.

[0051] This application obtains the code type corresponding to a preset bill of materials (BOM) code; then obtains the format specification corresponding to the code type; the format specification is used to perform format validation on the target BOM code; if the target BOM code passes the format validation, then based on location information, all target material information corresponding to the target BOM code is retrieved through a query interface. Based on the above processing flow, this application obtains the code type corresponding to a preset BOM code and the format specification corresponding to the code type, then performs format validation on the target BOM code based on the format specification, and if the target BOM code passes the format validation, then based on location information, all target material information corresponding to the target BOM code is retrieved through a query interface, thereby achieving efficient and accurate retrieval of all target material information corresponding to the target BOM code, improving the query efficiency of target material information.

[0052] In some optional implementations of this embodiment, step S205 includes the following steps: Obtain the hierarchical relationship corresponding to the target material information, and obtain the unit price information corresponding to the target material information.

[0053] In this embodiment, the Bill of Materials (BOM) is stored in a tree structure, where each node represents a material and includes information such as material code, name, quantity, unit cost, and pointers or references to its child materials. Furthermore, the materials in the BOM are organized hierarchically, from the lowest level (e.g., raw materials, components) to the highest level (e.g., finished products, semi-finished products).

[0054] Specifically, the hierarchical relationship can be obtained by querying the target material information. Furthermore, for each sub-material contained in the target material information, the quantity of sub-materials and the unit cost (cost information) of the sub-materials can be calculated.

[0055] Anomaly detection and handling are performed during the process of obtaining unit price information.

[0056] In this embodiment, during the process of acquiring the unit price information corresponding to the aforementioned target material information, the system will also intelligently identify any anomalies related to the absence of unit price during the unit price information query process. Specifically, it will identify whether the target material information has an anomaly of no unit price (empty unit price) and generate corresponding anomaly identification results. Specifically, the system pre-sets a series of integrity rules for material information. For the key field of unit price, it stipulates that it cannot be empty (i.e., it must have a specific numerical value). During the process of acquiring material information, the system automatically checks the unit price field in each piece of material information. If it finds that the unit price field of a certain piece of material information is empty, the system will determine that the material information has an anomaly of no unit price. The anomaly identification results may include whether the process of acquiring unit price information is abnormal or not. Specifically, if an anomaly of no unit price is detected in the target material information, a first anomaly identification result indicating an abnormal acquisition process of unit price information is generated. If an anomaly of no unit price is detected in the target material information, a second anomaly identification result indicating that the acquisition process of unit price information is not abnormal is generated.

[0057] If there are no abnormalities in the process of obtaining unit price information, then the preset price calculation method is obtained.

[0058] In this embodiment, the price calculation method described above refers to the strategy for calculating the total cost of the target material corresponding to the aforementioned target material information. The strategy includes: starting from the lowest level: the system first locates the lowest-level materials in the BOM. These materials typically have no sub-materials and form the basis for cost calculation. Calculating upwards level by level: for each upper-level material, the system calculates the total cost of that material based on the number of its sub-materials and the unit cost of those sub-materials. This process is performed recursively or iteratively according to relevant algorithms until the top level of the BOM (finished product) is reached. Accumulating costs: during the calculation process, the system accumulates the cost of each material to ultimately obtain the total cost of the finished product.

[0059] The choice of algorithm can be either recursive or iterative. Recursive algorithms are suitable for deep BOM hierarchies and relatively simple structures. They can intuitively simulate the hierarchical structure of the BOM, but may face the risk of stack overflow (for very deep BOMs). Iterative algorithms use data structures such as stacks or queues to simulate the recursive process, and are suitable for deep or complex BOM hierarchies. They can avoid stack overflow issues, but may be slightly more complex to implement.

[0060] Based on hierarchical relationships and unit price information, the target material information is calculated level by level using price calculation methods to obtain the corresponding calculation results.

[0061] In this embodiment, based on the obtained hierarchical relationship and unit price information, the target material information is calculated step by step upwards using the calculation strategy corresponding to the above price calculation method, and the obtained calculation result is used as the total price (total cost) of the cost corresponding to the target material information, i.e., price information.

[0062] The following example illustrates the process of calculating the price information for product A: Assume there is a simple BOM structure for producing a finished product "Product A", with the following structure: Product A (top layer, finished product); Component B (middle layer, semi-finished product, quantity: 2); Part C (bottom layer, raw material, quantity: 3, unit cost: 10 yuan); Part D (bottom layer, raw material, quantity: 1, unit cost: 20 yuan). Component E (Middle layer, semi-finished product, quantity: 1); Part F (bottom layer, raw material, quantity: 2, unit cost: 15 yuan).

[0063] The calculation process for the price information of Product A includes: 1. Calculate the cost of component B: The total cost of part C is: 3 (quantity) × 10 (unit cost) = 30 yuan; The total cost of part D: 1 (quantity) × 20 (unit cost) = 20 yuan; The total cost of component B is: 30 (total cost of component C) + 20 (total cost of component D) = 50 yuan; 2. Calculate the cost of component E: The total cost of part F is: 2 (quantity) × 15 (unit cost) = 30 yuan; Total cost of component E: 30 yuan (because component E only includes part F); 3. Calculate the total cost (price information) of product A: Total cost of component B (part of product A): 2 (quantity) × 50 (unit cost of component B, which is its total cost here, because component B is only calculated once in product A for its overall cost, but considering the quantity, it needs to be multiplied by 2) = 100 yuan (Note: This statement is for the purpose of explaining the calculation process. In fact, the cost of component B is directly calculated by multiplying its total cost by the quantity when calculating the cost of product A).

[0064] A more accurate statement: The total contribution cost of component B in product A = Total cost of component B × Quantity of component B in product A = 50 × 2 = 100 yuan.

[0065] Total cost of component E (part of product A): 1 (quantity) × 30 (total cost of component E) = 30 yuan.

[0066] Total cost of product A: 100 (total contribution cost of component B) + 30 (total contribution cost of component E) = 130 yuan.

[0067] The calculation results will be used as price information.

[0068] In this embodiment, calculating the total price is a crucial step in the entire query process. It derives the total cost of a material based on its hierarchical structure and unit price information. Simultaneously, the anomaly detection function helps ensure the accuracy of the price data. By calculating costs at each level and identifying anomalies, the software can provide accurate and reliable total price information, offering strong support for enterprise procurement decisions and cost control.

[0069] This application obtains the hierarchical relationship and unit price information corresponding to the target material information; then, it performs anomaly detection processing on the unit price information acquisition process; if no anomalies are detected in the unit price information acquisition process, it obtains a preset price calculation method; subsequently, based on the hierarchical relationship and unit price information, it performs a step-by-step upward calculation on the target material information using the price calculation method to obtain the corresponding calculation result; and finally, it uses the calculation result as the price information. Based on the above processing flow, this application obtains the hierarchical relationship and unit price information corresponding to the target material information, and performs anomaly detection processing on the unit price information acquisition process. If no anomalies are detected in the unit price information acquisition process, it performs a step-by-step upward calculation on the target material information using the price calculation method based on the hierarchical relationship and unit price information, and uses the obtained calculation result as the price information corresponding to the target material information. This enables automatic and accurate price calculation processing for target material information, improves the efficiency of price calculation processing, and ensures the accuracy of the obtained price information.

[0070] In some alternative implementations, after the step of anomaly detection and handling in the process of obtaining unit price information, the following steps are also included: If there is an anomaly in the process of obtaining unit price information, then obtain the anomaly information identified in the process of obtaining unit price information.

[0071] In this embodiment, during the process of obtaining the unit price information corresponding to the above-mentioned target material information, the system will also intelligently identify the absence of unit price anomalies during the process of querying unit price information. If an anomaly of absence of unit price is identified, the system will automatically extract the absence of unit price anomaly information of the corresponding sub-material.

[0072] Generate error message corresponding to the error information.

[0073] In this embodiment, the content of the above-mentioned abnormal prompt information can be set according to actual business needs, for example, it may include: "There are materials without unit price, please check the data".

[0074] Identify the area with abnormal information in the viewing interface.

[0075] In this embodiment, the aforementioned abnormal information area is a pre-built area on the aforementioned viewing interface used to present abnormal situations.

[0076] The abnormal information and abnormal prompts are displayed and processed within the abnormal information area.

[0077] In this embodiment, the above-mentioned abnormal information and abnormal prompt information can be input into the above-mentioned abnormal information area, and the above-mentioned abnormal information and abnormal prompt information can be marked with different colors or fonts so that relevant users can quickly discover them.

[0078] If anomalies such as missing unit prices occur, users need to handle the anomaly information according to the anomaly prompts displayed on the system interface. For example, if a sub-material lacks unit price information, the user needs to contact the purchasing department or relevant data provider to obtain the accurate unit price of that sub-material and update it in the data source. After the update is complete, the user can click the "Calculate Total Price" button again, and the software will recalculate costs and identify anomalies. Only after all anomalies are cleared will the software allow the next export operation. This process ensures the accuracy and completeness of the exported data, preventing erroneous prices from being carried over to the next stage, proactively intercepting anomalies from a mistake-proofing perspective. By requiring users to handle anomalies, it ensures that the final exported data is accurate and reliable, providing a correct basis for enterprise decision-making and reducing losses caused by data errors.

[0079] If this application detects an anomaly in the process of acquiring unit price information, it acquires the anomaly information identified during the acquisition process; then, it generates an anomaly prompt message corresponding to the anomaly information; subsequently, it identifies the anomaly information area in the viewing interface; and then displays the anomaly information and the anomaly prompt message within the anomaly information area. Based on the above processing flow, if this application detects an anomaly in the process of acquiring unit price information, it acquires the anomaly information identified during the acquisition process, generates anomaly prompt message corresponding to the anomaly information, and then displays the anomaly information and the anomaly prompt message within the anomaly information area to provide intelligent anomaly reminders to relevant users so that they can quickly discover the anomaly, thereby helping to ensure the accuracy of the subsequently generated price information.

[0080] In some alternative implementations, step S206 includes the following steps: Perform integrity checks on the target material information and price information.

[0081] In this embodiment, before exporting the target file, it is ensured that all target material information (including material code, name, quantity, unit cost, etc.) and the calculated total price (price information) are accurately prepared. Integrity verification includes checking for any abnormal information or errors that need to be addressed, ensuring that the exported data is clean and accurate.

[0082] If the verification passes, the preset organization policy is obtained.

[0083] In this embodiment, when performing integrity checks on the target material information and price information, if both the target material information and price information pass the integrity check, a preset organization strategy will be obtained. The organization strategy includes: organizing the target material information and price information according to a predetermined format to ensure the logic and coherence of the data, and sorting, filtering or grouping the data to better display it in an Excel document.

[0084] In addition, if the target material information and price information fail the integrity check, or if there are missing material information, missing price information, or incorrect total price calculations, the target material information and price information will be corrected according to the preset processing strategy. Then, a data integrity check will be performed again to confirm that all material information and prices are accurate and error-free. Specifically, the processing strategy includes a material information missing handling strategy and a price information missing or error handling strategy. The material information missing handling strategy includes: 1) For missing material codes. Search and supplement: First, search for the corresponding code of the material in the company's internal material management system, purchase orders, inventory records, and other relevant documents. You can search and match by key information such as the material name, specifications, and supplier. Manual entry: If it cannot be found in the existing system, contact the department responsible for material management (such as the purchasing department or warehousing department) to obtain the accurate material code and manually enter it into the data. Establish temporary coding rules: If the situation is urgent and a formal code cannot be obtained in time, a temporary code can be generated for the material according to the company's preset temporary coding rules, and the situation should be explained in the remarks. It can be updated and replaced later. 2) For missing material names: Refer to similar materials: Check other similar material names and, considering their purpose and characteristics, deduce the possible material name. Consult relevant personnel: Consult with personnel familiar with the material (such as purchasing or production personnel) to obtain the accurate material name and complete it. 3) For missing quantities: Verify inventory records: If it is inventory material, check the inventory quantity records in the inventory management system and add the accurate quantity to the data. Check purchasing or production documents: For newly purchased or produced materials, check purchase orders, production work orders, and other relevant documents to determine and enter the quantity. Estimate: When an accurate quantity cannot be obtained and the situation is urgent, a reasonable estimate can be made based on historical data and business experience. However, the basis and circumstances of the estimate should be explained in the remarks, and the accurate quantity should be verified and updated as soon as possible.

[0085] Strategies for handling missing or incorrect price information include: 1) Missing unit cost. Cost accounting: Recalculate the cost based on the material's purchase price, transportation costs, tariffs, and other cost components to obtain an accurate unit cost. Refer to previous purchase invoices, cost accounting reports, etc. Market price reference: If the unit cost cannot be obtained through internal cost accounting, check the average price of similar materials in the market as a reference, and make appropriate adjustments based on factors such as the company's purchase discounts and quality requirements. Communication with suppliers: Directly contact the material's supplier to inquire about the latest price information and obtain a formal quotation to supplement the data. 2) Total price calculation error. Recalculation: Recalculate the total price using an appropriate formula (e.g., total price = quantity × unit cost) based on the correct material quantity and unit cost. Check the calculation process: Carefully check for data entry errors, incorrect formula usage, etc., during the total price calculation process. For example, confirm whether the quantity and unit cost values ​​are accurate, and whether the multiplication operations are correct. Compare with historical data: Compare the calculated total price with the total price of similar materials in the past. If the difference is too large, the accuracy of the calculation process and data needs to be further verified.

[0086] Furthermore, it can record the measures taken, modifications made, and references used when processing data that failed integrity checks. These records facilitate subsequent auditing and traceability, and provide experience for handling similar issues.

[0087] Organizational strategies are used to integrate target material information and price information to obtain corresponding specified material information and specified price information.

[0088] In this embodiment, information integration between the target material information and price information can be performed based on the strategy content of the above-mentioned organizational strategy to obtain the corresponding specified material information and specified price information.

[0089] Fill the specified material information and specified price information into the preset specified file to generate the corresponding target file.

[0090] In this embodiment, the specific implementation process of filling the specified material information and specified price information into the preset specified file to generate the corresponding target file will be described in more detail in subsequent specific embodiments of this application, and will not be elaborated on here.

[0091] This application performs integrity verification on the target material information and price information. If the verification passes, a preset organizational strategy is obtained. The organizational strategy is used to integrate the target material information and price information to obtain corresponding specified material information and specified price information. Subsequently, the specified material information and specified price information are filled into a preset specified file to generate the corresponding target file. Based on the above processing flow, this application performs integrity verification on the target material information and price information. If the verification passes, the target material information and price information are integrated based on the use of the organizational strategy, and then the integrated specified material information and specified price information are filled into a preset specified file. This enables the automatic and accurate generation of the corresponding target file, improving the generation efficiency and intelligence of the target file.

[0092] In some optional implementations of this embodiment, the specified material information and specified price information are filled into a preset specified file to generate a corresponding target file, including the following steps: Creates the specified file based on the preset creation tool.

[0093] In this embodiment, the selection of the aforementioned creation tool is not specifically limited and can be determined according to actual business needs. For example, Excel software or related libraries (such as Python's openpyxl or pandas library) can be used. A new Excel file can be created based on the selected creation tool as the designated file. A new worksheet is then created within the designated file to store material information and price information.

[0094] The specified file is used to populate the specified material information and the specified price information to obtain the corresponding first processing file.

[0095] In this embodiment, the integrated specified material information and specified price information are filled into the worksheet of the specified file line by line, and the accuracy and consistency of the filled data are ensured to avoid errors or omissions, thereby generating the corresponding first processing file.

[0096] The second processed file is used as the target file. The second processed file is obtained by optimizing the format of the first processed file based on a preset format.

[0097] In this embodiment, the aforementioned preset format is an application format constructed based on actual business needs. Specifically, it may include applying a predetermined format to the data in the Excel file, such as setting header styles, adjusting column widths, and setting number formats. Conditional formatting is also considered to highlight important data or outliers. Furthermore, the aforementioned preset format is applied to the worksheet of the first processed file, and cell borders, background colors, fonts, and other attributes are adjusted to improve the readability and aesthetics of the file, thus completing the format optimization processing of the first processed file. The resulting second processed file is then used as the final target file.

[0098] This application creates a specified file using a preset creation tool. This specified file is then populated with specified material and price information to obtain a first processed file. A second processed file, which is obtained by optimizing the first processed file based on a preset format, is then used as the target file. Based on this process, this application creates a specified file using a creation tool, populates it with specified material and price information to obtain a first processed file, optimizes the first processed file using a preset format, and uses the resulting second processed file as the final target file. This effectively ensures the accuracy, completeness, and readability of the data in the generated target file, facilitating subsequent data processing and analysis by relevant users.

[0099] In some optional implementations of this embodiment, after step S206, the electronic device may further perform the following steps: Get a variety of preset storage strategies.

[0100] In this embodiment, the above storage strategies may include at least database storage, cloud storage, blockchain storage, and so on.

[0101] Storage strategies include target storage strategies.

[0102] In this embodiment, a desired strategy can be selected from all storage strategies based on actual business needs to serve as the corresponding target storage strategy. Preferably, database storage can be used as the target storage strategy. By introducing database technology, all exported data is imported into the database, and software is used to query and maintain the BOM. This differs from the current data storage model of remote sharing of multiple Excel documents, which is beneficial to improving the office efficiency of the company's functional departments.

[0103] The target storage strategy is used to store target files.

[0104] In this embodiment, the storage processing of the target file can be performed according to the selected target storage strategy, that is, the target file is stored in the target storage medium corresponding to the target storage strategy.

[0105] This application obtains multiple preset storage strategies, including a target storage strategy, which is used to store target files. Based on the above processing flow, this application obtains a target storage strategy from the multiple storage strategies and then stores the target file based on the use of the target storage strategy. This ensures the stability and reliability of the target file, avoids file corruption or data loss, improves the intelligence of target file storage, and facilitates subsequent retrieval and use.

[0106] In some alternative implementations, the user information obtained is subject to user consent and complies with relevant laws and policies.

[0107] Furthermore, any software tools or components not belonging to our company that appear in the embodiments of this application are merely illustrative examples and do not represent actual use.

[0108] It should be understood that the sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0109] The embodiments of this application can acquire and process relevant data based on artificial intelligence technology. Artificial intelligence (AI) refers to the theories, methods, technologies, and application systems that use digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use that knowledge to obtain optimal results. Foundational technologies for artificial intelligence generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing, operating / interactive systems, and mechatronics. AI software technologies mainly encompass computer vision, robotics, biometrics, speech processing, natural language processing, and machine learning / deep learning.

[0110] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing related hardware through computer-readable instructions. These computer-readable instructions can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above methods. The aforementioned storage medium can be a non-volatile storage medium such as a magnetic disk, optical disk, or read-only memory (ROM), or random access memory (RAM).

[0111] It should be understood that although the steps in the flowcharts of the accompanying figures are shown sequentially as indicated by the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the accompanying figures may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily completed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the sub-steps or stages of other steps.

[0112] Further reference Figure 3 As a response to the above Figure 2 To implement the method shown, this application provides an embodiment of a data processing apparatus, which is similar to... Figure 2 Corresponding to the method embodiments shown, this device can be specifically applied to various electronic devices.

[0113] like Figure 3 As shown, the data processing device 300 of this embodiment includes: a first processing module 301, a receiving module 302, a searching module 303, a display module 304, a calculation module 305, and a second processing module 306. Wherein: A first processing module 301 is used to receive a specified shared file from a preset main interface and read location information containing material information from the specified shared file based on a preset reading interface; A receiving module 302 for receiving target bill of materials codes based on a preset input interface; Module 303 is used to find all target material information corresponding to the target bill of materials code based on location information through a preset query interface; Display module 304 is used to display the target material information based on the preset viewing interface if a display instruction for the target material information is received from the preset viewing interface. Calculation module 305 is used to calculate the price of the target material information based on a preset calculation strategy and obtain the corresponding price information if a calculation instruction for the target material information is received. The second processing module 306 is used to generate a corresponding target file based on the target material information and price information, and to export the target file if an export instruction is received.

[0114] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here.

[0115] In some optional implementations of this embodiment, the lookup module 303 includes: The first acquisition submodule is used to acquire the code type corresponding to the preset bill of materials code; The second acquisition submodule is used to acquire the format specification corresponding to the code type; the format specification is used to perform format validation on the target bill of materials code. The search submodule is used to find all target material information corresponding to the target bill of materials code based on the location information through the query interface if the target bill of materials code passes the format validation.

[0116] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here.

[0117] In some optional implementations of this embodiment, the calculation module 305 includes: The third acquisition submodule is used to acquire the hierarchical relationship corresponding to the target material information, and to acquire the unit price information corresponding to the target material information; The identification submodule is used to perform anomaly identification and handling during the acquisition of unit price information. The fourth acquisition submodule is used to acquire the preset price calculation method if there are no abnormalities in the process of acquiring unit price information; The calculation submodule is used to perform hierarchical calculations on the target material information based on hierarchical relationships and unit price information, and obtain the corresponding calculation results by calculating the price. The first determination submodule is used to use the calculation results as price information.

[0118] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here.

[0119] In some optional implementations of this embodiment, the calculation module 305 further includes: The fifth acquisition submodule is used to acquire abnormal information identified during the acquisition process of unit price information if there is an abnormality in the acquisition process. The generation submodule is used to generate exception message information corresponding to the exception information; The second determination submodule is used to identify the abnormal information area in the viewing interface; The display submodule is used to display and process abnormal information and abnormal prompts within the abnormal information area.

[0120] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here.

[0121] In some optional implementations of this embodiment, the second processing module 306 includes: The verification submodule is used to perform integrity verification on the target material information and price information. The sixth submodule is used to obtain the preset organization strategy if the verification passes; the organization strategy is used to integrate the target material information and price information to obtain the corresponding specified material information and specified price information. The fill submodule is used to fill specified material information and specified price information into a preset specified file to generate the corresponding target file.

[0122] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here. In some optional implementations of this embodiment, the filling submodule includes: The creation unit is used to create a specified file based on a preset creation tool; the specified file is used to fill in the specified material information and specified price information into the specified file to obtain the corresponding first processing file; The determining unit is used to take the second processing file as the target file, which is obtained by optimizing the format of the first processing file based on a preset format.

[0123] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here.

[0124] In some optional implementations of this embodiment, the data processing apparatus further includes: The acquisition module is used to acquire multiple preset storage strategies; the storage strategies include the target storage strategy; the target storage strategy is used to perform storage processing on the target file.

[0125] In this embodiment, the operations performed by the above modules or units correspond one-to-one with the steps of the data processing method in the aforementioned embodiments, and will not be repeated here. To address the aforementioned technical problems, embodiments of this application also provide a computer device. Please refer to [link / reference needed]. Figure 4 , Figure 4 This is a basic structural block diagram of the computer device in this embodiment.

[0126] Computer device 4 includes a memory 41, a processor 42, and a network interface 43 that are interconnected via a system bus. It should be noted that only computer device 4 with components 41-43 is shown in the figure; however, it should be understood that it is not required to implement all the shown components, and more or fewer components may be implemented alternatively. Those skilled in the art will understand that the computer device described here is a device capable of automatically performing numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes, but is not limited to, microprocessors, application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), digital signal processors (DSPs), embedded devices, etc.

[0127] Computer devices can include desktop computers, laptops, handheld computers, and cloud servers. These devices allow for human-computer interaction with users through keyboards, mice, remote controls, touchpads, or voice-activated devices.

[0128] The memory 41 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 41 may be an internal storage unit of the computer device 4, such as the hard disk or memory of the computer device 4. In other embodiments, the memory 41 may also be an external storage device of the computer device 4, such as a plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, etc., equipped on the computer device 4. Of course, the memory 41 may include both the internal storage unit and the external storage device of the computer device 4. In this embodiment, the memory 41 is typically used to store the operating system and various application software installed on the computer device 4, such as computer-readable instructions for data processing methods. In addition, the memory 41 may also be used to temporarily store various types of data that have been output or will be output.

[0129] In some embodiments, processor 42 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip. Processor 42 is typically used to control the overall operation of computer device 4. In this embodiment, processor 42 is used to execute computer-readable instructions stored in memory 41 or to process data, such as computer-readable instructions for executing data processing methods.

[0130] The network interface 43 may include a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the computer device 4 and other electronic devices.

[0131] Compared with the prior art, the embodiments of this application have the following beneficial effects: In this embodiment, unlike existing manual processing methods, this application utilizes pre-reading of location information containing material information to locate all target material information corresponding to the received target material list code, thereby improving the data query efficiency of target material information. Furthermore, based on the use of a calculation strategy, it automatically performs price calculation processing for the target material information, improving the processing efficiency and accuracy of price calculation, and enhancing the data accuracy of the subsequently exported target file.

[0132] This application also provides another embodiment, namely, providing a computer-readable storage medium storing computer-readable instructions that can be executed by at least one processor to cause the at least one processor to perform the steps of the data processing method described above.

[0133] Compared with the prior art, the embodiments of this application have the following main advantages: In this embodiment, unlike existing manual processing methods, this application utilizes pre-reading of location information containing material information to locate all target material information corresponding to the received target material list code, thereby improving the data query efficiency of target material information. Furthermore, based on the use of a calculation strategy, it automatically performs price calculation processing for the target material information, improving the processing efficiency and accuracy of price calculation, and enhancing the data accuracy of the subsequently exported target file.

[0134] Embodiments of this application also provide a computer program product that, when run on a terminal device, enables the terminal device to implement the steps described in the various method embodiments above.

[0135] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods of the various embodiments of this application.

[0136] Obviously, the embodiments described above are only some embodiments of this application, not all embodiments. The accompanying drawings show preferred embodiments of this application, but do not limit the patent scope of this application. This application can be implemented in many different forms; rather, the purpose of providing these embodiments is to provide a more thorough and comprehensive understanding of the disclosure of this application. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing specific embodiments, or make equivalent substitutions for some of the technical features. Any equivalent structures made using the content of this application's specification and drawings, directly or indirectly applied to other related technical fields, are similarly within the scope of patent protection of this application.

Claims

1. A data processing method, characterized in that, Includes the following steps: Receive a specified shared file from the preset main interface, and read the location information containing material information from the specified shared file based on the preset reading interface; Receive the target bill of materials code based on the preset input interface; Based on the location information, all target material information corresponding to the target bill of materials code is retrieved through a preset query interface; If a display instruction for the target material information is received from the preset viewing interface, the target material information is displayed based on the preset viewing interface. If a calculation instruction for the target material information is received, the price of the target material information is calculated based on a preset calculation strategy to obtain the corresponding price information; If an export instruction is received, a corresponding target file is generated based on the target material information and the price information, and the target file is exported.

2. The data processing method according to claim 1, characterized in that, The step of finding all target material information corresponding to the target bill of materials code based on the location information through a preset query interface specifically includes: Retrieve the code type corresponding to the preset bill of materials code; Obtain the format specification corresponding to the encoding type; The format specification is used to perform format validation on the target bill of materials code; If the target bill of materials code passes the format validation, then based on the location information, all target material information corresponding to the target bill of materials code is retrieved through the query interface.

3. The data processing method according to claim 1, characterized in that, The step of calculating the price of the target material information based on a preset calculation strategy to obtain the corresponding price information specifically includes: Obtain the hierarchical relationship corresponding to the target material information, and obtain the unit price information corresponding to the target material information; Anomaly detection processing is performed on the process of acquiring the unit price information; If there are no abnormalities in the process of obtaining the unit price information, then the preset price calculation method is obtained; Based on the hierarchical relationship and the unit price information, the target material information is calculated upwards level by level using the price calculation method to obtain the corresponding calculation result; The calculation result is used as the price information.

4. The data processing method according to claim 3, characterized in that, After the step of performing anomaly identification processing in the process of obtaining the unit price information, the method further includes: If there is an anomaly in the process of obtaining the unit price information, then the anomaly information identified in the process of obtaining the unit price information is obtained; Generate an exception message corresponding to the exception information; Identify the abnormal information area in the viewing interface; The abnormal information and the abnormal prompt information are displayed and processed within the abnormal information area.

5. The data processing method according to claim 1, characterized in that, The step of generating a corresponding target file based on the target material information and the price information specifically includes: Perform an integrity check on the target material information and the price information; If the verification passes, the preset organization strategy is obtained; The organizational strategy is used to integrate the target material information and the price information to obtain the corresponding specified material information and specified price information; The specified material information and the specified price information are filled into a preset specified file to generate the corresponding target file.

6. The data processing method according to claim 5, characterized in that, The step of filling the specified material information and the specified price information into a preset specified file to generate the corresponding target file specifically includes: A specified file is created based on a preset creation tool; the specified file is used to fill in the specified material information and the specified price information to obtain the corresponding first processing file; The second processed file is used as the target file, which is obtained by optimizing the format of the first processed file based on a preset format.

7. The data processing method according to claim 1, characterized in that, After the steps of generating a corresponding target file based on the target material information and the price information, and exporting the target file, the method further includes: The system acquires multiple preset storage strategies, including a target storage strategy, which is used to store the target file.

8. A data processing apparatus, characterized in that, include: A first processing module for receiving a specified shared file from a preset main interface and reading location information containing material information from the specified shared file based on a preset reading interface; A receiving module for receiving target bill of materials codes based on a preset input interface; A search module for finding all target material information corresponding to the target bill of materials code based on the location information through a preset query interface; A display module for displaying the target material information based on a preset viewing interface if a display instruction for the target material information is received from a preset viewing interface. A calculation module for performing price calculations on the target material information based on a preset calculation strategy to obtain the corresponding price information if a calculation instruction for the target material information is received. A second processing module is used to generate a corresponding target file based on the target material information and the price information, and to export the target file if an export instruction is received.

9. A computer device, characterized in that, The method includes a memory and a processor, wherein the memory stores computer-readable instructions, and the processor executes the computer-readable instructions to implement the steps of the data processing method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-readable instructions, which, when executed by a processor, implement the steps of the data processing method as described in any one of claims 1 to 7.

Images