Design And Implementation Of Product Drawing Management System

With the aggravation of the market competition, product replacement becomes change rapidly. And the birth of new products is often based on improved processing based on old products. However, the process of new product design, engineering drawings a lot needs to be designed, modify, see is inevitable. These documents are mainly scattered in various departments and individuals, not effectively centralized management, resulting in a large number of data accumulation, the document can not be fully utilized, which makes the search, management and delivery of enterprise information in documents becomes increasingly important.In view of this phenomenon, in the enterprise implementation of product data management (PDM) system, from the documents, drawings, data entry (Electronic) whole to document publishing and network management solutions, which can effectively reduce the drawings input and information costs, ensure document security, improve the response speed of document search, query, facilitate remote information acquisition, contribute to transfer and sharing of knowledge and information, and design units to make drawings management specialization, standardization, to lay a more solid foundation for the document management department of the safe, efficient operation. The design uses VBA on the AutoCAD platform as a development tool, the realization of SQL database management system.The design drawings and documents management in one, set up electronic drawing database for the user, the user through the classification retrieval or condition combination query, fuzzy search get the drawings or information.According to the design of plant electrical diagram face the problem and problem, solved the actual demand in electrical engineering data query, statistics and summary, is to the product data management (PDM) is an important supplement to the system.