backup.aspx.cs

互联网程序设计的课程

using System;
using System.Data;
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 DBClass;
using System.IO;
using System.Text;
using System.Collections.Generic;
using SQLDMO;



public partial class backup_Default : System.Web.UI.Page
{
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        Labelts.Text = "";
        Panelbf.Visible =false ;
        Panelhf.Visible = false;
      




    }


   

  
    protected void bf_Click(object sender, EventArgs e)
    {
        string server = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["server"].ToString();
        string uid = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["id"].ToString();
        string pwd = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["mm"].ToString();
        SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
        //获取当前日期，以生成备份文件名
       
        string urldate = DateTime.Now.Date.ToShortDateString();   
       
        ///
        try
        {
           

            oSQLServer.LoginSecure = false;
           oSQLServer.Connect(server, uid, pwd);  //数据连接       
            oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
            oBackup.Database = "91";  //要进行备份的数据库 
           // oBackup.Files = @"i:91.bak";  //备份数据库的保存路径 
            oBackup.Files = @textboxurl.Text + urldate + ".bak"; 

            oBackup.BackupSetName = "91";  //备份后的数据库名称 
            oBackup.BackupSetDescription = "数据库备份";
            oBackup.Initialize = true;
            oBackup.SQLBackup(oSQLServer);

            Labelts.Text = "完成备份！";
      
        }
        catch (Exception exp)
        {

            Labelts.Text = "备份失败！" + exp.Message;
          
        }
        finally
        {
            oSQLServer.DisConnect();
        }

        DropDownListxm.SelectedValue = "0";
 
    }
   
        
        
    protected void  DropDownListxm_SelectedIndexChanged(object sender, EventArgs e)
{
    
   //选择服务种类
   
    switch (DropDownListxm.SelectedValue)
    {
        case "0":
            Panelbf.Visible = false;
            Panelhf.Visible = false;
            Labelts.Text = "请选择操作类型";
           
            break;
        case "1":
            Panelbf.Visible = true;
            Panelhf.Visible = false;
            Labelts.Text = "";
            break;
        case "2":
            Panelbf.Visible = false;
            Panelhf.Visible = true;
            Labelts.Text = "";
            break;
        
        default:  break;
    }   






}

    protected void hfqd_Click(object sender, EventArgs e)
    {
        //恢复

        string myname = FileUpload1.PostedFile.FileName;//恢复路径
        if (myname == "")
        {
        Labelts.Text ="恢复失败，您没有选择任何可还原的数据库";
        DropDownListxm.SelectedValue = "0";   
    }
        else
        {
            Labelts.Text = db.DbRestore(myname);
            DropDownListxm.SelectedValue = "0";
        }
    }
}