Electrical data two-dimensional and three-dimensional integrated processing method, device, equipment and medium

Abstract

The invention provides an electrical data two-dimensional and three-dimensional integrated processing method and device, equipment and a medium, and the method comprises the steps: responding to a drawing creation request, creating a two-dimensional drawing containing at least one entity in first two-dimensional software, and storing entity information in an independent database; in response to the export request, exporting entity information of the first drawing as a data file; and in response to an import request, importing the data file into second three-dimensional software to create a three-dimensional drawing. The data processing efficiency can be improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method, device, electronic device and storage medium for integrated two-dimensional and three-dimensional processing of electrical data. Background Art

[0002] Current shipbuilding projects are characterized by complexity and scale. In addition, the projects themselves have high requirements for digital transformation of electrical design. Therefore, object classification, data storage and data output in the electrical two-dimensional design process are very important in the design and production process.

[0003] At the same time, since electrical equipment also uses 3D design software to model electrical equipment, 2D and 3D data become data islands. Although data can be transferred through files such as Excel, it is still not convenient and effective enough. Summary of the invention

[0004] In view of this, the embodiments of the present application provide a method, device, equipment and medium for integrated two-dimensional and three-dimensional processing of electrical data, which can improve processing efficiency.

[0005] The technical solution of the embodiment of the present application is implemented as follows:

[0006] In a first aspect, an embodiment of the present application provides a method for integrated two-dimensional and three-dimensional processing of electrical data, comprising the following steps:

[0007] In response to a drawing creation request, a first drawing is created in a first software; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each entity in the at least one entity corresponds to entity information, the entity information is used to link two-dimensional and three-dimensional data, the entity information is stored in an independent database, the independent database includes at least one data table, and each data table in the at least one data table is used to store part of the entity information;

[0008] In response to a first export request, exporting entity information corresponding to the first drawing in the independent database to obtain a first data file;

[0009] In response to an import request, the first data file is imported into a second software so that the second software creates a second drawing based on the data file; wherein the second software is a three-dimensional software, and the second drawing is a three-dimensional drawing created by the three-dimensional software.

[0010] In a second aspect, the present application also provides a two-dimensional and three-dimensional integrated processing device for electrical data, the device comprising:

[0011] A creation module, configured to create a first drawing in a first software in response to a drawing creation request; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each entity in the at least one entity corresponds to an entity information, the entity information is used to link two-dimensional and three-dimensional data, the entity information is stored in an independent database, the independent database includes at least one data table, and each data table in the at least one data table is used to store part of the entity information;

[0012] An export module, configured to export the entity information corresponding to the first drawing in the independent database in response to a first export request to obtain a first data file;

[0013] An import module is used to import the first data file into a second software in response to an import request, so that the second software creates a second drawing based on the data file; wherein the second software is a three-dimensional software, and the second drawing is a three-dimensional drawing created by the three-dimensional software.

[0014] In the third aspect, an embodiment of the present application also provides an electronic device, comprising: a processor, a storage medium and a bus, wherein the storage medium stores machine-readable instructions executable by the processor, and when the electronic device is running, the processor communicates with the storage medium through the bus, and the processor executes the machine-readable instructions to execute the two-dimensional and three-dimensional integrated processing method of electrical data as described in any one of the first aspects.

[0015] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the two-dimensional and three-dimensional integrated processing method for electrical data described in any one of the first aspects is executed.

[0016] The embodiments of the present application have the following beneficial effects:

[0017] Through the business-based database architecture, the embodiment of the present application scientifically stores the equipment and related coordinate information, providing a solid foundation for the two-dimensional and three-dimensional integrated processing of electrical data. This architecture not only ensures the integrity and accuracy of the data, but also improves the efficiency of data query and update. Further, the method adopts an intuitive visual UI design to provide designers with a parameter editing interface that is visible as what you get. This interface enables designers to intuitively understand the entity information in the drawing and modify it as needed. Compared with the traditional discrete drawing allocation information, the method greatly improves the flexibility and efficiency of the design. Designers can easily edit parameters in a visual environment without manually entering or modifying complex coordinate information. In addition, using the secondary development capabilities of BricsCAD, the method realizes the export of all device information based on the connection information in the database. This function enables designers to easily export the device information in the two-dimensional drawing to the three-dimensional software for further design and analysis. At the same time, the method also supports the automatic update of the layout drawing according to the latest coordinates returned by S3D (or other three-dimensional software). This function greatly reduces the repeated input work of designers and improves the accuracy and efficiency of the design. Finally, through the implementation of this method, the effect of partial two-dimensional and three-dimensional linkage is achieved. When the equipment or layout in the 3D drawing changes, these changes can be automatically reflected in the 2D drawing without the need for designers to manually update. This linkage effect not only ensures consistency between 2D and 3D drawings, but also improves the overall efficiency and quality of the design.

[0018] In summary, the embodiment of the present application provides designers with an efficient, convenient and accurate 2D and 3D integrated processing tool for electrical data through scientific database architecture, intuitive visual UI design, secondary development of BricsCAD and realization of 2D and 3D linkage effects. This tool not only reduces design cost and time cost, but also improves design flexibility and accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0020] Figure 1 is a flowchart of steps S101-S103 provided in an embodiment of the present application;

[0021] Figure 2 This is a drawing attribute interface diagram provided in an embodiment of the present application;

[0022] Figure 3 This is a property bar interface diagram provided in an embodiment of the present application;

[0023] Figure 4 This is a diagram of the drop-down list management and application interface provided by the embodiment of the present application;

