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

import java.util.List;

import fr.zng.xxzx.common.dao.UnoDao;
import fr.zng.xxzx.common.dao.base.BaseDao;
import fr.zng.xxzx.common.entity.UnoEntity;
import fr.zng.xxzx.common.entity.UserEntity;
import fr.zng.xxzx.util.StringUtil;

/**
 * 小区用户
 */
public class UnoDaoImpl extends BaseDao implements UnoDao{

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

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

	public UnoEntity getVillageUserCinfo(String pk) {
		List<UnoEntity> result = null;
		try {
			makeSession();
			System.out.println("实际用户："+pk);
			if(pk.startsWith("00")){
				result = session.selectList("Uno.getVillageUserCinfo", pk);
			}else{
				result = session.selectList("Uno.getVillageUserCinfo2", pk);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		if(result.size()>0){
			System.out.println("result.size()"+result.get(0));
			return result.get(0);
		}else{
			return null;
		}
	}
	@Override
	public UnoEntity getByUserUid(String userUid) {
		UnoEntity result = null;
		try {
			makeSession();
			result = session.selectOne("Uno.getByUserUid", userUid);
		} catch (Exception e) {
			session.rollback();
			e.printStackTrace();
		} finally {
			close();
		}
		return result;
	}
	
	public UnoEntity getVillageUserCinfoByUno(String pk) {
		List<UnoEntity> result = null;
		try {
			makeSession();
			System.out.println("实际用户："+pk);
			if(pk.startsWith("00")){
				result = session.selectList("Uno.getVillageUserCinfoByUno2", pk);
			}else{
				result = session.selectList("Uno.getVillageUserCinfoByUno", pk);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close();
		}
		if(result.size()>0){
			System.out.println("result.size()"+result.get(0));
			return result.get(0);
		}else{
			return null;
		}
	}
}