XinYu_RZMES/.svn/pristine/5b/5be1b88828d6347b1a5aca84fbf005c3d8aa654e.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 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;

    }

}