package xin.glue.ui.B.common;

import xin.glue.ui.B.B02.MutilConditionFind;

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

/**
 * 
 * @Description  {界面ID:板坯详细信息查询}
 * @author       梅贵平{meiguiping}
 * @date         2009-8-9 下午07:24:16
 * @JDK Version  jdk1.4.2
 */
public class FindSlabLibaryInfo extends PosActivity
{

	public String runActivity(PosContext context)
	{
		PosGenericDao	dao	=	this.getDao("mesdao");
		PosParameter	param	=	null;
		
		String[]CHARGENO	=	(String[])context.get("CHARGENO");
		String[]SHEN_SDTIME	=	(String[])context.get("SHEN_SDTIME");
		String[]SHEN_EDTIME	=	(String[])context.get("SHEN_EDTIME");
		String[]STLGRD		=	(String[])context.get("STLGRD");//牌号	
		String[]CHARGENO1	=	(String[])context.get("CHARGENO1");
		MutilConditionFind mcf	=	new MutilConditionFind();
		StringBuffer	sb		=	mcf.getQuerySql("UIB030201.SELECT");
		
		param	=	new PosParameter();
		int j	=	0;
		if(!"".equals(CHARGENO[0]))
		{
			sb.append("\n AND SUBSTR(CCM.SLAB_NO , 1 , 10) BETWEEN  ?  AND  ? ");
			param.setWhereClauseParameter(j++, CHARGENO[0]);
			param.setWhereClauseParameter(j++, CHARGENO1[0]);
		}
		
		if(!"0000".equals(SHEN_SDTIME[0]))
		{
			sb.append("\n AND CCM.SLAB_CUT_DTIME BETWEEN  ?  AND  ?");
			param.setWhereClauseParameter(j++, SHEN_SDTIME[0]);
			param.setWhereClauseParameter(j++, SHEN_EDTIME[0]);
		}
		
		if(!"".equals(STLGRD[0]))
		{
			sb.append("\n  AND CCM.STL_GRD = ? ");
			param.setWhereClauseParameter(j++, STLGRD[0]);
		}
		
		StringBuffer	sbb	=	new StringBuffer(sb.toString());
		
		//总量
		PosRowSet	rowSet1	=	dao.findByQueryStatement(sb.toString(), param);//总量
		context.put("ListResult_1", rowSet1);
		
		//在库量
		sb.append("\n  AND  SUBSTR(CCM.CUR_LOAD_LOC , 0 , 1)  =  'L'");
		PosRowSet	rowSet2	=	dao.findByQueryStatement(sb.toString(), param);
		context.put("ListResult_2", rowSet2);
		
		//出库量
		sbb.append("\n AND      SUBSTR(CCM.CUR_LOAD_LOC , 0 , 1) != 'L'");//出库量
		PosRowSet	rowSet3	=	dao.findByQueryStatement(sbb.toString() , param);
		context.put("ListResult_3", rowSet3);
		
		return  PosBizControlConstants.SUCCESS;
	}

}