gdzcserviceimpl.java

本源码为教学管理信息系统

package com.wygl.qtyy.service;

import java.sql.Types;
import java.util.List;

import net.sf.hibernate.HibernateException;

import com.wygl.page.HQuery;
import com.wygl.page.Paras;
import com.wygl.page.ParasList;
import com.wygl.qtyy.condition.GdzcCondition;
import com.wygl.qtyy.domain.Gdzc;
import com.wygl.service.AbstractService;
/**
 * 固定资产接口实现
 * @author qxb
 *
 */
public class GdzcServiceImpl  extends AbstractService implements GdzcService {
    private GdzcCondition condition;//基类条件
    
    /**设置condition*/
	public void setCondition(GdzcCondition condition) {
		this.condition = (GdzcCondition) condition;
	}
	/**获得condition*/
	public GdzcCondition getCondition(){
		return condition;
	}
	/** 构建hquery*/
	public void creatHquery() throws Exception{		
		hquery = new HQuery();
		hquery.setQueryString(condition.getHqlString());
		//实例化参数，本例为两个参数		
		
		Paras paras1=new Paras();
		if(condition.getZcName()==null||condition.getZcName().equals("")){
			condition.setZcName("%");
		}
		paras1.setPName("%"+condition.getZcName()+"%");
		paras1.setTypeNo(Types.VARCHAR); 	
		
		Paras paras3=new Paras();
		paras3.setPName(condition.getDeptId()+"%");
		paras3.setTypeNo(Types.VARCHAR); 
				
		ParasList paraslist=new ParasList();
		paraslist.add(paras1);
		paraslist.add(paras3);
		hquery.setParaslist(paraslist);		
		this.setPageInfo();	//设置分页信息
	}
	/**设置页面信息	 */
	public void setPageInfo() throws HibernateException {
		//查询记录总数
		int pagecount = 0;
		pagecount = dbDao.count(hquery);
		condition.setRowCounts(pagecount);
		condition.setCrossPages(Math.round(Math.ceil(pagecount*1.0/condition.getRowsPerpage())));  
		if(condition.getPageNo() > condition.getCrossPages()){
		    condition.setPageNo(condition.getCrossPages());
		}
		//设置当前行
		long currentRow = (condition.getPageNo() - 1)*condition.getRowsPerpage();
		if(currentRow < 0){
			currentRow = 0;
			condition.setPageNo(1);
		}
		condition.setCurrentRow(currentRow + 1);	
		
		//调用查寻方法得到第一页结果
		hquery.setPageStartNo(condition.getPageNo());
		//hquery.setOrderby(" order by dj.kdrq  desc" );
	}	
	/**查询信息*/
	public List queryList() throws Exception{
   		return dbDao.queryObjectsToPages(hquery);
   	} 	
   	/**查询库房登记主表信息*/
	public Object queryById(Class obj,String obj_id) throws Exception {
		try {
			return dbDao.queryObjectById(obj,obj_id);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
   	}  
	
	/**保存库房登记主表对象*/
	public String save(Object obj) throws Exception  {		
		Gdzc gdzc= (Gdzc)obj; 	
		try{
			if (checkRepeat(gdzc) <= 0 ) {//校验录入内容是否重复
			    if(gdzc.getGdzcId()==null ||gdzc.getGdzcId().equals("")){	
					dbDao.addObject(gdzc);
				}else{
					dbDao.updateObject(gdzc);
				}
			}else{
    			return "false";
    		}
	    }catch (HibernateException e) {
	        return "error";
	    }
	    return "true";
   	}

   	/**校验输入重复*/
    public int checkRepeat(Object obj) throws Exception {	
    	Gdzc gdzc= (Gdzc)obj; 
		String str = "from Gdzc as gdzc where gdzc.zcName ='"+gdzc.getZcName()+"'  and   gdzc.deptId='"+gdzc.getDeptId()+"'";
		if(gdzc.getGdzcId()==null ||gdzc.getGdzcId().equals("")){
	    	return dbDao.queryObjectsCount(str);
		}else{
			return dbDao.queryObjectsCount(str+" and gdzc.gdzcId <> '"+gdzc.getGdzcId()+"'");    	
	    } 	
    } 
    
   	/**删除登记主表信息*/
	public String delete(List list) throws Exception{
		try {
			if(list==null||list.size()==0)	return "false";	
			for(int i=0;i<list.size();i++){
				String zj = (String)list.get(i);
				if(zj==null||zj.equals(""))continue;
				Gdzc dj= (Gdzc)dbDao.queryObjectById(Gdzc.class,zj);	
				dbDao.deleteObject(dj);
			}
			return "true";
		} catch (Exception e) {
			e.printStackTrace();
			return "error";		
		}
	}

		
}