1 12:02:56 Log started for: 项目管理系统 2 12:02:56 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='THCS' and CZBZ00 in ('1') 3 12:02:56 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.5.3.9','C',trim(PROGRAM)||'+'||'项目管理系统',SID,serial# ,'20110414','12:02:56','sd_Hospital@thcs:C4B3D180C347F03A6B48C291B0F8B2E2' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 12:02:56 SQL Data In: ORACLE - Rows affected = 1 5 12:02:56 SQL Execute: ORACLE - Commit 6 12:02:56 SQL Data In: ORACLE - Rows affected = 0 7 12:02:56 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 8 12:02:56 SQL Data In: ORACLE - Rows affected = 0 9 12:02:56 SQL Execute: ORACLE - Commit 10 12:02:56 SQL Data In: ORACLE - Rows affected = 0 11 12:02:56 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='C' 12 12:02:56 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='THCS' and CZBZ00 in ('1') 13 12:02:56 SQL Execute: ORACLE - Select SYSDATE from Dual 14 12:02:56 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 15 12:02:56 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 16 12:02:56 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='C' 17 12:02:56 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 12:02:56 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 = 'SLE4442' 19 12:02:56 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='THCS')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='THCS')) order by b.PLXH00,a.BH0000 20 12:02:57 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'thcs'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'C' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='THCS')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='THCS') 21 12:02:57 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=61012 22 12:02:57 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 23 12:02:57 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 24 12:02:57 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 25 12:02:57 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 26 12:02:57 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')) 27 12:02:58 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(600003487215,61012,'sd_mz09','C',nvl('6026318',' '),'192.5.3.9#855:22862@PrjXmgl 20110328.exe+项目管理系统',15) 28 12:02:58 SQL Data In: ORACLE - Rows affected = 1 29 12:02:58 SQL Execute: ORACLE - Commit 30 12:02:58 SQL Data In: ORACLE - Rows affected = 0 31 12:02:58 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 32 12:02:58 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= 'A' 33 12:02:58 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 34 12:02:58 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.5.3.9' 35 12:02:58 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 36 12:02:58 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 37 12:02:58 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('A') 38 12:02:58 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 39 12:02:58 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='61012' and name00='SYSTEMSKIN' 40 12:02:58 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='C') and YXQ000>='20110414' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',15,' )>0 ) 41 12:02:58 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 42 12:02:58 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 43 12:02:58 SQL Execute: ORACLE - Select SYSDATE from Dual 44 12:02:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='C' and (( 61012= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=61012 and XTDM00='C'))) 45 12:02:58 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'C$%' and A.XTDM00='C' and trim(A.MKDM00)='C$'||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 46 12:02:58 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 ((61012= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=61012 and XTDM00='0 '))) 47 12:02:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 48 12:02:58 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 61012= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=61012 and XTDM00='+ '))) 49 12:02:58 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_SFGL' and (( 61012= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=61012)))) 50 12:02:58 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_CLGL' and (( 61012= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=61012)))) 51 12:02:58 SQL Execute: ORACLE - select yydj00 from xt_yyxx00 where yyid00='A' 52 12:02:58 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 53 12:02:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61012.000000 54 12:02:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = XM_ZXGXXLH_ID00 55 12:02:58 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 56 12:02:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61012.000000 57 12:02:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_HZSRF 58 12:02:58 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 59 12:02:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61012.000000 60 12:02:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_SRXG0 61 12:02:58 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 62 12:02:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61012.000000 63 12:02:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_PPFX0 64 12:02:58 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 65 12:02:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61012.000000 66 12:02:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_ZDJLS 67 12:02:58 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 68 12:02:58 SQL Execute: ORACLE - select name00,value0 from xt_yhcs00 where ygbh00=61012 order by name00 69 12:02:58 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00='XMGL_YBYPDYSCMM' 70 12:02:59 SQL Execute: ORACLE - select * from bm_bmgz00 a where exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0') or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0') order by BMGZSH 71 12:02:59 SQL Execute: ORACLE - select * from bm_bmgz00 a where bmgzid=1 order by BMGZSH 72 12:02:59 SQL Execute: ORACLE - select sybz00,xmmc00,bh0000 from bm_fpxm00 where bh0000>'03' order by bh0000 73 12:02:59 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 74 12:03:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 75 12:03:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 76 12:03:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 77 12:03:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 78 12:03:01 SQL Execute: ORACLE - select * from bm_sfxmbz where flag00='0' and bmgzid=? and tzrq00 is null and ((? = 2 and BMGZID=1 and BH0000 like '9%') or (? = 1 and not (BMGZID=1 and BH0000 like '9%')) or (? not in (1,2))) order by bh0000 79 12:03:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 80 12:03:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 81 12:03:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 82 12:03:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 83 12:03:01 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 84 12:03:01 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 85 12:03:01 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 86 12:03:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 87 12:03:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 88 12:03:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 89 12:03:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 90 12:03:03 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 91 12:03:03 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 92 12:03:03 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 93 12:03:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 94 12:03:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 95 12:03:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 96 12:03:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 97 12:03:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 98 12:03:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 99 12:03:05 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 100 12:03:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 101 12:03:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 102 12:03:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 103 12:03:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 104 12:03:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 105 12:03:07 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 106 12:03:07 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 107 12:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 108 12:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 109 12:03:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 110 12:03:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 111 12:03:09 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 112 12:03:09 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 113 12:03:09 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 114 12:03:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 02304% 115 12:03:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 116 12:03:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 02304% 117 12:03:11 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 118 12:03:11 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 119 12:03:11 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 120 12:03:11 SQL Execute: ORACLE - select decode(a.flag00, '0' , '类别', '1' , '项目') lbbz, decode(a.zhxmbz,'0','否','1','是')zhxm, b3.yydj00 as yydjmc, b4.yydj00 as zdyydjmc, b5.yydj00 as zgyydjmc, a.XMBZID,a.BMGZID,a.XH0000,a.BH0000,a.FLAG00,a.XMMC00,decode(a.FLAG00,'0',null,trim(a.XMNH00)) XMNH00,decode(a.FLAG00,'0',null,trim(a.CWNR00)) CWNR00,a.DW0000,a.BZJE00,a.FDBL00,a.SFSX00,a.SFXX00,a.MZFPID,a.ZYFPID,a.QYRQ00,a.QYSJ00,a.TZRQ00,a.TZSJ00,decode(a.FLAG00,'0',null,trim(a.BZ0000)) BZ0000,a.ZJBZ00,a.YYDJ00,a.ZGYYDJ,a.ZDYYDJ,a.DJXS00,a.ZHXMBZ,a.RSFSX0,a.HSXMID,a.BAXMID,a.GJBM00,a.FM0000,a.LSCL00,a.JSXM00,b1.xmmc00 as mzfpxmmc,b2.xmmc00 as zyfpxmmc, b6.hsxmmc,b7.baxmmc as baxmmc,decode(a.zjbz00, '0','总部','1', '医院','2','分部','3','不能增加') zjbzmc from bm_sfxmbz a,bm_fpxm00 b1,bm_fpxm00 b2, bm_yydj00 b3, bm_yydj00 b4,bm_yydj00 b5,bm_yyhsxm b6,bm_baxm00 b7 where a.bh0000 like ? and A.BMGZID=? and a.tzrq00 is null and b1.fpxmid(+)=a.mzfpid and b2.fpxmid(+)=a.zyfpid and length(trim(a.bh0000))>=length(?) and b3.yydjxh=a.yydj00 and b4.yydjxh=a.zdyydj and b5.yydjxh=a.zgyydj and b6.hsxmid(+)=a.hsxmid and b7.baxmid(+)=a.baxmid and (a.xmmc00 like ? or a.bh0000 like ? or trim(substrb(a.bz0000,1,40)) like ?) order by a.bh0000 121 12:03:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 02304 122 12:03:17 SQL Execute: ORACLE - select zjbz00 from bm_sfxmbz where rtrim(ltrim(bh0000))=? and flag00='0' 123 12:03:17 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 124 12:03:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 125 12:03:19 SQL Execute: ORACLE - select max(xh0000) from bm_sfxmbz where bmgzid=? 126 12:04:15 SQL Execute: ORACLE - select zjbz00 from bm_sfxmbz where bh0000='02304' and bmgzid=1 127 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 128 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 129 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 130 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 131 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 132 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 133 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 023 134 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 135 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 136 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 02304 137 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 138 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 139 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 02304 140 12:04:15 SQL Execute: ORACLE - select zjbz00 from bm_sfxmbz where rtrim(ltrim(bh0000))=? and flag00='0' 141 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 023040000903 142 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 143 12:04:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 144 12:04:15 SQL Execute: ORACLE - Select 1 from bm_sfxmbz where rtrim(ltrim(bh0000))=? and bmgzid=? and yydj00=? 145 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 146 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 147 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 148 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 149 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 150 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 151 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 023 152 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 153 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 154 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 02304 155 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 156 12:04:15 SQL Execute: ORACLE - select bh0000 from bm_sfxmbz where bh0000=? and bmgzid=? and flag00='0' 157 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 02304 158 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 159 12:04:15 SQL Execute: ORACLE - select zjbz00 from bm_sfxmbz where bh0000=? and bmgzid=? 160 12:04:15 SQL Execute: ORACLE - select sq_bm_sfxmbz_xmbzid.nextval from dual 161 12:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 600002333.000000 162 12:04:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 163 12:04:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33600.000000 164 12:04:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 023040000903 165 12:04:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 166 12:04:15 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 49, Scale = 0, Data = 正电子发射计算机断层－X线计算机体层综合显像：全身 167 12:04:15 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 168 12:04:15 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 169 12:04:15 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全身 170 12:04:15 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000.000000 171 12:04:15 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 172 12:04:15 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 173 12:04:15 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7000.000000 174 12:04:15 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 175 12:04:15 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 176 12:04:15 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110414 177 12:04:15 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12:03:16 178 12:04:15 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 179 12:04:15 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 180 12:04:15 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 181 12:04:15 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 182 12:04:15 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 183 12:04:15 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 184 12:04:15 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 185 12:04:15 SQL Data In: ORACLE - Param = 25, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 186 12:04:15 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 187 12:04:15 SQL Data In: ORACLE - Param = 27, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 188 12:04:15 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 23040001010 189 12:04:15 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 190 12:04:15 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 191 12:04:15 SQL Data In: ORACLE - Param = 31, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 192 12:04:15 SQL Execute: ORACLE - insert into bm_sfxmbz (XMBZID, BMGZID, XH0000, BH0000, FLAG00, XMMC00, XMNH00, CWNR00, DW0000, BZJE00, FDBL00, SFXX00, SFSX00, MZFPID, ZYFPID, QYRQ00, QYSJ00, TZRQ00, TZSJ00, BZ0000, ZJBZ00, YYDJ00, ZGYYDJ, ZDYYDJ, DJXS00, ZHXMBZ, HSXMID, BAXMID,GJBM00,JSXM00,LSCL00,RSFSX0) select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,decode(?,'0','0','3'), ?, ?, ?, ?, '0', ?, ?,?,?,?,? from dual where rownum=1 193 12:08:05 SQL Data In: ORACLE - Rows affected = 1 194 12:08:05 SQL Execute: ORACLE - COMMIT WORK