package zhaobiao.db;

import java.util.*;
import java.sql.*;
import zhaobiao.db.*;
import zhaobiao.data.*;

/**
 * <p>Title: 招標管理信息系統</p>
 * <p>Description: 招標管理信息系統的前臺設計</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: 招標信息管理系統</p>
 * @author csk
 * @version 1.0
 */

public class Basic {

  public Basic() {
  }
  /**  根據項目id獲得該項目對象
  *@param 項目id
  *@return 項目對象實例
  */
 public Project getProject(long project_id)
 {
   Project pj=new Project();
   db=DBConnectionManager.getInstance();
   con=db.getConnection("idb");
   String sql="select *from project where project_id=?";
   try {
     ps=con.prepareStatement(sql);
     ps.setLong(1,project_id);
     rs=ps.executeQuery();
     if(rs.next())
     {
       pj.setProject_id(rs.getLong("project_id"));
       pj.setProject_name(rs.getString("project_name"));
       pj.setProject_time(rs.getString("project_time"));
       pj.setProject_company(rs.getString("project_company"));
       pj.setProject_cost(rs.getString("project_cost"));
       pj.setProject_content(rs.getString("project_content"));
     }
   }
   catch (SQLException ex) {
     freeCon();
     ex.printStackTrace();
   }
   freeCon();
   return pj;
 }
 /**  根據類別的id獲得該類別對象
  *@param 類別id
  *@return 類別對象實例
  */
 public Type getType(long type_id)
 {
   Type type=new Type();
   db=DBConnectionManager.getInstance();
   con=db.getConnection("idb");
   String sql="select *from type where type_id=?";
   try {
     ps=con.prepareStatement(sql);
     ps.setLong(1,type_id);
     rs=ps.executeQuery();
     if(rs.next())
     {
       type.setType_id(rs.getLong("type_id"));
       type.setType_name(rs.getString("type_name"));
       type.setType_content(rs.getString("type_content"));

     }
   }
   catch (SQLException ex) {
     ex.printStackTrace();
     freeCon();
   }
   freeCon();
   return type;
 }

 /**根據產品id獲得該產品對象
  *@param 產品id
  *@return 產品對象實例
  */
 public Product getProduct(long product_id)
 {
   Product pd=new Product();
   db=DBConnectionManager.getInstance();
   con=db.getConnection("idb");
   String sql="select *from product where product_id=?";
   try {
     ps=con.prepareStatement(sql);
     ps.setLong(1,product_id);
     rs=ps.executeQuery();
     if(rs.next())
     {
       pd.setProduct_id(rs.getLong("product_id"));
       pd.setProduct_name(rs.getString("product_name"));
       pd.setType_id(rs.getLong("type_id"));
       pd.setProduct_content(rs.getString("product_content"));
       pd.setMaker_id(rs.getLong("maker_id"));

     }
   }
   catch (SQLException ex) {
     freeCon();
     ex.printStackTrace();
   }
   freeCon();
   return pd;

 }
/**根據廠商id返回廠商對象
 *@oaram 廠商id
 * @return 廠商對象
 */
 public Maker getMaker(long maker_id)
 {
   Maker mk=new Maker();
   db=DBConnectionManager.getInstance();
   con=db.getConnection("idb");
   String sql="select *from maker where maker_id=?";
   try {
     ps=con.prepareStatement(sql);
     ps.setLong(1,maker_id);
     rs=ps.executeQuery();
     if(rs.next())
     {
       mk.setMaker_id(rs.getLong("maker_id"));
       mk.setMaker_name(rs.getString("maker_name"));
       mk.setMaker_address(rs.getString("maker_address"));
       mk.setMaker_cr_address(rs.getString("maker_cr_address"));
       mk.setMaker_cr_time(rs.getString("maker_cr_time"));
       mk.setMaker_cr_address(rs.getString("maker_cr_address"));
       mk.setMaker_cr_cost(rs.getString("maker_cr_cost"));
       mk.setMaker_fr_name(rs.getString("maker_fr_name"));
       mk.setMaker_fr_position(rs.getString("maker_fr_position"));
       mk.setMaker_attribute(rs.getString("maker_attribute"));
       mk.setMaker_relation(rs.getString("maker_relation"));
       mk.setMaker_db_content(rs.getString("maker_db_content"));
     }
   }
   catch (SQLException ex) {
     freeCon();
     ex.printStackTrace();
   }
   freeCon();
   return mk;
 }

 /** 根據ppmid獲得該PPM對象
  *@param PPM_id  (long)
  *@return PPM對象
  */
 public  PPM getPPM(long id)
 {
    PPM ppm=new PPM();
    db=DBConnectionManager.getInstance();
    con=db.getConnection("idb");
    String sql="select *from ppm where id=?";
    try {
      ps=con.prepareStatement(sql);
      ps.setLong(1,id);
      rs=ps.executeQuery();
      if(rs.next())
      {
        boolean isok=false;
        ppm.setId(id);
        ppm.setProject_id(rs.getLong("project_id"));
        ppm.setProduct_id(rs.getLong("product_id"));
        ppm.setMaker_id(rs.getLong("maker_id"));
        if(rs.getLong("zhongbiao")==1)
          isok=true;
        ppm.setZhongbiao(isok);

        ppm.setPrice_id(rs.getLong("price_id"));

      }
    }
    catch (SQLException ex) {
      freeCon();
      ex.printStackTrace();
    }
    freeCon();
    return ppm;

 }
 /** 根據標價id獲得標價對象
  * @param 標價id
  * @return 標價對象
  */


public Price getPrice(long id)
{
  Price price=new Price();
  db=DBConnectionManager.getInstance();
  con=db.getConnection("idb");
  String sql="select *from price where price_id=?";
  try {
    ps=con.prepareStatement(sql);
    ps.setLong(1,id);
    rs=ps.executeQuery();
       if(rs.next())
       {
         price.setPrice_id(id);
        // price.setMaker_id(rs.getLong("maker_id"));
         price.setDevice_price(rs.getString("device_price"));
         price.setTool_price(rs.getString("tool_price"));
         price.setService_price(rs.getString("service_price"));
         price.setOptional_price(rs.getString("optional_price"));
         price.setRePro_price(rs.getString("rePro_price"));
         price.setInter_price(rs.getString("inter_price"));;
         price.setEnsure_price(rs.getString("ensure_price"));
         price.setDeliver_time(rs.getString("deliver_time"));


       }
  }
  catch (SQLException ex) {
    ex.printStackTrace();
  }
  freeCon();
  return price;
}

/** 主要替換回車符為空，雙引號為\"
  *@param String
  *@return String
  */

 public String cnvtBr(String str) {
   String text = str;
   int index=text.indexOf(13);
   while(index!=-1)
  {
     text=text.substring(0,index)+"<br>"+text.substring(index+2);
     index=text.indexOf(13);
    }
    return text;
 }
 /**
  * 釋放數據庫資源<p>
  *PreparedStatement和ResultSep將關閉，Connection返回給連接池
  
  */
 public void freeCon(){
   try {
     if (rs!=null)
       rs.close() ;
     if (ps!=null)
       ps.close() ;
   }
   catch (SQLException ex) {
   }
   if (db!=null)
     db.freeConnection("idb",con) ;
 }
 private DBConnectionManager db;
 private Connection con=null;
 private ResultSet rs=null;
  private PreparedStatement ps=null;
}