PDA到货扫描遗漏信息排查

select * from CGDD1 


SELECT  * FROM CGFHD2 WHERE CGFHD2_LSBH+CGFHD2_FLBH IN(SELECT  CGDHD1_C1 FROM  CGDHD1)
AND CGFHD2_ZT='ZZ'


SELECT CGDHD2_CGDDLS,CGDHD2_CGDDFL,CGDHD2_FHDLS,CGDHD2_FHDFL, * FROM CGDHD2 WHERE CGDHD2_LSBH IN(
SELECT  CGDHD1_LSBH  FROM  CGDHD1 WHERE CGDHD1_C1='')


SELECT CGDHD2_CGDDLS,CGDHD2_CGDDFL,CGDHD2_FHDLS,CGDHD2_FHDFL, * FROM CGDHD2 WHERE CGDHD2_LSBH IN(
SELECT  CGDHD1_LSBH  FROM  CGDHD1 WHERE CGDHD1_C1='')

SELECT CGFHD2_ZT, * FROM CGFHD2
WHERE (CGFHD2_LSBH + CGFHD2_FLBH) IN (
SELECT  CGDHD2_FHDLS+CGDHD2_FHDFL FROM CGDHD2 WHERE CGDHD2_LSBH IN(
SELECT  CGDHD1_LSBH   FROM  CGDHD1 WHERE CGDHD1_C1='')
) AND CGFHD2_ZT='ZX'

---更新PDA未返写成功的发货单
UPDATE  CGFHD2 SET CGFHD2_ZT='WC'
WHERE (CGFHD2_LSBH + CGFHD2_FLBH) IN (
SELECT  CGDHD2_FHDLS+CGDHD2_FHDFL FROM CGDHD2 WHERE CGDHD2_LSBH IN(
SELECT  CGDHD1_LSBH   FROM  CGDHD1 WHERE CGDHD1_C1='')
) AND CGFHD2_ZT='ZX'

select * from CGFHD2 WHERE CGFHD2_WLBH='JC0623515012' AND CGFHD2_SL='11000' and CGFHD2_LSBH='90541'

update  CGFHD2 set CGFHD2_ZT='WC' WHERE CGFHD2_WLBH='JC0623515012' AND CGFHD2_SL='11000' and CGFHD2_LSBH='90541'

select  * from CGDHD1 where CGDHD1_C1='905410000000001' 


select  * from CGDD1 where CGDD1_LSBH='19000'
select  * from CGDD2 where CGDD2_LSBH='19000' and CGDD2_WLBH='JC0623515012'
select  * from CGDD2 where CGDD2_WLBH='JC0623515012' and CGDD2_DHSL='11000'


select  * from CGDHD2 where CGDHD2_DDLS='19000'

select  * from CGDHD2 where CGDHD2_WLBH='JC0623515012' and CGDHD2_YSSL=11000

select  * from CGDHD1 where CGDHD1_LSBH=161349

update CGDHD1 set CGDHD1_C1='905410000000001' where CGDHD1_LSBH=161349

select  * from   CGDHD2 where CGDHD2_LSBH=161349

update  CGDHD2 set CGDHD2_FHDLS='90541',CGDHD2_FHDFL='0000000001',CGDHD2_CGDDLS='52053',CGDHD2_CGDDFL='0000000369' 
where CGDHD2_LSBH=161349

select  * from CGDHD2 where CGDHD2_FHDLS is null

select  * from CGFHD1,CGFHD2 where CGFHD1_LSBH=CGFHD2_LSBH and CGFHD2_ZT='ZX' and CGFHD1_FHRQ<'20240701'
AND CGFHD1_YWLX='ZJH'