1 15:45:03 Log started for: Sickberth 2 15:45:03 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 15:45:03 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 15:45:03 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.100','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20100323','15:45:03','scott@9999:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 15:45:03 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.100','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20100323','15:45:03','scott@9999:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 6 15:45:03 SQL Data In: ORACLE - Rows affected = 1 7 15:45:03 SQL Prepare: ORACLE - Commit 8 15:45:03 SQL Execute: ORACLE - Commit 9 15:45:03 SQL Data In: ORACLE - Rows affected = 0 10 15:45:03 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 15:45:03 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 15:45:03 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 13 15:45:03 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 14 15:45:03 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.100','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20100323','15:45:03','sd_hospital@9999:89B5FD45D0756FB053918C0C236D01D1' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 15 15:45:03 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.100','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20100323','15:45:03','sd_hospital@9999:89B5FD45D0756FB053918C0C236D01D1' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 16 15:45:03 SQL Data In: ORACLE - Rows affected = 1 17 15:45:03 SQL Prepare: ORACLE - Commit 18 15:45:03 SQL Execute: ORACLE - Commit 19 15:45:03 SQL Data In: ORACLE - Rows affected = 0 20 15:45:03 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 21 15:45:03 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 22 15:45:03 SQL Data In: ORACLE - Rows affected = 0 23 15:45:03 SQL Prepare: ORACLE - Commit 24 15:45:03 SQL Execute: ORACLE - Commit 25 15:45:03 SQL Data In: ORACLE - Rows affected = 0 26 15:45:03 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 27 15:45:03 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 28 15:45:03 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 29 15:45:03 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 30 15:45:03 SQL Prepare: ORACLE - Select SYSDATE from Dual 31 15:45:03 SQL Execute: ORACLE - Select SYSDATE from Dual 32 15:45:03 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 33 15:45:03 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 34 15:45:03 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 35 15:45:03 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 36 15:45:03 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 15:45:03 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 15:45:03 SQL Prepare: 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 39 15:45:03 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 40 15:45:03 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 41 15:45:03 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 42 15:45:03 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) 43 15:45:03 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) 44 15:45:03 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=515 45 15:45:03 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=515 46 15:45:03 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 15:45:03 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 15:45:03 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 15:45:03 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 15:45:03 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 15:45:03 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 15:45:03 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 15:45:03 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 15:45:03 SQL Prepare: 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')) 55 15:45:03 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')) 56 15:45:03 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(756251,515,'lenovo-10b786db','9',nvl('1085',' '),'192.168.1.100#9:77@SickBerth.exe+病区护理系统',29) 57 15:45:03 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(756251,515,'lenovo-10b786db','9',nvl('1085',' '),'192.168.1.100#9:77@SickBerth.exe+病区护理系统',29) 58 15:45:03 SQL Data In: ORACLE - Rows affected = 1 59 15:45:03 SQL Prepare: ORACLE - Commit 60 15:45:03 SQL Execute: ORACLE - Commit 61 15:45:03 SQL Data In: ORACLE - Rows affected = 0 62 15:45:03 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 29 63 15:45:03 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 29 64 15:45:03 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '224465' 65 15:45:03 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '224465' 66 15:45:03 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.100' 67 15:45:03 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.100' 68 15:45:03 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 69 15:45:03 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 70 15:45:03 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 29 and FLAG00 like '%' order by decode(CKBH00,99,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 71 15:45:03 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 29 and FLAG00 like '%' order by decode(CKBH00,99,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 72 15:45:03 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='515' and name00='SYSTEMSKIN' 73 15:45:03 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='515' and name00='SYSTEMSKIN' 74 15:45:03 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20100323' 75 15:45:03 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20100323' 76 15:45:03 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 77 15:45:03 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 15:45:03 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 79 15:45:03 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 15:45:03 SQL Prepare: ORACLE - select sysdate from dual 81 15:45:03 SQL Execute: ORACLE - select sysdate from dual 82 15:45:03 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='9' and (( 515= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='9' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=515)))) 83 15:45:03 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='9' and (( 515= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='9' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=515)))) 84 15:45:04 SQL Prepare: 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 85 15:45:04 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 86 15:45:04 SQL Prepare: 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 ((515= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=515)))) 87 15:45:04 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 ((515= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=515)))) 88 15:45:04 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 89 15:45:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 90 15:45:04 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 515= 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=515)))) 91 15:45:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 515= 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=515)))) 92 15:45:04 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 93 15:45:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 94 15:45:04 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 95 15:45:04 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 96 15:45:04 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 97 15:45:04 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 98 15:45:04 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 99 15:45:04 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 100 15:45:04 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 101 15:45:04 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 102 15:45:04 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_ZQCYJH') 103 15:45:04 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_ZQCYJH') 104 15:45:04 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','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_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_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_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','WZ_SFQYEJKF','BQ_CYDYCFDDYGS') 105 15:45:04 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','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_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_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_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','WZ_SFQYEJKF','BQ_CYDYCFDDYGS') 106 15:45:04 SQL Prepare: 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') and YGBH00 = 515 107 15:45:04 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') and YGBH00 = 515 108 15:45:04 SQL Prepare: ORACLE - select sysdate nowtime from dual 109 15:45:04 SQL Execute: ORACLE - select sysdate nowtime from dual 110 15:45:04 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 111 15:45:04 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 112 15:45:04 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 113 15:45:04 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 114 15:45:04 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 115 15:45:04 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 116 15:45:04 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 117 15:45:04 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 118 15:45:04 SQL Prepare: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=515 119 15:45:04 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=515 120 15:45:04 SQL Prepare: ORACLE - select ZZXKH0,ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00) XZYZ00 from VW_BQ_BRZYXX A where DQBQ00 = :1 order by RYCWH0 121 15:45:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 122 15:45:04 SQL Execute: ORACLE - select ZZXKH0,ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00) XZYZ00 from VW_BQ_BRZYXX A where DQBQ00 = ? order by RYCWH0 123 15:45:05 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 124 15:45:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 125 15:45:05 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 126 15:45:05 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19610901) AS NL FROM DUAL 127 15:45:05 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19610901) AS NL FROM DUAL 128 15:45:05 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 129 15:45:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 130 15:45:05 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 131 15:45:07 SQL Prepare: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 WHERE DQBQ00=:1 AND RYCWH0 IS NOT NULL and SUBSTR(BRZT00,1,1)='2' UNION ALL SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 WHERE DQBQ00=:2 AND RYCWH0 IS NULL and SUBSTR(BRZT00,1,1)='2' order by rycwh0 132 15:45:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 133 15:45:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 134 15:45:07 SQL Execute: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 WHERE DQBQ00=? AND RYCWH0 IS NOT NULL and SUBSTR(BRZT00,1,1)='2' UNION ALL SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 WHERE DQBQ00=? AND RYCWH0 IS NULL and SUBSTR(BRZT00,1,1)='2' order by rycwh0 135 15:45:07 SQL Prepare: 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; 136 15:45:07 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 137 15:45:07 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 096043 138 15:45:07 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 139 15:45:07 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 140 15:45:07 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 141 15:45:07 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 142 15:45:07 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 143 15:45:07 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 144 15:45:07 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 145 15:45:07 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 146 15:45:07 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 147 15:45:07 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 148 15:45:07 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 149 15:45:07 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 150 15:45:07 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 151 15:45:07 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; 152 15:45:07 SQL Prepare: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=:1 and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||:2 order by clbz00,qsrq00 153 15:45:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 154 15:45:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 155 15:45:07 SQL Execute: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=? and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||? order by clbz00,qsrq00 156 15:45:07 SQL Prepare: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 157 15:45:07 SQL Execute: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 158 15:45:10 SQL Prepare: ORACLE - delete bq_jzxm00 where ID0000=993731 159 15:45:10 SQL Execute: ORACLE - delete bq_jzxm00 where ID0000=993731 160 15:45:10 SQL Data In: ORACLE - Rows affected = 1 161 15:45:10 SQL Prepare: ORACLE - commit 162 15:45:10 SQL Execute: ORACLE - commit 163 15:45:10 SQL Data In: ORACLE - Rows affected = 0 164 15:45:10 SQL Prepare: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=:1 and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||:2 order by clbz00,qsrq00 165 15:45:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 166 15:45:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 167 15:45:10 SQL Execute: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=? and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||? order by clbz00,qsrq00 168 15:45:10 SQL Prepare: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 169 15:45:10 SQL Execute: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 170 15:45:11 SQL Prepare: ORACLE - select to_date(to_char(sysdate,'YYYYMMDDHH24')||':00:00','YYYYMMDDHH24:MI:SS') from dual 171 15:45:11 SQL Execute: ORACLE - select to_date(to_char(sysdate,'YYYYMMDDHH24')||':00:00','YYYYMMDDHH24:MI:SS') from dual 172 15:45:14 SQL Prepare: ORACLE - select LSCL00,GJBM00 from VW_BM_YYSFXM where GJBM00 IS NOT NULL and JSXM00='0' and (SFXMID in (0,20059) ) 173 15:45:14 SQL Execute: ORACLE - select LSCL00,GJBM00 from VW_BM_YYSFXM where GJBM00 IS NOT NULL and JSXM00='0' and (SFXMID in (0,20059) ) 174 15:45:14 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 175 15:45:14 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 176 15:45:14 SQL Prepare: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,dw0000,yblbmc,zfbl00,GJBM00,JSXM00 from VW_BQ_CWSFXM where (pysm00 Like :1 or bh0000 Like :2) and( YBZXLB='0' and Ybbrlb='0' and fbbh00='1' ) Order By bh0000,pysm00) where Rownum<=30 177 15:45:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 178 15:45:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 179 15:45:14 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,dw0000,yblbmc,zfbl00,GJBM00,JSXM00 from VW_BQ_CWSFXM where (pysm00 Like ? or bh0000 Like ?) and( YBZXLB='0' and Ybbrlb='0' and fbbh00='1' ) Order By bh0000,pysm00) where Rownum<=30 180 15:45:17 SQL Prepare: ORACLE - insert into BQ_JZXM00 (CH0000, ID0000, ZYID00, CLBZ00, XMLB00, SFXMID, XMMC00, CS0000, DW0000, SFJE00, LRRXM0, QSRQ00, BZ0000,GJBM00) values (:1, :2, :3, :4, 1, :5, :6, :7, :8, :9, :10, TO_CHAR(TO_DATE(:11,'YYYYMMDD'),'YYYYMMDD') , :12, :13) 181 15:45:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 182 15:45:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 183 15:45:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 184 15:45:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 185 15:45:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20058.000000 186 15:45:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 42, Scale = 0, Data = 普通病房床位费[需严格消毒传染科每床日加收] 187 15:45:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 188 15:45:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 日 189 15:45:17 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 190 15:45:17 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 191 15:45:17 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100323 192 15:45:17 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 193 15:45:17 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 110900001 194 15:45:17 SQL Execute: ORACLE - insert into BQ_JZXM00 (CH0000, ID0000, ZYID00, CLBZ00, XMLB00, SFXMID, XMMC00, CS0000, DW0000, SFJE00, LRRXM0, QSRQ00, BZ0000,GJBM00) values (?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ?, TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') , ?, ?) 195 15:45:17 SQL Data In: ORACLE - Rows affected = 1 196 15:45:17 SQL Prepare: ORACLE - update BQ_JZXM00 set CH0000 = :1, ID0000 = :2, ZYID00 = :3, CLBZ00 = :4, XMLB00 = 1, SFXMID = :5, XMMC00 = :6, CS0000 = :7, DW0000 = :8, SFJE00 = :9, LRRXM0 = :10, QSRQ00 = TO_CHAR(TO_DATE(:11,'YYYYMMDD'),'YYYYMMDD') , BZ0000 = :12, GJBM00 = :13 where ID0000 = :14 197 15:45:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 198 15:45:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 993664.000000 199 15:45:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 200 15:45:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 201 15:45:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20059.000000 202 15:45:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 普通病房床位费 203 15:45:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 204 15:45:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 日 205 15:45:17 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 206 15:45:17 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴春兰 207 15:45:17 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091019 208 15:45:17 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 209 15:45:17 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 110900001 210 15:45:17 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 993664.000000 211 15:45:17 SQL Execute: ORACLE - update BQ_JZXM00 set CH0000 = ?, ID0000 = ?, ZYID00 = ?, CLBZ00 = ?, XMLB00 = 1, SFXMID = ?, XMMC00 = ?, CS0000 = ?, DW0000 = ?, SFJE00 = ?, LRRXM0 = ?, QSRQ00 = TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') , BZ0000 = ?, GJBM00 = ? where ID0000 = ? 212 15:45:17 SQL Data In: ORACLE - Rows affected = 1 213 15:45:17 SQL Prepare: ORACLE - COMMIT WORK 214 15:45:17 SQL Execute: ORACLE - COMMIT WORK 215 15:45:17 SQL Prepare: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=:1 and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||:2 order by clbz00,qsrq00 216 15:45:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 217 15:45:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 218 15:45:17 SQL Execute: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, LRRQ00||' '||LRSJ00 "LRRQSJ", ZFJE00,GFJE00,DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000,sfxmid,zyid00,xmlb00, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=? and Tzrq00 is null and gzrq00 is null AND XMLB00='1' and Clbz00 like '%'||? order by clbz00,qsrq00 219 15:45:17 SQL Prepare: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 220 15:45:17 SQL Execute: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 221 15:45:19 SQL Prepare: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 B WHERE DQBQ00=:1 and SUBSTR(BRZT00,1,1)='2' AND EXISTS ( SELECT 1 FROM BQ_JZXM00 J WHERE XMLB00='1' AND TZRQ00 IS NULL AND TRUNC(:2)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE(QSRQ00,'YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 AND B.ZYID00=J.ZYID00 ) ORDER BY RYCWH0 222 15:45:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 223 15:45:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 224 15:45:19 SQL Execute: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 B WHERE DQBQ00=? and SUBSTR(BRZT00,1,1)='2' AND EXISTS ( SELECT 1 FROM BQ_JZXM00 J WHERE XMLB00='1' AND TZRQ00 IS NULL AND TRUNC(?)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE(QSRQ00,'YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 AND B.ZYID00=J.ZYID00 ) ORDER BY RYCWH0 225 15:45:19 SQL Prepare: 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; 226 15:45:19 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 227 15:45:19 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 096043 228 15:45:19 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 229 15:45:19 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 230 15:45:19 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 231 15:45:19 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 232 15:45:19 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 233 15:45:19 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 234 15:45:19 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 235 15:45:19 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 236 15:45:19 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 237 15:45:19 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 238 15:45:19 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 239 15:45:19 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 240 15:45:19 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 241 15:45:19 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; 242 15:45:19 SQL Prepare: ORACLE - SELECT ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,JZJE00,DW0000,LRRXM0,BZ0000,ch0000, DECODE(YBLB00,'0',ZFJE00,SFJE00*ZFBL00*CS0000)"ZFJE00", DECODE(YBLB00,'0',GFJE00,SFJE00*(1-ZFBL00)*CS0000)"GFJE00" from vw_BQ_brJZXM where zyid00=:1 and Tzrq00 is null and XMLB00='1' AND TRUNC(:2)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(:3)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 and Clbz00 like (:4)||'%' order by clbz00,qsrq00 243 15:45:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 244 15:45:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 245 15:45:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 246 15:45:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 247 15:45:19 SQL Execute: ORACLE - SELECT ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,JZJE00,DW0000,LRRXM0,BZ0000,ch0000, DECODE(YBLB00,'0',ZFJE00,SFJE00*ZFBL00*CS0000)"ZFJE00", DECODE(YBLB00,'0',GFJE00,SFJE00*(1-ZFBL00)*CS0000)"GFJE00" from vw_BQ_brJZXM where zyid00=? and Tzrq00 is null and XMLB00='1' AND TRUNC(?)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(?)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 and Clbz00 like (?)||'%' order by clbz00,qsrq00 248 15:45:23 SQL Prepare: ORACLE - BEGIN "SP_BQ_JZXMGZ_BR" (PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCZY000 => :PCZY000,PCLBZ00 => :PCLBZ00,PXMLB00 => :PXMLB00,PRETURN => :PRETURN,PGZRQ00 => :PGZRQ00); END; 249 15:45:23 SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 250 15:45:23 SQL Data In: ORACLE - Param = 2, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 251 15:45:23 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 515.000000 252 15:45:23 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 253 15:45:23 SQL Data In: ORACLE - Param = 5, Name = PXMLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 254 15:45:23 SQL Data In: ORACLE - Param = 6, Name = PRETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 255 15:45:23 SQL Data In: ORACLE - Param = 7, Name = PGZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 3/23/2010 0:0:0:0 256 15:45:23 SQL Execute: ORACLE - BEGIN "SP_BQ_JZXMGZ_BR" (PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCZY000 => :PCZY000,PCLBZ00 => :PCLBZ00,PXMLB00 => :PXMLB00,PRETURN => :PRETURN,PGZRQ00 => :PGZRQ00); END; 257 15:45:24 SQL Prepare: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 B WHERE DQBQ00=:1 and SUBSTR(BRZT00,1,1)='2' AND EXISTS ( SELECT 1 FROM BQ_JZXM00 J WHERE XMLB00='1' AND TZRQ00 IS NULL AND TRUNC(:2)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE(QSRQ00,'YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 AND B.ZYID00=J.ZYID00 ) ORDER BY RYCWH0 258 15:45:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 259 15:45:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 260 15:45:24 SQL Execute: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00 FROM ZY_BRXXB0 B WHERE DQBQ00=? and SUBSTR(BRZT00,1,1)='2' AND EXISTS ( SELECT 1 FROM BQ_JZXM00 J WHERE XMLB00='1' AND TZRQ00 IS NULL AND TRUNC(?)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE(QSRQ00,'YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 AND B.ZYID00=J.ZYID00 ) ORDER BY RYCWH0 261 15:45:24 SQL Prepare: 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; 262 15:45:24 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 263 15:45:24 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 096585 264 15:45:24 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 265 15:45:24 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 266 15:45:24 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 267 15:45:24 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 268 15:45:24 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 269 15:45:24 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 270 15:45:24 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 271 15:45:24 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 272 15:45:24 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 273 15:45:24 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 274 15:45:24 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 275 15:45:24 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 276 15:45:24 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 277 15:45:24 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; 278 15:45:24 SQL Prepare: ORACLE - SELECT ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,JZJE00,DW0000,LRRXM0,BZ0000,ch0000, DECODE(YBLB00,'0',ZFJE00,SFJE00*ZFBL00*CS0000)"ZFJE00", DECODE(YBLB00,'0',GFJE00,SFJE00*(1-ZFBL00)*CS0000)"GFJE00" from vw_BQ_brJZXM where zyid00=:1 and Tzrq00 is null and XMLB00='1' AND TRUNC(:2)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(:3)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 and Clbz00 like (:4)||'%' order by clbz00,qsrq00 279 15:45:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 114820.000000 280 15:45:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 281 15:45:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/23/2010 15:45:18:0 282 15:45:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 283 15:45:24 SQL Execute: ORACLE - SELECT ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,JZJE00,DW0000,LRRXM0,BZ0000,ch0000, DECODE(YBLB00,'0',ZFJE00,SFJE00*ZFBL00*CS0000)"ZFJE00", DECODE(YBLB00,'0',GFJE00,SFJE00*(1-ZFBL00)*CS0000)"GFJE00" from vw_BQ_brJZXM where zyid00=? and Tzrq00 is null and XMLB00='1' AND TRUNC(?)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(?)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0 and Clbz00 like (?)||'%' order by clbz00,qsrq00 284 15:45:28 SQL Prepare: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, TZRQ00,GZRQ00,ZFJE00,GFJE00, DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=:1 AND XMLB00='1' and Clbz00 like '%'||:2 order by clbz00,qsrq00 285 15:45:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 286 15:45:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 287 15:45:28 SQL Execute: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, TZRQ00,GZRQ00,ZFJE00,GFJE00, DECODE(SFYBXM,'Y','是','否')"SFYBXM", JZJE00,DW0000,LRRXM0,BZ0000, GJBM00,JSXM00 from VW_BQ_BRJZXM where zyid00=? AND XMLB00='1' and Clbz00 like '%'||? order by clbz00,qsrq00 288 15:45:28 SQL Prepare: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 289 15:45:28 SQL Execute: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 290 15:45:31 SQL Prepare: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,DW0000,TZRXM0,BZ0000 from BQ_JZXM00 where zyid00=:1 AND XMLB00='1' and tzrq00=to_char(sysdate,'yyyymmdd') and Clbz00 like '%'||(:2) order by clbz00,qsrq00 291 15:45:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113850.000000 292 15:45:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 293 15:45:31 SQL Execute: ORACLE - select ID0000,CH0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00, GZRQ00,DW0000,TZRXM0,BZ0000 from BQ_JZXM00 where zyid00=? AND XMLB00='1' and tzrq00=to_char(sysdate,'yyyymmdd') and Clbz00 like '%'||(?) order by clbz00,qsrq00 294 15:45:31 SQL Prepare: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850 295 15:45:31 SQL Execute: ORACLE - Select ch0000 from bm_cwk000 where zyid00=113850