xsplandao.java

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

						
			}			
			
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
		
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
//	显示货物销售执行情况
	public List findWareAct(Integer deptcode,Integer warecode,Integer startPer,Integer endPer,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear,a.period,a.planMoney,a.planAmount," +
					"			d.capitalWhole,d.quantity,(d.capitalWhole-a.planMoney),(d.quantity-a.planAmount),(d.capitalWhole/a.planMoney)*100," +
					"			(d.quantity/a.planAmount)*100,e.invoiceBillMainId from XsPlan as a,GyDepartment as b,GyMaterial as c,XsInvoiceBillSub as d,XsInvoiceBillMain as e " +
					"			where a.deptCode=b.deptCode and a.wareCode=c.wareCode and a.deptCode=e.deptCode and d.invoiceBillMainId=e.invoiceBillMainId";
			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(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;
					}
				}
						
			}			
			
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	
//	显示销售员销售执行情况
	public List findPersonAct(Integer personcode,Integer warecode,Integer startPer,Integer endPer,Integer kjyear)
	{
		try {
			String queryString="select a.personCode,b.personName,a.wareCode,c.wareName,c.wareType,c.warePrice,a.kjYear,a.period,a.planMoney,a.planAmount," +
					"			d.capitalWhole,d.quantity,(d.capitalWhole-a.planMoney),(d.quantity-a.planAmount),(d.capitalWhole/a.planMoney)*100," +
					"			(d.quantity/a.planAmount)*100,e.invoiceBillMainId from XsPlan as a,GyPerson as b,GyMaterial as c,XsInvoiceBillSub as d,XsInvoiceBillMain as e " +
					"			where a.personCode=b.personCode and a.wareCode=c.wareCode and a.personCode=e.personCode and d.invoiceBillMainId=e.invoiceBillMainId";
			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(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;
					}
				}
						
			}			
			
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	
	
//	显示客户销售执行情况
	public List findCusAct(Integer deptcode,Integer cuscode,Integer startPer,Integer endPer,Integer kjyear)
	{
		try {
			String queryString="select a.deptCode,b.deptName,a.cusCode,c.cusName,a.kjYear,a.period,a.planMoney,a.sellMoney," +
					"			d.capitalWhole,(d.capitalWhole-a.planMoney),(d.capitalWhole-a.sellMoney),(d.capitalWhole/a.planMoney)*100," +
					"			(d.capitalWhole/a.sellMoney)*100,e.invoiceBillMainId from XsPlan as a,GyDepartment as b,GyCustomer as c,XsInvoiceBillSub as d,XsInvoiceBillMain as e " +
					"			where a.deptCode=b.deptCode and a.cusCode=c.cusCode and a.deptCode=e.deptCode and a.cusCode=e.cusCode and d.invoiceBillMainId=e.invoiceBillMainId";
			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(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;
					}
				}
						
			}			
			
			if(kjyear!=null)
			{
				if(kjyear!=0)
				{
					queryString=queryString+" and a.kjYear="+kjyear;
				}
			}
			
			return getHibernateTemplate().find(queryString);			
		} catch (RuntimeException re) {
			throw re;
		}
	}
	


	public List findByKjYear(Object kjYear) {
		return findByProperty(KJ_YEAR, kjYear);
	}

	public List findByPeriod(Object period) {
		return findByProperty(PERIOD, period);
	}

	public List findByDeptCode(Object deptCode) {
		return findByProperty(DEPT_CODE, deptCode);
	}

	public List findByPersonCode(Object personCode) {
		return findByProperty(PERSON_CODE, personCode);
	}

	public List findByCusCode(Object cusCode) {
		return findByProperty(CUS_CODE, cusCode);
	}

	public List findByWareCode(Object wareCode) {
		return findByProperty(WARE_CODE, wareCode);
	}

	public List findByPlanMoney(Object planMoney) {
		return findByProperty(PLAN_MONEY, planMoney);
	}

	public List findByPlanMoneyMin(Object sellMoney) {
		return findByProperty(SELL_MONEY, sellMoney);
	}

	public List findByPlanAmount(Object planAmount) {
		return findByProperty(PLAN_AMOUNT, planAmount);
	}

	public List findAll() {
		log.debug("finding all XsPlan instances");
		try {
			String queryString = "from XsPlan";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public void attachDirty(XsPlan instance) {
		log.debug("attaching dirty XsPlan instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(XsPlan instance) {
		log.debug("attaching clean XsPlan instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static IXsPlanDAO getFromApplicationContext(ApplicationContext ctx) {
		return (IXsPlanDAO) ctx.getBean("XsPlanDAO");
	}
}