package com.lovo.bo;

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

import com.lovo.factory.BOFactory;
import com.lovo.factory.DAOFactory;
import com.lovo.po.BlockPO;
import com.lovo.po.PublishPO;
import com.lovo.po.UserPO;
import com.lovo.util.Page;

public class PublishBOImpl implements PublishBO{

	
	
	public boolean addPub(PublishPO publishPO) {
		try {
			DAOFactory.getPublishDAOInstance().insert(publishPO);
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean deletePub(int id) {
		try {
			DAOFactory.getPublishDAOInstance().delete(id);
			System.out.println("?????");
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
		return true;
		
	}

	public PublishPO queryById(int id) {
		PublishPO po = null;
		try {
			po = DAOFactory.getPublishDAOInstance().queryById(id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return po;
	}
	
	public List<PublishPO> queryPubByUserid(int userid) {
		List<PublishPO> list=null;
		try {
			list = DAOFactory.getPublishDAOInstance().queryByUserId(userid);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}


	public List<PublishPO> queryPubByBlockid(int blockid, Page page) {
		List<PublishPO> list=null;
		try {
			list = DAOFactory.getPublishDAOInstance().queryByBlockId(blockid, page);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	
	public List<PublishPO> queryByPublishDate() {
		List<PublishPO> list=null;
		try {
			list = DAOFactory.getPublishDAOInstance().queryByPublishDate();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	public boolean digest(PublishPO po) {
		try {
			po.setDigest(1);
			DAOFactory.getPublishDAOInstance().updateDigest(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean finish(PublishPO po) {
		try {
			po.setFinish(1);
			DAOFactory.getPublishDAOInstance().updateFinish(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	

	public boolean recommend(PublishPO po) {
		try {
			po.setRecommend(1);
			DAOFactory.getPublishDAOInstance().updateRecmmend(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean stick(PublishPO po) {
		try {
			po.setStick(1);
			DAOFactory.getPublishDAOInstance().updateStick(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public boolean delDigest(PublishPO po) {
		try {
			po.setDigest(0);
			DAOFactory.getPublishDAOInstance().updateDigest(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean delRecommend(PublishPO po) {
		try {
			po.setRecommend(0);
			DAOFactory.getPublishDAOInstance().updateRecmmend(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean delStick(PublishPO po) {
		try {
			po.setStick(0);
			DAOFactory.getPublishDAOInstance().updateStick(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	

	public int queryPublishMaxRowsInBlock(int id) {
		int maxRows = 0;
		try {
			maxRows = DAOFactory.getPublishDAOInstance().queryPublishMaxRowsInBlock(id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return maxRows;
	}

	public List<PublishPO> queryByContent(String content) throws SQLException {
		return DAOFactory.getPublishDAOInstance().queryByContent(content);
	}

	public List<PublishPO> queryByTitle(String title) throws SQLException {
		return DAOFactory.getPublishDAOInstance().queryByTitle(title);
	}

	public PublishPO queryByDigestdate() throws SQLException {
		return DAOFactory.getPublishDAOInstance().queryByDigestdate();
	}

	public PublishPO queryByRecomendate() throws SQLException {
		return DAOFactory.getPublishDAOInstance().queryByRecomendate();
	}

}