XinYu_LZMES/.svn/pristine/d9/d93d6ba04d96e72e1f3f50978a83604ae010220f.svn-base

package QCM.QCM01.QCM0104;
import java.sql.ResultSet;
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 SaveDete extends CoreIComponent {
	CoreReturnObject cro = new CoreReturnObject();	
	StringBuffer sqlucomm = null;
	int count=0;
	ResultSet rs=null;
	//参数：探伤描述、缺陷分类描述、备注、创建人ID、创建人、探伤代码
	public CoreReturnObject Save(ArrayList chemName) {
		sqlCount countWay= new sqlCount();
		count=countWay.countData("QCM_BASE_DETECTION","DETECTION_CODE",(String)chemName.get(5),1);
		if(count>0){
			sqlucomm=new StringBuffer();
			sqlucomm.append("update QCM_BASE_DETECTION "+
						"set DETECTION_NAME=?,DEFECT_TYPE_DESC=?,MEMO=?,UPDATE_ID=?,UPDATE_NAME=?,"+
						"UPDATE_TIME=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')"+
						"where DETECTION_CODE=?");
			Object[] obj=new Object[]{chemName.get(0),chemName.get(1),chemName.get(2),chemName.get(3),chemName.get(4),chemName.get(5)};
			try {
				cro = this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return cro;
	}
}