public async System.Threading.Tasks.Task RequestTestAsync()
{
WMSGetDeliveryDetailListReqModel reqModel = new WMSGetDeliveryDetailListReqModel();
reqModel.DateFor = DateTime.Parse("2019-10-01");
reqModel.DateTo = DateTime.Parse("2020-12-30");
string[] wharehouseIds = new string[1];
wharehouseIds[0] = "21";
reqModel.WarehouseArr = wharehouseIds;
WMSGetDeliveryDetailListRequest req = new WMSGetDeliveryDetailListRequest("admin", "eccang123456", reqModel);
var response = await req.Request();
}
public override async Task Job(DateTime?datetime = null)
{
List <ECDeliveryDetail> insertList = new List <ECDeliveryDetail>();
List <ECDeliveryDetail> updateList = new List <ECDeliveryDetail>();
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECDeliveryDetail>();
DateTime lastGetTime = (DateTime)repository.GetPage(0, 1, x => x.OrderByDescending(c => c.AddTime)).FirstOrDefault().AddTime;
WMSGetDeliveryDetailListReqModel reqModel = new WMSGetDeliveryDetailListReqModel();
reqModel.DateFor = lastGetTime;
reqModel.DateTo = DateTime.Now;
reqModel.PageSize = 5;
reqModel.Page = 1;
WMSGetDeliveryDetailListRequest req = new WMSGetDeliveryDetailListRequest(login.Username, login.Password, reqModel);
log.Info($"出库单 - 开始拉取,请求参数:{JsonConvert.SerializeObject(reqModel, new IsoDateTimeConverter { DateTimeFormat = "yyyy - MM - dd HH: mm:ss" })}");
var response = await req.Request();
response.TotalCount = response.TotalCount == null ? "1" : response.TotalCount;
int pageNum = (int)Math.Ceiling(long.Parse(response.TotalCount) * 1.0 / 1000);
log.Info($"出库单 - 共计{pageNum}页");
for (int page = 1; page < pageNum + 1; page++)
{
reqModel.PageSize = 1000;
reqModel.Page = page;
try
{
log.Info($"出库单 - 正在拉取第{page}页;");
req = new WMSGetDeliveryDetailListRequest(login.Username, login.Password, reqModel);
response = await req.Request();
}
catch (Exception ex)
{
log.Error($"出库单 - 接口调用出现异常:{ex.Message}");
throw;
}
foreach (var item in response.Body)
{
try
{
var m = Mapper <EC_DeliveryDetail, ECDeliveryDetail> .Map(item);
var res = repository.Get(item.IlId);
if (res != null)
{
updateList.Add(m);
}
else
{
insertList.Add(m);
}
}
catch (Exception ex)
{
log.Error($"出库单 - 转换实体类出现异常:{ex.Message}");
throw ex;
}
}
try
{
insertList = insertList.GroupBy(item => item.IlId).Select(item => item.First()).ToList();
updateList = updateList.GroupBy(item => item.IlId).Select(item => item.First()).ToList();
await repository.BulkInsertAsync(insertList, x => x.IncludeGraph = true);
await repository.BulkUpdateAsync(updateList, x => x.IncludeGraph = true);
uow.BulkSaveChanges();
insertList.Clear();
updateList.Clear();
}
catch (Exception ex)
{
log.Error($"出库单 - 写入数据库异常:{ex.Message}");
throw ex;
}
}
log.Info($"出库单 - 写入完成");
}
log.Info($"出库单 - 任务完成");
}
public override async Task Job(DateTime?datetime = null)
{
WMSGetDeliveryDetailListReqModel reqModel = new WMSGetDeliveryDetailListReqModel();
reqModel.DateFor = DateTime.Parse("2018-01-01");
reqModel.DateTo = DateTime.Now;
reqModel.PageSize = 5;
reqModel.Page = 1;
List <ECDeliveryDetail> deliveryDetails = new List <ECDeliveryDetail>();
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECDeliveryDetail>();
try
{
await repository.DeleteAll();
await uow.SaveChangesAsync();
}
catch (Exception ex)
{
log.Error($"初始化入库单信息,删除入库单信息异常:{ex.Message}");
throw ex;
}
WMSGetDeliveryDetailListRequest req = new WMSGetDeliveryDetailListRequest(login.Username, login.Password, reqModel);
var response = await req.Request();
response.TotalCount = response.TotalCount == null ? "1" : response.TotalCount;
int pageNum = (int)Math.Ceiling(long.Parse(response.TotalCount) * 1.0 / 1000);
for (int page = pageNum; page > 0; page--)
{
reqModel.PageSize = 1000;
reqModel.Page = page;
try
{
log.Info($"入库单信息,开始拉取:时间区间{reqModel.DateFor.ToString()}TO{reqModel.DateTo.ToString()}第{page}页;");
req = new WMSGetDeliveryDetailListRequest(login.Username, login.Password, reqModel);
response = await req.Request();
}
catch (Exception ex)
{
log.Error($"初始化入库单信息,接口调用出现异常:时间区间{reqModel.DateFor.ToString()}TO{reqModel.DateTo.ToString()}第{page}页;异常信息:{ex.Message}");
throw;
}
foreach (var item in response.Body)
{
try
{
var m = Mapper <EC_DeliveryDetail, ECDeliveryDetail> .Map(item);
deliveryDetails.Add(m);
}
catch (Exception ex)
{
log.Error($"初始化入库单信息,转换实体类出现异常:时间区间{reqModel.DateFor.ToString()}TO{reqModel.DateTo.ToString()}第{page}页;异常信息:{ex.Message}");
throw ex;
}
}
try
{
await repository.BulkInsertAsync(deliveryDetails, x => x.IncludeGraph = true);
uow.BulkSaveChanges();
deliveryDetails.Clear();
}
catch (Exception ex)
{
log.Error($"入库单信息,写入数据库异常:时间区间{reqModel.DateFor.ToString()}TO{reqModel.DateTo.ToString()}第{page}页;异常信息:{ex.Message}");
throw ex;
}
}
log.Info($"入库单信息拉取写入完成,时间区间{reqModel.DateFor.ToString()}TO{reqModel.DateTo.ToString()}");
}
}