package UIK.UIK01;

import java.sql.SQLException;
import java.util.ArrayList;

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

	public CoreReturnObject DoQuery(String starttiem,String endtime,Boolean flag) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			String sql	=	"select 'FALSE' CHK, RECORD_ID,SPA_CCT,SPA_CDT,NAOH_CON_1,FE_CON_1,OIL_CON_1,CDT_1,AKL_CCT_1" +
					",NAOH_CON_2,FE_CON_2,OIL_CON_2,CDT_2,AKL_CCT_2" +
					",REG_ID,REG_DTIME,SAM_DATE,SAM_TIME,SAM_ADDRESS,PH_CON_3,CL_CON_3,PH_CON4,IR_CON4 from c_tbk01_lt_result" +
					" WHERE 1 = 1";
		    if(flag){
		    	sql += " AND SUBSTR(REG_DTIME,1,8) BETWEEN '"+starttiem+"' AND '"+endtime+"'";
		    }
			cro = this.getDao("KgDao").ExcuteQuery(sql);
			return cro;
	}
	
	public CoreReturnObject DoUpdate(ArrayList args) throws SQLException
	{
		String sqlQuery	="UPDATE C_TBK01_LT_RESULT \n"
							   +"SET SPA_CCT = ?,\n"
							   +"SPA_CDT     = ?,\n"
							   +"NAOH_CON_1  = ?,\n"
							   +"FE_CON_1    = ?,\n"
							   +"OIL_CON_1   = ?,\n"
							   +"CDT_1       = ?,\n"
							   +"AKL_CCT_1   = ?,\n"
							   +"NAOH_CON_2  = ?,\n"
							   +"FE_CON_2    = ?,\n"
							   +"OIL_CON_2   = ?,\n"
							   +"CDT_2       = ?,\n"
							   +"AKL_CCT_2   = ?,\n"
							   +"ALTER_TIME  = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'),\n"
							   +"SAM_DATE    = ?,\n"
							   +"SAM_ADDRESS = ?,\n"							   
							   +"SAM_TIME    = ?,\n"
							   +"PH_CON_3 	 = ?,\n"
							   +"CL_CON_3	 = ?,\n"
							   +"PH_CON4 	 = ?,\n"
							   +"IR_CON4	 = ?\n"
							   +"WHERE RECORD_ID = ?";
		return this.getDao("KgDao").ExcuteNonQuery(sqlQuery,args.toArray());
	}
	
	public CoreReturnObject DoInsert(ArrayList args) throws SQLException
	{	
		String sql	=	"INSERT INTO C_TBK01_LT_RESULT( RECORD_ID,SPA_CCT,SPA_CDT,NAOH_CON_1,FE_CON_1\n"
								+",OIL_CON_1,CDT_1,AKL_CCT_1,NAOH_CON_2,FE_CON_2,OIL_CON_2,CDT_2,AKL_CCT_2\n"
								+",SAM_ADDRESS,SAM_DATE,SAM_TIME,PH_CON_3,CL_CON_3,PH_CON4,IR_CON4,REG_ID,REG_DTIME)\n"
								+"VALUES(\n"
								+"(SELECT TRIM(TO_CHAR(SYSDATE, 'YYYYMMDD')) ||\n"
								+"              TRIM(TO_CHAR(NVL(TO_NUMBER(SUBSTR(MAX(RECORD_ID), -4, 4)) + 1, 1),\n"
								+"		                       '0000')) AS RECORD_ID\n"
								+"		     FROM C_TBK01_LT_RESULT\n"
								+"		    WHERE RECORD_ID LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%'),\n"
								+"        ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,to_char(sysdate,'yyyymmddhh24miss')\n"
								+")";
		return this.getDao("KgDao").ExcuteNonQuery(sql,args.toArray());
	}
}