package com.saas.biz.rawMaterialsMgr;

import java.util.ArrayList;
import com.saas.biz.dao.rawmaterialsDAO.RawMaterialsDAO;
import com.saas.biz.dao.rawmaterialsDAO.RawMaterialsExt;
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 RawMaterialsInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public RawMaterialsInfo() {
		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;
	}

	public void addRawInfo(Buffers inbuffer) {
		log.LOG_INFO("進入addRawInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String product_id = inbuffer.getString("PRODUCT_ID");
		String raw_id = inbuffer.getString("RAW_ID");
		String raw_name = inbuffer.getString("RAW_NAME");
		String raw_num = inbuffer.getString("RAW_NUM");
		String raw_price = inbuffer.getString("RAW_PRICE");
		String raw_site = inbuffer.getString("RAW_SITE");
		String raw_desc = inbuffer.getString("RAW_DESC");
		String unit = inbuffer.getString("UNIT");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			RawMaterialsDAO rawdao = new RawMaterialsDAO();
			rawdao.setCust_id(cust_id);
			rawdao.setProduct_id(product_id);
			rawdao.setRaw_id(raw_id);
			rawdao.setRaw_name(raw_name);
			rawdao.setRaw_num(raw_num);
			rawdao.setRaw_price(raw_price);
			rawdao.setRaw_site(raw_site);
			rawdao.setRaw_desc(raw_desc);
			rawdao.setUnit(unit);
			rawdao.setUser_id(user_id);
			rawdao.setPublish_date(publish_date);
			rawdao.setRemark(remark);

			iResult = addRawInfo(rawdao);

		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出addRawInfo方法...");
	}

	public int addRawInfo(RawMaterialsDAO rawdao)
			throws SaasApplicationException {

		RawMaterialsExt rawExt = new RawMaterialsExt();
		rawExt.setParam(":VCUST_ID", rawdao.getCust_id());
		rawExt.setParam(":VPRODUCT_ID", rawdao.getProduct_id());
		rawExt.setParam(":VRAW_ID", rawdao.getRaw_id());
		rawExt.setParam(":VRAW_NAME", rawdao.getRaw_name());
		rawExt.setParam(":VRAW_NUM", rawdao.getRaw_num());
		rawExt.setParam(":VRAW_PRICE", rawdao.getRaw_price());
		rawExt.setParam(":VRAW_SITE", rawdao.getRaw_site());
		rawExt.setParam(":VRAW_DESC", rawdao.getRaw_desc());
		rawExt.setParam(":VUNIT", rawdao.getUnit());
		rawExt.setParam(":VUSER_ID", rawdao.getUser_id());
		rawExt.setParam(":VPUBLISH_DATE", rawdao.getPublish_date());
		rawExt.setParam(":VREMARK", rawdao.getRemark());

		tradeQuery.executeBy(rawExt.insBy("INS_BY_RAW"));
		return 0;
	}

	public void modifyRawList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入modifyRawList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String raw_id = inbuffer.getString("RAW_ID");
		String raw_name = inbuffer.getString("RAW_NAME");
		String raw_num = inbuffer.getString("RAW_NUM");
		String raw_price = inbuffer.getString("RAW_PRICE");
		String raw_site = inbuffer.getString("RAW_SITE");
		String raw_desc = inbuffer.getString("RAW_DESC");
		String unit = inbuffer.getString("UNIT");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			RawMaterialsDAO rawdao = new RawMaterialsDAO();
			rawdao.setCust_id(cust_id);
			rawdao.setRaw_id(raw_id);
			rawdao.setRaw_name(raw_name);
			rawdao.setRaw_num(raw_num);
			rawdao.setRaw_price(raw_price);
			rawdao.setRaw_site(raw_site);
			rawdao.setRaw_desc(raw_desc);
			rawdao.setUnit(unit);
			rawdao.setUser_id(user_id);
			rawdao.setPublish_date(publish_date);
			rawdao.setRemark(remark);

			iResult = modifyRawList(rawdao);
		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出modifyRawList方法...");
	}

	public int modifyRawList(RawMaterialsDAO rawdao)
			throws SaasApplicationException {

		RawMaterialsExt rawExt = new RawMaterialsExt();
		rawExt.setParam(":VCUST_ID", rawdao.getCust_id());
		rawExt.setParam(":VRAW_ID", rawdao.getRaw_id());
		rawExt.setParam(":VRAW_NAME", rawdao.getRaw_name());
		rawExt.setParam(":VRAW_NUM", rawdao.getRaw_num());
		rawExt.setParam(":VRAW_PRICE", rawdao.getRaw_price());
		rawExt.setParam(":VRAW_SITE", rawdao.getRaw_site());
		rawExt.setParam(":VRAW_DESC", rawdao.getRaw_desc());
		rawExt.setParam(":VUNIT", rawdao.getUnit());
		rawExt.setParam(":VUSER_ID", rawdao.getUser_id());
		rawExt.setParam(":VPUBLISH_DATE", rawdao.getPublish_date());
		rawExt.setParam(":VREMARK", rawdao.getRemark());

		tradeQuery.executeBy(rawExt.insBy("UP_BY_RAW"));
		return 0;
	}

	public void DelRawList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入DelRawList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String raw_id = inbuffer.getString("RAW_ID");
		try {
			RawMaterialsDAO rawdao = new RawMaterialsDAO();
			rawdao.setCust_id(cust_id);
			rawdao.setRaw_id(raw_id);

			iResult = DelRawList(rawdao);
		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出DelRawList方法...");
	}

	public int DelRawList(RawMaterialsDAO rawdao)
			throws SaasApplicationException {

		RawMaterialsExt conExt = new RawMaterialsExt();
		conExt.setParam(":VCUST_ID", rawdao.getCust_id());
		conExt.setParam(":VRAW_ID", rawdao.getRaw_id());

		tradeQuery.executeBy(conExt.insBy("DEL_BY_RAW"));
		return 0;
	}

	public ArrayList getRawMList(int iStart, String cust_id ,String product_id)
			throws SaasApplicationException {

		
		iStart = iStart  * 20;
		
		RawMaterialsExt rawExt = new RawMaterialsExt();
		rawExt.setParam(":VCUST_ID", cust_id);
		rawExt.setParam(":VPRODUCT_ID", product_id);
		ArrayList list = rawExt.selByList("SEL_BY_PRO_ID", iStart, 20);
		return list;
	}

	public int getRawMList(String cust_id,String product_id) throws SaasApplicationException {
		int count = 0;
		RawMaterialsExt rawExt = new RawMaterialsExt();
		rawExt.setParam(":VCUST_ID", cust_id);
		rawExt.setParam(":VPRODUCT_ID", product_id);
		ArrayList list = rawExt.selByList("SEL_BY_PRO_ID");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}

	public ArrayList getListByRaw(String cust_id, String raw_id)
			throws SaasApplicationException {

		RawMaterialsExt chriExt = new RawMaterialsExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VRAW_ID", raw_id);
		ArrayList list = chriExt.selByList("SEL_BY_RAW_ID");
		return list;
	}

}