package xin.glue.ui.D.D01; 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 FinishSlabDesignRst extends PosActivity { public String runActivity(PosContext context) { // TODO Auto-generated method stub String[] rowStatus1 = (String[])context.get("rowStatus1" ) ; String[] rowStatus2 = (String[])context.get("rowStatus2" ) ; logger.logInfo("Here is FinishSlabDesignRst.java!!!"); //1.설계된 슬라브 정보를 화면으로부터 변경한 후 저장하고자 할 때 사용한다. // - 설계대상주문TBL의 설계상태='2'(설계완료) // - 설계결과TBL에 변경내용을 갱신 String[] CHK_FG1 = (String[])context.get("CHK_FG1" ) ; String[] sDb_OrdNo = (String[])context.get("ORD_NO" ) ; //ORD_NO 주문번호('41':열연+주문접수년월:YYYYMM+접수SEQ:9999) String[] sDb_OrdSeq = (String[])context.get("ORD_SEQ" ) ; //ORD_SEQ 주문행번(3자리) String[] sDb_NeedWgt = (String[])context.get("NEED_WGT" ) ; String[] sDb_DsnProcStat = (String[])context.get("DSN_PROC_STAT" ) ; String[] sDb_DsnProcYn = (String[])context.get("DSN_PROC_YN" ) ; String[] sDb_DsnErrDesc = (String[])context.get("DSN_ERR_DESC" ) ; String[] sDb_HcrClf = (String[])context.get("HCR_CLF" ) ; // TBD01_SLABDN_RST(UID010031.xrw's datagrid : dg2) //String[] CHK_FG2 = (String[])context.get("CHK_FG2" ) ; String[] sDb_DsnSlabNo = (String[])context.get("DSN_SLAB_NO" ) ; //DSN_SLAB_NO 설계SLAB일련번호 String[] sDb_PDsnSlabNo = (String[])context.get("P_DSN_SLAB_NO" ) ; //P_DSN_SLAB_NO 모설계SLAB일련번호 //String[] sDb_OrdNo = (String[])context.get("ORD_NO" ) ; //ORD_NO 주문번호('41':열연+주문접수년월:YYYYMM+접수SEQ:9999) //String[] sDb_OrdSeq = (String[])context.get("ORD_SEQ" ) ; //ORD_SEQ 주문행번(3자리) String[] sDb_SlabThk = (String[])context.get("SLAB_THK" ) ; //SLAB_THK SLAB두께(단위:mm) String[] sDb_SlabWth = (String[])context.get("SLAB_WTH" ) ; //SLAB_WTH SLAB폭(단위:mm) String[] sDb_SlabLen = (String[])context.get("SLAB_LEN" ) ; //SLAB_LEN SLAB길이(단위:mm) String[] sDb_SlabWgt = (String[])context.get("SLAB_WGT" ) ; //SLAB_WGT SLAB중량(단위:kg) String[] sDb_SlabTrmthTp = (String[])context.get("SLAB_TRMTH_TP" ) ; //SLAB_TRMTH_TP SLAB손질방법(TBZ00_COMMCD's LG_CD='D01005') String[] sDb_Gravity = (String[])context.get("GRAVITY" ) ; //GRAVITY 비중(단위:0.00) String[] sDb_AutodsnYn = (String[])context.get("AUTODSN_YN" ) ; //AUTODSN_YN 자동설계여부(Y/N) String[] sDb_CoilPackWgtMin = (String[])context.get("COIL_PACK_WGT_MIN") ; //COIL_PACK_WGT_MIN 코일포장단중[하한](단위:kg) String[] sDb_CoilPackWgtMax = (String[])context.get("COIL_PACK_WGT_MAX") ; //COIL_PACK_WGT_MAX 코일포장단중[상한](단위:kg) String[] sDb_FacStlGrd = (String[])context.get("FAC_STL_GRD" ) ; //FAC_STL_GRD 사내강호 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[] sDb_ProcPath = (String[])context.get("PROC_PATH" ) ; //PROC_PATH 통과공정(구분자:'>') String[] sDb_HcrYn = (String[])context.get("HCR_YN" ) ; //HCR_YN HCR지정여부(Y/N) String[] sDb_EmgmtrYn = (String[])context.get("EMGMTR_YN" ) ; //EMGMTR_YN 긴급재여부(Y/N) String[] sDb_FacStlGrp = (String[])context.get("FAC_STL_GRP" ) ; //FAC_STL_GRP 사내강호그룹 String[] sDb_CombYn = (String[])context.get("COMB_YN" ) ; //COMB_YN 조합여부(Y/N) String[] sDb_CoilIndia = (String[])context.get("COIL_INDIA" ) ; //COIL_INDIA 코일내경(단위:mm) String[] sDb_CoilOutdia = (String[])context.get("COIL_OUTDIA" ) ; //COIL_OUTDIA 코일외경(단위:mm) PosParameter param = null; int iCnt1 = 0; if (rowStatus1 != null){ iCnt1 = rowStatus1.length; } logger.logInfo("rowStatus1 = ["+ iCnt1 +"]"); for(int i=0 ; i < iCnt1; i++) { param = new PosParameter(); if ("i".equals(rowStatus1[i])) { // insert operation param.setValueParamter( 0, sDb_OrdNo[i] ) ; param.setValueParamter( 1, sDb_OrdSeq[i] ) ; param.setValueParamter( 2, sDb_NeedWgt[i] ) ; param.setValueParamter( 3, sDb_DsnProcStat[i] ) ; param.setValueParamter( 4, sDb_DsnProcYn[i] ) ; param.setValueParamter( 5, sDb_DsnErrDesc[i] ) ; param.setValueParamter( 6, sDb_HcrClf[i] ) ; param.setValueParamter( 7, "Login-ID" ) ; param.setValueParamter( 8, "Login-ID" ) ; getDao("mesdao").insert("SaveSlabDnObj.insert", param); } else if("u".equals(rowStatus1[i])) { if ("1".equals(CHK_FG1[i])) { // update TBD01_SLABDN_OBJ sDb_DsnProcYn[i] = "N"; sDb_DsnProcStat[i] = "2"; // param.setWhereClauseParameter( 0, "N" ) ; //None // param.setWhereClauseParameter( 1, "2" ) ; //Finish // param.setWhereClauseParameter( 2, sDb_OrdNo[i] ) ; // param.setWhereClauseParameter( 3, sDb_OrdSeq[i] ) ; // iAffectedCnt = getDao("mesdao").update("ModifyTargetRows.update", param); } // update operation param.setWhereClauseParameter( 0, sDb_NeedWgt[i] ) ; param.setWhereClauseParameter( 1, sDb_DsnProcStat[i] ) ; param.setWhereClauseParameter( 2, sDb_DsnProcYn[i] ) ; param.setWhereClauseParameter( 3, sDb_DsnErrDesc[i] ) ; param.setWhereClauseParameter( 4, sDb_HcrClf[i] ) ; param.setWhereClauseParameter( 5, "Login-ID" ) ; param.setWhereClauseParameter( 6, sDb_OrdNo[i] ) ; param.setWhereClauseParameter( 7, sDb_OrdSeq[i] ) ; getDao("mesdao").update("SaveSlabDnObj.update", param); } else if("d".equals(rowStatus1[i])) { // delete operation param.setWhereClauseParameter( 0, sDb_OrdNo[i] ) ; param.setWhereClauseParameter( 1, sDb_OrdSeq[i] ) ; getDao("mesdao").delete("SaveSlabDnObj.delete", param); } } // end for int iCnt2 = 0; if (rowStatus2 != null){ iCnt2 = rowStatus2.length; } logger.logInfo("rowStatus2 = ["+ iCnt2 +"]"); for(int i=0 ; i < iCnt2; i++) { param = new PosParameter() ; if ("i".equals(rowStatus2[i])) { param = new PosParameter() ; // insert operation param.setValueParamter( 0, sDb_DsnSlabNo[i] ) ; param.setValueParamter( 1, sDb_PDsnSlabNo[i] ) ; param.setValueParamter( 2, sDb_OrdNo[i] ) ; param.setValueParamter( 3, sDb_OrdSeq[i] ) ; param.setValueParamter( 4, sDb_SlabThk[i] ) ; param.setValueParamter( 5, sDb_SlabWth[i] ) ; param.setValueParamter( 6, sDb_SlabLen[i] ) ; param.setValueParamter( 7, sDb_SlabWgt[i] ) ; param.setValueParamter( 8, sDb_SlabTrmthTp[i] ) ; param.setValueParamter( 9, sDb_Gravity[i] ) ; param.setValueParamter( 10, sDb_AutodsnYn[i] ) ; param.setValueParamter( 11, sDb_CoilPackWgtMin[i] ) ; param.setValueParamter( 12, sDb_CoilPackWgtMax[i] ) ; param.setValueParamter( 13, sDb_FacStlGrd[i] ) ; param.setValueParamter( 14, sDb_CoilThk[i] ) ; param.setValueParamter( 15, sDb_CoilWth[i] ) ; param.setValueParamter( 16, sDb_CoilLen[i] ) ; param.setValueParamter( 17, sDb_CoilWgt[i] ) ; param.setValueParamter( 18, sDb_ProcPath[i] ) ; param.setValueParamter( 19, sDb_HcrYn[i] ) ; param.setValueParamter( 20, sDb_EmgmtrYn[i] ) ; param.setValueParamter( 21, sDb_FacStlGrp[i] ) ; param.setValueParamter( 22, sDb_CombYn[i] ) ; param.setValueParamter( 23, sDb_CoilIndia[i] ) ; param.setValueParamter( 24, sDb_CoilOutdia[i] ) ; getDao("mesdao").update("FinishSlabDesignRst.insert", param); } else if ("u".equals(rowStatus2[i])) { param = new PosParameter() ; // update operation //param.setWhereClauseParameter( 0, sDb_DsnSlabNo[i] ) ; param.setWhereClauseParameter( 0, sDb_PDsnSlabNo[i] ) ; param.setWhereClauseParameter( 1, sDb_OrdNo[i] ) ; param.setWhereClauseParameter( 2, sDb_OrdSeq[i] ) ; param.setWhereClauseParameter( 3, sDb_SlabThk[i] ) ; param.setWhereClauseParameter( 4, sDb_SlabWth[i] ) ; param.setWhereClauseParameter( 5, sDb_SlabLen[i] ) ; param.setWhereClauseParameter( 6, sDb_SlabWgt[i] ) ; param.setWhereClauseParameter( 7, sDb_SlabTrmthTp[i] ) ; param.setWhereClauseParameter( 8, sDb_Gravity[i] ) ; param.setWhereClauseParameter( 9, sDb_AutodsnYn[i] ) ; param.setWhereClauseParameter( 10, sDb_CoilPackWgtMin[i] ) ; param.setWhereClauseParameter( 11, sDb_CoilPackWgtMax[i] ) ; param.setWhereClauseParameter( 12, sDb_FacStlGrd[i] ) ; param.setWhereClauseParameter( 13, sDb_CoilThk[i] ) ; param.setWhereClauseParameter( 14, sDb_CoilWth[i] ) ; param.setWhereClauseParameter( 15, sDb_CoilLen[i] ) ; param.setWhereClauseParameter( 16, sDb_CoilWgt[i] ) ; param.setWhereClauseParameter( 17, sDb_ProcPath[i] ) ; param.setWhereClauseParameter( 18, sDb_HcrYn[i] ) ; param.setWhereClauseParameter( 19, sDb_EmgmtrYn[i] ) ; param.setWhereClauseParameter( 20, sDb_FacStlGrp[i] ) ; param.setWhereClauseParameter( 21, sDb_CombYn[i] ) ; param.setWhereClauseParameter( 22, sDb_CoilIndia[i] ) ; param.setWhereClauseParameter( 23, sDb_CoilOutdia[i] ) ; param.setWhereClauseParameter( 24, sDb_DsnSlabNo[i] ) ; getDao("mesdao").update("FinishSlabDesignRst.update", param); } else if ("d".equals(rowStatus2[i])) { param = new PosParameter() ; // delete operation param.setWhereClauseParameter( 0, sDb_DsnSlabNo[i] ) ; getDao("mesdao").delete("FinishSlabDesignRst.delete", param); } } // end for return PosBizControlConstants.SUCCESS; } }