XinYu_LZMES/.svn/pristine/c7/c7b2dabeb7051b6d5566fd614df007ae0cd8542e.svn-base

package EGIS;
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 addEgis extends CoreIComponent{
	CoreReturnObject cro = null;
	StringBuffer sqlucomm=null;
	int max=0;
	ResultSet rs=null;
	//火运供方维护  参数：供方名称、产线、钢座架规格、车皮费单价、序号
	public CoreReturnObject add(ArrayList list){
		cro=new CoreReturnObject();
		sqlucomm=new StringBuffer();
		sqlucomm.append("select max(EGIS_ID) max from QCM_EGIS ");
		try {
			rs = this.getDao("KgDao").ExceuteQueryForResultSet(sqlucomm.toString());
			if (rs.next()) {
				max = rs.getInt("max");
				max++;
			}
		} catch (SQLException e1) {        
			e1.printStackTrace();
		}
		sqlucomm = new StringBuffer();
		sqlucomm.append("insert into QCM_EGIS(EGIS_ID,FOR_NAME,PRODUCTION_LINE,NORM,UNIT_PRICE,CREATE_DATE,FETTLE)"+
						"values("+max+",?,?,?,?,TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS'),1)");
		Object[] obj = new Object[]{list.get(0),list.get(1),list.get(2),list.get(3)};
		try {
			cro=this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return cro;
	}
	
}