1 16:13:16 SQL Prepare: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRSYKP a where BQH000=284 and zyid00 in (948897) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' ) 2 16:13:16 SQL Execute: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRSYKP a where BQH000=284 and zyid00 in (948897) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' ) 3 16:13:16 SQL Prepare: ORACLE - Insert Into XT_XTCZRZ(CZID00,CZTable,CZLX00,CZRYBM,CZNR00,DATAID) Values(SQ_XT_XTCZRZ_ID0000.NEXTVAL,'BQ_YZCFMX',5,1372,'病区医嘱执行单打印首次打印记录：病人姓名：陈肖华 yzid00:18541583打印人员:黄剑辉',18541583) 4 16:13:16 SQL Execute: ORACLE - Insert Into XT_XTCZRZ(CZID00,CZTable,CZLX00,CZRYBM,CZNR00,DATAID) Values(SQ_XT_XTCZRZ_ID0000.NEXTVAL,'BQ_YZCFMX',5,1372,'病区医嘱执行单打印首次打印记录：病人姓名：陈肖华 yzid00:18541583打印人员:黄剑辉',18541583) 5 16:13:16 SQL Data In: ORACLE - Rows affected = 1 6 16:13:16 SQL Prepare: ORACLE - Commit 7 16:13:16 SQL Execute: ORACLE - Commit 8 16:13:16 SQL Data In: ORACLE - Rows affected = 0 9 16:13:16 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='BQ_SYDDYL' 10 16:13:16 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='BQ_SYDDYL' 11 16:13:16 SQL Prepare: ORACLE - SELECT YZID00,MAX(DXSYSL)CS0000,CH0000,XM0000,QSSJ00,PCMC00,YPYFMC,ZYH000 FROM VW_BQ_JRSYKP a where BQH000 = 284 and zyid00 in (-1,948897) and zyid00 in (948897) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( JYKDY0,'0') in ('1','0')) and ((a.SRCS00=-1) or (a.SRCS00<>-1 and a.QYRQ00=to_char(sysdate,'YYYYMMDD') and (a.ZQCS00-a.SXH000-1 and a.QYRQ00<>to_char(sysdate,'YYYYMMDD')) ) GROUP BY YZID00,QSRQ00,QSSJ00,CH0000,XM0000,PCMC00,YPYFMC,ZYH000 ORDER BY CH0000,YZID00,QSSJ00 12 16:13:16 SQL Execute: ORACLE - SELECT YZID00,MAX(DXSYSL)CS0000,CH0000,XM0000,QSSJ00,PCMC00,YPYFMC,ZYH000 FROM VW_BQ_JRSYKP a where BQH000 = 284 and zyid00 in (-1,948897) and zyid00 in (948897) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( JYKDY0,'0') in ('1','0')) and ((a.SRCS00=-1) or (a.SRCS00<>-1 and a.QYRQ00=to_char(sysdate,'YYYYMMDD') and (a.ZQCS00-a.SXH000-1 and a.QYRQ00<>to_char(sysdate,'YYYYMMDD')) ) GROUP BY YZID00,QSRQ00,QSSJ00,CH0000,XM0000,PCMC00,YPYFMC,ZYH000 ORDER BY CH0000,YZID00,QSSJ00 13 16:13:16 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 14 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 15 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 16 16:13:16 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 17 16:13:16 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 18 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 19 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 20 16:13:16 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 21 16:13:16 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 22 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 23 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 24 16:13:16 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 25 16:13:16 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 26 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 27 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 28 16:13:16 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 29 16:13:16 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 30 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 31 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 32 16:13:16 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 33 16:13:16 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 34 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 35 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 36 16:13:16 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 37 16:13:16 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 38 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 39 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 40 16:13:16 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 41 16:13:16 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 42 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 43 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 44 16:13:16 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 45 16:13:16 SQL Prepare: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 46 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 47 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 48 16:13:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 49 16:13:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 50 16:13:16 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 51 16:13:16 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 52 16:13:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 53 16:13:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 54 16:13:16 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 55 16:13:16 SQL Prepare: ORACLE - select * from VW_BQ_SYKPNR where yzid00=18496989 56 16:13:16 SQL Execute: ORACLE - select * from VW_BQ_SYKPNR where yzid00=18496989 57 16:13:16 SQL Prepare: ORACLE - select * from VW_BQ_SYKPNR where yzid00=18497791 58 16:13:16 SQL Execute: ORACLE - select * from VW_BQ_SYKPNR where yzid00=18497791