{"printBb":[{"branch":"0","branchmc":"standard","code":"printYF_ZYBY_QT","createTime":1619072753000,"entityVersion":0,"fr3Name":"药房_其他发药标签.frx","id":"printYF_ZYBY_QT","inParam":"[{\"name\":\"vDH\",\"isRequired\":true,\"deFault\":\"238392\",\"remark\":\"出库单号或者药品请领批次\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"239724\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"vSFHZ\",\"isRequired\":true,\"deFault\":\"1\",\"remark\":\"vSFHZ=1,vDH=出库单号;vSFHZ=0,vDH=药品请领批次\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"1\",\"required\":true,\"LAY_TABLE_INDEX\":1},{\"name\":\"printMode\",\"isRequired\":true,\"deFault\":\"V\",\"remark\":\"P打印模式V预览模式D设计模式\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"V\",\"required\":true,\"LAY_TABLE_INDEX\":2},{\"name\":\"YYMC00\",\"isRequired\":true,\"deFault\":\"福建省人民医院\",\"remark\":\"医院名称\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"福建省人民医院\",\"required\":true,\"LAY_TABLE_INDEX\":3}]","inParams":[{"deFault":"238392","fieldType":"String","isRequired":true,"name":"vDH","proceduresParam":"","remark":"出库单号或者药品请领批次","required":true,"testParam":"239724"},{"deFault":"1","fieldType":"String","isRequired":true,"name":"vSFHZ","proceduresParam":"","remark":"vSFHZ=1,vDH=出库单号;vSFHZ=0,vDH=药品请领批次","required":true,"testParam":"1"},{"deFault":"V","fieldType":"String","isRequired":true,"name":"printMode","proceduresParam":"","remark":"P打印模式V预览模式D设计模式","required":true,"testParam":"V"},{"deFault":"福建省人民医院","fieldType":"String","isRequired":true,"name":"YYMC00","proceduresParam":"","remark":"医院名称","required":true,"testParam":"福建省人民医院"}],"name":"printYF_ZYBY_QT","outParam":"[{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"main\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"inParam\",\"name\":\"PRINTMODE\",\"outfieldType\":\"String\",\"value\":\"printMode\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":1},{\"dataSources\":\"inParam\",\"name\":\"YYMC00\",\"outfieldType\":\"String\",\"value\":\"YYMC00\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":2}]","outParams":[{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableMain","remark":"","value":"main"},{"dataSources":"inParam","deFault":"","name":"PRINTMODE","outfieldType":"String","paramType":"parameter","remark":"","value":"printMode"},{"dataSources":"inParam","deFault":"","name":"YYMC00","outfieldType":"String","paramType":"parameter","remark":"","value":"YYMC00"}],"printType":"FRX","sql":"[{\"name\":\"main\",\"sql\":\"select \\n  A.CFYZID CFLSH0, --处方号\\n  substrb(A.FYRQ00,1,4)||'-'||substrb(A.FYRQ00,5,2)||'-'||substrb(A.FYRQ00,7,2) FYRQXS, --发药日期(显示用)\\n  A.YPQLPC,   --\\n  A.BRXM00,   --姓名\\n  ' ' XB0000, --性别\\n  a.CH0000,   --床号\\n  substrb(a.CH0000,instrb(a.CH0000,'-')+1,10) CHXS00,  --床号(显示用)\\n  (select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH) BQMC00,  --病区名称\\n  A.YPMC00, --药品名称\\n  A.YPYFMC, --药品用法名称\\n  '('||A.YPGG00||')' YPGG00,\\n -- substr(replace(to_char(A.YPZSL0,'FM9999990.99')||' ','. ','')||a.QLDW00,1,10) SLDW00,   --药品总量\\n substr(SF_YF_YPSLZH(a.YPZSL0*a.ZHL000,a.YPNM00,3),1,10) SLDW00,\\n    nvl((select trim(SM0000)||' ' from BM_PC0000 M where M.PCMC00=A.PCMC00 and rownum=1),' ')||\\n    decode(A.CSL000,null,null,'每次'||rtrim(replace(to_char(A.CSL000/d.ZJJL2J,'FM9999990.99')||' ','. ',''))|| trim(d.ZJJLDW)||\\n    ' ('||rtrim(replace(to_char(A.CSL000,'FM9999990.99')||' ','. ',''))|| trim(A.JLDW00)||')') XXYF00, --详细用法 \\n  case when (a.ypyfmc like '%灌肠%' or a.ypyfmc like '%塞肛%' or a.ypyfmc like '%外用%' \\n   or a.ypyfmc like '%外洗%' or a.ypyfmc like '%阴道%' or a.ypyfmc like '%坐浴%') then a.ypyfmc  \\n    else ' ' end  as BZ0000, --用法备注\\n  D.YFID00,   --用法ID\\n  A.CKDH00,   --出库单号\\n  A.FYRQ00 ,\\nsubstrb(SF_YF_GETKFYPEWM(a.YPQLPC,1),1,200)  as EWM001 \\n,(select MC0000 from BM_TYZD00 ZD where zdmc00='储存方法' and ZD.nbbh00=D.CCFS00) CCFSMC\\nfrom YF_YZYPSQ A, BM_YD0000 D\\n where A.YPNM00=D.YPNM00\\n<#if vSFHZ=='1'>\\n  and CKDH00='${vDH}'\\n<#else >\\n  and YPQLPC in (${vDH})\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"main","remark":"","sql":"select \n  A.CFYZID CFLSH0, --处方号\n  substrb(A.FYRQ00,1,4)||'-'||substrb(A.FYRQ00,5,2)||'-'||substrb(A.FYRQ00,7,2) FYRQXS, --发药日期(显示用)\n  A.YPQLPC,   --\n  A.BRXM00,   --姓名\n  ' ' XB0000, --性别\n  a.CH0000,   --床号\n  substrb(a.CH0000,instrb(a.CH0000,'-')+1,10) CHXS00,  --床号(显示用)\n  (select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH) BQMC00,  --病区名称\n  A.YPMC00, --药品名称\n  A.YPYFMC, --药品用法名称\n  '('||A.YPGG00||')' YPGG00,\n -- substr(replace(to_char(A.YPZSL0,'FM9999990.99')||' ','. ','')||a.QLDW00,1,10) SLDW00,   --药品总量\n substr(SF_YF_YPSLZH(a.YPZSL0*a.ZHL000,a.YPNM00,3),1,10) SLDW00,\n    nvl((select trim(SM0000)||' ' from BM_PC0000 M where M.PCMC00=A.PCMC00 and rownum=1),' ')||\n    decode(A.CSL000,null,null,'每次'||rtrim(replace(to_char(A.CSL000/d.ZJJL2J,'FM9999990.99')||' ','. ',''))|| trim(d.ZJJLDW)||\n    ' ('||rtrim(replace(to_char(A.CSL000,'FM9999990.99')||' ','. ',''))|| trim(A.JLDW00)||')') XXYF00, --详细用法 \n  case when (a.ypyfmc like '%灌肠%' or a.ypyfmc like '%塞肛%' or a.ypyfmc like '%外用%' \n   or a.ypyfmc like '%外洗%' or a.ypyfmc like '%阴道%' or a.ypyfmc like '%坐浴%') then a.ypyfmc  \n    else ' ' end  as BZ0000, --用法备注\n  D.YFID00,   --用法ID\n  A.CKDH00,   --出库单号\n  A.FYRQ00 ,\nsubstrb(SF_YF_GETKFYPEWM(a.YPQLPC,1),1,200)  as EWM001 \n,(select MC0000 from BM_TYZD00 ZD where zdmc00='储存方法' and ZD.nbbh00=D.CCFS00) CCFSMC\nfrom YF_YZYPSQ A, BM_YD0000 D\n where A.YPNM00=D.YPNM00\n<#if vSFHZ=='1'>\n  and CKDH00='${vDH}'\n<#else >\n  and YPQLPC in (${vDH})\n</#if>"}],"updateTime":1712821578000,"versions":1}],"printPz":[{"catalog":"ZhuYuanBaiYao","code":"printYF_ZYBY_QT","entityVersion":0,"id":"printYF_ZYBY_QT","module":"yf","name":"printYF_ZYBY_QT","nowVersions":1,"remark":"其他发药标签","system":"his"}],"printAll":[{"branch":"0","branchmc":"standard","catalog":"ZhuYuanBaiYao","code":"printYF_ZYBY_QT","createTime":1619072753000,"entityVersion":0,"fr3Name":"药房_其他发药标签.frx","id":"printYF_ZYBY_QT","inParam":"[{\"name\":\"vDH\",\"isRequired\":true,\"deFault\":\"238392\",\"remark\":\"出库单号或者药品请领批次\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"239724\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"vSFHZ\",\"isRequired\":true,\"deFault\":\"1\",\"remark\":\"vSFHZ=1,vDH=出库单号;vSFHZ=0,vDH=药品请领批次\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"1\",\"required\":true,\"LAY_TABLE_INDEX\":1},{\"name\":\"printMode\",\"isRequired\":true,\"deFault\":\"V\",\"remark\":\"P打印模式V预览模式D设计模式\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"V\",\"required\":true,\"LAY_TABLE_INDEX\":2},{\"name\":\"YYMC00\",\"isRequired\":true,\"deFault\":\"福建省人民医院\",\"remark\":\"医院名称\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"福建省人民医院\",\"required\":true,\"LAY_TABLE_INDEX\":3}]","inParams":[{"deFault":"238392","fieldType":"String","isRequired":true,"name":"vDH","proceduresParam":"","remark":"出库单号或者药品请领批次","required":true,"testParam":"239724"},{"deFault":"1","fieldType":"String","isRequired":true,"name":"vSFHZ","proceduresParam":"","remark":"vSFHZ=1,vDH=出库单号;vSFHZ=0,vDH=药品请领批次","required":true,"testParam":"1"},{"deFault":"V","fieldType":"String","isRequired":true,"name":"printMode","proceduresParam":"","remark":"P打印模式V预览模式D设计模式","required":true,"testParam":"V"},{"deFault":"福建省人民医院","fieldType":"String","isRequired":true,"name":"YYMC00","proceduresParam":"","remark":"医院名称","required":true,"testParam":"福建省人民医院"}],"module":"yf","name":"printYF_ZYBY_QT","nowVersions":1,"outParam":"[{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"main\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"inParam\",\"name\":\"PRINTMODE\",\"outfieldType\":\"String\",\"value\":\"printMode\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":1},{\"dataSources\":\"inParam\",\"name\":\"YYMC00\",\"outfieldType\":\"String\",\"value\":\"YYMC00\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":2}]","outParams":[{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableMain","remark":"","value":"main"},{"dataSources":"inParam","deFault":"","name":"PRINTMODE","outfieldType":"String","paramType":"parameter","remark":"","value":"printMode"},{"dataSources":"inParam","deFault":"","name":"YYMC00","outfieldType":"String","paramType":"parameter","remark":"","value":"YYMC00"}],"printType":"FRX","remark":"其他发药标签","sql":"[{\"name\":\"main\",\"sql\":\"select \\n  A.CFYZID CFLSH0, --处方号\\n  substrb(A.FYRQ00,1,4)||'-'||substrb(A.FYRQ00,5,2)||'-'||substrb(A.FYRQ00,7,2) FYRQXS, --发药日期(显示用)\\n  A.YPQLPC,   --\\n  A.BRXM00,   --姓名\\n  ' ' XB0000, --性别\\n  a.CH0000,   --床号\\n  substrb(a.CH0000,instrb(a.CH0000,'-')+1,10) CHXS00,  --床号(显示用)\\n  (select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH) BQMC00,  --病区名称\\n  A.YPMC00, --药品名称\\n  A.YPYFMC, --药品用法名称\\n  '('||A.YPGG00||')' YPGG00,\\n -- substr(replace(to_char(A.YPZSL0,'FM9999990.99')||' ','. ','')||a.QLDW00,1,10) SLDW00,   --药品总量\\n substr(SF_YF_YPSLZH(a.YPZSL0*a.ZHL000,a.YPNM00,3),1,10) SLDW00,\\n    nvl((select trim(SM0000)||' ' from BM_PC0000 M where M.PCMC00=A.PCMC00 and rownum=1),' ')||\\n    decode(A.CSL000,null,null,'每次'||rtrim(replace(to_char(A.CSL000/d.ZJJL2J,'FM9999990.99')||' ','. ',''))|| trim(d.ZJJLDW)||\\n    ' ('||rtrim(replace(to_char(A.CSL000,'FM9999990.99')||' ','. ',''))|| trim(A.JLDW00)||')') XXYF00, --详细用法 \\n  case when (a.ypyfmc like '%灌肠%' or a.ypyfmc like '%塞肛%' or a.ypyfmc like '%外用%' \\n   or a.ypyfmc like '%外洗%' or a.ypyfmc like '%阴道%' or a.ypyfmc like '%坐浴%') then a.ypyfmc  \\n    else ' ' end  as BZ0000, --用法备注\\n  D.YFID00,   --用法ID\\n  A.CKDH00,   --出库单号\\n  A.FYRQ00 ,\\nsubstrb(SF_YF_GETKFYPEWM(a.YPQLPC,1),1,200)  as EWM001 \\n,(select MC0000 from BM_TYZD00 ZD where zdmc00='储存方法' and ZD.nbbh00=D.CCFS00) CCFSMC\\nfrom YF_YZYPSQ A, BM_YD0000 D\\n where A.YPNM00=D.YPNM00\\n<#if vSFHZ=='1'>\\n  and CKDH00='${vDH}'\\n<#else >\\n  and YPQLPC in (${vDH})\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"main","remark":"","sql":"select \n  A.CFYZID CFLSH0, --处方号\n  substrb(A.FYRQ00,1,4)||'-'||substrb(A.FYRQ00,5,2)||'-'||substrb(A.FYRQ00,7,2) FYRQXS, --发药日期(显示用)\n  A.YPQLPC,   --\n  A.BRXM00,   --姓名\n  ' ' XB0000, --性别\n  a.CH0000,   --床号\n  substrb(a.CH0000,instrb(a.CH0000,'-')+1,10) CHXS00,  --床号(显示用)\n  (select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH) BQMC00,  --病区名称\n  A.YPMC00, --药品名称\n  A.YPYFMC, --药品用法名称\n  '('||A.YPGG00||')' YPGG00,\n -- substr(replace(to_char(A.YPZSL0,'FM9999990.99')||' ','. ','')||a.QLDW00,1,10) SLDW00,   --药品总量\n substr(SF_YF_YPSLZH(a.YPZSL0*a.ZHL000,a.YPNM00,3),1,10) SLDW00,\n    nvl((select trim(SM0000)||' ' from BM_PC0000 M where M.PCMC00=A.PCMC00 and rownum=1),' ')||\n    decode(A.CSL000,null,null,'每次'||rtrim(replace(to_char(A.CSL000/d.ZJJL2J,'FM9999990.99')||' ','. ',''))|| trim(d.ZJJLDW)||\n    ' ('||rtrim(replace(to_char(A.CSL000,'FM9999990.99')||' ','. ',''))|| trim(A.JLDW00)||')') XXYF00, --详细用法 \n  case when (a.ypyfmc like '%灌肠%' or a.ypyfmc like '%塞肛%' or a.ypyfmc like '%外用%' \n   or a.ypyfmc like '%外洗%' or a.ypyfmc like '%阴道%' or a.ypyfmc like '%坐浴%') then a.ypyfmc  \n    else ' ' end  as BZ0000, --用法备注\n  D.YFID00,   --用法ID\n  A.CKDH00,   --出库单号\n  A.FYRQ00 ,\nsubstrb(SF_YF_GETKFYPEWM(a.YPQLPC,1),1,200)  as EWM001 \n,(select MC0000 from BM_TYZD00 ZD where zdmc00='储存方法' and ZD.nbbh00=D.CCFS00) CCFSMC\nfrom YF_YZYPSQ A, BM_YD0000 D\n where A.YPNM00=D.YPNM00\n<#if vSFHZ=='1'>\n  and CKDH00='${vDH}'\n<#else >\n  and YPQLPC in (${vDH})\n</#if>"}],"system":"his","updateTime":1712821578000,"versions":1}]}