[0024] Figure 5 This is a diagram of the data import and export button interface provided in an embodiment of the present application;

[0025] Figure 6 It is a flowchart of steps S201-S203 provided in an embodiment of the present application;

[0026] Figure 7 It is a structural schematic diagram of a two-dimensional and three-dimensional integrated processing device for electrical data provided in an embodiment of the present application;

[0027] Figure 8 It is a schematic diagram of the composition structure of the electronic device provided in the embodiment of the present application. DETAILED DESCRIPTION

[0028] To make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. It should be understood that the drawings in the present application only serve the purpose of explanation and description and are not used to limit the scope of protection of the present application. In addition, it should be understood that the schematic drawings are not drawn in real proportion. The flowchart used in this application shows the operations implemented according to some embodiments of the present application. It should be understood that the operations of the flowchart can be implemented out of sequence, and the steps without logical context can be reversed in order or implemented simultaneously. In addition, those skilled in the art can add one or more other operations to the flowchart under the guidance of the content of the present application, or remove one or more operations from the flowchart.

[0029] In the following description, reference is made to “some embodiments”, which describe a subset of all possible embodiments, but it will be understood that “some embodiments” may be the same subset or different subsets of all possible embodiments and may be combined with each other without conflict.

[0030] In addition, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative work belong to the scope of protection of the present application.

[0031] In the following description, the terms "first\second\third" involved are merely used to distinguish similar objects and do not represent a specific ordering of the objects. It can be understood that "first\second\third" can be interchanged with a specific order or sequence where permitted, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described herein.

[0032] It should be noted that the term "comprising" will be used in the embodiments of the present application to indicate the existence of the features declared thereafter, but does not exclude the addition of other features.

[0033] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are for the purpose of describing the embodiments of this application and are not intended to limit this application.

[0034] See also Figure 1 , Figure 1 is a flow chart of steps S101-S103 of the two-dimensional and three-dimensional integrated processing method of electrical data provided in the embodiment of the present application, which will be combined with Figure 1 Steps S101-S103 are shown for explanation.

[0035] In step S101, in response to a request for creating a new drawing, a first drawing is created in a first software; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each of the at least one entity corresponds to an entity information, the entity information is used to link two- and three-dimensional data, the entity information is stored through an independent database, the independent database includes at least one data table, each of the at least one data table is used to store part of the entity information.

[0036] Here, when the user needs to create a new drawing, the system will respond to this request. In this process, the user will create a new two-dimensional drawing in the first software (such as BricsCAD), which is called the first drawing. The first drawing will contain at least one entity. These entities can be handles (text, lines, blocks), and handles correspond to electrical components, circuits or equipment, etc. Each entity will correspond to an entity information, which is used to link two-dimensional and three-dimensional data. Entity information is stored in an independent database, which contains at least one data table, and each data table is used to store part of the entity information.

[0037] In step S102, in response to a first export request, entity information corresponding to the first drawing in the independent database is exported to obtain a first data file.

[0038] Here, when the user needs to export the information in the 2D drawing to the 3D software, the system will respond to this export request and extract the entity information corresponding to the first drawing from the independent database. Then, this information will be exported into a data file, which contains all the information needed to create the 3D drawing.

[0039] In step S103, in response to an import request, the first data file is imported into second software so that the second software creates a second drawing based on the data file; wherein the second software is 3D software, and the second drawing is a 3D drawing created by the 3D software.

[0040] Here, in response to an import request initiated by a user, a first data file is imported into a second software (e.g., S3D). Here, the first data file is exported from a two-dimensional software and contains information about all entities in a two-dimensional drawing. These data files may be stored in a specific format so that the three-dimensional software can correctly parse and import them. Based on the imported data file, the second software will create a second drawing. This second drawing is three-dimensional and contains entities and information corresponding to the two-dimensional drawing.

[0041] In some embodiments, the electrical data is ship electrical data, and the entity information realizes two-dimensional and three-dimensional data linkage by defining a target coordinate system in the two-dimensional software, and the target coordinate system includes an X-axis, a Y-axis, and a Z-axis;

[0042] The coordinate of the X-axis is determined based on the rib number and the rib number offset;

[0043] The Y-axis coordinate is determined based on the offset from the centerline of the ship, with a positive value representing the right side from the stern to the bow and a negative value representing the left side from the stern to the bow;

[0044] The Z-axis represents altitude information, and the coordinate of the Z-axis is determined based on a deck number and / or a height above the ground.

[0045] Here, in order to realize the conversion from two-dimensional to three-dimensional, a coordinate system needs to be defined in the two-dimensional drawing.

[0046] The X-axis will be represented by the rib number and the rib number offset. The rib number is an enumerated list. The database will record the specific location of each rib number, and the user selects the name of the rib number. The rib number offset indicates the offset from the nearest rib number when the device is not exactly at a rib number. A positive value indicates a value greater than the rib number, and a negative value indicates a value less than the rib number.

[0047] The Y axis, which is the offset from the centerline of the ship, is positive when looking from the stern to the bow, and negative when looking from the left.

[0048] The Z axis, i.e. the height, is represented by the deck number and the height above the ground. The deck number is also an enumerated list. The user only needs to select a deck, and the absolute height of the specific deck will be stored in the database. The height above the ground has a unified default value of 1.2 meters, which can be modified. Therefore, the overall height is the sum of the two.

[0049] In some embodiments, the independent database is used to store at least the following information:

[0050] Equipment information, coordinate parameter information corresponding to the equipment, enumeration list matching the parameter information, layout information, base point information, and report information;

