TDPF 配送退回模拟LIMS退回数据

最新推荐文章于 2024-07-23 18:15:54 发布

NO66781

最新推荐文章于 2024-07-23 18:15:54 发布

阅读量357

点赞数

分类专栏： WMS

本文链接：https://blog.csdn.net/NO66781/article/details/98765110

版权

WMS 专栏收录该内容

4 篇文章 1 订阅

订阅专栏

INSERT INTO INF_ERP_IMP_RK_BILL
            (djbh,dwbh,rq,shy,cgy,zjy,dhfs,bmid,scf,dj_sort,spid,jiansh,lingsshl,shl,dj,je,ph,baozhiqi,sxrq,xhz,rktype,cgddh
            ,yew_type,phzt,branchid,storeid,cgdd_sort,antilotno,wendjl,tuih_reason,yuns_fydd,lengc_wend,lengc_wenkfs,yuns_danw
            ,yuns_qysj,yuns_dhsj,yans_zhjy1,yans_zhjy2,sh_date,ys_date,pzwh,picurl,youx_print,is_zx,is_up,lastmodifytime,qxshl)
SELECT djbh,dwbh,rq,'周海'shy,ywy AS cgy,''zjy,''dhfs,''bmid,''scf,dj_sort,spid,jiansh,lingsshl,shl,dj,je,pihao AS ph,baozhiqi,sxrq,''xhz,'1' rktype,djbh AS cgddh
            ,'4' yew_type,'合格'phzt,''branchid,''storeid,dj_sort AS  cgdd_sort,''antilotno,''wendjl,''tuih_reason,''yuns_fydd,0.00 lengc_wend,''lengc_wenkfs,''yuns_danw
            ,''yuns_qysj,''yuns_dhsj,''yans_zhjy1,''yans_zhjy2,''sh_date,''ys_date,''pzwh,''picurl,''youx_print,'N' is_zx,'Y'is_up,CONVERT(CHAR(19),GETDATE(),120) AS lastmodifytime,0 AS qxshl
FROM JZT_RKJXDJ_HIS 
WHERE djbh='KDBZDA00089330'

--SELECT * FROM pf_djmx2 WHERE djbh='XSSZZY00023563'


INSERT INTO INF_ERP_IMP_RK_BILL
            (djbh,dwbh,rq,shy,cgy,zjy,dhfs,bmid,scf,dj_sort,spid,jiansh,lingsshl,shl,dj,je,ph,baozhiqi
            ,sxrq,xhz,rktype,cgddh,yew_type,phzt,branchid,storeid,cgdd_sort,antilotno,wendjl,tuih_reason
            ,yuns_fydd,lengc_wend,lengc_wenkfs,yuns_danw,yuns_qysj,yuns_dhsj,yans_zhjy1,yans_zhjy2,sh_date
            ,ys_date,pzwh,picurl,youx_print,is_zx,is_up,lastmodifytime,qxshl)
 
--SELECT * FROM ZJK.TDPFZJK.dbo.INF_ERP_IMP_RK_BILL WHERE cgddh ='XSSZZY00024791'
--UNION ALL 
--SELECT * FROM INF_ERP_IMP_RK_BILL WHERE cgddh ='XSSZZY00024791'
--UNION ALL 
SELECT a.djbh,a.dwbh,a.rq,'吕孝星' AS shy,a.ywy AS cgy,'0' AS zjy,'' AS dhfs,'' AS bmid,'0' AS scf,b.dj_sort,b.spid,0 AS jiansh,0 AS lingsshl,b.shl/b.jlgg AS shl
      ,0 AS dj,0 AS je,b.pihao AS ph,b.baozhiqi,b.sxrq,'' AS xhz,'1' AS rktype,a.djbh AS cgddh,'4' AS yew_type,'合格' AS phzt,'' AS branchid,'' AS storeid,b.dj_sn AS cgdd_sort
      ,'' AS antilotno,'' AS wendjl,'' AS tuih_reason,'' AS yuns_fydd,0.00 AS lengc_wend,'' AS lengc_wenkfs,'' AS yuns_danw,'' AS yuns_qysj,'' AS yuns_dhsj,'' AS yans_zhjy1,'' AS yans_zhjy2
      ,'' AS sh_date,'' AS ys_date,'' AS pzwh,'' AS picurl,'' AS youx_print,'N' AS is_zx,'Y' AS is_up,CONVERT(CHAR(19),GETDATE(),121) AS lastmodifytime,0.00 AS qxshl
FROM pf_djhz2 AS a
     INNER JOIN pf_djmx2 AS b ON a.djbh = b.djbh
WHERE a.djbh='XSSZZY00023563'