1 16:33:32 SQL Execute: ORACLE - Select SYSDATE from Dual 2 16:33:32 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 16:33:32 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 16:33:32 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYB350110627398' and ICKNBH ='FZYB350110627398' 5 16:33:32 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =1492635 6 16:33:32 SQL Execute: ORACLE - select count(1) from yf_mzcf00 a,yf_mzcfmx b where a.cflsh0=b.cflsh0 and GHH000='4706641' and ((ypzsl0>0 and cfzt00 not in ('0','3','4')) or (ypzsl0<0 and cfzt00 not in ('3')) ) group by ypnm00 having sum(ypzsl0)>0 7 16:33:32 SQL Execute: ORACLE - select count(1) from yj_yw0000 where mzzybz='0' and ZYHGHH='4706641' and ((sl0000>0 and xmzt00 not in ('0','1','6')) or (sl0000<0 and xmzt00 not in ('6')) ) group by zlxmid having sum(sl0000)>0 8 16:33:32 SQL Execute: ORACLE - select count(*) from yj_yw0000 where mzzybz='0' and ZYHGHH='4706641' and sl0000>0 and xmzt00 in ('0','1') 9 16:33:32 SQL Execute: ORACLE - select count(*) from yf_mzcf00 where GHH000='4706641' and cfzje0>0 and cfzt00 in ('0','4') 10 16:33:32 SQL Execute: ORACLE - Update yj_yw0000 set xmzt00='6' where ZYHGHH='4706641' and mzzybz='0' and sl0000>0 and xmzt00 in ('0','1') 11 16:33:32 SQL Data In: ORACLE - Rows affected = 0 12 16:33:32 SQL Execute: ORACLE - Update yf_mzcf00 set cfzt00='3' where GHH000='4706641' and cfzje0>0 and cfzt00 in ('0','4') 13 16:33:32 SQL Data In: ORACLE - Rows affected = 0 14 16:33:32 SQL Execute: ORACLE - Update sf_brxxb0 set thBZ00='1' where GHH000='4706641' 15 16:33:32 SQL Data In: ORACLE - Rows affected = 1 16 16:33:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1492635.000000 17 16:33:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4706641 18 16:33:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 16:33:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 20 16:33:32 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?)SFZRZY from dual 21 16:33:32 SQL Data In: ORACLE - Param = 1, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 22 16:33:32 SQL Data In: ORACLE - Param = 2, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 23 16:33:32 SQL Data In: ORACLE - Param = 3, Name = AS_ICKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 16:33:32 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4706641 25 16:33:32 SQL Data In: ORACLE - Param = 5, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 16:33:32 SQL Data In: ORACLE - Param = 6, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 030392310 27 16:33:32 SQL Data In: ORACLE - Param = 7, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 副主任医师 28 16:33:32 SQL Data In: ORACLE - Param = 8, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 29 16:33:32 SQL Data In: ORACLE - Param = 9, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 朱成相 30 16:33:32 SQL Data In: ORACLE - Param = 10, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 31 16:33:32 SQL Data In: ORACLE - Param = 11, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19750416 32 16:33:32 SQL Data In: ORACLE - Param = 12, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保 33 16:33:32 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000 34 16:33:32 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 35 16:33:32 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 36 16:33:32 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 142.000000 37 16:33:32 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000 38 16:33:32 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 39 16:33:32 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 40 16:33:32 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 41 16:33:32 SQL Data In: ORACLE - Param = 21, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 42 16:33:32 SQL Data In: ORACLE - Param = 22, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 43 16:33:32 SQL Data In: ORACLE - Param = 23, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 44 16:33:32 SQL Data In: ORACLE - Param = 24, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 45 16:33:32 SQL Data In: ORACLE - Param = 25, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 46 16:33:32 SQL Data In: ORACLE - Param = 26, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 16:33:32 SQL Data In: ORACLE - Param = 27, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 48 16:33:32 SQL Data In: ORACLE - Param = 28, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 16:33:32 SQL Data In: ORACLE - Param = 29, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 16:33:32 SQL Data In: ORACLE - Param = 30, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 51 16:33:32 SQL Data In: ORACLE - Param = 31, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 16:33:32 SQL Data In: ORACLE - Param = 32, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 53 16:33:32 SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX_EDIT00" (AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_GHH000 => :AS_GHH000,AS_YBGHH0 => :AS_YBGHH0,AS_BRBLH0 => :AS_BRBLH0,AS_GHLBMC => :AS_GHLBMC,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 54 16:33:32 SQL Execute: ORACLE - Commit 55 16:33:32 SQL Data In: ORACLE - Rows affected = 0