unit zclbgl;

interface

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

type
  TForm2 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Panel3: TPanel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    procedure FormShow(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Edit1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure BitBtn1MouseUp(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation
  uses Dataz;
{$R *.dfm}

procedure TForm2.FormShow(Sender: TObject);
begin
  Edit1.Clear;
  with Daz.ADOQuery1 do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from 固定資產類別表');
    Open
  end;
  DataSource1.DataSet := Daz.ADOQuery1;
end;

procedure TForm2.BitBtn1Click(Sender: TObject);
begin
  if Trim(Edit1.Text)<>'' then
  begin
    Try
    with Daz.ADOQuery2 do
    begin
      Close;
      SQL.Clear;
      SQL.Add('Insert 固定資產類別表 values(:a)');
      Parameters.ParamByName('a').Value := Trim(Edit1.Text);
      ExecSQL;
    end;
    Self.OnShow(Sender);
    Application.MessageBox('添加成功。','提示',64);
    Edit1.SetFocus;
    Except
      Application.MessageBox('操作失敗。','提示',64);
      Close;
    end;
  end;
end;

procedure TForm2.Edit1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if (Key = VK_ReTurn)and(Trim(Edit1.Text)<>'') then
    BitBtn1.SetFocus;
end;

procedure TForm2.BitBtn2Click(Sender: TObject);
begin
  if Application.MessageBox('確實要刪除當前記錄嗎？','提示',MB_YesNo)= ID_Yes then
    Daz.ADOQuery1.Delete;
end;

procedure TForm2.BitBtn1MouseDown(Sender: TObject; Button: TMouseButton;
  Shift: TShiftState; X, Y: Integer);
begin
  TBitBtn(Sender).Font.Color := clRed;
end;

procedure TForm2.BitBtn1MouseUp(Sender: TObject; Button: TMouseButton;
  Shift: TShiftState; X, Y: Integer);
begin
  TBitBtn(Sender).Font.Color := clBlue;
end;

end.