30eacb707aba001b101097118648788b

来自「gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程」· 代码 · 共 57 行

package com.gensou.dao.production;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.gensou.hibernate.model.Shengchanjihua;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.sheji.plan.QueryPlans;
import com.gensou.util.Pagination;

public class QueryplanDao {
	 public List queryway(String scjhid,int max,int page){
		 Session session=HibernateSessionFactory.getSession();
		 List list;
		 List plan_info=new ArrayList();
		 Query query;
		 if(scjhid==null||scjhid.equals("")){
			 query=session.createQuery("from Shengchanjihua where zhuangtai=0");
			 Pagination pagination=new Pagination();
			 list=pagination.getNowlist(query,page,max);
			 if(!list.isEmpty()&&list!=null){
				 for(int i=0;i<list.size();i++){
					 Shengchanjihua plan=(Shengchanjihua)list.get(i);
					 QueryPlans plans=new QueryPlans(plan);
					 plan_info.add(plans);
				 }
			 }
		 }else{
			 query=session.createQuery("from Shengchanjihua where shengchangjihanId like ? and zhuangtai=0");
			 query.setString(0,"%"+scjhid+"%");
			 Pagination pagination=new Pagination();
			 list=pagination.getNowlist(query,page,max);
			 if(!list.isEmpty()&&list!=null){
				 for(int i=0;i<list.size();i++){
					 Shengchanjihua plan=(Shengchanjihua)list.get(i);
					 QueryPlans plans=new QueryPlans(plan);
					 plan_info.add(plans);
				 }
			 }
		 }
		 return plan_info;
	 }
	 public void deleteplan(Integer id){
		 Session session=HibernateSessionFactory.getSession();
		 session.clear();
		 Transaction tx = session.beginTransaction();
		 Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, id);
		 plan.setZhuangtai("1");
		 session.update(plan);
		 session.clear();
	 }
}