package UIK.UIK05;

import java.sql.SQLException;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
                               
public class UIK050020 extends CoreIComponent{

	/**ss
	 * @param args
	 */                                
	public CoreReturnObject DoQueryShang(String zgNum, String zgAr,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str = "SPEC_NO,STAND_ID,ROLL_TYPE,ROLL_ID_UP,ROLL_DIAMETER_UP,ROLL_CROWN_UP,ROLL_ROUGHNESS_UP,ROLL_SHAPE_UP,ROLL_PROPERTY_CLASS,OP_CHOCK_NO_UP,DR_CHOCK_NO_UP,SA1,SA2,SA3,SA4,SA5,SA6,SA7,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_SPEC order by STAND_ID";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
				if(!zgNum.equals("") && !zgAr.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC 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_SPEC 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_SPEC 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_SPEC where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						return cro;	
				}
				}
				
			}
			
			return cro;
	}
	                        
	public CoreReturnObject DoQueryXia(String zgNum, String zgAr,Boolean flag,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String str ="SPEC_NO,STAND_ID,ROLL_TYPE,ROLL_ID_LO,ROLL_DIAMETER_LO,ROLL_CROWN_LO,ROLL_ROUGHNESS_LO,ROLL_SHAPE_LO,ROLL_PROPERTY_CLASS_LO,OP_CHOCK_NO_LO,DR_CHOCK_NO_LO,XA1,XA2,XA3,XA4,XA5,XA6,XA7,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME";
			
			if(!flag)
			{
				
				String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC order by STAND_ID";
			       
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery );
				return cro;
				
			}
			
			else
			{
				if(!zgNum.equals("") && !zgAr.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK05_ROLL_SPEC 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_SPEC 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_SPEC 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_SPEC where  (TO_CHAR(REG_DTIME,'YYYYMMDDHH24MISS') between '"+beginTime+"' and '"+endTime+"')";
							
							cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
							return cro;	
					}
				}
			}
			
			return cro;
	}

}