using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CRM.SysManage
{
    public partial class frmDataRevert : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        public frmDataRevert()
        {
            InitializeComponent();
        }

        private void btnSel_Click(object sender, EventArgs e)
        {
            ofDialogFile.InitialDirectory = "D:\\";
            ofDialogFile.Filter = "bak files (*.bak)|*.bak";
            ofDialogFile.RestoreDirectory = true;
            ofDialogFile.ShowDialog();
            txtDRPath.Text = ofDialogFile.FileName.ToString().Trim();
        }

        private void btnDRevert_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon = boperate.getcon();
            try
            {
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
                boperate.getcom("backup log db_CRM to disk='" + txtDRPath.Text.Trim()
                    + "' use master restore database db_CRM from disk='" + txtDRPath.Text.Trim() + "'");
                MessageBox.Show("數據還原成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}