风电齿轮箱装配工艺信息管理系统设计

The design of assembly process information management system in gear box of wind turbine

为了解决风电齿轮箱装配工艺的信息化管理问题,在进行系统总体设计分析的基础上,规划了系统管理模块、部装基础信息管理模块、部装附加信息管理模块、产品装配过程动画模块,规划了数据库,包括进装物料表、工装辅具表、装配图表、部件表、装配基准表、工艺参数管理表、部件装配过程表等.采用VB6.0和Access2003数据库,结合ADO技术,实现了对风电齿轮箱装配工艺信息的查询、浏览、添加、删除、修改等功能.该系统的功能、模块、数据结构及流程图等对于同类应用具有参考价值.

In order to solve the problem of the assembly process information management in gear box of wind turbine, a kind of system is explored and analyzed on the base of the general design, the system is divided into 4 modules which are as follows： System Management Module , Basic Information Management Module and Additional Information of Part Assembly Management Module, database is designed too, include assembly material table, aids tools table, assembly diagrams, parts table, assembly reference table, process parameter management table, and assembly process management table. Using VB6.0 and Access2003 database, combining with ADO technology, the system, assembly process information management of gear box of wind turbine, can realize its query, browse, add, delete, modify and other functions. The systemic functions, modules, data structures and flow chart have reference value for similar applications.