1 18:29:37 Log started for: 易联众医院信息综合管理平台 2 18:29:37 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3 18:29:37 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.226','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 18:29:37 SQL Data In: ORACLE - Rows affected = 1 5 18:29:37 SQL Execute: ORACLE - Commit 6 18:29:37 SQL Data In: ORACLE - Rows affected = 0 7 18:29:37 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 8 18:29:37 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='00498' and CZBZ00 in ('0','1') 9 18:29:37 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '00498' and YCLBBZ ='0' and CLBZ00 = '0' 10 18:29:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 11 18:29:37 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=2832 and XTDM00 not in ('OE','MC') order by XTDM00 12 18:29:37 SQL Execute: ORACLE - Select SYSDATE from Dual 13 18:29:37 SQL Execute: ORACLE - Select SYSDATE from Dual 14 18:29:37 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 2832 15 18:29:37 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 2832 16 18:29:37 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 17 18:29:38 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 18:29:38 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 19 18:29:38 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 20 18:29:38 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 18:29:38 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 2832 22 18:29:38 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 2832 23 18:29:38 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.226' 24 18:29:38 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 25 18:29:38 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 2832 and RowNum <= 10 order by DLRQSJ DESC 26 18:29:38 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 2832 and XTDM00='2' order by BMPLXH,BMBH00 27 18:29:39 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 2832 and XTDM00='R' order by BMPLXH,BMBH00 28 18:29:40 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='R' and KJLB00 ='3' 29 18:29:40 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = 'R' and KJLB00 < '3' order by XH0000 30 18:29:40 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'R'||',')>0 31 18:29:40 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 2832 and XTDM00 = 'R' 32 18:29:40 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'R' 33 18:29:40 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2275 and FLAG00 like '0' order by decode(CKBH00,523,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 34 18:29:40 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 35 18:29:40 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.226','R',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 36 18:29:40 SQL Data In: ORACLE - Rows affected = 1 37 18:29:40 SQL Execute: ORACLE - Commit 38 18:29:40 SQL Data In: ORACLE - Rows affected = 0 39 18:29:40 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 18:29:40 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 41 18:29:40 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(22238815,2832,'SRM-20240805WSM','R',nvl('410439334',' '),'129.7.13.226#7:3647@appYLZHis.exe',2275,'129.7.13.226') 42 18:29:40 SQL Data In: ORACLE - Rows affected = 1 43 18:29:40 SQL Execute: ORACLE - Commit 44 18:29:40 SQL Data In: ORACLE - Rows affected = 0 45 18:29:40 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=2832 and XTDM00='R' 46 18:29:40 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.226' and NAME00 = 'QDXTJZ' 47 18:29:40 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = 'R' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 2832 and XTDM00 = 'R') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 48 18:29:40 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 2832 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 49 18:29:40 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=2832 and XTDM00='R' order by XH0000 50 18:29:40 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 51 18:29:40 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 52 18:29:40 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 18:29:40 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 54 18:29:40 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2832.000000 55 18:29:40 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2275.000000 56 18:29:40 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 140786287.000000 57 18:29:40 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 58 18:29:40 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 2832 and CZXH00 = 140786287.00) 59 18:29:40 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 60 18:29:40 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 61 18:29:40 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 62 18:29:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 63 18:29:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 64 18:29:40 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2275 65 18:29:40 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2275 66 18:29:40 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 67 18:29:40 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 68 18:29:40 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 69 18:29:40 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2275) as SFBZDJ from dual 70 18:29:40 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_MZPY_ZHYW.dll' and YGBH00 = 2832 and XTDM00 = 'R' 71 18:29:40 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '门诊审方退回原因' and LBBZ00='0' order by XSXH00 72 18:29:40 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY' 73 18:29:40 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_SFZZSM' 74 18:29:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 75 18:29:40 SQL Execute: ORACLE - select JZCKBZ from BM_CKBM00 where CKBH00 = ? 76 18:29:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 77 18:29:40 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 78 18:29:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 79 18:29:40 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 80 18:29:40 SQL Execute: ORACLE - select ZWXM00||'|'||XKH000 from VW_PY_PYXTRY A 81 18:29:41 SQL Execute: ORACLE - select SF_PY_GetYFLB(2275) from dual 82 18:29:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 83 18:29:41 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 84 18:29:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 203 85 18:29:41 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 86 18:29:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 303 87 18:29:41 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 88 18:29:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ' 89 18:29:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '排队叫号通用接口参数配置' and BH0000 = 'PDJHJK_YFBMBH' 90 18:29:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '排队叫号通用接口参数配置' and BH0000 = 'PDJHJK_SFQY' 91 18:29:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '发药信息推送接口配置' and BH0000 = 'QY' 92 18:29:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='发药信息推送接口配置' 93 18:29:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_QY' 94 18:29:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='CA认证接口配置' 95 18:29:41 SQL Execute: ORACLE - select * from BM_SZZSXX where YGBH00 = 2832 96 18:29:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 97 18:29:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 98 18:29:41 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 99 18:29:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 100 18:29:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 101 18:29:44 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 102 18:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 103 18:29:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 104 18:29:47 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 105 18:29:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 106 18:29:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 107 18:29:50 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 108 18:29:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = YWX 109 18:29:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 110 18:29:53 SQL Execute: ORACLE - select SF_YF_CAURL0( ?,? ) from dual 111 18:29:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈成辉 112 18:29:53 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where ZWXM00 = ? 113 18:29:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈成辉 114 18:29:53 SQL Execute: ORACLE - select XKH000 from BM_YGBM00 where ZWXM00 = ? 115 18:30:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18:30:00 116 18:30:00 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250929' and '20250929' and FYCKBH = 303 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 117 18:30:00 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250929' and '20250929' and FYCKBH = 303 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A