XinYu_RZMES/.svn/pristine/74/74762eef5e86cfaacce8d7f0132c74e34e56c290.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
  <query id="UIG03COMM_INTI_CHARGE.select" desc="获得待机结晶器信息">
      <![CDATA[
	   SELECT LD_GRADE FROM TBG03_LADLE_PROG  WHERE LD_NO = ?
        ]]>  
  </query>
  <query id="UIG03COMM_LADLE_PROG_LDINFO.select" desc="获得待机结晶器信息">
      <![CDATA[
		  SELECT LD_ACCESSORY,LD_FAC,LD_TQ_FAC
			FROM TBG03_LADLE_PROG
			WHERE LD_NO = ?
        ]]>  
  </query>
  <query id="UIG03COMM_CHARGE_STATION_01.select" desc="获得待机结晶器信息">
      <![CDATA[
		  SELECT A.CHARGE_NO,B.LD_NO FROM TBG03_SMS_TRACKING A
                			 ,TBG02_CHARGE_COMM B
			 WHERE A.CHARGE_NO = B.CHARGE_NO
			 AND   A.TREAT_CD = ?
			 AND   B.LD_NO IS NOT NULL
        ]]>  
  </query>		
  <query id="UIG03COMM_LADLE_PROG_LDFAC.update" desc="获得待机结晶器信息">
      <![CDATA[
		  UPDATE TBG03_LADLE_PROG 
		  SET    LD_ACCESSORY = ?
				 ,LD_FAC = ?
				 ,LD_TQ_FAC  = ?
		  WHERE LD_NO = ?    
        ]]>  
  </query>
  <query id="UIG03COMM_CHARGE_COMM_SENDLD.update" desc="  ">
      <![CDATA[
		  update tbg02_charge_comm 
           set ld_no = ?
        ,ld_in_dtime = to_char(sysdate,'yyyymmddhh24miss')
		  where charge_no = (select charge_no from tbg03_sms_tracking where treat_cd = ?)
        ]]>  
  </query>
  <query id="UIG03COMM_LADLE_PROG_SENDLD.update" desc="  ">
      <![CDATA[
		  UPDATE TBG03_LADLE_PROG SET CURR_CHARGE_NO = (SELECT T.CHARGE_NO FROM TBG03_SMS_TRACKING T WHERE T.TREAT_CD = ?)
									   ,LD_CUR_LOC = Decode(?,'B1','BOF1','B2','BOF2','B3','BOF3')
									   ,LD_GRADE = ?
									   ,BOF_IN_DTIME  = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
									   ,REG_PGM_ID = 'UIG030041'
									   ,REG_ID = 'ADMIN'
									   ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
									   ,LD_STAT = '1'
									   ,CCM_DEP_DTIME = ''
		  WHERE LD_NO = ?
        ]]>  
  </query>	
  <query id="UIG03COMM_CHARGE_COMM_SENDLD_02.update" desc="  ">
      <![CDATA[
		  UPDATE TBG02_CHARGE_COMM 
           SET LD_NO = ''
          ,LD_IN_DTIME = ''
          WHERE CHARGE_NO = (SELECT CURR_CHARGE_NO FROM TBG03_LADLE_PROG WHERE LD_NO = ?)
        ]]>  
  </query>
  <query id="UIG03COMM_LADLE_PROG_SENDLD_02.update" desc="  ">
      <![CDATA[
		  UPDATE TBG03_LADLE_PROG SET CURR_CHARGE_NO = ''
									   ,LD_CUR_LOC = 'WTAR'
									   ,LD_GRADE = ''
									   ,BOF_IN_DTIME  = ''
									   ,REG_PGM_ID = ''
									   ,REG_ID = ''
									   ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
									   ,LD_STAT = '1'
									   ,CCM_DEP_DTIME = ''
		  WHERE LD_NO = ?
        ]]>  
  </query>	
  <query id="UIG03COMM_LADLE_PROG_LDINFO.update" desc="  ">
      <![CDATA[
		  UPDATE TBG03_LADLE_PROG  SET  ld_cur_form_bdlg = ?
                               ,ld_cur_form_bkjz_yn = ?
                               ,ld_cur_form_bkdz = ?
		  WHERE LD_NO = ? 
        ]]>  
  </query>
	<query id="UIG03COMM_LADLE_PROG_HKINFO.update" desc="  ">
      <![CDATA[
		  UPDATE TBG03_LADLE_PROG  SET  
                               LD_ROAST_STAT_DTIME = ?
                               ,LD_ROAST_END_DTIME = ?
                               ,LD_ROAST_STATION_ID = ?
							   ,LD_CUR_LOC = ?
		  WHERE LD_NO = ? 
        ]]>  
  </query>
  <query id="UIG03COMM_LADLE_PROG_LDSTAT.update" desc="  ">
      <![CDATA[
			update tbg03_ladle_prog   T
			set ld_stat = ?
				,ld_roast_end_dtime = ''
			    ,ld_roast_stat_dtime = ''
          ,T.LD_ROAST_STATION_ID = ''
          ,T.LD_CUR_LOC = 'WTAR'
            ,ccm_dep_dtime = ''
			where ld_no = ? 
        ]]>  
  </query>	
  <query id="UIG03COMM_HK_TIME.update" desc="  ">
      <![CDATA[
			update tbg03_ladle_prog   t
      	set LD_ROAST_STAT_DTIME = ''
				  ,ld_roast_end_dtime = ''
			  ,t.ld_grade = ?
			  ,t.ld_stat = ?
			
			where ld_no = ? 
        ]]>  
  </query>		
  <query id="UIG03COMM_SEARCHLDGRADE_LDNO.SELECT" desc="  ">
      <![CDATA[
			SELECT LD_NO,LD_ROAST_END_DTIME,LD_GRADE FROM TBG03_LADLE_PROG
        ]]>  
  </query>
  <query id="UIG03COMM_SEARCHLDGRADE_LDNO_02.SELECT" desc="  ">
      <![CDATA[
			SELECT LD_NO,LD_GRDAE FROM TBG03_LADLE_PROG 
		    WHERE LD_NO = ?
        ]]>  
  </query>
  <query id="UIG03COMM_SEARCHLDGRADE_LDNO_03.SELECT" desc="  ">
      <![CDATA[
			SELECT C.CCM_DEP_DTIME,DECODE(T.PROC_CD,'B1','BOF1','B2','BOF2','B3','BOF3','C1','CAS1','C2','CAS2','C3','CAS3','L1','LF01','L2','LF02','R1','RH01','R2','RH02','J1','CCM1','J2','CCM2','J3','CCM3')PROC_CD
			FROM TBG03_STLMAKE_PROG T
				 ,(SELECT MAX(TREAT_DTIME)TREAT_DTIME FROM TBG03_STLMAKE_PROG 
						  WHERE CHARGE_NO = (SELECT CURR_CHARGE_NO FROM TBG03_LADLE_PROG WHERE LD_NO = ?)
				  )B
			,TBG03_LADLE_PROG C 
			WHERE T.CHARGE_NO = (SELECT CURR_CHARGE_NO FROM TBG03_LADLE_PROG WHERE LD_NO = ?)
			AND   T.TREAT_DTIME = B.TREAT_DTIME --   AND   C.LD_NO = T.LD_NO(+)
			AND   C.LD_NO = ?
			AND   ROWNUM = '1' 
        ]]>  
  </query>	
  <query id="UIG03COMM_LST_PROC.update" desc="  ">
      <![CDATA[
			UPDATE TBG03_LADLE_PROG 
			SET LD_CUR_LOC = ?
				,LD_GRADE = ?
			WHERE LD_NO = ?
        ]]>  
  </query>			
</queryMap>