1 12:19:47 Log started for: SQL Navigator for Oracle 2 12:20:23 Log started for: 门诊挂号收费管理系统 3 12:20:27 Log started for: SQL Navigator for Oracle 4 12:20:39 Log started for: 门诊挂号收费管理系统 5 12:20:42 Log started for: SQL Navigator for Oracle 6 12:23:12 Log started for: 门诊挂号收费管理系统 7 12:30:57 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',493,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '493') AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null) 8 12:30:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8080893.000000 9 12:30:59 SQL Execute: ORACLE - select A.*,(A.XMJE00-A.QZFJE0)*A.ZFBL00+A.QZFJE0 ZFJE00 from sf_pjsymx A where PJH000 =? 10 12:31:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8044695.000000 11 12:31:00 SQL Execute: ORACLE - select A.*,(A.XMJE00-A.QZFJE0)*A.ZFBL00+A.QZFJE0 ZFJE00 from sf_pjsymx A where PJH000 =? 12 12:31:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2228.000000 13 12:31:03 SQL Execute: ORACLE - select count(*) num000 from SST_YGBHDY where YGBH00=? 14 12:31:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 15 12:31:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 16 12:31:03 SQL Execute: ORACLE - Select PJLYID from BM_PJLYQK where PJLXBM =? and PJSYR0 =? and SYBZ00 = 'Y' 17 12:31:03 SQL Execute: ORACLE - update SF_PJSYQK SET PJXH00='0',PJLYID='0',CZY000='1913',CZYXM0='易联众ss',CZYKS0='493',SFDY00='Y',BDPJH0='0' where pjh000='8044695' 18 12:31:03 SQL Data In: ORACLE - Rows affected = 1 19 12:31:04 SQL Execute: ORACLE - select * from vw_sf_fp0000 where PJH000=8044695 20 12:31:04 SQL Execute: ORACLE - select B.DWMC00 from BM_BRXXB0 A,BM_TYDWB0 B where A.TYDWID=B.DWID00 and A.BRID00=4179463 21 12:31:04 SQL Execute: ORACLE - SELECT B.XMMC00,b.sfje00 FROM xt_xtcs00 A,BM_YYSFXM B WHERE TO_NUMBER(A.VALUE0)=B.SFXMID AND A.NAME00='IC_SFDM' 22 12:31:04 SQL Execute: ORACLE - select nvl(sum(a.hjje00),0) ickje0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and a.XMBH00=8000000001 and b.jzdh00+0=0 and b.brid00= 4179463 23 12:31:04 SQL Execute: ORACLE - select * from BM_TSBZB0 where BH0000='' 24 12:31:04 SQL Execute: ORACLE - select A.YBID00, A.fbbh00,B.FBMC00,c.YBMC00 from BM_BRXXB0 A,BM_BRFBB0 B, IC_YBBRLB C where a.fbbh00=c.fbbh00 and a.yblb00=c.yblb00 and A.FBBH00=B.FBBH00 AND A.BRID00=4179463 25 12:31:04 SQL Execute: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00=7650861 AND A.BRID00=4179463 26 12:31:04 SQL Execute: ORACLE - select YBKH00,YBDJH0 from SF_PJSYQK B,SF_JZB000 A,BM_BRXXB0 C where A.BRID00=C.BRID00 and B.FZPJH0 = A.PJH000 and b.pjh000=8044695 27 12:31:04 SQL Execute: ORACLE - select SF_SF_YBFPJE(2267351,1) XSNR00 from dual 28 12:31:04 SQL Execute: ORACLE - select SF_SF_YBFPJE(2267351,2) XSNR00 from dual 29 12:31:04 SQL Execute: ORACLE - select SF_SF_YBFPJE(2267351,4) XSNR00 from dual 30 12:31:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2267351.000000 31 12:31:04 SQL Execute: ORACLE - select NVL(max(JFLBID),1) JFLBID from SF_BRFY00 where MZH000 = '4063695' and JZDH00 =? 32 12:31:04 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =4179463 33 12:31:04 SQL Execute: ORACLE - select * from sf_pjsymx where XMJE00<>0 and pjh000=8044695 order by XMBH00 34 12:31:10 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',493,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '493') AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null) 35 12:31:10 SQL Execute: ORACLE - Commit 36 12:31:10 SQL Data In: ORACLE - Rows affected = 0 37 12:31:10 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =1913 and SYBZ00 = 'Y' 38 12:31:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20190107 39 12:31:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20190807 40 12:31:10 SQL Execute: ORACLE - select * from VW_SF_FP0000 where 1 = 1 and PJZT00 <> '1' AND BRZJE0<>0 and BRID00 in ( select BRID00 from IC_YHXX00 where ICKH00 = 'FZYBA79621290' and ZT0000 = '1' ) and FPDYRQ >= ? and FPDYRQ <= ? and PJZT00 <> '1' order by FPDYRQ||FPDYSJ desc 41 12:31:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8124512.000000 42 12:31:10 SQL Execute: ORACLE - select A.*,(A.XMJE00-A.QZFJE0)*A.ZFBL00+A.QZFJE0 ZFJE00 from sf_pjsymx A where PJH000 =? 43 12:31:17 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',493,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '493') AND (INSTR (',' || a.jsksbh || ',',',493,') > 0 or a.jsksbh is null) 44 15:23:15 Log started for: SQL Navigator for Oracle 45 16:42:21 Log started for: 门诊挂号收费管理系统