public void AddNLPOST(NetherlandsParcelRespons netherlandsParcelRespons, WayBillInfo wayBillInfo)
{
if (netherlandsParcelRespons == null)
{
throw new BusinessLogicException("数据不能为空！");
}
var result = _netherlandsParcelResponsRepository.Exists(p => p.WayBillNumber == netherlandsParcelRespons.WayBillNumber);
if (result)
{
throw new BusinessLogicException("该数据已存在！");
}
netherlandsParcelRespons.LastUpdatedBy = _workContext.User.UserUame;
netherlandsParcelRespons.LastUpdatedOn = DateTime.Now;
netherlandsParcelRespons.CreatedBy = _workContext.User.UserUame;
netherlandsParcelRespons.CreatedOn = DateTime.Now;
_netherlandsParcelResponsRepository.Add(netherlandsParcelRespons);
wayBillInfo.LastUpdatedBy = _workContext.User.UserUame;
wayBillInfo.LastUpdatedOn = DateTime.Now;
wayBillInfo.CustomerOrderInfo.LastUpdatedBy = _workContext.User.UserUame;
wayBillInfo.CustomerOrderInfo.LastUpdatedOn = DateTime.Now;
_wayBillInfoRepository.Modify(wayBillInfo);
using (var tran = new TransactionScope())
{
_netherlandsParcelResponsRepository.UnitOfWork.Commit();
_wayBillInfoRepository.UnitOfWork.Commit();
AddDeliveryChannelChangeLog(wayBillInfo.WayBillNumber, wayBillInfo.OutShippingMethodID.Value, wayBillInfo.VenderCode);
tran.Complete();
}
}
//修改运单信息
public void UpdateWayBillInfo(string waybillNumber)
{
WayBillInfo getWayBillInfo = _wayBillInfoRepository.First(p => p.WayBillNumber == waybillNumber);
getWayBillInfo.Status = WayBill.StatusToValue(WayBill.StatusEnum.Delivered);
_wayBillInfoRepository.Modify(getWayBillInfo);
_wayBillInfoRepository.UnitOfWork.Commit();
}
public bool UpdateTrackingNumberInfoDetailAndWayBillInfo(WayBillInfo wayBillInfo)
{
bool bResult = false;
if (wayBillInfo == null)
{
return(bResult);
}
if (wayBillInfo.InShippingMethodID.HasValue)
{
var trackingNumberDetail = TrackNumberAssignStandard(wayBillInfo.InShippingMethodID.Value, 1, wayBillInfo.CountryCode);
//_trackingNumberDetailInfoRepository.GetTrackingNumberDetailInfo(wayBillInfo.InShippingMethodID.Value, wayBillInfo.CountryCode);
if (null != trackingNumberDetail && trackingNumberDetail.Any())
{
//trackingNumberDetail.Status = (short)TrackingNumberDetailInfo.StatusEnum.Used;
//trackingNumberDetail.WayBillNumber = wayBillInfo.WayBillNumber;
// _trackingNumberDetailInfoRepository.Modify(trackingNumberDetail);
wayBillInfo.TrackingNumber = trackingNumberDetail[0];
wayBillInfo.LastUpdatedOn = DateTime.Now;
wayBillInfo.LastUpdatedBy = _workContext.User.UserUame;
wayBillInfo.LastUpdatedOn = DateTime.Now;
using (var transaction = new TransactionScope())
{
_wayBillInfoRepository.Modify(wayBillInfo);
//_trackingNumberDetailInfoRepository.UnitOfWork.Commit();
_wayBillInfoRepository.UnitOfWork.Commit();
transaction.Complete();
bResult = true;
}
}
}
return(bResult);
}
public void CreateOutStorage(CreateOutStorageExt createOutStorageExt)
{
Check.Argument.IsNotNull(createOutStorageExt, "createOutStorageExt");
Check.Argument.IsNotNull(createOutStorageExt.OutStorage, "createOutStorageExt.OutStorage");
Check.Argument.IsNotNull(createOutStorageExt.WayBillInfos, "createOutStorageExt.WayBillInfos");
DateTime outStorageCreatedOn = DateTime.Now;
List <string> waybillinfoIds = new List <string>();
createOutStorageExt.WayBillInfos.Each(p => waybillinfoIds.Add(p.WayBillNumber));
var wayBills = _wayBillInfoRepository.GetList(p => waybillinfoIds.Contains(p.WayBillNumber));
List <WayBillEventLog> listWayBillEventLog = new List <WayBillEventLog>();
List <OutStorageInfo> listOutStorageInfo = new List <OutStorageInfo>();
List <CustomerOrderStatus> listCustomerOrderStatus = new List <CustomerOrderStatus>();
List <string> listWaybillSend = new List <string>();
List <string> listWaybillWaitOrder = new List <string>();
List <int> listCustomerOrderId = new List <int>();
var outShippingMethodId = createOutStorageExt.WayBillInfos.First().OutShippingMethodID;
var outShippingMethodName = createOutStorageExt.WayBillInfos.First().OutShippingMethodName;
createOutStorageExt.WayBillInfos.Each(p =>
{
#region 修改运单资料信息和订单状态
var oldstatus = WayBill.StatusToValue(WayBill.StatusEnum.Have);
var wayBillInfo = wayBills.Find(w => w.WayBillNumber == p.WayBillNumber && w.Status == oldstatus);
if (wayBillInfo == null)
{
throw new ArgumentException("该运单号\"{0}\"不存在，或则是当前状态不是已收货！".FormatWith(p.WayBillNumber));
}
//有跟踪号
if (p.HaveTrackingNum)
{
if (p.TrackingNumber == "null" || string.IsNullOrEmpty(p.TrackingNumber))
{
//修改运单状态 待转单
listWaybillWaitOrder.Add(p.WayBillNumber);
}
else
{
//修改运单状态 已发货
listWaybillSend.Add(p.WayBillNumber);
}
}
else
{
//修改运单状态 已发货
listWaybillSend.Add(p.WayBillNumber);
}
//插入订单状态记录
listCustomerOrderStatus.Add(new CustomerOrderStatus
{
CustomerOrderID = wayBillInfo.CustomerOrderID.Value,
CreatedOn = DateTime.Now,
Status = CustomerOrder.StatusToValue(CustomerOrder.StatusEnum.Send)
});
listCustomerOrderId.Add(wayBillInfo.CustomerOrderID.Value);
#region 录入内部信息
var wayBillEventLog = new WayBillEventLog()
{
WayBillNumber = wayBillInfo.WayBillNumber,
EventCode = (int)WayBillEvent.EventCodeEnum.OutStorage,
Description = WayBillEvent.GetEventCodeDescription((int)WayBillEvent.EventCodeEnum.OutStorage),
EventDate = outStorageCreatedOn,
LastUpdatedOn = outStorageCreatedOn,
Operator = _workContext.User.UserUame,
};
listWayBillEventLog.Add(wayBillEventLog);
#endregion
#endregion
});
//createOutStorageExt.WayBillInfos.Each(p =>
// {
// #region 修改运单资料信息和订单状态
// var oldstatus = WayBill.StatusToValue(WayBill.StatusEnum.Have);
// var wayBillInfo = wayBills.Find(w => w.WayBillNumber == p.WayBillNumber && w.Status == oldstatus);
// if (wayBillInfo == null)
// {
// throw new ArgumentException("该运单号\"{0}\"不存在，或则是当前状态不是已收货！".FormatWith(p.WayBillNumber));
// }
// wayBillInfo.OutShippingMethodID = p.OutShippingMethodID;
// wayBillInfo.OutShippingMethodName = p.OutShippingMethodName;
// wayBillInfo.OutStorageID = createOutStorageExt.OutStorage.OutStorageID;
// wayBillInfo.VenderCode = createOutStorageExt.OutStorage.VenderCode;
// //有跟踪号
// if (p.HaveTrackingNum)
// {
// if (p.TrackingNumber == "null" || string.IsNullOrEmpty(p.TrackingNumber))
// {
// //修改运单状态 待转单
// wayBillInfo.Status = WayBill.StatusToValue(WayBill.StatusEnum.WaitOrder);
// }
// else
// {
// //修改运单状态 已发货
// wayBillInfo.Status = WayBill.StatusToValue(WayBill.StatusEnum.Send);
// }
// }
// else
// {
// //修改运单状态 已发货
// wayBillInfo.Status = WayBill.StatusToValue(WayBill.StatusEnum.Send);
// }
// if (wayBillInfo.CustomerOrderID.HasValue)
// {
// //修改订单状态
// wayBillInfo.CustomerOrderInfo.Status =
// CustomerOrder.StatusToValue(CustomerOrder.StatusEnum.Send);
// wayBillInfo.CustomerOrderInfo.LastUpdatedBy = _workContext.User.UserUame;
// wayBillInfo.CustomerOrderInfo.LastUpdatedOn = DateTime.Now;
// //插入订单状态记录
// listCustomerOrderStatus.Add(new CustomerOrderStatus
// {
// CustomerOrderID = wayBillInfo.CustomerOrderID.Value,
// CreatedOn = DateTime.Now,
// Status = CustomerOrder.StatusToValue(CustomerOrder.StatusEnum.Send)
// });
// }
// wayBillInfo.LastUpdatedBy = _workContext.User.UserUame;
// wayBillInfo.LastUpdatedOn = DateTime.Now;
// wayBillInfo.OutStorageCreatedOn = outStorageCreatedOn;
// _wayBillInfoRepository.Modify(wayBillInfo);
// #endregion
// #region 录入内部信息
// //Add By zxq
// //Time:2014-09-15
// var wayBillEventLog = new WayBillEventLog()
// {
// WayBillNumber = wayBillInfo.WayBillNumber,
// EventCode = (int)WayBillEvent.EventCodeEnum.OutStorage,
// Description = WayBillEvent.GetEventCodeDescription((int)WayBillEvent.EventCodeEnum.OutStorage),
// EventDate = DateTime.Now,
// LastUpdatedOn = DateTime.Now,
// Operator = _workContext.User.UserUame,
// };
// listWayBillEventLog.Add(wayBillEventLog);
// #endregion
// });
//生成出仓资料
var outStorage = new OutStorageInfo();
outStorage = createOutStorageExt.OutStorage;
outStorage.DeliveryStaff = outStorage.CreatedBy = outStorage.LastUpdatedBy = _workContext.User.UserUame;
outStorage.CreatedOn = outStorage.LastUpdatedOn = outStorageCreatedOn;
outStorage.Status = 1;
if (createOutStorageExt.WayBillInfos.First().OutShippingMethodName == "国际小包优+")
{
var countryCode = createOutStorageExt.WayBillInfos.First().CountryCode;
string sequenceNumber = SequenceNumberService.GetSequenceNumber("U-");
_mailPostBagInfoRepository.Add(new MailPostBagInfo()
{
CountryCode = countryCode,
OutStorageID = outStorage.OutStorageID,
IsBattery = createOutStorageExt.WayBillInfos.First().IsBattery,
PostBagNumber = sequenceNumber.Replace("-", "-" + countryCode + "-"),
TotalWeight = createOutStorageExt.WayBillInfos.Sum(p => p.Weight),
CreatedBy = outStorage.LastUpdatedBy,
CreatedOn = DateTime.Now,
LastUpdatedBy = outStorage.LastUpdatedBy,
LastUpdatedOn = DateTime.Now,
});
}
//_outStorageInfoRepository.Add(outStorage);
listOutStorageInfo.Add(outStorage);
using (var transaction = new TransactionScope())
{
_wayBillInfoRepository.BulkInsert("WayBillEventLogs", listWayBillEventLog);
_wayBillInfoRepository.BulkInsert("OutStorageInfos", listOutStorageInfo);
_wayBillInfoRepository.BulkInsert("CustomerOrderStatuses", listCustomerOrderStatus);
if (listWaybillSend.Any())
{
_wayBillInfoRepository.Modify(w => new WayBillInfo()
{
OutShippingMethodID = outShippingMethodId,
OutShippingMethodName = outShippingMethodName,
OutStorageID = createOutStorageExt.OutStorage.OutStorageID,
VenderCode = createOutStorageExt.OutStorage.VenderCode,
LastUpdatedBy = _workContext.User.UserUame,
LastUpdatedOn = outStorageCreatedOn,
OutStorageCreatedOn = outStorageCreatedOn,
Status = WayBill.StatusToValue(WayBill.StatusEnum.Send),
}, w => listWaybillSend.Contains(w.WayBillNumber));
}
if (listWaybillWaitOrder.Any())
{
_wayBillInfoRepository.Modify(w => new WayBillInfo()
{
OutShippingMethodID = outShippingMethodId,
OutShippingMethodName = outShippingMethodName,
OutStorageID = createOutStorageExt.OutStorage.OutStorageID,
VenderCode = createOutStorageExt.OutStorage.VenderCode,
LastUpdatedBy = _workContext.User.UserUame,
LastUpdatedOn = outStorageCreatedOn,
OutStorageCreatedOn = outStorageCreatedOn,
Status = WayBill.StatusToValue(WayBill.StatusEnum.WaitOrder),
}, w => listWaybillWaitOrder.Contains(w.WayBillNumber));
}
if (listCustomerOrderId.Any())
{
_customerOrderInfoRepository.Modify(c => new CustomerOrderInfo()
{
Status = CustomerOrder.StatusToValue(CustomerOrder.StatusEnum.Send),
LastUpdatedBy = _workContext.User.UserUame,
LastUpdatedOn = outStorageCreatedOn,
}, c => listCustomerOrderId.Contains(c.CustomerOrderID));
}
//_wayBillInfoRepository.UnitOfWork.Commit();
_mailPostBagInfoRepository.UnitOfWork.Commit();
transaction.Complete();
}
//创建总包号
if (createOutStorageExt.IsCreateTotalPackageNumber.HasValue)
{
if (createOutStorageExt.IsCreateTotalPackageNumber.Value)
{
//创建新的
var totalPackageInfo = new TotalPackageInfo
{
CreatedBy = _workContext.User.UserUame,
LastUpdatedBy = _workContext.User.UserUame,
CreatedOn = outStorageCreatedOn,
LastUpdatedOn = outStorageCreatedOn,
TotalPackageNumber = createOutStorageExt.TotalPackageNumber,
Remark = createOutStorageExt.Remark,
TotalQty = createOutStorageExt.TotalQty,
TotalVotes = createOutStorageExt.TotalVotes,
TotalWeight = createOutStorageExt.TotalWeight,
VenderCode = createOutStorageExt.OutStorage.VenderCode,
VenderName = createOutStorageExt.OutStorage.VenderName
};
_totalPackageInfoRepository.Add(totalPackageInfo);
var relational = new TotalPackageOutStorageRelationalInfo
{
OutStorageID = createOutStorageExt.OutStorage.OutStorageID,
TotalPackageNumber = createOutStorageExt.TotalPackageNumber,
CreatedOn = DateTime.Now
};
_totalPackageOutStorageRelationalInfoRepository.Add(relational);
}
else
{
////追加到已存在的总包号里面
var totalPackageInfo =
_totalPackageInfoRepository.Single(
p =>
p.TotalPackageNumber == createOutStorageExt.TotalPackageNumber &&
p.VenderCode == createOutStorageExt.OutStorage.VenderCode);
if (totalPackageInfo != null)
{
totalPackageInfo.TotalQty += createOutStorageExt.TotalQty;
totalPackageInfo.TotalVotes += createOutStorageExt.TotalVotes;
totalPackageInfo.TotalWeight += createOutStorageExt.TotalWeight;
totalPackageInfo.LastUpdatedBy = _workContext.User.UserUame;
totalPackageInfo.LastUpdatedOn = outStorageCreatedOn;
_totalPackageInfoRepository.Modify(totalPackageInfo);
var relational = new TotalPackageOutStorageRelationalInfo
{
OutStorageID = createOutStorageExt.OutStorage.OutStorageID,
TotalPackageNumber = createOutStorageExt.TotalPackageNumber,
CreatedOn = DateTime.Now
};
_totalPackageOutStorageRelationalInfoRepository.Add(relational);
}
}
using (var transaction = new TransactionScope())
{
_totalPackageInfoRepository.UnitOfWork.Commit();
_totalPackageOutStorageRelationalInfoRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
}
public void BatchAddReturnGoods(List <ReturnGoodsExt> list)
{
var returnList = list.FindAll(p => p.IsDirectReturnGoods).Where(returnGoods =>
!_returnGoodsRepository.Exists(p => p.WayBillNumber == returnGoods.WayBillNumber)).ToList();
if (returnList.Any())
{
//直接退货操作
foreach (var returnGoods in returnList)
{
#region 修改订单、运单状态
var wayBillInfo = _wayBillInfoRepository.Get(returnGoods.WayBillNumber);
if (wayBillInfo != null)
{
if (wayBillInfo.Status != (int)WayBill.StatusEnum.Send && wayBillInfo.Status != (int)WayBill.StatusEnum.WaitOrder)
{
throw new Exception(string.Format("运单{0}的状态不是已发货或待转单", returnGoods.WayBillNumber));
}
wayBillInfo.Status = WayBill.StatusToValue(WayBill.StatusEnum.ReGoodsInStorage);
wayBillInfo.LastUpdatedOn = DateTime.Now;
wayBillInfo.LastUpdatedBy = returnGoods.UserName;
wayBillInfo.CustomerOrderInfo.Status =
CustomerOrder.StatusToValue(CustomerOrder.StatusEnum.ReGoodsInStorage);
wayBillInfo.CustomerOrderInfo.LastUpdatedBy = returnGoods.UserName;
wayBillInfo.CustomerOrderInfo.LastUpdatedOn = DateTime.Now;
_wayBillInfoRepository.Modify(wayBillInfo);
}
#endregion
#region 录入内部信息
if (wayBillInfo != null)
{
//Add By zxq
//Time:2014-09-15
var wayBillEventLog = new WayBillEventLog()
{
WayBillNumber = wayBillInfo.WayBillNumber,
EventCode = (int)WayBillEvent.EventCodeEnum.OutStorage,
Description = WayBillEvent.GetEventCodeDescription((int)WayBillEvent.EventCodeEnum.OutStorage),
EventDate = DateTime.Now,
LastUpdatedOn = DateTime.Now,
Operator = returnGoods.UserName,
};
_wayBillEventLogRepository.Add(wayBillEventLog);
}
#endregion
//退货详细
if (wayBillInfo != null)
{
ReceivingExpensesEditExt receivingExpensesEditExt = new ReceivingExpensesEditExt();
receivingExpensesEditExt =
_financialService.GetReceivingExpensesEditExt(wayBillInfo.WayBillNumber);
ReturnGoods rgGoods = new ReturnGoods()
{
WayBillNumber = returnGoods.WayBillNumber,
Weight = returnGoods.Weight != 0 ? returnGoods.Weight : wayBillInfo.Weight.Value,
CreatedBy = returnGoods.UserName,
CreatedOn = DateTime.Now,
IsReturnShipping = returnGoods.IsReturnShipping,
LastUpdatedBy = returnGoods.UserName,
LastUpdatedOn = DateTime.Now,
Reason = returnGoods.Reason,
ReasonRemark = returnGoods.ReasonRemark,
ReGoodsId = SequenceNumberService.GetSequenceNumber(PrefixCode.ReturnGoodsID),
Type = returnGoods.Type,
Status = (int)ReturnGood.ReturnStatusEnum.UnAudited,
ReturnSource = (int)ReturnGood.ReturnSourceStatusEnum.CSReturn
};
//是否退运费
if (returnGoods.IsReturnShipping)
{
if (receivingExpensesEditExt != null)
{
if (receivingExpensesEditExt.TotalFeeFinal.HasValue)
{
rgGoods.ShippingFee = receivingExpensesEditExt.TotalFeeFinal ?? 0;
}
else if (receivingExpensesEditExt.TotalFeeOriginal.HasValue)
{
rgGoods.ShippingFee = receivingExpensesEditExt.TotalFeeOriginal ?? 0;
}
}
else
{
rgGoods.ShippingFee = 0;
}
}
else
{
rgGoods.ShippingFee = 0;
}
_returnGoodsRepository.Add(rgGoods);
}
using (var transaction = new TransactionScope())
{
_returnGoodsRepository.UnitOfWork.Commit();
_wayBillInfoRepository.UnitOfWork.Commit();
_wayBillEventLogRepository.UnitOfWork.Commit();
_receivingExpensRepository.UnitOfWork.Commit();
transaction.Complete();
}
}
}
}