1 10:35:30 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260101 2 10:35:30 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 3 10:35:30 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20260105 4 10:35:30 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 5 10:35:30 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有科室 6 10:35:30 SQL Data In: ORACLE - Param = 6, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 10:35:30 SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 10:35:30 SQL Data In: ORACLE - Param = 8, Name = AS_FYFSLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 9 10:35:30 SQL Data In: ORACLE - Param = 9, Name = AS_YBMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病人 10 10:35:30 SQL Data In: ORACLE - Param = 10, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 10:35:30 SQL Data In: ORACLE - Param = 11, Name = as_MZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 10:35:30 SQL Data In: ORACLE - Param = 12, Name = as_SFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 13 10:35:30 SQL Data In: ORACLE - Param = 13, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 10:35:30 SQL Data In: ORACLE - Param = 14, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 10:35:30 SQL Data In: ORACLE - Param = 15, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 10:35:30 SQL Execute: ORACLE - BEGIN "SP_ZH_QYSLTJ_HSHZYS" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSMC00 => :AS_KSMC00,AS_SFYB00 => :AS_SFYB00,AS_TJLB00 => :AS_TJLB00,AS_FYFSLB => :AS_FYFSLB,AS_YBMC00 => :AS_YBMC00,AS_YYID00 => :AS_YYID00,as_MZZYBZ => :as_MZZYBZ,as_SFJS00 => :as_SFJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 17 10:35:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10398304.000000 18 10:35:43 SQL Execute: ORACLE - select decode(A.YPHJ00,1,'',2,'',A.BMMC00) YSXM00,decode(A.YPHJ00,0,'合计',1,'门诊',2,'住院') LB0000,A.XMHJ00,round(decode(nvl(A.XMHJ00,'0'),'0','0',nvl(A.SFXM99,'0')/nvl(A.XMHJ00,'0'))*100,3)||'%' YPBL00, A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06,A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96,A.SFXM97,A.SFXM98,A.SFXM99 from BM_YYSFTJ A where A.ID0000 =? order by A.BMBH00,YPHJ00 19 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='01' 20 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='02' 21 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='03' 22 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='04' 23 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='05' 24 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='06' 25 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='07' 26 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='08' 27 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='09' 28 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='10' 29 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='11' 30 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='12' 31 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='13' 32 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='14' 33 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='15' 34 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='16' 35 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='17' 36 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='18' 37 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='19' 38 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='20' 39 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='21' 40 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='22' 41 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='23' 42 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='24' 43 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='25' 44 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='26' 45 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='27' 46 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='28' 47 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='29' 48 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='30' 49 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='31' 50 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='32' 51 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='33' 52 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='34' 53 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='35' 54 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='36' 55 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='37' 56 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='38' 57 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='39' 58 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='40' 59 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='41' 60 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='42' 61 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='43' 62 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='44' 63 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='45' 64 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='46' 65 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='47' 66 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='48' 67 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='49' 68 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='50' 69 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='51' 70 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='52' 71 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='53' 72 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='54' 73 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='55' 74 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='56' 75 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='57' 76 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='58' 77 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='59' 78 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='60' 79 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='61' 80 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='62' 81 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='63' 82 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='64' 83 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='65' 84 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='66' 85 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='67' 86 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='68' 87 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='69' 88 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='70' 89 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='71' 90 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='72' 91 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='73' 92 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='74' 93 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='75' 94 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='76' 95 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='77' 96 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='78' 97 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='79' 98 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='81' 99 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='82' 100 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='83' 101 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='84' 102 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='85' 103 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='86' 104 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='87' 105 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='88' 106 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='89' 107 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='90' 108 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='91' 109 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='92' 110 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='93' 111 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='94' 112 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='95' 113 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='96' 114 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='97' 115 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='98' 116 10:35:44 SQL Execute: ORACLE - select * from bm_yyhsxm where XSXLH0 ='99'