public ActionResult Add(Entity.SysDbBack entity)
{
LoadType();
if (entity.BackType == 0)
{
ModelState.AddModelError("BackType", "备份类别必选");
}
if (ModelState.IsValid)
{
string msg = "";
BLL.BLLSysDbBack bll = new BLL.BLLSysDbBack();
entity.AddTime = DateTime.Now;
entity.LastUpdateTime = DateTime.Now;
entity.AddUserID = WorkContext.UserInfo.ID;
entity.LastUpdateUserID = WorkContext.UserInfo.ID;
bool is_ok = bll.BackDb(entity, out msg);
if (is_ok)
{
AddAdminLogs(Entity.SysLogMethodType.Add, "新增备份的数据库：" + entity.FilePath);
return(PromptView("/admin/SysDbBack", "OK", "Success", "备份成功", 5));
}
else
{
return(PromptView("/admin/SysDbBack", "404", "Error", msg, 10));
}
}
return(View(entity));
}
/// <summary>
/// 加载平台列表
/// </summary>
private void LoadType()
{
List <SelectListItem> typeList = new List <SelectListItem>();
//typeList.Add(new SelectListItem() { Text = "所有类别", Value = "0" });
foreach (var item in EnumHelper.BEnumToDictionary(typeof(Entity.SysDbBackType)))
{
string text = EnumHelper.GetDescription((Entity.SysDbBackType)item.Key);
typeList.Add(new SelectListItem()
{
Text = text, Value = item.Key.ToString()
});
}
ViewData["TypeList"] = typeList;
BLL.BLLSysDbBack bll = new BLL.BLLSysDbBack();
var db_list = bll.GetSysDbList();
List <SelectListItem> dbList = new List <SelectListItem>();
dbList.Add(new SelectListItem()
{
Text = "请选择数据库", Value = ""
});
foreach (var item in db_list)
{
dbList.Add(new SelectListItem()
{
Text = item.name, Value = item.name
});
}
ViewData["dbList"] = dbList;
}
public JsonResult Del(string ids)
{
if (string.IsNullOrWhiteSpace(ids))
{
WorkContext.AjaxStringEntity.msgbox = "缺少参数";
return(Json(WorkContext.AjaxStringEntity));
}
BLL.BLLSysDbBack bll = new BLL.BLLSysDbBack();
string del_file = "";
string msg = "";
var is_ok = bll.Del(ids, out msg, out del_file);
if (is_ok)
{
AddAdminLogs(Entity.SysLogMethodType.Delete, "删除备份的数据库：" + del_file);
WorkContext.AjaxStringEntity.msg = 1;
WorkContext.AjaxStringEntity.msgbox = "删除成功";
}
else
{
WorkContext.AjaxStringEntity.msgbox = msg;
}
return(Json(WorkContext.AjaxStringEntity));
}
public JsonResult Restore(int id)
{
BLL.BaseBLL <Entity.SysDbBack> bll = new BLL.BaseBLL <Entity.SysDbBack>();
var entity = bll.GetModel(p => p.ID == id, null);
if (entity == null)
{
WorkContext.AjaxStringEntity.msgbox = "备份信息不存在";
}
else
{
string msg = "";
bool is_ok = new BLL.BLLSysDbBack().RestoreDb(entity, out msg);
if (is_ok)
{
AddAdminLogs(Entity.SysLogMethodType.Resotre, "还原数据库：" + entity.FilePath);
WorkContext.AjaxStringEntity.msg = 1;
WorkContext.AjaxStringEntity.msgbox = "还原成功";
}
else
{
WorkContext.AjaxStringEntity.msgbox = msg;
}
}
return(Json(WorkContext.AjaxStringEntity));
}
