Ejemplo n.º 1
0
 /// <summary>
 /// 创建自动备份数据库计划
 /// </summary>
 /// <param name="entity">实体参数</param>
 /// <param name="_Mode">执行方式</param>
 /// <param name="_StartTime">执行时间</param>
 public void CreateDbBackup(Base_BackupJob entity, string _Mode, string _StartTime)
 {
     IDatabase database = DataFactory.Database();
     DbTransaction isOpenTrans = database.BeginTrans();
     try
     {
         int IsOk = DataFactory.Database().Insert(entity, isOpenTrans);
         if (IsOk > 0)
         {
             //调用执行备份计划存储过程
             List<DbParameter> parameter = new List<DbParameter>();
             parameter.Add(DbFactory.CreateDbParameter("@ServerName", entity.ServerName));
             parameter.Add(DbFactory.CreateDbParameter("@DbName", entity.DbName));
             parameter.Add(DbFactory.CreateDbParameter("@JobName", entity.JobName));
             parameter.Add(DbFactory.CreateDbParameter("@FilePath", entity.FilePath));
             parameter.Add(DbFactory.CreateDbParameter("@DispatchType", _Mode));
             parameter.Add(DbFactory.CreateDbParameter("@StartTime", _StartTime));
             database.ExecuteByProc("Proc_CreateBackJob", parameter.ToArray(), isOpenTrans);
         }
         database.Commit();
     }
     catch
     {
         database.Rollback();
     }
 }
Ejemplo n.º 2
0
 /// <summary>
 /// 新增备份计划
 /// </summary>
 /// <param name="entity"></param>
 /// <param name="_Mode"></param>
 /// <param name="_StartTime"></param>
 /// <returns></returns>
 public ActionResult AddDbBackup(Base_BackupJob entity, string _Mode, string _StartTime)
 {
     try
     {
         entity.FilePath = entity.FilePath;
         entity.Create();
         base_databasebll.CreateDbBackup(entity, _Mode, _StartTime);
         return Content(new JsonMessage { Success = true, Code = "1", Message = "操作成功" }.ToString());
     }
     catch (Exception ex)
     {
         return Content(new JsonMessage { Success = false, Code = "-1", Message = "操作失败:" + ex.Message }.ToString());
     }
 }