发票问题派发和还原

---检查入库单是否有被参照过
SELECT  * FROM A_CGFPCW 
where rkdbh in(SELECT CGFP2_RKDBH FROM CGFP1,CGFP2 WHERE CGFP1_LSBH=CGFP2_LSBH )

--查询入库单情况
SELECT KCRKD1_FPHX,KCRKD1_CYFPHX,KCRKD1_KCJZ,KCRKD1_YWBS,KCRKD2_SSSL,KCRKD2_HLSH,KCRKD2_HXSL,KCRKD1_DWBH,KCRKD2_WLBH
FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH  in(SELECT  rkdbh FROM A_CGFPCW )

--还原开票信息
update KCRKD1 set  KCRKD1_FPHX=0,KCRKD1_CYFPHX=1 FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH  in(SELECT  rkdbh FROM A_CGFPCW )
update KCRKD2 set  KCRKD2_HXSL=0 FROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH AND KCRKD1_SJDH  in(SELECT  rkdbh FROM A_CGFPCW )