package UIF.UIF07;

import java.sql.SQLException;
import java.util.ArrayList;
import java.lang.Object;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import UIB.COM.XmlSqlParsersFactory;

public class UIF071010 extends CoreIComponent {
	// 根据条件获得包装钢卷信息
	public CoreReturnObject queryCalCoil(String where) throws SQLException {
		try {
			CoreReturnObject cro = new CoreReturnObject();
			String sql = XmlSqlParsersFactory.getSql("UIF071010_01.SELECT");
			sql = sql + where;
			cro = this.getDao("KgDao").ExcuteQuery(sql);
			return cro;
		} catch (Exception ex) {
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}

	// 获取编制的包装的汇总信息
	public CoreReturnObject queryPkgData() throws SQLException {
		try {
			CoreReturnObject cro = new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF071010_02.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		} catch (Exception ex) {
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}

	// 获取编制的包装的明细信息
	public CoreReturnObject queryPkgList() throws SQLException {
		try {
			CoreReturnObject cro = new CoreReturnObject();
			String Sql = XmlSqlParsersFactory.getSql("UIF071010_03.SELECT");
			cro = this.getDao("KgDao").ExcuteQuery(Sql);
			return cro;
		} catch (Exception ex) {
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}

	/**
	 * 修改包装等级
	 * 
	 * @param coilNo
	 * @param pkgLvl
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject updatePkgLevel(String coilNo, String pkgNo,
			String pkgLvl) throws SQLException {
		try {
			CoreReturnObject cro = new CoreReturnObject();
			String sql = XmlSqlParsersFactory.getSql("UIF071010_01.UPDATE");
			cro = this.getDao("KgDao").ExcuteNonQuery(sql,
					new Object[] { pkgLvl, pkgNo, coilNo });
			return cro;
		} catch (Exception ex) {
			CoreReturnObject err = new CoreReturnObject();
			err.SetErrInfo(ex.toString());
			return err;
		}
	}
}