1       10:55:43  SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual

2       10:55:43  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'

3       10:55:43  SQL Execute: ORACLE - Select SYSDATE from Dual

4       10:55:43  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')

5       10:55:43  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-MMRK'
and KLDH00 not in ('CK','JMCK')

6       10:55:43  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'HEC'
and KLDH00 not in ('CK','JMCK')

7       10:55:43  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'EHC'
and KLDH00 not in ('CK','JMCK')

8       10:55:43  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')

9       10:55:43  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4428'
and KLDH00 not in ('CK','JMCK')

10      10:55:43  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')

11      10:55:44  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBAA6495437'
and ICKNBH = 'FZYBAA6495437'

12      10:55:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
13      10:55:44  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBAA6495437
14      10:55:44  SQL Execute: ORACLE -  select a.* from VW_SF_BRZHXX a where a.SFDJ00<>'2' and a.JFLBID = ? and a.ICKH00 = ? 

15      10:55:44  SQL Execute: ORACLE -  select ICKLB0 from IC_YHXX00 where brid00='10382840' and ZT0000='1'

16      10:55:44  SQL Execute: ORACLE - select *  from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_MZ'

17      10:55:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
18      10:55:44  SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 

19      10:55:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000
20      10:55:44  SQL Execute: ORACLE - Select *  from bm_ygbm00 where YGBH00=?

21      10:55:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000
22      10:55:44  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
23      10:55:44  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=?

24      10:55:44  SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000
25      10:55:44  SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000
26      10:55:44  SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
27      10:55:44  SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000
28      10:55:44  SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众
29      10:55:44  SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
30      10:55:44  SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
31      10:55:44  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
32      10:55:44  SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
33      10:55:44  SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
34      10:55:44  SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
35      10:55:44  SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
36      10:55:44  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;
37      10:55:44  SQL Execute: ORACLE - Rollback

38      10:55:44  SQL Data In: ORACLE - Rows affected = 0