379 17:13:22 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1913 and RowNum <= 10 order by DLRQSJ DESC 380 17:13:24 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='K' order by BMPLXH,BMBH00 381 17:13:26 SQL Execute: ORACLE - RollBack 382 17:13:26 SQL Data In: ORACLE - Rows affected = 0 383 17:13:26 SQL Execute: ORACLE - Commit 384 17:13:26 SQL Data In: ORACLE - Rows affected = 0 385 17:13:26 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000= 5526385 386 17:13:26 SQL Data In: ORACLE - Rows affected = 1 387 17:13:26 SQL Execute: ORACLE - Commit 388 17:13:26 SQL Data In: ORACLE - Rows affected = 0 389 17:13:26 SQL Execute: ORACLE - select * from VW_XT_XTKJMK where XTDM00='K' and KJLB00 ='3' 390 17:13:26 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS,MKDYCS from VW_XT_XTKJMK where XTDM00 = 'K' and KJLB00 < '3' order by XH0000 391 17:13:26 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'K'||',')>0 392 17:13:26 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1913 and XTDM00 = 'K' 393 17:13:26 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'K' 394 17:13:26 SQL Execute: ORACLE - select XTDM00,RQLMC0,KJNAME,KJLMC0,MKKJMC,KJJMC0,MKDLL0 from VW_XT_MKKJMC where XTDM00 = 'K' 395 17:13:26 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 580 and FLAG00 like '0' order by decode(CKBH00,152,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 396 17:13:26 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 397 17:13:26 SQL Execute: ORACLE - update XT_XTLJ00 set XTDM00='K' where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 398 17:13:26 SQL Data In: ORACLE - Rows affected = 1 399 17:13:26 SQL Execute: ORACLE - Commit 400 17:13:26 SQL Data In: ORACLE - Rows affected = 0 401 17:13:26 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 402 17:13:26 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 403 17:13:26 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(5526386,1913,'FJLNYY-PC','K',nvl('64159050',' '),'10.99.99.52#2838:36055@appYLZHis.exe',580,'10.99.99.52') 404 17:13:26 SQL Data In: ORACLE - Rows affected = 1 405 17:13:26 SQL Execute: ORACLE - Commit 406 17:13:26 SQL Data In: ORACLE - Rows affected = 0 407 17:13:26 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '10.99.99.52' and NAME00 = 'QDXTJZ' 408 17:13:26 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = 'K' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1913 and XTDM00 = 'K') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 409 17:13:26 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1913 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 410 17:13:26 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1913 and XTDM00='K' order by XH0000 411 17:13:26 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 412 17:13:26 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 580.000000 413 17:13:26 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68340516.000000 414 17:13:26 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 415 17:13:26 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 68340516.00) 416 17:13:27 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 417 17:13:27 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='K' 418 17:13:27 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 419 17:13:27 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 420 17:13:27 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=580 421 17:13:27 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=580 422 17:13:27 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 423 17:13:27 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 424 17:13:27 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 425 17:13:27 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(580) as SFBZDJ from dual 426 17:13:27 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_WZ_ZHYW.dll' and YGBH00 = 1913 and XTDM00 = 'K' 427 17:13:27 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1913 and NAME00 in ( 'YK_HZSRM','YK_DJYS','YK_FZSRM_FHJLS','YK_FZSRM_PPFX','YK_FZSRM_CXFS' ) 428 17:13:27 SQL Execute: ORACLE - select * from VW_YK_YPPCKC where YKBMBH = 580 and YPSXRQ>=to_char(sysdate,'YYYYMMDD') and YPSXRQ<=to_char(sysdate+30,'YYYYMMDD') and PCKC00 > 0 429 17:13:29 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'测试库','10.99.99.52','00-50-56-9D-B9-FF','K','ACT_WZ_SXWZCX','64159050') 430 17:13:29 SQL Data In: ORACLE - Rows affected = 1 431 17:13:29 SQL Execute: ORACLE - Commit 432 17:13:29 SQL Data In: ORACLE - Rows affected = 0 433 17:13:33 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 434 17:13:33 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='3' 435 17:13:33 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 436 17:13:33 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 437 17:13:33 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=580 438 17:13:33 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=580 439 17:13:33 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 440 17:13:33 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 441 17:13:33 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 442 17:13:33 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(580) as SFBZDJ from dual 443 17:13:33 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YK_ZHYW.dll' and YGBH00 = 1913 and XTDM00 = 'K' 444 17:13:33 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1913 and NAME00 in ( 'YK_HZSRM','YK_DJYS','YK_FZSRM_FHJLS','YK_FZSRM_PPFX','YK_FZSRM_CXFS' ) 445 17:13:33 SQL Execute: ORACLE - SELECT * FROM BM_YKCKLX 446 17:13:33 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'测试库','10.99.99.52','00-50-56-9D-B9-FF','K','ACT_YK_BLFP','64159050') 447 17:13:33 SQL Data In: ORACLE - Rows affected = 1 448 17:13:33 SQL Execute: ORACLE - Commit 449 17:13:33 SQL Data In: ORACLE - Rows affected = 0 450 17:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 580.000000 451 17:13:38 SQL Execute: ORACLE - SELECT 0 XZ0000,decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,A.*,' ' JXMC00,' ' ZLQK00,' ' YSJL00,0 C_LSJE,0 C_PFJE,0 C_JXCJ, A.JHRQ00||A.JHSJ00 as JHRQSJ,A.QRRQ00||A.QRSJ00 as QRRQSJ,to_date(A.SHRQ00||A.SHSJ00,'YYYY-MM-DDHH24:MI:SS')SHRQ01 ,(select ZYHGHH from VW_ss_yw0000 where SSDH00=A.SSDH00 and rownum=1) ZYHGHH ,(select XM0000 from VW_ss_yw0000 where SSDH00=A.SSDH00 and rownum=1) XM0000 ,(select SQKSMC from VW_ss_yw0000 where SSDH00=A.SSDH00 and rownum=1) SQKSMC FROM VW_YK_RKZBCX A WHERE A.YKBMBH=? AND A.QRRQ00>='20250701' AND A.QRRQ00<='20250808' ORDER BY A.QRRQ00||A.QRSJ00 desc 452 17:13:39 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 453 17:13:39 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 454 17:13:43 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 455 17:13:44 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 456 17:13:48 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 457 17:13:48 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 458 17:13:48 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 459 17:14:36 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20496' ORDER BY A.YPRKPC 460 17:14:40 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20489' ORDER BY A.YPRKPC 461 17:14:49 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20431' ORDER BY A.YPRKPC 462 17:14:50 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20431' ORDER BY A.YPRKPC 463 17:14:55 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 464 17:14:58 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 465 17:14:58 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 466 17:14:58 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 467 17:15:41 SQL Execute: ORACLE - update YK_YPRKMX set FPH000 = '876543210' ,FPRQ00 = '20250505' ,FPDM00 = '202508081245' where RKDH00 in ('R20496','R20431','R20432') 468 17:15:41 SQL Data In: ORACLE - Rows affected = 3 469 17:15:41 SQL Execute: ORACLE - Commit 470 17:15:41 SQL Data In: ORACLE - Rows affected = 0 471 17:15:41 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 472 17:15:47 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 473 17:15:57 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 474 17:15:57 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 475 17:16:01 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 476 17:16:01 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 477 17:16:01 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 478 17:16:24 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 479 17:16:25 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 480 17:16:25 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 481 17:16:51 SQL Execute: ORACLE - update YK_YPRKMX set FPH000 = '65432145678' ,FPRQ00 = '20250807' ,FPDM00 = '202508081716' where RKDH00 in ('R20574','R20496','R20431','R20432') 482 17:16:51 SQL Data In: ORACLE - Rows affected = 4 483 17:16:51 SQL Execute: ORACLE - Commit 484 17:16:51 SQL Data In: ORACLE - Rows affected = 0 485 17:16:51 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 486 17:16:58 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC 487 17:16:59 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20431' ORDER BY A.YPRKPC 488 17:17:01 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20574' ORDER BY A.YPRKPC 489 17:17:02 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20431' ORDER BY A.YPRKPC 490 17:17:03 SQL Execute: ORACLE - SELECT decode(A.RKZT00,'0','未确认','1','已审核','2','已转正','3','已确认') RKZTMC,0 XGBZ00,A.*,round(A.LSDJ00*A.RKSL00,2) C_LSJE,round(A.PFDJ00*A.RKSL00,2) C_PFJE,round(A.LSDJ00*A.RKSL00,2)-A.GJJE00 as C_JXCJ ,( select ZCZXX0 from BM_WZQTXX where YPNM00=A.ypnm00 AND ROWNUM=1) ZCZXX0 FROM VW_YK_YPRKCX A WHERE a.RKDH00='R20432' ORDER BY A.YPRKPC