package UIM;

import java.sql.SQLException;

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

/**
 * 堆垛原则维护类
 * @author siy
 * @date 2010-8-4
 */
public class UIM010030 extends CoreIComponent{
	/**
	 * 查询堆垛原则
	 * @param areaNo
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject queryYardStd(String areaNo) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		
		String sql = "select yard_kind,area_kind,yard_addr,from_stl_grd,to_stl_grd,stl_grd1,stl_grd2,stl_grd3,stl_grd4,stl_grd5,stl_grd6,stl_grd7 from c_tbk08_yard_std_stock";
		sql += " order by yard_kind";
		cro=this.getDao("KgDao").ExcuteQuery(sql);

		return cro;
	}
	
	/**
	 * 添加堆垛原则
	 * @param yardKind
	 * @param areaKind
	 * @param yardAddr
	 * @param fromStlGrd
	 * @param toStlGrd
	 * @param stlGrd1
	 * @param stlGrd2
	 * @param stlGrd3
	 * @param stlGrd4
	 * @param stlGrd5
	 * @param stlGrd6
	 * @param stlGrd7
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject addYardRule(String yardKind, String areaKind, 
			String yardAddr, String fromStlGrd, String toStlGrd, 
			String stlGrd1, String stlGrd2, String stlGrd3, String stlGrd4, 
			String stlGrd5, String stlGrd6, String stlGrd7) throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();

		String addSql = "insert into c_tbk08_yard_std_stock (yard_kind,area_kind,"
				+ "yard_addr,from_stl_grd,to_stl_grd,stl_grd1,stl_grd2,stl_grd3," +
						"stl_grd4,stl_grd5,stl_grd6,stl_grd7) values ('"
				+ yardKind + "','" + areaKind + "','" + yardAddr + "','" + fromStlGrd
				+ "','" + toStlGrd + "','" + stlGrd1 + "','"+ stlGrd2 + "','"+ stlGrd3 
				+ "','"+ stlGrd4 + "','"+ stlGrd5 + "','"+ stlGrd6 + "','" + stlGrd7 + "')";
		
		cro = this.getDao("KgDao").ExcuteNonQuery(addSql);
		return cro;
	}
	
	public CoreReturnObject updateYardRule(String yardKind, String areaKind, 
			String yardAddr, String fromStlGrd, String toStlGrd, 
			String stlGrd1, String stlGrd2, String stlGrd3, String stlGrd4, 
			String stlGrd5, String stlGrd6, String stlGrd7)throws SQLException
	{
		CoreReturnObject cro = new CoreReturnObject();

		String updSql = "update c_tbk08_yard_std_stock set from_stl_grd = '" 
			+ fromStlGrd + "',to_stl_grd = '" + toStlGrd + "',stl_grd1='" + stlGrd1 
			+ "',stl_grd2='" + stlGrd2 + "',stl_grd3='" + stlGrd3 + "',stl_grd4='" 
			+ stlGrd4 + "',stl_grd5='" + stlGrd5 + "',stl_grd6=" + stlGrd6 
			+ "'',stl_grd7='" + stlGrd7 + "' where yard_kind='" + yardKind 
			+ "' and area_kind='" + areaKind + "' and yard_addr='" + yardAddr + "'";
		
		cro = this.getDao("KgDao").ExcuteNonQuery(updSql);
		return cro;
	}
	
	/**
	 * 删除堆垛原则
	 * 
	 * @param yardKind 仓库类型
	 * @param areaKind 区域类型
	 * @param yardAddr 堆放位置
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject delYardRule(String yardKind,String areaKind,String yardAddr) throws SQLException {
		CoreReturnObject cro = new CoreReturnObject();
		String sql = "delete from c_tbk08_yard_std_stock where";
		sql += " yard_kind = '" + yardKind + "'";
		sql += " and area_kind = '" + areaKind + "'";
		sql += " and yard_addr = '" + yardAddr + "'";

		cro = this.getDao("KgDao").ExcuteNonQuery(sql);

		return cro;
	}
}