package imis_manager;

import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import database.DBPoolManager;

public class organ_maintain {
        
        String organID;
        String supOrganID;
        String organName;
        String organAddr;
        String telephone;
        String fax;
        String postal;
        String remark;                
        String action;
        
              
        byte   temp[];
                            
	public void setOrganID(String value){
		organID = ISOtoGB(value);		 
        }

	public void setSupOrganID(String value){
		supOrganID = ISOtoGB(value);		 
        }
        
	public void setOrganName(String value){
		organName = ISOtoGB(value);	 		 
        }
        
	public void setOrganAddr(String value){
		organAddr = ISOtoGB(value);		
        }
        
	public void setTelephone(String value){
		telephone = ISOtoGB(value);		
        }
	public void setFax(String value){
		fax = ISOtoGB(value);		
        }
        
	public void setPostal(String value){
		postal = ISOtoGB(value);		
        }
        
	public void setRemark(String value){
		remark = ISOtoGB(value);				
        }  
	public void setAction(String value){
		action = ISOtoGB(value);		
        }   
                

	public String ISOtoGB(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("iso-8859-1"),"gb2312");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out; 		
        } 
	public String GBtoISO(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("gb2312"),"iso-8859-1");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {

    				e.printStackTrace();
    			}
    		}
    		return out;		
        } 
          
        public String processthis(){
        	String result= new String("執(zhí)行成功！");
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    sql  = null;
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = null;
			
			if (action.equals("mod")) {        
             	             	sql="update Organ set OrganName='"+organName
				+"', OrganAddr='"+organAddr
				+"', Telephone='"+telephone
				+"', Fax='"+fax
				+"', Postal='"+postal
				+"', ModifyDate=sysdate, Remark='"+remark
				+"'  where OrganID='"+organID+"'";
				stmt.executeUpdate(sql);
             		}
             		else if (action.equals("add")){
             	             	sql="insert into Organ(OrganID, OrganName,SupOrganID, OrganAddr, Telephone, Fax, Postal, ModifyDate, Remark,ORGANFLAG)values(ORGANID.NextVal,'"+organName
				+"','"+organID
				+"','"+organAddr
				+"','"+telephone
				+"','"+fax
				+"','"+postal
				+"',sysdate,'"+remark
				+"','1')";             
				stmt.executeUpdate(sql);
             		}
			else if (action.equals("del")){
				sql="select UserId from  staff where USERFLAG='1' and OrganID="+organID;
				rest = stmt.executeQuery(sql);
				if  (rest.next()) {
					result = "該部門有用戶存在，不能作廢！";
				}
				else{
					rest.close();
					stmt.close();					
					sql="select OrganID from Organ where ORGANFLAG='1' and OrganID<>"+organID+" start with OrganID="+organID+" connect by prior OrganID=SupOrganID ";
					stmt = dbpool.conn.createStatement();
					rest = stmt.executeQuery(sql);
					if  (rest.next()) {
						result = "該部門具有子機(jī)構(gòu)，不能作廢！";
					}
					else{
             	             			//sql="delete from  Organ where OrganID="+organID;             
						sql="update Organ set ORGANFLAG='0' where OrganID="+organID;
             	             			stmt.close();
						stmt = dbpool.conn.createStatement();
             	             			stmt.executeUpdate(sql);									             	             	
					}
				}
				rest.close();								
             		} 												
             		stmt.close();
		} catch (SQLException ex) {
			result = "執(zhí)行出錯！";
			System.err.println("Get organ_maintain SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		return result;	
	} 
}