package xin.glue.ui.G.G01;

import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

public class XTBGCreateMaterial {
	private PosGenericDao dao;
	private PosParameter param;
	private PosRowSet rowset;
	private PosRow row;
	 
	public XTBGCreateMaterial(PosGenericDao dao){
		this.dao = dao;
	}
	
	public void CreateCharge(String chargeNo){
		param = new PosParameter();
		param.setValueParamter(0, chargeNo);
		dao.insert("XTBGCOMM_CREATE_CHARGE_INSERT_01", param);
		
		param = new PosParameter();
		param.setValueParamter(0, chargeNo);
		dao.insert("XTBGCOMM_CREATE_CHARGE_D_INSERT_01", param);
	}
	
	
	public void CreateSlab(String planSlabNo){
		param = new PosParameter();
		param.setValueParamter(0, planSlabNo);
		dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_01", param);
		
		param = new PosParameter();
		param.setValueParamter(0, planSlabNo);
		dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_01", param);
		
		/*
		param = new PosParameter();
		param.setWhereClauseParameter(0, planSlabNo);
		int udtcnt = dao.update("XTBGCOMM_CREATE_SLAB_UPDATE_01", param);
		if(udtcnt == 0){
			param = new PosParameter();
			param.setValueParamter(0, planSlabNo);
			dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_01", param);
		}
		
		param = new PosParameter();
		param.setWhereClauseParameter(0, planSlabNo);
		udtcnt = dao.update("XTBGCOMM_CREATE_SLAB_D_UPDATE_01", param);
		if(udtcnt == 0){
			param = new PosParameter();
			param.setValueParamter(0, planSlabNo);
			dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_01", param);
		}
		*/
	}
	public void CreateSlab(String planSlabNo,String tag){
		param = new PosParameter();
		param.setValueParamter(0, planSlabNo);
		param.setValueParamter(1, planSlabNo);
		dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_02", param);
		
		param = new PosParameter();
		param.setValueParamter(0, planSlabNo);
		param.setValueParamter(1, planSlabNo);
		dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_02", param);
	}
	public String getSubSlabNo(PosContext context,String slabNo,String strandNo){
		String subSlabNo = null;
		if(strandNo == null || strandNo.equals("")){
			return "";
		}
		
		param = new PosParameter();
		param.setWhereClauseParameter(0, slabNo);
		param.setWhereClauseParameter(1, strandNo);
		rowset = dao.find("", param);
		if(rowset.hasNext()){
			PosRow row = rowset.next();
		}
		
		return subSlabNo;
	}
}