package com.easyjf.asp.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;

public class SystemRegion implements IObject {
private String cid;
private String sn;
private String title;
private String parentSn;
private Integer lev;
private Integer sequence;
private Date inputTime;
private String inputUser;
public static SystemRegion read(String cid)
{
	EasyJDB db=EasyJDB.getInstance();		
	return (SystemRegion)db.get(SystemRegion.class,cid);
}
public static SystemRegion readBySn(String sn)
{
	EasyJDB db=EasyJDB.getInstance();
	Collection paras=new ArrayList();
	paras.add(sn);
	return (SystemRegion)db.read(SystemRegion.class,"sn=?",paras);
}

public static List query(String scope)
{
	EasyJDB db=EasyJDB.getInstance();
	return db.query(SystemRegion.class,scope);	
}
public List children()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.query(SystemRegion.class,"parentSn='"+this.sn+"' order by sequence");	
}
public boolean save()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.add(this);
}
public boolean update()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.update(this);
}
public boolean del()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.del(this);
}

public String getCid() {
	return cid;
}
public void setCid(String cid) {
	this.cid = cid;
}

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 Integer getLev() {
	return lev;
}

public void setLev(Integer lev) {
	this.lev = lev;
}

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 String getTitle() {
	return title;
}

public void setTitle(String title) {
	this.title = title;
}

	public String getTableName() {
		// TODO Auto-generated method stub
		return "SystemRegion";
	}

	public String getKeyField() {
		// TODO Auto-generated method stub
		return "cid";
	}

	public String getKeyGenerator() {
		// TODO Auto-generated method stub
		return  "com.easyjf.dbo.IdGenerator";
	}	
}