package xin.glue.ui.A.A02;

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 SaveDlvtDetailList extends PosActivity {

	public String runActivity(PosContext context) {

        String[] 	rowStatus1 			= 	 (String[])context.get("rowStatus1"  ) ;
        String[] 	rowStatus2 			= 	 (String[])context.get("rowStatus2"  ) ;

        //
        String[]    sDb_SpecStlGrd      =    (String[])context.get("SPEC_STL_GRD") ; //SPEC_STL_GRD(TBZ00_COMMCD's LG_CD=A02001)
        String[]    sDb_DlvtGrpTp       =    (String[])context.get("DLVT_GRP_TP" ) ; //DLVT_GRP_TP (TBZ00_COMMCD's LG_CD=A02002)
        String[]    sDb_DspSeq          =    (String[])context.get("DSP_SEQ"     ) ; //DSP_SEQ
        String[]    sDb_Remarks         =    (String[])context.get("REMARKS"     ) ; //REMARKS

        //
        String[]    sDb_Chk2              =    (String[])context.get("CHK2"           ) ; //CHK2
        String[]    sDb_SpecStlGrd2       =    (String[])context.get("SPEC_STL_GRD2"  ) ; //SPEC_STL_GRD(TBZ00_COMMCD's LG_CD=A02001)
        String[]    sDb_DlvtGrpTp2        =    (String[])context.get("DLVT_GRP_TP2"   ) ; //DLVT_GRP_TP (TBZ00_COMMCD's LG_CD=A02002)
        String[]    sDb_ElmtSeq2          =    (String[])context.get("ELMT_SEQ2"      ) ; //ELMT_SEQ
        String[]    sDb_TermDays2         =    (String[])context.get("TERM_DAYS2"     ) ; //TERM_DAYS
        String[]    sDb_TermDaysDesc2     =    (String[])context.get("TERM_DAYS_DESC2") ; //TERM_DAYS_DESC
        String[]    sDb_RegId             =    (String[])context.get("REG_ID"         ) ; //REG_ID
      //String[]    sDb_RegDtime2         =    (String[])context.get("REG_DTIME2"     ) ; //REG_DTIME
        String[]    sDb_ModId             =    (String[])context.get("MOD_ID"         ) ; //MOD_ID
      //String[]    sDb_ModDtime2         =    (String[])context.get("MOD_DTIME2"     ) ; //MOD_DTIME

        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_SpecStlGrd[i]  )  ;
		        param.setValueParamter( 1, sDb_DlvtGrpTp[i]   )  ;
		        param.setValueParamter( 2, sDb_DspSeq[i]      )  ;
		        param.setValueParamter( 3, sDb_Remarks[i]     )  ;
		
		        getDao("mesdao").insert("UIA020020.List.DlvtGroup.insert", param);
		
		    } else if("u".equals(rowStatus1[i])) {
		
		    	// update operation
		        param.setWhereClauseParameter( 0, sDb_DspSeq[i]     )  ;
		        param.setWhereClauseParameter( 1, sDb_Remarks[i]    )  ;
		        param.setWhereClauseParameter( 2, sDb_SpecStlGrd[i]	)  ;
		        param.setWhereClauseParameter( 3, sDb_DlvtGrpTp[i]  )  ;
		
		        getDao("mesdao").update("UIA020020.List.DlvtGroup.update", param);
		
		    } else if("d".equals(rowStatus1[i])) {	// delete operation
		
		        param.setWhereClauseParameter( 0, sDb_SpecStlGrd[i] )  ;
		        param.setWhereClauseParameter( 1, sDb_DlvtGrpTp[i]  )  ;
		
		        getDao("mesdao").delete("UIA020020.List.DlvtGroup.delete", param);
		    }
		
		}


		int iCnt2 = 0;
		if (rowStatus2 != null){
			iCnt2 = rowStatus2.length;
		}
logger.logInfo("rowCount2 = ["+ iCnt2 +"]");

//	    PosParameter param = null;
		
		for(int i=0 ; i < iCnt2; i++) {
logger.logInfo("rowStatus2["+ i +"] = ["+ rowStatus2[i] +"]");

		    param = new PosParameter();
		    
		    if ("Y".equals(sDb_Chk2[i])) {
		
		    	// update operation
		        param.setWhereClauseParameter( 0, sDb_TermDays2[i]     )  ;
		        param.setWhereClauseParameter( 1, sDb_TermDaysDesc2[i] )  ;
		        param.setWhereClauseParameter( 2, sDb_ModId[0]	       )  ;
		        param.setWhereClauseParameter( 3, sDb_SpecStlGrd2[i]   )  ;
		        param.setWhereClauseParameter( 4, sDb_DlvtGrpTp2[i]    )  ;
		        param.setWhereClauseParameter( 5, sDb_ElmtSeq2[i]      )  ;
		
		        int iRow = getDao("mesdao").update("UIA020020.List.DlvtDetail.update", param);

		        if(iRow == 0) {
			        // insert operation
			        param.setValueParamter( 0, sDb_SpecStlGrd2[i]   )  ;
			        param.setValueParamter( 1, sDb_DlvtGrpTp2[i]    )  ;
			        param.setValueParamter( 2, sDb_ElmtSeq2[i]      )  ;
			        param.setValueParamter( 3, sDb_TermDays2[i]     )  ;
			        param.setValueParamter( 4, sDb_TermDaysDesc2[i] )  ;
			        param.setValueParamter( 5, sDb_RegId[0]         )  ;
			        param.setValueParamter( 6, sDb_ModId[0]         )  ;
			
			        getDao("mesdao").insert("UIA020020.List.DlvtDetail.insert", param);
		        }
		
		    } else { // if("N".equals(sDb_Chk2[i]))
		
		        param.setWhereClauseParameter( 0, sDb_SpecStlGrd2[i] )  ;
		        param.setWhereClauseParameter( 1, sDb_DlvtGrpTp2[i]  )  ;
		        param.setWhereClauseParameter( 2, sDb_ElmtSeq2[i]    )  ;
		
		        getDao("mesdao").delete("UIA020020.List.DlvtDetail.delete", param);
		    }
		
		}

		return PosBizControlConstants.SUCCESS;

	}

}