1 11:02:52 SQL Execute: ORACLE - select lengthb('') LENGTH from dual 2 11:02:52 SQL Execute: ORACLE - select 1 from SF_BRXXB0 where THBZ00='0' and GHID00 in (133430766) 3 11:02:52 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='117280453' and LBBH00='0' 4 11:02:52 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='16579089' and ZT0000='1' 5 11:02:52 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='16579089' and ZT0000='1' 6 11:02:52 SQL Execute: ORACLE - Select SYSDATE from Dual 7 11:02:52 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') 8 11:02:52 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 9 11:02:52 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT82620023432' and ICKNBH = 'PTYBPT82620023432' 10 11:02:52 SQL Execute: ORACLE - select count(1) CNT from VW_YS_XZZCY0 where VALUE0='1' and YPNM00=3289 11 11:02:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3289 12 11:02:52 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 13 11:02:53 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3289 and MZZYBZ in('0','2') 14 11:02:53 SQL Execute: ORACLE - Delete from YS_CFMX00_TEMP where cflsh0='18470283' 15 11:02:53 SQL Data In: ORACLE - Rows affected = 0 16 11:02:53 SQL Execute: ORACLE - insert into YS_CFMX00_TEMP(GHID00,CFLSH0,YFBMBH,CFID00,YPNM00,YPMC00,YPZSL0,ZHL000,LSDJ00)Values ('133430766','18470283','160',0,'3289','阿胶','3','1','3.3038') 17 11:02:53 SQL Data In: ORACLE - Rows affected = 1 18 11:02:53 SQL Execute: ORACLE - commit 19 11:02:53 SQL Data In: ORACLE - Rows affected = 0 20 11:02:53 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3289 21 11:02:53 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='18470283' and cfid00 not in (-1) 22 11:02:53 SQL Data In: ORACLE - Rows affected = 0 23 11:02:53 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, ZJYFID, XMYFMC, YYZF00, SFZBY0,YPZSL0, CFDW00, ZHL000, ZFBL00, YBLB00, THBZ00,TSYS00, CQLY00,ZFFSBZ,GJBZBM)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '18470283','3289','阿胶','g','3.3038','76','','1','g','76','烊化','','N','3','g','1','1','7','0','','','N','T001700233') 24 11:02:53 SQL Data In: ORACLE - Rows affected = 1 25 11:02:53 SQL Execute: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,ZYMRCS,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,YBSSSH,YZYZM0,YPXZ00) Values ('18470283','160','133430766','117280453','16579089','苏景煌','男',0,'1','4476','1260','993','2','0','3','0',0,0,'1',0,'4476',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,9.91,null, '','N','N','','',1,-1, '0', '0', '0', '0','0','','') 26 11:02:53 SQL Data In: ORACLE - Rows affected = 1 27 11:02:53 SQL Execute: ORACLE - select * from XT_YYXX00 28 11:02:53 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 29 11:02:53 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='开处方前' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',993,')>0) order by nvl(a.QYKS00,'0') desc 30 11:02:53 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_BC00_0003' and SFQY00='1' 31 11:02:53 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ,LYKS00,WGCFSX)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19960505',DJH000,YSGZH0,'郑煌森',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ ,'','' from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='18470283' 32 11:02:53 SQL Data In: ORACLE - Rows affected = 1 33 11:02:53 SQL Execute: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00,ZFFSBZ,SQYS00,GJBZBM)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00,a.ZFFSBZ,decode(a.TSYS00,7,4476,0),a.GJBZBM from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='18470283' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 34 11:02:53 SQL Data In: ORACLE - Rows affected = 1 35 11:02:53 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18470283 36 11:02:53 SQL Data In: ORACLE - Param = 2, Name = AD_GHID00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 133430766 37 11:02:53 SQL Data In: ORACLE - Param = 3, Name = AD_YFBMBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 160 38 11:02:53 SQL Data In: ORACLE - Param = 4, Name = AD_CFID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 11:02:53 SQL Data In: ORACLE - Param = 5, Name = AD_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 40 11:02:53 SQL Execute: ORACLE - BEGIN "SP_YF_YPKCSLYKNEW" (AS_CFLSH0 => :AS_CFLSH0,AD_GHID00 => :AD_GHID00,AD_YFBMBH => :AD_YFBMBH,AD_CFID00 => :AD_CFID00,AD_CZBZ00 => :AD_CZBZ00); END; 41 11:02:53 SQL Data In: ORACLE - Param = 1, Name = AD_YSBH00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4476 42 11:02:53 SQL Data In: ORACLE - Param = 2, Name = AD_GHID00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 133430766 43 11:02:53 SQL Data In: ORACLE - Param = 3, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18470283 44 11:02:53 SQL Execute: ORACLE - BEGIN "SP_YS_ZJKLJCFXL" (AD_YSBH00 => :AD_YSBH00,AD_GHID00 => :AD_GHID00,AS_CFLSH0 => :AS_CFLSH0); END; 45 11:02:53 SQL Execute: ORACLE - select SF_YS_YBDZTSXZ_HIS(133430766,4476,993 ) MSG000 from dual 46 11:02:53 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18470283 47 11:02:53 SQL Execute: ORACLE - BEGIN "SP_YS_YWMZCF" (AS_CFLSH0 => :AS_CFLSH0); END; 48 11:02:53 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18470283 49 11:02:53 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 117280453 50 11:02:53 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑煌森 51 11:02:53 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 52 11:02:53 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 53 11:02:53 SQL Execute: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 54 11:02:53 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 11:02:53 SQL Data In: ORACLE - Param = 2, Name = V_GHZYID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 133430766.000000 56 11:02:53 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 57 11:02:53 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 11:02:53 SQL Data In: ORACLE - Param = 5, Name = V_SFZDZD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 59 11:02:53 SQL Data In: ORACLE - Param = 6, Name = P_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18470283 60 11:02:53 SQL Data In: ORACLE - Param = 7, Name = P_YSBH00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4476 61 11:02:53 SQL Execute: ORACLE - BEGIN "SP_XT_TSXZ00" (V_FLAG00 => :V_FLAG00,V_GHZYID => :V_GHZYID,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_SFZDZD => :V_SFZDZD,P_CFLSH0 => :P_CFLSH0,P_YSBH00 => :P_YSBH00); END; 62 11:02:53 SQL Execute: ORACLE - select SF_YS_GETTSBZTSXX_ZZCF('18470283','') TSXX00 from DUAL 63 11:02:53 SQL Execute: ORACLE - Commit 64 11:02:53 SQL Data In: ORACLE - Rows affected = 0 65 11:02:53 SQL Execute: ORACLE - select * from XT_YYXX00 66 11:02:53 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 67 11:02:53 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='开处方' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',993,')>0) order by nvl(a.QYKS00,'0') desc 68 11:02:53 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_BC00_0004' and SFQY00='1' 69 11:02:53 SQL Execute: ORACLE - select * from XT_YYXX00 70 11:02:53 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 71 11:02:53 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='事前事中保存' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',993,')>0) order by nvl(a.QYKS00,'0') desc 72 11:02:53 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 73 11:02:53 SQL Execute: ORACLE - select VALUE0,SF_BM_SQXQTSXX('YS_YBSQSZSQ','0',4476) TSXX00,SF_SF_GETYYID00() YYID00 from XT_XTCS00 where name00='YS_YBSQSZSQ' 74 11:02:53 SQL Execute: ORACLE - select SF_WBJK_GETSQSHURL(0,133430766,'1','0','18470283','0',4476,993) URL from dual 75 11:02:54 SQL Execute: ORACLE - select * from XT_YYXX00 76 11:02:54 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 77 11:02:54 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='CA门诊医嘱保存' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',993,')>0) order by nvl(a.QYKS00,'0') desc 78 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18470283 79 11:02:54 SQL Execute: ORACLE - select rownum,a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL ,a.GJBZBM ,(select GJBZMC from BM_YD0000 where YPNM00=a.YPNM00) GJBZMC ,(select GZDJ00 from BM_YD0000 where YPNM00=a.YPNM00) GZDJ00 from YS_CFMX00 a,ys_CFXXB0 b where a.CFLSH0=? AND a.cflsh0=b.cflsh0 order by a.ZB0000,a.CFID00 80 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18470283 81 11:02:54 SQL Execute: ORACLE - select a.*, nvl((select '颗粒药房' from BM_TYZD00 where ZDMC00='厂家颗粒药房对应' and BH0000=a.YFBMBH),' ') QTYFMC,(select SFKSLY from YF_MZCF00 where CFLSH0=a.CFLSH0) SFKSLY from YS_CFXXB0 a where CFLSH0=? and YPDLBH in ('2') and CFXZ00='0' 82 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18470283 83 11:02:54 SQL Execute: ORACLE - select CFZT00,YSXM00 from YF_MZCF00 where cflsh0=? 84 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18470283 85 11:02:54 SQL Execute: ORACLE - select rownum,a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL ,a.GJBZBM ,(select GJBZMC from BM_YD0000 where YPNM00=a.YPNM00) GJBZMC ,(select GZDJ00 from BM_YD0000 where YPNM00=a.YPNM00) GZDJ00 from YS_CFMX00 a,ys_CFXXB0 b where a.CFLSH0=? AND a.cflsh0=b.cflsh0 order by a.ZB0000,a.CFID00 86 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 76 87 11:02:54 SQL Execute: ORACLE - select * from BM_YPYF00 where YFID00=? 88 11:02:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 89 11:02:54 SQL Execute: ORACLE - select * from VW_BM_PC0000 where PCID00=? 90 11:02:54 SQL Execute: ORACLE - select count(1) from YS_CFXXB0 where GHH000='117280453' and to_number(CFLSH0)to_number('18470283') and YPDLBH in ('2') and CFXZ00='0' and rownum=1 91 11:02:54 SQL Execute: ORACLE - select 1 from yj_yw0000 a, YS_ZYBZLZ b where a.zlxmid=b.zlxmid and a.mzzybz='0' and a.zyghid=133430766 and a.sl0000>0 and not exists(select 1 from yj_yw0000 where zyghid=a.zyghid and cxdjh0=a.yjdjh0) 92 11:02:54 SQL Execute: ORACLE - select * from VW_YS_ZYBZLZ a where SF_YS_ZYBZLZLB(4476,a.MRGHLB,133430766)=1 order by XSXH00 93 11:02:59 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 11:02:59 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41381.000000 95 11:02:59 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 133430766.000000 96 11:02:59 SQL Data In: ORACLE - Param = 4, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 97 11:02:59 SQL Data In: ORACLE - Param = 5, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 11:02:59 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 99 11:02:59 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 100 11:02:59 SQL Data In: ORACLE - Param = 8, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 101 11:02:59 SQL Data In: ORACLE - Param = 9, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4476.000000 102 11:02:59 SQL Data In: ORACLE - Param = 10, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 993.000000 103 11:02:59 SQL Data In: ORACLE - Param = 11, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 993.000000 104 11:02:59 SQL Data In: ORACLE - Param = 12, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 105 11:02:59 SQL Data In: ORACLE - Param = 13, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 106 11:02:59 SQL Data In: ORACLE - Param = 14, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 107 11:02:59 SQL Data In: ORACLE - Param = 15, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4476.000000 108 11:02:59 SQL Data In: ORACLE - Param = 16, Name = PSM0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 109 11:02:59 SQL Data In: ORACLE - Param = 17, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 11:02:59 SQL Data In: ORACLE - Param = 18, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 111 11:02:59 SQL Data In: ORACLE - Param = 19, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 112 11:02:59 SQL Data In: ORACLE - Param = 20, Name = PBRID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 113 11:02:59 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 114 11:02:59 SQL Data In: ORACLE - Param = 22, Name = PBWBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 115 11:02:59 SQL Execute: ORACLE - BEGIN "SP_YS_JCSQWH_SF" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PSM0000 => :PSM0000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,PBRID00 => :PBRID00,PBH0000 => :PBH0000,PBWBH00 => :PBWBH00); END; 116 11:02:59 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36752894.000000 117 11:02:59 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 118 11:02:59 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 119 11:02:59 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 120 11:02:59 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1018 121 11:02:59 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 993.000000 122 11:02:59 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 123 11:02:59 SQL Execute: ORACLE - Commit 124 11:02:59 SQL Data In: ORACLE - Rows affected = 0 125 11:02:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 117280453 126 11:02:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 117280453 127 11:02:59 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 128 11:02:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16579089 129 11:02:59 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 130 11:02:59 SQL Execute: ORACLE - select a.ZDMC00 from ys_brzdxx A,BM_TYZD00 b where a.ghid00=133430766 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制' and b.BZ0000=(select min(b.BZ0000) from ys_brzdxx A,BM_TYZD00 b where a.ghid00=133430766 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制') and rownum=1