[0051] The equipment information includes the PieceMark number, equipment classification, and description information of the electrical equipment; the coordinate parameter information corresponding to the equipment includes the rib number, height from the ground, room number, deck number, and Y-axis offset; the enumeration list matching the parameter information includes the rib number and deck number, and the enumeration list matching the parameter information is used for standardized selection; the layout information is used to store the data of the first drawing, and the layout information includes drawings, handles, and drawing scales; the base point information is used to determine multiple drawing frames in the first drawing; the report information is used to store report definitions for the three-dimensional software;

[0052] The at least one data table forms a foreign key through a primary key to combine the at least one data table.

[0053] Here, after sorting out the business, it is determined that at least the following data needs to be stored:

[0054] Equipment information, such as the PieceMark number of the electrical equipment, equipment classification, Chinese description, English description, etc.

[0055] Necessary coordinate parameter information of the equipment, including rib number, height from the ground, room number, deck number, Y-axis offset, etc.

[0056] An enumerated list of matching parameters, such as rib number, deck number, etc., for standardized selection.

[0057] Layout drawing information, stores the data of the DWG itself, including drawings, handles, drawing scales, etc.

[0058] The concept of base point. Since there may be multiple drawing frames, that is, multiple coordinate origins, in a dwg file, it is necessary to introduce the concept of a base point to assist processing.

[0059] Report information is stored in the S3D export report definition.

[0060] In order to meet the above database storage requirements, the following data tables are required for storage, including but not limited to:

[0061] Ec_enginedata, engineering data table, is used to store basic information of all equipment and cables, including piecemark number, object classification, etc. The core is enginedataId.

[0062] Ec_enginedata_property, engineering data property table, is used to store relevant parameters of equipment and cables, such as Chinese and English descriptions, cable specifications, etc. The core is enginedataId and PropertyName.

[0063] Ec_enginedata_propertyhis, engineering data property modification table, used to record the history of property modifications.

[0064] Ec_dataitem, stores necessary data dictionary, such as rib number, drawing type, deck number, the core of which is dataitemId.

[0065] Ec_property, property definition table, is used to define the property itself. You can also set the property type here and allocate the required data dictionary.

[0066] Ec_dataitemdetail stores the specific drop-down value content under the data dictionary, such as 5, 10, and 15 under the rib position number, which is used for users to make standardized selections. It corresponds to the Ec_dataitem table, and its core is dataitemdetailId and dataitemId.

[0067] Ec_drawing, stores the information of the drawing itself, the core of which is drawingid.

[0068] Ec_enginedatapixel stores the handle information of the engineering data on the drawing, so that when interacting with the CAD software, the database objects and parameters behind it can be smoothly queried from the database, which is convenient for viewing and editing. The core is pixelid and EnginedataId.

[0069] Ec_objecttype, a special classification for storing base points, the core of which is objecttypeid.

[0070] Ec_reportfile, stores report information, facilitating the management of the Excel template behind it.

[0071] With these tables, a good foundation can be laid for data storage. Later, only the UI user interface needs to be designed to store the required parameters and carry out the functions required for two-dimensional and three-dimensional linkage. Compared with traditional data storage in file form, it has higher security, reliability and convenience.

[0072] The information in the data table corresponds to the specific business information one by one and is stored independently, which is convenient for users to filter, sort, and query by conditions. In this way, the data can be stored independently without being isolated. Foreign keys are formed through primary keys, and multiple tables are combined to facilitate data query logic and administrator maintenance, as well as potential application expansion in the future.

[0073] In some embodiments, the first software includes a first display area, and the first drawing is displayed in the first display area; the method further includes:

[0074] In response to a trigger operation on a specified entity among the at least one entity in the first display area, displaying entity information corresponding to the specified entity in the second display area;

[0075] In response to an editing operation on the entity information, displaying the edited entity information in the second display area;

[0076] In response to a confirmation operation for the editing operation, a data table corresponding to the entity information is updated based on the edited entity information.

[0077] Here, in BricsCAD, after logging into the project, you can create a new drawing. In order to distinguish the drawing types, users can choose layout drawings, system drawings, and terminal drawings. Figure 2 As shown in the drawing attribute interface. For 2D and 3D linkage, the drawings involved should include system drawings and corresponding layout drawings. The same equipment should be drawn at least once on the system drawing and once on the layout drawing.

[0078] In BricsCAD, a property sidebar is set in the right panel area. After opening the drawing, click on a handle on the drawing (it may be text, line, block), if the handle is already recorded in the database of an electrical device, its properties can be displayed, such as Figure 3 If you need to modify related parameters, such as the height from the ground, you can modify them directly, provided that the drawing has been checked out and is in an editable state, not a read-only state. In addition, to ensure the reliability of data during 2D and 3D linkage, the necessary parameters will be set to enumeration category types, and then when editing, users can only select from fixed drop-down lists, such as rib number, etc. Figure 4 The drop-down list management and application interface are shown in the figure.

[0079] After inputting the necessary 3D coordinates, the data can be exported for use in S3D. The interface design based on BricsCAD allows designers to use it in their daily life while ensuring the most familiar CAD operating environment. At the same time, the support for the database is increased, so that the required electrical parameters can be viewed and edited at any time, which can improve efficiency compared to the traditional file parameter search in Excel.

[0080] In some embodiments, the first software includes an export control; in response to the first export request, the entity information corresponding to the first drawing in the independent database is exported to obtain a first data file, including:

