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("请输入文件路径！");
}
