XinYu_LZMES/.svn/pristine/a3/a3d453e46958b02d132539b45da779931a79f45e.svn-base

package UIK.UIK05;

import java.sql.SQLException;

import UIB.COM.TechDcsResult;
import UIB.COM.XmlSqlParsersFactory;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class StorageStandby extends CoreIComponent{
	
	public CoreReturnObject Query_Coil_State(String starttiem,String endtime,Boolean flag) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();			
		//String str = "A.OLD_SAMPL_NO,A.STL_GRD,B.ORD_THK  INSTR_COIL_THK,B.ORD_WTH  INSTR_COIL_WTH,B.ORD_LEN  INSTR_COIL_LEN,B.ORD_INDIA  INSTR_COIL_INDIA,B.ORD_OUTDIA  INSTR_COIL_OUTDIA,B.ORD_WGT  INSTR_COIL_WGT,A.ACT_WGT,A.CRK_CD1,A.CRK_CD2,A.CRK_CD3,A.CRK_CD4,A.CRK_CD5,A.FM_EXT_STRIP_TEMP_AVG,A.DC_TEMP_AVG,decode(A.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD,decode(A.ORD_FL,'1','订单材','2','余材') ORD_FL,decode(A.CUR_PROG_CD,'PAB','基料卷入库待机') CUR_PROG_CD,A.COIL_LEN,A.COIL_INDIA,A.COIL_OUTDIA,A.COIL_THK,A.COIL_WTH,CUR_PROG_CD_DTIME ";
		if(!flag)
		{
			//String sqlQuery	="select "+str+" from c_tbk02_coil_comm A,TBE02_ORD_PRC B where A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' order by TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS')";
			//cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
			String sqlQuery = XmlSqlParsersFactory.getSql("UIK050010_01.SELECT");
			Object[] params = new Object[]{};
			//做生产规范标准判定
			TechDcsResult tdr = new TechDcsResult();
			cro = tdr.doTechDcs(sqlQuery,params);
			if(null == cro) 
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
			return cro;
				
		}
		else
		{
			if(endtime.equals(starttiem))
			{
				//String sqlQuery	="select "+str+" from c_tbk02_coil_comm A,TBE02_ORD_PRC B where A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date('"+starttiem+"','YYYY-MM-DD HH24:MI:SS') and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date('"+starttiem+"','YYYY-MM-DD HH24:MI:SS')+1";
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050010_02.SELECT");  
				Object[] params = new Object[]{starttiem,endtime,starttiem,endtime};
				//做生产规范标准判定
				TechDcsResult tdr = new TechDcsResult();
				cro = tdr.doTechDcs(sqlQuery,params);
				if(null == cro) 
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,params);
				
				return cro;
			}
			else
			{
				//String sqlQuery	="select "+str+" from c_tbk02_coil_comm A,TBE02_ORD_PRC B where A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date('"+starttiem+"','YYYY-MM-DD HH24:MI:SS')and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date('"+endtime+"','YYYY-MM-DD HH24:MI:SS')+1 order by TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS')";
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050010_03.SELECT");  
				Object[] params = new Object[]{starttiem,endtime,starttiem,endtime};
				//做生产规范标准判定
				TechDcsResult tdr = new TechDcsResult();
				cro = tdr.doTechDcs(sqlQuery,params);
				if(null == cro) 
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,params);
				//cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);new Object[]{starttiem,starttiem}
				return cro;
			}
			
		}
	}
}