package com.sitech.ismp.coll.busi.e2e.dao;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.sitech.ismp.coll.busi.e2e.domain.TbE2eOneStopOrder;

public class TbE2eOneStopOrderDao extends OracleBaseDao {
	public TbE2eOneStopOrderDao(Map<String, String> params) {
		super(params);
	}
	
	@SuppressWarnings("unchecked")
	public List<TbE2eOneStopOrder> selectTbE2eOneStopOrder(TbE2eOneStopOrder order) {
		try {
			return sqlmapClient.queryForList("selectTbE2eOneStopOrder", order);
		} catch (SQLException e) {
			error.error("Exception while selectTbE2eOneStopOrder", e);
			return null;
		}
	}
	
	public List<TbE2eOneStopOrder> selectTbE2eOneStopOrderToNotFinish(TbE2eOneStopOrder order) {
		try {
			HashMap map = new HashMap();
			map.put("ITEM_ID", order.getITEM_ID());
			map.put("finish", "完成");
			return sqlmapClient.queryForList("selectTbE2eOneStopOrderToNotFinish", order);
		} catch (SQLException e) {
			error.error("Exception while selectTbE2eOneStopOrderToNotFinish", e);
			return null;
		}
	}
	
	public void editTbE2eOneStopOrder(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.update("editTbE2eOneStopOrder", order);
		} catch (SQLException e) {
			error.error("Exception while editTbE2eOneStopOrder", e);
		}
	}
	
	public void addTbE2eOneStopOrder(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.insert("addTbE2eOneStopOrder", order);
		} catch (SQLException e) {
			error.error("Exception while addTbE2eOneStopOrder", e);
		}
	}
	
	public void delTbE2eOneStopOrder(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.delete("delTbE2eOneStopOrder", order);
		} catch (SQLException e) {
			error.error("Exception while delTbE2eOneStopOrder", e);
		}
	}
	
	public void moveTbE2eOneStopOrderToHistory(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.delete("moveTbE2eOneStopOrderToHistory", order);
		} catch (SQLException e) {
			error.error("Exception while moveTbE2eOneStopOrderToHistory", e);
		}
	}
	
	public void delTbE2eOneStopOrderByItemId(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.delete("delTbE2eOneStopOrderByItemId", order);
		} catch (SQLException e) {
			error.error("Exception while delTbE2eOneStopOrderByItemId", e);
		}
	}
	
	public void moveTbE2eOneStopOrderToHistoryByItemId(TbE2eOneStopOrder order) {
		try {
			sqlmapClient.delete("moveTbE2eOneStopOrderToHistoryByItemId", order);
		} catch (SQLException e) {
			error.error("Exception while moveTbE2eOneStopOrderToHistoryByItemId", e);
		}
	}
}