XinYu_RZMES/.svn/pristine/dd/dd448c14032fb33824a7119ac740f237e3fe19c0.svn-base

package xin.glue.ui.D.D03;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.vo.PosParameter;

public class CustomSaveMatDnRst extends PosActivity {

	public String runActivity(PosContext context) {

		getDao("mesdao").delete("UID030020.MatDnRst.All.Delete");

		String[]    sDb_MatSpecSeq          =    (String[])context.get("MAT_SPEC_SEQ"    ) ; //MAT_SPEC_SEQ        재료사양일련번호
		String[]    sDb_PmatSpecSeq         =    (String[])context.get("PMAT_SPEC_SEQ"   ) ; //PMAT_SPEC_SEQ       모재료사양일련번호
		String[]    sDb_MatTp               =    (String[])context.get("MAT_TP"          ) ; //MAT_TP              재료구분(01:CAST 02:CHARGE 03:SLAB 04:SLAB-D)
		String[]    sDb_ExpMatNo            =    (String[])context.get("EXP_MAT_NO"      ) ; //EXP_MAT_NO          예정재료번호(예정CAST번호,예정CHARGE번호,예정SLAB번호)
		String[]    sDb_WithinSubSeq        =    (String[])context.get("WITHIN_SUB_SEQ"  ) ; //WITHIN_SUB_SEQ      모재료내자재료순서
		String[]    sDb_CmatCnt             =    (String[])context.get("CMAT_CNT"        ) ; //CMAT_CNT            자재료개수
		String[]    sDb_FacStlGrd           =    (String[])context.get("FAC_STL_GRD"     ) ; //FAC_STL_GRD         사내강호
		String[]    sDb_FacStlGrp           =    (String[])context.get("FAC_STL_GRP"     ) ; //FAC_STL_GRP         사내강호그룹
		String[]    sDb_MatRt               =    (String[])context.get("MAT_RT"          ) ; //MAT_RT              재료행선(H:열연 P:후판)
		String[]    sDb_TreatRtCd           =    (String[])context.get("TREAT_RT_CD"     ) ; //TREAT_RT_CD         처리경로코드
		String[]    sDb_PathProcCd          =    (String[])context.get("PATH_PROC_CD"    ) ; //PATH_PROC_CD        제강통과공정
		String[]    sDb_LineProcCd          =    (String[])context.get("LINE_PROC_CD"    ) ; //LINE_PROC_CD        제강통과공정라인
		String[]    sDb_MatThk              =    (String[])context.get("MAT_THK"         ) ; //MAT_THK             재료두께
		String[]    sDb_MatWth              =    (String[])context.get("MAT_WTH"         ) ; //MAT_WTH             재료폭
		String[]    sDb_MatLen              =    (String[])context.get("MAT_LEN"         ) ; //MAT_LEN             재료길이
		String[]    sDb_MatLenMin           =    (String[])context.get("MAT_LEN_MIN"     ) ; //MAT_LEN_MIN         재료길이<최소>
		String[]    sDb_MatLenMax           =    (String[])context.get("MAT_LEN_MAX"     ) ; //MAT_LEN_MAX         재료길이<최대>
		String[]    sDb_MatWgt              =    (String[])context.get("MAT_WGT"         ) ; //MAT_WGT             재료중량
		String[]    sDb_CcmTermTime         =    (String[])context.get("CCM_TERM_TIME"   ) ; //CCM_TERM_TIME       주조시간(주조시간 = 예정주조완료일시 - 예정주조개시일시:분단위)
		String[]    sDb_WidChgFl            =    (String[])context.get("WID_CHG_FL"      ) ; //WID_CHG_FL          폭변경여부(Y/N Default:N)
		String[]    sDb_HcrYn               =    (String[])context.get("HCR_YN"          ) ; //HCR_YN              HCR구분(LG_CD = 'E01012')
		String[]    sDb_EmgmtrYn            =    (String[])context.get("EMGMTR_YN"       ) ; //EMGMTR_YN           긴급재여부(LG_CD = 'E01011')
		String[]    sDb_SmsDuedate          =    (String[])context.get("SMS_DUEDATE"     ) ; //SMS_DUEDATE         제강기한일(YYYYMMDD)
		String[]    sDb_PrcLine             =    (String[])context.get("PRC_LINE"        ) ; //PRC_LINE            전로호기
		String[]    sDb_CcmPrcLine          =    (String[])context.get("CCM_PRC_LINE"    ) ; //CCM_PRC_LINE        연주기번호
		String[]    sDb_ProgCd              =    (String[])context.get("PROG_CD"         ) ; //PROG_CD             진도코드(재료구분=01이면 JBA:BOF작업지시대기로 설정, 나머진 NULL)
		String[]    sDb_SlabCutSeq          =    (String[])context.get("SLAB_CUT_SEQ"    ) ; //SLAB_CUT_SEQ        SLAB전단순서
		String[]    sDb_DsgRate             =    (String[])context.get("DSG_RATE"        ) ; //DSG_RATE            설계실수율
		String[]    sDb_OverRollYn          =    (String[])context.get("OVER_ROLL_YN"    ) ; //OVER_ROLL_YN        OVERROLL여부(Y/N)
		String[]    sDb_SampleCut           =    (String[])context.get("SAMPLE_CUT"      ) ; //SAMPLE_CUT          SLABSAMPLE여부(Y/N)
		String[]    sDb_OrdFl               =    (String[])context.get("ORD_FL"          ) ; //ORD_FL              주여구분(1:주문재 2:여재)
		String[]    sDb_OrdNo               =    (String[])context.get("ORD_NO"          ) ; //ORD_NO              주문공통
		String[]    sDb_OrdSeq              =    (String[])context.get("ORD_SEQ"         ) ; //ORD_SEQ             주문행번
		String[]    sDb_DelvReqDate         =    (String[])context.get("DELV_REQ_DATE"   ) ; //DELV_REQ_DATE       납기일자(YYYYMMDD)
		String[]    sDb_SpmProcYn           =    (String[])context.get("SPM_PROC_YN"     ) ; //SPM_PROC_YN         SKINPASS지정유무(Y/N)
		String[]    sDb_ScarpingProcYn      =    (String[])context.get("SCARPING_PROC_YN") ; //SCARPING_PROC_YN    SCARPING지정유무(Y/N)
		String[]    sDb_SendSts             =    (String[])context.get("SEND_STS"        ) ; //SEND_STS            전송상태(01:지시대기 02:전송대기 03:전송완료)
		String[]    sDb_CombYn              =    (String[])context.get("COMB_YN"         ) ; //COMB_YN             조합여부(Y/N)
		String[]    sDb_CoilThk             =    (String[])context.get("COIL_THK"        ) ; //COIL_THK            코일두께(단위:mm)
		String[]    sDb_CoilWth             =    (String[])context.get("COIL_WTH"        ) ; //COIL_WTH            코일폭(단위:mm)
		String[]    sDb_CoilLen             =    (String[])context.get("COIL_LEN"        ) ; //COIL_LEN            코일길이(단위:mm 열연:미사용)
		String[]    sDb_CoilWgt             =    (String[])context.get("COIL_WGT"        ) ; //COIL_WGT            코일중량(단위:kg)
		String[]    DSN_SLAB_NO             =    (String[])context.get("DSN_SLAB_NO"     ) ; //DSN_SLAB_NO         겼툰뵀
		String[]    P_DSN_SLAB_NO           =    (String[])context.get("P_DSN_SLAB_NO"   ) ; //P_DSN_SLAB_NO       莉북겼툰뵀
		String[]    GRAVITY   =    (String[])context.get("GRAVITY"   ) ;
		String[]    AUTODSN_YN  =    (String[])context.get("AUTODSN_YN"   ) ;
		String[]    COIL_INDIA  =    (String[])context.get("COIL_INDIA"   ) ;
		String[]    COIL_OUTDIA  =    (String[])context.get("COIL_OUTDIA"   ) ;
		
		String[]    sDb_Spec_Req_Desc             =    (String[])context.get("SPEC_REQ_DESC"        ) ; //COIL_WGT  
		
		PosParameter param = null;
		PosParameter param2 = null;
		int	iRows	=	sDb_MatSpecSeq.length;

		for(int i = 0; i < iRows; i++) {

			if(!"".equals(sDb_OrdNo[i]) && !"".equals(sDb_OrdSeq[i])){
				sDb_OrdFl[i] = "1";
			}else{
				sDb_OrdFl[i] = "2";
			}
			param = new PosParameter();

			param.setValueParamter(  0, sDb_MatSpecSeq[i]     );
			param.setValueParamter(  1, sDb_PmatSpecSeq[i]    );
			param.setValueParamter(  2, sDb_MatTp[i]          );
			param.setValueParamter(  3, sDb_ExpMatNo[i]       );
			param.setValueParamter(  4, sDb_WithinSubSeq[i]   );
			param.setValueParamter(  5, sDb_CmatCnt[i]        );
			param.setValueParamter(  6, sDb_FacStlGrd[i]      );
			param.setValueParamter(  7, sDb_FacStlGrp[i]      );
			param.setValueParamter(  8, sDb_MatRt[i]          );
			param.setValueParamter(  9, sDb_TreatRtCd[i]      );
			param.setValueParamter( 10, sDb_PathProcCd[i]     );
			param.setValueParamter( 11, sDb_LineProcCd[i]     );
			param.setValueParamter( 12, sDb_MatThk[i]         );
			param.setValueParamter( 13, sDb_MatWth[i]         );
			param.setValueParamter( 14, sDb_MatLen[i]         );
			param.setValueParamter( 15, sDb_MatLenMin[i]      );
			param.setValueParamter( 16, sDb_MatLenMax[i]      );
			param.setValueParamter( 17, sDb_MatWgt[i]         );
			param.setValueParamter( 18, sDb_CcmTermTime[i]    );
			param.setValueParamter( 19, sDb_WidChgFl[i]       );
			param.setValueParamter( 20, sDb_HcrYn[i]          );
			param.setValueParamter( 21, sDb_EmgmtrYn[i]       );
			param.setValueParamter( 22, sDb_SmsDuedate[i]     );
			param.setValueParamter( 23, sDb_PrcLine[i]        );
			param.setValueParamter( 24, sDb_CcmPrcLine[i]     );
			param.setValueParamter( 25, sDb_ProgCd[i]         );
			param.setValueParamter( 26, sDb_SlabCutSeq[i]     );
			param.setValueParamter( 27, sDb_DsgRate[i]        );
			param.setValueParamter( 28, sDb_OverRollYn[i]     );
			param.setValueParamter( 29, sDb_SampleCut[i]      );
			param.setValueParamter( 30, sDb_OrdFl[i]          );
			param.setValueParamter( 31, sDb_OrdNo[i]          );
			param.setValueParamter( 32, sDb_OrdSeq[i]         );
			param.setValueParamter( 33, sDb_DelvReqDate[i]    );
			param.setValueParamter( 34, sDb_SpmProcYn[i]      );
			param.setValueParamter( 35, sDb_ScarpingProcYn[i] );
			param.setValueParamter( 36, sDb_SendSts[i]        );
			param.setValueParamter( 37, sDb_CombYn[i]         );
			param.setValueParamter( 38, sDb_CoilThk[i]        );
			param.setValueParamter( 39, sDb_CoilWth[i]        );
			param.setValueParamter( 40, sDb_CoilLen[i]        );
			param.setValueParamter( 41, sDb_CoilWgt[i]        );
			param.setValueParamter( 42, DSN_SLAB_NO[i]        );
			param.setValueParamter( 43, P_DSN_SLAB_NO[i]      );
			param.setValueParamter( 44, GRAVITY[i]            );
			param.setValueParamter( 45, AUTODSN_YN[i]         );
			param.setValueParamter( 46, COIL_INDIA[i]         );
			param.setValueParamter( 47, COIL_OUTDIA[i]        );
			param.setValueParamter( 48, sDb_Spec_Req_Desc[i]        );
			
			if(!"".equals(DSN_SLAB_NO[i]))
			{
				param2 = new PosParameter();
				param2.setWhereClauseParameter(0, "03");
				param2.setWhereClauseParameter(1, DSN_SLAB_NO[i]);
				getDao("mesdao").update("UID030020.SlabDnObj2.Update", param2);
			}
			
			getDao("mesdao").insert("UID030020.MatDnRst.Row.Insert", param);
		}

		getDao("mesdao").delete("UID030020.SlabDnRst.Rows.Delete");

		//return PosBizControlConstants.FAILURE;
		return PosBizControlConstants.SUCCESS;
	}

}