1 23:28:48 Log started for: 药库管理系统 2 23:28:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 3 23:28:50 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,Z2J000,M2J000,LSJ000,KCSX00,KCXX00,KCSL00,GJJ000,SPM000,ZBXH00,SCCJZW,GHDWNM,GHDWMC,SCCJBH,YPTYM0,ZBQMC0,SFZBYP,MRCGSL,YPMLBZ from VW_YK_YPSRTS where (PYSM00 Like ?) and( YKBMBH=169 ) Order By PYSM00) where Rownum<=999 4 23:28:52 SQL Execute: ORACLE - select Round(Sum(Nvl(a.SJKCSL,0))/1000,3) KCSL00 from YF_YPKCXX a where a.YPNM00=31086 5 23:28:52 SQL Execute: ORACLE - select Round(Sum(Nvl(a.FCSL00*a.ZHL000/a.K2J000,0)),3) YFSYL0 from VW_YK_YFYPSYL a where a.YPNM00=31086 and a.JZRQ00 BETWEEN '20220325' AND '20220401' group by a.ypnm00 6 23:28:52 SQL Execute: ORACLE - select max(JZRQ00) ZHCKRQ from YK_YPMXZ0 where ypnm00=31086 AND YKBMBH=169 AND JZXZ00='C' 7 23:28:52 SQL Execute: ORACLE - select COUNT(1) COUNT0 from BM_YDTSSX T,BM_YPSX00 S where T.SXBH00=S.SXBH00 and SXMC00='GMP' and T.YPNM00=31086 8 23:28:52 SQL Execute: ORACLE - select BMMC00,K2J000,Round(Sum(Nvl(SJKCSL,0))/c.K2J000,3) KCSL00 from YF_YPKCXX a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=31086 and a.YFBMBH=b.BMBH00 AND Nvl(SJKCSL,0)>0 and a.ypnm00=c.ypnm00 GROUP BY BMMC00,K2J000,PXXH00,BH0000 order by PXXH00,BH0000 9 23:28:52 SQL Execute: ORACLE - select b.BMMC00,c.K2J000,Round(Sum(Nvl(a.FCSL00*a.ZHL000,0))/c.K2J000,3) FCSL00 from VW_YK_YFYPSYL a,BM_BMBM00 b,BM_YD0000 c where a.YPNM00=31086 and a.YFBMBH=b.BMBH00 and JZRQ00 BETWEEN '20220325' AND '20220401' and a.ypnm00=c.ypnm00 GROUP BY b.BMMC00,c.K2J000,PXXH00,BH0000 order by PXXH00,BH0000 10 23:28:52 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 = '3') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',169,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '169') AND (INSTR (',' || a.jsksbh || ',',',169,') > 0 or a.jsksbh is null) 11 23:29:04 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 = '3') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',169,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '169') AND (INSTR (',' || a.jsksbh || ',',',169,') > 0 or a.jsksbh is null) 12 23:29:08 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 23:29:08 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = YKYPCGJHDH 14 23:29:08 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 15 23:29:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 003026 16 23:29:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 169.000000 17 23:29:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 23:29:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10018.000000 19 23:29:08 SQL Execute: ORACLE - INSERT INTO YK_YPCGJH (CGJHDH,YKBMBH,CZYBH0,GHDWNM,JHBZRQ,JHBZSJ) VALUES(?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 20 23:29:08 SQL Data In: ORACLE - Rows affected = 1 21 23:29:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 003026 22 23:29:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31086.000000 23 23:29:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0.9%氯化钠针 24 23:29:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 1000ml:9g 25 23:29:08 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 袋 26 23:29:08 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000 27 23:29:08 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000 28 23:29:08 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.440000 29 23:29:08 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 30 23:29:08 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 319 31 23:29:08 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 四川科伦药业股份有限公司 32 23:29:08 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 33 23:29:08 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 23:29:08 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10018.000000 35 23:29:08 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1440.000000 36 23:29:08 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 37 23:29:08 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1667.000000 38 23:29:08 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 23:29:08 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 49.000000 40 23:29:08 SQL Execute: ORACLE - insert into YK_CGJHMX (CGJHDH, YPNM00, YPMC00, YPGG00, CGDW00, ZHL000, JHCGSL, GJDJ00, LSDJ00, SCCJBH, SCCJZW, GMP000, CGCKSL, GHDWNM, CGMXXH, KCSL00, BZ0000, YFZSL0,JQYL00,YFSYL0) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SQ_YK_CGJHMX_CGMXXH.NEXTVAL, ?, ?,?,?,?) 41 23:29:08 SQL Data In: ORACLE - Rows affected = 1 42 23:29:08 SQL Execute: ORACLE - Commit 43 23:29:08 SQL Data In: ORACLE - Rows affected = 0 44 23:29:08 SQL Execute: ORACLE - COMMIT WORK 45 23:29:08 SQL Execute: ORACLE - Commit 46 23:29:08 SQL Data In: ORACLE - Rows affected = 0 47 23:29:11 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 48 23:29:11 SQL Execute: ORACLE - SELECT To_Char(SYSDATE-30, 'YYYYMMDD') OraSysDate FROM DUAL 49 23:29:11 SQL Execute: ORACLE - select bmbh00 from bm_bmbm00 where yyid00='223455' and bmxz00 in ('2','3') 50 23:29:11 SQL Execute: ORACLE - select C.CGJHDH,C.YPNM00,C.YPMC00,C.YPGG00,C.CGDW00,C.ZHL000,C.BZ0000, C.LSDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,C.CGCKSL,nvl(C.GHDWNM,1) GHDWNM,nvl(C.CGMXXH,1) CGMXXH,D.YPBM00, C.JHCGSL,C.GJDJ00,D.KCSL00,D.KCSX00,D.KCXX00,D.ZBXH00,D.PYSM00, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, E.YPTYM0,E.ZBQMC0, D.YFZSL0, (select MAX(JZRQ00) ZHCKRQ FROM YK_YPMXZ0 WHERE YKBMBH=D.YKBMBH AND YPNM00=C.YPNM00 AND JZXZ00='C') ZHCKRQ,E.SFZBYP, nvl(c.YFSYL0,DECODE('Y','N',0, (SELECT Round(Sum(Nvl(a.FCSL00*a.ZHL000/a.K2J000,0)),3) FROM VW_YK_YFYPSYL a WHERE a.YPNM00=C.YPNM00 AND a.JZRQ00 BETWEEN '20220325' AND '20220401' GROUP BY a.YPNM00))) YFSYL0,E.YPMLBZ, (SELECT Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3) FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20220302' AND '20220401' AND yfbmbh in (165,166,5,173,179,226,1329,163,1389,2809,2909,2910,2972)) JQYL00 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YD0000 E WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=169 AND CGJHDH='003026' AND C.YPNM00=E.YPNM00 ORDER BY GHDWNM,CGMXXH