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

	public String runActivity(PosContext context) {
		// TODO Auto-generated method stub
		logger.logInfo("Here is SetParamsObjectStatus.java!!!");
        String[] 	rowStatus1 			= 	 (String[])context.get("rowStatus1");

        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_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)

        int iCnt1 = 0;
        if (rowStatus1 != null){
        	iCnt1 = rowStatus1.length;
        }
logger.logInfo("rowCount = ["+ iCnt1 +"]");

		PosParameter param = null;

        for(int i=0 ; i < iCnt1; i++) {
        	
			if ("3".equals(sDb_DsnProcStat[i]))
				continue;

logger.logInfo("CHK_FG["+ i +"] = ["+ CHK_FG1[i] +"] sDb_OrdNo = ["+ sDb_OrdNo[i] +"] sDb_OrdSeq = ["+ sDb_OrdSeq[i] +"]");
			if ("1".equals(CHK_FG1[i])) {

			    param = new PosParameter();
			
			    // update tbd01_slabdn_obj
			    param.setWhereClauseParameter( 0, "N"                  )  ; //Pre-View
			    param.setWhereClauseParameter( 1, "1"                  )  ; //Pre-Save
			    param.setWhereClauseParameter( 2, sDb_OrdNo[i]         )  ;
			    param.setWhereClauseParameter( 3, sDb_OrdSeq[i]        )  ;
			
			    getDao("mesdao").update("ModifyTargetRows.update", param);

			    // delete from tbd01_slabdn_rst
			    param = new PosParameter();
			
			    param.setWhereClauseParameter( 0, sDb_OrdNo[i]         )  ;
			    param.setWhereClauseParameter( 1, sDb_OrdSeq[i]        )  ;
			
			    getDao("mesdao").update("DeleteDesignResult.delete", param);

			}
        }

        return PosBizControlConstants.SUCCESS;
	}

}