1       16:59:39  Log started for: 药房管理系统
2       16:59:51  SQL Execute: ORACLE - delete from  yf_cflsh0 

3       16:59:51  SQL Data In: ORACLE - Rows affected = 1
4       16:59:51  SQL Execute: ORACLE -  insert into yf_cflsh0 values('6814214')

5       16:59:51  SQL Data In: ORACLE - Rows affected = 1
6       16:59:51  SQL Execute: ORACLE - SELECT sf_xt_yymc00(160)||'住院处方笺(补打)' TITLE,'第一联' LS0000,decode(instr(DQBQ00,'儿'),0,decode(instr(DQBQ00,'急'),0,'普通处方','急诊处方'),'儿科处方') CFXZ00,a.* from VW_YF_ZYCYCF_MSQL a where CFLSH0='6814214'

7       16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
8       16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
9       16:59:51  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

10      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
11      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
12      16:59:51  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

13      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
14      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
15      16:59:51  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

16      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
17      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
18      16:59:51  SQL Execute: ORACLE - select * from t_CtlEdit    where f_sysid=? and f_tempid=? order by F_Sequence

19      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
20      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
21      16:59:51  SQL Execute: ORACLE - select * from t_CtlDate    where f_sysid=? and f_tempid=? order by F_Sequence

22      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
23      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
24      16:59:51  SQL Execute: ORACLE - select * from t_CtlLine    where f_sysid=? and f_tempid=? order by F_Sequence

25      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
26      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
27      16:59:51  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

28      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
29      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
30      16:59:51  SQL Execute: ORACLE - select * from t_CtlGrid    where f_sysid=? and f_tempid=? order by F_Sequence

31      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
32      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
33      16:59:51  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
34      16:59:51  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
35      16:59:51  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

36      16:59:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
37      16:59:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
38      16:59:51  SQL Execute: ORACLE - select * from t_SQLlist    where f_sysid=? and f_tempid=? order by F_Sequence

39      16:59:51  SQL Execute: ORACLE - select Y.*  from VW_YF_ZYZYDY Y,(select ZB0000,CFID00,to_char(rownum)||'.' ROWN00 from  YF_ZYCFMX  where CFLSH0='6814214') X where Y.CFLSH0='6814214' and Y.CFID00>0 and X.CFID00=Y.CFID00 order by decode(ZB0000,'',' ',ZB0000),Y.CFID00