package imis_mate.common;

import database.DBPoolManager;

import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Iterator;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

//庫存樹
import java.sql.SQLException;

public class MaterialBuyTree {
	public MaterialBuyTree() {
		
	}

		
  public ArrayList getBuyNo() {
	ArrayList list = new ArrayList();
	DBPoolManager db = new DBPoolManager();

	   String sOrganID=null;
	   String sSupOrganID=null;
	   String sOrganName=null;
	db.getConnection();
	
	try {
		String s = null;
		String sql = "SELECT BuyNo FROM (SELECT BuyNo FROM Material_Buy_Table order by InDate DESC)where rownum<=50 order by BuyNo"; 
		
		//String sql = "select maintainID,materialName  from Material_Maintain_Table  order by  MaintainDate Desc"; //
		Statement stmt = db.conn.createStatement(); 
		ResultSet rs = stmt.executeQuery(sql);
		String buyNo;
		
		Hashtable ht1 = new Hashtable();
		ht1.put("OrganID", "1");
		ht1.put("SupOrganID", "0");
		ht1.put("OrganName", "采購編號");
		list.add(ht1);
		int i = 11;
		while(rs.next()){
			Hashtable ht = new Hashtable();
			buyNo = rs.getString("BuyNo");
			ht.put("OrganID", String.valueOf(i));
			ht.put("SupOrganID", "1");
			ht.put("OrganName", buyNo);
			i++;
			list.add(ht);
		}
			rs.close();
			stmt.close();	
			ArrayList list1 = new ArrayList();
			Iterator itr = list.iterator();
			 while (itr.hasNext()) {
			   
			     
					Hashtable ht = (Hashtable) itr.next();   
					
			  				sOrganID      =  ht.get("OrganID").toString();
			            	sSupOrganID   =  ht.get("SupOrganID").toString(); 
			            	sOrganName    =  ht.get("OrganName").toString();
			
		     sql = "select BuyId,materialTypeName  from Material_Buy_Detail  where BuyNo='"+sOrganName+"'"; //

		 	
		     stmt = db.conn.createStatement(); 
			 rs = stmt.executeQuery(sql);
			 
			 i = 11;
		
			 
			 while (rs.next()) {
			Hashtable hash = new Hashtable();
			s = rs.getString("materialTypeName");
			String no = new Integer(rs.getInt("BuyId")).toString();
			
			s = s.trim();
			
			
		//	hash.put("OrganID", no);
			hash.put("OrganID", String.valueOf(i)+"*"+no);
			hash.put("SupOrganID", sOrganID);
			hash.put("OrganName", s);
			i=i+1;
			
			list1.add(hash);
			
			
		   }
		
			 }
		list.addAll(list1);
		
		rs.close();
		stmt.close();
	} catch (SQLException ex){
		System.err.print("Get MaterialTree SQLException: " + ex.toString());
		ex.printStackTrace();
	} finally {
		db.freeConnection();
	}
	return list;
}



	
}