1 11:06:47 Log started for: Sickberth 2 11:06:47 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:06:47 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.104','9','SickBerth.exe'||'+'||'病区护理系统','855','2696' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@yj:6587EF097EA4D57056F73EF93DAD7DFF' from dual 4 11:06:47 SQL Data In: ORACLE - Rows affected = 1 5 11:06:47 SQL Execute: ORACLE - Commit 6 11:06:47 SQL Data In: ORACLE - Rows affected = 0 7 11:06:47 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 11:06:47 SQL Connect: ORACLE - Disconnect PASSTHRU 9 11:06:47 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218' 10 11:06:47 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='YJ' and CZBZ00 in ('1') 11 11:06:47 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 12 11:06:47 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.104','9','SickBerth.exe'||'+'||'病区护理系统','767','7036' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@yj:63A2035D2E81CC4C9AFD7390729D93B5' from dual 13 11:06:47 SQL Data In: ORACLE - Rows affected = 1 14 11:06:47 SQL Execute: ORACLE - Commit 15 11:06:47 SQL Data In: ORACLE - Rows affected = 0 16 11:06:47 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 17 11:06:47 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='YJ' and CZBZ00 in ('1') 18 11:06:47 SQL Execute: ORACLE - Select SYSDATE from Dual 19 11:06:47 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 20 11:06:47 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 21 11:06:47 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 22 11:06:47 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 23 11:06:47 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' 24 11:06:47 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 = 'YB-MMRK' 25 11:06:47 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 = 'YB-SBK' 26 11:06:48 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ')) order by b.PLXH00,a.BH0000 27 11:06:48 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'yj'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='YJ') 28 11:06:49 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=157 29 11:06:49 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 11:06:49 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 31 11:06:49 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 32 11:06:49 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 33 11:06:49 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')) 34 11:06:49 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1652030,157,'D','9',nvl('10320961',' '),'192.168.3.99-192.168.0.104#767:7036@SickBerth.exe+病区护理系统',56) 35 11:06:49 SQL Data In: ORACLE - Rows affected = 1 36 11:06:49 SQL Execute: ORACLE - Commit 37 11:06:49 SQL Data In: ORACLE - Rows affected = 0 38 11:06:49 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 56 39 11:06:49 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221218' 40 11:06:49 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 41 11:06:49 SQL Blob IO: ORACLE - Return blob data 42 11:06:49 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.104' 43 11:06:49 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 44 11:06:49 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 56 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 45 11:06:49 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221218') 46 11:06:49 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'9'||',')>0 47 11:06:49 SQL Blob IO: ORACLE - Return blob data 48 11:06:49 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='157' and name00='SYSTEMSKIN' 49 11:06:49 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 50 11:06:49 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140228' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',56,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='9') 51 11:06:49 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 52 11:06:49 SQL Blob IO: ORACLE - Return blob data 53 11:06:49 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 54 11:06:49 SQL Blob IO: ORACLE - Return blob data 55 11:06:49 SQL Execute: ORACLE - select sysdate from dual 56 11:06:49 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 157= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='9'))) 57 11:06:49 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 58 11:06:49 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 ((157= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='0 '))) 59 11:06:49 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 60 11:06:49 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 157= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=157 and XTDM00='+ '))) 61 11:06:49 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 62 11:06:49 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 63 11:06:49 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 64 11:06:49 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 65 11:06:49 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 66 11:06:49 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 67 11:06:49 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_ZDYDY_SYHDD','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_SERVERDIRCP','YJ_JSXMSFXZ','BQ_YZZXDDYSFQB','BQ_CQYZZJSSFTXYPSL','YS_ZFBRZFBLYBLB','BQ_YLFYJY_ZYCWXM') 68 11:06:50 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet','YJ_BBCYHZDPrintSet') and YGBH00 = 157 69 11:06:50 SQL Execute: ORACLE - select sysdate nowtime from dual 70 11:06:50 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 71 11:06:50 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 72 11:06:50 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='病区消息时间间隔' AND YXBZ00='1' and MC0000='刷新间隔' 73 11:06:50 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 74 11:06:50 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 75 11:06:50 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 76 11:06:50 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 77 11:06:50 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 78 11:06:50 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 79 11:06:50 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 80 11:06:50 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 81 11:06:50 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 82 11:06:50 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 83 11:06:50 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=157 84 11:06:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 85 11:06:50 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 86 11:06:50 SQL Blob IO: ORACLE - Return blob data 87 11:06:54 SQL Execute: ORACLE - SELECT ZYH000,XM0000,XB0000,ZYYS00,ZYYSXM,ZZYS00,ZZYSXM,ZRYS00,ZRYSXM,SZYS00,SZYSXM,RYZD00,RYCWH0, RYSQK0,BQMC00,BRLB00,RYRQSJ,FBBH00,RYZDMC,RYICD0 FROM VW_BQ_DDSZBR WHERE BQH000=56 and (brlb00='新入病人' or brlb00='转入病人' ) and (zkjcbz<>'Y' or zkjcbz is null) order by zyh000 88 11:06:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 89 11:06:54 SQL Execute: ORACLE - SELECT CH0000,KSMC00,CWDJMC,FJH000,CWXZ00,CWF000,CWYJ00, zrhs00,h.zwxm00"zrhsxm",zyYS00,y.zwxm00 "zyYSXM",zzys00, z.zwxm00"zzysxm",zrys00,r.zwxm00"zrysxm" FROM VW_BM_CWK000 C,BM_YGBM00 Y,BM_YGBM00 z,BM_YGBM00 r,BM_YGBM00 h WHERE C.zyYS00=Y.YGBH00(+)and c.zzys00=z.ygbh00(+) and c.zrys00=r.ygbh00(+) and c.zrhs00=h.ygbh00(+) AND C.BQH000=? AND CWZT00 IN ('0') ORDER BY CH0000 90 11:06:54 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 91 11:06:54 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 78348 92 11:06:54 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 93 11:06:54 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 11:06:54 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 11:06:54 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 11:06:54 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 11:06:54 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 98 11:06:54 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 11:06:54 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 11:06:54 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 11:06:54 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 102 11:06:54 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 103 11:06:54 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 104 11:06:54 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 105 11:06:54 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 106 11:06:54 SQL Execute: ORACLE - SELECT ZYH000,XM0000,XB0000,ZYYS00,ZYYSXM,ZZYS00,ZZYSXM,ZRYS00,ZRYSXM,SZYS00,SZYSXM,RYZD00,RYCWH0, RYSQK0,BQMC00,BRLB00,RYRQSJ,FBBH00,RYZDMC,RYICD0 FROM VW_BQ_DDSZBR WHERE BQH000=56 and (brlb00='新入病人' or brlb00='转入病人' ) and (zkjcbz<>'Y' or zkjcbz is null) order by zyh000 107 11:06:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 108 11:06:54 SQL Execute: ORACLE - SELECT CH0000,KSMC00,CWDJMC,FJH000,CWXZ00,CWF000,CWYJ00, zrhs00,h.zwxm00"zrhsxm",zyYS00,y.zwxm00 "zyYSXM",zzys00, z.zwxm00"zzysxm",zrys00,r.zwxm00"zrysxm" FROM VW_BM_CWK000 C,BM_YGBM00 Y,BM_YGBM00 z,BM_YGBM00 r,BM_YGBM00 h WHERE C.zyYS00=Y.YGBH00(+)and c.zzys00=z.ygbh00(+) and c.zrys00=r.ygbh00(+) and c.zrhs00=h.ygbh00(+) AND C.BQH000=? AND CWZT00 IN ('0') ORDER BY CH0000 109 11:06:54 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 110 11:06:54 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 78348 111 11:06:54 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 112 11:06:54 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 113 11:06:54 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 114 11:06:54 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 115 11:06:54 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 116 11:06:54 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 117 11:06:54 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 118 11:06:54 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 119 11:06:54 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 120 11:06:54 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 121 11:06:54 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 122 11:06:54 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 123 11:06:54 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 124 11:06:54 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 125 11:06:57 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('BQ_SZYS_YSKS','BQ_SZYS_RYZD','BQ_SZYS_RYZDSFXS','BQ_SZYS_ZRYS','BQ_SZYS_ZZYS','BQ_BQSZSFYXZDYZD','BQ_SZYS_SFSYSZFZ','BQ_SZYS_RYQK') 126 11:06:57 SQL Execute: ORACLE - SELECT MAX(ZYID00) ZYID00 FROM ZY_BRXXB0 WHERE ZYH000= '78348' 127 11:06:57 SQL Execute: ORACLE - Select zlxmid,zlxmjc from vw_bq_hlyzxm 128 11:06:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.000000 129 11:06:57 SQL Execute: ORACLE - select a.ksh000 ,a.bqh000, (Select b.bmmc00 from BM_BMBM00 b where a.ksh000=b.bmbh00 ) ksmc00, (Select c.bmmc00 from BM_BMBM00 c where a.bqh000=c.bmbh00 ) bqmc00 from BM_BQKS00 a ,bm_bmbm00 f where a.ksh000=f.bmbh00 and f.czbz00<>'2' and a.bqh000 =? 130 11:06:57 SQL Execute: ORACLE - Select DQKS00 from ZY_BRXXB0 where ZYH000='78348' 131 11:06:58 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 132 11:06:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 133 11:06:58 SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00,BMBH00 from VW_BQ_ZYYS00 where (pysm00 Like ?) Order By pysm00) where Rownum<=50 134 11:07:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %z% 135 11:07:02 SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00,BMBH00 from VW_BQ_ZYYS00 where (pysm00 Like ?) Order By Instrb(pysm00,'z'),pysm00) where Rownum<=50 136 11:07:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %zy% 137 11:07:03 SQL Execute: ORACLE - Select * from (select zwxm00,xkh000,pysm00,wbsm00,ygbh00,BMBH00 from VW_BQ_ZYYS00 where (pysm00 Like ?) Order By Instrb(pysm00,'zy'),pysm00) where Rownum<=50