/// <summary>
/// 根据入库红冲生成的新入库单，创建待处理队列数据
/// </summary>
/// <param name="newInDocumentRedId"></param>
/// <param name="occurTime"></param>
/// <returns></returns>
public IEnumerable <RealTimeGrossSettlementProcessQueueInfo> CreateByNewInDocumentAtRed(Guid newInDocumentRedId, DateTime occurTime)
{
List <RealTimeGrossSettlementProcessQueueInfo> result = new List <RealTimeGrossSettlementProcessQueueInfo>();
try
{
var newInDocument = _redDao.GetDocumentRed(newInDocumentRedId); // 入库红冲单，对应的新入库单
var newInDocumentDetails = _redDao.GetDocumentRedDetailListByRedId(newInDocumentRedId); // 入库红冲单，对应的新入库单明细
if (newInDocument == null || newInDocument.DocumentType != (int)DocumentType.NewInDocument || newInDocument.RedType != (int)RedType.ModifyPriceInRed || newInDocument.State != (int)DocumentRedState.Finished ||
newInDocumentDetails == null || newInDocumentDetails.Count == 0)
{
return(result);
}
var purchaseStockInRecord = _storageDao.GetStorageRecord(newInDocument.LinkTradeId); // 入库红冲单，对应的原始入库单
var purchaseStockInDetails = _storageDao.GetStorageRecordDetailListByStockId(newInDocument.LinkTradeId); // 入库红冲单，对应的原始入库单明细
if (purchaseStockInRecord == null || purchaseStockInRecord.StockType != (int)StorageRecordType.BuyStockIn || purchaseStockInRecord.StockState != (int)StorageRecordState.Finished ||
purchaseStockInDetails == null || purchaseStockInDetails.Count == 0)
{
return(result);
}
var goodsStockQuantityDict = WMSSao.GetGoodsStockQuantiyByFilialeIdGoodsIds(newInDocument.FilialeId, newInDocumentDetails.Select(m => m.GoodsId).Distinct());
var lastGoodsUnitPriceDict = GetLatestListByMultiGoods(newInDocument.FilialeId, newInDocumentDetails.Select(m => m.GoodsId).Distinct());
foreach (var groupByGoodsId in newInDocumentDetails.GroupBy(g => g.GoodsId))
{
var purchaseStockInDetailsByGoodsId = purchaseStockInDetails.Where(m => m.GoodsId == groupByGoodsId.Key);
var item = new RealTimeGrossSettlementProcessQueueInfo
{
QueueId = Guid.NewGuid(),
FilialeId = newInDocument.FilialeId,
GoodsId = groupByGoodsId.Key,
StockQuantity = goodsStockQuantityDict.ContainsKey(groupByGoodsId.Key) ? goodsStockQuantityDict[groupByGoodsId.Key] : 0,
LastGrossSettlement = lastGoodsUnitPriceDict.ContainsKey(groupByGoodsId.Key) ? lastGoodsUnitPriceDict[groupByGoodsId.Key] : null,
RelatedTradeType = (int)RealTimeGrossSettlementRelatedTradeType.StockInFormDashAtRed,
RelatedTradeNo = newInDocument.TradeCode,
GoodsQuantityInBill = groupByGoodsId.Sum(m => Math.Abs(m.Quantity)),
GoodsAmountInBill = groupByGoodsId.Sum(m => Math.Abs(m.UnitPrice * m.Quantity)), // 红冲单金额
ExtField_1 = purchaseStockInDetailsByGoodsId.Sum(m => Math.Abs(m.UnitPrice * m.Quantity)), // 原采购入库单金额
OccurTime = occurTime == DateTime.MinValue ? (newInDocument.AuditTime.HasValue ? newInDocument.AuditTime.Value : newInDocument.DateCreated) : occurTime,
CreateTime = DateTime.Now
};
result.Add(item);
}
}
catch (Exception ex)
{
ERP.SAL.LogCenter.LogService.LogError(string.Format("创建基于入库红冲生成的新入库单 {0} 的即时结算价失败！", newInDocumentRedId), LOG_TAG, ex);
}
return(result);
}
/// <summary>
/// 根据采购退货出库单，创建待处理队列数据
/// </summary>
/// <param name="purchaseReturnStockOutId"></param>
/// <param name="occurTime"></param>
/// <returns></returns>
public IEnumerable <RealTimeGrossSettlementProcessQueueInfo> CreateByPurchaseReturnStockOut(Guid purchaseReturnStockOutId, DateTime occurTime)
{
List <RealTimeGrossSettlementProcessQueueInfo> result = new List <RealTimeGrossSettlementProcessQueueInfo>();
try
{
var purchaseReturnStockOutRecord = _storageDao.GetStorageRecord(purchaseReturnStockOutId);
var purchaseReturnStockOutDetails = _storageDao.GetStorageRecordDetailListByStockId(purchaseReturnStockOutId);
if (purchaseReturnStockOutRecord == null || purchaseReturnStockOutRecord.StockType != (int)StorageRecordType.BuyStockOut || purchaseReturnStockOutRecord.StockState != (int)StorageRecordState.Finished ||
purchaseReturnStockOutDetails == null || purchaseReturnStockOutDetails.Count == 0)
{
return(result);
}
Dictionary <Guid, int> goodsStockQuantityDict = new Dictionary <Guid, int>();
// 销售公司向物流配送公司采购退货时，销售公司的库存为0
if (purchaseReturnStockOutRecord.TradeBothPartiesType != (int)TradeBothPartiesType.HostingToSale)
{
goodsStockQuantityDict = WMSSao.GetGoodsStockQuantiyByFilialeIdGoodsIds(purchaseReturnStockOutRecord.FilialeId, purchaseReturnStockOutDetails.Select(m => m.GoodsId).Distinct());
}
var lastGoodsUnitPriceDict = GetLatestListByMultiGoods(purchaseReturnStockOutRecord.FilialeId, purchaseReturnStockOutDetails.Select(m => m.GoodsId).Distinct());
foreach (var groupByGoodsId in purchaseReturnStockOutDetails.GroupBy(g => g.GoodsId))
{
var item = new RealTimeGrossSettlementProcessQueueInfo
{
QueueId = Guid.NewGuid(),
FilialeId = purchaseReturnStockOutRecord.FilialeId,
GoodsId = groupByGoodsId.Key,
StockQuantity = goodsStockQuantityDict.ContainsKey(groupByGoodsId.Key) ? goodsStockQuantityDict[groupByGoodsId.Key] : 0,
LastGrossSettlement = lastGoodsUnitPriceDict.ContainsKey(groupByGoodsId.Key) ? lastGoodsUnitPriceDict[groupByGoodsId.Key] : null,
RelatedTradeType = (int)RealTimeGrossSettlementRelatedTradeType.PurchaseReturnStockOut,
RelatedTradeNo = purchaseReturnStockOutRecord.TradeCode,
GoodsQuantityInBill = groupByGoodsId.Sum(m => Math.Abs(m.Quantity)),
GoodsAmountInBill = -groupByGoodsId.Sum(m => Math.Abs(m.UnitPrice * m.Quantity)),// 采购退货，金额为负数
OccurTime = occurTime == DateTime.MinValue ? purchaseReturnStockOutRecord.DateCreated : occurTime,
CreateTime = DateTime.Now
};
result.Add(item);
}
}
catch (Exception ex)
{
ERP.SAL.LogCenter.LogService.LogError(string.Format("创建基于采购退货出库单 {0} 的即时结算价失败！", purchaseReturnStockOutId), LOG_TAG, ex);
}
return(result);
}
/// <summary>
/// 根据来自WMS的拆分组合单，创建待处理队列数据
/// </summary>
/// <param name="bill"></param>
/// <param name="occurTime"></param>
/// <returns></returns>
public IEnumerable <RealTimeGrossSettlementProcessQueueInfo> CreateByCombineSplit(ERP.SAL.WMS.CombineSplitBillDTO bill, DateTime occurTime)
{
List <RealTimeGrossSettlementProcessQueueInfo> result = new List <RealTimeGrossSettlementProcessQueueInfo>();
if (bill == null || bill.Details == null || bill.Details.Count == 0 || bill.Details.Any(m => m.Quantity <= 0))
{
return(result);
}
try
{
var goodsIds = bill.Details.Select(m => m.GoodsId).Union(new Guid[] { bill.GoodsId }).Distinct();
var goodsStockQuantityDict = WMSSao.GetGoodsStockQuantiyByFilialeIdGoodsIds(bill.HostingFilialeId, goodsIds);
if (bill.IsSplit)
{
// 拆分单
var fromGoodsUnitPrice = GetLatestUnitPrice(bill.HostingFilialeId, bill.GoodsId);
var toGoodsUnitPriceDict = GetLatestListByMultiGoods(bill.HostingFilialeId, bill.Details.Select(m => m.GoodsId));
var toTotalCost = bill.Details.Sum(m => m.Quantity * (toGoodsUnitPriceDict.ContainsKey(m.GoodsId) ? toGoodsUnitPriceDict[m.GoodsId].UnitPrice : 0));
foreach (var detail in bill.Details)
{
var item = new RealTimeGrossSettlementProcessQueueInfo
{
QueueId = Guid.NewGuid(),
FilialeId = bill.HostingFilialeId,
GoodsId = detail.GoodsId,
StockQuantity = goodsStockQuantityDict.ContainsKey(detail.GoodsId) ? goodsStockQuantityDict[detail.GoodsId] : 0,
LastGrossSettlement = toGoodsUnitPriceDict.ContainsKey(detail.GoodsId) ? toGoodsUnitPriceDict[detail.GoodsId] : null,
RelatedTradeType = (int)RealTimeGrossSettlementRelatedTradeType.CombineSplit,
RelatedTradeNo = bill.BillNo,
GoodsQuantityInBill = detail.Quantity,
GoodsAmountInBill = fromGoodsUnitPrice * bill.Quantity * detail.Quantity * (toGoodsUnitPriceDict.ContainsKey(detail.GoodsId) ? toGoodsUnitPriceDict[detail.GoodsId].UnitPrice : 0) / toTotalCost,
OccurTime = occurTime == DateTime.MinValue ? DateTime.Now : occurTime,
CreateTime = DateTime.Now
};
result.Add(item);
}
}
else
{
// 组合单
var fromGoodsUnitPriceDict = GetLatestUnitPriceListByMultiGoods(bill.HostingFilialeId, bill.Details.Select(m => m.GoodsId));
var toGoodsUnitPrice = GetLatest(bill.HostingFilialeId, bill.GoodsId);
var item = new RealTimeGrossSettlementProcessQueueInfo
{
QueueId = Guid.NewGuid(),
FilialeId = bill.HostingFilialeId,
GoodsId = bill.GoodsId,
StockQuantity = goodsStockQuantityDict.ContainsKey(bill.GoodsId) ? goodsStockQuantityDict[bill.GoodsId] : 0,
LastGrossSettlement = toGoodsUnitPrice,
RelatedTradeType = (int)RealTimeGrossSettlementRelatedTradeType.CombineSplit,
RelatedTradeNo = bill.BillNo,
GoodsQuantityInBill = bill.Quantity,
GoodsAmountInBill = bill.Details.Sum(m => m.Quantity * (fromGoodsUnitPriceDict.ContainsKey(m.GoodsId) ? fromGoodsUnitPriceDict[m.GoodsId] : 0)),
OccurTime = occurTime == DateTime.MinValue ? DateTime.Now : occurTime,
CreateTime = DateTime.Now
};
result.Add(item);
}
}
catch (Exception ex)
{
ERP.SAL.LogCenter.LogService.LogError(string.Format("创建基于WMS的拆分组合单 {0} 的即时结算价失败！", bill.BillNo), LOG_TAG, ex);
}
return(result);
}