package jinLing.department;

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

public class Department extends PubDb {

    public Collection execSel(Hashtable list, String pageno,
                              String count) {
        Collection col = null;
        String sql = "select * from TF_DEPARTMENT ";
        if (list.containsKey("DEPARTMENT_ID")) {
            sql += " where DEPARTMENT_ID=" +
                    list.get("DEPARTMENT_ID").toString();
        }
        col = super.execSel(sql, pageno, count);
        return col;
    }

    public Collection execSel(Hashtable list) {
        return execSel(list, "1", "1000000");
    }

    public int addRec(Hashtable list) {
        int st = 1;
        int id = 0;
        String sql1 = "select max(DEPARTMENT_ID) from TF_DEPARTMENT";
        id = super.getMax(sql1) + 1;
        String sql2 =
                "insert into TF_DEPARTMENT (DEPARTMENT_ID,DEPARTMENT_NAME) VALUES(" +
                id + ",'" + list.get("DEPARTMENT_NAME").toString() + "')";
        st = super.execUpd(sql2);
        return st;
    }

    public int setRec(String DEPARTMENT_ID, Hashtable list) {
        int st = 0;
        String sql = "update TF_DEPARTMENT SET DEPARTMENT_NAME='" +
                     list.get("DEPARTMENT_NAME").toString() +
                     "' where DEPARTMENT_ID=" + DEPARTMENT_ID;
        st = super.execUpd(sql);
        return st;
    }

    public int delRec(String DEPARTMENT_ID) {
        int st = 0;
        String sql = "delete  from TF_DEPARTMENT  where DEPARTMENT_ID=" +
                     DEPARTMENT_ID;
        st = super.execUpd(sql);
        return st;
    }

    public String getInitData(String DEPARTMENT_ID) {
        String sql =
                "select DEPARTMENT_NAME, DEPARTMENT_ID from TF_DEPARTMENT";
        String str = super.getInitData("DEPARTMENT_NAME", "DEPARTMENT_ID", sql,
                                       "---------請選擇---------", DEPARTMENT_ID);
        return str;
    }
}