5215 09:27:24 SQL Data Out: ORACLE - Column = 17, Name = COLOR0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 5216 09:27:24 SQL Stmt: ORACLE - Reset 5217 09:27:24 SQL Stmt: ORACLE - Close 5218 09:27:24 SQL Prepare: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=:1 and YBBRLB=:2 and YBZXLB=:3 5219 09:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 5220 09:27:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5221 09:27:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5222 09:27:24 SQL Execute: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=? and YBBRLB=? and YBZXLB=? 5223 09:27:24 SQL Stmt: ORACLE - Fetch 5224 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = JLS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5225 09:27:24 SQL Stmt: ORACLE - Reset 5226 09:27:24 SQL Stmt: ORACLE - Close 5227 09:27:24 SQL Prepare: ORACLE - select a.tsbzbh bh0000,a.tsbzmc mc0000 from VW_SF_YBTZBZ A where 1=1 and a.djh000+0=0 and A.BRID00 = :1 and trim(a.tsbzbh) is not null and a.GHH000= :2 group by a.tsbzbh,a.tsbzmc 5228 09:27:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5229 09:27:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5230 09:27:24 SQL Execute: ORACLE - select a.tsbzbh bh0000,a.tsbzmc mc0000 from VW_SF_YBTZBZ A where 1=1 and a.djh000+0=0 and A.BRID00 = ? and trim(a.tsbzbh) is not null and a.GHH000= ? group by a.tsbzbh,a.tsbzmc 5231 09:27:24 SQL Stmt: ORACLE - Fetch 5232 09:27:24 SQL Stmt: ORACLE - EOF 5233 09:27:24 SQL Stmt: ORACLE - Reset 5234 09:27:24 SQL Prepare: ORACLE - select GHID00,BRID00 from sf_brxxb0 where GHH000 = '1339461' 5235 09:27:24 SQL Execute: ORACLE - select GHID00,BRID00 from sf_brxxb0 where GHH000 = '1339461' 5236 09:27:24 SQL Stmt: ORACLE - Fetch 5237 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = GHID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2515926.000000 5238 09:27:24 SQL Data Out: ORACLE - Column = 2, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5239 09:27:24 SQL Stmt: ORACLE - Reset 5240 09:27:24 SQL Stmt: ORACLE - Close 5241 09:27:24 SQL Prepare: ORACLE - select * from XT_YBTSBZ WHERE brid00= 848440 and CZRQ00||CZSJ00=(select MAX(CZRQ00||CZSJ00) from XT_YBTSBZ where brid00= 848440) 5242 09:27:24 SQL Execute: ORACLE - select * from XT_YBTSBZ WHERE brid00= 848440 and CZRQ00||CZSJ00=(select MAX(CZRQ00||CZSJ00) from XT_YBTSBZ where brid00= 848440) 5243 09:27:24 SQL Stmt: ORACLE - Fetch 5244 09:27:24 SQL Stmt: ORACLE - EOF 5245 09:27:24 SQL Stmt: ORACLE - Reset 5246 09:27:24 SQL Stmt: ORACLE - Close 5247 09:27:24 SQL Prepare: ORACLE - select * from VW_SF_YBTZBZ where ghid00=2515926 and 1=2 5248 09:27:24 SQL Execute: ORACLE - select * from VW_SF_YBTZBZ where ghid00=2515926 and 1=2 5249 09:27:24 SQL Stmt: ORACLE - Fetch 5250 09:27:24 SQL Stmt: ORACLE - EOF 5251 09:27:24 SQL Stmt: ORACLE - Reset 5252 09:27:24 SQL Stmt: ORACLE - Close 5253 09:27:24 SQL Prepare: ORACLE - select YBZXLB from ic_ybbrlb where YBLB00 = '2' 5254 09:27:24 SQL Execute: ORACLE - select YBZXLB from ic_ybbrlb where YBLB00 = '2' 5255 09:27:24 SQL Stmt: ORACLE - Fetch 5256 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5257 09:27:24 SQL Stmt: ORACLE - Reset 5258 09:27:24 SQL Stmt: ORACLE - Close 5259 09:27:24 SQL Prepare: ORACLE - select BH0000||'_'||MC0000 TSBZ00 from BM_TSBZB0 where YBZXLB = '2' 5260 09:27:24 SQL Execute: ORACLE - select BH0000||'_'||MC0000 TSBZ00 from BM_TSBZB0 where YBZXLB = '2' 5261 09:27:24 SQL Stmt: ORACLE - Fetch 5262 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000001_恶性肿瘤化学治疗和放射治疗 5263 09:27:24 SQL Stmt: ORACLE - Fetch 5264 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000002_重症尿毒症透析 5265 09:27:24 SQL Stmt: ORACLE - Fetch 5266 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000003_结核病规范治疗 5267 09:27:24 SQL Stmt: ORACLE - Fetch 5268 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000004_器官移植抗排异反映治疗 5269 09:27:24 SQL Stmt: ORACLE - Fetch 5270 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000005_精神分裂症治疗 5271 09:27:24 SQL Stmt: ORACLE - Fetch 5272 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000001000006_危重病的抢救 5273 09:27:24 SQL Stmt: ORACLE - Fetch 5274 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000002000001_高血压病 5275 09:27:24 SQL Stmt: ORACLE - Fetch 5276 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000002000002_糖尿病 5277 09:27:24 SQL Stmt: ORACLE - Fetch 5278 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000002000003_再生障碍性贫血 5279 09:27:24 SQL Stmt: ORACLE - Fetch 5280 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000002000004_慢性心功能衰竭 5281 09:27:24 SQL Stmt: ORACLE - Fetch 5282 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = TSBZ00, Type = fldZSTRING, Precision = 63, Scale = 0, Data = 000002000005_系统性红斑狼疮 5283 09:27:24 SQL Stmt: ORACLE - Fetch 5284 09:27:24 SQL Stmt: ORACLE - EOF 5285 09:27:24 SQL Stmt: ORACLE - Reset 5286 09:27:24 SQL Prepare: ORACLE - select * from vw_sf_wjzcf where BRID00='848440' AND GHH000='1339461' 5287 09:27:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='848440' AND GHH000='1339461' 5288 09:27:24 SQL Stmt: ORACLE - Fetch 5289 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5290 09:27:24 SQL Data Out: ORACLE - Column = 2, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5291 09:27:24 SQL Data Out: ORACLE - Column = 3, Name = GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 5292 09:27:24 SQL Data Out: ORACLE - Column = 4, Name = DJLSH0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 1258056 5293 09:27:24 SQL Data Out: ORACLE - Column = 5, Name = ZLDCCF, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 5294 09:27:24 SQL Data Out: ORACLE - Column = 6, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 5295 09:27:24 SQL Data Out: ORACLE - Column = 7, Name = CFYJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5296 09:27:24 SQL Stmt: ORACLE - Fetch 5297 09:27:24 SQL Stmt: ORACLE - EOF 5298 09:27:24 SQL Stmt: ORACLE - Reset 5299 09:27:24 SQL Stmt: ORACLE - Close 5300 09:27:24 SQL Prepare: ORACLE - select * from vw_sf_wjzcf where BRID00='848440' AND GHH000='1339461' 5301 09:27:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='848440' AND GHH000='1339461' 5302 09:27:24 SQL Stmt: ORACLE - Fetch 5303 09:27:24 SQL Data Out: ORACLE - Column = 1, Name = BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5304 09:27:24 SQL Data Out: ORACLE - Column = 2, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5305 09:27:24 SQL Data Out: ORACLE - Column = 3, Name = GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 5306 09:27:24 SQL Data Out: ORACLE - Column = 4, Name = DJLSH0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 1258056 5307 09:27:24 SQL Data Out: ORACLE - Column = 5, Name = ZLDCCF, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 5308 09:27:24 SQL Data Out: ORACLE - Column = 6, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 5309 09:27:24 SQL Data Out: ORACLE - Column = 7, Name = CFYJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5310 09:27:24 SQL Stmt: ORACLE - Fetch 5311 09:27:24 SQL Stmt: ORACLE - EOF 5312 09:27:24 SQL Stmt: ORACLE - Reset 5313 09:27:25 SQL Stmt: ORACLE - Close 5314 09:27:25 SQL Prepare: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1 and cfyjbz = '0' and A.GHH000 = :2 5315 09:27:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5316 09:27:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5317 09:27:25 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '0' and A.GHH000 = ? 5318 09:27:25 SQL Stmt: ORACLE - Fetch 5319 09:27:25 SQL Data Out: ORACLE - Column = 1, Name = DJLSH0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 1258056 5320 09:27:25 SQL Data Out: ORACLE - Column = 2, Name = ZLDCCF, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 5321 09:27:25 SQL Data Out: ORACLE - Column = 3, Name = CFYJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5322 09:27:25 SQL Stmt: ORACLE - Close 5323 09:27:25 SQL Prepare: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 in ('1258056 ') 5324 09:27:25 SQL Execute: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 in ('1258056 ') 5325 09:27:25 SQL Data In: ORACLE - Rows affected = 0 5326 09:27:25 SQL Stmt: ORACLE - Close 5327 09:27:25 SQL Prepare: ORACLE - commit 5328 09:27:25 SQL Execute: ORACLE - commit 5329 09:27:25 SQL Data In: ORACLE - Rows affected = 0 5330 09:27:25 SQL Stmt: ORACLE - Close 5331 09:27:25 SQL Prepare: ORACLE - select SF_MZ_PSCFYS('1339461','1258056 ') NFJJ00 from dual 5332 09:27:25 SQL Execute: ORACLE - select SF_MZ_PSCFYS('1339461','1258056 ') NFJJ00 from dual 5333 09:27:25 SQL Stmt: ORACLE - Fetch 5334 09:27:25 SQL Data Out: ORACLE - Column = 1, Name = NFJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5335 09:27:25 SQL Stmt: ORACLE - Reset 5336 09:27:25 SQL Stmt: ORACLE - Close 5337 09:27:25 SQL Prepare: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 in ('1258056 ') 5338 09:27:25 SQL Execute: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 in ('1258056 ') 5339 09:27:25 SQL Stmt: ORACLE - Fetch 5340 09:27:25 SQL Data Out: ORACLE - Column = 1, Name = CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1258056 5341 09:27:25 SQL Data Out: ORACLE - Column = 2, Name = YFBMBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 538.000000 5342 09:27:25 SQL Data Out: ORACLE - Column = 3, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 门诊西药房 5343 09:27:25 SQL Data Out: ORACLE - Column = 4, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 5344 09:27:25 SQL Data Out: ORACLE - Column = 5, Name = FPXMMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 成药费 5345 09:27:25 SQL Data Out: ORACLE - Column = 6, Name = SFDM00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 9999999998.000000 5346 09:27:25 SQL Data Out: ORACLE - Column = 7, Name = SFXMMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 成药费 5347 09:27:25 SQL Data Out: ORACLE - Column = 8, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5348 09:27:25 SQL Data Out: ORACLE - Column = 9, Name = BRXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 5349 09:27:25 SQL Data Out: ORACLE - Column = 10, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 女 5350 09:27:25 SQL Data Out: ORACLE - Column = 11, Name = YSGZH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 5351 09:27:25 SQL Data Out: ORACLE - Column = 12, Name = YSXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 吴海峰 5352 09:27:25 SQL Data Out: ORACLE - Column = 13, Name = SRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5353 09:27:25 SQL Data Out: ORACLE - Column = 14, Name = SRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:19:28 5354 09:27:25 SQL Data Out: ORACLE - Column = 15, Name = CFZJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 53.260000 5355 09:27:25 SQL Data Out: ORACLE - Column = 16, Name = YPDLBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5356 09:27:25 SQL Data Out: ORACLE - Column = 17, Name = CFTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5357 09:27:25 SQL Data Out: ORACLE - Column = 18, Name = YPNM00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 5978.000000 5358 09:27:25 SQL Data Out: ORACLE - Column = 19, Name = YPMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 活血止痛膏 5359 09:27:25 SQL Data Out: ORACLE - Column = 20, Name = YPGG00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 7cm*10cm*2贴*3袋 5360 09:27:25 SQL Data Out: ORACLE - Column = 21, Name = LSDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 26.630000 5361 09:27:25 SQL Data Out: ORACLE - Column = 22, Name = SFZBY0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 5362 09:27:25 SQL Data Out: ORACLE - Column = 23, Name = YPZSL0, Type = fldFLOAT, Precision = 13, Scale = 3, Data = 2.000000 5363 09:27:25 SQL Data Out: ORACLE - Column = 24, Name = AMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.260000 5364 09:27:25 SQL Data Out: ORACLE - Column = 25, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.326000 5365 09:27:25 SQL Data Out: ORACLE - Column = 26, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 47.934000 5366 09:27:25 SQL Data Out: ORACLE - Column = 27, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5367 09:27:25 SQL Data Out: ORACLE - Column = 28, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 5368 09:27:25 SQL Data Out: ORACLE - Column = 29, Name = CFDW00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 盒 5369 09:27:25 SQL Data Out: ORACLE - Column = 30, Name = ZYDJS0, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 5370 09:27:25 SQL Data Out: ORACLE - Column = 31, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 0.100000 5371 09:27:25 SQL Data Out: ORACLE - Column = 32, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 5372 09:27:25 SQL Data Out: ORACLE - Column = 33, Name = CFID00, Type = fldFLOAT, Precision = 20, Scale = 0, Data = 3492070.000000 5373 09:27:25 SQL Data Out: ORACLE - Column = 34, Name = ZYMRCS, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 2.000000 5374 09:27:25 SQL Prepare: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =:1 and A.YBZXLB=:2 and A.SFYP00 ='Y' 5375 09:27:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5978.000000 5376 09:27:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5377 09:27:25 SQL Execute: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =? and A.YBZXLB=? and A.SFYP00 ='Y' 5378 09:27:25 SQL Stmt: ORACLE - Fetch 5379 09:27:25 SQL Data Out: ORACLE - Column = 1, Name = YBXMMC, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 活血止痛膏 5380 09:27:25 SQL Data Out: ORACLE - Column = 2, Name = SFXMID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 5978.000000 5381 09:27:25 SQL Data Out: ORACLE - Column = 3, Name = SFYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5382 09:27:25 SQL Data Out: ORACLE - Column = 4, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5383 09:27:25 SQL Data Out: ORACLE - Column = 5, Name = YBBRLB, Type = fldZSTRING, Precision = 20, Scale = 0, Data = Z 5384 09:27:25 SQL Data Out: ORACLE - Column = 6, Name = YBXMBH, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 22701209047028112202 5385 09:27:25 SQL Data Out: ORACLE - Column = 7, Name = YBFPXM, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 5386 09:27:25 SQL Data Out: ORACLE - Column = 8, Name = YBFPMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 成药费 5387 09:27:25 SQL Data Out: ORACLE - Column = 9, Name = SFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5388 09:27:25 SQL Data Out: ORACLE - Column = 10, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 02 5389 09:27:25 SQL Data Out: ORACLE - Column = 11, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 成药费 5390 09:27:25 SQL Data Out: ORACLE - Column = 12, Name = SYBZ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 5391 09:27:25 SQL Data Out: ORACLE - Column = 13, Name = SFSX00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5392 09:27:25 SQL Data Out: ORACLE - Column = 14, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 5393 09:27:25 SQL Stmt: ORACLE - Fetch 5394 09:27:25 SQL Stmt: ORACLE - EOF 5395 09:27:25 SQL Stmt: ORACLE - Reset 5396 09:27:25 SQL Stmt: ORACLE - Close 5397 09:27:25 SQL Stmt: ORACLE - Fetch 5398 09:27:25 SQL Stmt: ORACLE - EOF 5399 09:27:25 SQL Stmt: ORACLE - Reset 5400 09:27:25 SQL Stmt: ORACLE - Close 5401 09:27:25 SQL Prepare: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = :1 and cfyjbz = '1' and A.GHH000 = :2 5402 09:27:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5403 09:27:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5404 09:27:25 SQL Execute: ORACLE - select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ? and cfyjbz = '1' and A.GHH000 = ? 5405 09:27:25 SQL Stmt: ORACLE - Fetch 5406 09:27:25 SQL Stmt: ORACLE - EOF 5407 09:27:25 SQL Stmt: ORACLE - Reset 5408 09:27:25 SQL Stmt: ORACLE - Close 5409 09:27:25 SQL Prepare: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = :1 and BRID00 = :2 5410 09:27:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5411 09:27:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5412 09:27:25 SQL Execute: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = ? and BRID00 = ? 5413 09:27:25 SQL Stmt: ORACLE - Fetch 5414 09:27:25 SQL Data Out: ORACLE - Column = 1, Name = JFLBMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 门诊预交金 5415 09:27:25 SQL Data Out: ORACLE - Column = 2, Name = MZZHID, Type = fldFLOAT, Precision = 11, Scale = 0, Data = 705298.000000 5416 09:27:25 SQL Data Out: ORACLE - Column = 3, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 5417 09:27:25 SQL Data Out: ORACLE - Column = 4, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5418 09:27:25 SQL Data Out: ORACLE - Column = 5, Name = SFDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5419 09:27:25 SQL Data Out: ORACLE - Column = 6, Name = KHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5420 09:27:25 SQL Data Out: ORACLE - Column = 7, Name = KHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 5421 09:27:25 SQL Data Out: ORACLE - Column = 8, Name = CZYBH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5422 09:27:25 SQL Data Out: ORACLE - Column = 9, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 5423 09:27:25 SQL Data Out: ORACLE - Column = 10, Name = THRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5424 09:27:25 SQL Data Out: ORACLE - Column = 11, Name = THSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5425 09:27:25 SQL Data Out: ORACLE - Column = 12, Name = THCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5426 09:27:25 SQL Data Out: ORACLE - Column = 13, Name = THCZYM, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5427 09:27:25 SQL Data Out: ORACLE - Column = 14, Name = XJYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5428 09:27:25 SQL Data Out: ORACLE - Column = 15, Name = ZZYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5429 09:27:25 SQL Data Out: ORACLE - Column = 16, Name = YJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5430 09:27:25 SQL Data Out: ORACLE - Column = 17, Name = WJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5.500000 5431 09:27:25 SQL Data Out: ORACLE - Column = 18, Name = YYJ000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5432 09:27:25 SQL Data Out: ORACLE - Column = 19, Name = ZYE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5433 09:27:25 SQL Data Out: ORACLE - Column = 20, Name = YKZYE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5434 09:27:25 SQL Data Out: ORACLE - Column = 21, Name = BJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5435 09:27:25 SQL Data Out: ORACLE - Column = 22, Name = TYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5436 09:27:25 SQL Data Out: ORACLE - Column = 23, Name = YXQFJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.000000 5437 09:27:25 SQL Data Out: ORACLE - Column = 24, Name = KL0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 5438 09:27:25 SQL Data Out: ORACLE - Column = 25, Name = YBZHYE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5439 09:27:25 SQL Data Out: ORACLE - Column = 26, Name = YBYJS0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.260000 5440 09:27:25 SQL Data Out: ORACLE - Column = 27, Name = YBYZF0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.770000 5441 09:27:25 SQL Data Out: ORACLE - Column = 28, Name = DBJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5442 09:27:25 SQL Stmt: ORACLE - Reset 5443 09:27:25 SQL Stmt: ORACLE - Close 5444 09:27:25 SQL Stmt: ORACLE - Close 5445 09:27:25 SQL Stmt: ORACLE - Close 5446 09:27:25 SQL Prepare: ORACLE - select distinct tsbzbh from VW_SF_YBTZBZ where ghid00=2515926 and ((flag00='0' and cfh000 in ( 0 , 1258056 )) or (flag00='1' and cfh000 in (0 ))) 5447 09:27:25 SQL Execute: ORACLE - select distinct tsbzbh from VW_SF_YBTZBZ where ghid00=2515926 and ((flag00='0' and cfh000 in ( 0 , 1258056 )) or (flag00='1' and cfh000 in (0 ))) 5448 09:27:25 SQL Stmt: ORACLE - Fetch 5449 09:27:25 SQL Stmt: ORACLE - EOF 5450 09:27:25 SQL Stmt: ORACLE - Reset 5451 09:27:26 SQL Stmt: ORACLE - Reset 5452 09:27:26 SQL Stmt: ORACLE - Close 5453 09:27:26 SQL Prepare: ORACLE - select nvl(max(A.YBGHH0),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghh000= :1 and TRIM(A.YBGHH0)<>'0' and A.BRID00 = :2 5454 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5455 09:27:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5456 09:27:26 SQL Execute: ORACLE - select nvl(max(A.YBGHH0),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghh000= ? and TRIM(A.YBGHH0)<>'0' and A.BRID00 = ? 5457 09:27:26 SQL Stmt: ORACLE - Fetch 5458 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = YBGHH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 48976387 5459 09:27:26 SQL Stmt: ORACLE - Reset 5460 09:27:26 SQL Stmt: ORACLE - Close 5461 09:27:26 SQL Prepare: ORACLE - select SQ_SF_TEMP00_ID0000.nextval ID0000 from dual 5462 09:27:26 SQL Execute: ORACLE - select SQ_SF_TEMP00_ID0000.nextval ID0000 from dual 5463 09:27:26 SQL Stmt: ORACLE - Fetch 5464 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610777.000000 5465 09:27:26 SQL Stmt: ORACLE - Reset 5466 09:27:26 SQL Stmt: ORACLE - Close 5467 09:27:26 SQL Prepare: ORACLE - insert into BM_SFCFMX_TEMP00(ID0000,XMBH00,SFYB00,FPXMMC,XMMC00,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00) values(610777,'22701209047028112202','Y','成药费','活血止痛膏','7cm*10cm*2贴*3袋','盒',26.63,2,53.26,'吴海峰') 5468 09:27:26 SQL Execute: ORACLE - insert into BM_SFCFMX_TEMP00(ID0000,XMBH00,SFYB00,FPXMMC,XMMC00,XMGG00,XMDW00,XMDJ00,XMSL00,XMJE00,YSXM00) values(610777,'22701209047028112202','Y','成药费','活血止痛膏','7cm*10cm*2贴*3袋','盒',26.63,2,53.26,'吴海峰') 5469 09:27:26 SQL Data In: ORACLE - Rows affected = 1 5470 09:27:26 SQL Stmt: ORACLE - Close 5471 09:27:26 SQL Prepare: ORACLE - insert into BM_SFCF00_TEMP00(id0000,name00,value0,bz0000) select id0000,fpxmmc,sum(xmje00),sfyb00 from BM_SFCFMX_TEMP00 where id0000=610777 group by id0000,fpxmmc,sfyb00 5472 09:27:26 SQL Execute: ORACLE - insert into BM_SFCF00_TEMP00(id0000,name00,value0,bz0000) select id0000,fpxmmc,sum(xmje00),sfyb00 from BM_SFCFMX_TEMP00 where id0000=610777 group by id0000,fpxmmc,sfyb00 5473 09:27:26 SQL Data In: ORACLE - Rows affected = 1 5474 09:27:26 SQL Stmt: ORACLE - Close 5475 09:27:26 SQL Prepare: ORACLE - BEGIN "SP_SF_MZSF00_YBJK02" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5476 09:27:26 SQL Misc: ORACLE - Set stored procedure on or off 5477 09:27:26 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5478 09:27:26 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5479 09:27:26 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1339461 5480 09:27:26 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 平潭分中心 5481 09:27:26 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5482 09:27:26 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610777.000000 5483 09:27:26 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5484 09:27:26 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5485 09:27:26 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK02" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5486 09:27:26 SQL Stmt: ORACLE - Close 5487 09:27:26 SQL Stmt: ORACLE - Reset 5488 09:27:26 SQL Stmt: ORACLE - Close 5489 09:27:26 SQL Prepare: ORACLE - select bxlb00 from sf_brxxb0 where ghh000= :1 order by ghid00 desc 5490 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5491 09:27:26 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where ghh000= ? order by ghid00 desc 5492 09:27:26 SQL Stmt: ORACLE - Fetch 5493 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = BXLB00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 普通 5494 09:27:26 SQL Prepare: ORACLE - select COUNT(*) NUM from BM_SFCFMX_TEMP00 where ID0000 = :1 5495 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610779.000000 5496 09:27:26 SQL Execute: ORACLE - select COUNT(*) NUM from BM_SFCFMX_TEMP00 where ID0000 = ? 5497 09:27:26 SQL Stmt: ORACLE - Fetch 5498 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = NUM, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 5499 09:27:26 SQL Stmt: ORACLE - Reset 5500 09:27:26 SQL Stmt: ORACLE - Close 5501 09:27:26 SQL Prepare: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 848440 and mzid00=2515926 5502 09:27:26 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 848440 and mzid00=2515926 5503 09:27:26 SQL Stmt: ORACLE - Fetch 5504 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ZJL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5505 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = CXJL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5506 09:27:26 SQL Stmt: ORACLE - Reset 5507 09:27:26 SQL Stmt: ORACLE - Close 5508 09:27:26 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = :1 and BZ0000 = 'Y' 5509 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610779.000000 5510 09:27:26 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 5511 09:27:26 SQL Stmt: ORACLE - Fetch 5512 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5513 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 成药费 5514 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 53.26 5515 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5516 09:27:26 SQL Stmt: ORACLE - Fetch 5517 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5518 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 诊察费 5519 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 4 5520 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5521 09:27:26 SQL Stmt: ORACLE - Fetch 5522 09:27:26 SQL Stmt: ORACLE - EOF 5523 09:27:26 SQL Stmt: ORACLE - Reset 5524 09:27:26 SQL Stmt: ORACLE - Close 5525 09:27:26 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = :1 and BZ0000 = 'N' 5526 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610779.000000 5527 09:27:26 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 5528 09:27:26 SQL Stmt: ORACLE - Fetch 5529 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5530 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 挂号费 5531 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 5532 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 5533 09:27:26 SQL Stmt: ORACLE - Fetch 5534 09:27:26 SQL Stmt: ORACLE - EOF 5535 09:27:26 SQL Stmt: ORACLE - Reset 5536 09:27:26 SQL Stmt: ORACLE - Close 5537 09:27:26 SQL Prepare: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = :1 5538 09:27:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610779.000000 5539 09:27:26 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 5540 09:27:26 SQL Stmt: ORACLE - Fetch 5541 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5542 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 011010000104 5543 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 5544 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 挂号费 5545 09:27:26 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费（县医院） 5546 09:27:26 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 次 5547 09:27:26 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 5548 09:27:26 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 5549 09:27:26 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 5550 09:27:26 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 5551 09:27:26 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 无 5552 09:27:26 SQL Stmt: ORACLE - Fetch 5553 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5554 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 011020000132 5555 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5556 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 诊察费 5557 09:27:26 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 普通门诊诊查费？副主任医师（三甲以下医院） 5558 09:27:26 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 次 5559 09:27:26 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 5560 09:27:26 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 5561 09:27:26 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 5562 09:27:26 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 5563 09:27:26 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 无 5564 09:27:26 SQL Stmt: ORACLE - Fetch 5565 09:27:26 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610779.000000 5566 09:27:26 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 22701209047028112202 5567 09:27:26 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5568 09:27:26 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 成药费 5569 09:27:26 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 活血止痛膏 5570 09:27:26 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 盒 5571 09:27:26 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 26.630000 5572 09:27:26 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 2.000000 5573 09:27:26 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 53.260000 5574 09:27:26 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 5575 09:27:26 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 7cm*10cm*2贴*3袋 5576 09:27:26 SQL Stmt: ORACLE - Fetch 5577 09:27:26 SQL Stmt: ORACLE - EOF 5578 09:27:26 SQL Stmt: ORACLE - Reset 5579 09:27:28 SQL Prepare: ORACLE - select SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'1','0' ) zfje00 from dual 5580 09:27:28 SQL Execute: ORACLE - select SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'1','0' ) zfje00 from dual 5581 09:27:28 SQL Stmt: ORACLE - Fetch 5582 09:27:28 SQL Data Out: ORACLE - Column = 1, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.490000 5583 09:27:28 SQL Stmt: ORACLE - Close 5584 09:27:28 SQL Prepare: ORACLE - RollBack 5585 09:27:28 SQL Execute: ORACLE - RollBack 5586 09:27:28 SQL Data In: ORACLE - Rows affected = 0 5587 09:27:28 SQL Stmt: ORACLE - Close 5588 09:27:28 SQL Stmt: ORACLE - Reset 5589 09:27:28 SQL Stmt: ORACLE - Close 5590 09:27:28 SQL Prepare: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= :1 5591 09:27:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5592 09:27:28 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 5593 09:27:28 SQL Stmt: ORACLE - Fetch 5594 09:27:28 SQL Data Out: ORACLE - Column = 1, Name = TYJE01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5595 09:27:31 SQL Prepare: ORACLE - Select SYSDATE from Dual 5596 09:27:31 SQL Execute: ORACLE - Select SYSDATE from Dual 5597 09:27:31 SQL Stmt: ORACLE - Fetch 5598 09:27:31 SQL Data Out: ORACLE - Column = 1, Name = SYSDATE, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/3/2010 9:27:32:0 5599 09:27:31 SQL Stmt: ORACLE - Reset 5600 09:27:31 SQL Stmt: ORACLE - Close 5601 09:27:31 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5602 09:27:31 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5603 09:27:31 SQL Stmt: ORACLE - Fetch 5604 09:27:31 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 46 5605 09:27:31 SQL Stmt: ORACLE - Reset 5606 09:27:31 SQL Stmt: ORACLE - Close 5607 09:27:31 SQL Prepare: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 5608 09:27:31 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 5609 09:27:31 SQL Data In: ORACLE - Rows affected = 1 5610 09:27:31 SQL Stmt: ORACLE - Close 5611 09:27:31 SQL Prepare: ORACLE - Commit 5612 09:27:31 SQL Execute: ORACLE - Commit 5613 09:27:31 SQL Data In: ORACLE - Rows affected = 0 5614 09:27:31 SQL Stmt: ORACLE - Close 5615 09:27:31 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 5616 09:27:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 5617 09:27:31 SQL Stmt: ORACLE - Fetch 5618 09:27:31 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = SLE4442 5619 09:27:31 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5620 09:27:31 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 5621 09:27:31 SQL Stmt: ORACLE - Reset 5622 09:27:31 SQL Stmt: ORACLE - Close 5623 09:27:31 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 5624 09:27:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 5625 09:27:31 SQL Stmt: ORACLE - Fetch 5626 09:27:31 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-XMJK 5627 09:27:31 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5628 09:27:31 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = XMJK 5629 09:27:31 SQL Stmt: ORACLE - Reset 5630 09:27:31 SQL Stmt: ORACLE - Close 5631 09:27:31 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 5632 09:27:31 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 5633 09:27:31 SQL Stmt: ORACLE - Fetch 5634 09:27:31 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-FZYB 5635 09:27:31 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5636 09:27:31 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = FZYB 5637 09:27:31 SQL Stmt: ORACLE - Reset 5638 09:27:31 SQL Stmt: ORACLE - Close 5639 09:27:34 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYB350107827509' and ICKNBH ='FZYB350107827509' 5640 09:27:34 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='FZYB350107827509' and ICKNBH ='FZYB350107827509' 5641 09:27:34 SQL Stmt: ORACLE - Fetch 5642 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = FZYB350107827509 5643 09:27:34 SQL Data Out: ORACLE - Column = 2, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5644 09:27:34 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5645 09:27:34 SQL Data Out: ORACLE - Column = 4, Name = KMH000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 350107827509 5646 09:27:34 SQL Data Out: ORACLE - Column = 5, Name = ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5647 09:27:34 SQL Stmt: ORACLE - Reset 5648 09:27:34 SQL Stmt: ORACLE - Close 5649 09:27:34 SQL Prepare: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =848440 5650 09:27:34 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =848440 5651 09:27:34 SQL Stmt: ORACLE - Fetch 5652 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = MZZHID, Type = fldFLOAT, Precision = 11, Scale = 0, Data = 705298.000000 5653 09:27:34 SQL Data Out: ORACLE - Column = 2, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 5654 09:27:34 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5655 09:27:34 SQL Data Out: ORACLE - Column = 4, Name = SFDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5656 09:27:34 SQL Data Out: ORACLE - Column = 5, Name = KHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5657 09:27:34 SQL Data Out: ORACLE - Column = 6, Name = KHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 5658 09:27:34 SQL Data Out: ORACLE - Column = 7, Name = CZYBH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5659 09:27:34 SQL Data Out: ORACLE - Column = 8, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 5660 09:27:34 SQL Data Out: ORACLE - Column = 9, Name = THRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5661 09:27:34 SQL Data Out: ORACLE - Column = 10, Name = THSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5662 09:27:34 SQL Data Out: ORACLE - Column = 11, Name = THCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5663 09:27:34 SQL Data Out: ORACLE - Column = 12, Name = THCZYM, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5664 09:27:34 SQL Data Out: ORACLE - Column = 13, Name = XJYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5665 09:27:34 SQL Data Out: ORACLE - Column = 14, Name = ZZYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5666 09:27:34 SQL Data Out: ORACLE - Column = 15, Name = YJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5667 09:27:34 SQL Data Out: ORACLE - Column = 16, Name = WJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5.500000 5668 09:27:34 SQL Data Out: ORACLE - Column = 17, Name = YYJ000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5669 09:27:34 SQL Data Out: ORACLE - Column = 18, Name = ZYE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5670 09:27:34 SQL Data Out: ORACLE - Column = 19, Name = YKZYE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5671 09:27:34 SQL Data Out: ORACLE - Column = 20, Name = BJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5672 09:27:34 SQL Data Out: ORACLE - Column = 21, Name = TYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5673 09:27:34 SQL Data Out: ORACLE - Column = 22, Name = YXQFJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.000000 5674 09:27:34 SQL Data Out: ORACLE - Column = 23, Name = KL0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 5675 09:27:34 SQL Data Out: ORACLE - Column = 24, Name = YBZHYE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5676 09:27:34 SQL Data Out: ORACLE - Column = 25, Name = YBYJS0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.260000 5677 09:27:34 SQL Data Out: ORACLE - Column = 26, Name = YBYZF0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.770000 5678 09:27:34 SQL Data Out: ORACLE - Column = 27, Name = DBJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5679 09:27:34 SQL Stmt: ORACLE - Reset 5680 09:27:34 SQL Stmt: ORACLE - Close 5681 09:27:34 SQL Prepare: ORACLE - update SF_BRZHXX set YBYJS0 = 58.26 ,YBYZF0 = SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2','0' ) where BRID00=:1 and JFLBID = 1 5682 09:27:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5683 09:27:34 SQL Execute: ORACLE - update SF_BRZHXX set YBYJS0 = 58.26 ,YBYZF0 = SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2','0' ) where BRID00=? and JFLBID = 1 5684 09:27:34 SQL Data In: ORACLE - Rows affected = 1 5685 09:27:34 SQL Stmt: ORACLE - Close 5686 09:27:34 SQL Stmt: ORACLE - Reset 5687 09:27:34 SQL Stmt: ORACLE - Close 5688 09:27:34 SQL Prepare: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= :1 5689 09:27:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5690 09:27:34 SQL Execute: ORACLE - select tyje01 from VW_SF_BRZHXX where brid00= ? 5691 09:27:34 SQL Stmt: ORACLE - Fetch 5692 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = TYJE01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5693 09:27:34 SQL Prepare: ORACLE - select * from sf_brzhxx where 1 = 1 and JFLBID = 1 and BRID00 = 848440 5694 09:27:34 SQL Execute: ORACLE - select * from sf_brzhxx where 1 = 1 and JFLBID = 1 and BRID00 = 848440 5695 09:27:34 SQL Stmt: ORACLE - Fetch 5696 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = MZZHID, Type = fldFLOAT, Precision = 11, Scale = 0, Data = 705298.000000 5697 09:27:34 SQL Data Out: ORACLE - Column = 2, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 5698 09:27:34 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5699 09:27:34 SQL Data Out: ORACLE - Column = 4, Name = SFDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5700 09:27:34 SQL Data Out: ORACLE - Column = 5, Name = KHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5701 09:27:34 SQL Data Out: ORACLE - Column = 6, Name = KHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 5702 09:27:34 SQL Data Out: ORACLE - Column = 7, Name = CZYBH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5703 09:27:34 SQL Data Out: ORACLE - Column = 8, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 5704 09:27:34 SQL Data Out: ORACLE - Column = 9, Name = THRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5705 09:27:34 SQL Data Out: ORACLE - Column = 10, Name = THSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5706 09:27:34 SQL Data Out: ORACLE - Column = 11, Name = THCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5707 09:27:34 SQL Data Out: ORACLE - Column = 12, Name = THCZYM, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5708 09:27:34 SQL Data Out: ORACLE - Column = 13, Name = XJYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5709 09:27:34 SQL Data Out: ORACLE - Column = 14, Name = ZZYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5710 09:27:34 SQL Data Out: ORACLE - Column = 15, Name = YJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5711 09:27:34 SQL Data Out: ORACLE - Column = 16, Name = WJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 5.500000 5712 09:27:34 SQL Data Out: ORACLE - Column = 17, Name = YYJ000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5713 09:27:34 SQL Data Out: ORACLE - Column = 18, Name = ZYE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5714 09:27:34 SQL Data Out: ORACLE - Column = 19, Name = YKZYE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 24.500000 5715 09:27:34 SQL Data Out: ORACLE - Column = 20, Name = BJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5716 09:27:34 SQL Data Out: ORACLE - Column = 21, Name = TYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5717 09:27:34 SQL Data Out: ORACLE - Column = 22, Name = YXQFJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.000000 5718 09:27:34 SQL Data Out: ORACLE - Column = 23, Name = KL0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 5719 09:27:34 SQL Data Out: ORACLE - Column = 24, Name = YBZHYE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5720 09:27:34 SQL Data Out: ORACLE - Column = 25, Name = YBYJS0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.260000 5721 09:27:34 SQL Data Out: ORACLE - Column = 26, Name = YBYZF0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.770000 5722 09:27:34 SQL Data Out: ORACLE - Column = 27, Name = DBJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5723 09:27:34 SQL Stmt: ORACLE - Reset 5724 09:27:34 SQL Stmt: ORACLE - Close 5725 09:27:34 SQL Stmt: ORACLE - Reset 5726 09:27:34 SQL Stmt: ORACLE - Close 5727 09:27:34 SQL Prepare: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 848440 and YJDJH0 not in ( 0 ) and GHH000 = '1339461' 5728 09:27:34 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 848440 and YJDJH0 not in ( 0 ) and GHH000 = '1339461' 5729 09:27:34 SQL Stmt: ORACLE - Fetch 5730 09:27:34 SQL Stmt: ORACLE - EOF 5731 09:27:34 SQL Stmt: ORACLE - Reset 5732 09:27:34 SQL Prepare: ORACLE - select distinct tsbzbh from VW_SF_YBTZBZ where ghid00=2515926 and ((flag00='0' and cfh000 in ( 0 , 1258056 )) or (flag00='1' and cfh000 in (0 ))) 5733 09:27:34 SQL Execute: ORACLE - select distinct tsbzbh from VW_SF_YBTZBZ where ghid00=2515926 and ((flag00='0' and cfh000 in ( 0 , 1258056 )) or (flag00='1' and cfh000 in (0 ))) 5734 09:27:34 SQL Stmt: ORACLE - Fetch 5735 09:27:34 SQL Stmt: ORACLE - EOF 5736 09:27:34 SQL Stmt: ORACLE - Reset 5737 09:27:34 SQL Stmt: ORACLE - Close 5738 09:27:34 SQL Prepare: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 5739 09:27:34 SQL Execute: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 5740 09:27:34 SQL Stmt: ORACLE - Fetch 5741 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863348.000000 5742 09:27:34 SQL Stmt: ORACLE - Reset 5743 09:27:34 SQL Stmt: ORACLE - Close 5744 09:27:34 SQL Prepare: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5745 09:27:34 SQL Misc: ORACLE - Set stored procedure on or off 5746 09:27:34 SQL Data In: ORACLE - Param = 1, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3492070.000000 5747 09:27:34 SQL Data In: ORACLE - Param = 2, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.260000 5748 09:27:34 SQL Data In: ORACLE - Param = 3, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5749 09:27:34 SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5750 09:27:34 SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5751 09:27:34 SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5752 09:27:34 SQL Stmt: ORACLE - Close 5753 09:27:34 SQL Prepare: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AS_SFQZF0 => :AS_SFQZF0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5754 09:27:34 SQL Misc: ORACLE - Set stored procedure on or off 5755 09:27:34 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1258056 5756 09:27:34 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863348.000000 5757 09:27:34 SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5758 09:27:34 SQL Data In: ORACLE - Param = 4, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 5759 09:27:34 SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5760 09:27:34 SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5761 09:27:34 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AS_SFQZF0 => :AS_SFQZF0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5762 09:27:34 SQL Stmt: ORACLE - Close 5763 09:27:34 SQL Prepare: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5764 09:27:34 SQL Misc: ORACLE - Set stored procedure on or off 5765 09:27:34 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5766 09:27:34 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1339461 5767 09:27:34 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 5768 09:27:34 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 5769 09:27:34 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5770 09:27:34 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王爱云 5771 09:27:34 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 5772 09:27:34 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1515.000000 5773 09:27:34 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨欢欢 5774 09:27:34 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 488.000000 5775 09:27:34 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863348.000000 5776 09:27:34 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5777 09:27:34 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5778 09:27:34 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5779 09:27:34 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5780 09:27:34 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5781 09:27:34 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5782 09:27:34 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 5783 09:27:34 SQL Stmt: ORACLE - Close 5784 09:27:34 SQL Stmt: ORACLE - Close 5785 09:27:34 SQL Prepare: ORACLE - select count(*) num from sf_brxxb0 a,yf_mzcf00 b where a.ghid00=b.ghid00 and b.cfzt00=0 and a.brid00= :1 and a.ghrq00>to_char(sysdate-:2,'YYYYMMDD' ) 5786 09:27:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5787 09:27:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 5788 09:27:34 SQL Execute: ORACLE - select count(*) num from sf_brxxb0 a,yf_mzcf00 b where a.ghid00=b.ghid00 and b.cfzt00=0 and a.brid00= ? and a.ghrq00>to_char(sysdate-?,'YYYYMMDD' ) 5789 09:27:34 SQL Stmt: ORACLE - Fetch 5790 09:27:34 SQL Data Out: ORACLE - Column = 1, Name = NUM, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5791 09:27:35 SQL Prepare: ORACLE - commit 5792 09:27:35 SQL Execute: ORACLE - commit 5793 09:27:35 SQL Data In: ORACLE - Rows affected = 0 5794 09:27:35 SQL Stmt: ORACLE - Close 5795 09:27:35 SQL Stmt: ORACLE - Close 5796 09:27:35 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 5797 09:27:35 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 5798 09:27:35 SQL Stmt: ORACLE - Fetch 5799 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = 1, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5800 09:27:35 SQL Stmt: ORACLE - Reset 5801 09:27:35 SQL Stmt: ORACLE - Close 5802 09:27:35 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 5803 09:27:35 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 5804 09:27:35 SQL Stmt: ORACLE - Fetch 5805 09:27:35 SQL Stmt: ORACLE - EOF 5806 09:27:35 SQL Stmt: ORACLE - Reset 5807 09:27:35 SQL Stmt: ORACLE - Close 5808 09:27:35 SQL Prepare: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = :1 and SYBZ00 = 'Y' 5809 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1515.000000 5810 09:27:35 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 = ? and SYBZ00 = 'Y' 5811 09:27:35 SQL Stmt: ORACLE - Fetch 5812 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = PJLYID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3499.000000 5813 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = PJLXBM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 5814 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = PJLXMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 门诊发票 5815 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = PJSYR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5816 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = PJQZMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1030 5817 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = PJQSH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 05721751 5818 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = PJZZH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 05722250 5819 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = PJFFRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100827 5820 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = PJTZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5821 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = PJCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1163.000000 5822 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = PJDQH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 05722114 5823 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = SYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5824 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = CFQCS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 5825 09:27:35 SQL Stmt: ORACLE - Reset 5826 09:27:35 SQL Stmt: ORACLE - Close 5827 09:27:35 SQL Stmt: ORACLE - Reset 5828 09:27:35 SQL Stmt: ORACLE - Close 5829 09:27:35 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='6036' 5830 09:27:35 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='6036' 5831 09:27:35 SQL Stmt: ORACLE - Fetch 5832 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = XKH000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 6036 5833 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = USER00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 6036 5834 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = TZH000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 001 5835 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = PWS000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 5836 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = SYZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5837 09:27:35 SQL Prepare: ORACLE - select A.*,B.JFLBMC,C.*,D.FBMC00 from sf_brzhxx A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = :1 and A.JFLBID = :2 5838 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5839 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5840 09:27:35 SQL Execute: ORACLE - select A.*,B.JFLBMC,C.*,D.FBMC00 from sf_brzhxx A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 5841 09:27:35 SQL Blob IO: ORACLE - Return blob data 5842 09:27:35 SQL Stmt: ORACLE - Fetch 5843 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = MZZHID, Type = fldFLOAT, Precision = 11, Scale = 0, Data = 705298.000000 5844 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 5845 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5846 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = SFDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5847 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = KHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5848 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = KHSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 5849 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = CZYBH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5850 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 5851 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = THRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5852 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = THSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5853 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = THCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5854 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = THCZYM, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5855 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = XJYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -28.760000 5856 09:27:35 SQL Data Out: ORACLE - Column = 14, Name = ZZYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5857 09:27:35 SQL Data Out: ORACLE - Column = 15, Name = YJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5858 09:27:35 SQL Data Out: ORACLE - Column = 16, Name = WJSJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.760000 5859 09:27:35 SQL Data Out: ORACLE - Column = 17, Name = YYJ000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5860 09:27:35 SQL Data Out: ORACLE - Column = 18, Name = ZYE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -28.760000 5861 09:27:35 SQL Data Out: ORACLE - Column = 19, Name = YKZYE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -28.760000 5862 09:27:35 SQL Data Out: ORACLE - Column = 20, Name = BJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5863 09:27:35 SQL Data Out: ORACLE - Column = 21, Name = TYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5864 09:27:35 SQL Data Out: ORACLE - Column = 22, Name = YXQFJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.000000 5865 09:27:35 SQL Data Out: ORACLE - Column = 23, Name = KL0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 5866 09:27:35 SQL Data Out: ORACLE - Column = 24, Name = YBZHYE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5867 09:27:35 SQL Data Out: ORACLE - Column = 25, Name = YBYJS0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5868 09:27:35 SQL Data Out: ORACLE - Column = 26, Name = YBYZF0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 5869 09:27:35 SQL Data Out: ORACLE - Column = 27, Name = DBJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5870 09:27:35 SQL Data Out: ORACLE - Column = 28, Name = JFLBMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 门诊预交金 5871 09:27:35 SQL Data Out: ORACLE - Column = 29, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5872 09:27:35 SQL Data Out: ORACLE - Column = 30, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 5873 09:27:35 SQL Data Out: ORACLE - Column = 31, Name = BRBLH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 5874 09:27:35 SQL Data Out: ORACLE - Column = 32, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350107827509 5875 09:27:35 SQL Data Out: ORACLE - Column = 33, Name = YBID00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350128520218054 5876 09:27:35 SQL Data Out: ORACLE - Column = 34, Name = YBLB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 5 5877 09:27:35 SQL Data Out: ORACLE - Column = 35, Name = BRXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 5878 09:27:35 SQL Data Out: ORACLE - Column = 36, Name = BRXB00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 女 5879 09:27:35 SQL Data Out: ORACLE - Column = 37, Name = BRXX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5880 09:27:35 SQL Data Out: ORACLE - Column = 38, Name = BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19520218 5881 09:27:35 SQL Data Out: ORACLE - Column = 39, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5882 09:27:35 SQL Data Out: ORACLE - Column = 40, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5883 09:27:35 SQL Data Out: ORACLE - Column = 41, Name = BRMZ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 汉族 5884 09:27:35 SQL Data Out: ORACLE - Column = 42, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 5885 09:27:35 SQL Data Out: ORACLE - Column = 43, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 身份证 5886 09:27:35 SQL Data Out: ORACLE - Column = 44, Name = BRZJBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5887 09:27:35 SQL Data Out: ORACLE - Column = 45, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 5888 09:27:35 SQL Data Out: ORACLE - Column = 46, Name = BRGFZH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 5889 09:27:35 SQL Data Out: ORACLE - Column = 47, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 平潭县 5890 09:27:35 SQL Data Out: ORACLE - Column = 48, Name = BRDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5891 09:27:35 SQL Data Out: ORACLE - Column = 49, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 福建省 5892 09:27:35 SQL Data Out: ORACLE - Column = 50, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5893 09:27:35 SQL Data Out: ORACLE - Column = 51, Name = TYDWID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5894 09:27:35 SQL Data Out: ORACLE - Column = 52, Name = TYDWMC, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 福建省平潭县盐场 5895 09:27:35 SQL Data Out: ORACLE - Column = 53, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5896 09:27:35 SQL Data Out: ORACLE - Column = 54, Name = BRLXXM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 5897 09:27:35 SQL Data Out: ORACLE - Column = 55, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 5898 09:27:35 SQL Data Out: ORACLE - Column = 56, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5899 09:27:35 SQL Data Out: ORACLE - Column = 57, Name = BRZTQK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 退休人员 5900 09:27:35 SQL Data Out: ORACLE - Column = 58, Name = BRJKQK, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 5901 09:27:35 SQL Data Out: ORACLE - Column = 59, Name = BRLX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 复诊 5902 09:27:35 SQL Data Out: ORACLE - Column = 60, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 5903 09:27:35 SQL Data Out: ORACLE - Column = 61, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5904 09:27:35 SQL Data Out: ORACLE - Column = 62, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 5905 09:27:35 SQL Data Out: ORACLE - Column = 63, Name = SHR000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 5906 09:27:35 SQL Data Out: ORACLE - Column = 64, Name = SHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 5907 09:27:35 SQL Data Out: ORACLE - Column = 65, Name = RYCS00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 5908 09:27:35 SQL Data Out: ORACLE - Column = 66, Name = CYQKJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 5909 09:27:35 SQL Data Out: ORACLE - Column = 67, Name = ZYZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5910 09:27:35 SQL Data Out: ORACLE - Column = 68, Name = SFYX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5911 09:27:35 SQL Data Out: ORACLE - Column = 69, Name = BZ0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 5912 09:27:35 SQL Data Out: ORACLE - Column = 70, Name = YBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5913 09:27:35 SQL Data Out: ORACLE - Column = 71, Name = LBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 5914 09:27:35 SQL Data Out: ORACLE - Column = 72, Name = SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5915 09:27:35 SQL Data Out: ORACLE - Column = 73, Name = DWZBID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 5916 09:27:35 SQL Data Out: ORACLE - Column = 74, Name = BRSZSF, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 福建省 5917 09:27:35 SQL Data Out: ORACLE - Column = 75, Name = BRSZS0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5918 09:27:35 SQL Data Out: ORACLE - Column = 76, Name = BRSZZ0, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 5919 09:27:35 SQL Data Out: ORACLE - Column = 77, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5920 09:27:35 SQL Data Out: ORACLE - Column = 78, Name = SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5921 09:27:35 SQL Data Out: ORACLE - Column = 79, Name = PYSM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = way 5922 09:27:35 SQL Data Out: ORACLE - Column = 80, Name = WBSM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = gef 5923 09:27:35 SQL Data Out: ORACLE - Column = 81, Name = LXRXB0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 5924 09:27:35 SQL Data Out: ORACLE - Column = 82, Name = LXRSFZ, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 5925 09:27:35 SQL Data Out: ORACLE - Column = 83, Name = BRTZ00, Type = fldFLOAT, Precision = 8, Scale = 2, Data = NULL 5926 09:27:35 SQL Data Out: ORACLE - Column = 84, Name = EMAIL0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 5927 09:27:35 SQL Data Out: ORACLE - Column = 86, Name = BJJBIE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 5928 09:27:35 SQL Data Out: ORACLE - Column = 87, Name = FWBJ00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 平潭县 5929 09:27:35 SQL Data Out: ORACLE - Column = 88, Name = TSSXMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 普通 5930 09:27:35 SQL Data Out: ORACLE - Column = 89, Name = SFYDY0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 5931 09:27:35 SQL Data Out: ORACLE - Column = 90, Name = BRSZC0, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 5932 09:27:35 SQL Data Out: ORACLE - Column = 91, Name = BRSZQY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5933 09:27:35 SQL Data Out: ORACLE - Column = 92, Name = BMMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 5934 09:27:35 SQL Data Out: ORACLE - Column = 93, Name = SFSD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 5935 09:27:35 SQL Data Out: ORACLE - Column = 94, Name = FBMC00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 医保 5936 09:27:35 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 5937 09:27:35 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 5938 09:27:35 SQL Stmt: ORACLE - Fetch 5939 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = ORASYSDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 5940 09:27:35 SQL Prepare: ORACLE - select * from ic_ybbrlb where YBLB00 = :1 5941 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 5942 09:27:35 SQL Execute: ORACLE - select * from ic_ybbrlb where YBLB00 = ? 5943 09:27:35 SQL Stmt: ORACLE - Fetch 5944 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = YBLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 5 5945 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = YBMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 平潭分中心 5946 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5947 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = SFJSDW, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 5948 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 5949 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = MRZFBL, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 5950 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = MRYYDJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 5951 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = MRJMBL, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 0.000000 5952 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = TSJK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 5953 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = YBBHSB, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 14,15 5954 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = SFXNH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5955 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = PXH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = NULL 5956 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = FYBQZ0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 5957 09:27:35 SQL Stmt: ORACLE - Reset 5958 09:27:35 SQL Stmt: ORACLE - Close 5959 09:27:35 SQL Prepare: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=:1 and YBBRLB=:2 and YBZXLB=:3 5960 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 5961 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 5962 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5963 09:27:35 SQL Execute: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=? and YBBRLB=? and YBZXLB=? 5964 09:27:35 SQL Stmt: ORACLE - Fetch 5965 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = JLS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5966 09:27:35 SQL Stmt: ORACLE - Reset 5967 09:27:35 SQL Stmt: ORACLE - Close 5968 09:27:35 SQL Prepare: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =:1 5969 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5970 09:27:35 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 5971 09:27:35 SQL Stmt: ORACLE - Fetch 5972 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = TBLBMC, Type = fldZSTRING, Precision = 62, Scale = 0, Data = (福州市医保中心)平潭分中心 5973 09:27:35 SQL Prepare: ORACLE - select max(GHID00) GHID00 from SF_BRXXB0 A where 1 = 1 and A.BRID00 = :1 and A.LBBH00 = :2 and A.GHH000 = :3 5974 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5975 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 5976 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5977 09:27:35 SQL Execute: ORACLE - select max(GHID00) GHID00 from SF_BRXXB0 A where 1 = 1 and A.BRID00 = ? and A.LBBH00 = ? and A.GHH000 = ? 5978 09:27:35 SQL Stmt: ORACLE - Fetch 5979 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 5980 09:27:35 SQL Stmt: ORACLE - Reset 5981 09:27:35 SQL Stmt: ORACLE - Close 5982 09:27:35 SQL Prepare: ORACLE - select NVL(max(A.YBGHH0),0) YBLSH0,max(C.BMMC00) GHKSMC,max(D.LBMC00) GHLBMC,max(A.GHH000) GHH000 from SF_BRXXB0 A,SF_BRFY00 B,BM_BMBM00 C ,BM_GHLBB0 D where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.GHLB00 = D.LBBH00(+) and A.LBBH00 = B.JFLBID and B.JZDH00+0 = 0 and A.GHID00 = :1 5983 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 5984 09:27:35 SQL Execute: ORACLE - select NVL(max(A.YBGHH0),0) YBLSH0,max(C.BMMC00) GHKSMC,max(D.LBMC00) GHLBMC,max(A.GHH000) GHH000 from SF_BRXXB0 A,SF_BRFY00 B,BM_BMBM00 C ,BM_GHLBB0 D where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.GHLB00 = D.LBBH00(+) and A.LBBH00 = B.JFLBID and B.JZDH00+0 = 0 and A.GHID00 = ? 5985 09:27:35 SQL Stmt: ORACLE - Fetch 5986 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = YBLSH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 48976387 5987 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = GHKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科专家门诊 5988 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = GHLBMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 副主任医师 5989 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 5990 09:27:35 SQL Stmt: ORACLE - Reset 5991 09:27:35 SQL Stmt: ORACLE - Close 5992 09:27:35 SQL Prepare: ORACLE - select a.fbbh00,a.brid00,b.ybzxlb from bm_brxxb0 a,ic_ybbrlb b where a.brid00 = :1 and a.yblb00=b.yblb00 and a.fbbh00=b.fbbh00 5993 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 5994 09:27:35 SQL Execute: ORACLE - select a.fbbh00,a.brid00,b.ybzxlb from bm_brxxb0 a,ic_ybbrlb b where a.brid00 = ? and a.yblb00=b.yblb00 and a.fbbh00=b.fbbh00 5995 09:27:35 SQL Stmt: ORACLE - Fetch 5996 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 5997 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 5998 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 5999 09:27:35 SQL Prepare: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> :1 and D.BRID00 = :2 and D.JFLBID = :3 and D.CZRQ00>= :4 and D.CZRQ00<= :5 and ( MZH000 = :6 or MZH000 = '0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<> :7 ) 6000 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000001488.000000 6001 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6002 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6003 09:27:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6004 09:27:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6005 09:27:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6006 09:27:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6007 09:27:35 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000 = '0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<> ? ) 6008 09:27:35 SQL Stmt: ORACLE - Fetch 6009 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6010 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6011 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6012 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6013 09:27:35 SQL Stmt: ORACLE - Reset 6014 09:27:35 SQL Stmt: ORACLE - Close 6015 09:27:35 SQL Prepare: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=:1 and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =:2) 6016 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6017 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6018 09:27:35 SQL Execute: ORACLE - select sum(ZFJE00) ZFJE00,sum(JZJE00) JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 =?) 6019 09:27:35 SQL Stmt: ORACLE - Fetch 6020 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6021 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6022 09:27:35 SQL Stmt: ORACLE - Reset 6023 09:27:35 SQL Stmt: ORACLE - Close 6024 09:27:35 SQL Prepare: ORACLE - update SF_BRFY00 SET CZRQ00='20100903' WHERE BRID00=848440 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '1339461') 6025 09:27:35 SQL Execute: ORACLE - update SF_BRFY00 SET CZRQ00='20100903' WHERE BRID00=848440 and JZDH00+0=0 AND CZRQ00='19990101' and ( MZH000 = '1339461') 6026 09:27:35 SQL Data In: ORACLE - Rows affected = 0 6027 09:27:35 SQL Stmt: ORACLE - Close 6028 09:27:35 SQL Prepare: ORACLE - select max(JZDH00) JZDH00 from sf_brfy00 where BRID00 = :1 and jzdh00+0<>0 and CZRQ00>= :2 and CZRQ00<= :3 and MZH000 = :4 6029 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6030 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6031 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6032 09:27:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1339461 6033 09:27:35 SQL Execute: ORACLE - select max(JZDH00) JZDH00 from sf_brfy00 where BRID00 = ? and jzdh00+0<>0 and CZRQ00>= ? and CZRQ00<= ? and MZH000 = ? 6034 09:27:35 SQL Stmt: ORACLE - Fetch 6035 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6036 09:27:35 SQL Prepare: ORACLE - select 0 FPXMID,'合计' XMMC00, :1 JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0<> :2 and D.BRID00 = :3 and D.JFLBID = :4 and D.CZRQ00>= :5 and D.CZRQ00<= :6 and ( MZH000 = :7 or MZH000='0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>:8 ) group by C.FPXMID, C.XMMC00 6037 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6038 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000001488.000000 6039 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6040 09:27:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6041 09:27:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6042 09:27:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6043 09:27:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6044 09:27:35 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6045 09:27:35 SQL Execute: ORACLE - select 0 FPXMID,'合计' XMMC00, ? JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0<> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000='0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>? ) group by C.FPXMID, C.XMMC00 6046 09:27:35 SQL Stmt: ORACLE - Fetch 6047 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = FPXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6048 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 合计 6049 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6050 09:27:35 SQL Stmt: ORACLE - Fetch 6051 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = FPXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 6052 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 成药费 6053 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.260000 6054 09:27:35 SQL Stmt: ORACLE - Fetch 6055 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = FPXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 6056 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 挂号费 6057 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.500000 6058 09:27:35 SQL Stmt: ORACLE - Fetch 6059 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = FPXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 6060 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = XMMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 诊察费 6061 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 6062 09:27:35 SQL Stmt: ORACLE - Fetch 6063 09:27:35 SQL Stmt: ORACLE - EOF 6064 09:27:35 SQL Stmt: ORACLE - Reset 6065 09:27:35 SQL Prepare: ORACLE - select A.*,D.CZYXM0,D.MZH000 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and a.xmbh00+0<> :1 and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = :2 and D.JFLBID = :3 and D.CZRQ00>= :4 and D.CZRQ00<= :5 and ( D.MZH000 = :6 or MZH000='0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>:7 ) 6066 09:27:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000001488.000000 6067 09:27:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6068 09:27:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6069 09:27:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6070 09:27:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6071 09:27:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6072 09:27:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6073 09:27:35 SQL Execute: ORACLE - select A.*,D.CZYXM0,D.MZH000 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and a.xmbh00+0<> ? and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>= ? and D.CZRQ00<= ? and ( D.MZH000 = ? or MZH000='0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>? ) 6074 09:27:35 SQL Stmt: ORACLE - Fetch 6075 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = MXID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9684039.000000 6076 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7863059.000000 6077 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20011.000000 6078 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费 6079 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6080 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6081 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.500000 6082 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6083 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.500000 6084 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.500000 6085 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6086 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6087 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = JMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6088 09:27:35 SQL Data Out: ORACLE - Column = 14, Name = JMSHR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6089 09:27:35 SQL Data Out: ORACLE - Column = 15, Name = JMYY00, Type = fldZSTRING, Precision = 150, Scale = 0, Data = NULL 6090 09:27:35 SQL Data Out: ORACLE - Column = 16, Name = JMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6091 09:27:35 SQL Data Out: ORACLE - Column = 17, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6092 09:27:35 SQL Data Out: ORACLE - Column = 18, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 6093 09:27:35 SQL Data Out: ORACLE - Column = 19, Name = ZXRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6094 09:27:35 SQL Data Out: ORACLE - Column = 20, Name = ZXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:15:21 6095 09:27:35 SQL Data Out: ORACLE - Column = 21, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 6096 09:27:35 SQL Data Out: ORACLE - Column = 22, Name = SFYDJ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6097 09:27:35 SQL Data Out: ORACLE - Column = 23, Name = KDKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 488.000000 6098 09:27:35 SQL Data Out: ORACLE - Column = 24, Name = YSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 488.000000 6099 09:27:35 SQL Data Out: ORACLE - Column = 25, Name = KDYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6100 09:27:35 SQL Data Out: ORACLE - Column = 26, Name = KDBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6101 09:27:35 SQL Data Out: ORACLE - Column = 27, Name = ZXKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 488.000000 6102 09:27:35 SQL Data Out: ORACLE - Column = 28, Name = ZXYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6103 09:27:35 SQL Data Out: ORACLE - Column = 29, Name = SFLSCF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6104 09:27:35 SQL Data Out: ORACLE - Column = 30, Name = BEIZHU, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6105 09:27:35 SQL Data Out: ORACLE - Column = 31, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 6106 09:27:35 SQL Data Out: ORACLE - Column = 32, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6107 09:27:35 SQL Data Out: ORACLE - Column = 33, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110100001 6108 09:27:35 SQL Data Out: ORACLE - Column = 34, Name = SFLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6109 09:27:35 SQL Data Out: ORACLE - Column = 35, Name = YJJZID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 6110 09:27:35 SQL Data Out: ORACLE - Column = 36, Name = ZHJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6111 09:27:35 SQL Data Out: ORACLE - Column = 37, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 6112 09:27:35 SQL Data Out: ORACLE - Column = 38, Name = SHJG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6113 09:27:35 SQL Data Out: ORACLE - Column = 39, Name = TCJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 6114 09:27:35 SQL Data Out: ORACLE - Column = 40, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 6115 09:27:35 SQL Data Out: ORACLE - Column = 41, Name = MZH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0 6116 09:27:35 SQL Stmt: ORACLE - Fetch 6117 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = MXID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9684449.000000 6118 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7863348.000000 6119 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 9999999998.000000 6120 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 成药费 6121 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6122 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 6123 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 53.260000 6124 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6125 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 53.260000 6126 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 53.260000 6127 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6128 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6129 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = JMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6130 09:27:35 SQL Data Out: ORACLE - Column = 14, Name = JMSHR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6131 09:27:35 SQL Data Out: ORACLE - Column = 15, Name = JMYY00, Type = fldZSTRING, Precision = 150, Scale = 0, Data = NULL 6132 09:27:35 SQL Data Out: ORACLE - Column = 16, Name = JMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6133 09:27:35 SQL Data Out: ORACLE - Column = 17, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6134 09:27:35 SQL Data Out: ORACLE - Column = 18, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:27:35 6135 09:27:35 SQL Data Out: ORACLE - Column = 19, Name = ZXRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6136 09:27:35 SQL Data Out: ORACLE - Column = 20, Name = ZXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:27:35 6137 09:27:35 SQL Data Out: ORACLE - Column = 21, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 6138 09:27:35 SQL Data Out: ORACLE - Column = 22, Name = SFYDJ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6139 09:27:35 SQL Data Out: ORACLE - Column = 23, Name = KDKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 526.000000 6140 09:27:35 SQL Data Out: ORACLE - Column = 24, Name = YSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 610.000000 6141 09:27:35 SQL Data Out: ORACLE - Column = 25, Name = KDYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6142 09:27:35 SQL Data Out: ORACLE - Column = 26, Name = KDBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6143 09:27:35 SQL Data Out: ORACLE - Column = 27, Name = ZXKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 538.000000 6144 09:27:35 SQL Data Out: ORACLE - Column = 28, Name = ZXYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6145 09:27:35 SQL Data Out: ORACLE - Column = 29, Name = SFLSCF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6146 09:27:35 SQL Data Out: ORACLE - Column = 30, Name = BEIZHU, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1258056 6147 09:27:35 SQL Data Out: ORACLE - Column = 31, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 0.100000 6148 09:27:35 SQL Data Out: ORACLE - Column = 32, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 53.260000 6149 09:27:35 SQL Data Out: ORACLE - Column = 33, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 6150 09:27:35 SQL Data Out: ORACLE - Column = 34, Name = SFLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6151 09:27:35 SQL Data Out: ORACLE - Column = 35, Name = YJJZID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 6152 09:27:35 SQL Data Out: ORACLE - Column = 36, Name = ZHJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6153 09:27:35 SQL Data Out: ORACLE - Column = 37, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 6154 09:27:35 SQL Data Out: ORACLE - Column = 38, Name = SHJG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6155 09:27:35 SQL Data Out: ORACLE - Column = 39, Name = TCJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 6156 09:27:35 SQL Data Out: ORACLE - Column = 40, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 6157 09:27:35 SQL Data Out: ORACLE - Column = 41, Name = MZH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6158 09:27:35 SQL Stmt: ORACLE - Fetch 6159 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = MXID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9684155.000000 6160 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7863137.000000 6161 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20008.000000 6162 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费 6163 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6164 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6165 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6166 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6167 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6168 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6169 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6170 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6171 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = JMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6172 09:27:35 SQL Data Out: ORACLE - Column = 14, Name = JMSHR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6173 09:27:35 SQL Data Out: ORACLE - Column = 15, Name = JMYY00, Type = fldZSTRING, Precision = 150, Scale = 0, Data = NULL 6174 09:27:35 SQL Data Out: ORACLE - Column = 16, Name = JMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6175 09:27:35 SQL Data Out: ORACLE - Column = 17, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6176 09:27:35 SQL Data Out: ORACLE - Column = 18, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:18:40 6177 09:27:35 SQL Data Out: ORACLE - Column = 19, Name = ZXRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6178 09:27:35 SQL Data Out: ORACLE - Column = 20, Name = ZXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:18:40 6179 09:27:35 SQL Data Out: ORACLE - Column = 21, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 6180 09:27:35 SQL Data Out: ORACLE - Column = 22, Name = SFYDJ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6181 09:27:35 SQL Data Out: ORACLE - Column = 23, Name = KDKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 526.000000 6182 09:27:35 SQL Data Out: ORACLE - Column = 24, Name = YSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 610.000000 6183 09:27:35 SQL Data Out: ORACLE - Column = 25, Name = KDYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6184 09:27:35 SQL Data Out: ORACLE - Column = 26, Name = KDBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6185 09:27:35 SQL Data Out: ORACLE - Column = 27, Name = ZXKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 526.000000 6186 09:27:35 SQL Data Out: ORACLE - Column = 28, Name = ZXYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6187 09:27:35 SQL Data Out: ORACLE - Column = 29, Name = SFLSCF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6188 09:27:35 SQL Data Out: ORACLE - Column = 30, Name = BEIZHU, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6189 09:27:35 SQL Data Out: ORACLE - Column = 31, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 6190 09:27:35 SQL Data Out: ORACLE - Column = 32, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6191 09:27:35 SQL Data Out: ORACLE - Column = 33, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110100001 6192 09:27:35 SQL Data Out: ORACLE - Column = 34, Name = SFLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6193 09:27:35 SQL Data Out: ORACLE - Column = 35, Name = YJJZID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 6194 09:27:35 SQL Data Out: ORACLE - Column = 36, Name = ZHJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6195 09:27:35 SQL Data Out: ORACLE - Column = 37, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 6196 09:27:35 SQL Data Out: ORACLE - Column = 38, Name = SHJG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6197 09:27:35 SQL Data Out: ORACLE - Column = 39, Name = TCJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 6198 09:27:35 SQL Data Out: ORACLE - Column = 40, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 6199 09:27:35 SQL Data Out: ORACLE - Column = 41, Name = MZH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6200 09:27:35 SQL Stmt: ORACLE - Fetch 6201 09:27:35 SQL Data Out: ORACLE - Column = 1, Name = MXID00, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 9684156.000000 6202 09:27:35 SQL Data Out: ORACLE - Column = 2, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7863137.000000 6203 09:27:35 SQL Data Out: ORACLE - Column = 3, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20018.000000 6204 09:27:35 SQL Data Out: ORACLE - Column = 4, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 普通门诊诊查费—副主任医师 6205 09:27:35 SQL Data Out: ORACLE - Column = 5, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6206 09:27:35 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6207 09:27:35 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 6208 09:27:35 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6209 09:27:35 SQL Data Out: ORACLE - Column = 9, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 6210 09:27:35 SQL Data Out: ORACLE - Column = 10, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 6211 09:27:35 SQL Data Out: ORACLE - Column = 11, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6212 09:27:35 SQL Data Out: ORACLE - Column = 12, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6213 09:27:35 SQL Data Out: ORACLE - Column = 13, Name = JMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6214 09:27:35 SQL Data Out: ORACLE - Column = 14, Name = JMSHR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6215 09:27:35 SQL Data Out: ORACLE - Column = 15, Name = JMYY00, Type = fldZSTRING, Precision = 150, Scale = 0, Data = NULL 6216 09:27:35 SQL Data Out: ORACLE - Column = 16, Name = JMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6217 09:27:35 SQL Data Out: ORACLE - Column = 17, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6218 09:27:35 SQL Data Out: ORACLE - Column = 18, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:18:40 6219 09:27:35 SQL Data Out: ORACLE - Column = 19, Name = ZXRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6220 09:27:35 SQL Data Out: ORACLE - Column = 20, Name = ZXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:18:40 6221 09:27:35 SQL Data Out: ORACLE - Column = 21, Name = CXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 6222 09:27:35 SQL Data Out: ORACLE - Column = 22, Name = SFYDJ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6223 09:27:35 SQL Data Out: ORACLE - Column = 23, Name = KDKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 526.000000 6224 09:27:35 SQL Data Out: ORACLE - Column = 24, Name = YSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 610.000000 6225 09:27:35 SQL Data Out: ORACLE - Column = 25, Name = KDYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6226 09:27:35 SQL Data Out: ORACLE - Column = 26, Name = KDBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 6227 09:27:35 SQL Data Out: ORACLE - Column = 27, Name = ZXKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 526.000000 6228 09:27:35 SQL Data Out: ORACLE - Column = 28, Name = ZXYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1109.000000 6229 09:27:35 SQL Data Out: ORACLE - Column = 29, Name = SFLSCF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6230 09:27:35 SQL Data Out: ORACLE - Column = 30, Name = BEIZHU, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 6231 09:27:35 SQL Data Out: ORACLE - Column = 31, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 0.000000 6232 09:27:35 SQL Data Out: ORACLE - Column = 32, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6233 09:27:35 SQL Data Out: ORACLE - Column = 33, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110200001-3 6234 09:27:35 SQL Data Out: ORACLE - Column = 34, Name = SFLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6235 09:27:35 SQL Data Out: ORACLE - Column = 35, Name = YJJZID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 6236 09:27:35 SQL Data Out: ORACLE - Column = 36, Name = ZHJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 0.000000 6237 09:27:35 SQL Data Out: ORACLE - Column = 37, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 6238 09:27:35 SQL Data Out: ORACLE - Column = 38, Name = SHJG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6239 09:27:35 SQL Data Out: ORACLE - Column = 39, Name = TCJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 6240 09:27:35 SQL Data Out: ORACLE - Column = 40, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 6241 09:27:35 SQL Data Out: ORACLE - Column = 41, Name = MZH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6242 09:27:35 SQL Stmt: ORACLE - Fetch 6243 09:27:35 SQL Stmt: ORACLE - EOF 6244 09:27:35 SQL Stmt: ORACLE - Reset 6245 09:27:35 SQL Stmt: ORACLE - Reset 6246 09:27:35 SQL Stmt: ORACLE - Close 6247 09:27:35 SQL Stmt: ORACLE - Reset 6248 09:27:35 SQL Stmt: ORACLE - Close 6249 09:27:35 SQL Stmt: ORACLE - Close 6250 09:27:36 SQL Prepare: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> :1 and D.BRID00 = :2 and D.JFLBID = :3 and D.CZRQ00>=:4 and D.CZRQ00<= :5 and ( MZH000 = :6 or MZH000 = '0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>:7 ) 6251 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000001488.000000 6252 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6253 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6254 09:27:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6255 09:27:36 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6256 09:27:36 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6257 09:27:36 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 6258 09:27:36 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> ? and D.BRID00 = ? and D.JFLBID = ? and D.CZRQ00>=? and D.CZRQ00<= ? and ( MZH000 = ? or MZH000 = '0') and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>? ) 6259 09:27:36 SQL Stmt: ORACLE - Fetch 6260 09:27:36 SQL Data Out: ORACLE - Column = 1, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6261 09:27:36 SQL Data Out: ORACLE - Column = 2, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6262 09:27:36 SQL Data Out: ORACLE - Column = 3, Name = JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6263 09:27:36 SQL Data Out: ORACLE - Column = 4, Name = GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6264 09:27:36 SQL Stmt: ORACLE - Reset 6265 09:27:36 SQL Stmt: ORACLE - Close 6266 09:27:36 SQL Prepare: ORACLE - select ZFJE00, JZJE00 FROM SF_BRFY00 WHERE BRID00=:1 and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 = :2) 6267 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6268 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6269 09:27:36 SQL Execute: ORACLE - select ZFJE00, JZJE00 FROM SF_BRFY00 WHERE BRID00=? and JZDH00+0=0 AND CXPJR0='999999' and ( MZH000 = ?) 6270 09:27:36 SQL Stmt: ORACLE - Fetch 6271 09:27:36 SQL Stmt: ORACLE - EOF 6272 09:27:36 SQL Stmt: ORACLE - Reset 6273 09:27:36 SQL Stmt: ORACLE - Close 6274 09:27:36 SQL Stmt: ORACLE - Reset 6275 09:27:36 SQL Stmt: ORACLE - Close 6276 09:27:36 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 6277 09:27:36 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 6278 09:27:36 SQL Stmt: ORACLE - Fetch 6279 09:27:36 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 3 6280 09:27:36 SQL Stmt: ORACLE - Reset 6281 09:27:36 SQL Stmt: ORACLE - Close 6282 09:27:36 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 6283 09:27:36 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 6284 09:27:36 SQL Stmt: ORACLE - Fetch 6285 09:27:36 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 3 6286 09:27:36 SQL Stmt: ORACLE - Reset 6287 09:27:36 SQL Stmt: ORACLE - Close 6288 09:27:36 SQL Prepare: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= :1) and d.srrq00>=to_char(sysdate-:2,'YYYYMMDD') 6289 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6290 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6291 09:27:36 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 6292 09:27:36 SQL Stmt: ORACLE - Fetch 6293 09:27:36 SQL Stmt: ORACLE - EOF 6294 09:27:36 SQL Stmt: ORACLE - Reset 6295 09:27:36 SQL Stmt: ORACLE - Close 6296 09:27:36 SQL Prepare: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=:1 and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') 6297 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6298 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6299 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6300 09:27:36 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 6301 09:27:36 SQL Stmt: ORACLE - Fetch 6302 09:27:36 SQL Stmt: ORACLE - EOF 6303 09:27:36 SQL Stmt: ORACLE - Reset 6304 09:27:36 SQL Stmt: ORACLE - Close 6305 09:27:36 SQL Prepare: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= :1 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-:2,'YYYYMMDD') and A.YPDLBH=D.LBBH00 6306 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6307 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6308 09:27:36 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 6309 09:27:36 SQL Stmt: ORACLE - Fetch 6310 09:27:36 SQL Stmt: ORACLE - EOF 6311 09:27:36 SQL Stmt: ORACLE - Reset 6312 09:27:36 SQL Stmt: ORACLE - Close 6313 09:27:36 SQL Prepare: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= :1 and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') 6314 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6315 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6316 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6317 09:27:36 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 6318 09:27:36 SQL Stmt: ORACLE - Fetch 6319 09:27:36 SQL Stmt: ORACLE - EOF 6320 09:27:36 SQL Stmt: ORACLE - Reset 6321 09:27:36 SQL Stmt: ORACLE - Close 6322 09:27:36 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=:1 and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= :2) and B.srrq00>=to_char(sysdate-:3,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 6323 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6324 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6325 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6326 09:27:36 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 6327 09:27:36 SQL Stmt: ORACLE - Fetch 6328 09:27:36 SQL Stmt: ORACLE - EOF 6329 09:27:36 SQL Stmt: ORACLE - Reset 6330 09:27:36 SQL Stmt: ORACLE - Close 6331 09:27:36 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= :1 and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= :2) and B.srrq00>=to_char(sysdate-:3,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 6332 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6333 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6334 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6335 09:27:36 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 6336 09:27:36 SQL Stmt: ORACLE - Fetch 6337 09:27:36 SQL Data Out: ORACLE - Column = 1, Name = SS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6338 09:27:36 SQL Data Out: ORACLE - Column = 2, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 6339 09:27:36 SQL Data Out: ORACLE - Column = 3, Name = SRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6340 09:27:36 SQL Data Out: ORACLE - Column = 4, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6341 09:27:36 SQL Data Out: ORACLE - Column = 5, Name = GHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6342 09:27:36 SQL Stmt: ORACLE - Fetch 6343 09:27:36 SQL Stmt: ORACLE - EOF 6344 09:27:36 SQL Stmt: ORACLE - Reset 6345 09:27:36 SQL Stmt: ORACLE - Close 6346 09:27:36 SQL Prepare: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= :1 and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 6347 09:27:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6348 09:27:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6349 09:27:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 6350 09:27:36 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 6351 09:27:36 SQL Stmt: ORACLE - Fetch 6352 09:27:36 SQL Stmt: ORACLE - EOF 6353 09:27:36 SQL Stmt: ORACLE - Reset 6354 09:27:37 SQL Stmt: ORACLE - Close 6355 09:27:37 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='6036' 6356 09:27:37 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='6036' 6357 09:27:37 SQL Stmt: ORACLE - Fetch 6358 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = XKH000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 6036 6359 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = USER00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 6036 6360 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = TZH000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 001 6361 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = PWS000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = hplZOq6iScaqyo 6362 09:27:37 SQL Data Out: ORACLE - Column = 5, Name = SYZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6363 09:27:37 SQL Prepare: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_HJJE01 => :AD_HJJE01); END; 6364 09:27:37 SQL Misc: ORACLE - Set stored procedure on or off 6365 09:27:37 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6366 09:27:37 SQL Data In: ORACLE - Param = 2, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6367 09:27:37 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6368 09:27:37 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1339461 6369 09:27:37 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6370 09:27:37 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6371 09:27:37 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6372 09:27:37 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王爱云 6373 09:27:37 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 6374 09:27:37 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 6375 09:27:37 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6376 09:27:37 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6377 09:27:37 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6378 09:27:37 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6379 09:27:37 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6380 09:27:37 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 6381 09:27:37 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6382 09:27:37 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6383 09:27:37 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6384 09:27:37 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1515.000000 6385 09:27:37 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨欢欢 6386 09:27:37 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 488.000000 6387 09:27:37 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6388 09:27:37 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 05722114 6389 09:27:37 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6390 09:27:37 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6391 09:27:37 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6392 09:27:37 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6393 09:27:37 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6394 09:27:37 SQL Data In: ORACLE - Param = 30, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6395 09:27:37 SQL Data In: ORACLE - Param = 31, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6396 09:27:37 SQL Data In: ORACLE - Param = 32, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6397 09:27:37 SQL Data In: ORACLE - Param = 33, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6398 09:27:37 SQL Data In: ORACLE - Param = 34, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6399 09:27:37 SQL Data In: ORACLE - Param = 35, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6400 09:27:37 SQL Data In: ORACLE - Param = 36, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6401 09:27:37 SQL Data In: ORACLE - Param = 37, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6402 09:27:37 SQL Data In: ORACLE - Param = 38, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6403 09:27:37 SQL Data In: ORACLE - Param = 39, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6404 09:27:37 SQL Data In: ORACLE - Param = 40, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6405 09:27:37 SQL Data In: ORACLE - Param = 41, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6406 09:27:37 SQL Data In: ORACLE - Param = 42, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6407 09:27:37 SQL Data In: ORACLE - Param = 43, Name = AD_HJJE01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6408 09:27:37 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_HJJE01 => :AD_HJJE01); END; 6409 09:27:37 SQL Stmt: ORACLE - Close 6410 09:27:37 SQL Prepare: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 6411 09:27:37 SQL Misc: ORACLE - Set stored procedure on or off 6412 09:27:37 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6413 09:27:37 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6414 09:27:37 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1339461 6415 09:27:37 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 平潭分中心 6416 09:27:37 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6417 09:27:37 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6418 09:27:37 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6419 09:27:37 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6420 09:27:37 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 6421 09:27:37 SQL Stmt: ORACLE - Close 6422 09:27:37 SQL Prepare: ORACLE - select max(A.GHRQ00) GHRQ00,to_char(sysdate,'YYYYMMDD') DTDATE from SF_BRXXB0 A,SF_BRFY00 b,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.LBBH00 = B.JFLBID and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and TRIM(A.YBGHH0)<>'0' and a.ghh000=:1 and A.BRID00 = :2 6423 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6424 09:27:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6425 09:27:37 SQL Execute: ORACLE - select max(A.GHRQ00) GHRQ00,to_char(sysdate,'YYYYMMDD') DTDATE from SF_BRXXB0 A,SF_BRFY00 b,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.LBBH00 = B.JFLBID and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and TRIM(A.YBGHH0)<>'0' and a.ghh000=? and A.BRID00 = ? 6426 09:27:37 SQL Stmt: ORACLE - Fetch 6427 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = GHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6428 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = DTDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6429 09:27:37 SQL Stmt: ORACLE - Reset 6430 09:27:37 SQL Stmt: ORACLE - Close 6431 09:27:37 SQL Stmt: ORACLE - Reset 6432 09:27:37 SQL Stmt: ORACLE - Close 6433 09:27:37 SQL Prepare: ORACLE - select bxlb00 from sf_brxxb0 where brid00= :1 and ghh000= :2 order by ghid00 desc 6434 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6435 09:27:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6436 09:27:37 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where brid00= ? and ghh000= ? order by ghid00 desc 6437 09:27:37 SQL Stmt: ORACLE - Fetch 6438 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = BXLB00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 普通 6439 09:27:37 SQL Stmt: ORACLE - Reset 6440 09:27:37 SQL Stmt: ORACLE - Close 6441 09:27:37 SQL Prepare: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT from BM_SFCFMX_TEMP00 where ID0000 = :1 6442 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610781.000000 6443 09:27:37 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT from BM_SFCFMX_TEMP00 where ID0000 = ? 6444 09:27:37 SQL Stmt: ORACLE - Fetch 6445 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = NUM, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 6446 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = AMOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.260000 6447 09:27:37 SQL Stmt: ORACLE - Reset 6448 09:27:37 SQL Stmt: ORACLE - Close 6449 09:27:37 SQL Prepare: ORACLE - select count(*) ZJL,sum(decode(sign(HJJE00),-1,1,0)) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = :1 and mzid00 in (select mzid00 from sf_jzb000 where jzdh00=375369) 6450 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6451 09:27:37 SQL Execute: ORACLE - select count(*) ZJL,sum(decode(sign(HJJE00),-1,1,0)) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = ? and mzid00 in (select mzid00 from sf_jzb000 where jzdh00=375369) 6452 09:27:37 SQL Stmt: ORACLE - Fetch 6453 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ZJL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6454 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = CXJL, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6455 09:27:37 SQL Stmt: ORACLE - Reset 6456 09:27:37 SQL Stmt: ORACLE - Close 6457 09:27:37 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = :1 and BZ0000 = 'Y' 6458 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610781.000000 6459 09:27:37 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 6460 09:27:37 SQL Stmt: ORACLE - Fetch 6461 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6462 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 成药费 6463 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 53.26 6464 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6465 09:27:37 SQL Stmt: ORACLE - Fetch 6466 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6467 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 诊察费 6468 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 4 6469 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6470 09:27:37 SQL Stmt: ORACLE - Fetch 6471 09:27:37 SQL Stmt: ORACLE - EOF 6472 09:27:37 SQL Stmt: ORACLE - Reset 6473 09:27:37 SQL Stmt: ORACLE - Close 6474 09:27:37 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = :1 and BZ0000 = 'N' 6475 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610781.000000 6476 09:27:37 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 6477 09:27:37 SQL Stmt: ORACLE - Fetch 6478 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6479 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 挂号费 6480 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = VALUE0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 1 6481 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 6482 09:27:37 SQL Stmt: ORACLE - Fetch 6483 09:27:37 SQL Stmt: ORACLE - EOF 6484 09:27:37 SQL Stmt: ORACLE - Reset 6485 09:27:37 SQL Stmt: ORACLE - Close 6486 09:27:37 SQL Prepare: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = :1 6487 09:27:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 610781.000000 6488 09:27:37 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 6489 09:27:37 SQL Stmt: ORACLE - Fetch 6490 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6491 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 011010000104 6492 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 6493 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 挂号费 6494 09:27:37 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费（县医院） 6495 09:27:37 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 次 6496 09:27:37 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6497 09:27:37 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6498 09:27:37 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6499 09:27:37 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 6500 09:27:37 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 无 6501 09:27:37 SQL Stmt: ORACLE - Fetch 6502 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6503 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 011020000132 6504 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6505 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 诊察费 6506 09:27:37 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 普通门诊诊查费？副主任医师（三甲以下医院） 6507 09:27:37 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 次 6508 09:27:37 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 6509 09:27:37 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 1.000000 6510 09:27:37 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 4.000000 6511 09:27:37 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 6512 09:27:37 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 无 6513 09:27:37 SQL Stmt: ORACLE - Fetch 6514 09:27:37 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 15, Scale = 0, Data = 610781.000000 6515 09:27:37 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 22701209047028112202 6516 09:27:37 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6517 09:27:37 SQL Data Out: ORACLE - Column = 4, Name = FPXMMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 成药费 6518 09:27:37 SQL Data Out: ORACLE - Column = 5, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 活血止痛膏 6519 09:27:37 SQL Data Out: ORACLE - Column = 6, Name = XMDW00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 盒 6520 09:27:37 SQL Data Out: ORACLE - Column = 7, Name = XMDJ00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 26.630000 6521 09:27:37 SQL Data Out: ORACLE - Column = 8, Name = XMSL00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 2.000000 6522 09:27:37 SQL Data Out: ORACLE - Column = 9, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 4, Data = 53.260000 6523 09:27:37 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 吴海峰 6524 09:27:37 SQL Data Out: ORACLE - Column = 11, Name = XMGG00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 7cm*10cm*2贴*3袋 6525 09:27:37 SQL Stmt: ORACLE - Fetch 6526 09:27:37 SQL Stmt: ORACLE - EOF 6527 09:27:37 SQL Stmt: ORACLE - Reset 6528 09:27:37 SQL Stmt: ORACLE - Close 6529 09:27:40 SQL Stmt: ORACLE - Reset 6530 09:27:40 SQL Stmt: ORACLE - Close 6531 09:27:40 SQL Prepare: ORACLE - select SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'1','1' ) zfje00 from dual 6532 09:27:40 SQL Execute: ORACLE - select SF_SF_YBFYJS(58.26,0,31.77,0,0,0,0,0,26.49,848440,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'1','1' ) zfje00 from dual 6533 09:27:40 SQL Stmt: ORACLE - Fetch 6534 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.490000 6535 09:27:40 SQL Prepare: ORACLE - BEGIN "SP_SF_YBJSDJ" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_YBLB00 => :AS_YBLB00,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_ZFJE00 => :AD_ZFJE00,AD_TCJJZF => :AD_TCJJZF,AD_GRZHZF => :AD_GRZHZF,AD_YBXJZF => :AD_YBXJZF,AD_SBTJDH => :AD_SBTJDH,AD_SBZHDH => :AD_SBZHDH,AD_SBZFJE => :AD_SBZFJE,AD_SBTJJE => :AD_SBTJJE,AD_SBZHJE => :AD_SBZHJE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AS_YBZHYE => :AS_YBZHYE,AS_TSBZBH => :AS_TSBZBH,AD_JJZFE0 => :AD_JJZFE0,AD_JJDJH0 => :AD_JJDJH0,AD_BCKBCS => :AD_BCKBCS,AD_GWYBZ0 => :AD_GWYBZ0,AD_SYDJH0 => :AD_SYDJH0,AD_SYBXZF => :AD_SYBXZF,AD_FYBJE0 => :AD_FYBJE0,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_SBZFE0 => :AD_SBZFE0,AD_SBDJH0 => :AD_SBDJH0,AD_BJZFE0 => :AD_BJZFE0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_YBYL01 => :ad_YBYL01,ad_YBYL02 => :ad_YBYL02,ad_YBYL03 => :ad_YBYL03,ad_YBYL04 => :ad_YBYL04,ad_YBYL05 => :ad_YBYL05,ad_YBYL06 => :ad_YBYL06,ad_YBYL07 => :ad_YBYL07,ad_YBYL08 => :ad_YBYL08,ad_YBYL09 => :ad_YBYL09,ad_YBYL10 => :ad_YBYL10,ad_YBYL11 => :ad_YBYL11,ad_YBYL12 => :ad_YBYL12,ad_YBYL13 => :ad_YBYL13); END; 6536 09:27:40 SQL Misc: ORACLE - Set stored procedure on or off 6537 09:27:40 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 57606299 6538 09:27:40 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6539 09:27:40 SQL Data In: ORACLE - Param = 3, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 6540 09:27:40 SQL Data In: ORACLE - Param = 4, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6541 09:27:40 SQL Data In: ORACLE - Param = 5, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863351.000000 6542 09:27:40 SQL Data In: ORACLE - Param = 6, Name = AD_GZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863350.000000 6543 09:27:40 SQL Data In: ORACLE - Param = 7, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.490000 6544 09:27:40 SQL Data In: ORACLE - Param = 8, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6545 09:27:40 SQL Data In: ORACLE - Param = 9, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.770000 6546 09:27:40 SQL Data In: ORACLE - Param = 10, Name = AD_YBXJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.490000 6547 09:27:40 SQL Data In: ORACLE - Param = 11, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863353.000000 6548 09:27:40 SQL Data In: ORACLE - Param = 12, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863352.000000 6549 09:27:40 SQL Data In: ORACLE - Param = 13, Name = AD_SBZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6550 09:27:40 SQL Data In: ORACLE - Param = 14, Name = AD_SBTJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6551 09:27:40 SQL Data In: ORACLE - Param = 15, Name = AD_SBZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6552 09:27:40 SQL Data In: ORACLE - Param = 16, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6553 09:27:40 SQL Data In: ORACLE - Param = 17, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:16:00 6554 09:27:40 SQL Data In: ORACLE - Param = 18, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6555 09:27:40 SQL Data In: ORACLE - Param = 19, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 6556 09:27:40 SQL Data In: ORACLE - Param = 20, Name = AD_JJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6557 09:27:40 SQL Data In: ORACLE - Param = 21, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863354.000000 6558 09:27:40 SQL Data In: ORACLE - Param = 22, Name = AD_BCKBCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6559 09:27:40 SQL Data In: ORACLE - Param = 23, Name = AD_GWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6560 09:27:40 SQL Data In: ORACLE - Param = 24, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863355.000000 6561 09:27:40 SQL Data In: ORACLE - Param = 25, Name = AD_SYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6562 09:27:40 SQL Data In: ORACLE - Param = 26, Name = AD_FYBJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6563 09:27:40 SQL Data In: ORACLE - Param = 27, Name = AD_YLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6564 09:27:40 SQL Data In: ORACLE - Param = 28, Name = AD_CFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6565 09:27:40 SQL Data In: ORACLE - Param = 29, Name = AD_SBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6566 09:27:40 SQL Data In: ORACLE - Param = 30, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863356.000000 6567 09:27:40 SQL Data In: ORACLE - Param = 31, Name = AD_BJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6568 09:27:40 SQL Data In: ORACLE - Param = 32, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863357.000000 6569 09:27:40 SQL Data In: ORACLE - Param = 33, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7863358.000000 6570 09:27:40 SQL Data In: ORACLE - Param = 34, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6571 09:27:40 SQL Data In: ORACLE - Param = 35, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6572 09:27:40 SQL Data In: ORACLE - Param = 36, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6573 09:27:40 SQL Data In: ORACLE - Param = 37, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6574 09:27:40 SQL Data In: ORACLE - Param = 38, Name = ad_YBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6575 09:27:40 SQL Data In: ORACLE - Param = 39, Name = ad_YBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6576 09:27:40 SQL Data In: ORACLE - Param = 40, Name = ad_YBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6577 09:27:40 SQL Data In: ORACLE - Param = 41, Name = ad_YBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6578 09:27:40 SQL Data In: ORACLE - Param = 42, Name = ad_YBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6579 09:27:40 SQL Data In: ORACLE - Param = 43, Name = ad_YBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6580 09:27:40 SQL Data In: ORACLE - Param = 44, Name = ad_YBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6581 09:27:40 SQL Data In: ORACLE - Param = 45, Name = ad_YBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6582 09:27:40 SQL Data In: ORACLE - Param = 46, Name = ad_YBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6583 09:27:40 SQL Data In: ORACLE - Param = 47, Name = ad_YBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6584 09:27:40 SQL Data In: ORACLE - Param = 48, Name = ad_YBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6585 09:27:40 SQL Data In: ORACLE - Param = 49, Name = ad_YBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6586 09:27:40 SQL Data In: ORACLE - Param = 50, Name = ad_YBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6587 09:27:40 SQL Execute: ORACLE - BEGIN "SP_SF_YBJSDJ" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_YBLB00 => :AS_YBLB00,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_ZFJE00 => :AD_ZFJE00,AD_TCJJZF => :AD_TCJJZF,AD_GRZHZF => :AD_GRZHZF,AD_YBXJZF => :AD_YBXJZF,AD_SBTJDH => :AD_SBTJDH,AD_SBZHDH => :AD_SBZHDH,AD_SBZFJE => :AD_SBZFJE,AD_SBTJJE => :AD_SBTJJE,AD_SBZHJE => :AD_SBZHJE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AS_YBZHYE => :AS_YBZHYE,AS_TSBZBH => :AS_TSBZBH,AD_JJZFE0 => :AD_JJZFE0,AD_JJDJH0 => :AD_JJDJH0,AD_BCKBCS => :AD_BCKBCS,AD_GWYBZ0 => :AD_GWYBZ0,AD_SYDJH0 => :AD_SYDJH0,AD_SYBXZF => :AD_SYBXZF,AD_FYBJE0 => :AD_FYBJE0,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_SBZFE0 => :AD_SBZFE0,AD_SBDJH0 => :AD_SBDJH0,AD_BJZFE0 => :AD_BJZFE0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_YBYL01 => :ad_YBYL01,ad_YBYL02 => :ad_YBYL02,ad_YBYL03 => :ad_YBYL03,ad_YBYL04 => :ad_YBYL04,ad_YBYL05 => :ad_YBYL05,ad_YBYL06 => :ad_YBYL06,ad_YBYL07 => :ad_YBYL07,ad_YBYL08 => :ad_YBYL08,ad_YBYL09 => :ad_YBYL09,ad_YBYL10 => :ad_YBYL10,ad_YBYL11 => :ad_YBYL11,ad_YBYL12 => :ad_YBYL12,ad_YBYL13 => :ad_YBYL13); END; 6588 09:27:40 SQL Stmt: ORACLE - Close 6589 09:27:40 SQL Stmt: ORACLE - Reset 6590 09:27:40 SQL Stmt: ORACLE - Close 6591 09:27:40 SQL Prepare: ORACLE - commit 6592 09:27:40 SQL Execute: ORACLE - commit 6593 09:27:40 SQL Data In: ORACLE - Rows affected = 0 6594 09:27:40 SQL Stmt: ORACLE - Close 6595 09:27:40 SQL Stmt: ORACLE - Reset 6596 09:27:40 SQL Stmt: ORACLE - Close 6597 09:27:40 SQL Prepare: ORACLE - select * from vw_sf_fp0000 where jzdh00=375369 6598 09:27:40 SQL Execute: ORACLE - select * from vw_sf_fp0000 where jzdh00=375369 6599 09:27:40 SQL Stmt: ORACLE - Fetch 6600 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = BRBLH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 6601 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6602 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = YBGHH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 48976387 6603 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = BRGFZH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 6604 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350107827509 6605 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = YBID00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350128520218054 6606 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = BRXM00, Type = fldZSTRING, Precision = 62, Scale = 0, Data = 王爱云 6607 09:27:40 SQL Data Out: ORACLE - Column = 8, Name = BRXB00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 女 6608 09:27:40 SQL Data Out: ORACLE - Column = 9, Name = PJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6609 09:27:40 SQL Data Out: ORACLE - Column = 10, Name = FZPJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6610 09:27:40 SQL Data Out: ORACLE - Column = 11, Name = JZDH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 375369.000000 6611 09:27:40 SQL Data Out: ORACLE - Column = 12, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 848440.000000 6612 09:27:40 SQL Data Out: ORACLE - Column = 13, Name = MZID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2515926.000000 6613 09:27:40 SQL Data Out: ORACLE - Column = 14, Name = BRZJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.760000 6614 09:27:40 SQL Data Out: ORACLE - Column = 15, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6615 09:27:40 SQL Data Out: ORACLE - Column = 16, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6616 09:27:40 SQL Data Out: ORACLE - Column = 17, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.760000 6617 09:27:40 SQL Data Out: ORACLE - Column = 18, Name = JMJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6618 09:27:40 SQL Data Out: ORACLE - Column = 19, Name = GRZHZF, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.770000 6619 09:27:40 SQL Data Out: ORACLE - Column = 20, Name = TCJJZF, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6620 09:27:40 SQL Data Out: ORACLE - Column = 21, Name = SBGRZH, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6621 09:27:40 SQL Data Out: ORACLE - Column = 22, Name = SBTCJJ, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6622 09:27:40 SQL Data Out: ORACLE - Column = 23, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 26.490000 6623 09:27:40 SQL Data Out: ORACLE - Column = 24, Name = JZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6624 09:27:40 SQL Data Out: ORACLE - Column = 25, Name = JZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:27:38 6625 09:27:40 SQL Data Out: ORACLE - Column = 26, Name = XJFKJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 58.760000 6626 09:27:40 SQL Data Out: ORACLE - Column = 27, Name = ZZFKJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6627 09:27:40 SQL Data Out: ORACLE - Column = 28, Name = YHKJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6628 09:27:40 SQL Data Out: ORACLE - Column = 29, Name = JZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 6629 09:27:40 SQL Data Out: ORACLE - Column = 30, Name = JMYY00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 6630 09:27:40 SQL Data Out: ORACLE - Column = 31, Name = FPBH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 05722114 6631 09:27:40 SQL Data Out: ORACLE - Column = 32, Name = PJXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 58.760000 6632 09:27:40 SQL Data Out: ORACLE - Column = 33, Name = PJZZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6633 09:27:40 SQL Data Out: ORACLE - Column = 34, Name = CZYBH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1515.000000 6634 09:27:40 SQL Data Out: ORACLE - Column = 35, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 杨欢欢 6635 09:27:40 SQL Data Out: ORACLE - Column = 36, Name = FPDYRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6636 09:27:40 SQL Data Out: ORACLE - Column = 37, Name = FPDYSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:27:38 6637 09:27:40 SQL Data Out: ORACLE - Column = 38, Name = DYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6638 09:27:40 SQL Data Out: ORACLE - Column = 39, Name = GYJZD0, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 0.000000 6639 09:27:40 SQL Data Out: ORACLE - Column = 40, Name = PJZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6640 09:27:40 SQL Data Out: ORACLE - Column = 41, Name = FBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 6641 09:27:40 SQL Data Out: ORACLE - Column = 42, Name = YBZHYE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6642 09:27:40 SQL Data Out: ORACLE - Column = 43, Name = XJFK00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 26.490000 6643 09:27:40 SQL Data Out: ORACLE - Column = 44, Name = ZZFK00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 31.770000 6644 09:27:40 SQL Data Out: ORACLE - Column = 45, Name = FKFS00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 现金 6645 09:27:40 SQL Data Out: ORACLE - Column = 46, Name = SHIWAN, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 零 6646 09:27:40 SQL Data Out: ORACLE - Column = 47, Name = WAN000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 零 6647 09:27:40 SQL Data Out: ORACLE - Column = 48, Name = QIAN00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 零 6648 09:27:40 SQL Data Out: ORACLE - Column = 49, Name = BAI000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 零 6649 09:27:40 SQL Data Out: ORACLE - Column = 50, Name = SHI000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 伍 6650 09:27:40 SQL Data Out: ORACLE - Column = 51, Name = GE0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 捌 6651 09:27:40 SQL Data Out: ORACLE - Column = 52, Name = JIAO00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 柒 6652 09:27:40 SQL Data Out: ORACLE - Column = 53, Name = FEN000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 陆 6653 09:27:40 SQL Data Out: ORACLE - Column = 54, Name = RQYEAR, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 2010 6654 09:27:40 SQL Data Out: ORACLE - Column = 55, Name = RQMON0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 09 6655 09:27:40 SQL Data Out: ORACLE - Column = 56, Name = RQDAY0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 03 6656 09:27:40 SQL Data Out: ORACLE - Column = 57, Name = TYDWQC, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 6657 09:27:40 SQL Data Out: ORACLE - Column = 58, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 6658 09:27:40 SQL Data Out: ORACLE - Column = 59, Name = YBXJZF, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 26.490000 6659 09:27:40 SQL Data Out: ORACLE - Column = 60, Name = YLZFJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6660 09:27:40 SQL Data Out: ORACLE - Column = 61, Name = CFDXJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6661 09:27:40 SQL Data Out: ORACLE - Column = 62, Name = GWYBZ0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6662 09:27:40 SQL Data Out: ORACLE - Column = 63, Name = BCKBCS, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6663 09:27:40 SQL Data Out: ORACLE - Column = 64, Name = JJZFE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6664 09:27:40 SQL Data Out: ORACLE - Column = 65, Name = FYBJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6665 09:27:40 SQL Data Out: ORACLE - Column = 66, Name = SYBXZF, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6666 09:27:40 SQL Data Out: ORACLE - Column = 67, Name = XKH000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 6036 6667 09:27:40 SQL Data Out: ORACLE - Column = 68, Name = SBZFE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6668 09:27:40 SQL Data Out: ORACLE - Column = 69, Name = BJZFE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6669 09:27:40 SQL Data Out: ORACLE - Column = 70, Name = TSBZMC, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 6670 09:27:40 SQL Data Out: ORACLE - Column = 71, Name = YBYL01, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6671 09:27:40 SQL Data Out: ORACLE - Column = 72, Name = YBYL02, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6672 09:27:40 SQL Data Out: ORACLE - Column = 73, Name = YBYL03, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6673 09:27:40 SQL Data Out: ORACLE - Column = 74, Name = YBYL04, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6674 09:27:40 SQL Data Out: ORACLE - Column = 75, Name = YBYL05, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6675 09:27:40 SQL Data Out: ORACLE - Column = 76, Name = YBYL06, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6676 09:27:40 SQL Data Out: ORACLE - Column = 77, Name = YBYL07, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6677 09:27:40 SQL Data Out: ORACLE - Column = 78, Name = YBYL08, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6678 09:27:40 SQL Data Out: ORACLE - Column = 79, Name = YBYL09, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6679 09:27:40 SQL Data Out: ORACLE - Column = 80, Name = YBYL10, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6680 09:27:40 SQL Data Out: ORACLE - Column = 81, Name = YBYL11, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6681 09:27:40 SQL Data Out: ORACLE - Column = 82, Name = YBYL12, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6682 09:27:40 SQL Data Out: ORACLE - Column = 83, Name = YBYL13, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6683 09:27:40 SQL Data Out: ORACLE - Column = 84, Name = YBBHSB, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 14,15 6684 09:27:40 SQL Data Out: ORACLE - Column = 85, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 6685 09:27:40 SQL Data Out: ORACLE - Column = 86, Name = JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 预交金 6686 09:27:40 SQL Prepare: ORACLE - select nvl(a.bmmc00,'--') bmmc00 from bm_bmbm00 a,sf_brxxb0 b where a.bmbh00(+) =b.jzks00 and b.ghid00 =2515926 6687 09:27:40 SQL Execute: ORACLE - select nvl(a.bmmc00,'--') bmmc00 from bm_bmbm00 a,sf_brxxb0 b where a.bmbh00(+) =b.jzks00 and b.ghid00 =2515926 6688 09:27:40 SQL Stmt: ORACLE - Fetch 6689 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科专家门诊 6690 09:27:40 SQL Stmt: ORACLE - Reset 6691 09:27:40 SQL Stmt: ORACLE - Close 6692 09:27:40 SQL Prepare: ORACLE - select YBID00, fbbh00 from BM_BRXXB0 where BRID00=848440 6693 09:27:40 SQL Execute: ORACLE - select YBID00, fbbh00 from BM_BRXXB0 where BRID00=848440 6694 09:27:40 SQL Stmt: ORACLE - Fetch 6695 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = YBID00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350128520218054 6696 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 6697 09:27:40 SQL Stmt: ORACLE - Reset 6698 09:27:40 SQL Stmt: ORACLE - Close 6699 09:27:40 SQL Prepare: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =848440 6700 09:27:40 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =848440 6701 09:27:40 SQL Stmt: ORACLE - Fetch 6702 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = ZYE000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.010000 6703 09:27:40 SQL Stmt: ORACLE - Reset 6704 09:27:40 SQL Stmt: ORACLE - Close 6705 09:27:40 SQL Prepare: ORACLE - select sum(a.hjje00) ickje0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and a.XMBH00=8000001488 and b.jzdh00+0=0 and b.brid00= 848440 6706 09:27:40 SQL Execute: ORACLE - select sum(a.hjje00) ickje0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and a.XMBH00=8000001488 and b.jzdh00+0=0 and b.brid00= 848440 6707 09:27:40 SQL Stmt: ORACLE - Fetch 6708 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = ICKJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6709 09:27:40 SQL Stmt: ORACLE - Reset 6710 09:27:40 SQL Stmt: ORACLE - Close 6711 09:27:40 SQL Stmt: ORACLE - Reset 6712 09:27:40 SQL Stmt: ORACLE - Close 6713 09:27:40 SQL Prepare: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00= :1 AND A.BRID00= 848440 6714 09:27:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2515926.000000 6715 09:27:40 SQL Execute: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00= ? AND A.BRID00= 848440 6716 09:27:40 SQL Stmt: ORACLE - Fetch 6717 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = LBMC00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 副主任医师 6718 09:27:40 SQL Stmt: ORACLE - Reset 6719 09:27:40 SQL Stmt: ORACLE - Close 6720 09:27:40 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SF_TJPJDYXSFPBH' 6721 09:27:40 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SF_TJPJDYXSFPBH' 6722 09:27:40 SQL Stmt: ORACLE - Fetch 6723 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 8 6724 09:27:40 SQL Stmt: ORACLE - Reset 6725 09:27:40 SQL Stmt: ORACLE - Close 6726 09:27:40 SQL Prepare: ORACLE - select * from SF_PJSYMX where xmje00<>0 and PJH000 =3493856 order by XMBH00 6727 09:27:40 SQL Execute: ORACLE - select * from SF_PJSYMX where xmje00<>0 and PJH000 =3493856 order by XMBH00 6728 09:27:40 SQL Stmt: ORACLE - Fetch 6729 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = PJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6730 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2.000000 6731 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 成药费 6732 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 53.260000 6733 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 6734 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6735 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 53.260000 6736 09:27:40 SQL Stmt: ORACLE - Fetch 6737 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = PJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6738 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 4.000000 6739 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费 6740 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 1.500000 6741 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 6742 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6743 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6744 09:27:40 SQL Stmt: ORACLE - Fetch 6745 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = PJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6746 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = XMBH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 6.000000 6747 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 诊察费 6748 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = XMJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 4.000000 6749 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = ZFBL00, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 6750 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6751 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 6752 09:27:40 SQL Stmt: ORACLE - Fetch 6753 09:27:40 SQL Stmt: ORACLE - EOF 6754 09:27:40 SQL Stmt: ORACLE - Reset 6755 09:27:40 SQL Stmt: ORACLE - Close 6756 09:27:40 SQL Prepare: ORACLE - select * from vw_sf_rqdmx3 where jzdh00=375369 6757 09:27:40 SQL Execute: ORACLE - select * from vw_sf_rqdmx3 where jzdh00=375369 6758 09:27:40 SQL Stmt: ORACLE - Fetch 6759 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110100001 6760 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6761 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 6762 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6763 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = MZH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 6764 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20008.000000 6765 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费 6766 09:27:40 SQL Data Out: ORACLE - Column = 8, Name = XMGG00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 县级医院 6767 09:27:40 SQL Data Out: ORACLE - Column = 9, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6768 09:27:40 SQL Data Out: ORACLE - Column = 10, Name = XMDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6769 09:27:40 SQL Data Out: ORACLE - Column = 11, Name = XMSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6770 09:27:40 SQL Data Out: ORACLE - Column = 12, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6771 09:27:40 SQL Data Out: ORACLE - Column = 13, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 6772 09:27:40 SQL Data Out: ORACLE - Column = 14, Name = FPXMMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 挂号费 6773 09:27:40 SQL Data Out: ORACLE - Column = 15, Name = SFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 6774 09:27:40 SQL Data Out: ORACLE - Column = 16, Name = ZFBL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000 6775 09:27:40 SQL Data Out: ORACLE - Column = 17, Name = QDH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6776 09:27:40 SQL Stmt: ORACLE - Fetch 6777 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110100001 6778 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6779 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 6780 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6781 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = MZH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 6782 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20011.000000 6783 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 挂号费 6784 09:27:40 SQL Data Out: ORACLE - Column = 8, Name = XMGG00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 初诊建病历及病历手册收费 6785 09:27:40 SQL Data Out: ORACLE - Column = 9, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6786 09:27:40 SQL Data Out: ORACLE - Column = 10, Name = XMDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.500000 6787 09:27:40 SQL Data Out: ORACLE - Column = 11, Name = XMSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6788 09:27:40 SQL Data Out: ORACLE - Column = 12, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.500000 6789 09:27:40 SQL Data Out: ORACLE - Column = 13, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 6790 09:27:40 SQL Data Out: ORACLE - Column = 14, Name = FPXMMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 挂号费 6791 09:27:40 SQL Data Out: ORACLE - Column = 15, Name = SFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 6792 09:27:40 SQL Data Out: ORACLE - Column = 16, Name = ZFBL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000 6793 09:27:40 SQL Data Out: ORACLE - Column = 17, Name = QDH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6794 09:27:40 SQL Stmt: ORACLE - Fetch 6795 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 110200001-3 6796 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6797 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 6798 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6799 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = MZH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 6800 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20018.000000 6801 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 普通门诊诊查费—副主任医师 6802 09:27:40 SQL Data Out: ORACLE - Column = 8, Name = XMGG00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 三甲以下医院 6803 09:27:40 SQL Data Out: ORACLE - Column = 9, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 6804 09:27:40 SQL Data Out: ORACLE - Column = 10, Name = XMDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 6805 09:27:40 SQL Data Out: ORACLE - Column = 11, Name = XMSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6806 09:27:40 SQL Data Out: ORACLE - Column = 12, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 6807 09:27:40 SQL Data Out: ORACLE - Column = 13, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 6808 09:27:40 SQL Data Out: ORACLE - Column = 14, Name = FPXMMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 诊察费 6809 09:27:40 SQL Data Out: ORACLE - Column = 15, Name = SFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6810 09:27:40 SQL Data Out: ORACLE - Column = 16, Name = ZFBL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6811 09:27:40 SQL Data Out: ORACLE - Column = 17, Name = QDH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6812 09:27:40 SQL Stmt: ORACLE - Fetch 6813 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = GJBM00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 6814 09:27:40 SQL Data Out: ORACLE - Column = 2, Name = JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6815 09:27:40 SQL Data Out: ORACLE - Column = 3, Name = XM0000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 王爱云 6816 09:27:40 SQL Data Out: ORACLE - Column = 4, Name = MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6817 09:27:40 SQL Data Out: ORACLE - Column = 5, Name = MZH000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 41602684 6818 09:27:40 SQL Data Out: ORACLE - Column = 6, Name = XMBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5978.000000 6819 09:27:40 SQL Data Out: ORACLE - Column = 7, Name = XMMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 活血止痛膏 6820 09:27:40 SQL Data Out: ORACLE - Column = 8, Name = XMGG00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 7cm*10cm*2贴*3袋 6821 09:27:40 SQL Data Out: ORACLE - Column = 9, Name = XMDW00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 盒 6822 09:27:40 SQL Data Out: ORACLE - Column = 10, Name = XMDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.630000 6823 09:27:40 SQL Data Out: ORACLE - Column = 11, Name = XMSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 6824 09:27:40 SQL Data Out: ORACLE - Column = 12, Name = HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.260000 6825 09:27:40 SQL Data Out: ORACLE - Column = 13, Name = BH0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 6826 09:27:40 SQL Data Out: ORACLE - Column = 14, Name = FPXMMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 西药费 6827 09:27:40 SQL Data Out: ORACLE - Column = 15, Name = SFYBXM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 6828 09:27:40 SQL Data Out: ORACLE - Column = 16, Name = ZFBL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 6829 09:27:40 SQL Data Out: ORACLE - Column = 17, Name = QDH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100903 6830 09:27:40 SQL Stmt: ORACLE - Fetch 6831 09:27:40 SQL Stmt: ORACLE - EOF 6832 09:27:40 SQL Stmt: ORACLE - Reset 6833 09:27:40 SQL Stmt: ORACLE - Close 6834 09:27:40 SQL Prepare: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,:1,:2,:3,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),:4,:5,:6,:7,:8) 6835 09:27:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 029 6836 09:27:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 375369.000000 6837 09:27:40 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 05722114 6838 09:27:40 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1515.000000 6839 09:27:40 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 杨欢欢 6840 09:27:40 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6841 09:27:40 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6842 09:27:40 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 200, Scale = 0, Data = 成功:029,05722114,58.76,2010030h萞 6843 09:27:40 SQL Execute: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,?,?,?,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),?,?,?,?,?) 6844 09:27:40 SQL Data In: ORACLE - Rows affected = 1 6845 09:27:40 SQL Stmt: ORACLE - Close 6846 09:27:40 SQL Prepare: ORACLE - commit 6847 09:27:40 SQL Execute: ORACLE - commit 6848 09:27:40 SQL Data In: ORACLE - Rows affected = 0 6849 09:27:40 SQL Stmt: ORACLE - Close 6850 09:27:40 SQL Prepare: ORACLE - select pjh000 from sf_jzb000 where jzdh00=375369 6851 09:27:40 SQL Execute: ORACLE - select pjh000 from sf_jzb000 where jzdh00=375369 6852 09:27:40 SQL Stmt: ORACLE - Fetch 6853 09:27:40 SQL Data Out: ORACLE - Column = 1, Name = PJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 3493856.000000 6854 09:27:40 SQL Prepare: ORACLE - update sf_pjsyqk set pjxh00='05722114' where pjzt00='0' and fzpjh0=3493856 6855 09:27:40 SQL Execute: ORACLE - update sf_pjsyqk set pjxh00='05722114' where pjzt00='0' and fzpjh0=3493856 6856 09:27:40 SQL Data In: ORACLE - Rows affected = 1 6857 09:27:40 SQL Stmt: ORACLE - Close 6858 09:27:40 SQL Prepare: ORACLE - commit 6859 09:27:40 SQL Execute: ORACLE - commit 6860 09:27:40 SQL Data In: ORACLE - Rows affected = 0 6861 09:27:40 SQL Stmt: ORACLE - Close 6862 09:27:40 SQL Prepare: ORACLE - select * from vw_sf_wjzcf a where a.BRID00 = :1 and A.GHH000 = :2 6863 09:27:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 848440.000000 6864 09:27:40 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1339461 6865 09:27:40 SQL Execute: ORACLE - select * from vw_sf_wjzcf a where a.BRID00 = ? and A.GHH000 = ? 6866 09:27:40 SQL Stmt: ORACLE - Fetch 6867 09:27:40 SQL Stmt: ORACLE - EOF 6868 09:27:40 SQL Stmt: ORACLE - Reset 6869 09:27:40 SQL Stmt: ORACLE - Close 6870 09:27:40 SQL Prepare: ORACLE - rollback 6871 09:27:40 SQL Execute: ORACLE - rollback 6872 09:27:40 SQL Data In: ORACLE - Rows affected = 0 6873 09:27:40 SQL Stmt: ORACLE - Close 6874 09:27:40 SQL Stmt: ORACLE - Reset 6875 09:27:40 SQL Stmt: ORACLE - Close 6876 09:27:40 SQL Stmt: ORACLE - Close 6877 09:27:40 SQL Stmt: ORACLE - Reset 6878 09:27:40 SQL Stmt: ORACLE - Close 6879 09:27:40 SQL Stmt: ORACLE - Reset 6880 09:27:40 SQL Stmt: ORACLE - Close 6881 09:27:40 SQL Stmt: ORACLE - Close