1       15:13:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 
534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=534))))

2       15:13:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 
534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=534))))

3       15:13:43  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=534)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

4       15:13:43  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=534)))) ORDER BY B.F_TEMPTYPE,A.MKDM00

5       15:13:44  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((534= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=534))))  

6       15:13:44  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((534= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=534))))  

7       15:13:44  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

8       15:13:44  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

9       15:13:45  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=534))))

10      15:13:45  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
534= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=534))))

11      15:13:49  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=534 and BMBH00=204
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX'

12      15:13:49  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=534 and BMBH00=204
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX'

13      15:13:50  SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH

14      15:13:50  SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH

15      15:13:50  SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 
WHERE RCKBZ0 = '1' AND SFYX00 = 'Y'

16      15:13:50  SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 
WHERE RCKBZ0 = '1' AND SFYX00 = 'Y'

17      15:13:52  SQL Prepare: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC,
a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.WZEJFL,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00,
b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, 
b.WZJCL0,b.LSJ000,b.fprq00
from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c 
where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKLB0 = '1' 
and a.KDRQ00 >=:1 and a.KDRQ00 <=:2 
and a.KFBMBH = :3 and c.WZDMBM||'' like :4 ||'%' 
and b.BZSL00<>'0' 
and ((A.rcklx0 =:5) OR (:6 = '-1')) order by a.RCKDH0 desc,b.RCKMXH

18      15:13:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090601
19      15:13:52  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090601
20      15:13:52  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 204.000000
21      15:13:52  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
22      15:13:52  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
23      15:13:52  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
24      15:13:52  SQL Execute: ORACLE - select a.ZTBZ00,decode(a.ZTBZ00,'1','已开单','2','已确认','3','已审核','4','已作废','5','已更正') as ZTBZMC,
a.RCKBMC,a.QRRQ00,a.RCKDH0,b.FPH000,b.WZMC00,b.GGXH00,b.WZEJFL,b.GG0000,b.WZXH00,b.BZDW00,b.BZSL00 CRKSL0,b.CGJBZ0 CGJ000,B.ZBXH00,
b.PH0000,b.YXQ000,b.ZJE000,b.BZDW00,a.RCKID0,a.FHBMMC,b.CJMC00,c.pysm00,c.wbsm00,b.CXBZ00,decode(b.FPDWQK,'1','已到','未到') FPDWQK,b.BZ0000, 
b.WZJCL0,b.LSJ000,b.fprq00
from VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c 
where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID and a.RCKLB0 = '1' 
and a.KDRQ00 >=? and a.KDRQ00 <=? 
and a.KFBMBH = ? and c.WZDMBM||'' like ? ||'%' 
and b.BZSL00<>'0' 
and ((A.rcklx0 =?) OR (? = '-1')) order by a.RCKDH0 desc,b.RCKMXH