xsplandao.java

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

package com.company.hib.dao.impl;

import java.util.ArrayList;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.ActionForm;
import org.hibernate.LockMode;
import org.hibernate.SQLQuery;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.company.hib.dao.DAOAdapter;
import com.company.hib.dao.IXsPlanDAO;
import com.company.struts.form.XsPlan;
import com.company.struts.form.GyDepartment;
/**
 * Data access object (DAO) for domain model class XsPlan.
 * 
 * @see com.company.struts.form.XsPlan
 * @author MyEclipse Persistence Tools
 */

public class XsPlanDAO extends DAOAdapter implements IXsPlanDAO {
	private static final Log log = LogFactory.getLog(XsPlanDAO.class);

	// property constants
	public static final String KJ_YEAR = "kjYear";

	public static final String PERIOD = "period";

	public static final String DEPT_CODE = "deptCode";

	public static final String PERSON_CODE = "personCode";

	public static final String CUS_CODE = "cusCode";

	public static final String WARE_CODE = "wareCode";

	public static final String PLAN_MONEY = "planMoney";

	public static final String SELL_MONEY = "sellMoney";

	public static final String PLAN_AMOUNT = "planAmount";

	protected void initDao() {
		// do nothing
	}
	
	public ActionForm findById(java.lang.Integer id) {
		log.debug("getting XsPlan instance with id: " + id);
		try {
			XsPlan instance = (XsPlan) getHibernateTemplate().get(
					"com.company.struts.form.XsPlan", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}
	
	
	public List findByExample(ActionForm instance) {
		log.debug("finding XsPlan instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding XsPlan instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from XsPlan as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}
	
	
	//显示部门销售计划列表和查询的方法	
	public List findDeptPlan(Integer startDept,Integer endDept,Integer kjyear)
	{
		try {
				
			String queryString="select a.deptCode,b.deptName,a.kjYear,sum(a.planMoney),sum(a.sellMoney) from XsPlan as a , GyDepartment as b where a.deptCode = b.deptCode ";		
			
			/*
			 * 当起始部门为空时，只查询该部门的销售计划
			 */
			if(startDept!=null)
			{
				if(startDept!=0)
				{
					if(endDept!=null)
					{
						if(endDept!=0)	
						{
							queryString=queryString+" and a.deptCode>="+startDept;
						}
						else
						{
							queryString=queryString+" and a.deptCode="+startDept;
						}
					}
					else 
					{
						queryString=queryString+" and a.deptCode="+startDept;
					}				
				}				
			}
					
			if(endDept!=null)
			{				
				if(endDept!=0)
				{
					if(startDept!=null)
					{
						if(startDept!=0)
						{
							queryString=queryString+" and a.deptCode<="+endDept;
						}
						else 
						{
							queryString=queryString+" and a.deptCode="+endDept;
						}	
					}
					else
					{
						queryString=queryString+" and a.deptCode="+endDept;
					}
				}
						
			}			
			
			if(kjyear!=null )
			{	
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			
			queryString=queryString+" group by a.deptCode,b.deptName,a.kjYear order by a.deptCode asc";
			
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	//查看部门每月销售计划的方法
	public List findDeptMonth(Integer deptcode,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.kjYear,a.period,a.planMoney,a.sellMoney from XsPlan as a,GyDepartment as b where a.deptCode=b.deptCode and a.deptCode="+deptcode+" and a.kjYear="+kjyear+" order by a.period asc";
			return getHibernateTemplate().find(queryString);
			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	public List findDeptPara(Integer deptcode,Integer kjyear,Integer per)
	{
		try {
			String queryString="select a.planId,a.deptCode,b.deptName,a.kjYear,a.period,a.planMoney,a.sellMoney from XsPlan as a,GyDepartment as b where a.deptCode=b.deptCode and a.deptCode="+deptcode+" and a.kjYear="+kjyear+" and a.period="+per;
			return getHibernateTemplate().find(queryString);
			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	
	//显示货物销售列表和查询的方法
	public List findWarePlan(Integer deptcode,Integer warecode,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear,sum(a.planAmount),sum(a.planMoney) from XsPlan as a,GyDepartment as b,GyMaterial as c where a.deptCode=b.deptCode and a.wareCode=c.wareCode";
			if(deptcode!=null)
			{
				if(deptcode!=0)
				{
					queryString=queryString+" and a.deptCode="+deptcode;
				}
			}
			if(warecode!=null)
			{
				if(warecode!=0)
				{
					queryString=queryString+" and a.wareCode="+warecode;
				}
			}
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			queryString=queryString+" group by a.deptCode,b.deptName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear order by a.deptCode";
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	//显示销售员销售列表和查询的方法	
	public List findPersonPlan(Integer personcode,Integer warecode,Integer kjyear)
	{
		try {
			String queryString="select a.personCode,b.personName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear,sum(a.planAmount),sum(a.planMoney) from XsPlan as a,GyPerson as b,GyMaterial as c where a.personCode=b.personCode and a.wareCode=c.wareCode";
			if(personcode!=null)
			{
				if(personcode!=0)
				{
					queryString=queryString+" and a.personCode="+personcode;
				}
			}
			if(warecode!=null)
			{
				if(warecode!=0)
				{
					queryString=queryString+" and a.wareCode="+warecode;
				}
			}
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			queryString=queryString+" group by a.personCode,b.personName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear order by a.personCode";
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	//显示客户销售列表和查询的方法
	public List findCusPlan(Integer deptcode,Integer cuscode,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.cusCode,c.cusName,a.kjYear,sum(a.planMoney),sum(a.sellMoney) from XsPlan as a,GyDepartment as b,GyCustomer as c where a.deptCode=b.deptCode and a.cusCode=c.cusCode";
			if(deptcode!=null)
			{
				if(deptcode!=0)
				{
					queryString=queryString+" and a.deptCode="+deptcode;
				}
			}
			if(cuscode!=null)
			{
				if(cuscode!=0)
				{
					queryString=queryString+" and a.cusCode="+cuscode;
				}
			}
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			queryString=queryString+" group by a.deptCode,b.deptName,a.cusCode,c.cusName,a.kjYear";
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	
	//显示部门销售执行情况
	public List findDeptAct(Integer deptcode,Integer startPer,Integer endPer,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.kjYear,a.period,a.planMoney,a.sellMoney,c.nowValue,(c.nowValue-a.planMoney),(c.nowValue-a.sellMoney),(c.nowValue/a.planMoney)*100,(c.nowValue/a.sellMoney)*100 from XsPlan as a,GyDepartment as b,XsInvoiceBillMain as c where a.deptCode=b.deptCode and a.deptCode=c.deptCode";
			if(deptcode!=null)
			{
				if(deptcode!=0)
				{
					queryString=queryString+" and a.deptCode="+deptcode;
				}
			}
			if(startPer!=null)
			{
				if(startPer!=0)
				{
					if(endPer!=null)
					{
						if(endPer!=0)	
						{
							queryString=queryString+" and a.period>="+startPer;
						}
						else
						{
							queryString=queryString+" and a.period="+startPer;
						}
					}
					else 
					{
						queryString=queryString+" and a.period="+startPer;
					}				
				}				
			}
					
			if(endPer!=null)
			{				
				if(endPer!=0)
				{
					if(startPer!=null)
					{
						if(startPer!=0)
						{
							queryString=queryString+" and a.period<="+endPer;
						}
						else 
						{
							queryString=queryString+" and a.period="+endPer;
						}	
					}
					else
					{
						queryString=queryString+" and a.period="+endPer;
					}
				}