Aegis SQL query

先查询
select * from ProductRouteTransactions where ItemInventoryID in(
select ii1.ID
  from ItemInventories II
  left join Containments CT on II.ID = CT.ParentItemInventoryID
  left join ItemInventories II1 on CT.ChildItemInventoryID = II1.ID
  where II.Identifier = '100152817002021000272318');

把站别ID替换后，执行
update ProductRouteTransactions set TimeCompleted_BaseDateTimeUTC = '2021-11-22 23:21:45.380',
CycleTime =1 where ID = 'AE207F46-9092-498E-9993-3356276F47EA';
update ProductTransactionStatus set StatusEnum =-1 where ProductRouteTransactionID='AE207F46-9092-498E-9993-3356276F47EA';