Song.Site/Manage/Sys/DataBaseBackup.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 WeiSha.Common;

using Song.ServiceInterfaces;
using Song.Entities;
//using NBear.Data;
using System.Data.SqlClient;

namespace Song.Site.Manage.Sys
{
    public partial class DataBaseBackup : Extend.CustomPage
    {
        //数据库完整物理物路径
        private string dataBaseHy = "";
        //数据库备份目录
        private string backDir = "";
        //数据库备份文件后缀名
        private string backExt = ".aspx";
        //数据库类型，仅限access与sqlserver；
        private string dbType = "access";
        //要操作的数据库名称。
        private string dbName = "";

        protected void Page_Load(object sender, EventArgs e)
        {
            //数据库类型
            dbType = WeiSha.Common.Server.DatabaseType;
            if (dbType == "access")
            {
                backDir = "accBackup";
                dataBaseHy = WeiSha.Common.Server.DatabaseFilePath;
            }
            else if (dbType == "sqlServer")
            {
                backDir = "sqlSBackup";
                backExt = ".sasp";
                ConnectionStringSettings connsett = ConfigurationManager.ConnectionStrings[ConfigurationManager.ConnectionStrings.Count - 1];
                string str = connsett.ConnectionString;

                int a = str.IndexOf("Initial Catalog=");
                a = a == -1 ? str.IndexOf("DataBase=") + 9 : a + 16;
                string strjie = str.Substring(a);
                dbName = str.Substring(a, strjie.IndexOf(";"));

            }
            else
            {
                Message.Prompt("此功能仅限Access版和SQL Server版。");
                return;