【泛微E9】资产盘点页面拓展插入语句

INSERT INTO uf_zcpdxxzb(formmodeid,pdny,pdbm,zcdl,zclb,kpbm,zcbm,zcmc,ggxh,bgr,bgbm,zczt,sfypd,pdksrq,pdjsrq)
SELECT 144,z.pdny,z.pdbm,k.zcdl,k.zclb,k.kpbm,k.zcbm,k.zcmc,k.ggxh,k.dqsyr,k.zcwz,k.zczt,1,z.pdksrq,z.pdjssj
FROM uf_zcpdzq z,uf_zckp k
WHERE z.pdbm = '{?pdbm}'
AND FIND_IN_SET(k.zcwz,z.bcpdbm)



INSERT INTO uf_zcpdtx(formmodeid,pdbm,bgr,bgbm,pdksrq,pdjsrq)
SELECT 146,z.pdbm,k.dqsyr,k.zcwz,z.pdksrq,z.pdjssj
FROM uf_zcpdzq z,uf_zckp k
WHERE z.pdbm = '{?pdbm}'
AND FIND_IN_SET(k.zcwz,z.bcpdbm)