xtcsh.pas

来自「企业安防管理系统」· PAS 代码 · 共 60 行

unit xtcsh;

interface

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

type
  TForm20 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Label1: TLabel;
    Panel3: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    Panel4: TPanel;
    Image1: TImage;
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form20: TForm20;

implementation
  uses DataModal;
{$R *.dfm}

procedure TForm20.SpeedButton2Click(Sender: TObject);
begin
  Close;
end;

procedure TForm20.SpeedButton1Click(Sender: TObject);
begin
  if Application.MessageBox('确实要初始化所有数据吗?','提示',mb_YesNo)=ID_Yes then
  begin
    Try
      with Data.ADOQuery1 do
      begin
        Close;
        SQL.Clear;
        SQL.Add('Exec Deletetable'); //Deletetable是预先创建的存储过程
        ExecSQL;
      end; 
      Application.MessageBox('初始化成功.','提示',64);
    Except
      Application.MessageBox('系统出错.','提示',64);
    end;
  end;
end;

end.