package imis_mate.bean;

import imis_mate.DAO.MateBuyDAO;
import imis_mate.DAO.MateOutDetailDAO;
import imis_mate.DAO.MaterialBuyDetailDAO;
import imis_mate.DAO.MaterialTypeDAO;

import java.io.Serializable;
import java.sql.Date;

/*
 * 物品庫存表 對應表 Material_Table
 * */
public class MaterialBean implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = -2489713608592101966L;
	private int materialNo; //庫存編號 主鍵
	private String materialTypeName; //物品名稱
	private String materialTypeNo; //物品類型
	private String materialTypeNoToString;  //
	private String maModel;	//型號
	private String maBrand;	//品牌
	private String maMadeIn;	//產地
	private int buyId;	//對應采購單ID
	private double priceUnit;	//入庫單價
	private int inCount;	//入庫數量
	private int nowCount;	//庫存數量
	private Date inDate;	//入庫日期
	private String userCode;	//入庫人
	private int inFrom;	//入庫來源(1采購入庫 2調撥入庫 3變更入庫 4盤點及其他)
	private String inFromToString; 
	private String reMark;	//摘要
	private String checkLink;
	private String buyNo;
	


	public MaterialBean() {
		
	}
	
	public String getBuyNo() {
		MaterialBuyDetailBean mateBuyD = null;
		if(this.buyId!=0){
			MaterialBuyDetailDAO mateBuyDAO = new MaterialBuyDetailDAO();
			mateBuyD = mateBuyDAO.getMaterialBuyDetailOfBuyId(buyId);
		}
		if(mateBuyD != null){
			this.buyNo = mateBuyD.getBuyNo();
		}
		return buyNo;
	}
	public String getCheckLink() {
		//return chaFlagLink;
			String url = "/Imis/servlet/MaterialCheckServlet?pattern=insertCheck&&materialNo="+this.materialNo;
			return "<a href="+url+" onclick=\"window.open(this.href,'_blank','scrollbars=0,resizable=0,width=650,height=400');return false\">"+"<span class=\"mylink\">盤點</span></a>";
	}
	public int getBuyId() {
		return buyId;
	}
	public void setBuyId(int buyId) {
		this.buyId = buyId;
	}
	public void setBuyId(String buyId) {
		//重載set 接受String參數
		if(buyId != null && buyId.equals("") == false) {
			this.buyId = new Integer(buyId.trim()).intValue();
		}
			
	}
	public int getInCount() {
		return inCount;
	}
	public void setInCount(int inCount) {
		this.inCount = inCount;
	}
	public void setInCount(String inCount) {
		//重載set方法 接受String 參數
		if(inCount != null && inCount.equals("") == false) {
			this.inCount = new Integer(inCount.trim()).intValue();
		}
	}
	public Date getInDate() {
		return inDate;
	}
	public String getInDateToString() {
		//重載get 方法 返回String 類型數據
		return inDate.toString();
	}
	public void setInDate(Date inDate) {
		this.inDate = inDate;
	}
	public void setInDate(String inDate) {
		//重載set方法 接受String 參數 DATE
		if(inDate != null && (inDate.equals("") != true)) {
			this.inDate = Date.valueOf(inDate);
		}
	}
	public int getInFrom() {
		return inFrom;
	}
	public void setInFrom(int inFrom) {
		this.inFrom = inFrom;
	}
	public void setInFrom(String inFrom) {
		//重載set方法 接受String參數
		if(inFrom != null && inFrom.equals("") == false) {
			this.inFrom = new Integer(inFrom.trim()).intValue();
		}
	}
	public String getMaBrand() {
		return maBrand;
	}
	public void setMaBrand(String maBrand) {
		if(maBrand != null && !maBrand.trim().equals("null")) {
			this.maBrand = maBrand.trim();
		}else{
			this.maBrand = "";
		}
	}
	public String getMaMadeIn() {
		return maMadeIn;
	}
	public void setMaMadeIn(String maMadeIn) {
		if(maMadeIn != null && !maMadeIn.trim().equals("null")) {
			this.maMadeIn = maMadeIn.trim();
		}else{
			this.maMadeIn = "";
		}
	}
	public String getMaModel() {
		return maModel;
	}
	public void setMaModel(String maModel) {
		if(maModel != null && !maModel.trim().equals("null")) {
			this.maModel = maModel.trim();
		}else{
			this.maModel = "";
		}
	}
	public int getMaterialNo() {
		return materialNo;
	}
	public void setMaterialNo(int materialNo) {
		this.materialNo = materialNo;
	}
	public void setMaterialNo(String materialNo) {
		//重載set方法　接受String參數
		if(materialNo != null && materialNo.equals("") == false) {
			this.materialNo = new Integer(materialNo.trim()).intValue();
		} else {
			this.materialNo = 0;
		}
	}
	public String getMaterialTypeName() {
		return materialTypeName;
	}
	public void setMaterialTypeName(String materialTypeName) {
		if(materialTypeName != null) {
			this.materialTypeName = materialTypeName.trim();
		}else{
			this.materialTypeName = "";
		}
	}
	public String getMaterialTypeNo() {
		return materialTypeNo;
	}
	public void setMaterialTypeNo(String materialTypeNo) {
		if(materialTypeNo != null) {
			this.materialTypeNo = materialTypeNo.trim();
		}else{
			this.materialTypeNo = "";
		}
	}
	public int getNowCount() {
		return nowCount;
	}
	public void setNowCount(int nowCount) {
		this.nowCount = nowCount;
	}
	public void setNowCount(String nowCount) {
		//重載set方法 接受String 參數
		if(nowCount != null && nowCount.equals("") == false) {
			this.nowCount = new Integer(nowCount.trim()).intValue();
		}
	}
	public double getPriceUnit() {
		return priceUnit;
	}
	public void setPriceUnit(double priceUnit) {
		this.priceUnit = priceUnit;
	}
	public void setPriceUnit(String priceUnit) {
		//重載set方法 接受String 參數
		if(priceUnit !=null && priceUnit.equals("") == false) {
			this.priceUnit = new Double(priceUnit.trim()).doubleValue();
		}
	}
	public String getReMark() {
		return reMark;
	}
	public void setReMark(String reMark) {
		if(reMark!=null) {
			this.reMark = reMark.trim();
		}else{
			this.reMark = "";
		}
	}
	public String getUserCode() {
		return userCode;
	}
	public void setUserCode(String userCode) {
		if(userCode != null) {
			this.userCode = userCode.trim();
		}else{
			this.userCode = "";
		}
	}
	public String getInFromToString() {
		//入庫來源(1采購入庫 2調撥入庫 3變更入庫 4盤點及其他)
		if(this.inFrom == 1) {
			this.inFromToString = "采購入庫";
		} else if(this.inFrom == 2){
			this.inFromToString = "調撥入庫";
		} else if(this.inFrom == 3) {
			this.inFromToString = "變更入庫";
		} else if(this.inFrom == 4) {
			this.inFromToString = "盤點及其他";
		}
		return inFromToString;
	}
	public void setInFromToString(String inFromToString) {
		if(inFromToString != null && inFromToString.equals("采購入庫")){
			this.inFrom = 1;
		} else if(inFromToString != null && inFromToString.equals("調撥入庫")){
			this.inFrom = 2;
		} else if(inFromToString != null && inFromToString.equals("變更入庫")){
			this.inFrom = 3;
		} else if(inFromToString != null && inFromToString.equals("盤點及其他")){
			this.inFrom = 4;
		}
		this.inFromToString = inFromToString;
	}

	public String getMaterialTypeNoToString() throws Exception {
		MaterialTypeDAO mtd = new MaterialTypeDAO();
		this.materialTypeNoToString = mtd.getMaterialTypeName(this.materialTypeNo);
		return materialTypeNoToString;
	}
	public void setMaterialTypeNoToString(String materialTypeNoToString) {
		this.materialTypeNoToString = materialTypeNoToString;
	}
	
}