package UIM.UIM02;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 连退计划查询
 * 
 * @author siy
 * @date 2011-08-19
 */
public class UIM020040 extends CoreIComponent {
	/**
	 * 查询连退轧制单元
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalNo() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIM020040_01.SELECT");
		PreparedStatement pSta = this.getDao("KgDao").getPreparedStatement(sql);
		ResultSet rs = pSta.executeQuery();
		ArrayList<String[]> list = new ArrayList<String[]>();
		String[] param = null;
		while (rs.next()) {
			param = new String[2];
			param[0] = rs.getString("SEQ");
			param[1] = rs.getString("CAL_NO");
			list.add(param);
		}
		cro.setResult(list);
		
		rs.close();
		Connection con = pSta.getConnection();
		pSta.close();
		con.close();
		return cro;
	}
	
	/**
	 * 查询连退过度卷轧制单元
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryInterimCalNo() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = XmlSqlParsersFactory.getSql("UIM020040_06.SELECT");
		PreparedStatement pSta = this.getDao("KgDao").getPreparedStatement(sql);
		ResultSet rs = pSta.executeQuery();
		ArrayList<String[]> list = new ArrayList<String[]>();
		String[] param = null;
		while (rs.next()) {
			param = new String[2];
			param[0] = rs.getString("SEQ");
			param[1] = rs.getString("CAL_NO");
			list.add(param);
		}
		cro.setResult(list);
		
		rs.close();
		Connection con = pSta.getConnection();
		pSta.close();
		con.close();
		return cro;
	}
	
	/**
	 * 查询连退计划
	 * @param calNo
	 * @param pFromDate
	 * @param pToDate
	 * @param mFromDate
	 * @param mToDate
	 * @param ordNo
	 * @param ordSeq
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalPlan(String calNo,String calNo2,String pFromDate,String pToDate, String mFromDate, String mToDate, String ordNo,String ordSeq,Boolean flag) throws SQLException 
	{
		CoreReturnObject cro = null;
		if(!flag){
			String sqlQuery = XmlSqlParsersFactory.getSql("UIM020040_02.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{calNo,calNo2, mFromDate, mToDate, ordNo, ordSeq});
		}
		else{
			String sqlQuery = XmlSqlParsersFactory.getSql("UIM020040_03.SELECT");    
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{ pFromDate, pToDate, mFromDate, mToDate, ordNo, ordSeq});
		}
		return cro;
	}
	/**
	 * 查询连退过度卷计划
	 * @param calNo
	 * @param pFromDate
	 * @param pToDate
	 * @param mFromDate
	 * @param mToDate
	 * @param ordNo
	 * @param ordSeq
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryInterimCalPlan(String calNo,String calNo2,String pFromDate,String pToDate, String mFromDate, String mToDate, String ordNo,String ordSeq,Boolean flag) throws SQLException 
	{
		CoreReturnObject cro = null;
		if(!flag){
			String sqlQuery = XmlSqlParsersFactory.getSql("UIM020040_04.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{calNo,calNo2, mFromDate, mToDate, ordNo, ordSeq});
		}
		else{
			String sqlQuery = XmlSqlParsersFactory.getSql("UIM020040_05.SELECT");    
			cro = this.getDao("KgDao").ExcuteQuery(sqlQuery,new Object[]{ pFromDate, pToDate, mFromDate, mToDate, ordNo, ordSeq});
		}
		return cro;
	}
}