package com.yhcms.artclass.dao;

import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;

import com.yhcms.artclass.bean.ArtClass;
import com.yhcms.artclass.itface.ArtClassDao;
import com.yhcms.db.DBConnException;
import com.yhcms.db.DBConnect;

/**
 * <p>Title:系統(tǒng)文章欄目的相關(guān)操作</p>
 * <li>文章欄目與數(shù)據(jù)庫(kù)相關(guān)的各項(xiàng)操作</li>
 * <b>CopyRight: yyhweb[由由華網(wǎng)]</b>
 * @author stephen
 * @version YH-2.0
 */
public class ArtClassDaoIm implements ArtClassDao {
	
	private static Logger yhlog = Logger.getLogger(ArtClassDaoIm.class.getName());
	
	private DBConnect dbconn = null;
	
	private static ArtClassDaoIm artClassDao= new ArtClassDaoIm();
	
	/**
	 * @return 取得一個(gè)系統(tǒng)欄目操作對(duì)象
	 */
	public static ArtClassDaoIm getInstance(){
		return artClassDao;
	}
	
	public boolean addOneClass(ArtClass artClass) throws DBConnException{
		int i = 0;
		// 取得系統(tǒng)欄目最大Id+1 作為新欄目的Id
		int maxid = getClassMaxId()+1;
		ArtClass curClass = artClass;
		String sql = "insert into artclass(id,parentid,name,sort,isclass,url,about) values ('"
					+maxid+"','"+curClass.getParentid()+"','"+curClass.getName()+"','"
					+curClass.getSort()+"','"+curClass.getIsclass()+"','"+curClass.getUrl()+"','"
					+curClass.getAbout()+"')";
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When add a class,throw an Exception!");
		}finally{
			dbconn.close();
		}
		if(i>0){
			yhlog.info("Add a class successfully,the class id is:"+maxid+".");
			return true;
		}else{
			yhlog.info("Add a class unsuccessfully!");
			return false;
		}
		
	}

	public boolean delOneClass(int id) throws DBConnException {
		int i = 0;
		int j = 0;
		String sql = "delete from artclass where id="+id;
		String sql2 = "delete from article where bigclassid="+id;
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When delete a class,throw an Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>0){	   // 如果刪除了某一個(gè)欄目,其所有的文章全部刪除!
			try{
				dbconn = new DBConnect(sql2);
				j = dbconn.executeUpdate();
			}catch(Exception e){
				yhlog.warn("After deleted a class,delete all of its articles,throw an Exception!");
			}finally{
				dbconn.close();
			}
			
			if(j>=0){	//刪除該欄目的所有文章(有些大類無文章)
				yhlog.info("Delete all a class's articles successfully,the class id is:"+id+".");
				return true;
			}else{
				yhlog.info("Delete all a class's articles unsuccessfully,the class id is:"+id+".");
				return false;
			}
		}else{
			yhlog.info("Delete a class unsuccessfully,the class id is:"+id+".");
			return false;
		}
		
	}

	public boolean updateClass(ArtClass artClass) throws DBConnException {
		int i = 0;
		int j = 0;
		int id = artClass.getId();
		String sql = "update artclass set parentid="+artClass.getParentid()+",name='"+artClass.getName()+
					"',isclass="+artClass.getIsclass()+",url='"+artClass.getUrl()+"',about='"+
					artClass.getAbout()+"' where id="+id;
		String sql2 = "update article set bigclass='"+artClass.getName()+"' where bigclassid="+id;
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When update a class,throw an Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>0){
			try{
				dbconn = new DBConnect(sql2);
				j = dbconn.executeUpdate();
			}catch(Exception e){
				yhlog.warn("When update all a class's article,throw an Exception!The class id is:"+id+".");
			}finally{
				dbconn.close();
			}
			if(j>=0){
				yhlog.info("Update a class successfully,the class id is:"+id+".");
				return true;
			}else{
				yhlog.warn("Update all a class's articles unsuccessfully,the class id is:"+id+".");
				return false;
			}
		}else{
			yhlog.info("Update a class unsuccessfully,the class id is:"+id+".");
			return false;
		}
	}
	
	public ArtClass getOneClass(int id) throws DBConnException {
		ArtClass curClass = null;
		String sql = "select a.parentid,a.name,a.sort,a.isclass,a.url,a.about from artclass as a where id="+id;
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			if(dbconn.next()){
				curClass = new ArtClass();
				curClass.setId(id);
				curClass.setParentid(dbconn.getInt(1));
				curClass.setName(dbconn.getString(2));
				curClass.setSort(dbconn.getInt(3));
				curClass.setIsclass(dbconn.getInt(4));
				curClass.setUrl(dbconn.getString(5));
				curClass.setAbout(dbconn.getString(6));
			}
		}catch(Exception e){
			yhlog.warn("When get a class,throw an Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		return curClass;
	}

	public int getOneClass(String classname) throws DBConnException {
		int cId = 0;
		String sql = "select id from artclass where name='"+classname+"'";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			if(dbconn.next()){
				cId = dbconn.getInt(1);
			}
		}catch(Exception e){
			yhlog.warn("When check a class whether exist,throw an Exception!The class name is:"+classname+".");
		}finally{
			dbconn.close();
		}
		return cId;
	}
	
	public String getNameById(int id) throws DBConnException {
		String name = "";
		String sql = "select a.name from artclass as a where id="+id;
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			if(dbconn.next()){
				name = dbconn.getString(1);
			}
		}catch(Exception e){
			yhlog.warn("When get a class's name,throw a Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		return name;
	}
	
	public List getOneCsAllSon(int id) throws DBConnException {
		ArrayList classlist = new ArrayList();
		ArtClass oneClass = null;
		String sql = "select a.id,a.name,a.sort,a.isclass,a.url,a.about from artclass as a where parentid="+id;
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				oneClass = new ArtClass();
				oneClass.setParentid(id);
				oneClass.setId(dbconn.getInt(1));
				oneClass.setName(dbconn.getString(2));
				oneClass.setSort(dbconn.getInt(3));
				oneClass.setIsclass(dbconn.getInt(4));
				oneClass.setUrl(dbconn.getString(5));
				oneClass.setAbout(dbconn.getString(6));
				classlist.add(oneClass);
			}
		}catch(Exception e){
			yhlog.warn("When get all a class's son class,throw an Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		return classlist;
	}

	public List getAllClass() throws DBConnException {
		ArrayList classlist = new ArrayList();
		ArtClass oneClass = null;
		String sql = "select a.id,a.parentid,a.name,a.sort,a.isclass,a.url,a.about from artclass as a";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				oneClass = new ArtClass();
				oneClass.setId(dbconn.getInt(1));
				oneClass.setParentid(dbconn.getInt(2));
				oneClass.setName(dbconn.getString(3));
				oneClass.setSort(dbconn.getInt(4));
				oneClass.setIsclass(dbconn.getInt(5));
				oneClass.setUrl(dbconn.getString(6));
				oneClass.setAbout(dbconn.getString(7));
				classlist.add(oneClass);
			}
		}catch(Exception e){
			yhlog.warn("When get all class of system,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return classlist;
	}
	
	public List getAllParClass() throws DBConnException {
		ArrayList classlist = new ArrayList();
		ArtClass oneClass = null;
		String sql = "select a.id,a.name,a.sort,a.isclass,a.url,a.about from artclass as a where a.parentid=0 order by a.sort";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				oneClass = new ArtClass();
				oneClass.setParentid(0);
				oneClass.setId(dbconn.getInt(1));
				oneClass.setName(dbconn.getString(2));
				oneClass.setSort(dbconn.getInt(3));
				oneClass.setIsclass(dbconn.getInt(4));
				oneClass.setUrl(dbconn.getString(5));
				oneClass.setAbout(dbconn.getString(6));
				classlist.add(oneClass);
			}
		}catch(Exception e){
			yhlog.warn("When get all parent class of system,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return classlist;
	}
	
	public List getAllInClass() throws DBConnException {
		ArrayList classlist = new ArrayList();
		ArtClass oneClass = null;
		String sql = "select a.id,a.name from artclass as a where a.parentid=0 and a.isclass=1 order by a.sort";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			while(dbconn.next()){
				oneClass = new ArtClass();
				oneClass.setParentid(0);
				oneClass.setId(dbconn.getInt(1));
				oneClass.setName(dbconn.getString(2));
				classlist.add(oneClass);
			}
		}catch(Exception e){
			yhlog.warn("When get all inner parent class of system,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return classlist;
	}

	public int getClassMaxId() throws DBConnException {
		int maxId = 0;
		String sql = "select max(id) from artclass";
		try{
			dbconn = new DBConnect(sql);
			dbconn.executeQuery();
			if(dbconn.next()){
				maxId = dbconn.getInt(1);
			}
		}catch(Exception e){
			yhlog.warn("When get the max id class,throw an Exception!");
		}finally{
			dbconn.close();
		}
		return maxId;
	}

	public boolean updateClassSort(int id, int sort) throws DBConnException {
		int i = 0;
		String sql = "update artclass set sort="+sort+" where id="+id;
		try{
			dbconn = new DBConnect(sql);
			i = dbconn.executeUpdate();
		}catch(Exception e){
			yhlog.warn("When update a class's sort,throw an Exception!The class id is:"+id+".");
		}finally{
			dbconn.close();
		}
		if(i>=0){
			yhlog.info("Update a class's sort successfully,the class id is:"+id+".");
			return true;
		}else{
			yhlog.warn("Update a class's sort unsuccessfully,the class id is:"+id+".");
			return false;
		}
	}




}