XinYu_LZMES/.svn/pristine/1e/1e2eb97b02940daffce95b5ca434c51612985c2b.svn-base

package QCM.QCM01.QCM0101;
import java.sql.SQLException;
import java.util.ArrayList;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;
import QCM.COMMUNAL.communalClass;
import QCM.COMMUNAL.sqlCount;

public class SaveChem extends CoreIComponent {
	CoreReturnObject cro = new CoreReturnObject();	
	StringBuffer sqlucomm =null;
	int count=0;
	//元素代码、元素名称、元素类型、公式、缺陷类型、备注、修改人ID、修改人
	public CoreReturnObject Save(ArrayList updateChem) {
		sqlCount countWay= new sqlCount();
		count=countWay.countData("QCM_BASE_CHEM","CHEM_CODE",(String)updateChem.get(0),1);
		if(count>0){
			sqlucomm=new StringBuffer();
			sqlucomm.append("update QCM_BASE_CHEM "+
						"set CHEM_NAME=?,CHEM_TYPE=?,CHEM_FORMULA=?,DEFECT_TYPE_DESC=?,"+
						"MEMO=?,UPDATE_ID=?,UPDATE_NAME=?,UPDATE_TIME=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')"+
						" where CHEM_CODE=?" );
			Object[] obj = new Object[]{updateChem.get(1),updateChem.get(2),updateChem.get(3),updateChem.get(4),updateChem.get(5),updateChem.get(6),updateChem.get(7),updateChem.get(0)};
			try {
				cro=this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}else{
			cro.setResult("当前修改的数据是无效的，请刷新页面");
		}
		return cro;
	}

}