Database Technology Software Development

Application of Database Technology in ARX Software Development

In engineering practice, in order to improve the efficiency of drawing and design, ARX technology is used for secondary development of CAD. This method is widely used in engineering and provides a standardized model for the design process. Among the three development interface technologies of CAD, the ARX program is the most suitable tool for secondary development of CAD, which can effectively utilize the resources provided by ARX, and release products to the outside world by utilizing abundant resources in the VC development environment . During the secondary development of CAD, it can be found that the design of its software can only satisfy the drawing of graphics, and it cannot effectively manage the data and software structure. Therefore, the application of database technology in the development of ARX program software can improve the framework system of secondary software development and facilitate the management work in the later stage of software development, so as to realize the centralized management of CAD system, ERP and PDM data, and other sub-systems. System integration work.

1. Introduction to the meaning of ARX program

ARX is the latest software secondary development technology in modern times. It supports the writing and application program of c language, allowing developers to make full use of CAD graphics software and can directly access it. ARX program can be used together with the programming interface of CAD software. The application program developed in the ARX program is essentially a dynamic link library, that is, a DLL, so that CAD can share and communicate with its address space. The running speed of the ARX program is improved, and the function of the program is also enhanced. New derivatives are established through the ARX program and shared with other programs, so that programming can be fully utilized. The ARX program, LISP, and VBA program are the third software development tools. The ARX program is an open architecture, which can directly access and operate the CAD software. The ARX program can use the functions outside the database Call to initialize the graphics database, create database objects, edit and save database objects, so that the graphics database CAD can generate visible and invisible solid geometric objects, build symbol tables and dictionaries, Its essence is to add block table records to CAD, form a dynamic link, enable CAD software to share with other application systems, improve program functions, and directly access and browse CAD software.

2. Database technology selection in ARX program

The access of ARX program to the external database can be accessed and developed on the VC development platform according to the programming interface ASI provided by CAD. Using the ASI library function to access the external database requires developers to learn the relevant professional knowledge of ASI. Due to the serious shortage of ASI programming materials, it is not conducive to the secondary development of CAD by the external database. MFC programming needs to be done after the ARX program has been initialized for a certain period of time. The development of the ARX program needs to access the external database according to the class library functions provided by MFC, which can effectively shorten the development cycle, reduce the difficulty of development, and make the program function It is enhanced to facilitate the implementation of the C/S mode of the ARX program.

3. Application of database technology in ARX program

3.1 ADO-based ARX program development and application

For the secondary development of CAD, it is first necessary to establish a library of standard parts and basic parts. The shape and structure of standard parts and basic parts are generally finalized and can form a series. The dimensional relationship between parts is indicated by parameters. The importance of engineering databases The components and related basic data first need to determine the unique static and sharing of the geometric relationship data of the parts. Generally in chemical equipment, parts should be designed and developed in accordance with national standards. Moreover, the number of parts and components in chemical equipment is large, there are many forms, and the regularity of its data is strong, so it is often used in chemical equipment, and the data of parts is managed through the database.

This article takes the development of JBFF4713～92 as an example of the support parts. There are mainly four series of support development, which are A, AN, B, and BN. Most of these four series have Standardized data is represented by standardized formulas and implemented by overloading functions. The four series of brackets are separated independently, mainly because other modules may call a certain bracket separately for a clearer description. The data formula of the ARX program is to call the corresponding structure function and transfer the data after the user inputs and selects the data, and then proposes the corresponding data from the database according to the obtained data, that is, the corresponding corresponding class. The correctness of the data is checked in detail, and finally the graphics are drawn according to the class library functions provided by the ARX program, and the database access of MFCDAO is completed.

3.2 Application of ODBC-based ARX program development in engineering drawing management

PDM is a technology for computerized management of engineering drawings. According to the PDM technology, an engineering drawing management system is established to realize various management functions such as engineering electronic document and data management, workflow and product configuration management, and project classification retrieval management. The design of engineering drawings is generally submitted by the designer to the server after the design, and through detailed processes such as review and verification. During the review process, the design of the drawing will be browsed and modified, and the design of the drawing is usually designed on the CAD software for a long time, and it is not integrated with the engineering drawing management system. At present, CAD software and engineering drawing management system can be connected through a variety of technologies, but in specific occasions, such as the design and modification of engineering drawings, CAD and engineering drawing management system are still not completely integrated, and designers need to use different software There are various problems in operation, such as using OLE technology to establish communication between CAD and engineering drawing management system, the embedded method still does not meet the needs of users, and the response of the system is slow, causing inconvenience to users. The development of ARX programs needs to be combined with the advantages of MFC in developing databases, so that CAD software can be effectively integrated with engineering drawing management systems, and designers can work and design in an environment familiar with CAD software. However, if the drawings are read-only, it is more practical to combine OLE technology with quick browsing tools.

The submission of engineering drawings requires the use of ARx program and MFCODBC to access the database, and various methods can be used to submit the drawn CAD files, such as using varbinary fields and Winsock in the database. The ARX program is based on the CAD client to create a read-only folder for the server administrator to use. In the read-only folder, the class library functions provided by ARX are saved as dwg format files, and the system commands executed by the database are called and copied. Copy the files to the relevant folders of the server to ensure the security of the server and avoid damage to the security of the server directory. The specific process is shown in Figure 1.

epilogue

The secondary development of software in the ARX program by database technology is mainly to call the external database, and make comprehensive use of the database development technology and CAD technology, and improve the quality of software development according to the advantages of CAD software in graphics. Software development provides standardized data management, effectively solves the integration problem between CAD system and other subsystems, and provides new solutions and methods for the secondary development of CAD software.

The above is the application of database technology in ARX software development introduced by Shenzhen Zuchuang Microelectronics Co., Ltd. If you have software and hardware function development needs for smart electronic products, you can rest assured to entrust them to us. We have rich experience in customized development of electronic products, and can evaluate the development cycle and IC price as soon as possible, and can also calculate PCBA quotations. We are a number of chip agents at home and abroad: Songhan, Yingguang, Jieli, Ankai, Quanzhi, realtek, with MCU, voice IC, Bluetooth IC and module, wifi module. We have hardware design and software development capabilities. Covering circuit design, PCB design, single-chip microcomputer development, software custom development, APP custom development, WeChat official account development, voice recognition technology, Bluetooth wifi development, etc. It can also undertake the research and development of smart electronic products, the design of household appliances, the development of beauty equipment, the development of Internet of Things applications, the design of smart home solutions, the development of TWS earphones, the development of Bluetooth earphone speakers, the development of children's toys, and the research and development of electronic education products.