[0081] In response to a triggering operation on an export control in the first software, displaying at least one element included in the first drawing;

[0082] In response to a selection operation on the at least one element, determining an element to be exported from the at least one element;

[0083] In response to the determination operation on the to-be-exported component, the entity information corresponding to the to-be-exported original is exported to obtain the first data file, wherein the first data file is in Excel format.

[0084] Here, in BricsCAD, there is a special button for exporting coordinate information from the database, such as Figure 5 The data import and export button interface is shown in the figure. Click the component export to export an excel file with the required parameters. This excel file will be given to S3D for 3D modeling guidance. The data needs to include the following information:

[0085] Serial number, automatically generated.

[0086] AMD, only for S3D additional editing.

[0087] The equipment number, that is, the electrical equipment number, or PieceMark number, needs to ensure uniformity in the project, so that the two- and three-dimensional linkage is meaningful and unique throughout the ship.

[0088] Chinese name, that is, the attribute content of the same name.

[0089] English name, that is, the attribute content of the same name.

[0090] PartNumber, the attribute of the same name, is to ensure that S3D can find a code file to drive the creation of the model. Otherwise, S3D will not know what shape to use to create the device.

[0091] The rib position number refers to the attribute content with the same name.

[0092] The offset value x(m) is the attribute "rib number offset" in the database.

[0093] The offset value y(m) is the attribute "Y axis" in the database.

[0094] Deck, that is, the attribute "deck number" in the database.

[0095] The offset value z(m) is the attribute “height above the ground” in the database.

[0096] Room number, which is the attribute content of the same name.

[0097] Whether to import, only for S3D additional editing.

[0098] Based on the data source of the database, electrical designers can easily export the equipment parameters of the entire field without having to manually process the original Excel files.

[0099] In some embodiments, see Figure 6 , Figure 6 It is a flowchart of steps S201-S203 provided in an embodiment of the present application. The method also includes steps S201-S203, which will be described in combination with each step.

[0100] In step S201, in response to a second export request, a second data file corresponding to a third drawing is exported; wherein the third drawing is a three-dimensional drawing modified on the basis of the second drawing.

[0101] In step S202, the second data file is imported into the independent database, and the at least one data table is updated through the second data file.

[0102] In step S203, in response to the update request, the first drawing is updated based on the at least one updated data table, and the updated first drawing is displayed.

[0103] Here, when the user completes the modification of the third drawing in the second software, a second export request can be initiated. In response to this request, the system exports the second data file corresponding to the third drawing. This data file contains all the information of the modified three-dimensional drawing. The exported second data file is then imported into an independent database, and through this data file, at least one data table (a table storing entity information) in the independent database is updated to reflect the latest changes in the three-dimensional drawing. When the user or system initiates an update request, the system will update the first drawing (the original two-dimensional drawing) based on the updated data table. The updated first drawing will reflect the latest changes in the three-dimensional drawing and will be displayed in the two-dimensional software for the user to view.

[0104] This process not only realizes the conversion and import of data from 2D to 3D, but also realizes the export and update of data from 3D to 2D. This two-way data synchronization capability ensures the consistency between 2D and 3D drawings. With an independent database as an intermediary, the data of 2D and 3D drawings can be uniformly managed and maintained, ensuring the integrity and accuracy of the data. Users can design and modify in a 3D environment, and then reflect these modifications to the 2D drawings through the export and update process. This interactive method improves the flexibility and efficiency of design.

[0105] In some embodiments, updating the first drawing based on the updated at least one data table includes:

[0106] In response to a trigger operation for updating the control in the first software, determining whether the current drawing is a layout drawing, and if the current drawing is not the layout drawing, displaying corresponding prompt information;

[0107] If the current drawing is a layout drawing, update information is determined based on the at least one updated data table, wherein the update information includes bit number information, frame information, and base point information, wherein the bit number information includes entity information and attribute information, the frame information and the base point information are determined based on the entity information, and the base point information includes direction information, and the direction information is used to characterize whether the direction of the base point is horizontal or vertical, and one frame corresponds to only one base point;

[0108] An offset is determined based on the update information, and a corresponding entity is moved based on the offset.

[0109] Here, the latest coordinate information exported from S3D is imported back into the two-dimensional database. Two things need to be done: one is to update the relevant parameters of the equipment, and the other is to update the position of the handle of the layout drawing where the equipment is located.

[0110] Regarding the first point, updating the relevant parameters of the equipment will be done through a special webapi interface. After calling this interface, the Excel file selected will be passed from the client. The format of the current Excel file is also agreed with S3D in advance to ensure that the columns can correspond. After that, the interface will use the bit number to identify the unique primary key and update the corresponding attributes or parameters. At the same time, in the "engineering data attribute modification table", the history of the modification is recorded to facilitate some necessary judgments later. Regarding the second point, updating the layout drawing, a new update button is added to the BricsCAD interface. After clicking, the currently opened layout drawing will be operated. If it is not a layout drawing, a prompt will be given. Before updating, the relevant information of the layout drawing will be returned from the server through a special webapi interface. The relevant information includes bit number information, frame information, base point information, etc. Among them, the bit number information includes handle information and attribute information, while the frame and base point information are mainly based on handle information. All handle information will be used to find which block the corresponding device on the drawing is. There will be a constraint here, that is, there can only be one drawing expression for the same equipment on a layout drawing, otherwise it will cause misjudgment. After the program recognizes this situation, it will remind you. In order to update the layout drawing, it is necessary to identify the coordinate base point and convert the respective coordinates. Regarding the coordinate base point, the handle of the special object classification of the base point will be used as the standard. At the same time, it is also necessary to cooperate with the handle of the drawing frame, and then calculate whether a handle is included in its two-dimensional space range according to the size of the drawing frame. There will also be a constraint here, that is, there can only be one base point in a drawing frame, but since there are several drawing frames, there can be multiple base points in the entire dwg drawing. At the same time, the base point also has a concept of direction, and the program will realize the judgment of the direction of the base point, whether it is horizontal or vertical. These base points are when the designer draws the layout drawing before, and the system will judge whether there is a base point when the layout drawing is checked in and saved. At this point, the coordinate origin and orientation in each drawing frame have been judged, and then it can be judged in which drawing frame range each equipment bit number is included, so as to determine which coordinate system corresponding to which base point the bit number should be bound.

