menutreebean.java

来自「电信的网厅的整站代码」· Java 代码 · 共 293 行

package com.doone.fj1w.fjmgr.config;


import com.doone.data.DacClient;
import com.doone.data.DataTable;
import com.doone.fj1w.fj1w.login.app.CommitDate;
import com.doone.util.FileLogger;

/**
 *
 * <p>Title:取出树形菜单 </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author wull
 * @version 1.0
 */
public class MenuTreeBean {

    private static String _tableName = "TD_Tree";

    private static String _fieldNames = null;
    
    static final String OPOENT_1 = "打开";
    static final String OPOENT_0 = "关闭";
    static final String STATE_E = "可用";
    static final String STATE_D = "禁用";
    private Integer treeid = null;
    private Integer pid = null;
    private String name = "";
    private String url = "";
    private String title = "";
    private String target = "";
    private String icon = "";
    private String iconOpen = "";
    private String open = "";
    private String citycode = "";
    private String menucode = "";
    private String state = "";
    private String explain = "";
    private String newtime;

    public MenuTreeBean() {
    }
    /**
     *
     * @param cityCode
     * @param menuCode
     * @return
     */
    public static DataTable getTreeList(String cityCode, String menuCode) {
        try {
        	DacClient db = new DacClient();
        	Object[] aParam = null;
            StringBuffer sql = new StringBuffer();
            sql.append("select ");
            if (_fieldNames == null)
                sql.append("*");
            else
                sql.append(_fieldNames);
            sql.append(" from ");
            sql.append(_tableName);
            sql.append(" where ");
            if(cityCode==null || cityCode.equals("")){
            	sql.append("menucode = ?");
            	sql.append(" order by SEQNUMBER");
            	aParam = new Object[1];
                aParam[0] = menuCode;
    		}
    		else{
    			sql.append(" citycode = ?");
    			sql.append(" and menucode = ?");
    			sql.append(" order by SEQNUMBER");
    			aParam = new Object[2];
    			aParam[0] = cityCode;
    			aParam[1] = menuCode;
    		}
            return db.executeQuery(sql.toString(), aParam);
        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex);
            throw new RuntimeException(ex);
        }
    }
    /**张怡 
     * 
     * @param sTreeId
     * @return
     */
    public static DataTable getTreeListByTreeId(String sTreeId) {
        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select ");
            if (_fieldNames == null)
                sql.append("*");
            else
                sql.append(_fieldNames);
            sql.append(" from ");
            sql.append(_tableName);
            sql.append(" where ");
            sql.append(" TreeId = "+sTreeId);
            DacClient db = new DacClient();
            return db.executeQuery(sql.toString());
        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex);
            throw new RuntimeException(ex);
        }
    }
    /**
     * 
     * @param cityCode
     * @return
     */
    public static DataTable getTreeRootList(String cityCode) {
    	try {
    		DacClient db = null;
    		StringBuffer sql = new StringBuffer();
    		sql.append("select ");
    		if (_fieldNames == null)
    			sql.append("*");
    		else
    			sql.append(_fieldNames);
    		sql.append(" from ");
    		sql.append(_tableName);
    		sql.append(" where ");
    		if(cityCode==null || cityCode.equals("")){
    			sql.append("pid = '-1'");
    			db = new DacClient();
    			return db.executeQuery(sql.toString());
    		}
    		else{
    			sql.append(" citycode = ?");
    			sql.append(" and pid = '-1'");
    			Object[] aParam = new Object[1];
    			aParam[0] = cityCode;
    			db = new DacClient();
    			return db.executeQuery(sql.toString(), aParam);
    		}  
    	} catch (Exception ex) {
    		FileLogger.getLogger().warn(ex);
    		
    		throw new RuntimeException(ex);
    	}
    }
    /**
     * 
     * @param sTreeId
     */
    public boolean UpdateTreeByTreeId(String sTreeId) {
    	boolean ok = true;
        try {
            StringBuffer sql = new StringBuffer();
            CommitDate cd = CommitDate.getInstance();
            sql.append("update ");
            sql.append("Td_Tree ");
            sql.append("set ");
            sql.append("Opent=?,");
            sql.append("State=?");
            sql.append(" where TreeId="+sTreeId+"");
            Object[] aParam = new Object[2];
            aParam[0] = open;
            aParam[1] = state;
            cd.commitUpdateDate(sql.toString(),aParam);
          }
          catch (Exception ex) {
        	  ok = false;
          	  FileLogger.getLogger().warn(ex);
              ex.printStackTrace();
              throw new RuntimeException(ex);
          }
          
          return ok;
    }
    

    public Integer getTreeid() {
        return this.treeid;
    }

    public Integer getPid() {
        return this.pid;
    }

    public String getName() {
        return this.name;
    }

    public String getUrl() {
        return this.url;
    }

    public String getTitle() {
        return this.title;
    }

    public String getTarget() {
        return this.target;
    }

    public String getIcon() {
        return this.icon;
    }

    public String getIconOpen() {
        return this.iconOpen;
    }

    public String getOpen() {
        return this.open;
    }

    public String getCitycode() {
        return this.citycode;
    }

    public String getMenucode() {
        return this.menucode;
    }

    public String getState() {
        return this.state;
    }

    public String getExplain() {
        return this.explain;
    }

    public String getNewtime() {
        return newtime;
    }

    public void setTreeid(Integer id) {
        this.treeid = id;
    }

    public void setPid(Integer pid) {
        this.pid = pid;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setUrl(String url) {
        this.url = url;
    }

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

    public void setTarget(String target) {
        this.target = target;
    }

    public void setIcon(String icon) {
        this.icon = icon;
    }

    public void setIconOpen(String iconOpen) {
        this.iconOpen = iconOpen;
    }

    public void setOpen(String open) {
        this.open = open;
    }

    public void setCitycode(String citycode) {
        this.citycode = citycode;
    }

    public void setMenucode(String menucode) {
        this.menucode = menucode;
    }

    public void setState(String state) {
        this.state = state;
    }

    public void setExplain(String explain) {
        this.explain = explain;
    }

    public void setNewtime(String newtime) {
        this.newtime = newtime;
    }

}