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 System.IO;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["UID"]) == "")
        {
            Response.Redirect("login.aspx");

        }
        if (!IsPostBack)
        {
            this.TextBox1.Text = DateTime.Now.ToShortDateString() + "Backup";//初使备份数据库的备份名称
        }
       
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string path = Server.MapPath("~/backup") + "\\";
        
        string backcmd = "backup database SmallHouse to disk='" + path + TextBox1.Text.Trim() + ".bak'";
        //Response.Write(backcmd);
        //Response.End();
        string file = path + TextBox1.Text.Trim() + ".bak";

        try
        {
            if (File.Exists( file))
            {
                Response.Write("<script language='javascript'>alert('此文件已存在，请选择其它文件名');</script>");
                return;
            }
            else
            {
                BaseClass BC = new BaseClass();
                BC.ExecSql(backcmd);
                Response.Write("<script language=javascript>alert('文件备份成功！');location='backup.aspx'</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<scirpt language='javascript'>alert('文件备份失败！');location='default.aspx'</script>");
            Response.Write (ex.Message);

        }
        finally 
        {
           
        }

    }
}