//public List<model.errorlog> GetListErrorlog(Dictionary<string, string> dic, int skip, int take, int type, out int listCount, out string mess)
//{
// listCount = 0;
// mess = "";
// return null;
//}
/// <summary>
/// 数据备份
/// </summary>
/// <param name="pathName"></param>
/// <param name="mess"></param>
/// <param name="DBPath"></param>
/// <returns></returns>
public bool DateBackups(string pathName, out string mess, out string DBPath)
{
mess = "";
DBPath = "";
try
{
pbx = new model.pbxdatasourceDataContext(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
pbx.Connection.Open();
string name = pbx.Connection.Database;
string path = "pbxDB" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".bak";
string DBname = pathName + "\\" + path;
//BACKUP DATABASE " + name + " TO DISK = N'" + DBname + "' WITH NOFORMAT, NOINIT,NAME = N'数据备份'" + DateTime.Now + "', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
// pbx.ExecuteCommand("BACKUP DATABASE " + name + " TO disk = '" + DBname + "' WITH FORMAT, NAME = '数据备份" + DateTime.Now + "'");
pbx.ExecuteCommand("BACKUP DATABASE " + name + " TO DISK = N'" + DBname + "' WITH NOFORMAT, NOINIT,NAME = N'数据备份" + DateTime.Now + "', SKIP, NOREWIND, NOUNLOAD, STATS = 10");
mess = "数据备份成功！备份路径：" + pathName + "\\pbxDB";
DBPath = path;
return(true);
}
catch (Exception ex)
{
mess = ex.ToString();
return(false);
}
finally
{
pbx.Connection.Close();
}
}
