1 10:52:35 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1 2 10:52:35 SQL Execute: ORACLE - commit 3 10:52:35 SQL Data In: ORACLE - Rows affected = 0 4 10:52:35 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='' and SFXYZD='1' and ZDXXID not in (-1) 5 10:52:35 SQL Data In: ORACLE - Rows affected = 0 6 10:52:35 SQL Execute: ORACLE - insert into YS_BRZDXX (ZDXXID, GHID00, GHH000,ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM,JZKS00,ZDMC00, SFYZ00, SFXYZD,ZDRQ00,ZDSJ00)Values (SQ_YS_BRZDXX_ZDXXID.nextval, 3146959 ,'999999999999','3','J39.900','','736','王长兴','1069','上呼吸道疾病','0','1',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS')) 7 10:52:35 SQL Data In: ORACLE - Rows affected = 1 8 10:52:35 SQL Execute: ORACLE - Delete YS_BRZDXX where GHH000='' and SFXYZD='0' and ZDXXID not in (-1) 9 10:52:35 SQL Data In: ORACLE - Rows affected = 0 10 10:52:35 SQL Execute: ORACLE - select SF_YS_GHZDXZ(10004,736,3146959,'N','0',2857800,1069) from dual 11 10:52:35 SQL Execute: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00)Values('',3146959,SQ_YS_BRBQB0_BRBQID.Nextval,'999999999999',736,0,to_char(sysdate,'yyyymmddhh24'),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'王长兴','20210126') 12 10:52:35 SQL Data In: ORACLE - Rows affected = 1 13 10:52:35 SQL Execute: ORACLE - commit 14 10:52:35 SQL Data In: ORACLE - Rows affected = 0 15 10:52:35 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2857800.000000 16 10:52:35 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10004 17 10:52:35 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1069.000000 18 10:52:35 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 19 10:52:35 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 20 10:52:35 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 21 10:52:35 SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 22 10:52:35 SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 23 10:52:35 SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 10:52:35 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END; 25 10:52:35 SQL Execute: ORACLE - select BRZTQK from VW_BM_BRXXB0 where BRID00='2857800' 26 10:52:35 SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1 27 10:52:35 SQL Execute: ORACLE - select GHHBID from sf_ysghhb where GHKSBH=1069 and GHYSBH=736 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') order by ghjssj 28 10:52:35 SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198310264755 29 10:52:35 SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 10:52:35 SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 本院职工 31 10:52:35 SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2857800.000000 32 10:52:35 SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 33 10:52:35 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 胡锡峰 34 10:52:35 SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 35 10:52:35 SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19831026 36 10:52:35 SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保 37 10:52:35 SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 38 10:52:35 SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 39 10:52:35 SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 40 10:52:35 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 736.000000 41 10:52:35 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王长兴 42 10:52:35 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1068.000000 43 10:52:35 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1069.000000 44 10:52:35 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 736.000000 45 10:52:35 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王长兴 46 10:52:35 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 10:52:35 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 48 10:52:35 SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 49 10:52:35 SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 10:52:35 SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 51 10:52:35 SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 52 10:52:35 SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 53 10:52:35 SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 10:52:35 SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 55 10:52:35 SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 10:52:35 SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 10:52:35 SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 58 10:52:35 SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 10:52:35 SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 60 10:52:35 SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 10:52:35 SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 10:52:35 SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 63 10:52:35 SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 64 10:52:35 SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 10:52:35 SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 66 10:52:35 SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 67 10:52:35 SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 68 10:52:35 SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 69 10:52:35 SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 10:52:35 SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 71 10:52:35 SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 10:52:35 SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 73 10:52:35 SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 74 10:52:35 SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 75 10:52:35 SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1594538 76 10:52:35 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 10:52:35 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 10:52:35 SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 79 10:52:35 SQL Data In: ORACLE - Param = 52, Name = AS_SFJZLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 80 10:52:35 SQL Data In: ORACLE - Param = 53, Name = as_ZSQGFF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 81 10:52:35 SQL Data In: ORACLE - Param = 54, Name = as_SFZRZY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 82 10:52:35 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_SFJZLB => :AS_SFJZLB,as_ZSQGFF => :as_ZSQGFF,as_SFZRZY => :as_SFZRZY); END; 83 10:52:35 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='1594538' and HZZT00 in ('0','2','4') 84 10:52:35 SQL Data In: ORACLE - Rows affected = 1 85 10:52:35 SQL Execute: ORACLE - update SF_BRXXB0 set SFSH00='0' where GHH000='1594538' 86 10:52:35 SQL Data In: ORACLE - Rows affected = 1 87 10:52:35 SQL Execute: ORACLE - select ghid00,LBBH00 from SF_BRXXB0 where ghh000='1594538' 88 10:52:35 SQL Execute: ORACLE - update YS_BRZDXX set GHID00=3146960 WHERE GHID00=3146959 89 10:52:35 SQL Data In: ORACLE - Rows affected = 1 90 10:52:35 SQL Execute: ORACLE - COMMIT 91 10:52:35 SQL Data In: ORACLE - Rows affected = 0 92 10:52:35 SQL Execute: ORACLE - select SF_YS_SXZZDJZ(2857800,1069,736) SXZZ00 from dual 93 10:52:35 SQL Execute: ORACLE - update YS_BRZZSQ set GHID00=3146960 where ID0000=30 94 10:52:35 SQL Data In: ORACLE - Rows affected = 1 95 10:52:35 SQL Execute: ORACLE - commit 96 10:52:35 SQL Data In: ORACLE - Rows affected = 0 97 10:52:35 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00,SF_SF_GETYYID00() YYID00 from XT_XTCS00 where name00='SXZZ_JKSQDM' 98 10:52:35 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SXZZ_CJDM' 99 10:52:35 SQL Execute: ORACLE - select b.brdh00,b.YBKH00,b.BRJTDZ,b.BRZJBH,b.BRCSRQ,b.BRXB00,b.BRXM00,a.*,(select BMMC00 from BM_BMBM00 where BMBH00=1069) BMMC00 from sf_brxxb0 a,bm_brxxb0 b where a.brid00=b.brid00 and a.ghid00='3146960' 100 10:52:35 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='双向转诊' 101 10:52:35 SQL Execute: ORACLE - select ZZQZD0,BQZY00,BZ0000,SQYSDH,ZZLBMC,JGMC00,MSGID0,DAH000,JSYSXM,JSKSMC,SQRQ00,SQSJ00,SQDH00,ZT0000,SFZH00 from YS_BRZZSQ where LB0000='1' and GHID00='3146960' order by id0000 desc 102 10:52:37 SQL Execute: ORACLE - Update sf_brxxb0 set THBZ00='2' where GHH000='1594538' 103 10:52:37 SQL Data In: ORACLE - Rows affected = 1 104 10:52:37 SQL Execute: ORACLE - commit 105 10:52:37 SQL Data In: ORACLE - Rows affected = 0 106 10:52:37 SQL Execute: ORACLE - commit 107 10:52:37 SQL Data In: ORACLE - Rows affected = 0 108 10:52:37 SQL Execute: ORACLE - select * from ys_brzdxx where ghid00=3146960 109 10:52:37 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2857800 110 10:52:37 SQL Data In: ORACLE - Param = 2, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3146960 111 10:52:37 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 736 112 10:52:37 SQL Data In: ORACLE - Param = 4, Name = PCZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 113 10:52:37 SQL Data In: ORACLE - Param = 5, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 114 10:52:37 SQL Execute: ORACLE - BEGIN "SP_YS_GHSMZGL" (PBRID00 => :PBRID00,PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZLX00 => :PCZLX00,PERRMSG => :PERRMSG); END; 115 10:52:37 SQL Execute: ORACLE - select ZDMC00,ZDXXID from YS_BRZDXX where GHID00=3146960 order by zdxxid 116 10:52:37 SQL Execute: ORACLE - select a.*,(select SFKSLY from YF_MZCF00 where CFLSH0=a.CFLSH0) SFKSLY from ys_cfxxb0 a where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000='1594538' and YPDLBH in ('0','1') and CFXZ00='0') 117 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 118 10:52:37 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, DECODE(TRIM(A.ICD900),'', (SELECT SIGN(COUNT(1)) FROM VW_YS_FJCRBZD B WHERE A.ZDMC00 LIKE B.MC0000), (SELECT NVL(MAX(SFCRB0),'0') SFCRB0 FROM XT_ICD900 WHERE ICD900(+)= A.ICD900)) SFCRB0, CRDJID from YS_BRZDXX a where a.SFXYZD='1'and a.GHID00=? 119 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 120 10:52:37 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD from YS_BRZDXX where SFXYZD='0'and GHID00=? 121 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 122 10:52:37 SQL Execute: ORACLE - select * from VW_YS_BRZZXX where GHID00=? 123 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 124 10:52:37 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 125 10:52:37 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2857800)and GHID00<3146960 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2857800)and GHID00>3146960 and rownum=1 126 10:52:37 SQL Execute: ORACLE - select sum(CFZJE0)-sum(nvl((select sum(round(YPZSL0*LSDJ00,2)) from YF_MZCFMX where CFLSH0=a.CFLSH0 and SFZBY0='Y'),0)) from YF_MZCF00 a where GHH000='1594538' and cfzt00 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH='1594538' and MZZYBZ='0' and xmzt00 in ('0','1') 127 10:52:37 SQL Execute: ORACLE - select ZYE000,SFJZFP from VW_YS_BRXXB0 where brid00='2857800' 128 10:52:37 SQL Execute: ORACLE - select BRZTQK from VW_BM_BRXXB0 where BRID00='2857800' 129 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1594538 130 10:52:37 SQL Execute: ORACLE - select SF_YS_GETZD0(?) zdmc00 from dual 131 10:52:37 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=1069 order by mrbz00 desc 132 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 133 10:52:37 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, DECODE(TRIM(A.ICD900),'', (SELECT SIGN(COUNT(1)) FROM VW_YS_FJCRBZD B WHERE A.ZDMC00 LIKE B.MC0000), (SELECT NVL(MAX(SFCRB0),'0') SFCRB0 FROM XT_ICD900 WHERE ICD900(+)= A.ICD900)) SFCRB0, CRDJID from YS_BRZDXX a where a.SFXYZD='1'and a.GHID00=? 134 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 135 10:52:37 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD from YS_BRZDXX where SFXYZD='0'and GHID00=? 136 10:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 137 10:52:37 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 138 10:52:37 SQL Execute: ORACLE - select ZDMC00,ZDXXID from YS_BRZDXX where GHID00=3146960 order by zdxxid 139 10:52:37 SQL Execute: ORACLE - select a.*,(select SFKSLY from YF_MZCF00 where CFLSH0=a.CFLSH0) SFKSLY from ys_cfxxb0 a where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000='1594538' and YPDLBH in ('0','1') and CFXZ00='0') 140 10:52:37 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00='本院职工' 141 10:52:37 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2857800.000000 142 10:52:37 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 143 10:52:37 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 144 10:52:37 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 145 10:52:37 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = X 146 10:52:37 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 736.000000 147 10:52:37 SQL Data In: ORACLE - Param = 7, Name = V_TAB000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 148 10:52:37 SQL Execute: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0,V_TAB000 => :V_TAB000); END; 149 10:52:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 150 10:52:39 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, DECODE(TRIM(A.ICD900),'', (SELECT SIGN(COUNT(1)) FROM VW_YS_FJCRBZD B WHERE A.ZDMC00 LIKE B.MC0000), (SELECT NVL(MAX(SFCRB0),'0') SFCRB0 FROM XT_ICD900 WHERE ICD900(+)= A.ICD900)) SFCRB0, CRDJID from YS_BRZDXX a where a.SFXYZD='1'and a.GHID00=? 151 10:52:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 152 10:52:39 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD from YS_BRZDXX where SFXYZD='0'and GHID00=? 153 10:52:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3146960.000000 154 10:52:39 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 155 10:52:39 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2857800)and GHID00<3146960 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=2857800)and GHID00>3146960 and rownum=1 156 11:04:09 Log started for: 药房管理系统