1 11:09:05 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 2 11:09:05 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 3 11:09:05 SQL Prepare: ORACLE - BEGIN "SP_BQ_SRTJ00" (PBQH000 => :PBQH000,PBQH001 => :PBQH001,PZXBQ00 => :PZXBQ00,PZXBQ01 => :PZXBQ01,PQSRQ00 => :PQSRQ00,PJZRQ00 => :PJZRQ00,PCXTJ00 => :PCXTJ00,PXSKDKS => :PXSKDKS,PID0000 => :PID0000); END; 4 11:09:05 SQL Prepare: ORACLE - BEGIN "SP_BQ_SRTJ00" (PBQH000 => :PBQH000,PBQH001 => :PBQH001,PZXBQ00 => :PZXBQ00,PZXBQ01 => :PZXBQ01,PQSRQ00 => :PQSRQ00,PJZRQ00 => :PJZRQ00,PCXTJ00 => :PCXTJ00,PXSKDKS => :PXSKDKS,PID0000 => :PID0000); END; 5 11:09:05 SQL Data In: ORACLE - Param = 1, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6 11:09:05 SQL Data In: ORACLE - Param = 2, Name = PBQH001, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 99999999.000000 7 11:09:05 SQL Data In: ORACLE - Param = 3, Name = PZXBQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362.000000 8 11:09:05 SQL Data In: ORACLE - Param = 4, Name = PZXBQ01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362.000000 9 11:09:05 SQL Data In: ORACLE - Param = 5, Name = PQSRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/26/2010 0:0:0:0 10 11:09:05 SQL Data In: ORACLE - Param = 6, Name = PJZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 7/26/2010 0:0:0:0 11 11:09:05 SQL Data In: ORACLE - Param = 7, Name = PCXTJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 12 11:09:05 SQL Data In: ORACLE - Param = 8, Name = PXSKDKS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 11:09:05 SQL Data In: ORACLE - Param = 9, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 11:09:05 SQL Execute: ORACLE - BEGIN "SP_BQ_SRTJ00" (PBQH000 => :PBQH000,PBQH001 => :PBQH001,PZXBQ00 => :PZXBQ00,PZXBQ01 => :PZXBQ01,PQSRQ00 => :PQSRQ00,PJZRQ00 => :PJZRQ00,PCXTJ00 => :PCXTJ00,PXSKDKS => :PXSKDKS,PID0000 => :PID0000); END; 15 11:09:06 SQL Prepare: ORACLE - select * from vw_bq_fpxm00 16 11:09:06 SQL Execute: ORACLE - select * from vw_bq_fpxm00 17 11:09:06 SQL Prepare: ORACLE - Select Decode(czrq00,'合计',czrq00,SubstrB(czrq00,1,4)||'年'||SubstrB(czrq00,5,2)||'月') "日期",sfxm01 "西药费",sfxm02 "成药费",sfxm03 "草药费",sfxm05 "床位费",sfxm06 "诊察费",sfxm07 "护理费",sfxm08 "检查费",sfxm09 "化验费",sfxm10 "治疗费",sfxm11 "手术费",sfxm12 "救护车费",sfxm13 "其他费",sfxm51 "急诊留观床位费",sfxm18 "输血费",sfxm17 "输氧费",sfxm14 "MRI费",sfxm15 "CT费",sfxm19 "麻醉费",sfxm20 "麻醉相关",sfxm21 "其它医疗",sfxm16 "彩超费",sfxm52 "材料费",xmhj00 "合计" from bq_srtj00 a where id0000=156722 18 11:09:06 SQL Execute: ORACLE - Select Decode(czrq00,'合计',czrq00,SubstrB(czrq00,1,4)||'年'||SubstrB(czrq00,5,2)||'月') "日期",sfxm01 "西药费",sfxm02 "成药费",sfxm03 "草药费",sfxm05 "床位费",sfxm06 "诊察费",sfxm07 "护理费",sfxm08 "检查费",sfxm09 "化验费",sfxm10 "治疗费",sfxm11 "手术费",sfxm12 "救护车费",sfxm13 "其他费",sfxm51 "急诊留观床位费",sfxm18 "输血费",sfxm17 "输氧费",sfxm14 "MRI费",sfxm15 "CT费",sfxm19 "麻醉费",sfxm20 "麻醉相关",sfxm21 "其它医疗",sfxm16 "彩超费",sfxm52 "材料费",xmhj00 "合计" from bq_srtj00 a where id0000=156722 19 11:09:10 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 20 11:09:10 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 21 11:09:15 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 22 11:09:15 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 23 11:09:20 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 24 11:09:20 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 25 11:09:25 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 26 11:09:25 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 27 11:09:30 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 28 11:09:30 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 29 11:09:35 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 30 11:09:35 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 31 11:09:40 SQL Prepare: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 32 11:09:40 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=2 or (JSKSBH=362 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0