1 12:31:00 Log started for: 药房管理系统 2 12:31:10 SQL Execute: ORACLE - SELECT X.*,(select ypmlbz from bm_yd0000 where ypnm00=X.ypnm00) ypmlbz FROM YK_YPRKMX X WHERE X.RKDH00='' 3 12:31:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 4 12:31:12 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,YKBMBH,SJKCSL,YKYPKC,SPM000,PFJ000,YPMLBZ,PZWH00 from VW_YF_YPSLSRTS where (PYSM00 Like ?) and( YKBMBH=30 and YFBMBH=22 ) Order By PYSM00) where Rownum<=10 5 12:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 6 12:31:16 SQL Execute: ORACLE - Select * from (select YPNM00,YPMC00,SCPH00,LSDJ00,YKSL00,SJSL00,YPSXRQ,GJDJ00 from VW_YF_PCKCMX where (SCPH00 Like ?) and( YPNM00=3 and YFBMBH=22 ) Order By SCPH00) where Rownum<=10 7 12:31:23 SQL Execute: ORACLE - delete from YF_YPCKMX_TEMP 8 12:31:23 SQL Data In: ORACLE - Rows affected = 1 9 12:31:23 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=22 10 12:31:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 11 12:31:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 454 12 12:31:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 13 12:31:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 14 12:31:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 15 12:31:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 17.4 16 12:31:23 SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00) VALUES(?,?,?,?,?,?) 17 12:31:23 SQL Data In: ORACLE - Rows affected = 1 18 12:31:23 SQL Execute: ORACLE - commit 19 12:31:23 SQL Data In: ORACLE - Rows affected = 0 20 12:31:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 21 12:31:26 SQL Execute: ORACLE - Select * from (select YPNM00,YPMC00,SCPH00,LSDJ00,YKSL00,SJSL00,YPSXRQ,GJDJ00 from VW_YF_PCKCMX where (SCPH00 Like ?) and( YPNM00=3 and YFBMBH=22 ) Order By SCPH00) where Rownum<=10 22 12:31:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 23 12:31:28 SQL Execute: ORACLE - Select * from (select YPNM00,YPMC00,SCPH00,LSDJ00,YKSL00,SJSL00,YPSXRQ,GJDJ00 from VW_YF_PCKCMX where (SCPH00 Like ?) and( YPNM00=3 and YFBMBH=22 ) Order By SCPH00) where Rownum<=10 24 12:31:34 SQL Execute: ORACLE - delete from YF_YPCKMX_TEMP 25 12:31:34 SQL Data In: ORACLE - Rows affected = 1 26 12:31:34 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=22 27 12:31:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 28 12:31:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 21.75 29 12:31:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 30 12:31:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 31 12:31:34 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1111 32 12:31:34 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 17.4 33 12:31:34 SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00) VALUES(?,?,?,?,?,?) 34 12:31:34 SQL Data In: ORACLE - Rows affected = 1 35 12:31:34 SQL Execute: ORACLE - commit 36 12:31:34 SQL Data In: ORACLE - Rows affected = 0 37 12:31:39 SQL Execute: ORACLE - delete from YF_YPCKMX_TEMP 38 12:31:39 SQL Data In: ORACLE - Rows affected = 1 39 12:31:39 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=22 40 12:31:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 41 12:31:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 21.75 42 12:31:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 43 12:31:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 44 12:31:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1111 45 12:31:39 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 17.4 46 12:31:39 SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00) VALUES(?,?,?,?,?,?) 47 12:31:39 SQL Data In: ORACLE - Rows affected = 1 48 12:31:39 SQL Execute: ORACLE - commit 49 12:31:39 SQL Data In: ORACLE - Rows affected = 0 50 12:31:39 SQL Execute: ORACLE - SELECT SUM(A.CKSL00*A.ZHL000) RKSL00,round(A.LSDJ00/A.ZHL000,20) LSDJ00 ,round(A.GJDJ00/A.ZHL000,20) GJDJ00 FROM YF_YPCKMX_TEMP A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPNM00=3 AND A.SCPH00='1111' AND ROUND(A.LSDJ00/A.ZHL000,2)=ROUND(0.02175,2) AND ROUND(A.GJDJ00/A.ZHL000,2)=ROUND(0.0174,2) GROUP BY A.YPNM00,A.SCPH00,round(A.LSDJ00/A.ZHL000,20),round(A.GJDJ00/A.ZHL000,20) 51 12:31:39 SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000 WHERE YPNM00=3 52 12:31:39 SQL Execute: ORACLE - SELECT ROUND(sum(NVL(SJKCSL,0))/1,6)-1000 SJKCSL,(1000-ROUND(sum(NVL(SJKCSL,0))/1,6))/1000 jdKCSL FROM YF_PCKCMX WHERE YFBMBH=22 AND YPNM00=3 AND SCPH00='1111' AND Round(LSDJ00,2)=21.75 AND Round(GJDJ00,2)=17.4 53 12:31:39 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 12:31:39 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = YKRKDH 55 12:31:39 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 56 12:31:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 014523 57 12:31:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 58 12:31:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 59 12:31:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 60 12:31:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 61 12:31:39 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 62 12:31:39 SQL Execute: ORACLE - INSERT INTO YK_YPRKD0 (RKDH00,YKBMBH,CZYBH0,GHDWNM,RKLXBH,ZDFCF0,JHRQ00,JHSJ00) VALUES(?,?,?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 63 12:31:39 SQL Data In: ORACLE - Rows affected = 1 64 12:31:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 014523 65 12:31:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 66 12:31:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 67 12:31:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 68 12:31:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 艾绒 69 12:31:39 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 1000g 70 12:31:39 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = kg 71 12:31:39 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000 72 12:31:39 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 73 12:31:39 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.400000 74 12:31:39 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 75 12:31:39 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.750000 76 12:31:39 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.400000 77 12:31:39 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.400000 78 12:31:39 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 79 12:31:39 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1111 80 12:31:39 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150606 81 12:31:39 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 454.000000 82 12:31:39 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 83 12:31:39 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 84 12:31:39 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 85 12:31:39 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 86 12:31:39 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 87 12:31:39 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 88 12:31:39 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 89 12:31:39 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 90 12:31:39 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 12:31:39 SQL Execute: ORACLE - insert into YK_YPRKMX (YPRKPC, RKDH00, FPH000, FPFLH0, YPNM00, YPMC00, YPGG00, RKDW00, ZHL000, RKSL00, FPGJDJ, KL0000, LSDJ00, PFDJ00, GJJE00, PCKCSL, SCPH00, YPSXRQ, XXLSDJ, YPTHPC, CXRKPC, SCCJBH, SCCJZW, CFWZBH, CFWZMC, BZ0000, SFZBYP,PZWH00) values (SQ_YK_YPRKMX_YPRKPC.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?) 92 12:31:39 SQL Data In: ORACLE - Rows affected = 1 93 12:31:39 SQL Execute: ORACLE - COMMIT WORK 94 12:31:40 SQL Execute: ORACLE - SELECT R.YKBMBH,R.RKLXBH,R.JHRQ00 FROM YK_YPRKD0 R WHERE R.GHDWNM=22 AND R.RKZT00='0' AND R.RKDH00='014523' AND R.RKLXBH='06' 95 12:31:40 SQL Execute: ORACLE - SELECT X.*,(select ypmlbz from bm_yd0000 where ypnm00=X.ypnm00) ypmlbz FROM YK_YPRKMX X WHERE X.RKDH00='014523'