private bool DoSave()
{
string sql = FrmDataBaseConfig.GetFileSql("smartaccess_createbackupjob.sql");
string path = this.tbPath.Text.Trim();
path = path.TrimEnd('\\', '/');
sql = sql.Replace("${PATH}", path);
sql = sql.Replace("${ENABLE}", cbAutoBk.Checked ? "1" : "0");
sql = sql.Replace("${DAYS}", iiDays.Value.ToString());
var sqls = sql.Split(new string[] { "GO\r" }, StringSplitOptions.RemoveEmptyEntries);
bool b = false;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
foreach (var item in sqls)
{
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(item);
}
b = true;
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存自动备份配置异常！" + ex.Message);
log.Error("保存自动备份配置异常：", ex);
}
});
waiting.ShowDialog(this);
return(b);
}
private void DoExcute()
{
string sql = FrmDataBaseConfig.GetFileSql("smartaccess_excutebackup.sql");
string path = this.tbPath.Text.Trim();
path = path.TrimEnd('\\', '/');
sql = sql.Replace("${PATH}", path);
var sqls = sql.Split(new string[] { "GO\r" }, StringSplitOptions.RemoveEmptyEntries);
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
foreach (var item in sqls)
{
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(item);
}
this.Invoke(new Action(() =>
{
WinInfoHelper.ShowInfoWindow(this, "立即备份成功！");
}));
}
catch (System.Data.SqlClient.SqlException ex)
{
if (ex.ErrorCode == -2146232060)//
{
WinInfoHelper.ShowInfoWindow(this, "备份异常,请启动Sql Server服务器中服务“SQL Server 代理 (MSSQLSERVER)”！");
}
else
{
WinInfoHelper.ShowInfoWindow(this, "立即备份异常！" + ex.Message);
}
log.Error("立即备份异常：", ex);
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "立即备份异常！" + ex.Message);
log.Error("立即备份异常：", ex);
}
});
waiting.Show(this);
}