补领用班组 

---更新限额领料单的领用班组
update lc0019999.KCXED1 SET KCXED1_C3=生产线代码  FROM ningdaMES.dbo.采购领料单主 
where KCXED1_SJDH=条码值 and isnull(KCXED1_C3,'')=''
---更新生产领料单领用班组
update lc0019999.KCCKD1 set KCCKD1_C3 =KCXED1_C3  from  lc0019999.KCXED1 
where KCCKD1_LYBH=KCXED1_SJDH and isnull(KCCKD1_C3,'')=''

 

posted @ 2024-05-14 09:17  CelonY  阅读(7)  评论(0)    收藏  举报