/// <summary>
/// 添加订单商品价格信息
/// </summary>
/// <param name="info"></param>
/// <param name="companyCode"></param>
public void InsertSOPriceItem(SOPriceItemInfo info, int soSysNo, string companyCode)
{
DataCommand command = DataCommandManager.GetDataCommand("SOPrice_Insert_SOPriceItem");
command.SetParameterValue <SOPriceItemInfo>(info, true, false);
command.SetParameterValue("@SOSysNo", soSysNo);
command.SetParameterValue("@CompanyCode", companyCode);
command.ExecuteNonQuery();
}
private decimal CalculateSOPriceItemCashPay(SOPriceItemInfo subSOItem)
{
decimal cash = (subSOItem.OriginalPrice.Value * subSOItem.Quantity.Value - subSOItem.CouponAmount.Value - subSOItem.PointPayAmount.Value);
if (cash <= 0M)
{
cash = 0M;
}
return(cash);
}
public List <SOPriceMasterInfo> SplitSO()
{
bool isCombine = CurrentSO.ShippingInfo.IsCombine.HasValue ? CurrentSO.ShippingInfo.IsCombine.Value : false;
decimal currenSOInvocieAmount = SOCommon.CalculateInvoiceAmount(CurrentSO.BaseInfo.CashPay, CurrentSO.BaseInfo.PremiumAmount.Value, CurrentSO.BaseInfo.ShipPrice.Value, CurrentSO.BaseInfo.PayPrice.Value, CurrentSO.BaseInfo.PromotionAmount.Value, CurrentSO.BaseInfo.GiftCardPay.Value, CurrentSO.BaseInfo.PayWhenReceived.Value);
decimal currenSOReceivableAmount = CurrentSO.BaseInfo.ReceivableAmount;
List <SOPriceMasterInfo> soPriceList = new List <SOPriceMasterInfo>();
if (CurrentSO.Items == null || CurrentSO.Items.Count == 0)
{
return(soPriceList);//BackOrder订单存在0 item的情况
}
//排序的目的是为了最后一个商品的价格是最大的，不会因为减去折扣失败，导致重新计算
List <SOItemInfo> soItemList = CurrentSO.Items.OrderBy(item => item.Price)
.Select(item => item)
.ToList();
SOItemInfo soLastSOItem = soItemList.Last();
SOItemInfo soLastSOItemNoExtend = soItemList.Where(item => (item.ProductType != SOProductType.ExtendWarranty &&
item.ProductType != SOProductType.Coupon)).Last();
//拆分逻辑
decimal itemSumValue = CurrentSO.Items.Sum(x => x.Price.Value * x.Quantity.Value) + CurrentSO.BaseInfo.PromotionAmount.Value;
//计算Item总重量，因为延保和优惠券Weight为0，这里不用排除
decimal totalWeight = CurrentSO.Items.Sum(x => x.Weight.Value * x.Quantity.Value);
decimal residual_CashPay = CurrentSO.BaseInfo.CashPay;
decimal residual_PayPrice = CurrentSO.BaseInfo.PayPrice.Value;
decimal residual_PointPay = CurrentSO.BaseInfo.PointPayAmount.Value;
decimal residual_PremiumAmt = CurrentSO.BaseInfo.PremiumAmount.Value;
decimal residual_PrepayAmt = CurrentSO.BaseInfo.PrepayAmount.Value;
decimal residual_ShippingCharge = CurrentSO.BaseInfo.ShipPrice.Value;
decimal residual_GiftCardPay = CurrentSO.BaseInfo.GiftCardPay.Value;
//找到所有优惠券
List <SOPriceItemInfo> couponProductPriceInfoList = new List <SOPriceItemInfo>();
//找到所有延保
List <SOPriceItemInfo> extendWarrentyProductPriceInfoList = new List <SOPriceItemInfo>();
soItemList.ForEach(item =>
{
SOPriceItemInfo priceItem = new SOPriceItemInfo();
decimal itemRate = (item.Price.Value * item.Quantity.Value + item.PromotionAmount.Value) / (itemSumValue <= 0 ? 1 : itemSumValue);
decimal itemRateForShippingCharge = item.Weight.Value * item.Quantity.Value / (totalWeight <= 0 ? 1 : totalWeight);
priceItem.MasterProductSysNo = item.MasterProductSysNo;
priceItem.PromotionAmount = item.PromotionAmount;
priceItem.Price = item.Price;
priceItem.OriginalPrice = item.OriginalPrice;
priceItem.ProductSysNo = item.ProductSysNo;
priceItem.ProductType = item.ProductType;
priceItem.Quantity = item.Quantity;
priceItem.CouponAmount = item.CouponAmount;
priceItem.GainPoint = item.GainPoint;
priceItem.MasterSysNo = 0;//暂时放仓库编号,作为分仓的中间变量
//对非优惠券项进行分摊
if (item.ProductType != SOProductType.Coupon)
{
if (item != soLastSOItem)
{
priceItem.PayPrice = UtilityHelper.ToMoney(CurrentSO.BaseInfo.PayPrice.Value * itemRate);
residual_PayPrice -= priceItem.PayPrice.Value;
priceItem.PointPayAmount = UtilityHelper.ToMoney(CurrentSO.BaseInfo.PointPayAmount.Value * itemRate);
residual_PointPay -= priceItem.PointPayAmount.Value;
priceItem.PremiumAmount = UtilityHelper.ToMoney(CurrentSO.BaseInfo.PremiumAmount.Value * itemRate);
residual_PremiumAmt -= priceItem.PremiumAmount.Value;
}
else
{
priceItem.PayPrice = UtilityHelper.ToMoney(residual_PayPrice);
priceItem.PointPayAmount = UtilityHelper.ToMoney(residual_PointPay);
priceItem.PremiumAmount = UtilityHelper.ToMoney(residual_PremiumAmt);
}
if (item != soLastSOItemNoExtend)
{
priceItem.ShipPrice = UtilityHelper.ToMoney(CurrentSO.BaseInfo.ShipPrice.Value * itemRateForShippingCharge);
residual_ShippingCharge -= priceItem.ShipPrice.Value;
}
else
{
priceItem.ShipPrice = UtilityHelper.ToMoney(residual_ShippingCharge);
}
//计算现金支付
priceItem.CashPay = UtilityHelper.ToMoney(CalculateSOPriceItemCashPay(priceItem));
decimal priceRate_Prepay = (priceItem.CashPay.Value
+ priceItem.PayPrice.Value
+ priceItem.ShipPrice.Value
+ priceItem.PromotionAmount.Value
+ priceItem.PremiumAmount.Value)
/ (CurrentSO.BaseInfo.SOTotalAmount <= 0 ? 1 : CurrentSO.BaseInfo.SOTotalAmount);
if (item != soLastSOItem)
{
priceItem.PrepayAmount = UtilityHelper.ToMoney(CurrentSO.BaseInfo.PrepayAmount.Value * priceRate_Prepay);
residual_PrepayAmt -= priceItem.PrepayAmount.Value;
priceItem.GiftCardPay = UtilityHelper.ToMoney(CurrentSO.BaseInfo.GiftCardPay.Value * priceRate_Prepay);
residual_GiftCardPay -= priceItem.GiftCardPay.Value;
}
else
{
priceItem.PrepayAmount = UtilityHelper.ToMoney(residual_PrepayAmt);
priceItem.GiftCardPay = UtilityHelper.ToMoney(residual_GiftCardPay);
}
priceItem.ExtendPrice = priceItem.OriginalPrice * priceItem.Quantity;
priceItem.InvoiceAmount = item.OriginalPrice * item.Quantity;
}
// 根据仓库编号将订单商品价格信息分组
switch (item.ProductType.Value)
{
case SOProductType.Product:
case SOProductType.Gift:
case SOProductType.Award:
case SOProductType.Accessory:
case SOProductType.SelfGift:
{
SOPriceMasterInfo soPriceInfo = soPriceList.Find((p) => { return(p.StockSysNo == item.StockSysNo); });
if (soPriceInfo == null)
{
soPriceInfo = new SOPriceMasterInfo();
soPriceInfo.StockSysNo = item.StockSysNo;
soPriceList.Add(soPriceInfo);
}
soPriceInfo.Items.Add(priceItem);
break;
}
case SOProductType.Coupon:
couponProductPriceInfoList.Add(priceItem);
break;
case SOProductType.ExtendWarranty:
extendWarrentyProductPriceInfoList.Add(priceItem);
break;
}
});
int i = 0;
foreach (SOPriceMasterInfo soPriceInfo in soPriceList)
{
i++;
//添加优惠券到每个分仓
soPriceInfo.Items.AddRange(couponProductPriceInfoList);
//延保跟随主商品
extendWarrentyProductPriceInfoList.ForEach(item =>
{
if (soPriceInfo.Items.Exists(o => o.ProductSysNo == int.Parse(item.MasterProductSysNo)))
{
soPriceInfo.Items.Add(item);
}
});
soPriceInfo.CashPay = soPriceInfo.Items.Sum(item => item.CashPay);
soPriceInfo.PromotionAmount = soPriceInfo.Items.Sum(item => item.PromotionAmount);
soPriceInfo.PayPrice = soPriceInfo.Items.Sum(item => item.PayPrice);
soPriceInfo.PointPayAmount = soPriceInfo.Items.Sum(item => item.PointPayAmount);
soPriceInfo.PremiumAmount = soPriceInfo.Items.Sum(item => item.PremiumAmount);
soPriceInfo.PrepayAmount = soPriceInfo.Items.Sum(item => item.PrepayAmount);
soPriceInfo.CouponAmount = soPriceInfo.Items.Sum(item => item.CouponAmount);
soPriceInfo.ShipPrice = soPriceInfo.Items.Sum(item => item.ShipPrice);
soPriceInfo.GainPoint = soPriceInfo.Items.Sum(item => item.GainPoint);
soPriceInfo.GiftCardPay = soPriceInfo.Items.Sum(item => item.GiftCardPay);
soPriceInfo.SOAmount = UtilityHelper.ToMoney(soPriceInfo.Items
.Where(item => item.ProductType == SOProductType.Product ||
item.ProductType == SOProductType.ExtendWarranty)
.Sum(item => item.OriginalPrice.Value * item.Quantity.Value));
decimal substactAmt = 0;
//模式4，发票金额为0
if (CurrentSO.InvoiceInfo.InvoiceType == InvoiceType.MET &&
CurrentSO.ShippingInfo.StockType == StockType.SELF &&
CurrentSO.ShippingInfo.ShippingType == ECCentral.BizEntity.Invoice.DeliveryType.SELF)
{
foreach (SOPriceItemInfo subItem in soPriceInfo.Items)
{
substactAmt += subItem.Price.Value * subItem.Quantity.Value;
subItem.InvoiceAmount = 0;
}
}
//商家仓储，商家开票
if (CurrentSO.ShippingInfo.StockType == StockType.MET &&
CurrentSO.InvoiceInfo.InvoiceType == InvoiceType.MET)
{
foreach (SOPriceItemInfo subItem in soPriceInfo.Items)
{
substactAmt += subItem.Price.Value * subItem.Quantity.Value;
subItem.InvoiceAmount = 0;
}
}
//代收代付的商品需减去InvocieAmt
currenSOInvocieAmount -= substactAmt;
if (i == soPriceList.Count)
{
soPriceInfo.InvoiceAmount = CalculateInvoiceAmount(soPriceInfo, CurrentSO.BaseInfo.PayWhenReceived.Value, isCombine) - substactAmt;
currenSOInvocieAmount -= soPriceInfo.InvoiceAmount.Value;
soPriceInfo.ReceivableAmount = CalculateReceivableAmount(soPriceInfo, CurrentSO.BaseInfo.PayWhenReceived.Value, isCombine);
currenSOReceivableAmount -= soPriceInfo.ReceivableAmount.Value;
}
else
{
soPriceInfo.InvoiceAmount = currenSOInvocieAmount;
soPriceInfo.ReceivableAmount = currenSOReceivableAmount;
}
soPriceInfo.InvoiceAmount = soPriceInfo.InvoiceAmount < 0 ? 0 : soPriceInfo.InvoiceAmount;
soPriceInfo.SOSysNo = SOSysNo;
soPriceInfo.Status = SOPriceStatus.Original;
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//初始化数据，如果存在则删除
SOPriceDA.DeleteSOPriceBySOSysNo(SOSysNo);
foreach (SOPriceMasterInfo priceInfo in soPriceList)
{
SOPriceDA.InsertSOPrice(priceInfo, CurrentSO.CompanyCode);
foreach (SOPriceItemInfo priceItem in priceInfo.Items)
{
priceItem.MasterSysNo = priceInfo.SysNo;
SOPriceDA.InsertSOPriceItem(priceItem, SOSysNo, CurrentSO.CompanyCode);
}
}
scope.Complete();
}
return(soPriceList);
}