1       16:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
2       16:57:10  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481255.000000
3       16:57:10  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
4       16:57:10  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20152.000000
5       16:57:10  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = 一般专项护理[口腔护理]
6       16:57:10  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
7       16:57:10  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 次
8       16:57:10  SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
9       16:57:10  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 管理员
10      16:57:10  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090513
11      16:57:10  SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
12      16:57:10  SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 120100014
13      16:57:10  SQL Execute: ORACLE - insert into BQ_JZXM00
  (ID0000, ZYID00, CLBZ00, XMLB00, SFXMID, XMMC00, CS0000, 
DW0000, 
   SFJE00, LRRXM0, QSRQ00, BZ0000,GJBM00)
values
  (?, ?, ?, 0, ?, ?, ?, 
   ?, ?, ?, 
TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD'), ?,
?)

14      16:57:10  SQL Data In: ORACLE - Rows affected = 1
15      16:57:10  SQL Prepare: ORACLE - COMMIT WORK
16      16:57:10  SQL Execute: ORACLE - COMMIT WORK
17      16:57:10  SQL Prepare: ORACLE - select ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00,
LRRQ00||' '||LRSJ00 "LRRQSJ",JZJE00,DW0000,LRRXM0,BZ0000,
ZFJE00,GFJE00,
DECODE(SFYBXM,'Y','是','否')"YBSFXM",ZYID00,xmlb00,sfxmid,
GJBM00,JSXM00,LSCL00
FROM VW_BQ_BRJZXM 
where zyid00=:1 and Tzrq00 is null and gzrq00 is null 
AND XMLB00='0' and Clbz00 like '%'||:2 
order by clbz00,qsrq00



18      16:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481255.000000
19      16:57:10  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
20      16:57:10  SQL Execute: ORACLE - select ID0000,CLBZ00,XMMC00,SFJE00,CS0000,QSRQ00,
LRRQ00||' '||LRSJ00 "LRRQSJ",JZJE00,DW0000,LRRXM0,BZ0000,
ZFJE00,GFJE00,
DECODE(SFYBXM,'Y','是','否')"YBSFXM",ZYID00,xmlb00,sfxmid,
GJBM00,JSXM00,LSCL00
FROM VW_BQ_BRJZXM 
where zyid00=? and Tzrq00 is null and gzrq00 is null 
AND XMLB00='0' and Clbz00 like '%'||? 
order by clbz00,qsrq00



21      16:57:10  SQL Prepare: ORACLE - select distinct xmzt00,xh0000,zyid00,sfxmid,xmmc00,xmdj00,bh0000,gjbm00,jsxm00,lscl00,pysm00,wbsm00 From VW_BQ_SFXMYJYZ 
where zyid00=:1 and xh0000 like :2 
order by xh0000,gjbm00

22      16:57:10  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481255.000000
23      16:57:10  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
24      16:57:10  SQL Execute: ORACLE - select distinct xmzt00,xh0000,zyid00,sfxmid,xmmc00,xmdj00,bh0000,gjbm00,jsxm00,lscl00,pysm00,wbsm00 From VW_BQ_SFXMYJYZ 
where zyid00=? and xh0000 like ? 
order by xh0000,gjbm00