public ActionResult Recover(string id) { bll.Errorlogbll errorlog = new bll.Errorlogbll(); string path = "E:/fabu/ExcelFile/database/" + id + ".bak"; if (errorlog.Recover(path, out mess)) { model.errorlog err = new model.errorlog() { ErrorMsg = "备份数据库", errorMsgDetails = "数据库恢复", errorSrc = "ErrorloController.cs->Recover()", errorTime = DateTime.Now, UserId = userInfo.User.Id, operation = 2 }; errorlog.InsertErrorlog(err); return(Content("True")); } model.errorlog errr = new model.errorlog() { ErrorMsg = "备份数恢复", errorMsgDetails = mess, errorSrc = "ErrorloController.cs->Recover()", errorTime = DateTime.Now, UserId = userInfo.User.Id, operation = 2 }; errorlog.InsertErrorlog(errr); return(Content(mess)); }
/// <summary> /// 数据备份 /// </summary> /// <param name="fr"></param> public string DateBackups(FormCollection fr) { bll.Errorlogbll errorlog = new bll.Errorlogbll(); string path = "E:\\fabu\\ExcelFile\\database"; if (!string.IsNullOrWhiteSpace(path)) { mess = ""; string DBPath;//备份成功后的文件在服务器的完全路径 bool bo = errorlog.DateBackups(path, out mess, out DBPath); if (bo) { model.errorlog err = new model.errorlog() { ErrorMsg = "备份数据库", errorMsgDetails = "数据库备份", errorSrc = "ErrorloController.cs->DateBackups()", errorTime = DateTime.Now, UserId = userInfo.User.Id, operation = 2 }; errorlog.InsertErrorlog(err); FileInfo file = new FileInfo(Server.MapPath("~/ErrorlogPath.txt")); FileStream sf = file.Open(FileMode.OpenOrCreate); StreamReader sr = new StreamReader(sf, System.Text.Encoding.UTF8); string str = sr.ReadToEnd(); sr.Close(); str = DBPath.Replace(".bak", "") + "\r\n" + str; StreamWriter sw = new StreamWriter(file.Open(FileMode.OpenOrCreate), System.Text.Encoding.UTF8); sw.Write(str); sw.Close(); return(bo.ToString() + "|" + DBPath); } else { model.errorlog err = new model.errorlog() { ErrorMsg = "备份数据库", errorMsgDetails = mess, errorSrc = "ErrorloController.cs->DateBackups()", errorTime = DateTime.Now, UserId = userInfo.User.Id, operation = 2 }; errorlog.InsertErrorlog(err); return(mess); } } //string st= Server.MapPath("~/ErrorlogPath.txt"); //FileInfo file = new FileInfo(st); // FileStream sf = file.Open(FileMode.OpenOrCreate); // StreamReader sr = new StreamReader(sf); // string str = sr.ReadLine(); return("请输入文件路径!"); }