package jinLing.manager;

import java.util.*;
import jinLing.pub.*;

public class ManagerInfo extends PubDb {
    /**
     * 功能：登陸驗證
     * @param list 登陸信息
     * @return 驗證信息:
     * @return      list 中存放權限信息及ST的值
     * @return      ST:  1－成功 0－失敗 2－用戶密碼錯誤
     */
    public Hashtable manLand(Hashtable list) {
        Hashtable rlist = new Hashtable();
        int st = 1;
        if (list.isEmpty()) {
            st = 0;
            System.out.println("parameter is not full");
        }
        if (st == 1) {
            try {
                int rcount = 0;
                String sql = "";
                if (st == 1) {
                    sql =
                            "select count(*) as sl from TF_MANAGER_INFO where MAN_NO='" +
                            list.get("MAN_NO").toString().trim() + "'" +
                            " and MAN_PWD='" +
                            list.get("MAN_PWD").toString().trim() + "'";
                    rcount = super.getRecordcount(sql);
                    if (rcount < 1) {
                        st = 2; //密碼錯誤
                    }
                }
                if (st == 1) {
                    sql = "select * from TF_MANAGER_INFO where MAN_NO='" +
                          list.get("MAN_NO").toString().trim() + "'";
                    Collection col = super.execSel(sql);
                    Iterator it = col.iterator();
                    if (it.hasNext()) {
                        rlist = (Hashtable) it.next();
                    }
                }
            } catch (Exception ex) {
                st = 0;
                ex.printStackTrace();
            }
        }
        rlist.put("ST", String.valueOf(st));
        return rlist;
    }

    /**
     * 功能：查詢系統帳號
     * @param list 存放系統帳號各個字段的值
     * @param pageno 頁碼
     * @param count 每頁記錄條數
     * @return 系統帳號數據集
     */
    public Collection execSel(Hashtable list, String pageno, String count) {
        Collection col = null;
        String sql = "";
        if (!list.containsKey("MAN_ID")) {
            sql = "select * from TF_MANAGER_INFO ";
        } else {
            sql = "select * from TF_MANAGER_INFO where MAN_ID=" +
                  list.get("MAN_ID").toString();
        }
        col = super.execSel(sql, pageno, count);
        return col;
    }

    /**
     * 功能：查詢系統帳號
     * @param list 存放系統帳號各個字段的值
     * @return 系統帳號數據集
     */
    public Collection execSel(Hashtable list) {
        Collection col = execSel(list, "1", "1000000");
        return col;
    }

    /**
     * 功能：增加系統帳號
     * @param list 存放系統帳號各個字段的值
     * @return 更新記錄條數
     */
    public int addRec(Hashtable list) {
        int st = 1;
        int id = 0;
        //找出此記錄的ID值
        String sql1 = "select max(MAN_ID) from TF_MANAGER_INFO";
        id = super.getMax(sql1) + 1;
        //插入記錄
        String sql2 =
                "insert into TF_MANAGER_INFO (MAN_ID,MAN_NO,MAN_PWD,MAN_NAME) VALUES(" +
                id + ",'" + list.get("MAN_NO").toString() + "','" +
                list.get("MAN_PWD").toString() + "','" +
                list.get("MAN_NAME").toString() + "')";
        st = super.execUpd(sql2);
        return st;
    }

    /**
     * 功能：修改系統帳號
      @param MAN_ID 系統帳號的 ID
     * @return 更新記錄條數
     */
    public int setRec(String MAN_ID, Hashtable list) {
        int st = 0;
        String sql = "update TF_MANAGER_INFO SET MAN_NO='" +
                     list.get("MAN_NO").toString() + "',MAN_PWD='" +
                     list.get("MAN_PWD").toString() + "', MAN_NAME='" +
                     list.get("MAN_NAME").toString() + "' where MAN_ID='" +
                     MAN_ID + "'";
        st = super.execUpd(sql);
        return st;
    }

    /**
     * 功能：刪除系統帳號
     * @param MAN_ID 系統帳號的 ID
     * @return 更新記錄條數
     */
    public int delRec(String MAN_ID) {
        int st = 0;
        String sql = "delete  from TF_MANAGER_INFO  where MAN_ID='" + MAN_ID +
                     "'";
        st = super.execUpd(sql);
        return st;
    }

    /**
     * 功能：設置權限
     * @param MAN_ID 系統帳號的 ID
     * @param list 權限值
     * @return 更新記錄條數
     */
    public int setRole(String MAN_ID, Hashtable list) {
        int st = 0;
        if (!list.isEmpty()) {
            String sql = "update TF_MANAGER_INFO SET  ";
            if (list.get("ROLE_1") != null)
                sql += " ROLE_1 = '" + list.get("ROLE_1").toString() + "',";
            if (list.get("ROLE_2") != null)
                sql += "ROLE_2= '" + list.get("ROLE_2").toString() + "',";
            if (list.get("ROLE_3") != null)
                sql += " ROLE_3= '" + list.get("ROLE_3").toString() + "',";
            if (list.get("ROLE_4") != null)
                sql += " ROLE_4= '" + list.get("ROLE_4").toString() + "',";
            if (list.get("ROLE_5") != null)
                sql += "ROLE_5= '" + list.get("ROLE_5").toString() + "',";
            if (list.get("ROLE_6") != null)
                sql += " ROLE_6= '" + list.get("ROLE_6").toString() + "',";
            if (list.get("ROLE_7") != null)
                sql += "ROLE_7= '" + list.get("ROLE_7").toString() + "',";
            if (list.get("ROLE_8") != null)
                sql += "ROLE_8= '" + list.get("ROLE_8").toString() + "',";
            if (list.get("ROLE_9") != null)
                sql += "ROLE_9= '" + list.get("ROLE_9").toString() + "',";
            if (list.get("ROLE_10") != null)
                sql += "ROLE_10= '" + list.get("ROLE_10").toString() + "',";
            if (list.get("ROLE_11") != null)
                sql += "ROLE_11= '" + list.get("ROLE_11").toString() + "',";
            if (list.get("ROLE_12") != null)
                sql += "ROLE_12= '" + list.get("ROLE_12").toString() + "',";
            if (list.get("ROLE_13") != null)
                sql += "ROLE_13= '" + list.get("ROLE_13").toString() + "',";
            if (list.get("ROLE_14") != null)
                sql += "ROLE_14= '" + list.get("ROLE_14").toString() + "',";
            if (list.get("ROLE_15") != null)
                sql += "ROLE_15= '" + list.get("ROLE_15").toString() + "'";
            if (sql.endsWith(","))
                sql = sql.substring(0, sql.length() - 1);
            sql += " where MAN_ID=" + MAN_ID;
            st = super.execUpd(sql);
        }
        return st;
    }
}