1055b8eeb315001d1425beaaf88110b5

实训时做的物流系统

/******************************************
 *   author@ZhanLiangfei                  *
 *   2008-04-02                           *
 *   本类实现商务部门对费用(委托单)的各项操作方法 *
 ******************************************/
package com.cost.biz.bsm;


import java.util.Calendar;
import java.util.Date;
import java.util.List;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMessage;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import com.cost.persistence.util.HibernateUtil;
import com.cost.persistence.hibernate.home.InvoiceHome;
import com.cost.persistence.hibernate.home.OrderHome;
import com.cost.persistence.hibernate.home.UserinfoHome;
import com.cost.persistence.hibernate.home.ChargeHome;
import com.cost.persistence.hibernate.pojo.Invoice;
import com.cost.persistence.hibernate.pojo.Order;
import com.cost.persistence.hibernate.pojo.Userinfo;
import com.cost.persistence.hibernate.pojo.Charge;
import com.cost.web.struts.action.bsm.FeeUpdateAction;
import com.sun.java_cup.internal.internal_error;

public class FeeOperate implements java.io.Serializable {

	public static List FeeForAccounter(Userinfo userinfo) {
		/* 根据账单员ID查询所有本人提交的委托单，并返回list型查询结果 */
		HibernateUtil.currentSession().beginTransaction();
		Query query = HibernateUtil.currentSession().createQuery(
				"from Order where userinfoByRecorderId =:userinfo");
		query.setEntity("userinfo", userinfo);
		List list = query.list();
		return list;
	}

	public static List FeeWaitForCheck() {
		/* 查询数据库中所有状态为"待稽核"的费用单(委托单)，返回list型查询结果 */
		HibernateUtil.currentSession().beginTransaction();
		Query query = HibernateUtil.currentSession().createQuery(
				"select order from Order order, Charge charge where order = charge.order");
		List list = query.list();
		return list;
	}

	public static List FeeWaitForRecord() {
		/* 遍历数据库中所有状态为"已稽核/待登帐"的费用单(委托单)，返回list型查询结果" */
		List list = HibernateUtil.currentSession().createQuery(
				"from Order where cancleState ='1' or cancleState = '2'").list();
		return list;
	}

	public static List FeeWaitForCancle() {
		/* 遍历数据库中所有状态为"已登帐/待核销"的费用单(委托单)，返回list型查询结果" */
		List list = HibernateUtil.currentSession().createQuery(
				"from Order where cancleState='2' or cancleState = '3'").list();
		return list;
	}
	
	public static List FeeWaitForRelease() {
		/* 遍历数据库中所有状态为"已登帐/待核销"的费用单(委托单)，返回list型查询结果" */
		List list = HibernateUtil.currentSession().createQuery(
				"from Order where cancleState='3'").list();
		return list;
	}
    
	public static Order FeeView(String orderNo) {
		/* 按委托单号查询某一委托单的明细，返回查询结果 */
		List list = OrderHome.getInstance().findByOrderNo(orderNo);
		Order order = (Order) list.get(0);
		return order;
	}

	public static ActionErrors OrderUpdate(Order order) {
		/* 更新费用单 */
		ActionErrors errors = new ActionErrors();
		try {
			HibernateUtil.currentSession().beginTransaction();
			OrderHome.getInstance().attachDirty(order);
			HibernateUtil.currentSession().getTransaction().commit();
		} catch (Exception e) {
			HibernateUtil.currentSession().getTransaction().rollback();
			errors
					.add("feeUpdate", new ActionMessage(
							"feeadd.database.failed"));
		}
		return errors;
	}

	public static Charge FindCharge(int orderid) {
		/* 根据委托单号查找该笔业务费用明细 */
		HibernateUtil.currentSession().beginTransaction();
		Query query = HibernateUtil.currentSession().createQuery(
				"from Charge where order_id=" + orderid);
		List list = query.list();
		return (Charge) list.get(0);
	}

	public static void ChargeRecord(Charge charge) {
		/* 为某笔委托单录入费用明细 */
		try {
			HibernateUtil.currentSession().beginTransaction();
			ChargeHome.getInstance().attachDirty(charge);
			HibernateUtil.currentSession().getTransaction().commit();
		} catch (Exception e) {
			HibernateUtil.currentSession().getTransaction().rollback();
		}
	}
   public static Invoice InvoiceFindByNum(String invoiceNum){
		/* 按发票号查找发票信息，返回发票类 */
	      List list  = InvoiceHome.getInstance().findByInvoiceNum(invoiceNum);
	      Invoice invoice = (Invoice)list.get(0);
	      return invoice;
   }
   public static List OrderWaitForAddfee(){
	   /*查询所有待录入费用的委托单*/
	   List list = HibernateUtil.currentSession().createQuery
	   ("from Order as order where order not in(select order from Order order, Charge charge where order = charge.order)").list();
	   return list;
   }  
   public static List OrderWaitForRelease(){
	   /*查询所有可以放单的委托单*/
	   List list = HibernateUtil.currentSession().createQuery
	   ("form Order where cancleState='3'").list();
	   return list;
   }
   public static void main(String[] args) {
	List list = FeeWaitForCheck()();
	System.out.println(list.size());
}
}