门诊收费平台
统计---收费员统计报表----收费人员工作量统计
这个很慢。


1       09:51:40  SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='MZSF_SFYGZLBBGS'

2       09:51:40  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='MZSF_SFYGZLBBGS'

3       09:51:58  SQL Prepare: ORACLE - BEGIN "SP_SF_BB_SFYGZLTJ" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
4       09:51:58  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120602
5       09:51:58  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
6       09:51:58  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120602
7       09:51:58  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
8       09:51:58  SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
9       09:51:58  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      09:51:58  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      09:51:58  SQL Execute: ORACLE - BEGIN "SP_SF_BB_SFYGZLTJ" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
12      10:16:15  SQL Prepare: ORACLE - select substr(GHRQ00,1,8) "收费员",XMHJ00 "合计金额",GHKS02 "发票项目数",GHKS03 "票据张数",GHKS04 "办卡量",GHKS05 "病历本数" from  BM_GHKSTJ where  ID0000 =:1 

13      10:16:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1177257.000000
14      10:16:15  SQL Execute: ORACLE - select substr(GHRQ00,1,8) "收费员",XMHJ00 "合计金额",GHKS02 "发票项目数",GHKS03 "票据张数",GHKS04 "办卡量",GHKS05 "病历本数" from  BM_GHKSTJ where  ID0000 =?