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);
        }
    }

}