package com.ICT.AFC.user.beans;

import com.ICT.AFC.DB.DB;
import java.sql.ResultSet;
import java.util.ArrayList;

/**
 * <p>Title:權限類相關操作 </p>
 * <p>Description:權限類相關操作，包括部門插入、修改、刪除。 </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: 電子所AFC事業部</p>
 * @author 梅曉峰
 * @version 1.0
 */

public class RightOperate {
  public RightOperate() {
  }

  /**
   * 添加新權限信息方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */

  public static boolean AddRight(DB db, Right right) throws
      Exception {
    ResultSet rs;
    int rightid = right.getRightId();
    String rightremark = right.getRightRemark();
    String rightdesc = right.getRightDesc();
    String sqlstr =
        "insert into M_RIGHT(RIGHTID,RIGHTNAME,RIGHTREMARK) values("
        + rightid + ",'"
        + rightdesc + "','"
        + rightremark + "')";

    if (db.ExecSql(sqlstr) == 0) {
      return false;
    }
    else {
      return true;
    }

  }

  /**
   * 查找權限信息方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */

  public static ArrayList SearchRight(DB db) throws
      Exception {
    ResultSet rs;
    ArrayList RightList = new ArrayList();
    String sqlstr = "select * from M_RIGHT order by RIGHTID";

    rs = db.OpenSql(sqlstr);
    while (rs.next()) {
      Right right = new Right();
      right.setRightId(rs.getInt("RIGHTID"));
      right.setRightDesc(rs.getString("RIGHTNAME"));
      right.setRightRemark(rs.getString("RIGHTREMARK"));
      RightList.add(right);
    }
    return RightList;
  }

  /**
   * 刪除權限信息方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */

  public static boolean deleteRight(DB db, int rightID) throws Exception {

    String strSql = null;

    strSql = "delete M_Right where RIGHTID=" + rightID;

    if (db.ExecSql(strSql) == 0) {
      System.out.println("order false");
      return false;

    }
    else {
      System.out.println("order true");
      return true;
    }
  }

  /**
   * 修改權限信息方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */

  public static boolean updateRight(DB db, Right right) throws Exception {

    String strSql = null;
    String rightname = right.getRightDesc();
    String rightremark = right.getRightRemark();
    int rightid = right.getRightId();
    strSql = "update M_Right set RIGHTNAME=" + rightname +
        ",RIGHTREMARK=" + "'" + rightremark + "'" +
        " where RIGHTID=" + rightid;

    if (db.ExecSql(strSql) == 0) {
      System.out.println("order false");
      return false;

    }
    else {
      System.out.println("order true");
      return true;
    }
  }

  /**
   * 權限編號加1方法
   * @param db DB
   * @param department Department
   * @throws Exception
   * @return boolean
   */

  public static int SearchRightID(DB db) throws Exception {
    int no;
    ResultSet rs;
    String strSql = null;

    strSql = "select Max(RIGHTID) from M_RIGHT";
    rs = db.OpenSql(strSql);
    if (rs.next()) {

      no = rs.getInt(1) + 1;
    }
    else {
      no = 1;
    }
    return no;
  }

}