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; } }