1 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=17157 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 2 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19491 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 3 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19492 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 4 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19495 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 5 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=21687 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 6 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=21692 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 7 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=22694 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 8 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=502 and ZLXMID=24892 and YJDJH0=20534938 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 9 09:17:31 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=6722788 and KSBH00=502 and ZLXMID=24892 and YJDJH0=20534938 and JCRQ00 IS NOT NULL and rownum=1 10 09:17:32 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '3650071' AND ROWNUM = 1) 11 09:17:32 SQL Execute: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '1415' 12 09:17:32 SQL Execute: ORACLE - select a.ghid00 from tj_brxxb0 a,sf_brxxb0 b where a.grghid=b.ghid00 and b.ghh000='3650071' 13 09:17:32 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00=(select ghid00 from sf_brxxb0 where ghh000='3650071') 14 09:17:32 SQL Execute: ORACLE - select GRGHID from TJ_BRXXB0 where GHID00=6722788 15 09:17:32 SQL Execute: ORACLE - SELECT TRIM(NVL(LQQK00,'')) FROM TJ_BRXXB0 WHERE GHID00 = '6722788' 16 09:17:32 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='4214545' 17 09:17:32 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6722788 18 09:17:32 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 19 09:17:32 SQL Data In: ORACLE - Param = 3, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 20 09:17:32 SQL Data In: ORACLE - Param = 4, Name = PYYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035 21 09:17:32 SQL Execute: ORACLE - BEGIN "SP_TJ_INSTJ_TJBG00" (PGHID00 => :PGHID00,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PYYID00 => :PYYID00); END; 22 09:17:32 SQL Execute: ORACLE - select lpad(ksbh00,5,' ')||zlxmid ksxmid,zlxmid,nvl(yjdjh0,0) yjdjh0, ksbh00,zlxmjc,xh0000,lbbh00,bgys00,CKSBH0,YYID00 ,KSLX00, JGHQFS from ( select mc0000 zlxmjc,a.ksbh00,xh0000,0 zlxmid,0 yjdjh0, DECODE(LX0000,'2','4','0') lbbh00,a.bgys00,A.CKSBH0, B.YYID00, KSLX00, NULL JGHQFS from tj_kslb00 a, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = D.ZLXMID AND ROWNUM = 1 AND BH0000 = D.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = D.KSBH00) KSLX00 from tj_tjbg00 D where ghid00=6722788) b where a.ksbh00=b.ksbh00 union select zlxmjc zlxmjc,b.ksbh00,c.xh0000,a.zlxmid,b.yjdjh0, TO_CHAR(a.lbbh00) LBBH00,c.bgys00,C.CKSBH0, B.YYID00, KSLX00, JGHQFS from bm_zlzd00 a,tj_kslb00 c, (select distinct ksbh00,zlxmid,yjdjh0, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND ROWNUM = 1 AND BH0000 = E.KSBH00) YYID00, (SELECT LX0000 FROM TJ_KSLB00 where KSBH00 = E.KSBH00) KSLX00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID = E.ZLXMID AND BH0000 = E.KSBH00) JGHQFS from tj_tjbg00 E where ghid00=6722788) b where a.zlxmid=b.zlxmid and b.ksbh00=c.ksbh00 AND A.ZLXMID IN (SELECT ZLXMID FROM TJ_ZHXM00 WHERE SFYX00 = 'Y') ) where 1=1 AND YYID00 = '220035' order by xh0000,ksbh00,zlxmid, yjdjh0 23 09:17:33 SQL Execute: ORACLE - select * from TJ_PACSJG where GHID00='6722788' and KSBH00='502' and YJDJH0 ='0' and ZLXMID='0' 24 09:17:33 SQL Execute: ORACLE - select TJURL0 from BM_ZLZD00 a,BM_JCLB00 b where a.JCLBID=b.JCLBID and TJURL0 is not null and a.ZLXMID='0' 25 09:17:33 SQL Execute: ORACLE - delete from TJ_PACSPIC where GHID00='6722788' and KSBH00='502' and ZLXMID='0' 26 09:17:33 SQL Data In: ORACLE - Rows affected = 0 27 09:17:33 SQL Execute: ORACLE - delete from TJ_PACSJGLJ where GHID00='6722788' and KSBH00='502' and ZLXMID='0' 28 09:17:33 SQL Data In: ORACLE - Rows affected = 0 29 09:17:33 SQL Execute: ORACLE - COMMIT 30 09:17:33 SQL Data In: ORACLE - Rows affected = 0 31 09:17:33 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='6722788' and ksbh00='502' order by JBMC00 32 09:17:33 SQL Execute: ORACLE - select GHID00,TJJL00,TJJY00,ZJYS00,ZJYSXM,BGRQ00,FCRQ00,CZY000,CZYXM0,TJSGJL from VW_TJ_BRXXB0 where GHID00='6722788' 33 09:17:33 SQL Execute: ORACLE - SELECT "ID0000", "DWID00", "BRID00", "GHID00", "GHH000", "ICD900", "JBMC00", "JY0000", "SFDDDY" FROM "VW_TJ_TJJYB0" WHERE ((("DWID00") = ('1415')) AND (("BRID00") = ('4214545'))) AND (("GHID00") = ('6722788')) 34 09:17:33 SQL Execute: ORACLE - select JYJZKS,(select BMMC00 from BM_BMBM00 where BMBH00=JYJZKS) JYKSMC, JYJZYS,(select ZWXM00 from BM_YGBM00 where YGBH00=JYJZYS) JYYSXM, JYKS01,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS01) JYMC01, JYYS01,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS01) JYXM01, JYKS02,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS02) JYMC02, JYYS02,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS02) JYXM02, JYKS03,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS03) JYMC03, JYYS03,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS03) JYXM03, JYKS04,(select BMMC00 from BM_BMBM00 where BMBH00=JYKS04) JYMC04, JYYS04,(select ZWXM00 from BM_YGBM00 where YGBH00=JYYS04) JYXM04 from TJ_BRXXB0 a where GHID00='6722788' 35 09:17:33 SQL Execute: ORACLE - select * from TJ_JKZJG0 where ghid00=6722788 36 09:17:33 SQL Execute: ORACLE - SELECT C.* FROM ( select yjdjh0,yjfzh0,a.zlxmid,b.zlxmjc,b.lbbh00,xmzt00,SL0000,YJKSBH, DECODE(XMZT00,'0','已申请','1','已计价','2','已收费','3','已执行', '6','已作废','7','已退费','D','已取消') XMZTMC, (SELECT YYID00 FROM TJ_ZHXM00 WHERE ZLXMID = A.ZLXMID AND ROWNUM = 1 AND BH0000 = A.YJKSBH) YYID00 from TJ_YJDJH0 a,bm_zlzd00 b where a.zlxmid=b.zlxmid and xmzt00 in('0','1','2','6','D') and (not exists (select 'y' from yj_yw0000 c where c.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and (ghid00='6722788' or ghid00='') ) C WHERE YYID00 = '220035' 37 09:17:33 SQL Execute: ORACLE - select * from ( select SJLX00,BGID00,XSSX00,A.ZLXMID,A.YJDJH0,A.JCXMID,XXZ000,SXZ000,XXTS00,SXTS00,CKZ000,JCRQ00,SFCSTS,XMMC00,CDZ000,DW0000,JGSM00,JCYS00,JCYSXM,B.XH0000 ZLXMXH,SFJRXJ,CDMS00,ICD900,JBMC00,A.SFDY00 from VW_TJ_TJBG00_DIS A,TJ_ZHXM00 B where A.ZLXMID=B.ZLXMID AND GHID00='6722788' and A.KSBH00='498' AND A.KSBH00=B.BH0000 UNION select 'C' SJLX00,0 BGID00,0 XSSX00,A.ZLXMID,C.YJDJH0,0 JCXMID,0 XXZ000,0 SXZ000,'' XXTS00,'' SXTS00,'' CKZ000,C.JCRQ00,'' SFCSTS,B.ZLXMJC XMMC00,'' CDZ000,'' DW0000,'' JGSM00,C.JCYS00,C.JCYSXM,A.XH0000 ZLXMXH,'N' SFJRXJ,'' CDMS00,'' ICD900,'' JBMC00,'N' SFDY00 from TJ_ZHXM00 A,BM_ZLZD00 B,VW_TJ_TJBG00_DIS C WHERE C.GHID00='6722788' and C.KSBH00='498' and A.ZLXMID=B.ZLXMID AND A.ZLXMID=C.ZLXMID and A.BH0000=C.KSBH00 and ((exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is not null) or (not exists(select 1 from tj_tjbg00 where ghid00=c.ghid00 and zlxmid=c.zlxmid and ksbh00=c.ksbh00 and yjdjh0=c.yjdjh0 and jcys00 is not null) and jcys00 is null)) )order by ZLXMXH,ZLXMID,YJDJH0,XSSX00 38 09:17:33 SQL Execute: ORACLE - select * from TJ_TJXJB0 where GHID00='6722788' and KSBH00='498' 39 09:17:33 SQL Execute: ORACLE - select ICD900,JBMC00,JY0000 from TJ_TJBGCF where GHID00='6722788' and ksbh00='498' order by ID0000 40 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=17157 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 41 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19491 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 42 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19492 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 43 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=19495 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 44 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=21687 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 45 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=21692 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 46 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=498 and ZLXMID=22694 and YJDJH0=20533522 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 47 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_TJBG00 where ghid00=6722788 and KSBH00=502 and ZLXMID=24892 and YJDJH0=20534938 and JCRQ00 IS NOT NULL and rownum=1 AND JCXMID <> 9999 48 09:17:33 SQL Execute: ORACLE - select count(*) from TJ_PACSJG where ghid00=6722788 and KSBH00=502 and ZLXMID=24892 and YJDJH0=20534938 and JCRQ00 IS NOT NULL and rownum=1 49 09:17:33 SQL Execute: ORACLE - SELECT * FROM (SELECT b.ZLXMID,c.ZLXMJC,c.LBBH00,YJKSBH,GHID00,NVL(YJDJH0,0) YJDJH0,YJKSBH KSBH00, (SELECT JGHQFS FROM TJ_ZHXM00 WHERE ZLXMID=B.ZLXMID AND BH0000=B.YJKSBH) JGHQFS FROM TJ_YJDJH0 B,BM_ZLZD00 C WHERE B.ZLXMID=C.ZLXMID AND (GHID00='6722788' OR GHID00=(SELECT GRGHID FROM TJ_BRXXB0 WHERE GHID00='6722788')) AND XMZT00 in('3','4') AND (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0)) AND ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND C.LBBH00<>'4' ) WHERE JGHQFS = '1' 50 09:17:33 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6722788 51 09:17:33 SQL Data In: ORACLE - Param = 2, Name = PKSBH00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 502 52 09:17:33 SQL Data In: ORACLE - Param = 3, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20534938 53 09:17:33 SQL Data In: ORACLE - Param = 4, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 24892 54 09:17:33 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 55 09:17:33 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 56 09:17:33 SQL Data In: ORACLE - Param = 7, Name = PCXJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 57 09:17:33 SQL Execute: ORACLE - BEGIN "SP_TJ_RECIEVE_PACSJG" (PGHID00 => :PGHID00,PKSBH00 => :PKSBH00,PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCXJS00 => :PCXJS00); END; 58 09:17:33 SQL Data In: ORACLE - Param = 1, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6722788 59 09:17:33 SQL Data In: ORACLE - Param = 2, Name = PKSBH00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 502 60 09:17:33 SQL Data In: ORACLE - Param = 3, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20535364 61 09:17:33 SQL Data In: ORACLE - Param = 4, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 24589 62 09:17:33 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 63 09:17:33 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 64 09:17:33 SQL Data In: ORACLE - Param = 7, Name = PCXJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 65 09:17:33 SQL Execute: ORACLE - BEGIN "SP_TJ_RECIEVE_PACSJG" (PGHID00 => :PGHID00,PKSBH00 => :PKSBH00,PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCXJS00 => :PCXJS00); END; 66 09:17:35 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'T') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',510,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '510') AND (INSTR (',' || a.jsksbh || ',',',510,') > 0 or a.jsksbh is null)