1       15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = SF_MZFYJSTCFD
2       15:54:47  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

3       15:54:47  SQL Execute: ORACLE - select NVL(max(YYID00),'0') YYID00  from  BM_JKB000  where  JKDH00 in (71891) 

4       15:54:47  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'XT_SFQYBRAFYFKCZMS' 

5       15:54:47  SQL Execute: ORACLE - select trim(MC0000) from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'SFYJZDSFGLDZFPJL_MZ' and rownum = 1

6       15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
7       15:54:47  SQL Execute: ORACLE - select * from VW_SF_JKB001 where JKDH00 =? and PJBH00 = 1 

8       15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
9       15:54:47  SQL Execute: ORACLE - select * from VW_SF_JKB001 where JKDH00 =? and PJBH00 = 7 

10      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
11      15:54:47  SQL Execute: ORACLE - select * from VW_SF_JKB001 where JKDH00 =? and PJBH00 = 2 

12      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
13      15:54:47  SQL Execute: ORACLE - select * from VW_SF_ZLKJS0 where JKDH00 =? 

14      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
15      15:54:47  SQL Execute: ORACLE - select XMMC00, sum(XMJE00) XMJE00, sum(QZFJE0) QZFJE0 from VW_SF_PJSYMX a where JKDH00 =? group by XMBH00, XMMC00

16      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
17      15:54:47  SQL Execute: ORACLE - select * from VW_SF_SKHZ00 where JKDH00 =? order by PXFS00

18      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
19      15:54:47  SQL Execute: ORACLE - select * from VW_SF_CXFPXH where JKDH00 =? 

20      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
21      15:54:47  SQL Execute: ORACLE - select * from VW_SF_ZFFPXH where JKDH00 =? 

22      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
23      15:54:47  SQL Execute: ORACLE - select a.* from VW_SF_ZFYJXH a where JKDH00 =? 

24      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
25      15:54:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
26      15:54:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227769
27      15:54:47  SQL Execute: ORACLE - select * from VW_SF_JKTK00 where JKDH00 =? and (? <> '1' or YYID00 = ?) 

28      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
29      15:54:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
30      15:54:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227769
31      15:54:47  SQL Execute: ORACLE - select * from VW_SF_JKHK00 where JKDH00 =? and (? <> '1' or YYID00 = ?) 

32      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
33      15:54:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
34      15:54:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227769
35      15:54:47  SQL Execute: ORACLE - select YBMC00, sum(ZFJE00) ZFJE00, sum(GRZHZF) GRZHZF, sum(TCJJZF) TCJJZF, sum(HJJE00) HJJE00, sum(SYBXJE) SYBXJE, sum(MZBZJE) MZBZJE from VW_SF_JKJSSR_FB where JKDH00 =? and (? <> '1' or YYID00 = ?) group by YBMC00 

36      15:54:47  SQL Execute: ORACLE - select '2022-04-22 00:00:00至2022-04-22 23:59:59' as JKSJD0 from dual

37      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
38      15:54:47  SQL Execute: ORACLE - select sum(decode(a.JFBZ00, '0', a.JFJE00, 0)) HJJKJE,sum(decode(a.JFBZ00,'1', a.JFJE00, 0)) HJTKJE from VW_SF_CWJFB0_JZD a where a.JKBID0=?

39      15:54:47  SQL Execute: ORACLE - select a.* from VW_SF_DZFPJZHZXX a where JKDH00 in (71891) 

40      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
41      15:54:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
42      15:54:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
43      15:54:47  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
44      15:54:47  SQL Execute: ORACLE - select (select count(*) from VW_SF_CXFPXH where JKDH00 =?  ) CXPJZS, (select count(*) from VW_SF_ZFFPXH where JKDH00 =? ) ZFPJZS, (select count(*) from VW_SF_ZFFPXH where JKDID0 =? ) JKZFPJZS, (select count(*) from VW_SF_ZFYJXH where JKDH00 =? ) YJZFZS from dual 

45      15:54:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71891
46      15:54:47  SQL Execute: ORACLE - select * from VW_SF_ZFFPXH where JKDID0 =? 

47      15:54:47  SQL Execute: ORACLE - select 857 as UserId,'9999' as UserCode,'管理员' as UserName,193 as UserLogDepId,'门诊收费处' as UserLogDepName, '4' as UserLogSysCode,'门诊收费管理系统' as UserLogSysName,'227769' as HospitalCode,'南平市建阳第一医院' as HospitalName, '227769' as UserLogDepYYID,'南平市建阳第一医院' as UserLogDepYYMC  from dual 

48      15:54:47  SQL Execute: ORACLE - rollback

49      15:54:47  SQL Data In: ORACLE - Rows affected = 0