1 10:53:00 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 2 10:53:00 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 3 10:53:00 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 4 10:53:00 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5 10:53:00 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = JYJC 6 10:53:00 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 7 10:53:00 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); END; 8 10:53:01 SQL Execute: ORACLE - select ZJYFMC,YFID00 from vw_BM_YPZJYF 9 10:53:01 SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=1 and mbgs00='0') or (symbks=57 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') order by MBGS00 desc,nvl(FYID00,'0'),MBLBBH 10 10:53:01 SQL Execute: ORACLE - select b.* from xt_yzmblb a,vw_xt_yzmb00 b where a.mblbid=b.mblbid and ((a.symbys=1 and a.mbgs00='0') or (a.symbks=57 and a.mbgs00='1') or (a.symbys=0 and a.symbks=0 and a.mbgs00='2')) and b.MBNRBZ like '%诊%' 11 10:53:03 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and ((symbys=1) or (symbks=57) or (symbys=0 and symbks=0))) and MBNRBZ like '%诊%' order by mbmc00 12 10:53:03 SQL Execute: ORACLE - select 1 FLAG00,x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=21619 and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) order by xsxh00 13 10:53:05 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00001'and ((symbys=1) or (symbks=57) or (symbys=0 and symbks=0))) and MBNRBZ like '%诊%' order by mbmc00 14 10:53:05 SQL Execute: ORACLE - select 1 FLAG00,x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mbid00=33739 and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) order by xsxh00 15 10:53:06 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,x.mcsl00,x.dw0000,x.bz0000 from vw_xt_zlmbmx x where mxid00 in (-1,65286) order by xsxh00 16 10:53:10 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='11377808' and LBBH00='0' 17 10:53:10 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='8235865' and ZT0000='1' 18 10:53:10 SQL Execute: ORACLE - Select SYSDATE from Dual 19 10:53:10 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') 20 10:53:10 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '1226793000357750' and ICKNBH = '0226793600080526' 21 10:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 65286 22 10:53:10 SQL Execute: ORACLE - select nvl(a.ts0000,1)*nvl(a.mcsl00,1)*nvl(b.zqcs00,1) zxsl00 from vw_xt_zlmbmx a,vw_bm_pc0000 b where a.pcid00=b.pcid00(+) and MXID00=? 23 10:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 65286 24 10:53:10 SQL Execute: ORACLE - select lbbh00,zlxmid,zlxmjc,nvl(trim(fyid00),'0') fyid00 from bm_zlzd00 where zlxmid=(select zlxmid from xt_zlmbmx where mxid00=?) and tzrq00 is null 25 10:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 26 10:53:10 SQL Execute: ORACLE - select DLKSZX,b.BMBH00,b.bmmc00 from bm_zlzd00 A,bm_bmbm00 b where ZLXMID=? and a.ZXKS00=b.Bmbh00(+) 27 10:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 57 28 10:53:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 29 10:53:10 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJJSKS where SQXMKS=? and ZLXMID=? order by decode(bmbh00,57,0,1),decode(trim(YYID00),'226793',1,2),ksxmid 30 10:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 31 10:53:10 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJZXKS where ZLXMID=? order by decode(BMBH00,57,0,1),decode(trim(YYID00),'226793',1,2),decode(YYFZ00,'',0,1),KSXMID 32 10:53:10 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 33 10:53:10 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 10:53:10 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 35 10:53:10 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15601179 36 10:53:10 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 37 10:53:10 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 10:53:10 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 39 10:53:10 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 40 10:53:10 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 41 10:53:10 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 42 10:53:10 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 43 10:53:10 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 44 10:53:10 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 45 10:53:10 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 46 10:53:10 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 47 10:53:10 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 48 10:53:10 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 49 10:53:10 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 50 10:53:10 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 10:53:10 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 52 10:53:10 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 53 10:53:10 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 10:53:10 SQL Data In: ORACLE - Param = 23, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8235865 55 10:53:10 SQL Data In: ORACLE - Param = 24, Name = PXZKFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 56 10:53:10 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH_JZ" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT,PBRID00 => :PBRID00,PXZKFBZ => :PXZKFBZ); END; 57 10:53:11 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 58 10:53:11 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26126890.000000 59 10:53:11 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 60 10:53:11 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 61 10:53:11 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 62 10:53:11 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_BC00_0005' and SFQY00='1' 63 10:53:11 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 64 10:53:11 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 65 10:53:11 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 10:53:11 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 67 10:53:11 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 68 10:53:11 SQL Execute: ORACLE - commit 69 10:53:11 SQL Data In: ORACLE - Rows affected = 0 70 10:53:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 71 10:53:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 72 10:53:11 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') 73 10:53:13 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 74 10:53:13 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 75 10:53:13 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 76 10:53:13 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 77 10:53:13 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = JYJC 78 10:53:13 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 79 10:53:13 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); END; 80 10:53:13 SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,YPNM00,DCBZ00,CXDJH0,ZJE000,BZ0000,YJLRBZ,KDBQ00,JGZCBZ,BQSFBZ,ZLXMBH,BMMC,BBID00,bh0000,mc0000,ZJXGBZ,TEMPDJH,BBMC00,'0' tempbz,TMZT00 from VW_YS_JYSQYW where ZYHGHH='11377808' order by YJDJH0 81 10:53:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 26126890 82 10:53:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 83 10:53:13 SQL Execute: ORACLE - select a.zlxmjc,a.zxmid0 zlxmid,decode(b.zlxmid,null,'N','Y')gdxmbz,b.jgms00,a.jgdw00, b.ckz000,a.bbid00,a.zyzbid from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=?) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=? order by a.zxmbh0 84 10:53:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 85 10:53:13 SQL Execute: ORACLE - select zyzbid from bm_zlzd00 where zlxmid=? 86 10:53:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 87 10:53:13 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=? AND A.BBID00=B.BBID00 order by a.XH0000 88 10:53:13 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 89 10:53:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 90 10:53:13 SQL Execute: ORACLE - select THBZ00 from SF_BRXXB0 where GHH000=? and GHH000 is not null 91 10:53:13 SQL Execute: ORACLE - select * from XT_YYXX00 92 10:53:13 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 93 10:53:13 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||',',',57,')>0) order by nvl(a.QYKS00,'0') desc 94 10:53:26 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='11377808' and LBBH00='0' 95 10:53:26 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='8235865' and ZT0000='1' 96 10:53:26 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='8235865' and ZT0000='1' 97 10:53:26 SQL Execute: ORACLE - Select SYSDATE from Dual 98 10:53:26 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') 99 10:53:26 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '1226793000357750' and ICKNBH = '0226793600080526' 100 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 26126890 101 10:53:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 102 10:53:26 SQL Execute: ORACLE - select a.zlxmjc,a.zxmid0 zlxmid,decode(b.zlxmid,null,'N','Y')gdxmbz,b.jgms00,a.jgdw00, b.ckz000,a.bbid00,a.zyzbid from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=?) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=? order by a.zxmbh0 103 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 104 10:53:26 SQL Execute: ORACLE - select zyzbid from bm_zlzd00 where zlxmid=? 105 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 106 10:53:26 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=? AND A.BBID00=B.BBID00 order by a.XH0000 107 10:53:26 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 108 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 26126890 109 10:53:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 110 10:53:26 SQL Execute: ORACLE - select a.zlxmjc,a.zxmid0 zlxmid,decode(b.zlxmid,null,'N','Y')gdxmbz,b.jgms00,a.jgdw00, b.ckz000,a.bbid00,a.zyzbid from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=?) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=? order by a.zxmbh0 111 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 112 10:53:26 SQL Execute: ORACLE - select zyzbid from bm_zlzd00 where zlxmid=? 113 10:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 114 10:53:26 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=? AND A.BBID00=B.BBID00 order by a.XH0000 115 10:53:26 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 116 10:53:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 26126890 117 10:53:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 118 10:53:27 SQL Execute: ORACLE - select a.zlxmjc,a.zxmid0 zlxmid,decode(b.zlxmid,null,'N','Y')gdxmbz,b.jgms00,a.jgdw00, b.ckz000,a.bbid00,a.zyzbid from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=?) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=? order by a.zxmbh0 119 10:53:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 120 10:53:27 SQL Execute: ORACLE - select zyzbid from bm_zlzd00 where zlxmid=? 121 10:53:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 122 10:53:27 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=? AND A.BBID00=B.BBID00 order by a.XH0000 123 10:53:27 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 124 10:53:27 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26126890.000000 125 10:53:27 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 126 10:53:27 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 127 10:53:27 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 128 10:53:27 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 129 10:53:27 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 130 10:53:27 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 131 10:53:27 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 132 10:53:27 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 133 10:53:27 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 134 10:53:27 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 135 10:53:27 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 136 10:53:27 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 137 10:53:27 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 138 10:53:27 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 139 10:53:27 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 140 10:53:27 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 141 10:53:27 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 142 10:53:27 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 143 10:53:27 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 144 10:53:27 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 145 10:53:27 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 146 10:53:27 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END; 147 10:53:28 SQL Execute: ORACLE - commit 148 10:53:28 SQL Data In: ORACLE - Rows affected = 0 149 10:53:28 SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,YPNM00,DCBZ00,CXDJH0,ZJE000,BZ0000,YJLRBZ,KDBQ00,JGZCBZ,BQSFBZ,ZLXMBH,BMMC,BBID00,bh0000,mc0000,ZJXGBZ,TEMPDJH,BBMC00,'0' tempbz,TMZT00 from VW_YS_JYSQYW where ZYHGHH='11377808' order by YJDJH0 150 10:53:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 151 10:53:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 152 10:53:28 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') 153 10:53:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8235865 154 10:53:28 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 155 10:53:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 免费号 156 10:53:29 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 157 10:53:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 158 10:53:29 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 159 10:53:29 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 160 10:53:29 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 161 10:53:29 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 162 10:53:29 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 163 10:53:29 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 164 10:53:29 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 165 10:53:29 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 166 10:53:29 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 167 10:53:29 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 168 10:53:29 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 169 10:53:29 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = JYJC 170 10:53:29 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 171 10:53:29 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); END; 172 10:53:29 SQL Execute: ORACLE - select a.ZLXMID,a.ZLXMJC,b.GDBZ00 GDXMBZ,a.ZLXMID TEMPDJH,0 YJDJH0 from BM_ZLZD00 a,XT_ZLSFGX b where a.ZLXMID=b.ZLXMID and 1=3 173 10:53:30 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 174 10:53:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 175 10:53:30 SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,BZ0000,SFJE00,YBLBMC,ZFBL00,BH0000,NBLBMC,NBZFBL,GGBZTS from VW_YS_FBFYYZ a where (PYSM00 Like ?) and( LBBH00='4' and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) ) Order By PYSM00) where Rownum<=100 176 10:53:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19226 177 10:53:30 SQL Execute: ORACLE - select GJBZBM "国家医保编码",GJBZMC "国家医保名称",GG0000 "规格",SFJE00 "单价",SFCS00 "倍数" from VW_BM_ZLSFGX where TZRQ00 is null and GDBZ00='Y' and ZLXMID=? 178 10:53:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = s% 179 10:53:32 SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,BZ0000,SFJE00,YBLBMC,ZFBL00,BH0000,NBLBMC,NBZFBL,GGBZTS from VW_YS_FBFYYZ a where (PYSM00 Like ?) and( LBBH00='4' and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) ) Order By PYSM00) where Rownum<=100 180 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 14326 181 10:53:33 SQL Execute: ORACLE - select GJBZBM "国家医保编码",GJBZMC "国家医保名称",GG0000 "规格",SFJE00 "单价",SFCS00 "倍数" from VW_BM_ZLSFGX where TZRQ00 is null and GDBZ00='Y' and ZLXMID=? 182 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = sh% 183 10:53:33 SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,BZ0000,SFJE00,YBLBMC,ZFBL00,BH0000,NBLBMC,NBZFBL,GGBZTS from VW_YS_FBFYYZ a where (PYSM00 Like ?) and( LBBH00='4' and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) ) Order By PYSM00) where Rownum<=100 184 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 185 10:53:33 SQL Execute: ORACLE - select GJBZBM "国家医保编码",GJBZMC "国家医保名称",GG0000 "规格",SFJE00 "单价",SFCS00 "倍数" from VW_BM_ZLSFGX where TZRQ00 is null and GDBZ00='Y' and ZLXMID=? 186 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = shq% 187 10:53:33 SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,BZ0000,SFJE00,YBLBMC,ZFBL00,BH0000,NBLBMC,NBZFBL,GGBZTS from VW_YS_FBFYYZ a where (PYSM00 Like ?) and( LBBH00='4' and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) ) Order By PYSM00) where Rownum<=100 188 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 189 10:53:33 SQL Execute: ORACLE - select GJBZBM "国家医保编码",GJBZMC "国家医保名称",GG0000 "规格",SFJE00 "单价",SFCS00 "倍数" from VW_BM_ZLSFGX where TZRQ00 is null and GDBZ00='Y' and ZLXMID=? 190 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = shqt% 191 10:53:33 SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,BZ0000,SFJE00,YBLBMC,ZFBL00,BH0000,NBLBMC,NBZFBL,GGBZTS from VW_YS_FBFYYZ a where (PYSM00 Like ?) and( LBBH00='4' and (FYID00=rpad('0',6,' ') or FYID00=rpad('226793',6,' ')) ) Order By PYSM00) where Rownum<=100 192 10:53:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 193 10:53:33 SQL Execute: ORACLE - select GJBZBM "国家医保编码",GJBZMC "国家医保名称",GG0000 "规格",SFJE00 "单价",SFCS00 "倍数" from VW_BM_ZLSFGX where TZRQ00 is null and GDBZ00='Y' and ZLXMID=? 194 10:53:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 195 10:53:34 SQL Execute: ORACLE - select DLKSZX,b.BMBH00,b.bmmc00 from bm_zlzd00 A,bm_bmbm00 b where ZLXMID=? and a.ZXKS00=b.Bmbh00(+) 196 10:53:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 57 197 10:53:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 198 10:53:34 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJJSKS where SQXMKS=? and ZLXMID=? order by decode(bmbh00,57,0,1),decode(trim(YYID00),'226793',1,2),ksxmid 199 10:53:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 200 10:53:34 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJZXKS where ZLXMID=? order by decode(BMBH00,57,0,1),decode(trim(YYID00),'226793',1,2),decode(YYFZ00,'',0,1),KSXMID 201 10:53:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 202 10:53:34 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=? AND A.BBID00=B.BBID00 order by a.XH0000 203 10:53:34 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 204 10:53:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 205 10:53:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 206 10:53:34 SQL Execute: ORACLE - select zlxmjc,a.zxmid0 zlxmid,decode(a.SJLBBZ,'2','Y',a.gdxmbz)gdxmbz ,b.jgms00,a.jgdw00,SJLBBZ,b.ckz000,bbid00,zyzbid from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=?) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=? order by a.zxmbh0 207 10:53:35 SQL Execute: ORACLE - select SQ_YS_TEMPID_ID0000.NEXTVAL from dual 208 10:53:35 SQL Execute: ORACLE - select lengthb('') LENGTH from dual 209 10:53:35 SQL Execute: ORACLE - select 1 from SF_BRXXB0 where THBZ00='0' and GHID00 in (15601179) 210 10:53:35 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='11377808' and LBBH00='0' 211 10:53:35 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='8235865' and ZT0000='1' 212 10:53:35 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='8235865' and ZT0000='1' 213 10:53:35 SQL Execute: ORACLE - Select SYSDATE from Dual 214 10:53:35 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') 215 10:53:35 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '1226793000357750' and ICKNBH = '0226793600080526' 216 10:53:35 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 217 10:53:35 SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 218 10:53:35 SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11995.000000 219 10:53:35 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 220 10:53:35 SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 221 10:53:35 SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 222 10:53:35 SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11995 223 10:53:35 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 224 10:53:35 SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 225 10:53:35 SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 226 10:53:35 SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 227 10:53:35 SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 228 10:53:35 SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 229 10:53:35 SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 230 10:53:35 SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 231 10:53:35 SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 232 10:53:35 SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 233 10:53:35 SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 234 10:53:35 SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 235 10:53:35 SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 236 10:53:35 SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 237 10:53:35 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 238 10:53:35 SQL Data In: ORACLE - Param = 23, Name = PBRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8235865 239 10:53:35 SQL Data In: ORACLE - Param = 24, Name = PXZKFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 240 10:53:35 SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH_JZ" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT,PBRID00 => :PBRID00,PXZKFBZ => :PXZKFBZ); END; 241 10:53:36 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 242 10:53:36 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26126900.000000 243 10:53:36 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 244 10:53:36 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 245 10:53:36 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 246 10:53:36 SQL Execute: ORACLE - select count(*) COU from YJ_YW0000 a,BM_TYZD00 b where ZYGHID=15601179 and b.ZDMC00='前置医师选择采血费' and instr(','||b.MC0000||',',','||a.ZLXMID||',')>0 and substr(b.BH0000,1,6)='ZLXMID' and not exists(select 1 from YJ_YW0000 where ZYGHID=a.ZYGHID and CXDJH0=a.YJDJH0) 247 10:53:36 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='前置医师选择采血费' and BH0000='YS_CXBBID' 248 10:53:36 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZYS_BC00_0005' and SFQY00='1' 249 10:53:36 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 250 10:53:36 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 251 10:53:36 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 252 10:53:36 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 253 10:53:36 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 254 10:53:36 SQL Execute: ORACLE - select SF_YS_YBDZTSXZ_HIS(15601179,1,57 ) MSG000 from dual 255 10:53:36 SQL Execute: ORACLE - select * from XT_YYXX00 256 10:53:36 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 257 10:53:36 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='保存互认提示0' 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||',',',57,')>0) order by nvl(a.QYKS00,'0') desc 258 10:53:36 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 259 10:53:36 SQL Execute: ORACLE - select VALUE0,SF_BM_SQXQTSXX('YS_JCHRJKSQ','0',1) TSXX00,SF_SF_GETYYID00() YYID00 from XT_XTCS00 where name00='YS_JCHRJKSQ' 260 10:53:36 SQL Execute: ORACLE - commit 261 10:53:36 SQL Data In: ORACLE - Rows affected = 0 262 10:53:36 SQL Execute: ORACLE - select a.YJDJH0 from YJ_YW0000 a,BM_ZLZD00 b where ZYGHID=15601179 and a.ZLXMID=b.ZLXMID and a.XMZT00 in('0','1') and b.LBBH00=4 263 10:53:36 SQL Execute: ORACLE - select trim(Value0) Value0 from XT_XTCS00 a where name00='YS_JCHRJKDYFS' 264 10:53:36 SQL Execute: ORACLE - select SF_WBJK_GETJCHRURL(8235865,15601179,'1','2','26126900','0','0') URL from dual 265 10:53:37 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 266 10:53:38 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 267 10:53:39 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 268 10:53:40 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 269 10:53:41 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 270 10:53:41 SQL Execute: ORACLE - select count(*) COU from WLPT_HRJG00 a where a.BCHRID=5383 271 10:53:41 SQL Execute: ORACLE - select a.XMID00 from WLPT_HRJG00 a where a.SFCN00='1' and a.BCHRID=5383 272 10:53:41 SQL Execute: ORACLE - delete YJ_YW0000 where YJDJH0 in (26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900) 273 10:53:41 SQL Data In: ORACLE - Rows affected = 1 274 10:53:41 SQL Execute: ORACLE - delete YJ_YWJJ00 where YJDJH0 in (26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900) 275 10:53:41 SQL Data In: ORACLE - Rows affected = 31 276 10:53:41 SQL Execute: ORACLE - delete YJ_YWMX00 where YJDJH0 in (26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900,26126900) 277 10:53:41 SQL Data In: ORACLE - Rows affected = 1 278 10:53:41 SQL Execute: ORACLE - Commit 279 10:53:41 SQL Data In: ORACLE - Rows affected = 0 280 10:53:41 SQL Execute: ORACLE - select * from XT_YYXX00 281 10:53:41 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 282 10:53:41 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='保存互认提示1' 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||',',',57,')>0) order by nvl(a.QYKS00,'0') desc 283 10:53:41 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 284 10:53:41 SQL Execute: ORACLE - select VALUE0,SF_BM_SQXQTSXX('YS_JCHRJKSQ','0',1) TSXX00,SF_SF_GETYYID00() YYID00 from XT_XTCS00 where name00='YS_JCHRJKSQ' 285 10:53:41 SQL Execute: ORACLE - commit 286 10:53:41 SQL Data In: ORACLE - Rows affected = 0 287 10:53:41 SQL Execute: ORACLE - select * from XT_YYXX00 288 10:53:41 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 289 10:53:41 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||',',',57,')>0) order by nvl(a.QYKS00,'0') desc 290 10:53:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 291 10:53:41 SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,YPNM00,DCBZ00,CXDJH0,ZJE000,BZ0000,YJLRBZ,KDBQ00,JGZCBZ,BQSFBZ,ZLXMBH,BMMC,BBID00,bh0000,mc0000,ZJXGBZ,TEMPDJH,BBMC00,'0' tempbz,TMZT00 from VW_YS_JYSQYW where ZYHGHH=? order by YJDJH0 292 10:53:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 免费号 293 10:53:45 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 294 10:53:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 295 10:53:45 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 296 10:53:45 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 297 10:53:45 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 298 10:53:45 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 299 10:53:45 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 300 10:53:45 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 301 10:53:45 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 302 10:53:45 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8235865.000000 303 10:53:45 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15601179.000000 304 10:53:45 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 305 10:53:45 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 306 10:53:45 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = JYJC 307 10:53:45 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 308 10:53:45 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); END; 309 10:53:45 SQL Execute: ORACLE - select a.ZLXMID,a.ZLXMJC,b.GDBZ00 GDXMBZ,a.ZLXMID TEMPDJH,0 YJDJH0 from BM_ZLZD00 a,XT_ZLSFGX b where a.ZLXMID=b.ZLXMID and 1=3 310 10:53:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 311 10:53:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 11377808 312 10:53:45 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') 313 10:53:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8235865 314 10:53:45 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 315 10:53:45 SQL Execute: ORACLE - select a.ZDMC00 from ys_brzdxx A,BM_TYZD00 b where a.ghid00=15601179 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=15601179 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制') and rownum=1