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>
    
    <query id="frmCCM_Update.select" desc="连铸操作记录-修改" fetchSize="10">
        <![CDATA[
		     
		     UPDATE        stl_ccm_optinfo
		        set        optpersonnel = ?,
					       memo = ?,
					       watermeterno = ?,
					       coveringslag = ?,
					       arpre_s1 = ?,
					       arpre_s2 = ?,
					       upwaterpre_s1 = ?,
					       upwaterpre_s2 = ?,
					       waterchage_s1 = ?,
					       waterchage_s2 = ?,
					       liqfluct_s1 = ?,
					       liqfluct_s2 = ?,
					       closesteel = ?,
					       steelstick_s1 = ?,
					       steelstick_s2 = ?,
					       biasflow_s1 = ?,
					       biasflow_s2 = ?,
					       baleisdown = ?,
					       rhythmfast = ?,
					       tempt_high = ?,
					       tempt_low = ?,
					       notice_s1 = ?,
					       notice_s2 = ?,
					       jjqslkn_s1 = ?,
					       jjqslkw_s1 = ?,
					       jjqslzz_s1 = ?,
					       jjqslzy_s1 = ?,
					       jjqswckn_s1 = ?,
					       jjqswckw_s1 = ?,
					       jjqswczz_s1 = ?,
					       jjqswczy_s1 = ?,
					       jjqslkn_s2 = ?,
					       jjqslkw_s2 = ?,
					       jjqslzz_s2 = ?,
					       jjqslzy_s2 = ?,
					       jjqswckn_s2 = ?,
					       jjqswckw_s2 = ?,
					       jjqswczz_s2 = ?,
					       jjqswczy_s2 = ?,
					       billetcondition = ?,
					       midwgt_min = ?,
					       billetsection = ?,
						   billetsection2 = ?,
						   crystallizertimes6 = ?,
						   pfbalewgt = ?,
						   baleleavewgt = ?,
						   width_s1 = ?,
						   width_s2 = ?,
						   isaddtop = ?,
						   tempt_max = ?,
						   tempt_min = ?,
						   lasu_max = decode(?,null,lasu_max,lasu_max),/*2021-07-05 李强要求拉速不能修改*/
						   lasu_min = decode(?,null,lasu_min,lasu_min),
						   shiftcode = ?,
						   plansteel = ?,
						   lasu2_max = decode(?,null,lasu2_max,lasu2_max),
						   lasu2_min = decode(?,null,lasu2_min,lasu2_min),
						   crystallizerid = ?, 
						   crystallizerid2 = ?, 
						   crystallizerid3 = ?, 
						   crystallizerid4 = ?,
						   mouldnumid = ?,
						   heat_seq = ?,
						   s1_jjq_wgt = ?, 
						   s2_jjq_wgt = ?, 
						   s1zerowgt = ?, 
						   s2zerowgt = ?,
						   s1verticalwgt = ?,
						   s1bendwgt = ?,
						   tg_fac = ?,
						   sk_fac = ?，
						   JCDJ = ?，
						   MWRAPTNO = ?,
						   S1_ALERT = ?,
						   S2_ALERT = ?,
						   RESIDUETHICKNESS = ?
				  WHERE heatno = ?
 
        ]]>
	</query>
	
	<query id="frmCCM_Query.select" desc="连铸机操作记录-查询" fetchSize="10">
        <![CDATA[
		     
		     select * from stl_ccm_optinfo WHERE heatno = ?
 
        ]]>
	</query>
	
	<query id="frmCCM_Update2.select" desc="连铸操作记录-修改2" fetchSize="10">
        <![CDATA[
		     
		     UPDATE        j#stl_ccm_optinfo
		        set        optpersonnel = ?,
					       memo = ?,
					       watermeterno = ?,
					       coveringslag = ?,
					       arpre_s1 = ?,
					       arpre_s2 = ?,
					       upwaterpre_s1 = ?,
					       upwaterpre_s2 = ?,
					       waterchage_s1 = ?,
					       waterchage_s2 = ?,
					       liqfluct_s1 = ?,
					       liqfluct_s2 = ?,
					       closesteel = ?,
					       steelstick_s1 = ?,
					       steelstick_s2 = ?,
					       biasflow_s1 = ?,
					       biasflow_s2 = ?,
					       baleisdown = ?,
					       rhythmfast = ?,
					       tempt_high = ?,
					       tempt_low = ?,
					       notice_s1 = ?,
					       notice_s2 = ?,
					       jjqslkn_s1 = ?,
					       jjqslkw_s1 = ?,
					       jjqslzz_s1 = ?,
					       jjqslzy_s1 = ?,
					       jjqswckn_s1 = ?,
					       jjqswckw_s1 = ?,
					       jjqswczz_s1 = ?,
					       jjqswczy_s1 = ?,
					       jjqslkn_s2 = ?,
					       jjqslkw_s2 = ?,
					       jjqslzz_s2 = ?,
					       jjqslzy_s2 = ?,
					       jjqswckn_s2 = ?,
					       jjqswckw_s2 = ?,
					       jjqswczz_s2 = ?,
					       jjqswczy_s2 = ?,
					       billetcondition = ?,
					       midwgt_min = ?,
					       billetsection = ?,
						   billetsection2 = ?,
						   crystallizertimes6 = ?,
						   pfbalewgt = ?,
						   baleleavewgt = ?,
						   width_s1 = ?,
						   width_s2 = ?,
						   isaddtop = ?,
						   tempt_max = ?,
						   tempt_min = ?,
						   lasu_max = decode(?,null,lasu_max,lasu_max),
						   lasu_min = decode(?,null,lasu_min,lasu_min),
						   shiftcode = ?,
						   plansteel = ?,
						   lasu2_max = decode(?,null,lasu2_max,lasu2_max),
						   lasu2_min = decode(?,null,lasu2_min,lasu2_min),
						   crystallizerid = ?, 
						   crystallizerid2 = ?, 
						   crystallizerid3 = ?, 
						   crystallizerid4 = ?,
						   mouldnumid = ?,
						   heat_seq = ?,
						   s1_jjq_wgt = ?, 
						   s2_jjq_wgt = ?, 
						   s1_ld_wgt = ?, 
						   s2_ld_wgt = ?,
						   s1_czld_wgt = ?,
						   s1_wqld_wgt = ?,
						   tg_fac = ?,
						   sk_fac = ?,
						   JCDJ = ?,
						   MWRAPTNO = ?,
						   S1_ALERT = ?,
						   S2_ALERT = ?,
						   RESIDUETHICKNESS = ?
				  WHERE heatno = ?
 
        ]]>
	</query>
	
	<query id="frmCut_Query.select" desc="连铸机切割记录-查询" fetchSize="10">
        <![CDATA[
		     
		     select slab_no,
			        heatno,
			        bc bz,
			        bb,
			        optpersonnel,
			        plansteel,
			        billetsection_s1,
			        billetsection_s2,
			        billetfixsize_s1,
			        billetfixsize_s2,
			        orderno1,
			        balestarttime,
			        baleendtime,
			        steelwgt,
			        cutingdate,
			        orderno2,
		            case when substr(slab_no,11,1)<5 then substr(slab_no,11,3) end xuhao1,
		            case when substr(slab_no,11,1)>4 then substr(slab_no,11,3) end xuhao2
			   from stl_ccm_cutting
			  where slab_no like ?||'%'
			    and stationcode = ?
                and to_char(cutingdate,'yyyy-MM-dd') between ? and ? 
              order by slab_no 
        ]]>
	</query>
	
	<query id="getHeatnoCcm_Query.select" desc="获取连铸机炉号" fetchSize="10">
        <![CDATA[
		     
		     select heatprocessno,
		            heatno,
			       (select max(sum_s1) sum_s1 from stl_ccm_cutting where heatno=t.heatno)sum_s1, 
			       (select max(sum_s2) sum_s2 from stl_ccm_cutting where heatno=t.heatno)sum_s2
			  FRom (select *
			          FRom stl_ccm_optinfo 
			         where stationcode = ?
			           and to_char(optdate, 'yyyy-MM-dd') between ? and ?
			        union
			        select *
			          FRom j#stl_ccm_optinfo
			         where stationcode = ?
			           and to_char(optdate, 'yyyy-MM-dd') between ? and ?) t
			 order by optdate desc
        ]]>
	</query>
	
	<query id="frmCUT_Update.select" desc="修改切割信息" fetchSize="10">
        <![CDATA[
		     
		     update stl_ccm_cutting
			   set optpersonnel = ?,
			       heatno = ?,
			       plansteel = ?,
			       billetfixsize_s1 = ?,
			       billetfixsize_s2 = ?,
			       orderno1 = ?,
			       orderno2 = ?
			 where slab_no = ?
        ]]>
	</query>
	
	<query id="frmWidthGauge.select" desc="测宽仪数据查询" fetchSize="10">
        <![CDATA[
		     SELECT DECODE(T.CCMID,'6',(DECODE(SUBSTR(T.BILLETNO, 11, 1), '0', '1', '2')),'5',(DECODE(SUBSTR(T.BILLETNO, 11, 1), '0', '3', '4'))) STRANDNO,
		     T1.BILLETSECTION,T1.BILLETSECTION2,T.* 
		     FROM (SELECT * FROM STL_CCM_WIDTHGAUGE UNION SELECT * FROM J#STL_CCM_WIDTHGAUGE) T
		     LEFT JOIN (SELECT * FROM STL_CCM_OPTINFO UNION SELECT * FROM J#STL_CCM_OPTINFO) T1 ON T.HEATNO = T1.HEATNO AND T1.STATIONCODE = DECODE(T.CCMID,'6','01','5','02')
		      $ order by t.createtime desc

        ]]>
	</query>
    
</queryMap>