public static void UpdateInventoryStockAvailabeQty(InventoryStockEntity item)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateInventoryStockAvailabeQty");
command.SetParameterValue("@ProductSysNo",item.ProductSysNo);
command.SetParameterValue("@StockSysNo", item.StockSysNo);
command.SetParameterValue("@SubCountdownQty", item.SubCountdownQty);
command.ExecuteNonQuery();
}
public static InventoryStockEntity GetInventoryStock(int ProductSysNo, int StockSysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetInventoryStockByItemSysNoStockSysNo");
command.SetParameterValue("@ProductSysNo", ProductSysNo);
command.SetParameterValue("@StockSysNo", StockSysNo);
InventoryStockEntity entity = command.ExecuteEntity<InventoryStockEntity>();
return entity;
}
public static InventoryStockEntity InitInventoryStock(int productSysNo, int stockSysNo)
{
InventoryStockEntity entity = new InventoryStockEntity();
entity.ProductSysNo = productSysNo;
entity.StockSysNo = stockSysNo;
DataCommand command = DataCommandManager.GetDataCommand("InsertInventoryStock");
command.SetParameterValue("@ProductSysNo", productSysNo);
command.SetParameterValue("@StockSysNo", stockSysNo);
command.ExecuteEntity<InventoryStockEntity>();
entity.SysNo = Convert.ToInt32(command.GetParameterValue("@SysNo"));
return entity;
}
private static bool BatchUpdateStockVirtual_Run(SecKillEntity countdownItem, string snapShotOnlineQty)
{
if (string.IsNullOrWhiteSpace(countdownItem.AffectedStock))
{
return(true);
}
string Info = null;
if (countdownItem.AffectedStock.Trim().Length > 0)
{
Info = countdownItem.AffectedStock.Trim();
}
string[] InfoArray = Info.Substring(0, Info.Length - 1).Split(';');
Hashtable InfoHt = new Hashtable(10);
for (int i = 0; i < InfoArray.Length; i++)
{
InfoHt.Add(InfoArray[i].Split(':')[0], InfoArray[i].Split(':')[1]);
}
foreach (string key in InfoHt.Keys)
{
object item = InfoHt[key];
InventoryStockEntity instocklist = SecKillDA.GetInventoryStock(countdownItem.ProductSysNo, int.Parse(key));
int AffectedVirtualQty;
if (countdownItem.IsLimitedQty == 1)
{
AffectedVirtualQty = instocklist.AvailableQty + instocklist.ConsignQty
+ instocklist.VirtualQty - Util.TrimIntNull(item);
if (AffectedVirtualQty < 0)
{
AffectedVirtualQty = 0;
}
}
else
{
AffectedVirtualQty = 0;
}
bool bSuccess = SetInventorStockVirtualQty(int.Parse(key), countdownItem.ProductSysNo
, (-1) * AffectedVirtualQty, snapShotOnlineQty, Util.TrimIntNull(item));
if (!bSuccess)
{
return(false);
}
}
return(true);
}
