1 14:44:50 Log started for: 检验自动取单 2 14:44:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 14:44:50 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.171','J','PrjLIS_ZZQD.exe'||'+'||'检验自助取单','1934','19672' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@0:C0324AED7E799E98058027B34CD8ED15' from dual 4 14:44:50 SQL Data In: ORACLE - Rows affected = 1 5 14:44:50 SQL Execute: ORACLE - Commit 6 14:44:50 SQL Data In: ORACLE - Rows affected = 0 7 14:44:50 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 14:44:50 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 9 14:44:50 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 10 14:44:50 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.171','J','PrjLIS_ZZQD.exe'||'+'||'检验自助取单','2006','53915' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@0:0' from dual 11 14:44:50 SQL Data In: ORACLE - Rows affected = 1 12 14:44:50 SQL Execute: ORACLE - Commit 13 14:44:50 SQL Data In: ORACLE - Rows affected = 0 14 14:44:50 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 15 14:44:50 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 16 14:44:57 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'JY_ZZQDSFDYGRTJBG' 17 14:44:57 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD21STBGXMID' 18 14:44:57 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD18STBGXMID' 19 14:44:57 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNTDBGXMID' 20 14:44:57 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNL' 21 14:44:57 SQL Execute: ORACLE - Select SYSDATE from Dual 22 14:44:57 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 23 14:44:57 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'IC_YBYYJKLM' 24 14:44:57 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') 25 14:44:57 SQL Execute: ORACLE - Select YYID00 from IC_YYID00 where YYID00 ='221094' 26 14:44:57 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090848139' and ICKNBH = '0221094090848139' 27 14:44:57 SQL Execute: ORACLE - select count(*) from jy_yw0000 where mzzybz='0' AND BRID00='4494659' and SFTJ00= 'N' and MZZYBZ in ('0','1') 28 14:44:57 SQL Execute: ORACLE - select count(*) from jy_yw0000 where mzzybz='0' AND BRID00='4494659' 29 14:44:57 SQL Execute: ORACLE - SELECT * FROM BM_BRXXB0 WHERE BRID00 = '4494659' 30 14:44:57 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL('20150517') FROM DUAL 31 14:44:57 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '4494659' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 32 14:44:58 SQL Execute: ORACLE - select distinct TXM000,brid00 from VW_JY_YW0000 where MZZYBZ in ('0','1') and sqks00 not in (0) and BBSDRQ between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and brid00= '4494659' and JGZT00='3' AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') 33 14:44:58 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 34 14:44:58 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 35 14:44:58 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '4494659' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 36 14:44:58 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 37 14:44:58 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 38 14:44:58 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_BGDZDDYCS' 39 14:44:58 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_ZZQDSFDYGRTJBG' 40 14:44:58 SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20160906' and SUBSTR(YBH000,1,2)='XS' and SUBSTR(YBH000,3,4) BETWEEN '0092' AND '0092' AND NVL(DYCS00,0) < 1 and JGZT00 in ('6') and MZZYBZ='0' and SFTJ00='N' ) t1 41 14:44:58 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20160906','XS0092') from dual 42 14:44:58 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 14:44:58 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG') 44 14:44:58 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 45 14:44:58 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT') 46 14:44:58 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,4412900) 47 14:44:58 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='XS' 48 14:44:58 SQL Execute: ORACLE - select distinct decode(sign(count(*)-0),1,'>=',0,'>=','-1','<') FH from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412900) and a.YQDH00='XS') group by ybh000,pyrq00 49 14:44:58 SQL Execute: ORACLE - select * from (select DISTINCT a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412900) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) ) order by pyrq00,ybh000 50 14:44:58 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where 1=1 and YQDH00='XS' and (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412900) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0 51 14:44:58 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0092' AND pyrq00 ='20160906' AND BGXMID ='999999' 52 14:44:58 SQL Data In: ORACLE - Rows affected = 0 53 14:44:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 54 14:44:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 55 14:44:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999 56 14:44:58 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 57 14:44:58 SQL Data In: ORACLE - Rows affected = 1 58 14:44:59 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0092' AND pyrq00 ='20160906' AND BGXMID ='999998' 59 14:44:59 SQL Data In: ORACLE - Rows affected = 0 60 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 61 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 62 14:44:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999998 63 14:44:59 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 64 14:44:59 SQL Data In: ORACLE - Rows affected = 1 65 14:44:59 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0092' AND pyrq00 ='20160906' AND BGXMID ='999996' 66 14:44:59 SQL Data In: ORACLE - Rows affected = 0 67 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 68 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 69 14:44:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999996 70 14:44:59 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 71 14:44:59 SQL Data In: ORACLE - Rows affected = 1 72 14:44:59 SQL Execute: ORACLE - commit 73 14:44:59 SQL Data In: ORACLE - Rows affected = 0 74 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 75 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 76 14:44:59 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 77 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 78 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 79 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 80 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 81 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 82 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 83 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 84 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 85 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 86 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 87 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 88 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 89 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 90 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 91 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 92 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 93 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 94 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 95 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 96 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 97 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 98 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 99 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 100 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 101 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 102 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 103 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 104 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 105 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 106 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 107 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 108 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 109 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 110 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 111 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 112 14:44:59 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 113 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 114 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 115 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 116 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 117 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 118 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 119 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 120 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 121 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 122 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 123 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 124 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 125 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 126 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 127 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 128 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 129 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 130 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 131 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 132 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 133 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 134 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 135 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 136 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 137 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 138 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 139 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 140 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 141 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 142 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 143 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 144 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 145 14:44:59 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 146 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 147 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 148 14:44:59 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 149 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 150 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 151 14:44:59 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 152 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 153 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 154 14:44:59 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 155 14:44:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 156 14:44:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 157 14:44:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 158 14:44:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 159 14:44:59 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 160 14:45:01 SQL Execute: ORACLE - select * from dual 161 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 162 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 163 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 164 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 165 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 166 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 167 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 168 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 169 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 170 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 171 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 172 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 173 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 174 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 175 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 176 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 177 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 178 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 179 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 180 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 181 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 182 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 183 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 184 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 185 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 186 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 187 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 188 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 189 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 190 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 191 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 192 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 193 14:45:01 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 194 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 195 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 196 14:45:01 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 197 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 198 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 199 14:45:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 200 14:45:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 201 14:45:01 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 202 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 203 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 204 14:45:01 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 205 14:45:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 206 14:45:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0092 207 14:45:01 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 208 14:45:03 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 ='JY_LISDYDYCSSFJY' 209 14:45:03 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 ='JY_BGDYJLFS' 210 14:45:03 SQL Execute: ORACLE - update jy_yw0000 a set a.jgzt00='8',a.DYCS00 = NVL(a.DYCS00, 0) + 1 where 1=1 and a.YQDH00='XS' and (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412900) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) 211 14:45:03 SQL Data In: ORACLE - Rows affected = 1 212 14:45:03 SQL Execute: ORACLE - update jy_yw0000 a set a.ZZBGDY=trim('检验科取报告01'),a.ZZBGRS=to_char(sysdate,'YYYYMMDD HH24:MI:SS') where 1=1 and a.ZZBGDY is null and a.YQDH00='XS' and (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412900) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) 213 14:45:03 SQL Data In: ORACLE - Rows affected = 1 214 14:45:03 SQL Execute: ORACLE - COMMIT 215 14:45:03 SQL Data In: ORACLE - Rows affected = 0 216 14:45:12 SQL Execute: ORACLE - select * from dual 217 14:45:19 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'JY_ZZQDSFDYGRTJBG' 218 14:45:19 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD21STBGXMID' 219 14:45:19 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD18STBGXMID' 220 14:45:19 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNTDBGXMID' 221 14:45:19 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNL' 222 14:45:19 SQL Execute: ORACLE - Select SYSDATE from Dual 223 14:45:19 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 224 14:45:19 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') 225 14:45:20 SQL Execute: ORACLE - Select YYID00 from IC_YYID00 where YYID00 ='221094' 226 14:45:20 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090848139' and ICKNBH = '0221094090848139' 227 14:45:20 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '4494659' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 228 14:45:20 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 229 14:45:20 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='4494659' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 230 14:45:23 SQL Execute: ORACLE - select * from dual 231 14:45:30 SQL Execute: ORACLE - select * from dual 232 14:45:40 SQL Execute: ORACLE - select * from dual 233 14:45:50 SQL Execute: ORACLE - select * from dual 234 14:46:00 SQL Execute: ORACLE - select * from dual 235 14:46:00 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'JY_ZZQDSFDYGRTJBG' 236 14:46:00 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD21STBGXMID' 237 14:46:00 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD18STBGXMID' 238 14:46:00 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNTDBGXMID' 239 14:46:00 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNL' 240 14:46:01 SQL Execute: ORACLE - Select SYSDATE from Dual 241 14:46:01 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 242 14:46:01 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') 243 14:46:01 SQL Execute: ORACLE - Select YYID00 from IC_YYID00 where YYID00 ='221094' 244 14:46:01 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090883906' and ICKNBH = '0221094090883906' 245 14:46:01 SQL Execute: ORACLE - select count(*) from jy_yw0000 where mzzybz='0' AND BRID00='5509750' and SFTJ00= 'N' and MZZYBZ in ('0','1') 246 14:46:01 SQL Execute: ORACLE - select count(*) from jy_yw0000 where mzzybz='0' AND BRID00='5509750' 247 14:46:01 SQL Execute: ORACLE - SELECT * FROM BM_BRXXB0 WHERE BRID00 = '5509750' 248 14:46:01 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL('20150506') FROM DUAL 249 14:46:01 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '5509750' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 250 14:46:01 SQL Execute: ORACLE - select distinct TXM000,brid00 from VW_JY_YW0000 where MZZYBZ in ('0','1') and sqks00 not in (0) and BBSDRQ between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and brid00= '5509750' and JGZT00='3' AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') 251 14:46:01 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 252 14:46:01 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 253 14:46:01 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '5509750' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 254 14:46:01 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 255 14:46:01 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 256 14:46:01 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_BGDZDDYCS' 257 14:46:01 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_ZZQDSFDYGRTJBG' 258 14:46:01 SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20160906' and SUBSTR(YBH000,1,2)='XS' and SUBSTR(YBH000,3,4) BETWEEN '0091' AND '0091' AND NVL(DYCS00,0) < 1 and JGZT00 in ('6') and MZZYBZ='0' and SFTJ00='N' ) t1 259 14:46:01 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20160906','XS0091') from dual 260 14:46:01 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 261 14:46:01 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG') 262 14:46:01 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 263 14:46:01 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT') 264 14:46:01 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,4412904) 265 14:46:01 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='XS' 266 14:46:01 SQL Execute: ORACLE - select distinct decode(sign(count(*)-0),1,'>=',0,'>=','-1','<') FH from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 267 14:46:01 SQL Execute: ORACLE - select * from (select DISTINCT a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) ) order by pyrq00,ybh000 268 14:46:01 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where 1=1 and YQDH00='XS' and (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0 269 14:46:02 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999999' 270 14:46:02 SQL Data In: ORACLE - Rows affected = 0 271 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 272 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 273 14:46:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999 274 14:46:02 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 275 14:46:02 SQL Data In: ORACLE - Rows affected = 1 276 14:46:02 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999998' 277 14:46:02 SQL Data In: ORACLE - Rows affected = 0 278 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 279 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 280 14:46:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999998 281 14:46:02 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 282 14:46:02 SQL Data In: ORACLE - Rows affected = 1 283 14:46:02 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999996' 284 14:46:02 SQL Data In: ORACLE - Rows affected = 0 285 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 286 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 287 14:46:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999996 288 14:46:02 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 289 14:46:02 SQL Data In: ORACLE - Rows affected = 1 290 14:46:02 SQL Execute: ORACLE - commit 291 14:46:02 SQL Data In: ORACLE - Rows affected = 0 292 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 293 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 294 14:46:02 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 295 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 296 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 297 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 298 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 299 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 300 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 301 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 302 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 303 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 304 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 305 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 306 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 307 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 308 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 309 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 310 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 311 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 312 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 313 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 314 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 315 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 316 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 317 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 318 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 319 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 320 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 321 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 322 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 323 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 324 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 325 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 326 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 327 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 328 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 329 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 330 14:46:02 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 331 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 332 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 333 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 334 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 335 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 336 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 337 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 338 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 339 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 340 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 341 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 342 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 343 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 344 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 345 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 346 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 347 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 348 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 349 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 350 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 351 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 352 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 353 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 354 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 355 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 356 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 357 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 358 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 359 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 360 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 361 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 362 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 363 14:46:02 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 364 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 365 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 366 14:46:02 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 367 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 368 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 369 14:46:02 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 370 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 371 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 372 14:46:02 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 373 14:46:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 374 14:46:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 375 14:46:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 376 14:46:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 377 14:46:02 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 378 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 379 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 380 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 381 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 382 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 383 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 384 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 385 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 386 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 387 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 388 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 389 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 390 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 391 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 392 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 393 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 394 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 395 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 396 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 397 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 398 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 399 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 400 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 401 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 402 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 403 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 404 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 405 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 406 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 407 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 408 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 409 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 410 14:46:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 411 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 412 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 413 14:46:04 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 414 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 415 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 416 14:46:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 417 14:46:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 418 14:46:04 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 419 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 420 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 421 14:46:04 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 422 14:46:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 423 14:46:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 424 14:46:04 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 425 14:46:10 SQL Execute: ORACLE - select * from dual 426 14:46:20 SQL Execute: ORACLE - select * from dual 427 14:46:30 SQL Execute: ORACLE - select * from dual 428 14:46:40 SQL Execute: ORACLE - select * from dual 429 14:46:50 SQL Execute: ORACLE - select * from dual 430 14:47:00 SQL Execute: ORACLE - select * from dual 431 14:47:10 SQL Execute: ORACLE - select * from dual 432 14:47:18 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'JY_ZZQDSFDYGRTJBG' 433 14:47:18 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD21STBGXMID' 434 14:47:18 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD18STBGXMID' 435 14:47:18 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNTDBGXMID' 436 14:47:18 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNL' 437 14:47:18 SQL Execute: ORACLE - Select SYSDATE from Dual 438 14:47:18 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 439 14:47:18 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') 440 14:47:18 SQL Execute: ORACLE - Select YYID00 from IC_YYID00 where YYID00 ='221094' 441 14:47:18 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0221094090883906' and ICKNBH = '0221094090883906' 442 14:47:18 SQL Execute: ORACLE - select t1.*, SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000, SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00 FROM (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000, a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00, a.SFJM00,'Y' dy0000, SFYB00, BGYSZ0, A.DYCS00, A.CBGRQ0 from VW_JY_YW0000 a WHERE brid00 = '5509750' and sqks00 not in (0) and SFTJ00='N' AND MZZYBZ='0' AND JGZT00 IN ('6','8') and CBGRQ0 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') AND NVL(DYCS00, 0) < (SELECT NVL(VALUE0,0) FROM XT_XTCS00 WHERE NAME00 = 'JY_BGDZDDYCS') ) T1 order by pyrq00,ybh000 443 14:47:18 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('2','1','4','5') and sqrq00 between to_char(sysdate-180,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 444 14:47:18 SQL Execute: ORACLE - select brid00 from VW_JY_YW0000 where brid00='5509750' and MZZYBZ='0' and SFTJ00='N' and txm000+0 is not null and jgzt00 in ('0') and sqrq00 between to_char(sysdate-1,'YYYYMMDD') and to_char(sysdate,'YYYYMMDD') and sqks00 not in (0) and zlxmid not in (0) 445 14:47:18 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_BGDZDDYCS' 446 14:47:18 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE TRIM(NAME00) = 'JY_ZZQDSFDYGRTJBG' 447 14:47:18 SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20160906' and SUBSTR(YBH000,1,2)='XS' and SUBSTR(YBH000,3,4) BETWEEN '0091' AND '0091' AND NVL(DYCS00,0) < 1 and JGZT00 in ('6') and MZZYBZ='0' and SFTJ00='N' ) t1 448 14:47:18 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20160906','XS0091') from dual 449 14:47:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 450 14:47:18 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG') 451 14:47:18 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 452 14:47:18 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT') 453 14:47:18 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,4412904) 454 14:47:18 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='XS' 455 14:47:18 SQL Execute: ORACLE - select distinct decode(sign(count(*)-0),1,'>=',0,'>=','-1','<') FH from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 456 14:47:19 SQL Execute: ORACLE - select * from (select DISTINCT a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) ) order by pyrq00,ybh000 457 14:47:19 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where 1=1 and YQDH00='XS' and (ybh000,pyrq00) in (select ybh000,pyrq00 from jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,4412904) and a.YQDH00='XS') group by ybh000,pyrq00 having count(*) >= 0) and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0 458 14:47:19 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999999' 459 14:47:19 SQL Data In: ORACLE - Rows affected = 1 460 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 461 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 462 14:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999 463 14:47:19 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 464 14:47:19 SQL Data In: ORACLE - Rows affected = 1 465 14:47:19 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999998' 466 14:47:19 SQL Data In: ORACLE - Rows affected = 1 467 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 468 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 469 14:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999998 470 14:47:19 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 471 14:47:19 SQL Data In: ORACLE - Rows affected = 1 472 14:47:19 SQL Execute: ORACLE - DELETE FROM jy_pic000 WHERE ybh000 ='XS0091' AND pyrq00 ='20160906' AND BGXMID ='999996' 473 14:47:19 SQL Data In: ORACLE - Rows affected = 1 474 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 475 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 476 14:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999996 477 14:47:19 SQL Execute: ORACLE - insert into jy_pic000(ybh000,pyrq00,bgxmid,pic000) values(?,?,?,?) 478 14:47:19 SQL Data In: ORACLE - Rows affected = 1 479 14:47:19 SQL Execute: ORACLE - commit 480 14:47:19 SQL Data In: ORACLE - Rows affected = 0 481 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 482 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 483 14:47:19 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 484 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 485 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 486 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 487 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 488 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 489 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 490 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 491 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 492 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 493 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 494 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 495 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 496 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 497 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 498 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 499 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 500 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 501 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 502 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 503 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 504 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 505 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 506 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 507 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 508 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 509 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 510 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 511 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 512 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 513 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 514 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 515 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 516 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 517 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 518 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 519 14:47:19 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 520 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 521 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 522 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 523 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 524 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 525 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 526 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 527 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 528 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 529 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 530 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 531 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 532 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 533 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 534 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 535 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 536 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 537 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 538 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 539 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 540 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 541 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 542 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 543 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 544 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 545 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 546 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 547 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 548 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 549 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 550 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 551 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 552 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 553 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 554 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 555 14:47:19 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 556 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 557 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 558 14:47:19 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 559 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 560 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 561 14:47:19 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 562 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 563 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 564 14:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 565 14:47:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 566 14:47:19 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 567 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 568 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 569 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 570 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 571 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 572 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 573 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 574 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 575 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 576 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 577 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 578 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 579 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 580 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 581 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 582 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 583 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 584 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 585 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 586 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 587 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 588 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 589 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 590 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 591 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 592 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 593 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 594 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 595 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 596 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 597 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 598 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 599 14:47:19 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 600 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 601 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 602 14:47:19 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 603 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 604 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 605 14:47:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 606 14:47:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 607 14:47:19 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00 FROM VW_JY_JYJG00 WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S') ORDER BY DYSX00) C 608 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 609 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 610 14:47:19 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 where YBH000=? and PYRQ00=? 611 14:47:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160906 612 14:47:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0091 613 14:47:19 SQL Execute: ORACLE - select '福州肺科医院 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000 a WHERE a.pyrq00=? AND a.ybh000=? and rownum=1 614 14:47:20 SQL Execute: ORACLE - select * from dual 615 14:47:30 SQL Execute: ORACLE - select * from dual 616 14:47:40 SQL Execute: ORACLE - select * from dual 617 14:47:50 SQL Execute: ORACLE - select * from dual 618 14:48:00 SQL Execute: ORACLE - select * from dual 619 14:48:10 SQL Execute: ORACLE - select * from dual 620 14:48:20 SQL Execute: ORACLE - select * from dual 621 14:48:30 SQL Execute: ORACLE - select * from dual 622 14:48:40 SQL Execute: ORACLE - select * from dual 623 14:48:50 SQL Execute: ORACLE - select * from dual 624 14:49:00 SQL Execute: ORACLE - select * from dual 625 14:49:10 SQL Execute: ORACLE - select * from dual 626 14:49:20 SQL Execute: ORACLE - select * from dual 627 14:49:30 SQL Execute: ORACLE - select * from dual 628 14:49:40 SQL Execute: ORACLE - select * from dual 629 14:49:50 SQL Execute: ORACLE - select * from dual 630 14:50:00 SQL Execute: ORACLE - select * from dual 631 14:50:10 SQL Execute: ORACLE - select * from dual 632 14:50:20 SQL Execute: ORACLE - select * from dual 633 14:50:30 SQL Execute: ORACLE - select * from dual 634 14:50:40 SQL Execute: ORACLE - select * from dual 635 14:50:50 SQL Execute: ORACLE - select * from dual 636 14:51:00 SQL Execute: ORACLE - select * from dual 637 14:51:10 SQL Execute: ORACLE - select * from dual 638 14:51:20 SQL Execute: ORACLE - select * from dual 639 14:51:30 SQL Execute: ORACLE - select * from dual 640 14:51:38 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'JY_ZZQDSFDYGRTJBG' 641 14:51:38 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD21STBGXMID' 642 14:51:38 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGD18STBGXMID' 643 14:51:38 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNTDBGXMID' 644 14:51:38 SQL Execute: ORACLE - Select value0 From XT_XTCS00 Where NAME00 = 'JY_CQSCBGDNL' 645 14:51:38 SQL Execute: ORACLE - Select SYSDATE from Dual 646 14:51:38 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 647 14:51:38 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') 648 14:51:38 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-XMJK' and KLDH00 not in ('CK','JMCK') 649 14:51:38 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-FJYB' and KLDH00 not in ('CK','JMCK') 650 14:51:38 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-FZYB' and KLDH00 not in ('CK','JMCK') 651 14:51:38 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') 652 14:51:38 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-SBK' and KLDH00 not in ('CK','JMCK') 653 14:51:40 SQL Execute: ORACLE - select * from dual