1 09:59:56 SQL Execute: ORACLE - Select SYSDATE from Dual 2 09:59:56 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 09:59:56 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') 4 09:59:56 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0222137100144881' and ICKNBH ='0222137100144881' 5 09:59:56 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =4872558 6 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 7 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 8 09:59:56 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 9 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 10 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 11 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 12 09:59:56 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 13 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 14 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 15 09:59:56 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 16 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 17 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 18 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 19 09:59:56 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 20 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 21 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 22 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 23 09:59:56 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 24 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 25 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 26 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 27 09:59:56 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 28 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 29 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 30 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 31 09:59:56 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 32 09:59:56 SQL Execute: ORACLE - select ICKLB0,yyid00 from ic_yhxx00 where ickh00= '0222137100144881' 33 09:59:56 SQL Execute: ORACLE - select * from BM_BRJFLB where SFMZ00 = 'Y' and JFLBID in ( select JFLBID from SF_BRZHXX where 1 = 1 and BRID00 in ( select BRID00 from ic_YHXX00 where ickh00 = '0222137100144881' and ZT0000='1' ) ) 34 09:59:56 SQL Execute: ORACLE - select A.*,B.FBMC00 from BM_BRXXB0 A,BM_BRFBB0 B where A.FBBH00=B.FBBH00 and BRID00 in ( select BRID00 from ic_YHXX00 where ickh00 = '0222137100144881' and ZT0000='1' ) 35 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 36 09:59:56 SQL Execute: ORACLE - select * from IC_YHXX00 where BRID00 = ? and ZT0000='1' 37 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 38 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 39 09:59:56 SQL Execute: ORACLE - select * from SF_BRZHXX where brid00 =? and jflbid in ( select JFLBID from BM_BRJFLB where jflbmc = ? ) 40 09:59:56 SQL Execute: ORACLE - select sum(b.hjje00) NUM from sf_fymx00 b,SF_BRFY00 a where a.djh000=b.djh000 and b.xmbh00+0<>8000000218 and a.JFLBID=1 and a.JZDH00+0=0 and a.BRID00=4872558 41 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 42 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 43 09:59:56 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 AND D.GHH000=F.GHH000 and D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 44 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 45 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 46 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 09:59:56 SQL Execute: ORACLE - select kdrq00,zlxmjc,d.GHH000,f.ghrq00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 48 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 49 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 50 09:59:56 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.ghh000,F.ghrq00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 AND A.GHH000=F.GHH000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 51 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 52 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 53 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 09:59:56 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 AND D.GHH000=F.GHH000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 55 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 56 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 57 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 58 09:59:56 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,b.GHH000,F.GHRQ00 59 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 60 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 61 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 62 09:59:56 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00=?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,b.GHH000,f.ghrq00 63 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 64 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 65 09:59:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 66 09:59:56 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,d.ZYHGHH,f.ghrq00 from YJ_YW0000 D,bm_bmbm00 e,sf_brxxb0 f where 1=1 and d.zyhghh=f.ghh000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,d.ZYHGHH,f.ghrq00 67 09:59:56 SQL Misc: ORACLE - Set stored procedure on or off 68 09:59:56 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 69 09:59:56 SQL Data In: ORACLE - Param = 2, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 70 09:59:56 SQL Data In: ORACLE - Param = 3, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 71 09:59:56 SQL Data In: ORACLE - Param = 4, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 72 09:59:56 SQL Data In: ORACLE - Param = 5, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000 73 09:59:56 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = home 74 09:59:56 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 75 09:59:56 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 09:59:56 SQL Execute: ORACLE - BEGIN "SP_SF_BRTK00" (AD_BRID00 => :AD_BRID00,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_XM0000 => :AS_XM0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 77 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 78 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 79 09:59:56 SQL Execute: ORACLE - select * from SF_BRZHXX where brid00 =? and jflbid in ( select JFLBID from BM_BRJFLB where jflbmc = ? ) 80 09:59:56 SQL Misc: ORACLE - Set stored procedure on or off 81 09:59:56 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 82 09:59:56 SQL Data In: ORACLE - Param = 2, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 83 09:59:56 SQL Data In: ORACLE - Param = 3, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 清账退卡 84 09:59:56 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 85 09:59:56 SQL Data In: ORACLE - Param = 5, Name = PJYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 86 09:59:56 SQL Data In: ORACLE - Param = 6, Name = PQTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 87 09:59:56 SQL Data In: ORACLE - Param = 7, Name = PCXLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 88 09:59:56 SQL Data In: ORACLE - Param = 8, Name = PTKJLS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 89 09:59:56 SQL Data In: ORACLE - Param = 9, Name = PTKJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 90 09:59:56 SQL Data In: ORACLE - Param = 10, Name = PERRSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 09:59:56 SQL Data In: ORACLE - Param = 11, Name = PXTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 92 09:59:56 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_TKDATA" (PBRID00 => :PBRID00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PMZZYBZ => :PMZZYBZ,PJYJE00 => :PJYJE00,PQTCS00 => :PQTCS00,PCXLSH0 => :PCXLSH0,PTKJLS0 => :PTKJLS0,PTKJE00 => :PTKJE00,PERRSTR => :PERRSTR,PXTCS00 => :PXTCS00); END; 93 09:59:56 SQL Misc: ORACLE - Set stored procedure on or off 94 09:59:56 SQL Data In: ORACLE - Param = 1, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 95 09:59:56 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 96 09:59:56 SQL Data In: ORACLE - Param = 3, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 97 09:59:56 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 98 09:59:56 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 99 09:59:56 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000 100 09:59:56 SQL Data In: ORACLE - Param = 7, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = home 101 09:59:56 SQL Data In: ORACLE - Param = 8, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 102 09:59:56 SQL Data In: ORACLE - Param = 9, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 103 09:59:56 SQL Data In: ORACLE - Param = 10, Name = AS_SFDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 09:59:56 SQL Data In: ORACLE - Param = 11, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 105 09:59:56 SQL Data In: ORACLE - Param = 12, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.850000 106 09:59:56 SQL Data In: ORACLE - Param = 13, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 107 09:59:56 SQL Data In: ORACLE - Param = 14, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 108 09:59:56 SQL Data In: ORACLE - Param = 15, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 109 09:59:56 SQL Data In: ORACLE - Param = 16, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 110 09:59:56 SQL Data In: ORACLE - Param = 17, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 111 09:59:56 SQL Data In: ORACLE - Param = 18, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 112 09:59:56 SQL Data In: ORACLE - Param = 19, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 113 09:59:56 SQL Execute: ORACLE - BEGIN "SP_SF_MZBRZH_EDIT00" (AD_JFLBID => :AD_JFLBID,AD_BRID00 => :AD_BRID00,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_FPXH00 => :AS_FPXH00,AS_SFDJ00 => :AS_SFDJ00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_CZBZ00 => :AS_CZBZ00,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 114 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 115 09:59:56 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 2 and PJSYR0 = ? and SYBZ00 = 'Y' 116 09:59:56 SQL Misc: ORACLE - Set stored procedure on or off 117 09:59:56 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872558.000000 118 09:59:56 SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 119 09:59:56 SQL Data In: ORACLE - Param = 3, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 120 09:59:56 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 121 09:59:56 SQL Data In: ORACLE - Param = 5, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -7.150000 122 09:59:56 SQL Data In: ORACLE - Param = 6, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 123 09:59:56 SQL Data In: ORACLE - Param = 7, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 124 09:59:56 SQL Data In: ORACLE - Param = 8, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 125 09:59:56 SQL Data In: ORACLE - Param = 9, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 126 09:59:56 SQL Data In: ORACLE - Param = 10, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 127 09:59:56 SQL Data In: ORACLE - Param = 11, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 128 09:59:56 SQL Data In: ORACLE - Param = 12, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 129 09:59:56 SQL Data In: ORACLE - Param = 13, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 09:59:56 SQL Data In: ORACLE - Param = 14, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 131 09:59:56 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 132 09:59:56 SQL Data In: ORACLE - Param = 16, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 133 09:59:56 SQL Data In: ORACLE - Param = 17, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 09:59:56 SQL Data In: ORACLE - Param = 18, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 09:59:56 SQL Execute: ORACLE - BEGIN "SP_SF_BRZHXX" (AD_BRID00 => :AD_BRID00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 136 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 137 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 138 09:59:56 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 139 09:59:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 140 09:59:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 141 09:59:56 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 142 09:59:56 SQL Execute: ORACLE - commit 143 09:59:56 SQL Data In: ORACLE - Rows affected = 0 144 09:59:56 SQL Execute: ORACLE - select BRZJBH,brid00 from BM_BRXXB0 where BRBLH0='home7' and BRZJLX='身份证'