/**
 * @version $Id : UIPurchaseHistoryMemo.java,v 1.0 Exp $
 * @author : xxxx xx <br>
 * Description :顧客購入履歴メモのbeansクラス
 * <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>
 * 2007/09/28 Original
 */
package jp.co.sint.beans.mallmgr;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import org.apache.log4j.Category;

import jp.co.sint.basic.SIBasic;
import jp.co.sint.config.SIConfig;
import jp.co.sint.database.SIDBUtil;
import jp.co.sint.tools.SIUtil;

public class UIPurchaseHistoryMemo extends SIBasic {
  // ログ用のインスタンスの生成
  private static Category log = Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME);
  
  // メモ番号
  private String commentNumber = "";
  
  // 登録日
  private String initDateTime = "";
  
  // 更新日
  private String updateDateTime = "";
  
  // 担当者
  private String userName = "";
  
  // メモ
  private String memo = "";
  
  // 分類
  private String memoStatus = "";
  
  // 最終更新者
  private String lastUpdateUserName = "";
  
  public UIPurchaseHistoryMemo(){}
  
  public void reset(Connection lConnection,String custCode,String commentNumber){
    Statement lStatement = null;
    ResultSet lResultSet = null;
    if(SIUtil.isNull(custCode) || SIUtil.isNull(commentNumber)) return;
    StringBuffer str = new StringBuffer();
    
    str.append("SELECT * FROM purchaseCommentTbl WHERE custcode = ").append(SIDBUtil.SQL2Str(custCode," "));
    str.append("AND commentNumber = ").append(SIDBUtil.SQL2Str(commentNumber));
    
    try {
      lStatement = lConnection.createStatement();
      lResultSet = lStatement.executeQuery(str.toString());
      if(lResultSet.next()) {
        this.setCommentNumber(commentNumber);
        this.setInitDateTime(SIDBUtil.getDateTime(lResultSet.getTimestamp("initDateTime")));
        this.setUpdateDateTime(SIDBUtil.getDateTime(lResultSet.getTimestamp("updateDateTime")));
        this.setUserName(lResultSet.getString("userName"));
        this.setMemo(lResultSet.getString("comment"));
        this.setMemoStatus(lResultSet.getString("memoStatus"));
        this.setLastUpdateUserName(lResultSet.getString("lastUpdateUserName"));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      SIDBUtil.close(lStatement, lResultSet);
    }
  }
  
  // getter of commentNumber
  public String getCommentNumber() {
    return this.commentNumber;
  }
  
  // getter of initDateTime
  public String getInitDateTime() {
    return this.initDateTime;
  }
  
  public String getLastUpdateUserName() {
    return lastUpdateUserName;
  }
  
  // getter of memo
  public String getMemo() {
    return this.memo;
  }
  
  // getter of memoStatus
  public String getMemoStatus() {
    return this.memoStatus;
  }
  
  // getter of updateDateTime
  public String getUpdateDateTime() {
    return this.updateDateTime;
  }
  
  // getter of userName
  public String getUserName() {
    return this.userName;
  }
  
  // setter of commentNumber
  public void setCommentNumber(String commentNumber) {
    if (SIUtil.isNull(commentNumber)) commentNumber = "";
    this.commentNumber = SIUtil.changeTo(commentNumber.trim(), this.encode);
  }
  
  // setter of initDateTime
  public void setInitDateTime(String initDateTime) {
    if (SIUtil.isNull(initDateTime)) initDateTime = "";
    this.initDateTime = SIUtil.changeTo(initDateTime.trim(), this.encode);
  }
  
  public void setLastUpdateUserName(String lastUpdateUserName) {
    if (SIUtil.isNull(lastUpdateUserName)) lastUpdateUserName = "";
    this.lastUpdateUserName = lastUpdateUserName;
  }
  
  // setter of memo
  public void setMemo(String memo) {
    if (SIUtil.isNull(memo)) memo = "";
    this.memo = SIUtil.changeTo(memo.trim(), this.encode);
  }
  
  public void setMemoStatus(String memoStatus) {
    if (SIUtil.isNull(memoStatus)) memoStatus = "";
    this.memoStatus = memoStatus;
  }
  
  // setter of updateDateTime
  public void setUpdateDateTime(String updateDateTime) {
    if (SIUtil.isNull(updateDateTime)) updateDateTime = "";
    this.updateDateTime = SIUtil.changeTo(updateDateTime.trim(), this.encode);
  }
  
  // setter of userName
  public void setUserName(String userName) {
    if (SIUtil.isNull(userName)) userName = "";
    this.userName = SIUtil.changeTo(userName.trim(), this.encode);
  }
}