1       12:32:08  Log started for: 药库管理系统
2       12:32:10  SQL Execute: ORACLE - Select FYBZ00 from BM_BMBM00 where BMBH00=30

3       12:32:10  SQL Execute: ORACLE - UPDATE YK_YPRKD0 SET RKZT00='1',SFSH00='Y',SHRBH0='1513'
,SHRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),SHSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
,QRRBH0='1513'
 WHERE RKDH00 = '014523'

4       12:32:10  SQL Data In: ORACLE - Rows affected = 1
5       12:32:10  SQL Execute: ORACLE - UPDATE YK_YPMXZ0 SET SFSH00='Y',
SHRQ00= TO_CHAR(SYSDATE,'YYYYMMDD'),SHSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 WHERE DJH000= '014523'

6       12:32:10  SQL Data In: ORACLE - Rows affected = 1
7       12:32:10  SQL Execute: ORACLE - SELECT BMXZ00,YYID00 FROM BM_BMBM00 WHERE BMBH00=22

8       12:32:10  SQL Execute: ORACLE - UPDATE YK_YPRKD0 SET RKZT00='2'
 WHERE RKDH00 in (SELECT BZ0000 FROM YF_YPCKD0
 WHERE Trim(BZ0000) = '014523' AND CKZT00='1')

9       12:32:10  SQL Data In: ORACLE - Rows affected = 1
10      12:32:10  SQL Execute: ORACLE - Commit

11      12:32:10  SQL Data In: ORACLE - Rows affected = 0
12      12:32:27  Log started for: 药房管理系统
13      12:32:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
14      12:32:27  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

15      12:32:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 0%
16      12:32:35  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 0%
17      12:32:35  SQL Execute: ORACLE - Select * from (select YPMC00,LSDJ00,SCPH00,QRRQ00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,ZHL000,XH0000 from VW_YF_YPTKPHTS_PH  S where (xh0000 Like ? or XH0000 Like ?) and( YKBMBH=30 and YPNM00=3 and YFBMBH=22 )  Order By XH0000,xh0000) where Rownum<=200

18      12:32:40  SQL Execute: ORACLE - delete from  YF_YPCKMX_TEMP 

19      12:32:40  SQL Data In: ORACLE - Rows affected = 1
20      12:32:40  SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=22

21      12:32:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
22      12:32:40  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 21.75
23      12:32:40  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
24      12:32:40  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
25      12:32:40  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 140608
26      12:32:40  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 17.4
27      12:32:40  SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,SCPH00,GJDJ00)
 VALUES(?,?,?,?,?,?)

28      12:32:40  SQL Data In: ORACLE - Rows affected = 1
29      12:32:40  SQL Execute: ORACLE - commit

30      12:32:40  SQL Data In: ORACLE - Rows affected = 0
31      12:32:40  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='140608'
 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)

32      12:32:40  SQL Execute: ORACLE - SELECT K2J000 FROM BM_YD0000
 WHERE YPNM00=3

33      12:32:40  SQL Execute: ORACLE - SELECT ROUND(sum(NVL(SJKCSL,0))/1,6)-2000 SJKCSL,(2000-ROUND(sum(NVL(SJKCSL,0))/1,6))/1000 jdKCSL FROM YF_PCKCMX 
 WHERE YFBMBH=22 AND YPNM00=3
 AND SCPH00='140608' AND Round(LSDJ00,2)=21.75
 AND  Round(GJDJ00,2)=17.4

34      12:32:40  SQL Execute: ORACLE -  SELECT RKSL00*ZHL000 RKSL00,PCKCSL+ (2*1000 ) PCKCSL FROM YK_YPRKMX WHERE YPRKPC=73769

35      12:32:40  SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
36      12:32:40  SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = YKRKDH
37      12:32:40  SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END;
38      12:32:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 014524
39      12:32:40  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
40      12:32:40  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000
41      12:32:40  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
42      12:32:40  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06
43      12:32:40  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
44      12:32:40  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'))

45      12:32:40  SQL Data In: ORACLE - Rows affected = 1
46      12:32:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 014524
47      12:32:40  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
48      12:32:40  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
49      12:32:40  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
50      12:32:40  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 艾绒
51      12:32:40  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 1000g
52      12:32:40  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = kg
53      12:32:40  SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000
54      12:32:40  SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
55      12:32:40  SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.400000
56      12:32:40  SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
57      12:32:40  SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.750000
58      12:32:40  SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.400000
59      12:32:40  SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.800000
60      12:32:40  SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
61      12:32:40  SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 140608
62      12:32:40  SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
63      12:32:40  SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.750000
64      12:32:40  SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 73769.000000
65      12:32:40  SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
66      12:32:40  SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
67      12:32:40  SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
68      12:32:40  SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
69      12:32:40  SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
70      12:32:40  SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
71      12:32:40  SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
72      12:32:40  SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
73      12:32:40  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, ?, ?, ?, ?, 
?, ?, ?, 
   ?, ?, ?, ?, ?, ?, ?, ?, 
   ?, ?, ?, ?, ?, ?, ?, ?, 
?, 
   ?, ?,?)

74      12:32:40  SQL Data In: ORACLE - Rows affected = 1
75      12:32:40  SQL Execute: ORACLE - COMMIT WORK
76      12:32:42  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='014524'
 AND R.RKLXBH='06'

77      12:32:42  SQL Execute: ORACLE - SELECT X.*,(select ypmlbz from bm_yd0000 where ypnm00=X.ypnm00) ypmlbz FROM YK_YPRKMX X WHERE X.RKDH00='014524'