using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;

namespace Glonee.DAL
{
/// <summary>
/// 数据库操作类
/// </summary>
public class BackupService
{
/// <summary>
/// 备份数据库
/// </summary>
public static int BackUpToGo(string txtPath, string txtName)
{
string sql = "backup database Glonee to disk='" + txtPath.Trim() + "\\" + txtName.Trim() + ".bak'";
return SQLHelper.ExcuteNonQuery(sql);
}
/// <summary>
/// 还原数据库
/// </summary>
/// <param name="txtPath"></param>
/// <returns></returns>
public static int restore(string txtPath)
{
string sql = "use master;restore database @name from disk=@path With Replace;";
SqlParameter[] param =
{
new SqlParameter("@name","Glonee"),
new SqlParameter("@path",txtPath)
};
try
{
return SQLHelper.ExcuteNonQuery(sql, param);
}
catch
{
throw;
}
}
public static void KillThread(string MyId)
{
string strSQL = "select spid from master..sysprocesses where dbid=db_id('Glonee') ";
DataTable table = SQLHelper.ExcuteTable(strSQL).Tables[0];
for (int row = 0; row<=table.Rows.Count-1;row++)
{
string id = table.Rows[row][0].ToString();
if (id== MyId)
{
return;
}
string sql = "kill "+id;
SQLHelper.ExcuteNonQuery(sql);
}
}
}
}