Abstract: The CAD/CAM system has played an important role in many aspects. This paper combines the development practice of the tooling management system of Wafangdian Bearing Co., Ltd., and focuses on the overall structure of the system and the entry, retrieval, modification and printing of the tooling schedule. The realization of functions such as output, version management, and electronic signature hope to provide a reference for comrades who are doing similar development work.
Key words: tooling, CAD, PowerBuilder
0 Preface
Wafangdian Bearing Co., Ltd. is the largest bearing manufacturer in China. It has bearing production capacity of more than 5,000 varieties in nine series. The technical documents of its products are very complicated, and it is inconvenient to consult, copy, use, save and update. In the increasingly fierce market competition, in order to strengthen the standardization of management and improve work efficiency, the use of computer management has become an inevitable choice. Dalian University of Technology and Wafangdian Bearing Co., Ltd. worked closely together to successfully develop the bearing CAD/CAPP system and achieved the expected results. This article will discuss in detail the composition, function and characteristics of the tooling management system.
1. The overall design of the bearing tooling management system
1.1 Functional requirements of the system
The function of the system is shown in Figure 1. It consists of three modules: tooling schedule management, password management, and tooling name table management.
2. Main functions and features of bearing tooling management system
In the development process, according to the actual situation of the tile axis, the human-machine interface adopts the format of the paper tooling list used in the actual use, and adopts the color configuration of “white paper blackâ€, which makes the likes to eliminate the strangeness to the computer. Feeling and discomfort, enhance the friendliness of the interface, and in order to facilitate the likes and management, the four parts of the schedule use a consistent interface format.
2.1 data entry function
Since the tile axis has more than 5,000 bearing types, the amount of data to be entered is large. In order to ensure fast, accurate and standardized input data, a drop-down sub-data window and a drop-down list box technique are adopted in the data window of the input interface. The specific instructions are as follows:
Drop-down sub-data window technology: Since the name items of each fixture or gauge are basically similar, select the drop-down sub-data window attribute in the data window name item, increase the dynamic pull-down sub-data window function, and create a corresponding table to store The newly-created name, the new name can be entered once, the application will automatically remember and update the data content in the drop-down sub-data window. When you use it, you can enter the name by simply clicking the corresponding name item with the mouse. The data entry efficiency is obvious. Improve, and make the names of different expressions in the actual use unified into a consistent name, which achieves the standardization of data entry and creates favorable conditions for computer processing data.
The "a, b, f" symbols, which are often found in the main dimensions, also use the drop-down sub-data window technique to achieve the purpose of simplifying the entry.
Drop-down list box technology: For the "Remarks" option, the "basemap original" and "new design" use drop-down list box, just click the corresponding item with the mouse.
Due to the use of the drop-down sub-data window, the data table has been added, and the addition and deletion management module for this table has been added accordingly, which has increased the development workload.
2.2 Electronic signature function
When using the paper tooling schedule, it must be signed and validated by the relevant personnel when it is prepared, checked, audited and approved. When the paperwork schedule is entered into the computer, similar steps and signature functions are required, that is, electronic signature. The realization of the function. There are two main ways to implement this function: one is through the background stored procedure, it needs to use the database login password as the password, easy to leak, and requires complex data exchange; the second is unified by the front-end development tools, it has the use Convenient and easy to maintain.
The system is implemented by the second method, that is, unified development by the foreground. First, create a password table for storing passwords, names, and name codes. Secondly, the relevant personnel input their own names, and then the computer automatically generates the name code randomly. After I remember, I enter the private password, enter the password twice, and the computer confirms the consistency. Only valid, encrypted by the computer and then stored in the password table. When using, the relevant personnel input their own password and name code. After correct, the computer retrieves the real name and fills in the corresponding position in the title bar. The date is also automatically filled in according to the date of the system. For people with the same name, they can be distinguished according to different name codes. However, in practice, people with the same name must be distinguished. Otherwise, people can't distinguish who signed the words after the computer automatically signs. Here, the use of the name code plays three main roles: one is to add a layer of password settings, which increases the confidentiality, but because it is randomly generated and difficult to remember, the actual application only takes 4 digits; the second is to prevent different people from using the same password. When the application may have a judgment error; the third is to use the number instead of the name to save the trouble of inputting Chinese characters when inputting.
Due to the addition of the password table, the password management module has been developed accordingly, which is mainly divided into two parts: one is the input of the initial password, that is, the password is input for the first time. At this point, the relevant personnel are required to be on the designated computer (this machine needs special personnel to manage, prevent the illegal person from entering the name and password of others), enter their own name, password and remember the name code; the second is on any computer that can be used. The existing password is modified, and if the password is forgotten, the record can be deleted by inputting the name and the name code, so that the system administrator can be helped to delete the password without increasing the maintainability of the system.
2.3 modify the function
2.4 output function
In addition, in this function, a button that can save the detailed list to be output as a file (Powersoft Report format) is designed. This is to prevent the temporary table from being generated when the remote call is made, but to transfer the existing file. It can save communication time and facilitate user's use.
2.5 version management features and features
This function is mainly for all the items that have been electronically signed, that is, the official version of the tooling list that produces legal effects. In the actual use, the tooling schedule is difficult to avoid modification. In order to prevent the confusion of the management of the schedule caused by multiple modifications, each modification must be completed by the schedule modifier to modify the schedule. Moreover, the modified schedule and the revised schedule are saved, so the version management function of the new and old schedules is required, that is, each revision produces a new version and an old version, and more of the same schedule. Sub-modifications produce many versions, and the original schedules are retained. The management of the new version mainly sets the version number in the corresponding data item in the data table to indicate that the version is already the first edition. The larger the version number, the newer the new version; the management of the old version mainly through the establishment of the history database. Data from older versions is transferred to the store in the history store and provides search and query capabilities. If the history database is not established, the old and new data can be distinguished by the version number. However, as the usage period is extended, the amount of data will increase significantly, the workload of the query will increase significantly, and the mixing of old and new data is not conducive to management.
2.6 Realization of the compilation of search tooling schedules
The implementation of the search tooling schedule is mainly to first retrieve the approximate bearing model, and then modify it based on the original schedule, and then use the “Save As†function provided by the application to realize the new design of the schedule. The specific description is as follows: Firstly, the system provides fuzzy query function, retrieves all bearing models and fills in the drop-down list box, and automatically sorts them by the drop-down list box. After inputting the bearing model prefix, the similar bearing models will automatically appear in the drop-down list box. , select it with the mouse. Then, modify it in the data window. After the modification is completed, click the “Save As†button with the mouse to display a new window. After inputting the new bearing model number and the detail sheet number (the system automatically checks the legality of the input data) Implement a new design for the schedule.
2.7 Data Security Management
In order to ensure data security, the background domain administrator sets different access types for different accounts on Windows NT, and uses the domain account and password as security measures to restrict illegal users from accessing the network and infringement through passwords, realizing the security management of resources, and using SQL Server's authorization management function, to achieve different users with different data like vertical rights, for example: some users have only read and enjoy the data and can not modify and delete, etc.; in the foreground, after confirming that the network user registration password is legal, Mainly through the application of the password management and electronic signature function to prevent illegal modification of the schedule.
4 Conclusion
At present, this system has recorded all the bearing tooling schedules into the computer, which can conveniently maintain, query and output the required schedules, and connect the design, process, tooling and other departments through the computer network to realize paperless. The transmission has basically reached the goal of speeding up the tooling design, shortening the production cycle and reducing the production cost, and initially fulfilling the requirements of the “scratch boardâ€.
In summary, this paper combines the development practice of the tooling management system of Wafangdian Bearing Co., Ltd., and gives some ideas and practices that have universal application value in actual development. I hope that it can be used as a reference for similar work. effect.
references
Tang Hao, Design and Implementation of the CAPP System for the Wafer Rolling Bearing Grinding Operation Guide Card, Master thesis of Dalian University of Technology, 1998, 5
Hou Zhiping, PowerBuild4.0/5.0 Advanced Application Technology, Beijing Xiaotong Network Database Research Institute, 1996.
Zhang Xiwen et al. Development of Bearing Systems in Network Environment, Computer Application Research, 1998, 3:75-76
He Qinggang et al. Research on Computer Aided Drawing of Rolling Bearings in Network Environment, Computer Application Research, 1998, 4: 393-394.
Dish Rack,dish drying rack,kitchen dish rack,dish drainer rack,dish rack sink,etc. The materials used are 304 stainless steel, easy to clean, never rust!
China Kichen Rack,Sink Grid,Stainless Mesh Storage Baskets,Kitchen Wire Storage, we offered that you can trust. Welcome to do business with us.
Kichen Rack is made of high quality 304 stainless steel, This kind of material steel luxury, never rust, resist corruption, easily clean, safe, healthy and durable. Prevent rust or chemicals from contaminating food and damaging health
Kitchen Dish Rack,Dish draining Rack,Dish Rack Sink,2 tier Dish Rack
Shenzhen Lanejoy Technology Co.,LTD , https://www.compressionspring.net