SignatureDao.java

package com.norteksoft.bs.signature.dao;

import java.util.List;
import org.springframework.stereotype.Repository;
import com.norteksoft.bs.signature.entity.Signature;
import com.norteksoft.product.orm.Page;
import com.norteksoft.product.orm.hibernate.HibernateDao;
import com.norteksoft.product.util.ContextUtils;


@Repository
public class SignatureDao extends HibernateDao<Signature,Long>{
	
	public Long getCompanyId(){
		return ContextUtils.getCompanyId();
	}
	
	/**
	 * 获得签章实体
	 * @param page
	 */
	public Signature getSignatureById(Long id){
		List<Signature> list = this.find("from Signature s where s.id=? and s.companyId=?", id,getCompanyId());
		if(list.size()>0){
			return list.get(0);
		}else{
			return null;
		}
	}
	
	/**
	 * 获得所有签章
	 * @param page
	 */
	public void getAllSignaturePicture(Page<Signature> page){
		this.searchPageByHql(page, "from Signature s where s.companyId=?", getCompanyId());
	}
	
	/**
	 * 获得所有签章除当前signatureId
	 * @param page
	 */
	public List<Signature> getAllSignatureNoCurrentId(Long signatureId){
		if(signatureId==null){
			return this.find("from Signature s where s.companyId=? ", getCompanyId());
		}else{
			return this.find("from Signature s where s.companyId=? and s.id<>? ", getCompanyId(),signatureId);
		}
	}
	
	public Signature getSignByUserName(String userName) {
		List<Signature> list = this.find("from Signature s where s.userName=? and s.companyId=?", userName,getCompanyId());
		if(list.size()>0){
			return list.get(0);
		}
		return null;
	}
	public Signature getSignByUserId(Long userId) {
		List<Signature> list = this.find("from Signature s where s.userId=? and s.companyId=?", userId,getCompanyId());
		if(list.size()>0){
			return list.get(0);
		}
		return null;
	}
}