{"printBb":[{"branch":"0","branchmc":"standard","code":"printYJ_JECFD","createTime":1719559886000,"entityVersion":0,"fr3Name":"第二类麻醉处方.frx","id":"printYJ_JECFD","inParam":"[{\"name\":\"CFH000\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"处方号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"MZZYBZ\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":1}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"CFH000","proceduresParam":"","remark":"处方号","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"MZZYBZ","proceduresParam":"","remark":"","required":true,"testParam":""}],"name":"printYJ_JECFD","outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"sql\",\"name\":\"tableChild\",\"outfieldType\":\"String\",\"value\":\"tableChild\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"LAY_TABLE_INDEX\":1}]","outParams":[{"dataSources":"sql","deFault":"","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"sql","deFault":"","name":"tableChild","outfieldType":"String","paramType":"tableChild","remark":"","value":"tableChild"}],"printType":"FRX","sql":"[{\"name\":\"tableMain\",\"sql\":\"<#if MZZYBZ == '1'>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_YZYPSQ y,BM_YD0000 b\\nwhere TQDJH0 = '${CFH000}' \\nand y.YPNM00 = b.YPNM00\\nand  b.SJDJ00 = '2'\\n<#else>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n      to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_MZCFMX y,BM_YD0000 b\\nwhere CFLSH0 = '${CFH000}'\\nand y.YPNM00 = b.YPNM00\\nand  b.SJDJ00 = '2'\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0},{\"name\":\"tableChild\",\"sql\":\"<#if MZZYBZ == '1'>\\n  select y.BRXM00,\\n\\ty.ZYH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\ty.CH0000,\\n\\tz.RYZDMC ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\tz.FBBH00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as ZYBZ00,\\n    sum(HJJE00) HJJE00,y.TQDJH0 CFH000,\\n   (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \\n  where y.TQDJH0='${CFH000}'\\n\\tand y.ZYH000 = z.ZYH000\\n\\tand z.BRID00 = b.BRID00\\n\\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,y.TQDJH0,b.yblb00\\n<#else>\\n  select y.BRXM00,\\n\\tz.brid00,\\n\\ty.GHH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\tx.ZDMC00,\\n        z.FBBH00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n    (select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as MZBZ00,\\n    y.CFZJE0 HJJE00,\\n    y.CFLSH0 CFH000,\\n   '' as CH0000,\\n (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\\n  where y.CFLSH0='${CFH000}'\\n\\tand y.GHH000 = z.GHH000\\n    and y.GHH000 = x.GHH000\\n\\tand z.BRID00 = b.BRID00\\n\\tand x.GHID00 = y.GHID00\\n  group by   y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,z.FBBH00,y.CFZJE0,y.CFLSH0,b.yblb00\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":1}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"<#if MZZYBZ == '1'>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_YZYPSQ y,BM_YD0000 b\nwhere TQDJH0 = '${CFH000}' \nand y.YPNM00 = b.YPNM00\nand  b.SJDJ00 = '2'\n<#else>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n      to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_MZCFMX y,BM_YD0000 b\nwhere CFLSH0 = '${CFH000}'\nand y.YPNM00 = b.YPNM00\nand  b.SJDJ00 = '2'\n</#if>"},{"isCommit":false,"isProcedures":false,"name":"tableChild","remark":"","sql":"<#if MZZYBZ == '1'>\n  select y.BRXM00,\n\ty.ZYH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\ty.CH0000,\n\tz.RYZDMC ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\tz.FBBH00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as ZYBZ00,\n    sum(HJJE00) HJJE00,y.TQDJH0 CFH000,\n   (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \n  where y.TQDJH0='${CFH000}'\n\tand y.ZYH000 = z.ZYH000\n\tand z.BRID00 = b.BRID00\n\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,y.TQDJH0,b.yblb00\n<#else>\n  select y.BRXM00,\n\tz.brid00,\n\ty.GHH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\tx.ZDMC00,\n        z.FBBH00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n    (select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as MZBZ00,\n    y.CFZJE0 HJJE00,\n    y.CFLSH0 CFH000,\n   '' as CH0000,\n (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\n  where y.CFLSH0='${CFH000}'\n\tand y.GHH000 = z.GHH000\n    and y.GHH000 = x.GHH000\n\tand z.BRID00 = b.BRID00\n\tand x.GHID00 = y.GHID00\n  group by   y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,z.FBBH00,y.CFZJE0,y.CFLSH0,b.yblb00\n</#if>"}],"updateTime":1722501492000,"versions":1}],"printPz":[{"catalog":"XiangMuGuanLi","code":"printYJ_JECFD","entityVersion":0,"id":"printYJ_JECFD","module":"yj","name":"printYJ_JECFD","nowVersions":1,"remark":"医技-零散处方维护-精二处方单","system":"his"}],"printAll":[{"branch":"0","branchmc":"standard","catalog":"XiangMuGuanLi","code":"printYJ_JECFD","createTime":1719559886000,"entityVersion":0,"fr3Name":"第二类麻醉处方.frx","id":"printYJ_JECFD","inParam":"[{\"name\":\"CFH000\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"处方号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"MZZYBZ\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":1}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"CFH000","proceduresParam":"","remark":"处方号","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"MZZYBZ","proceduresParam":"","remark":"","required":true,"testParam":""}],"module":"yj","name":"printYJ_JECFD","nowVersions":1,"outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"sql\",\"name\":\"tableChild\",\"outfieldType\":\"String\",\"value\":\"tableChild\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"LAY_TABLE_INDEX\":1}]","outParams":[{"dataSources":"sql","deFault":"","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"sql","deFault":"","name":"tableChild","outfieldType":"String","paramType":"tableChild","remark":"","value":"tableChild"}],"printType":"FRX","remark":"医技-零散处方维护-精二处方单","sql":"[{\"name\":\"tableMain\",\"sql\":\"<#if MZZYBZ == '1'>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_YZYPSQ y,BM_YD0000 b\\nwhere TQDJH0 = '${CFH000}' \\nand y.YPNM00 = b.YPNM00\\nand  b.SJDJ00 = '2'\\n<#else>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n      to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_MZCFMX y,BM_YD0000 b\\nwhere CFLSH0 = '${CFH000}'\\nand y.YPNM00 = b.YPNM00\\nand  b.SJDJ00 = '2'\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0},{\"name\":\"tableChild\",\"sql\":\"<#if MZZYBZ == '1'>\\n  select y.BRXM00,\\n\\ty.ZYH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\ty.CH0000,\\n\\tz.RYZDMC ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\tz.FBBH00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as ZYBZ00,\\n    sum(HJJE00) HJJE00,y.TQDJH0 CFH000,\\n   (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \\n  where y.TQDJH0='${CFH000}'\\n\\tand y.ZYH000 = z.ZYH000\\n\\tand z.BRID00 = b.BRID00\\n\\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,y.TQDJH0,b.yblb00\\n<#else>\\n  select y.BRXM00,\\n\\tz.brid00,\\n\\ty.GHH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\tx.ZDMC00,\\n        z.FBBH00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n    (select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as MZBZ00,\\n    y.CFZJE0 HJJE00,\\n    y.CFLSH0 CFH000,\\n   '' as CH0000,\\n (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\\n  where y.CFLSH0='${CFH000}'\\n\\tand y.GHH000 = z.GHH000\\n    and y.GHH000 = x.GHH000\\n\\tand z.BRID00 = b.BRID00\\n\\tand x.GHID00 = y.GHID00\\n  group by   y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,z.FBBH00,y.CFZJE0,y.CFLSH0,b.yblb00\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":1}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"<#if MZZYBZ == '1'>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_YZYPSQ y,BM_YD0000 b\nwhere TQDJH0 = '${CFH000}' \nand y.YPNM00 = b.YPNM00\nand  b.SJDJ00 = '2'\n<#else>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n      to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_MZCFMX y,BM_YD0000 b\nwhere CFLSH0 = '${CFH000}'\nand y.YPNM00 = b.YPNM00\nand  b.SJDJ00 = '2'\n</#if>"},{"isCommit":false,"isProcedures":false,"name":"tableChild","remark":"","sql":"<#if MZZYBZ == '1'>\n  select y.BRXM00,\n\ty.ZYH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\ty.CH0000,\n\tz.RYZDMC ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\tz.FBBH00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as ZYBZ00,\n    sum(HJJE00) HJJE00,y.TQDJH0 CFH000,\n   (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \n  where y.TQDJH0='${CFH000}'\n\tand y.ZYH000 = z.ZYH000\n\tand z.BRID00 = b.BRID00\n\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,y.TQDJH0,b.yblb00\n<#else>\n  select y.BRXM00,\n\tz.brid00,\n\ty.GHH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\tx.ZDMC00,\n        z.FBBH00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n    (select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as MZBZ00,\n    y.CFZJE0 HJJE00,\n    y.CFLSH0 CFH000,\n   '' as CH0000,\n (select ybmc00 from ic_ybbrlb where yblb00=b.yblb00) FBMC00\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\n  where y.CFLSH0='${CFH000}'\n\tand y.GHH000 = z.GHH000\n    and y.GHH000 = x.GHH000\n\tand z.BRID00 = b.BRID00\n\tand x.GHID00 = y.GHID00\n  group by   y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,z.FBBH00,y.CFZJE0,y.CFLSH0,b.yblb00\n</#if>"}],"system":"his","updateTime":1722501492000,"versions":1}]}