1       16:23:05  Log started for: 门诊医生工作站分系统
2       16:24:44  SQL Prepare: ORACLE - select SJYSXM "付款方式",BMMC00 "科室",SFXM01 "挂号数",SFXM02 "总费用",SFXM04 "次均费用",SFXM03 "药费",SFXM06 "次均药费",
rtrim(replace(to_char(SFXM05*100,'FM9999990.9')||' ','. ',''))||'%'  "药比",
rtrim(replace(to_char(SFXM17*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号同比",
rtrim(replace(to_char(SFXM18*100,'FM9999990.9')||' ','. ',''))||'%'  "费用同比",
rtrim(replace(to_char(SFXM19*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用同比",
rtrim(replace(to_char(SFXM27*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号环比",
rtrim(replace(to_char(SFXM28*100,'FM9999990.9')||' ','. ',''))||'%'  "费用环比",
rtrim(replace(to_char(SFXM29*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用环比" 
from BM_YYSFTJ where ID0000=:1 order by rowid

3       16:24:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1098731.000000
4       16:24:44  SQL Execute: ORACLE - select SJYSXM "付款方式",BMMC00 "科室",SFXM01 "挂号数",SFXM02 "总费用",SFXM04 "次均费用",SFXM03 "药费",SFXM06 "次均药费",
rtrim(replace(to_char(SFXM05*100,'FM9999990.9')||' ','. ',''))||'%'  "药比",
rtrim(replace(to_char(SFXM17*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号同比",
rtrim(replace(to_char(SFXM18*100,'FM9999990.9')||' ','. ',''))||'%'  "费用同比",
rtrim(replace(to_char(SFXM19*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用同比",
rtrim(replace(to_char(SFXM27*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号环比",
rtrim(replace(to_char(SFXM28*100,'FM9999990.9')||' ','. ',''))||'%'  "费用环比",
rtrim(replace(to_char(SFXM29*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用环比" 
from BM_YYSFTJ where ID0000=? order by rowid

5       16:24:44  SQL Prepare: ORACLE - rollback

6       16:24:44  SQL Execute: ORACLE - rollback

7       16:24:44  SQL Data In: ORACLE - Rows affected = 0
8       16:24:49  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

9       16:24:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476
10      16:24:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
11      16:24:49  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

12      16:24:49  SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=:1 and jzks00=:2

13      16:24:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476
14      16:24:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
15      16:24:49  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

16      16:25:16  SQL Prepare: ORACLE - BEGIN "SP_YS_GRCJFY" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AD_KDKSTJ => :AD_KDKSTJ,AD_KDYS00 => :AD_KDYS00,AS_FZXTJ0 => :AS_FZXTJ0,AD_ID0000 => :AD_ID0000,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,AD_KSBH00 => :AD_KSBH00,AD_TJRK00 => :AD_TJRK00); END;
17      16:25:16  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120701
18      16:25:16  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120731
19      16:25:16  SQL Data In: ORACLE - Param = 3, Name = AD_KDKSTJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
20      16:25:16  SQL Data In: ORACLE - Param = 4, Name = AD_KDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
21      16:25:16  SQL Data In: ORACLE - Param = 5, Name = AS_FZXTJ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
22      16:25:16  SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
23      16:25:16  SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
24      16:25:16  SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
25      16:25:16  SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
26      16:25:16  SQL Data In: ORACLE - Param = 10, Name = AD_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000
27      16:25:16  SQL Data In: ORACLE - Param = 11, Name = AD_TJRK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
28      16:25:16  SQL Execute: ORACLE - BEGIN "SP_YS_GRCJFY" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AD_KDKSTJ => :AD_KDKSTJ,AD_KDYS00 => :AD_KDYS00,AS_FZXTJ0 => :AS_FZXTJ0,AD_ID0000 => :AD_ID0000,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,AD_KSBH00 => :AD_KSBH00,AD_TJRK00 => :AD_TJRK00); END;
29      16:26:21  SQL Prepare: ORACLE - select SJYSXM "付款方式",BMMC00 "科室",SFXM01 "挂号数",SFXM02 "总费用",SFXM04 "次均费用",SFXM03 "药费",SFXM06 "次均药费",
rtrim(replace(to_char(SFXM05*100,'FM9999990.9')||' ','. ',''))||'%'  "药比",
rtrim(replace(to_char(SFXM17*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号同比",
rtrim(replace(to_char(SFXM18*100,'FM9999990.9')||' ','. ',''))||'%'  "费用同比",
rtrim(replace(to_char(SFXM19*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用同比",
rtrim(replace(to_char(SFXM27*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号环比",
rtrim(replace(to_char(SFXM28*100,'FM9999990.9')||' ','. ',''))||'%'  "费用环比",
rtrim(replace(to_char(SFXM29*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用环比" 
from BM_YYSFTJ where ID0000=:1 order by rowid

30      16:26:21  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1098733.000000
31      16:26:21  SQL Execute: ORACLE - select SJYSXM "付款方式",BMMC00 "科室",SFXM01 "挂号数",SFXM02 "总费用",SFXM04 "次均费用",SFXM03 "药费",SFXM06 "次均药费",
rtrim(replace(to_char(SFXM05*100,'FM9999990.9')||' ','. ',''))||'%'  "药比",
rtrim(replace(to_char(SFXM17*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号同比",
rtrim(replace(to_char(SFXM18*100,'FM9999990.9')||' ','. ',''))||'%'  "费用同比",
rtrim(replace(to_char(SFXM19*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用同比",
rtrim(replace(to_char(SFXM27*100,'FM9999990.9')||' ','. ',''))||'%'  "挂号环比",
rtrim(replace(to_char(SFXM28*100,'FM9999990.9')||' ','. ',''))||'%'  "费用环比",
rtrim(replace(to_char(SFXM29*100,'FM9999990.9')||' ','. ',''))||'%'  "次均费用环比" 
from BM_YYSFTJ where ID0000=? order by rowid

32      16:26:21  SQL Prepare: ORACLE - rollback

33      16:26:21  SQL Execute: ORACLE - rollback

34      16:26:21  SQL Data In: ORACLE - Rows affected = 0
35      16:26:21  SQL Prepare: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=:1 and ghksbh=:2

36      16:26:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476
37      16:26:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
38      16:26:22  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

39      16:26:22  SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=:1 and jzks00=:2

40      16:26:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 476
41      16:26:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20
42      16:26:22  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?