Data interaction method and system based on CAD software

Abstract

The invention provides a data interaction method and system based on CAD software, and the method comprises the steps: creating enhanced attribute blocks in a CAD program, and obtaining original data in each enhanced attribute block; obtaining second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and updating the original data based on the second material information; acquiring a currently activated document, and extracting a bill of material from the component list object based on the enhanced attribute block after the original data is updated; and traversing each entry in the bill of materials, searching corresponding third material information in the database by using the unique identifier of the entry, if the characteristic of the third material information is not manually modified, updating the characteristic value of the characteristic, sending the third material information after the characteristic is updated to the enterprise management software platform, and sending the third material information after the characteristic is updated to the enterprise management software platform. Therefore, resources are saved, the working efficiency is improved, and the development cycle of products is greatly shortened.

Description

Technical Field

[0001] The present invention belongs to the technical field of data transmission, and in particular relates to a data interaction method and system based on CAD software. Background Art

[0002] With the increasing application of information technology in the manufacturing industry, the enterprise management software platform has become an important means of unified management of all product-related information and processes. In the manufacturing industry, CAD software is generally used as a drawing generation tool. The two-dimensional drawings, three-dimensional models, basic properties of parts, product specifications, equipment relationships between product parts, product data versions and status generated by the application need to be managed by the enterprise management software system. If data sharing and mutual operation between CAD and enterprise management software are achieved, it can be ensured that the modifications in CAD and the modifications in enterprise management software are interactive and consistent, and truly achieve two-way synchronization consistency, solving the "information island" phenomenon of the enterprise. Data sharing and application integration between the two can greatly improve the system operation efficiency, shorten the product development cycle, and improve generation efficiency. At present, the drawing version information requires users to manually set and manually update the parts information in the CAD software.

[0003] The shortcomings of the existing technology are obvious. If the material information is changed in the enterprise management software platform, it is necessary to manually modify the drawing content in CAD and change the component characteristics, which will waste manpower, material and financial resources and affect the product development cycle and upgrade promotion. At present, in the process of interaction between CAD and enterprise management software for related technologies, a large amount of maintenance content is required due to the changes in versions on both ends, resulting in a waste of resources and reduced work efficiency. Summary of the invention

[0004] In order to solve the above technical problems, the present invention provides a data interaction method and system based on CAD software, which are used to solve the technical problems in the prior art.

[0005] On the one hand, the invention provides the following technical solution, a data interaction method based on CAD software, the method comprising:

[0006] Creating enhanced attribute blocks in a CAD program, and acquiring original data in each of the enhanced attribute blocks, wherein the original data includes first material information previously set in the drawing;

[0007] Acquire second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and update the original data based on the second material information;

[0008] Acquire a currently activated document, scan a parts list object in the document, and extract a bill of materials from the parts list object based on the enhanced attribute block after updating the original data;

[0009] Traversing each item in the bill of materials, searching the database for corresponding third material information using the unique identifier of the item, and determining whether the characteristics of the third material information are manually modified;

[0010] If the characteristic of the third material information is not manually modified, the characteristic value of the characteristic is updated, and the third material information after the updated characteristic is sent to the enterprise management software platform.

[0011] Compared with the prior art, the beneficial effects of the present application are as follows: the second material information corresponding to the original data in the database is obtained through the interface of the enterprise management software platform, and the original data is updated based on the second material information, so as to realize the data intercommunication between the CAD software and the enterprise management software platform. The CAD can obtain the material information and component characteristics in the database of the enterprise software management platform through the interface, and set them to generate BOM detailed data for the specified block. At the same time, if the characteristic of the third material information is not manually modified, the characteristic value of the characteristic is updated, and the third material information after the updated characteristic is sent to the enterprise management software platform, the version information and material information in the design drawing can be synchronized to the enterprise software management platform database through the interface, so as to realize the two-way intercommunication of data between the CAD software and the enterprise management software, thereby realizing resource saving, improving work efficiency, and greatly shortening the product development cycle.

[0012] Furthermore, the step of obtaining second material information corresponding to the original data in the database through the interface of the enterprise management software platform, and updating the original data based on the second material information includes:

