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 SaveSlabDnObj extends PosActivity { public String runActivity(PosContext context) { // TODO Auto-generated method stub String[] rowStatus1 = (String[])context.get("rowStatus1" ) ; String[] rowStatus2 = (String[])context.get("rowStatus2" ) ; // TBD01_SLABDN_OBJ(UID010031.xrw's datagrid : dg1) //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" ) ; //NEED_WGT 요수배량(단위:kg) String[] sDb_DsnProcStat = (String[])context.get("DSN_PROC_STAT" ) ; //DSN_PROC_STAT 설계상태('1':설계대상 '2':설계완료 '3':설계확정) String[] sDb_DsnProcYn = (String[])context.get("DSN_PROC_YN" ) ; //DSN_PROC_YN 설계진행중여부(Y/N) String[] sDb_DsnErrDesc = (String[])context.get("DSN_ERR_DESC" ) ; //DSN_ERR_DESC 설계오류코드('0000':정상 'nnnn':오류) 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_NO2" ) ; //DSN_SLAB_NO 설계SLAB일련번호 String[] sDb_PDsnSlabNo = (String[])context.get("P_DSN_SLAB_NO2" ) ; //P_DSN_SLAB_NO 모설계SLAB일련번호 String[] sDb_OrdNo2 = (String[])context.get("ORD_NO2" ) ; //ORD_NO 주문번호('41':열연+주문접수년월:YYYYMM+접수SEQ:9999) String[] sDb_OrdSeq2 = (String[])context.get("ORD_SEQ2" ) ; //ORD_SEQ 주문행번(3자리) String[] sDb_SlabThk = (String[])context.get("SLAB_THK2" ) ; //SLAB_THK SLAB두께(단위:mm) String[] sDb_SlabWth = (String[])context.get("SLAB_WTH2" ) ; //SLAB_WTH SLAB폭(단위:mm) String[] sDb_SlabLen = (String[])context.get("SLAB_LEN2" ) ; //SLAB_LEN SLAB길이(단위:mm) String[] sDb_SlabWgt = (String[])context.get("SLAB_WGT2" ) ; //SLAB_WGT SLAB중량(단위:kg) String[] sDb_SlabTrmthTp = (String[])context.get("SLAB_TRMTH_TP2" ) ; //SLAB_TRMTH_TP SLAB손질방법(TBZ00_COMMCD's LG_CD='D01005') String[] sDb_Gravity = (String[])context.get("GRAVITY2" ) ; //GRAVITY 비중(단위:0.00) String[] sDb_AutodsnYn = (String[])context.get("AUTODSN_YN2" ) ; //AUTODSN_YN 자동설계여부(Y/N) String[] sDb_CoilPackWgtMin = (String[])context.get("COIL_PACK_WGT_MIN2") ; //COIL_PACK_WGT_MIN 코일포장단중[하한](단위:kg) String[] sDb_CoilPackWgtMax = (String[])context.get("COIL_PACK_WGT_MAX2") ; //COIL_PACK_WGT_MAX 코일포장단중[상한](단위:kg) String[] sDb_FacStlGrd = (String[])context.get("FAC_STL_GRD2" ) ; //FAC_STL_GRD 사내강호 String[] sDb_CoilThk = (String[])context.get("COIL_THK2" ) ; //COIL_THK 코일두께(단위:mm) String[] sDb_CoilWth = (String[])context.get("COIL_WTH2" ) ; //COIL_WTH 코일폭(단위:mm) String[] sDb_CoilLen = (String[])context.get("COIL_LEN2" ) ; //COIL_LEN 코일길이(단위:mm 열연:미사용) String[] sDb_CoilWgt = (String[])context.get("COIL_WGT2" ) ; //COIL_WGT 코일중량(단위:kg) String[] sDb_ProcPath = (String[])context.get("PROC_PATH2" ) ; //PROC_PATH 통과공정(구분자:'>') String[] sDb_HcrYn = (String[])context.get("HCR_YN2" ) ; //HCR_YN HCR지정여부(Y/N) String[] sDb_EmgmtrYn = (String[])context.get("EMGMTR_YN2" ) ; //EMGMTR_YN 긴급재여부(Y/N) String[] sDb_FacStlGrp = (String[])context.get("FAC_STL_GRP2" ) ; //FAC_STL_GRP 사내강호그룹 String[] sDb_CombYn = (String[])context.get("COMB_YN2" ) ; //COMB_YN 조합여부(Y/N) String[] sDb_CoilIndia = (String[])context.get("COIL_INDIA2" ) ; //COIL_INDIA 코일내경(단위:mm) String[] sDb_CoilOutdia = (String[])context.get("COIL_OUTDIA2" ) ; //COIL_OUTDIA 코일외경(단위:mm) String[] sDb_KeepWarnYn = (String[])context.get("KEEPWARM_YN2" ) ; //COIL_OUTDIA int iCnt1 = 0; if (rowStatus1 != null) { iCnt1 = rowStatus1.length; } logger.logInfo("rowCount1 = ["+ iCnt1 +"]"); PosParameter param = null; for(int i=0 ; i < iCnt1; i++) { logger.logInfo("rowStatus1["+ i +"] = ["+ rowStatus1[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])) { // 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); } } 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_OrdNo2[i] ) ; param.setValueParamter( 3, sDb_OrdSeq2[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] ) ; param.setValueParamter( 25, sDb_KeepWarnYn[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_OrdNo2[i] ) ; param.setWhereClauseParameter( 2, sDb_OrdSeq2[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_KeepWarnYn[i] ) ; param.setWhereClauseParameter( 25, 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; } }