1 17:38:56 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 2 17:38:56 SQL Prepare: ORACLE - select 1 from dual 3 17:38:56 SQL Execute: ORACLE - select 1 from dual 4 17:38:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5 17:38:56 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 6 17:38:56 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y') 7 17:38:56 SQL Execute: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y') 8 17:38:56 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 9 17:38:56 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 10 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = 1, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 11 17:38:56 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 12 17:38:56 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 13 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = CK 14 17:38:56 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 15 17:38:56 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 16 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = N 17 17:38:56 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 18 17:38:56 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00='YJJZ00' AND VALUE0='Y' 19 17:38:56 SQL Prepare: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' order by BMBH00 20 17:38:56 SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' order by BMBH00 21 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 180.000000 22 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 妇科(1A区) 23 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 181.000000 24 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 骨科(2区) 25 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 182.000000 26 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 三区A 27 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 183.000000 28 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 三区B 29 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 184.000000 30 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 4区A 31 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 222.000000 32 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 中医(5区) 33 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 239.000000 34 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 泌尿外(6) 35 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 240.000000 36 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 神外(7区) 37 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 241.000000 38 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 肿瘤(8区) 39 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 242.000000 40 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = ICU(9区) 41 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 243.000000 42 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 眼科(10区) 43 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 244.000000 44 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 耳鼻喉(11) 45 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 245.000000 46 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 儿科(12区) 47 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 246.000000 48 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心内3(13) 49 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 247.000000 50 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 特产(14区) 51 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 248.000000 52 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 特外1(15) 53 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 249.000000 54 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 干部(16区) 55 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 250.000000 56 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 特外3(17) 57 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 251.000000 58 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心内1(18) 59 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 252.000000 60 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 神内(19区) 61 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 253.000000 62 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心内2(20) 63 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 254.000000 64 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 呼吸(21区) 65 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 316.000000 66 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 4区B 67 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 367.000000 68 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 产科(1B区) 69 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 370.000000 70 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 急诊(22区) 71 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 427.000000 72 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 免疫(23区) 73 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 458.000000 74 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 放疗(24区) 75 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 459.000000 76 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 爱心病区 77 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 473.000000 78 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 骨科2(2区) 79 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 482.000000 80 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 肾内(25区) 81 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 527.000000 82 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 内分泌(26) 83 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 529.000000 84 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 康复(27区) 85 17:38:56 SQL Data Out: ORACLE - Column = 1, Name = BMBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 538.000000 86 17:38:56 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 超声介入28 87 17:38:58 SQL Prepare: ORACLE - Select SYSDATE from Dual 88 17:38:58 SQL Execute: ORACLE - Select SYSDATE from Dual 89 17:38:58 SQL Data Out: ORACLE - Column = 1, Name = SYSDATE, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/2/2012 17:39:5:0 90 17:38:58 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 91 17:38:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 92 17:38:58 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 55 93 17:38:58 SQL Prepare: 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') 94 17:38:58 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') 95 17:38:58 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = SLE4442 96 17:38:58 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 97 17:38:58 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 98 17:38:58 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '1225085000768372' and ICKNBH = '0225085600740270' 99 17:38:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '1225085000768372' and ICKNBH = '0225085600740270' 100 17:38:58 SQL Data Out: ORACLE - Column = 1, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = 1225085000768372 101 17:38:58 SQL Data Out: ORACLE - Column = 2, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 102 17:38:58 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2796610.000000 103 17:38:58 SQL Data Out: ORACLE - Column = 4, Name = KMH000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 00740270 104 17:38:58 SQL Data Out: ORACLE - Column = 5, Name = ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 105 17:38:58 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 106 17:38:58 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2796610.000000 107 17:38:58 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 108 17:38:58 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 17:38:58 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 110 17:38:58 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 111 17:38:58 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 112 17:38:58 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 113 17:38:58 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 114 17:38:58 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 115 17:38:58 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 116 17:38:58 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 117 17:38:58 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 118 17:38:58 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 119 17:38:58 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 120 17:38:58 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 121 17:38:58 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 122 17:38:58 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 123 17:38:58 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 124 17:38:58 SQL Prepare: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=:1 and (YJKSBH=:2 or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=:3) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=:4)) or (KDKSBH=:5 and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between :6 and :7 order by yjdjh0 125 17:38:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2796610.000000 126 17:38:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 127 17:38:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 128 17:38:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 129 17:38:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 218.000000 130 17:38:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120713 131 17:38:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120802 132 17:38:58 SQL Execute: ORACLE - Select brid00,yjdjh0,brxm00,yjfzh0,zyhghh,yexm00,zlxmjc,zxksmc,xb0000,csrq00,kdsj00,lrxm00,zje000,DQBQ00,RYCWH0,BQMC00, kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,mzzybz,sl0000,decode(xmzt00,'5','是','否') yt from vw_yj_yw0000_wzx b where xmzt00 in ('0','5','1') and brid00=? and (YJKSBH=? or (Zlxmid in (Select Zlxmid from vw_XT_xmfwfx where jsxmks=?) and kdksbh in (select SQXMKS from vw_xt_xmfwfx where jsxmks=?)) or (KDKSBH=? and YJLRBZ='Y')) and (not exists ( select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) and kdrq00 between ? and ? order by yjdjh0 133 17:38:58 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 134 17:38:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 135 17:38:58 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 136 17:38:58 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 137 17:38:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 138 17:38:58 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=?