unit Unit2;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ComCtrls, ExtCtrls, DBCtrls, DB, DBTables, Grids,
  DBGrids;

type
  TForm2 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    Button1: TButton;
    DBGrid1: TDBGrid;
    Table1: TTable;
    DataSource1: TDataSource;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Button2: TButton;
    Button3: TButton;
    DBGrid2: TDBGrid;
    DBNavigator1: TDBNavigator;
    Table2: TTable;
    DataSource2: TDataSource;
    GroupBox2: TGroupBox;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Button4: TButton;
    Button5: TButton;
    DBNavigator2: TDBNavigator;
    DBGrid3: TDBGrid;
    Table3: TTable;
    DataSource3: TDataSource;
    GroupBox3: TGroupBox;
    Label9: TLabel;
    Edit9: TEdit;
    Memo1: TMemo;
    Button6: TButton;
    GroupBox4: TGroupBox;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Button7: TButton;
    DBGrid4: TDBGrid;
    DBNavigator3: TDBNavigator;
    Table4: TTable;
    DataSource4: TDataSource;
    Button8: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

uses Unit1;

{$R *.dfm}

procedure TForm2.Button1Click(Sender: TObject);
begin
form2.Close;
form1.show;
end;

procedure TForm2.Button2Click(Sender: TObject);
begin
dbnavigator1.Enabled:=true;
end;

procedure TForm2.Button4Click(Sender: TObject);
begin
    dbgrid4.SetFocus;
   dbnavigator2.BtnClick(nbdelete);
end;

procedure TForm2.Button5Click(Sender: TObject);
begin
table3.Close;table3.Open;
end;

procedure TForm2.Button6Click(Sender: TObject);
begin
with table1 do
 begin
 indexfieldnames:='設備類型號';
 setkey;
 if edit9.text=''then
 showmessage('請輸入查詢內容！')
 else table1.fieldbyname('設備類型號').AsString:=edit9.Text;
 if gotokey then
 begin memo1.Lines[1]:=' 設備類型號： '+table1.fieldbyname('設備類型號').AsString +'設備名稱：  '+table1.fieldbyname('設備名稱').AsString+'供應商'+table1.fieldbyname('供應商').AsString+' 設備狀態：  '+table1.fieldbyname('設備狀態').AsString+' 價格：  '+table1.fieldbyname('價格').AsString
end
else
begin
 memo1.Lines[1]:='查找失敗，重新查找！';
 edit9.SetFocus;
 end;
 end;
end;

procedure TForm2.Button7Click(Sender: TObject);
begin
   dbnavigator3.BtnClick(nbdelete);
end;

procedure TForm2.Button8Click(Sender: TObject);
begin
table4.Close;table4.Open;
end;

end.