public bool Exists(Book.Model.DepotPosition depotPosition, Book.Model.Product product)
{
Hashtable paras = new Hashtable();
paras.Add("positionId", depotPosition.DepotPositionId);
paras.Add("ProductId", product.ProductId);
return(sqlmapper.QueryForObject <int>("Stock.count_productId_depotid", paras) > 0 ? true : false);
}
public void DecrementJC(Book.Model.DepotPosition depotPosition, Book.Model.Product product, double quantity)
{
Hashtable paras = new Hashtable();
paras.Add("Quantity", quantity);
paras.Add("positionId", depotPosition.DepotPositionId);
paras.Add("ProductId", product.ProductId);
sqlmapper.Update("Stock.decrementjc", paras);
}
public void Decrement(Book.Model.DepotPosition depotPosition, Book.Model.Product product, double quantity)
{
if (!Exists(depotPosition, product))
{
Model.Stock stock = new Book.Model.Stock();
stock.StockId = Guid.NewGuid().ToString();
stock.DepotPositionId = depotPosition.DepotPositionId;
stock.DepotId = depotPosition.DepotId;
stock.ProductId = product.ProductId;
stock.StockQuantity1 = 0 - quantity;
this.Insert(stock);
}
else
{
Hashtable paras = new Hashtable();
paras.Add("Quantity", quantity);
paras.Add("positionId", depotPosition.DepotPositionId);
paras.Add("ProductId", product.ProductId);
sqlmapper.Update("Stock.decrement", paras);
}
}
public void Decrement(Book.Model.DepotPosition depotPosition, Book.Model.Product product, double?quantity)
{
this.Decrement(depotPosition, product, quantity == null ? 0 : quantity.Value);
}
/// <param name="position">model 對象</param>
public EditForm(Book.Model.DepotPosition position)
: this()
{
this.depotPosition = position;
this.action = "update";
}
/// <param name="position">model 對象</param>
/// <param name="action">當前動作</param>
public EditForm(Book.Model.DepotPosition position, string action)
: this()
{
this.depotPosition = position;
this.action = action;
}
