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));
}
