sellacccommand.java

一个汽车售后服务站的典型的进销管理系统,B/S模式的

package com.xfaccp.command;

import java.util.List;

import com.xfaccp.adapter.CommandAdpater;
import com.xfaccp.base.BaseForm;
import com.xfaccp.form.AccessorySellTable;

public class SellAccCommand extends CommandAdpater 
{
	public List findByExample(BaseForm form) throws Exception 
	{
		List list=null;
		AccessorySellTable accsetbl=(AccessorySellTable)form;
		int years=accsetbl.getYear();
		int months=accsetbl.getMonth();
		int days=accsetbl.getDay();
		//System.out.println("SellAccCommand中的测试------"+years+"年"+months+"月"+days+"日");
		
		String monthStr=String.valueOf(months);
		String dayStr=String.valueOf(days);
		if(months<10)
		{
			monthStr="0"+monthStr;
		}
		if(days<10)
		{
			dayStr="0"+dayStr;
		}
		String hsql="from com.xfaccp.form.AccessorySellTable";
		if(years!=0&&months==0&&days==0)
		{
			hsql+=" where outTime like '"+years+"%'";
		}
		if(years!=0&&months!=0&&days==0)
		{
			hsql+=" where outTime like '"+years+"-"+monthStr+"%'";
		}
		if(years==0&&months!=0&&days==0)
		{
			hsql+=" where outTime like '____"+"-"+monthStr+"%'";
		}
		if(years==0&&months==0&&days!=0)
		{
			hsql+=" where outTime like '____"+"-__-"+dayStr+"%'";
		}
		if(years==0&&months!=0&&days!=0)
		{
			hsql+=" where outTime like '____"+"-"+monthStr+"-"+dayStr+"%'";
		}
		if(years!=0&&months==0&&days!=0)
		{
			hsql+=" where outTime like '"+years+"-__"+"-"+dayStr+"%'";
		}
		if(years!=0&&months!=0&&days!=0)
		{
			hsql+=" where outTime like '"+years+"-"+monthStr+"-"+dayStr+"%'";
		}
		list=this.dao.findBySql(hsql);
		return list;
	}
}