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); }