255     18:43:44  SQL Execute: ORACLE - SELECT  
 decode(YPDLBH,'0','西药','1','成药','2','草药')ypdlbh,
 DECODE(YPDLBH,'0',NULL,'1',NULL,ZYTS00)"ZYTS00",
 YPMC00,YPGG00,QLDW00,JLDW00,ZHL000,LSDJ00,CSL000,
 YPZSL0,YZID00,YZMXID,TQDJH0,YPQLPC,CXPCID,BMMC00,CXBZ00,H.ZWXM00,
 TO_DATE(SRRQ00||SRSJ00,'YYYYMMDDHH24:MI:SS')CZRQSJ,
 DECODE(QLZT00,'0','申请','1','退费','2','退药','4','退药','5','退药','6','退费') QLZT00,
 S.BRXM00,S.ZYH000,S.CH0000,S.ZYID00
 FROM  YF_YZYPSQ S,BM_BMBM00 B,BM_YGBM00 H
 WHERE  S.FYBZ00='0'   --QLZT00 IN ('1','0','2','4','5','6') AND
 AND CXBZ00 IN ('-') AND S.YFBMBH=B.BMBH00(+)
 AND S.CZY000=H.YGBH00
 AND ( (QLZT00 IN ('0','1','5','6')) or (QLZT00 IN ('2','4') and S.PSPC00 is null) )

 AND ZYID00 in (SELECT ZYID00 FROM ZY_BRXXB0 WHERE ZYH000='682670') AND SRRQ00 BETWEEN '20190415' AND '20190415' AND BQBMBH+0=2047 ORDER BY ZYH000,SRRQ00

256     18:43:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
257     18:43:44  SQL Execute: ORACLE - SELECT
 decode(YPDLBH,'0','西药','1','成药','2','草药')ypdlbh,
 DECODE(YPDLBH,'0',NULL,'1',NULL,ZYTS00)"ZYTS00",
 YPMC00,YPGG00,QLDW00,JLDW00,ZHL000,LSDJ00,CSL000,
 YPZSL0,YZID00,YZMXID,YPQLPC,BMMC00,CXBZ00,H.ZWXM00,TQDJH0,
 TO_DATE(SRRQ00||SRSJ00,'YYYYMMDDHH24:MI:SS')CZRQSJ,
 DECODE(QLZT00,'0','申请','1','收费','2','发药','4','发药') QLZT00,
 S.ZYID00, DECODE(S.CLBZ00,'0','长','1','临') CLBZ00,S.PSPC00
 FROM  YF_YZYPSQ S,BM_BMBM00 B,BM_YGBM00 H
 WHERE YPQLPC=? --AND QLZT00 IN ('1','0','2','4') 
 AND S.FYBZ00='0' 
 AND CXBZ00 IN ('+','Z') AND S.YFBMBH=B.BMBH00(+)
 AND S.CZY000=H.YGBH00
 AND ( (QLZT00 IN ('0','1')) or (QLZT00 IN ('2','4') and S.PSPC00 is null) )

258     18:44:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
259     18:44:01  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24506888.000000
260     18:44:01  SQL Execute: ORACLE - update YF_YZYPSQ
set BCCXSL = ?
Where YPQLPC = ?

261     18:44:01  SQL Data In: ORACLE - Rows affected = 1
262     18:44:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
263     18:44:01  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24506889.000000
264     18:44:01  SQL Execute: ORACLE - update YF_YZYPSQ
set BCCXSL = ?
Where YPQLPC = ?

265     18:44:01  SQL Data In: ORACLE - Rows affected = 1
266     18:44:01  SQL Execute: ORACLE - COMMIT WORK
267     18:44:01  SQL Data In: ORACLE - Param = 1, Name = PTQDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1010625085.000000
268     18:44:01  SQL Data In: ORACLE - Param = 2, Name = PYZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
269     18:44:01  SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
270     18:44:01  SQL Data In: ORACLE - Param = 4, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
271     18:44:01  SQL Data In: ORACLE - Param = 5, Name = PYPQLPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24506889.000000
272     18:44:01  SQL Data In: ORACLE - Param = 6, Name = PSFBFTY, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
273     18:44:01  SQL Data In: ORACLE - Param = 7, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
274     18:44:01  SQL Execute: ORACLE - BEGIN "SP_BQ_YZYPTY" (PTQDJH0 => :PTQDJH0,PYZID00 => :PYZID00,PCZY000 => :PCZY000,PZYID00 => :PZYID00,PYPQLPC => :PYPQLPC,PSFBFTY => :PSFBFTY,PYFBMBH => :PYFBMBH); END;
275     18:44:01  SQL Execute: ORACLE - SELECT DISTINCT 
    TQDJH0, ZYH000,ZYID00,CH0000,BRXM00,
    TO_CHAR(TO_DATE(SRRQ00||SRSJ00,'YYYYMMDD HH24:MI:SS'),'yyyy.mm.dd hh24:mi') "SQRQSJ",
    Y.ZWXM00 "CZYXM0",B.BMMC00"DQKSMC"
    FROM YF_YZYPSQ S,BM_BMBM00 B,BM_YGBM00 Y 
    WHERE  S.CZY000=Y.YGBH00(+) AND S.DQKS00=B.BMBH00(+)
    AND CXBZ00 IN ('Z','+') AND S.FYBZ00='0'
    AND ( (QLZT00 IN ('0','1','3')) or (QLZT00 IN ('2','4') and S.PSPC00 is null) )

 AND ZYID00 in (SELECT ZYID00 FROM ZY_BRXXB0 WHERE ZYH000='682670') AND SRRQ00 BETWEEN '20190415' AND '20190415' AND BQBMBH+0=2047 ORDER BY ZYH000,SQRQSJ

276     18:44:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1010625085.000000
277     18:44:01  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 653530.000000
278     18:44:01  SQL Execute: ORACLE - SELECT
 TQDJH0,YPDLBH,DECODE(YPDLBH,'0',NULL,'1',NULL,ZYTS00)"ZYTS00",
 YPMC00,YPGG00,QLDW00,JLDW00,ZHL000,LSDJ00,CSL000,BCCXSL,ZCXSL0,
 YPZSL0,YZID00,YZMXID,YPQLPC,BMMC00,CXBZ00,
 DECODE(QLZT00,'0','提取','1','收费','2','发药','4',decode(CXBZ00,'+',DECODE(ZCXSL0,0,'申请退药','已退药'),'发药'),'3','作废') QLZT00,
 DECODE(S.CLBZ00,'0','长','1','临') CLBZ00,S.YFBMBH,S.PSPC00
 FROM YF_YZYPSQ S,BM_BMBM00 B WHERE
 TQDJH0=? AND ZYID00=? --AND  QLZT00 IN ('1','0','2','4','3')
 AND S.FYBZ00='0' 
 AND CXBZ00 IN ('Z','+') AND S.YFBMBH=B.BMBH00(+)
 AND ( (QLZT00 IN ('0','1','3')) or (QLZT00 IN ('2','4') and S.PSPC00 is null) )
 ORDER BY YZID00