refundinfo.java

java阿里巴巴代码

package com.saas.biz.refundMgr;

import java.util.ArrayList;
import java.util.HashMap;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import com.saas.biz.dao.refundDAO.RefundDAO;
import com.saas.biz.dao.refundDAO.RefundExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:退货申请
 * @2008-5-5
 */
public class RefundInfo {

	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public RefundInfo() {

		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 addRefundInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addRefundInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		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 sale_quo_id = inbuffer.getString("SALE_QUO_ID");
		String back_type = inbuffer.getString("BACK_TYPE");
		String back_desc = inbuffer.getString("BACK_DESC");
		String give_date = inbuffer.getString("GIVE_DATE");
		String give_addr = inbuffer.getString("GIVE_ADDR");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String doc_date = inbuffer.getString("DOC_DATE");
		String currency_code = inbuffer.getString("CURRENCY_CODE");
		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 all_tag = inbuffer.getString("ALL_TAG");
		String back_num = inbuffer.getString("BACK_NUM");
		String surplus_num = inbuffer.getString("SURPLUS_NUM");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");

		try {
			RefundDAO refundDao = new RefundDAO();
			refundDao.setCust_id(cust_id);
			refundDao.setForm_id(form_id);
			refundDao.setQuo_name(quo_name);
			refundDao.setQuo_id(quo_id);
			refundDao.setSale_quo_id(sale_quo_id);
			refundDao.setBack_type(back_type);
			refundDao.setBack_desc(back_desc);
			refundDao.setGive_date(give_date);
			refundDao.setGive_addr(give_addr);
			refundDao.setShip_type(ship_type);
			refundDao.setDoc_date(doc_date);
			refundDao.setCurrency_code(currency_code);
			refundDao.setOff_count(off_count);
			refundDao.setOff_rate(off_rate);
			refundDao.setShip_fee(ship_fee);
			refundDao.setTax(tax);
			refundDao.setAll_fee(all_fee);
			refundDao.setAll_tag(all_tag);
			refundDao.setBack_num(back_num);
			refundDao.setSurplus_num(surplus_num);
			refundDao.setOper_user_id(oper_user_id);
			refundDao.setRemark2(remark2);

			iResult = addRefundInfo(refundDao);
		} catch (SaasApplicationException 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("退出addRefundInfo方法...");
	}

	public int addRefundInfo(RefundDAO refundDao)
			throws SaasApplicationException {

		RefundExt refundExt = new RefundExt();
		refundExt.setParam(":VCUST_ID", refundDao.getCust_id());
		refundExt.setParam(":VFORM_ID", refundDao.getForm_id());
		refundExt.setParam(":VQUO_NAME", refundDao.getQuo_name());
		refundExt.setParam(":VQUO_ID", refundDao.getQuo_id());
		refundExt.setParam(":VSALE_QUO_ID", refundDao.getSale_quo_id());
		refundExt.setParam(":VBACK_TYPE", refundDao.getBack_type());
		refundExt.setParam(":VBACK_DESC", refundDao.getBack_desc());
		refundExt.setParam(":VGIVE_DATE", refundDao.getGive_date());
		refundExt.setParam(":VGIVE_ADDR", refundDao.getGive_addr());
		refundExt.setParam(":VSHIP_TYPE", refundDao.getShip_type());
		refundExt.setParam(":VDOC_DATE", refundDao.getDoc_date());
		refundExt.setParam(":VCURRENCY_CODE", refundDao.getCurrency_code());
		refundExt.setParam(":VOFF_COUNT", refundDao.getOff_count());
		refundExt.setParam(":VOFF_RATE", refundDao.getOff_rate());
		refundExt.setParam(":VSHIP_FEE", refundDao.getShip_fee());
		refundExt.setParam(":VTAX", refundDao.getTax());
		refundExt.setParam(":VALL_FEE", refundDao.getAll_fee());
		refundExt.setParam(":VALL_TAG", refundDao.getAll_tag());
		refundExt.setParam(":VBACK_NUM", refundDao.getBack_num());
		refundExt.setParam(":VSURPLUS_NUM", refundDao.getSurplus_num());
		refundExt.setParam(":VOPER_USER_ID", refundDao.getOper_user_id());
		refundExt.setParam(":VREMARK2", refundDao.getRemark2());
		tradeQuery.executeBy(refundExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 修改退货申请
	public void editRefundInfo(Buffers inbuffer) {

		log.LOG_INFO("进入editRefundInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		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 sale_quo_id = inbuffer.getString("SALE_QUO_ID");
		String back_type = inbuffer.getString("BACK_TYPE");
		String back_desc = inbuffer.getString("BACK_DESC");
		String give_date = inbuffer.getString("GIVE_DATE");
		String give_addr = inbuffer.getString("GIVE_ADDR");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String doc_date = inbuffer.getString("DOC_DATE");
		String currency_code = inbuffer.getString("CURRENCY_CODE");
		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 all_tag = inbuffer.getString("ALL_TAG");
		String back_num = inbuffer.getString("BACK_NUM");
		String surplus_num = inbuffer.getString("SURPLUS_NUM");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");

		try {
			RefundDAO refundDao = new RefundDAO();
			refundDao.setCust_id(cust_id);
			refundDao.setForm_id(form_id);
			refundDao.setQuo_name(quo_name);
			refundDao.setQuo_id(quo_id);
			refundDao.setSale_quo_id(sale_quo_id);
			refundDao.setBack_type(back_type);
			refundDao.setBack_desc(back_desc);
			refundDao.setGive_date(give_date);
			refundDao.setGive_addr(give_addr);
			refundDao.setShip_type(ship_type);
			refundDao.setDoc_date(doc_date);
			refundDao.setCurrency_code(currency_code);
			refundDao.setOff_count(off_count);
			refundDao.setOff_rate(off_rate);
			refundDao.setShip_fee(ship_fee);
			refundDao.setTax(tax);
			refundDao.setAll_fee(all_fee);
			refundDao.setAll_tag(all_tag);
			refundDao.setBack_num(back_num);
			refundDao.setSurplus_num(surplus_num);
			refundDao.setOper_user_id(oper_user_id);
			refundDao.setRemark2(remark2);

			iResult = editRefundInfo(refundDao);
		} catch (SaasApplicationException 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("退出addRefundInfo方法...");
	}

	public int editRefundInfo(RefundDAO refundDao)
			throws SaasApplicationException {

		RefundExt refundExt = new RefundExt();
		refundExt.setParam(":VCUST_ID", refundDao.getCust_id());
		refundExt.setParam(":VFORM_ID", refundDao.getForm_id());
		refundExt.setParam(":VQUO_NAME", refundDao.getQuo_name());
		refundExt.setParam(":VQUO_ID", refundDao.getQuo_id());
		refundExt.setParam(":VSALE_QUO_ID", refundDao.getSale_quo_id());
		refundExt.setParam(":VBACK_TYPE", refundDao.getBack_type());
		refundExt.setParam(":VBACK_DESC", refundDao.getBack_desc());
		refundExt.setParam(":VGIVE_DATE", refundDao.getGive_date());
		refundExt.setParam(":VGIVE_ADDR", refundDao.getGive_addr());
		refundExt.setParam(":VSHIP_TYPE", refundDao.getShip_type());
		refundExt.setParam(":VDOC_DATE", refundDao.getDoc_date());
		refundExt.setParam(":VCURRENCY_CODE", refundDao.getCurrency_code());
		refundExt.setParam(":VOFF_COUNT", refundDao.getOff_count());
		refundExt.setParam(":VOFF_RATE", refundDao.getOff_rate());
		refundExt.setParam(":VSHIP_FEE", refundDao.getShip_fee());
		refundExt.setParam(":VTAX", refundDao.getTax());
		refundExt.setParam(":VALL_FEE", refundDao.getAll_fee());
		refundExt.setParam(":VALL_TAG", refundDao.getAll_tag());
		refundExt.setParam(":VBACK_NUM", refundDao.getBack_num());
		refundExt.setParam(":VSURPLUS_NUM", refundDao.getSurplus_num());
		refundExt.setParam(":VOPER_USER_ID", refundDao.getOper_user_id());
		refundExt.setParam(":VREMARK2", refundDao.getRemark2());
		tradeQuery.executeBy(refundExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}

	/**
	 * 删除退货申请
	 */
	public void delRefundInfo(Buffers inbuffer) {

		log.LOG_INFO("进入delRefundInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String quo_id = inbuffer.getString("QUO_ID");
		String sale_quo_id = inbuffer.getString("SALE_QUO_ID");
		try {
			RefundDAO refundDao = new RefundDAO();
			refundDao.setCust_id(cust_id);
			refundDao.setForm_id(form_id);
			refundDao.setQuo_id(quo_id);
			refundDao.setSale_quo_id(sale_quo_id);
			iResult = delRefundInfo(refundDao);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {