public void RecordDataMigrateJob(PerformContext context) { context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} RecordDataMigrateJob Running ..."); // 从SourceDB查询出符合条件的FinaSettlementlist var finaSettlement10s = SourceDB.Queryable <Models.SourceDB.FinaSettlement>().Where(it => SqlFunc.Between(it.CreateDate, DateTime.Now.AddHours(-1), DateTime.Now)).ToList(); context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} RecordDataMigrateJob 查询SourceDB.AreaList 个数为" + finaSettlement10s.Count.ToString()); if (finaSettlement10s.Count == 0) { context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} 更新个数为" + finaSettlement10s.Count.ToString() + ",停止更新!"); } else { var progressBar = context.WriteProgressBar(); var insertConnt = 0; foreach (Models.SourceDB.FinaSettlement item in finaSettlement10s.WithProgress(progressBar)) { Models.TargetDB.FinaSettlement targetItem = new Models.TargetDB.FinaSettlement(); targetItem.ID = item.ID; targetItem.SerialNumber = item.SerialNumber; targetItem.ClerkID = item.ClerkID; targetItem.ClerkNum = item.ClerkNum; targetItem.Date = item.CreateDate; targetItem.Company = item.Company; targetItem.Reckoner = item.Reckoner; targetItem.Money = item.Money; targetItem.ClearingForm = item.ClearingForm; targetItem.OpeningBank = item.OpeningBank; targetItem.Account = item.Account; targetItem.PrintCount = item.PrintCount; targetItem.PaymentWay = item.PaymentWay; targetItem.Verifier = item.Verifier; targetItem.Status = item.Status; targetItem.Creater = item.Creater; targetItem.CreateDate = item.CreateDate; targetItem.UpdateDate = item.UpdateDate; targetItem.Remark = item.Remark; targetItem.FundContent = "0.0"; // 为什么一个一个插入都不行? int insert = TargetDB.Insertable(targetItem).ExecuteCommand(); insertConnt += insert; } context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} RecordDataMigrateJob 插入TargetDB.AreaList 个数为" + insertConnt); } context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} TrySqlSugarJob Running Over ..."); }
/// <summary> /// DataMigrateJob 数据迁移job /// </summary> /// <param name="context"></param> //[RecurringJob("*/1 * * * *")] //[System.ComponentModel.DisplayName("BaseDataMigrateJob")] //[Queue("jobs")] public void BaseDataMigrateJob(PerformContext context) { context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} DataMigrateJob Running ..."); var areaLists = SourceDB.Queryable <AreaList>().ToList(); context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} DataMigrateJob 查询SourceDB.AreaList 个数为" + areaLists.Count.ToString()); var deleteCount = TargetDB.Deleteable <AreaList>().ExecuteCommand(); context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} DataMigrateJob 删除TargetDB.AreaList 个数为" + deleteCount); var insertConnt = TargetDB.Insertable(areaLists.ToArray()).ExecuteCommand(); context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} DataMigrateJob 插入TargetDB.AreaList 个数为" + insertConnt); context.WriteLine($"{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")} TrySqlSugarJob Running Over ..."); }