Standard parts database and query module. This module provides access to data on standard components as defined in the National Standard for Stamping, enabling designers to quickly retrieve specific shape and size parameters of required mold components without manually searching through physical standards. It also offers a powerful search function that automatically selects appropriate standard parts based on predefined parameters and selection criteria, improving efficiency and reducing errors during the design process.
Standard part class module. This module supports multiple functions, including calculating coordinates of each point in a drawing based on given parameters, generating detailed drawings of various standard parts, automatically annotating dimensions, tolerances, surface roughness, and text, and creating a title block. Additionally, it allows users to preview generated graphics, making the design and documentation process more streamlined and accurate.
The establishment of the library is carried out within a parameterized library system for standard parts. Although the shapes of standard parts may vary, the overall process for building the library remains largely consistent. The key step is creating a comprehensive and well-organized database, which is essential due to the large volume of related data. A well-structured database significantly simplifies future design tasks and enhances productivity.
For example, consider the data of the rear guide post mold base from the national die standard. This component has 16 parameters, with L, B, H or D0, H being the dominant ones. For a lower mold base with a concave shape, L, B, and H are the main parameters, while for a circular concave mold, D0 and H are the key factors. Once these leading parameters are determined, the specifications of the lower mold base can be fully defined. Therefore, the primary challenge in building the library is to create an effective database and ensure accurate search functionality.
This system uses VB (Visual Basic) combined with an external program and Visual Data Manager 0 to create an Access database named "rear side guide post lower mold base.mdb". The table in the database is called "hxm0", containing 17 fields—each representing a parameter, with zero used when a value is not available. Each record corresponds to a modular base. By using the leading parameters in the table, other parameters can be retrieved via SQL queries. For instance, if D0 is 200mm and H is 50mm, a query like "SELECT * FROM hxm0 WHERE D0 = 200 AND H = 50" can be executed to retrieve the full set of parameters. These results can then be used to generate previews and drawings in AutoCAD R14.
Conclusion: This system utilizes VB, an easy-to-learn and powerful object-oriented programming language, to perform secondary development on AutoCAD R14. The parameterized catalog of mold standard parts significantly reduces the design cycle and accelerates product updates. It also provides valuable insights into the application of VB in other engineering fields, offering practical benefits for real-world production environments.
Pressure Instrument,Oil Pressure Transmitter,Level Pressure Sensor,Intelligent Differential Pressure Meter
Jiangsu Pinpai Technology Co., Ltd. , https://www.jspingpa.com