XinYu_LG2MES/ServerSolution/WebRoot/WEB-INF/query/.svn/text-base/QueryLgGlobalMap.xml.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="炼钢生产总貌图">
<query id="GetTrackObjData.Select" desc="查询作业跟踪表信息" fetchSize="10">
        <![CDATA[
		        select OBJECTPOS,
				       nvl(OBJECTID, '') OBJECTID,
				       nvl(DISPOSALTIME, '') DISPOSALTIME,
				       nvl(POTNO, '') POTNO,
				       COMINGTIME,
				       nvl(FRONTPOS, '') FRONTPOS,
				       DEVICESTATES,
				       SENDTYPE
				  from TPM_TRACKOBJECTINFOR
	 ]]>
    </query>
    
    <query id="GetScheduleInfo.Select" desc="查询作业计划信息" fetchSize="10">
        <![CDATA[
		        select a.HEATNO,
				       a.aim_grade_code,
				       (select steel from scm_steel where steelcode = a.aim_grade_code) STEEL,
				       '' catalogid,
				       '' std_code,
				       a.PLAN_LINES,
				       a.FACT_ROUTE,
				       a.CAST_ID,
				       a.heat_state,
				       a.PLAN_MAKING_TIME,
				       a.PLAN_MAKER,
				       STD_CODE,
				       a.V_HEAT_ID,
				       a.ORD_GON_ID,
				       a.cast_no,
				       a.cast_seq,
				       a.HEAT_NUM,
				       a.len,
				       a.width,
				       a.thick,
				       /*(a.width || '×' || a.thick )*/e.MATERIELDEPICT MATERIELDEPICT,
				       b.potno SENDTOOLID,
				       b.POTDISTINCTION SENDGRADE,
				       b.POTWRAPSTATE INSTANCE,
				       b.POTAGE,
				       case when b.isaddtop = 'C' then '已加盖' else '' end isaddtop,
				       a.STD_NAME SPECIFICATION,
                       b.steelpass,
                       b.baleleavewgtpass,
                       c.mouldbalewgt-b.baleleavewgtpass gspz,
                       case when c.fronttime is not null then round((c.balestarttime - c.fronttime) * 24 * 60) || '分钟' else '' end SedationTime,
                       case when b.tappingendtime is not null then round((sysdate - b.tappingendtime) * 24 * 60)||'分钟' else '' end tappingendtime,
				       (select SLABWIDTH || '×' || SLABHEIGHT
				          from PPC_STEEL_CUTINGDETAIL
				         where FURNACENO = a.v_heat_id
				           and rownum < 2) Aim_W_T,
				       'A:'||d.A||',B:'||d.B||',C:'||d.C||',D:'||d.D INCLUSION /*20210802 新增夹杂物标准*/
				  from PPC_STEEL_HEAT a, STL_bof_optinfo b,stl_ccm_optinfo c,SCM_INCLUSION_INFO d,
				  (select FURNACENO,LISTAGG(MATERIELDEPICT, ' ') WITHIN GROUP(ORDER BY MATERIELDEPICT) MATERIELDEPICT
  					 from (SELECT slabwidth || '×' || slabheight MATERIELDEPICT, FURNACENO FROM ppc_steel_cutingdetail
         				group by FURNACENO, slabwidth || '×' || slabheight) t GROUP BY FURNACENO) e/*20220919 新增计划改变后的断面查询*/
				 WHERE a.heatno = b.heatno(+)
                   and a.heatno = c.heatno(+)
                   and a.V_HEAT_ID = d.STL_GRD(+)
                   and a.V_HEAT_ID = e.FURNACENO(+)
				   and a.heat_state > '02'
				   and a.heat_state < '10' and a.heatno is not null
	 ]]>
    </query>
    
    <query id="GetBofData.Select" desc="查询转炉作业数据" fetchSize="10">
        <![CDATA[
		        select heatprocessno,heatno,stationcode,disposaltime,
				       plansteel,woid,optdate,shiftcode,
				       molirnsource,ironpotid,ironpotwgt,irontemperature,
				       pigironwgt,wsteelwgt,joinmarlwgt,rsteelwgt,
				       changestarttime,changeendtime,changetime,openoxygentime,
				       stopoxygentime,
				       round((decode(B1STARTTIME,null,0,decode(B1ENDTIME,null,
				       (sysdate - B1STARTTIME) * 1440*60,B1TIME))) +
				       (decode(B2STARTTIME,null,0,decode(B2ENDTIME,null,
				       (sysdate - B2STARTTIME) * 1440*60,B2TIME))) +
				       (decode(B3STARTTIME,null,0,decode(B3ENDTIME,null,
				       (sysdate - B3STARTTIME) * 1440*60,B3TIME))) +
				       (decode(B4STARTTIME,null,0,decode(B4ENDTIME,null,
				       (sysdate - B4STARTTIME) * 1440*60,B4TIME))) +
				       (decode(B5STARTTIME,null,0,decode(B5ENDTIME,null,
				       (sysdate - B5STARTTIME) * 1440*60,B5TIME)))) SUPPLYOXYGENTIME,
				       o2press,o2flux,o2consume,molstltemperature,b1starttime,
				       b1endtime,b1time,b1temperature,b2starttime,
				       b2endtime,b2time,b2temperature,b3starttime,
				       b3endtime,b3time,b3temperature,b4starttime,
				       b4endtime,b4time,b4temperature,b5starttime,
				       b5endtime,b5time,b5temperature,terminustept,
				       terminusc,terminuso2,blowo2times,blowartimes,
				       blown2times,tappingstarttime,tappingendtime,tappingtime,
				       psstarttime,psendtime,brpstime,brpstimes,
				       n2press,n2flux,n2consume,topn2consume,
				       arpress,arflux,arconsume,brwgt,
				       drwgt,blkredmode,blkredeffects,oggnumid,
				       gage,subnumid,subage,subheight,
				       subtension,sage,emolstltime,potno,
				       potage,potdistinction,potwrapstate,tappingwgt,
				       rsstoveno,rswgt,ccmflag,vflag,
				       molstlwgt,ironwgt,foldflag,dfrflag,
				       prflag,addflag,eleconsume,ironcomponentid,
				       firstcomponentid,endcomponentid,numid,opttype,
				       molstlleave,molirntype,ccmplantempt,ccmplantempttime,
				       gasrecoverytime,wsid,optpersonnel,updatetime,memo,POTTEMP
				  from stl_bof_optinfo 
				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>
    
     <query id="GetCasData.Select" desc="查询吹氩作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HEATNO,STATIONCODE,DISPOSALTIME,
				       PLANSTEEL,WOID,OPTDATE,SHIFTCODE,
				       ARRIVETIME,LEAVETIME,STAYTIME,
				       BLOWARSTARTTIME,BLOWARENDTIME,BLOWARTIME,
				       CASSTARTTIME,CASENDTIME,CASTIME,CASUSETIME,
				       FEEDSILKBEGINTIME,FEEDSILKCLOSETIME,FEEDSILKTIME,FEEDINGSPEED,
				       ARRIVEWGT,LEAVEWGT,ARCONSUME,ARFLUX,
				       BLOWARPRESS,BLOWARMODE,USEDPRESS,ARFTEMPT,
				       ARITEMPT,ARBTEMPT,ARRIVEO2,LEAVEO2,
				       HPCONSUME,RESIDUETHICKNESS,TWSTEELWGT,MANTLEFLAG,
				       MANTLENUM,POTNO,POTDISTINCTION,POTAGE,
				       POTWRAPSTATE,GUNNO,BLOWARTIMES,ODERO2TIMES,
				       MOLSTLLEAVE, ARRIVECPTCODE,LEAVECPTCODE,PRODUCTCPTCODE,
				       DESLAGGFLAG,MOLSTLTAREWGT,MOLSTLWGT,WSID,LMLTEMPT,
				       OPTPERSONNEL,MEMO,UPDATETIME
				  FROM STL_CAS_OPTINFO
				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>
    
    <query id="GetLfsData.Select" desc="查询LF炉作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HEATNO,STATIONCODE,DISPOSALTIME,
				       PLANSTEEL,WOID,OPTDATE,SHIFTCODE,
				       ARRIVETIME,LEAVETIME,REFINETIME,
				       SEATDSTARTTIME,SEATDENDTIME,SEATDTIME,
				       BEGINBLOWAR,ENDBLOWAR,BLOWARTIME,
				       SELESTARTTIME,SELEENDTIME,SELETIME,
				       REPOSEBEGINTIME,REPOSECLOSETIME,REPOSETIME,
				       COVERUPPERTIME,COVERDOWNTIME,FEEDSILKBEGINTIME,
				       FEEDSILKCLOSETIME,ARCONSUME,BLOWARPRESS,ARFLUX,
				       BLOWARMODE,BLOWARTIMES,ARRIVETEMPT,LEAVETEMPT,
				       ELETRICITYCONSUME,ELETRICITYTIMES,FEEDINGSPEED,
				       ARRIVEWGT,LEAVEWGT,MOLSTLWGT,ARRIVEO2,
				       LEAVEO2,ODERO2TIMES,MRTCONSUME,NMRTCONSUME,
				       BESTROWDOSAGE,TEMPTNUM,RESIDUETHICKNESS,SLAGWGT,
				       POTNO,POTDISTINCTION,POTAGE,
				       POTWRAPSTATE,AGE,LFSNO,COVERAGE,
				       MOLSTLLEAVE,CCMTEMPT,FLEXIBLEBLOWTIME,SOFTBLOWBEGINTIME,
				       LADLECOVERAGE,ISRS,WSID,OPTPERSONNEL,
				       UPDATETIME,MEMO,DILUTEDRESIDUEDOSE,WAITTIME
				  FROM STL_LFS_OPTINFO
				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>    
    
    <query id="GetRhsData.Select" desc="查询RH炉作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HEATNO,STATIONCODE,DISPOSALTIME,
				       PLANSTEEL,WOID,SHIFTCODE,OPTDATE,
				       ARRIVETIME,LEAVETIME,REFINETIME,REPOSEBEGINTIME,
				       REPOSECLOSETIME,LD_RISE_STA_DTIME,LD_DOWN_DTIME,
				       SUM_TIME,VACBEGINTIME,VACLOSETIME,VAC_TIME,
				       O2BEGINTIME,O2CLOSETIME,O2_TIME,ARBEGINTIME,
				       ARCLOSETIME,AR_TIME,FEEDBEGINTIME,FEEDCLOSETIME,
				       FEED_TIME,FEEDINGSPEED,ARFTEMPT,
				       ARBTEMPT,ARRIVEWGT,LEAVEWGT,MOLSTLWGT,
				       ARRIVEO2,LEAVEO2,HPCONSUME,RESIDUETHICKNESS,
				       TWSTEELWGT,MANTLEFLAG,MANTLENUM,ARFLUX,
				       O2USEDTOTALAL,O2USEDTOTALC,N2_CONS_C,AR_CONS_S,
				       ARCONSUME,O2CONSUME,STEAMFLUX,STEAMPRESS,
				       STEAMTEMPT,STEAMCONSUME,WATER_CONS_LNQ,WATER_CONS_JX,
				       N2_CONS_S,LANCE_NO,LANCE_TIMES,VAC_KEEP_TIME,
				       PURE_TIME,BEF_VAC_TIME,VAC_MIN,RHSNO,VES_NO,
				       RHSNO2,VES_NO2,POTNO,POTDISTINCTION,
				       POTAGE,POTWRAPSTATE,VACGROOVEID,MOLSTLLEAVE,
				       ISRS,OPTPERSONNEL,WSID,UPDATETIME,MEMO,WAITTIME
				  FROM STL_RHS_OPTINFO
				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>
    
    <query id="GetVdsData.Select" desc="查询VD炉作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HEATNO,STATIONCODE,DISPOSALTIME,
				       PLANSTEEL,WOID,SHIFTCODE,OPTDATE,
				       ARRIVETIME,LEAVETIME,REFINETIME,REPOSEBEGINTIME,
				       REPOSECLOSETIME,TREATTIME,OXYGENSTARTTIME,
				       OXYGENENDTIME,OXYGENTIME,HYDGENSTARTTIME,
				       HYDGENENDTIME,HYDGENTIME,MIXSTARTTIME,MIXENDTIME,
				       MIXTIME,VACBEGINTIME,VACLOSETIME,VAC_TIME,
				       FEEDBEGINTIME,FEEDCLOSETIME,FEED_TIME,FEEDINGSPEED,
				       SUM_TIME,ARFTEMPT,ARBTEMPT,ARRIVEWGT,
				       LEAVEWGT,HPCONSUME,MANTLEFLAG,MANTLENUM,
				       VDAGE,VDNO,VACUUMPRESS,STOP_DATE,
				       SLAG_WGT,VAC_MIN,O2CONSUME,STEAMCONSUME,
				       STEAM_TEM,STEAM_PRES,POTNO,POTDISTINCTION,
				       POTAGE,POTWRAPSTATE,COVER,MOLSTLWGT,
				       ISRS,OPTPERSONNEL,WSID,ARRIVEO2,
				       LEAVEO2,UPDATETIME,MEMO,ARRIVEH,
				       LEAVEH,RESIDUETHICKNESS,ARBEGINTIME,ARCLOSETIME,
				       AR_TIME,ARFLUX
				  FROM STL_VDS_OPTINFO

				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>
    
    <query id="GetCcmData.Select" desc="查询连铸机作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HEATNO,STATIONCODE,DISPOSALTIME,
				       PLANSTEEL,CCMSTOVENO,WOID,BILLETSECTION,
				       BILLETFIXSIZE,OPTDATE,SHIFTCODE,POTNO,
				       POTDISTINCTION,POTAGE,POTWRAPSTATE,MOULDSTOVENUM,
				       PFBALETEMPT,PFBALEWGT,BALEPFTIME,MOULDINGPOTNO,
				       MOULDINGPOTRANK,MOULDBALEWGT,MOULDBALETEMPT,
				       BALESTARTTIME,BALEENDTIME,BALELEAVETIME,BALELEAVEWGT,
				       PLANPFTIME,WAITMOULDTIME,MOULDTIME,BALEFLOWFLAG,
				       BALEMOULDFLAG,BALEMOULDTIME,BALEFLOWTIEMS,
				       MWRAPNO,MWRAPTEMPT,MWRAPWGT,MWRAPSTARTTIME,
				       MWRAPENDTIME,HEAT_SEQ,BIGPOTARM1WEIGHT,BIGPOTARM2WEIGHT,
				       MOULDNUMID,MOULDNO,METERODDWGT,LMLTEMPT,
				       SWRAPREMAINWGT,SWRAPENDCAUSE,MOULDWAITTIME,MWRAPTEMPT05,
				       MWRAPTEMPT20,MWRAPLIQUID,MWRAPLIQUID15,SMWRAPLIQUID,
				       SMWRAPWGT,BILLETLENGTH,BILLETWGT,BILLETNUM,
				       S1BILLETLENGTH,S2BILLETLENGTH,RESIDUETHICKNESS,
				       PRODUCTCPTCODE,BAKEO2TIEMS,FLAG,FBTOTALWGT,
				       HOTPITCH, PROTECTDTEG,PROTECTDTEGDOSAGE,
				       RSMOLSTLWGT,ISRS,WSID,OPTPERSONNEL,UPDATETIME,MEMO,
				       HLSTANDARD1,HLSTANDARD2
				  FROM STL_CCM_OPTINFO
				 WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME=?
	 ]]>
    </query>
    
    <query id="GetHmpData.Select" desc="查询脱硫作业数据" fetchSize="10">
        <![CDATA[
		        SELECT HEATPROCESSNO,HUDWID,EQUIPMENTNO,WSID,
				       HEATNO,PLANSTEEL,ARRIVETIME,LEAVETIME,
				       INSTATIONTIME,SWTIME,WHISKBEGINTIME,WHISKCLOSETIME,
				       SB_FIRST_STARTIME,SB_FIRST_ENDTIME,SB_FIRST_TIME,
				       FIRSTQUANTITY,SB_SECOND_STARTIME,SB_SECOND_ENDTIME,
				       SB_SECOND_TIME,SECONDQUANTITY,SB_THIRD_STARTIME,
				       SB_THIRD_ENDTIME,SB_THIRD_TIME,THIRDQUANTITY,
				       CHURNUPDATE,SETCHURNUPDATE,DR_BEF_STARTTIME,
				       DR_BEF_ENDTIME,DR_BEF_TIME,DR_BEF_WGT,DR_AFT_STARTTIME,
				       DR_AFT_ENDTIME,DR_AFT_TIME,DR_AFT_WGT,DREFFECT,
				       DFRSTARTTIME,DFRENDTIME,DFRTIME,SWFELEMENTCODE,
				       SWFTEMPERATURE,SWBELEMENTCODE,SWBTEMPERATURE,
				       SWBSPERCENT,IRONPOTGROSSWGT,IRONPOTTAREWGT,IRONWGT,
				       ARRIVEWGTTIME,LEAVEWGTTIME,ARRIVEWGT,LEAVEWGT,
				       IRONPOTBOFWGT,PRETEMPERATURE,BLOWSPEED,MOSTROTATESPEED,
				       IRONPWRAPNO,POTAGE,MIX_REALITY_HEIGHT,MR_USER_TIMES,
				       IRONSOURCE,MOLIRNLEAVE,RSSTOVENO,RSWGT,
				       SBPRESS,SBPLUX,SBCONSUME,CAOCONSUME,
				       SCONTENT,N2PLUX,N2CONSUME,N2PRESS,
				       SGGNUMID,SGGAGE,SGGNUMNO,SIRONWGT,VFLAG,
				       EXECUTESTATE,DFRSTATE,DFRWGT,RESERVSECANPRESSURE,
				       VALVEOPENWIDTH,DRQUANTITY,NUMID,FORMER_S_VALUE,
				       DREGSSOLVENT,SITH_S_VALUE,SHIFTCODE,OPTPERSONNEL,
				       OPTDATE,UPDATETIME,MEMO
				  FROM STL_HMP_OPTINFO
				 WHERE HEATPROCESSNO = ?
	 ]]>
    </query>
    
    <query id="GetSumData.DayBofNum" desc="查询本日炼制炉数" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where nvl(TAPPINGSTARTTIME,OPTDATE) between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where nvl(TAPPINGSTARTTIME,OPTDATE) between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b
	 ]]>
    </query>
    
    <query id="GetSumData.DayBofNum_New1" desc="查询本日炼制炉数(跨天班次当天生产炉数)" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b
	 ]]>
    </query>
    
    <query id="GetSumData.DayBofNum_New2" desc="查询本日炼制炉数(跨天班次跨天生产总炉数)" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b
	 ]]>
    </query>
    
    <query id="GetSumData.ShiftBofNum" desc="查询本班炼制炉数" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) b
	 ]]>
    </query>
    
    <query id="GetSumData.ShiftBofNum_New1" desc="查询本班炼制炉数" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) b
	 ]]>
    </query>
    
    <query id="GetSumData.ShiftBofNum_New2" desc="查询本班炼制炉数" fetchSize="10">
        <![CDATA[
		    SELECT a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) a,
			       (select count(1) sum2
			          from j#STL_BOF_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')
			           and SHIFTCODE =
			               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAL)) b
	 ]]>
    </query>
    
    
     <query id="GetSumData.DayCcmNum" desc="获取本日连铸炉数   " fetchSize="10">
        <![CDATA[
		     select a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_CCM_OPTINFO
			         where nvl(BALESTARTTIME,OPTDATE) between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_CCM_OPTINFO
			         where nvl(BALESTARTTIME,OPTDATE) between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b

	 ]]>
    </query>
    
    <query id="GetSumData.DayCcmNum_New1" desc="获取本日连铸炉数   " fetchSize="10">
        <![CDATA[
		     select a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_CCM_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_CCM_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 20:00:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b

	 ]]>
    </query>
    
    <query id="GetSumData.DayCcmNum_New2" desc="获取本日连铸炉数   " fetchSize="10">
        <![CDATA[
		     select a.sum1 + b.sum2
			  from (select count(1) sum1
			          from STL_CCM_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 19:50:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:49:59',
			                       'yyyy-MM-dd HH24:mi:ss')) a,
			       (select count(1) sum2
			          from j#STL_CCM_OPTINFO
			         where OPTDATE between
			               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 19:50:00',
			                       'yyyy-MM-dd HH24:mi:ss') and
			               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:49:59',
			                       'yyyy-MM-dd HH24:mi:ss')) b

	 ]]>
    </query>
    
     <query id="GetSumData.ShiftCcmNum" desc="获取本班连铸炉数   " fetchSize="10">
        <![CDATA[
		    select a.sum1 + b.sum2
	  from (select count(1) sum1
	          from STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) a,
	       (select count(1) sum2
	          from j#STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 00:00:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) b
	 ]]>
    </query>
    
    <query id="GetSumData.ShiftCcmNum_New1" desc="获取本班连铸炉数   " fetchSize="10">
        <![CDATA[
		    select a.sum1 + b.sum2
	  from (select count(1) sum1
	          from STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:50:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) a,
	       (select count(1) sum2
	          from j#STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:50:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 23:59:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) b
	 ]]>
    </query>
    
    <query id="GetSumData.ShiftCcmNum_New2" desc="获取本班连铸炉数   " fetchSize="10">
        <![CDATA[
		    select a.sum1 + b.sum2
	  from (select count(1) sum1
	          from STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 19:50:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:49:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) a,
	       (select count(1) sum2
	          from j#STL_CCM_OPTINFO
	         where OPTDATE between
	               to_date(to_char(sysdate - 1, 'yyyy-MM-dd') || ' 19:50:00',
	                       'yyyy-MM-dd HH24:mi:ss') and
	               to_date(to_char(sysdate, 'yyyy-MM-dd') || ' 19:49:59',
	                       'yyyy-MM-dd HH24:mi:ss')
	           and SHIFTCODE =
	               (SELECT mes_lg_common.getlgshift1(sysdate) FROM DUAl)) b
	 ]]>
    </query>
    
    <query id="GetRDT_Pointccm.Select" desc="获取连铸机切割拉速状态信息   " fetchSize="10">
        <![CDATA[
               select round(t1.S1CASTSPEED,  2)  CCM01_S1CASTSPEED, 
                  round(t1.S2CASTSPEED,  2)  CCM01_S2CASTSPEED,  
                  round(t1.S3CASTSPEED,  2)  CCM01_S3CASTSPEED,  
                  round(t1.S4CASTSPEED,  2)  CCM01_S4CASTSPEED,  
                  round(t1.S5CASTSPEED,  2)  CCM01_S5CASTSPEED,  
                  decode(t2.s1cutting,1,'切割信号',decode(t2.s1casting,1,'浇铸模式',decode(t2.s1casttail,1,  
                                                            '在浇尾坯',decode(t2.s1castprep,1,'浇铸准备',decode(t2.s1castdumb,1,  
                                                            '送引锭杆',decode(t2.S1PREPMODE,1,'工作准备',''))))))  CCM01_S1State,  
                  decode(t2.s2cutting,1,'切割信号',decode(t2.s2casting,1,'浇铸模式',decode(t2.s2casttail,1,  
                                                            '在浇尾坯',decode(t2.s2castprep,1,'浇铸准备',decode(t2.s2castdumb,1,  
                                                            '送引锭杆',decode(t2.S2PREPMODE,1,'工作准备',''))))))  CCM01_S2State,  
                  decode(t2.s3cutting,1,'切割信号',decode(t2.s3casting,1,'浇铸模式',decode(t2.s3casttail,1,  
                                                            '在浇尾坯',decode(t2.s3castprep,1,'浇铸准备',decode(t2.s3castdumb,1,  
                                                            '送引锭杆',decode(t2.S3PREPMODE,1,'工作准备',''))))))  CCM01_S3State,  
                  decode(t2.s4cutting,1,'切割信号',decode(t2.s4casting,1,'浇铸模式',decode(t2.s4casttail,1,  
                                                            '在浇尾坯',decode(t2.s4castprep,1,'浇铸准备',decode(t2.s4castdumb,1,  
                                                            '送引锭杆',decode(t2.S4PREPMODE,1,'工作准备',''))))))  CCM01_S4State,  
                  decode(t2.s5cutting,1,'切割信号',decode(t2.s5casting,1,'浇铸模式',decode(t2.s5casttail,1,  
                                                            '在浇尾坯',decode(t2.s5castprep,1,'浇铸准备',decode(t2.s5castdumb,1,  
                                                            '送引锭杆',decode(t2.S5PREPMODE,1,'工作准备',''))))))  CCM01_S5State,  
                  round(t3.S1CASTSPEED,  2)  CCM02_S1CASTSPEED,  
                  round(t3.S2CASTSPEED,  2)  CCM02_S2CASTSPEED,  
                  round(t3.S3CASTSPEED,  2)  CCM02_S3CASTSPEED,  
                  round(t3.S4CASTSPEED,  2)  CCM02_S4CASTSPEED,  
                  round(t3.S5CASTSPEED,  2)  CCM02_S5CASTSPEED,  
                  decode(t4.s1cutting,1,'切割信号',decode(t4.s1casting,1,'浇铸模式',decode(t4.s1casttail,1,  
                                                            '在浇尾坯',decode(t4.s1castprep,1,'浇铸准备',decode(t4.s1castdumb,1,  
                                                             '送引锭杆',decode(t4.S1PREPMODE,1,'工作准备',''))))))  CCM02_S1State,  
                   decode(t4.s2cutting,1,'切割信号',decode(t4.s2casting,1,'浇铸模式',decode(t4.s2casttail,1,  
                                                             '在浇尾坯',decode(t4.s2castprep,1,'浇铸准备',decode(t4.s2castdumb,1,  
                                                             '送引锭杆',decode(t4.S2PREPMODE,1,'工作准备',''))))))  CCM02_S2State,  
                   decode(t4.s3cutting,1,'切割信号',decode(t4.s3casting,1,'浇铸模式',decode(t4.s3casttail,1,  
                                                             '在浇尾坯',decode(t4.s3castprep,1,'浇铸准备',decode(t4.s3castdumb,1,  
                                                             '送引锭杆',decode(t4.S3PREPMODE,1,'工作准备',''))))))  CCM02_S3State,  
                   decode(t4.s4cutting,1,'切割信号',decode(t4.s4casting,1,'浇铸模式',decode(t4.s4casttail,1,  
                                                             '在浇尾坯',decode(t4.s4castprep,1,'浇铸准备',decode(t4.s4castdumb,1,  
                                                             '送引锭杆',decode(t4.S4PREPMODE,1,'工作准备',''))))))  CCM02_S4State,  
                   decode(t4.s5cutting,1,'切割信号',decode(t4.s5casting,1,'浇铸模式',decode(t4.s5casttail,1,  
                                                             '在浇尾坯',decode(t4.s5castprep,1,'浇铸准备',decode(t4.s5castdumb,1,  
                                                             '送引锭杆',decode(t4.S5PREPMODE,1,'工作准备',''))))))  CCM02_S5State,  
                   round(t5.S1CASTSPEED,  2)  CCM03_S1CASTSPEED,  
                   round(t5.S2CASTSPEED,  2)  CCM03_S2CASTSPEED,  
                   round(t5.S3CASTSPEED,  2)  CCM03_S3CASTSPEED,  
                   round(t5.S4CASTSPEED,  2)  CCM03_S4CASTSPEED,  
                   round(t5.S5CASTSPEED,  2)  CCM03_S5CASTSPEED,  
                   decode(t6.s1cutting,1,'切割信号',decode(t6.s1casting,1,'浇铸模式',decode(t6.s1casttail,1,  
                                                             '在浇尾坯',decode(t6.s1castprep,1,'浇铸准备',decode(t6.s1castdumb,1,  
                                                             '送引锭杆',decode(t6.S1PREPMODE,1,'工作准备',''))))))  CCM03_S1State,  
                   decode(t6.s2cutting,1,'切割信号',decode(t6.s2casting,1,'浇铸模式',decode(t6.s2casttail,1,  
                                                             '在浇尾坯',decode(t6.s2castprep,1,'浇铸准备',decode(t6.s2castdumb,1,  
                                                             '送引锭杆',decode(t6.S2PREPMODE,1,'工作准备',''))))))  CCM03_S2State,  
                   decode(t6.s3cutting,1,'切割信号',decode(t6.s3casting,1,'浇铸模式',decode(t6.s3casttail,1,  
                                                             '在浇尾坯',decode(t6.s3castprep,1,'浇铸准备',decode(t6.s3castdumb,1,  
                                                             '送引锭杆',decode(t6.S3PREPMODE,1,'工作准备',''))))))  CCM03_S3State,  
                   decode(t6.s4cutting,1,'切割信号',decode(t6.s4casting,1,'浇铸模式',decode(t6.s4casttail,1,  
                                                             '在浇尾坯',decode(t6.s4castprep,1,'浇铸准备',decode(t6.s4castdumb,1,  
                                                             '送引锭杆',decode(t6.S4PREPMODE,1,'工作准备',''))))))  CCM03_S4State,  
                   decode(t6.s5cutting,1,'切割信号',decode(t6.s5casting,1,'浇铸模式',decode(t6.s5casttail,1,  
                                                             '在浇尾坯',decode(t6.s5castprep,1,'浇铸准备',decode(t6.s5castdumb,1,  
                                                               '送引锭杆',decode(t6.S5PREPMODE,1,'工作准备',''))))))  CCM03_S5State,  
                   round(t7.S1CASTSPEED,  2)  CCM04_S1CASTSPEED,  
                   round(t7.S2CASTSPEED,  2)  CCM04_S2CASTSPEED,  
                   round(t7.S3CASTSPEED,  2)  CCM04_S3CASTSPEED,  
                   round(t7.S4CASTSPEED,  2)  CCM04_S4CASTSPEED,  
                   round(t7.S5CASTSPEED,  2)  CCM04_S5CASTSPEED,  
                   decode(t8.s1cutting,1,'切割信号', decode(t8.s1casting,1,'浇铸模式',decode(t8.s1casttail,1,  
                                                             '在浇尾坯',decode(t8.s1castprep,1,'浇铸准备',decode(t8.s1castdumb,1,  
                                                             '送引锭杆',decode(t8.S1PREPMODE,1,'工作准备',''))))))  CCM04_S1State,  
                   decode(t8.s2cutting,1,'切割信号', decode(t8.s2casting,1,'浇铸模式',decode(t8.s2casttail,1,  
                                                             '在浇尾坯',decode(t8.s2castprep,1,'浇铸准备',decode(t8.s2castdumb,1,  
                                                             '送引锭杆',decode(t8.S2PREPMODE,1, '工作准备',''))))))  CCM04_S2State, 
                   decode(t8.s3cutting,1,'切割信号',decode(t8.s3casting,1,'浇铸模式', decode(t8.s3casttail, 1,  
                                                             '在浇尾坯',decode(t8.s3castprep,1,'浇铸准备',decode(t8.s3castdumb,1,  
                                                             '送引锭杆',decode(t8.S3PREPMODE,1, '工作准备',''))))))  CCM04_S3State,  
                   decode(t8.s4cutting,1,'切割信号',decode(t8.s4casting,1, '浇铸模式',decode(t8.s4casttail,1,  
                                                             '在浇尾坯',decode(t8.s4castprep,1,'浇铸准备',decode(t8.s4castdumb,1,  
                                                             '送引锭杆',decode(t8.S4PREPMODE,1, '工作准备',''))))))  CCM04_S4State,  
                   decode(t8.s5cutting,1,'切割信号',decode(t8.s5casting,1,'浇铸模式',decode(t8.s5casttail,1,  
                                                             '在浇尾坯',decode(t8.s5castprep,1,'浇铸准备',decode(t8.s5castdumb,1,  
                                                             '送引锭杆',decode(t8.S5PREPMODE,1, '工作准备',''))))))  CCM04_S5State,
                   round(XYQ1PRESSURE,2) XYQ1PRESSURE,
                   round(XYQ2PRESSURE,2) XYQ2PRESSURE,
                   round(XYQ3PRESSURE,2) XYQ3PRESSURE,
                   round(XYQ4PRESSURE,2) XYQ4PRESSURE,
                   round(XYQ5PRESSURE,2) XYQ5PRESSURE,
                   round(XYQ6PRESSURE,2) XYQ6PRESSURE,
                   ROUND(OXZYL, 2) OXZYL,
                   round(RHSTEAMPRESSURE,2) RHSTEAMPRESSURE,
                   round(RHSTEAMFLUX,2) RHSTEAMFLUX,
                   round(ARPRESSURE,2) ARPRESSURE,
                   round(VDSTEAMPRESSURE,2) VDSTEAMPRESSURE,
                   round(VDSTEAMFLUX,2) VDSTEAMFLUX,
                   round(BOF1O2PRESS,2) BOF1O2PRESS,
                   round(BOF2O2PRESS,2) BOF2O2PRESS, 
                   round(MIDN2PRESS,2) MIDN2PRESS, 
                   round(DOWNN2PRESS,2) DOWNN2PRESS, 
                   round(JLCO2PRESS,2) JLCO2PRESS,  
                   round(BOFCO2PRESS,2) BOFCO2PRESS,   
                   round(BOF1O2FLUX,2) BOF1O2FLUX,  
                   round(BOF2O2FLUX,2) BOF2O2FLUX, 
                   round(FQG1PRESS,2) FQG1PRESS                                                           
            from  
                     rtd_pointccm1no1  t1,  
                     rtd_pointccm1no3  t2,  
                     rtd_pointccm2no1  t3,  
                     rtd_pointccm2no3  t4,  
                     rtd_pointccm3no1  t5,  
                     rtd_pointccm3no3  t6,  
                     rtd_pointccm4no1  t7,  
                     rtd_pointccm4no3  t8,
                     rtd_pointlyjz1 t9
	 ]]>
    </query>
    
     <query id="GetBofAdditive.Select" desc="获取转炉作业物料消耗   " fetchSize="10">
        <![CDATA[
			    select round(sum(JMWGT)) JMWGT,
				       HEATNO,
				       'C' || STATIONCODE STATIONCODE,
				       DISPOSALTIME,
				       MATERIELCODE,
				       HOPPERNUMID,
				       MATERIELTYPE,
				       JMTYPE
				  from STL_BOF_ADDITIVES
				 where HEATNO = ?
				   AND STATIONCODE = ?
				   AND DISPOSALTIME = ?
				 group by HEATNO,
				          STATIONCODE,
				          DISPOSALTIME,
				          MATERIELCODE,
				          HOPPERNUMID,
				          MATERIELTYPE,
				          JMTYPE
				 ORDER BY STATIONCODE DESC, materieltype
	 ]]>
    </query>
    
    <query id="GetGlobalBofSampling.Select" desc="获取转炉作业采样信息   " fetchSize="10">
        <![CDATA[
			    select a.HEATPROCESSNO,
				       a.SAMPLINGID,
				       a.SAMPLINGNAME,
				       a.HEATNO,
				       a.STATIONCODE,
				       a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,
				       a.SAMPLINGVALUE,
				       a.SAMPLINGDATE
				  from STL_tempsampling a,
				       (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
				          FROM STL_tempsampling
				         GROUP BY heatno, stationcode, disposaltime) b
				 where a.heatno = b.heatno
				   and a.stationcode = b.stationcode
				   and a.disposaltime = b.disposaltime
				   and a.samplingid = b.samplingid
				   AND a.HEATNO = ?
				   AND a.STATIONCODE = ?
				   AND a.DISPOSALTIME = ?
	 ]]>
    </query>
    
    <query id="GetCasAdditive.Select" desc="获取吹氩作业物料消耗信息   " fetchSize="10">
        <![CDATA[
			    select sum(JMWGT) JMWGT,HEATNO,STATIONCODE,
				       DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				       MATERIELTYPE,JMTYPE
				  from (select JMWGT,HEATNO,
				               'D' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,
				               HOPPERNUMID,MATERIELTYPE,JMTYPE
				          from STL_CAS_ADDITIVES
				         WHERE HEATNO = ? AND STATIONCODE = ? AND DISPOSALTIME = ?
				        union
				        select JMWGT,HEATNO,'C' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE, HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from Stl_BOF_ADDITIVES
				         WHERE HEATNO =? AND DISPOSALTIME =?) a
				 group by STATIONCODE,DISPOSALTIME,MATERIELCODE,
				          HOPPERNUMID,MATERIELTYPE,JMTYPE,HEATNO
				 ORDER BY STATIONCODE DESC,materieltype 
	 ]]>
    </query>
    
    <query id="GetGlobalCasSampling.Select" desc="获取吹氩作业采样信息   " fetchSize="10">
        <![CDATA[
			    select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
				       a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
				  from stl_tempsampling a,
				       (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
				          FROM STL_tempsampling
				         GROUP BY heatno, stationcode, disposaltime) b
				 where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO = ?
				union
				select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
				       a.HEATNO,'D' || a.STATIONCODE STATIONCODE,
				       a.DISPOSALTIME,a.SAMPLINGDEPICT,a.SAMPLINGVALUE,
				       a.SAMPLINGDATE
				  from STL_CAS_SAMPLING a,
				       (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
				          FROM STL_CAS_SAMPLING GROUP BY heatno, stationcode, disposaltime) b
				 where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO = ?
				   AND a.DISPOSALTIME = ? ORDER BY STATIONCODE DESC,disposaltime
	 ]]>	 
    </query>
    
    <query id="GetLfsAdditive.Select" desc="获取LF炉作业物料消耗信息   " fetchSize="10">
        <![CDATA[
			    select sum(JMWGT) JMWGT,HEATNO,STATIONCODE,DISPOSALTIME,
				       MATERIELCODE,HOPPERNUMID,MATERIELTYPE,JMTYPE
				  from (select JMWGT,HEATNO,'E' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,
				               HOPPERNUMID,MATERIELTYPE,JMTYPE
				          from STL_LFS_ADDITIVES
				         WHERE HEATNO =? and STATIONCODE = ? AND DISPOSALTIME = ?
				        union
				        select JMWGT,HEATNO,'D' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_CAS_ADDITIVES WHERE HEATNO =?         
				        union
				        select JMWGT,HEATNO,'C' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_BOF_ADDITIVES WHERE HEATNO = ? and DISPOSALTIME = ?) a
				 group by STATIONCODE,DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				          MATERIELTYPE,JMTYPE,HEATNO
				          ORDER BY STATIONCODE DESC,materieltype
	 ]]>
    </query>
    
    <query id="GetGlobalLfsSampling.Select" desc="获取LF炉作业采样信息   " fetchSize="10">
        <![CDATA[
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
		               a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
		          from stl_tempsampling a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_tempsampling
		                 GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO =?
		        union
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,'E' || a.STATIONCODE STATIONCODE,
		               a.DISPOSALTIME,a.SAMPLINGDEPICT,a.SAMPLINGVALUE,
		               a.SAMPLINGDATE
		          from STL_LFS_SAMPLING a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_LFS_SAMPLING GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO = ?
		           AND a.DISPOSALTIME = ? ORDER BY STATIONCODE DESC,disposaltime
	 ]]>	 
    </query>
    
    <query id="GetRhsAdditive.Select" desc="获取RH炉作业物料消耗信息   " fetchSize="10">
        <![CDATA[
			    select sum(JMWGT) JMWGT,HEATNO,STATIONCODE,DISPOSALTIME,
				       MATERIELCODE,HOPPERNUMID,MATERIELTYPE,JMTYPE
				  from (select JMWGT,HEATNO,'F' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_RHS_ADDITIVES WHERE HEATNO =? and STATIONCODE =? 
				           AND DISPOSALTIME =?
				        union
				        select JMWGT,HEATNO,'E' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_LFS_ADDITIVES WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'D' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_CAS_ADDITIVES
				         WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'C' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_BOF_ADDITIVES WHERE HEATNO =? and DISPOSALTIME =?) a
				 group by STATIONCODE,DISPOSALTIME,MATERIELCODE,
				          HOPPERNUMID,MATERIELTYPE,JMTYPE, HEATNO
				 ORDER BY STATIONCODE DESC, materieltype
	 ]]>
    </query>
    
    <query id="GetGlobalRhsSampling.Select" desc="获取RH炉作业采样信息   " fetchSize="10">
        <![CDATA[
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
		               a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
		          from stl_tempsampling a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_tempsampling
		                 GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO =?
		        union
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,'F' || a.STATIONCODE STATIONCODE,
		               a.DISPOSALTIME,a.SAMPLINGDEPICT,a.SAMPLINGVALUE,
		               a.SAMPLINGDATE
		          from STL_RHS_SAMPLING a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_RHS_SAMPLING GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO = ?
		           AND a.DISPOSALTIME = ? ORDER BY STATIONCODE DESC,disposaltime
	 ]]>	 
    </query>
    
     <query id="GetVdsAdditive.Select" desc="获取VD炉作业物料消耗信息   " fetchSize="10">
        <![CDATA[
			    select sum(JMWGT) JMWGT,HEATNO,STATIONCODE,DISPOSALTIME,
				       MATERIELCODE,HOPPERNUMID,MATERIELTYPE,JMTYPE
				  from (
				        select JMWGT,HEATNO,'I' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_VDS_ADDITIVES WHERE HEATNO =? and STATIONCODE =? 
				           AND DISPOSALTIME =?
				        union
				  		select JMWGT,HEATNO,'F' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_RHS_ADDITIVES WHERE HEATNO =? 
				        union
				        select JMWGT,HEATNO,'E' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_LFS_ADDITIVES WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'D' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_CAS_ADDITIVES
				         WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'C' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_BOF_ADDITIVES WHERE HEATNO =? and DISPOSALTIME =?) a
				 group by STATIONCODE,DISPOSALTIME,MATERIELCODE,
				          HOPPERNUMID,MATERIELTYPE,JMTYPE, HEATNO
				 ORDER BY STATIONCODE DESC, materieltype
	 ]]>
    </query>
    
    <query id="GetGlobalVdsSampling.Select" desc="获取VD炉作业采样信息   " fetchSize="10">
        <![CDATA[
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
		               a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
		          from stl_tempsampling a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_tempsampling
		                 GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO =?
		        union
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,'I' || a.STATIONCODE STATIONCODE,
		               a.DISPOSALTIME,a.SAMPLINGDEPICT,a.SAMPLINGVALUE,
		               a.SAMPLINGDATE
		          from STL_VDS_SAMPLING a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_VDS_SAMPLING GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO = ?
		           AND a.DISPOSALTIME = ? ORDER BY STATIONCODE DESC,disposaltime
	 ]]>	 
    </query>
    
    <query id="GetCcmAdditive.Select" desc="获取其它工序作业物料消耗信息   " fetchSize="10">
        <![CDATA[
			    select sum(JMWGT) JMWGT,HEATNO,STATIONCODE,DISPOSALTIME,
				       MATERIELCODE,HOPPERNUMID,MATERIELTYPE,JMTYPE
				  from (
				        select JMWGT,HEATNO,'I' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_VDS_ADDITIVES WHERE HEATNO =? and STATIONCODE =? 
				           AND DISPOSALTIME =?
				        union
				  		select JMWGT,HEATNO,'F' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_RHS_ADDITIVES WHERE HEATNO =? 
				        union
				        select JMWGT,HEATNO,'E' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_LFS_ADDITIVES WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'D' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_CAS_ADDITIVES
				         WHERE HEATNO =?
				        union
				        select JMWGT,HEATNO,'C' || STATIONCODE STATIONCODE,
				               DISPOSALTIME,MATERIELCODE,HOPPERNUMID,
				               MATERIELTYPE,JMTYPE
				          from STL_BOF_ADDITIVES WHERE HEATNO =? and DISPOSALTIME =?) a
				 group by STATIONCODE,DISPOSALTIME,MATERIELCODE,
				          HOPPERNUMID,MATERIELTYPE,JMTYPE, HEATNO
				 ORDER BY STATIONCODE DESC, materieltype
	 ]]>
    </query>
    
    <query id="GetGlobalCcmSampling.Select" desc="获取连铸机作业采样信息   " fetchSize="10">
        <![CDATA[
		        select a.HEATPROCESSNO,a.SAMPLINGID,a.SAMPLINGNAME,
		               a.HEATNO,a.STATIONCODE,a.DISPOSALTIME,
		               a.SAMPLINGDEPICT,a.SAMPLINGVALUE,a.SAMPLINGDATE
		          from stl_tempsampling a,
		               (SELECT heatno, stationcode, disposaltime, MAX(samplingid) samplingid
		                  FROM STL_tempsampling
		                 GROUP BY heatno, stationcode, disposaltime) b
		         where a.heatno = b.heatno and a.stationcode = b.stationcode AND a.HEATNO =?		        
	 ]]>	 
    </query>
    
    <query id="GetGlobalCcmF1Sampling.Select" desc="获取1#连铸机拉速、配水采样信息   " fetchSize="10">
        <![CDATA[
		       select samplingid,
				       heatprocessno,
				       heatno,
				       stationcode,
				       disposaltime,
				       armladleaweight,
				       armladlebweight,
				       armacastpos,
				       armbcastpos,
				       midladle1weight,
				       midladle2weight,
				       midladletemp,
				       midladletemp1,
				       midladletemp2,
				       ladletemperature,
				       coolwatertotalpressure,
				       coolwatertotaltemp,
				       coolwatertotalflux,
				       crylwatertotalpressure,
				       crylwatertotaltemp,
				       clearwatertotalpressure,
				       dirtywatertotalpressure,
				       devicewatertotalpressure,
				       pressedairflux,
				       pressedairpressure,
				       s1castspeed,
				       s2castspeed,
				       s3castspeed,
				       s4castspeed,
				       s5castspeed,
				       s1castinglength,
				       s2castinglength,
				       s1drawsteellength,
				       s2drawsteellength,
				       s3drawsteellength,
				       s4drawsteellength,
				       s5drawsteellength,
				       s1castingmode,
				       s2castingmode,
				       s1crinwatertemp,
				       s1crnarrowloutwatertemp,
				       s1crinnerarcwatertemp,
				       s1croutsidearcwatertemp,
				       s1crnarrowroutwatertemp,
				       s2crinwatertemp,
				       s2crnarrowloutwatertemp,
				       s2crinnerarcwatertemp,
				       s2croutsidearcwatertemp,
				       s2crnarrowroutwatertemp,
				       s1crinwaterpres,
				       s1crnarrowloutwaterpres,
				       s1crinnerarcwaterpres,
				       s1croutsidearcwaterpres,
				       s1crnarrowroutwaterpres,
				       s2crinwaterpres,
				       s2crnarrowloutwaterpres,
				       s2crinnerarcwaterpres,
				       s2croutsidearcwaterpres,
				       s2crnarrowroutwaterpres,
				       s1crvibratorfrequency,
				       s2crvibratorfrequency,
				       s1cramplitude,
				       s2cramplitude,
				       s1crinwatertotalflux,
				       s1crnarrowloutwaterflux,
				       s1crinnerarcwaterflux,
				       s1croutsidearcwaterflux,
				       s1crnarrowroutwaterflux,
				       s1crnarrowloutwatertempdiff,
				       s1crinnerarcwatertempdiff,
				       s1croutsidearcwatertempdiff,
				       s1crnarrowroutwatertempdiff,
				       s2crinwatertotalflux,
				       s2crnarrowloutwaterflux,
				       s2crinnerarcwaterflux,
				       s2croutsidearcwaterflux,
				       s2crnarrowroutwaterflux,
				       s2crnarrowloutwatertempdiff,
				       s2crinnerarcwatertempdiff,
				       s2croutsidearcwatertempdiff,
				       s2crnarrowroutwatertempdiff,
				       s1seg1waternarrowlrflux,
				       s1seg1waterarcflux,
				       s1seg2waterarcflux,
				       s1seg3waterinnerarceflux,
				       s1seg3waterinnerarcmflux,
				       s1seg3wateroutsidearceflux,
				       s1seg3wateroutsidearcmflux,
				       s1seg4waterinnerarceflux,
				       s1seg4waterinnerarcmflux,
				       s1seg4wateroutsidearceflux,
				       s1seg4wateroutsidearcmflux,
				       s1seg5waterinnerarceflux,
				       s1seg5waterinnerarcmflux,
				       s1seg5wateroutsidearceflux,
				       s1seg5wateroutsidearcmflux,
				       s1seg6waterinnerarceflux,
				       s1seg6waterinnerarcmflux,
				       s1seg6wateroutsidearceflux,
				       s1seg6wateroutsidearcmflux,
				       s1seg7waterinnerarceflux,
				       s1seg7waterinnerarcmflux,
				       s1seg7wateroutsidearceflux,
				       s1seg7wateroutsidearcmflux,
				       s1seg8waterinnerarceflux,
				       s1seg8waterinnerarcmflux,
				       s1seg8wateroutsidearceflux,
				       s1seg8wateroutsidearcmflux,
				       s1seg9waterinnerarcflux,
				       s1seg9wateroutsidearcflux,
				       s1seg10waterinnerarcflux,
				       s1seg10wateroutsidearcflux,
				       s1seg1waternarrowlrpres,
				       s1seg1waterarcpres,
				       s1seg2waterarcpres,
				       s1seg3waterinnerarcepres,
				       s1seg3waterinnerarcmpres,
				       s1seg3wateroutsidearcepres,
				       s1seg3wateroutsidearcmpres,
				       s1seg4waterinnerarcepres,
				       s1seg4waterinnerarcmpres,
				       s1seg4wateroutsidearcepres,
				       s1seg4wateroutsidearcmpres,
				       s1seg5waterinnerarcepres,
				       s1seg5waterinnerarcmpres,
				       s1seg5wateroutsidearcepres,
				       s1seg5wateroutsidearcmpres,
				       s1seg6waterinnerarcepres,
				       s1seg6waterinnerarcmpres,
				       s1seg6wateroutsidearcepres,
				       s1seg6wateroutsidearcmpres,
				       s1seg7waterinnerarcepres,
				       s1seg7waterinnerarcmpres,
				       s1seg7wateroutsidearcepres,
				       s1seg7wateroutsidearcmpres,
				       s1seg8waterinnerarcepres,
				       s1seg8waterinnerarcmpres,
				       s1seg8wateroutsidearcepres,
				       s1seg8wateroutsidearcmpres,
				       s1seg9waterinnerarcpres,
				       s1seg9wateroutsidearcpres,
				       s1seg10waterinnerarcpres,
				       s1seg10wateroutsidearcpres,
				       s1segairintotalflux,
				       s1segair2to3arcmpres,
				       s1segair3arcepres,
				       s1segair4to8arcmpres,
				       s1segair4to8arcepres,
				       s1segair9to10arcpres,
				       s2seg1waternarrowlrflux,
				       s2seg1waterarcflux,
				       s2seg2waterarcflux,
				       s2seg3waterinnerarceflux,
				       s2seg3waterinnerarcmflux,
				       s2seg3wateroutsidearceflux,
				       s2seg3wateroutsidearcmflux,
				       s2seg4waterinnerarceflux,
				       s2seg4waterinnerarcmflux,
				       s2seg4wateroutsidearceflux,
				       s2seg4wateroutsidearcmflux,
				       s2seg5waterinnerarceflux,
				       s2seg5waterinnerarcmflux,
				       s2seg5wateroutsidearceflux,
				       s2seg5wateroutsidearcmflux,
				       s2seg6waterinnerarceflux,
				       s2seg6waterinnerarcmflux,
				       s2seg6wateroutsidearceflux,
				       s2seg6wateroutsidearcmflux,
				       s2seg7waterinnerarceflux,
				       s2seg7waterinnerarcmflux,
				       s2seg7wateroutsidearceflux,
				       s2seg7wateroutsidearcmflux,
				       s2seg8waterinnerarceflux,
				       s2seg8waterinnerarcmflux,
				       s2seg8wateroutsidearceflux,
				       s2seg8wateroutsidearcmflux,
				       s2seg9waterinnerarcflux,
				       s2seg9wateroutsidearcflux,
				       s2seg10waterinnerarcflux,
				       s2seg10wateroutsidearcflux,
				       s2seg1waternarrowlrpres,
				       s2seg1waterarcpres,
				       s2seg2waterarcpres,
				       s2seg3waterinnerarcepres,
				       s2seg3waterinnerarcmpres,
				       s2seg3wateroutsidearcepres,
				       s2seg3wateroutsidearcmpres,
				       s2seg4waterinnerarcepres,
				       s2seg4waterinnerarcmpres,
				       s2seg4wateroutsidearcepres,
				       s2seg4wateroutsidearcmpres,
				       s2seg5waterinnerarcepres,
				       s2seg5waterinnerarcmpres,
				       s2seg5wateroutsidearcepres,
				       s2seg5wateroutsidearcmpres,
				       s2seg6waterinnerarcepres,
				       s2seg6waterinnerarcmpres,
				       s2seg6wateroutsidearcepres,
				       s2seg6wateroutsidearcmpres,
				       s2seg7waterinnerarcepres,
				       s2seg7waterinnerarcmpres,
				       s2seg7wateroutsidearcepres,
				       s2seg7wateroutsidearcmpres,
				       s2seg8waterinnerarcepres,
				       s2seg8waterinnerarcmpres,
				       s2seg8wateroutsidearcepres,
				       s2seg8wateroutsidearcmpres,
				       s2seg9waterinnerarcpres,
				       s2seg9wateroutsidearcpres,
				       s2seg10waterinnerarcpres,
				       s2seg10wateroutsidearcpres,
				       s2segairintotalflux,
				       s2segair2to3arcmpres,
				       s2segair3arcepres,
				       s2segair4to8arcmpres,
				       s2segair4to8arcepres,
				       s2segair9to10arcpres,
				       lastfreshtime,
				       isvalid,
				       operator,
				       optdate,
				       S1CRYSTALCODE,
				       S2CRYSTALCODE
				  From (select *
				          from stl_ccm_f1sampling
				         WHERE Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ?
				           and samplingid = (select Max(samplingid)
				                               from stl_ccm_f1sampling
				                              WHERE Heatno = ?
				                                and StationCode = ?
				                                and DisposalTime = ?)
				         ORDER BY SAMPLINGID DESC) t,
				       (select S1CRYSTALCODE,
				               S2CRYSTALCODE               
				          from stl_ccm_mouldinfo t, stl_ccm_optinfo t1
				         where t.mouldno = t1.mouldno
				           and Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ? ) t1
	 ]]>	 
    </query>
    
    <query id="GetGlobalCcmF2Sampling.Select" desc="获取2#连铸机拉速、配水采样信息   " fetchSize="10">
        <![CDATA[
		        select samplingid,
				       heatprocessno,
				       heatno,
				       stationcode,
				       disposaltime,
				       armladleaweight,
				       armladlebweight,
				       armacastpos,
				       armbcastpos,
				       midladle1weight,
				       midladle2weight,
				       midladletemp,
				       midladletemp1,
				       midladletemp2,
				       ladletemperature,
				       coolwatertotalpressure,
				       coolwatertotaltemp,
				       coolwatertotalflux,
				       crylwatertotalpressure,
				       crylwatertotaltemp,
				       clearwatertotalpressure,
				       dirtywatertotalpressure,
				       devicewatertotalpressure,
				       pressedairflux,
				       pressedairpressure,
				       s1castspeed,
				       s2castspeed,
				       s3castspeed,
				       s4castspeed,
				       s5castspeed,
				       s1castinglength,
				       s2castinglength,
				       s1drawsteellength,
				       s2drawsteellength,
				       s3drawsteellength,
				       s4drawsteellength,
				       s5drawsteellength,
				       s1castingmode,
				       s2castingmode,
				       s1crinwatertemp,
				       s1crnarrowloutwatertemp,
				       s1crinnerarcwatertemp,
				       s1croutsidearcwatertemp,
				       s1crnarrowroutwatertemp,
				       s2crinwatertemp,
				       s2crnarrowloutwatertemp,
				       s2crinnerarcwatertemp,
				       s2croutsidearcwatertemp,
				       s2crnarrowroutwatertemp,
				       s1crinwaterpres,
				       s1crnarrowloutwaterpres,
				       s1crinnerarcwaterpres,
				       s1croutsidearcwaterpres,
				       s1crnarrowroutwaterpres,
				       s2crinwaterpres,
				       s2crnarrowloutwaterpres,
				       s2crinnerarcwaterpres,
				       s2croutsidearcwaterpres,
				       s2crnarrowroutwaterpres,
				       s1crvibratorfrequency,
				       s2crvibratorfrequency,
				       s1cramplitude,
				       s2cramplitude,
				       s1crinwatertotalflux,
				       s1crnarrowloutwaterflux,
				       s1crinnerarcwaterflux,
				       s1croutsidearcwaterflux,
				       s1crnarrowroutwaterflux,
				       s1crnarrowloutwatertempdiff,
				       s1crinnerarcwatertempdiff,
				       s1croutsidearcwatertempdiff,
				       s1crnarrowroutwatertempdiff,
				       s2crinwatertotalflux,
				       s2crnarrowloutwaterflux,
				       s2crinnerarcwaterflux,
				       s2croutsidearcwaterflux,
				       s2crnarrowroutwaterflux,
				       s2crnarrowloutwatertempdiff,
				       s2crinnerarcwatertempdiff,
				       s2croutsidearcwatertempdiff,
				       s2crnarrowroutwatertempdiff,
				       s1seg1waternarrowlrflux,
				       s1seg1waterarcflux,
				       s1seg2waterarcflux,
				       s1seg3waterinnerarceflux,
				       s1seg3waterinnerarcmflux,
				       s1seg3wateroutsidearceflux,
				       s1seg3wateroutsidearcmflux,
				       s1seg4waterinnerarceflux,
				       s1seg4waterinnerarcmflux,
				       s1seg4wateroutsidearceflux,
				       s1seg4wateroutsidearcmflux,
				       s1seg5waterinnerarceflux,
				       s1seg5waterinnerarcmflux,
				       s1seg5wateroutsidearceflux,
				       s1seg5wateroutsidearcmflux,
				       s1seg6waterinnerarceflux,
				       s1seg6waterinnerarcmflux,
				       s1seg6wateroutsidearceflux,
				       s1seg6wateroutsidearcmflux,
				       s1seg7waterinnerarceflux,
				       s1seg7waterinnerarcmflux,
				       s1seg7wateroutsidearceflux,
				       s1seg7wateroutsidearcmflux,
				       s1seg8waterinnerarceflux,
				       s1seg8waterinnerarcmflux,
				       s1seg8wateroutsidearceflux,
				       s1seg8wateroutsidearcmflux,
				       s1seg9waterinnerarcflux,
				       s1seg9wateroutsidearcflux,
				       s1seg10waterinnerarcflux,
				       s1seg10wateroutsidearcflux,
				       s1seg1waternarrowlrpres,
				       s1seg1waterarcpres,
				       s1seg2waterarcpres,
				       s1seg3waterinnerarcepres,
				       s1seg3waterinnerarcmpres,
				       s1seg3wateroutsidearcepres,
				       s1seg3wateroutsidearcmpres,
				       s1seg4waterinnerarcepres,
				       s1seg4waterinnerarcmpres,
				       s1seg4wateroutsidearcepres,
				       s1seg4wateroutsidearcmpres,
				       s1seg5waterinnerarcepres,
				       s1seg5waterinnerarcmpres,
				       s1seg5wateroutsidearcepres,
				       s1seg5wateroutsidearcmpres,
				       s1seg6waterinnerarcepres,
				       s1seg6waterinnerarcmpres,
				       s1seg6wateroutsidearcepres,
				       s1seg6wateroutsidearcmpres,
				       s1seg7waterinnerarcepres,
				       s1seg7waterinnerarcmpres,
				       s1seg7wateroutsidearcepres,
				       s1seg7wateroutsidearcmpres,
				       s1seg8waterinnerarcepres,
				       s1seg8waterinnerarcmpres,
				       s1seg8wateroutsidearcepres,
				       s1seg8wateroutsidearcmpres,
				       s1seg9waterinnerarcpres,
				       s1seg9wateroutsidearcpres,
				       s1seg10waterinnerarcpres,
				       s1seg10wateroutsidearcpres,
				       s1segairintotalflux,
				       s1segair2to3arcmpres,
				       s1segair3arcepres,
				       s1segair4to8arcmpres,
				       s1segair4to8arcepres,
				       s1segair9to10arcpres,
				       s2seg1waternarrowlrflux,
				       s2seg1waterarcflux,
				       s2seg2waterarcflux,
				       s2seg3waterinnerarceflux,
				       s2seg3waterinnerarcmflux,
				       s2seg3wateroutsidearceflux,
				       s2seg3wateroutsidearcmflux,
				       s2seg4waterinnerarceflux,
				       s2seg4waterinnerarcmflux,
				       s2seg4wateroutsidearceflux,
				       s2seg4wateroutsidearcmflux,
				       s2seg5waterinnerarceflux,
				       s2seg5waterinnerarcmflux,
				       s2seg5wateroutsidearceflux,
				       s2seg5wateroutsidearcmflux,
				       s2seg6waterinnerarceflux,
				       s2seg6waterinnerarcmflux,
				       s2seg6wateroutsidearceflux,
				       s2seg6wateroutsidearcmflux,
				       s2seg7waterinnerarceflux,
				       s2seg7waterinnerarcmflux,
				       s2seg7wateroutsidearceflux,
				       s2seg7wateroutsidearcmflux,
				       s2seg8waterinnerarceflux,
				       s2seg8waterinnerarcmflux,
				       s2seg8wateroutsidearceflux,
				       s2seg8wateroutsidearcmflux,
				       s2seg9waterinnerarcflux,
				       s2seg9wateroutsidearcflux,
				       s2seg10waterinnerarcflux,
				       s2seg10wateroutsidearcflux,
				       s2seg1waternarrowlrpres,
				       s2seg1waterarcpres,
				       s2seg2waterarcpres,
				       s2seg3waterinnerarcepres,
				       s2seg3waterinnerarcmpres,
				       s2seg3wateroutsidearcepres,
				       s2seg3wateroutsidearcmpres,
				       s2seg4waterinnerarcepres,
				       s2seg4waterinnerarcmpres,
				       s2seg4wateroutsidearcepres,
				       s2seg4wateroutsidearcmpres,
				       s2seg5waterinnerarcepres,
				       s2seg5waterinnerarcmpres,
				       s2seg5wateroutsidearcepres,
				       s2seg5wateroutsidearcmpres,
				       s2seg6waterinnerarcepres,
				       s2seg6waterinnerarcmpres,
				       s2seg6wateroutsidearcepres,
				       s2seg6wateroutsidearcmpres,
				       s2seg7waterinnerarcepres,
				       s2seg7waterinnerarcmpres,
				       s2seg7wateroutsidearcepres,
				       s2seg7wateroutsidearcmpres,
				       s2seg8waterinnerarcepres,
				       s2seg8waterinnerarcmpres,
				       s2seg8wateroutsidearcepres,
				       s2seg8wateroutsidearcmpres,
				       s2seg9waterinnerarcpres,
				       s2seg9wateroutsidearcpres,
				       s2seg10waterinnerarcpres,
				       s2seg10wateroutsidearcpres,
				       s2segairintotalflux,
				       s2segair2to3arcmpres,
				       s2segair3arcepres,
				       s2segair4to8arcmpres,
				       s2segair4to8arcepres,
				       s2segair9to10arcpres,
				       lastfreshtime,
				       isvalid,
				       operator,
				       optdate,
				       S1CRYSTALCODE,
				       S2CRYSTALCODE
				  From (select *
				          from stl_ccm_f2sampling
				         WHERE Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ?
				           and samplingid = (select Max(samplingid)
				                               from stl_ccm_f2sampling
				                              WHERE Heatno = ?
				                                and StationCode = ?
				                                and DisposalTime = ?)
				         ORDER BY SAMPLINGID DESC) t,
				       (select S1CRYSTALCODE,
				               S2CRYSTALCODE               
				          from stl_ccm_mouldinfo t, stl_ccm_optinfo t1
				         where t.mouldno = t1.mouldno
				           and Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ? ) t1
	 ]]>	 
    </query>
    
     <query id="GetGlobalCcmF3Sampling.Select" desc="获取3#连铸机拉速、配水采样信息   " fetchSize="10">
        <![CDATA[
		        select samplingid,
				       heatprocessno,
				       heatno,
				       stationcode,
				       disposaltime,
				       armladleaweight,
				       armladlebweight,
				       armacastpos,
				       armbcastpos,
				       midladle1weight,
				       midladle2weight,
				       midladletemp,
				       midladletemp1,
				       midladletemp2,
				       ladletemperature,
				       coolwatertotalpressure,
				       coolwatertotaltemp,
				       coolwatertotalflux,
				       crylwatertotalpressure,
				       crylwatertotaltemp,
				       clearwatertotalpressure,
				       dirtywatertotalpressure,
				       devicewatertotalpressure,
				       pressedairflux,
				       pressedairpressure,
				       s1castspeed,
				       s2castspeed,
				       s3castspeed,
				       s4castspeed,
				       s5castspeed,
				       s1castinglength,
				       s2castinglength,
				       s1drawsteellength,
				       s2drawsteellength,
				       s3drawsteellength,
				       s4drawsteellength,
				       s5drawsteellength,
				       s1castingmode,
				       s2castingmode,
				       s1crinwatertemp,
				       s1crnarrowloutwatertemp,
				       s1crinnerarcwatertemp,
				       s1croutsidearcwatertemp,
				       s1crnarrowroutwatertemp,
				       s1crinwaterpres,
				       s1crnarrowloutwaterpres,
				       s1crinnerarcwaterpres,
				       s1croutsidearcwaterpres,
				       s1crnarrowroutwaterpres,
				       s1crvibratorfrequency,
				       s2crvibratorfrequency,
				       s1cramplitude,
				       s2cramplitude,
				       s1crinwatertotalflux,
				       s1crnarrowloutwaterflux,
				       s1crinnerarcwaterflux,
				       s1croutsidearcwaterflux,
				       s1crnarrowroutwaterflux,
				       s1crnarrowloutwatertempdiff,
				       s1crinnerarcwatertempdiff,
				       s1croutsidearcwatertempdiff,
				       s1crnarrowroutwatertempdiff,
				       s1seg1waternarrowlrflux,
				       s1seg1waterarcflux,
				       s1seg2waterarcflux,
				       s1seg3waterinnerarceflux,
				       s1seg3waterinnerarcmflux,
				       s1seg3wateroutsidearceflux,
				       s1seg3wateroutsidearcmflux,
				       s1seg4waterinnerarceflux,
				       s1seg4waterinnerarcmflux,
				       s1seg4wateroutsidearceflux,
				       s1seg4wateroutsidearcmflux,
				       s1seg5waterinnerarceflux,
				       s1seg5waterinnerarcmflux,
				       s1seg5wateroutsidearceflux,
				       s1seg5wateroutsidearcmflux,
				       s1seg6waterinnerarceflux,
				       s1seg6waterinnerarcmflux,
				       s1seg6wateroutsidearceflux,
				       s1seg6wateroutsidearcmflux,
				       s1seg7waterinnerarceflux,
				       s1seg7waterinnerarcmflux,
				       s1seg7wateroutsidearceflux,
				       s1seg7wateroutsidearcmflux,
				       s1seg8waterinnerarceflux,
				       s1seg8waterinnerarcmflux,
				       s1seg8wateroutsidearceflux,
				       s1seg8wateroutsidearcmflux,
				       s1seg9waterinnerarceflux,
				       s1seg9waterinnerarcmflux,
				       s1seg9wateroutsidearceflux,
				       s1seg9wateroutsidearcmflux,
				       s1seg10waterinnerarceflux,
				       s1seg10waterinnerarcmflux,
				       s1seg10wateroutsidearceflux,
				       s1seg10wateroutsidearcmflux,
				       s1seg11waterinnerarcflux,
				       s1seg11wateroutsidearcflux,
				       s1seg12waterinnerarcflux,
				       s1seg12wateroutsidearcflux,
				       s1seg13waterinnerarcflux,
				       s1seg13wateroutsidearcflux,
				       s1seg1waternarrowlrpres,
				       s1seg1waterarcpres,
				       s1seg2waterarcpres,
				       s1seg3waterinnerarcepres,
				       s1seg3waterinnerarcmpres,
				       s1seg3wateroutsidearcepres,
				       s1seg3wateroutsidearcmpres,
				       s1seg4waterinnerarcepres,
				       s1seg4waterinnerarcmpres,
				       s1seg4wateroutsidearcepres,
				       s1seg4wateroutsidearcmpres,
				       s1seg5waterinnerarcepres,
				       s1seg5waterinnerarcmpres,
				       s1seg5wateroutsidearcepres,
				       s1seg5wateroutsidearcmpres,
				       s1seg6waterinnerarcepres,
				       s1seg6waterinnerarcmpres,
				       s1seg6wateroutsidearcepres,
				       s1seg6wateroutsidearcmpres,
				       s1seg7waterinnerarcepres,
				       s1seg7waterinnerarcmpres,
				       s1seg7wateroutsidearcepres,
				       s1seg7wateroutsidearcmpres,
				       s1seg8waterinnerarcepres,
				       s1seg8waterinnerarcmpres,
				       s1seg8wateroutsidearcepres,
				       s1seg8wateroutsidearcmpres,
				       s1seg9waterinnerarcepres,
				       s1seg9waterinnerarcmpres,
				       s1seg9wateroutsidearcepres,
				       s1seg9wateroutsidearcmpres,
				       s1seg10waterinnerarcepres,
				       s1seg10waterinnerarcmpres,
				       s1seg10wateroutsidearcepres,
				       s1seg10wateroutsidearcmpres,
				       s1seg11waterinnerarcpres,
				       s1seg11wateroutsidearcpres,
				       s1seg12waterinnerarcpres,
				       s1seg12wateroutsidearcpres,
				       s1seg13waterinnerarcpres,
				       s1seg13wateroutsidearcpres,
				       s1segairintotalflux,
				       s1segair2to4arcmpres,
				       s1segair3to4arcepres,
				       s1segair5to10arcmpres,
				       s1segair5to10arcepres,
				       s1segair11to13arcpres,
				       lastfreshtime,
				       isvalid,
				       operator,
				       optdate,
				       S1CRYSTALCODE,
				       S2CRYSTALCODE
				  From (select *
				          from stl_ccm_f3sampling
				         WHERE Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ?
				           and samplingid = (select Max(samplingid)
				                               from stl_ccm_f3sampling
				                              WHERE Heatno = ?
				                                and StationCode = ?
				                                and DisposalTime = ?)
				         ORDER BY SAMPLINGID DESC) t,
				       (select S1CRYSTALCODE, S2CRYSTALCODE
				          from stl_ccm_mouldinfo t, stl_ccm_optinfo t1
				         where t.mouldno = t1.mouldno
				           and Heatno = ?
				           and StationCode = ?
				           and DisposalTime = ?) t1
	 ]]>	 
    </query>
    
    <query id="GetGlobalCcmF4Sampling.Select" desc="获取4#连铸机拉速、配水采样信息   " fetchSize="10">
        <![CDATA[
		        SELECT SAMPLINGID,
				       HEATPROCESSNO,
				       HEATNO,
				       STATIONCODE,
				       DISPOSALTIME,
				       S1CASTSPEED,
				       S1DRAWSTEELLENGTH,
				       CRYSTALLORWATERLIBRATFRE,
				       CRYSTALLORWATERLEFTFLUX,
				       CRYSTALLORWATERRIGHTFLUX,
				       CRYSTALLORWATERINNERFLUX,
				       CRYSTALLORWATEROUTERFLUX,
				       CRYSTALLORLEFTDIT,
				       CRYSTALLORRIGHTDIT,
				       CRYSTALLORINNERDIT,
				       CRYSTALLOROUTERDIT,
				       S1SEG1WATERFLUX,
				       S1SEG2WATERFLUX,
				       S2SEG3WATERFLUX,
				       S3SEG4WATERFLUX,
				       S4SEG5WATERFLUX,
				       S4SEG6WATERFLUX,
				       S5SEG7WATERFLUX,
				       S5SEG8WATERFLUX,
				       S6SEG9WATERFLUX,
				       S6SEG10WATERFLUX,
				       S7SEG11WATERFLUX,
				       S7SEG12WATERFLUX,
				       S1SEG1WATERPRESS,
				       S1SEG2WATERPRESS,
				       S2SEG3WATERPRESS,
				       S3SEG4WATERPRESS,
				       S4SEG5WATERPRESS,
				       S4SEG6WATERPRESS,
				       S5SEG7WATERPRESS,
				       S5SEG8WATERPRESS,
				       S6SEG9WATERPRESS,
				       S6SEG10WATERPRESS,
				       S7SEG11WATERPRESS,
				       S7SEG12WATERPRESS,
				       S4SEG5AIRPRESS,
				       S4SEG6AIRPRESS,
				       S5SEG7AIRPRESS,
				       S5SEG8AIRPRESS,
				       S6SEG9AIRPRESS,
				       S6SEG10AIRPRESS,
				       CRYSTALLORWATERENTEMP,
				       CRYSTALLORWATERPRESSURE,
				       CRYSTALLORWATERTOTALFLUX,
				       COOLINGWATERPRESSURE,
				       COOLINGWATERTEMPERATURE,
				       COOLINGWATERTOTALFLUX,
				       COOLINGWATERTOTALWASTAGE,
				       DEVICEWATERTOTALWASTAGE,
				       SLABTHICK,
				       SLABWIDTH,
				       MIDLADLETEMPERATURE,
				       BIGPOTTEMPERATURE,
				       TRACKINGLENGTH,
				       CUTTINGLENGTH,
				       ARM1BIGPOTTOTALWEIGHT,
				       ARM2BIGPOTTOTALWEIGHT,
				       LASTFRESHTIME,
				       MIDLADLEWEIGHT,
				       ISVALID,
				       OPERATOR,
				       OPTDATE,
				       S2CASTSPEED,
				       S3CASTSPEED,
				       S4CASTSPEED,
				       S5CASTSPEED
				  From (select *
				          from stl_ccm_f4sampling a
				         WHERE a.HEATNO = ? AND a.STATIONCODE = ? AND a.DISPOSALTIME = ?
				           and samplingid = (select Max(samplingid)
				                               from stl_ccm_f4sampling a
				                              WHERe a.HEATNO = ? AND a.STATIONCODE = ?
				                                AND a.DISPOSALTIME = ?)
				         ORDER BY SAMPLINGID DESC) t,
				       (select S1CRYSTALCODE,S2CRYSTALCODE, S3CRYSTALCODE,
				               S4CRYSTALCODE,S5CRYSTALCODE, S6CRYSTALCODE
				          from stl_ccm_mouldinfo t, stl_ccm_optinfo a
				         where t.mouldno = a.mouldno
				           and a.HEATNO = ? AND a.STATIONCODE = ? AND a.DISPOSALTIME =?) t1
	 ]]>	 
    </query>

   <query id="GetTundishTemp.Select" desc="获取中包温度信息   " fetchSize="10">
        <![CDATA[
		        select samplingid, samplingvalue, samplingdate
                  from stl_tempsampling
                 where (samplingname = 'TUNDISHTEMP1' or samplingname = 'TUNDISHTEMP2')
                   and heatno =? and stationcode = ? order by samplingid desc
	 ]]>	 
    </query>
    
    <query id="GetTankcarInfo.Select" desc="获取真空槽信息   " fetchSize="10">
        <![CDATA[
		        select  t.positionid ,(t.topid || '#-' || t.toptimes) TankcarInfo
				  from dev_zkc_use_detail t
				 where t.nowstatus = '1'
	 ]]>	 
    </query>
    
    <query id="GetGlobalMapIronInfo.Select" desc="获取总貌图铁水信息   " fetchSize="10">
        <![CDATA[
		       select t.LADLEID, t1.NOWPOSITION
			    from dev_ib_base_info t, DEV_IB_USE_DETAIL t1
				WHERE t.STATUS = '使用'
				   and t.ladleid = t1.ladleid
				   and t1.cycid =
				       (select max(cycid) from dev_ib_use_detail where ladleid = t.ladleid)
				 order by BEGINTIME


	 ]]>	 
    </query>
     <query id="GetInitIronPotInfo.Select" desc="获取铁包信息   " fetchSize="10">
        <![CDATA[
		       select LADLEID FROM DEV_IB_BASE_INFO ORDER BY TO_NUMBER(LADLEID)
	 ]]>	 
    </query>
    
    <query id="GetGlobalMapIronPotInfo.Select" desc="获取铁包对应铁水信息   " fetchSize="10">
        <![CDATA[
		    select t2.*,
		    	   t3.rswgt FGWEIGHT,
			       t3.stoveid,
			       t3.stovetime,
			       t3.tapholeno,
			       t3.tfpotid,
			       t3.tfpotwgt,
			       t3.irontemperature,
			       t3.arrivetime,
			       t3.bfirontemture,
			       t3.C,
			       t3.SI,
			       t3.MN,
			       t3.P,
			       t3.S,
			       t3.Asn,
       			   t3.Cu,
       			   t3.Cr,
       			   t3.Sn,
       			   t3.Ni,
       			   0 TI,
			       t3.HSTAPHOLETIME,
			       t4.hudwid,
			       t4.heatno,
			       t4.dfrstarttime,
			       t4.dfrendtime,
			       round(t4.leavewgt - t2.TAREWEIGHT, 1) leavewgt,
			       CASE
			         WHEN t4.molirnleave IS NOT NULL THEN
			          t4.molirnleave
			         WHEN substr(t3.MOLIRNSOURCE, 1, 1) = 'J' THEN
			          t3.MOLIRNSOURCE
			       END molirnleave,
			       t4.SWBTEMPERATURE,
			       CASE
			         when nvl(t4.LEAVEWGT, 0) > 0 and nvl(t4.ARRIVEWGT, 0) > 0 and
			              nvl(t4.LEAVEWGT, 0) < nvl(t4.ARRIVEWGT, 0) THEN
			          round(t3.TFPOTWGT - (nvl(t4.ARRIVEWGT, 0) - nvl(t4.LEAVEWGT, 0)),
			                2)
			         ELSE
			          t3.TFPOTWGT
			       END lblInHeatWgt
			  from (select t.ladleid,
			               t.age,
			               t.manufacturers,
			               t.TAREWEIGHT,
			               t1.nowposition,
			               t1.mistapholestarttime,
			               t1.hmparrivetime,
			               t1.hmpleavetime,
			               t1.inno,
			               t1.hmpno/*,
			               t.fgweight*/
			          from dev_ib_base_info t, dev_ib_use_detail t1
			         where t.ladleid = ?
			           and t.ladleid = t1.ladleid
			           and t1.cycid = (select max(cycid)
			                             from dev_ib_use_detail a
			                            where a.ladleid = t.ladleid)) t2
			  LEFT JOIN STL_MIS_IMPORTIRON T3 ON T2.INNO = T3.MISID
			  LEFT JOIN (SELECT *
			               from stl_hmp_optinfo
			             union
			             SELECT * from J#stl_hmp_optinfo) t4 on t2.hmpno = t4.hudwid

	 ]]>	 
    </query>
    <query id="GetGlobalMapIronPotChemInfo.Select" desc="获取铁包对应铁水成分信息   " fetchSize="10">
        <![CDATA[
		      SELECT CHECKNO,HEATNO,STATIONCODE,ASSAYTYPECODE,
				               C,SI,MN,P,S,TI,ASN,CU,CR,SN,Ni,ASSAYDATE
				  FROM (select CHECKNO,HEATNO,STATIONCODE,ASSAYTYPECODE,
				               C,SI,MN,P,S,TI,ASN,CU,CR,SN,Ni,ASSAYDATE
				          from stl_chemelement
				        union
				        select CHECKNO,HEATNO,STATIONCODE,ASSAYTYPECODE,
				               C,SI,MN,P,S,TI,ASN,CU,CR,SN,Ni,ASSAYDATE
				          from J#stl_chemelement) t3
				 WHERE T3.HEATNO IN (?, ?)
				 order by assaydate
	 ]]>	 
    </query>
    <query id="GetInitGBPotInfo.Select" desc="获取钢包信息   " fetchSize="10">
        <![CDATA[
		       select LADLEID FROM DEV_GB_BASE_INFO $ ORDER BY TO_NUMBER(LADLEID) 
	 ]]>	 
    </query>
    <query id="GetPotStatusInfo.Select" desc="获取钢包状态信息   " fetchSize="10">
        <![CDATA[
		       select LADLEID,STATUS NOWPOSITION,
		       (select OVENID from dev_toolfiringdetail where FIRINGID=hotno) OVENID 
		       FROM DEV_GB_BASE_INFO $ ORDER BY TO_NUMBER(LADLEID) 
	 ]]>	 
    </query>
</queryMap>