package jp.co.sint.basic;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.Collection;

import jp.co.sint.database.SIDBAccessException;
import jp.co.sint.database.SIDBUtil;

/**
 * @version $Id : SIDeliveryName.java,v 1.0 Exp $
 * @author      : Tsuyoshi Yagi
 * <br>Description :
 * <p>History</p>
 * <p>Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Reason</p>
 * ============&nbsp;&nbsp;&nbsp;==========&nbsp;&nbsp;===========================<br>
 * Tsuyoshi yagi   2005/08/10  Original
 */

public class SIDeliveryName extends SIBasic {
  /**
   * <b>getNameCollection</b>
   * 顧客コードから配送先名称を取得
   * @param  Connection
   * @param  custCode    顧客コード
   * @return Collection　配送先名称リスト
   * @throws なし
   */
  public static Collection getNameCollection(Connection lConnection,String custCode){
    StringBuffer lSqlBuf=new StringBuffer("SELECT deliveryname,addresscode FROM CustAddresstbl ");
    lSqlBuf.append("WHERE custCode=").append(SIDBUtil.SQL2Str(custCode)).append(" ORDER BY addresscode ASC");

    Collection lResultColl=new ArrayList();

    try {
      lResultColl=SIDBUtil.getCollection(lConnection,lSqlBuf.toString(),false);
    } catch (SIDBAccessException e) {
      e.printStackTrace();
    }

    return lResultColl;
  }

}