1 08:55:48 SQL Execute: ORACLE - select count(*) from XK_BRXX00 WHERE BRID00=5640234 2 08:55:48 SQL Execute: ORACLE - select to_date('20161225','YYYYMMDD') from dual 3 08:55:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5640234.000000 4 08:55:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1608149 5 08:55:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1608149 6 08:55:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄灵敏 7 08:55:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 8 08:55:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19771128 9 08:55:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 08:55:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 11 08:55:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 08:55:48 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 13 08:55:48 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 14 08:55:48 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 15 08:55:48 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 住院 16 08:55:48 SQL Execute: ORACLE - insert into XK_BRXX00( BRID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00, ZDXX00,FDXX00,RHXX00,SXZSD0,CHYS00,SCS000,MZZYBZ) values( ?,?,?,?,?,?,?, ?,?,?,?,?,?) 17 08:55:48 SQL Data In: ORACLE - Rows affected = 1 18 08:55:48 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 19 08:55:48 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 20 08:55:48 SQL Data In: ORACLE - Param = 3, Name = P_ZYID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2477986 21 08:55:48 SQL Data In: ORACLE - Param = 4, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 08:55:48 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 23 08:55:48 SQL Data In: ORACLE - Param = 6, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 24 08:55:48 SQL Data In: ORACLE - Param = 7, Name = P_ZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 25 08:55:48 SQL Data In: ORACLE - Param = 8, Name = P_ZLXMMC, Type = fldZSTRING, Precision = 25, Scale = 0, Data = 滤白新鲜冰冻血浆常规200ml 26 08:55:48 SQL Data In: ORACLE - Param = 9, Name = P_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 123.000000 27 08:55:48 SQL Data In: ORACLE - Param = 10, Name = P_KZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1059.000000 28 08:55:48 SQL Data In: ORACLE - Param = 11, Name = P_LRRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈守斌 29 08:55:48 SQL Data In: ORACLE - Param = 12, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 30 08:55:48 SQL Data In: ORACLE - Param = 13, Name = P_QYSJ00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 08:44 31 08:55:48 SQL Data In: ORACLE - Param = 14, Name = P_TS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 32 08:55:48 SQL Data In: ORACLE - Param = 15, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 33 08:55:48 SQL Data In: ORACLE - Param = 16, Name = P_MCSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 34 08:55:48 SQL Data In: ORACLE - Param = 17, Name = P_TQFS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 35 08:55:48 SQL Data In: ORACLE - Param = 18, Name = P_YZCLLB, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 正常 36 08:55:48 SQL Data In: ORACLE - Param = 19, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 37 08:55:48 SQL Data In: ORACLE - Param = 20, Name = P_ZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 38 08:55:48 SQL Data In: ORACLE - Param = 21, Name = P_ZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 39 08:55:48 SQL Data In: ORACLE - Param = 22, Name = P_BQZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 40 08:55:48 SQL Data In: ORACLE - Param = 23, Name = P_BWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 41 08:55:48 SQL Data In: ORACLE - Param = 24, Name = P_BB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 42 08:55:48 SQL Data In: ORACLE - Param = 25, Name = P_BBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 08:55:48 SQL Data In: ORACLE - Param = 26, Name = p_sfsqd0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 44 08:55:48 SQL Execute: ORACLE - BEGIN "SP_ZS_YJYZ00" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_ZYID00 => :P_ZYID00,P_YEXM00 => :P_YEXM00,P_CLBZ00 => :P_CLBZ00,P_PXSJ00 => :P_PXSJ00,P_ZLXMID => :P_ZLXMID,P_ZLXMMC => :P_ZLXMMC,P_ZXKS00 => :P_ZXKS00,P_KZYS00 => :P_KZYS00,P_LRRXM0 => :P_LRRXM0,P_QYRQ00 => :P_QYRQ00,P_QYSJ00 => :P_QYSJ00,P_TS0000 => :P_TS0000,P_PCID00 => :P_PCID00,P_MCSL00 => :P_MCSL00,P_TQFS00 => :P_TQFS00,P_YZCLLB => :P_YZCLLB,P_BZ0000 => :P_BZ0000,P_ZDID00 => :P_ZDID00,P_ZDMC00 => :P_ZDMC00,P_BQZY00 => :P_BQZY00,P_BWMC00 => :P_BWMC00,P_BB0000 => :P_BB0000,P_BBID00 => :P_BBID00,p_sfsqd0 => :p_sfsqd0); END; 45 08:55:49 SQL Data In: ORACLE - Param = 1, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18240124.000000 46 08:55:49 SQL Data In: ORACLE - Param = 2, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 08:55:49 SQL Execute: ORACLE - BEGIN "SP_BQ_YJFJFY" (P_YZMXID => :P_YZMXID,P_CZY000 => :P_CZY000); END; 48 08:55:49 SQL Execute: ORACLE - select SQ_YJ_YW0000_YJDJH0.NEXTVAL from dual 49 08:55:49 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0, CXDJH0,YJFZH0,ZLXMJC, YJKSBH, ZYGHID, YEXM00, ZLXMID, KDYS00,KDKSBH,YZCFID,SL0000,KDRQ00, KDSJ00,LRXM00, JZBZ00, FBZXBZ, BWMC00, ZDID00,ZDMC00, XMZT00, MZZYBZ, BZ0000, TQPC00,DCBZ00,BQSFBZ, SM0000,BBID00,ZXYS00)values(25865649,'-1',NULL,'滤白新鲜冰冻血浆常规200ml','123','2477986',null,'7','1059','66','18240124','0',to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'1059','N','N',null,null,null,'1','1',null,'0','0','N',null,null,'0') 50 08:55:49 SQL Data In: ORACLE - Rows affected = 1 51 08:55:49 SQL Execute: ORACLE - Commit 52 08:55:49 SQL Data In: ORACLE - Rows affected = 0 53 08:55:49 SQL Execute: ORACLE - insert into YJ_YWJJ00(ID0000, YJDJH0, YJFZH0, SFXMID, SFXX00,JJJE00, SFSX00, CXBZ00, SL0000, SFCS00,GJBM00,SFLB00)select SQ_YJ_YWJJ00_ID0000.NEXTVAL, 25865649, '0', G.SFXMID,'0','0','0', 'Z', '0',G.SFCS00,G.GJBM00,'0' from BQ_YJYZJJ G where G.YZMXID='18240124' 54 08:55:49 SQL Data In: ORACLE - Rows affected = 1 55 08:55:49 SQL Execute: ORACLE - Select SQ_XK_SXSQ00_SQDH00.NextVal Val from Dual 56 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 123.000000 57 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 58 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2477986 59 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5640234.000000 60 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 外科一科室 61 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 外科一病区 62 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 输血 63 08:55:49 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 外1-04 64 08:55:49 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18240124.000000 65 08:55:49 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈守斌 66 08:55:49 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 67 08:55:49 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 68 08:55:49 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 08:55:49 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 08:55:49 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 肺部阴影 71 08:55:49 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 常规 72 08:55:49 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 滤白新鲜冰冻血浆 73 08:55:49 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 200.000000 74 08:55:49 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = ml 75 08:55:49 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 76 08:55:49 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 77 08:55:49 SQL Data In: ORACLE - Param = 22, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 78 08:55:49 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈群 79 08:55:49 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 80 08:55:49 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 81 08:55:49 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161225 82 08:55:49 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:14:55 83 08:55:49 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 手术用血 84 08:55:49 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 29 85 08:55:49 SQL Execute: ORACLE - insert into XK_SXSQ00(XKBMBH,SQDH00,ZYID00,BRID00,KSMC00,BQMC00, SXMD00,CH0000,YZMXID,LRRXM0,LRRQ00,LRSJ00, SQZT00,SFJWSX,LCZDMC,SXSZ00,SXCF00, SXSL00,SXDW00,CXRXM0,CYRQ00,SQYSBH, SHYSXM,SQRQ00,SQSJ00,YJSXRQ,YJSRSJ,SXSQYT, SHR000,MZZYBZ ) values(?,?,?,?,?,?, ?,?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?,?, ?,'住院' ) 86 08:55:49 SQL Data In: ORACLE - Rows affected = 1 87 08:55:49 SQL Execute: ORACLE - Commit 88 08:55:49 SQL Data In: ORACLE - Rows affected = 0 89 08:55:49 SQL Execute: ORACLE - commit 90 08:55:49 SQL Data In: ORACLE - Rows affected = 0 91 08:55:49 SQL Execute: ORACLE - delete XK_SQDJG0 where ZYID00=2477986 and SQDH00='-1' 92 08:55:49 SQL Data In: ORACLE - Rows affected = 0 93 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 94 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 95 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 109453.000000 96 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = A型 97 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 98 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 99 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 100 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 101 08:55:49 SQL Data In: ORACLE - Rows affected = 1 102 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 103 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 104 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 109454.000000 105 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阳性 106 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 107 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 108 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 109 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 110 08:55:49 SQL Data In: ORACLE - Rows affected = 1 111 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 112 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 113 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1168.000000 114 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 33(U/L) 115 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 116 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 117 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 118 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 119 08:55:49 SQL Data In: ORACLE - Rows affected = 1 120 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 121 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 122 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1221.000000 123 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阳性 124 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 125 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 126 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 127 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 128 08:55:49 SQL Data In: ORACLE - Rows affected = 1 129 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 130 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 131 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1228.000000 132 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阴性 133 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 134 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 135 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.000000 136 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 137 08:55:49 SQL Data In: ORACLE - Rows affected = 1 138 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 139 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 140 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1227.000000 141 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阴性 142 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 143 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 144 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27.000000 145 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 146 08:55:49 SQL Data In: ORACLE - Rows affected = 1 147 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 148 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 149 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1261.000000 150 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阴性 151 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 152 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 153 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 154 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 155 08:55:49 SQL Data In: ORACLE - Rows affected = 1 156 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 157 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 158 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1262.000000 159 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 阴性 160 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 161 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 162 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 163 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 164 08:55:49 SQL Data In: ORACLE - Rows affected = 1 165 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 166 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 167 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 168 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 13.30(秒) 169 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 170 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 171 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 101.000000 172 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 173 08:55:49 SQL Data In: ORACLE - Rows affected = 1 174 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 175 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 176 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 177 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1.21 178 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 179 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 180 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 104.000000 181 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 182 08:55:49 SQL Data In: ORACLE - Rows affected = 1 183 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 184 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 185 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 186 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 27.50(秒) 187 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 188 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 189 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 190 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 191 08:55:49 SQL Data In: ORACLE - Rows affected = 1 192 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 193 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 194 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 195 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 9.70(秒) 196 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 197 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 198 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 110.000000 199 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 200 08:55:49 SQL Data In: ORACLE - Rows affected = 1 201 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 202 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 203 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 204 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 5.52(g/L) 205 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 206 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 207 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 113.000000 208 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 209 08:55:49 SQL Data In: ORACLE - Rows affected = 1 210 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 211 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 212 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 213 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 0.251(mg/l) 214 08:55:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 215 08:55:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:53:29 216 08:55:49 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 116.000000 217 08:55:49 SQL Execute: ORACLE - insert into XK_SQDJG0(ZYID00,SQDH00,BGXMID,JYJG00,CZRQ00,CZSJ00,JYXMID ) values(?,?,?,?,?,?,? ) 218 08:55:49 SQL Data In: ORACLE - Rows affected = 1 219 08:55:49 SQL Execute: ORACLE - Commit 220 08:55:49 SQL Data In: ORACLE - Rows affected = 0 221 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 222 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161224 223 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 66.000000 224 08:55:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 66.000000 225 08:55:49 SQL Execute: ORACLE - SELECT "SQDH00", "ZYID00", "BRID00", "BRXM00", "MZZYBZ", "ZYH000", "MRN000", "XB0000", "CSRQ00", "NL0000", "XX0000", "FDXX00", "RHXX00", "TYKTSC", "TYKTJD", "JYYGXM", "FJRXM0", "JYRQSJ", "KSMC00", "BQMC00", "CH0000", "YZMXID", "YZXX00", "SXZSD0", "CHYS00", "SCS000", "LRRXM0", "LRRQ00", "LRSJ00", "LRRQSJ", "SQZT00", "SQZTMC", "SFJWSX", "LCZDMC", "SXSZ00", "SXCF00", "SXCFBH", "SXSL00", "SXDW00", "CXRXM0", "CYRQ00", "CYRQSJ", "SQYSBH", "SQYSXM", "SHYSXM", "SQRQ00", "SQSJ00", "YJSXRQ", "YJSRSJ", "SQRQSJ", "YJSRRQ", "SXMD00", "PXBGRQ", "PXBGSJ", "PXRQSJ", "PXYGBH", "PXRXM0", "PXFHXM", "QXRXM0", "FXRBH0", "QXRQ00", "QXSJ00", "SXRXM0", "SXRQ00", "SXSJ00", "HDRXM0", "HDRXM1", "SXHS00", "SXHS01", "SXKSRQ", "SXKSSJ", "SXJSRQ", "SXJSSJ", "SXGC00", "JLRQ00", "JLSJ00", "JLRXM0", "DQBQ00", "READBZ", "JSRQ00", "JSSJ00", "ZYE000", "YKZYE0", "FXDH00", "DQKS00", "SXSQYT", "SQDFZH", "SSZT00", "SHR000", "LSTDBZ", "SXL000", "SPRQ00", "SPSJ00", "YSSPRQ", "YSSPSJ", "YWKSPR", "SPRXM0", "SFYWYX" FROM "VW_XK_SXSQ00" WHERE ((("SQRQ00") >= (?)) AND (("SQRQ00") <= (?))) AND ((("DQBQ00") = (?)) OR (("DQKS00") = (?))) ORDER BY "SQDH00" 226 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 280.000000 227 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 228 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 229 08:55:49 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH, A.JYJG00, A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.JYXMID(+)=B.JYXMID and (B.BGDJID=? or (B.BGXMMC='输血申请中输血成分个性报告' and B.BZ0000='滤白新鲜冰冻血浆') ) AND ZYID00(+)=? and A.SQDH00(+)=? order by JYXMBH 230 08:55:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 280.000000 231 08:55:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2477986.000000 232 08:55:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 090659 233 08:55:49 SQL Execute: ORACLE - SELECT B.JYXMMC,B.JYXMBH, A.JYJG00, A.ZYID00,B.BGXMID,B.JYXMID FROM XK_SQDJG0 A,VW_XK_JYBGXM B WHERE A.JYXMID(+)=B.JYXMID and (B.BGDJID=? or (B.BGXMMC='输血申请中输血成分个性报告' and B.BZ0000='滤白新鲜冰冻血浆') ) AND ZYID00(+)=? and A.SQDH00(+)=? order by JYXMBH