[0013] Initiate an HTTP request using a script program to obtain an interface of the enterprise management software platform, and obtain the second material information corresponding to the original data in the database of the enterprise management software platform through the interface;

[0014] The second material information is transmitted back to the CAD software, and the original data is updated based on the second material information.

[0015] Furthermore, the two material information includes: component characteristics, materials, BOM details table data, and drawing version information.

[0016] Furthermore, the step of searching the database for corresponding third material information using the unique identifier of the entry includes:

[0017] Using the unique identifier of the entry, determining whether the third material information corresponding to the entry exists in the database;

[0018] If the third material information corresponding to the entry exists in the database, traversing the characteristics of the third material information;

[0019] Determine whether the characteristic of the third material information exists in the entry; if the characteristic of the third material information exists in the entry, execute the step of determining whether the characteristic of the third material information is manually modified.

[0020] Furthermore, after the step of using the unique identifier of the entry to determine whether the third material information corresponding to the entry exists in the database, the method further includes:

[0021] If the corresponding third material information does not exist in the database, the entry is ignored.

[0022] Furthermore, after the step of sending the third material information with updated characteristics to the enterprise management software platform, the method further includes:

[0023] After receiving the third material information, the enterprise management software platform generates a new bill of materials.

[0024] Furthermore, the characteristics of the third material information include specification model, manufacturer, material and description.

[0025] In a second aspect, the invention provides the following technical solution: a data interaction system based on CAD software, the system comprising:

[0026] An acquisition module, used for creating enhanced attribute blocks in a CAD program, and acquiring original data in each of the enhanced attribute blocks, wherein the original data includes first material information previously set in the drawing;

[0027] An updating module, configured to obtain second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and update the original data based on the second material information;

[0028] an extraction module, configured to obtain a currently activated document, scan a parts list object in the document, and extract a bill of materials from the parts list object based on the enhanced attribute block after updating the original data;

[0029] A judgment module, used to traverse each item in the bill of materials, use the unique identifier of the item to search the corresponding third material information in the database, and judge whether the characteristics of the third material information are manually modified;

[0030] The sending module is used to update the characteristic value of the characteristic if the characteristic of the third material information is not manually modified, and send the third material information with the updated characteristic to the enterprise management software platform.

[0031] In a third aspect, the invention provides the following technical solution: a computer comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the data interaction method based on CAD software as described above when executing the computer program.

[0032] In a fourth aspect, the invention provides the following technical solution: a storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the data interaction method based on CAD software as described above. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0034] Figure 1 A flow chart of a data interaction method based on CAD software provided in the first embodiment of the present invention;

[0035] Figure 2 A structural block diagram of a data interaction system based on CAD software provided in a second embodiment of the present invention;

[0036] Figure 3 A schematic diagram of the hardware structure of a computer provided in the third embodiment of the present invention.

[0037] The embodiments of the present invention will be further described below with reference to the accompanying drawings. DETAILED DESCRIPTION

[0038] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout are the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the embodiments of the present invention, and should not be construed as limiting the present invention.

[0039] In the description of the embodiments of the present invention, it should be understood that the terms "length", "width", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside" and "outside" etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the embodiments of the present invention and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present invention.

[0040] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of the embodiments of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0041] Embodiment 1

[0042] In the first embodiment of the present invention, see Figure 1 As shown, a data interaction method based on CAD software includes the following steps S01 to S05:

[0043] S01, creating enhanced attribute blocks in a CAD program, and acquiring original data in each of the enhanced attribute blocks, wherein the original data includes first material information previously set in the drawing;

[0044] In this embodiment, when designing drawings through CAD software, enhanced attribute blocks are created in the CAD program, and the original data in each enhanced attribute block is obtained. The original data refers to the first material information previously set for this drawing. If this drawing is changed, the previously set original data is first obtained and then updated according to the modified data of the enterprise management software platform.

[0045] S02, obtaining second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and updating the original data based on the second material information;

[0046] Specifically, the step of acquiring the second material information corresponding to the original data in the database through the interface of the enterprise management software platform, and updating the original data based on the second material information includes:

[0047] Initiate an HTTP request using a script program to obtain an interface of the enterprise management software platform, and obtain the second material information corresponding to the original data in the database of the enterprise management software platform through the interface;

