1 17:48:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 2800255 2 17:48:52 SQL Execute: ORACLE - SELECT * FROM VW_YS_YXGH00 WHERE GHH000=? 3 17:48:57 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 4 17:48:57 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 5 17:48:57 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 6 17:48:57 SQL Execute: ORACLE - Select SYSDATE from Dual 7 17:48:57 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 8 17:48:57 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') 9 17:48:57 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222142600409615' and ICKNBH = '0222142600409615' 10 17:48:57 SQL Execute: ORACLE - select ZDMC00, count(*) COU from BM_TYZD00 where ZDMC00='医技挂号类别' or (ZDMC00='体检挂号类别' and PYSM00='474' ) group by ZDMC00 11 17:48:57 SQL Execute: ORACLE - select LBMC00,LBBH00 from BM_GHLBB0 where lbbh00 in (select XSXH00 from BM_TYZD00 where ZDMC00='医技挂号类别') or lbbh00 = 33 12 17:48:57 SQL Execute: ORACLE - select brxm00,brcsrq,brxb00,fbmc00,sfyd00 from bm_brxxb0 a,bm_brfbb0 b where a.fbbh00=b.fbbh00 and brid00=676739 13 17:48:57 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 676739.000000 14 17:48:57 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 15 17:48:57 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 16 17:48:57 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 17 17:48:57 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 18 17:48:57 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 19 17:48:57 SQL Data In: ORACLE - Param = 7, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 20 17:48:57 SQL Data In: ORACLE - Param = 8, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 21 17:48:57 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END; 22 17:48:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 23 17:48:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101 24 17:48:57 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0,a.FWMC00,a.BWMC00 from YS_BRZDXX a, XT_ICD900 b where a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? and exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?) 25 17:48:57 SQL Execute: ORACLE - select brblh0,fbbh00 from bm_brxxb0 where brid00=676739 26 17:48:57 SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222142600409615 27 17:48:57 SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 17:48:57 SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 住院挂号 29 17:48:57 SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 676739.000000 30 17:48:57 SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 31 17:48:57 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈灿宇 32 17:48:57 SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 33 17:48:57 SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120129 34 17:48:57 SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 35 17:48:57 SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 36 17:48:57 SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 37 17:48:57 SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 38 17:48:57 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 39 17:48:57 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = admin 40 17:48:57 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 41 17:48:57 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000 42 17:48:57 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 43 17:48:57 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 5, Scale = 0, Data = admin 44 17:48:57 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 17:48:57 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 17:48:57 SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 17:48:57 SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 48 17:48:57 SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 49 17:48:57 SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 17:48:57 SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 51 17:48:57 SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 52 17:48:57 SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 53 17:48:57 SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 17:48:57 SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 55 17:48:57 SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 56 17:48:57 SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 57 17:48:57 SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 58 17:48:57 SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 17:48:57 SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 60 17:48:57 SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 17:48:57 SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 62 17:48:57 SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 63 17:48:57 SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 64 17:48:57 SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 65 17:48:57 SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 66 17:48:57 SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 67 17:48:57 SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 17:48:57 SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 17:48:57 SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 17:48:57 SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 71 17:48:57 SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 17:48:57 SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 73 17:48:57 SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 74 17:48:57 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 75 17:48:57 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 17:48:57 SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 77 17:48:57 SQL Data In: ORACLE - Param = 52, Name = as_SFHSGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 78 17:48:57 SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,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,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00,as_SFHSGH => :as_SFHSGH); END;