1 10:01:00 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=-1 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc 2 10:01:01 SQL Execute: ORACLE - select SF_YS_CHECKDTJR JRBZ00 from dual 3 10:01:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197 4 10:01:01 SQL Execute: ORACLE - select GHHZCK from vw_sf_ysghhb where GHYSBH=? AND GHMZSJ >= to_char(sysdate-1, 'YYYYMMDD' ) and TZBZ00 = '0' and ( (GHJSSJ >= GHQSSJ1 and GHJSSJ >= to_char(sysdate,'HH24:MI:SS') and GHQSSJ1 <= to_char(sysdate,'HH24:MI:SS') and GHMZSJ = to_char(sysdate,'YYYYMMDD') ) or (GHJSSJ < GHQSSJ and ((GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHQSSJ <= to_char(sysdate,'HH24:MI:SS' ) ) or (GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHJSSJ >= to_char(sysdate,'HH24:MI:SS' ) ) ) ) ) 5 10:01:01 SQL Execute: ORACLE - Select SYSDATE from Dual 6 10:01:01 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 7 10:01:02 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 8 10:01:02 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 9 10:01:02 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA99166977' and ICKNBH = 'FZYBA99166977' 10 10:01:02 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_MZ' 11 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 12 10:01:02 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 13 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000 14 10:01:02 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 15 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000 16 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 17 10:01:02 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0 from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 18 10:01:02 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000 19 10:01:02 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000 20 10:01:02 SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 21 10:01:02 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000 22 10:01:02 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王子建 23 10:01:02 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 10:01:02 SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 10:01:02 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 26 10:01:02 SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 27 10:01:02 SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 28 10:01:02 SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 29 10:01:02 SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 10:01:02 SQL Execute: ORACLE - BEGIN "SP_ONEPAY_YJJPTJK" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PCARDNO => :PCARDNO,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PRECODE => :PRECODE,PERRMSG => :PERRMSG); END; 31 10:01:02 SQL Execute: ORACLE - Rollback 32 10:01:02 SQL Data In: ORACLE - Rows affected = 0 33 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 34 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 35 10:01:02 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 36 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 37 10:01:02 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 38 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000 39 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 40 10:01:02 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 41 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 42 10:01:02 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 43 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000 44 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 45 10:01:02 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 46 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 47 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 48 10:01:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 49 10:01:02 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 50 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 51 10:01:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001 52 10:01:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 53 10:01:02 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual 54 10:01:02 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0001' and SFQY00='1' 55 10:01:02 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0002' and SFQY00='1' 56 10:01:02 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0003' and SFQY00='1' 57 10:01:02 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_DK00_0004' and SFQY00='1' 58 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 59 10:01:02 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 60 10:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 61 10:01:02 SQL Execute: ORACLE - select kmh000,ickh00,nvl((select YKTYE0 from SF_BRZHXX where BRID00=a.BRID00 and JFLBID=1),0) YKTYE0 from ic_yhxx00 a where zt0000='1' and brid00=? 62 10:01:02 SQL Execute: ORACLE - select 1 from BM_BRKDML where FBBH00=3 and YBZXLB='2' and rownum=1 63 10:01:02 SQL Execute: ORACLE - select count(1) Count0 from bm_tsbzb0 where ybzxlb='2' and instrb(',-1,',',2,')=0 64 10:01:02 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='科室特殊病种目录' and BH0000='474' 65 10:01:02 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 66 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 67 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 68 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 69 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 70 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 71 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 72 10:01:03 SQL Execute: ORACLE - select MC0000,BH0000 from VW_YS_TSBZB0 where YBZXLB='2' and (instr(','||KSBH00||',',',474,')>0 or KSBH00 is null) ORDER BY PXZD00 73 10:01:03 SQL Execute: ORACLE - select SF_YS_BRJZBSTS(601750) GHCSTS from dual 74 10:01:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 75 10:01:03 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=1197) or (a.JZYS00=0) ) or (a.GHKS00=474 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc