1 16:03:19 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 2 16:03:29 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 3 16:03:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13507055 4 16:03:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 5 16:03:38 SQL Execute: ORACLE - select nvl(max(A.YBGHH0),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghh000= ? and TRIM(A.YBGHH0)<>'0' and A.BRID00 = ? 6 16:03:39 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 7 16:03:49 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 8 16:03:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 9 16:03:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 10 16:03:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 11 16:03:54 SQL Execute: ORACLE - select SF_SF_YBBZBM(?,?,?) FSLX00 from dual 12 16:03:54 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 13 16:03: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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 14 16:04:09 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 15 16:04:19 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 16 16:04:19 SQL Execute: ORACLE - select YBLB00 from IC_YBBRLB where YBMC00 = '长乐分中心' 17 16:04:19 SQL Data In: ORACLE - Param = 1, Name = V_YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 18 16:04:19 SQL Data In: ORACLE - Param = 2, Name = V_YBKH00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = A40250293 19 16:04:19 SQL Data In: ORACLE - Param = 3, Name = V_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350126194410051810 20 16:04:19 SQL Data In: ORACLE - Param = 4, Name = V_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈智清 21 16:04:19 SQL Data In: ORACLE - Param = 5, Name = V_ZT0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 有效 22 16:04:19 SQL Execute: ORACLE - BEGIN "SP_IC_YBHMD0_COMMIT" (V_YBZXLB => :V_YBZXLB,V_YBKH00 => :V_YBKH00,V_YBID00 => :V_YBID00,V_XM0000 => :V_XM0000,V_ZT0000 => :V_ZT0000); END; 23 16:04:19 SQL Execute: ORACLE - Update sf_brxxb0 set ybghh0 = '10085084632',bxlb00='普通',dblb00='',dblbmc='' where GHH000 = '13507055' 24 16:04:19 SQL Data In: ORACLE - Rows affected = 1 25 16:04:19 SQL Execute: ORACLE - Commit 26 16:04:19 SQL Data In: ORACLE - Rows affected = 0 27 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 28 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 29 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 30 16:04:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 31 16:04:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200807 32 16:04:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 33 16:04:19 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 34 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 35 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYDBZJK 36 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 37 16:04:19 SQL Execute: ORACLE - select SF_SF_XTCS00_SFQYJK(?,?,?) FSDYLX from dual 38 16:04:19 SQL Execute: ORACLE - select SQ_SF_TEMP00_ID0000.nextval ID0000 from dual 39 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853200 40 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 41 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19272 42 16:04:19 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 43 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853200 44 16:04:19 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 45 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = bid 46 16:04:19 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 47 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 48 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 49 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 19 50 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 51 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 52 16:04:19 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 53 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 54 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 55 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:19 56 16:04:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 57 16:04:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 58 16:04:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 59 16:04:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 60 16:04:19 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11503057058176110101 61 16:04:19 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 62 16:04:19 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 63 16:04:19 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 盐酸曲美他嗪 64 16:04:19 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 65 16:04:19 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.040000 66 16:04:19 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 67 16:04:19 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.160000 68 16:04:19 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 69 16:04:19 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19272.000000 70 16:04:19 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19272.000000 71 16:04:19 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 72 16:04:19 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 35mg*30 73 16:04:19 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 60 74 16:04:19 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 75 16:04:19 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 35mg 76 16:04:19 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 77 16:04:19 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 78 16:04:19 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 79 16:04:19 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 80 16:04:19 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 81 16:04:19 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 82 16:04:19 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 83 16:04:19 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 84 16:04:19 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 60 85 16:04:19 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 86 16:04:19 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 87 16:04:19 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 88 16:04:19 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 89 16:04:19 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 90 16:04:19 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 16:04:19 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 16:04:19 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 93 16:04:19 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 94 16:04:19 SQL Data In: ORACLE - Rows affected = 1 95 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853201 96 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 97 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 18887 98 16:04:19 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 99 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853201 100 16:04:19 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 101 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = qd 102 16:04:19 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 103 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 104 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 105 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 106 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 107 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 108 16:04:19 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 109 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 110 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 111 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:19 112 16:04:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 113 16:04:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 114 16:04:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 115 16:04:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 116 16:04:19 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11001057007259830102 117 16:04:19 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 118 16:04:19 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 119 16:04:19 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 拜瑞妥 120 16:04:19 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 121 16:04:19 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.200000 122 16:04:19 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 123 16:04:19 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1211.000000 124 16:04:19 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 125 16:04:19 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18887.000000 126 16:04:19 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18887.000000 127 16:04:19 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 128 16:04:19 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 20mg*7 129 16:04:19 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 130 16:04:19 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 09 131 16:04:19 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 20mg 132 16:04:19 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 133 16:04:19 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 134 16:04:19 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 135 16:04:19 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 136 16:04:19 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 137 16:04:19 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 138 16:04:19 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 139 16:04:19 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 140 16:04:19 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 141 16:04:19 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 142 16:04:19 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 143 16:04:19 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 144 16:04:19 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 145 16:04:19 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 146 16:04:19 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 147 16:04:19 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 148 16:04:19 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 149 16:04:19 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 150 16:04:19 SQL Data In: ORACLE - Rows affected = 1 151 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853202 152 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 153 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19341 154 16:04:19 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 155 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853202 156 16:04:19 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 157 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = qn 158 16:04:19 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 159 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 160 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 161 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 162 16:04:19 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 163 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 164 16:04:19 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 165 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 166 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 167 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:19 168 16:04:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 169 16:04:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 170 16:04:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 171 16:04:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 172 16:04:19 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11507059007272910102 173 16:04:19 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 174 16:04:19 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 175 16:04:19 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 阿托伐他汀钙 176 16:04:19 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 177 16:04:19 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.860000 178 16:04:19 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 179 16:04:19 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.720000 180 16:04:19 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 181 16:04:19 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19341.000000 182 16:04:19 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19341.000000 183 16:04:19 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 184 16:04:19 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 20mg*14 185 16:04:19 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 186 16:04:19 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 99 187 16:04:19 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 20mg 188 16:04:19 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 189 16:04:19 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 190 16:04:19 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 191 16:04:19 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 192 16:04:19 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 193 16:04:19 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 194 16:04:19 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 195 16:04:19 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 196 16:04:19 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 197 16:04:19 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 198 16:04:19 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 199 16:04:19 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 200 16:04:19 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 201 16:04:19 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 202 16:04:19 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 203 16:04:19 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 204 16:04:19 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 205 16:04:19 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 206 16:04:19 SQL Data In: ORACLE - Rows affected = 1 207 16:04:19 SQL Execute: ORACLE - Commit 208 16:04:19 SQL Data In: ORACLE - Rows affected = 0 209 16:04:19 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 210 16:04:19 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 211 16:04:19 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 212 16:04:19 SQL Data In: ORACLE - Param = 4, Name = PJKLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 213 16:04:19 SQL Data In: ORACLE - Param = 5, Name = PYHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 214 16:04:19 SQL Data In: ORACLE - Param = 6, Name = PSYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 215 16:04:19 SQL Execute: ORACLE - BEGIN "SP_SF_YBJK00_YBYJS0" (PID0000 => :PID0000,PBRID00 => :PBRID00,PJZDH00 => :PJZDH00,PJKLX00 => :PJKLX00,PYHMSG0 => :PYHMSG0,PSYSMSG => :PSYSMSG); END; 216 16:04:19 SQL Execute: ORACLE - Commit 217 16:04:19 SQL Data In: ORACLE - Rows affected = 0 218 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13507055 219 16:04:19 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where ghh000= ? order by ghid00 desc 220 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 221 16:04:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 222 16:04:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 223 16:04:19 SQL Execute: ORACLE - select SF_SF_YBBZBM(?,?,?) FSLX00 from dual 224 16:04:19 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 225 16:04:19 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 226 16:04:19 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 227 16:04:19 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 228 16:04:19 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 229 16:04:19 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 230 16:04:19 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 231 16:04:19 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 232 16:04:19 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 233 16:04:19 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 234 16:04:19 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 235 16:04:19 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 236 16:04:19 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 237 16:04:19 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 238 16:04:19 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 239 16:04:19 SQL Data In: ORACLE - Param = 9, Name = as_CFLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 240 16:04:19 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_CFLSH0 => :as_CFLSH0); END; 241 16:04:19 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 242 16:04:19 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 243 16:04:19 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 244 16:04:19 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 长乐分中心 245 16:04:19 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 246 16:04:19 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471049.000000 247 16:04:19 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 248 16:04:19 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 249 16:04:19 SQL Data In: ORACLE - Param = 9, Name = as_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 250 16:04:19 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK02" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_TSBZBH => :as_TSBZBH); END; 251 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471051.000000 252 16:04:19 SQL Execute: ORACLE - select COUNT(*) NUM from BM_SFCFMX_TEMP00 where ID0000 = ? 253 16:04:19 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 2012420 and mzid00=29574586 254 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 255 16:04:19 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 256 16:04:19 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(2012420,13507055,0) YYKSBM from dual 257 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471051.000000 258 16:04:19 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 259 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471051.000000 260 16:04:19 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 261 16:04:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471051.000000 262 16:04:19 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 263 16:04:19 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 264 16:04:19 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 265 16:04:19 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 266 16:04:19 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 267 16:04:19 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 268 16:04:19 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 269 16:04:26 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 270 16:04:26 SQL Execute: ORACLE - select SF_SF_YBFYJS(1284.88,770.33,0,0,0,0,0,0,514.55,2012420,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1272.88,0,514.55,0,0,0,1284.88,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'000002000001','' ) zfje00 from dual 271 16:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 272 16:04:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 273 16:04:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 274 16:04:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 275 16:04:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200807 276 16:04:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 277 16:04:26 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 278 16:04:26 SQL Execute: ORACLE - RollBack 279 16:04:26 SQL Data In: ORACLE - Rows affected = 0 280 16:04:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 281 16:04:26 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 282 16:04:29 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 283 16:04:39 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 284 16:04:49 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 285 16:04: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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 286 16:05:02 SQL Execute: ORACLE - Commit 287 16:05:02 SQL Data In: ORACLE - Rows affected = 0 288 16:05:09 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 289 16:05:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 290 16:05:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13507055 291 16:05:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 292 16:05:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 293 16:05:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 294 16:05:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 295 16:05:19 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 296 16:05:19 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 297 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13507055 298 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 299 16:05:20 SQL Execute: ORACLE - select nvl(max(A.YBGHH0),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghh000= ? and TRIM(A.YBGHH0)<>'0' and A.BRID00 = ? 300 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 301 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 302 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 303 16:05:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 304 16:05:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200807 305 16:05:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 306 16:05:20 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 307 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 308 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYDBZJK 309 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 310 16:05:20 SQL Execute: ORACLE - select SF_SF_XTCS00_SFQYJK(?,?,?) FSDYLX from dual 311 16:05:20 SQL Execute: ORACLE - select SQ_SF_TEMP00_ID0000.nextval ID0000 from dual 312 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853200 313 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 314 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19272 315 16:05:20 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 316 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853200 317 16:05:20 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 318 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = bid 319 16:05:20 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 320 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 321 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 322 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 19 323 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 324 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 325 16:05:20 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 326 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 327 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 328 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:05:20 329 16:05:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 330 16:05:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 331 16:05:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 332 16:05:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 333 16:05:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11503057058176110101 334 16:05:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 335 16:05:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 336 16:05:20 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 盐酸曲美他嗪 337 16:05:20 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 338 16:05:20 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.040000 339 16:05:20 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 340 16:05:20 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 56.160000 341 16:05:20 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 342 16:05:20 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19272.000000 343 16:05:20 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19272.000000 344 16:05:20 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 345 16:05:20 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 35mg*30 346 16:05:20 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 60 347 16:05:20 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 348 16:05:20 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 35mg 349 16:05:20 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 350 16:05:20 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 351 16:05:20 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 352 16:05:20 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 353 16:05:20 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 354 16:05:20 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 355 16:05:20 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 356 16:05:20 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 357 16:05:20 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 60 358 16:05:20 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 359 16:05:20 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 360 16:05:20 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 361 16:05:20 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 362 16:05:20 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 363 16:05:20 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 364 16:05:20 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 365 16:05:20 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 366 16:05:20 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 367 16:05:20 SQL Data In: ORACLE - Rows affected = 1 368 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853201 369 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 370 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 18887 371 16:05:20 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 372 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853201 373 16:05:20 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 374 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = qd 375 16:05:20 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 376 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 377 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 378 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 379 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 380 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 381 16:05:20 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 382 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 383 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 384 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:05:20 385 16:05:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 386 16:05:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 387 16:05:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 388 16:05:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 389 16:05:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11001057007259830102 390 16:05:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 391 16:05:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 392 16:05:20 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 拜瑞妥 393 16:05:20 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 394 16:05:20 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 242.200000 395 16:05:20 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 396 16:05:20 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1211.000000 397 16:05:20 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 398 16:05:20 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18887.000000 399 16:05:20 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18887.000000 400 16:05:20 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 401 16:05:20 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 20mg*7 402 16:05:20 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 403 16:05:20 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 09 404 16:05:20 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 20mg 405 16:05:20 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 406 16:05:20 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 407 16:05:20 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 408 16:05:20 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 409 16:05:20 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 410 16:05:20 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 411 16:05:20 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 412 16:05:20 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 413 16:05:20 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 414 16:05:20 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 415 16:05:20 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 416 16:05:20 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 417 16:05:20 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 418 16:05:20 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 419 16:05:20 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 420 16:05:20 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 421 16:05:20 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 422 16:05:20 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 423 16:05:20 SQL Data In: ORACLE - Rows affected = 1 424 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853202 425 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70 426 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 19341 427 16:05:20 SQL Execute: ORACLE - select round(F.LSDJ00*Q.ZHL000/D.K2J000,4) LSDJ00 FROM BM_YD0000 D,YF_MZCFMX Q,YF_YPKCXX F WHERE F.YPNM00=D.YPNM00 and Q.YPNM00=D.YPNM00 and Q.CFID00=? and F.YFBMBH=? and F.YPNM00=? 428 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31853202 429 16:05:20 SQL Execute: ORACLE - select a.YYSJ00,a.YYSJDW,a.CSL000,a.JLDW00,a.PCMC00,a.ypdlbh,a.YPZSL0,a.CFDW00,a.YPYFMC,B.JXBH00,b.YPCZFL from yf_mzcfmx a,BM_YD0000 b where a.YPNM00=b.YPNM00 and a.CFID00=? 430 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = qn 431 16:05:20 SQL Execute: ORACLE - select YBPCBM from BM_PC0000 where PCMC00=? and rownum=1 432 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 口服 433 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPYF00 aa where YPYFMC=? and rownum=1 434 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 435 16:05:20 SQL Execute: ORACLE - select YBFSBM from BM_YPJX00 aa where JXBH00=? and rownum=1 436 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 437 16:05:20 SQL Execute: ORACLE - select YSZJHM from bm_ygbm00 where ZWXM00=? 438 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 439 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200814 440 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:05:20 441 16:05:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 442 16:05:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29574586.000000 443 16:05:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 444 16:05:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 445 16:05:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11507059007272910102 446 16:05:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 447 16:05:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 西药费 448 16:05:20 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 阿托伐他汀钙 449 16:05:20 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 450 16:05:20 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.860000 451 16:05:20 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 452 16:05:20 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.720000 453 16:05:20 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 郑天祥 454 16:05:20 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19341.000000 455 16:05:20 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19341.000000 456 16:05:20 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 457 16:05:20 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 20mg*14 458 16:05:20 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 459 16:05:20 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 99 460 16:05:20 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 20mg 461 16:05:20 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 462 16:05:20 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 463 16:05:20 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 464 16:05:20 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11990824 465 16:05:20 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 466 16:05:20 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = mg 467 16:05:20 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 468 16:05:20 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 469 16:05:20 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 470 16:05:20 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 471 16:05:20 SQL Data In: ORACLE - Param = 34, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 472 16:05:20 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 473 16:05:20 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 474 16:05:20 SQL Data In: ORACLE - Param = 37, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 475 16:05:20 SQL Data In: ORACLE - Param = 38, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 476 16:05:20 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 477 16:05:20 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 478 16:05:20 SQL Execute: ORACLE - insert into SF_YBFSMX( ID0000,MXID00,CZRQ00,CZSJ00,BRID00,GHID00,JZDH00,YJDJH0,XMBH00,SFYB00,FPXMMC, XMMC00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00,SFXMID,YPNM00,ZFBL00,XMGG00,YPTS00, YPPL00,YPYL00,YSZJHM,CFLSH0,CFBZ00,CFHAO0,JX0000,DCYYDW,QYZL00,QYZLDW,YLTS00, GYTJ00,YPCZFL,FPXMBH,FLAG00,GZHCID,SFFSHC,HCDBXM,JKLX00 ) values( ?,SQ_SF_YBFSMX_MXID00.nextval,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,? ) 479 16:05:20 SQL Data In: ORACLE - Rows affected = 1 480 16:05:20 SQL Execute: ORACLE - Commit 481 16:05:20 SQL Data In: ORACLE - Rows affected = 0 482 16:05:20 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 483 16:05:20 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 484 16:05:20 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 485 16:05:20 SQL Data In: ORACLE - Param = 4, Name = PJKLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 486 16:05:20 SQL Data In: ORACLE - Param = 5, Name = PYHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 487 16:05:20 SQL Data In: ORACLE - Param = 6, Name = PSYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 488 16:05:20 SQL Execute: ORACLE - BEGIN "SP_SF_YBJK00_YBYJS0" (PID0000 => :PID0000,PBRID00 => :PBRID00,PJZDH00 => :PJZDH00,PJKLX00 => :PJKLX00,PYHMSG0 => :PYHMSG0,PSYSMSG => :PSYSMSG); END; 489 16:05:20 SQL Execute: ORACLE - Commit 490 16:05:20 SQL Data In: ORACLE - Rows affected = 0 491 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13507055 492 16:05:20 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where ghh000= ? order by ghid00 desc 493 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 494 16:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 495 16:05:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 496 16:05:20 SQL Execute: ORACLE - select SF_SF_YBBZBM(?,?,?) FSLX00 from dual 497 16:05:20 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 498 16:05:20 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 499 16:05:20 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 500 16:05:20 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 501 16:05:20 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 502 16:05:20 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 503 16:05:20 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 504 16:05:20 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 505 16:05:20 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 506 16:05:20 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 507 16:05:20 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 508 16:05:20 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 509 16:05:20 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 510 16:05:20 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 511 16:05:20 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 512 16:05:20 SQL Data In: ORACLE - Param = 9, Name = as_CFLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 513 16:05:20 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_CFLSH0 => :as_CFLSH0); END; 514 16:05:20 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 515 16:05:20 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 516 16:05:20 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13507055 517 16:05:20 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 长乐分中心 518 16:05:20 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 519 16:05:20 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471062.000000 520 16:05:20 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 521 16:05:20 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 522 16:05:20 SQL Data In: ORACLE - Param = 9, Name = as_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000001 523 16:05:20 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK02" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_TSBZBH => :as_TSBZBH); END; 524 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471064.000000 525 16:05:20 SQL Execute: ORACLE - select COUNT(*) NUM from BM_SFCFMX_TEMP00 where ID0000 = ? 526 16:05:20 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 2012420 and mzid00=29574586 527 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2012420.000000 528 16:05:20 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 529 16:05:20 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(2012420,13507055,0) YYKSBM from dual 530 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471064.000000 531 16:05:20 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 532 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471064.000000 533 16:05:20 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 534 16:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8471064.000000 535 16:05:20 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 536 16:05:20 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 537 16:05:20 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 538 16:05:20 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 539 16:05:20 SQL Execute: ORACLE - Select * from SF_XMFSDY where MRFS00=1 order by PXXH00 540 16:05:20 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 541 16:05:29 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 542 16:05:39 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 543 16:05:49 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null) 544 16:05: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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',749,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =749 AND b.JSKSBH = '44') AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)