XinYu_LZMES/.svn/pristine/88/881546184a47e55ed85166a2bcacb9f099b8c800.svn-base

package UIE.UIE01;

import java.sql.SQLException;


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

public class UIE041010 extends CoreIComponent {
	/**
	 * 工序实得率录入
	 * @param 
	 * @return CoreReturnObject
	 * @throws SQLException
	 */
	public CoreReturnObject query01(String areaType) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		str.append("SELECT \n");
		str.append("USED_YN, 			--是否启用 \n");
		str.append("A.PROC_RATE,		-- 实得率 \n");
		str.append("A.MOD_ID,			-- 修改者 \n");
		str.append("A.MOD_DTIME,		-- 修改时间 \n");
		str.append("B.SM_CFNM PROC_NM,	-- 工厂名称 \n");
		str.append("B.SM_CD PROC_CD		-- 工厂代码 \n");
		str.append("FROM TBE01_PROC_RATE A, \n");
		str.append("(SELECT SM_CD, SM_CFNM, CD_SEQ FROM TBZ00_COMMCD WHERE LG_CD = 'F01002') B \n");
		str.append("WHERE B.SM_CD = A.PROC_CD(+) \n");
		str.append("AND   A.USED_YN = 'Y' \n");
		str.append("ORDER BY B.CD_SEQ \n");

		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteQuery(sql);
		
		System.out.println(cro);
		return cro;
	}
	
	public CoreReturnObject update01(String procRate,String usedYN,String procCD) throws SQLException
	{
		CoreReturnObject cro=new CoreReturnObject();
		StringBuffer str = new StringBuffer();
		
		str.append("update TBE01_PROC_RATE \n");
		str.append("set proc_rate = :1").append(" \n");
		str.append(",used_yn = :2").append(" \n");
		str.append("where proc_cd = :3").append(" \n");
		String sql = str.toString();
		cro=this.getDao("KgDao").ExcuteNonQuery(sql, new Object[] {procRate,usedYN,procCD});
		
		System.out.println(cro);
		return cro;
	}
}