package UIK.UIK01;

import java.sql.SQLException;

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

public class UIK010010  extends CoreIComponent{

	public CoreReturnObject DoQuery(String starttiem,String endtime,Boolean flag ) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "DENSITY,VISCOSITY,FLASH_POINT,FREEZ_POINT,STABILITY,CONCENT,ESI,ACID,PH,CONDUCTIVITY,SAPONIFICATION_VALUE,FE_VALUE,ASH_VALUE,C_VALUE,CL_VALUE,BACTERIA_FUNGI,TEMPERATURE,REG_ID,TO_CHAR(REG_DTIME,'YYYY-MM-DD HH24:MI:SS') REG_DTIME, MAG_OIL,BER_CON,TO_CHAR(SAM_DATE,'YYYY-MM-DD') SAM_DATE,SAM_TIME,SAM_ADDRESS,CANYOU,CATIE,STL_GRD,TYPH";
			
			if(!flag)
			{
				
					String sqlQuery	=	"select " + str+" from C_TBK01_RH_RESULT";
				       
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
					
			}
			else
			{
								
					String sqlQuery	=	"select " + str+" from C_TBK01_RH_RESULT where REG_DTIME >= TO_DATE('"+starttiem+"','YYYY-MM-DD HH24:MI:SS') and REG_DTIME <= TO_DATE('"+endtime+"','YYYY-MM-DD HH24:MI:SS') ";
					
					cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
					
					return cro;
				
			}

	}
	
	public CoreReturnObject DoSelect(String ireg_datetime ) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
			String str = "DENSITY,VISCOSITY,FLASH_POINT,FREEZ_POINT,STABILITY,CONCENT,ESI,ACID,PH,CONDUCTIVITY,SAPONIFICATION_VALUE,FE_VALUE,ASH_VALUE,C_VALUE,CL_VALUE,BACTERIA_FUNGI,TEMPERATURE,REG_ID,REG_DTIME,MAG_OIL,BER_CON,TO_CHAR(SAM_DATE,'YYYY-MM-DD') SAM_DATE,SAM_TIME,SAM_ADDRESS,CANYOU,CATIE,STL_GRD,TYPH";
			
			String sqlQuery	=	"select " + str+" from C_TBK01_RH_RESULT where REG_DTIME = TO_DATE('"+ireg_datetime+"','YYYY-MM-DD HH24:MI:SS')";
			
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery);
			
			return cro;
		
	}
	
	public CoreReturnObject DoUpdate(String IDENSITY,String IVISCOSITY,String IFLASH_POINT,String IFREEZ_POINT,String ISTABILITY,String ICONCENT,String IESI,String IACID,String IPH,String ICONDUCTIVITY,String ISAPONIFICATION_VALUE,String IFE_VALUE,String IASH_VALUE,String IC_VALUE,String ICL_VALUE,String IBACTERIA_FUNGI,String ITEMPERATURE,String IREG_ID,String IALTER_TIME,String  IREG_DTIME,String IMAG_OIL,String IBER_CON,String ISAM_DATE,String ISAM_TIME,String ISAM_ADDRESS,String CANYOU,String CANTIE ,String GANGZ,String TYPH) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();					

			String sqlQuery	="update C_TBK01_RH_RESULT  set DENSITY=?,VISCOSITY=?,FLASH_POINT=?,FREEZ_POINT=?,STABILITY=?,CONCENT=?,ESI=?,ACID=?,PH=?,CONDUCTIVITY=?,SAPONIFICATION_VALUE=?,FE_VALUE=?,ASH_VALUE=?,C_VALUE=?,CL_VALUE=?,BACTERIA_FUNGI=?,TEMPERATURE=?,REG_ID=?,ALTER_TIME=?, MAG_OIL=?, BER_CON=?, SAM_DATE=TO_DATE('"+ISAM_DATE+"','YYYY-MM-DD'), SAM_TIME=?, SAM_ADDRESS=? ,CANYOU=?,CATIE=?,STL_GRD=?,TYPH=? where REG_DTIME =TO_DATE('"+IREG_DTIME+"','YYYY-MM-DD HH24:MI:SS')";
			
			Object[] obj = new Object[]{ IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID, IALTER_TIME, IMAG_OIL, IBER_CON, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ,TYPH };
			
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlQuery,obj);	
			
			return cro;
		
	}
	
	public CoreReturnObject DoInsert(String IDENSITY,String IVISCOSITY,String IFLASH_POINT,String IFREEZ_POINT,String ISTABILITY,String ICONCENT,String IESI,String IACID,String IPH,String ICONDUCTIVITY,String ISAPONIFICATION_VALUE,String IFE_VALUE,String IASH_VALUE,String IC_VALUE,String ICL_VALUE,String IBACTERIA_FUNGI,String ITEMPERATURE,String IREG_ID,String ireg_datetime,String IMAG_OIL,String IBER_CON,String ISAM_DATE,String ISAM_TIME,String ISAM_ADDRESS,String CANYOU,String CANTIE ,String GANGZ ,String TYPH) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();							
			
			String sqlQuery	=	"insert into C_TBK01_RH_RESULT(DENSITY,VISCOSITY,FLASH_POINT,FREEZ_POINT,STABILITY,CONCENT,ESI,ACID,PH,CONDUCTIVITY,SAPONIFICATION_VALUE,FE_VALUE,ASH_VALUE,C_VALUE,CL_VALUE,BACTERIA_FUNGI,TEMPERATURE,REG_ID,REG_DTIME,MAG_OIL,BER_CON,SAM_DATE,SAM_TIME,SAM_ADDRESS,CANYOU,CATIE,STL_GRD,TYPH ) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_DATE('"+ireg_datetime+"','YYYY-MM-DD HH24:MI:SS'),?,?,TO_DATE('"+ISAM_DATE+"','YYYY-MM-DD'),?,?,?,?,?,?)";
			
			Object[] obj = new Object[]{IDENSITY, IVISCOSITY, IFLASH_POINT, IFREEZ_POINT, ISTABILITY, ICONCENT, IESI, IACID, IPH, ICONDUCTIVITY, ISAPONIFICATION_VALUE, IFE_VALUE, IASH_VALUE, IC_VALUE, ICL_VALUE, IBACTERIA_FUNGI, ITEMPERATURE, IREG_ID,IMAG_OIL, IBER_CON, ISAM_TIME, ISAM_ADDRESS,CANYOU,CANTIE,GANGZ ,TYPH};
			
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlQuery,obj);
			
			return cro;
		
	}
}