package com.fr.tx.common.dao.impl;

import java.util.List;
import com.fr.tx.common.dao.EquipAdrDao;
import com.fr.tx.common.dao.base.BaseDao;
import com.fr.tx.common.entity.EquipAdrEntity;

public class EquipAdrDaoImpl extends BaseDao implements EquipAdrDao{

	@Override
	public List<EquipAdrEntity> search() {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.search");
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
	}
	@Override
	public int getCount() {
		int ret = 0;
		try {
			makeSession();
			ret = session.selectOne("EquipAdr.getCount");
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
		
	}
	@Override
	public List<EquipAdrEntity> getLimitData(EquipAdrEntity condition) {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.getLimitData",condition);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
		
	}
	@Override
	public List<EquipAdrEntity> getDetailByPk(String pk) {
		
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.getDetailByPk", pk);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
	}
	@Override
	public int insert(EquipAdrEntity en) {
		int ret = 0;
		try {
			makeSession();
			ret = session.insert("EquipAdr.insert", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
		
	}
	@Override
	public int delete(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.delete", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public int updYjStatus(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.updYjStatus", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public int updBjStatus(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.updBjStatus", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public List<EquipAdrEntity> searchByAddr(EquipAdrEntity en) {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.searchByAddr",en);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
	}
	@Override
	public int updData(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.updData", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public int searchYjstatus(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.selectOne("EquipAdr.searchYjstatus", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public List<EquipAdrEntity> searchYjtime(EquipAdrEntity en) {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.searchYjtime",en);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
	}
	
	@Override
	public List<EquipAdrEntity> getListByType(String type) {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.getListByType",type);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
	}
	@Override
	public List<EquipAdrEntity> checkAddr(EquipAdrEntity en) {
		List<EquipAdrEntity> result = null;
		try {
			makeSession();
			result = session.selectList("EquipAdr.checkAddr",en);
			if(result!=null){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			// TODO: handle exception
			session.rollback();
			e.printStackTrace();
		}finally {
			close();
		}
        return result;
		
	}
	@Override
	public int save(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.save", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
	@Override
	public int updateEquipStatus(EquipAdrEntity en) {
		
		int ret = 0;
		try {
			makeSession();
			ret = session.update("EquipAdr.updateEquipStatus", en);
			if(ret>0){
				session.commit();
			}else{
				session.rollback();
			}
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
        return ret;
	}
}