public string fnUpdateAmountSql(MaterialStock materialStock) { MaterialStockTran materialStockTran = new MaterialStockTran(); materialStockTran.WarehouseId(materialStock.warehouse_id) .MaterialId(materialStock.material_id) .Description("系統進出貨正常變更") .CreateId(materialStock.create_id); string sSql = fnInsertSql(materialStockTran); sSql += " UPDATE [dbo].[MNDTmaterial_stock] " + " SET [amount] = [amount] + " + materialStock.amount + " " + " WHERE [material_id] = '" + materialStock.material_id + "' " + " AND [warehouse_id] = '" + materialStock.warehouse_id + "' "; return(sSql); }
public string fnUpdate(MaterialStock materialStock, string sDescription, string sIP) { MaterialStockTran materialStockTran = new MaterialStockTran(); materialStockTran.WarehouseId(materialStock.warehouse_id) .MaterialId(materialStock.material_id) .Description(sDescription) .CreateId(materialStock.create_id); string sSql = fnInsertSql(materialStockTran); sSql += " UPDATE [dbo].[MNDTmaterial_stock] " + " SET [amount] = '" + materialStock.amount + "' " + " ,[safe_amount] = '" + materialStock.safe_amount + "' " + " WHERE [material_id] = '" + materialStock.material_id + "' " + " AND [warehouse_id] = '" + materialStock.warehouse_id + "' "; return(PublicApi.fnExecuteSQL(sSql, "MNDT")); }