[0111] The next step is to determine where the device handle should be moved and repositioned. The coordinate origin and orientation are known, and we only need to know the latest coordinates of the bit number itself. Since it is a two-dimensional drawing, we only need to care about the two coordinate values ​​of x and y. For the x-axis, it is the rib bit number plus the rib bit number offset (which may be positive or negative); for the y-axis, it is the y-axis offset. After that, we can call the relevant interface of CAD to call this block to the latest position.

[0112] At the same time, you need to consider the conversion ratio of the drawing, which will be reflected in the properties of the drawing.

[0113] In summary, the embodiments of the present application have the following beneficial effects:

[0114] Through the business-based database architecture, the embodiment of the present application scientifically stores the equipment and related coordinate information, providing a solid foundation for the two-dimensional and three-dimensional integrated processing of electrical data. This architecture not only ensures the integrity and accuracy of the data, but also improves the efficiency of data query and update. Further, the method adopts an intuitive visual UI design to provide designers with a parameter editing interface that is visible as what you get. This interface enables designers to intuitively understand the entity information in the drawing and modify it as needed. Compared with the traditional discrete drawing allocation information, the method greatly improves the flexibility and efficiency of the design. Designers can easily edit parameters in a visual environment without manually entering or modifying complex coordinate information. In addition, using the secondary development capabilities of BricsCAD, the method realizes the export of all device information based on the connection information in the database. This function enables designers to easily export the device information in the two-dimensional drawing to the three-dimensional software for further design and analysis. At the same time, the method also supports the automatic update of the layout drawing according to the latest coordinates returned by S3D (or other three-dimensional software). This function greatly reduces the repeated input work of designers and improves the accuracy and efficiency of the design. Finally, through the implementation of this method, the effect of partial two-dimensional and three-dimensional linkage is achieved. When the equipment or layout in the 3D drawing changes, these changes can be automatically reflected in the 2D drawing without the need for designers to manually update. This linkage effect not only ensures consistency between 2D and 3D drawings, but also improves the overall efficiency and quality of the design.

[0115] In summary, the embodiment of the present application provides designers with an efficient, convenient and accurate 2D and 3D integrated processing tool for electrical data through scientific database architecture, intuitive visual UI design, secondary development of BricsCAD and realization of 2D and 3D linkage effects. This tool not only reduces design cost and time cost, but also improves design flexibility and accuracy.

[0116] Based on the same inventive concept, the embodiment of the present application also provides an electrical data two-dimensional integrated processing device corresponding to the electrical data two-dimensional integrated processing method in the first embodiment. Since the principle of solving the problem by the device in the embodiment of the present application is similar to the above-mentioned electrical data two-dimensional integrated processing method, the implementation of the device can refer to the implementation of the method, and the repeated parts will not be repeated.

[0117] like Figure 7 As shown, Figure 7 2 is a schematic diagram of the structure of the electrical data two-dimensional and three-dimensional integrated processing device 700 provided in an embodiment of the present application. The electrical data two-dimensional and three-dimensional integrated processing device 700 includes:

[0118] The creation module 701 is used to create a first drawing in a first software in response to a drawing creation request; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each entity in the at least one entity corresponds to an entity information, the entity information is used to link two-dimensional and three-dimensional data, the entity information is stored in an independent database, the independent database includes at least one data table, and each data table in the at least one data table is used to store part of the entity information;

[0119] An export module 702 is used to export the entity information corresponding to the first drawing in the independent database in response to a first export request to obtain a first data file;

[0120] The import module 703 is used to import the first data file into the second software in response to the import request, so that the second software creates a second drawing based on the data file; wherein the second software is a three-dimensional software, and the second drawing is a three-dimensional drawing created by the three-dimensional software.

[0121] Those skilled in the art should understand that Figure 7 The functions of each unit in the electrical data two-dimensional and three-dimensional integrated processing device 700 can be understood by referring to the related description of the electrical data two-dimensional and three-dimensional integrated processing method described above. Figure 7 The functions of the various units in the electrical data two-dimensional and three-dimensional integrated processing device 700 shown can be implemented by a program running on a processor, or can be implemented by a specific logic circuit.

[0122] In a possible implementation manner, the electrical data 2D / 3D integrated processing device 700 further includes an updating module 704, and the updating module 704 is used to export the second data file corresponding to the third drawing in response to the second export request; wherein the third drawing is a 3D drawing modified on the basis of the second drawing;

[0123] Importing the second data file into the independent database, and updating the at least one data table through the second data file;

[0124] In response to the update request, the first drawing is updated based on the at least one updated data table, and the updated first drawing is displayed.

