package com.david.dao;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.DataAccessResourceFailureException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.david.bo.Category;
import com.david.bo.File;
import com.david.bo.Userinfo;
import com.david.util.IPageBean;
import com.david.util.IPageBeanSH;

public class FileDao extends HibernateDaoSupport implements IFileDao {

	private IPageBeanSH pageBeanSH;
	
	public boolean save(File file) {
		// TODO Auto-generated method stub
		try{
			this.getHibernateTemplate().save(file);
			return true;
		}catch(DataAccessException e){
			e.printStackTrace();
			return false;
		}
		
	}

	public List<File> getFileList(int start, Category category) {
		// TODO Auto-generated method stub
		String hql="from File as file";// where file.category=?";
		try{
			if(category==null){
				return (List<File>) pageBeanSH.doInHibernate(this.getSession());
			}else{
				hql+=" where file.category=? Order by file.id desc";
				Category[] categories={category};		
				pageBeanSH.setHql(hql);
				pageBeanSH.setStart(start);
				pageBeanSH.setArrValues(categories);	
				return (List<File>) pageBeanSH.doInHibernate(this.getSession());
			}
		} catch (DataAccessResourceFailureException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (IllegalStateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}

	public void setPageBeanSH(IPageBeanSH pageBeanSH) {
		// TODO Auto-generated method stub
		this.pageBeanSH=pageBeanSH;
	}

	public List<File> getAllMyFileList(Category category) {
		// TODO Auto-generated method stub
		if(category==null){
			return this.getHibernateTemplate().find("from File as file Order by file.id desc");
		}else{
			return this.getHibernateTemplate().find("from File as file where file.category=? Order by file.id desc", category);
		}
	}

	public boolean deleteFileById(File file) {
		// TODO Auto-generated method stub
		try{
			this.getHibernateTemplate().delete(file);
			return true;
		}catch(DataAccessException e){
			return false;
		}
	}

	public File getFileById(int id) {
		// TODO Auto-generated method stub
		List<File> list=this.getHibernateTemplate().find("from File as file where file.id=?", id);
		if(list.size()!=1){
			return null;
		}else{
			return list.get(0);
		}
	}
}