[{"branch":"0","branchmc":"standard","button":"[]","catalog":"RiChangYeWu","chart":"[]","code":"showYjYwjj","column":"[{\"filter_name\":\"A.ID0000\",\"hidden\":true,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"ID0000\",\"field\":\"ID0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ID0000\"},{\"filter_name\":\"A.YJFZH0\",\"hidden\":true,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"YJFZH0\",\"headerAlign\":\"center\",\"field\":\"YJFZH0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YJFZH0\"},{\"filter_name\":\"TRIM(B.XMMC00)\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"项目名称\",\"align\":\"\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"XMMC00\",\"headerAlign\":\"center\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"180\",\"fixed\":\"\",\"render\":\"\",\"key\":\"XMMC00\"},{\"title\":\"项目编码\",\"key\":\"BH0000\",\"ora_name\":\"BH0000\",\"filter_name\":\"B.BH0000\",\"fatherKey\":\"\",\"width\":\"50\",\"minWidth\":\"\",\"align\":\"center\",\"headerAlign\":\"center\",\"footerAlign\":\"center\",\"className\":\"\",\"fixed\":\"\",\"sortable\":false,\"sortType\":\"asc\",\"hidden\":false,\"disabledCheckboxColumn\":false,\"sys_hidden\":\"\",\"ellipsis\":true,\"uiType\":\"\",\"isSummary\":\"false\",\"summary\":\"\",\"round\":\"\",\"trunc\":\"\",\"render\":\"\",\"LAY_TABLE_INDEX\":30,\"sequence\":3,\"field\":\"BH0000\"},{\"filter_name\":\"A.GJBM00\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"国家编码\",\"align\":\"\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"GJBM00\",\"headerAlign\":\"center\",\"field\":\"GJBM00\",\"sortType\":\"asc\",\"width\":\"90\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GJBM00\"},{\"sys_hidden\":\"\",\"filter_name\":\"b.BKEH83\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"国家医保编码\",\"align\":\"\",\"ora_name\":\"BKEH83\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BKEH83\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"BKEH83\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"b.GJBZMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"国家医保名称\",\"align\":\"\",\"ora_name\":\"GJBZMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJBZMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":6,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJBZMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"filter_name\":\"A.JJJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":7,\"ora_name\":\"JJJE00\",\"headerAlign\":\"center\",\"field\":\"JJJE00\",\"sortType\":\"asc\",\"width\":\"70\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JJJE00\"},{\"filter_name\":\"A.SL0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"SL0000\",\"headerAlign\":\"center\",\"field\":\"SL0000\",\"sortType\":\"asc\",\"width\":\"55\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SL0000\"},{\"filter_name\":\"B.DW0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单位\",\"align\":\"\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"DW0000\",\"headerAlign\":\"center\",\"field\":\"DW0000\",\"sortType\":\"asc\",\"width\":\"45\",\"fixed\":\"\",\"render\":\"\",\"key\":\"DW0000\"},{\"filter_name\":\"A.SFCS00\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"倍数\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"SFCS00\",\"headerAlign\":\"center\",\"field\":\"SFCS00\",\"sortType\":\"asc\",\"width\":\"55\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFCS00\"},{\"filter_name\":\"A.JZJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"记账金额\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"JZJE00\",\"headerAlign\":\"center\",\"field\":\"JZJE00\",\"sortType\":\"asc\",\"width\":\"70\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZJE00\"},{\"filter_name\":\"0\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"申退数\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"BCCXSL\",\"headerAlign\":\"center\",\"field\":\"BCCXSL\",\"sortType\":\"asc\",\"width\":\"70\",\"fixed\":\"\",\"render\":\"\",\"key\":\"BCCXSL\"},{\"filter_name\":\"A.CXSL00\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"已退数\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"CXSL00\",\"headerAlign\":\"center\",\"field\":\"CXSL00\",\"sortType\":\"asc\",\"width\":\"60\",\"fixed\":\"\",\"render\":\"\",\"key\":\"CXSL00\"},{\"filter_name\":\"A.GFJE00\",\"hidden\":true,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"其他支付\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":14,\"ora_name\":\"GFJE00\",\"headerAlign\":\"center\",\"field\":\"GFJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GFJE00\"},{\"filter_name\":\"A.ZFJE00\",\"hidden\":true,\"LAY_TABLE_INDEX\":14,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"现金支付\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"ZFJE00\",\"headerAlign\":\"center\",\"field\":\"ZFJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZFJE00\"},{\"sys_hidden\":\"\",\"filter_name\":\"GG0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":15,\"className\":\"\",\"title\":\"规格\",\"align\":\"center\",\"ora_name\":\"GG0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GG0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":16,\"round\":\"\",\"trunc\":\"\",\"field\":\"GG0000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SCCJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":16,\"className\":\"\",\"title\":\"厂家\",\"align\":\"center\",\"ora_name\":\"SCCJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SCCJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":17,\"round\":\"\",\"trunc\":\"\",\"field\":\"SCCJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"A.YBBZ00\",\"hidden\":true,\"LAY_TABLE_INDEX\":17,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":18,\"ora_name\":\"YBBZ00\",\"field\":\"YBBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBBZ00\"},{\"filter_name\":\"A.ZFBL00\",\"hidden\":false,\"LAY_TABLE_INDEX\":18,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"自付\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":19,\"ora_name\":\"ZFBL00\",\"headerAlign\":\"center\",\"field\":\"ZFBL00\",\"sortType\":\"asc\",\"width\":\"45\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZFBL00\"},{\"filter_name\":\"A.GDBZ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":19,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"必收\",\"align\":\"\",\"ellipsis\":true,\"sequence\":20,\"ora_name\":\"GDBZ00\",\"headerAlign\":\"center\",\"field\":\"GDBZ00\",\"sortType\":\"asc\",\"width\":\"45\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GDBZ00\"},{\"filter_name\":\"A.FJFYBZ\",\"hidden\":true,\"LAY_TABLE_INDEX\":20,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"附加\",\"align\":\"\",\"ellipsis\":true,\"sequence\":21,\"ora_name\":\"FJFYBZ\",\"headerAlign\":\"center\",\"field\":\"FJFYBZ\",\"sortType\":\"asc\",\"width\":\"45\",\"fixed\":\"\",\"render\":\"\",\"key\":\"FJFYBZ\"},{\"filter_name\":\"A.SFXMID\",\"hidden\":true,\"LAY_TABLE_INDEX\":21,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":22,\"ora_name\":\"SFXMID\",\"field\":\"SFXMID\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFXMID\"},{\"filter_name\":\"A.SFLB00\",\"hidden\":false,\"LAY_TABLE_INDEX\":22,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"标志\",\"align\":\"\",\"ellipsis\":true,\"sequence\":23,\"ora_name\":\"SFLB00\",\"headerAlign\":\"center\",\"field\":\"SFLB00\",\"sortType\":\"asc\",\"width\":\"75\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFLB00\"},{\"filter_name\":\"C.ZTM000\",\"hidden\":false,\"LAY_TABLE_INDEX\":23,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"主条码\",\"align\":\"\",\"ellipsis\":true,\"sequence\":24,\"ora_name\":\"ZTM000\",\"headerAlign\":\"center\",\"field\":\"ZTM000\",\"sortType\":\"asc\",\"width\":\"90\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTM000\"},{\"filter_name\":\"C.CTM000\",\"hidden\":false,\"LAY_TABLE_INDEX\":24,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"次条码\",\"align\":\"\",\"ellipsis\":true,\"sequence\":25,\"ora_name\":\"CTM000\",\"headerAlign\":\"center\",\"field\":\"CTM000\",\"sortType\":\"asc\",\"width\":\"90\",\"fixed\":\"\",\"render\":\"\",\"key\":\"CTM000\"},{\"filter_name\":\"A.YJDJH0\",\"hidden\":true,\"LAY_TABLE_INDEX\":25,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":26,\"ora_name\":\"YJDJH0\",\"field\":\"YJDJH0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YJDJH0\"},{\"filter_name\":\"A.SFXX00\",\"hidden\":true,\"LAY_TABLE_INDEX\":26,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":27,\"ora_name\":\"SFXX00\",\"field\":\"SFXX00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFXX00\"},{\"filter_name\":\"A.SFSX00\",\"hidden\":true,\"LAY_TABLE_INDEX\":27,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":28,\"ora_name\":\"SFSX00\",\"field\":\"SFSX00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFSX00\"},{\"filter_name\":\"B.SFJE00\",\"hidden\":true,\"LAY_TABLE_INDEX\":28,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":29,\"ora_name\":\"SFJE00\",\"field\":\"SFJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SFJE00\"},{\"filter_name\":\"A.MXID00\",\"hidden\":true,\"LAY_TABLE_INDEX\":29,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"\",\"ellipsis\":true,\"sequence\":30,\"ora_name\":\"MXID00\",\"field\":\"MXID00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"MXID00\"}]","condition":"[]","countSql":"<#if YJ_YNDGHZSWSDL=='N'>\nselect\n count(1) as total,count(1) as XMMC00, '条记录' as JJJE00 , sum(A.JZJE00) as JZJE00\nfrom YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C \nwhere A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = '${YJDJH0}'\n<#else>\nselect  \n   count(1) as total,count(1) as XMMC00, '条记录' as JJJE00 , sum(A.JZJE00) as JZJE00\nfrom YJ_YWJJ00 A, BM_YYSFXM B\nwhere A.SFXMID = B.SFXMID and YJDJH0 = '${YJDJH0}'\n</#if>","createTime":1621561530000,"entityVersion":0,"id":"showYjYwjj","isLaypage":"0","module":"yj","name":"showYjYwjj","pageSql":"<#if YJ_YNDGHZSWSDL=='N'>\nselect\n  A.ID0000, A.YJFZH0,TRIM(B.XMMC00) XMMC00,A.JJJE00, A.SL0000, B.BH0000,\n  B.DW0000, A.SFCS00, A.JZJE00, 0 BCCXSL, A.CXSL00,\n  A.GFJE00, A.ZFJE00, A.YBBZ00, A.ZFBL00, A.GDBZ00, \n  A.FJFYBZ, A.SFXMID, A.GJBM00, A.SFLB00, C.ZTM000,\n  C.CTM000, A.YJDJH0, A.SFXX00, A.SFSX00, B.SFJE00, \n  A.MXID00,b.BKEH83,b.GJBZMC,B.GG0000,B.SCCJ00\nfrom YJ_YWJJ00 A, BM_YYSFXM B,SS_GZHCJK C \nwhere A.SFXMID = B.SFXMID and A.ID0000 = C.JJID00(+) and A.YJDJH0 = '${YJDJH0}'\n<#else>\nselect  \n  A.ID0000, A.YJFZH0,TRIM(B.XMMC00) XMMC00, A.JJJE00, A.SL0000, B.BH0000,\n  B.DW0000, A.SFCS00, A.JZJE00, 0 BCCXSL, A.CXSL00,\n  A.GFJE00, A.ZFJE00, A.YBBZ00, A.ZFBL00, A.GDBZ00, \n  A.FJFYBZ, A.SFXMID, A.GJBM00, A.SFLB00, '' ZTM000,\n  '' CTM000,A.YJDJH0, A.SFXX00, A.SFSX00, B.SFJE00, \n  A.MXID00,b.BKEH83,b.GJBZMC ,B.GG0000,B.SCCJ00\nfrom YJ_YWJJ00 A, BM_YYSFXM B\nwhere A.SFXMID = B.SFXMID and YJDJH0 = '${YJDJH0}'\n</#if>","procedureCommit":0,"procedureParameter":"[]","remark":"获取医技业务计价数据","system":"his","updateTime":1711439910000,"version":0}]