1 17:40:27 Log started for: Sickberth 2 17:40:29 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 3 17:40:29 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15945683.000000 4 17:40:29 SQL Data In: ORACLE - Param = 3, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 761715.000000 5 17:40:29 SQL Data In: ORACLE - Param = 4, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6 17:40:29 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 7 17:40:29 SQL Data In: ORACLE - Param = 6, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:39:12 8 17:40:29 SQL Data In: ORACLE - Param = 7, Name = P_ZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24800.000000 9 17:40:29 SQL Data In: ORACLE - Param = 8, Name = P_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 550.000000 10 17:40:29 SQL Data In: ORACLE - Param = 9, Name = P_KZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1945.000000 11 17:40:29 SQL Data In: ORACLE - Param = 10, Name = P_LRRXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 12 17:40:29 SQL Data In: ORACLE - Param = 11, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150528 13 17:40:29 SQL Data In: ORACLE - Param = 12, Name = P_QYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:38:00 14 17:40:29 SQL Data In: ORACLE - Param = 13, Name = P_TS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 15 17:40:29 SQL Data In: ORACLE - Param = 14, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 87.000000 16 17:40:29 SQL Data In: ORACLE - Param = 15, Name = P_MCSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 17 17:40:29 SQL Data In: ORACLE - Param = 16, Name = P_TQFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 18 17:40:29 SQL Data In: ORACLE - Param = 17, Name = P_YZCLLB, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 正常 19 17:40:29 SQL Data In: ORACLE - Param = 18, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 20 17:40:29 SQL Data In: ORACLE - Param = 19, Name = P_bb0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 21 17:40:29 SQL Data In: ORACLE - Param = 20, Name = P_bbid00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 17:40:29 SQL Data In: ORACLE - Param = 21, Name = P_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1798.000000 23 17:40:29 SQL Data In: ORACLE - Param = 22, Name = p_zlxmmc, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 一次性吸引管[自费] 24 17:40:29 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZ00" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_ZYID00 => :P_ZYID00,P_YEXM00 => :P_YEXM00,P_CLBZ00 => :P_CLBZ00,P_PXSJ00 => :P_PXSJ00,P_ZLXMID => :P_ZLXMID,P_ZXKS00 => :P_ZXKS00,P_KZYS00 => :P_KZYS00,P_LRRXM0 => :P_LRRXM0,P_QYRQ00 => :P_QYRQ00,P_QYSJ00 => :P_QYSJ00,P_TS0000 => :P_TS0000,P_PCID00 => :P_PCID00,P_MCSL00 => :P_MCSL00,P_TQFS00 => :P_TQFS00,P_YZCLLB => :P_YZCLLB,P_BZ0000 => :P_BZ0000,P_bb0000 => :P_bb0000,P_bbid00 => :P_bbid00,P_ZXYS00 => :P_ZXYS00,p_zlxmmc => :p_zlxmmc); END; 25 17:40:29 SQL Data In: ORACLE - Param = 1, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15945696.000000 26 17:40:29 SQL Data In: ORACLE - Param = 2, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 27 17:40:29 SQL Execute: ORACLE - BEGIN "SP_BQ_YJFJFY" (P_YZMXID => :P_YZMXID,P_CZY000 => :P_CZY000); END; 28 17:40:29 SQL Data In: ORACLE - Param = 1, Name = V_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 761715.000000 29 17:40:29 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 30 17:40:29 SQL Data In: ORACLE - Param = 3, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 31 17:40:29 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 17:40:29 SQL Data In: ORACLE - Param = 5, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 17:40:29 SQL Execute: ORACLE - BEGIN "SP_ZS_YJTSXZ" (V_ZYID00 => :V_ZYID00,V_YJDJH0 => :V_YJDJH0,V_FLAG00 => :V_FLAG00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 34 17:40:29 SQL Execute: ORACLE - Commit 35 17:40:29 SQL Data In: ORACLE - Rows affected = 0 36 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 761715.000000 37 17:40:29 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 38 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 761715.000000 39 17:40:29 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID