tf_purview.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.rpt;

import java.util.Date;
import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.data.ObjectEntity;
import com.doone.util.FileLogger;

public class TF_purview extends ObjectEntity {
	private static DataTable _entityStruct = null;

	private static String _fieldNames = null;

	private static String _tableName = "TF_PURVIEW";
	
	private TF_purview TF_purviews[] = null;
	
	private DacClient dataAccess = null;
	
	
	protected DataTable get_entityStruct() {
		return _entityStruct;
	}

	protected void set_entityStruct(DataTable struct) {
		_entityStruct = struct;
	}

	protected String get_fieldNames() {
		return _fieldNames;
	}

	protected void set_fieldNames(String names) {
		_fieldNames = names;

	}

	protected String get_tableName() {
		return _tableName;
	}

	protected void set_tableName(String name) {
		_tableName = name;

	}

	protected TF_purview() {
		super();
		dataAccess = new DacClient();
	}

	public TF_purview(DacClient db, long objId) {
		super(db, objId);
		dataAccess = db;
	}

	public TF_purview(DacClient db) {
		super(db);
		
		dataAccess = db;
		try {
			this.setPurviewid(db.getSequence("seq_purviewid"));
			this.setUppurviewid(0);
			this.setCreatetime(new Date());
			this.setOrderno(1);
			this.setState("E");
			this.setUninherit("N");
			this.setCreatetime(new Date());
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex);

			throw new RuntimeException(ex);
		}
	}

	public TF_purview(DataRow dr) {
		super(dr);
		dataAccess = new DacClient();
	}

	public DataRow getDataRow() {
		return entityRow;
	}
	
	public static TF_Reports getInstanceByBoardId(DacClient db, long lBoardId) {
		TF_Reports result = null;
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("select ");
			if (_fieldNames != null) {
				sql.append(_fieldNames);
			}
			else {
				sql.append("*");
			}
			sql.append(" from ");
			sql.append(_tableName);
			sql.append(" where BOARD_ID = ?");


			Object ap[] = new Object[1];
			ap[0] = new Long(lBoardId);
			
			DataTable dt = db.executeQuery(sql.toString(), ap);
			if ( dt != null && dt.getRows().getCount() > 0 ) {
				result = new TF_Reports(dt.getRow(0));
			}
		} catch (Exception e) {
			FileLogger.getLogger().warn(e.getMessage(), e);
		}
		
		return result;
	}
	
	public TF_purview[] getTF_purviews() {
        if (TF_purviews == null) TF_purviews = TF_purview.getTF_purviews(this);

        return TF_purviews;
    }
	
	public static TF_purview[] getTF_purviews(TF_purview tf_purview){
        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select ");
            if (_fieldNames != null)
                sql.append(_fieldNames);
            else
                sql.append("*");
            sql.append("from TF_purview where uppurviewid=?");

            Object aInput[] = new Object[1];
            aInput[0] = String.valueOf(tf_purview.getPurviewid());
            DataTable dt = tf_purview.getDBClient().executeQuery(sql.toString(), aInput);
            if (dt == null) throw new Exception("找不到对应的环节的父接点信息。");

            TF_purview tf_purviews[] = new TF_purview[dt.getRows().getCount()];
            for (int i = 0; i < dt.getRows().getCount(); i++) {
            	tf_purviews[i] = new TF_purview(dt.getRow(i));
            }

            return tf_purviews;
        } catch (Exception ex) {
            FileLogger.getLogger().info("读取环节配置息出错：" + ex.getMessage(), ex);
        }
        return null;
    }
	
	public DacClient getDBClient() {
        return dataAccess;
    }
	
	public static TF_Reports getInstanceByBoardId(long lBoardId) {
		return getInstanceByBoardId(new DacClient(), lBoardId);
	}

	private void setPurviewid(long lPurviewid) {
		entityRow.setValue("PURVIEWID", new Long(lPurviewid));
	}

	public long getPurviewid() {
		return entityRow.getLong("PURVIEWID");
	}

	public void setUppurviewid(long lUppurviewid) {
		entityRow.setValue("UPPURVIEWID", new Long(lUppurviewid));
	}
	
	public long getUppurviewid() {
		return entityRow.getLong("UPPURVIEWID");
	}
	
	public void setPurviewcode(String sPurviewcode) {
		entityRow.setValue("PURVIEWCODE", sPurviewcode);
	}
	
	public String getPurviewcode() {
		return entityRow.getString("PURVIEWCODE");
	}
	
	public void setName(String sName) {
		entityRow.setValue("NAME", sName);
	}
	
	public String getName() {
		return entityRow.getString("NAME");
	}
    
	
	public void setCreatetime(Date sCreatetime) {
		entityRow.setValue("CREATETIME", sCreatetime);
	}
	
	public String getCreatetime() {
		return entityRow.getString("CREATETIME");
	}
	
	public void setDescribe(String sDescribe) {
		entityRow.setValue("DESCRIBE", sDescribe);
	}
	
	public String getDescribe() {
		return entityRow.getString("DESCRIBE");
	}

	public void setPurviewmode(String sPurviewmode) {
		entityRow.setValue("PURVIEWMODE", sPurviewmode);
	}
	
	public String getPurviewmode() {
		return entityRow.getString("PURVIEWMODE");
	}
	
	public void setPurviewoper(String sPurviewoper) {
		entityRow.setValue("PURVIEWOPER", sPurviewoper);
	}
	
	public String getPurviewoper() {
		return entityRow.getString("PURVIEWOPER");
	}
	
	public void setOrderno(long lOrderno) {
		entityRow.setValue("ORDERNO", new Long(lOrderno));
	}
	
	public long getOrderno() {
		return entityRow.getLong("ORDERNO");
	}
	
	public void setState(String sState) {
		entityRow.setValue("STATE", sState);
	}
	
	public String getState() {
		return entityRow.getString("STATE");
	}
	
	public void setStatemodifytime(Date sStatemodifytime) {
		entityRow.setValue("STATEMODIFYTIME", sStatemodifytime);
	}
	
	public String getStatemodifytime() {
		return entityRow.getString("STATEMODIFYTIME");
	}
	
	public void setUninherit(String sUninherit) {
		entityRow.setValue("UNINHERIT", sUninherit);
	}
	
	public String getUninherit() {
		return entityRow.getString("UNINHERIT");
	}

}