1       15:33:00  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1150 and BMBH00=244
 and DLXTMC='供应室管理子系统' and CTMC00='frmWZ_WZCKQR'

2       15:33:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = ,27,36,
3       15:33:00  SQL Execute: ORACLE - SELECT  DISTINCT a.SHBMBH,a.SHBMMC,b.BMBH00
 FROM WZ_RCK000 a,VW_WZ_CJBM00 b
 WHERE a.SHBMBH=b.BMID00
 AND RCKLB0='2'
 AND ZTBZ00='1'
 and instr(?,','||RCKLX0||',')<=0
 ORDER BY b.BMBH00

4       15:33:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000
5       15:33:00  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 999999999.000000
6       15:33:00  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = ,27,36,
7       15:33:00  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170727
8       15:33:00  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170803
9       15:33:00  SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,BZ0000,RCKID0,KFBMBH,KSQLDH,SHBMBH,SHBMMC,RKYGBH
FROM VW_WZ_RCK000
WHERE (SHBMBH = ? or 999999999=?)
  AND RCKLB0 ='2'  
  AND ZTBZ00 ='2'
  AND QRBZ00 is null
 -- AND (RCKLX0 <> '27' and rcklx0<>'36')
  and instr(?,','||RCKLX0||',')<=0
  AND KDRQ00 >=?
  AND KDRQ00 <=?
 and SHBMBH<>11111
 ORDER BY RCKDH0 DESC

10      15:33:00  SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' )  and owner = 'SD_HOSPITAL' and object_name = 'VW_WZ_RCKMX0' order by 1 ASC, 2 ASC 
11      15:33:00  SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'VW_WZ_RCKMX0' order by owner ASC, index_name ASC
12      15:33:00  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1926866.000000
13      15:33:00  SQL Execute: ORACLE - SELECT "RCKMXH", "RCKID0", "KCID00", "FPH000", "FPRQ00", "QRRQ00", "FHBMMC", "WPXZ00", "WZDMID", "WZMC00", "WZSXMC", "WZLBMC", "WZEJFL", "WZSXBH", "WZID00", "CJMC00", "CJID00", "GJMC00", "GGXH00", "GG0000", "WZXH00", "PH0000", "SCRQ00", "YXQ000", "SXRQ00", "CRKSL0", "BZSL00", "WZDW00", "BZDW00", "CGJ000", "CGJBZ0", "CKPFJ0", "CKJBZ0", "WZJCL0", "LSJ000", "KL0000", "CRCJ00", "CXBZ00", "CXMXID", "ZJE000", "JCS000", "BZ0000", "ZBXH00", "ZBQNM0", "QRRQBS", "PZWH00", "FPDWQK", "LSJE00", "BZBHSL", "QGKSBH", "QGKSMC", "XZZD01", "XZZD02", "XZZD03", "XZZD04", "MJPH00", "TXM000", "MJRQ00", "ZBDW00", "ZBDJ00", "DHDMXH", "FPDM00", "FPZLMC", "SWDJH0", "GHDWMC", "CPZCZH", "KCZSL0", "YXRQ00", "WD0000", "DDRQ00", "PSRQ00", "FPHOLD", "SFSFXM" FROM "VW_WZ_RCKMX0" WHERE ("RCKID0") = (?) ORDER BY "RCKMXH"
14      15:33:04  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'F')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',244,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '244')
  AND (INSTR (',' || a.jsksbh || ',',',244,') > 0 or a.jsksbh is null)  

15      15:33:14  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'F')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',244,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '244')
  AND (INSTR (',' || a.jsksbh || ',',',244,') > 0 or a.jsksbh is null)  

16      15:33:24  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'F')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',244,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '244')
  AND (INSTR (',' || a.jsksbh || ',',',244,') > 0 or a.jsksbh is null)