1 09:47:31 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1579,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1579 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 2 09:47:34 SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=57 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 3 09:47:34 SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=57 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 4 09:47:35 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' and B.CZBZ00<>'2' ORDER BY B.BH0000 5 09:47:36 SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=45 AND BQBMBH=57 6 09:47:36 SQL Data In: ORACLE - Rows affected = 1 7 09:47:36 SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1' WHERE YFBMBH=45 AND BQBMBH=57 AND QLZT00 IN ('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 8 09:47:36 SQL Data In: ORACLE - Rows affected = 2 9 09:47:36 SQL Execute: ORACLE - COMMIT 10 09:47:36 SQL Data In: ORACLE - Rows affected = 0 11 09:47:36 SQL Execute: ORACLE - UPDATE YF_YZYPSQ a SET a.qlzt00='3' WHERE a.YFBMBH=45 AND a.BQBMBH=57 AND a.QLZT00 IN ('0') AND a.CXBZ00='Z' and exists ( select 1 from zy_brxxb0 where a.zyid00=zyid00 and ((nvl(cyrq00,'20991231')<>'20991231') and (brzt00 in ('4','5')))) and not exists(select 1 from bq_ypyzmx where a.yzmxid=yzmxid and trim(yzcllb)='出院带药' ) 12 09:47:36 SQL Data In: ORACLE - Rows affected = 0 13 09:47:36 SQL Execute: ORACLE - COMMIT 14 09:47:36 SQL Data In: ORACLE - Rows affected = 0 15 09:47:36 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1579) and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' order by YGBH00 16 09:47:36 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=1579 and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' and DBGRIN='DBGridEh1' order by LS0000 17 09:47:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 18 09:47:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 19 09:47:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 20 09:47:36 SQL Execute: ORACLE - SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 FROM YF_YZYPSQ WHERE BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00='1' AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') like ? ORDER BY CH0000 21 09:47:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1710696.000000 22 09:47:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 23 09:47:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 24 09:47:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 25 09:47:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 26 09:47:36 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' AND nvl(a.SHBZ00,'0') LIKE ? ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 27 09:47:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1710696.000000 28 09:47:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 29 09:47:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 30 09:47:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 31 09:47:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 32 09:47:36 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' AND nvl(a.SHBZ00,'0') LIKE ? ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 33 09:47:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1710696.000000 34 09:47:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 35 09:47:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 36 09:47:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 37 09:47:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 38 09:47:36 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' AND nvl(a.SHBZ00,'0') LIKE ? ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 39 09:47:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1710696.000000 40 09:47:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 41 09:47:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 42 09:47:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 43 09:47:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 44 09:47:36 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' AND nvl(a.SHBZ00,'0') LIKE ? ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 45 09:47:40 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 46 09:47:41 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1579,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1579 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 47 09:47:43 SQL Execute: ORACLE - Select BMBH00,XKH000 from VW_XT_YHBMQX where UPPER(XKH000)='2300' and BMBH00='57' 48 09:47:43 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00<>'2' 49 09:47:43 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 50 09:47:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00 in ('1') 51 09:47:43 SQL Execute: ORACLE - Commit 52 09:47:43 SQL Data In: ORACLE - Rows affected = 0 53 09:47:43 SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 54 09:47:43 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 55 09:47:43 SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 56 09:47:43 SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 09:47:43 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 09:47:43 SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 59 09:47:43 SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1579.000000 60 09:47:43 SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1662.000000 61 09:47:43 SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 62 09:47:43 SQL Data In: ORACLE - Param = 10, Name = P_BYFHR0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 63 09:47:43 SQL Data In: ORACLE - Param = 11, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 64 09:47:43 SQL Data In: ORACLE - Param = 12, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 65 09:47:43 SQL Data In: ORACLE - Param = 13, Name = P_SHBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 66 09:47:43 SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_SHBZ00 => :P_SHBZ00); END; 67 09:50:49 Log started for: SQL Navigator for Oracle 68 09:55:18 Log started for: 后台维护系统 69 09:59:40 Log started for: SQL Navigator for Oracle