XinYu_LZMES/.svn/pristine/3b/3b51c1eeacab2f743db8ee7edb411c2b6988787a.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 SaveEgis extends CoreIComponent{
	CoreReturnObject cro = new CoreReturnObject();	
	StringBuffer sqlucomm = new StringBuffer();
	int count=0;
	ResultSet rs=null;
	//更新 参数：供方名称、产线、钢座架规格、车皮费单价、序号
	public CoreReturnObject Save(ArrayList BaseChem) {
		sqlCount countWay= new sqlCount();
		count=countWay.countData("QCM_EGIS","EGIS_ID",(String)BaseChem.get(4),null);
		if(count>0){
			sqlucomm=new StringBuffer();
			sqlucomm.append("update QCM_EGIS "+
							"set FOR_NAME=?,PRODUCTION_LINE=?,NORM=?,UNIT_PRICE=?,"+
							"REVISE_DATE=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')"+
							" where EGIS_ID=?");
			Object[] obj=new Object[]{BaseChem.get(0),BaseChem.get(1),BaseChem.get(2),BaseChem.get(3),BaseChem.get(4)};
			try {
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
			} catch (SQLException e) {
			e.printStackTrace();
			}
		}
		return cro;
	}

}