package UIM;

import java.io.StringWriter;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.Document;
import org.w3c.dom.Element;

import UIB.COM.XmlSqlParsersFactory;
import UIM.UIM01.BEANS.YardArea;

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

/**
 * 冷轧原料库库存现况查询
 * 
 * @author siy
 * @date 2010-09-02
 */
public class UIM010220 extends CoreIComponent {
	/**
	 * 查询库存垛位及钢卷统计信息
	 */
	public CoreReturnObject queryStockCount(String stockNo) throws SQLException {

		String sql = XmlSqlParsersFactory.getSql("UIM010220_01.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { stockNo, stockNo });
	}

	/**
	 * 查询库存垛位及钢卷统计信息
	 */
	public CoreReturnObject queryAreaCoils(String stockNo, Integer minRow,
			Integer maxRow) throws SQLException {

		String sql = XmlSqlParsersFactory.getSql("UIM010220_02.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql,
				new Object[] { stockNo, minRow, maxRow });
	}
}