package EGIS;

import CoreFS.SA01.CoreIComponent;

import CoreFS.SA06.CoreReturnObject;
public class QueryEgis extends CoreIComponent{
	CoreReturnObject cro = null;
	StringBuffer sqlucomm=null;
	//查询 供方名称、产线
	public CoreReturnObject Query(String name,String line) {
		sqlucomm = new StringBuffer();
		cro=new CoreReturnObject();
		sqlucomm.append("select " +
				"EGIS_ID,FOR_NAME,PRODUCTION_LINE,NORM,UNIT_PRICE," +
				"TO_CHAR(CREATE_DATE,'YYYY-MM-DD HH24:MI:SS') CREATE_DATE," +
				"TO_CHAR(REVISE_DATE,'YYYY-MM-DD HH24:MI:SS') REVISE_DATE"+
				" from QCM_EGIS where FETTLE=1");
		if(!"".equals(name)){
			sqlucomm.append(" and FOR_NAME='"+name+"'");
		}
		if(!"".equals(line)){
			sqlucomm.append(" and PRODUCTION_LINE='"+line+"'");
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlucomm.toString());
		return cro;
	}	
}