?? uback.pas
字號(hào):
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.
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -