1 15:45:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 2 15:45:45 SQL Execute: ORACLE - select CFZT00,YZYZM0,SRRQ00,CFLSH0 from YF_MZCF00 where CFLSH0=? 3 15:45:45 SQL Execute: ORACLE - select count(1) from YS_CFXXB0 where BRID00=3448321 and to_number(CFLSH0)to_number('13982467') and YPDLBH in ('2') and CFXZ00='0' and rownum=1 4 15:45:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 5 15:45:45 SQL Execute: ORACLE - SELECT TSBZBH from YS_CFXXB0 where CFLSH0=? 6 15:45:45 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YS_BYXXZDJYF' 7 15:45:45 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='13614827' and LBBH00='0' 8 15:45:45 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3448321' and ZT0000='1' 9 15:45:45 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='3448321' and ZT0000='1' 10 15:45:45 SQL Execute: ORACLE - Select SYSDATE from Dual 11 15:45:45 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 12 15:45:45 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') 13 15:45:46 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 14 15:45:47 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA74214960' and ICKNBH = 'FZYBA74214960' 15 15:45:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3242 16 15:45:47 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 17 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3242 and SJKCSL>0 18 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=269 and SJKCSL>0 19 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=44142 and SJKCSL>0 20 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1269 and SJKCSL>0 21 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1253 and SJKCSL>0 22 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3780 and SJKCSL>0 23 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=305 and SJKCSL>0 24 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=813 and SJKCSL>0 25 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3837 and SJKCSL>0 26 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=888 and SJKCSL>0 27 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=47510 and SJKCSL>0 28 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=37380 and SJKCSL>0 29 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=4184 and SJKCSL>0 30 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=906 and SJKCSL>0 31 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3907 and SJKCSL>0 32 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1101 and SJKCSL>0 33 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3306 and SJKCSL>0 34 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1792 and SJKCSL>0 35 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=884 and SJKCSL>0 36 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=816 and SJKCSL>0 37 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=5001 and SJKCSL>0 38 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1231 and SJKCSL>0 39 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=3982 and SJKCSL>0 40 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=1637 and SJKCSL>0 41 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=856 and SJKCSL>0 42 15:45:47 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=672 and YPNM00=190 and SJKCSL>0 43 15:45:47 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3242 and MZZYBZ in('0','2') 44 15:45:47 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=269 and MZZYBZ in('0','2') 45 15:45:47 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=44142 and MZZYBZ in('0','2') 46 15:45:47 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1269 and MZZYBZ in('0','2') 47 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1253 and MZZYBZ in('0','2') 48 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3780 and MZZYBZ in('0','2') 49 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=305 and MZZYBZ in('0','2') 50 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=813 and MZZYBZ in('0','2') 51 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3837 and MZZYBZ in('0','2') 52 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=888 and MZZYBZ in('0','2') 53 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=47510 and MZZYBZ in('0','2') 54 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=37380 and MZZYBZ in('0','2') 55 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=4184 and MZZYBZ in('0','2') 56 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=906 and MZZYBZ in('0','2') 57 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3907 and MZZYBZ in('0','2') 58 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1101 and MZZYBZ in('0','2') 59 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3306 and MZZYBZ in('0','2') 60 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1792 and MZZYBZ in('0','2') 61 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=884 and MZZYBZ in('0','2') 62 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=816 and MZZYBZ in('0','2') 63 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=5001 and MZZYBZ in('0','2') 64 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1231 and MZZYBZ in('0','2') 65 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=3982 and MZZYBZ in('0','2') 66 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=1637 and MZZYBZ in('0','2') 67 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=856 and MZZYBZ in('0','2') 68 15:45:48 SQL Execute: ORACLE - select count(*) counter from BM_ZKYYKZ where SFXM00='0' and ypnm00=190 and MZZYBZ in('0','2') 69 15:45:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 70 15:45:48 SQL Execute: ORACLE - select BCCFH0 from YF_MZCF00 where CFLSH0=? 71 15:45:48 SQL Execute: ORACLE - delete from YF_MZCFMX where CFLSH0='13982467' 72 15:45:48 SQL Data In: ORACLE - Rows affected = 26 73 15:45:48 SQL Execute: ORACLE - delete from YF_MZCF00 where CFLSH0= '13982467' 74 15:45:48 SQL Data In: ORACLE - Rows affected = 1 75 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3242 76 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=269 77 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=44142 78 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1269 79 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1253 80 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3780 81 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=305 82 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=813 83 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3837 84 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=888 85 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=47510 86 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=37380 87 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=4184 88 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=906 89 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3907 90 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1101 91 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3306 92 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1792 93 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=884 94 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=816 95 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=5001 96 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1231 97 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=3982 98 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=1637 99 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=856 100 15:45:48 SQL Execute: ORACLE - select b.YPMC00, b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00 from BM_YD0000 b where YPNM00=190 101 15:45:48 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='13982467' and cfid00 not in (-1,49148178,49148179,49148180,49148181,49148182,49148183,49148184,49148185,49148186,49148187,49148188,49148189,49148190,49148191,49148192,49148193,49148194,49148195,49148196,49148197,49148198,49148199,49148200,49148201,49148202,49148203) 102 15:45:48 SQL Data In: ORACLE - Rows affected = 0 103 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3242',YPMC00 = '刀豆壳',YPGG00 = '散 ',LSDJ00 = '0.02',YFID00 = '40',PCID00 = '',CSL000 = '15',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '45',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148178 104 15:45:48 SQL Data In: ORACLE - Rows affected = 1 105 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '269',YPMC00 = '麸炒白术',YPGG00 = '散',LSDJ00 = '0.1187',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148179 106 15:45:48 SQL Data In: ORACLE - Rows affected = 1 107 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '44142',YPMC00 = '大腹皮',YPGG00 = '散',LSDJ00 = '0.05',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148180 108 15:45:48 SQL Data In: ORACLE - Rows affected = 1 109 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1269',YPMC00 = '地肤子',YPGG00 = '15g',LSDJ00 = '0.1225',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '布包',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148181 110 15:45:48 SQL Data In: ORACLE - Rows affected = 1 111 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1253',YPMC00 = '冬瓜皮',YPGG00 = '散',LSDJ00 = '0.0275',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148182 112 15:45:48 SQL Data In: ORACLE - Rows affected = 1 113 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3780',YPMC00 = '煅石膏',YPGG00 = '散',LSDJ00 = '0.0088',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148183 114 15:45:48 SQL Data In: ORACLE - Rows affected = 1 115 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '305',YPMC00 = '法半夏',YPGG00 = '散',LSDJ00 = '0.2762',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148184 116 15:45:48 SQL Data In: ORACLE - Rows affected = 1 117 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '813',YPMC00 = '藁本',YPGG00 = '散',LSDJ00 = '0.2125',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148185 118 15:45:48 SQL Data In: ORACLE - Rows affected = 1 119 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3837',YPMC00 = '公丁香',YPGG00 = '散',LSDJ00 = '0.2188',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148186 120 15:45:48 SQL Data In: ORACLE - Rows affected = 1 121 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '888',YPMC00 = '合欢皮',YPGG00 = '散',LSDJ00 = '0.0312',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148187 122 15:45:48 SQL Data In: ORACLE - Rows affected = 1 123 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '47510',YPMC00 = '葛根',YPGG00 = '散',LSDJ00 = '0.0612',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148188 124 15:45:48 SQL Data In: ORACLE - Rows affected = 1 125 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '37380',YPMC00 = '禹白附',YPGG00 = '散',LSDJ00 = '0.15',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '经验用药',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148189 126 15:45:48 SQL Data In: ORACLE - Rows affected = 1 127 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '4184',YPMC00 = '广化皮',YPGG00 = '散',LSDJ00 = '0.05',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148190 128 15:45:48 SQL Data In: ORACLE - Rows affected = 1 129 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '906',YPMC00 = '黄柏',YPGG00 = '散',LSDJ00 = '0.075',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148191 130 15:45:48 SQL Data In: ORACLE - Rows affected = 1 131 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3907',YPMC00 = '红藤',YPGG00 = '散',LSDJ00 = '0.0563',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148192 132 15:45:48 SQL Data In: ORACLE - Rows affected = 1 133 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1101',YPMC00 = '蒲黄',YPGG00 = '散',LSDJ00 = '0.225',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '布包',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148193 134 15:45:48 SQL Data In: ORACLE - Rows affected = 1 135 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3306',YPMC00 = '银柴胡',YPGG00 = '散',LSDJ00 = '0.2762',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148194 136 15:45:48 SQL Data In: ORACLE - Rows affected = 1 137 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1792',YPMC00 = '僵蚕',YPGG00 = '散',LSDJ00 = '0.3063',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148195 138 15:45:48 SQL Data In: ORACLE - Rows affected = 1 139 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '884',YPMC00 = '肉桂',YPGG00 = '散',LSDJ00 = '0.1125',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '经验用药',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148196 140 15:45:48 SQL Data In: ORACLE - Rows affected = 1 141 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '816',YPMC00 = '藕节',YPGG00 = '散',LSDJ00 = '0.0563',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148197 142 15:45:48 SQL Data In: ORACLE - Rows affected = 1 143 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '5001',YPMC00 = '鸦胆子',YPGG00 = '散',LSDJ00 = '0.1275',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '经验用药',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148198 144 15:45:48 SQL Data In: ORACLE - Rows affected = 1 145 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1231',YPMC00 = '黑豆',YPGG00 = '散',LSDJ00 = '0.05',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148199 146 15:45:48 SQL Data In: ORACLE - Rows affected = 1 147 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '3982',YPMC00 = '盐杜仲',YPGG00 = '散',LSDJ00 = '0.065',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148200 148 15:45:48 SQL Data In: ORACLE - Rows affected = 1 149 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '1637',YPMC00 = '卤地菊',YPGG00 = '散',LSDJ00 = '0.0366',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148201 150 15:45:48 SQL Data In: ORACLE - Rows affected = 1 151 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '856',YPMC00 = '忍冬藤',YPGG00 = '散',LSDJ00 = '0.0262',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148202 152 15:45:48 SQL Data In: ORACLE - Rows affected = 1 153 15:45:48 SQL Execute: ORACLE - update YS_CFMX00 set YPNM00 = '190',YPMC00 = '山慈菇',YPGG00 = '散',LSDJ00 = '0.875',YFID00 = '40',PCID00 = '',CSL000 = '11',JLDW00 = 'g',ZJYFID = '40',XMYFMC = '',YYZF00 = '',SFZBY0 = 'N',YPZSL0 = '33',CFDW00 = '克',ZHL000 = '1',ZFBL00 = '0',YBLB00 = '5',TSYS00 = '',CQLY00 = '',THBZ00 = '0',ZFFSBZ = 'N' where CFID00 = 49148203 154 15:45:48 SQL Data In: ORACLE - Rows affected = 1 155 15:45:48 SQL Execute: ORACLE - Update ys_cfxxb0 set YFBMBH='672',BRXM00='林昀',XB0000='女',BRLB00='3',YSGZH0='2094',SSKS00='700',GHKS00='854',ZYTS00='3',ZYDJS0='0',ZYMRCS=2,BZID00=0,CZY000='2094',SRRQ00=to_char(sysdate,'yyyymmdd'),SRSJ00=to_char(sysdate,'hh24:mi:ss'),CFZJE0=120.2,BRDZ00=null ,TSBZBH='',ZYSFJJ='N', ZYSFNJ='N',ZYNJJL='400',ZJZFID='44',ZYMRJS=1,TSYS00=-1,DYCJSL='0',DYCJQL='0',DECJSL='0',DECJQL='0',YBSSSH='0',YZYZM0='',YPXZ00='' where CFLSH0='13982467' 156 15:45:48 SQL Data In: ORACLE - Rows affected = 1 157 15:45:48 SQL Execute: ORACLE - select distinct c.LBBH00 from YS_CFXXB0 a,YS_CFMX00 b,BM_YD0000 c where a.CFLSH0='13982467' and a.CFLSH0=b.CFLSH0 and b.YPNM00=c.YPNM00 and c.LBBH00='0' and not exists(select 1 from YS_BRZDXX d where d.GHH000=a.GHH000 and d.GHID00=a.GHID00 and d.SFXYZD='1' ) union select distinct c.LBBH00 from YS_CFXXB0 a,YS_CFMX00 b,BM_YD0000 c where a.CFLSH0='13982467' and a.CFLSH0=b.CFLSH0 and b.YPNM00=c.YPNM00 and c.LBBH00 in ('1','2') and not exists(select 1 from YS_BRZDXX d where d.GHH000=a.GHH000 and d.GHID00=a.GHID00 and d.SFXYZD='0' ) 158 15:45:49 SQL Execute: ORACLE - select SQ_YS_CFSHRZ_ID0000.NEXTVAL from dual 159 15:45:49 SQL Execute: ORACLE - select MC0000,BZ0000,BH0000 from BM_TYZD00 where ZDMC00='合理用药' AND YXBZ00='1' and BZ0000='医院代码' order by XSXH00 160 15:45:49 SQL Execute: ORACLE - select GHID00,BRID00,BRXM00,XB0000,CFZJE0,ZYTS00,SRRQ00,SRSJ00,YPDLBH,(select c.LBMC00 from SF_BRXXB0 b,BM_GHLBB0 c where b.GHID00=a.GHID00 and b.LBBH00=c.LBBH00) GHLBMC ,GHKS00,YSGZH0, (select BMMC00 from BM_BMBM00 where BMBH00=a.GHKS00) JZKSMC from YS_CFXXB0 a where CFLSH0='0' 161 15:45:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 162 15:45:49 SQL Execute: ORACLE - select (select YSLBMC from bm_yslb00 where YSLB00=a.YSLB00) YSLBMC,ZWXM00 from bm_ygbm00 a where ygbh00=? 163 15:45:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 164 15:45:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 165 15:45:49 SQL Execute: ORACLE - select ID0000, DECODE(JLFL00,'3','Y'||DM0000,DM0000) DM0000,MC0000,JLFL00 from BM_BRGMXX where BRID00=? and GHID00=? and JLFL00 in ('1','2','3','4') and SFYX00='Y' order by JLFL00 166 15:45:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 167 15:45:49 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 168 15:45:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 169 15:45:49 SQL Execute: ORACLE - select ZDXXID,trim(ICD900) ICD900,ZDMC00,ZZDBZ0,decode(SFXYZD,'1',2,0) as diagnose_type,decode(ZZDBZ0,'3','主要诊断','次要诊断') ZDLB00 ,ZDRQ00,ZDSJ00 ,a.JZKS00,(select BMMC00 from BM_BMBM00 where BMBH00=a.JZKS00) JZKSMC ,a.JZYS00,JZYSXM from ys_brzdxx a where a.ghid00=? 170 15:45:49 SQL Execute: ORACLE - select SF_YS_getJYJGStr() JYXML0 from dual 171 15:45:49 SQL Data In: ORACLE - Rows affected = 0 172 15:45:49 SQL Execute: ORACLE - select SF_YS_GETHLYYTSXX(194520,'0','0') TSXX00 from dual 173 15:45:49 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='' and SFQY00='1' 174 15:45:49 SQL Execute: ORACLE - select BRID00,(select YBKH00 from BM_BRXXB0 where BRID00=a.BRID00) YBKH00 from SF_BRXXB0 a where GHID00=28266000 175 15:45:49 SQL Execute: ORACLE - select trim(VALUE0) VALUE0 from XT_XTCS00 where NAME00='YS_ZNYBSSSHCJ' 176 15:45:49 SQL Execute: ORACLE - select VALUE0,SF_BM_SQXQTSXX('YS_SSTSSHJKSQ','0',0) TSXX00,SF_SF_GETYYID00() YYID00 from XT_XTCS00 where name00='YS_SSTSSHJKSQ' 177 15:45:49 SQL Execute: ORACLE - select * from VW_YBKF_FYSH00 where GHID00=28266000 178 15:45:49 SQL Execute: ORACLE - select * from VW_YBKF_FYSHMX_YP where GHID00=28266000 and CFLSH0='13982467' 179 15:45:50 SQL Execute: ORACLE - delete YS_CFSHJG where MZZYBZ='0' and GHID00=28266000 180 15:45:50 SQL Data In: ORACLE - Rows affected = 0 181 15:45:50 SQL Execute: ORACLE - insert into YS_CFSHJG(GHID00,SHJGDM,SHJG00,MZZYBZ) select 28266000,SHJGDM,SHJG00,0 from (select SHJGDM,SHJG00 from YS_CFSHRZ where ID0000=194520 order by to_number(SHJGDM) desc) where rownum=1 182 15:45:50 SQL Data In: ORACLE - Rows affected = 0 183 15:45:50 SQL Execute: ORACLE - update YS_CFMX00 a set TSYS00=nvl((select SHJGDM from YS_CFSHRZ where ID0000=194520 and YPNM00=a.YPNM00 and rownum=1 and SHJGDM<>'6'),null) where CFLSH0='13982467' 184 15:45:50 SQL Data In: ORACLE - Rows affected = 26 185 15:45:50 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19871219',DJH000,YSGZH0,'潘勋',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='13982467' 186 15:45:50 SQL Data In: ORACLE - Rows affected = 1 187 15:45:50 SQL Execute: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00,ZFFSBZ,SQYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00,a.ZFFSBZ,decode(a.TSYS00,7,2094,0) from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='13982467' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 188 15:45:50 SQL Data In: ORACLE - Rows affected = 26 189 15:45:50 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13982467 190 15:45:50 SQL Execute: ORACLE - BEGIN "SP_YS_YWMZCF" (AS_CFLSH0 => :AS_CFLSH0); END; 191 15:45:50 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13982467 192 15:45:50 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13614827 193 15:45:50 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 潘勋 194 15:45:50 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 195 15:45:50 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 196 15:45:50 SQL Execute: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 197 15:45:50 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 198 15:45:50 SQL Data In: ORACLE - Param = 2, Name = V_GHZYID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28266000.000000 199 15:45:50 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 200 15:45:50 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 201 15:45:50 SQL Data In: ORACLE - Param = 5, Name = V_SFZDZD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 202 15:45:50 SQL Data In: ORACLE - Param = 6, Name = P_CFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13982467 203 15:45:50 SQL Data In: ORACLE - Param = 7, Name = P_YSBH00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2094 204 15:45:50 SQL Execute: ORACLE - BEGIN "SP_XT_TSXZ00" (V_FLAG00 => :V_FLAG00,V_GHZYID => :V_GHZYID,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_SFZDZD => :V_SFZDZD,P_CFLSH0 => :P_CFLSH0,P_YSBH00 => :P_YSBH00); END; 205 15:45:50 SQL Execute: ORACLE - select SF_YS_GETTSBZTSXX_ZZCF('13982467','') TSXX00 from DUAL 206 15:45:50 SQL Execute: ORACLE - Commit 207 15:45:50 SQL Data In: ORACLE - Rows affected = 0 208 15:45:50 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='' and SFQY00='1' 209 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 210 15:45:51 SQL Execute: ORACLE - select rownum,a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL from YS_CFMX00 a,ys_CFXXB0 b where a.CFLSH0=? AND a.cflsh0=b.cflsh0 order by a.ZB0000,a.CFID00 211 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 212 15:45:51 SQL Execute: ORACLE - select a.*, nvl((select '颗粒药房' from BM_TYZD00 where ZDMC00='厂家颗粒药房对应' and BH0000=a.YFBMBH),' ') QTYFMC from YS_CFXXB0 a where CFLSH0=? and YPDLBH in ('2') and CFXZ00='0' 213 15:45:51 SQL Execute: ORACLE - select YFSMMC,YFSMID,PYSM00,WBSM00 from BM_YPYFSM where trim(YFSMID)='44' 214 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 215 15:45:51 SQL Execute: ORACLE - select CFZT00,YSXM00 from YF_MZCF00 where cflsh0=? 216 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 13982467 217 15:45:51 SQL Execute: ORACLE - select rownum,a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL from YS_CFMX00 a,ys_CFXXB0 b where a.CFLSH0=? AND a.cflsh0=b.cflsh0 order by a.ZB0000,a.CFID00 218 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 40 219 15:45:51 SQL Execute: ORACLE - select * from BM_YPYF00 where YFID00=? 220 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 221 15:45:51 SQL Execute: ORACLE - select * from VW_BM_PC0000 where PCID00=? 222 15:45:51 SQL Execute: ORACLE - select count(1) from YS_CFXXB0 where GHH000='13614827' and to_number(CFLSH0)to_number('13982467') and YPDLBH in ('2') and CFXZ00='0' and rownum=1 223 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3448321 224 15:45:51 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 225 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3448321 226 15:45:51 SQL Execute: ORACLE - select BRZTQK from VW_BM_BRXXB0 where BRID00=? 227 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3448321.000000 228 15:45:51 SQL Execute: ORACLE - select SF_SF_MSZFKQ(?)FHJG00 from dual 229 15:45:51 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='民生通系统参数' order by XSXH00 230 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3448321.000000 231 15:45:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 232 15:45:51 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0 from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 233 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2094.000000 234 15:45:51 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 235 15:45:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3448321.000000 236 15:45:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 5.0 237 15:45:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA74214960 238 15:45:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = YB-SBK 239 15:45:51 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 820007 240 15:45:51 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA74214960 241 15:45:51 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = A74214960 242 15:45:51 SQL Execute: ORACLE - select SF_SF_MSTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 243 15:45:51 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 244 15:45:51 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3448321.000000 245 15:45:51 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2094.000000 246 15:45:51 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 潘勋 247 15:45:51 SQL Data In: ORACLE - Param = 5, Name = P_JYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 248 15:45:51 SQL Data In: ORACLE - Param = 6, Name = P_MKDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 249 15:45:51 SQL Data In: ORACLE - Param = 7, Name = P_JYXXCS, Type = fldZSTRING, Precision = 44, Scale = 0, Data = 余额查询|mst_querydefaultbalance|011000001|0 250 15:45:51 SQL Data In: ORACLE - Param = 8, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 251 15:45:51 SQL Data In: ORACLE - Param = 9, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 252 15:45:51 SQL Data In: ORACLE - Param = 10, Name = P_PDEPTID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 35010141 253 15:45:51 SQL Data In: ORACLE - Param = 11, Name = P_PDEPTKEY, Type = fldZSTRING, Precision = 20, Scale = 0, Data = zEnhPVRWPOCclefldIE0 254 15:45:51 SQL Data In: ORACLE - Param = 12, Name = P_PTERMID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0135010141000161 255 15:45:51 SQL Data In: ORACLE - Param = 13, Name = P_PUSERID, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2094 256 15:45:51 SQL Data In: ORACLE - Param = 14, Name = P_PUSERNAME, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 潘勋 257 15:45:51 SQL Data In: ORACLE - Param = 15, Name = P_PCARDTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 258 15:45:51 SQL Data In: ORACLE - Param = 16, Name = P_PCARDAUTHDATA, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 259 15:45:51 SQL Data In: ORACLE - Param = 17, Name = P_PCARDNO, Type = fldZSTRING, Precision = 9, Scale = 0, Data = A74214960 260 15:45:51 SQL Data In: ORACLE - Param = 18, Name = P_PCARDZONE, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3500 261 15:45:51 SQL Data In: ORACLE - Param = 19, Name = P_PHISCUSTID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3448321 262 15:45:51 SQL Data In: ORACLE - Param = 20, Name = P_PDEPOSITTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 263 15:45:51 SQL Data In: ORACLE - Param = 21, Name = P_PAMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 264 15:45:51 SQL Data In: ORACLE - Param = 22, Name = P_PHISTYPE, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 265 15:45:51 SQL Data In: ORACLE - Param = 23, Name = P_PHISSERIAL, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 266 15:45:51 SQL Data In: ORACLE - Param = 24, Name = P_POLDHISSERIAL, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 267 15:45:51 SQL Data In: ORACLE - Param = 25, Name = P_PREVERSEKIND, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 268 15:45:51 SQL Data In: ORACLE - Param = 26, Name = P_POLDBATCHID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 269 15:45:51 SQL Data In: ORACLE - Param = 27, Name = P_POLDTRANSDATE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 270 15:45:51 SQL Data In: ORACLE - Param = 28, Name = P_POLDTRANSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 271 15:45:51 SQL Data In: ORACLE - Param = 29, Name = P_POLDAMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 272 15:45:51 SQL Data In: ORACLE - Param = 30, Name = P_PTRANSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 273 15:45:51 SQL Data In: ORACLE - Param = 31, Name = P_PBATCHID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 274 15:45:51 SQL Data In: ORACLE - Param = 32, Name = P_PTRANSINFO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 275 15:45:51 SQL Data In: ORACLE - Param = 33, Name = P_PTRANSSTATE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 276 15:45:51 SQL Data In: ORACLE - Param = 34, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 277 15:45:51 SQL Data In: ORACLE - Param = 35, Name = P_PERRMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 278 15:45:51 SQL Data In: ORACLE - Param = 36, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 279 15:45:51 SQL Data In: ORACLE - Param = 37, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 280 15:45:51 SQL Data In: ORACLE - Param = 38, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 281 15:45:51 SQL Data In: ORACLE - Param = 39, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 282 15:45:51 SQL Data In: ORACLE - Param = 40, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 283 15:45:51 SQL Data In: ORACLE - Param = 41, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 284 15:45:51 SQL Data In: ORACLE - Param = 42, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 285 15:45:51 SQL Execute: ORACLE - BEGIN "SP_SF_YKTRZB_MST" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_JYJE00 => :P_JYJE00,P_MKDM00 => :P_MKDM00,P_JYXXCS => :P_JYXXCS,P_INJKCS => :P_INJKCS,P_INKZCS => :P_INKZCS,P_PDEPTID => :P_PDEPTID,P_PDEPTKEY => :P_PDEPTKEY,P_PTERMID => :P_PTERMID,P_PUSERID => :P_PUSERID,P_PUSERNAME => :P_PUSERNAME,P_PCARDTYPE => :P_PCARDTYPE,P_PCARDAUTHDATA => :P_PCARDAUTHDATA,P_PCARDNO => :P_PCARDNO,P_PCARDZONE => :P_PCARDZONE,P_PHISCUSTID => :P_PHISCUSTID,P_PDEPOSITTYPE => :P_PDEPOSITTYPE,P_PAMOUNT => :P_PAMOUNT,P_PHISTYPE => :P_PHISTYPE,P_PHISSERIAL => :P_PHISSERIAL,P_POLDHISSERIAL => :P_POLDHISSERIAL,P_PREVERSEKIND => :P_PREVERSEKIND,P_POLDBATCHID => :P_POLDBATCHID,P_POLDTRANSDATE => :P_POLDTRANSDATE,P_POLDTRANSID => :P_POLDTRANSID,P_POLDAMOUNT => :P_POLDAMOUNT,P_PTRANSID => :P_PTRANSID,P_PBATCHID => :P_PBATCHID,P_PTRANSINFO => :P_PTRANSINFO,P_PTRANSSTATE => :P_PTRANSSTATE,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 286 15:45:51 SQL Execute: ORACLE - COMMIT 287 15:45:51 SQL Data In: ORACLE - Rows affected = 0 288 15:45:51 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 289 15:45:51 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3448321.000000 290 15:45:51 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2094.000000 291 15:45:51 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 潘勋 292 15:45:51 SQL Data In: ORACLE - Param = 5, Name = P_JYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 293 15:45:51 SQL Data In: ORACLE - Param = 6, Name = P_MKDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 294 15:45:51 SQL Data In: ORACLE - Param = 7, Name = P_JYXXCS, Type = fldZSTRING, Precision = 44, Scale = 0, Data = 余额查询|mst_querydefaultbalance|011000001|0 295 15:45:51 SQL Data In: ORACLE - Param = 8, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 296 15:45:51 SQL Data In: ORACLE - Param = 9, Name = P_INKZCS, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 297 15:45:51 SQL Data In: ORACLE - Param = 10, Name = P_PDEPTID, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 35010141 298 15:45:51 SQL Data In: ORACLE - Param = 11, Name = P_PDEPTKEY, Type = fldZSTRING, Precision = 20, Scale = 0, Data = zEnhPVRWPOCclefldIE0 299 15:45:51 SQL Data In: ORACLE - Param = 12, Name = P_PTERMID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0135010141000161 300 15:45:51 SQL Data In: ORACLE - Param = 13, Name = P_PUSERID, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2094 301 15:45:51 SQL Data In: ORACLE - Param = 14, Name = P_PUSERNAME, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 潘勋 302 15:45:51 SQL Data In: ORACLE - Param = 15, Name = P_PCARDTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 303 15:45:51 SQL Data In: ORACLE - Param = 16, Name = P_PCARDAUTHDATA, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 304 15:45:51 SQL Data In: ORACLE - Param = 17, Name = P_PCARDNO, Type = fldZSTRING, Precision = 9, Scale = 0, Data = A74214960 305 15:45:51 SQL Data In: ORACLE - Param = 18, Name = P_PCARDZONE, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3500 306 15:45:51 SQL Data In: ORACLE - Param = 19, Name = P_PHISCUSTID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3448321 307 15:45:51 SQL Data In: ORACLE - Param = 20, Name = P_PDEPOSITTYPE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 308 15:45:51 SQL Data In: ORACLE - Param = 21, Name = P_PAMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 309 15:45:51 SQL Data In: ORACLE - Param = 22, Name = P_PHISTYPE, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 310 15:45:51 SQL Data In: ORACLE - Param = 23, Name = P_PHISSERIAL, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 311 15:45:51 SQL Data In: ORACLE - Param = 24, Name = P_POLDHISSERIAL, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 312 15:45:51 SQL Data In: ORACLE - Param = 25, Name = P_PREVERSEKIND, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 313 15:45:51 SQL Data In: ORACLE - Param = 26, Name = P_POLDBATCHID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 314 15:45:51 SQL Data In: ORACLE - Param = 27, Name = P_POLDTRANSDATE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 315 15:45:51 SQL Data In: ORACLE - Param = 28, Name = P_POLDTRANSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 316 15:45:51 SQL Data In: ORACLE - Param = 29, Name = P_POLDAMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 317 15:45:51 SQL Data In: ORACLE - Param = 30, Name = P_PTRANSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 318 15:45:51 SQL Data In: ORACLE - Param = 31, Name = P_PBATCHID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 319 15:45:51 SQL Data In: ORACLE - Param = 32, Name = P_PTRANSINFO, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 320 15:45:51 SQL Data In: ORACLE - Param = 33, Name = P_PTRANSSTATE, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 321 15:45:51 SQL Data In: ORACLE - Param = 34, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 查询余额成功！ 322 15:45:51 SQL Data In: ORACLE - Param = 35, Name = P_PERRMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 323 15:45:51 SQL Data In: ORACLE - Param = 36, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 324 15:45:51 SQL Data In: ORACLE - Param = 37, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 325 15:45:51 SQL Data In: ORACLE - Param = 38, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 326 15:45:51 SQL Data In: ORACLE - Param = 39, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 327 15:45:51 SQL Data In: ORACLE - Param = 40, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 328 15:45:51 SQL Data In: ORACLE - Param = 41, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 329 15:45:51 SQL Data In: ORACLE - Param = 42, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 330 15:45:51 SQL Execute: ORACLE - BEGIN "SP_SF_YKTRZB_MST" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_JYJE00 => :P_JYJE00,P_MKDM00 => :P_MKDM00,P_JYXXCS => :P_JYXXCS,P_INJKCS => :P_INJKCS,P_INKZCS => :P_INKZCS,P_PDEPTID => :P_PDEPTID,P_PDEPTKEY => :P_PDEPTKEY,P_PTERMID => :P_PTERMID,P_PUSERID => :P_PUSERID,P_PUSERNAME => :P_PUSERNAME,P_PCARDTYPE => :P_PCARDTYPE,P_PCARDAUTHDATA => :P_PCARDAUTHDATA,P_PCARDNO => :P_PCARDNO,P_PCARDZONE => :P_PCARDZONE,P_PHISCUSTID => :P_PHISCUSTID,P_PDEPOSITTYPE => :P_PDEPOSITTYPE,P_PAMOUNT => :P_PAMOUNT,P_PHISTYPE => :P_PHISTYPE,P_PHISSERIAL => :P_PHISSERIAL,P_POLDHISSERIAL => :P_POLDHISSERIAL,P_PREVERSEKIND => :P_PREVERSEKIND,P_POLDBATCHID => :P_POLDBATCHID,P_POLDTRANSDATE => :P_POLDTRANSDATE,P_POLDTRANSID => :P_POLDTRANSID,P_POLDAMOUNT => :P_POLDAMOUNT,P_PTRANSID => :P_PTRANSID,P_PBATCHID => :P_PBATCHID,P_PTRANSINFO => :P_PTRANSINFO,P_PTRANSSTATE => :P_PTRANSSTATE,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 331 15:45:51 SQL Execute: ORACLE - COMMIT 332 15:45:51 SQL Data In: ORACLE - Rows affected = 0 333 15:45:51 SQL Execute: ORACLE - select 1 from yj_yw0000 a, YS_ZYBZLZ b where a.zlxmid=b.zlxmid and a.mzzybz='0' and a.zyghid=28266000 and a.sl0000>0 and not exists(select 1 from yj_yw0000 where zyghid=a.zyghid and cxdjh0=a.yjdjh0) 334 15:45:51 SQL Execute: ORACLE - select * from VW_YS_ZYBZLZ a where SF_YS_ZYBZLZLB(2094,a.MRGHLB,28266000)=1 order by XSXH00