1       09:10:50  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=3
 and a.YYRQ00='20140416'
 and a.PBSXW0='ÏÂÎç'
 order by a.XH0000  

2       09:10:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
3       09:10:52  SQL Execute: ORACLE - select zpjlid from yj_yw0000 where yjdjh0=?

4       09:10:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
5       09:10:52  SQL Execute: ORACLE - select * from bm_brzpxx where brid00=? and jllb00=1 order by jlid00 desc

6       09:10:55  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=3
 and a.YYRQ00='20140416'
 and a.PBSXW0='ÏÂÎç'
 order by a.XH0000  

7       09:11:00  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=3
 and a.YYRQ00='20140416'
 and a.PBSXW0='ÏÂÎç'
 order by a.XH0000  

8       09:11:04  SQL Execute: ORACLE -  Select SQ_BM_BRZPXX_JLID00.NextVal SID from Dual

9       09:11:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000
10      09:11:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
11      09:11:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
12      09:11:04  SQL Execute: ORACLE - insert into BM_BRZPXX(JLID00,brid00,ephoto,jllb00,PACSLJ) values(?,?,?,1,?)

13      09:11:04  SQL Data In: ORACLE - Rows affected = 1
14      09:11:04  SQL Execute: ORACLE - Commit

15      09:11:04  SQL Data In: ORACLE - Rows affected = 0
16      09:11:04  SQL Execute: ORACLE - UPDATE yj_yw0000 set zpjlid=8 where yjdjh0=0

17      09:11:04  SQL Data In: ORACLE - Rows affected = 0
18      09:11:04  SQL Execute: ORACLE - Commit

19      09:11:04  SQL Data In: ORACLE - Rows affected = 0
20      09:11:04  SQL Execute: ORACLE - Commit

21      09:11:04  SQL Data In: ORACLE - Rows affected = 0
22      09:11:05  SQL Execute: ORACLE - select a.*  from VW_YJ_JCPBYHMX a where (MZZYBZ='1' or MZZYBZ='2') 
 and  XMWHID=3
 and a.YYRQ00='20140416'
 and a.PBSXW0='ÏÂÎç'
 order by a.XH0000