public ActionResult Create(Domain.MirrorExport mirror, FormCollection collection)
{
JsonResult ret = new JsonResult();
try
{
var sc = db.SessionConnection.Find(mirror.SCID);
//主机名_模式_日期时间
var pureName = string.Format("{0}_{1}_{2}", sc.SCHostName, mirror.MESchemas,
mirror.MEExportTime.Replace("-", "").Replace(":", "").Replace(" ", ""));
mirror.MEFileName = string.Format("{0}.dmp", pureName);
mirror.MELogFile = string.Format("{0}.log", pureName);
mirror.CreatorID = LoginUser.ID;
mirror.CreationTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
mirror.MEStatus = "创建任务";
db.MirrorExport.Add(mirror);
db.SaveChanges();
ret.Data = JsonConvert.SerializeObject(new
{
status = 0,
message = ""
});
Task.Factory.StartNew(new Action(() =>
{
new DmMirrorExport().ExecuteExport(mirror.ID);
}));
}
catch (Exception ex)
{
ret.Data = JsonConvert.SerializeObject(new
{
status = 1,
message = ex.Message
});
RecordException(ex);
}
return(ret);
}
public ActionResult Create(long scId)
{
CreateAcion();
var sc = db.SessionConnection.Find(scId);
var dic = db.Dictionary.Where(d => d.DTypeCode == "OracleExport" && d.DCode == "backup_dir").FirstOrDefault();
Domain.MirrorExport me = new Domain.MirrorExport()
{
SCID = scId,
MEUser = sc.SCUser,
MEPassword = sc.SCPassword,
MEDirectory = dic.DName,
MESchemas = sc.SCUser,
MEExportTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")
};
using (var dal = new OracleDAL(GetSessionConnStr(scId)))
{
ViewBag.Users = dal.GetAllUsers();
}
return(View(me));
}
