/**
 * Copyright (c) 2003-2005 System Integrator Corporation.
 *                 All Rights Reserved.
 */
package jp.co.sint.beans.mallmgr;

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

import javax.servlet.http.HttpServletRequest;

import jp.co.sint.basic.SIBasic;
import jp.co.sint.config.SIConfig;
import jp.co.sint.config.SIFlagConf;
import jp.co.sint.database.SIDBAccessException;
import jp.co.sint.database.SIDBUtil;
import jp.co.sint.tools.SICheckDataConf;
import jp.co.sint.tools.SICheckUtil;
import jp.co.sint.tools.SICheckValid;
import jp.co.sint.tools.SICustomError;
import jp.co.sint.tools.SICustomErrors;
import jp.co.sint.tools.SIDateTime;
import jp.co.sint.tools.SIURLParameter;
import jp.co.sint.tools.SIUtil;

import org.apache.log4j.Category;

/**
 * @version $Id : UICmdtyParent.java,v 1.0 Exp $
 * @author : Tsuyoshi Yagi <br>
 * Description :商品マスタ（個別）に対するBean
 * <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/12 Original
 */
public class UIIndividual extends SIBasic {
  // ログ用のインスタンスの生成
  private static Category log = Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME);
  
  // ショップコード
  private String shopCode = "";
  
  // 親コード
  private String cmdtyCode = "";
  
  // 在庫コード
  private String individualCode = "";
  
  // 中古・新品区分
  private String usedNewFlg = "";
  
  // 入荷日
  private String arrivalDate = "";
  
  // 入荷日（年）
  private String arrivalYear = "";
  
  // 入荷日（月）
  private String arrivalMonth = "";
  
  // 入荷日（日）
  private String arrivalDay = "";
  
  // 加工費
  private String processingExpence = "";
  
  // 色コード
  private String colorCode = "";
  
  // 使用年数
  private String tenureofuse = "";
  
  // 販売状況
  private String salesSituationFlg = "";
  
  // SOLDOUT後表示
  private String soldOutDispFlg = "1";
  
  // キャンペーン特価区分
  private String campaignPriceFlg = "";
  
  // 問合せ区分
  private String inquiryFlg = "";
  
  // フロント表示
  private String frontDispFlg = "";
  
  // 顧客コード
  private String custCode = "";
  
  // 顧客名称
  private String custName = "";
  
  // コメント
  private String comment = "";
  
  // M価
  private String newFixedPrice = "";
  
  // BG卸価フロント表示
  private String bgPriceDispFlg = "";
  
  // 委託商品
  private String consignGoodsFlg = "";
  
  // 委託メモ
  private String consignmentMemo = "";
  
  // 商品説明
  private String commodityExplanation = "";
  
  // 仕入先コード
  private String stockCode = "";
  
  // 仕入価格
  private String purchasePrice = "";
  
  // BG卸価（本体価格）
  private String bgPrice = "";
  
  // BG卸価（税抜）
  private String bgPriceWithoutTax = "";
  
  // 特別価格
  private String specialPrice = "";
  
  // おすすめフラグ
  private String recommendationFlg = "";
  
  // 商品バナーファイル
  private String commodityBannerFile = "";
  
  // 会員値引フラグ
  private String memberDiscountFlg = "1";
  
  // 販売開始日
  private String sellFromDate = "";
  
  // 販売開始日（年）
  private String sellFromDateYear = "";
  
  // 販売開始日（月）
  private String sellFromDateMonth = "";
  
  // 販売開始日（日）
  private String sellFromDateDay = "";
  
  // 販売終了日設定フラグ
  private String endSellFlg = "";
  
  // 販売終了日
  private String sellToDate = "";
  
  // 販売終了日（年）
  private String sellToDateYear = "";
  
  // 販売終了日（月）
  private String sellToDateMonth = "";
  
  // 販売終了日（日）
  private String sellToDateDay = "";
  
  // 特別価格開始日
  private String salesFromdate = "";
  
  // 特別価格終了日
  private String salesToDate = "";
  
  // 予約販売フラグ
  private String rsrvEnableFlg = "";
  
  // 予約可能数
  private String rsrvAmount = "";
  
  // 在庫無販売フラグ
  private String noStockFlg = "";
  
  // 在庫数管理フラグ
  private String amountFlg = "";
  
  // 在庫状況番号
  private String stockStatusCode = "";
  
  // 売切日
  private String soldOutDate = "";
  
  // 保障期間
  private String guaranteedTerm = "";
  
  // ラッピングフラグ
  private String wrappingFlg = "";
  
  // 一括値引フラグ
  private String discountFlg = "";
  
  // 特価値引フラグ
  private String salesDiscountFlg = "";
  
  // おすすめ表示順
  private String adviceDispOrder = "";
  
  // 画像タイトル１
  private String imageName1 = "";
  
  // 画像タイトル２
  private String imageName2 = "";
  
  // 画像タイトル３
  private String imageName3 = "";
  
  // 画像タイトル４
  private String imageName4 = "";
  
  // 画像タイトル５
  private String imageName5 = "";
  
  // 画像タイトル サムネイル
  private String imageNamet = "";
  
  // 備考
  private String remarks = "";
  
  // 登録日時
  private String initDateTime = "";
  
  // 在庫保有店舗（一覧用）
  private String branchName = "";
  
  // 在庫数量（一覧用）
  private String amount = "";
  
  // ページ
  private String pageNumberTxt = "1";
  
  // 表示フラグ（初期遷移時判定）
  private String firstDispFlg = "0";
  
  // 削除可能フラグ
  private String deleteFlg = "0";
  
  // 在庫コード1
  private String individual1 = "";
  
  // 在庫コード2
  private String individual2 = "";
  
  // 在庫コード3
  private String individual3 = "U";
  
  // キャンペーン設定フラグ
  private String spCampaignFlg = "";
  
  // 通常価格
  private String nomalPrice = "";
  
  // アラート数量
  private String alertAmount = "";
  
  // 商品名
  private String cmdtyName = "";
  
  // 入庫数
  private String storeAmount = "0";
  
  // 出庫数
  private String shipAmount = "0";
  
  // 平均単価
  private String price = "0";
  
  // 帳簿在庫
  private String realAmount = "0";
  
  // 仕入単価（在庫管理しない）
  private String purchasePrice2 = "0";
  
  private String arrivalScheduleMsg = "";
  
  private String janCodeIndividual = "";
  
  private String searchIndividualCodeTxt = "";
  
  private String consignGoodsFee = "0";
  
  private String priceDownFlg = "0";
  
  // 追加コメント１タイトル
  private String expansionComment1Title = "";
  
  // 追加コメント１本文
  private String expansionComment1Text = "";
  
  // 追加コメント２タイトル
  private String expansionComment2Title = "";
  
  // 追加コメント２本文
  private String expansionComment2Text = "";
  
  // 追加コメント３タイトル
  private String expansionComment3Title = "";
  
  // 追加コメント３本文
  private String expansionComment3Text = "";
  
  // 追加コメント４タイトル
  private String expansionComment4Title = "";
  
  // 追加コメント４本文
  private String expansionComment4Text = "";
  
  //EDBTG005-00 kamata add start  
  // 追加コメント５タイトル
  private String expansionComment5Title = "";
  
  // 追加コメント５本文
  private String expansionComment5Text = "";
  //EDBTG005-00 kamata add end
  
  // 注意事項フラグ
  private String setItem1Flg = "0";
  
  // 検品時／ピッキング時注意事項
  private String setItem1 = "";
  
  // 同梱品フラグ
  private String setItem2Flg = "0";
  
  // 同梱品情報
  private String setItem2 = "";
  
  private boolean loginFlg = false;
  
  // 帳簿在庫表示フラグ
  private String realAmountFlg = "0";
  
  // カテゴリ名
  private String ctgryName = "";
  
  //EDBTG003-00 elecs-matsushima add start
  // 画像タイトル６
  private String imageName6 = "";
  
  // 画像タイトル７
  private String imageName7 = "";
  
  // 画像タイトル８
  private String imageName8 = "";
  
  // 画像タイトル９
  private String imageName9 = "";
  
  // 画像タイトル１０
  private String imageName10 = "";
  
  // 画像タイトル１１
  private String imageName11 = "";
  //EDBTG003-00 elecs-matsushima add end
  
  // キャッチコピー
  private String catchcopy = "";
  // 仕様
  private String specification = "";
  // 有効成分
  private String activeingredient = "";
  // 全成分
  private String component = "";
  // 注意事項
  private String precaution = "";
  // その他
  private String othernotice = "";

  public UIIndividual() {}
  
  public void setPageNumberTxt(String lPageNumberTxt) {
    if (SIUtil.isNull(lPageNumberTxt)) lPageNumberTxt = "1";
    this.pageNumberTxt = SIUtil.changeTo(lPageNumberTxt.trim(), this.encode);
  }
  
  public String getPageNumberTxt() {
    return this.pageNumberTxt;
  }
  
  /**
   * @return amount を戻します。
   */
  public String getAmount() {
    return amount;
  }
  
  /**
   * @param amount amount を設定。
   */
  public void setAmount(String amount) {
    if (SIUtil.isNull(amount)) amount = "";
    this.amount = amount;
  }
  
  /**
   * @return branchName を戻します。
   */
  public String getBranchName() {
    return branchName;
  }
  
  /**
   * @param branchName branchName を設定。
   */
  public void setBranchName(String branchName) {
    if (SIUtil.isNull(branchName)) branchName = "";
    this.branchName = branchName;
  }
  
  /**
   * @return adviceDisporder を戻します。
   */
  public String getAdviceDispOrder() {
    return adviceDispOrder;
  }
  
  /**
   * @param adviceDisporder adviceDisporder を設定。
   */
  public void setAdviceDispOrder(String adviceDisporder) {
    if (SIUtil.isNull(adviceDisporder)) adviceDisporder = "";
    this.adviceDispOrder = adviceDisporder;
  }
  
  /**
   * @return amountFlg を戻します。
   */
  public String getAmountFlg() {
    return amountFlg;
  }
  
  /**
   * @param amountFlg amountFlg を設定。
   */
  public void setAmountFlg(String amountFlg) {
    if (SIUtil.isNull(amountFlg)) amountFlg = "";
    this.amountFlg = amountFlg;
  }
  
  /**
   * @return arrivalDate を戻します。
   */
  public String getArrivalDate() {
    return arrivalDate;
  }
  
  /**
   * @param arrivalDate arrivalDate を設定。
   */
  public void setArrivalDate(String arrivalDate) {
    if (SIUtil.isNull(arrivalDate)) arrivalDate = "";
    this.arrivalDate = arrivalDate;
  }
  
  /**
   * @return bgPrice を戻します。
   */
  public String getBgPrice() {
    return bgPrice;
  }
  
  /**
   * @return bgPriceWithoutTax を戻します。
   */
  public String getBgPriceWithoutTax() {
    return bgPriceWithoutTax;
  }
  
  /**
   * @param bgPrice bgPrice を設定。
   */
  public void setBgPrice(String bgPrice) {
    if (SIUtil.isNull(bgPrice)) bgPrice = "";
    this.bgPrice = bgPrice;
  }
  
  /**
   * @param bgPriceWithoutTax bgPriceWithoutTax を設定。
   */
  public void setBgPriceWithoutTax(String bgPriceWithoutTax) {
    if (SIUtil.isNull(bgPriceWithoutTax)) bgPriceWithoutTax = "";
    this.bgPriceWithoutTax = bgPriceWithoutTax;
  }
  
  /**
   * @return bgPriceDispFlg を戻します。
   */
  public String getBgPriceDispFlg() {
    return bgPriceDispFlg;
  }
  
  /**
   * @param bgPriceDispFlg bgPriceDispFlg を設定。
   */
  public void setBgPriceDispFlg(String bgPriceDispFlg) {
    if (SIUtil.isNull(bgPriceDispFlg)) bgPriceDispFlg = "";
    this.bgPriceDispFlg = bgPriceDispFlg;
  }
  
  /**
   * @return campaignPriceFlg を戻します。
   */
  public String getCampaignPriceFlg() {
    return campaignPriceFlg;
  }
  
  /**
   * @param campaignPriceFlg campaignPriceFlg を設定。
   */
  public void setCampaignPriceFlg(String campaignPriceFlg) {
    if (SIUtil.isNull(campaignPriceFlg)) campaignPriceFlg = "";
    this.campaignPriceFlg = campaignPriceFlg;
  }
  
  /**
   * @return cmdtyCode を戻します。
   */
  public String getCmdtyCode() {
    return cmdtyCode;
  }
  
  /**
   * @param cmdtyCode cmdtyCode を設定。
   */
  public void setCmdtyCode(String cmdtyCode) {
    if (SIUtil.isNull(cmdtyCode)) cmdtyCode = "";
    this.cmdtyCode = cmdtyCode;
  }
  
  /**
   * @return colorCode を戻します。
   */
  public String getColorCode() {
    return colorCode;
  }
  
  /**
   * @param colorCode colorCode を設定。
   */
  public void setColorCode(String colorCode) {
    if (SIUtil.isNull(colorCode)) colorCode = "";
    this.colorCode = colorCode;
  }
  
  /**
   * @return comment を戻します。
   */
  public String getComment() {
    return comment;
  }
  
  /**
   * @param comment comment を設定。
   */
  public void setComment(String comment) {
    if (SIUtil.isNull(comment)) comment = "";
    this.comment = comment;
  }
  
  /**
   * @return commodityBannerFile を戻します。
   */
  public String getCommodityBannerFile() {
    return commodityBannerFile;
  }
  
  /**
   * @param commodityBannerFile commodityBannerFile を設定。
   */
  public void setCommodityBannerFile(String commodityBannerFile) {
    if (SIUtil.isNull(commodityBannerFile)) commodityBannerFile = "";
    this.commodityBannerFile = commodityBannerFile;
  }
  
  /**
   * @return consignGoodsFlg を戻します。
   */
  public String getConsignGoodsFlg() {
    return consignGoodsFlg;
  }
  
  /**
   * @param consignGoodsFlg consignGoodsFlg を設定。
   */
  public void setConsignGoodsFlg(String consignGoodsFlg) {
    if (SIUtil.isNull(consignGoodsFlg)) consignGoodsFlg = "";
    this.consignGoodsFlg = consignGoodsFlg;
  }
  
  /**
   * @return consignmentMemo を戻します。
   */
  public String getConsignmmentMemo() {
    return consignmentMemo;
  }
  
  /**
   * @param consignmentMemo consignmmentMemo を設定。
   */
  public void setConsignmentMemo(String consignmmentMemo) {
    if (SIUtil.isNull(consignmmentMemo)) consignmmentMemo = "";
    this.consignmentMemo = consignmmentMemo;
  }
  
  /**
   * @return custCode を戻します。
   */
  public String getCustCode() {
    return custCode;
  }
  
  /**
   * @param custCode custCode を設定。
   */
  public void setCustCode(String custCode) {
    if (SIUtil.isNull(custCode)) custCode = "";
    this.custCode = custCode;
  }
  
  /**
   * @return custName を戻します。
   */
  public String getCustName() {
    return custName;
  }
  
  /**
   * @param custName custName を設定。
   */
  public void setCustName(String custName) {
    if (SIUtil.isNull(custName)) custName = "";
    this.custName = custName;
  }
  
  /**
   * @return discountFlg を戻します。
   */
  public String getDiscountFlg() {
    return discountFlg;
  }
  
  /**
   * @param discountFlg discountFlg を設定。
   */
  public void setDiscountFlg(String discountFlg) {
    if (SIUtil.isNull(discountFlg)) discountFlg = "";
    this.discountFlg = discountFlg;
  }
  
  /**
   * @return endSellFlg を戻します。
   */
  public String getEndSellFlg() {
    return endSellFlg;
  }
  
  /**
   * @param endSellFlg endSellFlg を設定。
   */
  public void setEndSellFlg(String endSellFlg) {
    if (SIUtil.isNull(endSellFlg)) endSellFlg = "";
    this.endSellFlg = endSellFlg;
  }
  
  /**
   * @return frontDispFlg を戻します。
   */
  public String getFrontDispFlg() {
    return frontDispFlg;
  }
  
  /**
   * @param frontDispFlg frontDispFlg を設定。
   */
  public void setFrontDispFlg(String frontDispFlg) {
    if (SIUtil.isNull(frontDispFlg)) frontDispFlg = "";
    this.frontDispFlg = frontDispFlg;
  }
  
  /**
   * @return guaranteedTerm を戻します。
   */
  public String getGuaranteedTerm() {
    return guaranteedTerm;
  }
  
  /**
   * @param guaranteedTerm guaranteedTerm を設定。
   */
  public void setGuaranteedTerm(String guaranteedTerm) {
    if (SIUtil.isNull(guaranteedTerm)) guaranteedTerm = "";
    this.guaranteedTerm = guaranteedTerm;
  }
  
  /**
   * @return imageName1 を戻します。
   */
  public String getImageName1() {
    return imageName1;
  }
  
  /**
   * @param imageName1 imageName1 を設定。
   */
  public void setImageName1(String imageName1) {
    if (SIUtil.isNull(imageName1)) imageName1 = "";
    this.imageName1 = imageName1;
  }
  
  /**
   * @return imageName2 を戻します。
   */
  public String getImageName2() {
    return imageName2;
  }
  
  /**
   * @param imageName2 imageName2 を設定。
   */
  public void setImageName2(String imageName2) {
    if (SIUtil.isNull(imageName2)) imageName2 = "";
    this.imageName2 = imageName2;
  }
  
  /**
   * @return imageName3 を戻します。
   */
  public String getImageName3() {
    return imageName3;
  }
  
  /**
   * @param imageName3 imageName3 を設定。
   */
  public void setImageName3(String imageName3) {
    if (SIUtil.isNull(imageName3)) imageName3 = "";
    this.imageName3 = imageName3;
  }
  
  /**
   * @return imageName4 を戻します。
   */
  public String getImageName4() {
    return imageName4;
  }
  
  /**
   * @param imageName4 imageName4 を設定。
   */
  public void setImageName4(String imageName4) {
    if (SIUtil.isNull(imageName4)) imageName4 = "";
    this.imageName4 = imageName4;
  }
  
  /**
   * @return imageName5 を戻します。
   */
  public String getImageName5() {
    return imageName5;
  }
  
  /**
   * @param imageName5 imageName5 を設定。
   */
  public void setImageName5(String imageName5) {
    if (SIUtil.isNull(imageName5)) imageName5 = "";
    this.imageName5 = imageName5;
  }
  
  /**
   * @return imageNamet を戻します。
   */
  public String getImageNamet() {
    return imageNamet;
  }
  
  /**
   * @param imageNamet imageNamet を設定。
   */
  public void setImageNamet(String imageNamet) {
    if (SIUtil.isNull(imageNamet)) imageNamet = "";
    this.imageNamet = imageNamet;
  }
  
  /**
   * @return individualCode を戻します。
   */
  public String getIndividualCode() {
    return individualCode;
  }
  
  /**
   * @param individualCode individualCode を設定。
   */
  public void setIndividualCode(String individualCode) {
    if (SIUtil.isNull(individualCode)) individualCode = "";
    this.individualCode = individualCode;
  }
  
  /**
   * @return initDateTime を戻します。
   */
  public String getInitDateTime() {
    return initDateTime;
  }
  
  /**
   * @param initDateTime initDateTime を設定。
   */
  public void setInitDateTime(String initDateTime) {
    if (SIUtil.isNull(initDateTime)) initDateTime = "";
    this.initDateTime = initDateTime;
  }
  
  /**
   * @return inquiryFlg を戻します。
   */
  public String getInquiryFlg() {
    return inquiryFlg;
  }
  
  /**
   * @param inquiryFlg inquiryFlg を設定。
   */
  public void setInquiryFlg(String inquiryFlg) {
    if (SIUtil.isNull(inquiryFlg)) inquiryFlg = "";
    this.inquiryFlg = inquiryFlg;
  }
  
  /**
   * @return newFixedPrice を戻します。
   */
  public String getNewFixedPrice() {
    return newFixedPrice;
  }
  
  /**
   * @param newFixedPrice newFixedPrice を設定。
   */
  public void setNewFixedPrice(String newFixedPrice) {
    if (SIUtil.isNull(newFixedPrice)) newFixedPrice = "";
    this.newFixedPrice = newFixedPrice;
  }
  
  /**
   * @return noStockFlg を戻します。
   */
  public String getNoStockFlg() {
    return noStockFlg;
  }
  
  /**
   * @param noStockFlg noStockFlg を設定。
   */
  public void setNoStockFlg(String noStockFlg) {
    if (SIUtil.isNull(noStockFlg)) noStockFlg = "";
    this.noStockFlg = noStockFlg;
  }
  
  /**
   * @return processingExpence を戻します。
   */
  public String getProcessingExpence() {
    return processingExpence;
  }
  
  /**
   * @param processingExpence processingExpence を設定。
   */
  public void setProcessingExpence(String processingExpence) {
    if (SIUtil.isNull(processingExpence)) processingExpence = "";
    this.processingExpence = processingExpence;
  }
  
  /**
   * @return purchasePrice を戻します。
   */
  public String getPurchasePrice() {
    return purchasePrice;
  }
  
  /**
   * @param purchasePrice purchasePrice を設定。
   */
  public void setPurchasePrice(String purchasePrice) {
    if (SIUtil.isNull(purchasePrice)) purchasePrice = "";
    this.purchasePrice = purchasePrice;
  }
  
  /**
   * @return recommendationFlg を戻します。
   */
  public String getRecommendationFlg() {
    return recommendationFlg;
  }
  
  /**
   * @param recommendationFlg recommendationFlg を設定。
   */
  public void setRecommendationFlg(String recommendationFlg) {
    if (SIUtil.isNull(recommendationFlg)) recommendationFlg = "";
    this.recommendationFlg = recommendationFlg;
  }
  
  /**
   * @return remarks を戻します。
   */
  public String getRemarks() {
    return remarks;
  }
  
  /**
   * @param remarks remarks を設定。
   */
  public void setRemarks(String remarks) {
    if (SIUtil.isNull(remarks)) remarks = "";
    this.remarks = remarks;
  }
  
  /**
   * @return rsrvAmount を戻します。
   */
  public String getRsrvAmount() {
    return rsrvAmount;
  }
  
  /**
   * @param rsrvAmount rsrvAmount を設定。
   */
  public void setRsrvAmount(String rsrvAmount) {
    if (SIUtil.isNull(rsrvAmount)) rsrvAmount = "";
    this.rsrvAmount = rsrvAmount;
  }
  
  /**
   * @return rsrvEnableFlg を戻します。
   */
  public String getRsrvEnableFlg() {
    return rsrvEnableFlg;
  }
  
  /**
   * @param rsrvEnableFlg rsrvEnableFlg を設定。
   */
  public void setRsrvEnableFlg(String rsrvEnableFlg) {
    if (SIUtil.isNull(rsrvEnableFlg)) rsrvEnableFlg = "";
    this.rsrvEnableFlg = rsrvEnableFlg;
  }
  
  /**
   * @return salesDiscountFlg を戻します。
   */
  public String getSalesDiscountFlg() {
    return salesDiscountFlg;
  }
  
  /**
   * @param salesDiscountFlg salesDiscountFlg を設定。
   */
  public void setSalesDiscountFlg(String salesDiscountFlg) {
    if (SIUtil.isNull(salesDiscountFlg)) salesDiscountFlg = "";
    this.salesDiscountFlg = salesDiscountFlg;
  }
  
  /**
   * @return salesFromdate を戻します。
   */
  public String getSalesFromdate() {
    return salesFromdate;
  }
  
  /**
   * @param salesFromdate salesFromdate を設定。
   */
  public void setSalesFromdate(String salesFromdate) {
    if (SIUtil.isNull(salesFromdate)) salesFromdate = "";
    this.salesFromdate = salesFromdate;
  }
  
  /**
   * @return salesSituationFlg を戻します。
   */
  public String getSalesSituationFlg() {
    return salesSituationFlg;
  }
  
  /**
   * @param salesSituationFlg salesSituationFlg を設定。
   */
  public void setSalesSituationFlg(String salesSituationFlg) {
    if (SIUtil.isNull(salesSituationFlg)) salesSituationFlg = "";
    this.salesSituationFlg = salesSituationFlg;
  }
  
  /**
   * @return salesToDate を戻します。
   */
  public String getSalesToDate() {
    return salesToDate;
  }
  
  /**
   * @param salesToDate salesToDate を設定。
   */
  public void setSalesToDate(String salesToDate) {
    if (SIUtil.isNull(salesToDate)) salesToDate = "";
    this.salesToDate = salesToDate;
  }
  
  /**
   * @return sellFromDate を戻します。
   */
  public String getSellFromDate() {
    return sellFromDate;
  }
  
  /**
   * @param sellFromDate sellFromDate を設定。
   */
  public void setSellFromDate(String lsellFromDate) {
    if (SIUtil.isNull(lsellFromDate)) this.sellFromDate = "";
    else this.sellFromDate = lsellFromDate;
  }
  
  /**
   * @return sellToDate を戻します。
   */
  public String getSellToDate() {
    return sellToDate;
  }
  
  /**
   * @param sellToDate sellToDate を設定。
   */
  public void setSellToDate(String lsellToDate) {
    if (SIUtil.isNull(lsellToDate)) this.sellToDate = "";
    else this.sellToDate = lsellToDate;
  }
  
  /**
   * @return shopCode を戻します。
   */
  public String getShopCode() {
    return shopCode;
  }
  
  /**
   * @param shopCode shopCode を設定。
   */
  public void setShopCode(String shopCode) {
    if (SIUtil.isNull(shopCode)) shopCode = "";
    this.shopCode = shopCode;
  }
  
  /**
   * @return soldOutDate を戻します。
   */
  public String getSoldOutDate() {
    return soldOutDate;
  }
  
  /**
   * @param soldOutDate soldOutDate を設定。
   */
  public void setSoldOutDate(String soldOutDate) {
    if (SIUtil.isNull(soldOutDate)) soldOutDate = "";
    this.soldOutDate = soldOutDate;
  }
  
  /**
   * @return soldOutDispFlg を戻します。
   */
  public String getSoldOutDispFlg() {
    return soldOutDispFlg;
  }
  
  /**
   * @param soldOutDispFlg soldOutDispFlg を設定。
   */
  public void setSoldOutDispFlg(String soldOutDispFlg) {
    if (SIUtil.isNull(soldOutDispFlg)) soldOutDispFlg = "";
    this.soldOutDispFlg = soldOutDispFlg;
  }
  
  /**
   * @return specialPrice を戻します。
   */
  public String getSpecialPrice() {
    return specialPrice;
  }
  
  /**
   * @param specialPrice specialPrice を設定。
   */
  public void setSpecialPrice(String specialPrice) {
    if (SIUtil.isNull(specialPrice)) specialPrice = "";
    this.specialPrice = specialPrice;
  }
  
  /**
   * @return stockCode を戻します。
   */
  public String getStockCode() {
    return stockCode;
  }
  
  /**
   * @param stockCode stockCode を設定。
   */
  public void setStockCode(String stockCode) {
    if (SIUtil.isNull(stockCode)) stockCode = "";
    this.stockCode = stockCode;
  }
  
  /**
   * @return stockStatusCode を戻します。
   */
  public String getStockStatusCode() {
    return stockStatusCode;
  }
  
  /**
   * @param stockStatusCode stockStatusCode を設定。
   */
  public void setStockStatusCode(String stockStatusCode) {
    if (SIUtil.isNull(stockStatusCode)) stockStatusCode = "";
    this.stockStatusCode = stockStatusCode;
  }
  
  /**
   * @return tenureofuse を戻します。
   */
  public String getTenureofuse() {
    return tenureofuse;
  }
  
  /**
   * @param tenureofuse tenureofuse を設定。
   */
  public void setTenureofuse(String tenureofuse) {
    if (SIUtil.isNull(tenureofuse)) tenureofuse = "";
    this.tenureofuse = tenureofuse;
  }
  
  /**
   * @return usedNewFlg を戻します。
   */
  public String getUsedNewFlg() {
    return usedNewFlg;
  }
  
  /**
   * @param usedNewFlg usedNewFlg を設定。
   */
  public void setUsedNewFlg(String usedNewFlg) {
    if (SIUtil.isNull(usedNewFlg)) usedNewFlg = "";
    this.usedNewFlg = usedNewFlg;
  }
  
  /**
   * @return wrappingFlg を戻します。
   */
  public String getWrappingFlg() {
    return wrappingFlg;
  }
  
  /**
   * @param wrappingFlg wrappingFlg を設定。
   */
  public void setWrappingFlg(String wrappingFlg) {
    if (SIUtil.isNull(wrappingFlg)) wrappingFlg = "";
    this.wrappingFlg = wrappingFlg;
  }
  
  /**
   * @return arrivalYear を戻します。
   */
  public String getArrivalYear() {
    return arrivalYear;
  }
  
  /**
   * @param arrivalYear arrivalYear を設定。
   */
  public void setArrivalYear(String arrivalYear) {
    if (SIUtil.isNull(arrivalYear)) arrivalYear = "";
    this.arrivalYear = arrivalYear;
  }
  
  /**
   * @return commodityExplanation を戻します。
   */
  public String getCommodityExplanation() {
    return commodityExplanation;
  }
  
  /**
   * @param commodityExplanation commodityExplanation を設定。
   */
  public void setCommodityExplanation(String commodityExplanation) {
    if (SIUtil.isNull(commodityExplanation)) commodityExplanation = "";
    this.commodityExplanation = commodityExplanation;
  }
  
  /**
   * @return consignmentMemo を戻します。
   */
  public String getConsignmentMemo() {
    return consignmentMemo;
  }
  
  /**
   * @return arrivalDay を戻します。
   */
  public String getArrivalDay() {
    return arrivalDay;
  }
  
  /**
   * @param arrivalDay arrivalDay を設定。
   */
  public void setArrivalDay(String arrivalDay) {
    if (SIUtil.isNull(arrivalDay)) arrivalDay = "";
    this.arrivalDay = arrivalDay;
  }
  
  /**
   * @return arrivalMonth を戻します。
   */
  public String getArrivalMonth() {
    return arrivalMonth;
  }
  
  /**
   * @param arrivalMonth arrivalMonth を設定。
   */
  public void setArrivalMonth(String arrivalMonth) {
    if (SIUtil.isNull(arrivalMonth)) arrivalMonth = "";
    this.arrivalMonth = arrivalMonth;
  }
  
  /**
   * @return memberDiscountFlg を戻します。
   */
  public String getMemberDiscountFlg() {
    return memberDiscountFlg;
  }
  
  /**
   * @param memberDiscountFlg memberDiscountFlg を設定。
   */
  public void setMemberDiscountFlg(String memberDiscountFlg) {
    if (SIUtil.isNull(memberDiscountFlg)) memberDiscountFlg="0";
    this.memberDiscountFlg = memberDiscountFlg;
  }
  
  /**
   * @return sellFromDateDay を戻します。
   */
  public String getSellFromDateDay() {
    return sellFromDateDay;
  }
  
  /**
   * @param sellFromDateDay sellFromDateDay を設定。
   */
  public void setSellFromDateDay(String sellFromDateDay) {
    if (SIUtil.isNull(sellFromDateDay)) sellFromDateDay = "";
    this.sellFromDateDay = sellFromDateDay;
  }
  
  /**
   * @return sellFromDateMonth を戻します。
   */
  public String getSellFromDateMonth() {
    return sellFromDateMonth;
  }
  
  /**
   * @param sellFromDateMonth sellFromDateMonth を設定。
   */
  public void setSellFromDateMonth(String sellFromDateMonth) {
    if (SIUtil.isNull(sellFromDateMonth)) sellFromDateMonth = "";
    this.sellFromDateMonth = sellFromDateMonth;
  }
  
  /**
   * @return sellFromDateYear を戻します。
   */
  public String getSellFromDateYear() {
    return sellFromDateYear;
  }
  
  /**
   * @param sellFromDateYear sellFromDateYear を設定。
   */
  public void setSellFromDateYear(String sellFromDateYear) {
    if (SIUtil.isNull(sellFromDateYear)) sellFromDateYear = "";
    this.sellFromDateYear = sellFromDateYear;
  }
  
  /**
   * @return sellToDateDay を戻します。
   */
  public String getSellToDateDay() {
    return sellToDateDay;
  }
  
  /**
   * @param sellToDateDay sellToDateDay を設定。
   */
  public void setSellToDateDay(String sellToDateDay) {
    if (SIUtil.isNull(sellToDateDay)) sellToDateDay = "";
    this.sellToDateDay = sellToDateDay;
  }
  
  /**
   * @return sellToDateMonth を戻します。
   */
  public String getSellToDateMonth() {
    return sellToDateMonth;
  }
  
  /**
   * @param sellToDateMonth sellToDateMonth を設定。
   */
  public void setSellToDateMonth(String sellToDateMonth) {
    if (SIUtil.isNull(sellToDateMonth)) sellToDateMonth = "";
    this.sellToDateMonth = sellToDateMonth;
  }
  
  /**
   * @return sellToDateYear を戻します。
   */
  public String getSellToDateYear() {
    return sellToDateYear;
  }
  
  /**
   * @param sellToDateYear sellToDateYear を設定。
   */
  public void setSellToDateYear(String sellToDateYear) {
    if (SIUtil.isNull(sellToDateYear)) sellToDateYear = "";
    this.sellToDateYear = sellToDateYear;
  }
  
  /**
   * @return firstDispFlg を戻します。
   */
  public String getFirstDispFlg() {
    return firstDispFlg;
  }
  
  /**
   * @param firstDispFlg firstDispFlg を設定。
   */
  public void setFirstDispFlg(String firstDispFlg) {
    if (SIUtil.isNull(firstDispFlg)) firstDispFlg = "";
    this.firstDispFlg = firstDispFlg;
  }
  
  /**
   * @return deleteFlg を戻します。
   */
  public String getDeleteFlg() {
    return deleteFlg;
  }
  
  /**
   * @param deleteFlg deleteFlg を設定。
   */
  public void setDeleteFlg(String deleteFlg) {
    if (SIUtil.isNull(deleteFlg)) deleteFlg = "";
    this.deleteFlg = deleteFlg;
  }
  
  /**
   * @return individual1 を戻します。
   */
  public String getIndividual1() {
    return individual1;
  }
  
  /**
   * @return individual2 を戻します。
   */
  public String getIndividual2() {
    return individual2;
  }
  
  /**
   * @return individual3 を戻します。
   */
  public String getIndividual3() {
    return individual3;
  }
  
  /**
   * @param individual1 individual1 を設定。
   */
  public void setIndividual1(String individual1) {
    if (SIUtil.isNull(individual1)) individual1 = "";
    this.individual1 = individual1;
  }
  
  /**
   * @param individual2 individual2 を設定。
   */
  public void setIndividual2(String individual2) {
    if (SIUtil.isNull(individual2)) individual2 = "";
    this.individual2 = individual2;
  }
  
  /**
   * @param individual3 individual3 を設定。
   */
  public void setIndividual3(String individual3) {
    if (SIUtil.isNull(individual3)) individual3 = "";
    this.individual3 = individual3;
  }
  
  public String getNomalPrice() {
    return nomalPrice;
  }
  
  public void setNomalPrice(String nomalPrice) {
    if (SIUtil.isNull(nomalPrice)) nomalPrice = "";
    this.nomalPrice = nomalPrice;
  }
  
  public String getSpCampaignFlg() {
    return spCampaignFlg;
  }
  
  public void setSpCampaignFlg(String spCampaignFlg) {
    if (SIUtil.isNull(spCampaignFlg)) spCampaignFlg = "";
    this.spCampaignFlg = spCampaignFlg;
  }
  
  public String getAlertAmount() {
    return alertAmount;
  }
  
  public void setAlertAmount(String alertAmount) {
    if (SIUtil.isNull(alertAmount)) alertAmount = "";
    this.alertAmount = alertAmount;
  }
  
  /**
   * @return cmdtyName を戻します。
   */
  public String getCmdtyName() {
    return cmdtyName;
  }
  
  /**
   * @param cmdtyName cmdtyName を設定。
   */
  public void setCmdtyName(String cmdtyName) {
    if (SIUtil.isNull(cmdtyName)) cmdtyName = "";
    this.cmdtyName = cmdtyName;
  }
  
  /**
   * @return shipAmount を戻します。
   */
  public String getShipAmount() {
    return shipAmount;
  }
  
  /**
   * @param shipAmount shipAmount を設定。
   */
  public void setShipAmount(String shipAmount) {
    if (SIUtil.isNull(shipAmount)) shipAmount = "";
    this.shipAmount = shipAmount;
  }
  
  /**
   * @return storeAmount を戻します。
   */
  public String getStoreAmount() {
    return storeAmount;
  }
  
  /**
   * @param storeAmount storeAmount を設定。
   */
  public void setStoreAmount(String storeAmount) {
    if (SIUtil.isNull(storeAmount)) storeAmount = "";
    this.storeAmount = storeAmount;
  }
  
  /**
   * @return price を戻します。
   */
  public String getPrice() {
    return price;
  }
  
  /**
   * @param price price を設定。
   */
  public void setPrice(String price) {
    if (SIUtil.isNull(price)) price = "";
    this.price = price;
  }
  
  public String getRealAmount() {
    return realAmount;
  }
  
  public void setRealAmount(String realAmount) {
    if (SIUtil.isNull(realAmount)) realAmount = "";
    this.realAmount = realAmount;
  }
  
  public String getPurchasePrice2() {
    return purchasePrice2;
  }
  
  public void setPurchasePrice2(String purchasePrice2) {
    if (SIUtil.isNull(purchasePrice2)) purchasePrice2 = "";
    this.purchasePrice2 = purchasePrice2;
  }
  
  // getter of arrivalScheduleMsg
  public String getArrivalScheduleMsg() {
    return this.arrivalScheduleMsg;
  }
  
  // setter of arrivalScheduleMsg
  public void setArrivalScheduleMsg(String arrivalScheduleMsg) {
    if (SIUtil.isNull(arrivalScheduleMsg)) arrivalScheduleMsg = "";
    this.arrivalScheduleMsg = SIUtil.changeTo(arrivalScheduleMsg.trim(), this.encode);
  }
  
  // getter of loginFlg
  public boolean isLoginFlg() {
    return this.loginFlg;
  }
  
  // setter of loginFlg
  public void setLoginFlg(boolean loginFlg) {
    this.loginFlg = loginFlg;
  }
  
  //getter of janCodeIndividual
  public String getJanCodeIndividual() {
    return this.janCodeIndividual;
  }
  
  //setter of janCodeIndividual
  public void setJanCodeIndividual(String janCodeIndividual) {
    if (SIUtil.isNull(janCodeIndividual)) janCodeIndividual = "";
    this.janCodeIndividual = SIUtil.changeTo(janCodeIndividual.trim(), this.encode);
  }
  
  //getter of searchIndividualCodeTxt
  public String getSearchIndividualCodeTxt() {
    return this.searchIndividualCodeTxt;
  }
  
  //setter of searchIndividualCodeTxt
  public void setSearchIndividualCodeTxt(String searchIndividualCodeTxt) {
    if (SIUtil.isNull(searchIndividualCodeTxt)) searchIndividualCodeTxt = "";
    this.searchIndividualCodeTxt = SIUtil.changeTo(searchIndividualCodeTxt.trim(), this.encode);
  }
  
  public String getConsignGoodsFee() {
    return consignGoodsFee;
  }
  
  public void setConsignGoodsFee(String consignGoodsFee) {
    if (SIUtil.isNull(consignGoodsFee)) consignGoodsFee = "0";
    this.consignGoodsFee = consignGoodsFee;
  }
  
  public String getPriceDownFlg() {
    return priceDownFlg;
  }
  
  public void setPriceDownFlg(String priceDownFlg) {
    if (SIUtil.isNull(priceDownFlg)) priceDownFlg = "0";
    this.priceDownFlg = priceDownFlg;
  }
  
  public String getExpansionComment1Text() {
    return expansionComment1Text;
  }
  
  public void setExpansionComment1Text(String expansionComment1Text) {
    if (SIUtil.isNull(expansionComment1Text)) expansionComment1Text = "";
    this.expansionComment1Text = expansionComment1Text;
  }
  
  public String getExpansionComment1Title() {
    return expansionComment1Title;
  }
  
  public void setExpansionComment1Title(String expansionComment1Title) {
    if (SIUtil.isNull(expansionComment1Title)) expansionComment1Title = "";
    this.expansionComment1Title = expansionComment1Title;
  }
  
  public String getExpansionComment2Text() {
    return expansionComment2Text;
  }
  
  public void setExpansionComment2Text(String expansionComment2Text) {
    if (SIUtil.isNull(expansionComment2Text)) expansionComment2Text = "";
    this.expansionComment2Text = expansionComment2Text;
  }
  
  public String getExpansionComment2Title() {
    return expansionComment2Title;
  }
  
  public void setExpansionComment2Title(String expansionComment2Title) {
    if (SIUtil.isNull(expansionComment2Title)) expansionComment2Title = "";
    this.expansionComment2Title = expansionComment2Title;
  }
  
  public String getExpansionComment3Text() {
    return expansionComment3Text;
  }
  
  public void setExpansionComment3Text(String expansionComment3Text) {
    if (SIUtil.isNull(expansionComment3Text)) expansionComment3Text = "";
    this.expansionComment3Text = expansionComment3Text;
  }
  
  public String getExpansionComment3Title() {
    return expansionComment3Title;
  }
  
  public void setExpansionComment3Title(String expansionComment3Title) {
    if (SIUtil.isNull(expansionComment3Title)) expansionComment3Title = "";
    this.expansionComment3Title = expansionComment3Title;
  }
  
  public String getExpansionComment4Text() {
    return expansionComment4Text;
  }
  
  public void setExpansionComment4Text(String expansionComment4Text) {
    if (SIUtil.isNull(expansionComment4Text)) expansionComment4Text = "";
    this.expansionComment4Text = expansionComment4Text;
  }
  
  public String getExpansionComment4Title() {
    return expansionComment4Title;
  }
  
  public void setExpansionComment4Title(String expansionComment4Title) {
    if (SIUtil.isNull(expansionComment4Title)) expansionComment4Title = "";
    this.expansionComment4Title = expansionComment4Title;
  }
  
  //EDBTG005-00 kamata add start
  public String getExpansionComment5Title() {
    return expansionComment5Title;
  }
  
  public void setExpansionComment5Title(String expansionComment5Title) {
    if (SIUtil.isNull(expansionComment5Title)) expansionComment5Title = "";
    this.expansionComment5Title = expansionComment5Title;
  }
  
  public String getExpansionComment5Text() {
    return expansionComment5Text;
  }
  
  public void setExpansionComment5Text(String expansionComment5Text) {
    if (SIUtil.isNull(expansionComment5Text)) expansionComment5Text = "";
    this.expansionComment5Text = expansionComment5Text;
  }
  //EDBTG005-00 kamata add end
  
  public String getRealAmountFlg() {
    return realAmountFlg;
  }
  
  public void setRealAmountFlg(String realAmountFlg) {
    if (SIUtil.isNull(realAmountFlg)) realAmountFlg = "0";
    this.realAmountFlg = realAmountFlg;
  }
  
  public String getCtgryName() {
    return ctgryName;
  }
  
  public void setCtgryName(String ctgryName) {
    if (SIUtil.isNull(ctgryName)) ctgryName = "";
    this.ctgryName = ctgryName;
  }
  
  public String getSetItem1Flg() {
    return setItem1Flg;
  }
  
  public void setSetItem1Flg(String setItem1Flg) {
    if (SIUtil.isNull(setItem1Flg)) setItem1Flg = "0";
    this.setItem1Flg = setItem1Flg;
  }
  
  public String getSetItem1() {
    return setItem1;
  }
  
  public void setSetItem1(String setItem1) {
    if (SIUtil.isNull(setItem1)) setItem1 = "";
    this.setItem1 = setItem1;
  }
  
  public String getSetItem2Flg() {
    return setItem2Flg;
  }
  
  public void setSetItem2Flg(String setItem2Flg) {
    if (SIUtil.isNull(setItem2Flg)) setItem2Flg = "0";
    this.setItem2Flg = setItem2Flg;
  }
  
  public String getSetItem2() {
    return setItem2;
  }
  
  public void setSetItem2(String setItem2) {
    if (SIUtil.isNull(setItem2)) setItem2 = "";
    this.setItem2 = setItem2;
  }
  
  /**
   * <b>init</b> 入力したデータを基づいて、このbeansを設定します。
   * 
   * @param request クライアントからリクエスト
   * @param lUrlParam
   * @return なし
   * @throws なし
   */
  public void init(HttpServletRequest lRequest, SIURLParameter lUrlParam) {
    this.setShopCode((String) lUrlParam.getParam("shopCode"));
    this.setCmdtyCode((String) lUrlParam.getParam("cmdtyCode"));
    this.setConsignGoodsFlg((String) lUrlParam.getParam("consignGoodsFlg"));
    if (SIUtil.isNull(this.getConsignGoodsFlg())) {
      this.setConsignGoodsFlg("0");
    }
    if (SIUtil.isNull((String) lUrlParam.getParam("individual1")) && SIUtil.isNull((String) lUrlParam.getParam("individual2"))) {
      this.setIndividualCode((String) lUrlParam.getParam("individualCode"));
    } else {
      this.setIndividual1((String) lUrlParam.getParam("individual1"));
      this.setIndividual2((String) lUrlParam.getParam("individual2"));
      this.setIndividual3((String) lUrlParam.getParam("individual3"));
      if (this.getConsignGoodsFlg().equals("1")) {
        this.setIndividual3(SIConfig.INDIVIDUALTAIL[SIConfig.INDIVIDUALTAIL_CONSIGN]);
      }
      this.setIndividualCode(this.individual1 + "-" + this.individual2 + this.individual3);
    }
    this.setUsedNewFlg((String) lUrlParam.getParam("usedNewFlg"));
    this.setArrivalYear((String) lUrlParam.getParam("arrivalYear"));
    this.setArrivalMonth((String) lUrlParam.getParam("arrivalMonth"));
    this.setArrivalDay((String) lUrlParam.getParam("arrivalDay"));
    this.setArrivalDate(SIDateTime.getDate(this.getArrivalYear(), this.getArrivalMonth(), this.getArrivalDay()));
    if (SIUtil.isNull((String) lUrlParam.getParam("processingExpence"))) this.setProcessingExpence("0");
    else this.setProcessingExpence((String) lUrlParam.getParam("processingExpence"));
    this.setTenureofuse((String) lUrlParam.getParam("tenureofuse"));
    this.setSalesSituationFlg((String) lUrlParam.getParam("salesSituationFlg"));
    this.setSoldOutDispFlg((String) lUrlParam.getParam("soldOutDispFlg"));
    if (SIUtil.isNull(this.getSoldOutDispFlg())) this.setSoldOutDispFlg("0");
    this.setCampaignPriceFlg((String) lUrlParam.getParam("campaignPriceFlg"));
    if (SIUtil.isNull(this.getCampaignPriceFlg())) this.setCampaignPriceFlg("0");
    this.setInquiryFlg((String) lUrlParam.getParam("inquiryFlg"));
    this.setCustCode((String) lUrlParam.getParam("custCode"));
    this.setCustName((String) lUrlParam.getParam("custName"));
    this.setComment((String) lUrlParam.getParam("comment"));
    this.setBgPriceDispFlg((String) lUrlParam.getParam("bgPriceDispFlg"));
    
    this.setConsignmentMemo((String) lUrlParam.getParam("consignmentMemo"));
    this.setCommodityExplanation((String) lUrlParam.getParam("commodityExplanation"));
    this.setStockCode((String) lUrlParam.getParam("stockCode"));
    this.setPurchasePrice((String) lUrlParam.getParam("purchasePrice"));
    String exercisePrice = (String) lUrlParam.getParam("exercisePrice");
    int purchasePrice = 0;// 7.3.0 PI-NES0501
    if (SIUtil.isNotNull(this.getPurchasePrice())) purchasePrice = Integer.parseInt(this.getPurchasePrice());
    int intexercisePrice = 0;// 7.3.0 PI-NES0501
    if (SIUtil.isNotNull(exercisePrice)) intexercisePrice = Integer.parseInt(exercisePrice);
    if (purchasePrice == 0 && intexercisePrice != 0) {// 7.3.0 PI-NES0501
      this.setPurchasePrice(exercisePrice);
    } else if (purchasePrice == 0 && intexercisePrice == 0) {
      this.setPurchasePrice("0");
    }
    this.setBgPrice((String) lUrlParam.getParam("bgPrice"));
    this.setBgPriceWithoutTax((String) lUrlParam.getParam("bgPriceWithoutTax"));
    this.setSpecialPrice((String) lUrlParam.getParam("specialPrice"));
    this.setRecommendationFlg((String) lUrlParam.getParam("recommendationFlg"));
    this.setCommodityBannerFile((String) lUrlParam.getParam("commodityBannerFile"));
    this.setMemberDiscountFlg((String) lUrlParam.getParam("memberDiscountFlg"));
    this.setSellFromDateYear((String) lUrlParam.getParam("sellFromDateYear"));
    this.setSellFromDateMonth((String) lUrlParam.getParam("sellFromDateMonth"));
    this.setSellFromDateDay((String) lUrlParam.getParam("sellFromDateDay"));
    this.setSellFromDate(SIDateTime.getDate(this.getSellFromDateYear(), this.getSellFromDateMonth(), this.getSellFromDateDay()));
    this.setEndSellFlg((String) lUrlParam.getParam("endSellFlg"));
    this.setSellToDateYear((String) lUrlParam.getParam("sellToDateYear"));
    this.setSellToDateMonth((String) lUrlParam.getParam("sellToDateMonth"));
    this.setSellToDateDay((String) lUrlParam.getParam("sellToDateDay"));
    this.setSellToDate(SIDateTime.getDate(this.getSellToDateYear(), this.getSellToDateMonth(), this.getSellToDateDay()));
    this.setSalesFromdate((String) lUrlParam.getParam("salesFromdate"));
    this.setSalesToDate((String) lUrlParam.getParam("salesToDate"));
    this.setRsrvEnableFlg((String) lUrlParam.getParam("rsrvEnableFlg"));
    this.setRsrvAmount((String) lUrlParam.getParam("rsrvAmount"));
    this.setNoStockFlg((String) lUrlParam.getParam("noStockFlg"));
    this.setStockStatusCode((String) lUrlParam.getParam("stockStatusCode"));
    this.setSoldOutDate((String) lUrlParam.getParam("soldOutDate"));
    this.setGuaranteedTerm((String) lUrlParam.getParam("guaranteedTerm"));
    this.setWrappingFlg((String) lUrlParam.getParam("wrappingFlg"));
    this.setDiscountFlg((String) lUrlParam.getParam("discountFlg"));
    this.setSalesDiscountFlg((String) lUrlParam.getParam("salesDiscountFlg"));
    this.setAdviceDispOrder((String) lUrlParam.getParam("adviceDispOrder"));
    this.setImageName1((String) lUrlParam.getParam("imageName1"));
    this.setImageName2((String) lUrlParam.getParam("imageName2"));
    this.setImageName3((String) lUrlParam.getParam("imageName3"));
    this.setImageName4((String) lUrlParam.getParam("imageName4"));
    this.setImageName5((String) lUrlParam.getParam("imageName5"));
    this.setImageName5((String) lUrlParam.getParam("imageNamet"));
    this.setRemarks((String) lUrlParam.getParam("remarks"));
    this.setInitDateTime((String) lUrlParam.getParam("initDateTime"));
    this.setSpCampaignFlg((String) lUrlParam.getParam("spCampaignFlg"));
    this.setNomalPrice((String) lUrlParam.getParam("nomalPrice"));
    this.setAlertAmount((String) lUrlParam.getParam("alertAmount"));
    this.setPurchasePrice2((String) lUrlParam.getParam("purchasePrice2"));
    this.setArrivalScheduleMsg((String) lUrlParam.getParam("arrivalScheduleMsg"));
    if (SIUtil.isNull(this.nomalPrice)) this.setNomalPrice((String) lUrlParam.getParam("nomalPriceHid"));
    if (SIUtil.isNull((String) lUrlParam.getParam("amountFlg")) && this.usedNewFlg.equals("4")) {
      this.setAmountFlg("1");
    } else if (SIUtil.isNull((String) lUrlParam.getParam("amountFlg")) && this.usedNewFlg.equals("5")) {
      this.setAmountFlg("0");
    } else if (SIUtil.isNull((String) lUrlParam.getParam("amountFlg")) && this.consignGoodsFlg.equals("1")) {
      this.setAmountFlg("1");
    } else {
      this.setAmountFlg((String) lUrlParam.getParam("amountFlg"));
    }
    if (SIUtil.isNull((String) lUrlParam.getParam("frontDispFlg"))) {
      this.setFrontDispFlg("0");
    } else {
      this.setFrontDispFlg((String) lUrlParam.getParam("frontDispFlg"));
    }
    this.setJanCodeIndividual((String) lUrlParam.getParam("janCodeIndividual"));
    this.setSearchIndividualCodeTxt((String) lUrlParam.getParam("searchIndividualCodeTxt"));
    this.setConsignGoodsFee((String) lUrlParam.getParam("consignGoodsFee"));
    this.setPriceDownFlg((String) lUrlParam.getParam("priceDownFlg"));
    this.setExpansionComment1Text((String) lUrlParam.getParam("expansionComment1Text"));
    this.setExpansionComment1Title((String) lUrlParam.getParam("expansionComment1Title"));
    this.setExpansionComment2Text((String) lUrlParam.getParam("expansionComment2Text"));
    this.setExpansionComment2Title((String) lUrlParam.getParam("expansionComment2Title"));
    this.setExpansionComment3Text((String) lUrlParam.getParam("expansionComment3Text"));
    this.setExpansionComment3Title((String) lUrlParam.getParam("expansionComment3Title"));
    this.setExpansionComment4Text((String) lUrlParam.getParam("expansionComment4Text"));
    this.setExpansionComment4Title((String) lUrlParam.getParam("expansionComment4Title"));
    // EDBTG005-00 kamata add start
    this.setExpansionComment5Text((String) lUrlParam.getParam("expansionComment5Text"));
    this.setExpansionComment5Title((String) lUrlParam.getParam("expansionComment5Title"));
    // EDBTG005-00 kamata add end
    this.setSetItem1Flg((String) lUrlParam.getParam("setItem1Flg"));
    this.setSetItem1((String) lUrlParam.getParam("setItem1"));
    this.setSetItem2Flg((String) lUrlParam.getParam("setItem2Flg"));
    this.setSetItem2((String) lUrlParam.getParam("setItem2"));
    this.setRealAmountFlg((String) lUrlParam.getParam("realAmountFlg"));
    // EDBTG003-00 elecs-matsushima add start
    this.setImageName6((String) lUrlParam.getParam("imageName6"));
    this.setImageName7((String) lUrlParam.getParam("imageName7"));
    this.setImageName8((String) lUrlParam.getParam("imageName8"));
    this.setImageName9((String) lUrlParam.getParam("imageName9"));
    this.setImageName10((String) lUrlParam.getParam("imageName10"));
    this.setImageName11((String) lUrlParam.getParam("imageName11"));
    // EDBTG003-00 elecs-matsushima add end
    this.setCatchcopy((String) lUrlParam.getParam("catchcopy"));        // キャッチコピー
    this.setSpecification((String) lUrlParam.getParam("specification"));    // 仕様
    this.setActiveingredient((String) lUrlParam.getParam("activeingredient"));  // 有効成分
    this.setComponent((String) lUrlParam.getParam("component"));        // 全成分
    this.setPrecaution((String) lUrlParam.getParam("precaution"));        // 注意事項
    this.setOthernotice((String) lUrlParam.getParam("othernotice"));      // その他
  }
  
  /**
   * @param dbConnection
   * @throws SIDBAccessException
   */
  public void getIndividual(Connection dbConnection) throws SIDBAccessException {
    Statement statement = null;
    ResultSet resultSet = null;
    StringBuffer sqlStatement = new StringBuffer();
    
    // 出力項目
    sqlStatement.append("SELECT *,CASE WHEN cmdtycode");
    sqlStatement.append(" IN(SELECT cc.cmdtycode FROM cmdtyctgrymtbl cc,ctgryvw ct WHERE cc.ctgrycode = ct.ctgrycode");
    sqlStatement.append(" AND (");
    for (int i=0;i<SIConfig.LOGINCTGRY.length;i++){
      if (i>0) sqlStatement.append(" OR ");
      sqlStatement.append(" (ct.branch LIKE '%~").append(SIDBUtil.SQL2Like(SIConfig.LOGINCTGRY[i])).append("%'");
      sqlStatement.append(" OR ct.ctgrycode = ").append(SIDBUtil.SQL2Str(SIConfig.LOGINCTGRY[i], ")"));
    }
    sqlStatement.append(")) THEN '1' ELSE '0' END AS loginflg ");
    sqlStatement.append("FROM individualtbl ");
    sqlStatement.append("WHERE shopcode = ").append(SIDBUtil.SQL2Str(this.shopCode," "));
    sqlStatement.append("AND cmdtycode = ").append(SIDBUtil.SQL2Str(this.cmdtyCode," "));
    sqlStatement.append("AND individualcode = ").append(SIDBUtil.SQL2Str(this.individualCode));
    try {
      statement = dbConnection.createStatement();
      log.debug("SQL=" + sqlStatement.toString());
      resultSet = statement.executeQuery(sqlStatement.toString());
      this.clear();
      // 商品レコードのセットの作成
      while (resultSet.next()) {
        this.setShopCode(resultSet.getString("shopCode"));
        this.setCmdtyCode(resultSet.getString("cmdtyCode"));
        this.setIndividualCode(resultSet.getString("individualCode"));
        this.setUsedNewFlg(resultSet.getString("usedNewFlg"));
        this.setArrivalDate(resultSet.getString("arrivalDate"));
        SIDateTime lDateTime = new SIDateTime(this.getArrivalDate(), SIConfig.SIDATE_FORMAT0);
        this.setArrivalYear(lDateTime.getYearStr());
        this.setArrivalMonth(lDateTime.getMonthStr());
        this.setArrivalDay(lDateTime.getDayStr());
        this.setProcessingExpence(resultSet.getString("processingExpence"));
        this.setTenureofuse(resultSet.getString("tenureofuse"));
        this.setSalesSituationFlg(resultSet.getString("salesSituationFlg"));
        this.setSoldOutDispFlg(resultSet.getString("soldOutDispFlg"));
        this.setCampaignPriceFlg(resultSet.getString("campaignPriceFlg"));
        this.setInquiryFlg(resultSet.getString("inquiryFlg"));
        this.setFrontDispFlg(resultSet.getString("frontDispFlg"));
        this.setCustCode(resultSet.getString("custCode"));
        this.setCustName(resultSet.getString("custName"));
        this.setComment(resultSet.getString("comment"));
        this.setBgPriceDispFlg(resultSet.getString("bgPriceDispFlg"));
        this.setConsignGoodsFlg(resultSet.getString("consignGoodsFlg"));
        this.setConsignmentMemo(resultSet.getString("consignmentMemo"));
        this.setCommodityExplanation(resultSet.getString("commodityExplanation"));
        this.setStockCode(resultSet.getString("stockCode"));
        this.setPurchasePrice(resultSet.getString("purchasePrice"));
        this.setBgPrice(resultSet.getString("bgPrice"));
        this.setBgPriceWithoutTax(resultSet.getString("bgPriceWithoutTax"));
        this.setSpecialPrice(resultSet.getString("specialPrice"));
        this.setRecommendationFlg(resultSet.getString("recommendationFlg"));
        this.setCommodityBannerFile(resultSet.getString("commodityBannerFile"));
        this.setMemberDiscountFlg(resultSet.getString("memberDiscountFlg"));
        this.setSellFromDate(resultSet.getString("sellFromDate"));
        if (!this.getSellFromDate().equals("")) {
          SIDateTime mDateTime = new SIDateTime(resultSet.getString("sellFromDate"), SIConfig.SIDATE_FORMAT0);
          this.setSellFromDateYear(mDateTime.getYearStr());
          this.setSellFromDateMonth(mDateTime.getMonthStr());
          this.setSellFromDateDay(mDateTime.getDayStr());
        }
        this.setEndSellFlg(resultSet.getString("endSellFlg"));
        this.setSellToDate(resultSet.getString("sellToDate"));
        if (!this.getSellToDate().equals("")) {
          SIDateTime nDateTime = new SIDateTime(this.getSellToDate(), SIConfig.SIDATE_FORMAT0);
          this.setSellToDateYear(nDateTime.getYearStr());
          this.setSellToDateMonth(nDateTime.getMonthStr());
          this.setSellToDateDay(nDateTime.getDayStr());
        }
        this.setSalesFromdate(resultSet.getString("salesFromdate"));
        this.setSalesToDate(resultSet.getString("salesToDate"));
        this.setRsrvEnableFlg(resultSet.getString("rsrvEnableFlg"));
        this.setRsrvAmount(resultSet.getString("rsrvAmount"));
        this.setNoStockFlg(resultSet.getString("noStockFlg"));
        this.setAmountFlg(resultSet.getString("amountFlg"));
        this.setStockStatusCode(resultSet.getString("stockStatusCode"));
        this.setSoldOutDate(resultSet.getString("soldOutDate"));
        this.setGuaranteedTerm(resultSet.getString("guaranteedTerm"));
        this.setWrappingFlg(resultSet.getString("wrappingFlg"));
        this.setDiscountFlg(resultSet.getString("discountFlg"));
        this.setSalesDiscountFlg(resultSet.getString("salesDiscountFlg"));
        this.setAdviceDispOrder(resultSet.getString("adviceDispOrder"));
        this.setImageName1(resultSet.getString("imageName1"));
        if (SIUtil.isNull(this.getImageName1())) {
          this.setImageName1("");
        }
        this.setImageName2(resultSet.getString("imageName2"));
        if (SIUtil.isNull(this.getImageName2())) {
          this.setImageName2("");
        }
        this.setImageName3(resultSet.getString("imageName3"));
        if (SIUtil.isNull(this.getImageName3())) {
          this.setImageName3("");
        }
        this.setImageName4(resultSet.getString("imageName4"));
        if (SIUtil.isNull(this.getImageName4())) {
          this.setImageName4("");
        }
        this.setImageName5(resultSet.getString("imageName5"));
        if (SIUtil.isNull(this.getImageName5())) {
          this.setImageName5("");
        }
        this.setImageNamet(resultSet.getString("imageNamet"));
        if (SIUtil.isNull(this.getImageNamet())) {
          this.setImageNamet("");
        }
        this.setRemarks(resultSet.getString("remarks"));
        this.setInitDateTime(resultSet.getString("initDateTime"));
        this.setSpCampaignFlg(resultSet.getString("spcampaignflg"));
        this.setNomalPrice(resultSet.getString("nomalprice"));
        this.setAlertAmount(resultSet.getString("alertAmount"));
        this.setPurchasePrice2(resultSet.getString("purchasePrice2"));
        this.setArrivalScheduleMsg(resultSet.getString("arrivalScheduleMsg"));
        this.setLoginFlg(resultSet.getString("loginflg").equals("1"));
        this.setJanCodeIndividual(resultSet.getString("janCodeIndividual"));
        this.setConsignGoodsFee(resultSet.getString("consignGoodsFee"));
        this.setPriceDownFlg(resultSet.getString("priceDownFlg"));
        this.setExpansionComment1Text(resultSet.getString("expansionComment1Text"));
        this.setExpansionComment1Title(resultSet.getString("expansionComment1Title"));
        this.setExpansionComment2Text(resultSet.getString("expansionComment2Text"));
        this.setExpansionComment2Title(resultSet.getString("expansionComment2Title"));
        this.setExpansionComment3Text(resultSet.getString("expansionComment3Text"));
        this.setExpansionComment3Title(resultSet.getString("expansionComment3Title"));
        this.setExpansionComment4Text(resultSet.getString("expansionComment4Text"));
        this.setExpansionComment4Title(resultSet.getString("expansionComment4Title"));
        // EDBTG005-00 kamata add start
        this.setExpansionComment5Text(resultSet.getString("expansionComment5Text"));
        this.setExpansionComment5Title(resultSet.getString("expansionComment5Title"));
        // EDBTG005-00 kamata add end
        
        this.setCatchcopy(resultSet.getString("catchcopy"));        // キャッチコピー
        this.setSpecification(resultSet.getString("specification"));    // 仕様
        this.setActiveingredient(resultSet.getString("activeingredient"));  // 有効成分
        this.setComponent(resultSet.getString("component"));        // 全成分
        this.setPrecaution(resultSet.getString("precaution"));        // 注意事項
        this.setOthernotice(resultSet.getString("othernotice"));      // その他
        
        this.setSetItem1((String) resultSet.getString("setItem1"));
        this.setSetItem2((String) resultSet.getString("setItem2"));
        
        // EDBTG003-00 elecs-matsushima add start
        this.setImageName6(resultSet.getString("imageName6"));
        if (SIUtil.isNull(this.getImageName6())) {
          this.setImageName6("");
        }
        this.setImageName7(resultSet.getString("imageName7"));
        if (SIUtil.isNull(this.getImageName7())) {
          this.setImageName7("");
        }
        this.setImageName8(resultSet.getString("imageName8"));
        if (SIUtil.isNull(this.getImageName8())) {
          this.setImageName8("");
        }
        this.setImageName9(resultSet.getString("imageName9"));
        if (SIUtil.isNull(this.getImageName9())) {
          this.setImageName9("");
        }
        this.setImageName10(resultSet.getString("imageName10"));
        if (SIUtil.isNull(this.getImageName10())) {
          this.setImageName10("");
        }
        this.setImageName11(resultSet.getString("imageName11"));
        if (SIUtil.isNull(this.getImageName11())) {
          this.setImageName11("");
        }
        // EDBTG003-00 elecs-matsushima add end
      }
    } catch (Exception ex) {
      log.debug("exception sql = " + sqlStatement.toString());
      throw new SIDBAccessException(ex);
    } finally {
      SIDBUtil.close(resultSet, statement);
    }
  }
  
  public void defaultSet() {
    this.setUsedNewFlg("");
    this.setSalesSituationFlg("0");
    this.setBgPriceDispFlg("0");
    this.setAmountFlg("");
    this.setNoStockFlg("0");
    this.setRecommendationFlg("0");
    this.setDiscountFlg("0");
    this.setRsrvEnableFlg("0");
    this.setFrontDispFlg("0");
    this.setInquiryFlg("0");
    this.setSoldOutDispFlg("1");
    this.setCampaignPriceFlg("0");
    this.setConsignGoodsFlg("0");
    this.setMemberDiscountFlg("1");
    this.setEndSellFlg("0");
    this.setWrappingFlg("0");
    this.setSalesDiscountFlg("0");
    this.setSpCampaignFlg("0");
    this.setPurchasePrice2("0");
    this.setPriceDownFlg("0");
  }
  
  public boolean validateIndividual(HttpServletRequest lRequest, Connection lConnection) {
    lRequest.removeAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY);
    SICustomErrors errors = new SICustomErrors();
    StringBuffer lSqlBuf = new StringBuffer("");
    StringBuffer lSqlBufCust = new StringBuffer("");
    
    SICheckValid.checkValid(errors, "親コード", this.getCmdtyCode(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "親コード", this.getCmdtyCode(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 13);
    
    SICheckValid.checkValid(errors, "在庫コード", this.getIndividualCode(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "在庫コード", this.getIndividualCode(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    if (SIUtil.isNotNull(this.getIndividual2())) SICheckValid.checkValid(errors, "在庫コード1", this.getIndividual1(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "在庫コード1", this.getIndividual1(), SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "在庫コード1", this.getIndividual1(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 2);
    
    if (SIUtil.isNotNull(this.getIndividual1())) SICheckValid.checkValid(errors, "在庫コード2", this.getIndividual2(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "在庫コード2", this.getIndividual2(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "在庫コード2", this.getIndividual2(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_TYPE, 4, 4);
    
    if (this.getIndividualCode().length() > 7) {
      if (SIConfig.SIEDIT_MODE_INSERT.equalsIgnoreCase(this.getEditModeTxt().trim())) {
        lSqlBuf = new StringBuffer();
        // 重複レコードの存在をチェックします
        lSqlBuf.append("SELECT individualcode FROM individualtbl ");
        lSqlBuf.append("WHERE ShopCode=" + SIDBUtil.SQL2Str(this.getShopCode(), " "));
        lSqlBuf.append("AND individualcode like" + SIDBUtil.SQL2Str(this.getIndividualCode().substring(0, 7) + "%", " "));
        SICheckValid.checkDuplicate(errors, lConnection, "在庫コード", lSqlBuf.toString());
      } else {
        if (SIUtil.isNotNull(this.getShopCode()) && SIUtil.isNotNull(this.getCmdtyCode())) {
          lSqlBuf.append("SELECT individualcode FROM individualtbl ");
          lSqlBuf.append("WHERE CmdtyCode=" + SIDBUtil.SQL2Str(this.getCmdtyCode(), " "));
          lSqlBuf.append("AND ShopCode=" + SIDBUtil.SQL2Str(this.getShopCode(), " "));
          lSqlBuf.append("AND individualcode=" + SIDBUtil.SQL2Str(this.getIndividualCode(), " "));
          SICheckValid.checkExist(errors, lConnection, "在庫コード", lSqlBuf.toString());
        }
      }
    }
    
    // 新規登録時の対象カテゴリ存在チェック
    if (SIConfig.SIEDIT_MODE_INSERT.equalsIgnoreCase(this.getEditModeTxt().trim())) {// 7.3.0 PI-NES0501
      lSqlBuf = new StringBuffer();
      // 重複レコードの存在でかどうかをチェックします
      lSqlBuf.append("SELECT ctgrycode FROM ctgrymtbl ");
      lSqlBuf.append("WHERE ctgrycode=" + SIDBUtil.SQL2Str(this.getIndividual1(), " "));
      SICheckValid.checkExist(errors, lConnection, "カテゴリ", lSqlBuf.toString());
      boolean editableFlg = false;
      for(int i=0;i<SIConfig.INVISIBLECTGRYS.length;i++){
        if (SIConfig.INVISIBLECTGRYS[i].equals(this.getIndividual1())||"SF".equals(this.getIndividual1())||"ZM".equals(this.getIndividual1())) {
          for(int j=0;j<SIConfig.EDITABLECTGRYS.length;j++){
            if (SIConfig.EDITABLECTGRYS[j].equals(this.getIndividual1())) editableFlg=true;
          }
          if (!editableFlg){
            errors.addError(new SICustomError("manager.message.freeword","このカテゴリ("+this.getIndividual1()+")には商品を登録できません"));
            break;
          }
        }
      }
    }
    
    SICheckValid.checkValid(errors, "中古・新品", this.getUsedNewFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    
    SICheckValid.checkValid(errors, "入荷日", this.getArrivalDate(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "入荷日", this.getArrivalDate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "加工費", this.getProcessingExpence(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "加工費", this.getProcessingExpence(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    if ("1".equals(this.getUsedNewFlg())||"2".equals(this.getUsedNewFlg())||"4".equals(this.getUsedNewFlg())||"6".equals(this.getUsedNewFlg())||"7".equals(this.getUsedNewFlg())) {
      SICheckValid.checkValid(errors, "仕入先", this.getStockCode(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    }
    
    SICheckValid.checkValid(errors, "使用年数", this.getTenureofuse(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "使用年数", this.getTenureofuse(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "使用年数", this.getTenureofuse(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 3);
    
    SICheckValid.checkValid(errors, "販売状況", this.getSalesSituationFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "販売状況", this.getSalesSituationFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_SALES_SITUATION_INX);
    
    SICheckValid.checkValid(errors, "SOLDOUT後表示", this.getSoldOutDispFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "SOLDOUT後表示", this.getSoldOutDispFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_SOLDOUTDISP_FLG_INX);
    
    SICheckValid.checkValid(errors, "キャンペーン特価区分", this.getCampaignPriceFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "キャンペーン特価区分", this.getCampaignPriceFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_CAMPAIGNPRICE_FLG_INX);
    
    SICheckValid.checkValid(errors, "問合せ区分", this.getInquiryFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "問合せ区分", this.getInquiryFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_INQUIRY_FLG_INX);
    
    SICheckValid.checkValid(errors, "フロント表示", this.getFrontDispFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "フロント表示", this.getFrontDispFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_FRONT_DISP_FLG_INX);
    
    if (SIUtil.isNotNull(this.getCustCode())) {
      if (SICheckValid.checkValid(errors, "顧客コード（買取先）", this.getCustCode(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE, 10)) {
        lSqlBufCust.append("SELECT custcode FROM custtbl ");
        lSqlBufCust.append("WHERE custcode=").append(SIDBUtil.SQL2Str(this.getCustCode(), " "));
        SICheckValid.checkExist(errors, lConnection, "顧客コード（買取先）", lSqlBufCust.toString());
      }
    }
    
    SICheckValid.checkValid(errors, "顧客名称（買取先）", this.getCustName(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    
    SICheckValid.checkValid(errors, "コメント", this.getComment(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 100);
    
    SICheckValid.checkValid(errors, "ＢＧ卸価フロント表示", this.getBgPriceDispFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "ＢＧ卸価フロント表示", this.getBgPriceDispFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_BGPRICE_DISP_INX);
    
    SICheckValid.checkValid(errors, "委託商品", this.getConsignGoodsFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "委託商品", this.getConsignGoodsFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_CONSIGNGOODS_FLG_LIST_INX);
    
    if (this.getCommodityExplanation().indexOf("http")>=0) errors.addError(new SICustomError("manager.message.freeword","商品説明にURLは入力できません"));
    
    SICheckValid.checkValid(errors, "商品説明拡張１タイトル", this.getExpansionComment1Title(), SICheckDataConf.SICHECK_DATA_CMDTYNAME_TYPE);
    SICheckValid.checkValid(errors, "商品説明拡張１タイトル", this.getExpansionComment1Title(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    if(SIUtil.isNotNull(this.getExpansionComment1Text())){
      SICheckValid.checkValid(errors, "商品説明拡張１タイトル", this.getExpansionComment1Title(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      if (this.getExpansionComment1Text().indexOf("http")>=0) errors.addError(new SICustomError("manager.message.freeword","商品説明拡張１にURLは入力できません"));
    }
    
    SICheckValid.checkValid(errors, "商品説明拡張２タイトル", this.getExpansionComment2Title(), SICheckDataConf.SICHECK_DATA_CMDTYNAME_TYPE);
    SICheckValid.checkValid(errors, "商品説明拡張２タイトル", this.getExpansionComment2Title(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    if(SIUtil.isNotNull(this.getExpansionComment2Text())){
      SICheckValid.checkValid(errors, "商品説明拡張２タイトル", this.getExpansionComment2Title(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      if (this.getExpansionComment2Text().indexOf("http")>=0) errors.addError(new SICustomError("manager.message.freeword","商品説明拡張２にURLは入力できません"));
    }
    SICheckValid.checkValid(errors, "商品説明拡張３タイトル", this.getExpansionComment3Title(), SICheckDataConf.SICHECK_DATA_CMDTYNAME_TYPE);
    SICheckValid.checkValid(errors, "商品説明拡張３タイトル", this.getExpansionComment3Title(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    if(SIUtil.isNotNull(this.getExpansionComment3Text())){
      SICheckValid.checkValid(errors, "商品説明拡張３タイトル", this.getExpansionComment3Title(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      if (this.getExpansionComment3Text().indexOf("http")>=0) errors.addError(new SICustomError("manager.message.freeword","商品説明拡張３にURLは入力できません"));
    }
    
    SICheckValid.checkValid(errors, "商品説明拡張４タイトル", this.getExpansionComment4Title(), SICheckDataConf.SICHECK_DATA_CMDTYNAME_TYPE);
    SICheckValid.checkValid(errors, "商品説明拡張４タイトル", this.getExpansionComment4Title(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    if(SIUtil.isNotNull(this.getExpansionComment4Text())){
      SICheckValid.checkValid(errors, "商品説明拡張４タイトル", this.getExpansionComment4Title(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    }
    
    // EDBTG005-00 kamata add start
    SICheckValid.checkValid(errors, "商品説明拡張５タイトル", this.getExpansionComment5Title(), SICheckDataConf.SICHECK_DATA_CMDTYNAME_TYPE);
    SICheckValid.checkValid(errors, "商品説明拡張５タイトル", this.getExpansionComment5Title(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    if(SIUtil.isNotNull(this.getExpansionComment5Text())){
      SICheckValid.checkValid(errors, "商品説明拡張５タイトル", this.getExpansionComment5Title(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    }
    // EDBTG005-00 kamata add end
    
    SICheckValid.checkValid(errors, "仕入先コード", this.getStockCode(), SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "仕入先コード", this.getStockCode(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 16);
    
    if (SIUtil.isNull(this.getPurchasePrice2())) this.setPurchasePrice2("0");
    SICheckValid.checkValid(errors, "仕入価格（在庫管理しない）", this.getPurchasePrice2(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "仕入価格（在庫管理しない）", this.getPurchasePrice2(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    boolean zeroFlg = false;
    try{
      zeroFlg = SIDBUtil.hasData(lConnection, "SELECT * FROM saleslimittbl WHERE individualcode="+SIDBUtil.SQL2Str(this.getIndividualCode()));
    } catch (Exception e) {}
    
    boolean priceCheck = true;
    priceCheck=priceCheck&SICheckValid.checkValid(errors, "ＢＧ卸価税抜", this.getBgPriceWithoutTax(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    priceCheck=priceCheck&SICheckValid.checkValid(errors, "ＢＧ卸価税抜", this.getBgPriceWithoutTax(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    if (SIUtil.isNotNull(this.getBgPriceWithoutTax()) && this.getBgPriceWithoutTax().equals("0") && !zeroFlg) errors.addError((new SICustomError("input.data.instock.less", "ＢＧ卸価税抜", "1")));
    if (priceCheck) {
      try{
        String taxRate = SIDBUtil.getFirstData(lConnection,"SELECT taxrate FROM TaxVW");
        this.setBgPrice(SIUtil.multi_LD(this.getBgPriceWithoutTax(), SIUtil.add_DL(String.valueOf(Double.parseDouble(taxRate) / 100), "1")));
      }catch(Exception e){
        this.setBgPrice("0");
      }
    }
    if (SIUtil.isNotNull(this.getBgPrice()) && this.getBgPrice().equals("0") && !zeroFlg) errors.addError((new SICustomError("input.data.instock.less", "ＢＧ卸価", "1")));
    
    SICheckValid.checkValid(errors, "特別価格", this.getSpecialPrice(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "特別価格", this.getSpecialPrice(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    //SICheckValid.checkValid(errors, "おすすめフラグ", this.getRecommendationFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    //SICheckValid.checkValid(errors, "おすすめフラグ", this.getRecommendationFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_ADVICE_INX);
    
    SICheckValid.checkValid(errors, "商品バナーファイル", this.getCommodityBannerFile(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 128);
    
    SICheckValid.checkValid(errors, "会員値引フラグ", this.getMemberDiscountFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "会員値引フラグ", this.getMemberDiscountFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_MEMBER_DISCOUNT_TYPE_INX);
    
    SICheckValid.checkValid(errors, "販売開始日", this.getSellFromDate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "販売終了日設定フラグ", this.getEndSellFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "販売終了日設定フラグ", this.getEndSellFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_END_SELL_INX);
    
    SICheckValid.checkValid(errors, "販売終了日", this.getSellToDate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    // 販売期間大小
    try {
      if (!SICheckUtil.dateEqual(this.getSellFromDate(), this.getSellToDate())) {
        SICheckValid.checkValid(errors, "販売開始日", "販売終了日", this.getSellFromDate(), this.getSellToDate(), SICheckDataConf.SICHECK_DATA_DATE_LESS_TYPE);// 7.1.1 ST0162 修正
      }
    } catch (Exception e) {}
    
    SICheckValid.checkValid(errors, "特別販売開始日", this.getSalesFromdate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "特別販売終了日", this.getSalesToDate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "予約販売", this.getRsrvEnableFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "予約販売", this.getRsrvEnableFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_RSRV_ENABLE_INX);
    
    SICheckValid.checkValid(errors, "予約可能数", this.getRsrvAmount(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "予約可能数", this.getRsrvAmount(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    SICheckValid.checkValid(errors, "在庫無し販売", this.getNoStockFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "在庫無し販売", this.getNoStockFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_NO_STOCK_INX);
    
    SICheckValid.checkValid(errors, "在庫数管理", this.getAmountFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "在庫数管理", this.getAmountFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_AMOUNT_INX);
    
    SICheckValid.checkValid(errors, "在庫状況番号", this.getStockStatusCode(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "在庫状況番号", this.getStockStatusCode(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 6);
    
    SICheckValid.checkValid(errors, "売切日", this.getSoldOutDate(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "保証期間", this.getGuaranteedTerm(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "保証期間", this.getGuaranteedTerm(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 3);
    
    SICheckValid.checkValid(errors, "ラッピングフラグ", this.getWrappingFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "ラッピングフラグ", this.getWrappingFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_GIFT_INX);
    
    SICheckValid.checkValid(errors, "一括値引フラグ", this.getDiscountFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "一括値引フラグ", this.getDiscountFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_DISCOUNT_FLG_INX);
    
    SICheckValid.checkValid(errors, "特価値引フラグ", this.getSalesDiscountFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "特価値引フラグ", this.getSalesDiscountFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_SALES_DISCOUNT_FLG_INX);
    
    //if (this.getRecommendationFlg().equals("1")) {
    //  SICheckValid.checkValid(errors, "おすすめ表示順", this.getAdviceDispOrder(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    //  SICheckValid.checkValid(errors, "おすすめ表示順", this.getAdviceDispOrder(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 4);
    //}
    if ("1".equals(getSetItem1Flg())){
      SICheckValid.checkValid(errors, "検品時／ピッキング時注意事項", this.getSetItem1(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      SICheckValid.checkValid(errors, "検品時／ピッキング時注意事項", this.getSetItem1(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    }
    
    if ("1".equals(getSetItem2Flg())){
      SICheckValid.checkValid(errors, "同梱品情報", this.getSetItem2(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      SICheckValid.checkValid(errors, "同梱品情報", this.getSetItem2(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    }
    
    SICheckValid.checkValid(errors, "画像タイトル１", this.getImageName1(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    SICheckValid.checkValid(errors, "画像タイトル２", this.getImageName2(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    SICheckValid.checkValid(errors, "画像タイトル３", this.getImageName3(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    SICheckValid.checkValid(errors, "画像タイトル４", this.getImageName4(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    SICheckValid.checkValid(errors, "画像タイトル５", this.getImageName5(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    SICheckValid.checkValid(errors, "画像タイトルサムネイル", this.getImageNamet(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 50);
    
    SICheckValid.checkValid(errors, "備考", this.getRemarks(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 1000);
    
    SICheckValid.checkValid(errors, "登録日時", this.getInitDateTime(), SICheckDataConf.SICHECK_DATA_DATE_TYPE);
    
    SICheckValid.checkValid(errors, "キャンペーン設定フラグ", this.getSpCampaignFlg(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
    SICheckValid.checkValid(errors, "キャンペーン設定フラグ", this.getSpCampaignFlg(), SICheckDataConf.SICHECK_FLAG_TYPE, SIFlagConf.SIFLAG_SPCAMPAIGN_INX);
    if (!this.getSpCampaignFlg().equals("0")) {
      SICheckValid.checkValid(errors, "通常価格", this.getNomalPrice(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      SICheckValid.checkValid(errors, "通常価格", "BG卸価税抜", this.getNomalPrice(), this.getBgPriceWithoutTax(), SICheckDataConf.SICHECK_DATA_VALUE_GREATER_TYPE);
    }
    SICheckValid.checkValid(errors, "通常価格", this.getNomalPrice(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "通常価格", this.getNomalPrice(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    
    SICheckValid.checkValid(errors, "アラート数量", this.getAlertAmount(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE);
    SICheckValid.checkValid(errors, "アラート数量", this.getAlertAmount(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 6);
    if (SIUtil.isNotNull(this.getAlertAmount()) && this.getAlertAmount().equals("0")) errors.addError((new SICustomError("input.data.instock.less", "アラート数量", "0")));
    
    SICheckValid.checkValid(errors, "入荷予定コメント", this.getArrivalScheduleMsg(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 20);
    
    lSqlBuf = new StringBuffer();
    lSqlBuf.append("SELECT cmdtyCode FROM cmdtyMTbl WHERE deliveryTypeCode = 1 ");
    lSqlBuf.append("AND cmdtyCode = ").append(SIDBUtil.SQL2Str(this.getCmdtyCode()));
    try {
      if (SIDBUtil.hasData(lConnection, lSqlBuf.toString())){
        SICheckValid.checkValid(errors, "JANコード", this.getJanCodeIndividual(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      }
    } catch (SIDBAccessException e) {
      e.printStackTrace();
    }
    if(!SICheckUtil.isCODE39(this.getJanCodeIndividual())) {
      errors.addError(new SICustomError("manager.message.freeword","JANコードの値が不正です（CODE39外文字）"));
    }
    
    lSqlBuf = new StringBuffer();
    // 重複レコードの存在をチェックします
    lSqlBuf.append("SELECT janCodeIndividual FROM individualtbl ");
    lSqlBuf.append("WHERE JanCodeIndividual = ").append(SIDBUtil.SQL2Str(this.getJanCodeIndividual()," "));
    lSqlBuf.append("AND IndividualCode <> ").append(SIDBUtil.SQL2Str(this.getIndividualCode()));
    SICheckValid.checkDuplicate(errors, lConnection, "JANコード", lSqlBuf.toString());
    
    if ("1".equals(this.getConsignGoodsFlg())) {
      if (SICheckValid.checkValid(errors, "委託手数料", this.getConsignGoodsFee(), SICheckDataConf.SICHECK_DATA_DIGIT_TYPE)){
        if (Integer.parseInt(this.consignGoodsFee) == 0)
          errors.addError((new SICustomError("input.data.instock.less", "委託手数料", "1")));
      }
      SICheckValid.checkValid(errors, "委託手数料", this.getConsignGoodsFee(), SICheckDataConf.SICHECK_DATA_BYTE_LEN_WITHIN_TYPE, 8);
    } else {
      this.setConsignGoodsFee("0");
    }
    
    /*
     * 削除 if (errors.isEmpty()){ SIStock lStock=new SIStock(SIConfig.SIMALL.getMallShopCode(),this.getStockCode()); lStock.reset(lConnection); //仕入先名称 String
     * stockName=lStock.getStockName(); if(SIUtil.isNotNull(this.getCustName())&&SIUtil.isNotNull(stockName)&&!stockName.equals(" ")){ errors.addError((new
     * SICustomError("manager.message.error.individual.StockCode"))); } }
     */
    if (!errors.isEmpty()) lRequest.setAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY, errors);
    return errors.isEmpty();
    
  }
  
  public boolean validateImage(HttpServletRequest lRequest, int num) {
    SICustomErrors errors = new SICustomErrors();
    switch (num) {
    case 1:
      SICheckValid.checkValid(errors, "画像タイトル１", this.getImageName1(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      break;
    case 2:
      SICheckValid.checkValid(errors, "画像タイトル２", this.getImageName2(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      break;
    case 3:
      SICheckValid.checkValid(errors, "画像タイトル３", this.getImageName3(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      break;
    case 4:
      SICheckValid.checkValid(errors, "画像タイトル４", this.getImageName4(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      break;
    case 5:
      SICheckValid.checkValid(errors, "画像タイトル５", this.getImageName5(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE);
      break;
    }
    if (!errors.isEmpty()) lRequest.setAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY, errors);
    return errors.isEmpty();
  }
  
  public boolean validateSearch(HttpServletRequest lRequest, Connection lConnection) {
    lRequest.removeAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY);
    StringBuffer lSqlBuf = new StringBuffer();
    SICustomErrors errors = new SICustomErrors();
    try{
      if (SICheckValid.checkValid(errors, "カテゴリ", this.getIndividual1(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE)) {
        lSqlBuf = new StringBuffer("SELECT CtgryCode FROM CtgryMTbl WHERE CtgryCode=");
        lSqlBuf.append(SIDBUtil.SQL2Str(this.getIndividual1()));
        SICheckValid.checkExist(errors, lConnection, "カテゴリコード", lSqlBuf.toString());
      }
    }catch(Exception e){
      e.printStackTrace();
    }
    
    if (!errors.isEmpty()) {
      lRequest.setAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY, errors);
      this.setIndividual2("");
    }
    return errors.isEmpty();
    
  }
  
  public boolean validateIndividualSearch(HttpServletRequest lRequest, Connection lConnection) {
    lRequest.removeAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY);
    StringBuffer lSqlBuf = new StringBuffer();
    SICustomErrors errors = new SICustomErrors();
    try{
      if (SICheckValid.checkValid(errors, "検索用コード", this.getSearchIndividualCodeTxt(), SICheckDataConf.SICHECK_DATA_EMPTY_TYPE + SICheckDataConf.SICHECK_DATA_ALPHA_DIGIT_TYPE)) {
        lSqlBuf = new StringBuffer("SELECT individualCode FROM individualTbl WHERE individualCode=");
        lSqlBuf.append(SIDBUtil.SQL2Str(this.getSearchIndividualCodeTxt()));
        SICheckValid.checkExist(errors, lConnection, "在庫コード", lSqlBuf.toString());
      }
    }catch(Exception e){
      e.printStackTrace();
    }
    
    if (!errors.isEmpty()) {
      lRequest.setAttribute(SIConfig.SIERROR_ATTRIBUTE_MESSAGE_KEY, errors);
    }
    return errors.isEmpty();
  }
  
  public void individualCopy(Connection lConnection) {
    Statement lStatement = null;
    ResultSet lResultSet = null;
    
    StringBuffer lSqlBuf = new StringBuffer();
    lSqlBuf.append("SELECT * FROM individualtbl WHERE individualcode = ").append(SIDBUtil.SQL2Str(this.getSearchIndividualCodeTxt()));
    try {
      lStatement = lConnection.createStatement();
      lResultSet = lStatement.executeQuery(lSqlBuf.toString());
      
      if (lResultSet.next()) {
        this.setIndividual1(lResultSet.getString("individualcode").substring(0, 2));
        this.setPurchasePrice2(lResultSet.getString("purchasePrice2"));
        this.setTenureofuse(lResultSet.getString("tenureofuse"));
        this.setGuaranteedTerm(lResultSet.getString("guaranteedTerm"));
        this.setCampaignPriceFlg(lResultSet.getString("campaignPriceFlg"));
        this.setCommodityExplanation(lResultSet.getString("commodityExplanation"));
        this.setSpCampaignFlg(lResultSet.getString("spcampaignflg"));
        this.setNomalPrice(lResultSet.getString("nomalprice"));
        this.setBgPrice(lResultSet.getString("bgPrice"));
        this.setBgPriceWithoutTax(lResultSet.getString("bgPriceWithoutTax"));
        this.setBgPriceDispFlg(lResultSet.getString("bgPriceDispFlg"));
        this.setRecommendationFlg(lResultSet.getString("recommendationFlg"));
        this.setAdviceDispOrder(lResultSet.getString("adviceDispOrder"));
        this.setRsrvEnableFlg(lResultSet.getString("rsrvEnableFlg"));
        this.setRsrvAmount(lResultSet.getString("rsrvAmount"));
        this.setFrontDispFlg(lResultSet.getString("frontDispFlg"));
        this.setInquiryFlg(lResultSet.getString("inquiryFlg"));
        this.setArrivalScheduleMsg(lResultSet.getString("arrivalScheduleMsg"));
        this.setRemarks(lResultSet.getString("remarks"));
        this.setStockCode(lResultSet.getString("stockCode"));
        this.setExpansionComment1Text(lResultSet.getString("expansionComment1Text"));
        this.setExpansionComment1Title(lResultSet.getString("expansionComment1Title"));
        this.setExpansionComment2Text(lResultSet.getString("expansionComment2Text"));
        this.setExpansionComment2Title(lResultSet.getString("expansionComment2Title"));
        this.setExpansionComment3Text(lResultSet.getString("expansionComment3Text"));
        this.setExpansionComment3Title(lResultSet.getString("expansionComment3Title"));
        this.setExpansionComment4Text(lResultSet.getString("expansionComment4Text"));
        this.setExpansionComment4Title(lResultSet.getString("expansionComment4Title"));
        // EDBTG005-00 kamata add start
        this.setExpansionComment5Text(lResultSet.getString("expansionComment5Text"));
        this.setExpansionComment5Title(lResultSet.getString("expansionComment5Title"));
        // EDBTG005-00 kamata add end
        this.setSetItem1(lResultSet.getString("setItem1"));
        this.setSetItem2(lResultSet.getString("setItem2"));
        this.setCatchcopy(lResultSet.getString("catchcopy"));
        this.setSpecification(lResultSet.getString("specification"));
        this.setActiveingredient(lResultSet.getString("activeingredient"));
        this.setComponent(lResultSet.getString("component"));
        this.setPrecaution(lResultSet.getString("precaution"));
        this.setOthernotice(lResultSet.getString("othernotice"));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      SIDBUtil.close(lStatement, lResultSet);
    }
  }
  
  //EDBTG003-00 elecs-matsushima add start
  public String getImageName6() {
    return this.imageName6;
  }
  
  public String getImageName7() {
    return this.imageName7;
  }
  
  public String getImageName8() {
    return this.imageName8;
  }
  
  public String getImageName9() {
    return this.imageName9;
  }
  
  public String getImageName10() {
    return this.imageName10;
  }
  
  public String getImageName11() {
    return this.imageName11;
  }
  
  public void setImageName6(String imageName6) {
    this.imageName6 = imageName6;
  }
  
  public void setImageName7(String imageName7) {
    this.imageName7 = imageName7;
  }
  
  public void setImageName8(String imageName8) {
    this.imageName8 = imageName8;
  }
  
  public void setImageName9(String imageName9) {
    this.imageName9 = imageName9;
  }
  
  public void setImageName10(String imageName10) {
    this.imageName10 = imageName10;
  }
  
  public void setImageName11(String imageName11) {
    this.imageName11 = imageName11;
  }
  //EDBTG003-00 elecs-matsushima add end

/**
 * @return catchcopy
 */
public String getCatchcopy() {
  return catchcopy;
}

/**
 * @param catchcopy セットする catchcopy
 */
public void setCatchcopy(String catchcopy) {
  this.catchcopy = catchcopy;
}

/**
 * @return specification
 */
public String getSpecification() {
  return specification;
}

/**
 * @param specification セットする specification
 */
public void setSpecification(String specification) {
  this.specification = specification;
}

/**
 * @return activeingredient
 */
public String getActiveingredient() {
  return activeingredient;
}

/**
 * @param activeingredient セットする activeingredient
 */
public void setActiveingredient(String activeingredient) {
  this.activeingredient = activeingredient;
}

/**
 * @return component
 */
public String getComponent() {
  return component;
}

/**
 * @param component セットする component
 */
public void setComponent(String component) {
  this.component = component;
}

/**
 * @return precaution
 */
public String getPrecaution() {
  return precaution;
}

/**
 * @param precaution セットする precaution
 */
public void setPrecaution(String precaution) {
  this.precaution = precaution;
}

/**
 * @return othernotice
 */
public String getOthernotice() {
  return othernotice;
}

/**
 * @param othernotice セットする othernotice
 */
public void setOthernotice(String othernotice) {
  this.othernotice = othernotice;
}
}