XinYu_LZMES/.svn/pristine/64/64ce43fb334dd98d3f53ddc443d4dd8723e274aa.svn-base

package QCM.QCM01.QCM0102;

import java.sql.SQLException;
import java.util.ArrayList;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import QCM.COMMUNAL.communalClass;


public class removePhy extends CoreIComponent  {
	CoreReturnObject cro = new CoreReturnObject();	
	StringBuffer sqlucomm = new StringBuffer();
	
	//根据项目代码删除，传入项目代码、删除人、删除人ID
	public CoreReturnObject remove(ArrayList BaseChem) {
		sqlucomm.append("update QCM_BASE_PHY "+
						"set VALIDFLAG='0',DELETE_ID=?,DELETE_NAME=?,DELETE_TIME=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')"+
						" where PHY_GRP_CODE=?");
		Object[] obj=new Object[]{BaseChem.get(1),BaseChem.get(2),BaseChem.get(0)};
		try {
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return cro;
	}

}