[0125] In a possible implementation, the electrical data is ship electrical data, and the entity information realizes two-dimensional and three-dimensional data linkage by defining a target coordinate system in the two-dimensional software, and the target coordinate system includes an X-axis, a Y-axis, and a Z-axis;

[0126] The coordinate of the X-axis is determined based on the rib number and the rib number offset;

[0127] The Y-axis coordinate is determined based on the offset from the centerline of the ship, with a positive value representing the right side from the stern to the bow and a negative value representing the left side from the stern to the bow;

[0128] The Z-axis represents altitude information, and the coordinate of the Z-axis is determined based on a deck number and / or a height above the ground.

[0129] In a possible implementation, the independent database is used to store at least the following information:

[0130] Equipment information, coordinate parameter information corresponding to the equipment, enumeration list matching the parameter information, layout information, base point information, and report information;

[0131] The equipment information includes the PieceMark number, equipment classification, and description information of the electrical equipment; the coordinate parameter information corresponding to the equipment includes the rib number, height from the ground, room number, deck number, and Y-axis offset; the enumeration list matching the parameter information includes the rib number and deck number, and the enumeration list matching the parameter information is used for standardized selection; the layout information is used to store the data of the first drawing, and the layout information includes drawings, handles, and drawing scales; the base point information is used to determine multiple drawing frames in the first drawing; the report information is used to store report definitions for the three-dimensional software;

[0132] The at least one data table forms a foreign key through a primary key to combine the at least one data table.

[0133] In a possible implementation, the first software includes a first display area, and the first drawing is displayed in the first display area; the updating module 704 further includes:

[0134] In response to a trigger operation on a specified entity among the at least one entity in the first display area, displaying entity information corresponding to the specified entity in the second display area;

[0135] In response to an editing operation on the entity information, displaying the edited entity information in the second display area;

[0136] In response to a confirmation operation for the editing operation, a data table corresponding to the entity information is updated based on the edited entity information.

[0137] In a possible implementation, the first software includes an export control; the export module 702 exports the entity information corresponding to the first drawing in the independent database in response to the first export request to obtain a first data file, including:

[0138] In response to a triggering operation on an export control in the first software, displaying at least one element included in the first drawing;

[0139] In response to a selection operation on the at least one element, determining an element to be exported from the at least one element;

[0140] In response to the determination operation on the to-be-exported component, the entity information corresponding to the to-be-exported original is exported to obtain the first data file, wherein the first data file is in Excel format.

[0141] In a possible implementation manner, the updating module 704 updates the first drawing based on the at least one updated data table, including:

[0142] In response to a trigger operation for updating the control in the first software, determining whether the current drawing is a layout drawing, and if the current drawing is not the layout drawing, displaying corresponding prompt information;

[0143] If the current drawing is a layout drawing, update information is determined based on the at least one updated data table, wherein the update information includes bit number information, frame information, and base point information, wherein the bit number information includes entity information and attribute information, the frame information and the base point information are determined based on the entity information, and the base point information includes direction information, and the direction information is used to characterize whether the direction of the base point is horizontal or vertical, and one frame corresponds to only one base point;

[0144] An offset is determined based on the update information, and a corresponding entity is moved based on the offset.

[0145] The above-mentioned two-dimensional and three-dimensional integrated processing device for electrical data uses a business-based database architecture, and the embodiment of the present application scientifically stores the equipment and related coordinate information, providing a solid foundation for the two-dimensional and three-dimensional integrated processing of electrical data. This architecture not only ensures the integrity and accuracy of the data, but also improves the efficiency of data query and update. Further, the method adopts an intuitive visual UI design to provide designers with a parameter editing interface that is visible as what you get. This interface enables designers to intuitively understand the entity information in the drawing and modify it as needed. Compared with the traditional discrete drawing allocation information, the method greatly improves the flexibility and efficiency of the design. Designers can easily edit parameters in a visual environment without manually entering or modifying complex coordinate information. In addition, using the secondary development capabilities of BricsCAD, the method realizes the export of all equipment information based on the connection information in the database. This function enables designers to easily export the equipment information in the two-dimensional drawing to the three-dimensional software for further design and analysis. At the same time, the method also supports the automatic update of the layout drawing according to the latest coordinates returned by S3D (or other three-dimensional software). This function greatly reduces the repeated input work of designers and improves the accuracy and efficiency of the design. Finally, through the implementation of this method, the effect of partial 2D and 3D linkage was achieved. When the equipment or layout in the 3D drawing changes, these changes can be automatically reflected in the 2D drawing without the need for designers to manually update. This linkage effect not only ensures the consistency between 2D and 3D drawings, but also improves the overall efficiency and quality of the design.

[0146] In summary, the embodiment of the present application provides designers with an efficient, convenient and accurate 2D and 3D integrated processing tool for electrical data through scientific database architecture, intuitive visual UI design, secondary development of BricsCAD and realization of 2D and 3D linkage effects. This tool not only reduces design cost and time cost, but also improves design flexibility and accuracy.

[0147] like Figure 8 As shown, Figure 8 The present invention provides a schematic diagram of the structure of an electronic device 800 according to an embodiment of the present invention. The electronic device 800 includes:

[0148] A processor 801, a storage medium 802 and a bus 803, wherein the storage medium 802 stores machine-readable instructions executable by the processor 801. When the electronic device 800 is running, the processor 801 communicates with the storage medium 802 via the bus 803, and the processor 801 executes the machine-readable instructions to perform the steps of the two-dimensional and three-dimensional integrated processing method of electrical data described in the embodiment of the present application.

