{"printBb":[{"branch":"0","branchmc":"standard","code":"printYF_ZYBYMX_CYDY","createTime":1620115728000,"entityVersion":0,"fr3Name":"药房_住院摆药明细单(出院带药).frx","id":"printYF_ZYBYMX_CYDY","inParam":"[{\"name\":\"vDh\",\"isRequired\":true,\"deFault\":\"238382\",\"remark\":\"vType为1是药品请领批次，其他是出库单号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"238382\",\"required\":true,\"_VCUID\":\"row_483\"},{\"name\":\"vType\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"0整单1部分2多单\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"0\",\"required\":true,\"_VCUID\":\"row_484\"},{\"name\":\"vMZZY\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"0门诊药房1住院药房2出院带药\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"2\",\"required\":true,\"_VCUID\":\"row_485\"},{\"name\":\"xtcsValue\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"YF_BYDCZSFXSTYD值\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"0\",\"required\":true,\"_VCUID\":\"row_486\"},{\"name\":\"CFYZID\",\"isRequired\":false,\"deFault\":\"3718530\",\"remark\":\"vMZZY为0必填，处方医嘱ID\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"3718530\",\"required\":false,\"_VCUID\":\"row_487\"},{\"name\":\"BRID00\",\"isRequired\":false,\"deFault\":\"2709191\",\"remark\":\"vMZZY为0必填,病人ID\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"2709191\",\"required\":false,\"_VCUID\":\"row_488\"},{\"name\":\"CKDH00\",\"isRequired\":false,\"deFault\":\"238382\",\"remark\":\"vMZZY为0且vType 为1必填,出库单号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"238382\",\"required\":false,\"_VCUID\":\"row_489\"},{\"name\":\"vMXDYPX\",\"isRequired\":false,\"deFault\":\"BQBMBH\",\"remark\":\"vMZZY为1或2必填\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"BQBMBH\",\"required\":false,\"_VCUID\":\"row_490\"},{\"name\":\"printMode\",\"isRequired\":true,\"deFault\":\"V\",\"remark\":\"P打印模式V预览模式D设计模式\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"V\",\"required\":true,\"_VCUID\":\"row_491\"}]","inParams":[{"deFault":"238382","fieldType":"String","isRequired":true,"name":"vDh","proceduresParam":"","remark":"vType为1是药品请领批次，其他是出库单号","required":true,"testParam":"238382"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"vType","proceduresParam":"","remark":"0整单1部分2多单","required":true,"testParam":"0"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"vMZZY","proceduresParam":"","remark":"0门诊药房1住院药房2出院带药","required":true,"testParam":"2"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"xtcsValue","proceduresParam":"","remark":"YF_BYDCZSFXSTYD值","required":true,"testParam":"0"},{"deFault":"3718530","fieldType":"String","isRequired":false,"name":"CFYZID","proceduresParam":"","remark":"vMZZY为0必填，处方医嘱ID","required":false,"testParam":"3718530"},{"deFault":"2709191","fieldType":"String","isRequired":false,"name":"BRID00","proceduresParam":"","remark":"vMZZY为0必填,病人ID","required":false,"testParam":"2709191"},{"deFault":"238382","fieldType":"String","isRequired":false,"name":"CKDH00","proceduresParam":"","remark":"vMZZY为0且vType 为1必填,出库单号","required":false,"testParam":"238382"},{"deFault":"BQBMBH","fieldType":"String","isRequired":false,"name":"vMXDYPX","proceduresParam":"","remark":"vMZZY为1或2必填","required":false,"testParam":"BQBMBH"},{"deFault":"V","fieldType":"String","isRequired":true,"name":"printMode","proceduresParam":"","remark":"P打印模式V预览模式D设计模式","required":true,"testParam":"V"}],"name":"printYF_ZYBYMX_CYDY","outParam":"[{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"main\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"_VCUID\":\"row_494\"},{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"child\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"_VCUID\":\"row_495\"},{\"dataSources\":\"inParam\",\"name\":\"PRINTMODE\",\"outfieldType\":\"String\",\"value\":\"printMode\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"_VCUID\":\"row_496\"}]","outParams":[{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableMain","remark":"","value":"main"},{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableChild","remark":"","value":"child"},{"dataSources":"inParam","deFault":"","name":"PRINTMODE","outfieldType":"String","paramType":"parameter","remark":"","value":"printMode"}],"printType":"FRX","sql":"[{\"name\":\"main\",\"sql\":\"<#if vMZZY== '0'>  \\n  <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n    select distinct a.* from VW_YF_ZYBYDYDJ  A where (ZYID00,CFYZID,CKDH00) in      \\n    (select ZYID00,CFYZID,CKDH00 from YF_YZYPSQ where YPQLPC in (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>\\n<#elseif vMZZY== '1'> \\n   <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \\n     (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>\\n<#elseif vMZZY== '2'> \\n  <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \\n     (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>  \\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"_VCUID\":\"row_492\"},{\"name\":\"child\",\"sql\":\"select YPQLPC, YPMC00, YPGG00, CSL000, PCMC00, YPZSL0, nvl(JYZSL0,0) JYZSL0, nvl(SFZSL0,0) SFZSL0, nvl(JCZSL0,0) JCZSL0, \\nnvl(GHZSL0,0) GHZSL0, QLDW00, YPYF00, LSDJ00, YPJE00, TS0000, YYRQ00, YSXM00, CKDH00, \\nBRID00, ZYID00, ZYH000, XM0000, JLDW00, YZID00, YZMXID, XMYFMC, ZCXSL0, \\nCXCSL0, FYKSRQ, FYJZRQ, SFZDBY, BQBMBH, CH0000, XB0000, BQMC00, KSMC00, \\nNL0000, ZDMC00, FYRQSJ, BYTJMC, SHRXM0, CFYZID, MXTYJE, ZHL000, YPNM00, \\nYPZLXX, YZNR01, FYRXM0, YPDLBH, YFLBID, ZYDJS0, MJBZ00, CHZYH0, PC0000, \\nYPZL01, YFMC00, SQYSXM, YYZF00, CLZ000, SFBD00, QWM000, SCCJZW, YYMC00, \\nFZZD00, DYRQ00, DYSJ00, FYRXM1, CSL100, PYSM00, GZDJ00, to_char(ZQCS00) ZQCS00,to_char(YYTS00) YYTS00, \\nPDXH00, CSL200,FBMC00 ,(select sum(hjje00) from yf_yzypsq where ckdh00=a.ckdh00 and zyid00=a.zyid00) sumJe0,a.smdh00\\nfrom\\n<#if vMZZY == '0'>\\n  <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \\n     YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n      VW_YF_ZYBYDYMX a where  CKDH00='${CKDH00}' and BRID00=${BRID00} and CFYZID = ${CFYZID}  and \\n     YPQLPC in (${vDh}) order by YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \\n     YYRQ00,YZID00,YZMXID\\n  </#if>\\n<#elseif vMZZY == '1'>\\n   <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n     VW_YF_ZYBYDYMX a  where  YPQLPC in (${vDh}) order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  </#if>\\n<#elseif vMZZY == '2'>\\n  <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n      VW_YF_ZYBYDYMX a where  YPQLPC in (${vDh}) order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  </#if>\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"_VCUID\":\"row_493\"}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"main","remark":"","sql":"<#if vMZZY== '0'>  \n  <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n    select distinct a.* from VW_YF_ZYBYDYDJ  A where (ZYID00,CFYZID,CKDH00) in      \n    (select ZYID00,CFYZID,CKDH00 from YF_YZYPSQ where YPQLPC in (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>\n<#elseif vMZZY== '1'> \n   <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \n     (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>\n<#elseif vMZZY== '2'> \n  <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \n     (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>  \n</#if>"},{"isCommit":false,"isProcedures":false,"name":"child","remark":"","sql":"select YPQLPC, YPMC00, YPGG00, CSL000, PCMC00, YPZSL0, nvl(JYZSL0,0) JYZSL0, nvl(SFZSL0,0) SFZSL0, nvl(JCZSL0,0) JCZSL0, \nnvl(GHZSL0,0) GHZSL0, QLDW00, YPYF00, LSDJ00, YPJE00, TS0000, YYRQ00, YSXM00, CKDH00, \nBRID00, ZYID00, ZYH000, XM0000, JLDW00, YZID00, YZMXID, XMYFMC, ZCXSL0, \nCXCSL0, FYKSRQ, FYJZRQ, SFZDBY, BQBMBH, CH0000, XB0000, BQMC00, KSMC00, \nNL0000, ZDMC00, FYRQSJ, BYTJMC, SHRXM0, CFYZID, MXTYJE, ZHL000, YPNM00, \nYPZLXX, YZNR01, FYRXM0, YPDLBH, YFLBID, ZYDJS0, MJBZ00, CHZYH0, PC0000, \nYPZL01, YFMC00, SQYSXM, YYZF00, CLZ000, SFBD00, QWM000, SCCJZW, YYMC00, \nFZZD00, DYRQ00, DYSJ00, FYRXM1, CSL100, PYSM00, GZDJ00, to_char(ZQCS00) ZQCS00,to_char(YYTS00) YYTS00, \nPDXH00, CSL200,FBMC00 ,(select sum(hjje00) from yf_yzypsq where ckdh00=a.ckdh00 and zyid00=a.zyid00) sumJe0,a.smdh00\nfrom\n<#if vMZZY == '0'>\n  <#if vType == '0'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \n     YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n      VW_YF_ZYBYDYMX a where  CKDH00='${CKDH00}' and BRID00=${BRID00} and CFYZID = ${CFYZID}  and \n     YPQLPC in (${vDh}) order by YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \n     YYRQ00,YZID00,YZMXID\n  </#if>\n<#elseif vMZZY == '1'>\n   <#if vType == '0'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n     VW_YF_ZYBYDYMX a  where  YPQLPC in (${vDh}) order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  </#if>\n<#elseif vMZZY == '2'>\n  <#if vType == '0'>\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n      VW_YF_ZYBYDYMX a where  YPQLPC in (${vDh}) order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  </#if>\n</#if>"}],"updateTime":1714985365000,"versions":1}],"printPz":[{"catalog":"ZhuYuanBaiYao","code":"printYF_ZYBYMX_CYDY","entityVersion":0,"id":"printYF_ZYBYMX_CYDY","module":"yf","name":"printYF_ZYBYMX_CYDY","nowVersions":1,"remark":"药房_住院摆药明细单(出院带药)","system":"his"}],"printAll":[{"branch":"0","branchmc":"standard","catalog":"ZhuYuanBaiYao","code":"printYF_ZYBYMX_CYDY","createTime":1620115728000,"entityVersion":0,"fr3Name":"药房_住院摆药明细单(出院带药).frx","id":"printYF_ZYBYMX_CYDY","inParam":"[{\"name\":\"vDh\",\"isRequired\":true,\"deFault\":\"238382\",\"remark\":\"vType为1是药品请领批次，其他是出库单号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"238382\",\"required\":true,\"_VCUID\":\"row_483\"},{\"name\":\"vType\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"0整单1部分2多单\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"0\",\"required\":true,\"_VCUID\":\"row_484\"},{\"name\":\"vMZZY\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"0门诊药房1住院药房2出院带药\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"2\",\"required\":true,\"_VCUID\":\"row_485\"},{\"name\":\"xtcsValue\",\"isRequired\":true,\"deFault\":\"0\",\"remark\":\"YF_BYDCZSFXSTYD值\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"0\",\"required\":true,\"_VCUID\":\"row_486\"},{\"name\":\"CFYZID\",\"isRequired\":false,\"deFault\":\"3718530\",\"remark\":\"vMZZY为0必填，处方医嘱ID\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"3718530\",\"required\":false,\"_VCUID\":\"row_487\"},{\"name\":\"BRID00\",\"isRequired\":false,\"deFault\":\"2709191\",\"remark\":\"vMZZY为0必填,病人ID\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"2709191\",\"required\":false,\"_VCUID\":\"row_488\"},{\"name\":\"CKDH00\",\"isRequired\":false,\"deFault\":\"238382\",\"remark\":\"vMZZY为0且vType 为1必填,出库单号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"238382\",\"required\":false,\"_VCUID\":\"row_489\"},{\"name\":\"vMXDYPX\",\"isRequired\":false,\"deFault\":\"BQBMBH\",\"remark\":\"vMZZY为1或2必填\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"BQBMBH\",\"required\":false,\"_VCUID\":\"row_490\"},{\"name\":\"printMode\",\"isRequired\":true,\"deFault\":\"V\",\"remark\":\"P打印模式V预览模式D设计模式\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"V\",\"required\":true,\"_VCUID\":\"row_491\"}]","inParams":[{"deFault":"238382","fieldType":"String","isRequired":true,"name":"vDh","proceduresParam":"","remark":"vType为1是药品请领批次，其他是出库单号","required":true,"testParam":"238382"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"vType","proceduresParam":"","remark":"0整单1部分2多单","required":true,"testParam":"0"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"vMZZY","proceduresParam":"","remark":"0门诊药房1住院药房2出院带药","required":true,"testParam":"2"},{"deFault":"0","fieldType":"String","isRequired":true,"name":"xtcsValue","proceduresParam":"","remark":"YF_BYDCZSFXSTYD值","required":true,"testParam":"0"},{"deFault":"3718530","fieldType":"String","isRequired":false,"name":"CFYZID","proceduresParam":"","remark":"vMZZY为0必填，处方医嘱ID","required":false,"testParam":"3718530"},{"deFault":"2709191","fieldType":"String","isRequired":false,"name":"BRID00","proceduresParam":"","remark":"vMZZY为0必填,病人ID","required":false,"testParam":"2709191"},{"deFault":"238382","fieldType":"String","isRequired":false,"name":"CKDH00","proceduresParam":"","remark":"vMZZY为0且vType 为1必填,出库单号","required":false,"testParam":"238382"},{"deFault":"BQBMBH","fieldType":"String","isRequired":false,"name":"vMXDYPX","proceduresParam":"","remark":"vMZZY为1或2必填","required":false,"testParam":"BQBMBH"},{"deFault":"V","fieldType":"String","isRequired":true,"name":"printMode","proceduresParam":"","remark":"P打印模式V预览模式D设计模式","required":true,"testParam":"V"}],"module":"yf","name":"printYF_ZYBYMX_CYDY","nowVersions":1,"outParam":"[{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"main\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"_VCUID\":\"row_494\"},{\"dataSources\":\"sql\",\"name\":\"\",\"outfieldType\":\"String\",\"value\":\"child\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"_VCUID\":\"row_495\"},{\"dataSources\":\"inParam\",\"name\":\"PRINTMODE\",\"outfieldType\":\"String\",\"value\":\"printMode\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"_VCUID\":\"row_496\"}]","outParams":[{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableMain","remark":"","value":"main"},{"dataSources":"sql","deFault":"","name":"","outfieldType":"String","paramType":"tableChild","remark":"","value":"child"},{"dataSources":"inParam","deFault":"","name":"PRINTMODE","outfieldType":"String","paramType":"parameter","remark":"","value":"printMode"}],"printType":"FRX","remark":"药房_住院摆药明细单(出院带药)","sql":"[{\"name\":\"main\",\"sql\":\"<#if vMZZY== '0'>  \\n  <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n    select distinct a.* from VW_YF_ZYBYDYDJ  A where (ZYID00,CFYZID,CKDH00) in      \\n    (select ZYID00,CFYZID,CKDH00 from YF_YZYPSQ where YPQLPC in (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>\\n<#elseif vMZZY== '1'> \\n   <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \\n     (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>\\n<#elseif vMZZY== '2'> \\n  <#if vType == '0' || vType == '2'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  <#elseif vType == '1'>\\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \\n     (${vDh}))\\n     <#if xtcsValue != '1'>\\n        and CXBZ00<>'+'\\n     </#if>\\n  </#if>  \\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"_VCUID\":\"row_492\"},{\"name\":\"child\",\"sql\":\"select YPQLPC, YPMC00, YPGG00, CSL000, PCMC00, YPZSL0, nvl(JYZSL0,0) JYZSL0, nvl(SFZSL0,0) SFZSL0, nvl(JCZSL0,0) JCZSL0, \\nnvl(GHZSL0,0) GHZSL0, QLDW00, YPYF00, LSDJ00, YPJE00, TS0000, YYRQ00, YSXM00, CKDH00, \\nBRID00, ZYID00, ZYH000, XM0000, JLDW00, YZID00, YZMXID, XMYFMC, ZCXSL0, \\nCXCSL0, FYKSRQ, FYJZRQ, SFZDBY, BQBMBH, CH0000, XB0000, BQMC00, KSMC00, \\nNL0000, ZDMC00, FYRQSJ, BYTJMC, SHRXM0, CFYZID, MXTYJE, ZHL000, YPNM00, \\nYPZLXX, YZNR01, FYRXM0, YPDLBH, YFLBID, ZYDJS0, MJBZ00, CHZYH0, PC0000, \\nYPZL01, YFMC00, SQYSXM, YYZF00, CLZ000, SFBD00, QWM000, SCCJZW, YYMC00, \\nFZZD00, DYRQ00, DYSJ00, FYRXM1, CSL100, PYSM00, GZDJ00, to_char(ZQCS00) ZQCS00,to_char(YYTS00) YYTS00, \\nPDXH00, CSL200,FBMC00 ,(select sum(hjje00) from yf_yzypsq where ckdh00=a.ckdh00 and zyid00=a.zyid00) sumJe0,a.smdh00\\nfrom\\n<#if vMZZY == '0'>\\n  <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \\n     YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n      VW_YF_ZYBYDYMX a where  CKDH00='${CKDH00}' and BRID00=${BRID00} and CFYZID = ${CFYZID}  and \\n     YPQLPC in (${vDh}) order by YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \\n     YYRQ00,YZID00,YZMXID\\n  </#if>\\n<#elseif vMZZY == '1'>\\n   <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n     VW_YF_ZYBYDYMX a  where  YPQLPC in (${vDh}) order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  </#if>\\n<#elseif vMZZY == '2'>\\n  <#if vType == '0'>\\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType == '1'>\\n      VW_YF_ZYBYDYMX a where  YPQLPC in (${vDh}) order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  <#elseif vType =='2'>\\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \\n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\\n  </#if>\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"_VCUID\":\"row_493\"}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"main","remark":"","sql":"<#if vMZZY== '0'>  \n  <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n    select distinct a.* from VW_YF_ZYBYDYDJ  A where (ZYID00,CFYZID,CKDH00) in      \n    (select ZYID00,CFYZID,CKDH00 from YF_YZYPSQ where YPQLPC in (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>\n<#elseif vMZZY== '1'> \n   <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \n     (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>\n<#elseif vMZZY== '2'> \n  <#if vType == '0' || vType == '2'>\n     select distinct a.* from VW_YF_ZYBYDYDJ A where CKDH00='${vDh}'\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  <#elseif vType == '1'>\n     select distinct a.* from VW_YF_ZYBYDYDJ a where CKDH00 in (select CKDH00 from  YF_YZYPSQ where YPQLPC in \n     (${vDh}))\n     <#if xtcsValue != '1'>\n        and CXBZ00<>'+'\n     </#if>\n  </#if>  \n</#if>"},{"isCommit":false,"isProcedures":false,"name":"child","remark":"","sql":"select YPQLPC, YPMC00, YPGG00, CSL000, PCMC00, YPZSL0, nvl(JYZSL0,0) JYZSL0, nvl(SFZSL0,0) SFZSL0, nvl(JCZSL0,0) JCZSL0, \nnvl(GHZSL0,0) GHZSL0, QLDW00, YPYF00, LSDJ00, YPJE00, TS0000, YYRQ00, YSXM00, CKDH00, \nBRID00, ZYID00, ZYH000, XM0000, JLDW00, YZID00, YZMXID, XMYFMC, ZCXSL0, \nCXCSL0, FYKSRQ, FYJZRQ, SFZDBY, BQBMBH, CH0000, XB0000, BQMC00, KSMC00, \nNL0000, ZDMC00, FYRQSJ, BYTJMC, SHRXM0, CFYZID, MXTYJE, ZHL000, YPNM00, \nYPZLXX, YZNR01, FYRXM0, YPDLBH, YFLBID, ZYDJS0, MJBZ00, CHZYH0, PC0000, \nYPZL01, YFMC00, SQYSXM, YYZF00, CLZ000, SFBD00, QWM000, SCCJZW, YYMC00, \nFZZD00, DYRQ00, DYSJ00, FYRXM1, CSL100, PYSM00, GZDJ00, to_char(ZQCS00) ZQCS00,to_char(YYTS00) YYTS00, \nPDXH00, CSL200,FBMC00 ,(select sum(hjje00) from yf_yzypsq where ckdh00=a.ckdh00 and zyid00=a.zyid00) sumJe0,a.smdh00\nfrom\n<#if vMZZY == '0'>\n  <#if vType == '0'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \n     YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n      VW_YF_ZYBYDYMX a where  CKDH00='${CKDH00}' and BRID00=${BRID00} and CFYZID = ${CFYZID}  and \n     YPQLPC in (${vDh}) order by YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' and BRID00=${BRID00} and CFYZID = ${CFYZID} order by \n     YYRQ00,YZID00,YZMXID\n  </#if>\n<#elseif vMZZY == '1'>\n   <#if vType == '0'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n     VW_YF_ZYBYDYMX a  where  YPQLPC in (${vDh}) order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  </#if>\n<#elseif vMZZY == '2'>\n  <#if vType == '0'>\n     VW_YF_ZYBYDYMX a  where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType == '1'>\n      VW_YF_ZYBYDYMX a where  YPQLPC in (${vDh}) order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  <#elseif vType =='2'>\n     VW_YF_ZYBYDYMX a where  CKDH00='${vDh}' order by \n     ${vMXDYPX},lpad(CH0000,10,'0'),YYRQ00,YZID00,YZMXID\n  </#if>\n</#if>"}],"system":"his","updateTime":1714985365000,"versions":1}]}