/// <summary>
/// 添加商品
/// </summary>
/// <param name="itemEntity"></param>
/// <param name="ItemCategoryCode"></param>
public void AddItem(T_ItemEntity itemEntity, out T_SkuEntity skuEntity, string ItemCategoryName, string ItemCategoryCode, string SkuOriginPrice, string SkuSalesPrice)
{
var skuBll = new T_SkuBLL(CurrentUserInfo);
var skuPriceBll = new T_Sku_PriceBLL(CurrentUserInfo);
var skuProperty = new T_Sku_PropertyBLL(CurrentUserInfo);
var itemCategoryBll = new T_Item_CategoryBLL(CurrentUserInfo);
string ItemCategoryId = itemCategoryBll.CreateOrUpdateItemCategory(ItemCategoryName, ItemCategoryCode, CurrentUserInfo.ClientID, "0000", "1");
T_ItemEntity NewEntity = new T_ItemEntity();
NewEntity.item_id = Guid.NewGuid().ToString("N");
NewEntity.item_category_id = ItemCategoryId;
NewEntity.item_code = itemEntity.item_code;
NewEntity.item_name = itemEntity.item_name;
NewEntity.status = "-1";
NewEntity.status_desc = "下架";
NewEntity.create_user_id = "open";
NewEntity.create_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
NewEntity.modify_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
NewEntity.if_flag = "0";
NewEntity.ifservice = 0; // LM,2016/03/30
NewEntity.IsGB = 0; // LM,2016,03,30
NewEntity.ifgifts = 0;
NewEntity.data_from = "18"; //线下商品来源
NewEntity.ifoften = 0;
NewEntity.display_index = 1;
NewEntity.CustomerId = CurrentUserInfo.ClientID;
Create(NewEntity);
//新增规格|读取规格信息
skuEntity = skuBll.CreateNewSku(NewEntity.item_id);
if (!String.IsNullOrEmpty(skuEntity.sku_id))
{
//商品规格价格 原价|零售价|库存|销量
string SaleCount = "0"; //销量
string StoreCount = "0"; //库存
skuPriceBll.CreateNewSkuPrice(skuEntity.sku_id, SkuOriginPrice, SkuSalesPrice, StoreCount, SaleCount, CurrentUserInfo.ClientID);
}
}
/// <summary>
/// 处理商品销量库存
/// </summary>
/// <param name="orderId">订单ID</param>
/// <param name="inoutDetailList">订单明细</param>
/// <param name="actionType">操作类型 1=提交订单；2=取消订单</param>
/// <param name="loggingSessionInfo"></param>
public void SetStock(string orderId, IList <InoutDetailInfo> inoutDetailList, int actionType, LoggingSessionInfo loggingSessionInfo)
{
var itemPropertyBLL = new T_Item_PropertyBLL(loggingSessionInfo);
var skuPriceBLL = new T_Sku_PriceBLL(loggingSessionInfo);
var inoutService = new InoutService(loggingSessionInfo);
foreach (var item in inoutDetailList)
{
//商品总库存
var stockInfo = itemPropertyBLL.QueryByEntity(new T_Item_PropertyEntity()
{
item_id = item.item_id, prop_id = "34FF4445D39F49AD8174954D18BC1346"
}, null).FirstOrDefault();
if (stockInfo != null)
{
decimal stock = decimal.Parse(stockInfo.prop_value);
if (actionType == 1)
{
stock -= item.enter_qty;
}
else if (actionType == 2)
{
stock += item.enter_qty;
}
stockInfo.prop_value = stock.ToString();
itemPropertyBLL.Update(stockInfo);
}
//商品总销量
var salesCountInfo = itemPropertyBLL.QueryByEntity(new T_Item_PropertyEntity()
{
item_id = item.item_id, prop_id = "34FF4445D39F49AD8174954D18BC1347"
}, null).FirstOrDefault();
if (salesCountInfo != null)
{
decimal salesCount = decimal.Parse(salesCountInfo.prop_value);
if (actionType == 1)
{
salesCount += item.enter_qty;
}
else if (actionType == 2)
{
salesCount -= item.enter_qty;
}
salesCountInfo.prop_value = salesCount.ToString();
itemPropertyBLL.Update(salesCountInfo);
}
//sku库存
var skuStockInfo = skuPriceBLL.QueryByEntity(new T_Sku_PriceEntity()
{
sku_id = item.sku_id, item_price_type_id = "77850286E3F24CD2AC84F80BC625859E", status = "1"
}, null).FirstOrDefault();
if (skuStockInfo != null)
{
if (actionType == 1)
{
skuStockInfo.sku_price -= item.enter_qty;
}
else if (actionType == 2)
{
skuStockInfo.sku_price += item.enter_qty;
}
skuPriceBLL.Update(skuStockInfo);
}
//sku销量
var skuSalesCountInfo = skuPriceBLL.QueryByEntity(new T_Sku_PriceEntity()
{
sku_id = item.sku_id, item_price_type_id = "77850286E3F24CD2AC84F80BC625859f", status = "1"
}, null).FirstOrDefault();
if (skuSalesCountInfo != null)
{
if (actionType == 1)
{
skuSalesCountInfo.sku_price += item.enter_qty;
}
else
{
skuSalesCountInfo.sku_price -= item.enter_qty;
}
skuPriceBLL.Update(skuSalesCountInfo);
}
}
}
