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

public partial class SysManage_SqlDataBeiFen : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            
        }
    }

    

    /// <summary>
    /// 按钮事件：提交信息
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string bakpath = HttpContext.Current.Server.MapPath("../DataBak/");//要备份的文件夹
        string bakfilename = "Data_" + DateTime.Now.ToString("yyyy-MM-dd_hh-mm-ss") + ".bak";//要备份的文件名
        string filepath = bakpath + bakfilename;

        if (!Directory.Exists(bakpath))
        {
            Directory.CreateDirectory(bakpath);
        }
        if (File.Exists(filepath))
        {
            Common.ShowMessage(this.Page, "此文件已存在。", "");
            return;
        }
        else
        {
            //DB.ExecuteSql("backup database OfficeDocumentsDB to disk='" + filepath + "'");
            Common.ShowMessage(this.Page, "数据备份成功", "");
        }

    }

}