GYSW01-009@箱体类零件工艺分析及知识库研究（减速机）
收藏
资源目录
压缩包内文档预览：
编号：491935
类型：共享资源
大小：2.95MB
格式：ZIP
上传时间：2015-11-06
上传人：QQ28****1120
认证信息
个人认证
孙**（实名认证）
辽宁
IP属地：辽宁
20
积分
- 关 键 词：
-
机械毕业设计全套
- 资源描述：
-
GYSW01-009@箱体类零件工艺分析及知识库研究（减速机）,机械毕业设计全套
- 内容简介：
-
unit xjgy; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, ComCtrls, Grids, DBGrids, StdCtrls, OleCtrls, VOLOVIEWXLib_TLB, Buttons, ExtCtrls,shellapi, Menus, DB, ADODB; type Tl_xjgy = class(TForm) StatusBar1: TStatusBar; Splitter2: TSplitter; Splitter1: TSplitter; SaveDialog1: TSaveDialog; ADOQuery8: TADOQuery; ADOQuery7: TADOQuery; ADOQuery6: TADOQuery; ADOQuery5: TADOQuery; ADOQuery4: TADOQuery; ADOQuery3: TADOQuery; DataSource1: TDataSource; ADOQuery2: TADOQuery; ADOQuery1: TADOQuery; PopupMenu1: TPopupMenu; N1: TMenuItem; N2: TMenuItem; Panel3: TPanel; Splitter3: TSplitter; Splitter4: TSplitter; Panel4: TPanel; Panel7: TPanel; SpeedButton2: TSpeedButton; SpeedButton1: TSpeedButton; SpeedButton5: TSpeedButton; SpeedButton4: TSpeedButton; SpeedButton6: TSpeedButton; SpeedButton3: TSpeedButton; Panel8: TPanel; AvViewX1: TAvViewX; Panel5: TPanel; Label1: TLabel; Label2: TLabel; Label3: TLabel; nts Edit1: TEdit; Edit2: TEdit; Edit3: TEdit; Panel6: TPanel; DBGrid1: TDBGrid; Panel2: TPanel; Panel9: TPanel; Label6: TLabel; Panel10: TPanel; Panel11: TPanel; Label7: TLabel; Label8: TLabel; Edit7: TEdit; Edit8: TEdit; Panel12: TPanel; Label4: TLabel; Label5: TLabel; Edit4: TEdit; Edit5: TEdit; Panel1: TPanel; TreeView1: TTreeView; TreeView2: TTreeView; TreeView3: TTreeView; TreeView4: TTreeView; TreeView5: TTreeView; TreeView6: TTreeView; OpenDialog1: TOpenDialog; N3: TMenuItem; N4: TMenuItem; ADOQuery9: TADOQuery; ADOQuery10: TADOQuery; Label9: TLabel; Label10: TLabel; Edit6: TEdit; Edit9: TEdit; ADOQuery8DSDesigner: TIntegerField; ADOQuery8DSDesigner2: TIntegerField; ADOQuery8DSDesigner3: TStringField; ADOQuery8DSDesigner4: TStringField; ADOQuery8DSDesigner5: TStringField; ADOQuery8DSDesigner6: TStringField; ADOQuery8DSDesigner7: TStringField; ADOQuery8DSDesigner8: TStringField; ADOQuery8DSDesigner9: TStringField; nts ADOQuery8DSDesigner10: TStringField; ADOQuery8DSDesigner11: TFloatField; ADOQuery8DSDesigner12: TStringField; ADOQuery8DSDesigner13: TStringField; ADOQuery8DSDesigner14: TStringField; ADOQuery8DSDesigner15: TStringField; ADOQuery8DSDesigner16: TStringField; ADOQuery8DSDesigner17: TStringField; ADOQuery8DSDesigner18: TStringField; ADOQuery8DSDesigner19: TStringField; ADOQuery8DSDesigner20: TStringField; tuxing2: TBlobField; ADOQuery2DSDesigner: TIntegerField; ADOQuery2DSDesigner2: TIntegerField; ADOQuery2DSDesigner3: TStringField; ADOQuery2DSDesigner4: TStringField; ADOQuery2DSDesigner5: TStringField; ADOQuery2DSDesigner6: TStringField; ADOQuery2DSDesigner7: TStringField; ADOQuery2DSDesigner8: TStringField; ADOQuery2DSDesigner9: TStringField; ADOQuery2DSDesigner10: TStringField; ADOQuery2DSDesigner11: TFloatField; ADOQuery2DSDesigner12: TStringField; ADOQuery2DSDesigner13: TStringField; ADOQuery2DSDesigner14: TStringField; ADOQuery2DSDesigner15: TStringField; ADOQuery2DSDesigner16: TStringField; ADOQuery2DSDesigner17: TStringField; ADOQuery2DSDesigner18: TStringField; ADOQuery2DSDesigner19: TStringField; ADOQuery2DSDesigner20: TStringField; tuxing: TBlobField; procedure FormCreate(Sender: TObject); procedure SpeedButton3Click(Sender: TObject); procedure DBGrid1MouseUp(Sender: TObject; Button: TMouseButton; Shift: TShiftState; X, Y: Integer); procedure TreeView1Change(Sender: TObject; Node: TTreeNode); procedure TreeView2Change(Sender: TObject; Node: TTreeNode); procedure TreeView3Change(Sender: TObject; Node: TTreeNode); procedure TreeView4Change(Sender: TObject; Node: TTreeNode); procedure TreeView5Change(Sender: TObject; Node: TTreeNode); procedure TreeView6Change(Sender: TObject; Node: TTreeNode); procedure N1Click(Sender: TObject); nts procedure N2Click(Sender: TObject); procedure SpeedButton6Click(Sender: TObject); procedure SpeedButton4Click(Sender: TObject); procedure SpeedButton5Click(Sender: TObject); procedure SpeedButton1Click(Sender: TObject); procedure SpeedButton2Click(Sender: TObject); procedure N3Click(Sender: TObject); procedure N4Click(Sender: TObject); private Private declarations public Public declarations procedure LoadgcmcTREE; procedure LoadgcnrTREE; procedure LoadjckTREE; procedure LoadjjkTREE; procedure LoaddjkTREE; procedure LoadljkTREE; end; var l_xjgy: Tl_xjgy; tup,wjj:string; implementation uses unit1; $R *.dfm procedure Tl_xjgy.FormCreate(Sender: TObject); var i,ss:integer; serveString: string; begin wjj:=GetCurrentDir; /下面一部分是动态连接数据库 adoquery1.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery1.SQL.Clear; adoquery1.SQL.Add(select * from 工序名称库 ) ; adoquery1.open; ntsadoquery2.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery2.SQL.Clear; adoquery2.SQL.Add(select * from 机械加工工艺过程卡片 ) ; adoquery2.open; adoquery3.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery3.SQL.Clear; adoquery3.SQL.Add(select * from 工序内容 ) ; adoquery3.open; adoquery4.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery4.SQL.Clear; adoquery4.SQL.Add(select * from 机床库 ) ; adoquery4.open; adoquery5.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery5.SQL.Clear; adoquery5.SQL.Add(select * from 夹具库 ) ; adoquery5.open; adoquery6.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery6.SQL.Clear; adoquery6.SQL.Add(select * from 刀具库 ) ; adoquery6.open; adoquery7.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery7.SQL.Clear; nts adoquery7.SQL.Add(select * from 量具库 ) ; adoquery7.open; adoquery8.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery8.SQL.Clear; adoquery8.SQL.Add(select * from 机械加工工艺过程卡片 2) ; adoquery8.open; adoquery9.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery9.SQL.Clear; adoquery9.SQL.Add(select * from 零件名称汇总 ) ; adoquery9.open; adoquery10.ConnectionString:=Provider=SQLOLEDB.1;Password=+trim(form1.Edit4.Text)+;Persist Security Info=True;User ID=sa;Initial Catalog=bysjcapp;Data Source=+trim(form1.Edit3.Text)+; adoquery10.SQL.Clear; adoquery10.SQL.Add(select * from 零件工艺汇总 ) ; adoquery10.open; LoadgcnrTREE; LoadjckTREE; LoadjjkTREE; LoaddjkTREE; LoadljkTREE; LoadgcmcTREE; treeview1.Visible:=true; treeview2.Visible:=false; treeview3.Visible:=false; treeview4.Visible:=false; treeview5.Visible:=false; treeview6.Visible:=false; adoquery2.First; while not adoquery2.Eof do begin adoquery2.Delete; end; nts ss:=10; for i:=1 to 15 do begin adoquery2.Append; adoquery2工序标志 :=ss; adoquery2.Post; ss:=ss+10; end; adoquery2.Active:=false; adoquery2.Active:=true; /改变网格大小 dbgrid1.Columns0.Width:=50; dbgrid1.Columns1.Width:=100; dbgrid1.Columns2.Width:=100; dbgrid1.Columns3.Width:=60; dbgrid1.Columns4.Width:=60; dbgrid1.Columns5.Width:=70; dbgrid1.Columns6.Width:=70; dbgrid1.Columns7.Width:=70; dbgrid1.Columns8.Width:=70; dbgrid1.Columns9.Width:=60; end; procedure Tl_xjgy.LoadgcmcTREE; var RootNode, CatNode : TTreeNode; Category : string; begin treeview1.Items.Clear; RootNode := treeview1.Items.Add( nil, 工序名称 ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; adoquery1.First; while not adoquery1.Eof do begin Category := adoquery1.fieldbyname(工序名称 ).AsString; CatNode := treeview1.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; adoquery1.Next; end; end; procedure Tl_xjgy.LoadgcnrTREE; ntsvar RootNode, CatNode : TTreeNode; Category : string; begin treeview2.Items.Clear; RootNode := treeview2.Items.Add( nil, 工序内容 ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; adoquery3.First; while not adoquery3.Eof do begin Category := adoquery3.fieldbyname(工序内容 ).AsString; CatNode := treeview2.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; adoquery3.Next; end; end; procedure Tl_xjgy.LoadjckTREE; var RootNode, TipNode, CatNode : TTreeNode; ss,Category,jidian : string; begin treeview3.Items.Clear; adoquery4.First; while not adoquery4.Eof do begin if (adoquery4机床标志 1=0) and (adoquery4机床标志 2=0) and (adoquery4机床标志 3=0)then begin ss:=adoquery4机床名称 ; RootNode := treeview3.Items.Add( nil, ss ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; end; if (adoquery4机床标志 1=0) and (adoquery4机床标志 2=0) and (adoquery4机床标志 3=1)then begin Category := adoquery4.fieldbyname(机床分类 ).AsString; CatNode := treeview3.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; end; nts if (adoquery4机床标志 1=1) and (adoquery4机床标志 2=1) and (adoquery4机床标志 3=1)then begin jidian := adoquery4.fieldbyname(机床型号 ).AsString; tipNode := treeview3.Items.addchild( catnode,jidian ); tipNode.ImageIndex := 5; tipNode.SelectedIndex := 2; end; adoquery4.Next; end; end; procedure Tl_xjgy.LoadjjkTREE; var RootNode, TipNode, CatNode : TTreeNode; ss,Category,jidian : string; begin treeview4.Items.Clear; adoquery5.First; while not adoquery5.Eof do begin if (adoquery5夹具标志 1=0) and (adoquery5夹具标志 2=0) and (adoquery5夹具标志 3=0)then begin ss:=adoquery5夹具总称 ; RootNode := treeview4.Items.Add( nil, ss ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; end; if (adoquery5夹具标志 1=0) and (adoquery5夹具标志 2=0) and (adoquery5夹具标志 3=1)then begin Category := adoquery5.fieldbyname(夹具分类 ).AsString; CatNode := treeview4.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; end; if (adoquery5夹具标志 1=1) and (adoquery5夹具标志 2=1) and (adoquery5夹具标志 3=1)then begin jidian := adoquery5.fieldbyname(夹具名称 ).AsString; tipNode := treeview4.Items.addchild( catnode,jidian ); tipNode.ImageIndex := 5; tipNode.SelectedIndex := 2; nts end; adoquery5.Next; end; end; procedure Tl_xjgy.LoaddjkTREE; var RootNode,CatNode : TTreeNode; ss,Category : string; begin treeview5.Items.Clear; adoquery6.First; while not adoquery6.Eof do begin if (adoquery6刀具标志 1=0) and (adoquery6刀具标志 2=1) then begin ss:=adoquery6刀具名称 ; RootNode := treeview5.Items.Add( nil, ss ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; end; if (adoquery6刀具标志 1=1) and (adoquery6刀具标志 2=0) then begin Category := adoquery6.fieldbyname(刀具规格 ).AsString; CatNode := treeview5.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; end; adoquery6.Next; end; end; procedure Tl_xjgy.LoadljkTREE; var RootNode, CatNode : TTreeNode; ss,Category : string; begin treeview6.Items.Clear; adoquery7.First; while not adoquery7.Eof do begin if (adoquery7量具标志 1=0) and (adoquery7量具标志 2=1) then begin ss:=adoquery7量具名称 ; nts RootNode := treeview6.Items.Add( nil, ss ); RootNode.ImageIndex := 0; Specify which bitmap to use RootNode.SelectedIndex := 0; end; if (adoquery7量具标志 1=1) and (adoquery7量具标志 2=0) then begin Category := adoquery7.fieldbyname(量具规格 ).AsString; CatNode := treeview6.Items.AddChild( RootNode, Category ); CatNode.ImageIndex := 5; CatNode.SelectedIndex := 2; end; adoquery7.Next; end; end; procedure Tl_xjgy.SpeedButton3Click(Sender: TObject); begin close; end; procedure Tl_xjgy.DBGrid1MouseUp(Sender: TObject; Button: TMouseButton; Shift: TShiftState; X, Y: Integer); begin if (DBGrid1.SelectedIndex = 1) then begin /调用相应树形结构 treeview1.Visible:=true; treeview2.Visible:=false; treeview3.Visible:=false; treeview4.Visible:=false; treeview5.Visible:=false; treeview6.Visible:=false; end; if (DBGrid1.SelectedIndex = 2) then begin treeview2.Visible:=true; treeview1.Visible:=false; treeview3.Visible:=false; treeview4.Visible:=false; treeview5.Visible:=false; treeview6.Visible:=false; end; if (DBGrid1.SelectedIndex = 5) then begin nts treeview3.Visible:=true; treeview2.Visible:=false; treeview1.Visible:=false; treeview4.Visible:=false; treeview5.Visible:=false; treeview6.Visible:=false; end; if (DBGrid1.SelectedIndex = 6) then begin treeview4.Visible:=true; treeview2.Visible:=false; treeview3.Visible:=false; treeview1.Visible:=false; treeview5.Visible:=false; treeview6.Visible:=false; end; if (DBGrid1.SelectedIndex = 7) then begin treeview5.Visible:=true; treeview2.Visible:=false; treeview3.Visible:=false; treeview4.Visible:=false; treeview1.Visible:=false; treeview6.Visible:=false; end; if (DBGrid1.SelectedIndex = 8) then begin treeview6.Visible:=true; treeview2.Visible:=false; treeview3.Visible:=false; treeview4.Visible:=false; treeview5.Visible:=false; treeview1.Visible:=false; end; end; procedure Tl_xjgy.TreeView1Change(Sender: TObject; Node: TTreeNode); begin if (DBGrid1.SelectedIndex = 1) then begin adoquery2.Edit; adoquery2工序名称 :=TreeView1.Selected.Text; adoquery2.Post; end; ntsend; procedure Tl_xjgy.TreeView2Change(Sende
- 温馨提示:
1: 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2: 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3.本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
人人文库网所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。
川公网安备: 51019002004831号