1 15:04:54 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 2 15:04:56 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 WHERE CKBH00=45 3 15:04:56 SQL Execute: ORACLE - Select SYSDATE from Dual 4 15:04:56 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 15:04:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 6 15:04:56 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') 7 15:04:57 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0220045600107607' and ICKNBH = '0220045600107607' 8 15:04:57 SQL Execute: ORACLE - select * from vw_ys_brxxb0 where BRID00=286469 9 15:04:57 SQL Execute: ORACLE - select GHYXM0 from vw_ys_hzbr00 where brid00=286469 and dlxh00>0 union all select GHYXM0 from vw_ys_yzbr00 where brid00=286469 and dlxh00>0 10 15:04:57 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHKSBH=18 and GHYSBH=34 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') AND GHJSSJ>=to_char(sysdate-2/48,'HH24:mi:ss') 11 15:04:57 SQL Execute: ORACLE - select TZBZ00 from SF_YSGHHB where GHKSBH=18 and GHYSBH=34 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') AND GHJSSJ>=to_char(sysdate-2/48,'HH24:mi:ss') 12 15:04:57 SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=18 and GHYSBH=34 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 13 15:04:57 SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_YS_GHLBB0 where LBBH00=-99999 14 15:04:57 SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00 where HZLB00<>3 15 15:04:57 SQL Execute: ORACLE - select b.SFJE00 from sf_ghf000 a,bm_yysfxm b where a.SFXMID=b.SFXMID and a.GFLB00='-99999' union all select FJFFJE from vw_ys_fjghf0 where FJBRLB='0' and FJGHKS='27' and FJGHLB='-99999' 16 15:04:57 SQL Execute: ORACLE - SELECT NVL(MAX(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=57971 AND BRID00 IS NOT NULL AND YYBZ00='1' 17 15:04:57 SQL Execute: ORACLE - SELECT NVL(MAX(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=57971 AND YYBZ00='1' 18 15:04:57 SQL Execute: ORACLE - SELECT NVL(Min(HZXH00),0) HZXH00 FROM YS_HBHZXH WHERE GHHBID=57971 AND YYBZ00='1' and HZXH00 between 8 and 100 19 15:04:57 SQL Execute: ORACLE - SELECT BRID00,BRXM00,HZXH00,YYBZ00 FROM YS_HBHZXH WHERE GHHBID=57971 ORDER BY HZXH00 20 15:04:59 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 21 15:05:04 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 22 15:05:09 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 23 15:05:09 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDDHH24:MI:SS') OraSysDate FROM DUAL 24 15:05:09 SQL Execute: ORACLE - select GHHBID from vw_sf_ysghhb where GHYSBH=34 AND GHMZSJ >= to_char(sysdate-1, 'YYYYMMDD' ) and TZBZ00 = '0' and ((((GHXHS0-YYXHS0)>(GHYGHS-GHYYHS)) and (SFZJGH='0')) OR (SFZJGH='1')) and ( (GHJSSJ >= GHQSSJ and GHJSSJ >= to_char(sysdate,'HH24:MI:SS') and GHMZSJ = to_char(sysdate,'YYYYMMDD') ) or (GHJSSJ < GHQSSJ and ((GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHQSSJ <= to_char(sysdate,'HH24:MI:SS' ) ) or (GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) and GHJSSJ >= to_char(sysdate,'HH24:MI:SS' ) ) ) ) ) 25 15:05:09 SQL Data In: ORACLE - Param = 1, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = FJ059110030000054087 26 15:05:09 SQL Data In: ORACLE - Param = 2, Name = AS_YBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 27 15:05:09 SQL Data In: ORACLE - Param = 3, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 预挂号 28 15:05:09 SQL Data In: ORACLE - Param = 4, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 286469.000000 29 15:05:09 SQL Data In: ORACLE - Param = 5, Name = AS_SFCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 15:05:09 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 测试病人（不发药） 31 15:05:09 SQL Data In: ORACLE - Param = 7, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 32 15:05:09 SQL Data In: ORACLE - Param = 8, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620501 33 15:05:09 SQL Data In: ORACLE - Param = 9, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 34 15:05:09 SQL Data In: ORACLE - Param = 10, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 35 15:05:09 SQL Data In: ORACLE - Param = 11, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 36 15:05:09 SQL Data In: ORACLE - Param = 12, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 37 15:05:09 SQL Data In: ORACLE - Param = 13, Name = AD_GHY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 38 15:05:09 SQL Data In: ORACLE - Param = 14, Name = AS_GHYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林丽莉 39 15:05:09 SQL Data In: ORACLE - Param = 15, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 40 15:05:09 SQL Data In: ORACLE - Param = 16, Name = AD_GHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 41 15:05:09 SQL Data In: ORACLE - Param = 17, Name = AD_JZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 42 15:05:09 SQL Data In: ORACLE - Param = 18, Name = AS_JZYSXM, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林丽莉 43 15:05:09 SQL Data In: ORACLE - Param = 19, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57971.000000 44 15:05:09 SQL Data In: ORACLE - Param = 20, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 45 15:05:09 SQL Data In: ORACLE - Param = 21, Name = AS_FPXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 15:05:09 SQL Data In: ORACLE - Param = 22, Name = AD_GHF000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 15:05:09 SQL Data In: ORACLE - Param = 23, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 48 15:05:09 SQL Data In: ORACLE - Param = 24, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 49 15:05:09 SQL Data In: ORACLE - Param = 25, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 15:05:09 SQL Data In: ORACLE - Param = 26, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 51 15:05:09 SQL Data In: ORACLE - Param = 27, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 52 15:05:09 SQL Data In: ORACLE - Param = 28, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 53 15:05:09 SQL Data In: ORACLE - Param = 29, Name = AS_GHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150529 54 15:05:09 SQL Data In: ORACLE - Param = 30, Name = AS_SFYYGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 55 15:05:09 SQL Data In: ORACLE - Param = 31, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 15:05:09 SQL Data In: ORACLE - Param = 32, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 57 15:05:09 SQL Data In: ORACLE - Param = 33, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 15:05:09 SQL Data In: ORACLE - Param = 34, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 15:05:09 SQL Data In: ORACLE - Param = 35, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 60 15:05:09 SQL Data In: ORACLE - Param = 36, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 61 15:05:09 SQL Data In: ORACLE - Param = 37, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 62 15:05:09 SQL Data In: ORACLE - Param = 38, Name = AS_SFNLYD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 63 15:05:09 SQL Data In: ORACLE - Param = 39, Name = AS_HZLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 64 15:05:09 SQL Data In: ORACLE - Param = 40, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 15:05:09 SQL Data In: ORACLE - Param = 41, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 15:05:09 SQL Data In: ORACLE - Param = 42, Name = AD_FJJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 67 15:05:09 SQL Data In: ORACLE - Param = 43, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 15:05:09 SQL Data In: ORACLE - Param = 44, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 15:05:09 SQL Data In: ORACLE - Param = 45, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 70 15:05:09 SQL Data In: ORACLE - Param = 46, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 71 15:05:09 SQL Data In: ORACLE - Param = 47, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 15:05:09 SQL Data In: ORACLE - Param = 48, Name = AS_GHH000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 73 15:05:09 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 74 15:05:09 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 75 15:05:09 SQL Data In: ORACLE - Param = 51, Name = AS_JZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 76 15:05:09 SQL Data In: ORACLE - Param = 52, Name = as_SFHSGH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 77 15:05:09 SQL Data In: ORACLE - Param = 53, Name = as_HZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 78 15:05:09 SQL Execute: ORACLE - BEGIN "SP_SF_BRGHXX" (AS_BRBLH0 => :AS_BRBLH0,AS_YBGHH0 => :AS_YBGHH0,AS_GHLBMC => :AS_GHLBMC,AD_BRID00 => :AD_BRID00,AS_SFCZ00 => :AS_SFCZ00,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDH00 => :AS_BRDH00,AS_BRHYZK => :AS_BRHYZK,AD_GHY000 => :AD_GHY000,AS_GHYXM0 => :AS_GHYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_GHKS00 => :AD_GHKS00,AD_JZYS00 => :AD_JZYS00,AS_JZYSXM => :AS_JZYSXM,AD_GHHBID => :AD_GHHBID,AS_YJJXH0 => :AS_YJJXH0,AS_FPXH00 => :AS_FPXH00,AD_GHF000 => :AD_GHF000,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBID00 => :AS_YBID00,AS_YBKH00 => :AS_YBKH00,AS_GHRQ00 => :AS_GHRQ00,AS_SFYYGH => :AS_SFYYGH,AS_CZBZ00 => :AS_CZBZ00,AS_SFSBLF => :AS_SFSBLF,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_TYDWMC => :AS_TYDWMC,AS_SFNLYD => :AS_SFNLYD,AS_HZLB00 => :AS_HZLB00,AS_ICKH00 => :AS_ICKH00,AS_BRJTDZ => :AS_BRJTDZ,AD_FJJZDH => :AD_FJJZDH,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AS_GHH000 => :AS_GHH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JZSJ00 => :AS_JZSJ00,as_SFHSGH => :as_SFHSGH,as_HZXH00 => :as_HZXH00); END; 79 15:05:10 SQL Execute: ORACLE - Update sf_brxxb0 set THBZ00='2' where GHH000='1557656' 80 15:05:10 SQL Data In: ORACLE - Rows affected = 1 81 15:05:10 SQL Execute: ORACLE - select count(*) COUNT0 from SF_HZBR00 where YSPBID=57971 and GHLB00=-99999 and HZXH00=12 82 15:05:10 SQL Execute: ORACLE - commit 83 15:05:10 SQL Data In: ORACLE - Rows affected = 0 84 15:05:10 SQL Execute: ORACLE - Select to_number(trim(value0)) Value0 from XT_YHCS00 where YGBH00=34 and NAME00 ='YS_MBRJZSJ' 85 15:05:10 SQL Execute: ORACLE - Select to_number(trim(value0)) Value0 from XT_YHCS00 where YGBH00=34 and NAME00 ='YS_JZTKSJ' 86 15:05:10 SQL Execute: ORACLE - select a.*,TO_CHAR(SYSDATE,'YYYY')||'年'||TO_CHAR(SYSDATE,'MM')||'月'||TO_CHAR(SYSDATE,'DD')||'日' DYRQ00 from vw_ys_hzbr00 a where a.GHH000='1557656' and a.JZKS00=18 and a.JZYS00=34 87 15:05:10 SQL Execute: ORACLE - select ckmc00 from bm_ckbm00 where ckbh00=45 88 15:05:10 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM vw_ys_hzbr00 where jzks00=18 and jzys00=34 and dlxh00>0 AND HZXH00<12 AND HZZT00='0' 89 15:05:14 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 90 15:05:19 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 91 15:05:26 SQL Execute: ORACLE - SELECT ' ' zd0000 FROM YS_CFXXB0 WHERE rownum=1 92 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 93 15:05:27 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and dlxh00>0 order by jzys00,dlxh00 94 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 95 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 96 15:05:27 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and dlxh00>0 order by dlxh00 97 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 98 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 99 15:05:27 SQL Execute: ORACLE - select * from vw_ys_yzbr00 where jzks00=? and jzys00=? order by dlxh00 desc 100 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 101 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 102 15:05:27 SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a, (select count(*) total,hzlb00 ,jzys00 from VW_YS_HZBR00 where hzlb00>0 and jzks00=? group by hzlb00,jzys00 ) b where a.hzlb00=b.hzlb00 and jzys00=? 103 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 104 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 105 15:05:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 106 15:05:27 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where hzlb00=? and (jzys00=? or jzys00=0) and jzks00=? and nvl(dlxh00,0)=0 107 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 108 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 109 15:05:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 110 15:05:27 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where hzlb00=? and (jzys00=? or jzys00=0) and jzks00=? and nvl(dlxh00,0)=0 111 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 112 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 113 15:05:27 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and HZZT00='2' and dlxh00>0 114 15:05:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 115 15:05:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 116 15:05:27 SQL Execute: ORACLE - select a.YYH000,a.YYJSSJ,decode(a.YYZT00,'0','登记','确认') YYZT00,a.BRXM00,a.BRXB00,a.YYID00 from vw_yy_bryyxxcx a where a.YYRQ00=to_char(sysdate,'YYYYMMDD') and a.YYZT00 in ('0','1') and a.YYKSBH=? and a.YYYSBH=? order by a.YYJSSJ 117 15:05:27 SQL Execute: ORACLE - select GHLBBH,GHKSBH from SF_YSGHHB where GHHBID=57971 118 15:05:27 SQL Execute: ORACLE - select ZYE000 from vw_ys_brxxb0 where BRID00=286469 119 15:05:27 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 286469.000000 120 15:05:27 SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 48 121 15:05:27 SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 122 15:05:27 SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 123 15:05:27 SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 124 15:05:27 SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 125 15:05:27 SQL Data In: ORACLE - Param = 7, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 126 15:05:27 SQL Data In: ORACLE - Param = 8, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 127 15:05:27 SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE); END; 128 15:05:29 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 129 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 130 15:05:32 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and dlxh00>0 order by jzys00,dlxh00 131 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 132 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 133 15:05:32 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and dlxh00>0 order by dlxh00 134 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 135 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 136 15:05:32 SQL Execute: ORACLE - select * from vw_ys_yzbr00 where jzks00=? and jzys00=? order by dlxh00 desc 137 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 138 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 139 15:05:32 SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a, (select count(*) total,hzlb00 ,jzys00 from VW_YS_HZBR00 where hzlb00>0 and jzks00=? group by hzlb00,jzys00 ) b where a.hzlb00=b.hzlb00 and jzys00=? 140 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 141 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 142 15:05:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 143 15:05:32 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where hzlb00=? and (jzys00=? or jzys00=0) and jzks00=? and nvl(dlxh00,0)=0 144 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 145 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 146 15:05:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 147 15:05:32 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where hzlb00=? and (jzys00=? or jzys00=0) and jzks00=? and nvl(dlxh00,0)=0 148 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 149 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 150 15:05:32 SQL Execute: ORACLE - select * from vw_ys_hzbr00 where jzks00=? and jzys00=? and HZZT00='2' and dlxh00>0 151 15:05:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 152 15:05:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000 153 15:05:32 SQL Execute: ORACLE - select a.YYH000,a.YYJSSJ,decode(a.YYZT00,'0','登记','确认') YYZT00,a.BRXM00,a.BRXB00,a.YYID00 from vw_yy_bryyxxcx a where a.YYRQ00=to_char(sysdate,'YYYYMMDD') and a.YYZT00 in ('0','1') and a.YYKSBH=? and a.YYYSBH=? order by a.YYJSSJ 154 15:05:34 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0' 155 15:05:39 SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE HSFZT0=53 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='0'