package QCM.QCM01.QCM0101;

import java.sql.SQLException;
import CoreFS.SA06.CoreReturnObject;
import QCM.COMMUNAL.communalClass;
import CoreFS.SA01.CoreIComponent;

public class removeChem extends CoreIComponent  {

	CoreReturnObject cro = new CoreReturnObject();	
	StringBuffer sqlucomm = new StringBuffer();
	//根据化学元素代码删除，传入删除人 删除人ID
	public CoreReturnObject remove(String chemCode,String deleteId,String deleteName) {
		sqlucomm.append("update QCM_BASE_CHEM " +
				"set VALIDFLAG='0' , DELETE_ID='"+deleteId+"' ,DELETE_NAME='"+deleteName+"',DELETE_TIME=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')" +
				"where CHEM_CODE='"+chemCode+"'");
		try {
			cro=this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return cro;
	}
}