1 11:26:05 SQL Execute: ORACLE - Select * from VW_TJ_YJ_YW0000 b where YYID00 = '222137' AND (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and ZYGHID in (13861242) and (KDKSBH=34 or YJKSBH=34) and xmzt00 in('0','1','2') order by YJdjh0,KSXH00 2 11:26:12 SQL Execute: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 1114 3 11:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = s% 4 11:26:14 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 5 11:26:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = sy% 6 11:26:15 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 7 11:26:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = syc% 8 11:26:15 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 9 11:26:17 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=762 10 11:26:17 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='762' order by dwzbid 11 11:26:17 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 12 11:26:17 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='762' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 13 11:26:17 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746482' 14 11:26:17 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13690394' and (KDKSBH=34 or YJKSBH=34) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 15 11:26:17 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746482 16 11:26:17 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13690394) 17 11:26:17 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=762 18 11:26:17 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='762' order by dwzbid 19 11:26:17 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 20 11:26:17 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='762' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 21 11:26:18 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746482' 22 11:26:18 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13690394' and (KDKSBH=34 or YJKSBH=34) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 23 11:26:18 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746482 24 11:26:18 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13690394) 25 11:26:22 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746493' 26 11:26:22 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13861242' and (KDKSBH=34 or YJKSBH=34) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 27 11:26:22 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746493 28 11:26:22 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13861242) 29 11:26:33 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 30 11:26:33 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','298','3160' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 31 11:26:33 SQL Data In: ORACLE - Rows affected = 1 32 11:26:33 SQL Execute: ORACLE - Commit 33 11:26:33 SQL Data In: ORACLE - Rows affected = 0 34 11:26:33 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 35 11:26:33 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 36 11:26:33 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 37 11:26:33 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 38 11:26:33 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','303','7633' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:5A903F71852CD02AC8E9F0B697C1754E' from dual 39 11:26:33 SQL Data In: ORACLE - Rows affected = 1 40 11:26:33 SQL Execute: ORACLE - Commit 41 11:26:33 SQL Data In: ORACLE - Rows affected = 0 42 11:26:33 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 43 11:26:33 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 44 11:26:33 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 45 11:26:33 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 46 11:27:01 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '125' 47 11:27:01 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 48 11:27:01 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 49 11:27:01 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 50 11:27:01 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 51 11:27:01 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4188450 52 11:27:01 SQL Data In: ORACLE - Rows affected = 1 53 11:27:01 SQL Execute: ORACLE - Commit 54 11:27:01 SQL Data In: ORACLE - Rows affected = 0 55 11:27:01 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 56 11:27:01 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 57 11:27:01 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 58 11:27:01 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188452,1114,'wlzx-3','T',nvl('228505680',' '),'192.168.5.33#303:7633@MedicalExa.exe+健康体检系统',125) 59 11:27:01 SQL Data In: ORACLE - Rows affected = 1 60 11:27:01 SQL Execute: ORACLE - Commit 61 11:27:01 SQL Data In: ORACLE - Rows affected = 0 62 11:27:01 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125 63 11:27:01 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 64 11:27:01 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 65 11:27:01 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 66 11:27:01 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 67 11:27:01 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 125 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 68 11:27:01 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140911' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 69 11:27:01 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 70 11:27:01 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 71 11:27:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='T'))) 72 11:27:01 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 73 11:27:01 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 74 11:27:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 75 11:27:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 76 11:27:01 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 77 11:27:01 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 78 11:27:01 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1114' 79 11:27:01 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 80 11:27:01 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ') 81 11:27:01 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 82 11:27:18 SQL Execute: ORACLE - select ZGZKL0 AS ZKL000 from BM_ZKLQXB where YGBH00 = 1114 83 11:27:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = s% 84 11:27:23 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 85 11:27:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = sy% 86 11:27:25 SQL Execute: ORACLE - Select * from (select DWMC00,DWBH00,PY0000,WB0000,DWID00,DWZKL0,DWTJCS,DWXZ00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '222137' ) Order By PY0000) where Rownum<=30 87 11:27:27 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=762 88 11:27:27 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='762' order by dwzbid 89 11:27:27 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 90 11:27:27 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='762' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 91 11:27:27 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746482' 92 11:27:27 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13690394' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 93 11:27:27 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746482 94 11:27:27 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13690394) 95 11:27:27 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=762 96 11:27:27 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='762' order by dwzbid 97 11:27:27 SQL Execute: ORACLE - SELECT TCBH00 BH0000,TCMC00 MC0000,XSSX00 FROM TJ_TCWH00 WHERE YYID00 = '222137' AND YXBZ00='Y' order by XSSX00 98 11:27:27 SQL Execute: ORACLE - SELECT RYBH00,GHID00,GHH000,BRBLH0,BRID00,FBMC00,BRXM00,BRXB00,BRCSRQ,BRNL00,XX0000, TJRQ00,SFTJ00,FBBH00,EPHOTO,'N' SFXZ00,JYKDY0,SFRZTJ,ZYDYRQ FROM VW_TJ_BRXXB0 WHERE DWID00='762' AND SFYX00='Y' AND DWTJCS='1' ORDER BY RYBH00 99 11:27:28 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746482' 100 11:27:28 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13690394' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 101 11:27:28 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746482 102 11:27:28 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13690394) 103 11:27:30 SQL Execute: ORACLE - select ephoto from bm_brxxb0 where brid00='3746493' 104 11:27:30 SQL Execute: ORACLE - Select B.*,(B.ZJE000 - B.ZHJE00) ZKE000 from VW_TJ_YJ_YW0000 b where ZYGHID='13861242' and (KDKSBH=125 or YJKSBH=125) and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) AND B.YYID00 = '222137' order by YJdjh0,KSXH00 105 11:27:31 SQL Execute: ORACLE - select FBBH00 from BM_BRXXB0 where BRID00=3746493 106 11:27:31 SQL Execute: ORACLE - select sum(ZFJE00) from YJ_YWJJ00 a,TJ_YJDJH0 b where a.YJDJH0=b.YJDJH0 and CXBZ00='Z' and a.YJDJH0 in (select YJDJH0 from YJ_YW0000 where ZYGHID=13861242) 107 11:27:56 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 108 11:27:56 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','303','7635' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:CB99DFF7787F4059E70A7B68AD2C97D6' from dual 109 11:27:56 SQL Data In: ORACLE - Rows affected = 1 110 11:27:56 SQL Execute: ORACLE - Commit 111 11:27:56 SQL Data In: ORACLE - Rows affected = 0 112 11:27:56 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 113 11:27:56 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 114 11:27:56 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 115 11:27:56 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 116 11:27:56 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','298','3168' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:5A903F71852CD02AC8E9F0B697C1754E' from dual 117 11:27:56 SQL Data In: ORACLE - Rows affected = 1 118 11:27:56 SQL Execute: ORACLE - Commit 119 11:27:56 SQL Data In: ORACLE - Rows affected = 0 120 11:27:56 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T' 121 11:27:56 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 122 11:27:56 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T' 123 11:27:56 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 124 11:28:18 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '46' 125 11:28:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 126 11:28:18 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'T' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='T' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 127 11:28:18 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 128 11:28:18 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 129 11:28:18 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4188452 130 11:28:18 SQL Data In: ORACLE - Rows affected = 1 131 11:28:18 SQL Execute: ORACLE - Commit 132 11:28:18 SQL Data In: ORACLE - Rows affected = 0 133 11:28:18 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 134 11:28:18 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 135 11:28:18 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 136 11:28:18 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188453,1114,'wlzx-3','T',nvl('228505682',' '),'192.168.5.33#298:3168@MedicalExa.exe+健康体检系统',46) 137 11:28:18 SQL Data In: ORACLE - Rows affected = 1 138 11:28:18 SQL Execute: ORACLE - Commit 139 11:28:18 SQL Data In: ORACLE - Rows affected = 0 140 11:28:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46 141 11:28:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 142 11:28:18 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 143 11:28:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 144 11:28:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 145 11:28:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 46 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 146 11:28:18 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140911' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',46,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='T') 147 11:28:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 148 11:28:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 149 11:28:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='T'))) 150 11:28:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 151 11:28:18 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 152 11:28:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 153 11:28:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 154 11:28:18 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID' 155 11:28:18 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%' 156 11:28:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1114' 157 11:28:18 SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%' 158 11:28:18 SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ') 159 11:28:18 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 160 07:42:31 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6833998' AND ROWNUM = 1) 161 07:42:31 SQL Execute: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '762' 162 07:42:31 SQL Execute: ORACLE - select GHID00 from SF_BRXXB0 where GHH000='6833998' 163 07:42:31 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00='13861242' 164 07:42:31 SQL Execute: ORACLE - Select * from VW_TJ_YJ_YW0000 b where YYID00 = '222137' AND (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and ZYGHID in (13861242) and (KDKSBH=46 or YJKSBH=46) and xmzt00 in('0','1','2') order by YJdjh0,KSXH00 165 07:42:33 SQL Execute: ORACLE - SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = (SELECT GHID00 FROM SF_BRXXB0 WHERE GHH000 = '6833998' AND ROWNUM = 1) 166 07:42:33 SQL Execute: ORACLE - SELECT TRIM(YYID00) FROM BM_TYDWB0 WHERE DWID00 = '762' 167 07:42:33 SQL Execute: ORACLE - select GHID00 from SF_BRXXB0 where GHH000='6833998' 168 07:42:33 SQL Execute: ORACLE - SELECT * FROM VW_TJ_BRXXB0 WHERE GHID00>0 AND GHID00='13861242' 169 07:42:33 SQL Execute: ORACLE - Select * from VW_TJ_YJ_YW0000 b where YYID00 = '222137' AND (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and ZYGHID in (13861242) and (KDKSBH=46 or YJKSBH=46) and xmzt00 in('0','1','2') order by YJdjh0,KSXH00 170 07:43:41 Log started for: 后台维护系统 171 07:43:41 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 172 07:43:41 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 173 07:43:41 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 174 07:43:41 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','6','Authority.exe'||'+'||'后台维护系统','212','17342' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@super:4FEF60119F70D5321E2D46745E90A57C' from dual 175 07:43:41 SQL Data In: ORACLE - Rows affected = 1 176 07:43:41 SQL Execute: ORACLE - Commit 177 07:43:41 SQL Data In: ORACLE - Rows affected = 0 178 07:43:41 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='6' 179 07:43:41 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00 in ('1') 180 07:43:41 SQL Execute: ORACLE - Select SYSDATE from Dual 181 07:43:41 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 182 07:43:41 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 183 07:43:41 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 184 07:43:41 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 185 07:43:41 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 186 07:43:41 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') order by BH0000 187 07:43:41 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'super'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER')) 188 07:43:41 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=0 189 07:43:41 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 190 07:43:41 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 191 07:43:41 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 192 07:43:41 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 193 07:43:41 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 194 07:43:43 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4283308,0,'wlzx-3','6',nvl('228644174',' '),'',15) 195 07:43:43 SQL Data In: ORACLE - Rows affected = 1 196 07:43:43 SQL Execute: ORACLE - Commit 197 07:43:43 SQL Data In: ORACLE - Rows affected = 0 198 07:43:43 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 199 07:43:43 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 200 07:43:43 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 201 07:43:43 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 202 07:43:43 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 203 07:43:43 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 204 07:43:43 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 205 07:43:43 SQL Data In: ORACLE - Rows affected = 0 206 07:43:43 SQL Execute: ORACLE - Commit 207 07:43:43 SQL Data In: ORACLE - Rows affected = 0 208 07:43:43 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 209 07:43:43 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 210 07:43:43 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'6'||',')>0 211 07:43:44 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 212 07:43:44 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20140912' and XXXZ00='1' and (XTDM00='-1' or XTDM00='6') 213 07:43:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 214 07:43:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 215 07:43:45 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 216 07:43:45 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 217 07:43:45 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 218 07:43:45 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 219 07:43:45 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='6'))) 220 07:43:45 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 221 07:43:45 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='0 '))) 222 07:43:45 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=0 and XTDM00='+ '))) 223 07:43:45 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 224 07:43:45 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('XT_YSXGFBKS','XT_XTXXYTJRXG','YF_SFXSGJJ','XT_SFXSGLYKFPQX') 225 07:43:45 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 0 226 07:43:58 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_YYXX00' order by 1 ASC, 2 ASC 227 07:43:58 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_YYXX00' order by owner ASC, index_name ASC 228 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_YYXX00_YYID00' order by column_position ASC 229 07:43:58 SQL Execute: ORACLE - SELECT "YYID00", "YYQC00", "YYJC00", "XKZH00", "YYBZ10", "YYBZ20", "FLAG00", "YYDJ00", "YYFZ00" FROM "XT_YYXX00" 230 07:43:58 SQL Execute: ORACLE - SELECT "YYID00", "YYQC00", "YYJC00", "XKZH00", "YYBZ10", "YYBZ20", "FLAG00", "YYDJ00", "YYFZ00" FROM "XT_YYXX00" WHERE ("FLAG00") <> (0) ORDER BY "YYID00" 231 07:43:58 SQL Execute: ORACLE - SELECT "YYID00", "YYQC00", "YYJC00", "XKZH00", "YYBZ10", "YYBZ20", "FLAG00", "YYDJ00", "YYFZ00" FROM "XT_YYXX00" WHERE ("FLAG00") <> (0) ORDER BY "YYID00" 232 07:43:58 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'BM_BMBM00' order by 1 ASC, 2 ASC 233 07:43:58 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'BM_BMBM00' order by owner ASC, index_name ASC 234 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'INDEX_BM_BMBM00_BMMC00' order by column_position ASC 235 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'INDEX_BM_BMBM00_PYSM00' order by column_position ASC 236 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'INDEX_BM_BMBM00_WBSM00' order by column_position ASC 237 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_BM_BMBM00_BMBH00' order by column_position ASC 238 07:43:58 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'UQ_BM_BMBM00_BH0000' order by column_position ASC 239 07:43:58 SQL Execute: ORACLE - SELECT "BMBH00", "BH0000", "FLAG00", "BMMC00", "PYSM00", "WBSM00", "BMXZ00", "FYBZ00", "SYCW00", "YJXX00", "CKXX00", "JZXX00", "CZBZ00", "KSDH00", "XZGHLB", "YYID00", "SFICU0", "KFCW00", "QFSX00", "JKBH01", "ZXWXTS", "PXXH00", "SBKSID", "CHQZ00", "SFWKKS", "ZJFZ00", "KSFLBH", "YYKSBM", "YYSCKS", "WHKSID", "WHKSMC", "FBCKXX", "SFQTXS" FROM "BM_BMBM00" WHERE (("YYID00") = ('222137')) AND (("CZBZ00") <> ('2')) ORDER BY "BH0000", "BMMC00" 240 07:43:58 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t1.YGBH00<>0 and t1.CZBZ00<>'2' and t2.CZBZ00<>'2' and t2.BH0000 like '%' and t2.YYID00 like '222137%' order by t1.XKH000 241 07:43:58 SQL Execute: ORACLE - select a.xtmc00 XTMC00 from vw_xt_OwnerSys a where a.xtdm00 in (Select distinct t1.XTDM00 from XT_ZBQX00 t1,XT_YYXT00 t2 where t2.BMXZ00 is not null and t1.XTDM00=t2.XTDM00 and t1.zbdm00 in (select zbdm00 from XT_YHZB00 where ygbh00='1')) order by a.xtdm00 242 07:43:59 SQL Execute: ORACLE - Select BMXZ00 from XT_YYXT00 where XTMC00='公共模块' 243 07:43:59 SQL Execute: ORACLE - Select BMBH00,trim(BMMC00)||'_'||trim(BH0000) BMMC00 from BM_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' and BMXZ00 in ('c','0','1','5','2','9','a','8','4','6') order by YYID00,BH0000 244 07:43:59 SQL Execute: ORACLE - Select t1.BMBH00,trim(t1.BMMC00)||'_'||trim(t1.BH0000) BMMC00 from BM_BMBM00 t1,XT_YHBMQX t2,XT_YYXT00 t3 where t1.BMBH00=t2.BMBH00 and t2.XTDM00=t3.XTDM00 and t1.CZBZ00<>'2' and t2.YGBH00=1 and t3.XTMC00='公共模块' order by t1.YYID00,t1.BH0000 245 07:43:59 SQL Execute: ORACLE - SELECT "BMBH00", "BH0000", "FLAG00", "BMMC00", "PYSM00", "WBSM00", "BMXZ00", "FYBZ00", "SYCW00", "YJXX00", "CKXX00", "JZXX00", "CZBZ00", "KSDH00", "XZGHLB", "YYID00", "SFICU0", "KFCW00", "QFSX00", "JKBH01", "ZXWXTS", "PXXH00", "SBKSID", "CHQZ00", "SFWKKS", "ZJFZ00", "KSFLBH", "YYKSBM", "YYSCKS", "WHKSID", "WHKSMC", "FBCKXX", "SFQTXS" FROM "BM_BMBM00" WHERE ("CZBZ00") <> ('2') ORDER BY "BH0000", "BMMC00" 246 07:44:00 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 247 07:44:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = l% 248 07:44:00 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (xkh000 Like ?) order by xkh000) where Rownum<=30 249 07:44:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 250 07:44:05 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (xkh000 Like ?) order by xkh000) where Rownum<=30 251 07:44:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = c% 252 07:44:06 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (xkh000 Like ?) order by xkh000) where Rownum<=30 253 07:44:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cq% 254 07:44:07 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (xkh000 Like ?) order by xkh000) where Rownum<=30 255 07:44:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cq% 256 07:44:10 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (pysm00 Like ?) order by pysm00) where Rownum<=30 257 07:44:21 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t1.YGBH00<>0 and t1.CZBZ00<>'2' and t2.CZBZ00<>'2' and t1.YGBH00=745 order by t1.XKH000 258 07:44:21 SQL Execute: ORACLE - select a.xtmc00 XTMC00 from vw_xt_OwnerSys a where a.xtdm00 in (Select distinct t1.XTDM00 from XT_ZBQX00 t1,XT_YYXT00 t2 where t2.BMXZ00 is not null and t1.XTDM00=t2.XTDM00 and t1.zbdm00 in (select zbdm00 from XT_YHZB00 where ygbh00='745')) order by a.xtdm00 259 07:44:21 SQL Execute: ORACLE - Select BMXZ00 from XT_YYXT00 where XTMC00='门诊收费管理系统' 260 07:44:21 SQL Execute: ORACLE - Select BMBH00,trim(BMMC00)||'_'||trim(BH0000) BMMC00 from BM_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' and BMXZ00 in ('4') order by YYID00,BH0000 261 07:44:21 SQL Execute: ORACLE - Select t1.BMBH00,trim(t1.BMMC00)||'_'||trim(t1.BH0000) BMMC00 from BM_BMBM00 t1,XT_YHBMQX t2,XT_YYXT00 t3 where t1.BMBH00=t2.BMBH00 and t2.XTDM00=t3.XTDM00 and t1.CZBZ00<>'2' and t2.YGBH00=745 and t3.XTMC00='门诊收费管理系统' order by t1.YYID00,t1.BH0000 262 07:44:21 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHBMQX t1,BM_BMBM00 t2,XT_YYXT00 t3 WHERE t1.BMBH00=t2.BMBH00 AND t1.XTDM00=t3.XTDM00 AND t2.CZBZ00<>'2' AND t1.YGBH00=745 AND t2.BMMC00='门诊收费处_0402' AND t3.XTMC00='门诊收费管理系统' 263 07:44:21 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHBMQX t1,BM_BMBM00 t2,XT_YYXT00 t3 WHERE t1.BMBH00=t2.BMBH00 AND t1.XTDM00=t3.XTDM00 AND t2.CZBZ00<>'2' AND t1.YGBH00=745 AND t2.BMMC00='门诊收费处_0402' AND t3.XTMC00='门诊收费管理系统' 264 07:44:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = l% 265 07:44:32 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (pysm00 Like ?) order by pysm00) where Rownum<=30 266 07:44:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = ll% 267 07:44:33 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (pysm00 Like ?) order by pysm00) where Rownum<=30 268 07:44:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = llf% 269 07:44:34 SQL Execute: ORACLE - Select * from (select xkh000,zwxm00,pysm00,wbsm00,ygbh00 from vw_bm_ygbm00 where (pysm00 Like ?) order by pysm00) where Rownum<=30 270 07:44:35 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t1.YGBH00<>0 and t1.CZBZ00<>'2' and t2.CZBZ00<>'2' and t1.YGBH00=153 order by t1.XKH000 271 07:44:35 SQL Execute: ORACLE - select a.xtmc00 XTMC00 from vw_xt_OwnerSys a where a.xtdm00 in (Select distinct t1.XTDM00 from XT_ZBQX00 t1,XT_YYXT00 t2 where t2.BMXZ00 is not null and t1.XTDM00=t2.XTDM00 and t1.zbdm00 in (select zbdm00 from XT_YHZB00 where ygbh00='153')) order by a.xtdm00 272 07:44:35 SQL Execute: ORACLE - Select BMXZ00 from XT_YYXT00 where XTMC00='门诊收费管理系统' 273 07:44:35 SQL Execute: ORACLE - Select BMBH00,trim(BMMC00)||'_'||trim(BH0000) BMMC00 from BM_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' and BMXZ00 in ('4') order by YYID00,BH0000 274 07:44:35 SQL Execute: ORACLE - Select t1.BMBH00,trim(t1.BMMC00)||'_'||trim(t1.BH0000) BMMC00 from BM_BMBM00 t1,XT_YHBMQX t2,XT_YYXT00 t3 where t1.BMBH00=t2.BMBH00 and t2.XTDM00=t3.XTDM00 and t1.CZBZ00<>'2' and t2.YGBH00=153 and t3.XTMC00='门诊收费管理系统' order by t1.YYID00,t1.BH0000 275 07:44:35 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHBMQX t1,BM_BMBM00 t2,XT_YYXT00 t3 WHERE t1.BMBH00=t2.BMBH00 AND t1.XTDM00=t3.XTDM00 AND t2.CZBZ00<>'2' AND t1.YGBH00=153 AND t2.BMMC00='门诊收费处_0402' AND t3.XTMC00='门诊收费管理系统' 276 07:44:35 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHBMQX t1,BM_BMBM00 t2,XT_YYXT00 t3 WHERE t1.BMBH00=t2.BMBH00 AND t1.XTDM00=t3.XTDM00 AND t2.CZBZ00<>'2' AND t1.YGBH00=153 AND t2.BMMC00='门诊收费处_0402' AND t3.XTMC00='门诊收费管理系统' 277 07:44:57 SQL Execute: ORACLE - Select ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=6 and FZBDM0 is null and ZBDM00<>'** ' order by ZBMC00 278 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='24' and ZBJB00 like '00%' 279 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='79' and ZBJB00 like '00%' 280 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='06' and ZBJB00 like '00%' 281 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='05' and ZBJB00 like '00%' 282 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='50' and ZBJB00 like '00%' 283 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='10' and ZBJB00 like '00%' 284 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='369' and ZBJB00 like '00%' 285 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='15' and ZBJB00 like '00%' 286 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='91' and ZBJB00 like '00%' 287 07:44:57 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='93' and ZBJB00 like '00%' 288 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='92' and ZBJB00 like '00%' 289 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='90' and ZBJB00 like '00%' 290 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='351' and ZBJB00 like '00%' 291 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='69' and ZBJB00 like '00%' 292 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='35' and ZBJB00 like '00%' 293 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='38' and ZBJB00 like '00%' 294 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='76' and ZBJB00 like '00%' 295 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='77' and ZBJB00 like '00%' 296 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='354' and ZBJB00 like '00%' 297 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='55' and ZBJB00 like '00%' 298 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='54' and ZBJB00 like '00%' 299 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='53' and ZBJB00 like '00%' 300 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='60' and ZBJB00 like '00%' 301 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='00' and ZBJB00 like '00%' 302 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='52' and ZBJB00 like '00%' 303 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='57' and ZBJB00 like '00%' 304 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='27' and ZBJB00 like '00%' 305 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='30' and ZBJB00 like '00%' 306 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='23' and ZBJB00 like '00%' 307 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='65' and ZBJB00 like '00%' 308 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='68' and ZBJB00 like '00%' 309 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='81' and ZBJB00 like '00%' 310 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='82' and ZBJB00 like '00%' 311 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='80' and ZBJB00 like '00%' 312 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='67' and ZBJB00 like '00%' 313 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='371' and ZBJB00 like '00%' 314 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='364' and ZBJB00 like '00%' 315 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='365' and ZBJB00 like '00%' 316 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='476' and ZBJB00 like '00%' 317 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='353' and ZBJB00 like '00%' 318 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='379' and ZBJB00 like '00%' 319 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='14' and ZBJB00 like '00%' 320 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='11' and ZBJB00 like '00%' 321 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='48' and ZBJB00 like '00%' 322 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='73' and ZBJB00 like '00%' 323 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='33' and ZBJB00 like '00%' 324 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='12' and ZBJB00 like '00%' 325 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='08' and ZBJB00 like '00%' 326 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='20' and ZBJB00 like '00%' 327 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='07' and ZBJB00 like '00%' 328 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='59' and ZBJB00 like '00%' 329 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='84' and ZBJB00 like '00%' 330 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='477' and ZBJB00 like '00%' 331 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='94' and ZBJB00 like '00%' 332 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='89' and ZBJB00 like '00%' 333 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='474' and ZBJB00 like '00%' 334 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='0381' and ZBJB00 like '00%' 335 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='70' and ZBJB00 like '00%' 336 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='85' and ZBJB00 like '00%' 337 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='86' and ZBJB00 like '00%' 338 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='72' and ZBJB00 like '00%' 339 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='34' and ZBJB00 like '00%' 340 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='28' and ZBJB00 like '00%' 341 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='373' and ZBJB00 like '00%' 342 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='03' and ZBJB00 like '00%' 343 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='49' and ZBJB00 like '00%' 344 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='58' and ZBJB00 like '00%' 345 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='74' and ZBJB00 like '00%' 346 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='75' and ZBJB00 like '00%' 347 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='96' and ZBJB00 like '00%' 348 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='19' and ZBJB00 like '00%' 349 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='42' and ZBJB00 like '00%' 350 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='78' and ZBJB00 like '00%' 351 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='18' and ZBJB00 like '00%' 352 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='17' and ZBJB00 like '00%' 353 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='01' and ZBJB00 like '00%' 354 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='02' and ZBJB00 like '00%' 355 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='22' and ZBJB00 like '00%' 356 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='09' and ZBJB00 like '00%' 357 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='61' and ZBJB00 like '00%' 358 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='366' and ZBJB00 like '00%' 359 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='374' and ZBJB00 like '00%' 360 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='13' and ZBJB00 like '00%' 361 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='95' and ZBJB00 like '00%' 362 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='29' and ZBJB00 like '00%' 363 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='31' and ZBJB00 like '00%' 364 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='16' and ZBJB00 like '00%' 365 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='378' and ZBJB00 like '00%' 366 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='56' and ZBJB00 like '00%' 367 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='32' and ZBJB00 like '00%' 368 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='21' and ZBJB00 like '00%' 369 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='99' and ZBJB00 like '00%' 370 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='26' and ZBJB00 like '00%' 371 07:44:58 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='25' and ZBJB00 like '00%' 372 07:44:58 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 373 07:45:07 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='5555' ORDER BY XKH000 374 07:45:07 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='' and t2.BMBH00=0 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=0 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='' and t2.BMBH00=0) 375 07:45:07 SQL Execute: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='5555') 376 07:45:07 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='5555' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='5555' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='5555' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 377 07:45:08 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='5555' ORDER BY XKH000 378 07:45:08 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='' and t2.BMBH00=0 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=0 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='' and t2.BMBH00=0) 379 07:45:08 SQL Execute: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='5555') 380 07:45:08 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='5555' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='5555' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='5555' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 381 07:45:09 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 382 07:45:09 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='' and t2.BMBH00=0 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=0 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='' and t2.BMBH00=0) 383 07:45:09 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='门诊收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 384 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 385 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 386 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 387 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 388 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 389 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 390 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 391 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 392 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 393 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 394 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 395 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 396 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 397 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 398 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 399 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 400 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 401 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 402 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 403 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 404 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 405 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 406 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 407 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 408 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 409 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 410 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 411 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 412 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 413 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 414 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 415 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 416 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 417 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 418 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 419 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 420 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 421 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 422 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 423 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 424 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 425 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 426 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 427 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 428 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 429 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 430 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 431 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 432 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 433 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 434 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 435 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 436 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 437 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 438 07:45:10 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 439 07:45:10 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '门诊收费管理系统' 440 07:45:12 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 441 07:45:16 SQL Execute: ORACLE - select distinct ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=6 order by ZBMC00 442 07:45:16 SQL Execute: ORACLE - Select BMBH00,BMMC00||'_'||BH0000 BMMC00 from VW_HT_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' ORDER BY BMMC00 443 07:45:17 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 444 07:45:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 445 07:45:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 446 07:45:19 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from VW_HT_BMBM00 where (PYSM00 Like ? or BMBH00 Like ?) and( FLAG00 ='1' and CZBZ00<>'2' ) order by BMBH00,PYSM00) where Rownum<=30 447 07:45:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = z% 448 07:45:19 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from VW_HT_BMBM00 where (PYSM00 Like ?) and( FLAG00 ='1' and CZBZ00<>'2' ) order by PYSM00) where Rownum<=30 449 07:45:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = zy% 450 07:45:20 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,PYSM00,WBSM00,BMBH00 from VW_HT_BMBM00 where (PYSM00 Like ?) and( FLAG00 ='1' and CZBZ00<>'2' ) order by PYSM00) where Rownum<=30 451 07:45:22 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=43 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=43 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=43) 452 07:45:22 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=43 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=43 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=43) 453 07:45:28 SQL Execute: ORACLE - Select t1.*,t2.ZBMC00 from XT_YHZB00 t1,XT_XTZB00 t2 where t1.ZBDM00=t2.ZBDM00 and YGBH00=158 454 07:45:31 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 455 07:45:31 SQL Execute: ORACLE - Delete from XT_YHZB00 where YGBH00=158 and ZBDM00='59' 456 07:45:31 SQL Data In: ORACLE - Rows affected = 0 457 07:45:31 SQL Execute: ORACLE - Delete from XT_YHBMQX where YGBH00=158 and BMBH00=337 458 07:45:31 SQL Data In: ORACLE - Rows affected = 0 459 07:45:31 SQL Execute: ORACLE - Insert into XT_YHZB00(YGBH00,ZBDM00) values( '158','59' ) 460 07:45:31 SQL Data In: ORACLE - Rows affected = 1 461 07:45:31 SQL Execute: ORACLE - Insert into XT_YHBMQX(XTDM00,YGBH00,BMBH00) Select distinct t1.XTDM00,158,t2.BMBH00 from XT_ZBQX00 t1,BM_YGBM00 t2,BM_BMBM00 t3 where t1.ZBDM00='59' and t2.BMBH00=t3.BMBH00 and t3.FLAG00='1' and t1.XTDM00='Z' and t3.BMBH00=337 462 07:45:31 SQL Data In: ORACLE - Rows affected = 0 463 07:45:31 SQL Execute: ORACLE - delete from XT_YHMKQX where YGBH00=158 and ZBDM00='59' 464 07:45:31 SQL Data In: ORACLE - Rows affected = 0 465 07:45:31 SQL Execute: ORACLE - delete from XT_YHGLMK where YGBH00=158 and ZBDM00='59' 466 07:45:31 SQL Data In: ORACLE - Rows affected = 0 467 07:45:31 SQL Execute: ORACLE - insert into XT_YHMKQX(YGBH00,MKDM00,ZBDM00,XTDM00) select 158 YGBH00,MKDM00,ZBDM00,XTDM00 from XT_ZBQX00 where ZBDM00='59' and exists (select 1 from XT_YHZB00 where ZBDM00='59' and YGBH00=158 ) 468 07:45:31 SQL Data In: ORACLE - Rows affected = 211 469 07:45:31 SQL Execute: ORACLE - insert into XT_YHGLMK(YGBH00,MKDM00,ZBDM00,XTDM00) select 158 YGBH00,MKDM00,ZBDM00,XTDM00 from XT_ZBQX00 where ZBDM00='59' and exists (select 1 from XT_YHZB00 where ZBDM00='59' and YGBH00=158 ) 470 07:45:31 SQL Data In: ORACLE - Rows affected = 211 471 07:45:31 SQL Execute: ORACLE - Commit 472 07:45:31 SQL Data In: ORACLE - Rows affected = 0 473 07:45:31 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHZB00 T1,XT_XTZB00 T2 WHERE t1.ZBDM00=t2.ZBDM00 AND T1.YGBH00=158 AND T2.ZBMC00='收费员组2' 474 07:45:33 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHZB00 T1,XT_XTZB00 T2 WHERE t1.ZBDM00=t2.ZBDM00 AND T1.YGBH00=158 AND T2.ZBMC00='收费员组2' 475 07:45:35 SQL Execute: ORACLE - Select t1.*,t2.ZBMC00 from XT_YHZB00 t1,XT_XTZB00 t2 where t1.ZBDM00=t2.ZBDM00 and YGBH00=153 476 07:45:36 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '收费员组2' 477 07:45:36 SQL Execute: ORACLE - Delete from XT_YHZB00 where YGBH00=153 and ZBDM00='59' 478 07:45:36 SQL Data In: ORACLE - Rows affected = 0 479 07:45:36 SQL Execute: ORACLE - Delete from XT_YHBMQX where YGBH00=153 and BMBH00=337 480 07:45:36 SQL Data In: ORACLE - Rows affected = 0 481 07:45:36 SQL Execute: ORACLE - Insert into XT_YHZB00(YGBH00,ZBDM00) values( '153','59' ) 482 07:45:36 SQL Data In: ORACLE - Rows affected = 1 483 07:45:36 SQL Execute: ORACLE - Insert into XT_YHBMQX(XTDM00,YGBH00,BMBH00) Select distinct t1.XTDM00,153,t2.BMBH00 from XT_ZBQX00 t1,BM_YGBM00 t2,BM_BMBM00 t3 where t1.ZBDM00='59' and t2.BMBH00=t3.BMBH00 and t3.FLAG00='1' and t1.XTDM00='Z' and t3.BMBH00=337 484 07:45:36 SQL Data In: ORACLE - Rows affected = 0 485 07:45:36 SQL Execute: ORACLE - delete from XT_YHMKQX where YGBH00=153 and ZBDM00='59' 486 07:45:36 SQL Data In: ORACLE - Rows affected = 0 487 07:45:36 SQL Execute: ORACLE - delete from XT_YHGLMK where YGBH00=153 and ZBDM00='59' 488 07:45:36 SQL Data In: ORACLE - Rows affected = 0 489 07:45:36 SQL Execute: ORACLE - insert into XT_YHMKQX(YGBH00,MKDM00,ZBDM00,XTDM00) select 153 YGBH00,MKDM00,ZBDM00,XTDM00 from XT_ZBQX00 where ZBDM00='59' and exists (select 1 from XT_YHZB00 where ZBDM00='59' and YGBH00=153 ) 490 07:45:36 SQL Data In: ORACLE - Rows affected = 211 491 07:45:36 SQL Execute: ORACLE - insert into XT_YHGLMK(YGBH00,MKDM00,ZBDM00,XTDM00) select 153 YGBH00,MKDM00,ZBDM00,XTDM00 from XT_ZBQX00 where ZBDM00='59' and exists (select 1 from XT_YHZB00 where ZBDM00='59' and YGBH00=153 ) 492 07:45:36 SQL Data In: ORACLE - Rows affected = 211 493 07:45:36 SQL Execute: ORACLE - Commit 494 07:45:36 SQL Data In: ORACLE - Rows affected = 0 495 07:45:36 SQL Execute: ORACLE - SELECT TO_DATE(t1.KSRQ00,'YYYY.MM.DD') BeginDate,TO_DATE(t1.KSSJ00,'HH24:MI:SS') BeginTime, TO_DATE(NVL(t1.JSRQ00,'20501231'),'YYYY.MM.DD') EndDate,TO_DATE(NVL(t1.JSSJ00,'23:59:59'),'HH24:MI:SS') EndTime FROM XT_YHZB00 T1,XT_XTZB00 T2 WHERE t1.ZBDM00=t2.ZBDM00 AND T1.YGBH00=153 AND T2.ZBMC00='收费员组2' 496 07:45:51 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 497 07:45:51 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 498 07:45:51 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='住院收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='住院收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='住院收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 499 07:45:53 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 500 07:45:54 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 501 07:45:54 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='门诊收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 502 07:45:57 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 503 07:45:57 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 504 07:45:57 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='门诊收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 505 07:46:07 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 506 07:46:12 SQL Execute: ORACLE - select distinct ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=6 order by ZBMC00 507 07:46:12 SQL Execute: ORACLE - Select BMBH00,BMMC00||'_'||BH0000 BMMC00 from VW_HT_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' ORDER BY BMMC00 508 07:46:12 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=43 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=43 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=43) 509 07:46:12 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=43 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=43 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=43) 510 07:46:12 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 511 07:46:14 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 512 07:46:17 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 513 07:46:17 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 514 07:46:17 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='住院收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='住院收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='住院收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 515 07:46:35 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组2' ORDER BY XKH000 516 07:46:35 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组2' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组2' and t2.BMBH00=337) 517 07:46:35 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='门诊收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组2') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 518 07:46:40 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='收费员组' ORDER BY XKH000 519 07:46:40 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='收费员组' and t2.BMBH00=337 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=337 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='收费员组' and t2.BMBH00=337) 520 07:46:40 SQL Execute: ORACLE - select MKLB00,MKWBMC,MKDM00,Flag from ( select distinct MKLB00, MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组') union select distinct a.MKLB00,a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='门诊收费管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='门诊收费管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='收费员组') and a.MKDM00 = d.MKDM00 ) ) order by MKLB00 521 07:46:52 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4283308 522 07:46:52 SQL Data In: ORACLE - Rows affected = 1 523 07:46:52 SQL Execute: ORACLE - Commit 524 07:46:52 SQL Data In: ORACLE - Rows affected = 0 525 07:46:52 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 526 07:46:52 SQL Data In: ORACLE - Rows affected = 0 527 07:46:52 SQL Execute: ORACLE - Commit 528 07:46:52 SQL Data In: ORACLE - Rows affected = 0