//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(); } }