文档介绍：摘 要
电阻焊技术被广泛用于现代工业制造领域,但国内对阻焊资源的相关数据仍主要以纸质文件进行管理,造成数据分布的零散性、重复性和不一致性。为了提高阻焊信息的有效共享,亟须设计一个应用软件,用来合理地管理阻焊相关信息。本课题综合采用数据库技术、软件工程思想和面向对象技术开发了一个基于 Client/Server(客户端/服务器)结构的电阻焊生产管理数据库系统。
本文在分析已有焊接数据库现状的基础上,通过对用户的深入调研并与相关阻焊技术人员的相互沟通,根据阻焊信息计算机一体化的管理需求,结合数据库
技术特点,明确系统的功能和结构要求,构建了一个以SQL Server为数据库管理系统的总体结构框架。阻焊数据库框架中包括材料库、方法库、设备库以及焊工档案库。
系统采用E-R模型对阻焊数据进行规范化设计,引入PowerDesigner工具进行数据建模,以SQL Server 2005作为平台,设计出了阻焊数据库结构;同时,采用可视化编程工具Visual C#,在Visual Studio 2005平台上开发了具有人性化的人机界
面。
系统采用数据库技术实现对阻焊相关数据的的计算机管理,其中包括点焊、缝焊、凸焊、对焊等阻焊生产过程中的金属母材、焊机设备、电极、工艺参数、
接头性能、焊接标准、焊前清理、焊工档案等数据信息,提供了阻焊工艺和设备等相关信息的浏览、查询及打印等操作。
结果表明:该系统对电阻焊生产管理信息进行了科学的分类,提供了多种方
式的高效电阻焊数据查询方法,可实现对电阻焊生产管理数据的有效管理。
关键词:电阻焊,数据库,SQL Server,E-R 模型, Visual Studio
Abstract
Resistance welding technology is widely used in modern industrial manufacture, but the data management of resistance welding resources is still mainly depended on paper files, resulting in fragmentation, repetitiveness and inconsistency of data distribution. In order to improve the effective sharing of resistance welding information, a software application is designed for the rational management of resistance welding information. The purpose is to design a Resistance Welding Production Management Database System, which is based on Client / Server structure with bination of database technology, software engineering ideas and object-oriented technology.
Based on the analysis of current situation of welding database, through in-depth research on users and discussion with welding technical personnel, according to the requirements of resistance welding information integration management, combined with the characteristics of database, and the functions and structure of the system. An overall structure frame of database management system was constructed with SQL Server. Resistance welding database framework includes a material base, a method base, an equipment base and an operator archives base.
With SQL Server 2005 as a platform, the standardized design meth