package xin.glue.ui.G.G02;


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

/**
 * 选择合金、辅料或废料CODE时，查询相应的CODE内容
 * 从维护表中获取班次、组信息
 * 均为下拉列表中的内容
 * 
 * @author 梅贵平
 * @date   2008-9-1
 */
public class SelectBuildCombo extends PosActivity
{
	public String runActivity(PosContext context)
	{
		//查询各原料代码所对应得原料
		String[] flag = (String[])context.get("FLAG");
		PosGenericDao dao  = this.getDao("mesdao");
		
		//选择合金，查询相应的CODE内容
		if(flag!=null&&"metal".equals(flag[0]))
		{
			String[] MAINRAW_CD  = (String[])context.get("MAINRAW_CD");//获得原料代码
			
			PosParameter param   = new PosParameter();
			param.setWhereClauseParameter(0, MAINRAW_CD[0]);
			
			PosRowSet rowset =  dao.find("UIG020COMM_01_single.select",param);
			context.put("CommResult", rowset);
		}
		//选择辅料CODE时，查询相应的CODE内容
		else if(flag!=null&&"nonMetal".equals(flag[0]))
		{
			String[] MAINRAW_CD  = (String[])context.get("MAINRAW_CD");//获得原料代码
			
			PosParameter param   = new PosParameter();
			param.setWhereClauseParameter(0, MAINRAW_CD[0]);
			
			PosRowSet rowset =  dao.find("UIG020COMM_01_single.select",param);
			context.put("CommResult", rowset);
		}
		//选择废料CODE时，查询相应的CODE内容
		else if(flag!=null&&"scrap".equals(flag[0]))
		{
			String[] MAINRAW_CD  = (String[])context.get("MAINRAW_CD");//获得原料代码
			
			PosParameter param   = new PosParameter();
			param.setWhereClauseParameter(0, MAINRAW_CD[0]);
			
			PosRowSet rowset =  dao.find("UIG020COMM_01_single.select",param);
			context.put("CommResult", rowset);
		}		
		//将所有班次、组的信息及铁合金、辅料、废料进行查询并放到各自下拉框中
		else if(flag!=null&&"wk".equals(flag[0]))
		{
			//查询班次号信息SQL
			String wkShift     = "select distinct wkshift from test_shift";
			//查询组号信息SQL
			String wkGroup     = "select distinct wkgroup from test_shift";
			//查询铁合金信息SQL
			String metalSql    = "select distinct SM_CD from tbz00_commcd where SM_CD LIKE 'H0%'AND LG_CD='G03001'";
			//查询辅料信息SQL
			String nonMetalSql = "select distinct SM_CD from tbz00_commcd where SM_CD LIKE 'B0%'AND LG_CD='G03001'";
			//处擦训废料信息SQL
			String scrapSql    = "select distinct SM_CD from tbz00_commcd where SM_CD LIKE 'S0%'AND LG_CD='G03001'";		
			
			PosRowSet rowSetShift =  dao.findByQueryStatement(wkShift);//班次信息
			PosRowSet rowSetGroup =  dao.findByQueryStatement(wkGroup);//组号信息
			PosRowSet rowSetMetal =  dao.findByQueryStatement(metalSql);//铁合金CODE信息
			PosRowSet rowSetNon   =  dao.findByQueryStatement(nonMetalSql);//辅料CODE信息
			PosRowSet rowSetScrap =  dao.findByQueryStatement(scrapSql);//废料CODE信息
			PosRowSet noExitrow   =   new PosRowSetImpl();
			
			context.put("WkShiftResult", rowSetShift);
			context.put("WkGroupResult", rowSetGroup);
			context.put("WkMetalResult", rowSetMetal);
			context.put("WkNonMetalResult", rowSetNon);
			context.put("WkScrapResult", rowSetScrap);
			context.put("CommResult", noExitrow);
		}
		return PosBizControlConstants.SUCCESS;
	}
}