xsconsignbillmaindao.java

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

package com.company.hib.dao.impl;

import java.util.Date;
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.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.company.hib.dao.DAOAdapter;
import com.company.hib.dao.DAOPriceList;
import com.company.hib.dao.IConsignBillMainDAO;
import com.company.struts.form.XsConsignBillMain;

/**
 * Data access object (DAO) for domain model class XsConsignBillMain.
 * 
 * @see com.company.struts.form.XsConsignBillMain
 * @author MyEclipse Persistence Tools
 */

public class XsConsignBillMainDAO extends DAOAdapter implements IConsignBillMainDAO,DAOPriceList{
	private static final Log log = LogFactory
			.getLog(XsConsignBillMainDAO.class);

	// property constants
	public static final String CONSIGN_CODE = "consignCode";

	public static final String ORDER_BILL_MAIN_ID = "orderBillMainId";

	public static final String ORDER_CODE = "orderCode";

	public static final String KJ_YEAR = "kjYear";

	public static final String PERIOD = "period";

	public static final String CONSIGN_FLAG = "consignFlag";

	public static final String BILL_TYPE = "billType";

	public static final String SELL_TYPE_CODE = "sellTypeCode";

	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 PAY_CODE = "payCode";

	public static final String KDFLAG = "kdflag";

	public static final String RECEIVE_FLAG = "receiveFlag";

	public static final String CONSIGN_ADDRESS = "consignAddress";

	public static final String FOREIGN_CURR_CODE = "foreignCurrCode";

	public static final String EXCH_RATE = "exchRate";

	public static final String ACOUNT_OPT = "acountOpt";

	public static final String RETURN_SOURCE = "returnSource";

	public static final String RETURN_SOURCE_CODE = "returnSourceCode";

	public static final String FETCH_PERSON = "fetchPerson";

	public static final String MAKER = "maker";

	public static final String CHECKER = "checker";

	public static final String REMARK = "remark";

	public static final String CONVERT_FLAG = "convertFlag";

	public static final String RETURN_MONEY_FLAG = "returnMoneyFlag";

	public static final String PRE_FLAG = "preFlag";

	public static final String OUT_FLAG = "outFlag";

	protected void initDao() {
		// do nothing
	}
	
	public List findSum()
	{
		String sq="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 ";
		List sql=this.getHibernateTemplate().find(sq);
		return sql;
	}
	
	//发货单编制中显示所有的信息
	public List findByConsignAll(String ordercode)
	{
		try
		{
			String queryString="select b.wareCode,c.wareName,c.wareType,c.warePrice,b.quantity,b.recQuantity,b.taxUnitPrice,b.taxMoney,b.wholeMoney,b.consignMoney,b.discountMoney,b.remark,b.taxRate,b.unitPrice" +
								" from XsConsignBillMain as a,XsConsignBillSub as b,GyMaterial as c "
								+"where a.consignCode=b.consignCode and b.wareCode=c.wareCode";
			
			if(ordercode!=null)
			{
				if(!ordercode.equals("0"))
				{
					queryString=queryString+" and a.orderCode="+ordercode;
				}
			}			
			return getHibernateTemplate().find(queryString);
		}
		catch (RuntimeException re) {
			throw re;
		}
	}

