1 08:35:29 SQL Execute: ORACLE - Select SYSDATE from Dual 2 08:35:29 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 08:35:29 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 08:35:30 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') 5 08:35:31 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYBK51262778' and ICKNBH ='FZYBK51262778' 6 08:35:31 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =328872 7 08:35:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 8 08:35:31 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 9 08:35:31 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 328872 and YJDJH0 not in ( 0 , 17445664 ) and GHH000 = '3335316' 10 08:35:31 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 11 08:35:31 SQL Data In: ORACLE - Param = 2, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5951239.000000 12 08:35:31 SQL Data In: ORACLE - Param = 3, Name = PHJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 13 08:35:31 SQL Data In: ORACLE - Param = 4, Name = PMSTYE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 14 08:35:31 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1247.000000 15 08:35:31 SQL Data In: ORACLE - Param = 6, Name = PZDBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 16 08:35:31 SQL Data In: ORACLE - Param = 7, Name = PYHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 08:35:31 SQL Data In: ORACLE - Param = 8, Name = PSYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 08:35:31 SQL Execute: ORACLE - BEGIN "SP_SF_FYXX00_MSTYE0" (PBRID00 => :PBRID00,PGHID00 => :PGHID00,PHJJE00 => :PHJJE00,PMSTYE0 => :PMSTYE0,PCZY000 => :PCZY000,PZDBH00 => :PZDBH00,PYHMSG0 => :PYHMSG0,PSYSMSG => :PSYSMSG); END; 19 08:35:31 SQL Execute: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 20 08:35:31 SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 21 08:35:31 SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23750615.000000 22 08:35:31 SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 23 08:35:31 SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 24 08:35:31 SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 25 08:35:31 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 08:35:31 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 08:35:31 SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 28 08:35:31 SQL Data In: ORACLE - Param = 1, Name = AD_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17445664.000000 29 08:35:31 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16323242.000000 30 08:35:31 SQL Data In: ORACLE - Param = 3, Name = AD_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 31 08:35:31 SQL Data In: ORACLE - Param = 4, Name = AD_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1269.000000 32 08:35:31 SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 08:35:31 SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 08:35:31 SQL Execute: ORACLE - BEGIN "SP_SF_YJDJ00" (AD_YJDJH0 => :AD_YJDJH0,AD_DJH000 => :AD_DJH000,AD_ZXKS00 => :AD_ZXKS00,AD_ZXYS00 => :AD_ZXYS00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 35 08:35:31 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 08:35:31 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3335316 37 08:35:31 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5951239.000000 38 08:35:31 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 39 08:35:31 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 40 08:35:31 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 郑力 41 08:35:31 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 42 08:35:31 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1247.000000 43 08:35:31 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 罗志祥 44 08:35:31 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 45 08:35:31 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16323242.000000 46 08:35:31 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 08:35:31 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 08:35:31 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 08:35:31 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 08:35:31 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 08:35:31 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 08:35:31 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 53 08:35:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 54 08:35:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 55 08:35:32 SQL Execute: ORACLE - select count(*) num from sf_brxxb0 a,yf_mzcf00 b where a.ghid00=b.ghid00 and b.cfzt00=0 and a.brid00= ? and a.ghrq00>to_char(sysdate-?,'YYYYMMDD' ) 56 08:35:32 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where brid00=328872 and ZT0000='1' 57 08:35:32 SQL Execute: ORACLE - commit 58 08:35:32 SQL Data In: ORACLE - Rows affected = 0 59 08:35:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328872.000000 60 08:35:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 3335316 61 08:35:32 SQL Execute: ORACLE - select * from vw_sf_wjzcf a where a.BRID00 = ? and A.GHH000 = ? 62 08:35:35 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 ||',', ',493,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1247 AND b.JSKSBH = '493') AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null)