[{"branch":"0","branchmc":"standard","button":"[]","catalog":"RiChangYeWu","chart":"[]","code":"getYjdwhChildSfxmList","column":"[{\"filter_name\":\"XMMC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"名称\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"XMMC00\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"200\",\"fixed\":\"\",\"render\":\"\",\"key\":\"XMMC00\"},{\"filter_name\":\"BH0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"项目编码\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"BH0000\",\"field\":\"BH0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"BH0000\"},{\"sys_hidden\":\"\",\"filter_name\":\"GG0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"规格\",\"align\":\"center\",\"ora_name\":\"GG0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GG0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"GG0000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SCCJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"厂家\",\"align\":\"center\",\"ora_name\":\"SCCJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SCCJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"SCCJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"SFJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"收费金额\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"SFJE00\",\"field\":\"SFJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFJE00\"},{\"filter_name\":\"GJBM00\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"国家编码\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":5,\"ora_name\":\"GJBM00\",\"field\":\"GJBM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GJBM00\"},{\"sys_hidden\":\"\",\"filter_name\":\"BKEH83\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":6,\"className\":\"\",\"title\":\"国家医保编码\",\"align\":\"\",\"ora_name\":\"BKEH83\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"BKEH83\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":6,\"round\":\"\",\"trunc\":\"\",\"field\":\"BKEH83\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GJBZMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"国家医保名称\",\"align\":\"\",\"ora_name\":\"GJBZMC\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"GJBZMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJBZMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"filter_name\":\"PYSM00\",\"hidden\":true,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"拼音\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"PYSM00\",\"field\":\"PYSM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"PYSM00\"},{\"filter_name\":\"WBSM00\",\"hidden\":true,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"五笔\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"WBSM00\",\"field\":\"WBSM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"WBSM00\"},{\"filter_name\":\"SFXMID\",\"hidden\":true,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"SFXMID\",\"field\":\"SFXMID\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFXMID\"},{\"filter_name\":\"JSXM00\",\"hidden\":true,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"JSXM00\",\"field\":\"JSXM00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JSXM00\"}]","condition":"[]","countSql":"Select COUNT(1) as TOTAL\nfrom (select XMMC00,BH0000,PYSM00,WBSM00,SFXMID,SFJE00,GJBM00,JSXM00 ,SCCJ00,GG0000 \nfrom VW_YJ_YYSFXM_DJBZ\nwhere 1=1 and (SFBZDJ = ${SFBZDJ}\n<#if YJ_JSXMSFXZ=='Y'>\n     <#if strAllGJBM=='1'>\n        and ((JSXM00='0' and SFXMID in (select SFXMID from XT_ZLSFGX where \n        ZLXMID in (select ZLXMID from YJ_YW0000 where YJDJH0=${YJDJH0}))) \n        or (JSXM00='1' and ('${GJBM00}' like GJBM00||'%'))\n        or (JSXM00='2' and Instr('${strAllLSCL}',substrb(BH0000,1,6))>0))\n    </#if> \n<#elseif YJ_JSXMSFXZ=='M'>\n    and JSXM00 <> '0'\n</#if>\n)\n<#switch inputType>\n<#case '1'>\n\t<#switch likeType>\n                <#case '1'> and (BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '2'>\n\t<#switch likeType>\n\t\t<#case '1'> and (XMMC00 like '${content}%' or BH0000 like '${content}%')<#break>\n\t\t<#case '2'> and (XMMC00 like '%${content}' or BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (XMMC00 like '%${content}%' or BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '3'>\n\t<#switch likeType>\n\t\t<#case '1'> and (PYSM00 like '${content}%' or BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (PYSM00 like '%${content}' or BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (PYSM00 like '%${content}%' or BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '4'>\n\t<#switch likeType>\n\t\t<#case '1'> and (WBSM00 like '${content}%' or BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (WBSM00 like '%${content}' or BH0000 like '%${content}') <#break>\n\t\t<#case '3'> and (WBSM00 like '%${content}%' or BH0000 like '%${content}%') <#break>\n\t\t<#default>\n\t</#switch>\n<#break> \n<#default>\nand (PYSM00 Like '%${content}%' or BH0000 Like '%${content}%') \n</#switch>\n<#if likeType = '1'>\n       <#if inputType = '1'>\n              order by BH0000\n       <#elseif inputType = '2'>\n              order by BH0000,XMMC00\n       <#elseif inputType = '3'>\n              order by BH0000,PYSM00\n       <#elseif inputType = '4'>\n              order by BH0000,WBSM00\n       </#if>\n</#if>\n) where Rownum<=23","createTime":1622690075000,"entityVersion":0,"id":"getYjdwhChildSfxmList","isLaypage":"1","module":"yj","name":"getYjdwhChildSfxmList","pageSql":"Select * from (select XMMC00,BH0000,PYSM00,WBSM00,SFXMID,SFJE00,GJBM00,JSXM00,nvl(BKEH83,GJBM00)BKEH83,GJBZMC,SCCJ00,GG0000 \nfrom VW_YJ_YYSFXM_DJBZ\nwhere 1=1 and (SFBZDJ = ${SFBZDJ}\n<#if YJ_JSXMSFXZ=='Y'>\n     <#if strAllGJBM=='1'>\n        and ((JSXM00='0' and SFXMID in (select SFXMID from XT_ZLSFGX where \n        ZLXMID in (select ZLXMID from YJ_YW0000 where YJDJH0=${YJDJH0}))) \n        or (JSXM00='1' and ('${GJBM00}' like GJBM00||'%'))\n        or (JSXM00='2' and Instr('${strAllLSCL}',substrb(BH0000,1,6))>0))\n    </#if> \n<#elseif YJ_JSXMSFXZ=='M'>\n    and JSXM00 <> '0'\n</#if>\n)\n<#switch inputType>\n<#case '1'>\n\t<#switch likeType>\n                <#case '1'> and (BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '2'>\n\t<#switch likeType>\n\t\t<#case '1'> and (XMMC00 like '${content}%' or BH0000 like '${content}%')<#break>\n\t\t<#case '2'> and (XMMC00 like '%${content}' or BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (XMMC00 like '%${content}%' or BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '3'>\n\t<#switch likeType>\n\t\t<#case '1'> and (PYSM00 like '${content}%' or BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (PYSM00 like '%${content}' or BH0000 like '%${content}')<#break>\n\t\t<#case '3'> and (PYSM00 like '%${content}%' or BH0000 like '%${content}%')<#break>\n\t\t<#default>\n\t</#switch>\n<#break>\n<#case '4'>\n\t<#switch likeType>\n\t\t<#case '1'> and (WBSM00 like '${content}%' or BH0000 like '${content}%') <#break>\n\t\t<#case '2'> and (WBSM00 like '%${content}' or BH0000 like '%${content}') <#break>\n\t\t<#case '3'> and (WBSM00 like '%${content}%' or BH0000 like '%${content}%') <#break>\n\t\t<#default>\n\t</#switch>\n<#break> \n<#default>\nand (PYSM00 Like '%${content}%' or BH0000 Like '%${content}%') \n</#switch>\n<#if likeType = '1'>\n       <#if inputType = '1'>\n              order by BH0000\n       <#elseif inputType = '2'>\n              order by BH0000,XMMC00\n       <#elseif inputType = '3'>\n              order by BH0000,PYSM00\n       <#elseif inputType = '4'>\n              order by BH0000,WBSM00\n       </#if>\n</#if>\n) where Rownum<=23","procedureCommit":0,"procedureParameter":"[]","remark":"新增子单时，收费项目的输入法","system":"his","updateTime":1711439620000,"version":0}]