procurforminfo.java

java阿里巴巴代码

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		try {
			String cust_id = inbuffer.getString("SESSION_CUST_ID");
			String quo_id = inbuffer.getString("QUO_ID");
			iResult = delProcurform(cust_id,quo_id);
		}
		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("退出delProcurform方法...");
	}
	
	
	public int delProcurform(String cust_id, String quo_id) throws SaasApplicationException {
		ProcurformExt procurformExt = new ProcurformExt();
		procurformExt.setParam(":VCUST_ID", cust_id);
		procurformExt.setParam(":VQUO_ID", quo_id);
		tradeQuery.executeBy(procurformExt.insBy("DEL_PROCURFORM_BY_QUO_ID"));
		return 0;
	}
	
	public void updateProcurForm(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入updateProcurForm方法...");
		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 = updateProcurForm(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 updateProcurForm(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("UPDATE_PROCURFORM"));
		return 0;
	}
	
	
	public ArrayList getOneProcurform(String cust_id, String quo_id) throws SaasApplicationException {
		HashMap map = new HashMap();
		ArrayList list = new ArrayList();
		ProcurformExt procurformExt = new ProcurformExt();
		procurformExt.setParam(":VCUST_ID", cust_id);
		procurformExt.setParam(":VQUO_ID", quo_id);
		list = procurformExt.selByList("SEL_ONE_BY_QUO_ID");
		return list;
	}
	
	
	public ArrayList getProcurList(int iStart,String cust_id) throws SaasApplicationException{
		ProcurformExt procurformExt = new ProcurformExt();
		ArrayList list = new ArrayList();
		try {
			iStart = iStart*20;
			procurformExt.setParam(":VCUST_ID",cust_id);
			list = procurformExt.selByList("SEL_ALL_PROCUR", iStart, 20);
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return list;
	}
	
	//取出所有的采购单
	public int getProcurList(String cust_id) throws SaasApplicationException{
		ProcurformExt procurformExt = new ProcurformExt();
		ArrayList list = new ArrayList();
		int count = 0;
		try {
			procurformExt.setParam(":VCUST_ID",cust_id);
			list = procurformExt.selByList("SEL_ALL_PROCUR");
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		if(list != null && list.size()>0){
			count = list.size();
		}
		return count;
	}
	
}