1       10:31:15  SQL Execute: ORACLE -  delete YS_BRZDXX where ZDXXID=2756885

2       10:31:15  SQL Data In: ORACLE - Rows affected = 1
3       10:31:15  SQL Execute: ORACLE - commit

4       10:31:15  SQL Data In: ORACLE - Rows affected = 0
5       10:31:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7775507.000000
6       10:31:15  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19000101
7       10:31:15  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7775507
8       10:31:15  SQL Execute: ORACLE - select 
  a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0, a.ICD900, a.ZDMSMC,
  a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0,
  (SELECT TRIM(ICD900)||' '||JBMC00 FROM XT_ICD900 WHERE ICD900= A.ICD900 and SYBZ00='1' and rownum=1) ICDJMC ,a.FWMC00,a.BWMC00
from YS_BRZDXX a, XT_ICD900 b 
  where a.ICD900 = b.ICD900(+) and a.SFXYZD='1'
    and a.GHID00 = ?  
   and (exists(select 1 from SF_BRXXB0 where GHID00=a.GHID00 and GHRQ00>=?)  or a.GHID00=?)
order by zzdbz0,zdxxid


9       10:31:15  SQL Execute: ORACLE - select a.ZDMC00 from ys_brzdxx A,BM_TYZD00 b where a.ghid00=7775507 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制'
 and b.BZ0000=(select min(b.BZ0000) from ys_brzdxx A,BM_TYZD00 b where a.ghid00=7775507
 and a.zdmc00=b.mc0000 and b.zdmc00='诊断处方天数限制') and rownum=1