package UIK.UIK05;

import java.sql.SQLException;

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

public class UIK050060 extends CoreIComponent{

	public CoreReturnObject DoQuery(String zgNum, String zgAr,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();			
			String str = "STAND_ID,ROLL_TYPE,REASON_CODE,TO_CHAR(MOUNT_TIME,'YYYY-MM-DD HH24:MI:SS') MOUNT_TIME,SHIFT,CREW,ROLLID_UP,ROLLID_LO,SPEC_NO,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_UP order by REG_DTIME";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
				if(!zgNum.equals("") && !zgAr.equals(""))
				{
					String sqlQuery	=	"select "+str+" from C_TBK05_ROLL_UP where STAND_ID = '"+zgNum+"'and ROLL_AREA= '"+zgAr+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					return cro;
				}
				else
				{
				if(!zgNum.equals("")&& zgAr.equals(""))
				{
						String sqlQuery	=	"select "+str+" from C_TBK05_ROLL_UP where STAND_ID ='"+ zgNum+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
					
				if(zgNum.equals("")&& !zgAr.equals("") )
				{
						String sqlQuery	=	"select  "+str+"  from C_TBK05_ROLL_UP where ROLL_AREA ='" + zgAr+"' and (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
				if(zgNum.equals("")&& zgAr.equals("") )
				{
						String sqlQuery	=	"select  "+str+"  from C_TBK05_ROLL_UP where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
				}
				
			}
			
			return cro;
	}
	                        
	

}