库存盘点系统 [英] stock inventory system

问题描述

如何减少编号库存系统中的售后商品数量.我没有得到d代码，以便在完成销售时减少商品数量，并在添加商品数量时增加商品数量.plz帮助我解决问题

how to decrease no. of items after sale in stock inventory system.i m not getting d codes in order to decrease items when sales is done and increase when number of items is added.plz help me out

推荐答案

Dharmendra，

发生销售后，您可以按以下方式更新库存.

售完方法从谢谢页面中为购物车的每个项目调用以下方法.

Hi Dharmendra,

You can update inventory as below after sell happen.

Call below method for each item of cart after sells completion means from thank you page.

public void UpdateInventory(string skuID, int count)
{
   //use below query to update inventory table
   string query = "UPDATE inventory SET itemCount = (itemCount - " + count.ToString() + ") WHERE skuID = '" + skuID + "'";
  //write more code to execute this query
}

要在将物料添加到系统中时更新库存，请使用以下方法.

For updation of inventory when item is added to the system use below method.

public void RefreshInventory(Product product)
{
  //Write your code to update the invenroty
}

希望对您有帮助.

对于更具体的答案，您还需要发布您尝试过的代码段.

Hope this will help you.

For more specific answer you need to post code snippet as well, which you have tried.

这篇关于库存盘点系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！