[{"branch":"0","branchmc":"standard","button":"[]","catalog":"inOutHosp","chart":"[]","code":"getPatientSingleDiseaseList","column":"[{\"LAY_TABLE_INDEX\":0,\"minWidth\":\"120\",\"className\":\"\",\"sortable\":true,\"title\":\"病种状态\",\"align\":\"\",\"ora_name\":\"BZZTMC\",\"sequence\":0,\"field\":\"diseStatus\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_133\",\"render\":\"\",\"key\":\"diseStatus\"},{\"LAY_TABLE_INDEX\":1,\"minWidth\":\"100\",\"className\":\"\",\"sortable\":true,\"title\":\"当前病区\",\"align\":\"\",\"ora_name\":\"RYBQMC\",\"sequence\":1,\"field\":\"inPatientWardName\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_134\",\"render\":\"\",\"key\":\"inPatientWardName\"},{\"LAY_TABLE_INDEX\":2,\"minWidth\":\"120\",\"className\":\"\",\"sortable\":true,\"title\":\"当前科室\",\"align\":\"\",\"ora_name\":\"RZKSMC\",\"sequence\":2,\"field\":\"inPatientDepart\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_135\",\"render\":\"\",\"key\":\"inPatientDepart\"},{\"LAY_TABLE_INDEX\":3,\"minWidth\":\"75\",\"className\":\"\",\"sortable\":true,\"title\":\"床号\",\"align\":\"\",\"ora_name\":\"RYCWH0\",\"sequence\":3,\"field\":\"inHospBedNo\",\"sortType\":\"asc\",\"width\":\"75\",\"fixed\":\"\",\"_VCUID\":\"row_136\",\"render\":\"\",\"key\":\"inHospBedNo\"},{\"LAY_TABLE_INDEX\":4,\"minWidth\":\"120\",\"className\":\"\",\"sortable\":true,\"title\":\"住院号\",\"align\":\"\",\"ora_name\":\"ZYH000\",\"sequence\":4,\"field\":\"inHospNo\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_137\",\"render\":\"\",\"key\":\"inHospNo\"},{\"LAY_TABLE_INDEX\":5,\"minWidth\":\"55\",\"className\":\"\",\"sortable\":true,\"title\":\"次\",\"align\":\"right\",\"ora_name\":\"BRRYCS\",\"sequence\":5,\"field\":\"inHospNum\",\"sortType\":\"asc\",\"width\":\"55\",\"fixed\":\"\",\"_VCUID\":\"row_138\",\"render\":\"\",\"key\":\"inHospNum\"},{\"LAY_TABLE_INDEX\":6,\"minWidth\":\"75\",\"className\":\"\",\"sortable\":true,\"title\":\"姓名\",\"align\":\"\",\"ora_name\":\"XM0000\",\"sequence\":6,\"field\":\"pName\",\"sortType\":\"asc\",\"width\":\"75\",\"fixed\":\"\",\"_VCUID\":\"row_139\",\"render\":\"\",\"key\":\"pName\"},{\"LAY_TABLE_INDEX\":7,\"minWidth\":\"65\",\"className\":\"\",\"sortable\":true,\"title\":\"性别\",\"align\":\"\",\"ora_name\":\"XB0000\",\"sequence\":7,\"field\":\"pSex\",\"sortType\":\"asc\",\"width\":\"65\",\"fixed\":\"\",\"_VCUID\":\"row_140\",\"render\":\"\",\"key\":\"pSex\"},{\"LAY_TABLE_INDEX\":8,\"minWidth\":\"160\",\"className\":\"\",\"sortable\":true,\"title\":\"费别信息\",\"align\":\"\",\"ora_name\":\"FBXX00\",\"sequence\":8,\"field\":\"payType\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"_VCUID\":\"row_141\",\"render\":\"\",\"key\":\"payType\"},{\"LAY_TABLE_INDEX\":9,\"minWidth\":\"100\",\"className\":\"\",\"sortable\":true,\"title\":\"入院日期\",\"align\":\"\",\"ora_name\":\"RYRQ00\",\"sequence\":9,\"field\":\"admissDate\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_142\",\"render\":\"\",\"key\":\"admissDate\"},{\"LAY_TABLE_INDEX\":10,\"minWidth\":\"120\",\"className\":\"\",\"sortable\":true,\"title\":\"单病种编码\",\"align\":\"\",\"ora_name\":\"DBZBM0\",\"sequence\":10,\"field\":\"singleDiseaCode\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_143\",\"render\":\"\",\"key\":\"singleDiseaCode\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"160\",\"className\":\"\",\"sortable\":true,\"title\":\"单病种名称\",\"align\":\"\",\"ora_name\":\"BZMC00\",\"sequence\":11,\"field\":\"singleDiseaName\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"_VCUID\":\"row_144\",\"render\":\"\",\"key\":\"singleDiseaName\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":12,\"className\":\"\",\"title\":\"国家病种编码\",\"align\":\"\",\"ora_name\":\"BAE465\",\"headerAlign\":\"\",\"_VCUID\":\"row_145\",\"render\":\"\",\"key\":\"BAE465\",\"summary\":\"\",\"minWidth\":\"120\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":12,\"round\":\"\",\"trunc\":\"\",\"field\":\"BAE465\",\"sortType\":\"asc\",\"width\":\"120\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":13,\"className\":\"\",\"title\":\"国家病种名称\",\"align\":\"\",\"ora_name\":\"BAEMC0\",\"headerAlign\":\"\",\"_VCUID\":\"row_146\",\"render\":\"\",\"key\":\"BAEMC0\",\"summary\":\"\",\"minWidth\":\"160\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":13,\"round\":\"\",\"trunc\":\"\",\"field\":\"BAEMC0\",\"sortType\":\"asc\",\"width\":\"160\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"LAY_TABLE_INDEX\":14,\"minWidth\":\"100\",\"className\":\"\",\"sortable\":true,\"title\":\"进入日期\",\"align\":\"\",\"ora_name\":\"JRRQ00\",\"sequence\":14,\"field\":\"enterDate\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_147\",\"render\":\"\",\"key\":\"enterDate\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":15,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"进入时间\",\"align\":\"\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"JRSJ00\",\"round\":\"\",\"trunc\":\"\",\"field\":\"JRSJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"_VCUID\":\"row_148\",\"render\":\"\",\"key\":\"JRSJ00\"},{\"LAY_TABLE_INDEX\":16,\"minWidth\":\"200\",\"className\":\"\",\"sortable\":true,\"title\":\"主操作名称\",\"align\":\"\",\"ora_name\":\"ZCZMC0\",\"sequence\":16,\"field\":\"mainOperaName\",\"sortType\":\"asc\",\"width\":\"200\",\"fixed\":\"\",\"_VCUID\":\"row_149\",\"render\":\"\",\"key\":\"mainOperaName\"},{\"LAY_TABLE_INDEX\":17,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"单病种定额\",\"align\":\"right\",\"ora_name\":\"BZSFJE\",\"sequence\":17,\"field\":\"singleDiseQuota\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_150\",\"render\":\"\",\"key\":\"singleDiseQuota\"},{\"LAY_TABLE_INDEX\":18,\"minWidth\":\"145\",\"className\":\"\",\"sortable\":true,\"title\":\"医保预结算总额\",\"align\":\"right\",\"ora_name\":\"YBYJS0\",\"sequence\":18,\"field\":\"totalMediInsur\",\"sortType\":\"asc\",\"width\":\"145\",\"fixed\":\"\",\"_VCUID\":\"row_151\",\"render\":\"\",\"key\":\"totalMediInsur\"},{\"LAY_TABLE_INDEX\":19,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"医保预支付\",\"align\":\"right\",\"ora_name\":\"YBYZF0\",\"sequence\":19,\"field\":\"mediInsurPay\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_152\",\"render\":\"\",\"key\":\"mediInsurPay\"},{\"LAY_TABLE_INDEX\":20,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"预结自付金额\",\"align\":\"right\",\"ora_name\":\"YJZFJE\",\"sequence\":20,\"field\":\"prepaidOne\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_153\",\"render\":\"\",\"key\":\"prepaidOne\"},{\"LAY_TABLE_INDEX\":21,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"病种内费用\",\"align\":\"right\",\"ora_name\":\"BZNZFY\",\"sequence\":21,\"field\":\"bznExpenses\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_154\",\"render\":\"\",\"key\":\"bznExpenses\"},{\"LAY_TABLE_INDEX\":22,\"minWidth\":\"145\",\"className\":\"\",\"sortable\":true,\"title\":\"病种内可用余额\",\"align\":\"right\",\"ora_name\":\"BZNKYE\",\"sequence\":22,\"field\":\"bznAvaiBalance\",\"sortType\":\"asc\",\"width\":\"145\",\"fixed\":\"\",\"_VCUID\":\"row_155\",\"render\":\"\",\"key\":\"bznAvaiBalance\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":23,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"病种外费用\",\"align\":\"right\",\"ora_name\":\"BZWZFY\",\"sequence\":23,\"field\":\"bzwExpenses\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_156\",\"render\":\"\",\"key\":\"bzwExpenses\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":24,\"minWidth\":\"145\",\"className\":\"\",\"sortable\":true,\"title\":\"病种外可用余额\",\"align\":\"right\",\"ora_name\":\"BZWKYE\",\"sequence\":24,\"field\":\"bzwAvaiBalance\",\"sortType\":\"asc\",\"width\":\"145\",\"fixed\":\"\",\"_VCUID\":\"row_157\",\"render\":\"\",\"key\":\"bzwAvaiBalance\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":25,\"minWidth\":\"200\",\"className\":\"\",\"sortable\":true,\"title\":\"备注说明\",\"align\":\"\",\"ora_name\":\"BZ0000\",\"sequence\":25,\"field\":\"descr\",\"sortType\":\"asc\",\"width\":\"200\",\"fixed\":\"\",\"_VCUID\":\"row_158\",\"render\":\"\",\"key\":\"descr\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":26,\"minWidth\":\"125\",\"className\":\"\",\"sortable\":true,\"title\":\"预交总金额\",\"align\":\"right\",\"ora_name\":\"WJYJZE\",\"sequence\":26,\"field\":\"advanceTotal\",\"sortType\":\"asc\",\"width\":\"125\",\"fixed\":\"\",\"_VCUID\":\"row_159\",\"render\":\"\",\"key\":\"advanceTotal\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":27,\"minWidth\":\"120\",\"className\":\"\",\"sortable\":true,\"title\":\"费用占比%\",\"align\":\"\",\"ora_name\":\"BZNBL0\",\"sequence\":27,\"field\":\"expensZb\",\"sortType\":\"asc\",\"width\":\"120\",\"fixed\":\"\",\"_VCUID\":\"row_160\",\"render\":\"\",\"key\":\"expensZb\"},{\"hidden\":false,\"LAY_TABLE_INDEX\":28,\"minWidth\":\"160\",\"className\":\"\",\"sortable\":true,\"title\":\"费用临界情况\",\"align\":\"\",\"ora_name\":\"YJQKMC\",\"sequence\":28,\"field\":\"expensLimit\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"_VCUID\":\"row_161\",\"render\":\"\",\"key\":\"expensLimit\"},{\"hidden\":true,\"LAY_TABLE_INDEX\":29,\"minWidth\":\"160\",\"className\":\"\",\"sortable\":true,\"title\":\"住院ID\",\"align\":\"\",\"ora_name\":\"ZYID00\",\"sequence\":29,\"field\":\"inHospId\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"_VCUID\":\"row_162\",\"render\":\"\",\"key\":\"inHospId\"},{\"filter_name\":\"\",\"hidden\":true,\"LAY_TABLE_INDEX\":30,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"费别编号\",\"align\":\"\",\"sequence\":30,\"ora_name\":\"FBBH00\",\"field\":\"fbbh00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"_VCUID\":\"row_163\",\"render\":\"\",\"key\":\"fbbh00\"},{\"LAY_TABLE_INDEX\":31,\"minWidth\":\"160\",\"className\":\"\",\"sortable\":true,\"title\":\"进入操作人员\",\"align\":\"\",\"ora_name\":\"JRCZXM\",\"sequence\":31,\"field\":\"enterOperator\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"_VCUID\":\"row_164\",\"render\":\"\",\"key\":\"enterOperator\"}]","condition":"[{\"LAY_TABLE_INDEX\":0,\"label\":\"\",\"dateConfig\":{},\"ora_name\":\"\",\"uiComponentType\":\"\",\"name\":\"\",\"style\":{},\"positionIndex\":\"\",\"id\":\"\",\"placeholder\":\"\",\"uiClick\":\"\",\"_VCUID\":\"row_132\",\"data\":\"\"}]","createTime":1572846469000,"entityVersion":0,"id":"getPatientSingleDiseaseList","isLaypage":"0","module":"zysf","name":"getPatientSingleDiseaseList","pageSql":"select a.BZZTMC,a.RYBQMC,a.RZKSMC,a.RYCWH0,a.ZYH000,a.BRRYCS,a.XM0000,a.XB0000,a.FBXX00,a.RYRQ00,a.DBZBM0,a.BZMC00,a.BAE465,\n  a.BAEMC0,a.JRRQ00,a.JRSJ00,a.ZCZMC0,a.BZSFJE,a.YBYJS0,a.YBYZF0,a.YJZFJE,a.BZNZFY,a.BZNKYE,a.BZ0000,a.WJYJZE,a.BZNBL0,a.YJQKMC,\n  a.ZYID00,a.FBBH00,a.JRCZXM,a.BZZT00  \nfrom VW_ZY_DBZCZB a where (a.BRZT00 >='1' and a.BRZT00 <='3') and a.TCRQ00 is null\n\tand a.BQYYID = '${wardHospId}'\n\t<#switch diseaseStatus>\n\t\t<#case '1'> and a.BZZT00 = '1'<#break>\n\t\t<#case '2'> and a.BZZT00 = '2'<#break>\n\t\t<#case '3'> and a.BZZT00 = '3'<#break>\n\t\t<#case '4'> and a.BZZT00 = '4'<#break>\n\t\t<#default>\n\t</#switch>\n\t<#if wardDeptId?default(\"\")?trim?length gt 0>\n\t\tand a.DQKS00= '${wardDeptId}' \n\t</#if>\n\t<#if wardId?default(\"\")?trim?length gt 0>\n\t\tand a.DQBQ00= '${wardId}' \n\t</#if>\n\t<#if pName?default(\"\")?trim?length gt 0>\n\t\tand a.XM0000 like '%${pName}%'\n\t</#if>\n\t<#if inHospNo?default(\"\")?trim?length gt 0>\n\t\tand a.ZYH000 ='${inHospNo}' \n\t</#if>\n        <#if DAYYID?default(\"\")?trim?length gt 0>  \n               and nvl(DAYYID,'0') = '${DAYYID}'\n        </#if>\norder by a.BZZT00,a.DQBQ00,a.PXCWH0,a.ZYH000","procedureCommit":0,"procedureParameter":"[]","remark":"住院病人单病种列表查询","system":"his","updateTime":1766562730000,"version":0}]