package com.jshop.dao.impl;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import javax.annotation.Resource;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;
import com.jshop.dao.OrderTDao;
import com.jshop.entity.OrderT;
/**
* A data access object (DAO) providing persistence and search support for
* OrderT entities. Transaction control of the save(), update() and delete()
* operations can directly support Spring container-managed transactions or they
* can be augmented to handle user-managed Spring transactions. Each of these
* methods provides additional information for how to configure it for the
* desired type of transaction control.
*
* @see com.jshop.entity.OrderT
* @author MyEclipse Persistence Tools
*/
@Repository("orderTDao")
public class OrderTDaoImpl extends HibernateDaoSupport implements OrderTDao {
private static final Log log = LogFactory.getLog(OrderTDaoImpl.class);
public int addOrder(OrderT o) {
log.debug("save OrderT");
try {
this.getHibernateTemplate().save(o);
log.debug("save successful");
return 1;
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
public int delOrderByorderid(final String userid, final String orderid, final String orderstate) {
log.debug("update OrderT");
try {
final String queryString = "update OrderT as o set o.orderstate=:orderstate where o.userid=:userid and o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("userid", userid);
query.setParameter("orderid", orderid);
query.setParameter("orderstate", orderstate);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT error", re);
throw re;
}
return 0;
}
public int countfindAllOrderByorderstate(String userid, String orderstate, String paystate, String shippingstate) {
log.debug("count all OrderT by OrderTstate");
try {
String queryString = "select count(*) from OrderT as o where o.userid=:userid and o.orderstate!=:orderstate and o.paystate=:paystate and o.shippingstate=:shippingstate";
List list = this.getHibernateTemplate().findByNamedParam(queryString, new String[] { "userid", "orderstate", "paystate", "shippingstate" }, new Object[] { userid, orderstate, paystate, shippingstate });
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all OrderT by OrderTstate error", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllOrderByorderstate(final int currentPage, final int lineSize, final String userid, final String orderstate, final String paystate, final String shippingstate) {
log.debug("find all OrderT by OrderTstate");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o where o.orderstate!=:orderstate and o.userid=:userid and o.paystate=:paystate and o.shippingstate=:shippingstate order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("userid", userid);
query.setParameter("orderstate", orderstate);
query.setParameter("shippingstate", shippingstate);
query.setParameter("paystate", paystate);
List list = query.list();
return list;
}
});
return list;
} catch (RuntimeException re) {
log.error("find all OrderT by OrderTstate error", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllOrderByorderstateForOn(final int currentPage, final int lineSize, final String userid, final String orderstate, final String paystate, final String shippingstate) {
log.debug("find all OrderT by OrderTstate");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o where o.orderstate!=:orderstate and o.userid=:userid and o.paystate!=:paystate and o.shippingstate!=:shippingstate order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("userid", userid);
query.setParameter("orderstate", orderstate);
query.setParameter("shippingstate", shippingstate);
query.setParameter("paystate", paystate);
List list = query.list();
return list;
}
});
return list;
} catch (RuntimeException re) {
log.error("find all OrderT by OrderTstate error", re);
throw re;
}
}
public int countfindAllOrderByorderstateForOn(String userid, String orderstate, String paystate, String shippingstate) {
log.debug("count all OrderT by OrderTstate");
try {
String queryString = "select count(*) from OrderT as o where o.userid=:userid and o.orderstate!=:orderstate and o.paystate!=:paystate and o.shippingstate!=:shippingstate";
List list = this.getHibernateTemplate().findByNamedParam(queryString, new String[] { "userid", "orderstate", "paystate", "shippingstate" }, new Object[] { userid, orderstate, paystate, shippingstate });
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all OrderT by OrderTstate error", re);
throw re;
}
}
public OrderT findOrderDetailByorderid(String orderid) {
log.debug("getting findOrderDetailByorderid instance with id: " + orderid);
try {
OrderT list = (OrderT) this.getHibernateTemplate().get("com.jshop.entity.OrderT", orderid);
return list;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}
public int updateOrder(final OrderT o) {
log.debug("update OrderT");
try {
final String queryString = "update OrderT as o set o.username=:username,o.paymentid=:paymentid,o.paymentname=:paymentname,o.delivermode=:delivermode,o.deliverynumber=:deliverynumber," + "o.orderstate=:orderstate,o.logisticsid=:logisticsid,o.freight=:freight,o.amount=:amount,o.points=:points,o.purchasetime=:purchasetime,o.deliverytime=:deliverytime,o.invoice=:invoice," + "o.shippingaddressid=:shippingaddressid,o.customernotes=:customernotes,o.logisticswebaddress=:logisticswebaddress,o.paytime=:paytime,o.orderTag=:orderTag,o.toBuyer=:toBuyer," + "o.shouldpay=:shouldpay,o.usepoints=:usepoints,o.vouchersid=:vouchersid,o.goodid=:goodid,o.goodsname=:goodsname,o.needquantity=:needquantity,o.paystate=:paystate,o.shippingstate=:shippingstate,"
+ "o.deliveraddressid=:deliveraddressid,o.shippingusername=:shippingusername,o.createtime=:createtime where o.orderid=:orderid and o.userid=:userid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", o.getOrderid());
query.setParameter("userid", o.getUserid());
query.setParameter("username", o.getUsername());
query.setParameter("paymentid", o.getPaymentid());
query.setParameter("paymentname", o.getPaymentname());
query.setParameter("delivermode", o.getDelivermode());
query.setParameter("deliverynumber", o.getDeliverynumber());
query.setParameter("orderstate", o.getOrderstate());
query.setParameter("logisticsid", o.getLogisticsid());
query.setParameter("freight", o.getFreight());
query.setParameter("amount", o.getAmount());
query.setParameter("points", o.getPoints());
query.setParameter("purchasetime", o.getPurchasetime());
query.setParameter("deliverytime", o.getDeliverytime());
query.setParameter("invoice", o.getInvoice());
query.setParameter("shippingaddressid", o.getShippingaddressid());
query.setParameter("customernotes", o.getCustomernotes());
query.setParameter("logisticswebaddress", o.getLogisticswebaddress());
query.setParameter("paytime", o.getPaytime());
query.setParameter("orderTag", o.getOrderTag());
query.setParameter("toBuyer", o.getToBuyer());
query.setParameter("shouldpay", o.getShouldpay());
query.setParameter("usepoints", o.getUsepoints());
query.setParameter("vouchersid", o.getVouchersid());
query.setParameter("goodid", o.getGoodid());
query.setParameter("goodsname", o.getGoodsname());
query.setParameter("needquantity", o.getNeedquantity());
query.setParameter("paystate", o.getPaystate());
query.setParameter("shippingstate", o.getShippingstate());
query.setParameter("deliveraddressid", o.getDeliveraddressid());
query.setParameter("shippingusername", o.getShippingusername());
query.setParameter("createtime", o.getCreatetime());
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT error", re);
throw re;
}
return 0;
}
public int updateOrderPaystateByorderid(final String orderid, final String paystate) {
log.debug("update OrderT paystate");
try {
final String queryString = "update OrderT as o set o.paystate=:paystate where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("paystate", paystate);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT paystate error", re);
throw re;
}
return 0;
}
public int updateOrderShippingstateByorderid(final String orderid, final String shippingstate) {
log.debug("update OrderT UpdateOrderShippingstateByorderid");
try {
final String queryString = "update OrderT as o set o.shippingstate=:shippingstate where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("shippingstate", shippingstate);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateOrderShippingstateByorderid error", re);
throw re;
}
return 0;
}
public int updateOrderStateByorderid(final String orderid, final String orderstate) {
log.debug("update OrderT UpdateOrderStateByorderid");
try {
final String queryString = "update OrderT as o set o.orderstate=:orderstate where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("orderstate", orderstate);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateOrderStateByorderid error", re);
throw re;
}
return 0;
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllOrderT(final int currentPage, final int lineSize) {
log.debug("find all OrderT");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
List list = query.list();
return list;
}
});
if (list.size() > 0) {
return list;
}
return null;
} catch (RuntimeException re) {
log.error("find all OrderT ", re);
throw re;
}
}
public int countfindAllOrderT() {
log.debug("count all OrderT");
try {
String queryString = "select count(*) from OrderT";
List list = this.getHibernateTemplate().find(queryString);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all OrderT ", re);
throw re;
}
}
public int countfindOrderbyOrderid(String orderid) {
log.debug("count all countfindOrderbyOrderid");
try {
String queryString = "select count(*) from OrderT as o where o.orderid=:orderid";
List list = this.getHibernateTemplate().findByNamedParam(queryString, "orderid", orderid);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all countfindOrderbyOrderid ", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findOrderByOrderid(final int currentPage, final int lineSize, final String orderid) {
log.debug("find all findOrderByOrderid");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o where o.orderid=:orderid order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("orderid", orderid);
List list = query.list();
return list;
}
});
if (list.size() > 0) {
return list;
}
return null;
} catch (RuntimeException re) {
log.error("find all findOrderByOrderid ", re);
throw re;
}
}
public int countfindOrderByShippingUsername(String shippingusername) {
log.debug("count all countfindOrderByShippingUsername");
try {
String queryString = "select count(*) from OrderT as o where o.shippingusername=:shippingusername";
List list = this.getHibernateTemplate().findByNamedParam(queryString, "shippingusername", shippingusername);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all countfindOrderByShippingUsername ", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findOrderByShippingUsername(final int currentPage, final int lineSize, final String shippingusername) {
log.debug("find all findOrderByShippingUsername");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o where o.shippingusername=:shippingusername order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("shippingusername", shippingusername);
List list = query.list();
return list;
}
});
if (list.size() > 0) {
return list;
}
return null;
} catch (RuntimeException re) {
log.error("find all findOrderByShippingUsername ", re);
throw re;
}
}
public int updateOrderPayShippingState(final String orderid, final String orderstate, final String paystate, final String shippingstate) {
log.debug("update OrderT UpdateOrderPayShippingState");
try {
final String queryString = "update OrderT as o set o.orderstate=:orderstate,o.paystate=:paystate,o.shippingstate=:shippingstate where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("orderstate", orderstate);
query.setParameter("paystate", paystate);
query.setParameter("shippingstate", shippingstate);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateOrderPayShippingState error", re);
throw re;
}
return 0;
}
public int countfindAllTobeShippedOrders(String shippingstate) {
log.debug("count all countfindAllTobeShippedOrders");
try {
String queryString = "select count(*) from OrderT as o where o.orderstate='1' or o.orderstate='2' and o.paystate='0' or o.paystate='1' and o.shippingstate=:shippingstate order by purchasetime desc";
List list = this.getHibernateTemplate().findByNamedParam(queryString, "shippingstate", shippingstate);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
return 0;
} catch (RuntimeException re) {
log.error("count all countfindAllTobeShippedOrders ", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllTobeShippedOrders(final int currentPage, final int lineSize, final String shippingstate) {
log.debug("find all findAllTobeShippedOrders");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
String queryString = "from OrderT as o where o.orderstate='1' or o.orderstate='2' and o.paystate='0' or o.paystate='1' and o.shippingstate=:shippingstate order by purchasetime desc";
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("shippingstate", shippingstate);
List list = query.list();
return list;
}
});
if (list.size() > 0) {
return list;
}
return null;
} catch (RuntimeException re) {
log.error("find all findAllTobeShippedOrders ", re);
throw re;
}
}
public int updateExpressnumberByOrderId(final String orderid, final String expressnumber) {
log.debug("update OrderT UpdateExpressnumberByOrderId");
try {
final String queryString = "update OrderT as o set o.expressnumber=:expressnumber where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("expressnumber", expressnumber);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateExpressnumberByOrderId error", re);
throw re;
}
return 0;
}
//deliverynumber invoicenumber
//deliverytime invoicetime
public int updateInvoicenumberByOrderId(final String orderid, final String deliverynumber, final Date deliverytime) {
log.debug("update OrderT UpdateInvoicenumberByOrderId");
try {
final String queryString = "update OrderT as o set o.deliverynumber=:deliverynumber,o.deliverytime=:deliverytime where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("deliverynumber", deliverynumber);
query.setParameter("deliverytime", deliverytime);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateInvoicenumberByOrderId error", re);
throw re;
}
return 0;
}
public int updateInvoiceByOrderId(final String orderid, final String invoice) {
log.debug("update OrderT UpdateInvoiceByOrderId");
try {
final String queryString = "update OrderT as o set o.invoice=:invoice where o.orderid=:orderid";
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
int i = 0;
Query query = session.createQuery(queryString);
query.setParameter("orderid", orderid);
query.setParameter("invoice", invoice);
i = query.executeUpdate();
++i;
return i;
}
});
} catch (RuntimeException re) {
log.error("update OrderT UpdateInvoicenumberByOrderId error", re);
throw re;
}
return 0;
}
@SuppressWarnings("unchecked")
public List<OrderT> sortAllOrderT(final int currentPage, final int lineSize, final String queryString) {
log.debug("find all OrderT");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
List list = query.list();
return list;
}
});
if (list.size() > 0) {
return list;
}
return null;
} catch (RuntimeException re) {
log.error("find all OrderT ", re);
throw re;
}
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllhaveshippedOrder(final int currentPage, final int lineSize, final String shippingstate) {
log.debug("find all haveshippedOrder");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
String queryString = "from OrderT as ot where ot.shippingstate=:shippingstate order by purchasetime desc";
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("shippingstate", shippingstate);
List list = query.list();
return list;
}
});
if (list.size() > 0 && list != null) {
return list;
}
return null;
} catch (DataAccessException e) {
// TODO Auto-generated catch block
log.error("find all haveshippedOrder error");
e.printStackTrace();
throw e;
}
}
@SuppressWarnings("unchecked")
public int countAllhaveshippedOrder(String shippingstate) {
log.debug("count all haveshippedOrder");
try {
String queryString = "select count(*) from OrderT as ot where ot.shippingstate=:shippingstate order by purchasetime desc";
List<OrderT> list = this.getHibernateTemplate().findByNamedParam(queryString, "shippingstate", shippingstate);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
} catch (DataAccessException e) {
// TODO Auto-generated catch block
log.error("count all haveshippedOrder error");
e.printStackTrace();
throw e;
}
return 0;
}
@SuppressWarnings("unchecked")
public int countAllreturnOrder(String orderstate) {
log.debug("count all returnOrder");
try {
String queryString = "select count(*) from OrderT as ot where ot.orderstate=:orderstate order by purchasetime desc";
List<OrderT> list = this.getHibernateTemplate().findByNamedParam(queryString, "orderstate", orderstate);
if (list.size() > 0) {
Object o = list.get(0);
long l = (Long) o;
return (int) l;
}
} catch (DataAccessException e) {
// TODO Auto-generated catch block
log.error("count all returnOrder error");
e.printStackTrace();
throw e;
}
return 0;
}
@SuppressWarnings("unchecked")
public List<OrderT> findAllreturnOrder(final int currentPage, final int lineSize, final String orderstate) {
log.debug("find all returnOrder");
try {
List<OrderT> list = this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
String queryString = "from OrderT as ot where ot.orderstate=:orderstate order by purchasetime desc";
Query query = session.createQuery(queryString);
query.setFirstResult((currentPage - 1) * lineSize);
query.setMaxResults(lineSize);
query.setParameter("orderstate", orderstate);
List list = query.list();
return list;
}
});
if (list.size() > 0 && list != null) {
return list;
}
return null;
} catch (DataAccessException e) {
// TODO Auto-generated catch block
log.error("find all returnOrder error");
e.printStackTrace();
throw e;
}
}
}