1 10:42:06 SQL Execute: ORACLE - Select SYSDATE from Dual 2 10:42:06 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') 3 10:42:06 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='1225533000638066' and ICKNBH ='0225533600149361' 4 10:42:06 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =1605857 5 10:42:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1605857.000000 6 10:42:06 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 7 10:42:06 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 1605857 and YJDJH0 not in ( 0 ) and GHH000 = '2752652' 8 10:42:06 SQL Execute: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 9 10:42:06 SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1605857.000000 10 10:42:06 SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4702760.000000 11 10:42:06 SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 12 10:42:06 SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 10:42:06 SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 14 10:42:06 SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 10:42:06 SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 10:42:06 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; 17 10:42:06 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2226246 18 10:42:06 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20552917.000000 19 10:42:06 SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 20 10:42:06 SQL Data In: ORACLE - Param = 4, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 21 10:42:06 SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 10:42:06 SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 23 10:42:06 SQL Data In: ORACLE - Param = 7, Name = AS_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 653.000000 24 10:42:06 SQL Data In: ORACLE - Param = 8, Name = AS_ZYDJQT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 25 10:42:06 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AS_SFQZF0 => :AS_SFQZF0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CZY000 => :AS_CZY000,AS_ZYDJQT => :AS_ZYDJQT); END; 26 10:42:06 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 27 10:42:06 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2752652 28 10:42:06 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6583474.000000 29 10:42:06 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 30 10:42:06 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1605857.000000 31 10:42:06 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王文进 32 10:42:06 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 33 10:42:06 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 653.000000 34 10:42:06 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 实达巨龙 35 10:42:06 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.000000 36 10:42:06 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20552917.000000 37 10:42:06 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 10:42:06 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 10:42:06 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 10:42:06 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 41 10:42:06 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 10:42:06 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 10:42:06 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; 44 10:42:06 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where brid00=1605857 and ZT0000='1' 45 10:42:06 SQL Execute: ORACLE - commit 46 10:42:07 SQL Data In: ORACLE - Rows affected = 0 47 10:42:07 SQL Execute: ORACLE - select count(1) num from YF_MZCF00 where CFLSH0='2226246 ' and YFBMBH in (1067) 48 10:42:07 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZSF_FYGL_0005' and SFQY00='1' 49 10:42:07 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00='YF_WZTCAJK' 50 10:42:11 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||',', ',23,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '23') AND (INSTR (',' || a.jsksbh || ',',',23,') > 0 or a.jsksbh is null) 51 10:42:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2226246 52 10:42:12 SQL Execute: ORACLE - select * from VW_SF_CFMX00 a where trim(a.CFLSH0)=? 53 10:42:31 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||',', ',23,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '23') AND (INSTR (',' || a.jsksbh || ',',',23,') > 0 or a.jsksbh is null) 54 10:42:41 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||',', ',23,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',653,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =653 AND b.JSKSBH = '23') AND (INSTR (',' || a.jsksbh || ',',',23,') > 0 or a.jsksbh is null)