销售出库重复出库，销售退直插接口SQL留存

SELECT * FROM pf_djmx2 WHERE djbh IN ('XSSZDA00003727 ','XSSZDA00003729  ','XSSZDA00003730 ')

--UPDATE pf_djhz2 SET is_sc='是' WHERE djbh IN ('XSSZDA00003727 ','XSSZDA00003729  ','XSSZDA00003730 ')

SELECT TOP 1 * FROM int_wms_xsth_bill
UNION ALL 
INSERT INTO int_wms_xsth_bill
            (djbh,ydjbh,dwbh,rq,ywy,zjy,thlb,yzid,dj_sort,ydj_sort,ydj_sn,spid,sl,js,lss,ph,rq_sc,yxqz,yspd,lastmodifytime,is_zx,BMID,dj,hshj,shlv,je,she,hsje,qxshl,bzyy,clyj,erpdqrq)
SELECT a.djbh,a.djbh AS ydjbh,a.dwbh,a.rq,a.ywy,'成威' AS zjy,'','GZXS',b.dj_sort,b.dj_sort AS ydj_sort,b.dj_sn AS ydj_sn,b.spid,b.shl AS sl,b.baozhshl AS js,b.lingsshl AS lss
      ,b.pihao AS ph,b.baozhiqi AS rq_sc,b.sxrq AS yxqz,1 AS yspd,'','N' AS is_zx,'',0 AS dj,0 AS hshj,0 AS shlv,0 AS je,0 AS she,0 AS hsje,0 AS qxshl,'','',''
FROM pf_djhz2 AS a
     INNER JOIN pf_djmx2 AS b ON a.djbh = b.djbh
WHERE a.djbh IN ('XSSZDA00003727 ','XSSZDA00003729  ','XSSZDA00003730 ')

 

补足采退的

--select top 2 * from int_wms_gjtc_bill


--union all
--insert into int_wms_gjtc_bill
--select a.djbh,a.djbh as ydjbh,a.dwbh,a.rq,'' as thy,'' as cgy,'GZWL' as yzid,b.dj_sort,b.dj_sort as ydj_sort
--      ,b.spid,b.shl as sl,b.baozhshl as js,b.lingsshl as lss,'' as thyy,b.pihao as ph,b.baozhiqi as rq_sc
--      ,b.sxrq as yxqt,'' as kczt,CONVERT(char(19),getdate(),120) as lastmodifytime,'N' as is_zx,'' as billsn
--      ,b.dj_sn as ydj_sn,0 as dj,0 as hshj,0 as shlv,0 as je,0 as hsje,0 as she,0 as qxshl,'' as ssyjh_dwbh
--      ,CONVERT(char(19),getdate(),120) as erpdqrq
--from jzorder_hz as a
--     inner join jzorder_mx as b on a.djbh = b.djbh
--where a.djbs='JHT' and a.djbh in ('JHTZDA00000011','JHTZDA00000012')

--update jzorder_hz set is_sc='是' where djbh in ('JHTZDA00000011','JHTZDA00000012')