package UIM.UIM05;

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

import java.util.List;

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

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 总貌图
 * 
 * @author siy
 * @date 2011-11-24
 */
public class UIM050010 extends CoreIComponent {
	/**
	 * 查询酸轧实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getPltcmData() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_01.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}

	/**
	 * 查询连退实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getCalData() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_02.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}

	/**
	 * 查询重卷实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getRclData() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_03.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}
	
	/**
	 * 查询酸轧实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getPltcmInfo() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_04.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}

	/**
	 * 查询连退实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getCalInfo() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_05.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}

	/**
	 * 查询重卷实时生产钢卷
	 * 
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject getRclInfo() throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		try {
			String sql = XmlSqlParsersFactory.getSql("UIM050010_06.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(sql);
		} catch (Exception ex) {

		}
		return cro;
	}
}