XinYu_LZMES/.svn/pristine/57/57915ded0a822947b89a889c2e23e42b81e40a92.svn-base

package UIK.UIK03;

import java.sql.SQLException;

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

public class UIK030030 extends CoreIComponent  {

	public CoreReturnObject DoQuery(String mc_id,String starttiem,String endtime,Boolean flag ) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "MC_ID,MC_NAME,MC_MODEL,MC_SPEC,MC_FACTORY,MC_IN_DTIME,MC_PRICE,MC_CARE_SECTOR,MC_NOM_CAP,MC_UNIT,MC_TAI,MC_ACT,MC_MFACTUR_UNITS,MC_USE_YEAR,MC_USE_TIME,MC_INSTAL_LOCAL,MC_STAT,MC_INSTAL_COUNT,REQ_SPAR_COUNT,REA_STO_CONUT,MC_CHECKREASON,MC_CHANGTIME,MC_CHECKCYCLE,MC_CHECKTIME,MC_CHANGCYCLE,MAIN_MC_NAME,AREA";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
				if(mc_id.equals("")&& !starttiem.equals("")&&!endtime.equals(""))
				{
					if(starttiem == endtime)
					{
						String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE where MC_IN_DTIME = TO_DATE('"+starttiem+"','yyyy-mm-dd')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						
						return cro;
					}
					else
					{
						String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE where MC_IN_DTIME >= TO_DATE('"+starttiem+"','yyyy-mm-dd') and MC_IN_DTIME <= TO_DATE('"+endtime+"','yyyy-mm-dd')";
						
						cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
						
						return cro;
					}
				}
				
				if(!mc_id.equals("")&& starttiem.equals("")&&endtime.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE where MAIN_MC_NAME = '"+mc_id+"'";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				}
				
				if (!mc_id.equals("")&& !starttiem.equals("")&& !endtime.equals(""))
				{
					String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE where MAIN_MC_NAME ="+mc_id+" and MC_IN_DTIME >= TO_DATE('"+starttiem+"','yyyy-mm-dd') and MC_IN_DTIME <= TO_DATE('"+endtime+"','yyyy-mm-dd')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				}
			}
			return cro;

	}
	
}