[0149] In actual application, the components in the electronic device 800 are coupled together via bus 803. It is understood that bus 803 is used to realize the connection and communication between these components. Bus 803 includes not only a data bus, but also a power bus, a control bus and a status signal bus. However, for the sake of clarity, Figure 8 Various buses are labeled as bus 803.

[0150] The electronic device mentioned above uses a database architecture based on business, and the embodiment of the present application scientifically stores the device and related coordinate information, providing a solid foundation for the two-dimensional and three-dimensional integrated processing of electrical data. This architecture not only ensures the integrity and accuracy of the data, but also improves the efficiency of data query and update. Further, the method adopts an intuitive visual UI design to provide designers with a parameter editing interface that is visible as what you get. This interface enables designers to intuitively understand the entity information in the drawing and modify it as needed. Compared with the traditional discrete drawing allocation information, the method greatly improves the flexibility and efficiency of the design. Designers can easily edit parameters in a visual environment without manually entering or modifying complex coordinate information. In addition, using the secondary development capabilities of BricsCAD, the method realizes the export of all device information based on the connection information in the database. This function enables designers to easily export the device information in the two-dimensional drawing to the three-dimensional software for further design and analysis. At the same time, the method also supports the automatic update of the layout drawing according to the latest coordinates returned by S3D (or other three-dimensional software). This function greatly reduces the repeated input work of designers and improves the accuracy and efficiency of the design. Finally, through the implementation of this method, the effect of partial two-dimensional and three-dimensional linkage is achieved. When the equipment or layout in the 3D drawing changes, these changes can be automatically reflected in the 2D drawing without the need for designers to manually update. This linkage effect not only ensures consistency between 2D and 3D drawings, but also improves the overall efficiency and quality of the design.

[0151] In summary, the embodiment of the present application provides designers with an efficient, convenient and accurate 2D and 3D integrated processing tool for electrical data through scientific database architecture, intuitive visual UI design, secondary development of BricsCAD and realization of 2D and 3D linkage effects. This tool not only reduces design cost and time cost, but also improves design flexibility and accuracy.

[0152] The embodiment of the present application also provides a computer-readable storage medium, which stores executable instructions. When the executable instructions are executed by at least one processor 801, the two-dimensional and three-dimensional integrated processing method of electrical data described in the embodiment of the present application is implemented.

[0153] In some embodiments, the storage medium can be a magnetic random access memory (FRAM), a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), a flash memory, a magnetic surface storage, an optical disk, or a compact disc read-only memory (CD ROM); it can also be various devices including one or any combination of the above memories.

[0154] In some embodiments, executable instructions may be in the form of a program, software, software module, script or code, written in any form of programming language (including compiled or interpreted languages, or declarative or procedural languages), and may be deployed in any form, including as a stand-alone program or as a module, component, subroutine or other unit suitable for use in a computing environment.

[0155] As an example, executable instructions may, but do not necessarily, correspond to a file in a file system, may be stored as part of a file that stores other programs or data, for example, in one or more scripts in a HyperText Markup Language (HTML) document, in a single file dedicated to the program in question, or in multiple coordinated files (for example, files storing one or more modules, subroutines, or code portions).

[0156] By way of example, executable instructions may be deployed to be executed on one computing device, or on multiple computing devices located at one site, or on multiple computing devices distributed across multiple sites and interconnected by a communication network.

[0157] The computer-readable storage medium uses a business-based database architecture, and the embodiment of the present application scientifically stores the equipment and related coordinate information, providing a solid foundation for the two-dimensional and three-dimensional integrated processing of electrical data. This architecture not only ensures the integrity and accuracy of the data, but also improves the efficiency of data query and update. Further, the method adopts an intuitive visual UI design to provide designers with a parameter editing interface that is visible as what you get. This interface enables designers to intuitively understand the entity information in the drawing and modify it as needed. Compared with the traditional discrete drawing allocation information, the method greatly improves the flexibility and efficiency of the design. Designers can easily edit parameters in a visual environment without manually entering or modifying complex coordinate information. In addition, using the secondary development capabilities of BricsCAD, the method realizes the export of all device information based on the connection information in the database. This function enables designers to easily export the device information in the two-dimensional drawing to the three-dimensional software for further design and analysis. At the same time, the method also supports the automatic update of the layout drawing according to the latest coordinates returned by S3D (or other three-dimensional software). This function greatly reduces the repeated input work of designers and improves the accuracy and efficiency of the design. Finally, through the implementation of this method, the effect of partial 2D and 3D linkage was achieved. When the equipment or layout in the 3D drawing changes, these changes can be automatically reflected in the 2D drawing without the need for designers to manually update. This linkage effect not only ensures the consistency between 2D and 3D drawings, but also improves the overall efficiency and quality of the design.

[0158] In summary, the embodiment of the present application provides designers with an efficient, convenient and accurate 2D and 3D integrated processing tool for electrical data through scientific database architecture, intuitive visual UI design, secondary development of BricsCAD and realization of 2D and 3D linkage effects. This tool not only reduces design cost and time cost, but also improves design flexibility and accuracy.

[0159] In the several embodiments provided in the present application, it should be understood that the disclosed methods and electronic devices can be implemented in other ways. The device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as: multiple units or components can be combined, or can be integrated into another system, or some features can be ignored or not executed. In addition, the coupling, direct coupling, or communication connection between the components shown or discussed can be through some interfaces, and the indirect coupling or communication connection of the devices or units can be electrical, mechanical or other forms.

[0160] The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0161] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0162] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a non-volatile computer-readable storage medium that is executable by a processor. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a platform server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard drives, ROM, RAM, magnetic disks, or optical disks.

