1 09:25:03 Log started for: SQL Navigator for Oracle 2 09:25:15 Log started for: 门诊医生工作站分系统 3 09:25:15 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','313','3708' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@0806:EF006C93B1A7678757DA3EC138CDECB4' from dual 4 09:25:15 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','313','3708' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@0806:EF006C93B1A7678757DA3EC138CDECB4' from dual 5 09:25:15 SQL Data In: ORACLE - Rows affected = 1 6 09:25:15 SQL Prepare: ORACLE - Commit 7 09:25:15 SQL Execute: ORACLE - Commit 8 09:25:15 SQL Data In: ORACLE - Rows affected = 0 9 09:25:15 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 09:25:15 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 09:25:15 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 09:25:15 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 09:25:15 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 14 09:25:15 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 15 09:25:15 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 09:25:15 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 09:25:15 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','307','1674' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@0806:9FA6B8EF4FFA93CC5498E515793CD875' from dual 18 09:25:15 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','8','appYS_YSGZZ.exe'||'+'||'门诊医生工作站分系统','307','1674' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@0806:9FA6B8EF4FFA93CC5498E515793CD875' from dual 19 09:25:15 SQL Data In: ORACLE - Rows affected = 1 20 09:25:15 SQL Prepare: ORACLE - Commit 21 09:25:15 SQL Execute: ORACLE - Commit 22 09:25:15 SQL Data In: ORACLE - Rows affected = 0 23 09:25:15 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 24 09:25:15 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='8' 25 09:25:15 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 26 09:25:15 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0806' and CZBZ00 in ('1') 27 09:25:15 SQL Prepare: ORACLE - Select SYSDATE from Dual 28 09:25:15 SQL Execute: ORACLE - Select SYSDATE from Dual 29 09:25:15 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 09:25:15 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 09:25:15 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 09:25:15 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 09:25:15 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 34 09:25:15 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='8' 35 09:25:15 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 09:25:15 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 09:25:15 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 38 09:25:15 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 39 09:25:15 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5','9','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) order by b.PLXH00,a.BH0000 40 09:25:15 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','5','9','c') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) order by b.PLXH00,a.BH0000 41 09:25:15 SQL Prepare: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 42 09:25:15 SQL Execute: ORACLE - select trim(Value0) Value0,NAME00 from XT_XTCS00 where NAME00 IN ('XT_MZYSPBDL','YS_PBSJZDLPBKS') 43 09:25:15 SQL Prepare: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') and rownum=1 44 09:25:15 SQL Execute: ORACLE - select GHKSBH,GHQSSJ,GHJSSJ,GHMZSJ from SF_YSGHHB where ((GHQSSJ<=GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')) or (GHQSSJ>GHJSSJ and sysdate+1/24>to_date(GHMZSJ||GHQSSJ,'YYYYMMDDHH24:MI:SS') and sysdate-3/48<=to_date(GHMZSJ||GHJSSJ,'YYYYMMDDHH24:MI:SS')+1)) and TZBZ00 = '0' and GHYSBH=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') and rownum=1 45 09:25:15 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '0806'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') 46 09:25:15 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '0806'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '8' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0806') 47 09:25:15 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=444 48 09:25:15 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=444 49 09:25:15 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 50 09:25:15 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 51 09:25:15 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 52 09:25:15 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 53 09:25:15 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 54 09:25:15 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 55 09:25:15 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 56 09:25:15 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 57 09:25:15 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')) 58 09:25:15 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')) 59 09:25:16 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188399,444,'wlzx-y','8',nvl('228504714',' '),'192.168.5.22#307:1674@appYS_YSGZZ.exe+门诊医生工作站分系统',37) 60 09:25:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188399,444,'wlzx-y','8',nvl('228504714',' '),'192.168.5.22#307:1674@appYS_YSGZZ.exe+门诊医生工作站分系统',37) 61 09:25:16 SQL Data In: ORACLE - Rows affected = 1 62 09:25:16 SQL Prepare: ORACLE - Commit 63 09:25:16 SQL Execute: ORACLE - Commit 64 09:25:16 SQL Data In: ORACLE - Rows affected = 0 65 09:25:16 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 37 66 09:25:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 37 67 09:25:16 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 68 09:25:16 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 69 09:25:16 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 70 09:25:16 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 71 09:25:16 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 72 09:25:16 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 73 09:25:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 74 09:25:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 75 09:25:16 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 37 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 76 09:25:16 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 37 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 77 09:25:16 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 78 09:25:16 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 79 09:25:16 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 80 09:25:16 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 81 09:25:17 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='444' and name00='SYSTEMSKIN' 82 09:25:17 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='444' and name00='SYSTEMSKIN' 83 09:25:17 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 84 09:25:17 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 85 09:25:17 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140827' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',37,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='8') 86 09:25:17 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140827' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',37,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='8') 87 09:25:17 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 88 09:25:17 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 89 09:25:17 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 90 09:25:17 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 91 09:25:17 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 92 09:25:17 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 93 09:25:17 SQL Prepare: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 94 09:25:17 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 95 09:25:17 SQL Prepare: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 96 09:25:17 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 97 09:25:17 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 98 09:25:17 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 99 09:25:17 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS','YS_YYCXZNCXBYS','YS_JCJYJGDZ') 100 09:25:17 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YS_JRZJPH','YF_ZYCF_SFSH','SF_SFSYICK','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','YS_BLPAGEWIDTH','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','YS_CF_SAVE_YPKCSL','YS_MZYSRZGS','XT_CFYS','MZYS_SFDYJYSQD','MZYS_GHZJBC','MZYS_XSBLZTXX','MZYS_YBTSBZ','MZYS_ZLDSFXSSM','MZYS_YBBRYXGH','YS_jcdxz0','XT_GHDJXZ','MZYS_ZLDSFXZMX','MZYS_CXSFTSFZ','YS_YYSXFSSFXZYPXS','YS_YXGMFH','MZYS_JCXMLRFS','XT_MZJYJK','XT_JYDSFBXZDBB','MZYS_BSCX_XZTS','YS_bscx_xm','YS_brcx','MZYS_CFLR_TSBJJE','MZYS_BSCX_XZBYS','YS_BSYGRZD','YS_LRZDXZ','MZYS_GHLBTSYZ','YS_ZYYBRCF','YS_YZCFXZSL','YS_SFXSGXZD','YS_ZHXMXZ','YS_SFDZDCSYZD','YS_JCXMZDTDMXXM','SF_GHXGSFBRCZ','YS_CFLLSFKXGMC','YS_YPBZSFTSJXBC','YS_XSYPBM','ys_THBZPD','YS_BCTSFYXX','YS_SFYXQTYSXGBLZD','YS_YBYPCFSFXSWLS','YS_PACSTWBGWZ','YS_PACSTXLLWZ','YS_DWKSFJRBLYM','YS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','YS_CFZLCXSFCXQBYS','YS_SFXFTZYPSFXSQH','YS_KWJYDSFMRJXZJ','YS_SFTCXZTSBZCT','YK_QYNBFJK','YS_BSCXSFXSGHY','YS_JZLGMFH','YS_DKHCNCXBS','YS_YSXMSQD','YS_XZCXSJ','YS_GZLTJSFXSMX','YS_SFSESQDMS','YS_SFXSSCZD','YS_XMZDSFMRBLZD','YS_HSZYGH','YS_LRBSXZ','SF_GHLBBH','YS_JYXMGJ','YS_YYIDPDDLKS','YS_BRJBXXXSLS','YS_ZYSQSFXYDK','YJ_RHXMLYKSZX','YS_SFSYPASSXT','YS_SFSYDTPASSXT','XT_SFSYTYTYYSCXT','YS_XMJJCLFXZ','YS_SFXSLISCXJG','YS_SFXSJJMS','YS_BCWZLXMSFZX','YS_BLJMMRZD','YS_QYXMZSBS','YS_SFQYXCFGS','YS_BTTSBZYBZXLB','YS_CDJLSFTCZF','YF_TDGSW7DCS','YF_DJDGSCS','YF_CFDYGSCS','YF_CFDYGSCS2','YF_MZCFSFTD','YS_CFJMSFKTD','YS_BLDYSFDYCFD','YS_SFQYSGXT','YS_SFXSCQYY','YS_EKCFSFSRTZ','YS_XYYFSFKYWK','YS_YSSFXZGHLB','YS_YWZHCXXSKC','YS_BRFYTJSFZXSBR','YS_CFDYEKJZBZ','YS_BYSBSYCZLXX','YS_YDCXYBZFBL','YS_YSGZZDLTSXX','YS_YSGZZTSYXQ','YS_SFTSSRBW','YS_JYDKSSFMR','YS_JYXMSRSL','YS_SFCXSCSQD','YS_JCSSZLLRFL','YS_YZCFTSSL','YS_JYXMLRFS','YS_PBYSDKGH','YS_YBBRBGH','YS_HZJMSFXSDK','YS_LRXYCFKZYS','YS_HSGHXZHZXH','YS_GHSFTSYXGH','YS_YZBRZJJZ','YS_SRZDYZD','YS_MZTCFYPJJ','YS_JYDGZXKS','YS_ZFBRZFBLYBLB','YS_SFQYCRBGKGN','YS_ZJWSFTSJZ','YS_EKCFJDFS','YS_ZDYDY_MZRZ','YS_SFTHHCCX','YS_GDXMBYXXG','YS_CFXZZDTS','YS_SFBXYZDCNBCGH','YS_DMCFXZZDTS','YS_ZJCFSSFTSDJZCF','YS_MZYSMFGHLB','YS_SFTSGH','YS_ZJCFSSFTSDJZCF','YS_YSSFBJDZDXX','YS_BRJZBSCXSFXDK','YS_BQYHSYGHZGHSFJRDL','YS_SFTSQTKSYSYGH','YS_SFBXTXDMZD','YS_JYKDSFXSJZ','YS_YSCYZDWHSFYXSGSR','YS_SFXSJMYBSYJE','YS_YBBRDZCFXE','YK_YWSCTP_BCLJ','YK_YYGXH','YS_JZZGHSFZYXZYS','YS_CFFWFXSFPX','YS_ZLSQDGJSFXSQTZXKSSJ','YS_CFLRSFBXDDZFZD','YS_SFYXYSXGQTYSZD','YS_FZHBXSFZBL','YS_MJLYZCYGBRSQYCFY','YS_XCYCFTZYPSFTS15TNYL','YS_XMCXSFXZBYS','YS_BLDYBFCZHFZ','YF_SFABYFFYDWFY','YS_ZYCFBCBTSBRNY','YS_ZYMRFYCSMRFS','YS_XZZYBZLZ','YS_SFYXSYKYGHH','YS_SFFYCXTJ','YS_BSCXTJZJFBYBLB','YS_QYBLHQYBSSFPBYS','YS_JYJCSSZLZXKS','YS_BRZJGHXYYSSQTH','YS_CRBDJZDYID','YS_SFXZFNHYBBRZDTS','YS_JCJYMRSTJLZD','YS_KJYGQXZB','YS_SFXSPTYBSYJE','YS_KDSFXSBZ','YJ_ZDKSYXQXMZX','YS_DKHSFPDJTDZWK','YS_ZJCFSCFMRWZ','YS_BRNLXG','YS_SFKYYBCCF','YS_GHCFZCLFS','YS_CFLR_QTXXMRDG','YS_CYPBDKZJDKYSIDC','YS_JYXMLRFS_HB','YS_DMCFSFYZXS','YS_EKYSZNDLER','YS_YQBGBZSFKYXG','YS_BYSXSCRB','YS_ZYSQZDSFBT','YS_YETSSFCYFDCT','YS_SFPBJYJM','YS_GHLRZDSFXXQBZD','YS_JKXXDZ_NEW','YS_SFXZSCBL' ,'YS_JCJYSRSFYXDX','YS_JCSSZLDBCHSFZDTCGJCK','YS_YJZXDZDYID','YS_CYPBYSYXDKYSBHC','YS_LXLRJCJYSFBDCTCTSBZTS','YS_HZJMTSCL','YS_BCHZJJZ','YS_FYZLDSFZJJZ','YS_TSBZXZCFXM','YS_CFLRSFAYKPD','YS_MXBDJ','YS_CFBCSZDXXQSTS','YS_SFQYDZQB','YS_SYHZSLYPSFTSZYSY','YS_CRBDJSFQZSR','YS_CFXEFS','YS_SFXSYBZHYE','YS_ZYDYSFMRZJYF','SF_COMMIT_READICK','YS_CRBDJSFQFLBMD','YS_BSCXJMXMCXYXTS','YY_YYSFXMID','YY_SFYXDTYY','YY_YYTQTS','YS_YYHZDDYID','YY_ZJBHSFBT','YS_CFBCSSFTSBRZTQK','YS_YJJYEW0SYXGHBRLB','YS_BRJZSYXSYGXGHDKS','YS_LNYYMSXXMSFYXSRXS','YS_SFXZJTFBCFKJTS','YS_YYCXZNCXBYS','YS_JCJYJGDZ') 101 09:25:17 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 102 09:25:17 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 103 09:25:18 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 104 09:25:18 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 105 09:25:18 SQL Prepare: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 106 09:25:18 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 107 09:25:18 SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 108 09:25:18 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 109 09:25:18 SQL Prepare: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 110 09:25:18 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 111 09:25:18 SQL Prepare: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='居民健康档案提示的相关参数' AND YXBZ00='1' order by XSXH00 112 09:25:18 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='居民健康档案提示的相关参数' AND YXBZ00='1' order by XSXH00 113 09:25:18 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 444 114 09:25:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_XCYCYZD','YS_ZYCYZD','YS_JYCYZD','YS_JCCYZD','YS_ZDCYZD','YH_YS_JJMS','YH_YS_JCZLFL','YS_BLPrinter','YS_CFPrinter') and YGBH00 = 444 115 09:25:18 SQL Prepare: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=:1) 116 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 117 09:25:18 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 118 09:25:18 SQL Prepare: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 119 09:25:18 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=0 and lbmc00 like '%急%' and SFYX00='Y' 120 09:25:18 SQL Prepare: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=:1 and GHYSBH=:2 and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 121 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 122 09:25:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 123 09:25:18 SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=? and GHYSBH=? and GHMZSJ=to_char(sysdate,'yyyymmdd') and GHQSSJ<=to_char(sysdate,'hh24:mi:ss') and GHJSSJ>=to_char(sysdate,'hh24:mi:ss') and PBLX00='0' 124 09:25:18 SQL Prepare: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=:1 125 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 126 09:25:18 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 127 09:25:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 128 09:25:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 129 09:25:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='8'))) 130 09:25:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='8'))) 131 09:25:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||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 132 09:25:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '8$%' and A.XTDM00='8' and trim(A.MKDM00)='8$'||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 133 09:25:18 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 ((444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='0 '))) 134 09:25:18 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='0 '))) 135 09:25:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 136 09:25:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 137 09:25:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='+ '))) 138 09:25:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 444= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=444 and XTDM00='+ '))) 139 09:25:18 SQL Prepare: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=:1 and a.YSLB00=b.YSLB00(+) 140 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 141 09:25:18 SQL Execute: ORACLE - select a.YSLB00,nvl(b.YSLBMC,'未设置') YSLBMC,nvl(b.SCJKDJ,'A') SCJKDJ from BM_YGBM00 a,BM_YSLB00 b where a.YGBH00=? and a.YSLB00=b.YSLB00(+) 142 09:25:18 SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 143 09:25:18 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 144 09:25:18 SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=:1 145 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 146 09:25:18 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 147 09:25:18 SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and GZDJ00 <=:2 and MZDJ00 <=:3 and DPDJ00 <=:4 and KSSDJ0<=:5 and ((SJDJ00 >=:6 and :7 >'0') or SJDJ00='0') and Rownum=1 148 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 149 09:25:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 150 09:25:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 151 09:25:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 152 09:25:18 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 153 09:25:18 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 154 09:25:18 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 155 09:25:18 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 156 09:25:18 SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1 157 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 158 09:25:18 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 159 09:25:18 SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1 160 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 161 09:25:18 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 162 09:25:18 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 163 09:25:18 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 164 09:25:18 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 165 09:25:18 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 166 09:25:18 SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00 167 09:25:18 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 168 09:25:18 SQL Prepare: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 169 09:25:18 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 170 09:25:18 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 171 09:25:18 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 172 09:25:18 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 173 09:25:18 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 174 09:25:18 SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 175 09:25:18 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 176 09:25:18 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 177 09:25:18 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 178 09:25:18 SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 179 09:25:18 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 180 09:25:18 SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 181 09:25:18 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 182 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 183 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 184 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 185 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 186 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 187 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 188 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 189 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 190 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 191 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 192 09:25:18 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 193 09:25:18 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 194 09:25:18 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=:1 and ghksbh=:2 195 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 196 09:25:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 197 09:25:18 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 198 09:25:18 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=:1 and jzks00=:2 199 09:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444 200 09:25:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 201 09:25:18 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 202 09:25:19 SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 444 203 09:25:19 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 444 204 09:25:19 SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 205 09:25:19 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 206 09:25:19 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 207 09:25:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 208 09:25:19 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 209 09:25:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 210 09:25:19 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 211 09:25:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 212 09:25:19 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 213 09:25:19 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 214 09:25:19 SQL Prepare: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=444 215 09:25:19 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=444 216 09:25:26 SQL Prepare: ORACLE - Select SYSDATE from Dual 217 09:25:26 SQL Execute: ORACLE - Select SYSDATE from Dual 218 09:25:26 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 219 09:25:26 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 220 09:25:26 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 221 09:25:26 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 222 09:25:26 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601236069' and ICKNBH = '0222137601236069' 223 09:25:26 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601236069' and ICKNBH = '0222137601236069' 224 09:25:26 SQL Prepare: ORACLE - select * from vw_ys_brxxb0 where BRID00=:1 225 09:25:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 226 09:25:26 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=? 227 09:25:26 SQL Prepare: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=:1 228 09:25:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 229 09:25:26 SQL Execute: ORACLE - select kmh000,ickh00 from ic_yhxx00 where zt0000='1' and brid00=? 230 09:25:26 SQL Prepare: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=:1) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=444) or (a.JZYS00=0) ) or (a.GHKS00=37 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 231 09:25:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 232 09:25:26 SQL Execute: ORACLE - select * from VW_YS_YXGH00_YS a where (BRID00=?) and ghlb00<>-99999 and (('N'='N') or ((a.JZYS00=444) or (a.JZYS00=0) ) or (a.GHKS00=37 and instr(';'||'N'||';',';'||to_char(a.GHKS00)||';')>0 ) ) order by ghh000 desc 233 09:25:26 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='6965702' and LBBH00='0' 234 09:25:26 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='6965702' and LBBH00='0' 235 09:25:26 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 236 09:25:26 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 237 09:25:27 SQL Prepare: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=:1 and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,:2)>0) 238 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14186189 239 09:25:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = /222137/ 240 09:25:27 SQL Execute: ORACLE - select a.* from VW_YS_BYZJYPDDYZD a,YS_BRZDXX b where a.ZDICD0=trim(b.ICD900) and b.GHID00=? and exists(select 1 from XT_XTCS00 where NAME00='YS_TZDDYZJYYID' and instr(VALUE0,?)>0) 241 09:25:27 SQL Prepare: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='6965702' and HZZT00 in ('0','2','4') 242 09:25:27 SQL Execute: ORACLE - update SF_HZBR00 set HZZT00='1',YZRQ00=to_char(sysdate,'yyyymmdd'),YZSJ00=to_char(sysdate,'hh24:mi:ss') where GHH000='6965702' and HZZT00 in ('0','2','4') 243 09:25:27 SQL Data In: ORACLE - Rows affected = 0 244 09:25:27 SQL Prepare: ORACLE - commit 245 09:25:27 SQL Execute: ORACLE - commit 246 09:25:27 SQL Data In: ORACLE - Rows affected = 0 247 09:25:27 SQL Prepare: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = :1 order by zzdbz0 248 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 249 09:25:27 SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC, a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0, (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900) ICDJMC from YS_BRZDXX a, XT_ICD900 b where a.ICD900 = b.ICD900(+) and a.SFXYZD='1' and a.GHID00 = ? order by zzdbz0 250 09:25:27 SQL Prepare: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=:1 order by zzdbz0 251 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 252 09:25:27 SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC, JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD, DECODE((SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and ROWNUM=1), NULL, (SELECT TRIM(JBBH00)||' '||JBMC00 FROM VW_BM_ZYJBZD WHERE JBBH00= A.ICD900 and rownum=1), (SELECT TRIM(TRIM(ZHBH00)||' '||ZHMC00) FROM vw_bm_zyzhzd WHERE ZHBH00= A.ICD900 and rownum=1)) ICDJMC from YS_BRZDXX A where SFXYZD='0'and GHID00=? order by zzdbz0 253 09:25:27 SQL Prepare: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=14186189 254 09:25:27 SQL Execute: ORACLE - select nvl(SFLG00,'N') SFLG00,YYLBID,to_date(decode(nvl(YYKBRQ,' '),' ',to_char(sysdate,'YYYYMMDD'),YYKBRQ),'YYYYMMDD') YYKBRQ from SF_BRXXB0 where GHID00=14186189 255 09:25:27 SQL Prepare: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=:1 256 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 257 09:25:27 SQL Execute: ORACLE - SELECT BRBQID, GHID00, GHH000, BRZS00, SFCZ00, SFHC00, BS0000, TGJC00, SYSJC0, SZ0000, ST0000, MX0000, TW0000, XTCS00, HXCS00, SZY000, SSY000, JZYS00, SJYS00, CZRQ00, CZSJ00, JZYSXM, ZS0000, JZRQSJ, ZDCLNR, FBRQ00,TO_DATE(FBRQ00,'YYYYMMDD') FBRQ01 FROM YS_BRBQB0 WHERE GHID00=? 258 09:25:27 SQL Prepare: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=3508979)and GHID00<14186189 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=3508979)and GHID00>14186189 and rownum=1 259 09:25:27 SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=3508979)and GHID00<14186189 and rownum=1 Union all select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=3508979)and GHID00>14186189 and rownum=1 260 09:25:27 SQL Prepare: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=:1 and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=:2 and MZZYBZ='0' and xmzt00 in ('0','1') 261 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 262 09:25:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 263 09:25:27 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 264 09:25:27 SQL Prepare: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=:1 and a.BRID00=b.BRID00 265 09:25:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 266 09:25:27 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 267 09:25:27 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 268 09:25:27 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 269 09:25:30 SQL Prepare: ORACLE - select * from ys_cfxxb0 where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=:1 and YPDLBH in ('0','1') and CFXZ00='0') 270 09:25:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 271 09:25:30 SQL Execute: ORACLE - select * from ys_cfxxb0 where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=? and YPDLBH in ('0','1') and CFXZ00='0') 272 09:25:30 SQL Prepare: ORACLE - select CFZT00,YSXM00,bccfh0 from YF_MZCF00 where ghid00=:1 and (cflsh0=:2 or bccfh0=:3) 273 09:25:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14186189 274 09:25:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253537 275 09:25:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253537 276 09:25:30 SQL Execute: ORACLE - select CFZT00,YSXM00,bccfh0 from YF_MZCF00 where ghid00=? and (cflsh0=? or bccfh0=?) 277 09:25:30 SQL Prepare: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=:1 and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 278 09:25:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253537 279 09:25:30 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 280 09:25:30 SQL Prepare: ORACLE - select YFID00,YPYFMC from BM_YPYF00 281 09:25:30 SQL Execute: ORACLE - select YFID00,YPYFMC from BM_YPYF00 282 09:25:30 SQL Prepare: ORACLE - select pcid00,pcmc00,ZQDW00 "LCDW" from VW_bm_pc0000 283 09:25:30 SQL Execute: ORACLE - select pcid00,pcmc00,ZQDW00 "LCDW" from VW_bm_pc0000 284 09:25:30 SQL Prepare: ORACLE - select PSID00,PSMC00 from BM_PS0000 where YXBZ00='1' 285 09:25:30 SQL Execute: ORACLE - select PSID00,PSMC00 from BM_PS0000 where YXBZ00='1' 286 09:25:30 SQL Prepare: ORACLE - select count(1) from YS_CFXXB0 where GHH000='6965702' and to_number(CFLSH0)to_number('7253537') and YPDLBH in ('0','1') and CFXZ00='0' and rownum=1 287 09:25:30 SQL Execute: ORACLE - select count(1) from YS_CFXXB0 where GHH000='6965702' and to_number(CFLSH0)to_number('7253537') and YPDLBH in ('0','1') and CFXZ00='0' and rownum=1 288 09:25:32 SQL Prepare: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=:1 289 09:25:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 主治医师 290 09:25:32 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 291 09:25:32 SQL Prepare: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=:1 292 09:25:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 293 09:25:32 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 294 09:25:32 SQL Prepare: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 295 09:25:32 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3508979.000000 296 09:25:32 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 297 09:25:32 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 444.000000 298 09:25:32 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 299 09:25:32 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 300 09:25:32 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 301 09:25:32 SQL Prepare: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0); END; 302 09:25:32 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3508979.000000 303 09:25:32 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 304 09:25:32 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 305 09:25:32 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 306 09:25:32 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = X 307 09:25:32 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 444.000000 308 09:25:32 SQL Execute: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0); END; 309 09:25:32 SQL Prepare: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (p_LSH => :p_LSH); END; 310 09:25:32 SQL Data In: ORACLE - Param = 2, Name = p_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = MZYF_MZCFH 311 09:25:32 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 312 09:25:32 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (p_LSH => :p_LSH); END; 313 09:25:32 SQL Prepare: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=:1 and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 314 09:25:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253538 315 09:25:32 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 316 09:25:32 SQL Prepare: ORACLE - select * from YS_CFXXB0 where CFLSH0=:1 317 09:25:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253538 318 09:25:32 SQL Execute: ORACLE - select * from YS_CFXXB0 where CFLSH0=? 319 09:25:32 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 320 09:25:32 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=37 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 321 09:25:35 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 322 09:25:35 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 323 09:25:35 SQL Prepare: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like :1) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'w'),PYSM00) where Rownum<=300 324 09:25:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %w% 325 09:25:35 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like ?) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'w'),PYSM00) where Rownum<=300 326 09:25:35 SQL Prepare: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like :1) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'ws'),PYSM00) where Rownum<=300 327 09:25:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %ws% 328 09:25:35 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like ?) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'ws'),PYSM00) where Rownum<=300 329 09:25:37 SQL Prepare: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like :1) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'wss'),PYSM00) where Rownum<=300 330 09:25:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %wss% 331 09:25:37 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,bz0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like ?) and( LBBH00 in ('0','1','3') AND YFBMBH=70 AND CFJB00 <= 2 AND GZDJ00 <= '1' and KSSDJ0<='2' and YBBRLB='0' and YBZXLB='@' and FBBH00=3 ) Order By Instrb(PYSM00,'wss'),PYSM00) where Rownum<=300 332 09:25:40 SQL Prepare: ORACLE - select SF_YS_GETBRLSYPYYL(1791,3508979) VTS000 from dual 333 09:25:40 SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(1791,3508979) VTS000 from dual 334 09:25:40 SQL Prepare: ORACLE - SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=:1 335 09:25:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1791 336 09:25:40 SQL Execute: ORACLE - SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=? 337 09:25:40 SQL Prepare: ORACLE - BEGIN :Result := "SF_YS_GETCLY" (P_YPNM00 => :P_YPNM00,P_MCSL00 => :P_MCSL00,P_BRID00 => :P_BRID00); END; 338 09:25:40 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 339 09:25:40 SQL Data In: ORACLE - Param = 2, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1791.000000 340 09:25:40 SQL Data In: ORACLE - Param = 3, Name = P_MCSL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 341 09:25:40 SQL Data In: ORACLE - Param = 4, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3508979.000000 342 09:25:40 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_GETCLY" (P_YPNM00 => :P_YPNM00,P_MCSL00 => :P_MCSL00,P_BRID00 => :P_BRID00); END; 343 09:25:48 SQL Prepare: ORACLE - Select 1 from SF_BRXXB0 where GHH000='6965702' and LBBH00='0' 344 09:25:48 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='6965702' and LBBH00='0' 345 09:25:48 SQL Prepare: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 346 09:25:48 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 347 09:25:48 SQL Prepare: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 348 09:25:48 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='3508979' and ZT0000='1' 349 09:25:48 SQL Prepare: ORACLE - Select SYSDATE from Dual 350 09:25:48 SQL Execute: ORACLE - Select SYSDATE from Dual 351 09:25:48 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 352 09:25:48 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 353 09:25:48 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 354 09:25:48 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 355 09:25:48 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601236069' and ICKNBH = '0222137601236069' 356 09:25:48 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137601236069' and ICKNBH = '0222137601236069' 357 09:25:48 SQL Prepare: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=:1 358 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1791 359 09:25:48 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 360 09:25:48 SQL Prepare: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=:1 and YPNM00=:2 and SJKCSL>0 361 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 362 09:25:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1791 363 09:25:48 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=? and YPNM00=? and SJKCSL>0 364 09:25:48 SQL Prepare: ORACLE - select LBBH00 from vw_ys_ypkcxx where ypnm00=:1 and yfbmbh=:2 365 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1791 366 09:25:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 367 09:25:48 SQL Execute: ORACLE - select LBBH00 from vw_ys_ypkcxx where ypnm00=? and yfbmbh=? 368 09:25:48 SQL Prepare: ORACLE - select count(*) COU from BM_TYZD00 where ZDMC00='人流控制药品目录' and DJ0000 in (1791) 369 09:25:48 SQL Execute: ORACLE - select count(*) COU from BM_TYZD00 where ZDMC00='人流控制药品目录' and DJ0000 in (1791) 370 09:25:48 SQL Prepare: ORACLE - select b.YPMC00,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00 from BM_YD0000 b where YPNM00=1791 371 09:25:48 SQL Execute: ORACLE - select b.YPMC00,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00 from BM_YD0000 b where YPNM00=1791 372 09:25:48 SQL Prepare: ORACLE - Delete from ys_cfmx00 where cflsh0='7253538' and cfid00 not in (-1) 373 09:25:48 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='7253538' and cfid00 not in (-1) 374 09:25:48 SQL Data In: ORACLE - Rows affected = 0 375 09:25:48 SQL Prepare: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '7253538','1791','维生素B2片','5mg*42','0.0121','001','','1','mg','1','','','','','N','100','片','5','','1','7','0','','','','1') 376 09:25:48 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '7253538','1791','维生素B2片','5mg*42','0.0121','001','','1','mg','1','','','','','N','100','片','5','','1','7','0','','','','1') 377 09:25:48 SQL Data In: ORACLE - Rows affected = 1 378 09:25:48 SQL Prepare: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,TSYS00,BRZJBH) Values ('7253538','70','14186189','6965702','3508979','林宝英','女',0,'1','444','37','37','0','0',1,0,0,'1',0,'444',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,1.21,null,'',-1,'') 379 09:25:48 SQL Execute: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,TSYS00,BRZJBH) Values ('7253538','70','14186189','6965702','3508979','林宝英','女',0,'1','444','37','37','0','0',1,0,0,'1',0,'444',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,1.21,null,'',-1,'') 380 09:25:48 SQL Data In: ORACLE - Rows affected = 1 381 09:25:48 SQL Prepare: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19431030',DJH000,YSGZH0,'陈韵辉',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='7253538' 382 09:25:48 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19431030',DJH000,YSGZH0,'陈韵辉',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='7253538' 383 09:25:48 SQL Data In: ORACLE - Rows affected = 1 384 09:25:48 SQL Prepare: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00 from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='7253538' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 385 09:25:48 SQL Execute: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00 from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='7253538' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 386 09:25:48 SQL Data In: ORACLE - Rows affected = 1 387 09:25:48 SQL Prepare: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 388 09:25:48 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7253538 389 09:25:48 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6965702 390 09:25:48 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈韵辉 391 09:25:48 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 392 09:25:48 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 393 09:25:48 SQL Execute: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 394 09:25:48 SQL Prepare: ORACLE - select count(*) from YS_CFMX00 a,VW_YS_YPDYZXLZYZD b where a.CFLSH0='7253538' and a.YPNM00=b.YPNM00 395 09:25:48 SQL Execute: ORACLE - select count(*) from YS_CFMX00 a,VW_YS_YPDYZXLZYZD b where a.CFLSH0='7253538' and a.YPNM00=b.YPNM00 396 09:25:48 SQL Prepare: ORACLE - select SF_YS_GETTSBZTSXX_ZZCF('7253538','') TSXX00 from DUAL 397 09:25:48 SQL Execute: ORACLE - select SF_YS_GETTSBZTSXX_ZZCF('7253538','') TSXX00 from DUAL 398 09:25:48 SQL Prepare: ORACLE - select count(*) DCSL00 from YJ_YW0000 where YZCFID='7253538' and ZYHGHH='6965702' 399 09:25:48 SQL Execute: ORACLE - select count(*) DCSL00 from YJ_YW0000 where YZCFID='7253538' and ZYHGHH='6965702' 400 09:25:48 SQL Prepare: ORACLE - Commit 401 09:25:48 SQL Execute: ORACLE - Commit 402 09:25:48 SQL Data In: ORACLE - Rows affected = 0 403 09:25:48 SQL Prepare: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=:1 and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 404 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7253538 405 09:25:48 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 406 09:25:48 SQL Prepare: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=:1 and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=:2 and MZZYBZ='0' and xmzt00 in ('0','1') 407 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 408 09:25:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6965702 409 09:25:48 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 410 09:25:48 SQL Prepare: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=:1 and a.BRID00=b.BRID00 411 09:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 412 09:25:48 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 413 09:25:57 SQL Prepare: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=:1 and PBLX00='1' and flag00='4' 414 09:25:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37 415 09:25:57 SQL Execute: ORACLE - select count(*) vcount from bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 416 09:25:57 SQL Prepare: ORACLE - Rollback 417 09:25:57 SQL Execute: ORACLE - Rollback 418 09:25:57 SQL Data In: ORACLE - Rows affected = 0 419 09:25:57 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4188399 420 09:25:57 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4188399 421 09:25:57 SQL Data In: ORACLE - Rows affected = 1 422 09:25:57 SQL Prepare: ORACLE - Commit 423 09:25:57 SQL Execute: ORACLE - Commit 424 09:25:57 SQL Data In: ORACLE - Rows affected = 0 425 09:25:57 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 426 09:25:57 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 427 09:25:57 SQL Data In: ORACLE - Rows affected = 0 428 09:25:57 SQL Prepare: ORACLE - Commit 429 09:25:57 SQL Execute: ORACLE - Commit 430 09:25:57 SQL Data In: ORACLE - Rows affected = 0 431 09:25:57 Log started for: SQL Navigator for Oracle 432 09:26:08 Log started for: 门诊处方取号 433 09:26:08 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','D',trim(PROGRAM)||'+'||'门诊处方取号',SID,serial# ,'20140827','09:26:08','scott@3335:416BE2C90BFEAC59263EB5C4EB05E901' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 434 09:26:08 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','D',trim(PROGRAM)||'+'||'门诊处方取号',SID,serial# ,'20140827','09:26:08','scott@3335:416BE2C90BFEAC59263EB5C4EB05E901' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 435 09:26:08 SQL Data In: ORACLE - Rows affected = 1 436 09:26:08 SQL Prepare: ORACLE - Commit 437 09:26:08 SQL Execute: ORACLE - Commit 438 09:26:08 SQL Data In: ORACLE - Rows affected = 0 439 09:26:08 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 440 09:26:08 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 441 09:26:08 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 442 09:26:08 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 443 09:26:08 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3335' and CZBZ00 in ('1') 444 09:26:08 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3335' and CZBZ00 in ('1') 445 09:26:08 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','D',trim(PROGRAM)||'+'||'门诊处方取号',SID,serial# ,'20140827','09:26:08','sd_Hospital@3335:91CD1C8E5E6612D6BFBDD47FD73DEDEB' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 446 09:26:08 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.22','D',trim(PROGRAM)||'+'||'门诊处方取号',SID,serial# ,'20140827','09:26:08','sd_Hospital@3335:91CD1C8E5E6612D6BFBDD47FD73DEDEB' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 447 09:26:08 SQL Data In: ORACLE - Rows affected = 1 448 09:26:08 SQL Prepare: ORACLE - Commit 449 09:26:08 SQL Execute: ORACLE - Commit 450 09:26:08 SQL Data In: ORACLE - Rows affected = 0 451 09:26:08 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 452 09:26:08 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 453 09:26:08 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3335' and CZBZ00 in ('1') 454 09:26:08 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3335' and CZBZ00 in ('1') 455 09:26:08 SQL Prepare: ORACLE - Select SYSDATE from Dual 456 09:26:08 SQL Execute: ORACLE - Select SYSDATE from Dual 457 09:26:08 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 458 09:26:08 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 459 09:26:08 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 460 09:26:08 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 461 09:26:08 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 462 09:26:08 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 463 09:26:08 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 464 09:26:08 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 465 09:26:08 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3335')) order by BH0000 466 09:26:08 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3335')) order by BH0000 467 09:26:08 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '3335'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'D' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3335')) 468 09:26:08 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '3335'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'D' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3335')) 469 09:26:08 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=365 470 09:26:08 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=365 471 09:26:08 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 472 09:26:08 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 473 09:26:08 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 474 09:26:08 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 475 09:26:08 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 476 09:26:08 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 477 09:26:08 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 478 09:26:08 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 479 09:26:08 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')) 480 09:26:08 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')) 481 09:26:08 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188401,365,'wlzx-y','D',nvl('228504718',' '),'192.168.5.22#313:3734@Cfpdqh.exe+门诊处方取号',259) 482 09:26:08 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4188401,365,'wlzx-y','D',nvl('228504718',' '),'192.168.5.22#313:3734@Cfpdqh.exe+门诊处方取号',259) 483 09:26:08 SQL Data In: ORACLE - Rows affected = 1 484 09:26:08 SQL Prepare: ORACLE - Commit 485 09:26:08 SQL Execute: ORACLE - Commit 486 09:26:08 SQL Data In: ORACLE - Rows affected = 0 487 09:26:08 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 259 488 09:26:08 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 259 489 09:26:08 SQL Prepare: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 490 09:26:08 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 491 09:26:08 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 492 09:26:08 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22' 493 09:26:08 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 494 09:26:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 495 09:26:08 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 496 09:26:08 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 497 09:26:08 SQL Data In: ORACLE - Rows affected = 0 498 09:26:08 SQL Prepare: ORACLE - Commit 499 09:26:08 SQL Execute: ORACLE - Commit 500 09:26:08 SQL Data In: ORACLE - Rows affected = 0 501 09:26:08 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 259 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 502 09:26:08 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 259 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 503 09:26:08 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 504 09:26:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 505 09:26:08 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='D') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',259,')> 0) and YXQ000>='20140827' 506 09:26:08 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='D') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',259,')> 0) and YXQ000>='20140827' 507 09:26:08 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 508 09:26:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 509 09:26:08 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 510 09:26:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 511 09:26:08 SQL Prepare: ORACLE - select * from xt_yyxx00 where rownum=1 512 09:26:08 SQL Execute: ORACLE - select * from xt_yyxx00 where rownum=1 513 09:26:08 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YF_ZYCF_SFSH','SF_SFSYICK','XT_SGLRKH','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEWIDTH','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','XT_CFYS','YS_CF_SAVE_YPKCSL','XT_JYDSFBXZDBB','XT_MZJYJK','YS_YPBZSFTSJXBC','YS_JZLGMFH','YS_HSZYGH','YS_YSSFXZGHLB','YS_HSZSFDYHZD','YS_CFDRKGMFH','YS_SFANKSXZYS','YS_FZJMXSYGSJD','YS_HSGHXZHZXH','YS_HSZJJCL','YS_ZFBRZFBLYBLB','YS_YGHSFZZSGH','YS_MZCFDRXSFS','YS_MZYSMFGHLB','MZHS_DRXTSFYXZJTJXM','MZHS_HZBRPLSX','YK_YYGXH','MZHS_SFYXSCWSFZLXMDCCF','YJ_RHXMLYKSZX','MZHS_HZBRJHFA','MZHS_JZBRJHCS','MZHS_HZBRJHCS','MZHS_HZBRJHJGSJ','YF_SFABYFFYDWFY','MZHS_SFXSKSZLLBXM','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YJ_CXDCXMCXCF','YJ_XMCXZJTF','YJ_SYBLHCZ','MZHS_XMZXQXCXGHH','YS_QTYSYGHSFTS','YS_SFYXSYKYGHH','MZHS_YSPBHYSHBSFGLXTGN','MZPY_NPYYPYTSCL','YF_MZCFBLTS','MZHS_CYPHYF','MZHS_QYYF','PDXT_PRINTID','ZZQH_TSBLSJ','ZZQH_TGBRDKJGSJ','MZPY_JZHSFZJFY') 514 09:26:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_BRXXB0_QYJZHZ','YS_CFXXB0_DCFXE','YF_ZYCF_SFSH','SF_SFSYICK','XT_SGLRKH','XT_XYCYTCF','YS_BLFONTSIZE','YS_BLPAGEWIDTH','YS_BLPAGEHEIGHT','YS_BLBLANKROWS','XT_GZYJJYXTJK','YS_ZYSFDJ','YS_ZYMRTS','XT_CFYS','YS_CF_SAVE_YPKCSL','XT_JYDSFBXZDBB','XT_MZJYJK','YS_YPBZSFTSJXBC','YS_JZLGMFH','YS_HSZYGH','YS_YSSFXZGHLB','YS_HSZSFDYHZD','YS_CFDRKGMFH','YS_SFANKSXZYS','YS_FZJMXSYGSJD','YS_HSGHXZHZXH','YS_HSZJJCL','YS_ZFBRZFBLYBLB','YS_YGHSFZZSGH','YS_MZCFDRXSFS','YS_MZYSMFGHLB','MZHS_DRXTSFYXZJTJXM','MZHS_HZBRPLSX','YK_YYGXH','MZHS_SFYXSCWSFZLXMDCCF','YJ_RHXMLYKSZX','MZHS_HZBRJHFA','MZHS_JZBRJHCS','MZHS_HZBRJHCS','MZHS_HZBRJHJGSJ','YF_SFABYFFYDWFY','MZHS_SFXSKSZLLBXM','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YJ_CXDCXMCXCF','YJ_XMCXZJTF','YJ_SYBLHCZ','MZHS_XMZXQXCXGHH','YS_QTYSYGHSFTS','YS_SFYXSYKYGHH','MZHS_YSPBHYSHBSFGLXTGN','MZPY_NPYYPYTSCL','YF_MZCFBLTS','MZHS_CYPHYF','MZHS_QYYF','PDXT_PRINTID','ZZQH_TSBLSJ','ZZQH_TGBRDKJGSJ','MZPY_JZHSFZJFY') 515 09:26:08 SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 516 09:26:08 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 517 09:26:08 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_INPUTBMDIRECT') and YGBH00 = 365 518 09:26:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_INPUTBMDIRECT') and YGBH00 = 365 519 09:26:13 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 520 09:26:13 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 521 09:26:13 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 522 09:26:13 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 523 09:26:14 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = :1 and ICKNBH = :2 524 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222137601236069 525 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222137601236069 526 09:26:14 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = ? and ICKNBH = ? 527 09:26:14 SQL Prepare: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = '0222137601236069' 528 09:26:14 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = '0222137601236069' 529 09:26:14 SQL Prepare: ORACLE - select DKSJ00,DRDKCS,to_date(DKRQ00||DKSJ00,'YYYYMMDDHH24:MI:SS') DKRQSJ from BM_BRDKXX where BRID00=:1 and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 530 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 531 09:26:14 SQL Execute: ORACLE - select DKSJ00,DRDKCS,to_date(DKRQ00||DKSJ00,'YYYYMMDDHH24:MI:SS') DKRQSJ from BM_BRDKXX where BRID00=? and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 532 09:26:14 SQL Prepare: ORACLE - update BM_BRDKXX set DKSJ00=to_char(sysdate,'HH24:MI:SS'),DRDKCS=nVL(DRDKCS,0)+1 where BRID00=:1 and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 533 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 534 09:26:14 SQL Execute: ORACLE - update BM_BRDKXX set DKSJ00=to_char(sysdate,'HH24:MI:SS'),DRDKCS=nVL(DRDKCS,0)+1 where BRID00=? and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 535 09:26:14 SQL Data In: ORACLE - Rows affected = 1 536 09:26:14 SQL Prepare: ORACLE - commit 537 09:26:14 SQL Execute: ORACLE - commit 538 09:26:14 SQL Data In: ORACLE - Rows affected = 0 539 09:26:14 SQL Prepare: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=:1 540 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 541 09:26:14 SQL Execute: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=? 542 09:26:14 SQL Prepare: ORACLE - SELECT C.GHH000,C.CFLSH0,C.GHID00,C.BRXM00,C.XB0000,C.BRID00,C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,C.ZYTS00,C.ZYDJS0,C.GHKS00 GHKSBM,C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,C.THBZ00,(SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, DECODE(NVL((SELECT PHBZ00 FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'0'),'0','未排',(SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) ) DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT FBBH00 FROM SF_BRXXB0 where GHID00=C.GHID00) FBBH00,C.YFBMBH,CZY000,(SELECT FYCKBH FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) CKBH00, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=C.CZY000) CZYXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=:1 and C.YFBMBH IN (70) AND (((C.CFZT00='0' or ((C.CFZT00= '1' or (C.CFZT00= '2' and 'Y'='Y' )) and exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000 in ('0','1','2'))) ) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 543 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 544 09:26:14 SQL Execute: ORACLE - SELECT C.GHH000,C.CFLSH0,C.GHID00,C.BRXM00,C.XB0000,C.BRID00,C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,C.ZYTS00,C.ZYDJS0,C.GHKS00 GHKSBM,C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,C.THBZ00,(SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, DECODE(NVL((SELECT PHBZ00 FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'0'),'0','未排',(SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) ) DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT FBBH00 FROM SF_BRXXB0 where GHID00=C.GHID00) FBBH00,C.YFBMBH,CZY000,(SELECT FYCKBH FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) CKBH00, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=C.CZY000) CZYXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (70) AND (((C.CFZT00='0' or ((C.CFZT00= '1' or (C.CFZT00= '2' and 'Y'='Y' )) and exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000 in ('0','1','2'))) ) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 545 09:26:14 SQL Prepare: ORACLE - SELECT C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=:1 and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from yf_cfdl00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' and exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0') ORDER BY C.CFLSH0 546 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 547 09:26:14 SQL Execute: ORACLE - SELECT C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from yf_cfdl00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' and exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0') ORDER BY C.CFLSH0 548 09:26:14 SQL Prepare: ORACLE - select sum(b.ZFJE00) from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=3508979 and c.YFBMBH IN (70) and b.CFLSH0=c.CFLSH0 and c.CFZT00='0' and c.BCCFH0 IS NULL and c.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and c.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and c.BCCFH0 IS NULL 549 09:26:14 SQL Execute: ORACLE - select sum(b.ZFJE00) from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=3508979 and c.YFBMBH IN (70) and b.CFLSH0=c.CFLSH0 and c.CFZT00='0' and c.BCCFH0 IS NULL and c.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and c.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and c.BCCFH0 IS NULL 550 09:26:14 SQL Prepare: ORACLE - select ZYE000 from sf_brzhxx where brid00=:1 551 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 552 09:26:14 SQL Execute: ORACLE - select ZYE000 from sf_brzhxx where brid00=? 553 09:26:14 SQL Prepare: ORACLE - SELECT SQ_SF_BRJFB0_DJH000.NEXTVAL P_DJH00 FROM DUAL 554 09:26:14 SQL Execute: ORACLE - SELECT SQ_SF_BRJFB0_DJH000.NEXTVAL P_DJH00 FROM DUAL 555 09:26:14 SQL Prepare: ORACLE - BEGIN "SP_SF_YFCFJZ" (as_CFLSH0 => :as_CFLSH0,ad_DJH000 => :ad_DJH000,ad_SFCKBH => :ad_SFCKBH,ad_PYCKBH => :ad_PYCKBH,ad_FYCKBH => :ad_FYCKBH,ad_QYYF00 => :ad_QYYF00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 556 09:26:14 SQL Data In: ORACLE - Param = 1, Name = as_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7253538 557 09:26:14 SQL Data In: ORACLE - Param = 2, Name = ad_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35044774.000000 558 09:26:14 SQL Data In: ORACLE - Param = 3, Name = ad_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 559 09:26:14 SQL Data In: ORACLE - Param = 4, Name = ad_PYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 560 09:26:14 SQL Data In: ORACLE - Param = 5, Name = ad_FYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 561 09:26:14 SQL Data In: ORACLE - Param = 6, Name = ad_QYYF00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 562 09:26:14 SQL Data In: ORACLE - Param = 7, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 563 09:26:14 SQL Data In: ORACLE - Param = 8, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 564 09:26:14 SQL Execute: ORACLE - BEGIN "SP_SF_YFCFJZ" (as_CFLSH0 => :as_CFLSH0,ad_DJH000 => :ad_DJH000,ad_SFCKBH => :ad_SFCKBH,ad_PYCKBH => :ad_PYCKBH,ad_FYCKBH => :ad_FYCKBH,ad_QYYF00 => :ad_QYYF00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 565 09:26:14 SQL Prepare: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 566 09:26:14 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 567 09:26:14 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6965702 568 09:26:14 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14186189.000000 569 09:26:14 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 570 09:26:14 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3508979.000000 571 09:26:14 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林宝英 572 09:26:14 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 573 09:26:14 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 444.000000 574 09:26:14 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈韵辉 575 09:26:14 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 70.000000 576 09:26:14 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35044774.000000 577 09:26:14 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 578 09:26:14 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 579 09:26:14 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 580 09:26:14 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 581 09:26:14 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 582 09:26:14 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 583 09:26:14 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 584 09:26:14 SQL Prepare: ORACLE - BEGIN "SP_YF_MZCFFY" (P_YFBMBH => :P_YFBMBH,P_CFLSH0 => :P_CFLSH0,P_CZYBH0 => :P_CZYBH0,P_FHRBH0 => :P_FHRBH0,P_SFXMBH => :P_SFXMBH,P_SFXMMC => :P_SFXMMC,P_CFMXJE_SRWS => :P_CFMXJE_SRWS,P_CFZJE_SRWS => :P_CFZJE_SRWS,P_CFMXJE_CZFS => :P_CFMXJE_CZFS,P_CFZJE_CZFS => :P_CFZJE_CZFS); END; 585 09:26:14 SQL Data In: ORACLE - Param = 1, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 70.000000 586 09:26:14 SQL Data In: ORACLE - Param = 2, Name = P_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7253538 587 09:26:14 SQL Data In: ORACLE - Param = 3, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 365.000000 588 09:26:14 SQL Data In: ORACLE - Param = 4, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 589 09:26:14 SQL Data In: ORACLE - Param = 5, Name = P_SFXMBH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 9999999997 590 09:26:14 SQL Data In: ORACLE - Param = 6, Name = P_SFXMMC, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 591 09:26:14 SQL Data In: ORACLE - Param = 7, Name = P_CFMXJE_SRWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 592 09:26:14 SQL Data In: ORACLE - Param = 8, Name = P_CFZJE_SRWS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 593 09:26:14 SQL Data In: ORACLE - Param = 9, Name = P_CFMXJE_CZFS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 594 09:26:14 SQL Data In: ORACLE - Param = 10, Name = P_CFZJE_CZFS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 595 09:26:14 SQL Execute: ORACLE - BEGIN "SP_YF_MZCFFY" (P_YFBMBH => :P_YFBMBH,P_CFLSH0 => :P_CFLSH0,P_CZYBH0 => :P_CZYBH0,P_FHRBH0 => :P_FHRBH0,P_SFXMBH => :P_SFXMBH,P_SFXMMC => :P_SFXMMC,P_CFMXJE_SRWS => :P_CFMXJE_SRWS,P_CFZJE_SRWS => :P_CFZJE_SRWS,P_CFMXJE_CZFS => :P_CFMXJE_CZFS,P_CFZJE_CZFS => :P_CFZJE_CZFS); END; 596 09:26:14 SQL Prepare: ORACLE - commit 597 09:26:14 SQL Execute: ORACLE - commit 598 09:26:14 SQL Data In: ORACLE - Rows affected = 0 599 09:26:14 SQL Prepare: ORACLE - commit 600 09:26:14 SQL Execute: ORACLE - commit 601 09:26:14 SQL Data In: ORACLE - Rows affected = 0 602 09:26:14 SQL Prepare: ORACLE - SELECT SQ_YF_CFDL00_PHZXH0.NEXTVAL ZXH000 FROM DUAL 603 09:26:14 SQL Execute: ORACLE - SELECT SQ_YF_CFDL00_PHZXH0.NEXTVAL ZXH000 FROM DUAL 604 09:26:14 SQL Prepare: ORACLE - update YF_CFDL00 A SET PHBZ00='4',PHZXH0=1968391,PHRQ00=to_char(sysdate,'YYYYMMDD') WHERE PHBZ00='0' and BRID00=3508979 and EXISTS(SELECT 1 FROM YF_MZCF00 WHERE BRID00=3508979 and CFLSH0=A.CFLSH0 AND SRRQ00=to_char(sysdate,'YYYYMMDD') AND (CFZT00='1' or (CFZT00='2' and 'Y'='Y'))) and A.YFBMBH IN (70) 605 09:26:14 SQL Execute: ORACLE - update YF_CFDL00 A SET PHBZ00='4',PHZXH0=1968391,PHRQ00=to_char(sysdate,'YYYYMMDD') WHERE PHBZ00='0' and BRID00=3508979 and EXISTS(SELECT 1 FROM YF_MZCF00 WHERE BRID00=3508979 and CFLSH0=A.CFLSH0 AND SRRQ00=to_char(sysdate,'YYYYMMDD') AND (CFZT00='1' or (CFZT00='2' and 'Y'='Y'))) and A.YFBMBH IN (70) 606 09:26:14 SQL Data In: ORACLE - Rows affected = 1 607 09:26:14 SQL Prepare: ORACLE - COMMIT WORK 608 09:26:14 SQL Execute: ORACLE - COMMIT WORK 609 09:26:14 SQL Prepare: ORACLE - select distinct YFBMBH,FYCKBH from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=:1 and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'未排' ) ORDER BY C.CFLSH0 ) 610 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 611 09:26:14 SQL Execute: ORACLE - select distinct YFBMBH,FYCKBH from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'未排' ) ORDER BY C.CFLSH0 ) 612 09:26:14 SQL Prepare: ORACLE - select a.* from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=:1 and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'未排' ) ORDER BY C.CFLSH0 ) a where a.YFBMBH=:2 and a.FYCKBH=:3 and exists (select 1 from VW_PY_ZZQHPRINT where CFLSH0=a.CFLSH0) 613 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 614 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 615 09:26:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 616 09:26:14 SQL Execute: ORACLE - select a.* from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (70) AND (((C.CFZT00 = '1' or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'未排' ) ORDER BY C.CFLSH0 ) a where a.YFBMBH=? and a.FYCKBH=? and exists (select 1 from VW_PY_ZZQHPRINT where CFLSH0=a.CFLSH0) 617 09:26:14 SQL Prepare: ORACLE - select a.*,'2006' XH0000 from VW_PY_ZZQHPRINT a where CFLSH0 IN ('7253538') and rownum=1 618 09:26:14 SQL Execute: ORACLE - select a.*,'2006' XH0000 from VW_PY_ZZQHPRINT a where CFLSH0 IN ('7253538') and rownum=1 619 09:26:14 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 620 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 621 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 622 09:26:14 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 623 09:26:14 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 624 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 625 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 626 09:26:14 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 627 09:26:14 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 628 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 629 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 630 09:26:14 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 631 09:26:14 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 632 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 633 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 634 09:26:14 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 635 09:26:14 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 636 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 637 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 638 09:26:14 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 639 09:26:14 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 640 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 641 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 642 09:26:14 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 643 09:26:14 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 644 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 645 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 646 09:26:14 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 647 09:26:14 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 648 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 649 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 650 09:26:14 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 651 09:26:14 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 652 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 653 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 654 09:26:14 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 655 09:26:14 SQL Prepare: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 656 09:26:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 657 09:26:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 658 09:26:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = D 659 09:26:14 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 660 09:26:14 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 661 09:26:15 SQL Prepare: ORACLE - update yf_cfdl00 set QHDDY0=nvl(QHDDY0,0)+1,PHDYCS=nvl(PHDYCS,0)+1 where CFLSH0 IN ('7253538') 662 09:26:15 SQL Execute: ORACLE - update yf_cfdl00 set QHDDY0=nvl(QHDDY0,0)+1,PHDYCS=nvl(PHDYCS,0)+1 where CFLSH0 IN ('7253538') 663 09:26:15 SQL Data In: ORACLE - Rows affected = 1 664 09:26:15 SQL Prepare: ORACLE - Commit 665 09:26:15 SQL Execute: ORACLE - Commit 666 09:26:15 SQL Data In: ORACLE - Rows affected = 0 667 09:26:15 SQL Prepare: ORACLE - select A.YFBMBH,B.BMMC00,COUNT(1) CFSL00 from YF_MZCF00 A,BM_BMBM00 B where A.CFZT00<='1' AND A.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND A.YFBMBH=B.BMBH00 AND A.BRID00=:1 and not exists(select 1 from YF_HZDL00 where CFLSH0=A.CFLSH0 ) AND A.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and A.YFBMBH NOT IN (70) AND A.CFZT00 IN ('0','1') GROUP BY A.YFBMBH,B.BMMC00 668 09:26:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3508979 669 09:26:15 SQL Execute: ORACLE - select A.YFBMBH,B.BMMC00,COUNT(1) CFSL00 from YF_MZCF00 A,BM_BMBM00 B where A.CFZT00<='1' AND A.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') AND A.YFBMBH=B.BMBH00 AND A.BRID00=? and not exists(select 1 from YF_HZDL00 where CFLSH0=A.CFLSH0 ) AND A.SRRQ00>=TO_CHAR(SYSDATE-1/3,'YYYYMMDD') and A.YFBMBH NOT IN (70) AND A.CFZT00 IN ('0','1') GROUP BY A.YFBMBH,B.BMMC00 670 09:26:15 SQL Prepare: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=3508979 and a.brid00=b.brid00 and b.JFLBID=1 671 09:26:15 SQL Execute: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=3508979 and a.brid00=b.brid00 and b.JFLBID=1