1 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 3 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 4 10:11:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5 10:11:28 SQL Execute: ORACLE - select SF_SF_GETYWLSH0(?,?,?,?) AS FHXX00 from dual 6 10:11:28 SQL Execute: ORACLE - Select SYSDATE from Dual 7 10:11:28 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') 8 10:11:28 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0222137601841915' and ICKNBH ='0222137601841915' 9 10:11:28 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =4269334 10 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 11 10:11:28 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 12 10:11:28 SQL Execute: ORACLE - select count(1) num from SF_PJSYQK where PLBH00=1 and PJXH00='0000000015' and CZY000=369 13 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 14 10:11:28 SQL Execute: ORACLE - select a.*,b.ybmc00 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and brid00= ? 15 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000218.000000 16 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 17 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 10:11:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160525 19 10:11:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220601 20 10:11:28 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? 21 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 22 10:11:28 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' 23 10:11:28 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20220601' WHERE BRID00=4269334 and JZDH00+0=0 AND CZRQ00='19990101' 24 10:11:28 SQL Data In: ORACLE - Rows affected = 0 25 10:11:28 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 26 10:11:28 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 27 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 28 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 29 10:11:28 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') 30 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 31 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 32 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 33 10:11:28 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') 34 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 35 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 36 10:11:28 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 37 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 38 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 39 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 40 10:11:28 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') 41 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 42 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 43 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 44 10:11:28 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 45 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 46 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 47 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 48 10:11:28 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 49 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 50 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 51 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 52 10:11:28 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 53 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350126197505163552 54 10:11:28 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 55 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4269334 56 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = 医保病人以自费建卡登记 57 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 58 10:11:28 SQL Execute: ORACLE - select count(0) num from BM_TYZD00 where BH0000=? and ZDMC00=? and YXBZ00=? 59 10:11:28 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 60 10:11:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4269334.000000 61 10:11:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 62 10:11:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160525 63 10:11:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220601 64 10:11:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 65 10:11:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 66 10:11:28 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 67 10:11:28 SQL Execute: ORACLE - select SP_SF_PDBRSFYXQFJS(4269334) SFQFJS from dual