1 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1329585.000000 2 11:03:50 SQL Execute: ORACLE - select * from zy_brxxb0 where brid00=? and cyrq00 is null 3 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1329585.000000 4 11:03:50 SQL Execute: ORACLE - select max(ZYID00) ZYID00 from ZY_BRXXB0 where BRID00 = ? 5 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1329585.000000 6 11:03:50 SQL Execute: ORACLE - select B.BMMC00 BQMC00,C.BMMC00 KSMC00,A.CH0000,A.ZDMC00,a.ysgzh0,d.zwxm00,A.ZDM000 from ys_brzysq A, bm_bmbm00 B,bm_bmbm00 C,bm_ygbm00 d where A.BQH000 = B.BMBH00(+) and A.KSH000 = C.BMBH00(+) and a.YSGZH0=d.ygbh00(+) and A.BRID00 =? and jsbz00 = '0' 7 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 8 11:03:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1329585.000000 9 11:03:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 10 11:03:50 SQL Execute: ORACLE - select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual 11 11:03:50 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 =1 and SYBZ00 = 'Y' 12 11:03:50 SQL Execute: ORACLE - select * from VW_BM_BRFBB0 13 11:03:50 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by BH0000 14 11:03:50 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 15 11:03:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00 = '病人证件类型' and MC0000 = 'Y' and YXBZ00 = '1' order by XSXH00 16 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 17 11:03:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 18 11:03:50 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 19 11:03:50 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB where 1=1 order BY QTLBBH 20 11:03:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 21 11:03:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 22 11:03:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 23 11:03:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 24 11:03:50 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 25 11:03:50 SQL Execute: ORACLE - select * from vw_zy_brjflb where JFLBID <> 0 26 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 27 11:03:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 28 11:03:50 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 29 11:03:50 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 and ZFFSBH not in (18,20,26) order by nvl(XSXH00,0),ZFFSBH 30 11:03:50 SQL Execute: ORACLE - select C.BMMC00 from BM_BMBM00 A, BM_BQKS00 B,BM_BMBM00 C where A.BMBH00 = B.BQH000 and B.KSH000 = C.BMBH00 and B.YXBZ00 = '1' and A.BMMC00 = '内一病区' 31 11:03:50 SQL Execute: ORACLE - select * from vw_zy_cwk000 where BQMC00 = '内一病区' 32 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 482 33 11:03:50 SQL Execute: ORACLE - select * from bm_bmbm00 where bmbh00 =? 34 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 488 35 11:03:50 SQL Execute: ORACLE - select * from bm_bmbm00 where bmbh00 =? 36 11:03:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 37 11:03:50 SQL Execute: ORACLE - select * from VW_ZY_BRXX00 where brid00 = 1329585 38 11:03:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 39 11:03:50 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 40 11:03:50 SQL Execute: ORACLE - select max(ZYID00) ZYID00 from ZY_BRXXB0 A where brid00 =1329585 41 11:03:50 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 42 11:03:50 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 11:03:50 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 44 11:03:51 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 45 11:03:51 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 46 11:03:51 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 47 11:03:51 SQL Execute: ORACLE - select * from ZY_BRZHXX A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.BRID00 =1329585 and JFLBMC = '住院预交金' 48 11:04:50 Log started for: SQL Navigator for Oracle