XinYu_LZMES/.svn/pristine/47/4785495075ecadec4517c6069a45b88e80dbbb48.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="成品库入库管理">
	<query id="UIM010202_01.SELECT"  desc="查询成品库待入库钢卷信息">
		<![CDATA[
		SELECT A.COIL_NO,
       A.SPEC_STL_GRD,
       to_char(A.COIL_THK, 'FM990.099') || '*' || A.COIL_WTH T_W,
       to_char(A.INSTR_COIL_THK, 'FM990.099') || '*' || A.INSTR_COIL_WTH IT_IW,
       A.ORD_NO,
       A.ORD_SEQ,
       A.COIL_LEN,
       A.ACT_WGT,
       A.CAL_WGT,
       DECODE(A.CUR_PROG_CD,
              'CAB',
              '中间库入库待机',
              'CRC',
              '中间库充当待机',
              'CCA',
              '连退指示待机',
              'CCB',
              '连退作业待机',
              'CCC',
              '连退卷取待机',
              'DBA',
              '重卷指示待机',
              'DBB',
              '重卷作业待机',
              'DCA',
              '包装指示待机',
              'DCB',
              '包装作业待机',
              'DED',
              '综合判定待机',
              'DFA',
              '发货指示待机',
              'DFB',
              '发货待机',
              'DFF',
              '发货完成') CUR_PROG_CD,
       DECODE(A.TOT_DEC_GRD,
              '1',
              '合格',
              '2',
              '不合格',
              '3',
              '次品',
              '4',
              '废品',
              '',
              '待判定') TOT_DEC_GRD,
       DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL,
       /*DECODE(A.COIL_STAT,'1','未入库','2','在库','3','出库/结束',null)*/
       (CASE
         WHEN A.COIL_STAT = '1' THEN
          '未入库'
         WHEN A.COIL_STAT = '2' AND A.CUR_LOAD_LOC IS NULL THEN
          '未入库'
         WHEN A.COIL_STAT = '2' AND A.CUR_LOAD_LOC IS NOT NULL THEN
          '在库'
         WHEN A.COIL_STAT = '3' THEN
          '出库/结束'
       END) COIL_STAT
  FROM C_TBL02_COIL_COMM A
 WHERE A.COIL_NO = ?
 and a.coil_stat='2'
		 ]]>
	</query>
		<query id="UIM010202_02.SELECT"  desc="查询缓存区的钢卷">
		<![CDATA[
		SELECT 'FALSE' CHK,
       T.OLD_SAMPL_NO COIL_NO,
       T.COIL_THK THICK,
       T.COIL_WTH WIDTH,
       T.COIL_LEN LENGTH,
       T.ACT_WGT WEIGHT,
       T.SPEC_STL_GRD,
       DECODE(t.CUR_PROG_CD,
              'CAB',
              '中间库入库待机',
              'CRC',
              '中间库充当待机',
              'CCA',
              '连退指示待机',
              'CCB',
              '连退作业待机',
              'CCC',
              '连退卷取待机',
              'DBA',
              '重卷指示待机',
              'DBB',
              '重卷作业待机',
              'DCA',
              '包装指示待机',
              'DCB',
              '包装作业待机',
              'DED',
              '综合判定待机',
              'DFA',
              '发货指示待机',
              'DFB',
              '发货待机',
              'DFF',
              '发货完成') CUR_PROG_CD,
       T.ORD_NO,
       T.ORD_SEQ,
       C_PKG_UIM.GET_STDDATESTR(T.MILL_DTIME) PRODUCTED_TIME
  FROM C_TBL02_COIL_COMM T
 WHERE T.COIL_STAT = '3'
   AND T.OUT_YARD_KIND='4'
		 ]]>
	</query>
	<query id="UIM010202_01.update" desc="出库操作" fetchSize="10">
        <![CDATA[
			update c_tbl02_coil_comm t
   					set t.COIL_STAT     = '3',
   						t.CUR_LOAD_LOC  = '',
       					t.OUT_YARD_KIND = '4', --移库进缓存区
       					t.TRNF_SHIFT    = ?,
       					t.TRNF_GROUP    = ?,
       					t.TRNF_DTIME    = ?,
       					t.TRNF_REG      = ?
 				where t.COIL_NO = ?
        ]]>
    </query>
</queryMap>