package com.saas.biz.procurformMgr;

import java.util.*;
import java.text.SimpleDateFormat;
import com.saas.biz.dao.procurformDAO.ProcurformDAO;
import com.saas.biz.dao.procurformDAO.ProcurformExt;
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 ProcurformInfo{
	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public ProcurformInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
	}

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

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

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

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

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

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

	public void addProcurForm(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入addProcurForm方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String quo_name = inbuffer.getString("QUO_NAME");
		String quo_id = inbuffer.getString("QUO_ID");
		String obj_cust_id = inbuffer.getString("OBJ_CUST_ID");
		String quo_code = inbuffer.getString("QUO_CODE");
		String sale_obj_id = inbuffer.getString("SALE_OBJ_ID");
		String contact_man = inbuffer.getString("CONTACT_MAN");
		String contact = inbuffer.getString("CONTACT");
		String give_date = inbuffer.getString("GIVE_DATE");
		String give_addr = inbuffer.getString("GIVE_ADDR");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String doc_date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
		String currency_code = inbuffer.getString("CURRENCY_CODE");
		String sale_user_id = inbuffer.getString("SALE_USER_ID");
		String own_user_id = inbuffer.getString("OWN_USER_ID");
		String off_count = inbuffer.getString("OFF_COUNT");
		String off_rate = inbuffer.getString("OFF_RATE");
		String ship_fee = inbuffer.getString("SHIP_FEE");
		String tax = inbuffer.getString("TAX");
		String all_fee = inbuffer.getString("ALL_FEE");
		String order_count = inbuffer.getString("ORDER_COUNT");
		String part_delivery_tag = inbuffer.getString("PART_DELIVERY_TAG");
		String delivery_num = inbuffer.getString("DELIVERY_NUM");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String rsrv_str3 = inbuffer.getString("OBJ_CUST_NAME");
		String rsrv_str4 = inbuffer.getString("SALE_OBJ_NAME");
		String rsrv_str5 = inbuffer.getString("SALE_USER_NAME");
		String rsrv_str6 = inbuffer.getString("OWN_USER_NAME");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			ProcurformDAO procurformDAO = new ProcurformDAO();
			procurformDAO.setCust_id(cust_id);
			procurformDAO.setForm_id(form_id);
			procurformDAO.setQuo_name(quo_name);
			procurformDAO.setQuo_id(quo_id);
			procurformDAO.setObj_cust_id(obj_cust_id);
			procurformDAO.setQuo_code(quo_code);
			procurformDAO.setSale_obj_id(sale_obj_id);
			procurformDAO.setContact_man(contact_man);
			procurformDAO.setContact(contact);
			procurformDAO.setGive_date(give_date);
			procurformDAO.setGive_addr(give_addr);
			procurformDAO.setShip_type(ship_type);
			procurformDAO.setDoc_date(doc_date);
			procurformDAO.setCurrency_code(currency_code);
			procurformDAO.setSale_user_id(sale_user_id);
			procurformDAO.setOwn_user_id(own_user_id);
			procurformDAO.setOff_count(off_count);
			procurformDAO.setOff_rate(off_rate);
			procurformDAO.setShip_fee(ship_fee);
			procurformDAO.setTax(tax);
			procurformDAO.setAll_fee(all_fee);
			procurformDAO.setOrder_count(order_count);
			procurformDAO.setPart_delivery_tag(part_delivery_tag);
			procurformDAO.setDelivery_num(delivery_num);
			procurformDAO.setOper_user_id(oper_user_id);
			procurformDAO.setRsrv_str3(rsrv_str3);
			procurformDAO.setRsrv_str4(rsrv_str4);
			procurformDAO.setRsrv_str5(rsrv_str5);
			procurformDAO.setRsrv_str6(rsrv_str6);
			procurformDAO.setRemark2(remark2);
			
			iResult = addProcurForm(procurformDAO);
		}
		catch (Exception e) {
		}
		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("退出addSaleOrderForm方法...");
	}
	
	
	public int addProcurForm(ProcurformDAO procurformDAO) throws SaasApplicationException {

		ProcurformExt procurformExt = new ProcurformExt();
		procurformExt.setParam(":VCUST_ID", procurformDAO.getCust_id());
		procurformExt.setParam(":VFORM_ID", procurformDAO.getForm_id());
		procurformExt.setParam(":VQUO_NAME", procurformDAO.getQuo_name());
		procurformExt.setParam(":VQUO_ID", procurformDAO.getQuo_id());
		procurformExt.setParam(":VOBJ_CUST_ID", procurformDAO.getObj_cust_id());
		procurformExt.setParam(":VQUO_CODE", procurformDAO.getQuo_code());
		procurformExt.setParam(":VSALE_OBJ_ID", procurformDAO.getSale_obj_id());
		procurformExt.setParam(":VCONTACT_MAN", procurformDAO.getContact_man());
		procurformExt.setParam(":VCONTACT", procurformDAO.getContact());
		procurformExt.setParam(":VGIVE_DATE", procurformDAO.getGive_date());
		procurformExt.setParam(":VGIVE_ADDR", procurformDAO.getGive_addr());
		procurformExt.setParam(":VSHIP_TYPE", procurformDAO.getShip_type());
		procurformExt.setParam(":VDOC_DATE", procurformDAO.getDoc_date());
		procurformExt.setParam(":VCURRENCY_CODE", procurformDAO.getCurrency_code());
		procurformExt.setParam(":VSALE_USER_ID", procurformDAO.getSale_user_id());
		procurformExt.setParam(":VOWN_USER_ID", procurformDAO.getOwn_user_id());
		procurformExt.setParam(":VOFF_COUNT", procurformDAO.getOff_count());
		procurformExt.setParam(":VOFF_RATE", procurformDAO.getOff_rate());
		procurformExt.setParam(":VSHIP_FEE", procurformDAO.getShip_fee());
		procurformExt.setParam(":VTAX", procurformDAO.getTax());
		procurformExt.setParam(":VALL_FEE", procurformDAO.getAll_fee());
		procurformExt.setParam(":VORDER_COUNT", procurformDAO.getOrder_count());
		procurformExt.setParam(":VPART_DELIVERY_TAG", procurformDAO.getPart_delivery_tag());
		procurformExt.setParam(":VDELIVERY_NUM", procurformDAO.getDelivery_num());
		procurformExt.setParam(":VOPER_USER_ID", procurformDAO.getOper_user_id());
		procurformExt.setParam(":VREMARK2", procurformDAO.getRemark2());
		procurformExt.setParam(":VRSRV_STR3", procurformDAO.getRsrv_str3());
		procurformExt.setParam(":VRSRV_STR4", procurformDAO.getRsrv_str4());
		procurformExt.setParam(":VRSRV_STR5", procurformDAO.getRsrv_str5());
		procurformExt.setParam(":VRSRV_STR6", procurformDAO.getRsrv_str6());
		tradeQuery.executeBy(procurformExt.insBy("INS_BY_ALL"));
		return 0;
	}
	//根據CUST—ID取出采購單
	public ArrayList getAllProcurform(String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ProcurformExt procurformExt = new ProcurformExt();
		procurformExt.setParam(":VCUST_ID", cust_id);
		list = procurformExt.selByList("SEL_BY_CUST_ID");
		return list;
	}
	
	
	
	// 統計采購單總數
	public int getProcurforSize(String cust_id) throws SaasApplicationException {
		int size = 0;
		ArrayList list = new ArrayList();
		ProcurformExt procurformExt = new ProcurformExt();
		procurformExt.setParam(":VCUST_ID", cust_id);
		list = procurformExt.selByList("SEL_BY_CUST_ID");
		if (list != null && list.size() > 0) {
			size=list.size();
		}
		return size;
	}
	
	public void delProcurform(Buffers inbuffer) {

		log.LOG_INFO("進入delProcurform方法...");