package com.newvideo.service.imp;

import java.io.Serializable;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.newvideo.dao.FindClassDao;
import com.newvideo.domain.FindClass;
import com.newvideo.util.Constant;

@Service
public class FindClassService {
	
	@Resource
	private FindClassDao dao;
	
	@Resource
	private FindVideoService findVideoService;
	
	public int getCount() {
		long count = dao.getCount("select count(*) from FindClass");
		return (int) count;
	}

	public List<FindClass> getFindClass(int page) {
		int start =(page -1 )* Constant.pageCount;
		return dao.list("from FindClass where show=1 order by orderBy desc", start, Constant.pageCount, null);
	}

	@Transactional
	public Long save(FindClass findClass) {
		findClass.setCreateTime(System.currentTimeMillis());
		return (Long) dao.save(findClass);
	}
	
	@Transactional
	public void delete(FindClass findClass) {
		findVideoService.deleteByCid(findClass.getId());
		dao.delete(findClass);
	}
	
	@Transactional
	public void update(FindClass findClass) {
		findClass.setCreateTime(System.currentTimeMillis());
		dao.update(findClass);
	}

	public List<FindClass> getFindClassList(String key, int page) {
		int start = (page -1 ) * Constant.pageCount;
		return dao.list("from FindClass where name like ? order by orderBy desc ", start, Constant.pageCount, new Serializable[]{"%"+key+"%"});
	}

	public FindClass getFindClass(long id) {
		FindClass find = dao.find(FindClass.class, id);
		return find;
	}

	public int getCount(String key) {
		return (int) dao.getCount("select count(*) from FindClass where name like ? ", new Serializable[]{"%"+key+"%"});
	}

	public List<FindClass> getAllFindClass() {
		return dao.list("from FindClass");
	}

}