package xin.glue.ui.D.D03;

import java.math.BigDecimal;

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;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

/**
 * 从中厚板提取板坯
 * @author 王小炎
 * @date 2011-3-7
 */
public class ExtractSlabFromPlate extends PosActivity
{

	public String runActivity(PosContext context)
	{
		String[] DSN_SLAB_NO = (String[])context.get("DSN_SLAB_NO");
		String[] ORD_NO = (String[])context.get("ORD_NO");
		String[] ORD_SEQ = (String[])context.get("ORD_SEQ");
		int cn = 0;
		
		getDao("mesdao").deleteByQueryStatement("DELETE FROM TBD01_SLABDN_RST2");
		getDao("mesdao").deleteByQueryStatement("DELETE FROM TBD01_MATDN_RST2");
		
		if(DSN_SLAB_NO != null)
		{
			PosParameter	param 			= 	null;
			PosParameter 	param1 = new PosParameter();
			PosRowSet	 	rowset 	= null;
			PosRow		 	row 		= null;
			for(int i = 0; i < DSN_SLAB_NO.length; i++)
			{	
				//新增无品质设计的计划无法确认jiangxing 20240507
				param1 = new PosParameter();
				param1.setWhereClauseParameter(0, ORD_NO[i]);
				param1.setWhereClauseParameter(1, ORD_SEQ[i]);
				String querysql = "SELECT COUNT(*) CN FROM TBB01_ORD_INGR WHERE ORD_NO = ? AND ORD_SEQ = ?";
	        	rowset = getDao("mesdao").findByQueryStatement(querysql, param1);
				if(rowset.hasNext())
				{
					 row = rowset.next();
					 cn  = ((BigDecimal) row.getAttribute("CN")).intValue();
				}
				
				if(cn < 5)
					continue;
				
				param = new PosParameter();
				param.setWhereClauseParameter(0, DSN_SLAB_NO[i]);
				
				getDao("mesdao").update("slabFromPlate.update3", param);
				
			}
			getDao("mesdao").update("slabFromPlate03to02.update");
			getDao("mesdao").insert("slabFromPlate.insert");
		}
		return PosBizControlConstants.SUCCESS;
	}

}