private void BackupDatabase() { var bm = new BackupDatabaseModel { AuthSelected = Settings.Default.BackupScheduleAuth, CharSelected = Settings.Default.BackupScheduleChar, WorldSelected = Settings.Default.BackupScheduleWorld, BackupsScheduled = Settings.Default.BackupScheduleAuth || Settings.Default.BackupScheduleChar || Settings.Default.BackupScheduleWorld, BackupDays = Settings.Default.BackupDays, BackupHours = Settings.Default.BackupHours, BackupMinutes = Settings.Default.BackupMinutes }; var returnVal = _uiVisualizerService.ShowDialog(new BackupDatabaseViewModel(bm, _uiVisualizerService, _pleaseWaitService, _messageService)); if (returnVal.HasValue && returnVal.Value) { Settings.Default.BackupScheduleAuth = bm.AuthSelected; Settings.Default.BackupScheduleChar = bm.CharSelected; Settings.Default.BackupScheduleWorld = bm.WorldSelected; Settings.Default.BackupDays = bm.BackupDays; Settings.Default.BackupHours = bm.BackupHours; Settings.Default.BackupMinutes = bm.BackupMinutes; Settings.Default.Save(); InitBackupTimer(); } }
/// <summary> /// 记录备份日志 /// </summary> protected void BackupLog() { ///根据管理员编号得到管理员姓名 string strOperator = DataBackupBLL.GetNameByAdminID(Session["Company"].ToString()); DateTime strDataBackupTime = DateTime.Now;// File.GetLastWriteTime(strPathFileName); BackupDatabaseModel backupDatabaseModel = new BackupDatabaseModel(); backupDatabaseModel.DataBackupTime = strDataBackupTime; backupDatabaseModel.OperatorNum = strOperator; backupDatabaseModel.PathFileName = strPathFileName1; ///向数据库备份路径表中插入记录 int addCount = DataBackupBLL.AddBackupDatabase(backupDatabaseModel); if (addCount != 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("004212", "备份日志记录成功!"))); BackupDatabaseDataBind(); } else { Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("004210", "备份日志记录失败,请联络管理员!"))); return; } }
public BackupDatabaseViewModel(BackupDatabaseModel model, IUIVisualizerService uiVisualizerService, IPleaseWaitService pleaseWaitService, IMessageService messageService) { BackupDatabase = model; _uiVisualizerService = uiVisualizerService; _pleaseWaitService = pleaseWaitService; _messageService = messageService; _busy = false; BackupNowCommand = new Command(BackupNow); SaveCommand = new Command(SaveAndClose); }
/// <summary> /// 向数据库备份路径表中插入记录 /// </summary> /// <param name="backupDatabaseModel">数据库备份路径表模型</param> /// <returns>返回向数据库备份路径表中插入记录所影响的行数</returns> public static int AddBackupDatabase(BackupDatabaseModel backupDatabaseModel) { SqlParameter[] sparams = new SqlParameter[] { new SqlParameter("@dataBackupTime", SqlDbType.DateTime), new SqlParameter("@operatorNum", SqlDbType.VarChar, 50), new SqlParameter("@pathFileName", SqlDbType.VarChar, 500) }; sparams[0].Value = backupDatabaseModel.DataBackupTime; sparams[1].Value = backupDatabaseModel.OperatorNum; sparams[2].Value = backupDatabaseModel.PathFileName; return(DBHelper.ExecuteNonQuery("AddBackupDatabase", sparams, CommandType.StoredProcedure)); }
/// <summary> /// 向数据库备份路径表中插入记录 /// </summary> /// <param name="backupDatabaseModel">数据库备份路径表模型</param> /// <returns>返回向数据库备份路径表中插入记录所影响的行数</returns> public static int AddBackupDatabase(BackupDatabaseModel backupDatabaseModel) { return(BackupDatabaseDAL.AddBackupDatabase(backupDatabaseModel)); }