1 09:35:13 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2 09:35:13 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15090875.000000 3 09:35:13 SQL Data In: ORACLE - Param = 3, Name = P_ZYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 754620 4 09:35:13 SQL Data In: ORACLE - Param = 4, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 5 09:35:13 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6 09:35:13 SQL Data In: ORACLE - Param = 6, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:35:13 7 09:35:13 SQL Data In: ORACLE - Param = 7, Name = P_ZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19293.000000 8 09:35:13 SQL Data In: ORACLE - Param = 8, Name = P_ZLXMMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 彩超消化系统 9 09:35:13 SQL Data In: ORACLE - Param = 9, Name = P_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 10 09:35:13 SQL Data In: ORACLE - Param = 10, Name = P_KZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 11 09:35:13 SQL Data In: ORACLE - Param = 11, Name = P_LRRXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 易联众ss 12 09:35:13 SQL Data In: ORACLE - Param = 12, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140701 13 09:35:13 SQL Data In: ORACLE - Param = 13, Name = P_QYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:35:08 14 09:35:13 SQL Data In: ORACLE - Param = 14, Name = P_TS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 15 09:35:13 SQL Data In: ORACLE - Param = 15, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 16 09:35:13 SQL Data In: ORACLE - Param = 16, Name = P_MCSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 17 09:35:13 SQL Data In: ORACLE - Param = 17, Name = P_TQFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 18 09:35:13 SQL Data In: ORACLE - Param = 18, Name = P_YZCLLB, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 正常 19 09:35:13 SQL Data In: ORACLE - Param = 19, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 20 09:35:13 SQL Data In: ORACLE - Param = 20, Name = P_ZDID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = I25.602 21 09:35:13 SQL Data In: ORACLE - Param = 21, Name = P_ZDMC00, Type = fldZSTRING, Precision = 28, Scale = 0, Data = 冠心病，隐性(无症状性冠心病) 22 09:35:13 SQL Data In: ORACLE - Param = 22, Name = P_BQZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 23 09:35:13 SQL Data In: ORACLE - Param = 23, Name = P_BWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 24 09:35:13 SQL Data In: ORACLE - Param = 24, Name = P_BB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 25 09:35:13 SQL Data In: ORACLE - Param = 25, Name = P_BBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 26 09:35:13 SQL Data In: ORACLE - Param = 26, Name = P_SFSQD0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 27 09:35:13 SQL Data In: ORACLE - Param = 27, Name = P_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 28 09:35:13 SQL Data In: ORACLE - Param = 28, Name = P_CJKS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 29 09:35:13 SQL Data In: ORACLE - Param = 29, Name = P_LJID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 30 09:35:13 SQL Data In: ORACLE - Param = 30, Name = P_RCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 31 09:35:13 SQL Data In: ORACLE - Param = 31, Name = P_ZXID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 32 09:35:13 SQL Data In: ORACLE - Param = 32, Name = P_BWBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 09:35:13 SQL Data In: ORACLE - Param = 33, Name = P_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 34 09:35:13 SQL Execute: ORACLE - BEGIN "SP_ZS_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_ZLXMMC => :P_ZLXMMC,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_ZDID00 => :P_ZDID00,P_ZDMC00 => :P_ZDMC00,P_BQZY00 => :P_BQZY00,P_BWMC00 => :P_BWMC00,P_BB0000 => :P_BB0000,P_BBID00 => :P_BBID00,P_SFSQD0 => :P_SFSQD0,P_ZXYS00 => :P_ZXYS00,P_CJKS00 => :P_CJKS00,P_LJID00 => :P_LJID00,P_RCID00 => :P_RCID00,P_ZXID00 => :P_ZXID00,P_BWBH00 => :P_BWBH00,P_JZBZ00 => :P_JZBZ00); END; 35 09:35:13 SQL Data In: ORACLE - Param = 1, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15090889.000000 36 09:35:13 SQL Data In: ORACLE - Param = 2, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 37 09:35:13 SQL Execute: ORACLE - BEGIN "SP_BQ_YJFJFY" (P_YZMXID => :P_YZMXID,P_CZY000 => :P_CZY000); END; 38 09:35:13 SQL Execute: ORACLE - Commit 39 09:35:13 SQL Data In: ORACLE - Rows affected = 0 40 09:35:13 SQL Execute: ORACLE - select YZMXID,ZYSQID from BQ_YJYZ00 a,BM_ZLZD00 b where a.ZYID00=754620 and a.ZLXMID=b.ZLXMID and a.YZZT00='7' and nvl(b.ZYSQID,0)>0 and nvl(SQID00,0)=0 order by ZYSQID 41 09:35:13 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 754620 and LB0000 = '1' and (YZZT00 in ('7','0','1','2','5','9','7') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID