[{"branch":"0","branchmc":"standard","button":"[]","catalog":"ChaXun","chart":"[]","code":"qrySSTZD","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"SSJH00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"className\":\"\",\"title\":\"手术间\",\"align\":\"center\",\"ora_name\":\"SSJH00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSJH00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSJH00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"LJBZ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"className\":\"\",\"title\":\"路径标志\",\"align\":\"center\",\"ora_name\":\"LJBZ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LJBZ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"LJBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSRQSJ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"手术日期\",\"align\":\"center\",\"ora_name\":\"SSRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSRQSJ\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SQZD00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"术前诊断\",\"align\":\"center\",\"ora_name\":\"SQZD00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SQZD00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"SQZD00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"ZYHGHH\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"住院挂号号\",\"align\":\"center\",\"ora_name\":\"ZYHGHH\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"ZYHGHH\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZYHGHH\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XM0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"病人姓名\",\"align\":\"center\",\"ora_name\":\"XM0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XM0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"XM0000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XB0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":6,\"className\":\"\",\"title\":\"性别\",\"align\":\"center\",\"ora_name\":\"XB0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XB0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":6,\"round\":\"\",\"trunc\":\"\",\"field\":\"XB0000\",\"sortType\":\"asc\",\"width\":\"50\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"NL0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"年龄\",\"align\":\"center\",\"ora_name\":\"NL0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"NL0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"NL0000\",\"sortType\":\"asc\",\"width\":\"50\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"FBMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":8,\"className\":\"\",\"title\":\"费别\",\"align\":\"center\",\"ora_name\":\"FBMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"FBMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":8,\"round\":\"\",\"trunc\":\"\",\"field\":\"FBMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":9,\"className\":\"\",\"title\":\"手术名称\",\"align\":\"center\",\"ora_name\":\"SSMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":9,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSMC00\",\"sortType\":\"asc\",\"width\":\"200\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSYSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":10,\"className\":\"\",\"title\":\"手术医生\",\"align\":\"center\",\"ora_name\":\"SSYSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSYSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":10,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSYSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":11,\"className\":\"\",\"title\":\"手术助手\",\"align\":\"center\",\"ora_name\":\"SSZSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":11,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX11\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":12,\"className\":\"\",\"title\":\"手术助手1\",\"align\":\"center\",\"ora_name\":\"SSZSX11\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX11\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":12,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX11\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BZ0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":13,\"className\":\"\",\"title\":\"备注\",\"align\":\"center\",\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BZ0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":13,\"round\":\"\",\"trunc\":\"\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"200\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":14,\"className\":\"\",\"title\":\"麻醉方法\",\"align\":\"center\",\"ora_name\":\"MZMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":14,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZYSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":15,\"className\":\"\",\"title\":\"麻醉医生\",\"align\":\"center\",\"ora_name\":\"MZYSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZYSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":15,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZYSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"TSHSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":16,\"className\":\"\",\"title\":\"台上护士\",\"align\":\"center\",\"ora_name\":\"TSHSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TSHSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":16,\"round\":\"\",\"trunc\":\"\",\"field\":\"TSHSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GYHSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":17,\"className\":\"\",\"title\":\"供应护士\",\"align\":\"center\",\"ora_name\":\"GYHSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GYHSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":17,\"round\":\"\",\"trunc\":\"\",\"field\":\"GYHSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GLDJM1\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":18,\"className\":\"\",\"title\":\"是否隔离\",\"align\":\"center\",\"ora_name\":\"GLDJM1\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GLDJM1\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":18,\"round\":\"\",\"trunc\":\"\",\"field\":\"GLDJM1\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFYBSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":19,\"className\":\"\",\"title\":\"是否夜班\",\"align\":\"center\",\"ora_name\":\"SFYBSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFYBSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":19,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFYBSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SZKSMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":20,\"className\":\"\",\"title\":\"当前科室\",\"align\":\"center\",\"ora_name\":\"SZKSMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SZKSMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":20,\"round\":\"\",\"trunc\":\"\",\"field\":\"SZKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSTC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":21,\"className\":\"\",\"title\":\"手术台次\",\"align\":\"center\",\"ora_name\":\"SSTC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSTC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":21,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSTC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"TSYP01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":22,\"className\":\"\",\"title\":\"特殊药品\",\"align\":\"center\",\"ora_name\":\"TSYP01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TSYP01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":22,\"round\":\"\",\"trunc\":\"\",\"field\":\"TSYP01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GLDJMC\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":23,\"className\":\"\",\"title\":\"隔离名称\",\"align\":\"center\",\"ora_name\":\"GLDJMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GLDJMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":23,\"round\":\"\",\"trunc\":\"\",\"field\":\"GLDJMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CGZ000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":24,\"className\":\"\",\"title\":\"参观者\",\"align\":\"center\",\"ora_name\":\"CGZ000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CGZ000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":24,\"round\":\"\",\"trunc\":\"\",\"field\":\"CGZ000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"JSRQ01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":25,\"className\":\"\",\"title\":\"结束日期\",\"align\":\"center\",\"ora_name\":\"JSRQ01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JSRQ01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":25,\"round\":\"\",\"trunc\":\"\",\"field\":\"JSRQ01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"JSSJ01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":26,\"className\":\"\",\"title\":\"结束时间\",\"align\":\"center\",\"ora_name\":\"JSSJ01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JSSJ01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":26,\"round\":\"\",\"trunc\":\"\",\"field\":\"JSSJ01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BRLB00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":27,\"className\":\"\",\"title\":\"类别\",\"align\":\"center\",\"ora_name\":\"BRLB00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BRLB00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":27,\"round\":\"\",\"trunc\":\"\",\"field\":\"BRLB00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"ZYE000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":28,\"className\":\"\",\"title\":\"账户余额\",\"align\":\"center\",\"ora_name\":\"ZYE000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"ZYE000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":28,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZYE000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CZRQSJ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":29,\"className\":\"\",\"title\":\"手术申请时间\",\"align\":\"center\",\"ora_name\":\"CZRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CZRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":29,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SQRQSJ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":30,\"className\":\"\",\"title\":\"手术医嘱时间\",\"align\":\"center\",\"ora_name\":\"SQRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SQRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":30,\"round\":\"\",\"trunc\":\"\",\"field\":\"SQRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFTSYP\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":31,\"className\":\"\",\"title\":\"是否特殊药品\",\"align\":\"center\",\"ora_name\":\"SFTSYP\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFTSYP\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":31,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFTSYP\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZSC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":32,\"className\":\"\",\"title\":\"麻醉时长（小时）\",\"align\":\"center\",\"ora_name\":\"MZSC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZSC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":32,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZSC00\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZBM00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":33,\"className\":\"\",\"title\":\"麻醉编号\",\"align\":\"center\",\"ora_name\":\"MZBM00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZBM00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":33,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZBM00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZBZ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":34,\"className\":\"\",\"title\":\"麻醉备注\",\"align\":\"center\",\"ora_name\":\"MZBZ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZBZ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":34,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YSZMC0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":35,\"className\":\"\",\"title\":\"医生组\",\"align\":\"center\",\"ora_name\":\"YSZMC0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YSZMC0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":35,\"round\":\"\",\"trunc\":\"\",\"field\":\"YSZMC0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSDJMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":36,\"className\":\"\",\"title\":\"手术级别\",\"align\":\"center\",\"ora_name\":\"SSDJMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSDJMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":36,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSDJMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFQJSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":37,\"className\":\"\",\"title\":\"是否腔镜\",\"align\":\"center\",\"ora_name\":\"SFQJSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFQJSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":37,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFQJSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFWCSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":38,\"className\":\"\",\"title\":\"是否微创\",\"align\":\"center\",\"ora_name\":\"SFWCSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFWCSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":38,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFWCSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFZCSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":39,\"className\":\"\",\"title\":\"非计划再次手术\",\"align\":\"center\",\"ora_name\":\"SFZCSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFZCSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":39,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFZCSS\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BWMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":40,\"className\":\"\",\"title\":\"部位\",\"align\":\"center\",\"ora_name\":\"BWMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BWMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":40,\"round\":\"\",\"trunc\":\"\",\"field\":\"BWMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"DBZMC0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":41,\"className\":\"\",\"title\":\"单病种名称\",\"align\":\"center\",\"ora_name\":\"DBZMC0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"DBZMC0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":41,\"round\":\"\",\"trunc\":\"\",\"field\":\"DBZMC0\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFCRB0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":42,\"className\":\"\",\"title\":\"是否传染病\",\"align\":\"center\",\"ora_name\":\"SFCRB0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFCRB0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":42,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFCRB0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CRBZDM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":43,\"className\":\"\",\"title\":\"传染病诊断名称\",\"align\":\"center\",\"ora_name\":\"CRBZDM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CRBZDM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":43,\"round\":\"\",\"trunc\":\"\",\"field\":\"CRBZDM\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"DCLY00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":44,\"className\":\"\",\"title\":\"多重耐药信息\",\"align\":\"center\",\"ora_name\":\"DCLY00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"DCLY00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":44,\"round\":\"\",\"trunc\":\"\",\"field\":\"DCLY00\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX1\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":45,\"className\":\"\",\"title\":\"手术助手1\",\"align\":\"center\",\"ora_name\":\"SSZSX1\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX1\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":45,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX1\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","countSql":"select  count(1) as total\nfrom (select a.ssrqsj,substr(a.ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\na.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,\na.rycwh0,\nd.ssdh00,\ndecode(a.sftsyp,'Y','是','N ','否','否') sftsyp,\na.bz0000,\na.zye000,\na.fbbh00,a.FBMC00,a.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\na.sftsyp tsyp01,\na.MZBH00,\na.sfybss,\na.ssjsrq,a.ssjssj,\na.jsrq01,\na.jssj01,\na.mzsc00,\na.mzbm00,\na.mzbz00,\na.ssfybz,\na.SZKSMC,\na.YSZID0,\na.YSZMC0,\na.CGZ000,\na.lyjmc0,\na.DBZBM0,a.DBZMC0,\na.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\nd.SSDJMC,\ndecode(d.SFQJSS,'Y','是','否') SFQJSS,\ndecode(d.SFWCSS,'Y','是','否') SFWCSS,\ndecode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS, \na.BWMC00,\na.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,\na.GLDJM1,\na.SFCRB0,\na.CRBZDM,\nd.SSXMJC  SSMC00\n,a.BRID00\n,a.DCLY00\nfrom vw_ss_yw0000 a, ss_ywmx00 d \nwhere a.sszt00 in ('0','2') and mzzybz='1' \nand d.ssdh00 = a.ssdh00\n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n  <#if ZYHGHH?default(\"\")?trim?length gt 0>\n       and   a.ZYHGHH like '%${ZYHGHH}%'\n </#if>\n and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n      union all\n      select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\n      a.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,'''' rycwh0,d.ssdh00,decode(a.sftsyp,'Y','是','N','否','否') sftsyp,\n      a.bz0000,a.zye000,a.fbbh00,A.FBMC00,A.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\n      a.sftsyp tsyp01,a.MZBH00,a.sfybss,a.ssjsrq,a.ssjssj,a.jsrq01,a.jssj01,a.mzsc00,a.mzbm00,a.mzbz00,a.ssfybz,a.SZKSMC,a.YSZID0,a.YSZMC0,a.CGZ000,a.lyjmc0,\n      a.DBZBM0,a.DBZMC0,a.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\n      d.SSDJMC,decode(d.SFQJSS,'Y','是','否') SFQJSS,decode(d.SFWCSS,'Y','是','否') SFWCSS,\n      decode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS \n      ,a.BWMC00,a.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,a.GLDJM1,a.SFCRB0,a.CRBZDM,\n      d.SSXMJC  SSMC00\n     ,a.BRID00,a.DCLY00 \n      from vw_ss_yw0000 a , ss_ywmx00 d\n      where a.sszt00 in ('0','2') and mzzybz='0' \n       and d.ssdh00 = a.ssdh00\n     <#if ZYHGHH?default(\"\")?trim?length gt 0>\n          and   a.ZYHGHH like '%${ZYHGHH}%'\n      </#if>\n      and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n    and SSKSMC='${SSKSMC}'\n</#if>\n) v\n\n\n        ","createTime":1755596309000,"entityVersion":0,"id":"qrySSTZD","isLaypage":"0","module":"ss","name":"qrySSTZD","pageSql":"select  SSTC00,SSRQSJ,XM0000,LJBZ00,SSMC00,TSHSXM,GYHSXM,MZYSXM,MZMC00,SSJH00,TSYP01,GLDJMC,GLDJM1,SFYBSS,JSRQ01,JSSJ01,SSYS00,SSYSXM,SSZSXM,BRLB00,XB0000,NL0000,\nZYHGHH,FBMC00,ZYE000,BZ0000,CZRQSJ,SQRQSJ,SFTSYP,MZSC00,MZBM00,MZBZ00,SQZD00,SZKSMC,YSZMC0,CGZ000,SSDJMC,SFQJSS,SFWCSS,SFZCSS,BWMC00,DBZMC0,SFCRB0,CRBZDM,DCLY00,SSDH00,\nSSZSX11,SSZSX22,SSZSX33,SSZSX44,SSZSX1,SSZSX2,SSZSX3,SSZSX4\nfrom (select a.ssrqsj,substr(a.ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\na.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,\na.rycwh0,\nd.ssdh00,\ndecode(a.sftsyp,'Y','是','N ','否','否') sftsyp,\na.bz0000,\na.zye000,\na.fbbh00,a.FBMC00,a.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\na.sftsyp tsyp01,\na.MZBH00,\na.sfybss,\na.ssjsrq,a.ssjssj,\na.jsrq01,\na.jssj01,\na.mzsc00,\na.mzbm00,\na.mzbz00,\na.ssfybz,\na.SZKSMC,\na.YSZID0,\na.YSZMC0,\na.CGZ000,\na.lyjmc0,\na.DBZBM0,a.DBZMC0,\na.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\nd.SSDJMC,\nd.SFQJSS,\nd.SFWCSS,\ndecode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS, \na.BWMC00,\na.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,\na.GLDJM1,\na.SFCRB0,\na.CRBZDM,\nd.SSXMJC SSMC00\n,a.BRID00\n,a.DCLY00,a.SSZSX11,a.SSZSX22,a.SSZSX33,a.SSZSX44,a.SSZSX1,a.SSZSX2,a.SSZSX3,a.SSZSX4\nfrom vw_ss_yw0000 a, ss_ywmx00 d \nwhere a.sszt00 in ('0','2') and mzzybz='1' \nand d.ssdh00 = a.ssdh00\n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n  <#if ZYHGHH?default(\"\")?trim?length gt 0>\n       and   a.ZYHGHH like '%${ZYHGHH}%'\n </#if>\n and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n      union all\n      select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\n      a.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,'''' rycwh0,d.ssdh00,decode(a.sftsyp,'Y','是','N','否','否') sftsyp,\n      a.bz0000,a.zye000,a.fbbh00,A.FBMC00,A.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\n      a.sftsyp tsyp01,a.MZBH00,a.sfybss,a.ssjsrq,a.ssjssj,a.jsrq01,a.jssj01,a.mzsc00,a.mzbm00,a.mzbz00,a.ssfybz,a.SZKSMC,a.YSZID0,a.YSZMC0,a.CGZ000,a.lyjmc0,\n      a.DBZBM0,a.DBZMC0,a.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\n      d.SSDJMC,decode(d.SFQJSS,'Y','是','否') SFQJSS,decode(d.SFWCSS,'Y','是','否') SFWCSS,\n      decode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS \n      ,a.BWMC00,a.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,a.GLDJM1,a.SFCRB0,a.CRBZDM,\n     d.SSXMJC  SSMC00\n     ,a.BRID00,a.DCLY00,a.SSZSX11,a.SSZSX22,a.SSZSX33,a.SSZSX44,a.SSZSX1,a.SSZSX2,a.SSZSX3,a.SSZSX4 \n      from vw_ss_yw0000 a , ss_ywmx00 d\n      where a.sszt00 in ('0','2') and mzzybz='0' \n       and d.ssdh00 = a.ssdh00\n     <#if ZYHGHH?default(\"\")?trim?length gt 0>\n          and   a.ZYHGHH like '%${ZYHGHH}%'\n      </#if>\n      and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n) v\n <#if SS_SSTZDPXFS2?default(\"\")?trim?length gt 0>\n    order by ${SS_SSTZDPXFS2}\n<#else>\n  order by  SSRQSJ,SSDH00\n</#if>\n        ","procedureCommit":0,"procedureParameter":"[]","remark":"查询手术通知单","system":"his","updateTime":1758506553000,"version":0},{"branch":"227049","branchmc":"南平市第一医院","button":"[]","catalog":"ChaXun","chart":"[]","code":"qrySSTZD","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"SSJH00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"className\":\"\",\"title\":\"手术间\",\"align\":\"center\",\"ora_name\":\"SSJH00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSJH00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSJH00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"LJBZ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"className\":\"\",\"title\":\"路径标志\",\"align\":\"center\",\"ora_name\":\"LJBZ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LJBZ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"LJBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSRQSJ\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"手术日期时间\",\"align\":\"center\",\"ora_name\":\"SSRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSRQSJ\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSRQ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"手术日期\",\"align\":\"center\",\"ora_name\":\"SSRQ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSRQ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSRQ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSSJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"手术时间\",\"align\":\"center\",\"ora_name\":\"SSSJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSSJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSSJ00\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SQZD00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"术前诊断\",\"align\":\"center\",\"ora_name\":\"SQZD00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SQZD00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"SQZD00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"ZYHGHH\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":6,\"className\":\"\",\"title\":\"住院挂号号\",\"align\":\"center\",\"ora_name\":\"ZYHGHH\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"ZYHGHH\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":6,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZYHGHH\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XM0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"病人姓名\",\"align\":\"center\",\"ora_name\":\"XM0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XM0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"XM0000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XB0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":8,\"className\":\"\",\"title\":\"性别\",\"align\":\"center\",\"ora_name\":\"XB0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XB0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":8,\"round\":\"\",\"trunc\":\"\",\"field\":\"XB0000\",\"sortType\":\"asc\",\"width\":\"50\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"NL0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":9,\"className\":\"\",\"title\":\"年龄\",\"align\":\"center\",\"ora_name\":\"NL0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"NL0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":9,\"round\":\"\",\"trunc\":\"\",\"field\":\"NL0000\",\"sortType\":\"asc\",\"width\":\"50\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"RYCWH0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":10,\"className\":\"\",\"title\":\"床号\",\"align\":\"center\",\"ora_name\":\"RYCWH0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"RYCWH0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":10,\"round\":\"\",\"trunc\":\"\",\"field\":\"RYCWH0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"FBMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":11,\"className\":\"\",\"title\":\"费别\",\"align\":\"center\",\"ora_name\":\"FBMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"FBMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":11,\"round\":\"\",\"trunc\":\"\",\"field\":\"FBMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":12,\"className\":\"\",\"title\":\"手术名称\",\"align\":\"center\",\"ora_name\":\"SSMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":12,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSMC00\",\"sortType\":\"asc\",\"width\":\"300\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSYSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":13,\"className\":\"\",\"title\":\"手术医生\",\"align\":\"center\",\"ora_name\":\"SSYSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSYSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":13,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSYSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSXM\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":14,\"className\":\"\",\"title\":\"手术助手\",\"align\":\"center\",\"ora_name\":\"SSZSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":14,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX11\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":15,\"className\":\"\",\"title\":\"手术助手1\",\"align\":\"center\",\"ora_name\":\"SSZSX11\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX11\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":15,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX11\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX22\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":16,\"className\":\"\",\"title\":\"手术助手2\",\"align\":\"center\",\"ora_name\":\"SSZSX22\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX22\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":16,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX22\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX33\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":17,\"className\":\"\",\"title\":\"手术助手3\",\"align\":\"center\",\"ora_name\":\"SSZSX33\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX33\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":17,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX33\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX44\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":18,\"className\":\"\",\"title\":\"手术助手4\",\"align\":\"center\",\"ora_name\":\"SSZSX44\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX44\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":18,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX44\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BZ0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":19,\"className\":\"\",\"title\":\"备注\",\"align\":\"center\",\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BZ0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":19,\"round\":\"\",\"trunc\":\"\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"200\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":20,\"className\":\"\",\"title\":\"麻醉方法\",\"align\":\"center\",\"ora_name\":\"MZMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":20,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZYSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":21,\"className\":\"\",\"title\":\"麻醉医生\",\"align\":\"center\",\"ora_name\":\"MZYSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZYSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":21,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZYSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"TSHSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":22,\"className\":\"\",\"title\":\"台上护士\",\"align\":\"center\",\"ora_name\":\"TSHSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TSHSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":22,\"round\":\"\",\"trunc\":\"\",\"field\":\"TSHSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GYHSXM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":23,\"className\":\"\",\"title\":\"供应护士\",\"align\":\"center\",\"ora_name\":\"GYHSXM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GYHSXM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":23,\"round\":\"\",\"trunc\":\"\",\"field\":\"GYHSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GLDJM1\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":24,\"className\":\"\",\"title\":\"是否隔离\",\"align\":\"center\",\"ora_name\":\"GLDJM1\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GLDJM1\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":24,\"round\":\"\",\"trunc\":\"\",\"field\":\"GLDJM1\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFYBSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":25,\"className\":\"\",\"title\":\"是否夜班\",\"align\":\"center\",\"ora_name\":\"SFYBSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFYBSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":25,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFYBSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SZKSMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":26,\"className\":\"\",\"title\":\"当前科室\",\"align\":\"center\",\"ora_name\":\"SZKSMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SZKSMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":26,\"round\":\"\",\"trunc\":\"\",\"field\":\"SZKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSTC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":27,\"className\":\"\",\"title\":\"手术台次\",\"align\":\"center\",\"ora_name\":\"SSTC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSTC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":27,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSTC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"TSYP01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":28,\"className\":\"\",\"title\":\"特殊药品\",\"align\":\"center\",\"ora_name\":\"TSYP01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TSYP01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":28,\"round\":\"\",\"trunc\":\"\",\"field\":\"TSYP01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GLDJMC\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":29,\"className\":\"\",\"title\":\"隔离名称\",\"align\":\"center\",\"ora_name\":\"GLDJMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GLDJMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":29,\"round\":\"\",\"trunc\":\"\",\"field\":\"GLDJMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CGZ000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":30,\"className\":\"\",\"title\":\"参观者\",\"align\":\"center\",\"ora_name\":\"CGZ000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CGZ000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":30,\"round\":\"\",\"trunc\":\"\",\"field\":\"CGZ000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"JSRQ01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":31,\"className\":\"\",\"title\":\"结束日期\",\"align\":\"center\",\"ora_name\":\"JSRQ01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JSRQ01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":31,\"round\":\"\",\"trunc\":\"\",\"field\":\"JSRQ01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"JSSJ01\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":32,\"className\":\"\",\"title\":\"结束时间\",\"align\":\"center\",\"ora_name\":\"JSSJ01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JSSJ01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":32,\"round\":\"\",\"trunc\":\"\",\"field\":\"JSSJ01\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BRLB00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":33,\"className\":\"\",\"title\":\"类别\",\"align\":\"center\",\"ora_name\":\"BRLB00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BRLB00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":33,\"round\":\"\",\"trunc\":\"\",\"field\":\"BRLB00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"ZYE000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":34,\"className\":\"\",\"title\":\"账户余额\",\"align\":\"center\",\"ora_name\":\"ZYE000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"ZYE000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":34,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZYE000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CZRQSJ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":35,\"className\":\"\",\"title\":\"手术申请时间\",\"align\":\"center\",\"ora_name\":\"CZRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CZRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":35,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SQRQSJ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":36,\"className\":\"\",\"title\":\"手术医嘱时间\",\"align\":\"center\",\"ora_name\":\"SQRQSJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SQRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":36,\"round\":\"\",\"trunc\":\"\",\"field\":\"SQRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFTSYP\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":37,\"className\":\"\",\"title\":\"是否特殊药品\",\"align\":\"center\",\"ora_name\":\"SFTSYP\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFTSYP\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":37,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFTSYP\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZSC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":38,\"className\":\"\",\"title\":\"麻醉时长（小时）\",\"align\":\"center\",\"ora_name\":\"MZSC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZSC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":38,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZSC00\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZBM00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":39,\"className\":\"\",\"title\":\"麻醉编号\",\"align\":\"center\",\"ora_name\":\"MZBM00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZBM00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":39,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZBM00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"MZBZ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":40,\"className\":\"\",\"title\":\"麻醉备注\",\"align\":\"center\",\"ora_name\":\"MZBZ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"MZBZ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":40,\"round\":\"\",\"trunc\":\"\",\"field\":\"MZBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YSZMC0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":41,\"className\":\"\",\"title\":\"医生组\",\"align\":\"center\",\"ora_name\":\"YSZMC0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YSZMC0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":41,\"round\":\"\",\"trunc\":\"\",\"field\":\"YSZMC0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSDJMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":42,\"className\":\"\",\"title\":\"手术级别\",\"align\":\"center\",\"ora_name\":\"SSDJMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSDJMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":42,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSDJMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFQJSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":43,\"className\":\"\",\"title\":\"是否腔镜\",\"align\":\"center\",\"ora_name\":\"SFQJSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFQJSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":43,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFQJSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFWCSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":44,\"className\":\"\",\"title\":\"是否微创\",\"align\":\"center\",\"ora_name\":\"SFWCSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFWCSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":44,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFWCSS\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFZCSS\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":45,\"className\":\"\",\"title\":\"非计划再次手术\",\"align\":\"center\",\"ora_name\":\"SFZCSS\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFZCSS\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":45,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFZCSS\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BWMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":46,\"className\":\"\",\"title\":\"部位\",\"align\":\"center\",\"ora_name\":\"BWMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BWMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":46,\"round\":\"\",\"trunc\":\"\",\"field\":\"BWMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"DBZMC0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":47,\"className\":\"\",\"title\":\"单病种名称\",\"align\":\"center\",\"ora_name\":\"DBZMC0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"DBZMC0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":47,\"round\":\"\",\"trunc\":\"\",\"field\":\"DBZMC0\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SFCRB0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":48,\"className\":\"\",\"title\":\"是否传染病\",\"align\":\"center\",\"ora_name\":\"SFCRB0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SFCRB0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":48,\"round\":\"\",\"trunc\":\"\",\"field\":\"SFCRB0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CRBZDM\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":49,\"className\":\"\",\"title\":\"传染病诊断名称\",\"align\":\"center\",\"ora_name\":\"CRBZDM\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CRBZDM\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":49,\"round\":\"\",\"trunc\":\"\",\"field\":\"CRBZDM\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"DCLY00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":50,\"className\":\"\",\"title\":\"多重耐药信息\",\"align\":\"center\",\"ora_name\":\"DCLY00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"DCLY00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":50,\"round\":\"\",\"trunc\":\"\",\"field\":\"DCLY00\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX1\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":51,\"className\":\"\",\"title\":\"手术助手1\",\"align\":\"center\",\"ora_name\":\"SSZSX1\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX1\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":51,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX1\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX2\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":52,\"className\":\"\",\"title\":\"手术助手2\",\"align\":\"center\",\"ora_name\":\"SSZSX2\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX2\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":52,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX2\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX3\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":53,\"className\":\"\",\"title\":\"手术助手3\",\"align\":\"center\",\"ora_name\":\"SSZSX3\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX3\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":53,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX3\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SSZSX4\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":54,\"className\":\"\",\"title\":\"手术助手4\",\"align\":\"center\",\"ora_name\":\"SSZSX4\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SSZSX4\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":54,\"round\":\"\",\"trunc\":\"\",\"field\":\"SSZSX4\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","countSql":"select  count(1) as total\nfrom (select a.ssrqsj,substr(a.ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\na.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,\na.rycwh0,\nd.ssdh00,\ndecode(a.sftsyp,'Y','是','N ','否','否') sftsyp,\na.bz0000,\na.zye000,\na.fbbh00,a.FBMC00,a.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\na.sftsyp tsyp01,\na.MZBH00,\na.sfybss,\na.ssjsrq,a.ssjssj,\na.jsrq01,\na.jssj01,\na.mzsc00,\na.mzbm00,\na.mzbz00,\na.ssfybz,\na.SZKSMC,\na.YSZID0,\na.YSZMC0,\na.CGZ000,\na.lyjmc0,\na.DBZBM0,a.DBZMC0,\na.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\nd.SSDJMC,\ndecode(d.SFQJSS,'Y','是','否') SFQJSS,\ndecode(d.SFWCSS,'Y','是','否') SFWCSS,\ndecode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS, \na.BWMC00,\na.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,\na.GLDJM1,\na.SFCRB0,\na.CRBZDM,\nd.SSXMJC  SSMC00\n,a.BRID00\n,a.DCLY00\nfrom vw_ss_yw0000 a, ss_ywmx00 d \nwhere a.sszt00 in ('0','2') and mzzybz='1' \nand d.ssdh00 = a.ssdh00\n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n  <#if ZYHGHH?default(\"\")?trim?length gt 0>\n       and   a.ZYHGHH like '%${ZYHGHH}%'\n </#if>\n and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n      union all\n      select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\n      a.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,'''' rycwh0,d.ssdh00,decode(a.sftsyp,'Y','是','N','否','否') sftsyp,\n      a.bz0000,a.zye000,a.fbbh00,A.FBMC00,A.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\n      a.sftsyp tsyp01,a.MZBH00,a.sfybss,a.ssjsrq,a.ssjssj,a.jsrq01,a.jssj01,a.mzsc00,a.mzbm00,a.mzbz00,a.ssfybz,a.SZKSMC,a.YSZID0,a.YSZMC0,a.CGZ000,a.lyjmc0,\n      a.DBZBM0,a.DBZMC0,a.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\n      d.SSDJMC,decode(d.SFQJSS,'Y','是','否') SFQJSS,decode(d.SFWCSS,'Y','是','否') SFWCSS,\n      decode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS \n      ,a.BWMC00,a.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,a.GLDJM1,a.SFCRB0,a.CRBZDM,\n      d.SSXMJC  SSMC00\n     ,a.BRID00,a.DCLY00 \n      from vw_ss_yw0000 a , ss_ywmx00 d\n      where a.sszt00 in ('0','2') and mzzybz='0' \n       and d.ssdh00 = a.ssdh00\n     <#if ZYHGHH?default(\"\")?trim?length gt 0>\n          and   a.ZYHGHH like '%${ZYHGHH}%'\n      </#if>\n      and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SS_SSTZDPXFS1=='1'>\n    and d.SFZSS0=0\n</#if>\n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n    and SSKSMC='${SSKSMC}'\n</#if>\n) v\n\n\n        ","createTime":1756824877000,"entityVersion":0,"id":"qrySSTZD","isLaypage":"0","module":"ss","name":"qrySSTZD","pageSql":"select  SSTC00,SSRQSJ,SUBSTR(SSRQSJ,1,10) SSRQ00,SUBSTR(SSRQSJ,12,16) SSSJ00,XM0000,LJBZ00,\n--SSMC00,\nLISTAGG(SSMC00,' | ') WITHIN GROUP (ORDER BY SSMC00) SSMC00,\nTSHSXM,GYHSXM,MZYSXM,MZMC00,SSJH00,TSYP01,GLDJMC,GLDJM1,SFYBSS,JSRQ01,JSSJ01,SSYS00,SSYSXM,SSZSXM,BRLB00,XB0000,NL0000,\nZYHGHH,FBMC00,ZYE000,BZ0000,CZRQSJ,SQRQSJ,SFTSYP,MZSC00,MZBM00,MZBZ00,SQZD00,SZKSMC,YSZMC0,CGZ000,SSDJMC,SFQJSS,SFWCSS,SFZCSS,BWMC00,DBZMC0,SFCRB0,CRBZDM,DCLY00,SSDH00,RYCWH0,\nSSZSX11,SSZSX22,SSZSX33,SSZSX44,SSZSX1,SSZSX2,SSZSX3,SSZSX4\nfrom (select a.ssrqsj,substr(a.ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\na.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,\na.rycwh0,\nd.ssdh00,\ndecode(a.sftsyp,'Y','是','N ','否','否') sftsyp,\na.bz0000,\na.zye000,\na.fbbh00,a.FBMC00,a.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\na.sftsyp tsyp01,\na.MZBH00,\na.sfybss,\na.ssjsrq,a.ssjssj,\na.jsrq01,\na.jssj01,\na.mzsc00,\na.mzbm00,\na.mzbz00,\na.ssfybz,\na.SZKSMC,\na.YSZID0,\na.YSZMC0,\na.CGZ000,\na.lyjmc0,\na.DBZBM0,a.DBZMC0,\na.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\nd.SSDJMC,\nd.SFQJSS,\nd.SFWCSS,\ndecode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS, \na.BWMC00,\na.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,\na.GLDJM1,\na.SFCRB0,\na.CRBZDM,\nd.SSXMJC SSMC00\n,a.BRID00\n,a.DCLY00,a.SSZSX11,a.SSZSX22,a.SSZSX33,a.SSZSX44,a.SSZSX1,a.SSZSX2,a.SSZSX3,a.SSZSX4\nfrom vw_ss_yw0000 a, ss_ywmx00 d \nwhere a.sszt00 in ('0','2') and mzzybz='1' \nand d.ssdh00 = a.ssdh00\n <#if SS_SSTZDPXFS1=='1'>\n    --and d.SFZSS0=0\n</#if>\n  <#if ZYHGHH?default(\"\")?trim?length gt 0>\n       and   a.ZYHGHH like '%${ZYHGHH}%'\n </#if>\n and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n      union all\n      select a.ssrqsj,substr(ssqssj,1,5) sssj00,a.xm0000,a.xb0000,a.nl0000,a.brlb00,a.zyhghh,a.sqzd00,a.ssys00,a.ssysxm,\n      a.sszs00,a.sszsxm,a.mzysxm,a.mzmc00,a.tshsxm,a.gyhsxm,a.ssjh00,sstc00,ssksmc,glbz00,'''' rycwh0,d.ssdh00,decode(a.sftsyp,'Y','是','N','否','否') sftsyp,\n      a.bz0000,a.zye000,a.fbbh00,A.FBMC00,A.GLDJMC,decode(a.jzbz00,'Y','是',null) jz0000,a.sqrqsj,substr(a.czrq00,1,8)||' '||substr(a.czrq00,9,5) czrqsj,\n      a.sftsyp tsyp01,a.MZBH00,a.sfybss,a.ssjsrq,a.ssjssj,a.jsrq01,a.jssj01,a.mzsc00,a.mzbm00,a.mzbz00,a.ssfybz,a.SZKSMC,a.YSZID0,a.YSZMC0,a.CGZ000,a.lyjmc0,\n      a.DBZBM0,a.DBZMC0,a.LJBZ00||decode(a.DBZBM0,'','','(单)') LJBZ00,\n      d.SSDJMC,decode(d.SFQJSS,'Y','是','否') SFQJSS,decode(d.SFWCSS,'Y','是','否') SFWCSS,\n      decode((select count(1) from SS_YW0000 M,SS_YWMX00 N where M.ZYGHID=a.ZYGHID and M.MZZYBZ=a.MZZYBZ and M.sszt00 in ('0','2') and M.SSDH00=N.SSDH00 and M.SSDH00<a.SSDH00 and N.SSXMJC=d.SSXMJC and rownum=1),1,'是','否') as SFZCSS \n      ,a.BWMC00,a.BZ0000||substr(SF_SS_GETBWMC(a.SSDH00,a.BWMC00),1,20) BWMC01,a.GLDJM1,a.SFCRB0,a.CRBZDM,\n     d.SSXMJC  SSMC00\n     ,a.BRID00,a.DCLY00,a.SSZSX11,a.SSZSX22,a.SSZSX33,a.SSZSX44,a.SSZSX1,a.SSZSX2,a.SSZSX3,a.SSZSX4 \n      from vw_ss_yw0000 a , ss_ywmx00 d\n      where a.sszt00 in ('0','2') and mzzybz='0' \n       and d.ssdh00 = a.ssdh00\n     <#if ZYHGHH?default(\"\")?trim?length gt 0>\n          and   a.ZYHGHH like '%${ZYHGHH}%'\n      </#if>\n      and a.ssqsrq between '${QSRQ00}' and '${JZRQ00}'  and\na.ssqsrq||a.ssqssj between  '${QSRQ00}'||  '${QSSJ00}' and '${JZRQ00}'  || '${JZSJ00}'  \n <#if SS_SSTZDPXFS1=='1'>\n    --and d.SFZSS0=0\n</#if>\n <#if SSYSWK=='1'>\n    and a.SSYS00 is null\n<#else>\n  and a.SSYS00 is not null\n</#if>\n <#if MZYSFK=='Y'>\n    and a.MZYSXM is not null\n</#if>\n <#if SS_SSAPCXMZAPXSBKS=='Y'>\n     and a.SSKSMC='${SSKSMC}'\n</#if>\n) v group by \nSSTC00,SSRQSJ,XM0000,LJBZ00,TSHSXM,GYHSXM,MZYSXM,MZMC00,SSJH00,TSYP01,GLDJMC,GLDJM1,SFYBSS,JSRQ01,JSSJ01,SSYS00,SSYSXM,SSZSXM,BRLB00,XB0000,NL0000,ZYHGHH,FBMC00,ZYE000,BZ0000,CZRQSJ,SQRQSJ,SFTSYP,MZSC00,MZBM00,MZBZ00,SQZD00,SZKSMC,YSZMC0,CGZ000,SSDJMC,SFQJSS,SFWCSS,SFZCSS,BWMC00,DBZMC0,SFCRB0,CRBZDM,DCLY00,SSDH00,RYCWH0,SSZSX11,SSZSX22,SSZSX33,SSZSX44,SSZSX1,SSZSX2,SSZSX3,SSZSX4\n <#if SS_SSTZDPXFS2?default(\"\")?trim?length gt 0>\n    order by ${SS_SSTZDPXFS2}\n<#else>\n  order by  SSRQSJ,SSDH00\n</#if>\n        ","procedureCommit":0,"procedureParameter":"[]","remark":"查询手术通知单","system":"his","updateTime":1758506577000,"version":0}]