package com.javaniu.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.javaniu.dao.UserDownloadDao;
import com.javaniu.module.UserDownload;

@Transactional(readOnly = false, propagation = Propagation.SUPPORTS)
@Repository
public class UserDownloadDaoImpl extends BaseDaoImpl implements UserDownloadDao {

	@Override
	public void save(UserDownload userDownload) {
		getSession().save(userDownload);
	}

	@Override
	public void delete(Long id) {
		UserDownload userDownload = findById(id);
		getSession().delete(userDownload);
	}

	@Override
	public void delete(UserDownload userDownload) {
		getSession().delete(userDownload);
	}

	@Override
	public void update(UserDownload userDownload) {
		getSession().update(userDownload);
	}

	@Override
	public UserDownload findById(Long id) {
		return (UserDownload) getSession().get(UserDownload.class, id);
	}

	@Override
	public List<UserDownload> loadAll(int p, int ps) {
		String hql = "from UserDownload order by id desc";
		Query query = getSession().createQuery(hql);
		query.setFirstResult((p - 1) * ps);
		query.setMaxResults(ps);
		List<UserDownload> list = query.list();
		return list;
	}

	@Override
	public int countAll() {
		String hql = "select count(*) from UserDownload";
		Query query = getSession().createQuery(hql);
		return ((Number) query.uniqueResult()).intValue();
	}

	@Override
	public UserDownload findByUIdAndFId(Long uid, Long fid) {
		String hql = "from UserDownload where user.id=" + uid + " and file.id="
				+ fid;
		Query query = getSession().createQuery(hql);
		query.setMaxResults(1);
		List<UserDownload> list = query.list();
		if (list.size() > 0) {
			return list.get(0);
		}
		return null;
	}
}