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

import java.sql.Connection;
import java.util.HashMap;

import jp.co.sint.database.SIDBUtil;

/**
 * @version $Id: SIUtil.java,v 1.0 2003/07/25 Exp $
 * @author  Chihiro Imai
 * <br>Description: 入力したコードから名前を取得します
 * <p>History</p>
 * <p>Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Reason</p>
 * ============&nbsp;&nbsp;&nbsp;==========&nbsp;&nbsp;===========================<br>
 * Chihiro Imai       2004/09/13  Original
 */
public class SICodeToName {
	private String mallshopName = "";
	private String custName = "";


	public SICodeToName() {
	}
		
  //setter of ショップ名
	public void setMallShopName(String lMallShopName){
	  if (lMallShopName==null)lMallShopName="";
	  this.mallshopName=lMallShopName;
	}	

	//setter of 顧客名
	public void setCustName(String lCustName){
		if (lCustName==null)lCustName="";
		this.custName=lCustName;
	}	
	  			
	//getter of ショップ名
	public String getMallShopName() {
	  return mallshopName;
	}	

	//getter of 顧客名
	public String getCustName() {
	  return custName;
	}
			
	/**
	 * srchShopName
	 * 入力したショップコードからショップ名を取得します
	 * @return 
	 * @throws 
	 * @param lConnection
	 * @param lShopCode 
	 */
	public void srchShopName(Connection lConnection,String lShopCode){	
	  try {
		  String lSql = "SELECT FrontShopName FROM MallShopmTbl WHERE MallShopCode = " + SIDBUtil.SQL2Str(lShopCode);
		  HashMap lMap = SIDBUtil.getOneRowData(lConnection, lSql.toString());
		  this.setMallShopName((String)lMap.get("frontshopname"));
	  	
	  }catch(Exception e){
 		  e.printStackTrace();
	  }
	}

	/**
	 * srchCustName
	 * 入力した顧客コードから顧客名を取得します
	 * @return 
	 * @throws 
	 * @param lConnection
	 * @param lCustCode 
	 */
	public void srchCustName(Connection lConnection,String lCustCode){
	  try {
		  String lSql = "SELECT CustName FROM CustTbl WHERE CustCode = " + SIDBUtil.SQL2Str(lCustCode);
		  HashMap lMap = SIDBUtil.getOneRowData(lConnection, lSql.toString());
		  this.setCustName((String)lMap.get("custname"));
	  	
	  }catch(Exception e){
		  e.printStackTrace();
	  }
	}
}