[0163] The above are only specific implementations of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A two-dimensional and three-dimensional integrated processing method for electrical data, characterized in that: The method comprises: In response to a drawing creation request, a first drawing is created in a first software; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each entity in the at least one entity corresponds to entity information, the entity information is used to link two-dimensional and three-dimensional data, the entity information is stored in an independent database, the independent database includes at least one data table, and each data table in the at least one data table is used to store part of the entity information; In response to a first export request, exporting entity information corresponding to the first drawing in the independent database to obtain a first data file; In response to an import request, the first data file is imported into a second software so that the second software creates a second drawing based on the data file; wherein the second software is a three-dimensional software, and the second drawing is a three-dimensional drawing created by the three-dimensional software.

2. The method according to claim 1, characterized in that The method further comprises: In response to the second export request, export the second data file corresponding to the third drawing; wherein the third drawing is a three-dimensional drawing modified on the basis of the second drawing; Importing the second data file into the independent database, and updating the at least one data table through the second data file; In response to the update request, the first drawing is updated based on the at least one updated data table, and the updated first drawing is displayed.

3. The method according to claim 1, characterized in that The electrical data is ship electrical data, and the entity information realizes two-dimensional and three-dimensional data linkage by defining a target coordinate system in the two-dimensional software, and the target coordinate system includes an X-axis, a Y-axis and a Z-axis; The coordinate of the X-axis is determined based on the rib number and the rib number offset; The Y-axis coordinate is determined based on the offset from the centerline of the ship, with a positive value representing the right side from the stern to the bow and a negative value representing the left side from the stern to the bow; The Z-axis represents altitude information, and the coordinate of the Z-axis is determined based on a deck number and / or a height above the ground.

4. The method according to claim 3, characterized in that: The independent database is used to store at least the following information: Equipment information, coordinate parameter information corresponding to the equipment, enumeration list matching the parameter information, layout information, base point information, and report information; The equipment information includes the PieceMark number, equipment classification, and description information of the electrical equipment; the coordinate parameter information corresponding to the equipment includes the rib number, height from the ground, room number, deck number, and Y-axis offset; the enumeration list matching the parameter information includes the rib number and deck number, and the enumeration list matching the parameter information is used for standardized selection; the layout information is used to store the data of the first drawing, and the layout information includes drawings, handles, and drawing scales; the base point information is used to determine multiple drawing frames in the first drawing; the report information is used to store report definitions for the three-dimensional software; The at least one data table forms a foreign key through a primary key to combine the at least one data table.

5. The method according to claim 1, characterized in that The first software includes a first display area, and the first drawing is displayed in the first display area; the method further includes: In response to a trigger operation on a specified entity among the at least one entity in the first display area, displaying entity information corresponding to the specified entity in the second display area; In response to an editing operation on the entity information, displaying the edited entity information in the second display area; In response to a confirmation operation for the editing operation, a data table corresponding to the entity information is updated based on the edited entity information.

6. The method according to claim 1, characterized in that The first software includes an export control; in response to the first export request, the entity information corresponding to the first drawing in the independent database is exported to obtain a first data file, including: In response to a triggering operation on an export control in the first software, displaying at least one element included in the first drawing; In response to a selection operation on the at least one element, determining an element to be exported from the at least one element; In response to the determination operation on the to-be-exported component, the entity information corresponding to the to-be-exported original is exported to obtain the first data file, wherein the first data file is in Excel format.

7. The method according to claim 2, characterized in that The updating of the first drawing based on the at least one updated data table includes: In response to a trigger operation for updating the control in the first software, determining whether the current drawing is a layout drawing, and if the current drawing is not the layout drawing, displaying corresponding prompt information; If the current drawing is a layout drawing, update information is determined based on the at least one updated data table, wherein the update information includes bit number information, frame information, and base point information, wherein the bit number information includes entity information and attribute information, the frame information and the base point information are determined based on the entity information, and the base point information includes direction information, and the direction information is used to characterize whether the direction of the base point is horizontal or vertical, and one frame corresponds to only one base point; An offset is determined based on the update information, and a corresponding entity is moved based on the offset.

8. A two-dimensional and three-dimensional integrated processing device for electrical data, characterized in that: The device comprises: A creation module, configured to create a first drawing in a first software in response to a drawing creation request; wherein the first software is a two-dimensional software, the first drawing is a two-dimensional drawing created by the two-dimensional software, the first drawing includes at least one entity, each entity in the at least one entity corresponds to an entity information, the entity information is used to link two-dimensional and three-dimensional data, the entity information is stored in an independent database, the independent database includes at least one data table, and each data table in the at least one data table is used to store part of the entity information; An export module, configured to export the entity information corresponding to the first drawing in the independent database in response to a first export request to obtain a first data file; An import module is used to import the first data file into a second software in response to an import request, so that the second software creates a second drawing based on the data file; wherein the second software is a three-dimensional software, and the second drawing is a three-dimensional drawing created by the three-dimensional software.

9. An electronic device, characterized in that: include: A processor, a storage medium and a bus, wherein the storage medium stores machine-readable instructions executable by the processor. When the electronic device is running, the processor communicates with the storage medium via the bus, and the processor executes the machine-readable instructions to perform the two-dimensional and three-dimensional integrated processing method for electrical data 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 a computer program, and when the computer program is executed by a processor, the two-dimensional and three-dimensional integrated processing method of electrical data according to any one of claims 1 to 7 is executed.

Images