1 11:51:46 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='8' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999') 2 11:51:46 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=636 3 11:51:46 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 4 11:51:46 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 5 11:51:46 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 6 11:51:46 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 7 11:51:46 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')) 8 11:51:46 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(901768,636,'PC-20121101UDD','8',nvl('1071660',' '),'192.168.6.98#269:62586@appYS_YSGZZ.exe+门诊医生工作站分系统',474) 9 11:51:46 SQL Data In: ORACLE - Rows affected = 1 10 11:51:46 SQL Execute: ORACLE - Commit 11 11:51:46 SQL Data In: ORACLE - Rows affected = 0 12 11:51:46 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 474 13 11:51:46 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222142' 14 11:51:46 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 15 11:51:46 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.6.98' 16 11:51:46 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 17 11:51:46 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 474 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 18 11:51:46 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222142') 19 11:51:46 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'8'||',')>0 20 11:51:47 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='636' and name00='SYSTEMSKIN' 21 11:51:47 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 22 11:51:47 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='8') and YXQ000>='20131009' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',474,' )>0 ) 23 11:51:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 24 11:51:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 25 11:51:47 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '1' 26 11:51:47 SQL Execute: ORACLE - select PSID00 from BM_PS0000 where PSMC00='皮试' and YXBZ00='1' 27 11:51:47 SQL Execute: ORACLE - select 1 from xt_xtcs00 where NAME00 = 'MZYS_CKPCPD' and value0 = '3' 28 11:51:47 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YS_JCYPCZLXMLB','YS_ZLDCYPYYID') 29 11:51:47 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') 30 11:51:47 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肝功对应的诊断' AND YXBZ00='1' 31 11:51:47 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='肾功对应的诊断' AND YXBZ00='1' 32 11:51:47 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 33 11:51:47 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 34 11:51:47 SQL Execute: ORACLE - select MC0000,BZ0000 from BM_TYZD00 where ZDMC00='居民健康档案提示的相关参数' AND YXBZ00='1' order by XSXH00 35 11:51:47 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 = 636 36 11:51:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 37 11:51:47 SQL Execute: ORACLE - select LBBH00,GHDJ00,LBMC00 from bm_ghlbb0 where lbbh00=(select MRGHLB from bm_ygbm00 where YGBH00=?) 38 11:51:47 SQL Execute: ORACLE - select LBBH00 from bm_ghlbb0 where ghdj00=2 and lbmc00 like '%急%' and SFYX00='Y' 39 11:51:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 40 11:51:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 41 11:51:47 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' 42 11:51:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 43 11:51:47 SQL Execute: ORACLE - select lbbh00 from BM_KSGHDY where bmbh00=? 44 11:51:47 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 45 11:51:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='8' and (( 636= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=636 and XTDM00='8'))) 46 11:51:47 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 47 11:51:47 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 ((636= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=636 and XTDM00='0 '))) 48 11:51:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 49 11:51:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 636= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=636 and XTDM00='+ '))) 50 11:51:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 51 11:51:48 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(+) 52 11:51:48 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '煎%' and rownum=1 53 11:51:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 54 11:51:48 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 55 11:51:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 56 11:51:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 57 11:51:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 58 11:51:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 11:51:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 60 11:51:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 61 11:51:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 62 11:51:48 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 63 11:51:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 64 11:51:48 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 65 11:51:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 66 11:51:48 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 67 11:51:48 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 68 11:51:48 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 69 11:51:48 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 70 11:51:48 SQL Execute: ORACLE - select ZDMSMC,ZDMSH0 from BM_ZDMS00 where 1=1 order by ZDMSH0 71 11:51:49 SQL Execute: ORACLE - select NBBH00,MC0000,BZ0000 from BM_TYZD00 where ZDMC00='医生预约' and YXBZ00='1' and BZ0000 is not null order by XSXH00 72 11:51:49 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 73 11:51:49 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 74 11:51:49 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 75 11:51:49 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 76 11:51:49 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 77 11:51:49 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc,PX0000 78 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 79 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 80 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 81 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 82 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 83 11:51:49 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 84 11:51:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 85 11:51:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 86 11:51:49 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 87 11:51:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 88 11:51:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474 89 11:51:49 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 90 11:51:49 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 636 91 11:51:49 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '检验科' 92 11:51:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 636 93 11:51:49 SQL Execute: ORACLE - select GHHZCK from vw_sf_ysghhb where GHYSBH=? AND GHMZSJ >= to_char(sysdate-1, 'YYYYMMDD' ) and TZBZ00 = '0' and ((((GHXHS0-YYXHS0)>(GHYGHS-GHYYHS)) and (SFZJGH='0')) OR (SFZJGH='1')) and ( (GHJSSJ >= GHQSSJ and GHJSSJ >= to_char(sysdate,'HH24:MI:SS') and GHQSSJ <= to_char(sysdate,'HH24:MI:SS') and GHMZSJ = to_char(sysdate,'YYYYMMDD') ) or (GHJSSJ < GHQSSJ and ((GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHQSSJ <= to_char(sysdate,'HH24:MI:SS' ) ) or (GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHJSSJ >= to_char(sysdate,'HH24:MI:SS' ) ) ) ) ) 94 11:51:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 95 11:51:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 96 11:51:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 97 11:51:49 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 98 11:51:49 SQL Execute: ORACLE - select MZCFLB from BM_YGBM00 where YGBH00=636