package UIK.UIK05;

import java.sql.SQLException;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class UIK050040  extends CoreIComponent{

	public CoreReturnObject DoQueryShang(String zgNum,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str = "SPEC_NO,STAND_ID,ROLL_TYPE,ROLLID_UP,REASON_CODE,TO_CHAR(DISMOUNT_TIME,'YYYY-MM-DD HH24:MI:SS') DISMOUNT_TIME,SHIFT,CREW,ROLLED_LENGTH_UP,ROLLED_WEIGHT_UP,ROLLED_TIME_UP,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,ROLL_AREA,MEG_FLAG";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  order by REG_DTIME";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  where STAND_ID = '"+zgNum+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')" ;
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
			}
			
	}
	                        
	public CoreReturnObject DoQueryXia(String zgNum,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str ="SPEC_NO,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,ROLLID_LO,REASON_CODE,TO_CHAR(DISMOUNT_TIME,'YYYY-MM-DD HH24:MI:SS') DISMOUNT_TIME,SHIFT,CREW,ROLLED_LENGTH_LO,ROLLED_WEIGHT_LO,ROLLED_TIME_LO,ROLL_AREA,STAND_ID,ROLL_TYPE";
			
			if(!flag)
			{
				
				String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  order by REG_DTIME";
			       
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery );
				return cro;
				
			}
			
			else
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  where STAND_ID = '"+zgNum+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					return cro;
			}
				
	}
	public CoreReturnObject DoQueryShang1(String zgNum,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str = "SPEC_NO,STAND_ID,ROLL_TYPE,ROLLID_UP,REASON_CODE,TO_CHAR(DISMOUNT_TIME,'YYYY-MM-DD HH24:MI:SS') DISMOUNT_TIME,SHIFT,CREW,ROLLED_LENGTH_UP,ROLLED_WEIGHT_UP,ROLLED_TIME_UP,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,ROLL_AREA,MEG_FLAG";
			
			
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')" ;
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
			
			
	}
	                        
	public CoreReturnObject DoQueryXia1(String zgNum,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str ="SPEC_NO,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME,ROLLID_LO,REASON_CODE,TO_CHAR(DISMOUNT_TIME,'YYYY-MM-DD HH24:MI:SS') DISMOUNT_TIME,SHIFT,CREW,ROLLED_LENGTH_LO,ROLLED_WEIGHT_LO,ROLLED_TIME_LO,ROLL_AREA,STAND_ID,ROLL_TYPE";
			
			
				
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_DOWN  where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					return cro;
			
				
	}
}