Design And Implementation Of The Enterprise Standardization Based On VBA CAD Plug-in

This thesis mainly introduces how to solve the disunited problem between the enterprise-level CAD design frames and the catalog standards, and to provide standardized tools to enable designers to improve the design efficiency through secondary development of CAD plug-in. Also, this study researches and realizes a CAD standardized drawing plug-in tool based on VBA, LISP secondary development technologies, to replace the repeating mapping work and to improve production efficiency.Through ample communication, collection and analysis of the common demands of enterprises' CAD drawing design personnel, the author found that most domestic drawing related enterprises have their own standard file. While using, designers normally create a figure according to each project and copy it into the standard file manually, then place a figure box in the CAD. This process is supposed to be repeated at least once for each single project with high multiplicity, and different operators may draw the boxes differently. Hence more drawers and projects will produce more types of frames and boxes, which increase the difficulty of management. This thesis is to strengthen enterprise drawing standardization management, reverse CAD drawing chaos, promote the industrialization of the technology and standards of independent products, and to meet the urgent needs of national economic construction and information management. Also, UML will be used as the unified modeling language, andcase diagrams and activity diagrams as description language.Based on the collected demand analysis, the author uses flow diagram, sequence diagram and interface design to describe the idea of program design and execution. The primary function modules are insert design standard drawing frame function module, insert design standard directory function module, drawing comparison function module, frame split function module, font substitution function module, menu call module, plug-in installation function module. Also, the interfaces and operation processes of each function have been designed. Then the author executes each module according to the designs, and uses flow and sequence diagrams to describe the plug-in code logic and call sequence for the execution.Finally, after thoroughly functional and non-functional tests for the executed programs, all plug-ins meet the expected results. The set of VBA based and enterprise-level CAD standardized plug-insdesigned and executed by this thesis not only completes the plug-in installation, menu calls, frame insertion, catalogue insertion, graphical comparison, frame split, font substitution function, but also realizes the adoption of standard drawing specification to avoid misunderstandings or accidents caused by disunited drawing frames. In addition, through the application of computers and plug-ins, both the accuracy of the drawing resultsand the efficiency of the designers will be improved.