package com.easyjf.bbs.business;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;

import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.IObject;
/**
 * BBS欄目信息
 * @author 蔡世友
 *
 */
public class BBSDir implements IObject {
    // Fields   
    private String cid;
    private String sn;
    private String title;
    private String parentSn;
    private String dirPath;
    private String intro;
    private String tagImg;
    private String manager;
    private String subManager;
    private String vRType;
    private String vRValue;     
    private String inputUser;
    private Date inputTime; 
    private Integer sequence; 
    private Integer status;       
    // Constructors
    public BBSDir()
    {
    	
    }
    public BBSDir(String cid)
    {
    	this.cid=cid;    	
    }    

	public Number messageNum()
	{
		EasyJDB db=EasyJDB.getInstance();
		Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where dirSn='"+this.sn+"' and (parentId is null or (parentId='')) and status>=0");
		return  num;
	}
	public Number replyNum()
	{
		EasyJDB db=EasyJDB.getInstance();
		Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where dirSn='"+this.sn+"' and not(parentId is null or (parentId='')) and status>=0");
		return  num;
	}
	public static BBSDir read(String cid)
	{
		EasyJDB db=EasyJDB.getInstance();
		
		return (BBSDir)db.get(BBSDir.class,cid);
	}
	public static BBSDir readBySN(String sn)
	{
		EasyJDB db=EasyJDB.getInstance();
		Collection paras=new ArrayList();
		paras.add(sn);
		return (BBSDir)db.read(BBSDir.class,"sn=?",paras);
	}
	public boolean save()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.saveOrUpdate(this);
	}
	public boolean del()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.del(this);
	}
	public static List query(String scope)
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.query(BBSDir.class,scope);	
	}
	public BBSDoc lastDoc()
	{
		EasyJDB db=EasyJDB.getInstance();
		return (BBSDoc)db.read(BBSDoc.class,"dirSn='"+this.sn+"' and status>=0 order by inputTime desc");
	}
	public BBSDoc lastTopic()
	{
		EasyJDB db=EasyJDB.getInstance();
		return (BBSDoc)db.read(BBSDoc.class,"dirSn='"+this.sn+"' and status>=0 and  (parentId is null or (parentId='')) order by inputTime desc");
	}
    //實現IObject接口的方法
	public  String getTableName()
    {
    	return "BBSDir";
    }
    public  String getKeyField()
    {
    	return "cid";	
    }
    public String getKeyGenerator()//主鍵產生器
    {
    	return "com.easyjf.dbo.IdGenerator";
    }
    //  Property accessors
	public String getCid() {
		return cid;
	}
	public void setCid(String cid) {
		this.cid = cid;
	}
	public String getDirPath() {
		return dirPath;
	}
	public void setDirPath(String dirPath) {
		this.dirPath = dirPath;
	}
	public Date getInputTime() {
		return inputTime;
	}
	public void setInputTime(Date inputTime) {
		this.inputTime = inputTime;
	}
	public String getInputUser() {
		return inputUser;
	}
	public void setInputUser(String inputUser) {
		this.inputUser = inputUser;
	}
	public String getIntro() {
		return intro;
	}
	public void setIntro(String intro) {
		this.intro = intro;
	}
	public String getManager() {
		return manager;
	}
	public void setManager(String manager) {
		this.manager = manager;
	}
	public String getParentSn() {
		return parentSn;
	}
	public void setParentSn(String parentSn) {
		this.parentSn = parentSn;
	}
	public Integer getSequence() {
		return sequence;
	}
	public void setSequence(Integer sequence) {
		this.sequence = sequence;
	}
	public String getSn() {
		return sn;
	}
	public void setSn(String sn) {
		this.sn = sn;
	}
	public Integer getStatus() {
		return status;
	}
	public void setStatus(Integer status) {
		this.status = status;
	}
	public String getSubManager() {
		return subManager;
	}
	public void setSubManager(String subManager) {
		this.subManager = subManager;
	}
	public String getTagImg() {
		return tagImg;
	}
	public void setTagImg(String tagImg) {
		this.tagImg = tagImg;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public String getVRType() {
		return vRType;
	}
	public void setVRType(String type) {
		vRType = type;
	}
	public String getVRValue() {
		return vRValue;
	}
	public void setVRValue(String value) {
		vRValue = value;
	}
}