?? maintenanceaccess.cs
字號:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using Hotel.DAO;
using Hotel.Entity;
namespace Hotel.Operation
{
class MaintenanceAccess
{
private GetDatabase objGetDatabase = null;
public MaintenanceAccess()
{
this.objGetDatabase = new GetDatabase();
}
// 備份數(shù)據(jù)
/// </summary>
/// <param name="path">文件路徑</param>
/// <param name="file">文件名</param>
/// <returns>返回非0值成功</returns>
public int BackupData(string path, string file)
{
string strBackup = "backup database hotelDB to disk='" + path.Trim() + "\\" + file.Trim() + ".bak'";
return this.objGetDatabase.ExecuteSql(strBackup);
}
/// <summary>
/// 恢復(fù)數(shù)據(jù)
/// </summary>
/// <param name="path">保存路徑</param>
/// <returns>返回非0值成功</returns>
public int RestoreData(string path)
{
string strRestore = "USE master DECLARE tb CURSOR LOCAL FOR SELECT 'Kill '+ CAST(Spid AS VARCHAR) FROM master.dbo.sysprocesses";
strRestore += " WHERE dbid=DB_ID('hotelDB') DECLARE @s nvarchar(1000) OPEN tb FETCH tb INTO @s";
strRestore += " WHILE @@FETCH_STATUS = 0 BEGIN EXEC (@s) FETCH tb INTO @s END CLOSE tb DEALLOCATE tb";
strRestore += " RESTORE DATABASE hotelDB FROM disk='" + path + "'";
return this.objGetDatabase.ExecuteSql(strRestore);
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -