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; } }