XinYu_RZMES/.svn/pristine/08/08f38d3e2b2452da63fb88432fe0e6273a9676db.svn-base

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;

    }

}