public string fnUpdateAmountSql(ProductStock productStock)
{
ProductStockTran productStockTran = new ProductStockTran();
productStockTran.WarehouseId(productStock.warehouse_id)
.ProductId(productStock.product_id)
.Description("系統進出貨正常變更")
.CreateId(productStock.create_id);
string sSql = fnInsertSql(productStockTran);
sSql +=
" UPDATE [dbo].[MNDTproduct_stock] " +
" SET [amount] = [amount] + " + productStock.amount + " " +
" WHERE [product_id] = '" + productStock.product_id + "' " +
" AND [warehouse_id] = '" + productStock.warehouse_id + "' ";
return(sSql);
}
public string fnUpdate(ProductStock productStock, string sDescription, string sIP)
{
ProductStockTran productStockTran = new ProductStockTran();
productStockTran.WarehouseId(productStock.warehouse_id)
.ProductId(productStock.product_id)
.Description(sDescription)
.CreateId(productStock.create_id);
string sSql = fnInsertSql(productStockTran);
sSql +=
" UPDATE [dbo].[MNDTproduct_stock] " +
" SET [amount] = '" + productStock.amount + "' " +
" ,[safe_amount] = '" + productStock.safe_amount + "' " +
" WHERE [product_id] = '" + productStock.product_id + "' " +
" AND [warehouse_id] = '" + productStock.warehouse_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}