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

import java.util.ArrayList;
import java.util.Iterator;
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.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.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;
public class FindCretList extends PosActivity{
	public String runActivity(PosContext context)
	{
		
		PosParameter param = null;
		PosRowSet cretResult = null;
		int paramCount = 0;
		
		String[] cretUI	=   (String[])context.get("cretUI");//质保书编号
		String[] no 	=   (String[])context.get("no");//合同号
		String[] stlGrd	=	(String[])context.get("stlGrd");//牌号
		String[] custId	=	(String[])context.get("custId");	//合同单位
		
		String sql1 = this.getManagerSql("UIB021110_01.SELECT");
		StringBuffer sql = new StringBuffer(sql1);
		param = new PosParameter();
		if(!cretUI[0].equals(""))//质保书不为空
		{
			sql.append(" and a.CRET_NO = ?");
			param.setWhereClauseParameter(paramCount, cretUI[0]);
			paramCount++;
		}
		if(!"".equals(no[0]))//合同号不为空
		{
			sql.append(" AND a.ORD_NO  LIKE ?||'%'");
			param.setWhereClauseParameter(paramCount, no[0]);
			paramCount++;
		}
		if(!"".equals(stlGrd[0]))//牌号不为空
		{
			sql.append(" AND B.SPEC_STL_GRD  LIKE ?||'%'");
			param.setWhereClauseParameter(paramCount, stlGrd[0]);
		}
		if(!"".equals(custId[0]))//合同单位不为空
		{
			sql.append(" AND  D.CUST_NM LIKE  ?||'%'");
			param.setWhereClauseParameter(paramCount, custId[0]);
		}
		
		
		sql.append(" order by a.CRET_NO,c.COIL_NO");
		cretResult = this.getDao("mesdao").findByQueryStatement(sql.toString(), param);
		context.put("CretResult", cretResult);
		return "success";
	}
	
	private String getManagerSql(String id)
	{
		PosJdbcDao  dao      = (PosJdbcDao)this.getDao("mesdao");
		PosQueryManager ppt  = dao.getQueryManager();
		PosQueryDefinition x = ppt.getQueryDefinition(id);
		return x.getQueryStatement();
	}
}