1 11:23:02 Log started for: 门诊挂号收费管理系统 2 11:23:07 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 4 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 5 11:23:07 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 6 11:23:07 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 7 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 8 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 9 11:23:07 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 10 11:23:07 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 11 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 12 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 13 11:23:07 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 14 11:23:07 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 15 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 16 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 17 11:23:07 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 18 11:23:07 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 19 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 20 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 21 11:23:07 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 22 11:23:07 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 23 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 24 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 25 11:23:07 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 26 11:23:07 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 27 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 28 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 29 11:23:07 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 30 11:23:07 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 31 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 32 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 33 11:23:07 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 34 11:23:07 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 35 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 36 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 37 11:23:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 38 11:23:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 39 11:23:07 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 40 11:23:07 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 41 11:23:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 42 11:23:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 43 11:23:07 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 44 11:23:13 SQL Prepare: ORACLE - SELECT k.*,(SELECT rs0000 FROM (SELECT COUNT (DISTINCT ghid00) rs0000, dwid00 FROM (SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m, yj_ywjj00 n,tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00cxk f, sf_fymx00cxk h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 <= '20131231' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00 union all SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m,yj_ywjj00 n, tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00 f, sf_fymx00 h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 >= '20140101' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00) WHERE zje000 <> '0' GROUP BY dwid00) WHERE dwid00 = k.dwid00) rs0000 FROM (SELECT (SELECT dwid00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwid00, brid00,(SELECT dwmc00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwmc00, SUM (zhze00), SUM (zqze00), SUM (zkze00) FROM (SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00,(DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 )) zkze00 FROM sf_brfy00 a, sf_fymx00 b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 >= '20140101' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' union all SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 ) ) zkze00 FROM sf_brfy00cxk a, sf_fymx00cxk b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 <= '20131231' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' ) a GROUP BY brid00) k 45 11:23:13 SQL Execute: ORACLE - SELECT k.*,(SELECT rs0000 FROM (SELECT COUNT (DISTINCT ghid00) rs0000, dwid00 FROM (SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m, yj_ywjj00 n,tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00cxk f, sf_fymx00cxk h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 <= '20131231' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00 union all SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m,yj_ywjj00 n, tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00 f, sf_fymx00 h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 >= '20140101' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00) WHERE zje000 <> '0' GROUP BY dwid00) WHERE dwid00 = k.dwid00) rs0000 FROM (SELECT (SELECT dwid00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwid00, brid00,(SELECT dwmc00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwmc00, SUM (zhze00), SUM (zqze00), SUM (zkze00) FROM (SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00,(DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 )) zkze00 FROM sf_brfy00 a, sf_fymx00 b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 >= '20140101' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' union all SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 ) ) zkze00 FROM sf_brfy00cxk a, sf_fymx00cxk b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 <= '20131231' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' ) a GROUP BY brid00) k 46 11:23:56 SQL Prepare: ORACLE - SELECT k.*,(SELECT rs0000 FROM (SELECT COUNT (DISTINCT ghid00) rs0000, dwid00 FROM (SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m, yj_ywjj00 n,tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00cxk f, sf_fymx00cxk h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 <= '20131231' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00 union all SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m,yj_ywjj00 n, tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00 f, sf_fymx00 h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 >= '20140101' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00) WHERE zje000 <> '0' GROUP BY dwid00) WHERE dwid00 = k.dwid00) rs0000 FROM (SELECT (SELECT dwid00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwid00, brid00,(SELECT dwmc00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwmc00, SUM (zhze00), SUM (zqze00), SUM (zkze00) FROM (SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00,(DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 )) zkze00 FROM sf_brfy00 a, sf_fymx00 b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 >= '20140101' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' union all SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 ) ) zkze00 FROM sf_brfy00cxk a, sf_fymx00cxk b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 <= '20131231' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' ) a GROUP BY brid00) k 47 11:23:56 SQL Execute: ORACLE - SELECT k.*,(SELECT rs0000 FROM (SELECT COUNT (DISTINCT ghid00) rs0000, dwid00 FROM (SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m, yj_ywjj00 n,tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00cxk f, sf_fymx00cxk h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 <= '20131231' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00 union all SELECT SUM (m.zje000) zje000, m.ghid00, p.dwid00 FROM tj_yjdjh0 m,yj_ywjj00 n, tj_brxxb0 o, bm_tydwb0 p WHERE m.yjdjh0 = n.yjdjh0 AND o.dwid00 = p.dwid00 AND EXISTS ( SELECT 1 FROM sf_brfy00 f, sf_fymx00 h WHERE f.djh000 = h.djh000 AND f.brid00 = p.brid00 AND h.yjdjh0 = m.yjdjh0 AND f.czrq00 >= '20140101' AND f.jzdh00 IN ( SELECT jzdh00 FROM sf_tjjzb0 s WHERE s.mzid00 = f.mzid00 AND s.jzrq00 >= '20150201' AND s.jzrq00 <= '20150228')) AND o.dwid00 = m.dwid00 AND m.ghid00 = o.ghid00 AND (NOT EXISTS (SELECT 'y' FROM tj_yjdjh0 t WHERE t.cxdjh0 = m.yjdjh0)) AND ((m.cxdjh0 = 0) OR (m.cxdjh0 IS NULL)) GROUP BY m.ghid00, p.dwid00) WHERE zje000 <> '0' GROUP BY dwid00) WHERE dwid00 = k.dwid00) rs0000 FROM (SELECT (SELECT dwid00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwid00, brid00,(SELECT dwmc00 FROM bm_tydwb0 WHERE brid00 = a.brid00) dwmc00, SUM (zhze00), SUM (zqze00), SUM (zkze00) FROM (SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00,(DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 )) zkze00 FROM sf_brfy00 a, sf_fymx00 b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 >= '20140101' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' union all SELECT a.brid00, b.hjje00 zhze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', 0, b.hjje00 ) ) zqze00, (DECODE (SUBSTR (TRIM (b.beizhu), 2, 4), 'DWZK', b.hjje00, 0 ) ) zkze00 FROM sf_brfy00cxk a, sf_fymx00cxk b, sf_tjjzb0 c WHERE a.djh000 = b.djh000 AND a.jzdh00 <> 0 AND a.jzdh00 = c.jzdh00 AND a.mzid00 = c.mzid00 AND a.czrq00 <= '20131231' AND c.jzrq00 >= '20150201' AND c.jzrq00 <= '20150228' ) a GROUP BY brid00) k