1       11:09:34  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKQR'

2       11:09:34  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=208
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZCKQR'

3       11:09:34  SQL Prepare: ORACLE - SELECT  DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00
 FROM WZ_RCK000 a,VW_WZ_CJBM00 b
 WHERE a.SHBMBH=b.BMID00
 AND a.KFBMBH=208
 AND RCKLB0='2'
 AND ZTBZ00='1'
 and (RCKLX0<>'27' and rcklx0<>'36') 
 ORDER BY b.BMBH00

4       11:09:34  SQL Execute: ORACLE - SELECT  DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00
 FROM WZ_RCK000 a,VW_WZ_CJBM00 b
 WHERE a.SHBMBH=b.BMID00
 AND a.KFBMBH=208
 AND RCKLB0='2'
 AND ZTBZ00='1'
 and (RCKLX0<>'27' and rcklx0<>'36') 
 ORDER BY b.BMBH00

5       11:09:34  SQL Prepare: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC,RKYGBH
FROM VW_WZ_RCK000
WHERE (SHBMBH = :1 or 999999999=:2)
  AND KFBMBH = :3 
  AND RCKLB0 ='2'  
  AND ZTBZ00 ='1'
  AND (RCKLX0 <> '27' and rcklx0<>'36')
  AND KDRQ00 >=:4
  AND KDRQ00 <=:5
 and SHBMBH<>11111
 ORDER BY RCKDH0 DESC

6       11:09:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000
7       11:09:34  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000
8       11:09:34  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000
9       11:09:34  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130308
10      11:09:34  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20130315
11      11:09:34  SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC,RKYGBH
FROM VW_WZ_RCK000
WHERE (SHBMBH = ? or 999999999=?)
  AND KFBMBH = ? 
  AND RCKLB0 ='2'  
  AND ZTBZ00 ='1'
  AND (RCKLX0 <> '27' and rcklx0<>'36')
  AND KDRQ00 >=?
  AND KDRQ00 <=?
 and SHBMBH<>11111
 ORDER BY RCKDH0 DESC

12      11:09:34  SQL Prepare: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=:1
 order by RCKMXH

13      11:09:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 281303.000000
14      11:09:34  SQL Execute: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=?
 order by RCKMXH

15      11:09:35  SQL Prepare: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=:1
 order by RCKMXH

16      11:09:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 281303.000000
17      11:09:35  SQL Execute: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=?
 order by RCKMXH

18      11:09:44  SQL Prepare: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=:1
 order by RCKMXH

19      11:09:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 281303.000000
20      11:09:44  SQL Execute: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=?
 order by RCKMXH

21      11:09:44  SQL Prepare: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=:1
 order by RCKMXH

22      11:09:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 281303.000000
23      11:09:44  SQL Execute: ORACLE - select *
  from VW_WZ_RCKMX0
 where RCKID0=?
 order by RCKMXH

24      11:09:53  SQL Prepare: ORACLE - UPDATE WZ_RCK000 SET ZTBZ00='2'
,QRJSR0=476
,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 WHERE RCKID0=281303

25      11:09:53  SQL Execute: ORACLE - UPDATE WZ_RCK000 SET ZTBZ00='2'
,QRJSR0=476
,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 WHERE RCKID0=281303

26      11:09:53  SQL Data In: ORACLE - Rows affected = 0
27      11:09:53  SQL Prepare: ORACLE - Rollback

28      11:09:53  SQL Execute: ORACLE - Rollback

29      11:09:53  SQL Data In: ORACLE - Rows affected = 0