package QCM.QCM02.QCM0201;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import QCM.COMMUNAL.subCommunal;
public class QueryEntrust extends CoreIComponent {
	private CoreReturnObject cro = null;
	private StringBuffer sqlB=null;
	//根据时间 、轧批号、产品规范描述 查询
	public CoreReturnObject Query(String maxTime,String minTime,String maxBatchNo,String minBatchNo,String PscDesc) {
		cro= new CoreReturnObject();
		sqlB=new StringBuffer();
		sqlB.append("select "+
				"m.SMP_NO,m.BATCH_NO,m.PSC_DESC,m.SMP_CATG,m.CERT_INST_NAME,m.SMP_TYPE_NAME,m.PLINE_NAME,"+
				"m.VALIDFLAG,m.MEMO,m.CREATE_ID,m.CREATE_NAME,m.CREATE_TIME,m.UPDATE_ID,m.UPDATE_NAME,m.UPDATE_TIME," +
				"m.INSPECTION_LOT,m.PSC,m.CERT_INST_CODE,m.SMP_TYPE_CODE,m.PLINE_CODE,"+
				"ord.DESIGN_KEY,ord.SMP_NO,ord.PSC,ord.DELIVERY_STATE_DESC,ord.THICK,ord.WIDTH,"+
				"ord.LENGTH,ord.PLINE_NAME,ord.MSC_PLINE," +
				"item.SPECIMEN_NO,item.SEQ," +
				"d.BATCH_NO,d.VALIDFLAG,"+
				"d.SMP_NO,d.SPECIMEN_NO,d.SMP_QTY,d.SMP_LOCATION,d.STATUS,d.CONSIGN_NO"+
				" from QCM_JHY_SAMPLE_CONSIGN_M m "+
				" inner join QCM_JHY_SAMPLE_R_ORD ord on m.smp_no=ord.smp_no "+
				" inner join QCM_JHY_SAMPLE_CONSIGN_D d on m.smp_no=d.smp_no"+
				" inner join QCM_JHY_SAMPLE_CONSIGN_D_ITEM item " +
				" on d.specimen_no=item.specimen_no and d.smp_no=item.smp_no" +
				" where to_char(m.CREATE_TIME,'YYYY-MM-DD')>='"+minTime+"' and to_char(m.CREATE_TIME,'YYYY-MM-DD')<='"+maxTime+"' ");
		if(!"".equals(PscDesc.trim())){
			sqlB.append(" and m.PSC_DESC='"+PscDesc+"' ");
		}
		if(!"".equals(minBatchNo.trim())){
			sqlB.append(" and to_number(m.BATCH_NO)>="+subCommunal.sub(minBatchNo));
		}
		if(!"".equals(maxBatchNo.trim())){
			sqlB.append(" and to_number(m.BATCH_NO)<="+subCommunal.sub(maxBatchNo));
		}
		cro=this.getDao("KgDao").ExcuteQuery(sqlB.toString());
		return cro;
	}
	
}