/**
 * Created on 2003/08/29
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package jp.co.sint.basic;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;

import jp.co.sint.config.SIConfig;
import jp.co.sint.database.SIDBAccessException;
import jp.co.sint.database.SIDBUtil;
import jp.co.sint.tools.SIDateTime;
import jp.co.sint.tools.SIUtil;

import org.apache.log4j.Category;

/**
 * @author arai
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class SIStock extends SIBasic {
  //ログ用のインスタンスの生成
  private static Category log = Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME);
  
  private String stockCode = "";
  private String stockName = "";
  private String stockPronName = "";
  private String presidentName = "";
  private String presidentPronName = "";
  private String address1 = "";
  private String address2 = "";
  private String address3 = "";
  private String postCode1 = "";
  private String postCode2 = "";
  private String email = "";
  private String email2 = "";
  private String email3 = "";
  private String tel = "";
  private String fax = "";
  private String dealerStation = "";
  private String dealerStaff = "";
  private String chargeCode = "";
  private String chargeName = "";
  private String capital = "";
  private String establishDateYear = "";
  private String establishDateMonth = "";
  private String establishDateDay = "";
  private String accountingPeriod = "";
  private String financialInst = "";
  private String financialBranch = "";
  private String accountHolder = "";
  private String accountType = "";
  private String accountNumber = "";
  private String closeType = "";
  private String closeLimit = "";
  private String payType = "";
  private String payLimit = "";
  private String cmdtyCount = "";
  private String enableFlg = "";
  private String memo = "";
  
  public SIStock(){
  }
  
  public SIStock(String lStockCode){
    setStockCode(lStockCode);
  }
  
  public String getAccountHolder() {
    return accountHolder;
  }
  
  public void setAccountHolder(String accountHolder) {
    if (SIUtil.isNull(accountHolder)) accountHolder = "";
    this.accountHolder = accountHolder;
  }
  
  public String getAccountingPeriod() {
    return accountingPeriod;
  }
  
  public void setAccountingPeriod(String accountingPeriod) {
    if (SIUtil.isNull(accountingPeriod)) accountingPeriod = "";
    this.accountingPeriod = accountingPeriod;
  }
  
  public String getAccountNumber() {
    return accountNumber;
  }
  
  public void setAccountNumber(String accountNumber) {
    if (SIUtil.isNull(accountNumber)) accountNumber = "";
    this.accountNumber = accountNumber;
  }
  
  public String getAccountType() {
    return accountType;
  }
  
  public void setAccountType(String accountType) {
    if (SIUtil.isNull(accountType)) accountType = "";
    this.accountType = accountType;
  }
  
  public String getAddress1() {
    return address1;
  }
  
  public void setAddress1(String address1) {
    if (SIUtil.isNull(address1)) address1 = "";
    this.address1 = address1;
  }
  
  public String getAddress2() {
    return address2;
  }
  
  public void setAddress2(String address2) {
    if (SIUtil.isNull(address2)) address2 = "";
    this.address2 = address2;
  }
  
  public String getAddress3() {
    return address3;
  }
  
  public void setAddress3(String address3) {
    if (SIUtil.isNull(address3)) address3 = "";
    this.address3 = address3;
  }
  
  public String getCapital() {
    return capital;
  }
  
  public void setCapital(String capital) {
    if (SIUtil.isNull(capital)) capital = "";
    this.capital = capital;
  }
  
  public String getChargeCode() {
    return chargeCode;
  }
  
  public void setChargeCode(String chargeCode) {
    if (SIUtil.isNull(chargeCode)) chargeCode = "";
    this.chargeCode = chargeCode;
  }
  
  public String getChargeName() {
    return chargeName;
  }
  
  public void setChargeName(String chargeName) {
    if (SIUtil.isNull(chargeName)) chargeName = "";
    this.chargeName = chargeName;
  }
  
  public String getCloseLimit() {
    return closeLimit;
  }
  
  public void setCloseLimit(String closeLimit) {
    if (SIUtil.isNull(closeLimit)) closeLimit = "";
    this.closeLimit = closeLimit;
  }
  
  public String getCloseType() {
    return closeType;
  }
  
  public void setCloseType(String closeType) {
    if (SIUtil.isNull(closeType)) closeType = "";
    this.closeType = closeType;
  }
  
  public String getCmdtyCount() {
    return cmdtyCount;
  }
  
  public void setCmdtyCount(String cmdtyCount) {
    if (SIUtil.isNull(cmdtyCount)) cmdtyCount = "";
    this.cmdtyCount = cmdtyCount;
  }
  
  public String getDealerStaff() {
    return dealerStaff;
  }
  
  public void setDealerStaff(String dealerStaff) {
    if (SIUtil.isNull(dealerStaff)) dealerStaff = "";
    this.dealerStaff = dealerStaff;
  }
  
  public String getDealerStation() {
    return dealerStation;
  }
  
  public void setDealerStation(String dealerStation) {
    if (SIUtil.isNull(dealerStation)) dealerStation = "";
    this.dealerStation = dealerStation;
  }
  
  public String getEmail() {
    return email;
  }
  
  public void setEmail(String email) {
    if (SIUtil.isNull(email)) email = "";
    this.email = email;
  }
  
  public String getEmail2() {
    return email2;
  }
  
  public void setEmail2(String email2) {
    if (SIUtil.isNull(email2)) email2 = "";
    this.email2 = email2;
  }
  
  public String getEmail3() {
    return email3;
  }
  
  public void setEmail3(String email3) {
    if (SIUtil.isNull(email3)) email3 = "";
    this.email3 = email3;
  }
  
  public String getEnableFlg() {
    return enableFlg;
  }
  
  public void setEnableFlg(String enableFlg) {
    if (SIUtil.isNull(enableFlg)) enableFlg = "";
    this.enableFlg = enableFlg;
  }
  
  public String getEstablishDate() {
    return SIDateTime.getDate(getEstablishDateYear(), getEstablishDateMonth(), getEstablishDateDay());
  }
  
  public String getEstablishDateDay() {
    return establishDateDay;
  }
  
  public void setEstablishDateDay(String establishDateDay) {
    if (SIUtil.isNull(establishDateDay)) establishDateDay = "";
    this.establishDateDay = establishDateDay;
  }
  
  public String getEstablishDateMonth() {
    return establishDateMonth;
  }
  
  public void setEstablishDateMonth(String establishDateMonth) {
    if (SIUtil.isNull(establishDateMonth)) establishDateMonth = "";
    this.establishDateMonth = establishDateMonth;
  }
  
  public String getEstablishDateYear() {
    return establishDateYear;
  }
  
  public void setEstablishDateYear(String establishDateYear) {
    if (SIUtil.isNull(establishDateYear)) establishDateYear = "";
    this.establishDateYear = establishDateYear;
  }
  
  public String getFax() {
    return fax;
  }
  
  public void setFax(String fax) {
    if (SIUtil.isNull(fax)) fax = "";
    this.fax = fax;
  }
  
  public String getFinancialBranch() {
    return financialBranch;
  }
  
  public void setFinancialBranch(String financialBranch) {
    if (SIUtil.isNull(financialBranch)) financialBranch = "";
    this.financialBranch = financialBranch;
  }
  
  public String getFinancialInst() {
    return financialInst;
  }
  
  public void setFinancialInst(String financialInst) {
    if (SIUtil.isNull(financialInst)) financialInst = "";
    this.financialInst = financialInst;
  }
  
  public String getPayLimit() {
    return payLimit;
  }
  
  public void setPayLimit(String payLimit) {
    if (SIUtil.isNull(payLimit)) payLimit = "";
    this.payLimit = payLimit;
  }
  
  public String getPayType() {
    return payType;
  }
  
  public void setPayType(String payType) {
    if (SIUtil.isNull(payType)) payType = "";
    this.payType = payType;
  }
  
  public String getPostCode1() {
    return postCode1;
  }
  
  public void setPostCode1(String postCode1) {
    if (SIUtil.isNull(postCode1)) postCode1 = "";
    this.postCode1 = postCode1;
  }
  
  public String getPostCode2() {
    return postCode2;
  }
  
  public void setPostCode2(String postCode2) {
    if (SIUtil.isNull(postCode2)) postCode2 = "";
    this.postCode2 = postCode2;
  }
  
  public String getPresidentName() {
    return presidentName;
  }
  
  public void setPresidentName(String presidentName) {
    if (SIUtil.isNull(presidentName)) presidentName = "";
    this.presidentName = presidentName;
  }
  
  public String getPresidentPronName() {
    return presidentPronName;
  }
  
  public void setPresidentPronName(String presidentPronName) {
    if (SIUtil.isNull(presidentPronName)) presidentPronName = "";
    this.presidentPronName = presidentPronName;
  }
  
  public String getStockCode() {
    return stockCode;
  }
  
  public void setStockCode(String stockCode) {
    if (SIUtil.isNull(stockCode)) stockCode = "";
    this.stockCode = stockCode;
  }
  
  public String getStockName() {
    return stockName;
  }
  
  public void setStockName(String stockName) {
    if (SIUtil.isNull(stockName)) stockName = "";
    this.stockName = stockName;
  }
  
  public String getStockPronName() {
    return stockPronName;
  }
  
  public void setStockPronName(String stockPronName) {
    if (SIUtil.isNull(stockPronName)) stockPronName = "";
    this.stockPronName = stockPronName;
  }
  
  public String getTel() {
    return tel;
  }
  
  public void setTel(String tel) {
    if (SIUtil.isNull(tel)) tel = "";
    this.tel = tel;
  }
  
  public String getMemo() {
    return memo;
  }
  
  public void setMemo(String memo) {
    if (SIUtil.isNull(memo)) memo = "";
    this.memo = memo;
  }
  
  public static Collection getCollection(Connection lConnection){
    Collection lResultColl=new ArrayList();
    
    try {
      lResultColl=SIDBUtil.getCollection(lConnection,"SELECT StockName,StockCode FROM StockMtbl WHERE enableFlg=1  ORDER BY CASE stockcode WHEN '9999' THEN 0 ELSE 1 END,stockpronname",false);
    } catch (SIDBAccessException e) {
      e.printStackTrace();
    }
    
    return lResultColl;
  }
}