public static void UpdateWayBillEventLogExt(IEnumerable <WayBillEventLogExt> wayBillEventLogExts)
{
WayBillEventLogRepository wayBillEventLogRepository = new WayBillEventLogRepository(new LMS_DbContext());
wayBillEventLogExts.ToList().ForEach(p =>
{
WayBillEventLog wayBillEventLog = new WayBillEventLog();
p.CopyTo(wayBillEventLog);
wayBillEventLogRepository.Modify(wayBillEventLog);
});
wayBillEventLogRepository.UnitOfWork.Commit();
}
private static void Main(string[] args)
{
try
{
var lmsDbContext = new LMS_DbContext();
WayBillInfoRepository wayBillInfoRepository = new WayBillInfoRepository(lmsDbContext);
MailPostBagInfoRepository mailPostBagInfoRepository = new MailPostBagInfoRepository(lmsDbContext);
WayBillEventLogRepository wayBillEventLogRepository = new WayBillEventLogRepository(lmsDbContext);
MailTotalPackageInfoRepository mailTotalPackageInfoRepository =
new MailTotalPackageInfoRepository(lmsDbContext);
MailExchangeBagLogRepository mailExchangeBagLogRepository =
new MailExchangeBagLogRepository(lmsDbContext);
MailReturnGoodsLogRepository mailReturnGoodsLogRepository =
new MailReturnGoodsLogRepository(lmsDbContext);
MailHoldLogRepository mailHoldLogRepository = new MailHoldLogRepository(lmsDbContext);
//MailTotalPackageOrPostBagRelationalRepository mailTotalPackageOrPostBagRelationalRepository= new MailTotalPackageOrPostBagRelationalRepository(lmsDbContext);
List <MailPostBagInfo> listMailPostBagInfo;
List <MailTotalPackageInfo> listMailTotalPackageInfo;
List <MailReturnGoodsLog> listMailReturnGoodsLog;
IEnumerable <Country> listCountry = new CountryRepository(lmsDbContext).GetAll().ToList();
#region 收寄局
while ((listMailPostBagInfo =
mailPostBagInfoRepository.GetFiltered(t => t.FuPostBagNumber != null && t.TrackStatus == 0)
.Take(50).ToList())
.Any())
{
listMailPostBagInfo.ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
wayBillInfoRepository.GetList(
w =>
w.OutStorageID == p.OutStorageID && (w.Status == (int)WayBill.StatusEnum.Send ||
w.Status == (int)WayBill.StatusEnum.WaitOrder)
);
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w =>
{
//if (!wayBillEventLogRepository.Exists(
// we => we.WayBillNumber == w.WayBillNumber && we.EventCode == 610))
//{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 610,
EventDate = p.ScanTime.Value,
Description = "收寄局已收寄",
Operator = p.ScanBy,
LastUpdatedOn = DateTime.Now,
Remarks =
string.Format("发往：{0}",
listCountry.First(c => c.CountryCode == w.CountryCode)
.ChineseName)
});
//}
});
p.TrackStatus = 1;
Log.Info(string.Format("收寄局已收寄,更新袋号：{0}", p.PostBagNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailPostBagInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 收寄局换袋
while ((listMailPostBagInfo =
mailPostBagInfoRepository.GetFiltered(t => t.FuPostBagNumber != null && t.TrackStatus == 3)
.Take(50).ToList())
.Any())
{
listMailPostBagInfo.ForEach(p =>
{
var listTrackNumbers =
mailExchangeBagLogRepository.GetFiltered(me => me.NewPostBagNumber == p.PostBagNumber)
.Select(me => me.TrackNumber).ToList();
//获取换袋的运单
List <WayBillInfo> listWayBillInfo =
wayBillInfoRepository.GetList(
w => w.OutStorageID == p.OutStorageID && listTrackNumbers.Contains(w.TrackingNumber) &&
(w.Status == (int)WayBill.StatusEnum.Send ||
w.Status == (int)WayBill.StatusEnum.WaitOrder));
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w =>
{
//if (!wayBillEventLogRepository.Exists(
// we => we.WayBillNumber == w.WayBillNumber && we.EventCode == 610))
//{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 610,
EventDate = p.ScanTime.Value,
Description = "收寄局已收寄",
Operator = p.ScanBy,
LastUpdatedOn = DateTime.Now,
Remarks =
string.Format("发往：{0}",
listCountry.First(c => c.CountryCode == w.CountryCode)
.ChineseName)
});
//}
});
p.TrackStatus = 1;
Log.Info(string.Format("收寄局已收寄,更新袋号：{0}", p.PostBagNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailPostBagInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 处理中心扫描
while ((listMailPostBagInfo = mailPostBagInfoRepository.GetUnTrackingCreated(50).ToList()).Any())
{
listMailPostBagInfo.ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
wayBillInfoRepository.GetList(
w =>
w.OutStorageID == p.OutStorageID && (w.Status == (int)WayBill.StatusEnum.Send ||
w.Status == (int)WayBill.StatusEnum.WaitOrder));
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w => wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 620,
EventDate =
p.MailTotalPackageOrPostBagRelationals.First().ScanTime,
Description = "邮政处理中心直封封发",
Operator =
p.MailTotalPackageOrPostBagRelationals.First().CreatedBy,
LastUpdatedOn = DateTime.Now,
Remarks =
string.Format("封发总包号：{0}",
p.MailTotalPackageOrPostBagRelationals
.First()
.MailTotalPackageInfo.ShortNumber)
}));
p.TrackStatus = 2;
Log.Info(string.Format("处理中心,更新袋号：{0}", p.PostBagNumber));
});
using (var transaction = new TransactionScope(TransactionScopeOption.Required,
new TimeSpan(0, 5, 0)))
{
mailPostBagInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 离开福州
while ((listMailTotalPackageInfo = mailTotalPackageInfoRepository.GetFiltered(
t =>
t.FZFlightNo != null && t.FuZhouDepartureTime.HasValue && t.TrackStatus == 0 &&
t.FuZhouDepartureTime.Value < DateTime.Now).Take(50).ToList()).Any())
{
listMailTotalPackageInfo.ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
mailPostBagInfoRepository.GetWayBillByMailTotalPackageNumber(
p.MailTotalPackageNumber).Where(w => w.Status == (int)WayBill.StatusEnum.Send ||
w.Status == (int)WayBill.StatusEnum.WaitOrder)
.ToList();
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w =>
{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 630,
EventDate = p.FuZhouDepartureTime.Value,
Description = "货物配载启运，发往台北",
Operator = p.LastUpdatedBy,
LastUpdatedOn = DateTime.Now,
Remarks =
p.FZFlightType == 1
? string.Format("航班号：{0}", p.FZFlightNo)
: string.Format("邮轮号：{0}", p.FZFlightNo),
});
});
p.TrackStatus = 1;
Log.Info(string.Format("离开福州,更新中总包号：{0}", p.MailTotalPackageNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailTotalPackageInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 到达台湾
while (
(listMailTotalPackageInfo =
mailTotalPackageInfoRepository.GetFiltered(
t =>
t.TaiWanArrivedTime.HasValue && t.TrackStatus == 1 &&
t.TaiWanArrivedTime.Value < DateTime.Now)
.Take(50).ToList()).Any())
{
listMailTotalPackageInfo.ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
mailPostBagInfoRepository.GetWayBillByMailTotalPackageNumber(
p.MailTotalPackageNumber);
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w =>
{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 640,
EventDate = p.TaiWanArrivedTime.Value,
Description = string.Format("到达台北分拨中心，等待交航"),
Operator = p.LastUpdatedBy,
LastUpdatedOn = DateTime.Now,
});
});
p.TrackStatus = 2;
Log.Info(string.Format("到达台湾,更新中总包号：{0}", p.MailTotalPackageNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailTotalPackageInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 离开台湾
while (
(listMailTotalPackageInfo =
mailTotalPackageInfoRepository.GetFiltered(
t =>
t.TWFlightNo != null && t.TaiWanDepartureTime.HasValue &&
t.TrackStatus == 2 && t.TaiWanDepartureTime.Value < DateTime.Now).Take(50).ToList()).Any())
{
listMailTotalPackageInfo.ToList().ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
mailPostBagInfoRepository.GetWayBillByMailTotalPackageNumber(
p.MailTotalPackageNumber);
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.ForEach(w =>
{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 650,
EventDate = p.TaiWanDepartureTime.Value,
Description = string.Format("货物交航\r\n(此信息由航空公司提供)"),
Operator = p.LastUpdatedBy,
LastUpdatedOn = DateTime.Now,
Remarks = string.Format("航班号：{0}", p.TWFlightNo),
});
});
p.TrackStatus = 3;
Log.Info(string.Format("离开台湾,更新中总包号：{0}", p.MailTotalPackageNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailTotalPackageInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 到达目的国
while (
(listMailTotalPackageInfo =
mailTotalPackageInfoRepository.GetFiltered(
t =>
t.ToArrivedTime.HasValue && t.TrackStatus == 3 &&
t.ToArrivedTime.Value < DateTime.Now).Take(50).ToList()).Any())
{
listMailTotalPackageInfo.ToList().ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
mailPostBagInfoRepository.GetWayBillByMailTotalPackageNumber(
p.MailTotalPackageNumber);
//退件的不生成记录
var returnTrackNumbers =
mailReturnGoodsLogRepository.GetAll()
.Select(mr => mr.TrackNumber);
//拦截的不生成记录
var holdTrackNumbers = mailHoldLogRepository.GetAll().Select(mr => mr.TrackingNumber);
listWayBillInfo.RemoveAll(w => returnTrackNumbers.Contains(w.TrackingNumber));
listWayBillInfo.RemoveAll(w => holdTrackNumbers.Contains(w.TrackingNumber));
//中文国家名
var countryChineseName = listCountry.First(
c =>
c.CountryCode ==
mailPostBagInfoRepository.GetCountryCodeByMailTotalPackageNumber(p.MailTotalPackageNumber)).ChineseName;
listWayBillInfo.ForEach(w =>
{
wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 660,
EventDate = p.ToArrivedTime.Value,
Description =
string.Format("到达目的地（{0}），预计送达时间1～2天\r\n(此信息由航空公司提供)",
countryChineseName),
Operator = p.LastUpdatedBy,
LastUpdatedOn = DateTime.Now,
Remarks = string.Format("航班号：{0}", p.TWFlightNo),
});
});
p.TrackStatus = 4;
Log.Info(string.Format("到达目的国,更新中总包号：{0}", p.MailTotalPackageNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailTotalPackageInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
#region 退件
while ((listMailReturnGoodsLog =
mailReturnGoodsLogRepository.GetFiltered(t => t.TrackStatus == 0)
.Take(50).ToList())
.Any())
{
listMailReturnGoodsLog.ForEach(p =>
{
List <WayBillInfo> listWayBillInfo =
wayBillInfoRepository.GetList(
w =>
w.TrackingNumber == p.TrackNumber && (w.Status == (int)WayBill.StatusEnum.Send ||
w.Status == (int)WayBill.StatusEnum.WaitOrder)
);
listWayBillInfo.ForEach(w => wayBillEventLogRepository.Add(new WayBillEventLog()
{
WayBillNumber = w.WayBillNumber,
EventCode = 635,
EventDate = p.ReturnOn,
Description = "退回操作中心",
Operator = p.ReturnBy,
LastUpdatedOn = DateTime.Now,
Remarks = string.Format("已退回操作中心")
}));
p.TrackStatus = 1;
Log.Info(string.Format("收寄局已收寄,更新袋号：{0}", p.PostBagNumber));
});
using (
var transaction = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 5, 0)))
{
mailPostBagInfoRepository.UnitOfWork.Commit();
wayBillEventLogRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
#endregion
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
