logdaoimpl.java

一个完整的物流系统

package jp.com.cost.dao.impl;

import java.util.ArrayList;
import java.util.List;

import jp.com.cost.common.ComTool;
import jp.com.cost.dao.LogDao;

import jp.com.cost.pojo.Log;

import jp.com.cost.sw.web.form.SW4102Form;
import jp.com.cost.tj.entity.SW5101ViewEntity1;
import jp.com.cost.tj.entity.SW5201ViewEntity1;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class LogDaoImpl extends HibernateDaoSupport implements LogDao {
	Query query;
	Session session;

	/**
	 * 根据利润约束进行统计
	 * 
	 * @param gainUp-利润下限
	 * @param gainDown-利润上限
	 * @return
	 */

	public List findByCon(String gainUp, String gainDown) {

		StringBuffer sql = new StringBuffer();
		sql
				.append("SELECT 	oid,consigner,quantity,accountmoney,dealmoney,gain,updatetime FROM log WHERE  gain>"
						+ gainUp
						+ " And gain<"
						+ gainDown
						+ " And delstate='"
						+ ComTool.UDL + "'");
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(sql.toString());
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			SW5101ViewEntity1 a = new SW5101ViewEntity1();
			a.setOid((Integer) obj[0]);
			a.setConsigner(obj[1].toString());
			a.setQuantity(Double.parseDouble(obj[2].toString()));
			a.setAccountmoney(Double.parseDouble(obj[3].toString()));
			a.setDealmoney(Double.parseDouble(obj[4].toString()));
			a.setGain(Double.parseDouble(obj[5].toString()));
			a.setUpdatetime(obj[6].toString());
			;

			list1.add(a);
		}
		session.close();
		return list1;
	}

	/**
	 * 根据运货量约束进行统计
	 * 
	 * @param quantityUp-运货量下限
	 * @param quantityDown-运货量上限
	 * @return
	 */
	public List findByQuantity(String quantityUp, String quantityDown) {
		// TODO Auto-generated method stub
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT oid,operater,shipCo,quantity,updatetime FROM log WHERE quantity>"
						+ quantityUp
						+ " AND	quantity<"
						+ quantityDown
						+ " AND 	delstate='" + ComTool.UDL + "'");
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(sql.toString());
		List<Object> list = query.list();
		List list2 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			SW5201ViewEntity1 s = new SW5201ViewEntity1();
			s.setOid((Integer) obj[0]);
			s.setOperater(obj[1].toString());
			s.setShipCo(obj[2].toString());
			s.setQuantity(Double.parseDouble(obj[3].toString()));
			s.setUpdatetime(obj[4].toString());
			list2.add(s);
		}
		session.close();
		return list2;
	}

	/**
	 * Method insertLog
	 * 
	 * @param obj
	 * @return bln 表示执行是否成功 fales失败 true成功
	 * @author Angie.K
	 * @使用者 稽核页面 SW4101E2S 保存/登帐 事件
	 * @see jp.com.cost.dao.LogDao#insertLog(Object obj)
	 */

	// obj.getDealCost()-obj.getPayRate()
	// obj.getId(),obj.getSendPeron(),obj.getShipCName(),obj.getWeight(),obj.getDealCost(),obj.getPayRate(),"1.11"
	public boolean insertLog(SW4102Form obj) {
		boolean bln = false;
		// Log log = new
		// Log(1,1,"1","1",1.00d,1.00d,1.00d,1.00d,"admin","2008-9-1","1");
		Log log1 = new Log(null, obj.getId(), obj.getSendPeron(), obj
				.getShipCName(), obj.getWeight(), obj.getDealCost(), obj
				.getPayRate(), obj.getDealCost() - obj.getPayRate(), "Admin",
				"2008-9-9", "1.11");
		getHibernateTemplate().save(log1);

		bln = true;
		return bln;
	}

}