XinYu_RZMES/.svn/pristine/7d/7dda5f6af9ff6373a72ae90ab166ac93724add33.svn-base

/**
 * 
 */
package xin.glue.ui.B.B02;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.posdata.glue.biz.activity.PosActivity;
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;

/**
 * 类名    FindCoilReport.java
 * 说明    description of the class
 * 创建日期 2009-1-5
 * 作者    hewenxi 
 */
public class FindCoilReport extends PosActivity{
	public String runActivity(PosContext context)
	{
		PosParameter param = null;
		PosRowSet result = null;
		PosRow row = null;
		List list = null;
		Map map = null;
		String[] date;
		
		date = (String[])context.get("date");
		param = new PosParameter();
		param.setWhereClauseParameter(0, date[0]);
		
		//日生产炉次数
		result = this.getDao("mesdao").find("UIB020270_01.SELECT", param);
		
		map = new HashMap();
		list = new ArrayList();
		while(result.hasNext())
		{
			row = result.next();
			String PRODNM_CD = (String)row.getAttribute("PRODNM_CD");
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_3 = (String)row.getAttribute("CNT_3");
			if(PRODNM_CD.equals("AR"))
			{
				map.put("AR","热轧");			//厂线
				map.put("AR_DAY_CNT",CNT);		//日生产炉次
				map.put("AR_DAY_CNT_1",CNT_1);	//合格炉次
				map.put("AR_DAY_CNT_3",CNT_3);	//合格率
			}	
			if(PRODNM_CD.equals("PP"))
			{
				map.put("PP","厚板");			//厂线
				map.put("PP_DAY_CNT",CNT);		//日生产炉次
				map.put("PP_DAY_CNT_1",CNT_1);	//合格炉次
				map.put("pp_DAY_CNT_3",CNT_3);	//合格率
			}	
		}
		
		//月生产炉次数
		result = this.getDao("mesdao").find("UIB020270_02.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String PRODNM_CD = (String)row.getAttribute("PRODNM_CD");
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_3 = (String)row.getAttribute("CNT_3");
			if(PRODNM_CD.equals("AR"))
			{
				map.put("AR_MON_CNT",CNT);		//月生产炉次
				map.put("AR_MON_CNT_1",CNT_1);	//合格炉次
				map.put("AR_MON_CNT_3",CNT_3);	//合格率
			}	
			if(PRODNM_CD.equals("PP"))
			{
				map.put("PP_MON_CNT",CNT);		//月生产炉次
				map.put("PP_MON_CNT_1",CNT_1);	//合格炉次
				map.put("pp_MON_CNT_3",CNT_3);	//合格率
			}	
		}

		//日生产板坯数
		result = this.getDao("mesdao").find("UIB020270_03.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_2 = (String)row.getAttribute("CNT_2");
			
			map.put("BP_DAY_CNT",CNT);		//日生产板坯
			map.put("BP_DAY_CNT_1",CNT_1);	//合格板坯
			map.put("BP_DAY_CNT_2",CNT_2);	//不合格板坯	
		}

		//月生产板坯数
		result = this.getDao("mesdao").find("UIB020270_04.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_2 = (String)row.getAttribute("CNT_2");
			
			map.put("BP_MON_CNT",CNT);		//月生产板坯
			map.put("BP_MON_CNT_1",CNT_1);	//合格板坯
			map.put("BP_MON_CNT_2",CNT_2);	//不合格板坯	
		}
		list.add(map);
		context.put("LGResult", list);
		
		
		map = new HashMap();
		list = new ArrayList();
		result = this.getDao("mesdao").find("UIB020270_05.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CRK_CD1 = (String)row.getAttribute("CRK_CD1");
			String CRK_CD2 = (String)row.getAttribute("CRK_CD2");
			String CRK_CD3 = (String)row.getAttribute("CRK_CD3");
			String CRK_CD4 = (String)row.getAttribute("CRK_CD4");
			String CRK_CD5 = (String)row.getAttribute("CRK_CD5");
			
			map.put("DAY_CNT",CNT);		//日生产钢卷数
			map.put("DAY_CNT_1",CNT_1);	//合格钢卷数
			map.put("DAY_CRK_CD1",CRK_CD1);	//缺陷1	
			map.put("DAY_CRK_CD2",CRK_CD2);	//缺陷1	
			map.put("DAY_CRK_CD3",CRK_CD3);	//缺陷1	
			map.put("DAY_CRK_CD4",CRK_CD4);	//缺陷1	
			map.put("DAY_CRK_CD5",CRK_CD5);	//缺陷1	
		}
	
		result = this.getDao("mesdao").find("UIB020270_06.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CRK_CD1 = (String)row.getAttribute("CRK_CD1");
			String CRK_CD2 = (String)row.getAttribute("CRK_CD2");
			String CRK_CD3 = (String)row.getAttribute("CRK_CD3");
			String CRK_CD4 = (String)row.getAttribute("CRK_CD4");
			String CRK_CD5 = (String)row.getAttribute("CRK_CD5");
			
			map.put("MON_CNT",CNT);		//日生产钢卷数
			map.put("MON_CNT_1",CNT_1);	//合格钢卷数
			map.put("MON_CRK_CD1",CRK_CD1);	//缺陷1	
			map.put("MON_CRK_CD2",CRK_CD2);	//缺陷1	
			map.put("MON_CRK_CD3",CRK_CD3);	//缺陷1	
			map.put("MON_CRK_CD4",CRK_CD4);	//缺陷1	
			map.put("MON_CRK_CD5",CRK_CD5);	//缺陷1	
		}				
		list.add(map);
		context.put("EXTResult", list);
		
		
		map = new HashMap();
		list = new ArrayList();
		result = this.getDao("mesdao").find("UIB020270_07.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_2 = (String)row.getAttribute("CNT_2");
			String CNT_3 = (String)row.getAttribute("CNT_3");
			String CNT_4 = (String)row.getAttribute("CNT_4");
			String CNT_5 = (String)row.getAttribute("CNT_5");
			String CNT_6 = (String)row.getAttribute("CNT_6");
			
			map.put("DAY_CNT",CNT);		//日生产钢卷数
			map.put("DAY_CNT_1",CNT_1);	//合格钢卷数
			map.put("DAY_CNT_2",CNT_2);	//缺陷1	
			map.put("DAY_CNT_3",CNT_3);	//缺陷1	
			map.put("DAY_CNT_4",CNT_4);	//缺陷1	
			map.put("DAY_CNT_5",CNT_5);	//缺陷1	
			map.put("DAY_CNT_6",CNT_6);	//缺陷1	
		}

		result = this.getDao("mesdao").find("UIB020270_08.SELECT", param);
		while(result.hasNext())
		{
			row = result.next();
			String CNT = (String)row.getAttribute("CNT");
			String CNT_1 = (String)row.getAttribute("CNT_1");
			String CNT_2 = (String)row.getAttribute("CNT_2");
			String CNT_3 = (String)row.getAttribute("CNT_3");
			String CNT_4 = (String)row.getAttribute("CNT_4");
			String CNT_5 = (String)row.getAttribute("CNT_5");
			String CNT_6 = (String)row.getAttribute("CNT_6");
			
			map.put("MON_CNT",CNT);		//日生产钢卷数
			map.put("MON_CNT_1",CNT_1);	//合格钢卷数
			map.put("MON_CNT_2",CNT_2);	//缺陷1	
			map.put("MON_CNT_3",CNT_3);	//缺陷1	
			map.put("MON_CNT_4",CNT_4);	//缺陷1	
			map.put("MON_CNT_5",CNT_5);	//缺陷1	
			map.put("MON_CNT_6",CNT_6);	//缺陷1	
		}
		list.add(map);
		context.put("CPResult", list);
		return "success";
	}
}