	//显示发货单列表信息
	public List findByConsignBill(String startConsignDate,String endConsignDate,Integer cuscode,String ordercode,String consigncode,Integer warecode,Integer deptcode,Integer personcode,Integer sellTypecode)
	{
		try
		{
			String queryString="select a.consignDate,a.consignCode,a.cusCode,a.deptCode,a.personCode,a.sellTypeCode,b.wareCode,c.wareType,c.warePrice,b.quantity,b.recQuantity,b.capitalUnitPrice,b.capitalTaxUnitPrice,b.capitalWhole,b.capitalTax,b.capitalDiscount,a.maker,a.checker" +
								" from XsConsignBillMain as a,XsConsignBillSub as b,GyMaterial as c "
								+"where a.consignCode=b.consignCode and b.wareCode=c.wareCode";
			if(startConsignDate!=null)
			{
				if(!startConsignDate.equals("0"))
				{
					if(endConsignDate!=null)
					{
						
						String ss=startConsignDate.substring(0, 10);
						startConsignDate=ss;						
						
						if(!endConsignDate.equals("0"))	
						{
							queryString=queryString+" and a.consignDate>='"+startConsignDate+"'";
						}
						else
						{
							queryString=queryString+" and a.consignDate='"+startConsignDate+"'";
						}
					}
					else 
					{
						queryString=queryString+" and a.consignDate='"+startConsignDate+"'";
					}				
				}				
			}
					
			if(endConsignDate!=null)
			{				
				if(!endConsignDate.equals("0"))
				{
					
					String ss=endConsignDate.substring(0, 10);
					endConsignDate=ss;
					
					if(startConsignDate!=null)
					{
						if(!startConsignDate.equals("0"))
						{
							queryString=queryString+" and a.consignDate<='"+endConsignDate+"'";
						}
						else 
						{
							queryString=queryString+" and a.consignDate='"+endConsignDate+"'";
						}	
					}
					else
					{
						queryString=queryString+" and a.consignDate='"+endConsignDate+"'";
					}
				}
			}	
			if(cuscode!=null)
			{
				if(cuscode!=0)
				{
					queryString=queryString+" and a.cusCode="+cuscode;
				}
			}
			if(ordercode!=null)
			{
				if(!ordercode.equals(""))
				{
					queryString=queryString+" and a.orderCode="+ordercode;
				}
			}
			if(consigncode!=null)
			{
				if(!consigncode.equals(""))
				{
					queryString=queryString+" and a.consignCode="+consigncode;
				}
			}
			if(warecode!=null)
			{
				if(warecode!=0)
				{
					queryString=queryString+" and b.wareCode="+warecode;
				}
			}
			if(deptcode!=null)
			{
				if(deptcode!=0)
				{
					queryString=queryString+" and a.deptCode="+deptcode;
				}
			}	
			if(personcode!=null)
			{
				if(personcode!=0)
				{
					queryString=queryString+" and a.personCode="+personcode;
				}
			}
			if(sellTypecode!=null)
			{
				if(sellTypecode!=0)
				{
					queryString=queryString+" and a.sellTypeCode="+sellTypecode;
				}
			}		
			
			return getHibernateTemplate().find(queryString);
		}
		catch (RuntimeException re) {
			throw re;
		}
	}
	
	//显示发货单回执列表信息
	public List findByConsignRec(String startConsignDate,String endConsignDate,Integer cuscode,String consigncode,Integer warecode,Integer deptcode,Integer personcode,Integer sellTypecode)
	{
		try
		{
			String queryString="select a.consignDate,a.consignCode,a.cusCode,a.deptCode,a.personCode,a.sellTypeCode,b.wareCode,c.wareType,c.warePrice,b.emergeQuantity,b.recQuantity,b.capitalUnitPrice,b.capitalTaxUnitPrice,b.capitalWhole,b.capitalTax,b.capitalDiscount,a.receiveFlag,b.loseCause" +
								" from XsConsignBillMain as a,XsConsignBillSub as b,GyMaterial as c "
								+"where a.consignCode=b.consignCode and b.wareCode=c.wareCode";
			if(startConsignDate!=null)
			{
				if(!startConsignDate.equals("0"))
				{
					if(endConsignDate!=null)
					{
						
						String ss=startConsignDate.substring(0, 10);
						startConsignDate=ss;						
						
						if(!endConsignDate.equals("0"))	
						{
							queryString=queryString+" and a.consignDate>='"+startConsignDate+"'";
						}
						else
						{
							queryString=queryString+" and a.consignDate='"+startConsignDate+"'";
						}
					}
					else 
					{
						queryString=queryString+" and a.consignDate='"+startConsignDate+"'";
					}				
				}				
			}
					
			if(endConsignDate!=null)
			{				
				if(!endConsignDate.equals("0"))
				{
					
					String ss=endConsignDate.substring(0, 10);
					endConsignDate=ss;
					
					if(startConsignDate!=null)
					{
						if(!startConsignDate.equals("0"))
						{
							queryString=queryString+" and a.consignDate<='"+endConsignDate+"'";
						}
						else 
						{
							queryString=queryString+" and a.consignDate='"+endConsignDate+"'";
						}	
					}
					else
					{
						queryString=queryString+" and a.consignDate='"+endConsignDate+"'";
					}
				}
			}	
			if(cuscode!=null)
			{
				if(cuscode!=0)
				{
					queryString=queryString+" and a.cusCode="+cuscode;
				}
			}
			if(consigncode!=null)
			{
				if(!consigncode.equals("0"))
				{
					queryString=queryString+" and a.consignCode="+consigncode;
				}
			}
			if(warecode!=null)
			{
				if(warecode!=0)
				{
					queryString=queryString+" and b.wareCode="+warecode;
				}
			}
			if(deptcode!=null)
			{
				if(deptcode!=0)
				{
					queryString=queryString+" and a.deptCode="+deptcode;
				}
			}	
			if(personcode!=null)
			{
				if(personcode!=0)
				{
					queryString=queryString+" and a.personCode="+personcode;
				}
			}
			if(sellTypecode!=null)
			{
				if(sellTypecode!=0)
				{
					queryString=queryString+" and a.sellTypeCode="+sellTypecode;
				}
			}		
			return getHibernateTemplate().find(queryString);
		}
		catch (RuntimeException re) {
			throw re;
		}
	}

