unit Uback;

interface

uses
  Windows, Messages, Forms,
  Dialogs, Buttons,udm, StdCtrls, ComCtrls, Controls, Classes;

type
  Tfback = class(TForm)
    a1: TAnimate;
    BitBtn2: TBitBtn;
    BitBtn1: TBitBtn;
    Label1: TLabel;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fback: Tfback;

implementation

{$R *.dfm}

procedure Tfback.BitBtn1Click(Sender: TObject);
begin
label1.Caption:='正在備份....';
a1.Active:=true;
adodm.cback.CommandText:='backup database yd to disk=''d:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\yd.back''';
try
 adodm.cback.Execute;
 label1.Caption:='備份成功！'; a1.Active:=false;
except
 label1.Caption:='備份失?。?#039;;a1.Active:=false;
end;




end;

procedure Tfback.BitBtn2Click(Sender: TObject);
begin

  label1.Caption:='正在恢復(fù)....';
  adodm.ydconn.Close;
  if application.MessageBox('此操作將使上次備份以來(lái)的所有數(shù)據(jù)丟失，是否繼續(xù)？','恢復(fù)數(shù)據(jù)',MB_OKCANCEL)=idok then
 begin
 a1.Active:=true;
 adodm.cback.CommandText:='restore database yd from disk=''d:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\yd.back'' with replace';
  try
   try
   adodm.cback.Execute;
    label1.Caption:='恢復(fù)成功！';
    except
    showmessage('數(shù)據(jù)庫(kù)正在被使用！請(qǐng)確定已關(guān)閉其它藥店管理程序！');
    label1.Caption:='恢復(fù)失??！';
    end;
  finally
  a1.Active:=false;
   try
    adodm.typzdk.Open;
    adodm.tdw.Open;
    adodm.tbm.Open;
    adodm.tyg.Open;
    adodm.tkc.Open;
    adodm.tcr.Open;
    adodm.toper.Open;
    adodm.tuser.Open;
   except
     showmessage('程序運(yùn)行發(fā)生錯(cuò)誤，請(qǐng)重新啟動(dòng)程序！');
     application.Terminate;
   end;
  end;
end;
end;

procedure Tfback.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

end.