[0048] The second material information is transmitted back to the CAD software, and the original data is updated based on the second material information.

[0049] More specifically, the second material information includes: component characteristics, materials, BOM list data, and drawing version information, such as: MPC male connector, 3 / 8" HB, MPC22006T03M, MPC female plug, MPC32003, quick-release cover, TC50, etc.

[0050] In this embodiment, the script program HTTP requests the interface of the enterprise software management platform to obtain the component characteristics, material information, BOM list data, and drawing version information corresponding to the material.

[0051] S03, acquiring a currently activated document, scanning a parts list object in the document, and extracting a bill of materials from the parts list object based on the enhanced attribute block after updating the original data;

[0052] In this embodiment, the currently activated document is obtained, an AcmPartList Object (parts list object) in the document is scanned, and a BOM object (bill of materials) is extracted from the AcmPartList Object.

[0053] S04, traversing each item in the bill of materials, searching the database for corresponding third material information using the unique identifier of the item, and determining whether the characteristic of the third material information is manually modified;

[0054] Specifically, the step of searching the database for corresponding third material information using the unique identifier of the entry includes:

[0055] Using the unique identifier of the entry, determining whether the third material information corresponding to the entry exists in the database;

[0056] If the third material information corresponding to the entry exists in the database, traversing the characteristics of the third material information;

[0057] Determine whether the characteristic of the third material information exists in the entry; if the characteristic of the third material information exists in the entry, execute the step of determining whether the characteristic of the third material information is manually modified.

[0058] Specifically, after the step of using the unique identifier of the entry to determine whether the third material information corresponding to the entry exists in the database, the method further includes:

[0059] If the corresponding third material information does not exist in the database, the entry is ignored.

[0060] In this embodiment, the BOM object is traversed, and the third material information data is matched according to the unique identifier of the BOM Item;

[0061] If the item does not contain the third material information corresponding to the item, the BOM Item is ignored; if the third material information exists, the characteristics of the third material information are traversed;

[0062] Check whether the feature exists in the BOM Item. If not, ignore it. If it exists, check whether the feature value is manually modified. If it is manually modified, ignore the update of the feature value. Otherwise, update the feature value.

[0063] Specifically, the characteristics of the third material information include specification model, manufacturer, material and description.

[0064] S05: If the characteristic of the third material information is not manually modified, then update the characteristic value of the characteristic, and send the third material information after the updated characteristic to the enterprise management software platform.

[0065] Specifically, after the step of sending the third material information with updated characteristics to the enterprise management software platform, the method further includes:

[0066] After receiving the third material information, the enterprise management software platform generates a new bill of materials.

[0067] In this implementation, the CAD software on the client is started, the design drawing is opened through the CAD software, the drawing version and component content are obtained, and the enterprise management software platform interface is accessed through HTTP request, and the version information of the CAD application software and the material content, component information and information in the enterprise management software database are matched. If the version information has updated the content, the version information in the enterprise management software database is synchronized.

[0068] In summary, a data interaction method based on CAD software has the following effects:

[0069] The steps of obtaining the second material information corresponding to the original data in the database through the interface of the enterprise management software platform and updating the original data based on the second material information realize the data intercommunication between the CAD software and the enterprise management software platform. The CAD can obtain the material information and component characteristics in the database of the enterprise software management platform through the interface, and set them to generate BOM detailed data for the specified block. At the same time, if the characteristic of the third material information is not manually modified, the characteristic value of the characteristic is updated, and the third material information after the updated characteristic is sent to the enterprise management software platform, the version information and material information in the design drawing can be synchronized to the enterprise software management platform database through the interface, realizing the two-way intercommunication of data between the CAD software and the enterprise management software, thereby saving resources, improving work efficiency, and greatly shortening the product development cycle.

[0070] Embodiment 2

[0071] like Figure 2 As shown, in a second embodiment of the present invention, a data interaction system based on CAD software is provided, and the system includes:

[0072] The acquisition module 10 is used to create enhanced attribute blocks in the CAD program and acquire original data in each of the enhanced attribute blocks, wherein the original data includes the first material information previously set in the drawing;