	public ActionForm findById(java.lang.Integer id) {
		log.debug("getting XsConsignBillMain instance with id: " + id);
		try {
			XsConsignBillMain instance = (XsConsignBillMain) getHibernateTemplate()
					.get("com.company.struts.form.XsConsignBillMain", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(ActionForm instance) {
		log.debug("finding XsConsignBillMain 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 XsConsignBillMain instance with property: "
				+ propertyName + ", value: " + value);
		try {
			String queryString = "from XsConsignBillMain 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 findByConsignCode(Object consignCode) {
		return findByProperty(CONSIGN_CODE, consignCode);
	}

	public List findByOrderBillMainId(Object orderBillMainId) {
		return findByProperty(ORDER_BILL_MAIN_ID, orderBillMainId);
	}

	public List findByOrderCode(Object orderCode) {
		return findByProperty(ORDER_CODE, orderCode);
	}

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

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

	public List findByConsignFlag(Object consignFlag) {
		return findByProperty(CONSIGN_FLAG, consignFlag);
	}

	public List findByBillType(Object billType) {
		return findByProperty(BILL_TYPE, billType);
	}

	public List findBySellTypeCode(Object sellTypeCode) {
		return findByProperty(SELL_TYPE_CODE, sellTypeCode);
	}

	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 findByPayCode(Object payCode) {
		return findByProperty(PAY_CODE, payCode);
	}

	public List findByKdflag(Object kdflag) {
		return findByProperty(KDFLAG, kdflag);
	}

	public List findByReceiveFlag(Object receiveFlag) {
		return findByProperty(RECEIVE_FLAG, receiveFlag);
	}

	public List findByConsignAddress(Object consignAddress) {
		return findByProperty(CONSIGN_ADDRESS, consignAddress);
	}

	public List findByForeignCurrCode(Object foreignCurrCode) {
		return findByProperty(FOREIGN_CURR_CODE, foreignCurrCode);
	}

	public List findByExchRate(Object exchRate) {
		return findByProperty(EXCH_RATE, exchRate);
	}

	public List findByAcountOpt(Object acountOpt) {
		return findByProperty(ACOUNT_OPT, acountOpt);
	}

	public List findByReturnSource(Object returnSource) {
		return findByProperty(RETURN_SOURCE, returnSource);
	}

	public List findByReturnSourceCode(Object returnSourceCode) {
		return findByProperty(RETURN_SOURCE_CODE, returnSourceCode);
	}

	public List findByFetchPerson(Object fetchPerson) {
		return findByProperty(FETCH_PERSON, fetchPerson);
	}

	public List findByMaker(Object maker) {
		return findByProperty(MAKER, maker);
	}

	public List findByChecker(Object checker) {
		return findByProperty(CHECKER, checker);
	}

	public List findByRemark(Object remark) {
		return findByProperty(REMARK, remark);
	}

	public List findByConvertFlag(Object convertFlag) {
		return findByProperty(CONVERT_FLAG, convertFlag);
	}

	public List findByReturnMoneyFlag(Object returnMoneyFlag) {
		return findByProperty(RETURN_MONEY_FLAG, returnMoneyFlag);
	}

	public List findByPreFlag(Object preFlag) {
		return findByProperty(PRE_FLAG, preFlag);
	}

	public List findByOutFlag(Object outFlag) {
		return findByProperty(OUT_FLAG, outFlag);
	}

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

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

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

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