[{"branch":"0","branchmc":"standard","button":"[]","catalog":"YiBaoXiangMuWeiHu","chart":"[]","code":"queryYBSFXMWHXMDWZD","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"className\":\"\",\"title\":\"医保项目编号\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"XMBH00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"XMBH00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"className\":\"\",\"title\":\"医保项目名称\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"XMMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"单位\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"XMDW00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"XMDW00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"规格\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"YPGG00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPGG00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"医保中心类别\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"YBZXLB\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"YBZXLB\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"费别编号\",\"align\":\"\",\"ora_name\":\"\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"FBBH00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"FBBH00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"}]","condition":"[]","countSql":"select count(1) TOTAL from \nVW_BM_YBSFXM_NEW\nwhere \n(  FBBH00 = '${FBBH00}' and YBZXLB = '${YBZXLB}'  )\n<#switch inputType>\n<#case '1'>\n  <#switch likeType>\n      <#case '1'>and  (XMBH01 like lower('${content}%')) <#break>\n    <#case '2'>and  (XMBH01 like lower('%${content}')) <#break>\n    <#case '3'>and  (XMBH01 like lower('%${content}%')) <#break>\n    <#default>\n  </#switch>\norder by XMBH01\n<#break>\n<#case '2'>\n  <#switch likeType>\n    <#case '1'>and   (XMMC00 like lower('${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '2'>and   (XMMC00 like lower('%${content}') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '3'>and   (XMMC00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by XMMC00\n<#break>\n<#case '3'>\n  <#switch likeType>\n    <#case '1'>and   (PYSM00 like lower('${content}%')  or XMBH01 Like lower('${content}%'))  <#break>\n    <#case '2'>and   (PYSM00 like lower('%${content}') or XMBH01 Like lower('${content}%') )<#break>\n    <#case '3'>and   (PYSM00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by pysm00\n<#break>\n<#case '4'>\n  <#switch likeType>\n    <#case '1'>and   (WBSM00 like lower('${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '2'>and   (WBSM00 like lower('%${content}') or XMBH01 Like lower('${content}%'))<#break>\n    <#case '3'>and   (WBSM00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by wbsm00\n<#break> \n<#case '5'>\n <#switch likeType>\n    <#case '1'>and   (PYSM00 like lower('${content}%') or WBSM00 like lower('${content}%') or XMBH01 Like lower('${content}%') or XMMC00 like lower('${content}%'))<#break>\n    <#case '2'>and   (PYSM00 like lower('%${content}') or WBSM00 like lower('%${content}') or XMBH01 Like lower('%${content}') or XMMC00 like lower('%${content}')) <#break>\n    <#case '3'>and   (PYSM00 like lower('%${content}%') or WBSM00 like lower('%${content}%')  or XMMC00 like lower('%${content}%') or XMBH01 Like lower('${content}%'))<#break>\n    <#default>\n  </#switch>\norder by PYSM00 \n<#break> \n<#default> \n</#switch>","createTime":1629338300000,"entityVersion":0,"id":"queryYBSFXMWHXMDWZD","isLaypage":"1","module":"xmgl","name":"queryYBSFXMWHXMDWZD","pageSql":"select XMBH00,XMMC00,XMDW00,YPGG00,YBZXLB,FBBH00 from \nVW_BM_YBSFXM_NEW\nwhere \n(  FBBH00 = '${FBBH00}' and YBZXLB = '${YBZXLB}'  )\n<#switch inputType>\n<#case '1'>\n  <#switch likeType>\n    <#case '1'>and  (XMBH01 like lower('${content}%')) <#break>\n    <#case '2'>and  (XMBH01 like lower('%${content}')) <#break>\n    <#case '3'>and  (XMBH01 like lower('%${content}%')) <#break>\n    <#default>\n  </#switch>\norder by XMBH01\n<#break>\n<#case '2'>\n  <#switch likeType>\n    <#case '1'>and   (XMMC00 like lower('${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '2'>and   (XMMC00 like lower('%${content}') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '3'>and   (XMMC00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by XMMC00\n<#break>\n<#case '3'>\n  <#switch likeType>\n    <#case '1'>and   (PYSM00 like lower('${content}%')  or XMBH01 Like lower('${content}%'))  <#break>\n    <#case '2'>and   (PYSM00 like lower('%${content}') or XMBH01 Like lower('${content}%') )<#break>\n    <#case '3'>and   (PYSM00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by XMBH01,pysm00\n<#break>\n<#case '4'>\n  <#switch likeType>\n    <#case '1'>and   (WBSM00 like lower('${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#case '2'>and   (WBSM00 like lower('%${content}') or XMBH01 Like lower('${content}%'))<#break>\n    <#case '3'>and   (WBSM00 like lower('%${content}%') or XMBH01 Like lower('${content}%')) <#break>\n    <#default>\n  </#switch>\norder by wbsm00\n<#break> \n<#case '5'>\n  <#switch likeType>\n    <#case '1'>and   (PYSM00 like lower('${content}%') or WBSM00 like lower('${content}%') or XMBH01 Like lower('${content}%') or XMMC00 like lower('${content}%'))<#break>\n    <#case '2'>and   (PYSM00 like lower('%${content}') or WBSM00 like lower('%${content}') or XMBH01 Like lower('%${content}') or XMMC00 like lower('%${content}'))<#break>\n    <#case '3'>and   (PYSM00 like lower('%${content}%') or WBSM00 like lower('%${content}%')  or XMMC00 like lower('%${content}%') or XMBH01 Like lower('${content}%'))<#break>\n    <#default>\n  </#switch>\norder by XMBH01,PYSM00 \n<#break> \n<#default> \n</#switch>","procedureCommit":0,"procedureParameter":"[]","remark":"项目管理-医保项目维护-医保收费项目维护项目查找定位字典","system":"his","updateTime":1769159053000,"version":0}]