1       08:53:51  SQL Prepare: ORACLE - select * from  VW_SF_PJSYQK  where  1 = 1  
 and  PLMC00 = :1
 AND XJJE00<>0  and  DYRQ00 >= :2
 and  DYRQ00 <= :3
 and  DYRQ00||DYSJ00 >= :4
 and  DYRQ00||DYSJ00 <= :5
 order by PLBH00,DYRQ00,DYSJ00

2       08:53:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊缴款票据
3       08:53:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120705
4       08:53:51  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120706
5       08:53:51  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012070500:00:01
6       08:53:51  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012070623:59:59
7       08:53:51  SQL Execute: ORACLE - select * from  VW_SF_PJSYQK  where  1 = 1  
 and  PLMC00 = ?
 AND XJJE00<>0  and  DYRQ00 >= ?
 and  DYRQ00 <= ?
 and  DYRQ00||DYSJ00 >= ?
 and  DYRQ00||DYSJ00 <= ?
 order by PLBH00,DYRQ00,DYSJ00

8       08:53:51  SQL Prepare: ORACLE - select * from  VW_SF_PJSYQK  where  1 = 1  
 and  PLMC00 = :1
  and  DYRQ00 >= :2
 and  DYRQ00 <= :3
 and  DYRQ00||DYSJ00 >= :4
 and  DYRQ00||DYSJ00 <= :5
 order by PLBH00,DYRQ00,DYSJ00

9       08:53:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊缴款票据
10      08:53:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120705
11      08:53:51  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120706
12      08:53:51  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012070500:00:01
13      08:53:51  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012070623:59:59
14      08:53:51  SQL Execute: ORACLE - select * from  VW_SF_PJSYQK  where  1 = 1  
 and  PLMC00 = ?
  and  DYRQ00 >= ?
 and  DYRQ00 <= ?
 and  DYRQ00||DYSJ00 >= ?
 and  DYRQ00||DYSJ00 <= ?
 order by PLBH00,DYRQ00,DYSJ00