比如单号：SCRK00034982， 首先查询ID select id from xx_productioninstock_item where production_in_stock=(select id from xx_productioninstock where invoicesid='SCRK00034982' and invoices_state='B')
比如：25201, 查询保存的库存数量, 修改为正确的值 select * from xx_productioninventory where productioninstockitem_id='25201' update xx_productioninventory set reality_count=10 where productioninstockitem_id='25201'
