warereturnmoneyaction.java

关于网上汽车销售系统的详细编程项目实战实例

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.company.struts.action.returnmoney;

import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.company.hib.dao.IDAO;
import com.company.struts.action.basic.BaseAll;
import com.company.struts.form.XsConsignBillMain;
import com.company.struts.form.XsConsignBillSub;
import com.company.struts.form.XsReturnMoney;
import com.company.struts.form.returnmoney.ConsignBillForm;
import com.company.struts.form.returnmoney.WareMoneyBillForm;
import com.company.manager.tool.MyConnection;

/**
 * MyEclipse Struts Creation date: 03-09-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/wareReturnMoney" name="returnMoneyForm" scope="request"
 *                validate="true"
 */
public class WareReturnMoneyAction extends BaseAll {
	/*
	 * Generated Methods
	 */

	private IDAO rmdao;

	private IDAO cbmaindao;

	private IDAO cbsubdao;

	private IDAO mwdao;

	public IDAO getCbmaindao() {
		return cbmaindao;
	}

	public void setCbmaindao(IDAO cbmaindao) {
		this.cbmaindao = cbmaindao;
	}

	public IDAO getCbsubdao() {
		return cbsubdao;
	}

	public void setCbsubdao(IDAO cbsubdao) {
		this.cbsubdao = cbsubdao;
	}

	public IDAO getMwdao() {
		return mwdao;
	}

	public void setMwdao(IDAO mwdao) {
		this.mwdao = mwdao;
	}
	public IDAO getRmdao() {
		return rmdao;
	}

	public void setRmdao(IDAO rmdao) {
		this.rmdao = rmdao;
	}

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		XsReturnMoney returnMoneyForm = (XsReturnMoney) form;
		String id = request.getParameter("id");
		List c_list = null;
		List w_list = null;
		ConsignBillForm xbform = new ConsignBillForm();
		WareMoneyBillForm wmform = new WareMoneyBillForm();
		returnMoneyForm = (XsReturnMoney) this.rmdao.findById(Integer.parseInt(id));
		request.setAttribute("xrmform", returnMoneyForm);
		  if (returnMoneyForm != null) 
		  { 
			  String con_sql ="select a.consignCode,a.consignDate,b.capitalWhole,(b.capitalWhole-b.capReturnMoney) as notWareMoney,b.wareCode"
				  +" from  Xs_ConsignBillMain as a"
				  +" inner join Xs_ConsignBillSub as b on (a.consignBillMainID = b.consignBillMainID)"
			  	  +" where a.cusCode="+returnMoneyForm.getCusCode()+" and b.settleallFlag=0"
			  	  +" order by a.consignCode asc";
			  System.out.println(con_sql);
			  String ret_sql ="select returnMoneyCode,returnDate,capitalReturnMoney,capitalRemainMoney from Xs_ReturnMoney where cusCode="
				  	+returnMoneyForm.getCusCode()+" and checker='"+returnMoneyForm.getChecker()+"'and capitalRemainMoney!=capitalReturnMoney order by returnMoneyCode asc";
			  System.out.println(ret_sql);
			  try{
				  MyConnection mycon = new MyConnection();
				  c_list = mycon.findData(con_sql);
				  w_list = mycon.findData2(ret_sql);
			  }catch(Exception e)
			  {
				  System.out.println("123");
				  e.printStackTrace();
			  }
			  if (xbform!=null&&wmform!=null) {
				 // System.out.println("查询到数据：" + list.size() + "条");
				  request.setAttribute("consignBillForm", c_list);
				  request.setAttribute("wareMoneyBillForm", w_list);
				  return mapping.findForward("success");
			  }else{
				  return mapping.findForward("error");
			  }
		  }else{
			  return mapping.findForward("error");
		  }
		
	}


}