1 09:16:32 Log started for: SQL Navigator for Oracle 2 09:16:43 Log started for: 易联众医院信息综合管理平台 3 09:16:43 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 4 09:16:43 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.243','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 09:16:43 SQL Data In: ORACLE - Rows affected = 1 6 09:16:43 SQL Execute: ORACLE - Commit 7 09:16:43 SQL Data In: ORACLE - Rows affected = 0 8 09:16:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 9 09:16:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='CS10087' and CZBZ00 in ('0','1') 10 09:16:43 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = 'cs10087' and YCLBBZ ='0' and CLBZ00 = '0' 11 09:16:43 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 12 09:16:43 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=4960 and XTDM00 not in ('OE','MC') order by XTDM00 13 09:16:43 SQL Execute: ORACLE - Select SYSDATE from Dual 14 09:16:43 SQL Execute: ORACLE - Select SYSDATE from Dual 15 09:16:43 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 4960 16 09:16:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 4960 17 09:16:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 18 09:16:43 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 19 09:16:43 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 20 09:16:43 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 21 09:16:43 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 09:16:43 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 4960 23 09:16:43 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 4960 24 09:16:43 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.243' 25 09:16:43 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 26 09:16:43 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 4960 and RowNum <= 10 order by DLRQSJ DESC 27 09:16:44 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='2' order by BMPLXH,BMBH00 28 09:16:44 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='2' and KJLB00 ='3' 29 09:16:44 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '2' and KJLB00 < '3' order by XH0000 30 09:16:44 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'2'||',')>0 31 09:16:44 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 4960 and XTDM00 = '2' 32 09:16:44 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '2' 33 09:16:44 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 4443 and FLAG00 like '0' order by decode(CKBH00,600,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 34 09:16:44 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 09:16:44 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.243','2',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 36 09:16:44 SQL Data In: ORACLE - Rows affected = 1 37 09:16:44 SQL Execute: ORACLE - Commit 38 09:16:44 SQL Data In: ORACLE - Rows affected = 0 39 09:16:44 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 09:16:44 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 09:16:44 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(22665768,4960,'WINDOWS-J8UNJHL','2',nvl('416591839',' '),'129.7.13.243#1706:34597@appYLZHis.exe',4443,'129.7.13.243') 42 09:16:44 SQL Data In: ORACLE - Rows affected = 1 43 09:16:44 SQL Execute: ORACLE - Commit 44 09:16:44 SQL Data In: ORACLE - Rows affected = 0 45 09:16:44 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='2' 46 09:16:44 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.243' and NAME00 = 'QDXTJZ' 47 09:16:44 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 = '2' 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 = 4960 and XTDM00 = '2') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 48 09:16:44 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 4960 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 49 09:16:44 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='2' order by XH0000 50 09:16:44 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 51 09:16:44 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4443.000000 52 09:16:44 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 09:16:44 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 54 09:16:44 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 55 09:16:44 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4443.000000 56 09:16:44 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 146945380.000000 57 09:16:44 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 58 09:16:44 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 146945380.00) 59 09:16:51 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 4960 and RowNum <= 10 order by DLRQSJ DESC 60 09:16:54 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='7' order by BMPLXH,BMBH00 61 09:16:59 SQL Execute: ORACLE - RollBack 62 09:16:59 SQL Data In: ORACLE - Rows affected = 0 63 09:16:59 SQL Execute: ORACLE - Commit 64 09:16:59 SQL Data In: ORACLE - Rows affected = 0 65 09:16:59 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 22665768 66 09:17:00 SQL Data In: ORACLE - Rows affected = 1 67 09:17:00 SQL Execute: ORACLE - Commit 68 09:17:00 SQL Data In: ORACLE - Rows affected = 0 69 09:17:00 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='7' and KJLB00 ='3' 70 09:17:00 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '7' and KJLB00 < '3' order by XH0000 71 09:17:00 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'7'||',')>0 72 09:17:00 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 4960 and XTDM00 = '7' 73 09:17:00 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '7' 74 09:17:00 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2301 and FLAG00 like '0' order by decode(CKBH00,600,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 75 09:17:00 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)) 76 09:17:00 SQL Execute: ORACLE - update XT_XTLJ00 set XTDM00='7' where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 77 09:17:00 SQL Data In: ORACLE - Rows affected = 1 78 09:17:00 SQL Execute: ORACLE - Commit 79 09:17:00 SQL Data In: ORACLE - Rows affected = 0 80 09:17:00 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 81 09:17:00 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')) 82 09:17:00 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(22665769,4960,'WINDOWS-J8UNJHL','7',nvl('416591839',' '),'129.7.13.243#1706:34597@appYLZHis.exe',2301,'129.7.13.243') 83 09:17:00 SQL Data In: ORACLE - Rows affected = 1 84 09:17:00 SQL Execute: ORACLE - Commit 85 09:17:00 SQL Data In: ORACLE - Rows affected = 0 86 09:17:00 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.243' and NAME00 = 'QDXTJZ' 87 09:17:00 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 = '7' 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 = 4960 and XTDM00 = '7') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 88 09:17:00 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 4960 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 89 09:17:00 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' order by XH0000 90 09:17:00 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 91 09:17:00 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 92 09:17:00 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 146945381.000000 93 09:17:00 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 94 09:17:00 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 146945381.00) 95 09:17:00 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 96 09:17:00 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='7' 97 09:17:00 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 98 09:17:00 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 = '' 99 09:17:00 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 = '' 100 09:17:00 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2301 101 09:17:00 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2301 102 09:17:00 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 103 09:17:00 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 104 09:17:00 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 105 09:17:00 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2301) as SFBZDJ from dual 106 09:17:00 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YJ_ZHYW.dll' and YGBH00 = 4960 and XTDM00 = '7' 107 09:17:00 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 108 09:17:00 SQL Execute: ORACLE - select YJHTBZ from XT_YYXX00 where YYID00='220006' 109 09:17:00 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_TMTSY','YS_YSXMSQD','ZY_SFSYFPXMZMYHJM','YJ_XMZXDKHQX','YJ_XMZXSLMRYC','YJ_XMZJMRKSYS','YJ_TXMQJZM','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ') 110 09:17:00 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 111 09:17:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 112 09:17:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 113 09:17:00 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 114 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ' 115 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB' 116 09:17:00 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 117 09:17:00 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 118 09:17:00 SQL Execute: ORACLE - select 1 from dual where 2301 in (474) 119 09:17:00 SQL Execute: ORACLE - select ZLXMJC,ZLXMID from VW_YJ_KSKFMB where 1=1 and ZXKS00=2301 120 09:17:00 SQL Execute: ORACLE - select * from VW_YJ_LGBR00 where KSRQ00 between '20251219' and '20251222' 121 09:17:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 122 09:17:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 123 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='提示未执行项目互相对应科室' and (BH0000=? or MC0000=? ) 124 09:17:00 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='项目抢执行科室对应' and BH0000='2301' 125 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '高值耗材通用接口配置参数' and BH0000 = 'GZHCJK' 126 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 127 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'MultiChannel_Mode' 128 09:17:00 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual 129 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 130 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '标本采样接口平台' and BH0000 = 'BZCYJK_OPEN' 131 09:17:00 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='诊疗带出药品变更功能授权码' and BH0000='YJ_YPAUDSQM' 132 09:17:00 SQL Execute: ORACLE - select '1' from bm_tyzd00 where zdmc00='可变更诊疗带出药品的科室' and BH0000='2301' and YXBZ00='1' 133 09:17:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 134 09:17:00 SQL Execute: ORACLE - select YFBMBH from BM_KSYFDY where KSBH00=? and YXBZ00='1' 135 09:17:00 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open' 136 09:17:00 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,4960,'测试管理员','129.7.13.243','6C-4B-90-AB-D8-10','7','ACT_YJ_XMZX','416591839') 137 09:17:00 SQL Data In: ORACLE - Rows affected = 1 138 09:17:00 SQL Execute: ORACLE - Commit 139 09:17:00 SQL Data In: ORACLE - Rows affected = 0 140 09:17:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 141 09:17:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 142 09:17:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 143 09:17:11 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 144 09:17:11 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20250901' and '20251222' order by XMZT00,YJDJH0 Desc 145 09:20:50 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 197135169 146 09:20:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 147 09:20:50 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197135169 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 148 09:20:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6567760 149 09:20:50 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 150 09:20:50 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19630357,'1',6567760) from dual 151 09:20:50 SQL Execute: ORACLE - select '19630357' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13806974113' BRLXDH,'00512478' ZYHGHH, '廖伟' BRXM00, '男' BRXB00, '39岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19630357') FBMC00 , '08' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2406) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19630357' ) JZFPBZ from dual 152 09:20:50 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 153 09:20:50 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19630357','0','') as BRGMXX from dual 154 09:20:50 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19630357','1','') as BRGMXX from dual 155 09:20:50 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19630357','2','') as BRGMXX from dual 156 09:20:50 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19630357,'1',6567760) from dual 157 09:20:50 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 158 09:20:50 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 159 09:20:50 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 146945382.000000 160 09:20:50 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 161 09:20:50 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 146945382.00) 162 09:21:16 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 197114645 163 09:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213390437 164 09:21:16 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197114645 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 165 09:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213390437 166 09:21:16 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197114645 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 167 09:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6570525 168 09:21:16 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 169 09:21:16 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631373,'1',6570525) from dual 170 09:21:16 SQL Execute: ORACLE - select '19631373' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18950247636' BRLXDH,'00512677' ZYHGHH, '汤春梅' BRXM00, '女' BRXB00, '74岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19631373') FBMC00 , '60' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2408) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19631373' ) JZFPBZ from dual 171 09:21:16 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 172 09:21:16 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','0','') as BRGMXX from dual 173 09:21:16 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','1','') as BRGMXX from dual 174 09:21:16 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','2','') as BRGMXX from dual 175 09:21:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251014 176 09:21:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251222 177 09:21:28 SQL Execute: ORACLE - select * from VW_YJ_BRGHXX where (JLLBBZ = 0) or (GHRQ00 between ? and ? and BRID00 = 19631373 and THRQ00 is null ) order by JLLBBZ,GHRQ00 desc, GHH000 desc 178 09:21:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19631373 179 09:21:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 180 09:21:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 181 09:21:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 182 09:21:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 183 09:21:28 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251014' and '20251222' order by XMZT00,YJDJH0 Desc 184 09:21:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213390437 185 09:21:28 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197114645 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 186 09:21:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6570525 187 09:21:28 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 188 09:21:28 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631373,'1',6570525) from dual 189 09:21:28 SQL Execute: ORACLE - select '19631373' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18950247636' BRLXDH,'00512677' ZYHGHH, '汤春梅' BRXM00, '女' BRXB00, '74岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19631373') FBMC00 , '60' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2408) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19631373' ) JZFPBZ from dual 190 09:21:28 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 191 09:21:28 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','0','') as BRGMXX from dual 192 09:21:28 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','1','') as BRGMXX from dual 193 09:21:28 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','2','') as BRGMXX from dual 194 09:21:28 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631373,'1',6570525) from dual 195 09:21:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251014 196 09:21:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251014 197 09:21:34 SQL Execute: ORACLE - select * from VW_YJ_BRGHXX where (JLLBBZ = 0) or (GHRQ00 between ? and ? and BRID00 = 19631373 and THRQ00 is null ) order by JLLBBZ,GHRQ00 desc, GHH000 desc 198 09:21:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19631373 199 09:21:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 200 09:21:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 201 09:21:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 202 09:21:34 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 203 09:21:34 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251014' and '20251014' order by XMZT00,YJDJH0 Desc 204 09:21:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213390437 205 09:21:34 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197114645 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 206 09:21:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6570525 207 09:21:34 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 208 09:21:34 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631373,'1',6570525) from dual 209 09:21:34 SQL Execute: ORACLE - select '19631373' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18950247636' BRLXDH,'00512677' ZYHGHH, '汤春梅' BRXM00, '女' BRXB00, '74岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19631373') FBMC00 , '60' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2408) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19631373' ) JZFPBZ from dual 210 09:21:34 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 211 09:21:34 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','0','') as BRGMXX from dual 212 09:21:34 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','1','') as BRGMXX from dual 213 09:21:34 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631373','2','') as BRGMXX from dual 214 09:21:34 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631373,'1',6570525) from dual 215 09:21:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 216 09:21:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 217 09:21:37 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 218 09:21:37 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 219 09:21:37 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251014' and '20251014' order by XMZT00,YJDJH0 Desc 220 09:21:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213394439 221 09:21:38 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197120165 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 222 09:21:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6559276 223 09:21:38 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 224 09:21:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18967673 225 09:21:39 SQL Execute: ORACLE - select SF_XT_GETBRJZDXXX(?,'','1',1) from dual 226 09:21:39 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(18967673,'1',6559276) from dual 227 09:21:39 SQL Execute: ORACLE - select '18967673' BRID00, '1' MZZYBZ, '住院' MZZYMC, '19559135986' BRLXDH,'00419333' ZYHGHH, '陈寿仁' BRXM00, '男' BRXB00, '64岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '18967673') FBMC00 , '19' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2407) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='18967673' ) JZFPBZ from dual 228 09:21:39 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 229 09:21:39 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18967673','0','') as BRGMXX from dual 230 09:21:39 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18967673','1','') as BRGMXX from dual 231 09:21:39 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18967673','2','') as BRGMXX from dual 232 09:21:39 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(18967673,'1',6559276) from dual 233 09:21:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213389803 234 09:21:40 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197115514 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 235 09:21:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6569978 236 09:21:40 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 237 09:21:41 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19631107,'1',6569978) from dual 238 09:21:41 SQL Execute: ORACLE - select '19631107' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15159389496' BRLXDH,'00512647' ZYHGHH, '王舒琪' BRXM00, '女' BRXB00, '18岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19631107') FBMC00 , '59' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2260) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19631107' ) JZFPBZ from dual 239 09:21:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 240 09:21:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631107','0','') as BRGMXX from dual 241 09:21:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631107','1','') as BRGMXX from dual 242 09:21:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19631107','2','') as BRGMXX from dual 243 09:21:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 213389803 244 09:21:44 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,197115514 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 245 09:21:45 SQL Execute: ORACLE - select b.YPMC00,a.YPDLBH,b.YPGG00,a.CSL000,a.JLDW00,a.YPYFMC,a.PCMC00,a.YPZSL0,a.QLDW00 as CFDW00,a.TQDJH0 CFHTQH,a.LSDJ00, '1' MZZYBZ,b.PCID00,a.ZHL000,b.CYJL00,b.JLDW00,a.YPNM00,b.YFID00 YFID00,a.QLZT00 CFZT00,a.YYRQ00,a.YPQLPC CFMXID, decode(a.QLZT00, '1','已记账','2','已发药','3','作废','4','待审','5','退药','6','退费','7','退费中','8','退费中','未记账') as CFZTMC from YF_YZYPSQ a,BM_YD0000 b where b.YPNM00 = a.YPNM00 and a.TQDJH0 in ('1') 246 09:22:30 SQL Execute: ORACLE - RollBack 247 09:22:30 SQL Data In: ORACLE - Rows affected = 0 248 09:22:30 SQL Execute: ORACLE - Commit 249 09:22:30 SQL Data In: ORACLE - Rows affected = 0 250 09:22:30 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 22665769 251 09:22:30 SQL Data In: ORACLE - Rows affected = 1 252 09:22:30 SQL Execute: ORACLE - Commit 253 09:22:30 SQL Data In: ORACLE - Rows affected = 0 254 09:22:30 Log started for: SQL Navigator for Oracle 255 09:22:43 Log started for: 易联众医院信息综合管理平台 256 09:22:43 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 257 09:22:43 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.243','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 258 09:22:43 SQL Data In: ORACLE - Rows affected = 1 259 09:22:43 SQL Execute: ORACLE - Commit 260 09:22:43 SQL Data In: ORACLE - Rows affected = 0 261 09:22:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 262 09:22:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='10087' and CZBZ00 in ('0','1') 263 09:22:43 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '10087' and YCLBBZ ='0' and CLBZ00 = '0' 264 09:22:43 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 265 09:22:43 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=4960 and XTDM00 not in ('OE','MC') order by XTDM00 266 09:22:43 SQL Execute: ORACLE - Select SYSDATE from Dual 267 09:22:43 SQL Execute: ORACLE - Select SYSDATE from Dual 268 09:22:43 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 4960 269 09:22:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 4960 270 09:22:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 271 09:22:43 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 272 09:22:43 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 273 09:22:43 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 274 09:22:43 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 275 09:22:43 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 4960 276 09:22:43 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 4960 277 09:22:43 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.243' 278 09:22:43 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 279 09:22:44 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 4960 and RowNum <= 10 order by DLRQSJ DESC 280 09:22:44 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='2' order by BMPLXH,BMBH00 281 09:22:46 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='7' order by BMPLXH,BMBH00 282 09:22:52 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='7' and KJLB00 ='3' 283 09:22:52 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '7' and KJLB00 < '3' order by XH0000 284 09:22:52 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'7'||',')>0 285 09:22:52 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 4960 and XTDM00 = '7' 286 09:22:52 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '7' 287 09:22:52 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2301 and FLAG00 like '0' order by decode(CKBH00,608,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 288 09:22:52 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)) 289 09:22:52 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.243','7',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 290 09:22:52 SQL Data In: ORACLE - Rows affected = 1 291 09:22:52 SQL Execute: ORACLE - Commit 292 09:22:52 SQL Data In: ORACLE - Rows affected = 0 293 09:22:52 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 294 09:22:52 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')) 295 09:22:52 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(23076345,4960,'WINDOWS-J8UNJHL','7',nvl('422369678',' '),'129.7.13.243#4006:45355@appYLZHis.exe',2301,'129.7.13.243') 296 09:22:52 SQL Data In: ORACLE - Rows affected = 1 297 09:22:52 SQL Execute: ORACLE - Commit 298 09:22:52 SQL Data In: ORACLE - Rows affected = 0 299 09:22:52 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' 300 09:22:52 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.243' and NAME00 = 'QDXTJZ' 301 09:22:52 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 = '7' 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 = 4960 and XTDM00 = '7') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 302 09:22:52 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 4960 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 303 09:22:52 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' order by XH0000 304 09:22:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 305 09:22:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 306 09:22:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 307 09:22:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 308 09:22:53 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 309 09:22:53 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 310 09:22:53 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152399105.000000 311 09:22:53 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 312 09:22:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152399105.00) 313 09:22:54 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 314 09:22:54 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='7' 315 09:22:54 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 316 09:22:54 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 = '' 317 09:22:54 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 = '' 318 09:22:54 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2301 319 09:22:54 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2301 320 09:22:54 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 321 09:22:54 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 322 09:22:54 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 323 09:22:54 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2301) as SFBZDJ from dual 324 09:22:54 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YJ_ZHYW.dll' and YGBH00 = 4960 and XTDM00 = '7' 325 09:22:54 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 326 09:22:54 SQL Execute: ORACLE - select YJHTBZ from XT_YYXX00 where YYID00='220006' 327 09:22:54 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_TMTSY','YS_YSXMSQD','ZY_SFSYFPXMZMYHJM','YJ_XMZXDKHQX','YJ_XMZXSLMRYC','YJ_XMZJMRKSYS','YJ_TXMQJZM','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ') 328 09:22:54 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 329 09:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 330 09:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 331 09:22:54 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 332 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ' 333 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB' 334 09:22:54 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 335 09:22:54 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 336 09:22:54 SQL Execute: ORACLE - select 1 from dual where 2301 in (474) 337 09:22:54 SQL Execute: ORACLE - select ZLXMJC,ZLXMID from VW_YJ_KSKFMB where 1=1 and ZXKS00=2301 338 09:22:54 SQL Execute: ORACLE - select * from VW_YJ_LGBR00 where KSRQ00 between '20251219' and '20251222' 339 09:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 340 09:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 341 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='提示未执行项目互相对应科室' and (BH0000=? or MC0000=? ) 342 09:22:54 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='项目抢执行科室对应' and BH0000='2301' 343 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '高值耗材通用接口配置参数' and BH0000 = 'GZHCJK' 344 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 345 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'MultiChannel_Mode' 346 09:22:54 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual 347 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 348 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '标本采样接口平台' and BH0000 = 'BZCYJK_OPEN' 349 09:22:54 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='诊疗带出药品变更功能授权码' and BH0000='YJ_YPAUDSQM' 350 09:22:54 SQL Execute: ORACLE - select '1' from bm_tyzd00 where zdmc00='可变更诊疗带出药品的科室' and BH0000='2301' and YXBZ00='1' 351 09:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 352 09:22:54 SQL Execute: ORACLE - select YFBMBH from BM_KSYFDY where KSBH00=? and YXBZ00='1' 353 09:22:54 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open' 354 09:22:54 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,4960,'管理员','129.7.13.243','6C-4B-90-AB-D8-10','7','ACT_YJ_XMZX','422369678') 355 09:22:54 SQL Data In: ORACLE - Rows affected = 1 356 09:22:54 SQL Execute: ORACLE - Commit 357 09:22:54 SQL Data In: ORACLE - Rows affected = 0 358 09:23:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 359 09:23:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 360 09:23:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 361 09:23:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 362 09:23:01 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251219' and '20251222' order by XMZT00,YJDJH0 Desc 363 09:23:02 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200952280 364 09:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216021687 365 09:23:02 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200952280 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 366 09:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216021687 367 09:23:02 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200952280 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 368 09:23:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6625988 369 09:23:02 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 370 09:23:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(18324848,'1',6625988) from dual 371 09:23:02 SQL Execute: ORACLE - select '18324848' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13400561370' BRLXDH,'00518691' ZYHGHH, '徐发连' BRXM00, '女' BRXB00, '69岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '18324848') FBMC00 , '39' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2408) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='18324848' ) JZFPBZ from dual 372 09:23:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 373 09:23:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18324848','0','') as BRGMXX from dual 374 09:23:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18324848','1','') as BRGMXX from dual 375 09:23:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','18324848','2','') as BRGMXX from dual 376 09:23:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(18324848,'1',6625988) from dual 377 09:23:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216016428 378 09:23:03 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200951504 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 379 09:23:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6626006 380 09:23:03 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 381 09:23:03 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19410142,'1',6626006) from dual 382 09:23:03 SQL Execute: ORACLE - select '19410142' BRID00, '1' MZZYBZ, '住院' MZZYMC, '18060328975' BRLXDH,'00478746' ZYHGHH, '陈信品' BRXM00, '男' BRXB00, '71岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19410142') FBMC00 , '31' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2262) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19410142' ) JZFPBZ from dual 383 09:23:03 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 384 09:23:03 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19410142','0','') as BRGMXX from dual 385 09:23:03 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19410142','1','') as BRGMXX from dual 386 09:23:03 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19410142','2','') as BRGMXX from dual 387 09:23:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216016428 388 09:23:05 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200951504 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 389 09:23:06 SQL Execute: ORACLE - select b.YPMC00,a.YPDLBH,b.YPGG00,a.CSL000,a.JLDW00,a.YPYFMC,a.PCMC00,a.YPZSL0,a.QLDW00 as CFDW00,a.TQDJH0 CFHTQH,a.LSDJ00, '1' MZZYBZ,b.PCID00,a.ZHL000,b.CYJL00,b.JLDW00,a.YPNM00,b.YFID00 YFID00,a.QLZT00 CFZT00,a.YYRQ00,a.YPQLPC CFMXID, decode(a.QLZT00, '1','已记账','2','已发药','3','作废','4','待审','5','退药','6','退费','7','退费中','8','退费中','未记账') as CFZTMC from YF_YZYPSQ a,BM_YD0000 b where b.YPNM00 = a.YPNM00 and a.TQDJH0 in ('1') 390 09:25:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 391 09:25:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 392 09:25:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152399106.000000 393 09:25:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 394 09:25:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152399106.00) 395 09:28:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 396 09:28:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 397 09:28:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152399581.000000 398 09:28:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 399 09:28:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152399581.00) 400 09:31:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 401 09:31:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 402 09:31:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152399752.000000 403 09:31:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 404 09:31:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152399752.00) 405 09:34:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 406 09:34:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 407 09:34:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152400217.000000 408 09:34:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 409 09:34:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152400217.00) 410 09:37:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 411 09:37:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 412 09:37:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152400382.000000 413 09:37:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 414 09:37:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152400382.00) 415 09:40:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 416 09:40:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 417 09:40:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152400855.000000 418 09:40:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 419 09:40:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152400855.00) 420 09:43:52 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 421 09:43:52 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 422 09:43:52 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152401032.000000 423 09:43:52 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 424 09:43:53 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152401032.00) 425 09:46:14 SQL Execute: ORACLE - RollBack 426 09:46:14 SQL Data In: ORACLE - Rows affected = 0 427 09:46:14 SQL Execute: ORACLE - Commit 428 09:46:14 SQL Data In: ORACLE - Rows affected = 0 429 09:46:14 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 23076345 430 09:46:14 SQL Data In: ORACLE - Rows affected = 1 431 09:46:14 SQL Execute: ORACLE - Commit 432 09:46:14 SQL Data In: ORACLE - Rows affected = 0 433 09:46:14 Log started for: SQL Navigator for Oracle 434 11:04:10 Log started for: 易联众医院信息综合管理平台 435 11:04:10 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 436 11:04:10 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.243','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 437 11:04:10 SQL Data In: ORACLE - Rows affected = 1 438 11:04:10 SQL Execute: ORACLE - Commit 439 11:04:10 SQL Data In: ORACLE - Rows affected = 0 440 11:04:10 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 441 11:04:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='10087' and CZBZ00 in ('0','1') 442 11:04:10 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '10087' and YCLBBZ ='0' and CLBZ00 = '0' 443 11:04:10 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 444 11:04:10 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=4960 and XTDM00 not in ('OE','MC') order by XTDM00 445 11:04:10 SQL Execute: ORACLE - Select SYSDATE from Dual 446 11:04:10 SQL Execute: ORACLE - Select SYSDATE from Dual 447 11:04:10 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 4960 448 11:04:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 4960 449 11:04:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 450 11:04:11 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 451 11:04:11 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 452 11:04:11 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 453 11:04:11 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 454 11:04:11 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 4960 455 11:04:11 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 4960 456 11:04:11 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.243' 457 11:04:11 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 458 11:04:11 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 4960 and RowNum <= 10 order by DLRQSJ DESC 459 11:04:12 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='2' order by BMPLXH,BMBH00 460 11:04:14 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='7' order by BMPLXH,BMBH00 461 11:04:18 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='7' and KJLB00 ='3' 462 11:04:18 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '7' and KJLB00 < '3' order by XH0000 463 11:04:18 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'7'||',')>0 464 11:04:19 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 4960 and XTDM00 = '7' 465 11:04:19 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '7' 466 11:04:19 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2301 and FLAG00 like '0' order by decode(CKBH00,608,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 467 11:04:19 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)) 468 11:04:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.243','7',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 469 11:04:19 SQL Data In: ORACLE - Rows affected = 1 470 11:04:19 SQL Execute: ORACLE - Commit 471 11:04:19 SQL Data In: ORACLE - Rows affected = 0 472 11:04:19 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 473 11:04:19 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')) 474 11:04:19 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(23077718,4960,'WINDOWS-J8UNJHL','7',nvl('422385748',' '),'129.7.13.243#3775:37343@appYLZHis.exe',2301,'129.7.13.243') 475 11:04:19 SQL Data In: ORACLE - Rows affected = 1 476 11:04:19 SQL Execute: ORACLE - Commit 477 11:04:19 SQL Data In: ORACLE - Rows affected = 0 478 11:04:19 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' 479 11:04:19 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.243' and NAME00 = 'QDXTJZ' 480 11:04:19 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 = '7' 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 = 4960 and XTDM00 = '7') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 481 11:04:19 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 4960 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 482 11:04:19 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' order by XH0000 483 11:04:19 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 484 11:04:19 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 485 11:04:19 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 486 11:04:19 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 487 11:04:20 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 488 11:04:20 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 489 11:04:20 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152410790.000000 490 11:04:20 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 491 11:04:20 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152410790.00) 492 11:04:20 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 493 11:04:20 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 = '' 494 11:04:20 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 = '' 495 11:04:20 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2301 496 11:04:20 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2301 497 11:04:20 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 498 11:04:20 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 499 11:04:20 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 500 11:04:20 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2301) as SFBZDJ from dual 501 11:04:20 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YJ_ZHYW.dll' and YGBH00 = 4960 and XTDM00 = '7' 502 11:04:20 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 503 11:04:20 SQL Execute: ORACLE - select YJHTBZ from XT_YYXX00 where YYID00='220006' 504 11:04:20 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_TMTSY','YS_YSXMSQD','ZY_SFSYFPXMZMYHJM','YJ_XMZXDKHQX','YJ_XMZXSLMRYC','YJ_XMZJMRKSYS','YJ_TXMQJZM','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ') 505 11:04:20 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 506 11:04:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 507 11:04:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 508 11:04:20 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 509 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ' 510 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB' 511 11:04:21 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 512 11:04:21 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 513 11:04:21 SQL Execute: ORACLE - select 1 from dual where 2301 in (474) 514 11:04:21 SQL Execute: ORACLE - select ZLXMJC,ZLXMID from VW_YJ_KSKFMB where 1=1 and ZXKS00=2301 515 11:04:21 SQL Execute: ORACLE - select * from VW_YJ_LGBR00 where KSRQ00 between '20251219' and '20251222' 516 11:04:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 517 11:04:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 518 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='提示未执行项目互相对应科室' and (BH0000=? or MC0000=? ) 519 11:04:21 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='项目抢执行科室对应' and BH0000='2301' 520 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '高值耗材通用接口配置参数' and BH0000 = 'GZHCJK' 521 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 522 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'MultiChannel_Mode' 523 11:04:21 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual 524 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 525 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '标本采样接口平台' and BH0000 = 'BZCYJK_OPEN' 526 11:04:21 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='诊疗带出药品变更功能授权码' and BH0000='YJ_YPAUDSQM' 527 11:04:21 SQL Execute: ORACLE - select '1' from bm_tyzd00 where zdmc00='可变更诊疗带出药品的科室' and BH0000='2301' and YXBZ00='1' 528 11:04:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 529 11:04:21 SQL Execute: ORACLE - select YFBMBH from BM_KSYFDY where KSBH00=? and YXBZ00='1' 530 11:04:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open' 531 11:04:21 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,4960,'管理员','129.7.13.243','6C-4B-90-AB-D8-10','7','ACT_YJ_XMZX','422385748') 532 11:04:21 SQL Data In: ORACLE - Rows affected = 1 533 11:04:21 SQL Execute: ORACLE - Commit 534 11:04:21 SQL Data In: ORACLE - Rows affected = 0 535 11:04:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 536 11:04:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 537 11:04:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 538 11:04:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 539 11:04:28 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251219' and '20251222' order by XMZT00,YJDJH0 Desc 540 11:04:29 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200966912 541 11:04:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 542 11:04:30 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 543 11:04:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 544 11:04:30 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 545 11:04:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6626191 546 11:04:30 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 547 11:04:30 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19673523,'1',6626191) from dual 548 11:04:30 SQL Execute: ORACLE - select '19673523' BRID00, '1' MZZYBZ, '住院' MZZYMC, '17759076202' BRLXDH,'00518787' ZYHGHH, '郑春生' BRXM00, '男' BRXB00, '72岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19673523') FBMC00 , '30' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2409) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19673523' ) JZFPBZ from dual 549 11:04:30 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 550 11:04:30 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','0','') as BRGMXX from dual 551 11:04:30 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','1','') as BRGMXX from dual 552 11:04:30 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','2','') as BRGMXX from dual 553 11:04:30 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19673523,'1',6626191) from dual 554 11:04:31 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200966122 555 11:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038708 556 11:04:31 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966122 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 557 11:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038708 558 11:04:31 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966122 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 559 11:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038708 560 11:04:31 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966122 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 561 11:04:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6626193 562 11:04:31 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 563 11:04:31 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19570280,'1',6626193) from dual 564 11:04:31 SQL Execute: ORACLE - select '19570280' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13489099456' BRLXDH,'00504244' ZYHGHH, '王国柱' BRXM00, '男' BRXB00, '68岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19570280') FBMC00 , '47' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2408) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19570280' ) JZFPBZ from dual 565 11:04:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 566 11:04:31 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19570280','0','') as BRGMXX from dual 567 11:04:31 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19570280','1','') as BRGMXX from dual 568 11:04:31 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19570280','2','') as BRGMXX from dual 569 11:04:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038708 570 11:04:32 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966122 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 571 11:04:33 SQL Execute: ORACLE - select b.YPMC00,a.YPDLBH,b.YPGG00,a.CSL000,a.JLDW00,a.YPYFMC,a.PCMC00,a.YPZSL0,a.QLDW00 as CFDW00,to_char(a.TQDJH0) CFHTQH,a.LSDJ00, '1' MZZYBZ,b.PCID00,a.ZHL000,b.CYJL00,b.JLDW00,a.YPNM00,b.YFID00 YFID00,a.QLZT00 CFZT00,a.YYRQ00,a.YPQLPC CFMXID, decode(a.QLZT00, '1','已记账','2','已发药','3','作废','4','待审','5','退药','6','退费','7','退费中','8','退费中','未记账') as CFZTMC from YF_YZYPSQ a,BM_YD0000 b where b.YPNM00 = a.YPNM00 and a.TQDJH0 in ('1') 572 11:04:34 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 573 11:04:34 SQL Execute: ORACLE - select YPMC00,YPGG00,YPBM00,WBSM00,YPNM00,LSJ000,SJKCSL,PYSM00,MZFYDW,ZYFYDW,LBBH00,YFID00,PCID00,FYDW00,CYJL00,JLDW00,ZHL000 from VW_YJ_ZKYD00 where (PYSM00 Like '%%' or YPBM00 Like '%%') and ( YFBMBH=4443 ) and Rownum<=1000 574 11:04:38 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200962970 575 11:04:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216034352 576 11:04:38 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200962970 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 577 11:04:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216034352 578 11:04:38 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200962970 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 579 11:04:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216034352 580 11:04:38 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200962970 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 581 11:04:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6624743 582 11:04:38 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 583 11:04:38 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(2052018,'1',6624743) from dual 584 11:04:38 SQL Execute: ORACLE - select '2052018' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13788881561' BRLXDH,'00503702' ZYHGHH, '施依' BRXM00, '男' BRXB00, '75岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '2052018') FBMC00 , '58' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2260) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='2052018' ) JZFPBZ from dual 585 11:04:38 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 586 11:04:38 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','2052018','0','') as BRGMXX from dual 587 11:04:38 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','2052018','1','') as BRGMXX from dual 588 11:04:38 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','2052018','2','') as BRGMXX from dual 589 11:04:41 SQL Execute: ORACLE - RollBack 590 11:04:41 SQL Data In: ORACLE - Rows affected = 0 591 11:04:41 SQL Execute: ORACLE - Commit 592 11:04:41 SQL Data In: ORACLE - Rows affected = 0 593 11:04:41 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 23077718 594 11:04:41 SQL Data In: ORACLE - Rows affected = 1 595 11:04:41 SQL Execute: ORACLE - Commit 596 11:04:41 SQL Data In: ORACLE - Rows affected = 0 597 11:04:41 Log started for: SQL Navigator for Oracle 598 11:06:09 Log started for: 易联众医院信息综合管理平台 599 11:06:09 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 600 11:06:09 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '129.7.13.243','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 601 11:06:09 SQL Data In: ORACLE - Rows affected = 1 602 11:06:09 SQL Execute: ORACLE - Commit 603 11:06:09 SQL Data In: ORACLE - Rows affected = 0 604 11:06:09 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 605 11:06:09 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='10087' and CZBZ00 in ('0','1') 606 11:06:09 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '10087' and YCLBBZ ='0' and CLBZ00 = '0' 607 11:06:09 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 608 11:06:09 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=4960 and XTDM00 not in ('OE','MC') order by XTDM00 609 11:06:09 SQL Execute: ORACLE - Select SYSDATE from Dual 610 11:06:09 SQL Execute: ORACLE - Select SYSDATE from Dual 611 11:06:09 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 4960 612 11:06:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 4960 613 11:06:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 614 11:06:10 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 615 11:06:10 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 616 11:06:10 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 617 11:06:10 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 618 11:06:10 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 4960 619 11:06:10 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 4960 620 11:06:10 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '129.7.13.243' 621 11:06:10 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 622 11:06:10 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 4960 and RowNum <= 10 order by DLRQSJ DESC 623 11:06:10 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='2' order by BMPLXH,BMBH00 624 11:06:14 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 4960 and XTDM00='7' order by BMPLXH,BMBH00 625 11:06:19 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='7' and KJLB00 ='3' 626 11:06:19 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '7' and KJLB00 < '3' order by XH0000 627 11:06:19 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'7'||',')>0 628 11:06:19 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 4960 and XTDM00 = '7' 629 11:06:19 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '7' 630 11:06:19 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 2301 and FLAG00 like '0' order by decode(CKBH00,608,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 631 11:06:19 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)) 632 11:06:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '129.7.13.243','7',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 633 11:06:19 SQL Data In: ORACLE - Rows affected = 1 634 11:06:19 SQL Execute: ORACLE - Commit 635 11:06:19 SQL Data In: ORACLE - Rows affected = 0 636 11:06:19 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 637 11:06:19 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')) 638 11:06:19 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(23077743,4960,'WINDOWS-J8UNJHL','7',nvl('422385903',' '),'129.7.13.243#125:509@appYLZHis.exe',2301,'129.7.13.243') 639 11:06:19 SQL Data In: ORACLE - Rows affected = 1 640 11:06:19 SQL Execute: ORACLE - Commit 641 11:06:19 SQL Data In: ORACLE - Rows affected = 0 642 11:06:19 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' 643 11:06:19 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '129.7.13.243' and NAME00 = 'QDXTJZ' 644 11:06:19 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 = '7' 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 = 4960 and XTDM00 = '7') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 645 11:06:19 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 4960 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 646 11:06:19 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=4960 and XTDM00='7' order by XH0000 647 11:06:19 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 648 11:06:19 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 649 11:06:19 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 650 11:06:19 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 651 11:06:20 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 652 11:06:20 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 653 11:06:20 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 152410911.000000 654 11:06:20 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 655 11:06:20 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 4960 and CZXH00 = 152410911.00) 656 11:06:20 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 657 11:06:20 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 = '' 658 11:06:20 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 = '' 659 11:06:21 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=2301 660 11:06:21 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=2301 661 11:06:21 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220006' 662 11:06:21 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 663 11:06:21 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 664 11:06:21 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(2301) as SFBZDJ from dual 665 11:06:21 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YJ_ZHYW.dll' and YGBH00 = 4960 and XTDM00 = '7' 666 11:06:21 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 667 11:06:21 SQL Execute: ORACLE - select YJHTBZ from XT_YYXX00 where YYID00='220006' 668 11:06:21 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_TMTSY','YS_YSXMSQD','ZY_SFSYFPXMZMYHJM','YJ_XMZXDKHQX','YJ_XMZXSLMRYC','YJ_XMZJMRKSYS','YJ_TXMQJZM','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ') 669 11:06:21 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 670 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 671 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 672 11:06:21 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 673 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ' 674 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB' 675 11:06:21 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 676 11:06:21 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 677 11:06:21 SQL Execute: ORACLE - select 1 from dual where 2301 in (474) 678 11:06:21 SQL Execute: ORACLE - select ZLXMJC,ZLXMID from VW_YJ_KSKFMB where 1=1 and ZXKS00=2301 679 11:06:21 SQL Execute: ORACLE - select * from VW_YJ_LGBR00 where KSRQ00 between '20251219' and '20251222' 680 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 681 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 682 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='提示未执行项目互相对应科室' and (BH0000=? or MC0000=? ) 683 11:06:21 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='项目抢执行科室对应' and BH0000='2301' 684 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '高值耗材通用接口配置参数' and BH0000 = 'GZHCJK' 685 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 686 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'MultiChannel_Mode' 687 11:06:21 SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual 688 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 689 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '标本采样接口平台' and BH0000 = 'BZCYJK_OPEN' 690 11:06:21 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='诊疗带出药品变更功能授权码' and BH0000='YJ_YPAUDSQM' 691 11:06:21 SQL Execute: ORACLE - select '1' from bm_tyzd00 where zdmc00='可变更诊疗带出药品的科室' and BH0000='2301' and YXBZ00='1' 692 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 693 11:06:21 SQL Execute: ORACLE - select YFBMBH from BM_KSYFDY where KSBH00=? and YXBZ00='1' 694 11:06:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open' 695 11:06:21 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,4960,'管理员','129.7.13.243','6C-4B-90-AB-D8-10','7','ACT_YJ_XMZX','422385903') 696 11:06:21 SQL Data In: ORACLE - Rows affected = 1 697 11:06:21 SQL Execute: ORACLE - Commit 698 11:06:21 SQL Data In: ORACLE - Rows affected = 0 699 11:06:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 700 11:06:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 701 11:06:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 702 11:06:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2301 703 11:06:26 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',2207,',',2301,')>0)) and (1=1 and (a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and KDRQ00 between '20251219' and '20251222' order by XMZT00,YJDJH0 Desc 704 11:06:27 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200967685 705 11:06:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216039804 706 11:06:27 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200967685 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 707 11:06:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216039804 708 11:06:27 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200967685 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 709 11:06:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6626181 710 11:06:27 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 711 11:06:27 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19673428,'1',6626181) from dual 712 11:06:27 SQL Execute: ORACLE - select '19673428' BRID00, '1' MZZYBZ, '住院' MZZYMC, '13960922873' BRLXDH,'00518774' ZYHGHH, '金章雨' BRXM00, '男' BRXB00, '55岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19673428') FBMC00 , '3' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=10654) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19673428' ) JZFPBZ from dual 713 11:06:27 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 714 11:06:27 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673428','0','') as BRGMXX from dual 715 11:06:27 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673428','1','') as BRGMXX from dual 716 11:06:27 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673428','2','') as BRGMXX from dual 717 11:06:27 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19673428,'1',6626181) from dual 718 11:06:29 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 200966912 719 11:06:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 720 11:06:29 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 721 11:06:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 722 11:06:29 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 723 11:06:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 724 11:06:29 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 725 11:06:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6626191 726 11:06:29 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=? 727 11:06:29 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(19673523,'1',6626191) from dual 728 11:06:29 SQL Execute: ORACLE - select '19673523' BRID00, '1' MZZYBZ, '住院' MZZYMC, '17759076202' BRLXDH,'00518787' ZYHGHH, '郑春生' BRXM00, '男' BRXB00, '72岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '19673523') FBMC00 , '30' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=2409) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='19673523' ) JZFPBZ from dual 729 11:06:29 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 730 11:06:29 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','0','') as BRGMXX from dual 731 11:06:29 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','1','') as BRGMXX from dual 732 11:06:29 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','19673523','2','') as BRGMXX from dual 733 11:06:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216038568 734 11:06:30 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,200966912 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0' 735 11:06:32 SQL Execute: ORACLE - select b.YPMC00,a.YPDLBH,b.YPGG00,a.CSL000,a.JLDW00,a.YPYFMC,a.PCMC00,a.YPZSL0,a.QLDW00 as CFDW00,to_char(a.TQDJH0) CFHTQH,a.LSDJ00, '1' MZZYBZ,b.PCID00,a.ZHL000,b.CYJL00,b.JLDW00,a.YPNM00,b.YFID00 YFID00,a.QLZT00 CFZT00,a.YYRQ00,a.YPQLPC CFMXID, decode(a.QLZT00, '1','已记账','2','已发药','3','作废','4','待审','5','退药','6','退费','7','退费中','8','退费中','未记账') as CFZTMC from YF_YZYPSQ a,BM_YD0000 b where b.YPNM00 = a.YPNM00 and a.TQDJH0 in ('1') 736 11:06:33 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 737 11:06:33 SQL Execute: ORACLE - select YPMC00,YPGG00,YPBM00,WBSM00,YPNM00,LSJ000,SJKCSL,PYSM00,MZFYDW,ZYFYDW,LBBH00,YFID00,PCID00,FYDW00,CYJL00,JLDW00,ZHL000 from VW_YJ_ZKYD00 where (PYSM00 Like '%%' or YPBM00 Like '%%') and ( YFBMBH=4443 ) and Rownum<=1000 738 11:06:39 SQL Data In: ORACLE - Param = 1, Name = PYPBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 9000095602 739 11:06:39 SQL Data In: ORACLE - Param = 2, Name = PBMBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 740 11:06:39 SQL Data In: ORACLE - Param = 3, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 741 11:06:39 SQL Data In: ORACLE - Param = 4, Name = PZB0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 742 11:06:39 SQL Data In: ORACLE - Param = 5, Name = PJJYPMC, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 743 11:06:39 SQL Execute: ORACLE - BEGIN "SP_BM_YPJJPD" (PYPBM00 => :PYPBM00,PBMBZ00 => :PBMBZ00,PZYID00 => :PZYID00,PZB0000 => :PZB0000,PJJYPMC => :PJJYPMC); END; 744 11:06:40 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = ZYYF_ZYCFH 745 11:06:40 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 746 11:06:40 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 747 11:06:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 748 11:06:40 SQL Execute: ORACLE - select RYBQ00 from ZY_BRXXB0 where ZYID00=? 749 11:06:40 SQL Execute: ORACLE - select sq_bq_ypyz00_yzid00.nextval from dual 750 11:06:40 SQL Execute: ORACLE - select YFLBID from BM_YPYF00 where YFID00=573 751 11:06:40 SQL Execute: ORACLE - select SQ_BQ_YZMX00_YZMXID.NEXTVAL from dual 752 11:06:40 SQL Execute: ORACLE - select YPYFMC from BM_YPYF00 where YFID00=573 753 11:06:40 SQL Execute: ORACLE - select PCMC00 from BM_PC0000 where PCID00=22 754 11:06:40 SQL Execute: ORACLE - select b.ZQS000 as YYSJ00 from BM_YD0000 b where b.YPNM00=9000095602 755 11:06:40 SQL Execute: ORACLE - select c.ZQDW00 as YYSJDW from BM_YD0000 b, BM_PC0000 c where b.PCID00=c.PCID00 and b.YPNM00=9000095602 756 11:06:40 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 757 11:06:40 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 758 11:06:40 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 759 11:06:40 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 760 11:06:40 SQL Data In: ORACLE - Param = 2, Name = PYPQLPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 761 11:06:40 SQL Data In: ORACLE - Param = 3, Name = PTQDJH0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216040669 762 11:06:40 SQL Data In: ORACLE - Param = 4, Name = PYFBMBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4443 763 11:06:40 SQL Data In: ORACLE - Param = 5, Name = PBQBMBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 764 11:06:40 SQL Data In: ORACLE - Param = 6, Name = PSSKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 765 11:06:40 SQL Data In: ORACLE - Param = 7, Name = PDQKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 766 11:06:40 SQL Data In: ORACLE - Param = 8, Name = PZYID00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 767 11:06:40 SQL Data In: ORACLE - Param = 9, Name = PYFLBID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 768 11:06:40 SQL Data In: ORACLE - Param = 10, Name = PHZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 769 11:06:40 SQL Data In: ORACLE - Param = 11, Name = PYZID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 133502 770 11:06:40 SQL Data In: ORACLE - Param = 12, Name = PYZMXID, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 216040670 771 11:06:40 SQL Data In: ORACLE - Param = 13, Name = PZYTS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 772 11:06:40 SQL Data In: ORACLE - Param = 14, Name = PYSGZH0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 4960 773 11:06:40 SQL Data In: ORACLE - Param = 15, Name = PYPDLBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 774 11:06:40 SQL Data In: ORACLE - Param = 16, Name = PYPNM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 9000095602 775 11:06:40 SQL Data In: ORACLE - Param = 17, Name = PYPMC00, Type = fldZSTRING, Precision = 28, Scale = 0, Data = !(优维显)碘普罗胺注射液(省5) 776 11:06:40 SQL Data In: ORACLE - Param = 18, Name = PYPGG00, Type = fldZSTRING, Precision = 15, Scale = 0, Data = 100ml:76.89g/瓶 777 11:06:40 SQL Data In: ORACLE - Param = 19, Name = PQLDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 瓶 778 11:06:40 SQL Data In: ORACLE - Param = 20, Name = PZHL000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 100 779 11:06:40 SQL Data In: ORACLE - Param = 21, Name = PCSL000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 100 780 11:06:40 SQL Data In: ORACLE - Param = 22, Name = PJLDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = ml 781 11:06:40 SQL Data In: ORACLE - Param = 23, Name = PYPZSL0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 782 11:06:40 SQL Data In: ORACLE - Param = 24, Name = PYFID00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 573 783 11:06:40 SQL Data In: ORACLE - Param = 25, Name = PYPYFMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 静脉注射 784 11:06:40 SQL Data In: ORACLE - Param = 26, Name = PYFSMMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 785 11:06:40 SQL Data In: ORACLE - Param = 27, Name = PZJYFMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 786 11:06:40 SQL Data In: ORACLE - Param = 28, Name = PXMYFMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 787 11:06:40 SQL Data In: ORACLE - Param = 29, Name = PPCID00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 22 788 11:06:40 SQL Data In: ORACLE - Param = 30, Name = PPCMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = p.r.n. 789 11:06:40 SQL Data In: ORACLE - Param = 31, Name = PPCSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 790 11:06:40 SQL Data In: ORACLE - Param = 32, Name = PYYSJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 791 11:06:40 SQL Data In: ORACLE - Param = 33, Name = PYYSJDW, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 天 792 11:06:40 SQL Data In: ORACLE - Param = 34, Name = PCXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 793 11:06:40 SQL Data In: ORACLE - Param = 35, Name = PCXPCID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 794 11:06:40 SQL Data In: ORACLE - Param = 36, Name = PSFXS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 795 11:06:40 SQL Data In: ORACLE - Param = 37, Name = PSRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251222 796 11:06:40 SQL Data In: ORACLE - Param = 38, Name = PSRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:06:40 797 11:06:40 SQL Data In: ORACLE - Param = 39, Name = PBZ0000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 诊疗带出处方 798 11:06:40 SQL Data In: ORACLE - Param = 40, Name = PZYDJS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 799 11:06:40 SQL Data In: ORACLE - Param = 41, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 800 11:06:40 SQL Data In: ORACLE - Param = 42, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4960.000000 801 11:06:40 SQL Data In: ORACLE - Param = 43, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2301.000000 802 11:06:40 SQL Data In: ORACLE - Param = 44, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 803 11:06:40 SQL Data In: ORACLE - Param = 45, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 804 11:06:40 SQL Data In: ORACLE - Param = 46, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 805 11:06:40 SQL Data In: ORACLE - Param = 47, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 806 11:06:40 SQL Data In: ORACLE - Param = 48, Name = PSFXJJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 807 11:06:40 SQL Data In: ORACLE - Param = 49, Name = PTHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 808 11:06:40 SQL Data In: ORACLE - Param = 50, Name = PYYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20251222 809 11:06:40 SQL Data In: ORACLE - Param = 51, Name = PYZXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 810 11:06:40 SQL Data In: ORACLE - Param = 52, Name = PSFKSLY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 811 11:06:40 SQL Data In: ORACLE - Param = 53, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 812 11:06:40 SQL Data In: ORACLE - Param = 54, Name = PZFFSBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 813 11:06:40 SQL Data In: ORACLE - Param = 55, Name = PGJBZBM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 814 11:06:40 SQL Data In: ORACLE - Param = 56, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 815 11:06:40 SQL Data In: ORACLE - Param = 57, Name = PZDM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 816 11:06:40 SQL Data In: ORACLE - Param = 58, Name = PDBRZJH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 817 11:06:40 SQL Data In: ORACLE - Param = 59, Name = PZBYBZ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 818 11:06:40 SQL Data In: ORACLE - Param = 60, Name = PBLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 819 11:06:40 SQL Execute: ORACLE - BEGIN "SP_YF_YZYPSQ_EDIT" (POPFLAG => :POPFLAG,PYPQLPC => :PYPQLPC,PTQDJH0 => :PTQDJH0,PYFBMBH => :PYFBMBH,PBQBMBH => :PBQBMBH,PSSKS00 => :PSSKS00,PDQKS00 => :PDQKS00,PZYID00 => :PZYID00,PYFLBID => :PYFLBID,PHZBZ00 => :PHZBZ00,PYZID00 => :PYZID00,PYZMXID => :PYZMXID,PZYTS00 => :PZYTS00,PYSGZH0 => :PYSGZH0,PYPDLBH => :PYPDLBH,PYPNM00 => :PYPNM00,PYPMC00 => :PYPMC00,PYPGG00 => :PYPGG00,PQLDW00 => :PQLDW00,PZHL000 => :PZHL000,PCSL000 => :PCSL000,PJLDW00 => :PJLDW00,PYPZSL0 => :PYPZSL0,PYFID00 => :PYFID00,PYPYFMC => :PYPYFMC,PYFSMMC => :PYFSMMC,PZJYFMC => :PZJYFMC,PXMYFMC => :PXMYFMC,PPCID00 => :PPCID00,PPCMC00 => :PPCMC00,PPCSJ00 => :PPCSJ00,PYYSJ00 => :PYYSJ00,PYYSJDW => :PYYSJDW,PCXBZ00 => :PCXBZ00,PCXPCID => :PCXPCID,PSFXS00 => :PSFXS00,PSRRQ00 => :PSRRQ00,PSRSJ00 => :PSRSJ00,PBZ0000 => :PBZ0000,PZYDJS0 => :PZYDJS0,PYEXM00 => :PYEXM00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PSFXJJZ => :PSFXJJZ,PTHBZ00 => :PTHBZ00,PYYRQ00 => :PYYRQ00,PYZXZ00 => :PYZXZ00,PSFKSLY => :PSFKSLY,PSSDH00 => :PSSDH00,PZFFSBZ => :PZFFSBZ,PGJBZBM => :PGJBZBM,PZDMC00 => :PZDMC00,PZDM000 => :PZDM000,PDBRZJH => :PDBRZJH,PZBYBZ0 => :PZBYBZ0,PBLBZ00 => :PBLBZ00); END; 820 11:06:40 SQL Error: ORACLE - ORA-20001: 没有找到数据！*ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.SP_YF_YZYPSQ_EDIT", line 426 ORA-06512: 在 line 1 821 11:06:40 SQL Error: ORACLE - Unmapped SQL Error Code: 20001