package xin.glue.ui.B.B01;

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.PosJdbcDao;
import com.posdata.glue.dao.manager.PosQueryDefinition;
import com.posdata.glue.dao.manager.PosQueryManager;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRowSet;

/**
 * 
 * @Description  查询厂内钢号、生产线信息{界面ID:UIB010050}
 * @author       梅贵平{meiguiping}
 * @date         2008-10-15 下午04:28:18
 * @JDK Version  jdk1.4.2
 */
public class FindFactoryStlInfo extends PosActivity
{
	public String runActivity(PosContext context)
	{
		PosGenericDao dao = this.getDao("mesdao");
		
		String[]STL_GRD 	= (String[])context.get("STL_GRD");//厂内钢号
		//String[]F_CODE    = (String[])context.get("F_CODE");//生产线
		StringBuffer sql 	=  getManagerSql("UIB010050_02.SELECT");
		
		PosRowSet rowset = null;
		PosParameter	param	=	new PosParameter();
		param.setWhereClauseParameter(0, STL_GRD[0]+"%");
		//param.setWhereClauseParameter(1, F_CODE[0]+"%");
		rowset = dao.findByQueryStatement(sql.toString(), param);
		context.put("FacInfoResult", rowset);
		return PosBizControlConstants.SUCCESS;
	}
	
	public StringBuffer getManagerSql(String id)
	{
		PosJdbcDao  dao      = (PosJdbcDao)this.getDao("mesdao");
		PosQueryManager ppt  = dao.getQueryManager();
		PosQueryDefinition x = ppt.getQueryDefinition(id);
		return new StringBuffer(x.getQueryStatement());
	}
}