A general layer rapid drawing method based on ObjectARX and Excel combination

Abstract

The application discloses a general layer rapid drawing method based on combination of ObjectARX and Excel, which comprises loading an arx program in AutoCAD and running; dividing a drawing into cells according to positioning lines, taking the cells as positioning references, distributing parts of a layer on four sides of the cells, inputting XY direction positioning points in an Excel file; clicking to import XY direction positioning data in a software interface; inputting part data defined by X direction and Y direction existing blocks in the Excel file and one-key importing into the software interface; presetting part block attribute according to a view name of the input part and automatically inserting; further removing all walkway beam areas of corner areas of generated drawings, generating walkway beam and expansion beam panels; importing data in the Excel into the software interface, and rapidly generating a part arrangement drawing of a general layer. The application has the advantages of fast drawing speed, 70% time reduction compared with traditional manual drawing, convenient use, efficient function and strong reusability of codes.

Description

Technical Field

[0001] This invention relates to the field of LNG ship containment system installation platforms, and in particular to a method for rapid generation of general-purpose layer drawings for containment system installation platforms based on the combination of ObjectARX and EXCEL. Background Technology

[0002] Currently, ship design departments face a rather cumbersome process when designing and drawing component layout diagrams for containment system installation platforms. Taking the NO96 type containment system installation platform as an example, before drawing the diagrams, it's necessary to divide the platform into layers, spans, etc., based on the dimensions of the cargo tanks, and design the support leg arrangement according to GTT's pressure requirements for the support legs. After the parametric design is completed, engineers search for parts of suitable dimensions in the parts library and manually arrange the parts in AutoCAD. In previous design work, engineers often had to create individual part blocks and insert them into the AutoCAD drawings, requiring a significant amount of repetitive work. Without reference drawings after the parametric design of the installation platform, the drawing of its component layout diagrams often takes a very long time.

[0003] After the parts layout drawing is completed, engineers need a large amount of drawing data, including the parts bill of materials, the weight center of the drawing area, etc. They also need to arrange the telescopic beam panels, walkway beam panels, and platform panels based on the parts layout drawing. The calculation of this drawing data and the further generation of drawings consume a lot of time and are prone to errors during the calculation process. Summary of the Invention

[0004] Purpose of the invention: The purpose of this invention is to provide a method for rapid drawing of a general layer of an enclosure system installation platform based on the combination of ObjectARX and EXCEL.

[0005] Technical solution: This method includes the following steps:

[0006] S1: Load the ARX program in AutoCAD, run it using the APPLOAD command, enter "Quickly output drawing" and jump to the main interface of the software;

[0007] S2: Divide the drawing into cells according to the positioning lines, use the cells as positioning references, and distribute the parts of the layer on the four sides of the cells. Enter the positioning points in the XY direction in the Excel file.

[0008] S3: Click "Import XY Direction Positioning Data" in the software interface. The span data corresponding to the positioning point will be displayed in the table on the right side of the software interface.

[0009] S4: input the part data defined by X direction and Y direction block in the Excel file, and import into the software interface by one key;

[0010] S5: according to the view name of the input part, preset the part block attribute and automatically insert the corresponding block;

[0011] S6: click the steel jump plate and the expansion beam panel generation button, remove all walkway beam areas of the generated drawing further, and generate the walkway beam and the expansion beam panel;

[0012] S7: import the data in the Excel into the software interface, and quickly generate the part arrangement drawing of the general layer according to the drawing algorithm.

[0013] Further, in the step S2, the system divides the part drawing into cells according to the positioning line, and the arrangement of the parts takes the cell as the positioning reference.

[0014] Further, in the step S3, the widths and span distributions of different layers are different, the X and Y direction span distributions of the installation platform are input in each layer, and the span distributions are saved as sequences {X n} and {Y n}.

[0015] Further, in the step S3, the system internally generates a Y row and X column span two-dimensional array, the number of rows of the two-dimensional array is the same as the number of columns in the part arrangement table in the ship width direction plus one and the number of rows in the part arrangement table in the ship length direction plus one, and the number of columns of the two-dimensional array is the same as the number of rows in the part arrangement table in the ship width direction and the number of columns in the part arrangement table in the ship length direction.

[0016] Further, in the step S4, the input parameters of the EXCEL table are the part numbers of each cell edge positioned by X and Y coordinates, the parts are divided into X direction and Y direction arrangement according to the distribution direction of the cell edge, two part input tables of X direction and Y direction are established in the EXCEL file, and the user inputs the part numbers in X and Y directions according to the part arrangement in each cell.

[0017] Further, in the step S6, the walkway beam panel is laid according to the length of the walkway part of the walkway beam, and is composed of a fixed width steel jump plate and a plywood.

[0018] Beneficial effects: compared with the prior art, the present application has the following obvious advantages: fast drawing speed, after inputting the part arrangement data in Excel, the data is imported into the cad by one key, and the part arrangement drawing is quickly generated according to the part arrangement information, the drawing speed is fast, compared with the traditional manual drawing, the time is shortened by 70%, the use is convenient, the function is efficient, the code has strong reusability, the manual intervention is less, the drawing process is highly automated, the error rate is low, and the drawing style is consistent.BRIEF DESCRIPTION OF DRAWINGS BRIEF DESCRIPTION OF DRAWINGS

[0019] Figure 1 Flow chart of the present application. DETAILED DESCRIPTION

[0020] The technical solutions of the present application will be further described below in combination with the drawings.

[0021] As Figure 1 shown, a general layer rapid drawing method of a building envelope system installation platform based on ObjectARX combined with EXCEL, comprising the following steps:

