1 08:44:53 SQL Stmt: ORACLE - Reset 2 08:44:53 SQL Stmt: ORACLE - Close 3 08:44:53 SQL Prepare: ORACLE - Select value0,name00 from xt_xtcs00 where name00 in ('BQ_YZTZTS','BQ_CGGZTS','BQ_CWGZTS','BQ_DBGZTS') 4 08:44:53 SQL Execute: ORACLE - Select value0,name00 from xt_xtcs00 where name00 in ('BQ_YZTZTS','BQ_CGGZTS','BQ_CWGZTS','BQ_DBGZTS') 5 08:44:53 SQL Stmt: ORACLE - Fetch 6 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 1 7 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = BQ_CWGZTS 8 08:44:53 SQL Stmt: ORACLE - Fetch 9 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 1 10 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = BQ_CGGZTS 11 08:44:53 SQL Stmt: ORACLE - Fetch 12 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 1 13 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = BQ_YZTZTS 14 08:44:53 SQL Stmt: ORACLE - Fetch 15 08:44:53 SQL Stmt: ORACLE - EOF 16 08:44:53 SQL Stmt: ORACLE - Reset 17 08:44:53 SQL Stmt: ORACLE - Close 18 08:44:53 SQL Prepare: ORACLE - Select * from xt_yyxt00 where XTDM00='E' 19 08:44:53 SQL Execute: ORACLE - Select * from xt_yyxt00 where XTDM00='E' 20 08:44:53 SQL Stmt: ORACLE - Fetch 21 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XTDM00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = E 22 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = XTMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 手术麻醉管理系统 23 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XTBB00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 3.1版 24 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = BBXH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 25 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = DLFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = BMXZ00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 5 27 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = MMXSF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = PYSM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = ssmzglxt 29 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = WBSM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = rsystgtx 30 08:44:53 SQL Prepare: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00,RYZD00, TRUNC(SYSDATE)-TO_DATE(RYRQ00,'YYYYMMDD')"ZYTS00", ZZYS00,ZZYSXM FROM ZY_BRXXB0 WHERE DQBQ00=:1 AND BRZT00 in ('20','23') order by rycwh0 31 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 32 08:44:53 SQL Execute: ORACLE - SELECT RYCWH0,ZYH000,XM0000,ZYID00,RYZD00, TRUNC(SYSDATE)-TO_DATE(RYRQ00,'YYYYMMDD')"ZYTS00", ZZYS00,ZZYSXM FROM ZY_BRXXB0 WHERE DQBQ00=? AND BRZT00 in ('20','23') order by rycwh0 33 08:44:53 SQL Stmt: ORACLE - Fetch 34 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内01 35 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202435 36 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 宋方文 37 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509578.000000 38 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 39 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 40 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 41 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 42 08:44:53 SQL Stmt: ORACLE - Fetch 43 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内02 44 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202434 45 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张春竹 46 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509577.000000 47 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 48 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 49 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 50 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 51 08:44:53 SQL Stmt: ORACLE - Fetch 52 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内03 53 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202477 54 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 陈坤英 55 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511028.000000 56 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = R10.402 57 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 58 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 59 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 60 08:44:53 SQL Stmt: ORACLE - Fetch 61 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内04 62 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202410 63 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 朱丝柳 64 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508928.000000 65 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 66 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 67 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1285.000000 68 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 李鹏虹 69 08:44:53 SQL Stmt: ORACLE - Fetch 70 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内05 71 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202437 72 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 戴瑞珍 73 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509627.000000 74 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 75 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 76 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 77 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 78 08:44:53 SQL Stmt: ORACLE - Fetch 79 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内06 80 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202027 81 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 陈玉凤 82 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498183.000000 83 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 84 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 85 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 86 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 87 08:44:53 SQL Stmt: ORACLE - Fetch 88 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内07 89 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202370 90 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 赵东平 91 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 507477.000000 92 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 0 93 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16.000000 94 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1291.000000 95 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 许进 96 08:44:53 SQL Stmt: ORACLE - Fetch 97 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内08 98 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202173 99 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 李惠春 100 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 502028.000000 101 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 04 102 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 103 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 104 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 105 08:44:53 SQL Stmt: ORACLE - Fetch 106 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内09 107 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202422 108 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 于国颖 109 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509329.000000 110 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 111 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 112 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 113 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 114 08:44:53 SQL Stmt: ORACLE - Fetch 115 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内10 116 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202414 117 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王益琴 118 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509077.000000 119 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 120 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 121 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 122 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 123 08:44:53 SQL Stmt: ORACLE - Fetch 124 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内11 125 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202025 126 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张国英 127 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498181.000000 128 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 129 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 130 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 131 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 132 08:44:53 SQL Stmt: ORACLE - Fetch 133 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内12 134 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202255 135 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 徐丽森 136 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 504228.000000 137 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.104 138 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 139 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 140 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 141 08:44:53 SQL Stmt: ORACLE - Fetch 142 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内13 143 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202005 144 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 李士法 145 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 497579.000000 146 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 147 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000 148 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 149 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 150 08:44:53 SQL Stmt: ORACLE - Fetch 151 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内14 152 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202034 153 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘长澄 154 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498277.000000 155 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 156 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 157 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 158 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 159 08:44:53 SQL Stmt: ORACLE - Fetch 160 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内15 161 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202003 162 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘玉芳 163 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 497577.000000 164 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 165 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000 166 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 167 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 168 08:44:53 SQL Stmt: ORACLE - Fetch 169 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内16 170 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202089 171 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张秋泉 172 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 499781.000000 173 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 174 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 38.000000 175 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 176 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 177 08:44:53 SQL Stmt: ORACLE - Fetch 178 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内17 179 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202388 180 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 赵启华 181 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508177.000000 182 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 183 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 184 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 185 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 186 08:44:53 SQL Stmt: ORACLE - Fetch 187 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内18 188 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202026 189 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 曾平生 190 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498182.000000 191 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 192 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 193 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 194 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 195 08:44:53 SQL Stmt: ORACLE - Fetch 196 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内19 197 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202035 198 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 甘家国 199 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498278.000000 200 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 201 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 202 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 203 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 204 08:44:53 SQL Stmt: ORACLE - Fetch 205 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内20 206 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202188 207 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张凤池 208 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 502381.000000 209 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 210 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 211 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 212 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 213 08:44:53 SQL Stmt: ORACLE - Fetch 214 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内21 215 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202077 216 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘俊祥 217 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 499427.000000 218 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 04 219 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39.000000 220 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 221 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 222 08:44:53 SQL Stmt: ORACLE - Fetch 223 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内22 224 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202200 225 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 李仁 226 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 502579.000000 227 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 228 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 229 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 230 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 231 08:44:53 SQL Stmt: ORACLE - Fetch 232 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内23 233 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202302 234 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 陈秀莲 235 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 505577.000000 236 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 237 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 238 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 239 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 240 08:44:53 SQL Stmt: ORACLE - Fetch 241 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内24 242 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202509 243 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 方美英 244 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511777.000000 245 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 246 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 247 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 248 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 249 08:44:53 SQL Stmt: ORACLE - Fetch 250 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内26 251 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202393 252 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 祝振平 253 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508379.000000 254 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 255 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 256 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 257 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 258 08:44:53 SQL Stmt: ORACLE - Fetch 259 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内27 260 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202481 261 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨英 262 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511127.000000 263 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 264 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 265 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 266 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 267 08:44:53 SQL Stmt: ORACLE - Fetch 268 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内28 269 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202480 270 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 贾宛如 271 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511079.000000 272 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 273 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 274 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 275 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 276 08:44:53 SQL Stmt: ORACLE - Fetch 277 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内29 278 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202391 279 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 林坚金 280 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508327.000000 281 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 282 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 283 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 284 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 285 08:44:53 SQL Stmt: ORACLE - Fetch 286 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内30 287 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202128 288 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 冯瑞集 289 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 500728.000000 290 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 04 291 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36.000000 292 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 293 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 294 08:44:53 SQL Stmt: ORACLE - Fetch 295 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内35 296 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202082 297 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王炳麟 298 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 499627.000000 299 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I50.001 300 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39.000000 301 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 302 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 303 08:44:53 SQL Stmt: ORACLE - Fetch 304 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内36 305 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1201988 306 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 许传厚 307 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 497227.000000 308 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 309 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 310 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 311 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 312 08:44:53 SQL Stmt: ORACLE - Fetch 313 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内37 314 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202376 315 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 任学善 316 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 507677.000000 317 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = R09.801 318 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 319 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 320 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 321 08:44:53 SQL Stmt: ORACLE - Fetch 322 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内38 323 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1201880 324 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴志云 325 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 493428.000000 326 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 327 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000 328 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 329 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 330 08:44:53 SQL Stmt: ORACLE - Fetch 331 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内39 332 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202454 333 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 高振枢 334 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 510377.000000 335 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = J40 03 336 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 337 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 338 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 339 08:44:53 SQL Stmt: ORACLE - Fetch 340 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内40 341 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202127 342 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 许汇远 343 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 500727.000000 344 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 345 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36.000000 346 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 347 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 348 08:44:53 SQL Stmt: ORACLE - Fetch 349 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内41 350 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202030 351 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王健海 352 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498186.000000 353 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 354 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 355 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 356 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 357 08:44:53 SQL Stmt: ORACLE - Fetch 358 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内43 359 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202022 360 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 孟津 361 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 498178.000000 362 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 363 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 364 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 365 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 366 08:44:53 SQL Stmt: ORACLE - Fetch 367 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内44 368 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202009 369 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 高热 370 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 497678.000000 371 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.101 372 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000 373 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1666.000000 374 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林风辉 375 08:44:53 SQL Stmt: ORACLE - Fetch 376 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内45 377 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202425 378 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 曹碧珍 379 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509332.000000 380 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 381 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 382 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 383 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 384 08:44:53 SQL Stmt: ORACLE - Fetch 385 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内46 386 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202408 387 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 孙玉萍 388 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508877.000000 389 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 390 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 391 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 392 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 393 08:44:53 SQL Stmt: ORACLE - Fetch 394 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内47 395 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1201486 396 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王秀琴 397 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477077.000000 398 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I63.901 399 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 86.000000 400 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 401 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 402 08:44:53 SQL Stmt: ORACLE - Fetch 403 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内48 404 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202407 405 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘志高 406 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508829.000000 407 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 408 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 409 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 410 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 411 08:44:53 SQL Stmt: ORACLE - Fetch 412 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内49 413 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202492 414 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 廖华堂 415 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511227.000000 416 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = E78.502 417 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 418 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 419 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 420 08:44:53 SQL Stmt: ORACLE - Fetch 421 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内50 422 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202516 423 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 卢力山 424 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 512027.000000 425 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.104 426 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 427 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 428 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 429 08:44:53 SQL Stmt: ORACLE - Fetch 430 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内51 431 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202527 432 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 郑依枝 433 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 512377.000000 434 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 435 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 436 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 437 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 438 08:44:53 SQL Stmt: ORACLE - Fetch 439 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内52 440 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202398 441 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘上海 442 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508529.000000 443 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 444 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 445 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1290.000000 446 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 447 08:44:53 SQL Stmt: ORACLE - Fetch 448 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内53 449 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202386 450 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 刘赛金 451 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 508127.000000 452 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 453 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 454 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 455 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 456 08:44:53 SQL Stmt: ORACLE - Fetch 457 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内54 458 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202378 459 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 陈俊标 460 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 507777.000000 461 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 462 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 463 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 464 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 超级用户 465 08:44:53 SQL Stmt: ORACLE - Fetch 466 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内55 467 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202382 468 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 孙淑英 469 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 507927.000000 470 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 471 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 472 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 473 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 474 08:44:53 SQL Stmt: ORACLE - Fetch 475 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内56 476 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202185 477 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 李长枝 478 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 502378.000000 479 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 480 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 481 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 482 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 483 08:44:53 SQL Stmt: ORACLE - Fetch 484 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内57 485 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202421 486 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张梨俤 487 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509328.000000 488 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I25.104 489 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 490 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 491 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 492 08:44:53 SQL Stmt: ORACLE - Fetch 493 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内58 494 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202448 495 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 许水英 496 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 510127.000000 497 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 498 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 499 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 500 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 501 08:44:53 SQL Stmt: ORACLE - Fetch 502 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内59 503 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202092 504 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 潘兰英 505 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 499784.000000 506 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 04 507 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 38.000000 508 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 509 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 510 08:44:53 SQL Stmt: ORACLE - Fetch 511 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内60 512 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202485 513 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 幸禄康 514 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511131.000000 515 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 516 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 517 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1287.000000 518 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 519 08:44:53 SQL Stmt: ORACLE - Fetch 520 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内61 521 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202297 522 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 林开孙 523 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 505377.000000 524 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = E11.903 525 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 526 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1284.000000 527 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 杨月榕 528 08:44:53 SQL Stmt: ORACLE - Fetch 529 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内62 530 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202471 531 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 林逢年 532 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 510878.000000 533 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I50.001 534 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 535 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 536 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 537 08:44:53 SQL Stmt: ORACLE - Fetch 538 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内63 539 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202118 540 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王念祖 541 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 500428.000000 542 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = F03 05 543 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 37.000000 544 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1288.000000 545 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王卢敏 546 08:44:53 SQL Stmt: ORACLE - Fetch 547 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内64 548 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202491 549 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 钱金俤 550 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511182.000000 551 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 552 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 553 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1285.000000 554 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 李鹏虹 555 08:44:53 SQL Stmt: ORACLE - Fetch 556 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内65 557 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202523 558 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 严玉美 559 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 512179.000000 560 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = I10 02 561 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 562 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1286.000000 563 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 林涛 564 08:44:53 SQL Stmt: ORACLE - Fetch 565 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 心内66 566 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1202497 567 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王瑞美 568 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 511477.000000 569 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 570 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 571 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 572 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = ZZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 573 08:44:53 SQL Stmt: ORACLE - Fetch 574 08:44:53 SQL Stmt: ORACLE - EOF 575 08:44:53 SQL Stmt: ORACLE - Reset 576 08:44:53 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 577 08:44:53 SQL Misc: ORACLE - Set stored procedure on or off 578 08:44:53 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 579 08:44:53 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1202435 580 08:44:53 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 581 08:44:53 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 582 08:44:53 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 583 08:44:53 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 584 08:44:53 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 585 08:44:53 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 586 08:44:53 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 587 08:44:53 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 588 08:44:53 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 589 08:44:53 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 590 08:44:53 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 591 08:44:53 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 592 08:44:53 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 593 08:44:53 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 594 08:44:53 SQL Stmt: ORACLE - Close 595 08:44:53 SQL Prepare: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=:1 AND BQH000=:2 AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 596 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 597 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 598 08:44:53 SQL Execute: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=? AND BQH000=? AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 599 08:44:53 SQL Stmt: ORACLE - Fetch 600 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914450.000000 601 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 602 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 氨氯地平片(络活喜) 603 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 5mg 604 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qd 口服 605 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 606 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 607 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 608 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 609 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 610 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 611 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 612 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 613 08:44:53 SQL Stmt: ORACLE - Fetch 614 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914454.000000 615 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 616 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 阿托伐他汀钙片(立普妥) 617 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 10mg 618 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qn 口服 619 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 620 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 621 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 622 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 623 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 624 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 625 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 626 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 627 08:44:53 SQL Stmt: ORACLE - Fetch 628 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914456.000000 629 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 630 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 曲美他嗪片(万爽力) 631 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 20mg 632 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 633 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 634 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 635 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 636 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 637 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 638 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 639 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 640 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 641 08:44:53 SQL Stmt: ORACLE - Fetch 642 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914460.000000 643 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 644 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 阿卡波糖(拜糖平)片 645 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 50mg 646 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 (餐中即服) 647 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 648 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 649 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 650 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 651 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 652 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 653 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 654 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 655 08:44:53 SQL Stmt: ORACLE - Fetch 656 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914462.000000 657 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 658 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 非那雄胺片(保列治) 659 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 5mg 660 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qd 口服 661 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 662 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 663 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 664 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 665 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 666 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 667 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 668 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 669 08:44:53 SQL Stmt: ORACLE - Fetch 670 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915827.000000 671 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 672 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 多烯磷脂酰胆碱胶囊(易善复) 673 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 456mg 674 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 675 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 676 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 677 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 678 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 679 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 680 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 681 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 682 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 683 08:44:53 SQL Stmt: ORACLE - Fetch 684 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915831.000000 685 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 686 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 0.9%氯化钠注射液(塑)（海王） 687 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 100ml 688 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┓qd 静脉滴 689 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 690 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 691 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 692 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 693 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 694 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 695 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 696 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 697 08:44:53 SQL Stmt: ORACLE - Fetch 698 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915831.000000 699 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 700 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 胎盘多肽（泰邦制药） 701 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 4ml 702 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┛注(接瓶) 703 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 704 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 705 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 706 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 707 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 708 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 709 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 710 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 711 08:44:53 SQL Stmt: ORACLE - Fetch 712 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915834.000000 713 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 714 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 0.9%氯化钠注射液(塑)（海王） 715 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 60ml 716 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┓bid 静脉 717 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 718 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 719 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 720 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 721 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 722 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 723 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 724 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 725 08:44:53 SQL Stmt: ORACLE - Fetch 726 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915834.000000 727 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 728 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 磷酸肌酸钠针 729 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 1g 730 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┛滴注(接瓶) 731 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 732 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 733 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 734 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 735 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 736 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 737 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 738 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 739 08:44:53 SQL Stmt: ORACLE - Fetch 740 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915837.000000 741 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 742 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 氯化钠注射液 743 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 10ml 744 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┓bid 静脉 745 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 746 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 747 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 748 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 749 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 750 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 嘱托 751 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 752 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 753 08:44:53 SQL Stmt: ORACLE - Fetch 754 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915837.000000 755 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 756 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 前列地尔(碧凯)针 757 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 2ml 758 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┛注射 759 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 760 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 761 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 762 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 763 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 764 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 765 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 766 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 767 08:44:53 SQL Stmt: ORACLE - Fetch 768 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915840.000000 769 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 770 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 0.9%氯化钠注射液(塑)（海王） 771 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 250ml 772 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┓qd 静脉滴 773 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 774 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 775 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 776 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 777 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 778 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 779 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 780 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 781 08:44:53 SQL Stmt: ORACLE - Fetch 782 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9915840.000000 783 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 784 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 益气复脉（冻干） 785 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 5.2g 786 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = ┛注(特殊)(洁瑞) 787 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.02 788 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 789 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 790 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 791 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 792 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 793 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 794 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 795 08:44:53 SQL Stmt: ORACLE - Fetch 796 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9916005.000000 797 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 798 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 脾氨肽口服冻干粉（复可托） 799 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 4mg 800 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qd(中) 口服 801 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.03 802 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 803 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 804 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 805 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 806 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 807 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 808 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 809 08:44:53 SQL Stmt: ORACLE - Fetch 810 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9917677.000000 811 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 812 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 单硝酸异山梨酯(依姆多)片 813 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 30mg 814 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qn 口服 815 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.04 816 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 817 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 818 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 819 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑觅 820 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 821 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 822 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 823 08:44:53 SQL Stmt: ORACLE - Fetch 824 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9917855.000000 825 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 826 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 灭菌注射用水() 827 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 500ml 828 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = q2w(2、5) 吸氧用 829 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.04 830 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 831 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 832 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 833 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 李锦 834 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 835 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 836 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 837 08:44:53 SQL Stmt: ORACLE - Fetch 838 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9918415.000000 839 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 840 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 氨溴索片(贝莱) 841 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 30mg 842 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 843 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.04 844 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 845 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 846 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 847 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 魏大勇 848 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 849 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 850 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 851 08:44:53 SQL Stmt: ORACLE - Fetch 852 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9919141.000000 853 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 854 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 坦索罗辛片(哈乐) 855 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 0.2mg 856 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qn 口服 857 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.05 858 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 859 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 860 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 861 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 862 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 863 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 864 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 865 08:44:53 SQL Stmt: ORACLE - Fetch 866 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9919143.000000 867 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 868 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 泮托拉唑钠肠溶胶囊(诺森） 869 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 40mg 870 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = bid 口服 871 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.05 872 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 873 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 874 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 875 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 876 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 877 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 878 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 879 08:44:53 SQL Stmt: ORACLE - Fetch 880 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9919145.000000 881 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 882 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 瑞巴派特片(膜固思达) 883 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 0.1g 884 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 885 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.05 886 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 887 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 888 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 889 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 890 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 891 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 892 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 893 08:44:53 SQL Stmt: ORACLE - Fetch 894 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9919357.000000 895 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 896 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 辅酶Q10胶囊 897 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 10mg 898 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = tid 口服 899 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.05 900 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 901 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 902 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 903 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 张忠武 904 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 905 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 906 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 907 08:44:53 SQL Stmt: ORACLE - Fetch 908 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9919371.000000 909 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 910 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 左氧氟沙星片(可乐必妥) 911 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 0.2g 912 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = bid 口服 913 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.05 914 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 915 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 916 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 917 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 918 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 919 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 920 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 921 08:44:53 SQL Stmt: ORACLE - Fetch 922 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9921039.000000 923 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 924 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 坎地沙坦西酯(必洛斯)片 925 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = YL0000, Type = fldZSTRING, Precision = 47, Scale = 0, Data = 8mg 926 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = YZNR01, Type = fldZSTRING, Precision = 40, Scale = 0, Data = qd(中) 口服 927 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = QYRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.06 928 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 929 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = TQRQSJ, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.10 930 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = TS0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 931 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = KZYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 郑觅 932 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 933 08:44:53 SQL Data Out: ORACLE - Column = 12, Name = ZYL000, Type = fldZSTRING, Precision = 48, Scale = 0, Data = NULL 934 08:44:53 SQL Data Out: ORACLE - Column = 13, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 935 08:44:53 SQL Stmt: ORACLE - Fetch 936 08:44:53 SQL Stmt: ORACLE - EOF 937 08:44:53 SQL Stmt: ORACLE - Reset 938 08:44:53 SQL Prepare: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =:1 and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=:2 and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=:3 and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = :4 and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 939 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 940 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 941 08:44:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 942 08:44:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 943 08:44:53 SQL Execute: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =? and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = ? and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 944 08:44:53 SQL Stmt: ORACLE - Fetch 945 08:44:53 SQL Stmt: ORACLE - EOF 946 08:44:53 SQL Stmt: ORACLE - Reset 947 08:44:53 SQL Prepare: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=:1 AND BQH000=:2 and yzzt00 in ('1','2') 948 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 949 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 950 08:44:53 SQL Execute: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=? AND BQH000=? and yzzt00 in ('1','2') 951 08:44:53 SQL Stmt: ORACLE - Fetch 952 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZMXID, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914518.000000 953 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 954 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 测血压 955 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = PCMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = tid 956 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = TQRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/9/2012 0:0:0:0 957 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 958 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 959 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 960 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = CX0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 961 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心血管内科 962 08:44:53 SQL Stmt: ORACLE - Fetch 963 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZMXID, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914520.000000 964 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 965 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 中心吸氧 966 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = PCMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = tid 967 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = TQRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/9/2012 0:0:0:0 968 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 969 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 970 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 4小时 971 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = CX0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 972 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心血管内科 973 08:44:53 SQL Stmt: ORACLE - Fetch 974 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZMXID, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914281.000000 975 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 976 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 病房空调降温费—双人间 977 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = PCMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = qd 978 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = TQRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/9/2012 0:0:0:0 979 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 980 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 981 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1日 982 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = CX0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 983 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心血管内科 984 08:44:53 SQL Stmt: ORACLE - Fetch 985 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YZMXID, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9914282.000000 986 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长嘱 987 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = Ⅱ级护理 988 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = PCMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = qd 989 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = TQRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/9/2012 0:0:0:0 990 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YZCLLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 正常 991 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 992 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1日 993 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = CX0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 994 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心血管内科 995 08:44:53 SQL Stmt: ORACLE - Fetch 996 08:44:53 SQL Stmt: ORACLE - EOF 997 08:44:53 SQL Stmt: ORACLE - Reset 998 08:44:53 SQL Prepare: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=:1 AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 999 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1000 08:44:53 SQL Execute: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=? AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 1001 08:44:53 SQL Stmt: ORACLE - Fetch 1002 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 183015.000000 1003 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长期 1004 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 住院诊查费 1005 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = SFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 2.000000 1006 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = CS0000, Type = fldFLOAT, Precision = 7, Scale = 2, Data = 1.000000 1007 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = DW0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 日 1008 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = XMLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 常规 1009 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = GZRQ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.09 1010 08:44:53 SQL Stmt: ORACLE - Fetch 1011 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 183014.000000 1012 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = CLBZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 长期 1013 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = A类双人间（省级） 1014 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = SFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 55.000000 1015 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = CS0000, Type = fldFLOAT, Precision = 7, Scale = 2, Data = 1.000000 1016 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = DW0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 床日 1017 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = XMLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 床位 1018 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = GZRQ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.09 1019 08:44:53 SQL Stmt: ORACLE - Fetch 1020 08:44:53 SQL Stmt: ORACLE - EOF 1021 08:44:53 SQL Stmt: ORACLE - Reset 1022 08:44:53 SQL Prepare: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=:1 AND Z.BQH000=:2 AND Z.YZID00=D.YZID00 AND D.ZYID00=:3 order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 1023 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1024 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1025 08:44:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1026 08:44:53 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=? AND Z.BQH000=? AND Z.YZID00=D.YZID00 AND D.ZYID00=? order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 1027 08:44:53 SQL Stmt: ORACLE - Fetch 1028 08:44:53 SQL Stmt: ORACLE - EOF 1029 08:44:53 SQL Stmt: ORACLE - Reset 1030 08:44:53 SQL Prepare: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00, decode(thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND BQBMBH=:1 and zyid00=:2 and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 1031 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1032 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1033 08:44:53 SQL Execute: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00, decode(thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND BQBMBH=? and zyid00=? and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 1034 08:44:53 SQL Stmt: ORACLE - Fetch 1035 08:44:53 SQL Stmt: ORACLE - EOF 1036 08:44:53 SQL Stmt: ORACLE - Reset 1037 08:44:53 SQL Prepare: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00, decode(m.thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 --AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=:1 AND ZYID00=:2 AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 1038 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1039 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1040 08:44:53 SQL Execute: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00, decode(m.thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 --AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 1041 08:44:53 SQL Stmt: ORACLE - Fetch 1042 08:44:53 SQL Stmt: ORACLE - EOF 1043 08:44:53 SQL Stmt: ORACLE - Reset 1044 08:44:53 SQL Prepare: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=:1 1045 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1046 08:44:53 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 1047 08:44:53 SQL Stmt: ORACLE - Fetch 1048 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 509578.000000 1049 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZDLBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 入院诊断 1050 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZDMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 高血压(病) 1051 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZDRQ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.08.01 1052 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = ZDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:16:54 1053 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = SFYZMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 1054 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZLXGMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 其他 1055 08:44:53 SQL Stmt: ORACLE - Fetch 1056 08:44:53 SQL Stmt: ORACLE - EOF 1057 08:44:53 SQL Stmt: ORACLE - Reset 1058 08:44:53 SQL Prepare: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00 in ('0','1') AND Y.zje000>0 and kdbq00=:1 and zyghid=:2 and nvl(cxdjh0,0)=0 AND YJLRBZ='N' order by kdrq00 1059 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1060 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1061 08:44:53 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00 in ('0','1') AND Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND YJLRBZ='N' order by kdrq00 1062 08:44:53 SQL Stmt: ORACLE - Fetch 1063 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136057.000000 1064 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 粪便检查+OB 1065 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1066 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 25.000000 1067 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1068 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1069 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1070 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1071 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1072 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1073 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1074 08:44:53 SQL Stmt: ORACLE - Fetch 1075 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136069.000000 1076 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 血糖(GLU) 1077 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1078 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 3.000000 1079 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1080 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1081 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1082 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1083 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1084 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1085 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1086 08:44:53 SQL Stmt: ORACLE - Fetch 1087 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136070.000000 1088 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 肝功17项（TP PA ALB GLB TBIL DBIL IBIL AST ALT ALP 5'-NT GGT AFU ADA TBA CHE MAO) 1089 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1090 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 102.500000 1091 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1092 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1093 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1094 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1095 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1096 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1097 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1098 08:44:53 SQL Stmt: ORACLE - Fetch 1099 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136082.000000 1100 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = TEG肝素酶对比检测600元(高岭土+肝素酶) 1101 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1102 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 600.000000 1103 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1104 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1105 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1106 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1107 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1108 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1109 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1110 08:44:53 SQL Stmt: ORACLE - Fetch 1111 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136072.000000 1112 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 电解质4项(K Na CL nCa) 1113 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1114 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 18.000000 1115 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1116 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1117 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1118 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1119 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1120 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1121 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1122 08:44:53 SQL Stmt: ORACLE - Fetch 1123 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136073.000000 1124 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 微量元素4项(Ca P Mg Fe) 1125 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1126 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 17.000000 1127 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1128 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1129 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1130 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1131 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1132 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1133 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1134 08:44:53 SQL Stmt: ORACLE - Fetch 1135 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 8136071.000000 1136 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 血脂7项(TG CHOL HDL-C LDL-C APOA APOB LPa) 1137 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = SL0000, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 1 1138 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 57.000000 1139 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 检验科 1140 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 1141 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = KDYSXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 王世红 1142 08:44:53 SQL Data Out: ORACLE - Column = 8, Name = KDRQSJ, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/1/2012 20:36:12:0 1143 08:44:53 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 计价 1144 08:44:53 SQL Data Out: ORACLE - Column = 10, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 1145 08:44:53 SQL Data Out: ORACLE - Column = 11, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 1146 08:44:53 SQL Stmt: ORACLE - Fetch 1147 08:44:53 SQL Stmt: ORACLE - EOF 1148 08:44:53 SQL Stmt: ORACLE - Reset 1149 08:44:53 SQL Prepare: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'2','已收费','已收费')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00='2' and Y.zje000>0 and kdbq00=:1 and zyghid=:2 and nvl(cxdjh0,0)=0 AND YJLRBZ='N' and not exists (select 1 from yj_yw0000 where cxdjh0=y.yjdjh0) order by kdrq00 1150 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1151 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1152 08:44:53 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'2','已收费','已收费')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1'and xmzt00='2' and Y.zje000>0 and kdbq00=? and zyghid=? and nvl(cxdjh0,0)=0 AND YJLRBZ='N' and not exists (select 1 from yj_yw0000 where cxdjh0=y.yjdjh0) order by kdrq00 1153 08:44:53 SQL Stmt: ORACLE - Fetch 1154 08:44:53 SQL Stmt: ORACLE - EOF 1155 08:44:53 SQL Stmt: ORACLE - Reset 1156 08:44:53 SQL Prepare: ORACLE - select 0 YPQLPC,C.CFLSH0,YPMC00,YPGG00, TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00, TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND CFZT00 IN ('0') AND DQBQ00=:1 AND ZYID00=:2 AND CXBZ00 IN ('Z') AND CFSRBZ NOT IN ('4','5','6','7') 1157 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1158 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1159 08:44:53 SQL Execute: ORACLE - select 0 YPQLPC,C.CFLSH0,YPMC00,YPGG00, TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00, TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ NOT IN ('4','5','6','7') 1160 08:44:53 SQL Stmt: ORACLE - Fetch 1161 08:44:53 SQL Stmt: ORACLE - EOF 1162 08:44:53 SQL Stmt: ORACLE - Reset 1163 08:44:53 SQL Prepare: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1' and xmzt00 in ('0','1') AND (kdbq00=:1 and YJLRBZ='Y' or YJLRBZ='S') and zyghid=:2 and nvl(cxdjh0,0)=0 union all select SSDH00 yjdjh0,SSMC00 ZLXMJC,'1次' SL0000, to_number(NULL) ZJE000,SQKSMC bmmc00,NULL YEXM00, SQYSXM KDYSXM,TO_DATE(SQRQSJ,'yyyymmddhh24:mi:ss') KDRQSJ, DECODE(SSFYBZ,'0','申请','1','计价')XMZT00,to_number(NULL) CXDJH0,NULL bz0000 from vw_ss_yw0000 where ZYGHID=:3 and SSFYBZ in ('0','1') and MZFYBZ in ('0','1') and sszt00<>'1' and srkslb='0' order by bmmc00,KDRQSJ 1164 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1165 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1166 08:44:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1167 08:44:53 SQL Execute: ORACLE - select yjdjh0,ZLXMJC,to_char(SL0000)||DW0000 SL0000,ZJE000,bmmc00,YEXM00, KDYSXM,TO_DATE(KDRQ00||KDSJ00,'yyyymmddhh24:mi:ss')KDRQSJ, DECODE(XMZT00,'0','申请','1','计价')XMZT00,CXDJH0,BZ0000 FROM BM_BMBM00 B,YJ_YW0000 Y where Y.YJKSBH=B.BMBH00 AND mzzybz='1' and xmzt00 in ('0','1') AND (kdbq00=? and YJLRBZ='Y' or YJLRBZ='S') and zyghid=? and nvl(cxdjh0,0)=0 union all select SSDH00 yjdjh0,SSMC00 ZLXMJC,'1次' SL0000, to_number(NULL) ZJE000,SQKSMC bmmc00,NULL YEXM00, SQYSXM KDYSXM,TO_DATE(SQRQSJ,'yyyymmddhh24:mi:ss') KDRQSJ, DECODE(SSFYBZ,'0','申请','1','计价')XMZT00,to_number(NULL) CXDJH0,NULL bz0000 from vw_ss_yw0000 where ZYGHID=? and SSFYBZ in ('0','1') and MZFYBZ in ('0','1') and sszt00<>'1' and srkslb='0' order by bmmc00,KDRQSJ 1168 08:44:53 SQL Stmt: ORACLE - Fetch 1169 08:44:53 SQL Stmt: ORACLE - EOF 1170 08:44:53 SQL Stmt: ORACLE - Reset 1171 08:44:53 SQL Prepare: ORACLE - select p.xmmc00,sum(y.hjje00)hjje00,sum(y.zfje00)zfje00, sum(y.jzje00)jzje00,sum(y.gfje00)gfje00 from zy_fymx00 y,bm_yysfxm s,zy_brfy00 f,bm_fpxm00 p where y.xmbh00=s.sfxmid and f.djh000=y.djh000 and s.zyfpid=p.fpxmid and zyid00=:1 group by p.xmmc00 1172 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1173 08:44:53 SQL Execute: ORACLE - select p.xmmc00,sum(y.hjje00)hjje00,sum(y.zfje00)zfje00, sum(y.jzje00)jzje00,sum(y.gfje00)gfje00 from zy_fymx00 y,bm_yysfxm s,zy_brfy00 f,bm_fpxm00 p where y.xmbh00=s.sfxmid and f.djh000=y.djh000 and s.zyfpid=p.fpxmid and zyid00=? group by p.xmmc00 1174 08:44:53 SQL Stmt: ORACLE - Fetch 1175 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = CT费 1176 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 572.000000 1177 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 572.000000 1178 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1179 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1180 08:44:53 SQL Stmt: ORACLE - Fetch 1181 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 彩超费 1182 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 425.000000 1183 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 425.000000 1184 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1185 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1186 08:44:53 SQL Stmt: ORACLE - Fetch 1187 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 草药费 1188 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.750000 1189 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.750000 1190 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1191 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1192 08:44:53 SQL Stmt: ORACLE - Fetch 1193 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 成药费 1194 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 209.050000 1195 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 209.050000 1196 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1197 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1198 08:44:53 SQL Stmt: ORACLE - Fetch 1199 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 床位费 1200 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 540.000000 1201 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 540.000000 1202 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1203 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1204 08:44:53 SQL Stmt: ORACLE - Fetch 1205 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 护理费 1206 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 90.000000 1207 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 90.000000 1208 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1209 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1210 08:44:53 SQL Stmt: ORACLE - Fetch 1211 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 化验费 1212 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6398.500000 1213 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6398.500000 1214 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1215 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1216 08:44:53 SQL Stmt: ORACLE - Fetch 1217 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 检查费 1218 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 1219 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1220.000000 1220 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1221 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1222 08:44:53 SQL Stmt: ORACLE - Fetch 1223 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 其它医疗 1224 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 199.230000 1225 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 199.230000 1226 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1227 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1228 08:44:53 SQL Stmt: ORACLE - Fetch 1229 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 输氧费 1230 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 432.000000 1231 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 432.000000 1232 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1233 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1234 08:44:53 SQL Stmt: ORACLE - Fetch 1235 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 西药费 1236 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8569.390000 1237 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8569.390000 1238 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1239 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1240 08:44:53 SQL Stmt: ORACLE - Fetch 1241 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 诊察费 1242 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 1243 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 1244 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1245 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1246 08:44:53 SQL Stmt: ORACLE - Fetch 1247 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 治疗费 1248 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 165.000000 1249 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 165.000000 1250 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1251 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1252 08:44:53 SQL Stmt: ORACLE - Fetch 1253 08:44:53 SQL Stmt: ORACLE - EOF 1254 08:44:53 SQL Stmt: ORACLE - Reset 1255 08:44:53 SQL Prepare: ORACLE - select decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC) XMMC00,c.BAXMID FPXMID,sum(a.HJJE00) HJJE00, sum(a.ZFJE00) ZFJE00 from ZY_FYMX00 a,BM_YYSFXM b,BM_BAXM00 c,ZY_BRFY00 d where a.XMBH00 = b.SFXMID and b.BAXMID = c.BAXMID(+) and d.DJH000 = a.DJH000 and d.ZYID00 =:1 group by decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC),c.BAXMID order by c.BAXMID 1256 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 509578.000000 1257 08:44:53 SQL Execute: ORACLE - select decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC) XMMC00,c.BAXMID FPXMID,sum(a.HJJE00) HJJE00, sum(a.ZFJE00) ZFJE00 from ZY_FYMX00 a,BM_YYSFXM b,BM_BAXM00 c,ZY_BRFY00 d where a.XMBH00 = b.SFXMID and b.BAXMID = c.BAXMID(+) and d.DJH000 = a.DJH000 and d.ZYID00 =? group by decode(nvl(c.BAXMMC,''),'','未归档',c.BAXMMC),c.BAXMID order by c.BAXMID 1258 08:44:53 SQL Stmt: ORACLE - Fetch 1259 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 一般医疗服务费 1260 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 101.000000 1261 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 1262 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 1263 08:44:53 SQL Stmt: ORACLE - Fetch 1264 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 一般治疗操作费 1265 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 102.000000 1266 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 597.000000 1267 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 597.000000 1268 08:44:53 SQL Stmt: ORACLE - Fetch 1269 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 护理费 1270 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 103.000000 1271 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 90.000000 1272 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 90.000000 1273 08:44:53 SQL Stmt: ORACLE - Fetch 1274 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 其他费用 1275 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 104.000000 1276 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 540.000000 1277 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 540.000000 1278 08:44:53 SQL Stmt: ORACLE - Fetch 1279 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 实验室诊断费 1280 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 106.000000 1281 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6398.500000 1282 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6398.500000 1283 08:44:53 SQL Stmt: ORACLE - Fetch 1284 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 影像学诊断费 1285 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 107.000000 1286 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1007.000000 1287 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1007.000000 1288 08:44:53 SQL Stmt: ORACLE - Fetch 1289 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 临床诊断项目费 1290 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 108.000000 1291 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 250.000000 1292 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 250.000000 1293 08:44:53 SQL Stmt: ORACLE - Fetch 1294 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 非手术治疗项目费 1295 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 109.000000 1296 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 960.000000 1297 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 960.000000 1298 08:44:53 SQL Stmt: ORACLE - Fetch 1299 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 中医治疗费 1300 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 112.000000 1301 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 1302 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 1303 08:44:53 SQL Stmt: ORACLE - Fetch 1304 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 西药费 1305 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 113.000000 1306 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8569.390000 1307 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8569.390000 1308 08:44:53 SQL Stmt: ORACLE - Fetch 1309 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 中成药费 1310 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 114.000000 1311 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 209.050000 1312 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 209.050000 1313 08:44:53 SQL Stmt: ORACLE - Fetch 1314 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 中草药费 1315 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = FPXMID, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 115.000000 1316 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.750000 1317 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.750000 1318 08:44:53 SQL Stmt: ORACLE - Close 1319 08:44:53 SQL Stmt: ORACLE - Close 1320 08:44:53 SQL Stmt: ORACLE - Close 1321 08:44:53 SQL Stmt: ORACLE - Close 1322 08:44:53 SQL Stmt: ORACLE - Close 1323 08:44:53 SQL Stmt: ORACLE - Close 1324 08:44:53 SQL Stmt: ORACLE - Close 1325 08:44:53 SQL Stmt: ORACLE - Close 1326 08:44:53 SQL Stmt: ORACLE - Close 1327 08:44:53 SQL Stmt: ORACLE - Close 1328 08:44:53 SQL Stmt: ORACLE - Close 1329 08:44:53 SQL Prepare: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 1330 08:44:53 SQL Misc: ORACLE - Set stored procedure on or off 1331 08:44:53 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1332 08:44:53 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1202297 1333 08:44:53 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1334 08:44:53 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1335 08:44:53 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1336 08:44:53 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1337 08:44:53 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1338 08:44:53 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1339 08:44:53 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1340 08:44:53 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1341 08:44:53 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1342 08:44:53 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1343 08:44:53 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1344 08:44:53 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1345 08:44:53 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1346 08:44:53 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 1347 08:44:53 SQL Stmt: ORACLE - Close 1348 08:44:53 SQL Prepare: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=:1 AND BQH000=:2 AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 1349 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1350 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1351 08:44:53 SQL Execute: ORACLE - SELECT YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')TQRQSJ, TS0000,KZYSXM,YZCLLB,ZYL000,YEXM00 FROM VW_BQ_YPYZTQ WHERE ZYID00=? AND BQH000=? AND YZZT00 IN ('1','2') order by QYRQSJ,clbz00,lbmc00,yzid00,yzmxid 1352 08:44:53 SQL Stmt: ORACLE - Fetch 1353 08:44:53 SQL Stmt: ORACLE - EOF 1354 08:44:53 SQL Stmt: ORACLE - Reset 1355 08:44:53 SQL Stmt: ORACLE - Close 1356 08:44:53 SQL Prepare: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =:1 and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=:2 and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=:3 and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = :4 and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 1357 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1358 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1359 08:44:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1360 08:44:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1361 08:44:53 SQL Execute: ORACLE - select c.ypmc00 xmmc00,c.ypzsl0 zsl000,ROUND(c.YPZSL0*c.LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_ZYCF00 A,BM_YGBM00 B,yf_zycfmx c where A.CZY000 = B.YGBH00 and ZYID00 =? and a.cflsh0=c.cflsh0 and a.CFZT00 in('0','5') and BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.CFZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.CFZT00<>'0') ) union all select a.zlxmjc xmmc00,a.sl0000 zsl000,a.zje000 zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 A where a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid>0 union all select c.xmmc00 xmmc00,b.sl0000 zsl000,round(b.sl0000*b.sfcs00*b.jjje00,2) zje000,a.kdrq00 sqrq00,a.kdsj00 sqsj00,a.lrxm00 sqrxm0 from yj_yw0000 a,yj_ywjj00 b,bm_yysfxm c where a.yjdjh0=b.yjdjh0 and b.sfxmid=c.sfxmid and a.zyghid=? and a.MZZYBZ = '1' and a.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.zyghid and SFDJH0 in ( select DJH000 from ZY_BRFY00 where ZYID00=A.zyghid and JZDH00+0 = 0 )) and a.XMZT00 in ('0','1') and a.SFDJH0+0 = 0 and a.zlxmid=0 union all select A.ypmc00 xmmc00,a.ypzsl0 zsl000,ROUND(YPZSL0*LSDJ00,2) zje000,a.srrq00 sqrq00,a.srsj00 sqsj00,B.ZWXM00 sqrxm0 from YF_YZYPSQ A,BM_YGBM00 B where A.CZY000 = B.YGBH00 and ZYID00 = ? and QLZT00 in ('0','5') and CXPCID in (select YPQLPC from YF_YZYPSQ E,ZY_BRFY00 F where E.DJH000 = F.DJH000 and F.JZDH00+0 = 0 and F.ZYID00=A.ZYID00 and (A.QLZT00='0' and nvl(E.FYRQ00,'20991231')='20991231' or A.QLZT00<>'0') ) 1362 08:44:53 SQL Stmt: ORACLE - Fetch 1363 08:44:53 SQL Stmt: ORACLE - EOF 1364 08:44:53 SQL Stmt: ORACLE - Reset 1365 08:44:53 SQL Prepare: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=:1 AND BQH000=:2 and yzzt00 in ('1','2') 1366 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1367 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1368 08:44:53 SQL Execute: ORACLE - SELECT YZMXID,DECODE(Y.CLBZ00,'0','长嘱','1','短嘱') AS CLBZ00, ZLXMJC,PCMC00,TO_DATE(TQRQ00,'YYYYMMDD') AS TQRQSJ, YZCLLB,YEXM00,MCSL00||DW0000 SL0000,TS0000||TSDW00 CX0000,BMMC00 FROM BQ_YJYZ00 Y,BM_BMBM00 B WHERE Y.ZXKS00=B.BMBH00 AND ZYID00=? AND BQH000=? and yzzt00 in ('1','2') 1369 08:44:53 SQL Stmt: ORACLE - Fetch 1370 08:44:53 SQL Stmt: ORACLE - EOF 1371 08:44:53 SQL Stmt: ORACLE - Reset 1372 08:44:53 SQL Prepare: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=:1 AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 1373 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1374 08:44:53 SQL Execute: ORACLE - SELECT ID0000,DECODE(CLBZ00,'0','长期','零星')CLBZ00,XMMC00, SFJE00,CS0000,DW0000, DECODE(XMLB00,'0','常规','1','床位','代办') xmlb00, TO_CHAR(TO_DATE(GZRQ00,'YYYYMMDD'),'YYYY.MM.DD')GZRQ00 FROM BQ_JZXM00 WHERE ZYID00=? AND TZRQ00 IS NULL AND XMLB00 IN ('0','1','2') order by XMLB00,clbz00,GZRQ00 1375 08:44:53 SQL Stmt: ORACLE - Fetch 1376 08:44:53 SQL Stmt: ORACLE - EOF 1377 08:44:53 SQL Stmt: ORACLE - Reset 1378 08:44:53 SQL Prepare: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=:1 AND Z.BQH000=:2 AND Z.YZID00=D.YZID00 AND D.ZYID00=:3 order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 1379 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1380 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1381 08:44:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1382 08:44:53 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(Z.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,YL0000,YZNR01,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", LBMC00,KZYSXM,YZCLLB,TO_DATE(D.QSRQ00||D.QSSJ00,'YYYYMMDDHH24:MI:SS')QSRQSJ, TO_DATE(DECODE(TO_DATE(JSRQ00,'YYYYMMDD')-1, TO_DATE(QSRQ00,'YYYYMMDD'),NULL, JSRQ00||JSSJ00),'YYYYMMDDHH24:MI:SS')-1 JSRQSJ, JSRQ00,D.CS0000 FROM VW_BQ_YPYZMX Z,VW_BQ_YZZXJL_XYZX D WHERE Z.ZYID00=? AND Z.BQH000=? AND Z.YZID00=D.YZID00 AND D.ZYID00=? order by JSRQ00,clbz00,lbmc00,yzid00,yzmxid 1383 08:44:53 SQL Stmt: ORACLE - Fetch 1384 08:44:53 SQL Stmt: ORACLE - EOF 1385 08:44:53 SQL Stmt: ORACLE - Reset 1386 08:44:53 SQL Prepare: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00, decode(thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND BQBMBH=:1 and zyid00=:2 and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 1387 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1388 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1389 08:44:53 SQL Execute: ORACLE - SELECT YPQLPC,'0'CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||qldw00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000,TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,S.ZWXM00 YS0000,B.BMMC00 YFMC00, decode(thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_yzypsq Y,BM_BMBM00 B,BM_YGBM00 H,BM_YGBM00 S where Y.YFBMBH=B.BMBH00 AND Y.YSGZH0=S.YGBH00(+) AND Y.CZY000=H.YGBH00(+) AND BQBMBH=? and zyid00=? and qlzt00 IN ('0') AND CXBZ00 IN ('Z') 1390 08:44:53 SQL Stmt: ORACLE - Fetch 1391 08:44:53 SQL Stmt: ORACLE - EOF 1392 08:44:53 SQL Stmt: ORACLE - Reset 1393 08:44:53 SQL Prepare: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00, decode(m.thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 --AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=:1 AND ZYID00=:2 AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 1394 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000 1395 08:44:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1396 08:44:53 SQL Execute: ORACLE - select C.CFLSH0,YPMC00,YPGG00,TO_CHAR(ypzsl0)||CFDW00 YPSL00,ZYTS00,TO_CHAR(CSL000)||JLDW00||' '||pcmc00||' '||ypyfmc YF0000, YPZSL0*LSDJ00 JE0000, TO_DATE(SRRQ00||SRSJ00,'yyyymmddHH24:MI:SS')KDRQSJ,CXBZ00, DECODE(c.YPDLBH,'0','西药','1','成药','2','草药')YPDLBH, H.ZWXM00 LRRXM0,YSXM00 YS0000,B.BMMC00 YFMC00, decode(cfsrbz,'4','普通','5','带药','6','毒麻')cflb00, decode(m.thbz00,'0',null,'1','错误','2','缺药','3','缺钱','4','其他')bz0000 from yf_zycf00 c,yf_zycfmx M,BM_BMBM00 B,BM_YGBM00 H WHERE C.CFLSH0=M.CFLSH0 AND C.YFBMBH=B.BMBH00 AND C.CZY000=H.YGBH00 --AND SFKSLY='Y' AND CFZT00 IN ('0') AND DQBQ00=? AND ZYID00=? AND CXBZ00 IN ('Z') AND CFSRBZ in ('4','5','6','7') 1397 08:44:53 SQL Stmt: ORACLE - Fetch 1398 08:44:53 SQL Stmt: ORACLE - EOF 1399 08:44:53 SQL Stmt: ORACLE - Reset 1400 08:44:53 SQL Prepare: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=:1 1401 08:44:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505377.000000 1402 08:44:53 SQL Execute: ORACLE - select zyid00,zdlbmc,zdmc00,zdrq00,zdsj00,sfyzmc,zlxgmc from VW_BQ_BRZDXX where zyid00=? 1403 08:44:53 SQL Stmt: ORACLE - Fetch 1404 08:44:53 SQL Data Out: ORACLE - Column = 1, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 505377.000000 1405 08:44:53 SQL Data Out: ORACLE - Column = 2, Name = ZDLBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 门诊诊断 1406 08:44:53 SQL Data Out: ORACLE - Column = 3, Name = ZDMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 糖尿病(Ⅱ型) 1407 08:44:53 SQL Data Out: ORACLE - Column = 4, Name = ZDRQ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.07.19 1408 08:44:53 SQL Data Out: ORACLE - Column = 5, Name = ZDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:11:37 1409 08:44:53 SQL Data Out: ORACLE - Column = 6, Name = SFYZMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 1410 08:44:53 SQL Data Out: ORACLE - Column = 7, Name = ZLXGMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 其他 1411 08:44:53 SQL Stmt: ORACLE - Fetch 1412 08:44:53 SQL Error: ORACLE - ORA-01861: 文字与格式字符串不匹配 1413 08:44:53 SQL Error: ORACLE - Unmapped SQL Error Code: 1861 1414 08:44:53 SQL Stmt: ORACLE - ERROR 1415 08:44:53 SQL Stmt: ORACLE - Reset