package UIK.UIK03;

import java.sql.SQLException;

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

	public CoreReturnObject DoQuery(String mc_id,String starttiem,String endtime,Boolean flag ) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "MAIN_MC_NAME,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,REG_IN_ID,TO_CHAR(REG_IN_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_IN_DTIME,MC_STAT,MC_ID,MC_INSTAL_COUNT,REQ_SPAR_COUNT,REA_STO_CONUT,MC_CHECKREASON,MC_CHANGTIME,MC_CHECKCYCLE,MC_CHECKTIME,MC_CHANGCYCLE,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 REG_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 REG_IN_DTIME >= TO_DATE('"+starttiem+"','yyyy-mm-dd') and REG_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 REG_IN_DTIME >= TO_DATE('"+starttiem+"','yyyy-mm-dd') and REG_IN_DTIME <= TO_DATE('"+endtime+"','yyyy-mm-dd')";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				}
			}
			return cro;

	}
	
	
	public CoreReturnObject DoSelect(String IREG_IN_DTIME ) 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,REG_IN_ID,REG_IN_DTIME,MC_STAT,MAIN_MC_NAME,MC_INSTAL_COUNT,REQ_SPAR_COUNT,REA_STO_CONUT,MC_CHECKREASON,MC_CHANGTIME,MC_CHECKCYCLE,MC_CHECKTIME,MC_CHANGCYCLE,AREA";
			
			String sqlQuery	=	"select " + str+" from C_TBK03_MACHINE_ONLINE where REG_IN_DTIME =TO_DATE('"+IREG_IN_DTIME+"','YYYY-MM-DD HH24:MI:SS')";
			
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
			
			return cro;
		
	}
	
	public CoreReturnObject DoUpdate(String IMC_NAME,String IMC_MODEL,String IMC_SPEC,String IMC_FACTORY,String IMC_IN_DTIME, String IMC_PRICE,String IMC_CARE_SECTOR,String IMC_NOM_CAP,String IMC_UNIT,String IMC_TAI,String IMC_ACT,String IMC_MFACTUR_UNITS,String IMC_USE_YEAR,String IMC_USE_TIME,String IMC_INSTAL_LOCAL,String IREG_IN_ID,String reg_intime,String IMC_STAT,String IMAIN_MC_NAME,String IMC_INSTAL_COUNT,String IREQ_SPAR_COUNT,String IREA_STO_CONUT,String IMC_CHECKREASON,String IMC_CHANGTIME,String IMC_CHECKCYCLE,String IMC_CHECKTIME,String IMC_CHANGCYCLE,String IAREA  ) 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,REG_IN_ID,REG_IN_DTIME,MC_STAT";
			
			//String sqlQuery	=	"update C_TBK03_MACHINE_ONLINE  set MC_NAME = '"+IMC_NAME+"',MC_MODEL = '"+IMC_MODEL+"' ,MC_SPEC= '"+IMC_SPEC+"',MC_FACTORY= '"+IMC_FACTORY+"',MC_IN_DTIME= TO_DATE('"+IMC_IN_DTIME+"','yyyy-mm-dd'),MC_PRICE= '"+IMC_PRICE+"',MC_CARE_SECTOR= '"+IMC_CARE_SECTOR+"',MC_NOM_CAP= '"+IMC_NOM_CAP+"',MC_UNIT= '"+IMC_UNIT+"',MC_TAI= '"+IMC_TAI+"',MC_ACT= '"+IMC_ACT+"',MC_MFACTUR_UNITS= '"+IMC_MFACTUR_UNITS+"',MC_USE_YEAR= '"+IMC_USE_YEAR+"',MC_USE_TIME= TO_DATE('"+IMC_USE_TIME+"','yyyy-mm-dd'),MC_INSTAL_LOCAL= '"+IMC_INSTAL_LOCAL+"',REG_IN_ID= '"+IREG_IN_ID+"',REG_IN_DTIME= TO_DATE('"+IREG_IN_DTIME+"','yyyy-mm-dd'),MC_STAT= '"+IMC_STAT+"' where MC_ID ="+mcid;
			
			String sqlQuery	=	"update C_TBK03_MACHINE_ONLINE  set MC_NAME =?,MC_MODEL =? ,MC_SPEC=?,MC_FACTORY=? ,MC_IN_DTIME= TO_DATE('"+IMC_IN_DTIME+"','yyyy-mm-dd'),MC_PRICE=?,MC_CARE_SECTOR= ?,MC_NOM_CAP=?,MC_UNIT= ?,MC_TAI=?,MC_ACT= ?,MC_MFACTUR_UNITS= ?,MC_USE_YEAR=?,MC_USE_TIME= TO_DATE('"+IMC_USE_TIME+"','yyyy-mm-dd'),MC_INSTAL_LOCAL= ?,REG_IN_ID= ?,MC_STAT=?,MAIN_MC_NAME=?, MC_INSTAL_COUNT=?, REQ_SPAR_COUNT=?, REA_STO_CONUT=?, MC_CHECKREASON=?, MC_CHANGTIME=TO_DATE('"+IMC_CHANGTIME+"','YYYY-MM-DD'), MC_CHECKCYCLE=?, MC_CHECKTIME=TO_DATE('"+IMC_CHECKTIME+"','YYYY-MM-DD'), MC_CHANGCYCLE=?,AREA = ? where REG_IN_DTIME =TO_DATE('"+reg_intime+"','YYYY-MM-DD HH24:MI:SS')";
			
			Object[] obj = new Object[]{IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_INSTAL_LOCAL, IREG_IN_ID, IMC_STAT,IMAIN_MC_NAME, IMC_INSTAL_COUNT, IREQ_SPAR_COUNT, IREA_STO_CONUT, IMC_CHECKREASON, IMC_CHECKCYCLE, IMC_CHANGCYCLE,IAREA};
			//Object[] obj = new Object[]{mcid,IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY,IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR,IMC_USE_TIME, IMC_INSTAL_LOCAL, IREG_IN_ID,IREG_IN_DTIME, IMC_STAT};
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlQuery,obj);
			
			return cro;
		
	}
	
	public CoreReturnObject DoInsert(String mcid,String IMC_NAME,String IMC_MODEL,String IMC_SPEC,String IMC_FACTORY,String IMC_IN_DTIME, String IMC_PRICE,String IMC_CARE_SECTOR,String IMC_NOM_CAP,String IMC_UNIT,String IMC_TAI,String IMC_ACT,String IMC_MFACTUR_UNITS,String IMC_USE_YEAR,String IMC_USE_TIME,String IMC_INSTAL_LOCAL,String IREG_IN_ID,String IREG_IN_DTIME,String IMC_STAT,String IMAIN_MC_NAME,String IMC_INSTAL_COUNT,String IREQ_SPAR_COUNT,String IREA_STO_CONUT,String IMC_CHECKREASON,String IMC_CHANGTIME,String IMC_CHECKCYCLE,String IMC_CHECKTIME,String IMC_CHANGCYCLE,String IAREA  ) 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,REG_IN_ID,REG_IN_DTIME,MC_STAT";
			
			//String sqlQuery	=	"update C_TBK03_MACHINE_ONLINE  set MC_NAME = '"+IMC_NAME+"',MC_MODEL = '"+IMC_MODEL+"' ,MC_SPEC= '"+IMC_SPEC+"',MC_FACTORY= '"+IMC_FACTORY+"',MC_IN_DTIME= TO_DATE('"+IMC_IN_DTIME+"','yyyy-mm-dd'),MC_PRICE= '"+IMC_PRICE+"',MC_CARE_SECTOR= '"+IMC_CARE_SECTOR+"',MC_NOM_CAP= '"+IMC_NOM_CAP+"',MC_UNIT= '"+IMC_UNIT+"',MC_TAI= '"+IMC_TAI+"',MC_ACT= '"+IMC_ACT+"',MC_MFACTUR_UNITS= '"+IMC_MFACTUR_UNITS+"',MC_USE_YEAR= '"+IMC_USE_YEAR+"',MC_USE_TIME= TO_DATE('"+IMC_USE_TIME+"','yyyy-mm-dd'),MC_INSTAL_LOCAL= '"+IMC_INSTAL_LOCAL+"',REG_IN_ID= '"+IREG_IN_ID+"',REG_IN_DTIME= TO_DATE('"+IREG_IN_DTIME+"','yyyy-mm-dd'),MC_STAT= '"+IMC_STAT+"' where MC_ID ="+mcid;
			
			String sqlQuery	=	"insert into C_TBK03_MACHINE_ONLINE(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,REG_IN_ID,REG_IN_DTIME,MC_STAT,MAIN_MC_NAME,MC_INSTAL_COUNT,REQ_SPAR_COUNT,REA_STO_CONUT,MC_CHECKREASON,MC_CHANGTIME,MC_CHECKCYCLE,MC_CHECKTIME,MC_CHANGCYCLE,AREA) values(?,?,?,?,?,TO_DATE('"+IMC_IN_DTIME+"','yyyy-mm-dd'),?,?,?,?,?,?,?,?,TO_DATE('"+IMC_USE_TIME+"','yyyy-mm-dd'),?,?,TO_DATE('"+IREG_IN_DTIME+"','YYYY-MM-DD HH24:MI:SS'),?,?,?,?,?,?,TO_DATE('"+IMC_CHANGTIME+"','yyyy-mm-dd'),?,TO_DATE('"+IMC_CHECKTIME+"','yyyy-mm-dd'),?,?)";
			
			Object[] obj = new Object[]{mcid,IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_INSTAL_LOCAL, IREG_IN_ID, IMC_STAT,IMAIN_MC_NAME, IMC_INSTAL_COUNT, IREQ_SPAR_COUNT, IREA_STO_CONUT, IMC_CHECKREASON, IMC_CHECKCYCLE, IMC_CHANGCYCLE,IAREA };
			//Object[] obj = new Object[]{mcid,IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY,IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR,IMC_USE_TIME, IMC_INSTAL_LOCAL, IREG_IN_ID,IREG_IN_DTIME, IMC_STAT};
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlQuery,obj);
			
			return cro;
		
	}
	                        
}