package fr.zng.xxzx.common.dao.impl;

import java.util.List;

import fr.zng.xxzx.common.dao.EquipDao;
import fr.zng.xxzx.common.dao.base.BaseDao;
import fr.zng.xxzx.common.entity.EquipEntity;
import fr.zng.xxzx.util.StringUtil;

public class EquipDaoImpl extends BaseDao implements EquipDao{

	public List<EquipEntity> search(EquipEntity en) {
		List<EquipEntity> result = null;
		try {
			makeSession();
			result = session.selectList("Equip.search", en);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
        return result;
	}

	public int getCount(EquipEntity en) {
		Integer cnt = 0;
		try {
			makeSession();
			cnt = session.selectOne("Equip.getCount", en);
	        if (StringUtil.isEmpty(cnt)) {
	        	cnt = 0;
	        }
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
        return cnt;
	}

	public EquipEntity getDetailByPk(String pk) {
		List<EquipEntity> result = null;
		try {
			makeSession();
			result = session.selectList("Equip.getDetailByPk", pk);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		if(result.size()>0){
			return result.get(0);
		}else{
			return new EquipEntity();
		}
	}

	@Override
	public List<EquipEntity> searchByno(EquipEntity en) {
		List<EquipEntity> result = null;
		try {
			makeSession();
			result = session.selectList("Equip.searchByno", en);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
        return result;
	}

	@Override
	public EquipEntity getDetailByImei(String pk) {
		List<EquipEntity> result = null;
		try {
			makeSession();
			result = session.selectList("Equip.getDetailByImei", pk);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		if(result.size()>0){
			return result.get(0);
		}else{
			return new EquipEntity();
		}
	}

}