package xin.glue.ui.H.H05;

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.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;

public class SearchYardInfo extends PosActivity {

	public String runActivity(PosContext context) {
		String[] coilNo = (String[])context.get("COIL_NO");
		String[] stlGrd = (String[])context.get("STL_GRD");
		String[] curLoadLoc = (String[])context.get("CUR_LOAD_LOC");
		String[] ordFl = (String[])context.get("ORD_FL");
		String[] coilThkMin = (String[])context.get("COIL_THK_MIN");
		String[] coilThkMax = (String[])context.get("COIL_THK_MAX");
		String[] coilWthMin = (String[])context.get("COIL_WTH_MIN");
		String[] coilWthMax = (String[])context.get("COIL_WTH_MAX");
		String[] fromDate = (String[])context.get("FROM_DATE");
		String[] toDate = (String[])context.get("TO_DATE");
		String[] ordNo = (String[])context.get("ORD_NO");
		String[] curProgCd = (String[])context.get("CUR_PROG_CD");
		String[] qkYn = (String[])context.get("QK_YN");
		String[] DLIV_TP = (String[])context.get("DLIV_TP");
		String[] ORD_DEVLMT_DATE = (String[])context.get("ORD_DEVLMT_DATE");
		String[] COIL_DEFECTIVE = (String[])context.get("COIL_DEFECTIVE");
		String[] SMP_SEND_DTIME = (String[])context.get("SMP_SEND_DTIME");
		String[] RCVORD_CLF = (String[])context.get("RCVORD_CLF");
		String[] PROD_LINE = (String[])context.get("PROD_LINE");
		String[] ROLLFR = (String[])context.get("ROLLFR");
		String[] ROLLTO = (String[])context.get("ROLLTO");
		//销售区域
		String[] XSQY = (String[])context.get("XSQY");
		//产品类型
		String[] PRODNM_CD = (String[])context.get("PRODNM_CD");
		//下车方式 这里对应的是TBH02_COIL_COMM表中的实际下车方式
		String[] DLIV_TP1 = (String[])context.get("DLIV_TP1");
		String[] SPM_TYPE = (String[])context.get("SPM_TYPE");
		
		String[] sqlOrdFl = (String[])context.get("sql_ord_fl");
		logger.logDebug(sqlOrdFl[0]);
		StringBuffer sqlStr = null;
		
		try{
			PosJdbcDao  dao      = (PosJdbcDao)this.getDao("mesdao");
			PosQueryManager ppt  = dao.getQueryManager();
			PosQueryDefinition x = ppt.getQueryDefinition("UIH051100_01.select");
			sqlStr =  new StringBuffer(x.getQueryStatement());
			
			sqlStr = sqlStr.append("\n");
			sqlStr = sqlStr.append(sqlOrdFl[0]);
			sqlStr = sqlStr.append("\n");
			sqlStr = sqlStr.append("order by A.YARD_ENTRY_DTIME desc");
			
			logger.logDebug("------------------" + sqlStr); 
			PosParameter param = new PosParameter();
			param.setWhereClauseParameter(0, coilNo[0]);
			param.setWhereClauseParameter(1, stlGrd[0]);
			param.setWhereClauseParameter(2, curLoadLoc[0]);
			param.setWhereClauseParameter(3, coilThkMin[0]);
			param.setWhereClauseParameter(4, coilThkMax[0]);
			param.setWhereClauseParameter(5, coilWthMin[0]);
			param.setWhereClauseParameter(6, coilWthMax[0]);
			param.setWhereClauseParameter(7, fromDate[0]);
			param.setWhereClauseParameter(8, toDate[0]);
			param.setWhereClauseParameter(9, ordNo[0]);
			param.setWhereClauseParameter(10, curProgCd[0]);
			param.setWhereClauseParameter(11, DLIV_TP[0]);
			param.setWhereClauseParameter(12, ORD_DEVLMT_DATE[0]);
			param.setWhereClauseParameter(13, COIL_DEFECTIVE[0]);
			param.setWhereClauseParameter(14, SMP_SEND_DTIME[0]);
			param.setWhereClauseParameter(15, XSQY[0]);
			param.setWhereClauseParameter(16, PRODNM_CD[0]);
			param.setWhereClauseParameter(17, DLIV_TP1[0]);
			param.setWhereClauseParameter(18, RCVORD_CLF[0]);//合同类型  add by jungan 20110121
			param.setWhereClauseParameter(19, PROD_LINE[0]);//产线  add by jungan 20110121
			param.setWhereClauseParameter(20, SPM_TYPE[0]);
			param.setWhereClauseParameter(21, ROLLFR[0]);
			param.setWhereClauseParameter(22, ROLLTO[0]);
			PosRowSet rowSet =  getDao("mesdao").findByQueryStatement(sqlStr.toString(), param);
		
			context.put("UIH051100_RESULT", rowSet);
		}catch(Exception e){
			e.printStackTrace();
			this.rollbackTransaction("tx1");
		}
		
		return PosBizControlConstants.SUCCESS;
	}

}