1 15:52:27 SQL Prepare: ORACLE - select sum(b.ZFJE00) from YF_MZCF00 a,YF_MZCFMX b where a.GHH000=:1 and a.cfzt00 in ('0') and a.YFBMBH IN(140,141,1700,2698,3518) and a.cflsh0=b.cflsh0 2 15:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 10855310 3 15:52:27 SQL Execute: ORACLE - select sum(b.ZFJE00) from YF_MZCF00 a,YF_MZCFMX b where a.GHH000=? and a.cfzt00 in ('0') and a.YFBMBH IN(140,141,1700,2698,3518) and a.cflsh0=b.cflsh0 4 15:52:27 SQL Prepare: ORACLE - select ZYE000,ZYE001 from VW_YS_BRXXB0 where brid00=:1 5 15:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1501 6 15:52:27 SQL Execute: ORACLE - select ZYE000,ZYE001 from VW_YS_BRXXB0 where brid00=? 7 15:52:27 SQL Prepare: ORACLE - select distinct YFBMBH YFBMBH,TSBZBH FROM YF_MZCF00 A WHERE GHID00=18462250 AND BCCFH0 IS NULL AND NOT EXISTS (SELECT 1 FROM YF_MZCF00 WHERE GHID00=18462250 and BCCFH0= A.CFLSH0) AND CFZJE0>0 AND CFZT00 = '0' and A.YFBMBH IN (140,141,1700,2698,3518) and nvl(BZ0000,' ') not like '%诊疗项目带出处方%' 8 15:52:27 SQL Execute: ORACLE - select distinct YFBMBH YFBMBH,TSBZBH FROM YF_MZCF00 A WHERE GHID00=18462250 AND BCCFH0 IS NULL AND NOT EXISTS (SELECT 1 FROM YF_MZCF00 WHERE GHID00=18462250 and BCCFH0= A.CFLSH0) AND CFZJE0>0 AND CFZT00 = '0' and A.YFBMBH IN (140,141,1700,2698,3518) and nvl(BZ0000,' ') not like '%诊疗项目带出处方%' 9 15:52:34 SQL Prepare: ORACLE - select CFLSH0,YFBMBH,A.GHH000,TSBZBH FROM YF_MZCF00 A WHERE GHID00=18462250 AND BCCFH0 IS NULL AND NOT EXISTS (SELECT 1 FROM YF_MZCF00 WHERE GHID00=18462250 and BCCFH0= A.CFLSH0) AND CFZJE0>0 AND CFZT00 = '0' AND YFBMBH=140 and nvl(BZ0000,' ') not like '%诊疗项目带出处方%' and TSBZBH is null 10 15:52:34 SQL Execute: ORACLE - select CFLSH0,YFBMBH,A.GHH000,TSBZBH FROM YF_MZCF00 A WHERE GHID00=18462250 AND BCCFH0 IS NULL AND NOT EXISTS (SELECT 1 FROM YF_MZCF00 WHERE GHID00=18462250 and BCCFH0= A.CFLSH0) AND CFZJE0>0 AND CFZT00 = '0' AND YFBMBH=140 and nvl(BZ0000,' ') not like '%诊疗项目带出处方%' and TSBZBH is null 11 15:52:34 SQL Prepare: ORACLE - SELECT SQ_SF_BRJFB0_DJH000.NEXTVAL P_DJH00 FROM DUAL 12 15:52:34 SQL Execute: ORACLE - SELECT SQ_SF_BRJFB0_DJH000.NEXTVAL P_DJH00 FROM DUAL 13 15:52:34 SQL Prepare: ORACLE - BEGIN "SP_SF_YFCFJZ" (as_CFLSH0 => :as_CFLSH0,ad_DJH000 => :ad_DJH000,ad_SFCKBH => :ad_SFCKBH,ad_PYCKBH => :ad_PYCKBH,ad_FYCKBH => :ad_FYCKBH,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 14 15:52:34 SQL Misc: ORACLE - Set stored procedure on or off 15 15:52:34 SQL Data In: ORACLE - Param = 1, Name = as_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14255142 16 15:52:34 SQL Data In: ORACLE - Param = 2, Name = ad_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1052602710.000000 17 15:52:34 SQL Data In: ORACLE - Param = 3, Name = ad_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 18 15:52:34 SQL Data In: ORACLE - Param = 4, Name = ad_PYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 19 15:52:34 SQL Data In: ORACLE - Param = 5, Name = ad_FYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 20 15:52:34 SQL Data In: ORACLE - Param = 6, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 15:52:34 SQL Data In: ORACLE - Param = 7, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 15:52:34 SQL Execute: ORACLE - BEGIN "SP_SF_YFCFJZ" (as_CFLSH0 => :as_CFLSH0,ad_DJH000 => :ad_DJH000,ad_SFCKBH => :ad_SFCKBH,ad_PYCKBH => :ad_PYCKBH,ad_FYCKBH => :ad_FYCKBH,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 23 15:52:34 SQL Prepare: 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; 24 15:52:34 SQL Misc: ORACLE - Set stored procedure on or off 25 15:52:34 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 15:52:34 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10855310 27 15:52:34 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18462250.000000 28 15:52:34 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 29 15:52:34 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1501.000000 30 15:52:34 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林珍红 31 15:52:34 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 32 15:52:34 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 115.000000 33 15:52:34 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林晋浩 34 15:52:34 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 140.000000 35 15:52:34 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1052602710.000000 36 15:52:34 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 15:52:34 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 15:52:34 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 15:52:34 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 15:52:34 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 15:52:34 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 15:52:34 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; 43 15:52:34 SQL Prepare: ORACLE - Commit 44 15:52:34 SQL Execute: ORACLE - Commit 45 15:52:34 SQL Data In: ORACLE - Rows affected = 0 46 15:52:34 SQL Prepare: ORACLE - select 1 from yf_cfdl00 a, yf_mzcf00 b where a.cflsh0=b.cflsh0 and b.cfzt00 in ('1','2') and not exists (select 1 from yf_mzcf00 where BCCFH0=b.cflsh0) and b.cfzje0>0 and b.ghid00=18462250 and b.YFBMBH IN (140,141,1700,2698,3518) 47 15:52:34 SQL Execute: ORACLE - select 1 from yf_cfdl00 a, yf_mzcf00 b where a.cflsh0=b.cflsh0 and b.cfzt00 in ('1','2') and not exists (select 1 from yf_mzcf00 where BCCFH0=b.cflsh0) and b.cfzje0>0 and b.ghid00=18462250 and b.YFBMBH IN (140,141,1700,2698,3518) 48 15:52:34 SQL Prepare: ORACLE - select b.cflsh0,a.fydlxh,(select ckmc00 from bm_ckbm00 where ckbh00(+)=a.fyckbh) fyck00,b.BRXM00, (select bmmc00 from bm_bmbm00 where bmbh00(+)=b.yfbmbh) fyyf00 from yf_cfdl00 a, yf_mzcf00 b where a.cflsh0=b.cflsh0 and b.cfzt00 in ('1','2') and not exists (select 1 from yf_mzcf00 where BCCFH0=b.cflsh0) and b.cfzje0>0 and b.ghid00=18462250 and b.YFBMBH IN (140,141,1700,2698,3518) 49 15:52:34 SQL Execute: ORACLE - select b.cflsh0,a.fydlxh,(select ckmc00 from bm_ckbm00 where ckbh00(+)=a.fyckbh) fyck00,b.BRXM00, (select bmmc00 from bm_bmbm00 where bmbh00(+)=b.yfbmbh) fyyf00 from yf_cfdl00 a, yf_mzcf00 b where a.cflsh0=b.cflsh0 and b.cfzt00 in ('1','2') and not exists (select 1 from yf_mzcf00 where BCCFH0=b.cflsh0) and b.cfzje0>0 and b.ghid00=18462250 and b.YFBMBH IN (140,141,1700,2698,3518) 50 15:52:37 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=115 and ghksbh=1960 51 15:52:37 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=115 and ghksbh=1960 52 15:52:37 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=115 and jzks00=1960 53 15:52:37 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=115 and jzks00=1960