XinYu_LZMES/.svn/pristine/6f/6fd654a54fdc19aea2260d8b61b44e9eb9540953.svn-base

package QCM.QCM01.QCM0102;

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 addPhy  extends CoreIComponent   {
	StringBuffer sqlucomm=null;
	CoreReturnObject cro = new CoreReturnObject();	
	int count=0;
	ResultSet rs=null;
	//添加材质信息
	//参数：项目代码、项目名称、大类描述、材质检验项代码、缺陷分类描述、备注、创建人ID、创建人
	public CoreReturnObject add(ArrayList list) {
		sqlCount countWay= new sqlCount();
		count=countWay.countData("QCM_BASE_PHY","PHY_GRP_CODE",(String)list.get(0),null);
		if(count<=0){
			sqlucomm=new StringBuffer();
			sqlucomm.append("INSERT " +
				"INTO QCM_BASE_PHY" +
				"(PHY_GRP_CODE,PHY_GRP_DESC,PHY_DESC_L,PHY_CODE_S,DEFECT_TYPE_DESC,VALIDFLAG,MEMO,CREATE_ID,CREATE_NAME,CREATE_TIME) "+
				"VALUES(?,?,?,?,?,'1',?,?,?,TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')) ");
			Object[] obj = new Object[]{list.get(0),list.get(1),list.get(2),list.get(3),list.get(4),list.get(5),list.get(6),list.get(7)};
			try {
				System.out.println("sql+++++++"+sqlucomm.toString());
				cro=this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
			} catch (SQLException e) {
			// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}else{
			cro.setResult("组合项目代码已存在");
		}
		return cro;
	}
}