1 15:41:18 SQL Execute: ORACLE - select bh0000 from bm_yysfxm where ltrim(rtrim(bh0000))='I0301148003' and bmgzid=1 2 15:41:21 SQL Execute: ORACLE - select SQ_BM_YYSFXM_SFXMID.nextval+8000000000 from dual 3 15:41:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 4 15:41:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = L 5 15:41:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000113339.000000 6 15:41:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 7 15:41:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = I0301148003 8 15:41:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试添加 9 15:41:21 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = cstj 10 15:41:21 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = iyil 11 15:41:21 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 15:41:21 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 15:41:21 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 14 15:41:21 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 15 15:41:21 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 15:41:21 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 17 15:41:21 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 18 15:41:21 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 19 15:41:21 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 20 15:41:21 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 21 15:41:21 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 22 15:41:21 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 23 15:41:21 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 24 15:41:21 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 25 15:41:21 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220720 26 15:41:21 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:39:43 27 15:41:21 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 28 15:41:21 SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 116.000000 29 15:41:21 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 275 30 15:41:21 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 31 15:41:21 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 32 15:41:21 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 030114800 33 15:41:21 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 34 15:41:21 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 35 15:41:21 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 15:41:21 SQL Data In: ORACLE - Param = 34, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 15:41:21 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = I0301 38 15:41:21 SQL Data In: ORACLE - Param = 36, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 39 15:41:21 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 134 40 15:41:21 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 41 15:41:21 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 42 15:41:21 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 15:41:21 SQL Data In: ORACLE - Param = 41, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 44 15:41:21 SQL Data In: ORACLE - Param = 42, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 45 15:41:21 SQL Data In: ORACLE - Param = 43, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 46 15:41:21 SQL Data In: ORACLE - Param = 44, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 47 15:41:21 SQL Data In: ORACLE - Param = 45, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 48 15:41:21 SQL Data In: ORACLE - Param = 46, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 49 15:41:21 SQL Data In: ORACLE - Param = 47, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 50 15:41:21 SQL Execute: ORACLE - BEGIN "SP_XM_YYWHADD" (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); END; 51 15:41:49 SQL Execute: ORACLE - select * from VW_BM_YYSFXMGL a where 1=1 and a.flag00 = '1' and a.bmgzid= 1 and a.TREEBH like 'I0301%' and a.BH0000 not like '9%' and a.TZRQ00 is null order by a.TREEBH,a.bh0000 52 15:41:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000113337 53 15:41:49 SQL Execute: ORACLE - select G.SFXMID,G.ZLXMID,S.XMMC00,Z.ZLXMJC,Z.ZLXMBH,G.GXID00,Z.SFYXSQ,Z.DJ0000,Z.BZ0000,S.GJYLBM,Z.SFTY00,Z.TZRQ00,Z.QYRQ00 from XT_ZLSFGX G,VW_XM_ZLZD00 Z,BM_YYSFXM S where G.ZLXMID=Z.ZLXMID and G.SFXMID=S.SFXMID and G.SFXMID=? 54 15:41:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000113337 55 15:41:49 SQL Execute: ORACLE - select a.SFXMID, a.SFBZDJ, a.DJSFJE, a.DJBZ00, b.YYJC00 from BM_SFDJBZ a, XT_YYXX00 b where a.SFBZDJ = b.SFBZDJ and b.SFBZDJ <> '0' and a.SFXMID = ? 56 15:41:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000113337 57 15:41:49 SQL Execute: ORACLE - select c.YYJC00, b.YBMC00, a.SFXMID, a.SFYP00, a.SFBZDJ, a.YBZXLB, a.DJSFSX from BM_YBDJSX a,IC_YBBRLB b,XT_YYXX00 c where a.SFBZDJ = c.SFBZDJ and a.sfxmid=? and a.sfyp00='N' and c.SFBZDJ <> '0' and a.ybzxlb=b.ybzxlb and b.yblb00=b.ybzxlb order by c.YYJC00 58 15:41:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000113337 59 15:41:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000113337 60 15:41:49 SQL Execute: ORACLE - select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,ypmc00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00, (select MC0000 from BM_TYZD00 where ZDMC00='物资维护-物资属性' and LBBZ00='0' and BH0000=a.WZSX00 and rownum=1) as WZSXMC from BM_WZQTXX a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=? union select (select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH) as SCCJZW, (select GHDWMC from BM_YPGHDW where GHDWNM=B.GHDWNM) as GHDWMC,YPBM00,YPMC00,YPGG00,KCDW00, LSJ000,TXM000,a.SFXMID,b.GJJ000,a.YPNM00,b.WZXH00, (select MC0000 from BM_WZQTXX aa,BM_TYZD00 bb where aa.YPNM00=a.YPNM00 and bb.ZDMC00='物资维护-物资属性' and bb.LBBZ00='0' and bb.BH0000=aa.WZSX00 and rownum=1) as WZSXMC from BM_WZSFDY a, BM_YD0000 b where a.YPNM00=b.YPNM00 and b.LBBH00='9' and a.SFXMID=?