/* */ 20201105 14:17:24 select * from zy_Brxxb0 where zyid00='0' /* */ 20201105 14:17:24 select * from zy_Brxxb0 where zyid00='0' /* */ 20201105 14:17:24 select count(1) from (select a.zxrq00 from BQ_YPYZ00 a where a.yfid00 = '005' and a.zyid00 = '0' and To_Date(a.zxrq00, 'yyyymmdd') <=(SELECT To_Date(max(t.zxrq00), 'yyyymmdd') FROM BQ_YPYZ00 t where t.yfid00 = '005' and t.zyid00 ='0' group by t.zyid00) and To_Date(a.zxrq00, 'yyyymmdd') >= (SELECT To_Date(max(t.zxrq00), 'yyyymmdd') - 7 FROM BQ_YPYZ00 t where t.yfid00 = '005' and t.zyid00 = '0' group by t.zyid00) group by a.zxrq00 order by a.zxrq00) /* */ 20201105 14:17:24 select BJYZBL　 from ZS_BJYZBL where YBZXLB='0' /* */ 20201105 14:17:24 select * from BM_TYZD00 where ZDMC00='住院合理用药' AND YXBZ00='1' and bz0000 like '%颜色%' order by xsxh00 /* */ 20201105 14:17:24 parameters :zyid00=0 /* */ 20201105 14:17:24 SELECT qyyshs ,a.* FROM VW_ZS_YZLL00_ZYDZBL a where 1=1 and zyid00=:zyid00 order by Clbz00 desc, CZPC00,QYRQ00,QYSJ00 ,PXSJ00,YZID00,YZMXID /* */ 20201105 14:17:24 select * from BM_TYZD00 where ZDMC00='住院合理用药' AND YXBZ00='1' and bz0000 like '%颜色%' order by xsxh00 /* */ 20201105 14:17:24 parameters :zyid00=0 /* */ 20201105 14:17:24 parameters :ZYID00=0 /* */ 20201105 14:17:24 SELECT brid00,zyid00,jsxh00,yexm00,yecsrq,yecssj,yc0000,cc0000,fmfs00,ts0000,hypl00,hyzs00,syts00,yeqk00,apgar0,yexb00,yetz00,yesg00,jsr000 FROM BQ_JSXX00 WHERE zyid00= :ZYID00 /* */ 20201105 14:17:24 SELECT lb0000,lbbh00,lbmc00 FROM VW_BQ_YZLB00_ZYDZBL /* */ 20201105 14:17:24 select * from XT_YHCS00 where name00 in('ZS_YZBJYSNEWIN','ZS_YZBJYSCHECK','ZS_YZBJYSEXTRA','ZS_YZBJYSTODAYEXCUTE','ZS_YZBJYSSTOP','ZS_YZBJYSREVOC','ZS_YZBJYSSUSPEND','ZS_YZBJYSNEWLOCAL') and ygbh00 = 4960 /* */ 20201105 14:17:24 select * from ZY_BRZHXX where zyid00='6042475' /* */ 20201105 14:17:24 select * from ZY_BRZHXX where zyid00='6042475' /* */ 20201105 14:17:24 SELECT t.KSSJB0 FROM BM_YGBM00 t where t.ygbh00='4960' /* */ 20201105 14:17:24 parameters :NAME00=ZS_FYYZSFSRZDHBQZY /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :NAME00=BQ_YZLL_SJKZ /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :NAME00=ZS_CFJBKSSJB /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :NAME00=ZS_YZZJQRCDZ /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :NAME00=ZS_BRQFSFYXLYZ /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :NAME00=ZS_YZYXBCYPBM /* */ 20201105 14:17:24 SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00=:NAME00 /* */ 20201105 14:17:24 parameters :SLBMBH=0 /* */ 20201105 14:17:24 SELECT slbmbh,yplbbh,yfbmbh,mrbz00,bz0000 FROM XT_YPFWFX WHERE SLBMBH=:SLBMBH ORDER BY YPLBBH /* */ 20201105 14:17:24 parameters :ZYID00=0 /* */ 20201105 14:17:24 SELECT zyid00,brid00,mrn000,zyh000,ybzyh0,xm0000,xb0000,csrq00,fbbh00,lbbh00,ryrq00,rysj00,ryczy0,czyxm0,ryzd00,rysqk0,rylb00,rybq00,rzks00,rycwh0,dqbq00,dqks00,rcyfh0,cyrq00,cysj00,cyczy0,cyygxm,zzys00,zzysxm,zrys00,zrysxm,sxys00,sxysxm,hljbid,brrycs,brzt00,brhyzk,brzy00,brmz00,brjtdz,bryb00,tydwmc,brnl00,brgj00,ybzxlb,ybbrlb,brlbjc,kyje00,fbmc00,bjje00,ykzye0,sjye00 FROM VW_ZS_WTJBR0_ZYDZBL WHERE zyid00=:ZYID00 /* */ 20201105 14:17:24 select BZSFJE,BZNZFY,BZNKYE,BZNZFY,BZWKYE,YJQK00,SF_ZY_GETDBZWKYYE(0) BZWYE0 from VW_ZY_DBZCZB where TCRQ00 is null and rownum<=1 and zyid00= 0 /* */ 20201105 14:17:24 select nvl(sum(jfje00),0) jfje00 from ZY_BRJFB0 where JFLBID = 2 and jzdh00 = 0 and ZYID00=0 /* */ 20201105 14:17:24 select YXQFJE from ZY_BRZHXX where BRID00=0 /* */ 20201105 14:17:24 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b where a.djh000=b.djh000 and a.SFLB00<>'3' and b.ZYID00=0 /* */ 20201105 14:17:24 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b,bm_yd0000 y where a.djh000=b.djh000 and a.xmbh00=y.ypnm00 and y.lbbh00='2' and b.ZYID00=0 /* */ 20201105 14:17:24 select nvl(sum(a.HJJE00),0) hjje00 from zy_fymx00 a , ZY_BRFY00 b where a.djh000=b.djh000 and a.sflb00='3' and b.ZYID00=0 /* */ 20201105 14:17:24 select nvl(sum(HJJE00),0) ZJE000 from ZY_BRFY00 where ZYID00=0 /* */ 20201105 14:17:24 SELECT t.ypmc00,t.ypnm00 FROM YJ_BRGMJL T WHERE t.jgms00 like '%+%' and t.brid00='0' /* */ 20201105 14:17:24 select null ygbh00,null zwxm00,null zwxm00 from dual union all select t.ygbh00,t.zwxm00,t.ygxz00 from zy_brxxb0 b, bm_ygbm00 t where b.dqbq00 = t.bmbh00 and b.zyh000='' and t.ygxz00='2' /* */ 20201105 14:17:24 select null ygbh00,null zwxm00,null zwxm00 from dual union all select t.ygbh00,t.zwxm00,t.ygxz00 from zy_brxxb0 b, bm_ygbm00 t where b.dqks00=t.bmbh00 and b.zyh000='' and t.ygxz00='1' /* */ 20201105 14:17:24 select A.JTDZ00,A.GZDW00,A.BAH000,a.zyh000,BRXM00,XX0000,SFZH00,RH0000,BRCSRQ,HYZK00,ZY0000,MZ0000,GJ0000,A.SWRQ00,A.SWSJ00,A.BRXB00,A.LSH000,A.YBID00,RYKB00, sf_bq_csrqtonl(BRCSRQ) BRNL00,RYRQ00,RYSJ00,CYRQ00,CYKBMC,JTDZ00,XZZDH0,YBID00 ,CYSJ00,YBKH00,YBMC00,YBZYH0,ZZYSMC,SXYS00,CYKB00,RYKB00 from BA_BRZYXX A where a.lsh000=6042475 /* */ 20201105 14:17:17 SELECT distinct A.WSID00 WSID00,A.ZYID00 ZYID00,A.BLXMBH BLXMBH,A.WSMC00 WSMC00,A.MBBH00 MBBH00,E.MBMC00,A.CJYSBH CJYSBH,A.CJYSXM CJYSXM,A.CJRQ00 CJRQ00,A.CJSJ00 CJSJ00,A.SFXYSH SFXYSH,A.YGBZ00 YGBZ00,A.WSZT00 WSZT00,A.TJRQ00 TJRQ00,A.TJSJ00 TJSJ00,A.ZXRDJ0 ZXRDJ0,A.SHRDJ0 SHRDJ0,A.XGZBH0 XGZBH0,A.XGZXM0 XGZXM0,A.XGZDJ0 XGZDJ0,A.XGRQ00 XGRQ00,A.XGSJ00 XGSJ00,A.XGZBH1 XGZBH1,A.XGZXM1 XGZXM1,A.XGZDJ1 XGZDJ1,A.XGRQ01 XGRQ01,A.XGSJ01 XGSJ01,A.DYRBH0 DYRBH0,A.DYRXM0 DYRXM0,A.DYRQ00 DYRQ00,A.DYSJ00 DYSJ00,A.ZHZBH0 ZHZBH0,A.ZHZXM0 ZHZXM0,A.ZHZDJ0 ZHZDJ0,A.ZHRQ00 ZHRQ00,A.ZHSJ00 ZHSJ00,null XMLNR0,null CDA000,A.DQDKYS DQDKYS, A.WJMC00 WJMC00,A.PXRQ00 PXRQ00,A.PXSJ00 PXSJ00,A.JMHSJ0 JMHSJ0,A.GZRQ00 GZRQ00,A.GZSJ00 GZSJ00,C.RYRQ00 RYRQ00,A.WSHBID WSHBID,A.WSQYMC WSQYMC,A.SFHBWS SFHBWS,D.HBWJMC HBWJMC,D.HBWSMC HBWSMC,f.flid00 FLID00 FROM ZS_BLWS00 A,ZS_BLXX01 B,ZY_BRXXB0 C, ZS_WSHBXX D,ZS_BLMB01 E,ZS_BLZCXM F,ZS_BLZCFL G where A.ZYID00 = B.ZYID00 and a.wszt00<>'3' and A.zyid00 = C.zyid00 and A.WSHBID = D.WSHBID(+) and A.MBBH00=E.MBID00(+) and a.blxmbh=f.blxz00(+) and f.flid00=g.flid00(+) and B.DZBLH0 = '6042475' ORDER BY A.PXRQ00, substr(A.PXSJ00, 1, 5), A.CJSJ00 /* */ 20201105 14:17:17 SELECT distinct A.WSID00 WSID00,A.ZYID00 ZYID00,A.BLXMBH BLXMBH,A.WSMC00 WSMC00,A.MBBH00 MBBH00,E.MBMC00,A.CJYSBH CJYSBH,A.CJYSXM CJYSXM,A.CJRQ00 CJRQ00,A.CJSJ00 CJSJ00,A.SFXYSH SFXYSH,A.YGBZ00 YGBZ00,A.WSZT00 WSZT00,A.TJRQ00 TJRQ00,A.TJSJ00 TJSJ00,A.ZXRDJ0 ZXRDJ0,A.SHRDJ0 SHRDJ0,A.XGZBH0 XGZBH0,A.XGZXM0 XGZXM0,A.XGZDJ0 XGZDJ0,A.XGRQ00 XGRQ00,A.XGSJ00 XGSJ00,A.XGZBH1 XGZBH1,A.XGZXM1 XGZXM1,A.XGZDJ1 XGZDJ1,A.XGRQ01 XGRQ01,A.XGSJ01 XGSJ01,A.DYRBH0 DYRBH0,A.DYRXM0 DYRXM0,A.DYRQ00 DYRQ00,A.DYSJ00 DYSJ00,A.ZHZBH0 ZHZBH0,A.ZHZXM0 ZHZXM0,A.ZHZDJ0 ZHZDJ0,A.ZHRQ00 ZHRQ00,A.ZHSJ00 ZHSJ00,null XMLNR0,null CDA000,A.DQDKYS DQDKYS, A.WJMC00 WJMC00,A.PXRQ00 PXRQ00,A.PXSJ00 PXSJ00,A.JMHSJ0 JMHSJ0,A.GZRQ00 GZRQ00,A.GZSJ00 GZSJ00,C.RYRQ00 RYRQ00,A.WSHBID WSHBID,A.WSQYMC WSQYMC,A.SFHBWS SFHBWS,D.HBWJMC HBWJMC,D.HBWSMC HBWSMC,f.flid00 FLID00 FROM ZS_BLWS00 A,ZS_BLXX01 B,ZY_BRXXB0 C, ZS_WSHBXX D,ZS_BLMB01 E,ZS_BLZCXM F,ZS_BLZCFL G where A.ZYID00 = B.ZYID00 and a.wszt00<>'3' and A.zyid00 = C.zyid00 and A.WSHBID = D.WSHBID(+) and A.MBBH00=E.MBID00(+) and a.blxmbh=f.blxz00(+) and f.flid00=g.flid00(+) and B.DZBLH0 = '6042475' ORDER BY A.PXRQ00, substr(A.PXSJ00, 1, 5), A.CJSJ00 /* */ 20201105 14:17:17 parameters :ZYID00=6042475 /* */ 20201105 14:17:24 SELECT qyyshs ,a.* FROM VW_ZS_YZLL00_ZYDZBL a where 1=1 and zyid00=:zyid00 order by Clbz00 desc, CZPC00,QYRQ00,QYSJ00 ,PXSJ00,YZID00,YZMXID /* */