[0073] An updating module 20, configured to obtain second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and update the original data based on the second material information;

[0074] An extraction module 30, for acquiring a currently activated document, scanning a parts list object in the document, and extracting a bill of materials from the parts list object based on the enhanced attribute block after updating the original data;

[0075] A determination module 40 is used to traverse each item in the bill of materials, use the unique identifier of the item to search for the corresponding third material information in the database, and determine whether the characteristics of the third material information are manually modified;

[0076] The sending module 50 is used to update the characteristic value of the characteristic if the characteristic of the third material information is not manually modified, and send the third material information with the updated characteristic to the enterprise management software platform.

[0077] The data interaction system based on CAD software provided in the embodiment of the present invention has the same implementation principle and technical effects as those in the aforementioned method embodiment. For the sake of brief description, for matters not mentioned in the system embodiment, reference may be made to the corresponding contents in the aforementioned method embodiment.

[0078] Embodiment 3

[0079] like Figure 3 As shown, in the third embodiment of the present invention, the embodiment of the present invention provides the following technical solution, a computer, including a memory 202, a processor 201, and a computer program stored in the memory 202 and executable on the processor 201, and the processor 201 implements the data interaction method based on CAD software as described above when executing the computer program.

[0080] Specifically, the processor 201 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiments of the present application.

[0081] Among them, the memory 202 may include a large capacity memory for data or instructions. By way of example and not limitation, the memory 202 may include a hard disk drive (HDD), a floppy disk drive, a solid state drive (SSD), a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive, or a combination of two or more of these. Where appropriate, the memory 202 may include a removable or non-removable (or fixed) medium. Where appropriate, the memory 202 may be inside or outside a data processing device. In a specific embodiment, the memory 202 is a non-volatile memory. In a specific embodiment, the memory 202 includes a read-only memory (ROM) and a random access memory (RAM). Where appropriate, the ROM may be a mask-programmed ROM, a programmable ROM (Programmable Read-Only Memory, PROM for short), an erasable PROM (ErasableProgrammable Read-Only Memory, EPROM for short), an electrically erasable PROM (Electrically ErasableProgrammable Read-Only Memory, EEPROM for short), an electrically alterable ROM (ElectricallyAlterable Read-Only Memory, EAROM for short) or a flash memory (FLASH) or a combination of two or more of these. Under appropriate circumstances, the RAM can be a static random access memory (SRAM) or a dynamic random access memory (DRAM), wherein the DRAM can be a fast page mode dynamic random access memory (FPMDRAM), an extended data output dynamic random access memory (EDODRAM), a synchronous dynamic random access memory (SDRAM), etc.

[0082] The memory 202 may be used to store or cache various data files that need to be processed and / or used for communication, as well as possible computer program instructions executed by the processor 201 .

[0083] The processor 201 implements the above-mentioned data interaction method based on CAD software by reading and executing the computer program instructions stored in the memory 202.

[0084] In some embodiments, the computer may further include a communication interface 203 and a bus 200. Figure 3 As shown, the processor 201, the memory 202, and the communication interface 203 are connected via a bus 200 and communicate with each other.

[0085] The communication interface 203 is used to implement communication between the modules, devices, units and / or equipment in the embodiment of the present application. The communication interface 203 can also implement data communication with other components such as: external devices, image / data acquisition equipment, databases, external storage, and image / data processing workstations.

[0086] The bus 200 includes hardware, software or both, and couples the components of the computer to each other. The bus 200 includes but is not limited to at least one of the following: a data bus, an address bus, a control bus, an expansion bus, and a local bus. By way of example and not limitation, bus 200 may include an Accelerated Graphics Port (AGP) or other graphics bus, an Extended Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), a Hyper Transport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an InfiniBand interconnect, a Low Pin Count (LPC) bus, a memory bus, a Micro Channel Architecture (MCA) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a Video Electronics Standards Association Local Bus (VLB) bus, or other suitable buses or a combination of two or more of these. Where appropriate, bus 200 may include one or more buses. Although embodiments of the present application describe and illustrate a particular bus, the present application contemplates any suitable bus or interconnect.

[0087] Embodiment 4