[0022] S1: After loading the arx program in AutoCAD, run through the APPLOAD command; the specific implementation method is:

[0023] Open AutoCAD, load the generated arx program, and after displaying that the loading is successful, input "rapid drawing" to jump to the software main interface.

[0024] S2: According to the part arrangement style, first, divide the drawing into cells according to the positioning line, take the cell as the positioning reference, and the parts of the layer are distributed on the four sides of the cell. There is no part inside the cell, and it is necessary to input the XY direction positioning point in the excel file; the specific implementation method is: arbitrarily create an excel file, name sheet1 as "XY positioning point", and then input the specific XY direction span data in sheet1.

[0025] S3: Click to import the XY direction positioning data in the software interface, and the positioning point corresponding span data is displayed in the table on the right side of the software interface; the specific implementation method is: open the software general layer main interface, click to import the XY direction positioning point, and the data in sheet1 will be imported into the table on the lower right of the software. The system will automatically generate a two-dimensional array of Y rows and X columns. It may cause program crash due to array access out of bounds; the specific solution is: the number of rows of the two-dimensional array must be the same as the number of columns in the part arrangement table of the ship width direction plus one, and the number of rows of the two-dimensional array must be the same as the number of columns in the part arrangement table of the ship length direction plus one.

[0026] S4: Since the input parameter of the system is the part number of each unit cell edge positioned by X and Y coordinates, after inputting the X direction and Y direction part data in the excel file, one-key import into the software interface, making it more intuitive and simple; the specific implementation method is:

[0027] The connection between MFC and Excel is established, and the response functions are set for the buttons of "Import X direction parts" and "Import Y direction parts". The functions of LongLayOut() and WightLayOut() are written to realize the layout of parts in the length and width directions of the ship,

[0028] It is also necessary to ensure that the inserted parts have block definitions. The specific implementation is as follows:

[0029] The part data input in Excel is transmitted into the part definition function SetItemText() as a parameter through the connection function between MFC and Excel, so as to ensure that the inserted parts have block definitions.

[0030] S5: According to the input parts, the block attributes of the parts are preset and the corresponding blocks are automatically inserted. The specific implementation method is as follows:

[0031] The OnInitListCtr and OnInitListCtr2 functions are used to create and obtain the names and definitions of the current corresponding blocks, and the pointer of AcDbObjectIterator is created to obtain the attribute iterator of the blocks.

[0032] S6: The walkway girder and telescopic girder panel generation buttons on the system interface are clicked to generate walkway girders and telescopic girder panels in the area of all walkway girders and telescopic girder panels except the corner area. The specific implementation method is as follows: The block table of the current database is obtained through the SteelSpringboard() function and the TelescopicGirderboard() function in the LeveTwo class to realize the generation of the steel springboard and telescopic girder panel.

[0033] S7: The part layout diagram generation button is clicked to quickly generate a part layout diagram. The specific implementation method is as follows:

[0034] The insertion points corresponding to the parts are inserted through the AcGePoint3dArray class, and the loop statement is used to check whether the part block definition specified by the user exists. When it is found that all the part blocks have been inserted, the part layout diagram is generated according to the drawing generation algorithm.

Claims

1. A general layer quick drawing method based on ObjectARX combined with Excel, characterized in that: The method comprises the following steps: S1: loading arx program in AutoCAD, running through APPLOAD command, inputting "quick drawing" and jumping to the main interface of the software; S2: dividing the drawing into cells according to the positioning line, taking the cell as the positioning reference, distributing the parts of the layer on the four edges of the cell, and inputting the XY direction positioning points in the Excel file; S3: clicking the imported XY direction positioning data in the software interface, and displaying the positioning point corresponding span data in the table on the right side of the software interface; S4: inputting the part data defined by the X direction and Y direction existing blocks in the Excel file, and one-key importing into the software interface; S5: presetting the part block attribute according to the view name of the input part, and automatically inserting the corresponding block; S6: clicking the steel jump plate and telescopic beam panel generation button, further removing all walkway beam areas in the corner area of the generated drawing, and generating the walkway beam and telescopic beam panel; S7: importing the data in the Excel into the software interface, and quickly generating the part arrangement drawing of the general layer according to the drawing algorithm; The width of different layers in the step S3 is different from the span distribution, the span distribution of the X, Y direction of the input installation platform is saved as a sequence and ; In the step S3, the system internally generates a Y row and X column span two-dimensional array, the row number of the two-dimensional array is the same as the column number in the part arrangement table in the ship width direction plus one and the row number in the part arrangement table in the ship length direction plus one, and the column number of the two-dimensional array is the same as the row number in the part arrangement table in the ship width direction and the column number in the part arrangement table in the ship length direction. In the step S4, the input parameters of the EXCEL table are the part numbers of each cell edge positioned by X and Y coordinates, the parts are divided into X direction and Y direction arrangement according to the distribution direction of the cell edge, the X direction and Y direction part input tables are established in the EXCEL file, and the user inputs the part numbers in the X and Y directions according to the part arrangement in each cell.

2. The method of claim 1, wherein the ObjectARX-based and Excel-combined general layer quick drawing method is characterized by: In the step S2, the system divides the part drawing into cells according to the positioning line, and the arrangement of the parts takes the cell as the positioning reference.

3. The method of claim 1, wherein the ObjectARX-based and Excel-combined general layer quick drawing method is characterized by: In the step S6, the walkway beam panel is laid according to the length of the walkway part of the walkway beam, and is composed of fixed-width steel jump plates and plywood.

Images