[{"branch":"0","branchmc":"standard","button":"[]","catalog":"queryAndReport","chart":"[]","code":"getPatientList4InHospSummary","column":"[{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"床位号\",\"align\":\"\",\"sequence\":0,\"ora_name\":\"RYCWH0\",\"field\":\"inHospBedNo\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"inHospBedNo\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"病人姓名\",\"align\":\"\",\"sequence\":1,\"ora_name\":\"XM0000\",\"field\":\"pName\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"pName\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"性别\",\"align\":\"\",\"sequence\":2,\"ora_name\":\"XB0000\",\"field\":\"pSex\",\"sortType\":\"asc\",\"width\":\"90\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"pSex\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"住院号\",\"align\":\"\",\"sequence\":3,\"ora_name\":\"ZYH000\",\"field\":\"inHospNo\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"inHospNo\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"入院日期\",\"align\":\"\",\"sequence\":4,\"ora_name\":\"RYRQ00\",\"field\":\"RYRQ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"RYRQ00\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"费别信息\",\"align\":\"\",\"sequence\":5,\"ora_name\":\"FBXX00\",\"field\":\"FBXX00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"FBXX00\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"合计住院费用\",\"align\":\"\",\"sequence\":6,\"ora_name\":\"HJJE00\",\"field\":\"HJJE00\",\"sortType\":\"asc\",\"width\":\"130\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"HJJE00\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"在院状态\",\"align\":\"\",\"sequence\":7,\"ora_name\":\"BRZTMC\",\"field\":\"BRZTMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"BRZTMC\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"清单起始日期\",\"align\":\"\",\"sequence\":8,\"ora_name\":\"QDQSRQ\",\"field\":\"QDQSRQ\",\"sortType\":\"asc\",\"width\":\"130\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"QDQSRQ\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"清单截止日期\",\"align\":\"\",\"sequence\":9,\"ora_name\":\"QDJZRQ\",\"field\":\"QDJZRQ\",\"sortType\":\"asc\",\"width\":\"130\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"QDJZRQ\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"所属病区\",\"align\":\"\",\"sequence\":10,\"ora_name\":\"DQBQMC\",\"field\":\"DQBQMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"DQBQMC\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"所属科室\",\"align\":\"\",\"sequence\":11,\"ora_name\":\"DQKSMC\",\"field\":\"DQKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"DQKSMC\"},{\"filter_name\":\"\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"付费病种编码\",\"align\":\"\",\"sequence\":12,\"ora_name\":\"FFBZBM\",\"field\":\"FFBZBM\",\"sortType\":\"asc\",\"width\":\"130\",\"uiType\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"FFBZBM\"}]","condition":"[]","countSql":"select COUNT(1) as TOTAL from VW_ZY_BRHZQD where 1=1\n--and BRZT00 between '1' and '3'\n<#if wardId?default(\"\")?trim?length gt 0>\n \tand DQBQ00 = ${wardId}\n</#if> \n<#if deptId?default(\"\")?trim?length gt 0>\n \tand DQKS00= ${deptId}\n</#if> \n<#if inHospId?default(\"\")?trim?length gt 0>\n \tand ZYID00= ${inHospId}\n</#if>","createTime":1583102813000,"entityVersion":0,"id":"getPatientList4InHospSummary","isLaypage":"0","module":"zysf","name":"getPatientList4InHospSummary","pageSql":"select * from (select rownum as rowno,tt.* from (\nselect * from VW_ZY_BRHZQD where 1=1\n--and BRZT00 between '1' and '3'\n<#if wardId?default(\"\")?trim?length gt 0>\n \tand DQBQ00 = ${wardId}\n</#if> \n<#if deptId?default(\"\")?trim?length gt 0>\n \tand DQKS00= ${deptId}\n</#if> \n<#if inHospId?default(\"\")?trim?length gt 0>\n \tand ZYID00= ${inHospId}\n</#if> \n order by DQBQ00,PXCWH0,ZYH000\n)tt where rownum <= ${end}) table_alias where table_alias.rowno >${start}","procedureCommit":0,"procedureParameter":"[]","remark":"统计查询-住院汇总清单综合查询-病人列表","system":"his","updateTime":1751255703000,"version":0}]