[0088] In the fourth embodiment of the present invention, in combination with the above-mentioned data interaction method based on CAD software, the embodiment of the present invention provides the following technical solution, a storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the above-mentioned data interaction method based on CAD software is implemented.

[0089] Those skilled in the art will appreciate that the logic and / or steps described in the flowchart as data or in other ways herein, for example, can be considered as a sequenced data table of executable instructions for implementing logical functions, and can be specifically implemented in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purposes of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses.

[0090] More specific examples of computer-readable media (non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk case (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and editable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be a paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium, followed by editing, deciphering or, if necessary, processing in another suitable manner, and then stored in a computer memory.

[0091] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, a plurality of steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or a combination thereof: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0092] The technical features of the above-described embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above-described embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0093] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A data interaction method based on CAD software, characterized in that: The method comprises: Creating enhanced attribute blocks in a CAD program, and acquiring original data in each of the enhanced attribute blocks, wherein the original data includes first material information previously set in the drawing; Acquire second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and update the original data based on the second material information; Acquire a currently activated document, scan a parts list object in the document, and extract a bill of materials from the parts list object based on the enhanced attribute block after updating the original data; Traversing each item in the bill of materials, searching the database for corresponding third material information using the unique identifier of the item, and determining whether the characteristics of the third material information are manually modified; If the characteristic of the third material information is not manually modified, the characteristic value of the characteristic is updated, and the third material information after the updated characteristic is sent to the enterprise management software platform.

2. The data interaction method based on CAD software according to claim 1, characterized in that: The step of acquiring the second material information corresponding to the original data in the database through the interface of the enterprise management software platform, and updating the original data based on the second material information includes: Initiate an HTTP request using a script program to obtain an interface of the enterprise management software platform, and obtain the second material information corresponding to the original data in the database of the enterprise management software platform through the interface; The second material information is transmitted back to the CAD software, and the original data is updated based on the second material information.

3. The data interaction method based on CAD software according to claim 2, characterized in that: The second material information includes: component characteristics, materials, BOM details table data, and drawing version information.

4. The data interaction method based on CAD software according to claim 1, characterized in that: The step of searching the database for corresponding third material information using the unique identifier of the entry includes: Using the unique identifier of the entry, determining whether the third material information corresponding to the entry exists in the database; If the third material information corresponding to the entry exists in the database, traversing the characteristics of the third material information; Determine whether the characteristic of the third material information exists in the entry; if the characteristic of the third material information exists in the entry, execute the step of determining whether the characteristic of the third material information is manually modified.

5. The data interaction method based on CAD software according to claim 4, characterized in that: After the step of using the unique identifier of the entry to determine whether the third material information corresponding to the entry exists in the database, the method further includes: If the corresponding third material information does not exist in the database, the entry is ignored.

6. The data interaction method based on CAD software according to claim 1, characterized in that: After the step of sending the third material information with updated characteristics to the enterprise management software platform, the method further includes: After receiving the third material information, the enterprise management software platform generates a new bill of materials.

7. The data interaction method based on CAD software according to claim 1, characterized in that: The characteristics of the third material information include specification model, manufacturer, material and description.

8. A data interaction system based on CAD software, characterized in that: The system comprises: An acquisition module, used for creating enhanced attribute blocks in a CAD program, and acquiring original data in each of the enhanced attribute blocks, wherein the original data includes first material information previously set in the drawing; An updating module, configured to obtain second material information corresponding to the original data in a database through an interface of an enterprise management software platform, and update the original data based on the second material information; an extraction module, configured to obtain a currently activated document, scan a parts list object in the document, and extract a bill of materials from the parts list object based on the enhanced attribute block after updating the original data; A judgment module, used to traverse each item in the bill of materials, use the unique identifier of the item to search the corresponding third material information in the database, and judge whether the characteristics of the third material information are manually modified; The sending module is used to update the characteristic value of the characteristic if the characteristic of the third material information is not manually modified, and send the third material information with the updated characteristic to the enterprise management software platform.

9. A computer comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the CAD software-based data interaction method according to any one of claims 1 to 7 is implemented.

10. A storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by the processor, the data interaction method based on CAD software as described in any one of claims 1 to 7 is implemented.

Images