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> /// <returns></returns> public ActionResult ShowErrorlog() { if (Session["count"] == null) { Session["count"] = 20; } if (Session["pageIndex"] == null) { Session["pageIndex"] = 1; } bll.Errorlogbll errorlog = new bll.Errorlogbll(); int menuId = int.Parse(Request.QueryString["menuId"]); PublicHelpController pub = new PublicHelpController(); if (!pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName)) { return(View("../NoPermisson/Index")); } ViewData["IsDelete"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName); ViewData["show"] = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName); ViewData["menuId"] = menuId; ViewData["backups"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.backups); ViewData["recover"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.recover); int listCount; int count = int.Parse(Session["count"].ToString()); List <model.errorlog> list = errorlog.GetListErrorlog(0, count, 1, out listCount, out mess); if (mess != "") { return(Content(mess)); } ViewBag.pageProCount = listCount % count == 0 ? listCount / count : listCount / count + 1; return(View(list)); }
/// <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("请输入文件路径!"); }