1 09:33:47 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',51,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',980,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =980 AND b.JSKSBH = '51') AND (INSTR (',' || a.jsksbh || ',',',51,') > 0 or a.jsksbh is null) 2 09:33:48 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 3 09:33:48 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 4 09:33:49 SQL Execute: ORACLE - Select SYSDATE from Dual 5 09:33:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 6 09:33:49 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT30120101728' and ICKNBH = 'PTYBPT30120101728' 7 09:33:49 SQL Execute: ORACLE - select * from VW_ZY_BRXX00 a where 1 = 1 8 09:33:49 SQL Execute: ORACLE - select * from VW_ZY_BRXX00 a where 1 = 1 and a.BRID00 in ( select BRID00 from IC_YHXX00 where ICKH00='PTYBPT30120101728' and ZT0000='1' ) order by CZRQ00 9 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 10 09:33:50 SQL Execute: ORACLE - select * from zy_brxxb0 where brid00=? and cyrq00 is null 11 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 12 09:33:50 SQL Execute: ORACLE - select max(ZYID00) ZYID00 from ZY_BRXXB0 where BRID00 = ? 13 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 809568 14 09:33:50 SQL Execute: ORACLE - select BRZT00 from ZY_BRXXB0 where ZYID00 = ? 15 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 16 09:33:50 SQL Execute: ORACLE - select B.BMMC00 BQMC00,C.BMMC00 KSMC00,A.CH0000,A.ZDMC00,a.ysgzh0,d.zwxm00,A.ZDM000 from ys_brzysq A, bm_bmbm00 B,bm_bmbm00 C,bm_ygbm00 d where A.BQH000 = B.BMBH00(+) and A.KSH000 = C.BMBH00(+) and a.YSGZH0=d.ygbh00(+) and A.BRID00 =? and A.SQRQ00 >='20220927' and jsbz00 = '0' and A.SQRQ00 <='20221027' 17 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 18 09:33:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 19 09:33:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 20 09:33:50 SQL Execute: ORACLE - select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual 21 09:33:50 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 =980 and SYBZ00 = 'Y' 22 09:33:50 SQL Execute: ORACLE - select * from VW_BM_BRFBB0 23 09:33:50 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by BH0000 24 09:33:50 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 25 09:33:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='新冠职业分类' order by XSXH00 26 09:33:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00 = '病人证件类型' and MC0000 = 'Y' and YXBZ00 = '1' order by XSXH00 27 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 980.000000 28 09:33:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 29 09:33:50 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 30 09:33:50 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB where 1=1 order BY QTLBBH 31 09:33:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 32 09:33:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 33 09:33:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 34 09:33:50 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 35 09:33:50 SQL Execute: ORACLE - select * from VW_BM_NEWYBJK_YBJKLX where SFYX00='1' and 1=1 order by XSXH00 36 09:33:50 SQL Execute: ORACLE - select * from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' order by VALUE0 37 09:33:50 SQL Execute: ORACLE - select VALUE0,nvl(JKDZMC,SXMC00)SXMC00 from BM_YBSXZD where JKBM00=1 and sxbm00='bke284' and SFYX00='1' and JKDZBM is not null order by VALUE0 38 09:33:50 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 39 09:33:50 SQL Execute: ORACLE - select * from vw_zy_brjflb where JFLBID <> 0 40 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 980.000000 41 09:33:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 42 09:33:50 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 43 09:33:50 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 and ZFFSBH not in (18,20,26) order by nvl(XSXH00,0),ZFFSBH 44 09:33:50 SQL Execute: ORACLE - select C.BMMC00 from BM_BMBM00 A, BM_BQKS00 B,BM_BMBM00 C where A.BMBH00 = B.BQH000 and B.KSH000 = C.BMBH00 and B.YXBZ00 = '1' and A.BMMC00 = '八病区' 45 09:33:50 SQL Execute: ORACLE - select * from vw_zy_cwk000 where BQMC00 = '八病区' 46 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 482 47 09:33:50 SQL Execute: ORACLE - select * from bm_bmbm00 where bmbh00 =? 48 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 488 49 09:33:50 SQL Execute: ORACLE - select * from bm_bmbm00 where bmbh00 =? 50 09:33:50 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 51 09:33:50 SQL Execute: ORACLE - select * from VW_ZY_BRXX00 where brid00 = 1571873 52 09:33:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 533022197812122019 53 09:33:50 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 54 09:33:50 SQL Execute: ORACLE - select max(ZYID00) ZYID00 from ZY_BRXXB0 A where brid00 =1571873 55 09:33:50 SQL Execute: ORACLE - select ZYH000,BRRYCS,BRZT00,ZYHBAK from ZY_BRXXB0 where ZYID00 = 809568 56 09:33:50 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 57 09:33:50 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 09:33:50 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 59 09:33:50 SQL Execute: ORACLE - select * from ZY_BRZHXX A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.BRID00 =1571873 and JFLBMC = '住院预交金' 60 09:33:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 61 09:33:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 62 09:33:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 63 09:33:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 64 09:33:55 SQL Execute: ORACLE - select SF_ZY_GETYWLSH0(?,?,?,?) AS FHXX00 from dual 65 09:33:59 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',51,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',980,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =980 AND b.JSKSBH = '51') AND (INSTR (',' || a.jsksbh || ',',',51,') > 0 or a.jsksbh is null) 66 09:34:00 SQL Execute: ORACLE - select SF_ZY_TSBRXXTS('533022197812122019','','0') MSG000 from dual 67 09:34:00 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 =980 and SYBZ00 = 'Y' 68 09:34:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 533022197812122019 69 09:34:00 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 70 09:34:00 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 71 09:34:00 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 413664 72 09:34:00 SQL Data In: ORACLE - Param = 3, Name = AS_ZYH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 413664 73 09:34:00 SQL Data In: ORACLE - Param = 4, Name = AS_YBZYH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 74 09:34:00 SQL Data In: ORACLE - Param = 5, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 胡学聪 75 09:34:00 SQL Data In: ORACLE - Param = 6, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 76 09:34:00 SQL Data In: ORACLE - Param = 7, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19781212 77 09:34:00 SQL Data In: ORACLE - Param = 8, Name = AD_FBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 78 09:34:00 SQL Data In: ORACLE - Param = 9, Name = AS_RYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20221027 79 09:34:00 SQL Data In: ORACLE - Param = 10, Name = AS_RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:31:00 80 09:34:00 SQL Data In: ORACLE - Param = 11, Name = AD_RYCZY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 980.000000 81 09:34:00 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘雪琼 82 09:34:00 SQL Data In: ORACLE - Param = 13, Name = AS_RYZD00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 83 09:34:00 SQL Data In: ORACLE - Param = 14, Name = AS_RYSQK0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 09:34:00 SQL Data In: ORACLE - Param = 15, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 85 09:34:00 SQL Data In: ORACLE - Param = 16, Name = AS_RYBQMC, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 八病区 86 09:34:00 SQL Data In: ORACLE - Param = 17, Name = AS_RZKSMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 住院呼吸内科 87 09:34:00 SQL Data In: ORACLE - Param = 18, Name = AS_RYCWH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 88 09:34:00 SQL Data In: ORACLE - Param = 19, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 89 09:34:00 SQL Data In: ORACLE - Param = 20, Name = AD_ZZYS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 90 09:34:00 SQL Data In: ORACLE - Param = 21, Name = AS_ZZYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 91 09:34:00 SQL Data In: ORACLE - Param = 22, Name = AD_ZRYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 92 09:34:00 SQL Data In: ORACLE - Param = 23, Name = AS_ZRYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 93 09:34:00 SQL Data In: ORACLE - Param = 24, Name = AD_SXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 94 09:34:00 SQL Data In: ORACLE - Param = 25, Name = AS_SXYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 95 09:34:00 SQL Data In: ORACLE - Param = 26, Name = AS_JFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 96 09:34:00 SQL Data In: ORACLE - Param = 27, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 住院预交金 97 09:34:00 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 98 09:34:00 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 99 09:34:00 SQL Data In: ORACLE - Param = 30, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 100 09:34:00 SQL Data In: ORACLE - Param = 31, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 101 09:34:00 SQL Data In: ORACLE - Param = 32, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 102 09:34:00 SQL Data In: ORACLE - Param = 33, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 103 09:34:00 SQL Data In: ORACLE - Param = 34, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 1014014198 104 09:34:00 SQL Data In: ORACLE - Param = 35, Name = AS_BRRYCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 105 09:34:00 SQL Data In: ORACLE - Param = 36, Name = AD_YZCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 106 09:34:00 SQL Data In: ORACLE - Param = 37, Name = AD_YZYBJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 107 09:34:00 SQL Data In: ORACLE - Param = 38, Name = AD_SZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 706.000000 108 09:34:00 SQL Data In: ORACLE - Param = 39, Name = AS_RYZDMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 109 09:34:00 SQL Data In: ORACLE - Param = 40, Name = AS_YBZFRY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 110 09:34:00 SQL Data In: ORACLE - Param = 41, Name = AD_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 111 09:34:00 SQL Data In: ORACLE - Param = 42, Name = AD_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国 112 09:34:00 SQL Data In: ORACLE - Param = 43, Name = AD_TBZX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 113 09:34:00 SQL Data In: ORACLE - Param = 44, Name = AD_ZJHM00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 533022197812122019 114 09:34:00 SQL Data In: ORACLE - Param = 45, Name = AD_DWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 115 09:34:00 SQL Data In: ORACLE - Param = 46, Name = AD_LXR000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 116 09:34:00 SQL Data In: ORACLE - Param = 47, Name = AD_BRLXDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15892059537 117 09:34:00 SQL Data In: ORACLE - Param = 48, Name = AD_BRJTDZ, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建省莆田市涵江区 118 09:34:00 SQL Data In: ORACLE - Param = 49, Name = AS_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 119 09:34:00 SQL Data In: ORACLE - Param = 50, Name = as_BRZTQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 120 09:34:00 SQL Data In: ORACLE - Param = 51, Name = ad_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 121 09:34:00 SQL Data In: ORACLE - Param = 52, Name = ad_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 122 09:34:00 SQL Data In: ORACLE - Param = 53, Name = as_YBLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 123 09:34:00 SQL Data In: ORACLE - Param = 54, Name = as_BRRYTJ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 124 09:34:00 SQL Data In: ORACLE - Param = 55, Name = as_BRZLLB, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 中西医 125 09:34:00 SQL Data In: ORACLE - Param = 56, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 126 09:34:00 SQL Data In: ORACLE - Param = 57, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 127 09:34:00 SQL Data In: ORACLE - Param = 58, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 09:34:00 SQL Data In: ORACLE - Param = 59, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 129 09:34:00 SQL Data In: ORACLE - Param = 60, Name = ad_ZJXXLY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 09:34:00 SQL Data In: ORACLE - Param = 61, Name = as_GZDWDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 09:34:00 SQL Data In: ORACLE - Param = 62, Name = as_BRGRDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 132 09:34:00 SQL Data In: ORACLE - Param = 63, Name = as_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 133 09:34:00 SQL Data In: ORACLE - Param = 64, Name = as_RYDJRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 134 09:34:00 SQL Data In: ORACLE - Param = 65, Name = as_RYDJSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 135 09:34:00 SQL Data In: ORACLE - Param = 66, Name = as_RJSSBL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 136 09:34:00 SQL Data In: ORACLE - Param = 67, Name = as_JDCZFL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 137 09:34:00 SQL Data In: ORACLE - Param = 68, Name = as_YBJKID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 138 09:34:00 SQL Data In: ORACLE - Param = 69, Name = ad_BRSJHM, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15892059537 139 09:34:00 SQL Data In: ORACLE - Param = 70, Name = as_ZYFL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 140 09:34:00 SQL Data In: ORACLE - Param = 71, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 09:34:00 SQL Data In: ORACLE - Param = 72, Name = as_SFYLJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 142 09:34:00 SQL Data In: ORACLE - Param = 73, Name = as_YBTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 143 09:34:00 SQL Data In: ORACLE - Param = 74, Name = as_XMLSTR, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 144 09:34:00 SQL Data In: ORACLE - Param = 75, Name = as_YBRYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 145 09:34:00 SQL Execute: ORACLE - BEGIN "SP_ZY_BRRYDJ" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_ZYH000 => :AS_ZYH000,AS_YBZYH0 => :AS_YBZYH0,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AD_FBBH00 => :AD_FBBH00,AS_RYRQ00 => :AS_RYRQ00,AS_RYSJ00 => :AS_RYSJ00,AD_RYCZY0 => :AD_RYCZY0,AS_CZYXM0 => :AS_CZYXM0,AS_RYZD00 => :AS_RYZD00,AS_RYSQK0 => :AS_RYSQK0,AS_RYLB00 => :AS_RYLB00,AS_RYBQMC => :AS_RYBQMC,AS_RZKSMC => :AS_RZKSMC,AS_RYCWH0 => :AS_RYCWH0,AS_BRZT00 => :AS_BRZT00,AD_ZZYS00 => :AD_ZZYS00,AS_ZZYSXM => :AS_ZZYSXM,AD_ZRYS00 => :AD_ZRYS00,AS_ZRYSXM => :AS_ZRYSXM,AD_SXYS00 => :AD_SXYS00,AS_SXYSXM => :AS_SXYSXM,AS_JFBZ00 => :AS_JFBZ00,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_BRRYCS => :AS_BRRYCS,AD_YZCS00 => :AD_YZCS00,AD_YZYBJE => :AD_YZYBJE,AD_SZYS00 => :AD_SZYS00,AS_RYZDMC => :AS_RYZDMC,AS_YBZFRY => :AS_YBZFRY,AD_BRMZ00 => :AD_BRMZ00,AD_BRGJ00 => :AD_BRGJ00,AD_TBZX00 => :AD_TBZX00,AD_ZJHM00 => :AD_ZJHM00,AD_DWMC00 => :AD_DWMC00,AD_LXR000 => :AD_LXR000,AD_BRLXDH => :AD_BRLXDH,AD_BRJTDZ => :AD_BRJTDZ,AS_GSDJH0 => :AS_GSDJH0,as_BRZTQK => :as_BRZTQK,ad_DBLB00 => :ad_DBLB00,ad_DBLBMC => :ad_DBLBMC,as_YBLB00 => :as_YBLB00,as_BRRYTJ => :as_BRRYTJ,as_BRZLLB => :as_BRZLLB,AD_ZYID00 => :AD_ZYID00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_ZJXXLY => :ad_ZJXXLY,as_GZDWDH => :as_GZDWDH,as_BRGRDH => :as_BRGRDH,as_SFJZFP => :as_SFJZFP,as_RYDJRQ => :as_RYDJRQ,as_RYDJSJ => :as_RYDJSJ,as_RJSSBL => :as_RJSSBL,as_JDCZFL => :as_JDCZFL,as_YBJKID => :as_YBJKID,ad_BRSJHM => :ad_BRSJHM,as_ZYFL00 => :as_ZYFL00,as_ZYZFL0 => :as_ZYZFL0,as_SFYLJZ => :as_SFYLJZ,as_YBTYPE => :as_YBTYPE,as_XMLSTR => :as_XMLSTR,as_YBRYID => :as_YBRYID); END; 146 09:34:00 SQL Execute: ORACLE - select DYBZBM, DYJBMC from XT_ICD900 where ICD900 = 'R51.x00' 147 09:34:00 SQL Execute: ORACLE - select SQ_BQ_BRZDXX_ID0000.NextVal from dual 148 09:34:00 SQL Execute: ORACLE - insert into BQ_BRZDXX(ID0000,BRID00,ZYID00,ZDLB00,ZDM000,ZDMC00,ZDRQ00,ZDSJ00,SFYZ00,ZLXG00,LRR000,YQBGBZ,BZ0000,GJBZBM,GJBZMC,CJRQ00,CJSJ00) values(1166159,1571873,809569,'2','R51.x00','头痛', '20221027','09:31:00','0','2', 980,'2','入院登记时填写', 'R51.x00', '头痛', to_char(sysdate,'yyyymmdd'), to_char(sysdate,'HH24:MI:SS') ) 149 09:34:00 SQL Data In: ORACLE - Rows affected = 1 150 09:34:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 809569.000000 151 09:34:00 SQL Execute: ORACLE - select * from zy_brxxb0 where zyid00 =? 152 09:34:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 533022197812122019 153 09:34:00 SQL Execute: ORACLE - select count(1) num from BM_MZJZBR where BRSFZH = ? 154 09:34:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 413664 155 09:34:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1571873.000000 156 09:34:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 胡学聪 157 09:34:00 SQL Execute: ORACLE - select count(*) count from ZY_BRXXB0 where ZYH000 =? and BRID00<>? and XM0000<>? 158 09:34:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 159 09:34:00 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 160 09:34:00 SQL Execute: ORACLE - Commit 161 09:34:00 SQL Data In: ORACLE - Rows affected = 0 162 09:34:11 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',51,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',980,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =980 AND b.JSKSBH = '51') AND (INSTR (',' || a.jsksbh || ',',',51,') > 0 or a.jsksbh is null) 163 09:34:23 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',51,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',980,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =980 AND b.JSKSBH = '51') AND (INSTR (',' || a.jsksbh || ',',',51,') > 0 or a.jsksbh is null) 164 09:35:07 SQL Execute: ORACLE - select TXNR00 from BM_HMDML0 where SFZH00='533022197812122019' 165 09:35:07 SQL Execute: ORACLE - Commit 166 09:35:07 SQL Data In: ORACLE - Rows affected = 0