SQLServerDAL/GlobalManage.cs

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

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

using System;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
using SQLDMO;
using System.Collections.Generic;

using WMPT.SQLServerDAL;
using WMPT.Model;
using WMPT.Common;
using WMPT.DBUtility;

// GlobalManage.cs :class GlobalManage
// CopyRight (c) 2009-2016 WMPT Teconology. All Rights Reserved.
// 123@163.com.com
// 2010-01-13

namespace WMPT.SQLServerDAL
{
    public class GlobalManage
    {
        public string BackUpDatabase(string backuppath, string ServerName, string UserName, string Password, string strDbName, string strFileName)
        {
            SQLServer svr = new SQLServerClass();
            try
            {
                svr.Connect(ServerName, UserName, Password);
                Backup bak = new BackupClass();
                bak.Action = 0;
                bak.Initialize = true;
                bak.Files = backuppath + strFileName;//文件加一个config后缀
                bak.Database = strDbName;
                bak.SQLBackup(svr);
                return string.Empty;
            }
            catch (Exception ex)
            {
                string message = ex.Message.Replace("'", " ");
                message = message.Replace("\n", " ");
                message = message.Replace("\\", "/");
                return message;
            }
            finally
            {
                svr.DisConnect();
            }
        }

        public string RestoreDatabase(string backuppath, string ServerName, string UserName, string Password, string strDbName, string strFileName)
        {
            #region 数据库的恢复的代码

            SQLServer svr = new SQLServerClass();
            try
            {
                svr.Connect(ServerName, UserName, Password);
                QueryResults qr = svr.EnumProcesses(-1);
                int iColPIDNum = -1;