1 10:10:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 106457.000000 2 10:10:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 15774128 3 10:10:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 4 10:10:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 5 10:10:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 6 10:10:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,645, 7 10:10:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 8 10:10:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 9 10:10:57 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.SYLSH0,b.cfid00,b.SFDJH0,b.zlxmid NewZlxmid,b.sl0000 NewSL0000,b.ZJE000 DJ0000,b.zdid00,b.KDKSBH,b.KDYS00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='0' and brid00=? and yzcfid=? and (YJKSBH=? or ( (((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,cfid00,kdrq00,zlxmid 10 10:11:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 106457.000000 11 10:11:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 15774128 12 10:11:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 13 10:11:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 14 10:11:00 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 15 10:11:00 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,645, 16 10:11:00 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 17 10:11:00 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 18 10:11:00 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.SYLSH0,b.cfid00,b.SFDJH0,b.zlxmid NewZlxmid,b.sl0000 NewSL0000,b.ZJE000 DJ0000,b.zdid00,b.KDKSBH,b.KDYS00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='0' and brid00=? and yzcfid=? and (YJKSBH=? or ( (((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,cfid00,kdrq00,zlxmid 19 10:11:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 106457.000000 20 10:11:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 15774128 21 10:11:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 22 10:11:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 23 10:11:01 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 24 10:11:01 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,645, 25 10:11:01 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 26 10:11:01 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 27 10:11:01 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.SYLSH0,b.cfid00,b.SFDJH0,b.zlxmid NewZlxmid,b.sl0000 NewSL0000,b.ZJE000 DJ0000,b.zdid00,b.KDKSBH,b.KDYS00 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='0' and brid00=? and yzcfid=? and (YJKSBH=? or ( (((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,cfid00,kdrq00,zlxmid 28 10:11:03 SQL Execute: ORACLE - Select SYSDATE from Dual 29 10:11:03 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 30 10:11:03 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') 31 10:11:04 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-MMRK' and KLDH00 not in ('CK','JMCK') 32 10:11:04 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-MTYB' and KLDH00 not in ('CK','JMCK') 33 10:11:04 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') 34 10:11:06 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBB00431345' and ICKNBH = 'PTYBB00431345' 35 10:11:06 SQL Execute: ORACLE - Select SYSDATE from Dual 36 10:11:06 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 37 10:11:06 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') 38 10:11:06 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-MMRK' and KLDH00 not in ('CK','JMCK') 39 10:11:06 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-MTYB' and KLDH00 not in ('CK','JMCK') 40 10:11:06 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') 41 10:11:08 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBB00431345' and ICKNBH = 'PTYBB00431345' 42 10:11:08 SQL Execute: ORACLE - Select SYSDATE from Dual 43 10:11:08 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 44 10:11:08 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') 45 10:11:08 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-MMRK' and KLDH00 not in ('CK','JMCK') 46 10:11:09 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-MTYB' and KLDH00 not in ('CK','JMCK') 47 10:11:09 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') 48 10:11:11 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBB00431345' and ICKNBH = 'PTYBB00431345' 49 10:11:11 SQL Execute: ORACLE - Select SYSDATE from Dual 50 10:11:11 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 51 10:11:11 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') 52 10:11:11 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-MMRK' and KLDH00 not in ('CK','JMCK') 53 10:11:11 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-MTYB' and KLDH00 not in ('CK','JMCK') 54 10:11:11 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') 55 10:11:13 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBB00431345' and ICKNBH = 'PTYBB00431345' 56 10:11:14 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641161.000000 57 10:11:14 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 58 10:11:14 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 59 10:11:14 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 60 10:11:14 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 62920 61 10:11:14 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 62 10:11:14 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 63 10:11:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 005 64 10:11:14 SQL Execute: ORACLE - SELECT 1 FROM BM_YPYF00 WHERE YFID00=? AND YFLBID=2 65 10:11:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = SQ_YJ_20140716 66 10:11:14 SQL Execute: ORACLE - select 1 FROM ALL_SEQUENCES WHERE SEQUENCE_NAME=? 67 10:11:14 SQL Execute: ORACLE - select lpad(SQ_YJ_20140716.NextVal,3,'0') FROM dual 68 10:11:14 SQL Execute: ORACLE - update YJ_YW0000 SET SYLSH0='911' WHERE YJDJH0=29641161 69 10:11:14 SQL Data In: ORACLE - Rows affected = 1 70 10:11:14 SQL Execute: ORACLE - Commit 71 10:11:14 SQL Data In: ORACLE - Rows affected = 0 72 10:11:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641161.000000 73 10:11:14 SQL Execute: ORACLE - select b.LBBH00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 74 10:11:14 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641162.000000 75 10:11:14 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 76 10:11:14 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 77 10:11:14 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 78 10:11:14 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 62920 79 10:11:14 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 80 10:11:14 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 81 10:11:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 005 82 10:11:14 SQL Execute: ORACLE - SELECT 1 FROM BM_YPYF00 WHERE YFID00=? AND YFLBID=2 83 10:11:14 SQL Execute: ORACLE - update YJ_YW0000 SET SYLSH0='911' WHERE YJDJH0=29641162 84 10:11:14 SQL Data In: ORACLE - Rows affected = 1 85 10:11:14 SQL Execute: ORACLE - Commit 86 10:11:14 SQL Data In: ORACLE - Rows affected = 0 87 10:11:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641162.000000 88 10:11:14 SQL Execute: ORACLE - select b.LBBH00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 89 10:11:15 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641165.000000 90 10:11:15 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 91 10:11:15 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 92 10:11:15 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 93 10:11:15 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 62920 94 10:11:15 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 95 10:11:15 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 96 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641165.000000 97 10:11:15 SQL Execute: ORACLE - select b.LBBH00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 98 10:11:15 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641164.000000 99 10:11:15 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 100 10:11:15 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 101 10:11:15 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 102 10:11:15 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 62920 103 10:11:15 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 104 10:11:15 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 105 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 005 106 10:11:15 SQL Execute: ORACLE - SELECT 1 FROM BM_YPYF00 WHERE YFID00=? AND YFLBID=2 107 10:11:15 SQL Execute: ORACLE - update YJ_YW0000 SET SYLSH0='911' WHERE YJDJH0=29641164 108 10:11:15 SQL Data In: ORACLE - Rows affected = 1 109 10:11:15 SQL Execute: ORACLE - Commit 110 10:11:15 SQL Data In: ORACLE - Rows affected = 0 111 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29641164.000000 112 10:11:15 SQL Execute: ORACLE - select b.LBBH00 from YJ_YW0000 a,BM_ZLZD00 b WHERE a.YJDJH0=? AND a.ZLXMID=b.ZLXMID 113 10:11:15 SQL Execute: ORACLE - SELECT ZB0000,DXSYSL CS0000,GHH000,XM0000,QSSJ00,XB0000,NL0000,BRBLH0,YPYF00,SYLSH0,YJDJH0 FROM VW_YJ_SYKP00_ZSSY where yjdjh0 in (29641161,29641162,29641165,29641164) and yjksbh=645 GROUP BY ZB0000,KDRQ00,QSSJ00,GHH000,XM0000,XB0000,NL0000,BRBLH0,YPYF00,SYLSH0,DXSYSL,YJDJH0 ORDER BY GHH000,ZB0000,QSSJ00 114 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 115 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 116 10:11:15 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 117 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 118 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 119 10:11:15 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 120 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 121 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 122 10:11:15 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 123 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 124 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 125 10:11:15 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 126 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 127 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 128 10:11:15 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 129 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 130 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 131 10:11:15 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 132 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 133 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 134 10:11:15 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 135 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 136 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 137 10:11:15 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 138 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 139 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 140 10:11:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 141 10:11:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 142 10:11:15 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 143 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 144 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 145 10:11:15 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 146 10:11:15 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2 WHERE t2.CFLSH0||'-'||NVL(ZB0000,'0')='15774128 -1'and t2.CFLSH0='15774128' 147 10:11:15 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2 WHERE t2.CFLSH0||'-'||NVL(ZB0000,'0')='15774128 -1'and t2.CFLSH0='15774128' 148 10:11:15 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2 WHERE t2.CFLSH0||'-'||NVL(ZB0000,'0')='15774128 -1'and t2.CFLSH0='15774128' 149 10:11:15 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2 WHERE t2.CFLSH0||'-'||NVL(ZB0000,'0')='15774128 -2'and t2.CFLSH0='15774128' 150 10:11:15 SQL Execute: ORACLE - select distinct YZCFID,CFID00,DCBZ00,SUM(ZJE000) ZJE000 from YJ_YW0000 WHERE YJDJH0 in (29641161,29641162,29641165,29641164) group by yzcfid,cfid00,DCBZ00 151 10:11:15 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000,JE0000) VALUES (52608711,2,1.69) 152 10:11:15 SQL Data In: ORACLE - Rows affected = 1 153 10:11:15 SQL Execute: ORACLE - select nvl(ZQCS00,1),CFID00 FROM VW_YJ_ZSSYCFMXDY WHERE CFLSH0='15774128' and Instr(',52608711,',To_char(CFID00))>0 154 10:11:15 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000,JE0000) VALUES (52608710,1,16.61) 155 10:11:15 SQL Data In: ORACLE - Rows affected = 1 156 10:11:15 SQL Execute: ORACLE - select nvl(ZQCS00,1),CFID00 FROM VW_YJ_ZSSYCFMXDY WHERE CFLSH0='15774128' and Instr(',52608710,52608711,',To_char(CFID00))>0 157 10:11:15 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000,JE0000) VALUES (52608712,1,2.37) 158 10:11:15 SQL Data In: ORACLE - Rows affected = 1 159 10:11:15 SQL Execute: ORACLE - select nvl(ZQCS00,1),CFID00 FROM VW_YJ_ZSSYCFMXDY WHERE CFLSH0='15774128' and Instr(',52608712,52608713,',To_char(CFID00))>0 160 10:11:15 SQL Execute: ORACLE - select SP_YS_MONEY(20.67) ZJE000,'急性扁桃体炎' LCZD00,'911' SYLSH0, '程芳芳' KDYSXM,'输液巡视卡' BT0000, a.* from VW_YJ_ZSSYCFMXDY a where CFLSH0='15774128' and rownum=1 161 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 162 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 163 10:11:15 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 164 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 165 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 166 10:11:15 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 167 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 168 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 169 10:11:15 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 170 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 171 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 172 10:11:15 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 173 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 174 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 175 10:11:15 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 176 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 177 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 178 10:11:15 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 179 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 180 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 181 10:11:15 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 182 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 183 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 184 10:11:15 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 185 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 186 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 187 10:11:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 188 10:11:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 189 10:11:15 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 190 10:11:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 191 10:11:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 192 10:11:15 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 193 10:11:15 SQL Execute: ORACLE - select decode('Y','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('Y','N',Decode(a.FJXMJE,NULL,NULL,'1.69'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('Y','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608711,',To_char(CFID00))>0 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('N','N',Decode(a.FJXMJE,NULL,NULL,'16.61'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608710,52608711,',To_char(CFID00))>0 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,' ' FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a where CFID00=52608710 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,' ' FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a where CFID00=52608711 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('N','N',Decode(a.FJXMJE,NULL,NULL,'2.37'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608712,52608713,',To_char(CFID00))>0 194 10:11:16 SQL Execute: ORACLE - select SP_YS_MONEY(20.67) ZJE000,'急性扁桃体炎' LCZD00,'911' SYLSH0, '程芳芳' KDYSXM,'输液加药卡' BT0000, a.* from VW_YJ_ZSSYCFMXDY a where CFLSH0='15774128' and rownum=1 195 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 196 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 197 10:11:16 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 198 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 199 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 200 10:11:16 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 201 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 202 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 203 10:11:16 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 204 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 205 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 206 10:11:16 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 207 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 208 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 209 10:11:16 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 210 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 211 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 212 10:11:16 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 213 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 214 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 215 10:11:16 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 216 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 217 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 218 10:11:16 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 219 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 220 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 221 10:11:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 222 10:11:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 223 10:11:16 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 224 10:11:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 225 10:11:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 226 10:11:16 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 227 10:11:16 SQL Execute: ORACLE - select decode('Y','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('Y','N',Decode(a.FJXMJE,NULL,NULL,'1.69'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('Y','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608711,',To_char(CFID00))>0 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('N','N',Decode(a.FJXMJE,NULL,NULL,'16.61'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608710,52608711,',To_char(CFID00))>0 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,' ' FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a where CFID00=52608710 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,' ' FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a where CFID00=52608711 union all select decode('N','Y',a.ZB0000||'Z',a.ZB0000) ZB0000,decode('N','N',Decode(a.FJXMJE,NULL,NULL,'2.37'),a.FJXMJE) FJXMJE, a.CFNR00,a.CJL000,Decode('N','Y',a.PSMC00,a.PCYFMC) PCYFMC,a.* FROM VW_YJ_ZSSYCFMXDY a WHERE CFLSH0='15774128' and Instr(',52608712,52608713,',To_char(CFID00))>0 228 10:11:16 SQL Execute: ORACLE - Rollback 229 10:11:16 SQL Data In: ORACLE - Rows affected = 0 230 10:11:16 SQL Execute: ORACLE - SELECT ZB0000,MAX(DXSYSL) CS0000,GHH000,XM0000,QSSJ00,XB0000,NL0000,BRBLH0,YPYF00 FROM VW_YJ_SYKP00 where yjdjh0 in (29641161,29641162,29641165,29641164) and yjksbh=645 GROUP BY ZB0000,KDRQ00,QSSJ00,GHH000,XM0000,XB0000,NL0000,BRBLH0,YPYF00 ORDER BY GHH000,ZB0000,QSSJ00 231 10:11:16 SQL Execute: ORACLE - select ZDMC00 from ys_brzdxx where zzdbz0='3' and sfxyzd='1' and ghh000 = '15120564' 232 10:11:16 SQL Execute: ORACLE - SELECT '1' a from dual 233 10:11:16 SQL Execute: ORACLE - Select SYSDATE from Dual 234 10:11:16 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 235 10:11:16 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') 236 10:11:16 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-MMRK' and KLDH00 not in ('CK','JMCK') 237 10:11:17 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-MTYB' and KLDH00 not in ('CK','JMCK') 238 10:11:17 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') 239 10:11:18 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBB00431345' and ICKNBH = 'PTYBB00431345' 240 10:11:18 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 106457.000000 241 10:11:18 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 242 10:11:18 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 243 10:11:18 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 244 10:11:18 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 245 10:11:18 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 246 10:11:18 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 247 10:11:18 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 248 10:11:18 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 249 10:11:18 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 250 10:11:18 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 251 10:11:18 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 252 10:11:18 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 253 10:11:18 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 254 10:11:18 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 255 10:11:18 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 256 10:11:18 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 257 10:11:18 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 258 10:11:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 106457.000000 259 10:11:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 260 10:11:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 261 10:11:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 645.000000 262 10:11:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,645, 263 10:11:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 264 10:11:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 265 10:11:19 SQL Execute: ORACLE - select * from VW_YJ_ZSSYCFMX a where 1=1 and brid00=? and cflsh0 in (Select yzcfid from yj_yw0000 b where b.zlxmjc<>'医技科室费用退费' and b.xmzt00 in ('0','1','2') and b.mzzybz='0' and b.brid00=a.BRID00 and (YJKSBH=? or ( (((b.Zlxmid,kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 ) 266 10:11:19 SQL Execute: ORACLE - select * from yj_yw0000 where yjdjh0 in (29641161,29641162,29641165,29641164) order by zyhghh,mzzybz 267 10:11:19 SQL Execute: ORACLE - select * from yj_yw0000 where yjdjh0 in (29641161,29641162,29641165,29641164) order by zyhghh,mzzybz