databackuprestore.ascx.cs

学生成绩管理系统

using System;
using System.Data;
using System.IO;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TeachHelper.Comm;

public partial class TeachHelper_Controls_DataBackupRestore : System.Web.UI.UserControl
{
    DbOperate db = new DbOperate();
    string path;

    protected void Page_Load(object sender, EventArgs e)
    {
        path = this.Server.MapPath("/") + @"TeachHelper\TeachHelper\DABACKUP\";

        if (!IsPostBack)
        {

            // Determine whether the directory exists.
            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
                return;
            } 

            LoadBackUpFileList();
            this.ButtonDelete.Attributes.Add("onclick", "return confirm('确定要删除吗?');");
            this.ButtonRestore.Attributes.Add("onclick", "return confirm('确定要恢复吗?');");
            //this.ButtonBackUp.Attributes.Add("onclick", "return confirm('备份数据将杀掉所有当前连接到数据库的进程，是否继续？');");
        }
    }

    protected void ButtonBackUp_Click(object sender, EventArgs e)
    {
        Backup();
    }

    protected void ButtonRestore_Click(object sender, EventArgs e)
    {
        if (this.ListBoxFileList.SelectedIndex == -1)
        {
            MessageBox.Show(this.Page, "请选择要恢复的一项");
            return;
        }

        Restore();
    }

    protected void ButtonDelete_Click(object sender, EventArgs e)
    {
        if (this.ListBoxFileList.SelectedIndex == -1)
        {
            MessageBox.Show(this.Page, "请选择要删除的一项");
            return;
        }

        DeleteFile();
    }

    private void Backup()
    {        
        bool result = db.DbBackup(path);
        string message;
        if (result)
        {
            message = "备份数据成功！";
        }
        else
        {
            message = "备份数据失败！";
        }
        MessageBox.Show(this.Page, message);
        LoadBackUpFileList();
    }

    private void Restore()
    {
        string restorePath = this.ListBoxFileList.SelectedItem.Value;
        string result = db.DbRestore(restorePath);
        string message;
        if (result == "ok")
        {
            message = "备份修复成功！您需要重新登录！";
            MessageBox.Show(this.Page, message);
        }
        else
        {
            message = "备份修复失败！";
        }
        MessageBox.Show(this.Page, message);
        LoadBackUpFileList();
    }

    private void DeleteFile()
    {
        string filePath = this.ListBoxFileList.SelectedItem.Value;
        try
        {
            File.Delete(filePath);
        }
        catch (Exception ex)
        {
            string message = "删除失败！原因：" + ex.Message;
            MessageBox.Show(this.Page, message);
        }

        LoadBackUpFileList();
    }

    private void LoadBackUpFileList()
    {
        string[] fileList = System.IO.Directory.GetFiles(path, "*.BAK");
        this.ListBoxFileList.Items.Clear();
        foreach (string str in fileList)
        {
            string filename = str.Substring(str.LastIndexOf("\\") + 1, str.Length - str.LastIndexOf("\\") - 1);
            ListItem li = new ListItem(filename, str);
            this.ListBoxFileList.Items.Add(li);
        }
    }
}