unit xtcsh;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, Buttons, StdCtrls, jpeg;

type
  TForm69 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Label1: TLabel;
    Panel3: TPanel;
    SpeedButton1: TSpeedButton;
    Panel4: TPanel;
    Image1: TImage;
    SpeedButton2: TSpeedButton;
    procedure SpeedButton1MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure SpeedButton1MouseUp(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form69: TForm69;

implementation
  uses Dataz;
{$R *.dfm}

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

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

procedure TForm69.SpeedButton1Click(Sender: TObject);
begin
  if Application.MessageBox('確實要刪除全部數據嗎？','提示',MB_YesNo)= ID_yes then
  begin
    Try
      if FileExists('C:\gdzcBack.Bak') then
      begin
        with Daz.ADOQuery1 do
        begin
          Close;
          SQL.Clear;
          //DeleteTable 是預先創建的存儲過程
          SQL.Add('exec DeleteTable');
          ExecSQL;
        end;
        Application.MessageBox('系統初始化成功。','提示',0+64);
      end
      else
        Application.MessageBox('數據庫沒有備份，不能初始化數據，請先備份數據庫。','提示',64);
    Except
      Application.MessageBox('系統出錯。','提示',0+64);
      Close;
    end;
  end;
end;
procedure TForm69.SpeedButton2Click(Sender: TObject);
begin
  Close;
end;

end.