package UIM.UIM02;

import java.sql.SQLException;

import UIB.COM.XmlSqlParsersFactory;

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

/**
 * 库存报表
 * 
 * @author siy
 * @date 2010-12-3
 */
public class UIM020010 extends CoreIComponent {

	/**
	 * 酸轧成品产、出、存日报表
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject query(String queryDate,String queryDate1,String queryDate2) throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_01.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,//
				new Object[] {
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2});
	}
	public CoreReturnObject querysx(String queryDate,String queryDate1,String queryDate2) throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_SX.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,//
				new Object[] {
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2});
	}
	/**
	 * 原料收发存日报
	 * 
	 * @param day
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryMaterialOfDay(String day) throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_02.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,
				new Object[] { day, day, day, day, day, day, day, day, day, day,
							   day, day, day, day, day, day, day, day, day, day, 
							   day, day, day, day, day, day, day, day, day, day, 
							   day, day, day, day, day, day, day, day, day, day, 
							   //day, day, day, day, day, day, day, day, day, day, 
							   //day, day, day, day, day, day, day, day, day, day,
							   //day, day, day, day, day, day, day, day, day, day,
							   //day, day, day, day, day, day, day, day, day, day,
							   day, day, day, day//, day, day, day, day
							   
				});
	}

	/**
	 * 原料收存月报
	 * 
	 * @param month
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryMaterialOfMonth(String MILL_DTIME1,String MILL_DTIME2,String queryDate)
			throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_03.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,
				new Object[] {
						MILL_DTIME1,MILL_DTIME2,MILL_DTIME1,MILL_DTIME2,
						MILL_DTIME1,MILL_DTIME2,MILL_DTIME1,MILL_DTIME2,
						queryDate, queryDate, queryDate, queryDate,
						MILL_DTIME1,MILL_DTIME2,MILL_DTIME1,MILL_DTIME2,
						queryDate, queryDate, queryDate, queryDate
				});
	//       (?1,?2,?1,?2,   ?1,?2,?1,?2,   ?3,?3,?3,?3,  ?1,?2,?1,?2,    ?3,?3,?3,?3)
	}

	/**
	 * 连退成品产、出、存日报表
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalCoilOfDay(String queryDate,String queryDate1,String queryDate2)
			throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_04.SELECT");
		return this.getDao("KgDao")
				.ExcuteQuery(
						sql,
						new Object[] { 
								/*queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate, queryDate, queryDate, queryDate,
								queryDate */
								queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,	
								queryDate,queryDate1,queryDate2,queryDate2,
								queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
								queryDate,queryDate1,queryDate2,queryDate2,
								queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
								queryDate,queryDate1,queryDate2,queryDate2,queryDate,queryDate1
						});
	}

	/**
	 * 成品产、出、存日报表
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryFinishedCoilOfDay(String queryDate)
			throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_05.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,
				new Object[] { queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,						
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate, queryDate, queryDate, queryDate,
						queryDate, queryDate });
	}

	/**
	 * 酸轧规格明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryPltcmSizeDetail()
			throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_06.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
	}
	
	/**
	 * 酸洗规格明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject querySuanXiSizeDetail()
	throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_09.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
	}
	/**
	 * 酸轧规格新明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryPltcmSizeDetailnew()
			throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIM020010_20.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
	}
	public CoreReturnObject queryPltcmSizeDetailA(String fr_wth,String to_wth,String queryDate)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_18.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_wth, to_wth, queryDate, fr_wth,
				to_wth, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, fr_wth, to_wth,
				queryDate,fr_wth, to_wth, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, fr_wth, to_wth,
				queryDate, queryDate,fr_wth, to_wth, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate,fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate});
	}
	
	public CoreReturnObject queryPltcmSizeDetailE(String fr_Date,String to_Date,String stl)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_19.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_Date,to_Date,stl});
}
	
	/**
	 * 连退规格明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalSizeDetail()
			throws SQLException {
		
		String sql = XmlSqlParsersFactory.getSql("UIM020010_07.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
				
	}
	
	public CoreReturnObject querylcDetail()
	throws SQLException {

String sql = XmlSqlParsersFactory.getSql("UIM020010_lc.SELECT");
return this.getDao("KgDao").ExcuteQuery(sql);
		
}
	
	public CoreReturnObject queryCalSizeDetailnew()
	throws SQLException {

		String sql = XmlSqlParsersFactory.getSql("UIM020010_21.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
		
	}
	/**
	 * 重卷规格明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryRclSizeDetail()
			throws SQLException {
		
		String sql = XmlSqlParsersFactory.getSql("UIM020010_22.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
				
	}
	public CoreReturnObject queryRclSizeDetailnew()
	throws SQLException {

		String sql = XmlSqlParsersFactory.getSql("UIM020010_23.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
		
}
	public CoreReturnObject queryINYARDSizeDetail()
	throws SQLException {

		String sql = XmlSqlParsersFactory.getSql("UIM020010_24.SELECT");
		return this.getDao("KgDao").ExcuteQuery(sql);
		
}
	/**
	 * 连退规格明细选择
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalSizeDetailB(String fr_wth,String to_wth,String queryDate)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_14.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_wth, to_wth, queryDate, fr_wth,
				to_wth, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, fr_wth, to_wth,
				queryDate,fr_wth, to_wth, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, fr_wth, to_wth,
				queryDate, queryDate,fr_wth, to_wth, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate,fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate});
}
	
	/**
	 * 连退规格明细000
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryCalSizeDetailF(String fr_Date,String to_Date,String stl)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_15.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_Date,to_Date,stl});
}
	
	
	
	/**
	 * 重卷规格明细
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryRclSizeDetail(String queryDate1,String queryDate2,String queryDate3)
			throws SQLException {
		//System.out.println("test");
		String sql = XmlSqlParsersFactory.getSql("UIM020010_08.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,//增加23+62个
				new Object[] {queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3, 
						queryDate3,queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate3, queryDate3, 
						queryDate3,queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3,
						queryDate3,queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate1, queryDate2, queryDate3, queryDate1, queryDate2, queryDate1, queryDate2, queryDate3, queryDate3,
						queryDate3, queryDate3, queryDate3, queryDate3, queryDate3, queryDate3});
	}
	
	public CoreReturnObject queryRclSizeDetailC(String fr_wth,String to_wth,String queryDate)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_16.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_wth, to_wth, queryDate, fr_wth,
				to_wth, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, fr_wth, to_wth,
				queryDate,fr_wth, to_wth, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, fr_wth, to_wth,
				queryDate, queryDate,fr_wth, to_wth, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate,fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, fr_wth, to_wth, queryDate,
				fr_wth, to_wth, queryDate, fr_wth, to_wth,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate, queryDate, queryDate,
				queryDate, queryDate, queryDate});
}
	
	/**
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryRclSizeDetailG(String fr_Date,String to_Date,String stl)
	throws SQLException {
String sql = XmlSqlParsersFactory.getSql("UIM020010_17.SELECT");
return this.getDao("KgDao").ExcuteQuery(
		sql,
		new Object[]{fr_Date,to_Date,stl});
}
	
	
	
	

	/**
	 * 库存出入库台帐
	 * 
	 * @param queryDate
	 * @return
	 * @throws SQLException
	 */
	public CoreReturnObject queryStockHis(String beginDate, String endDate,
			String coilNo, String stockFlag) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = "";
		try {
			switch (Integer.parseInt(stockFlag)) {
			case 1:
				sql = XmlSqlParsersFactory.getSql("UIM020010_10.SELECT");// 原料库
				cro = this.getDao("KgDao").ExcuteQuery(
						sql,
						new Object[] { beginDate, endDate, beginDate, endDate,
								coilNo });
				break;
			case 2:
				sql = XmlSqlParsersFactory.getSql("UIM020010_11.SELECT");// 中间库
				cro = this.getDao("KgDao").ExcuteQuery(
						sql,
						new Object[] { beginDate, endDate, beginDate, endDate,
								coilNo });
				break;
			case 3:
			case 4:
				sql = XmlSqlParsersFactory.getSql("UIM020010_12.SELECT");// 连退库
				cro = this.getDao("KgDao").ExcuteQuery(sql,
						new Object[] { beginDate, endDate, coilNo });
				break;
			case 5:
				sql = XmlSqlParsersFactory.getSql("UIM020010_13.SELECT");// 重卷库
				cro = this.getDao("KgDao").ExcuteQuery(sql,
						new Object[] { beginDate, endDate, coilNo });
				break;
			default:
				return cro;
			}

		} catch (NumberFormatException ex) {

		}
		return cro;
	}
}