package UIK.UIK05;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Map;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import UIB.COM.XmlSqlParsersFactory;

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

public class UIK050101 extends CoreIComponent {
	
	public CoreReturnObject DoQuery(String zgNum,String beginTime,String endTime,String beginTime1,String endTime1) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050101_01.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{zgNum, beginTime,endTime,beginTime1,endTime1});						
			
			return cro;
	}
	public CoreReturnObject DoQuerydetail(String zgNum,String beginTime,String endTime) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050101_02.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{zgNum, beginTime,endTime});						
			
			return cro;//DoQuerydetailwithno
	}
	public CoreReturnObject DoQuerydetailwithno(String zgNum) throws SQLException
	{
			CoreReturnObject cro = new CoreReturnObject();
			
				String sqlQuery = XmlSqlParsersFactory.getSql("UIK050101_03.SELECT");
				cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{zgNum});						
			
			return cro;//DoQuerydetailwithno
	}
	public CoreReturnObject PlanAdd(String roll_num,String daima,String cucaodu,String kaishizhijing,String jieshuzhijing,String ruandian,String moxueliang,String chuangbianhao,String yingdu,String kaishi,String jieshu,String gunxing,String yuandu,String liewen) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();
		

		String addSql = "insert into TBS02_ROLL_GRIND(ROLL_NUMBER,PROGRAM_NUMBE,ROUGHNESS,ROLL_DIAMETER_MD_BEFORE," +
				"ROLL_DIAMETER_MD_AFTER,BRUISEMAX,GRIND_AMOUNT,STATION_NO,HARDNESS_MD,GRIND_START_TIME,GRIND_END_TIME,ROLL_TYPE,ROLL_ROUNDNESS,CRACKMAX)" +
				"values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		System.out.print(addSql);//TO_DATE('"+kaishi+"','YYYY-MM-DD hh24:mi:ss'),TO_DATE('"+jieshu+"','YYYY-MM-DD hh24:mi:ss')
		cro = this.getDao("KgDao").ExcuteNonQuery(addSql,new Object[]{roll_num, daima, cucaodu, kaishizhijing, jieshuzhijing, ruandian, moxueliang, chuangbianhao, yingdu,kaishi,jieshu,gunxing,yuandu,liewen});
		return cro;
	 
	}

}