1 18:56:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 2 18:56:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 3 18:56:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 4 18:56:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 5 18:56:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = %049044% 6 18:56:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 7 18:56:52 SQL Execute: ORACLE - SELECT K.* FROM VW_YJ_YWCX_JZSJ K where JZRQ00>=? AND JZRQ00<=? AND YJKSBH+0=? AND MZZYBZ =? AND ZYHGHH LIKE ? AND (BRXM00 like ? ) order by k.JZRQ00 8 18:56:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7644952.000000 9 18:56:52 SQL Execute: ORACLE - SELECT S.XMMC00, DECODE(FJFYBZ,'Y','是','否')FJFYBZ, SL0000,S.DW0000,SFCS00,JJJE00,CXBZ00,DECODE(YBBZ00,'Y','','')YBBZ00,MXID00 FROM YJ_YWJJ00 Y,BM_YYSFXM S WHERE YJDJH0=? AND Y.SFXMID=S.SFXMID 10 18:56:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7644952.000000 11 18:56:52 SQL Execute: ORACLE - SELECT XMMC00,JGDW00,CKZ000,JGMS00,BZ0000,ZXRXM0,sl0000, TO_DATE(ZXRQ00||ZXSJ00,'YYYYMMDDHH24:MI:SS')ZXRQSJ, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 FROM YJ_YWMX00 a WHERE YJDJH0=? 12 18:56:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7644952.000000 13 18:56:52 SQL Execute: ORACLE - SELECT S.XMMC00, DECODE(FJFYBZ,'Y','是','否')FJFYBZ, SL0000,S.DW0000,SFCS00,JJJE00,CXBZ00,DECODE(YBBZ00,'Y','','')YBBZ00,MXID00 FROM YJ_YWJJ00 Y,BM_YYSFXM S WHERE YJDJH0=? AND Y.SFXMID=S.SFXMID 14 18:56:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7644952.000000 15 18:56:52 SQL Execute: ORACLE - SELECT XMMC00,JGDW00,CKZ000,JGMS00,BZ0000,ZXRXM0,sl0000, TO_DATE(ZXRQ00||ZXSJ00,'YYYYMMDDHH24:MI:SS')ZXRQSJ, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 FROM YJ_YWMX00 a WHERE YJDJH0=? 16 18:56:58 SQL Execute: ORACLE - select BMMC00 from bm_bmbm00 where BMBH00=77 17 18:56:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 18 18:56:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = %049044% 19 18:56:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 20 18:56:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 21 18:56:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 22 18:56:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 23 18:56:58 SQL Execute: ORACLE - SELECT mzzybz,K.yjksbh,K.zyhghh, decode(K.yexm00,null, K.brxm00,K.yexm00) brxm00, decode(K.yexm00,null,K.xb0000,(select yexb00 from bq_jsxx00 where zyid00 in (select zyid00 from zy_brxxb0 where zyh000=K.ZYHGHH and rownum=1) and yexm00=K.yexm00)) xb0000,'20150101' minrq0,'20150407' maxrq0 FROM VW_YJ_YWCX_JZSJ K where MZZYBZ =? AND ZYHGHH LIKE ? AND JZRQ00>=? AND JZRQ00<=? AND YJKSBH+0=? and (K.BRXM00 like ? ) group by mzzybz,K.yjksbh,K.zyhghh,K.brxm00,K.xb0000,K.yexm00 24 18:56:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 25 18:56:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 26 18:56:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 27 18:56:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 28 18:56:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 29 18:56:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 30 18:56:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 31 18:56:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 32 18:56:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 33 18:56:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 34 18:56:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 35 18:56:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 36 18:56:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 37 18:56:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 38 18:56:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 39 18:56:58 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 40 18:56:58 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 41 18:56:58 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 42 18:56:58 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 43 18:56:58 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 44 18:56:58 SQL Execute: ORACLE - SELECT order0,ZLXMJC,GKSM00,DW0000,sum(SL0000) SL0000,sum(ZJE000) ZJE000,XMZT00 FROM ( SELECT 0 order0,zlxmjc,null gksm00,dw0000,SL0000,zje000,xmzt00,yjdjh0 FROM VW_YJ_YWCX_JZSJ where MZZYBZ =? AND ZYHGHH=? and ((BRXM00=? and yexm00 is null) or (yexm00=?)) AND JZRQ00>=? AND JZRQ00<=? and yjksbh=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and '门诊' = ? and a.GHH000=? AND a.brxm00=? and a.JZRQ00>=? AND a.JZRQ00<=? and ghks00=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_zycf00 a,yf_zycfmx b where a.cflsh0=b.cflsh0 and '住院' = ? and a.ZYH000=? and ((a.BRXM00=? and a.yexm00 is null) or (a.yexm00=?)) and a.JZRQ00>=? AND a.JZRQ00<=? and DQKS00=?) group by order0,ZLXMJC,GKSM00,DW0000,XMZT00 order by order0 45 18:56:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 46 18:56:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 47 18:56:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 48 18:56:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 49 18:56:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 50 18:56:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 51 18:56:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 52 18:56:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 53 18:56:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 54 18:56:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 55 18:56:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 56 18:56:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 57 18:56:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 58 18:56:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 59 18:56:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 60 18:56:58 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 61 18:56:58 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 62 18:56:58 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 63 18:56:58 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 64 18:56:58 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 65 18:56:58 SQL Execute: ORACLE - SELECT order0,ZLXMJC,GKSM00,DW0000,sum(SL0000) SL0000,sum(ZJE000) ZJE000,XMZT00 FROM ( SELECT 0 order0,zlxmjc,null gksm00,dw0000,SL0000,zje000,xmzt00,yjdjh0 FROM VW_YJ_YWCX_JZSJ where MZZYBZ =? AND ZYHGHH=? and ((BRXM00=? and yexm00 is null) or (yexm00=?)) AND JZRQ00>=? AND JZRQ00<=? and yjksbh=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and '门诊' = ? and a.GHH000=? AND a.brxm00=? and a.JZRQ00>=? AND a.JZRQ00<=? and ghks00=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_zycf00 a,yf_zycfmx b where a.cflsh0=b.cflsh0 and '住院' = ? and a.ZYH000=? and ((a.BRXM00=? and a.yexm00 is null) or (a.yexm00=?)) and a.JZRQ00>=? AND a.JZRQ00<=? and DQKS00=?) group by order0,ZLXMJC,GKSM00,DW0000,XMZT00 order by order0 66 18:56:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 67 18:56:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 68 18:56:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 69 18:56:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 70 18:56:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 71 18:56:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 72 18:56:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 73 18:56:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 74 18:56:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 75 18:56:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 76 18:56:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 77 18:56:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 78 18:56:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 79 18:56:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 80 18:56:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 81 18:56:58 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 82 18:56:58 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 83 18:56:58 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 84 18:56:58 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 85 18:56:58 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 86 18:56:58 SQL Execute: ORACLE - SELECT order0,ZLXMJC,GKSM00,DW0000,sum(SL0000) SL0000,sum(ZJE000) ZJE000,XMZT00 FROM ( SELECT 0 order0,zlxmjc,null gksm00,dw0000,SL0000,zje000,xmzt00,yjdjh0 FROM VW_YJ_YWCX_JZSJ where MZZYBZ =? AND ZYHGHH=? and ((BRXM00=? and yexm00 is null) or (yexm00=?)) AND JZRQ00>=? AND JZRQ00<=? and yjksbh=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and '门诊' = ? and a.GHH000=? AND a.brxm00=? and a.JZRQ00>=? AND a.JZRQ00<=? and ghks00=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_zycf00 a,yf_zycfmx b where a.cflsh0=b.cflsh0 and '住院' = ? and a.ZYH000=? and ((a.BRXM00=? and a.yexm00 is null) or (a.yexm00=?)) and a.JZRQ00>=? AND a.JZRQ00<=? and DQKS00=?) group by order0,ZLXMJC,GKSM00,DW0000,XMZT00 order by order0 87 18:56:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 88 18:56:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 89 18:56:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 90 18:56:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 91 18:56:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 92 18:56:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 93 18:56:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 94 18:56:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 95 18:56:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 96 18:56:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 97 18:56:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 98 18:56:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 99 18:56:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 100 18:56:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 101 18:56:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 049044 102 18:56:58 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 103 18:56:58 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 方元英 104 18:56:58 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150101 105 18:56:58 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150407 106 18:56:58 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 107 18:56:58 SQL Execute: ORACLE - SELECT order0,ZLXMJC,GKSM00,DW0000,sum(SL0000) SL0000,sum(ZJE000) ZJE000,XMZT00 FROM ( SELECT 0 order0,zlxmjc,null gksm00,dw0000,SL0000,zje000,xmzt00,yjdjh0 FROM VW_YJ_YWCX_JZSJ where MZZYBZ =? AND ZYHGHH=? and ((BRXM00=? and yexm00 is null) or (yexm00=?)) AND JZRQ00>=? AND JZRQ00<=? and yjksbh=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and '门诊' = ? and a.GHH000=? AND a.brxm00=? and a.JZRQ00>=? AND a.JZRQ00<=? and ghks00=? union select 1 order0,b.ypmc00 zlxmjc,ypgg00||'['||YPYFMC||']' gksm00,b.CFDW00,b.YPZSL0,ROUND(b.YPZSL0*b.LSDJ00,2) zje000, DECODE(a.CFZT00,'0','未记账','1','已记账','2','已发药','3','作废'),b.cfid00 from yf_zycf00 a,yf_zycfmx b where a.cflsh0=b.cflsh0 and '住院' = ? and a.ZYH000=? and ((a.BRXM00=? and a.yexm00 is null) or (a.yexm00=?)) and a.JZRQ00>=? AND a.JZRQ00<=? and DQKS00=?) group by order0,ZLXMJC,GKSM00,DW0000,XMZT00 order by order0