private void DoJob()
{
#region [备份并删除会员任务详情信息]
var sw = new Stopwatch();
sw.Start();
var maxPkid = DalTaskBackup.GetMaxPkid();
const int newStep = 1000;
var newIndex = 0;
var start = 0;
while (start < maxPkid)
{
if (!CheckSwitch())
{
Logger.Warn($"数据备份开关关闭-->ste3-->备份并删除会员任务详情信息-->min:{start};max:{start + newStep}");
return;
}
sw.Restart();
var backupCount = DalTaskBackup.BackupDetailInfo(start, start + newStep);
var deletedCount = DalTaskBackup.DeleteDetailInfo(start, start + newStep);
sw.Stop();
Logger.Info(
$"备份并删除任务详情数据，第{newIndex + 1}批,共{maxPkid / newStep + 1}批,最小PKID为{start},最大PKID为{start + newStep},备份{backupCount}条数据,删除{deletedCount}条数据,用时{sw.ElapsedMilliseconds}毫秒");
start += newStep;
newIndex++;
}
#endregion
}
private void DoJob()
{
var st = new Stopwatch();
st.Start();
#region [备份并删除会员任务数据]
const int step = 1000;
var startGuid = Guid.Empty;
var index = 0;
var sw = new Stopwatch();
sw.Start();
if (!CheckSwitch())
{
Logger.Warn($"数据备份开关关闭-->step4-->备份并删除会员任务数据-->startGuid:{startGuid};step:{step}");
return;
}
var userList = DalTaskBackup.GetUserList(step, startGuid);
//var userList = new List<Guid> { new Guid("{51cf3203-d28a-4226-b771-6734d8144980}"),new Guid("{0165d634-bd37-47bd-9cc3-3bae23db3823}"),
//new Guid("{ceee291d-7acb-410a-b4aa-5cfa634bd749}"),new Guid("{430cd5a7-4336-460d-8037-95e2ff3af178}"),new Guid("{1c188e5b-5c9d-42ab-8f2a-4cae8bfb86e6}"),new Guid("{452f1ca9-6f83-4ed1-9b9b-18251310a409}"),new Guid("{97cd1f54-12e6-8f43-2bd1-97d80c1f14fb}") };
//var userList = new List<Guid> { new Guid("93F1B820-9F61-4C1E-B1A9-550349FB8A23") };
while (userList.Any())
{
var backupCount = DalTaskBackup.BackupUserTaskInfo(userList);
var deletedCount = DalTaskBackup.DeleteData(userList);
sw.Stop();
Logger.Info(
$"带备份数据第{index}批,用时{sw.ElapsedMilliseconds}毫秒,备份{backupCount}条数据,删除{deletedCount}条数据,最小用户ID是{startGuid},分批步长为{step}条");
startGuid = userList.Last();
index++;
sw.Reset();
sw.Start();
if (!CheckSwitch())
{
Logger.Warn($"数据备份开关关闭-->step2-->备份并删除会员任务数据-->startGuid:{startGuid};step:{step}");
return;
}
userList = DalTaskBackup.GetUserList(step, startGuid);
//userList = new List<Guid>();
}
st.Stop();
Logger.Info($"TaskDataBackupStep2Job-->Step2完成-->用时{st.ElapsedMilliseconds}毫秒");
#endregion
}
private void DoJob()
{
#region [备份已删除任务数据]
if (!CheckSwitch())
{
Logger.Warn("数据备份开关关闭-->step1->备份已删除任务数据");
return;
}
var st = new Stopwatch();
st.Start();
var backupCount = DalTaskBackup.BackupDeletedTask();
Logger.Info($"备份已删除任务数据{backupCount}条!");
if (!CheckSwitch())
{
Logger.Warn("数据备份开关关闭-->清理已删除任务数据");
return;
}
var deletedCount = DalTaskBackup.DeleteData();
Logger.Warn($"删除已备份数据{deletedCount}条!");
if (!CheckSwitch())
{
Logger.Warn("数据备份开关关闭-->清理已删除任务详情数据");
return;
}
var deleteCount2 = DalTaskBackup.DeleteDetailDate();
Logger.Warn($"删除已删除任务详情记录{deleteCount2}条");
st.Stop();
Logger.Info($"TaskDataBackupStep1Job-->Step1完成-->用时{st.ElapsedMilliseconds}毫秒");
#endregion
}
