XinYu_LG2MES/ServerSolution/WebRoot/WEB-INF/query - 副本/.svn/text-base/QueryCcmJob.xml.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="连铸机作业">
<query id="GetCcmPlanAndFactTime.Select" desc="查询作业计划时间与实际时间" fetchSize="10">
        <![CDATA[
		      select PLAN_CCM_STR_TIME,
				       PLAN_CCM_END_TIME,
				       BALESTARTTIME,
				       round(nvl(decode(BALEENDTIME,
				                        null,
				                        (sysdate - BALESTARTTIME) * 24 * 60,
				                        (BALEENDTIME - BALESTARTTIME) * 24 * 60),
				                 0)) REFINETIME,
				       decode(BALESTARTTIME,
				              null,
				              round((sysdate - PLAN_CCM_STR_TIME) * 24 * 60),
				              round((BALESTARTTIME - PLAN_CCM_STR_TIME) * 24 * 60)) SJYS
				  from ppc_steel_heat a, stl_ccm_optinfo b
				 where a.HeatNo = b.heatno
				   and a.HeatNo = ?
	 ]]>
    </query>
    
 <query id="GetCcmOptInfo.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,
				       CRYSTALLIZERID,
				       CRYSTALLIZERTIMES,
				       CRYSTALLIZERID2,
				       CRYSTALLIZERTIMES2,
				       CRYSTALLIZERID3,
				       CRYSTALLIZERTIMES3,
				       CRYSTALLIZERID4,
				       CRYSTALLIZERTIMES4,
				       CRYSTALLIZERID5,
				       CRYSTALLIZERTIMES5,
				       CRYSTALLIZERID6,
				       CRYSTALLIZERTIMES6,
				       BAKEO2TIEMS,
				       FLAG,
				       FBTOTALWGT,
				       HOTPITCH,
				       SAMPLINGTIME1,
				       SAMPLINGTIME2,
				       SAMPLINGTIME3,
				       SENDSMPTIME1,
				       SENDSMPTIME2,
				       SENDSMPTIME3,
				       SENDSMPOPTOR1,
				       SENDSMPOPTOR2,
				       SENDSMPOPTOR3,
				       CONFIRMFLAG,
				       CONFIRMOPTOR,
				       CONFIRMTIME,
				       PROTECTDTEG,
				       PROTECTDTEGDOSAGE,
				       RSMOLSTLWGT,
				       ISRS,
				       WSID,
				       OPTPERSONNEL,
				       UPDATETIME,
				       MEMO,
				       S1ZEROWGT,
					   S2ZEROWGT,
					   S1VERTICALWGT,
					   S2VERTICALWGT,
					   S1BENDWGT,
					   S2BENDWGT
				  FROM STL_CCM_OPTINFO
				 WHERE HEATNO = ?
				   AND STATIONCODE = ?
				   AND DISPOSALTIME = ?
	 ]]>
    </query>  
   <query id="GetSendSteelPotInfo.Select" desc="查询送钢钢包信息" fetchSize="10">
        <![CDATA[
		     select POTNO,POTDISTINCTION,POTWRAPSTATE from stl_bof_optinfo where heatno=?
	 ]]>
    </query>
    
    <query id="GetJobCcmF1SamplingInfo.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="GetJobCcmF2SamplingInfo.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="GetJobCcmF3SamplingInfo.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>
    
</queryMap>