1 21:45:55 SQL Execute: ORACLE - SELECT BMBH00,BMMC00 FROM BM_BMBM00 WHERE BMXZ00 in ('2','3') And FLAG00='1' 2 21:45:55 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 3 21:45:55 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='2' 4 21:45:55 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='2' 5 21:45:55 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=398) and (BMBH00=0 or BMBH00=22) and DLXTMC='药房管理系统' and CTMC00='frmYF_YPKCCXPC' order by YGBH00 6 21:45:55 SQL Execute: ORACLE - select * from BM_YPLB00 7 21:45:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 21:45:55 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 9 21:45:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 10 21:45:55 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 11 21:45:55 SQL Execute: ORACLE - select A.*, LSJ000 LSJ000_KCDW,YKKCSL YKKCSL_KCDW,SJKCSL SJKCSL_KCDW,GJJ000 GJJ000_KCDW ,SF_YF_GETPCKCJE(a.YPNM00,a.YFBMBH) KCJE01,SF_YF_GETPCGJJE(a.YPNM00,a.YFBMBH) C_GJJE1 from VW_YF_YPKCXX A where LBBH00 like '2%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=22 and A.TZRQ00 IS NULL order by YPBM00 12 21:45:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 13 21:45:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 14 21:45:56 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0) 15 21:45:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 16 21:45:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 17 21:45:56 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0) 18 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 19 21:45:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 20 21:45:57 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0) 21 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 22 21:45:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 23 21:45:57 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0) 24 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 25 21:45:57 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 26 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 27 21:45:57 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 28 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 29 21:45:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 30 21:45:57 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0) 31 21:45:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 32 21:45:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 33 21:45:57 SQL Execute: ORACLE - SELECT A.YFBMBH,A.YPNM00,A.SCPH00,A.YPSXRQ,decode(A.SCCJBH,'',(select trim(sccjzw) from BM_YPSCCJ where sccjbh=B.sccjbh),(select trim(sccjzw) from BM_YPSCCJ where sccjbh=A.sccjbh)) SCCJZW, A.LSDJ00 LSDJ00,ROUND(A.SJKCSL/B.K2J000,3) SJKCSL,A.GJDJ00 ,substr(SF_YF_GETYPGHDW(a.YPNM00,a.YFBMBH,a.GJDJ00,a.LSDJ00,a.SCPH00,a.SCCJBH),1,100) GHDWMC FROM YF_PCKCMX A,BM_YD0000 B WHERE A.YFBMBH=? and A.YPNM00=? AND A.YPNM00=B.YPNM00 ORDER BY TO_NUMBER(KCLSH0)