quitwarelistselectaction.java

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

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

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.manager.tool.FormatDate;
import com.company.struts.action.basic.BaseDAO;
import com.company.struts.form.XsConsignBillMain;

/** 
 * MyEclipse Struts
 * Creation date: 03-10-2008
 * 
 * XDoclet definition:
 * @struts.action path="/quitWareListSelect" name="XsConsignBillMainForm" scope="request" validate="true"
 */
public class QuitWareListSelectAction extends BaseDAO {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		XsConsignBillMain XsConsignBillMainForm = (XsConsignBillMain) form;// TODO Auto-generated method stub
		/*
		String startDate=request.getParameter("");*/
		//起止时间
		//客户名称
		String start = request.getParameter("start");
		String end =  request.getParameter("end");
		
	/*	FormatDate fd = new FormatDate();
		java.sql.Date startDate=null;
		java.sql.Date endDate=null;
		if(start!=null&&start!=""){
			startDate = fd.getSqlDate(fd.getDate(start));
		}
		if(end!=null&&end!=""){
			endDate = fd.getSqlDate(fd.getDate(end));
		}
		*/
		
		
		String cusCode=request.getParameter("cusCode");
		String consignCode=request.getParameter("consignCode");
		String deptCode=request.getParameter("deptCode");
		String personCode=request.getParameter("personCode");
		String sellTypeCode=request.getParameter("sellTypeCode");
		
		 
		String sql=" select a.consignBillMainId,a.consignDate,a.consignCode,a.returnSource,a.cusCode,a.deptCode,a.personCode,b.wareCode,c.wareType,b.emergeQuantity,b.capitalUnitPrice,b.capitalTaxUnitPrice,b.wholeMoney,b.capitalTax,a.checker from XsConsignBillMain as a,XsConsignBillSub as b,GyMaterial as c where a.billType=1 and a.consignCode=b.consignCode and b.wareCode=c.wareCode";
		
//		if(start!=null){
//			sql=sql+" and a.consignDate>='"+start+"'";
//		}
//		
//		if(end!=null){
//			sql=sql+" and a.consignDate<='"+end+"'";
//		}
		
		if(!cusCode.equals("请选择"))
		{
			if(cusCode!=null)
			{
				sql=sql+" and a.cusCode="+cusCode+"";
			}
		}
		if(!consignCode.equals("请选择"))
		{
			if(consignCode!=null)
			{
				sql=sql+" and a.consignCode='"+consignCode+"'";
			}
		}		
		if(!deptCode.equals("请选择"))
		{
			if(cusCode!=null)
			{
				sql=sql+" and a.deptCode="+deptCode+"";
			}
		}		
		if(!personCode.equals("请选择"))
		{
			if(personCode!=null)
			{
				sql=sql+" and a.personCode="+personCode+"";
			}
		}		
		if(!sellTypeCode.equals("请选择"))
		{
			if(sellTypeCode!=null)
			{
				sql=sql+" and a.sellTypeCode="+sellTypeCode+"";
			}
		}
		
		
		System.out.println(sql);
		List list=this.getDao().select1(sql);
		System.out.println("list size:"+list.size());
		request.setAttribute("listall", list);
		return mapping.findForward("success");
	}
}