skserviceimple.java

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

package com.xm.cjgl.skgl.service;

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

import com.wygl.page.HQuery;
import com.wygl.page.Paras;
import com.wygl.page.ParasList;
import com.wygl.service.AbstractService;
import com.xm.cjgl.skgl.condition.SkCondition;
import com.xm.cjgl.skgl.domain.SkbEntity;

public class SkServiceImple extends AbstractService implements SkService {

	private SkCondition condition ;
	public int checkRepeat(Object obj) throws Exception {
		return 0;
	}

	public void creatHquery() throws Exception {
		super.hquery = new HQuery();
		hquery.setQueryString(condition.getHqlString());
		//实例化参数
		Paras paras1=new Paras();
		paras1.setPName("%"+condition.getKCMC()+"%");
		paras1.setTypeNo(Types.VARCHAR);
		Paras paras2=new Paras();
		paras2.setPName("%"+condition.getSKBJ()+"%");
		paras2.setTypeNo(Types.VARCHAR);
		Paras paras3=new Paras();
		paras3.setPName("%"+condition.getSKR()+"%");
		paras3.setTypeNo(Types.VARCHAR);
		ParasList paraslist=new ParasList();
		paraslist.add(paras1);
		paraslist.add(paras2);
		paraslist.add(paras3);
		hquery.setParaslist(paraslist);
		this.setPageInfo();
	}

	public void delete(String id) throws Exception {

	}

	public Object queryById(String id) throws Exception {
		return dbDao.queryObjectById(SkbEntity.class, id);
	}

	public List queryList() throws Exception {
		return dbDao.queryObjectsToPages(hquery);
	}

	public String save(Object obj) throws Exception {
		return dbDao.updateObjectBackPK(obj);
	}

	public void saveObject(Object obj) throws Exception {
		dbDao.addObject(obj);
	}

	public void setPageInfo() throws Exception {
		 //查询记录总数
		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 st.SK_ID asc" );
	}

	public SkCondition getCondition() {
		return condition;
	}
	public void setCondition(SkCondition condition) {
		this.condition = condition;
	}

	//选择授课人
	public List selectSKR() throws Exception {
		return dbDao.queryObjects("from Employee st where st.zw ='普通教师' or st.zw='教研室主任'");
	}


	public String delete(List list) {
		try {
			if(list==null||list.size()==0)	return "false";			
			dbDao.deleteObjects(SkbEntity.class,list);
			return "true";
		} catch (Exception e) {
			e.printStackTrace();
			return "error";		
		}
	}

	public void update(Object obj) throws Exception {
		dbDao.updateObject(obj);
	}
	

}