1 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BI 2 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 3 14:10:17 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 4 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 5 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 6 14:10:17 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.JLS000,A.SFDCNY,A.XJNYJC,A.SFXWR0,A.SFWJ00 FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000= ? AND PYRQ00= ? ) d order by d.XJID00 7 14:10:17 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='7667' 8 14:10:17 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 9 14:10:17 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='7667' 10 14:10:17 SQL Execute: ORACLE - select XJKSID from (SELECT XJKSID FROM JY_XJBGJG WHERE YBH000='BI0003' and PYRQ00='20210402' and XJID00 = '7667' order by xjksid desc) where rownum=1 11 14:10:17 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='8' 12 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7667 13 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 14 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 15 14:10:17 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00=? AND YBH000=? AND PYRQ00=? ) ORDER BY XH0000) JG 16 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7667 17 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 18 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 19 14:10:17 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00= ? AND YBH000=? AND PYRQ00=? ) AND B.XJKSID='8' ORDER BY XY0000 DESC,XH0001,XH0000 20 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 21 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 22 14:10:17 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00= ? and YBH000= ? 23 14:10:17 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='7667' 24 14:10:17 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 25 14:10:17 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='7667' 26 14:10:17 SQL Execute: ORACLE - select XJKSID from (SELECT XJKSID FROM JY_XJBGJG WHERE YBH000='BI0003' and PYRQ00='20210402' and XJID00 = '7667' order by xjksid desc) where rownum=1 27 14:10:17 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='8' 28 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7667 29 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 30 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 31 14:10:17 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00=? AND YBH000=? AND PYRQ00=? ) ORDER BY XH0000) JG 32 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7667 33 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 34 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 35 14:10:17 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00= ? AND YBH000=? AND PYRQ00=? ) AND B.XJKSID='8' ORDER BY XY0000 DESC,XH0001,XH0000 36 14:10:17 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 37 14:10:17 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 38 14:10:17 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 39 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 40 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 41 14:10:17 SQL Execute: ORACLE - select BBID00 from VW_JY_YW0000 where YBH000=? and PYRQ00=? 42 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 43 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 44 14:10:17 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? and ZYHGHH='00754' order by jyywid desc 45 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 46 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 47 14:10:17 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 48 14:10:17 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='A2' 49 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 50 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 51 14:10:17 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 52 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 53 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 54 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 55 14:10:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 56 14:10:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 57 14:10:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 58 14:10:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 59 14:10:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 60 14:10:17 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, FCYSJG fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00,a.CUTOFF,a.SP0000 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, FCYSJG fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00,a.CUTOFF,a.SP0000 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 61 14:10:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 62 14:10:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BI 63 14:10:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 64 14:10:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 65 14:10:17 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 66 14:10:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057 67 14:10:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BI 68 14:10:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 69 14:10:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGDY 70 14:10:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 71 14:10:18 SQL Execute: ORACLE - delete from JY_YW0000_TSDY where pyrq00='20210402' and YSYBH0='BI0003' 72 14:10:18 SQL Data In: ORACLE - Rows affected = 0 73 14:10:18 SQL Execute: ORACLE - insert into JY_YW0000_TSDY(YSYBH0,YBH000,PYRQ00,ZLXMJC,ZYHGHH,BRLX00,SFTJ00,MZZYBZ,SZKS00,BRBLH0,FBMC00,BRXM00,XBMC00,CSRQ00,NL0000,NLDW00,CH0000,ZDMC00,BBMC00,CJRXM0,BBSDR0,SDRXM0,BBSDRQ,BBSDSJ,BBCYRQ,BBCYSJ,SQRQ00,SQSJ00,SQKSMC,SQBQMC,SQYSXM,BGR000,BGRXM0,BGJYR0,JYRXM0,TXM000,DYBZ00,CBGRQ0,CBGSJ0,YQMC00,JYJS00,BBBZ00,BBSM00)select YBH000,YBH000,PYRQ00,ZLXMJC,ZYHGHH,BRLX00,SFTJ00,MZZYBZ,SZKS00,BRBLH0,FBMC00,BRXM00,XBMC00,CSRQ00,NL0000,NLDW00,CH0000,ZDMC00,BBMC00,CJRXM0,BBSDR0,SDRXM0,BBSDRQ,BBSDSJ,BBCYRQ,BBCYSJ,SQRQ00,SQSJ00,SQKSMC,SQBQMC,SQYSXM,BGR000,BGRXM0,BGJYR0,JYRXM0,TXM000,DYBZ00,CBGRQ0,CBGSJ0,YQMC00,JYJS00,substrb(BBBZ00,1,100) ,BBSM00 from VW_JY_YW0000 where pyrq00='20210402' and YBH000='BI0003' and rownum=1 74 14:10:18 SQL Data In: ORACLE - Rows affected = 1 75 14:10:18 SQL Execute: ORACLE - commit 76 14:10:18 SQL Data In: ORACLE - Rows affected = 0 77 14:10:19 SQL Execute: ORACLE - select bbid00,bbmc00 bbmc00 from BM_BBZD00 order by bbid00 78 14:10:19 SQL Execute: ORACLE - select VALUE0,DM0000 from XT_ZD0000 where YXBZ00='1' AND ZDBM00='BBZT00' ORDER BY DM0000 79 14:10:19 SQL Execute: ORACLE - select * from jy_yw0000_tsdy where pyrq00='20210402' and YSYBH0='BI0003' 80 14:10:19 SQL Execute: ORACLE - select BBID00 from BM_BBZD00 where bbmc00='全血' 81 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = JY_DYYLSFZDGB 82 14:10:21 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 83 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = JY_DYJSZBCFS 84 14:10:21 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 85 14:10:21 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1057' and YQDH00='BI' and QXLX00='JGCL' and QXGNDH='JGDY' 86 14:10:21 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20210402' and SUBSTR(YBH000,1,2)='BI' and SUBSTR(YBH000,3,4) BETWEEN '0003' AND '0003' and JGZT00 in ('4','5') AND SFTJ00='Y') 87 14:10:21 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20210402' and SUBSTR(YBH000,1,2)='BI' and SUBSTR(YBH000,3,4) BETWEEN '0003' AND '0003' AND MZZYBZ='0') 88 14:10:21 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20210402' and SUBSTR(YBH000,1,2)='BI' and SUBSTR(YBH000,3,4) BETWEEN '0003' AND '0003' AND MZZYBZ='1') 89 14:10:21 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1057' and YQDH00='BI' and QXLX00='JGCL' and QXGNDH='DYZYBG' 90 14:10:21 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20210402' and SUBSTR(YBH000,1,2)='BI' and SUBSTR(YBH000,3,4) BETWEEN '0003' AND '0003' and JGZT00 in ('4','5') AND SFJM00='Y') 91 14:10:21 SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZYTSDY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20210402' and SUBSTR(YBH000,1,2)='BI' and SUBSTR(YBH000,3,4) BETWEEN '0003' AND '0003' and JGZT00 in ('4','5') ) t1 92 14:10:21 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20210402','BI0003') from dual 93 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = JY_JGCLDYYLBDYSFGXZT 94 14:10:21 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 95 14:10:21 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 96 14:10:21 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,19300) 97 14:10:21 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='BI' 98 14:10:21 SQL Execute: ORACLE - select 1 from dual 99 14:10:21 SQL Execute: ORACLE - select ybh000,pyrq00,bgdh00 from (select DISTINCT a.ybh000,a.pyrq00,b.bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a,JY_XJBGJG b where a.JYYWID in (0,19300) and a.YQDH00='BI' and a.pyrq00=b.pyrq00 and a.ybh000=b.ybh000 ) order by SQBQ00 100 14:10:21 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from JY_JYJG00_temp where JYYWID IN (select a.JYYWID from JY_YW0000 a where a.JYYWID in (0,19300) ) and YQDH00='BI' and 1=1 and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0 101 14:10:21 SQL Execute: ORACLE - commit 102 14:10:21 SQL Data In: ORACLE - Rows affected = 0 103 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 104 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 105 14:10:21 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 106 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 107 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 108 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 109 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 110 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 111 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 112 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 113 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 114 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 115 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 116 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 117 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 118 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 119 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 120 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 121 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 122 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 123 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 124 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 125 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 126 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 127 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 128 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 129 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 130 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 131 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 132 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 133 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 134 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 135 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 136 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 137 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 138 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 139 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 140 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 141 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999988' 142 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 143 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 144 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999989' 145 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 146 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 147 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999990' 148 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 149 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 150 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999991' 151 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 152 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 153 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999992' 154 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 155 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 156 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where YBH000=? and pyrq00=? and bgxmid='999993' 157 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 158 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 159 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999994' 160 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 161 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 162 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND bgxmid='999995' 163 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 164 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 165 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999996' 166 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 167 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 168 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 169 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 170 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 171 14:10:21 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 172 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 173 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 174 14:10:21 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 175 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 176 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 177 14:10:21 SQL Execute: ORACLE - select ' 检验报告单' title,a.*,a.BRLX00||'号:' BRLXMC,decode(nl0000,'0','',nl0000||NLDWMC) NLDWQC from VW_JY_YW0000_TSDY a WHERE a.pyrq00=? AND a.YSYBH0=? and rownum=1 178 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 179 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 180 14:10:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 181 14:10:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 182 14:10:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 183 14:10:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 184 14:10:21 SQL Execute: ORACLE - SELECT rownum,(select count(*) from (SELECT DISTINCT XJID00,zwmc00,xjywmc,XJMS00,XJJG00,BGDH00,LCPY00,BBBZ00 FROM VW_JY_XJJG00 WHERE BGDH00=? AND YBH000=? AND PYRQ00=?)) ROWCOUNT ,A.* FROM (SELECT DISTINCT XJID00,zwmc00 xjzwmc,xjywmc,XJMS00,XJJG00,BGDH00,LCPY00,BBBZ00 FROM VW_JY_XJJG00_TSDY WHERE BGDH00=? AND YBH000=? AND PYRQ00=?) A ORDER BY BGDH00 185 14:10:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 186 14:10:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BI0003 187 14:10:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210402 188 14:10:21 SQL Execute: ORACLE - SELECT DISTINCT XJID00,KSSID0,KSZWMC,KSYWMC,CRJL00,XYND00,NYND00,XH0000,KSSTDH,XJMS00, YMSM00,YMJG00,YMJGKB,JGBZ00 FROM VW_JY_XJJG00_TSDY WHERE BGDH00=? AND YBH000=? AND PYRQ00=? order by XJID00,XH0000 189 14:10:21 SQL Execute: ORACLE - 190 14:10:21 SQL Error: ORACLE - ORA-00900: 无效 SQL 语句 191 14:10:21 SQL Error: ORACLE - Unmapped SQL Error Code: 900 192 14:10:21 SQL Data In: ORACLE - Rows affected = 0