update InvoiceItem set expensiveDGBarcode=(select barcode from barcodeDevice where id=(select expensiveDisposablegoodsId from DiposableGoodsItem where invoiceItemID=InvoiceItem.id)) where amount=1 and disposableGoodsType='高值耗材'; update DiposableGoodsItem set expensiveDGBarcode=(select barcode from barcodeDevice where id=DiposableGoodsItem.expensiveDisposablegoodsId) where expensiveDisposablegoodsId is not null and expensiveDGBarcode is null;