package com.saas.biz.damageMgr;

import java.util.ArrayList;
import com.saas.biz.dao.damageDAO.DamageDAO;
import com.saas.biz.dao.damageDAO.DamageExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class DamageInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public DamageInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		outBuffer = new Buffers();
	}

	public void setOutBuffer(Buffers outBuffer) {
		this.outBuffer = outBuffer;
	}

	public Buffers getOutBuffer() {
		return this.outBuffer;
	}

	public void setTradeQuery(Dbtable tradeQuery) {
		this.tradeQuery = tradeQuery;
	}

	public Dbtable getTradeQuery() {
		return this.tradeQuery;
	}

	public ArrayList getQueryResult() {
		return this.queryResult;
	}

	public void setQueryResult(ArrayList queryResult) {
		this.queryResult = queryResult;
	}

	// 添加產(chǎn)品
	public void addDamageInfo(Buffers inbuffer) {
		log.LOG_INFO("進(jìn)入addDamageInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String trade_id = inbuffer.getString("TRADE_ID");
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String damage_id = inbuffer.getString("DAMAGE_ID");
		String damage_name = inbuffer.getString("DAMAGE_NAME");
		String goods_id = inbuffer.getString("GOODS_ID");
		String goods_name = inbuffer.getString("GOODS_NAME");
		String damage_num = inbuffer.getString("DAMAGE_NUM");
		String gamage_state = inbuffer.getString("GAMAGE_STATE");
		String gamage_date = inbuffer.getString("GAMAGE_DATE");
		String gamage_resean = inbuffer.getString("GAMAGE_RESEAN");
		String oper_date = "";
		String oper_user_id = inbuffer.getString("SESSION_CUST_ID");
		String remark = inbuffer.getString("REMARK");

		try {
			DamageDAO damageDAO = new DamageDAO();
			damageDAO.setTrade_id(trade_id);
			damageDAO.setCust_id(cust_id);
			damageDAO.setDamage_id(damage_id);
			damageDAO.setDamage_name(damage_name);
			damageDAO.setDamage_num(damage_num);
			damageDAO.setGamage_date(gamage_date);
			damageDAO.setGamage_resean(gamage_resean);
			damageDAO.setGamage_state(gamage_state);
			damageDAO.setGoods_id(goods_id);
			damageDAO.setGoods_name(goods_name);
			damageDAO.setOper_date(oper_date);
			damageDAO.setOper_user_id(oper_user_id);
			damageDAO.setRemark(remark);
			iResult = addDamageInfo(damageDAO);
		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理成功！");
		}
		log.LOG_INFO("退出addDamageInfo方法...");
	}

	public int addDamageInfo(DamageDAO areaDao) throws SaasApplicationException {

		DamageExt damageExt = new DamageExt();
		// log.LOG_INFO("開(kāi)始執(zhí)行SQL:===:");
		damageExt.setParam(":VTRADE_ID", areaDao.getTrade_id());
		damageExt.setParam(":VCUST_ID", areaDao.getCust_id());
		damageExt.setParam(":VGOODS_ID", areaDao.getGoods_id());
		damageExt.setParam(":VDAMAGE_ID", areaDao.getDamage_id());
		damageExt.setParam(":VDAMAGE_NAME", areaDao.getDamage_name());
		damageExt.setParam(":VGOODS_NAME", areaDao.getGoods_name());
		damageExt.setParam(":VDAMAGE_NUM", areaDao.getDamage_num());
		damageExt.setParam(":VGAMAGE_STATE", areaDao.getGamage_state());
		damageExt.setParam(":VGAMAGE_DATE", areaDao.getGamage_date());
		damageExt.setParam(":VGAMAGE_RESEAN", areaDao.getGamage_resean());
		damageExt.setParam(":VOPER_DATE", areaDao.getOper_date());
		damageExt.setParam(":VOPER_USER_ID", areaDao.getOper_user_id());
		damageExt.setParam(":VREMARK", areaDao.getRemark());
		// log.LOG_INFO("開(kāi)始執(zhí)行SQL:===:" + damageExt.insBy("INS_BY_DAMAGE"));
		tradeQuery.executeBy(damageExt.insBy("INS_BY_DAMAGE"));
		return 0;
	}

	// 修改產(chǎn)品資料
	public void modifyDamageInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進(jìn)入modifyDamageInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String damage_id = inbuffer.getString("DAMAGE_ID");
		String gamage_state = "1";
		String damage_num = inbuffer.getString("DAMAGE_NUM");

		try {
			DamageDAO damageDao = new DamageDAO();
			damageDao.setCust_id(cust_id);
			damageDao.setDamage_id(damage_id);
			damageDao.setDamage_num(damage_num);
			damageDao.setGamage_state(gamage_state);
			iResult = modifyDamageInfo(damageDao);
		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理成功！");
		}
		log.LOG_INFO("退出modifyDamageInfo方法...");
	}

	public int modifyDamageInfo(DamageDAO damageDao)
			throws SaasApplicationException {

		DamageExt damageExt = new DamageExt();
		damageExt.setParam(":VCUST_ID", damageDao.getCust_id());
		damageExt.setParam(":VDAMAGE_ID", damageDao.getDamage_id());
		damageExt.setParam(":VGAMAGE_STATE",damageDao.getGamage_state());
		damageExt.setParam(":VDAMAGE_NUM", damageDao.getDamage_num());

		tradeQuery.executeBy(damageExt.insBy("UP_DAMAGE_BY_ALL_AGAIN"));
		return 0;
	}

	public ArrayList getById(String cust_id,String gamage_state) throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		DamageExt damageExt = new DamageExt();
		damageExt.setParam(":VCUST_ID", cust_id);
		damageExt.setParam(":VGAMAGE_STATE", gamage_state);
		relationList = damageExt.selByList("SEL_BY_ID");
		return relationList;
	}

}